mmsulieman/WFP-Somali-Region-Process-Monitoring-Indicators-Automation

# WFP Somali Region – Process Monitoring Thematic Cleaner (Streamlit App) This Streamlit application helps the WFP Somali Region RAM/M&E Unit to: - Ingest multi-sheet MoDA / ODK process monitoring Excel exports - Infer activity and monitoring type from sheet names - Apply indicator / column-level thematic mapping - Produce wide cleaned datasets and long fact tables for Tableau / Power BI - Export the result as a single Excel file ## 1. Install Dependencies From a terminal in this folder: ```bash pip install -r requirements.txt ``` ## 2. Run the App ```bash streamlit run app.py ``` The app will open in your browser (usually at localhost). ## 3. Basic Usage 1. Upload your MoDA / ODK Excel export (with multiple sheets). 2. Review the detected sheets and inferred activity / monitoring types. 3. Let the app process and classify indicators into thematic areas. 4. Download the resulting Excel file containing: - A mapping sheet (indicators, themes, activity, monitoring type) - A wide cleaned dataset - A long-format fact table ## 4. Notes - This app is designed for internal WFP Somali Region use by the RAM/M&E Unit. - Adjust thematic mapping logic in app.py if new indicators or activities are added.