Jean1776/KENYA_SCHOOLS_PROJECT

The program attempts to connect Kenya secondary schools with Safaricom interventions for digital learning and infrastructure # KENYA_SCHOOLS_PROJECT This Python script processes school data from Kenya and generates synthetic (simulated) data about digital infrastructure interventions that could be implemented by Safaricom and its partners across secondary schools. ## What It Does 1. **Extracts School Data**: Opens a compressed file containing school directory data and loads it from an old database format (DBF) 2. **Cleans and Filters Data**: - Removes unnecessary columns (zone, ward, coordinates, district, source) - Keeps only important information: school name, county, sub-county, and education level - Filters to keep only secondary schools (high schools) - Removes duplicate entries 3. **Adds Synthetic Data**: - Assigns unique ID numbers to each school - Randomly assigns classroom resources (computers, tablets, smart boards, etc.) - Randomly assigns teacher-to-student ratios 4. **Generates Intervention Scenarios**: - Selects up to 350 schools randomly to receive interventions - Assigns each school to one of three program pillars: - **UNICEF Giga Connectivity Pipeline** (40% probability): Focuses on internet connectivity (fiber optic, 4G/5G) - **With MySafaricom EdTech Track** (35% probability): Focuses on digital learning tools (platforms, training, software, SMS) - **Citizens of the Future Infrastructure** (25% probability): Focuses on advanced technology (smart classrooms, AI tools, VR labs) - Assigns realistic investment amounts based on intervention type - Calculates the number of learners impacted by each intervention 5. **Exports Results**: - Saves the school data to `KENYA_SECONDARY_SCHOOL.csv` - Saves the intervention data to `SAFARICOM_DIGITAL_SCHOOL_INFRASTRUCTURE.csv` ## Why This Matters This program helps stakeholders visualize and plan digital infrastructure investments in Kenyan schools. By generating realistic scenarios, it can support: - **Budget Planning**: Understanding potential investment requirements - **Impact Assessment**: Estimating how many learners could …