Amara-4312/Healthcare-Expenditure-Analysis

# Nigeria Health Expenditure Analysis An exploratory data analysis of Nigeria's health expenditure trends using World Health Organization (WHO) health expenditure data from **2000–2023**. The project examines how Nigeria's health spending has changed over time, how expenditure relates to the size of the economy, and how healthcare financing has been distributed across government, domestic private, out-of-pocket, and external sources. The analysis forms part of a **data journalism portfolio** and will be used as the evidence base for a publication-focused article. ## Project workflow The project follows a structured data analysis workflow: 1. **Reconnaissance** — understanding the source dataset, variables, metadata, and available indicators. 2. **Cleaning** — selecting relevant Nigeria observations, standardising variables, and preparing the analytical dataset. 3. **Exploratory Data Analysis** — examining trends, changes over time, missingness, and descriptive statistics. 4. **Visualization** — developing exploratory charts in Python and selecting the strongest findings for publication-ready visualizations. 5. **Data storytelling** — translating the analysis into a clear, accessible health data journalism piece. ## Data **Source:** World Health Organization health expenditure data. The original workbook contains multiple sheets, including: * `Codebook` * `Metadata` * `Version` * `Data` * `Nigeria_Analysis_Data` * `Nigeria_Clean` * `Reconnaissance sheet` The `Nigeria_Clean` dataset is the main analytical dataset used for exploratory analysis and visualization. It contains **24 annual observations covering 2000–2023** and 15 variables covering health expenditure, financing sources, out-of-pocket spending, and primary healthcare expenditure. ## Key variables | Variable | Description | | ------------ | ----------------------------------------------------------------------- | | `year` | Y …