jaji-capstone/project_AfriHealth

Capstone project analyzing healthcare spending impact in Africa and how to optimize Health Investment Strategies Across Africa # Healthcare Spending Impact Analysis: Optimizing Health Investment Strategies Across Africa This repository documents our comprehensive analysis of healthcare financing and outcomes across African countries. We identify which spending patterns deliver the greatest health impact per dollar invested and highlight high-efficiency health systems that achieve strong outcomes despite limited resources. ## 🌐 Project Overview **Research Question**: *"Which spending patterns deliver the greatest health impact per dollar invested, and which countries offer scalable models of efficient health system performance?"* **Key Finding**: **Efficiency > Spending** - How you spend matters more than how much you spend. Algeria achieves 11+ years more life expectancy than predicted by its spending level. **Data Sources**: - WHO Global Health Expenditure Database (GHED) - World Bank Health, Nutrition and Population (HNP) Statistics **Time Period**: 2000-2022 **Coverage**: 47 African countries **Observations**: 1,054 country-year records ## 🔬 The Complete Data Pipeline Our analysis follows a rigorous, transparent data science workflow. Below is the **chronological journey** from raw data to actionable insights. ### 📥 **Stage 1: Data Acquisition** *(Notebook: `notebooks/data_acquisition.ipynb`)* **What We Did**: 1. Downloaded 12 WHO GHED indicator files (2000-2023) 2. Downloaded World Bank HNP data for all health indicators 3. Downloaded WHO codes files (COUNTRY.csv, REGION.csv, etc.) **Why It Matters**: Starting with raw data ensures transparency and reproducibility. The WHO GHED provides detailed health financing data, while the World Bank offers outcome metrics and socioeconomic context. **Key Insight**: The WHO data uses a standardized coding system (SpatialDimensionValueCode) that must be mapped to country names for integration with World Bank data. --- ### 🌍 **Stage 2: WHO Data Processing** *(Notebook: `notebooks/who_data_aggregation_processing.ipynb`)* **What We D …