Data Science Capstone Project Using Python and Tableau
NIDDK (National Institute of Diabetes and Digestive and Kidney Diseases) research creates knowledge about and treatments for the most chronic, costly, and consequential diseases.
The dataset used in this project is originally from NIDDK. The objective is to predict whether or not a patient has diabetes, based on certain diagnostic measurements included in the dataset. Build a model to accurately predict whether the patients in the dataset have diabetes or not.
The datasets consists of several medical predictor variables and one target variable (Outcome). Predictor variables includes the number of pregnancies the patient has had, their BMI, insulin level, age, and more.
Variables Description
Pregnancies Number of times pregnant
Glucose Plasma glucose concentration in an oral glucose tolerance test
BloodPressure Diastolic blood pressure (mm Hg)
SkinThickness Triceps skinfold thickness (mm)
Insulin Two hour serum insulin
BMI Body Mass Index
DiabetesPedigreeFunction Diabetes pedigree function
Age Age in years
Outcome Class variable (either 0 or 1). 268 of 768 values are 1, and the others are 0
Perform descriptive analysis. Understand the variables and their corresponding values. On the columns below, a value of zero does not make sense and thus indicates missing value:
Glucose
BloodPressure
SkinThickness
Insulin
BMI
Visually explore these variables using histograms. Treat the missing values accordingly.
There are integer and float data type variables in this dataset. Create a count (frequency) plot describing the data types and the count of variables.
Check the balance of the data by plotting the count of outcomes by their value. Describe your findings and plan future course of action.
Create scatter charts between the pair of variables to understand the relationships. Describe your findings.
Perform correlation analysis. Visually explore it using a heat map.
Devise strategies for model building. It is important to decide the right validation framework. Express your thought process.
Apply an appropriate classification algorithm to build a model.
Compare various models with the results from KNN algorithm.
Create a classification report by analyzing sensitivity, specificity, AUC (ROC curve), etc.
Please be descriptive to explain what values of these parameter you have used.
Create a dashboard in tableau by choosing appropriate chart types and metrics useful for the business. The dashboard must entail the following:
Pie chart to describe the diabetic or non-diabetic population
Scatter charts between relevant variables to analyze the relationships
Histogram or frequency charts to analyze the distribution of the data
Heatmap of correlation analysis among the relevant variables
Create bins of these age values: 20-25, 25-30, 30-35, etc. Analyze different variables for these age brackets using a bubble chart.
Download the data sets from https://github.com/Simplilearn-Edu/Data-Science-Capstone-Projects