madhav1698/NigeriaMalproj

project analyzing the impact of malaria across Nigeria, where I examined geographic and public health factors affecting different regions # Nigeria Malaria Data Analysis Assessment This project involves analyzing malaria prevalence and housing quality data for children under the age of five in Nigeria. The analysis includes data cleaning, statistical calculations, geospatial mapping, and data visualization. ## Project Overview The primary goal of this assessment is to answer a series of questions related to malaria testing results (blood smear, rapid test, and microscopy) and their distribution across different demographics (urban vs rural) and geographical locations (Nigerian states). Additionally, the project explores the relationship between housing quality and malaria. ## Notebooks and Analysis The project is organized into several Jupyter notebooks, each addressing specific questions from the assessment: - **q1.ipynb**: Calculates the number of children under the age of five tested for malaria with a blood smear test. - **q2&q4.ipynb**: Analyzes rapid test results, determining the number of children tested and those who tested positive. - **q3.ipynb**: Estimates the number of children who tested positive for malaria via microscopy, using blood smear results as a proxy. - **q5.ipynb**: Provides a visualization showing the count of positive and negative malaria cases by microscopy in urban and rural areas. - **q6.ipynb**: Visualizes the proportion of positive vs. negative malaria cases in urban and rural areas. - **q7.ipynb**: Generates an interactive map showing the number of children who tested positive for malaria by state. - **q8.ipynb**: Extracts data from a raster file to create a map showing average housing quality values for each Nigerian state. - **q9.ipynb**: A separate data scraping task involving IMDb movie ratings and various visualizations (distribution of ratings, ratings over time, and comparison with IMDb averages). ## Data Dictionary Key columns used in the analysis: - `hc1`: Age in months. - `hml32`: Results of blood smear test (Microscopy proxy). - `hml34`: Barcode for bl …