Risper-Nyawira/kenya-food-security-analysis

SQL, Power BI, and Python analysis of maize production, climate variability, market prices, and food security in Kenya. # Kenya Food Security Project Project question: How have agricultural production, climate variability, and market dynamics influenced food security across Kenya? ## Folder Order 1. `01_data/raw` - original source datasets. 2. `01_data/processed` - cleaned/exported analysis datasets for Python and Power BI. 3. `02_database` - SQLite project database. 4. `03_sql` - recovered SQL views and database object definitions. 5. `04_powerbi` - place the `.pbix` dashboard file here when saved/found. 6. `05_python/notebooks` - Python/Jupyter notebooks go here. 7. `06_outputs` - charts and final tables exported from Python or Power BI. 8. `07_docs` - source inventory and project notes. ## Current Main Processed Dataset `01_data/processed/maize_food_security_analysis.csv` This CSV is exported from the SQLite view `maize_food_security_analysis` and is the recommended starting point for Python analysis.