GeamXD/A-Case-Study-on-Tackling-the-Health-Crises-in-Africa

A data driven case study # Tackling the Health Crisis in Africa: A Data-Driven Analysis (2000-2019) # Project Background As a data analyst for a continental public health organization, my role is to analyze health trends across Africa to inform policy, guide resource allocation, and support strategic interventions. Our organization partners with national governments and NGOs to improve health outcomes. This project analyzes 20 years of health data (2000-2019) to identify the most pressing health challenges, pinpoint high-risk countries, and understand the demographic groups most at risk. The goal is to provide actionable insights to our directors and stakeholders to shape the next decade of public health strategy. Insights and recommendations are provided on the following key areas: - **Category 1:** Overall Health Landscape in Africa - **Category 2:** High-Mortality Countries and Contributing Factors - **Category 3:** Leading Causes of Death by Country - **Category 4:** Age Group Vulnerability Analysis The Python scripts used to wrangle and analyze the data for this project can be found here: **Code**. An interactive Tableau dashboard used to report and explore these health trends can be found here: **Live Dashboard**. # Data Structure & Initial Checks The analysis integrated five distinct datasets to create a comprehensive view of the public health landscape in Africa. The final merged dataset covers the years 2000 to 2019. A description of each data source is as follows: - **Causes of Deaths:** Contains records of the number of deaths attributed to various causes across different countries. - **Number of Deaths by Age Group:** Details mortality figures broken down by specific age demographics for each country. - **Medical Doctors Per 10,000 Population:** Provides data on the density of medical practitioners in African nations. - **Health Expenditure (% of GDP):** Shows national spending on health as a percentage of the Gross Domestic Product. - **World Popula …