[R] How to calculate row means while ignore NAs
lily li
chocold12 at gmail.com
Fri Oct 28 20:15:36 CEST 2016
My apologize, it has been solved. Just include w inside of select, such as:
select = c(w, x, y)
On Fri, Oct 28, 2016 at 12:06 PM, lily li <chocold12 at gmail.com> wrote:
> Hi R users,
>
> I have the dataframe as below:
>
> w=c(5,6,7,8)
> x=c(1,2,3,4)
> y=c(1,2,3)
> length(y)=4
> z=data.frame(w,x,y)
>
> z$mean1 <- rowMeans(subset(z, select = c(x, y)), na.rm = T)
> z$mean2 <- rowMeans(subset(z, select = c(x, y)), na.rm=F)
>
> w x y mean1 mean2
> 1 5 1 1 1 1
> 2 6 2 2 2 2
> 3 7 3 3 3 3
> 4 8 4 NA 4 NA
>
> How to calculate mean value for the three columns, while default removing
> NAs.
> For example, for the fourth row, the mean value should be (8+4)/2 = 6
>
> Thanks for your help.
>
[[alternative HTML version deleted]]
More information about the R-help
mailing list