please answer this question

Place all your coding work for this question in the lab notebook template and your 300-word summary in the TMA word processing template.

In this question, you will use Pima Indians Diabetes Dataset. Download the data set from https://www.kaggle.com/uciml/pima-indians-diabetes-database.

This dataset is originally from the National Institute of Diabetes and Digestive and Kidney Diseases. The objective of the dataset is to diagnostically predict whether a patient has diabetes, based on certain diagnostic measurements included in the dataset. Several constraints were placed on the selection of these instances from a larger database. In particular, all patients here are females at least 21 years old of Pima Indian heritage.

Write a summary of your understanding of the purpose and contents of this dataset and your assessment of the quality of the data. To do this, you must develop code to explore the data programmatically in a notebook and provide it as part of your answer.

Write a summary (~ 300 words) in word processing document which includes the following:

· The contents of the above dataset with detailed description

· The quality of the data with respect to validity, accuracy, completeness, consistency, and uniformity

· Estimate the amount of dirtiness of the data of each type and discuss its potential impact of the goal of the analysis

Place all your coding work for this question in the lab notebook template and your project report in the TMA word processing template.

In answering this question, you will benefit from the experience you gained in the previous question.

In this question, you will formulate your own research question and investigate it and write a report of your findings in your Solution document. The research question should be related to investigating the relationships between a selected independent variable and a selected dependent variable. Your investigation must include the use of a proper measure of correlation to show the relationships between your selected variables and appropriate visualizations. Visualizations can be provided either by utilizing folium or matplotlib.

For example, you may wish to investigate the relationship between

· Blood pressure and diabetes

· Number of pregnancies and diabetes

· Age and diabetes

· ……..

The above given relationships are just samples, there are many other research questions that you can investigate.

Study the data sets, analyze it and then prepare a research document according to the following report structure:

1. Executive summary

0. A brief summary of your project

1. Aims and objectives

1. A brief description about the general aims of your project

1. and more detailed objectives to achieve those aims

1. The Research Question

2. State your research question by:

0. identifying the independent variables, and

0. the dependent variables you wish to investigate

1. Analysis and Findings

3. Produce convincing correlations demonstrating a statistically significant correlation among your chosen independent and dependent variables. You must choose an appropriate statistical method for the types of measure in the variables in your study.

3. Give your critical interpretation and conclusions about those observed correlations.

3. Produce tabular summaries of the data in the form of crosstabs or pivot tables along with your critical interpretation of those tables

3. At least two relevant visualizations

3. along with your critical interpretations of each visualization

3. Your final answer to the research question you posed

3. and critical comment on your conclusions.

1. Reflection

4. Reflect on:

0. your experience with the project

0. what you learned

0. what you went well

0. what went wrong

0. and how can you benefit from this experience in future projects

1. References

5. At least 6 references. All references must be in the Harvard style of referencing and must be accompanied by proper citations in the text.