Project 2 - EDA on Vehicle Insurance Customer Data

In Project 2, I learned how to perform Exploratory Data Analysis (EDA) on Vehicle Insurance Customer Data. The project aimed to assist the company in offering premium discounts by cleaning and merging customer and policy data. I added column names, checked and cleaned the data by handling null values, outliers, white spaces, and case corrections. I also converted categorical data into dummies for future modeling and removed duplicates. By merging the customer and policy datasets, I created a master table. I then analyzed gender-wise, age-wise, and vehicle age-wise average premiums, checked the gender balance, and explored the relationship between customer age and annual premium using correlation. This project helped me understand the importance of data cleaning and transformation for accurate analysis, and how data-driven insights can guide decision-making processes in offering targeted discounts, improving customer retention, and optimizing business strategies.