MaandaOkundahoPhidane/african-fiscal-analysis

Comprehensive analysis of budget deficits/surpluses across 14 African countries (1960-2025). Transforms fiscal data into actionable insights with trend analysis, risk assessment, and strategic policy recommendations. # African Fiscal Health Analysis A comprehensive data analysis project examining budget deficits and surpluses across 14 African countries from 1960 to 2025. This project transforms raw fiscal data into actionable insights for policymakers, economists, and researchers. ## 📊 Project Overview This analysis provides deep insights into fiscal health patterns, trends, and country performance across Africa. The project processes macroeconomic data to identify chronic deficit issues, volatility patterns, and strategic recommendations for fiscal policy improvement. ### Key Features - **Multi-country Analysis**: 14 African nations spanning 65+ years - **Trend Identification**: Year-over-year fiscal performance tracking - **Risk Assessment**: Country categorization by deficit severity and volatility - **Strategic Recommendations**: Data-driven policy suggestions - **Professional Visualizations**: Comprehensive dashboard and charts - **Exportable Reports**: Excel and image outputs for presentations ## 🗂️ Dataset ### Source Data - **Countries**: Algeria, Angola, Botswana, Egypt, Ethiopia, Ghana, Ivory Coast, Kenya, Nigeria, Rwanda, Senegal, South Africa, Tanzania, Togo - **Time Period**: 1960-2025 - **Indicators**: Budget Deficit/Surplus amounts - **Frequency**: Mixed (Yearly, Monthly, Quarterly) - **Currencies**: Local currencies standardized to million units ### Data Structure