AnalystLab Africa Week 8 Capstone — Nigeria's population growth analyzed against 7 African peer countries using WDI data
# Nigeria & Africa: Population Growth Dashboard
**AnalystLab Africa Data Analytics Internship — Week 8 Capstone Project**
Nigeria's population growth analyzed in comparison with 7 other major African countries, using World Bank World Development Indicators (WDI) data.
---
## 📌 Project Overview
This project analyzes Nigeria's population growth from 1990–2023 in comparison with seven other major African countries — Ethiopia, Egypt, DR Congo, South Africa, Kenya, Ghana, and Cameroon — using World Bank World Development Indicators (WDI) data. The project follows the full data analytics workflow: data extraction, cleaning, exploratory analysis, and interactive dashboard development.
## 🌍 Data Source
World Bank World Development Indicators (WDI):
datatopics.worldbank.org
## 📊 Indicators Analyzed
| Indicator | Description |
|---|---|
| Population, total | Total population count |
| Population growth (annual %) | Year-over-year population growth rate |
| Urban population (% of total) | Share of population in urban areas |
| Population density | People per sq. km of land area |
| Fertility rate, total | Average births per woman |
| Age dependency ratio | Ratio of dependents to working-age population |
## 🗺️ Countries Studied
Nigeria, Ethiopia, Egypt (Arab Rep.), DR Congo, South Africa, Kenya, Ghana, Cameroon — covering 1990 to 2023.
## 🧹 Data Cleaning Process
- Filtered the full WDI dataset (396,970 rows) down to 8 countries and 6 indicators.
- Identified and backward-filled 3 missing values (Ethiopia's population density, 1990–1992).
- Checked for and confirmed no duplicate country-indicator records.
- Verified column and country name standardization.
- Reshaped data from wide format to long format (1,632 rows) for analysis and dashboarding.
## 🔑 Key Findings
- **Population Scale:** Nigeria's population (227.9M) is nearly double the next-largest country studied (Ethiopia, 128.7M).
- **Growth Rate:** Nigeria's average grow …