Willsmike2012/food-inflation-dashboard

Capstone Project to generate an interactive Food Inflation Dashboard to show how households feel rising food prices in Nigeria by analyzing and visualizing food-price versus inflation trends. # Nigeria Food Inflation Dashboard Capstone project: an interactive dashboard analyzing Nigerian food-price inflation vs. general inflation, built from FAOSTAT Consumer Price Index data (2000–2025). ## Contents - `site/index.html` — the interactive dashboard (open directly in any browser, or deploy via GitHub Pages) - `data/nga_food_inflation_cleaned.csv` — cleaned, tidy monthly dataset (Date, Food_CPI, General_CPI, Food_Inflation_YoY_pct, General_Inflation_YoY_pct, Food_minus_General) - `docs/insight_summary.docx` — 1-page insight summary (Word document) - `clean_data.py` — the Python/pandas script used to clean the raw FAOSTAT export ## Run locally Just double-click `site/index.html`, or serve it: ``` cd site python3 -m http.server 8080 ``` Then open localhost ## Data cleaning summary The raw FAOSTAT export has one row per (Item × Month × Year), with three "Item" types stacked in one column (Food CPI, General CPI, Food inflation %). The cleaning script pivots this into one row per month with each series as its own column, parses proper dates, and derives General_Inflation_YoY_pct and Food_minus_General for comparison. Values were cross-checked against FAOSTAT's own reported inflation figures (independently recomputed as a % change over 12 months) — they matched to within rounding.