JesseAnak7534/GH-AMR-Dashboard

Multi-source Surveillance (Environment, Food, Human, Animal, Aquaculture) | Ghana # AMR Surveillance Dashboard **Environment & Food Samples | Ghana** A production-ready Streamlit application for monitoring Antimicrobial Resistance (AMR) in environmental and food samples across Ghana. Built for academic research and policy decision-making. --- ## Features ✅ **Data Upload & Validation** - Excel import with strict schema validation - Auto-generated template for consistent data entry - Human-readable error reporting ✅ **Interactive Dashboards** - **Resistance Overview**: Multi-filter analysis with charts - **Trends**: Time-series tracking of resistance patterns - **Map Hotspots**: Geographic visualization with district rankings - **Report Export**: HTML reports with summary statistics ✅ **Local Data Storage** - SQLite database (auto-created) - No external APIs or internet required - Full data privacy and control --- ## Quick Start ### 1. Install Python 3.10+ Verify installation: ```bash python --version ``` ### 2. Clone or Extract Project ```bash cd amr_env_food_dashboard ``` ### 3. Create Virtual Environment **Windows (PowerShell):** ```powershell python -m venv venv .\venv\Scripts\Activate.ps1 ``` **macOS/Linux:** ```bash python3 -m venv venv source venv/bin/activate ``` ### 4. Install Dependencies ```bash pip install -r requirements.txt ``` ### 5. Run the Dashboard ```bash streamlit run app.py ``` The app will open at `localhost` ### Database The app uses **PostgreSQL** (previously SQLite — migrated April 2026). Set `DATABASE_URL` in `.env` (local) or Streamlit secrets (cloud): ```env DATABASE_URL=postgresql://amr_app:amr_app_local_2026@localhost:5432/amr_surveillance ``` For a one-shot local bootstrap: ```sql CREATE USER amr_app WITH PASSWORD ' '; CREATE DATABASE amr_surveillance OWNER amr_app; GRANT ALL PRIVILEGES ON DATABASE amr_surveillance TO amr_app; \c amr_surveillance GRANT ALL ON SCHEMA public TO amr_app; ALTER SCHEM …