Project 2 - EDA on Vehicle Insurance Customer Data

The project involves data preprocessing and analysis for an insurance company's customer data. The dataset consists of two tables: one containing customer details and another containing policy information. The tasks include adding column names, checking and cleaning data quality (handling null values, outliers, white spaces, case correction, and converting nominal data to dummies), creating a master table by joining the two datasets, and extracting key insights.

The analyses conducted include determining gender-wise and age-wise average annual premiums, checking data balance between genders, and finding the average annual premium based on vehicle age categories. Additionally, the project explores the relationship between person age and annual premium using correlation coefficients, with interpretations provided based on predefined thresholds.

The project aims to provide the insurance company with valuable information to make data-driven decisions for future growth and strategy planning.