Slyza13/-South-Africa-Transport-Analysis---Week-1-Project

This Week 1 project analyzes South Africa's transport landscape using official statistics from various government surveys. The analysis focuses on four key areas of transportation: learner transport patterns, worker commuting, household transport costs, and provincial expenditure disparities. 🚦 South Africa Transport Analysis - Week 1 # 🚦 South Africa Transport Analysis - Week 1 ## 📋 Executive Summary This project analyzes South Africa's transportation landscape using official government statistics to uncover mobility patterns, financial burdens, and spatial inequalities. As **Week 1 of a 90-day execution challenge**, this analysis transforms raw data into actionable insights about how transport shapes opportunity and inequality in South Africa. **Analysis Period:** Week 1 (14 Dec - 20 Dec 2025) **Core Question:** How does transportation access and cost influence economic opportunity and social equity in South Africa? 📊 Key Insights at a Glance 🚸 The Walking Divide 61.1% of students walk to school vs only 22.8% of workers Students walk 2.7 times more than working adults Indicates either safer routes for students or economic pressures forcing different choices 🚕 Parallel Transport Economies Workers use taxis (24.3%) almost as much as private cars (25.9%) The informal taxi sector is not marginal—it's central to urban mobility Formal buses serve only 3.6% of workers, highlighting service gaps 💰 Financial Burden Transport is the 3rd largest household expense (15.3% of expenditure) 74.5% of households spend R300+ weekly on work transport Creates potential "transport poverty traps" limiting economic mobility 🗺️ Geographic Inequality Western Cape spends R33,487 annually (53% above national average) Gauteng spends R29,333 (34% above average) National average: R21,930 Wealthier provinces spend more, but on what—better options or just higher costs? 📁 Project Structure text South_Africa_Transport_Analysis/ ├── README.md # This documentation ├── South_Africa_Transport_Analysis.xlsx # Main Excel workbook │ ├── Transport_Mode_Learners # Student commuting patterns │ ├── Transport_Mode_Workers # Worker commuting patterns │ ├── Household_Transport_Costs # Financial burden analysis │ └── P …