[R] Replacing NA s with the average

PIKAL Petr petr@p|k@| @end|ng |rom prechez@@cz
Mon Oct 18 16:43:35 CEST 2021


Hi.

sometimes is worth to try google first

R fill NA with average

resulted in

https://stackoverflow.com/questions/25835643/replace-missing-values-with-col
umn-mean

and from that

library(zoo)
na.aggregate(DF)

will replace all numeric NA values with column averages.

Cheers
Petr

> -----Original Message-----
> From: R-help <r-help-bounces using r-project.org> On Behalf Of Admire Tarisirayi
> Chirume
> Sent: Monday, October 18, 2021 2:39 PM
> To: Jim Lemon <drjimlemon using gmail.com>
> Cc: r-help mailing list <r-help using r-project.org>
> Subject: [R] Replacing NA s with the average
> 
> Good day colleagues. Below is a csv file attached which i am using in my
> > analysis.
> >
> >
> >
> > household.id <http://hh.id>
> >
> > hd17.perm
> >
> > hd17employ
> >
> > health.exp
> >
> > total.food.exp
> >
> > total.nfood.exp
> >
> > 1
> >
> > 2
> >
> > yes
> >
> > 1654
> >
> > 23654
> >
> > 23655
> >
> > 2
> >
> > 2
> >
> > yes
> >
> > NA
> >
> > NA
> >
> > 65984
> >
> > 3
> >
> > 6
> >
> > no
> >
> > 2547
> >
> > 123311
> >
> > 52416
> >
> > 4
> >
> > 8
> >
> > NA
> >
> > 2365
> >
> > 13648
> >
> > 12544
> >
> > 5
> >
> > 6
> >
> > NA
> >
> > 1254
> >
> > 36549
> >
> > 12365
> >
> > 6
> >
> > 8
> >
> > yes
> >
> > 1236
> >
> > 236541
> >
> > 26522
> >
> > 7
> >
> > 8
> >
> > no
> >
> > NA
> >
> > 13264
> >
> > 23698
> >
> >
> >
> >
> >
> > So I created a df using the above and its a csv file as follows
> >
> > wbpractice <- read.csv("world_practice.csv")
> >
> > Now i am doing data cleaning and trying to replace all missing values
> > with the averages of the respective columns.
> >
> > the dimension of the actual dataset is;
> >
> > dim(wbpractice)
> [1] 31998    6
> 
> I used the following script which i executed by i got some error messages
> 
> for(i in 1:ncol( wbpractice  )){
>      wbpractice  [is.na( wbpractice  [,i]), i] <- mean( wbpractice  [,i],
na.rm =
> TRUE)
>     }
> 
> Any help to replace all NAs with average values in my dataframe?
> 
> 
> 
> >
> >>
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-
> guide.html
> and provide commented, minimal, self-contained, reproducible code.


More information about the R-help mailing list