How to normalize the dataset with many missing values?


#1

Is there any method or package which ll help me in normalizing the data with many missing values(NA)…

data set is in follwing format.
GDP FDI net_income
country1
country2
country3
.
.
.
.
.
country80

any help ll be much appreciated.

Thanks
Ashis


#2

hello @Ashis,

Before you normalize the data,you will have to treat the missing values.If it is categorical you might want to consider replacing the missing values with the mode.
In case of continuous you can replace them with the mean.
If you are using R there is a package called “mice” which can be used for missing value imputation.
Hope this helps!!


#3

Thanks for your help.