Data analysis of African road infrastructure using Python. Built automated pipelines to assess paved vs unpaved roads and generate insights on governance and infrastructure gaps
# Road Infrastructure Analysis – Tanzania 🇹🇿
## Overview
This project analyzes road infrastructure data using the FRST dataset (~13M road segments across Africa).
The objective is to quantify road conditions and uncover infrastructure gaps linked to governance, policy decisions, and investment outcomes.
---
## Objectives
- Measure paved vs unpaved road distribution
- Calculate total road network length
- Identify infrastructure gaps
- Support data-driven governance insights
---
## Key Results (Tanzania Case Study)
- **Total road network:** ~320,319 km
- **Paved roads:** 27,203.75 km (**8.49%**)
- **Unpaved roads:** 293,115.38 km (**91.51%**)
### Insight
Over 90% of roads in Tanzania are unpaved, highlighting a significant infrastructure gap.
This supports the "Budget vs Reality" narrative, where investment does not fully translate into road quality outcomes.
---
## Tools & Technologies
- Python (Pandas)
- Data cleaning & transformation
- Automated data processing pipeline
---
## Pipeline
- Load raw dataset (country-level files)
- Clean and standardize road length values
- Convert units for consistency
- Compute infrastructure metrics (km, % distribution)
- Generate summary outputs