Project 2 - EDA on Vehicle Insurance Customer Data

In Project_2 I have learned about - How to import Pandas,How read and write cvs file.

How to make graph in Python.how to import numpy.

Chaquing & cleaning Data Value.

• Generate a summary of count of all the null values column wise
• Drop Null values for customer_id because central tendencies for id’s is not feasible.
• Replace all null values for numeric columns by mean.
• Replace all null values for Categorical value by mode.

• White spaces

  • Remove white spaces

  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.