zainabibraheem/Healthcare-Access-Analysis-in-Africa

This case study aims to analyze healthcare facility data, identify disparities in access to healthcare between rural and urban regions, and evaluate the efficiency of healthcare funding. The objective is to propose data-driven recommendations that governments and stakeholders can implement to enhance healthcare service delivery across Africa. # Healthcare-Access-Analysis-in-Africa Unraveling the Challenges of Healthcare Accessibility in Africa: A Case Study ## Project Overview This case study aims to analyze healthcare facility data, identify disparities in access to healthcare between rural and urban regions, and evaluate the efficiency of healthcare funding. The objective is to propose data-driven recommendations that governments and stakeholders can implement to enhance healthcare service delivery across Africa. ## Problem Statement Access to healthcare services across Africa remains uneven, with significant disparities between rural and urban regions. Rural populations often face challenges such as inadequate medical infrastructure, a shortage of healthcare professionals, and limited access to essential services. ## Aims and Objectives ## Aims This study seeks to analyze healthcare facility data to identify gaps in service delivery, assess funding efficiency, and provide evidence-based recommendations to improve healthcare accessibility and equity across rural and urban regions in Africa. ## Objectives 1. To provide insights into the distribution of healthcare facilities between urban and rural locations. The number of doctors and nurses, and patient accessibility across different regions. 2. To give information on the availability of doctors and nurses per facility and how this varies between urban and rural locations. 3. To track the efficiency of the healthcare facilities by looking into funding per patient visits, emergency response time, and patient satisfaction rate. 4. To analyse the funding received by healthcare facilities and their access to essential services, such as electricity and the internet. ## Data Transformation and Data Wrangling Prepared the dataset for analysis by performing data cleaning and transformation tasks using Power Query. The process includes handling duplicates, missing values, and ensuring that the data format is consistent across various columns. ## Dat …