Project 2 - EDA on Vehicle Insurance Customer Data

EDA on Vehicle Insurance Customer Data

1. step1- Reading Data

2. step2- Checking and Cleaning the data

- Null values

-counting the null values of each column of table1 and 2

- dropping rows with null customer_id of table1 and 2

-replacing all null values for numeric columns by mean of table1 and 2

-replacing all null values for Categorical value by mode of table1 and 2

- outliers

-generating a summary of count of all the outliers column wise of table1 (only for numeric columns)

-replacing all outlier values for numeric columns by mean for table 1
-though as can be seen above, there are no outliers at all!, anyways the code is following

-generating a summary of count of all the outliers column wise of table2 (only for numeric columns)

- replacing all outlier values for numeric columns by mean for table 2

-Remove Whitespaces from table and 2

-case correction for table an table 2

3. Step3- Creating a master table

4. Step4- getting information

-Gender wise average annual premium and Age wise average annual premium

5.Is there any relation between Person Age and annual premium?