[R] How to take the ave of two rows in a data frame

John Kane jrkrideau at yahoo.ca
Fri Nov 30 16:37:40 CET 2007


Try the reshape package

This should do what you want.
================================================
library(reshape)
df1 <- melt(mydata, id=c("ID"),
measured=c("a1","a2","a3")) ; df1
stats  <- cast(df1, ID ~ variable  , mean) ; stats
=================================================


--- affy snp <affysnp at gmail.com> wrote:

> > Dear list,
> > I have a data frame like:
> >
> > > log2.ratios[1:3,1:4]
> >            ID                  a1             a2  
>           a3
> > 1 GS1-232B23      -0.0207500 0.17553833 
> 0.21939333
> > 2 RP11-82D16      -0.1896667 0.02645167
> -0.03112333
> > 3 RP11-62M23      -0.1761700 0.08214500
> -0.04877000
> > 4 RP11-62M23      0.2761700 -0.15214500
> -0.05877000
> >
> 
> the 3rd and 4th rows are of the same ID, I would
> like to take the avarage of
> these
> two rows and get the data frame to:
> 
>         ID                  a1             a2       
>      a3
> 1 GS1-232B23      -0.0207500 0.17553833  0.21939333
> 2 RP11-82D16      -0.1896667 0.02645167 -0.03112333
> 3 RP11-62M23      -0.05         -0.035          
> 0.094135
> 
> Can anyone suggest how to deal with this (to take
> the ave of two rows of the
> same ID ) more quickly?
> 
> Thanks a bunch!
> 
> Allen
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at r-project.org mailing list
> 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