During analysis, how do you treat the missing values?

1.	During analysis, how do you treat the missing values?
Answer» To IDENTIFY the extent of missing VALUES, we first have to identify the variables with the missing values. Let us say a pattern is identified. The analyst should now concentrate on them as it could lead to interesting and meaningful insights. HOWEVER, if there are no patterns identified, we can SUBSTITUTE the missing values with the median or mean values or we can simply ignore the missing values. If the variable is categorical, the default value to the mean, MINIMUM, and maximum is assigned. The missing value is assigned to the default value. If we have a distribution of data coming, for normal distribution, we give the mean value. If 80% of the values are missing for a particular variable, then we would drop the variable instead of treating the missing values.

Answer»

To IDENTIFY the extent of missing VALUES, we first have to identify the variables with the missing values. Let us say a pattern is identified. The analyst should now concentrate on them as it could lead to interesting and meaningful insights. HOWEVER, if there are no patterns identified, we can SUBSTITUTE the missing values with the median or mean values or we can simply ignore the missing values.

If the variable is categorical, the default value to the mean, MINIMUM, and maximum is assigned. The missing value is assigned to the default value. If we have a distribution of data coming, for normal distribution, we give the mean value.

If 80% of the values are missing for a particular variable, then we would drop the variable instead of treating the missing values.

Discussion

No Comment Found

Related InterviewSolutions

How is the grid search parameter different from the random search tuning strategy?
What is the importance of dimensionality reduction?
How do you identify if a coin is biased?
How is feature selection performed using the regularization method?
What are various assumptions used in linear regression? What would happen if they are violated?
Is it good to do dimensionality reduction before fitting a Support Vector Model?
Give one example where both false positives and false negatives are important equally?
What are some examples when false positive has proven important than false negative?
Toss the selected coin 10 times from a jar of 1000 coins. Out of 1000 coins, 999 coins are fair and 1 coin is double-headed, assume that you see 10 heads. Estimate the probability of getting a head in the next coin toss.
Consider a case where you know the probability of finding at least one shooting star in a 15-minute interval is 30%. Evaluate the probability of finding at least one shooting star in a one-hour duration?