Spaces:
Sleeping
Sleeping
| import streamlit as st | |
| import pandas as pd | |
| # --------------------------- | |
| # App Title and Description | |
| # --------------------------- | |
| st.set_page_config(page_title="Excel Data Dashboard", layout="wide") | |
| st.title("📊 Excel Data Upload & Preview Dashboard") | |
| st.markdown(""" | |
| Upload your Excel file below to view and explore data. | |
| This app works best when deployed on **Streamlit Cloud** or run locally. | |
| """) | |
| # --------------------------- | |
| # File Uploader | |
| # --------------------------- | |
| uploaded_file = st.file_uploader("📂 Upload Excel File", type=["xlsx", "xls"]) | |
| if uploaded_file is not None: | |
| try: | |
| # Read Excel file | |
| df = pd.read_excel(uploaded_file) | |
| # Success message | |
| st.success(f"✅ File '{uploaded_file.name}' uploaded successfully!") | |
| # Show basic info | |
| st.write("### Data Preview") | |
| st.dataframe(df.head()) | |
| # Basic statistics | |
| st.write("### Data Summary") | |
| st.write(df.describe(include='all')) | |
| # Optional: download processed CSV | |
| csv = df.to_csv(index=False).encode('utf-8') | |
| st.download_button( | |
| label="⬇️ Download Data as CSV", | |
| data=csv, | |
| file_name="processed_data.csv", | |
| mime="text/csv" | |
| ) | |
| except Exception as e: | |
| st.error(f"❌ Error reading file: {e}") | |
| else: | |
| st.info("Please upload an Excel file to start.") | |