ryanreilly/phase_3_project

Classification analysis to predict the operating condition of water wells in Tanzania. ## Tanzanian Water Well Prediction #### Authors: Ryan Reilley and Kevin McDonough ### Overview This project analyzes data for over 59,000 water wells that have been installed in Tanzania over the years. The goal of this analysis is to determine what features of a water well provide a good prediction of if the well is functional, not functional, or functional but needs repair. This will be done through exploratory data analysis and iterative predictive modeling using classification models. ### Business Problem The Tanzania Ministry of Water have hired us to predict the operating condition for wells in their country. They will use our analysis to send teams of people out to fix the waterpoints that are currently not functional or need repair. Based on our analysis, we are going to provide reccomendations based on the following. * Which wells you should start fixing first based on location * Which funders and installers to focus on when building new wells * Which type of wells should be replaced based on age ### Data Understanding Each row in this dataset represents a unique water well in Tanzania and surrounding information about the well. There are 59,400 rows in the training data set and 14,850 rows in the test data set. The target feature we will be predicting on is "status_group." Status_group represents the functionality of the well and there are three classes: "functional," "non functional" and "functional needs repair." There are a number of columns related to geo location of the well. There is also a good mix of continuous and categorical variables in the dataset. Each feature and its description is listed below. The different predictors are listed in the table below: | Feature | Description| |:-------| :-------| |amount_tsh| Total static head (amount water available to waterpoint)| |date_recorded| The date the row was entered| |funder| Who funded the well| |gps_height| Altitude of the well| |installer| Organization that installed the well| |longitude| G …