Challenge

Project 2 - EDA on Vehicle Insurance Customer Data

EDA on Vehicle Insurance Customer Data

1. Added the column names to both datasets:

2. Checked and Cleaned Data for Quality:

3. Created a Master table by Joining the customer table and customer_policy table using customer_id in both tables.

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

i. Gender wise average annual premium

ii. Age wise average annual premium

iii. Is your data balanced between the genders?

(Hint: Data is balanced if number of counts in each group is approximately same)

iv. Vehicle age wise average annual premium

5. Checked for any relation between Person Age and annual premium?

Ship work like this
in your own course.