Exploratory analysis of public investment, fiscal balance and economic development across 54 African countries (1980) — Python · Jupyter Notebook
# Africa Economic Investment Analysis — 1980
> Exploratory analysis of public investment, fiscal balance and economic development
> across 54 African countries (1980) | Python · Jupyter Notebook
---
## 1. Project Overview
In 1980, African economies faced severe budgetary constraints, structural adjustment
programs imposed by the IMF and World Bank, and deep economic disparities between
countries. This project investigates how public investment capacity and fiscal health
shaped economic trajectories across the continent — identifying the sub-regions and
countries with the most critical structural imbalances requiring strategic resource
reallocation.
Central business question:
> To what extent do public investment levels and economic capacity (GDP, public
> expenditure, capital formation) determine African countries' economic development
> trajectories — and which countries or sub-regions show the most critical imbalances
> requiring strategic reorientation?
---
## 2. Dataset
| Attribute | Details |
|------------------------|------------------------------------------------------|
| Source | World Bank / IMF (structured CSV export) |
| Raw dimensions | 1,729 rows × 8 columns |
| Reference year | 1980 (single cross-sectional snapshot) |
| Countries | 54 African countries + 7 regional aggregates |
| Indicators | 29 macroeconomic indicators |
| Final dataset | 61 rows × 21 columns (wide format, post-processing) |
Variable categories:
- Segmentation — `country_code`, `country_name`, `region_id`
- Economic size — `gdp_current_usd`, `gdp_constant_usd`
- Investment — `total_investment_pct_gdp`, `public_investment_pct_gdp`, `private_investment_pct_gdp`
- Fiscal — `gov_revenue_pct_gdp`, `gov_expenditure_pct_gdp`, `fiscal_balance_pct_gdp`
- Trade — `exports_pc …