[R] Changing ungrouped cases to grouped cases

[arun]

Hi,

Try this:

dat1<-read.table(text="
y    A  B  C
0    1    1  2
0    1    2  1
1    1    1  2
0    1    1  2
1    1    1  2
1    1    2  1
0    1    2  2
",sep="",header=TRUE)
 dat2<-aggregate(y~A+B+C,data=dat1,sum)
 dat2<-dat2[,c(4,1:3)]
dat3<-dat2[with(dat2,rev(order(y,A,B,C))),]
 dat3
  y A B C
2 2 1 1 2
1 1 1 2 1
3 0 1 2 2

A.K.





----- Original Message -----
From: Christopher Desjardins <cddesjardins at gmail.com>
To: R help <r-help at r-project.org>
Cc: 
Sent: Thursday, July 19, 2012 8:34 PM
Subject: [R] Changing ungrouped cases to grouped cases

Hi,
I have my data the following way:

y     A   B   C
0     1    1   2
0     1    2   1
1     1    1   2
0     1    1   2
1     1    1   2
1     1    2   1
0     1    2   2
.
.
.
And so on.  How can I make my data look like the following:
y   A  B  C
2   1   1  2
1   1   2  1
0   1   2   2
.
.
.

In other words how can I change my ungrouped cases into grouped cases?
Thanks!
Chris

    [[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.