Spaces:
Sleeping
Sleeping
File size: 2,447 Bytes
a207b64 |
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 |
import streamlit as st
from funcs.googlesheet import get_google_sheet_data
import pandas as pd
def CreatePage():
st.header("Upload or Connect Your Data")
data_source = st.radio("Choose data source:", ["CSV Files", "Google Sheets"])
if data_source == "CSV Files":
if "data" in st.session_state:
st.success("Data uploaded successfully! Here is a preview:")
st.dataframe(st.session_state["data"].head(10)) # Display only the first 10 rows for a cleaner view
else:
uploaded_files = st.file_uploader("Upload your CSV files", type=["csv"], accept_multiple_files=True)
if uploaded_files is not None:
dfs = []
for uploaded_file in uploaded_files:
try:
df = pd.read_csv(uploaded_file)
dfs.append(df)
except Exception as e:
st.error(f"Error reading file {uploaded_file.name}: {e}")
if dfs:
full_data = pd.concat(dfs, ignore_index=True)
st.session_state["data"] = full_data
st.success("Data uploaded successfully! Here is a preview:")
st.dataframe(full_data.head(10)) # Show preview of first 10 rows
else:
st.warning("No valid data found in the uploaded files.")
if st.button("Clear Data"):
del st.session_state["data"]
st.success("Data has been cleared!")
elif data_source == "Google Sheets":
sheet_id = st.text_input("Enter Google Sheet ID")
range_name = st.text_input("Enter the data range (e.g., Sheet1!A1:C100)")
if sheet_id and range_name:
if st.button("Fetch Data"):
with st.spinner("Fetching data from Google Sheets..."):
try:
data = get_google_sheet_data(sheet_id, range_name)
st.session_state["data"] = data
st.success("Data fetched successfully! Here is a preview:")
st.dataframe(data.head(10)) # Show preview of first 10 rows
except Exception as e:
st.error(f"Error fetching data: {e}")
else:
st.warning("Please enter both Sheet ID and Range name before fetching data.")
|