jeisteve999/Poverty-Inequality-and-Data-Availability-in-African-Countries-2000-2025-

Domain:

socioeconomic

Creator:

jei

Host:

This project analyzes poverty, income inequality, and data availability across African countries using World Bank indicators. The analysis includes data cleaning, transformation, validation, and exploratory analysis to identify socioeconomic patterns and assess data coverage. # Poverty-Inequality-and-Data-Availability-in-African-Countries-2000-2025- This project analyzes poverty, income inequality, and data availability across African countries using World Bank indicators. The analysis includes data cleaning, transformation, validation, and exploratory analysis to identify socioeconomic patterns and assess data coverage. # Data Source Source: World Bank Open Data link here: data.worldbank.org -Dataset: Poverty and Equity Database # SQL Script The complete SQL workflow used for data cleaning, transformation, validation, and exploratory analysis can be found here: View SQL Script -Coverage: African Countries Multiple poverty indicators Income distribution indicators Gini Index Slum population indicators Period: 2000–2025 # Data Reshaping (UNPIVOT) Objective Transform the dataset from wide format: Country 2000 2001 2002 into long format: Country Year Value SQL Technique # Outcome This structure significantly improves analytical flexibility and reporting capabilities. # Data Cleaning & Preparation Transform the dataset from wide format -Database Setup -Column Renaming -Data Structure Validation -Indicator Scale Validation Outcome # Exploratory Data Analysis (EDA) -Poverty Ranking -Results: - GINI Index Ranking -Results: -Data Availability by Country -Results : -Poverty & Inequality Analysis -Results # Key Findings - Niger recorded the highest poverty rate among countries with available data (94.7%, based on most recent observation). - Angola presents a notable paradox: one of the lowest poverty rates (8.0%) alongside a high Gini Index (51.3), reflecting wealth concentration driven by oil revenues. - Data availability is a critical limitation: the Gini Index and income share indicators show significant gaps across countries and years. # Contribution Developed by Jeisson Rojas as a contribution to OpenGovAfrica.

Visit

github.com

SECURITY THREATS, POVERTY AND INEQUALITY IN WEST AFRICAN COUNTRIES

This study explores the relationship between security threats, poverty and inequality in West Africa

How the Adoption of Government Interventions has Affected Income Inequality and Poverty in Some African Countries

The majority of Sub-Saharan African (SSA) nations continue to have higher rates of poverty than othe

Does financial inclusion induce poverty, income inequality, and financial stability: empirical evidence from the 54 African countries?

Purpose The aim of the study is to examine the impact of financial inclusion on poverty, income ine

Poverty, Inequality, and conflict data Understanding the Moderating Role of Socioeconomic Development in Poverty- and Inequality-Driven Conflicts: Insights from North Central Nigeria

This study explores the interplay between poverty, inequality, and conflict in the North Central reg

African External Security Engagement Observatory (ASEO), 2000–2025

A country-year database of external military engagement with all 54 African states, 2000–2025: arms

Poverty Alleviation and Inequality in Nigeria

This study investigates the impact of poverty alleviation initiatives on income inequality in Nigeri