Jan 2 in Data Science

Q: During analysis, how do you treat missing values?

1 Answer

Jan 2

The extent of the missing values is identified after identifying the variables with missing values. If any patterns are identified the analyst has to concentrate on them as it could lead to interesting and meaningful business insights.

If there are no patterns identified, then the missing values can be substituted with mean or median values (imputation) or they can simply be ignored. Assigning a default value which can be mean, minimum or maximum value. Getting into the data is important.

If it is a categorical variable, the default value is assigned. The missing value is assigned a default value. If you have a distribution of data coming, for normal distribution give the mean value.

If 80% of the values for a variable are missing then you can answer that you would be dropping the variable instead of treating the missing values.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

Nov 14, 2019 in R Language
Aug 24, 2019 in Ansible
Feb 13 in JAVA