Jonathan-NP/namibia-2023-census-explorer

Interactive geospatial analytics web app utilizing the Namibia 2023 Census data to optimize retail site selection and infrastructure allocation. # 🇳🇦 2023 Namibia Census Explorer & Infrastructure Dashboard An end-to-end Business Intelligence platform and ETL data pipeline powered by **Streamlit**, **DuckDB**, and **Plotly Express**. The system ingests complex census data published by the **Namibia Statistics Agency (NSA)** from the 2023 Population and Housing Census and transforms raw tabular spreadsheets into real-time analytical metrics. Designed primarily to drive **retail site selection**, **youth target demographic mapping**, and **public sector infrastructure allocation** across Namibia's 14 administrative regions. --- ## 🌟 Key Features * **Automated Data Cleaning & Normalization**: Custom ETL script parsing unstructured Excel sheets (`Table 2.1` & `Table 2.3`), standardizing string encodings, removing special click characters, non-breaking spaces, and validating schema metrics. * **High-Performance Embedded Analytics Engine**: Uses **DuckDB** for ultra-fast in-memory analytical querying and persistent local caching. * **Interactive BI Filters**: Dynamic slider thresholds targeting regional youth demographics (Ages 15–34), multi-region comparison filters, and customizable visual representations (Bar, Line, Area charts). * **Granular Urban vs. Rural Splits**: Interactive regional donut chart grids dynamically rendered based on active filter criteria. * **Developer Info & Portfolio Page**: Integrated multi-page state management within Streamlit allowing users to view software engineering profiles and project details seamlessly. * **Data Export Ready**: Built-in functionality for analysts to download cleaned regional extracts directly as CSV files. --- ## 🛠️ Architecture & Tech Stack ```text [ NSA Census Excel Source ] │ ▼ [ Python ETL Pipeline (Pandas) ] (Data Cleaning & Character Normalization) │ ▼ [ Embedded DuckDB Database Engine ] │ ▼ [ Interactive Streamlit Dashboard Engine ] (Plotly Charts | Dynamic Filtering | State Nav) ``` | Component | Technology Used | Primary Role | | :--- | :- …