[R] group by in data.frame
zem
zmanolova at gmail.com
Fri Feb 25 16:14:50 CET 2011
Yeah, you are right
i want to post an short example what i want to do .. and in the meantime i
solved the problem ...
but here is:
i have something like this dataframe:
c1<-c(1,2,3,2,2,3,1,2,2,2)
c2<-c(5,6,7,7,5,7,5,7,6,6)
c3<-rnorm(10)
x<-cbind(c1,c2,c3)
> x
c1 c2 c3
[1,] 1 5 0.08279036
[2,] 2 6 0.59135988
[3,] 3 7 1.45520468
[4,] 2 7 -1.70094640
[5,] 2 5 0.13065228
[6,] 3 7 -1.12080980
[7,] 1 5 0.42779354
[8,] 2 7 -1.53111972
[9,] 2 6 0.29299987
[10,] 2 6 -0.01602095
#whith aggregate i receive this:
>aggregate(x[,3],list(x[,1],x[,2]),mean)
Group.1 Group.2 x
1 1 5 0.2552920
2 2 5 0.1306523
3 2 6 0.2894463
4 2 7 -1.6160331
5 3 7 0.1671974
and the problem was that i was grouping by 2 columns, so i couldn't copy the
result to x.
the solution was i made another column with paste(x[,1],x[,2],sep="_")
and then i used the solution from this link:
http://tolstoy.newcastle.edu.au/R/help/06/07/30184.html
so i solved my problem
Ivan, many thanks for your support and quik responses! :)
--
View this message in context: http://r.789695.n4.nabble.com/group-by-in-data-frame-tp3324240p3324608.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list