How sebastianmunozcodes/smart-utilities-analytics works
Smart Utilities Analytics turns monthly EIA electricity data into a cleaned dataset, statistical summaries, charts, SQLite-backed SQL analysis, and a Markdown report. The graph preserves the documented workflow and major analysis capabilities. Source excerpts show the cleaning, Pandas, database, and report behaviors; workflow ordering and SQL validation are also documented in the README, but no runtime orchestrator is shown.
Main entry points: eia_sales_revenue_monthly_states_cleaned.csv Cleaned CSV · charts Analysis charts · clean_data.py Data cleaning · analyze_pandas.py State sales
Components 16
Data preparation
- Raw EIA CSV
data/raw/eia_sales_revenue_monthly_states.csv - Data cleaning
src/clean_data.py - Cleaned CSV
data/cleaned/eia_sales_revenue_monthly_states_cleaned.csv
Pandas analytics
- State sales
src/analyze_pandas.py - State prices
src/analyze_pandas.py - State revenue
src/analyze_pandas.py - Monthly trends
src/analyze_pandas.py - Record rankings
src/analyze_pandas.py - Analysis charts
charts
Database analytics
- Table setup
src/setup_database.py - CSV loader
src/load_data.py - SQLite table
- SQL summaries
src/analyze_sql.py - SQL validation
src/analyze_sql.py
Reporting
- Markdown report
src/generate_report.py
Other components
- Analyst
Connections 20
- Analyst → Data cleaning: runs workflow
README.md - Raw EIA CSV → Data cleaning: reads
src/clean_data.py - Data cleaning → Cleaned CSV: writes
src/clean_data.py - Cleaned CSV → State sales: reads
src/analyze_pandas.py - Cleaned CSV → State prices: reads
src/analyze_pandas.py - Cleaned CSV → State revenue: reads
src/analyze_pandas.py - Cleaned CSV → Monthly trends: reads
src/analyze_pandas.py - Cleaned CSV → Record rankings: reads
src/analyze_pandas.py - State sales → Analysis charts: generates
src/analyze_pandas.py - State prices → Analysis charts: generates
src/analyze_pandas.py - State revenue → Analysis charts: generates
src/analyze_pandas.py - Monthly trends → Analysis charts: generates
src/analyze_pandas.py - Record rankings → Analysis charts: generates
src/analyze_pandas.py - Table setup → SQLite table: creates table
src/setup_database.py - Cleaned CSV → CSV loader: reads
src/load_data.py - CSV loader → SQLite table: inserts rows
src/load_data.py - SQLite table → SQL summaries: queried by
src/analyze_sql.py - SQL summaries → SQL validation: reproduces summaries
README.md - Cleaned CSV → Markdown report: reads
src/generate_report.py - SQL validation → Markdown report: summarized in
README.md