loreenach254/2011-2024-diabetes-change

From raw health data to public health insights: a Python pipeline exploring diabetes trends in Kenya. # Kenya Diabetes Trend Analysis (2011-2024) ## Project Overview This project developed an end-to-end data pipeline to integrate and analyze diabetes-related indicators for Kenya using publicly available datasets. The pipeline integrates diabetes prevalence data from the International Diabetes Federation (IDF) and socioeconomic indicators from the World Bank. The project demonstrates data extraction, cleaning, data integration, validation, exploratory data analysis, and reporting using Python. --- ## Objectives - Build a reproducible data pipeline for diabetes-related data. - Integrate health and socioeconomic indicators. - Assess diabetes prevalence changes in Kenya. - Evaluate the suitability of available data for statistical modelling. --- ## Data Sources ### International Diabetes Federation (IDF) Provides diabetes prevalence estimates. Variables: - Country - Year - Diabetes prevalence (%) ### World Bank Provides socioeconomic indicators. Variables: - Population - GDP per capita - Poverty indicators --- ## Project Workflow Data Sources ↓ Data Extraction ↓ Data Cleaning ↓ Data Integration ↓ Data Quality Checks ↓ Exploratory Analysis ↓ Visualization --- ## Analysis Performed The analysis included: - Dataset structure assessment - Missing value checks - Summary statistics - Diabetes prevalence change analysis - Percentage change calculations - Trend visualization --- ## Key Findings The pipeline successfully integrated data from IDF and World Bank sources. Only two diabetes prevalence observations were available for Kenya. Therefore, inferential modelling and machine learning approaches were not appropriate due to insufficient observations. The project focused on descriptive assessment and change analysis of available indicators. --- ## Limitations The limited number of national-level diabetes observations restricts advanced statistical analysis. More detailed datasets are required to investigate diabetes risk factors and outcomes. -- …