Project 2 - EDA on Vehicle Insurance Customer Data

Following steps are involved in doing the Analysis:

1. First, I imported two raw data sets and added desired column names to it.(using pd.read_csv())

2. Then displayed total null values in both tables columnwise(using isna().sum())

3. Then I removed the null values of column id in both tables(using dropna function)

4.All null values in numeric column is replaced by mean. (using fillna() with mean as argument)

5. Then I replaced all null values in categorical column by mode(fillna() with mode value as argument)

6. Then I found outliers in all columns by using Interquartile Rule and replaced them with mean.

7. Then I removed white spaces using strip function and droped duplicate datas.

8. Then I create dummy of both tables. and mearge them to create a mastercopy

9. Then found out the required answers as per query.