Bpetal8/zipline-rwanda-analysis

# Zipline Rwanda — Drone Delivery Operations Analysis **Geospatial SQL and analytics pipeline project modelling Zipline Rwanda drone delivery operations.** Operational analytics and telemetry modelling project built in Python + SQLite. --- ## Background Zipline's Rwanda network delivers blood products and medical supplies to hospitals across the Southern and Eastern provinces. This project simulates a full operational analytics pipeline modelled on that network — covering data ingestion, quality validation, SQL analysis, and visualisation. The dataset is synthetic but grounded in Zipline's actual operating context: the Muhanga distribution centre, the hospitals it serves, blood product payloads, and the telemetry data drones produce in flight. --- ## Project structure ``` zipline-rwanda-analysis/ │ ├── data/ │ ├── generate_data.py # Generates synthetic flight datasets │ ├── flights_summary.csv # 1,200 flights: launch time, outcome, weather, battery, payload │ └── flight_telemetry.csv # 16,273 telemetry points: lat/lon/altitude/speed per flight │ ├── sql/ │ └── analysis_queries.sql # 15 SQL queries across 5 operational categories │ ├── pipeline/ │ ├── load_and_validate.py # Loads CSVs → SQLite, runs QA checks, outputs report │ └── qa_report.txt # Auto-generated data quality report │ ├── visualizations/ │ ├── generate_charts.py # Generates 4 operational charts │ ├── 01_monthly_volume_success.png │ ├── 02_success_by_weather.png │ ├── 03_coverage_map.png │ └── 04_fleet_utilisation.png │ └── zipline_rwanda.db # SQLite database (auto-created by pipeline) ``` --- ## Quickstart ```bash # 1. Clone the repo git clone github.com cd zipline-rwanda-analysis # 2. Install dependencies (Python 3.8+ required) pip install pandas numpy matplotlib # 3. Generate the dataset python data/generate_data.py # 4. Run the pipeline + QA validation python pipeli …