Project 2 - EDA on Vehicle Insurance Customer Data

#####EDA on Vehicle Insurance Customer Data####

1. Add the column names to both datasets:

step 1 import pandas and set the csv (comma seoparater file using pandas in exal)

i. Column Name for customer details table:

ii. Column Name for customer_policy table:

2. Checking and Cleaning Data Quality:

mention the :

customer_id, Gender,age, driving licence present, region code, previously insured, vehicle age and vehicle damage, in respective order in table 1

i. count of all the null values column wise of table1 using for loop and it range

Drop Null values for customer_id because central tendencies for id’s is not feasible table1

ii. Outliers

iii. White spaces

• Remove white spaces from both of the table

iv. case correction(lower or upper, any one)

v. Convert nominal data (categorical) into dummies

• for future modeling use if required

vi. Drop Duplicates (duplicated rows)

3. 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)

4. Company needs some important information from the master table to make decisions for future growth.They needs following information:

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

using to import the pyplot function for find realtion b/w of them