🍊 Programmer’s Picnic • Pandas Projects

Pandas Projects Pack

Three projects that cover data entry from CSV, JSON, MySQL, MongoDB and processing in Pandas, charts in Matplotlib, and exports to CSV, JSON, MySQL, MongoDB, and PNG.

Easy → Difficult Includes sample datasets Includes starter Python scripts

Quick start: Open any project page → follow run steps → run the matching script in scripts/.

Easy — Expense Tracker Analytics CSV + JSON input → clean → groupby summaries → bar chart → export CSV/JSON/PNG

Open Project → Download .py

Moderate — Sales & Customers Dashboard Orders CSV + Customers JSON + (optional) MySQL → join → KPIs → city revenue chart → export CSV/JSON/MySQL/PNG

Open Project → Download .py

Difficult — IoT Anomaly Monitor MongoDB/JSONL readings → rolling stats → anomaly detection → trend chart → export CSV/JSON/Mongo/MySQL/PNG

Open Project → Download .py

Folder structure Keep this structure to run scripts without changing paths.

📁 Structure

pandas-projects-pack/
  index.html
  project_easy.html
  project_moderate.html
  project_difficult.html
  assets/
    style.css
    app.js
  data/
    expenses.csv
    expenses_sample.json
    orders.csv
    customers.json
    iot_readings.jsonl
  scripts/
    easy_expense_analytics.py
    moderate_sales_customers_dashboard.py
    difficult_iot_anomaly_monitor.py
  output/
  requirements.txt
  README.md

Install deps: pip install -r requirements.txt
Run scripts: open terminal in scripts/.