TimmyX27/-Nigerian-Population-and-Health-Indicators-Analysis

This project explores the relationship between population trends and health indicators in Nigeria using data obtained through web scraping and visualization in Power BI. The goal is to understand how demographic changes — such as fertility, mortality, and population growth — impact key health outcomes across different regions and time periods. # -Nigerian-Population-and-Health-Indicators-Analysis This project explores the relationship between population trends and health indicators in Nigeria using data obtained through web scraping and visualization in Power BI. The goal is to understand how demographic changes — such as fertility, mortality, and population growth — impact key health outcomes across different regions and time periods. Web Scraping Nigerian Demographic Data 🇳🇬📊 This repository contains the Python code used to scrape Vital Statistics data from the Wikipedia page on the Demographics of Nigeria. The scraped data was then cleaned and utilized to create an interactive dashboard in Power BI for deeper analysis. The goal of this project was to extract structured, historical demographic data, which is mm often presented in a hard-to-reuse tabular format on web pages, into a clean, reusable dataset (population.csv). ⚙️ Workflow and Tools This project's data pipeline followed these steps: * Data Extraction (Web Scraping): The HTML content from the target Wikipedia page was downloaded and parsed. * HTML Parsing: The specific HTML table containing the vital statistics was located using BeautifulSoup. * Data Transformation: The table data was converted into a structured Pandas DataFrame. * Data Storage: The final cleaned data was saved into a CSV file (population.csv). * Data Visualization (Power BI): The generated CSV file was imported into Power BI to create an interactive and visual dashboard. | Tool | Purpose | |---|---| | Python | Core programming language for scraping and data processing. | | requests | Used to make HTTP requests to the target URL to retrieve the HTML content. | | BeautifulSoup | Library for parsing the HTML content and navigating the tag structure to find the target table. | | pandas | Used to structure and clean the extracted data into a DataFrame and export it to a CSV file. | | Power BI | Employed for data ingestion, visualization, and creating the final interactive dashboa …