Hello,
Still with aggregate, use length() not sum().
dtagroup <- aggregate(y ~ A + B + C, data=dtf, sum)
dtalength <- aggregate(y ~ A + B + C, data=dtf, length)
# Now merge the two
names(dtalength)[4] <- "count"
mm <- merge(dtagroup, dtalength)
# And make it pretty
mm <- mm[, c("y", "A", "B", "C", "count")]
mm
Hope this helps,
Rui Barradas
Em 20-07-2012 19:52, Christopher Desjardins escreveu:
As a follow up is there any way to also get the count for each combination?
For example
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
Should become:
y A B C count
2 1 1 2 4
1 1 2 1 2
0 1 2 2 1
.
.
.
So I would know there were 2 successes out of 4.
Thanks!
Chris
On Fri, Jul 20, 2012 at 10:41 AM, Christopher Desjardins <
cddesjard...@gmail.com> wrote:
Thanks the aggregate() command is what I was looking for.
Chris
On Thu, Jul 19, 2012 at 9:03 PM, David L Carlson <dcarl...@tamu.edu>wrote:
dtf <- 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",
+ header=TRUE)
dtagroup <- aggregate(y~A+B+C, dtf, sum)
# Gets you the groups. If you need the column/row order:
dtagroup <- dtagroup[order(dtagroup$y, decreasing=TRUE),c(4, 1:3)]
----------------------------------------------
David L Carlson
Associate Professor of Anthropology
Texas A&M University
College Station, TX 77843-4352
-----Original Message-----
From: r-help-boun...@r-project.org [mailto:r-help-bounces@r-
project.org] On Behalf Of Christopher Desjardins
Sent: Thursday, July 19, 2012 7:35 PM
To: R help
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@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.
[[alternative HTML version deleted]]
______________________________________________
R-help@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.
______________________________________________
R-help@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.
