Message-ID: <CAKK5bs-gHQd=9uT5DRJsSVN7weVPrZnqa5hp9di5Cg__1SE4Gg@mail.gmail.com>
Date: 2012-12-16T03:44:22Z
From: Yao He
Subject: how to handle NA values in aggregate()
Dear All:
I am trying to calculate four columns' means in a dataframe like this:
FID MID IID EW_INCU EW_17.5 EMW EEratio
1 4621 TWF2H5 45.26 NA 15.61 NA
1 4621 TWF2H6 48.02 44.09 13.41 0.3041506
2 4630 TWF2H19 51.44 47.81 NA NA
2 4631 TWF2H21 NA 52.72 16.70 0.3167678
2 4632 TWF2H22 55.70 50.45 16.48 0.3266601
2 4633 TWF2H23 44.42 40.89 12.96 0.3169479
I try this code
> aggregate(df[,4:7],df[,1],mean)
But I couldn't set the agrument na.rm=T in the mean() function,so the
results are all NAs
Please tell me how to handle NA values in the use of aggregate()
Thanks a lot
Yao He
?????????????????????????
Master candidate in 2rd year
Department of Animal genetics & breeding
Room 436,College of Animial Science&Technology,
China Agriculture University,Beijing,100193
E-mail: yao.h.1988 at gmail.com
??????????????????????????