Ruth-Kasina/Digital-Connectivity-Africa

Digital Connectivity & Economic Development in Africa # Digital Connectivity & Economic Development in Africa **AnalystLab Africa Data Analytics Internship — Week 8 Capstone Project** ## Project Overview This project examines the relationship between digital connectivity and economic development across nine African countries (Kenya, South Africa, Nigeria, Ghana, Egypt, Rwanda, Ethiopia, Tanzania, and Uganda) between 2010 and 2023. It applies the complete data analytics workflow: data cleaning, exploratory analysis, interactive dashboarding, and insight generation. **Data Source:** World Bank — World Development Indicators (WDI) ## Problem Statement To examine the relationship between digital connectivity and economic development across selected African countries, and to identify disparities, trends, and opportunities for digital investment. ## Repository Structure ``` ├── data/ │ ├── cleaned_wdi_2010_2023.csv # Cleaned dataset (wide format) │ └── wdi_long_format_powerbi.csv # Cleaned dataset (long format, for Power BI) ├── notebook/ │ └── 01_exploration.ipynb # Data cleaning & exploration notebook ├── dashboard/ │ ├── digital-connectivity-africa.pbix # Power BI dashboard file │ └── screenshots/ # Dashboard page screenshots └── report/ └── Capstone_Final_Report.docx # Full written report ``` ## Key Findings - Average internet penetration across the 9 countries reached **42.45%** in 2023. - South Africa leads the group at **78.34%** internet penetration; the lowest sits at **9.29%**. - Average GDP per capita across the group was approximately **$2,260** in 2023. - A positive relationship was found between internet penetration and GDP per capita. Countries with higher connectivity tend to report higher income levels. - This relationship is a correlation, not proven causation. See the full report for discussion. ## Dashboard The Power BI dashboard has 3 pages: 1. **Executive Overview** — KPI summary, connectivity trend, map, country ranking 2. **Country …