ASA DataQuest 2025 Runner-up (Ethics): Analysing African socio-economic trends using World Bank data. Achieved Top 4 rankings in Statistical Insight and Data Visualization categories.
# African Socio-Economic Transformation & Demographic Analysis
### 🏆 Award Winning Project - ASA DataQuest 2025
This repository contains a comprehensive data analysis project that investigates the complex relationship between population growth, education enrollment levels, and life expectancy across the African continent from 1960 to 2023.
---
## 🎖 Competition Achievements
This project was recognized and awarded in the **ASA DataQuest 2025** competition with the following official rankings:
* **2nd Place:** Consideration of Ethics (Ethical Excellence Award)
* **4th Place:** Data Visualization
* **4th Place:** Statistical Insight
---
## 📊 Project Overview
The study provides a data-driven perspective on Africa's social evolution by focusing on:
1. **Demographic Trends:** Tracking total and urban population growth.
2. **Educational Progression:** Analyzing gross enrollment rates for Primary, Secondary, and Tertiary education.
3. **Correlative Insights:** Using standardized data to observe how education levels correlate with regional life expectancy improvements.
---
## 🛠 Technical Stack
* **Language:** Python
* **Libraries:** Pandas, NumPy, Matplotlib, Seaborn
* **Environment:** Jupyter Notebook
* **Dataset:** World Bank Development Indicators (WDI)
---
## 🧬 Core Methodology
### 1. Data Engineering & Cleaning
* Merged diverse country metadata with temporal socio-economic indicators.
* Managed missing values and inconsistencies using robust parsing and interpolation.
* Reshaped datasets (Melt/Pivot operations) for efficient time-series analysis.
### 2. Statistical Analysis
* **Decadal Aggregation:** Analyzed 10-year averages to identify long-term trends while filtering short-term volatility.
* **Z-Score Normalization:** Standardized different scales (percentages vs. years) to allow direct comparative analysis.
* **Pearson Correlation:** Calculated correlation coefficients (r) to quantify the strength of relationships between education and longevity.
### 3 …