Project 2 - EDA on Vehicle Insurance Customer Data

Project 2 - EDA on Vehicle Insurance Customer Data

In this project we used pandas and numpy library.

we change column name and Check and Cleaning Data Quality.

Replace all null values for numeric columns by mean

Outliers Generate a summary of count of all the outliers column wise

checking outliers for age

White spaces Remove white spaces and case correction sing upper case

Convert nominal data (categorical) into dummies for future modeling use if required

Drop Duplicates (duplicated rows

Create a Master table for future use. Join the customer table and customer_policy table to get a master table using customer_id in both tables.

(Hint: use pd.merge() function)

Is there find relation between Person Age and annual premium