[R] Changing ungrouped cases to grouped cases
arun
smartpink111 at yahoo.com
Fri Jul 20 03:25:56 CEST 2012
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.
More information about the R-help
mailing list