aurelephy/Tanzanian-Water-Wells

Tanzania, as a developing country, struggles with providing clean water to its population of over 57,000,000. There are many water points already established in the country, but some are in need of repair while others have failed altogether. # Tanzanian-Water-Wells ## Business Understanding Tanzania struggles with providing clean water to its population, particularly in rural areas where access to safe drinking water and well-maintenance are significant issues. These challenges often result from a combination of limited infrastructure, funding constraints, and the harsh environmental conditions that affect the sustainability of water sources ## Goal of the project The goal is to use data from existing wells throughout the country to identify the wells in need of repair. This analysis is focused on assisting the Tanzanian Government reduce resources spent to identify water wells that need repair to ensure that clean water is available to its citizens. ## project objective ### Main Objective This analysis is focused on assisting the Tanzanian Government reduce resources spent to identify water wells that need repair to ensure that clean water is available to its citizens. ### Specific Objective to analyze the functionality of the existing water wells ## Data Understanding To better understand the data, I have reviewed the features and separated them into numerical and categorical feature types: **Numerical:** - `id` - Unique identifier - `amount_tsh` - Total static head (amount water available to waterpoint) - `gps_height` - Altitude of the well - `longitude` - GPS coordinate - `latitude` - GPS coordinate - `num_private` - Number private - `population` - Population around the well - `construction_year` - Year the waterpoint was constructed **Categorical:** - `installer` - Organization that installed the well - `wpt_name` - Name of the waterpoint if there is one - `basin` - Geographic water basin - `subvillage` - Geographic location - `lga` - Geographic location - `ward` - Geographic location - `public_meeting` - True/False - `scheme_management` - Who operates the waterpoint - `permit` - If the waterpoint is permitted - `extraction_type` - The kind of extraction the waterpoint uses - `extraction_type_gro …