python2Sheet/index.py at main · KetanAgrawal2002/python2Sheet · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
import streamlit as st
import pandas as pd
from createNewSheet import *
from authenticate import *
from appendToSheet import *
from filter import *


# Set the title of the app
st.title("CSV File To Google Sheet")

# Create a file uploader widget
uploadedFile = st.file_uploader("Upload a CSV file", type=["csv"])
checkboxValue = st.checkbox("Add to Exisiting File")

# Use the value of the checkbox
if checkboxValue:
    linkToSheet = st.text_input("Enter a link to the sheet to upload")

    # Extract the Sheet Id from the link
    startIndex = linkToSheet.find("/d/") + 3
    endIndex = linkToSheet.find("/edit")
    keyToSheet = linkToSheet[startIndex:endIndex]

    if keyToSheet=="":
        st.warning("Invalid link")

    if uploadedFile is not None:
        # Read the CSV file into a DataFrame
        df = pd.read_csv(uploadedFile)

        selectedColumns = st.multiselect("Select columns to add to sheet", df.columns.tolist())
        selectedDF = pd.DataFrame()
        # Check if any columns are selected
        if selectedColumns:
            # Filter the DataFrame to display only the selected columns
            selectedDF = df[selectedColumns]
            st.write("Selected Data:")
            st.write(selectedDF)
        else:
            st.warning("Please select at least one column to display.")


        applyFilter = st.checkbox("Apply Filter")


        if applyFilter:
            st.sidebar.title("Filter")
            filteredDF = pd.DataFrame()
            with st.sidebar:
                filteredDF = filter(selectedDF)
            if st.button("Append filtered Data"):
                if selectedColumns:
                    # added title for columns selected
                    if filteredDF.empty:
                        filteredDF.loc[0] = selectedDF.columns
                    else:
                        filteredDF.iloc[0]=selectedDF.columns
                    st.write(appendData(keyToSheet,filteredDF))
                else:
                    st.warning("Please select at least one column to apply filter")
        else:
            # adding data when filter is not used
            if st.button("Append Data"):
                if selectedColumns:
                    selectedDF.iloc[0]=selectedDF.columns
                    st.write(appendData(keyToSheet,selectedDF))
                else:
                    st.warning("Please select at least one column to add to Sheets.")


else:
    customTitle = st.text_input("Enter a custom name for the sheet (optional)")
    # Check if a file has been uploaded
    if uploadedFile is not None:
        # Read the CSV file into a DataFrame
        df = pd.read_csv(uploadedFile)
        title = customTitle.strip() if customTitle else uploadedFile.name
        selectedColumns = st.multiselect("Select columns to add to sheet", df.columns.tolist())

        # Check if any columns are selected
        if selectedColumns:
            # Filter the DataFrame to display only the selected columns
            selectedDF = df[selectedColumns]
            st.write("Selected columns:")
            st.write(selectedDF)
        else:
            st.warning("Please select at least one column to display.")

        # filter code starts here
        applyFilter = st.checkbox("Apply Filter")

        # adding data with filter
        if applyFilter:
            st.sidebar.title("Filter")
            filteredDF = pd.DataFrame()
            with st.sidebar:

                # function called for sidebar that is in filter.py and returns filtered Dataframe
                filteredDF = filter(selectedDF)


            if st.button("Add filtered Data"):
                if selectedColumns:
                    # added title for columns selected
                    if filteredDF.empty:
                        filteredDF.loc[0] = selectedDF.columns
                    else:
                        filteredDF.iloc[0]=selectedDF.columns
                    st.write(addData(filteredDF,title))
                else:
                    st.warning("Please select at least one column to apply filter")
        else:
            # adding data when filter is not used
            if st.button("Add Data"):
                if selectedColumns:
                    selectedDF.iloc[0]=selectedDF.columns
                    st.write(addData(selectedDF,title))
                else:
                    st.warning("Please select at least one column to add to Sheets.")


st.write("---")

st.write("Crafted with ❤️ by Ketan Agrawal (20BIT0437)")