Tandah-Marcelle/Africa-Population-Pulse-Streamlit-Analytical-Dashboard

Africa Population Pulse is an interactive analytical and descision making tool built with Streamlit to visualize and analyze historical and projected demographic trends across 54 African countries(from 1960 -2023). # Africa Population Pulse: Streamlit Analytical Dashboard # Project Overview Africa Population Pulse is an interactive analytical and descision making tool built with Streamlit to visualize and analyze historical and projected demographic trends across 54 African countries(from 1960 -2023). The raw dataset originally contained 54 separate year columns, making analysis and visualization inefficient. An ETL pipeline was constructed to unpivot (reshape) the dataset into a clean, long-format time series consisting of over 3,700 observations. The application features interactive dark-mode visualizations including distribution boxplots, correlation matrices, dynamic metric cards, and geographic heatmaps. Dashboard Link: dashboard-analytique-app-su… # Tech Stack Language: Python 3.12 Data Analysis: Pandas, NumPy Visualization: Plotly Express (Interactive charts) Interface: Streamlit Deployment: Streamlit Community Cloud # Data Pipeline (ETL) The project follows a structured data processing rigor: Extraction: Retrieval of the "World Development Indicators" dataset from the World Bank. Transformation (Wide to Long): Reshaping from wide format (years as columns) to long format via the melt method. The dataset expanded from 54 rows to over 3,400 rows. Cleaning & Enrichment: Normalization of column names (snake_case). Missing value handling using median imputation by country. Outlier detection using the IQR (Interquartile Range) method. Creation of 10 analytical columns (YoY growth rate, Population in millions, Regions, Decades, etc.). Loading: Export to an optimized CSV file for the dashboard. # Dashboard Features The dashboard provides 5 levels of analytical reading: - Key Performance Indicators (KPIs): Instant visualization of total filtered population and average growth rate. - Temporal Analysis: Line chart showing growth trajectories by country. - Geographic Comparison: Interactive choropleth map of Africa. …