marcuskiama97-ai/County-Economic-Development-Scorecard-Ranking-Kenya-s-47-Counties

Build a comprehensive data analytics and data science project that ranks all 47 counties in Kenya based on key economic and social development indicators. Your final output should be an interactive dashboard, a scoring model, and a data pipeline that automatically refreshes when new data is available. # County Economic Development Scorecard Ranking Kenyas 47 Counties ## Project Overview This project ranks all 47 counties in Kenya based on key development indicators: healthcare access, education, economy, and service delivery. It uses publicly available data to create a composite scorecard, providing insights into regional disparities and opportunities for improvement. The scorecard is built using data pipelines for processing, scoring models for ranking, and interactive dashboards for visualization. The goal is to assist policymakers, researchers, and stakeholders in understanding county level performance and prioritizing interventions. ## Key Indicators ### Healthcare - Health facilities per capita - Immunization coverage - Maternal & child health statistics - Health workforce density ### Education - Literacy rates - School enrollment (primary & secondary) - Pupil–teacher ratio - KCSE performance averages ### Economy - County GDP / economic output - Employment rates - Household income levels - Poverty index ### Service Delivery - Access to clean water - Infrastructure quality (roads, electricity) - Public service efficiency metrics - Budget absorption rates ## Data Sources - Kenya Open Data Portal - World Bank Kenya County Indicators - KNBS reports - County Integrated Development Plans (CIDPs) - Ministry of Health, Education, and Economy datasets - Healthcare Access: Download Kenya Master Health Facility List (KMHFL) from kmhfl.health.go.ke or KNBS County Statistical Abstracts (CSAs) from knbs.or.ke. Metrics: facilities per 100k population, hospitals/wards per county.​ Education: Fetch KNBS school census data (e.g., knbs.or.ke) or statskenya.co.ke datasets. Metrics: primary/secondary schools per capita, enrollment rates, pupil-teacher ratios by county.​ Economy: Use KNBS Gross County Product (GCP) tables from knbs.or.ke …