Missing Value analysis


#1

Hi All,

I need help of you all guys.
Actually, I am working on retail data set so here the problem is imputation by groups.
Manufacture>category>sub.brand>>brand>’units’
Here i need to impute data in units by Manufacture>category>sub.brand>>brand>.

Please Help me.


#2

Hi @vamshi4hope,

Missing value imputation is a very tricky question. In missing value imputation we have various methods which can impute the missing values, which also based on type of missing values we have in data. You can refer the link to know more about missing value types.

Here I am listing some methods which I used to impute missing values.

  1. Mean value imputation
  2. Median value imputation
  3. KNN
  4. Use ML(single or multiple) model to predict missing values

Since I don’t know which tool you are using so you can refer this link to impute missing values in R.

Regards
Ankit