Project 2 - EDA on Vehicle Insurance Customer Data

answers in jupyter notebook

ques 1 is in docx file ques 2 is in jupyternotebook

file in jupyter notebook

perform on auto_clean.csv

ques 1 is in ms word

ques 2 is in ms word

all questions are in ms word

code in the jupyter notebook and rest in the word

in grading policy section it is mentioned that it should be done in excel. therefore i submitted both excel and word files but the calculations for ques 1 is done on excel. all answered questions are in excel and word file

no image required to solve the above questions

PCA, K-Means Clustering and Hierarchical Clustering are in three different scripts

These regression models are used to learn the underlying patterns in the given dataset and make predictions on whether a patient is likely to have heart disease based on their clinical parameters. 

some questions was not tought in the course

three files

I took Uber cab request from Kaggle. Dataset provided below

all the questions can be done in Python and R. but got no information. therefore I have to write it in the box; Display the data of white wine and red wine: Display the rows and columns of the "winequality-white" and "winequality-red" datasets. Get the size of both white wine and red wine: Count the number of rows and…

great learning

great learning

great learning

import pandas as pdimport mysql.connector cnx = mysql.connector.connect( host='your_host', user='your_user', password='your_password', database='alumni') def fetch_rows(table_name): query = f"SELECT * FROM {table_name} LIMIT 1000" df = pd.read_sql(query, cnx) return df table_names = [ 'College_A_HS', 'College_A_SE', 'College_A_SJ',…

Sub DataSummary() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Replace "Sheet1" with your actual sheet name ' Data Summary for All Female Clients Dim femaleData As Range Dim femaleIncome As Range Dim femaleLoanAmount As Range ' Filter data for female clients based on CODE_GENDER column Set femaleData =…

b and h are in sheet 1 pivot table in sheet 2

great learning

coding