[R] adding group totals to a table

[jim holtman]

?ave

> x
  V1 V2
1  A  1
2  A  1
3  A  2
4  B  2
5  C  0
> x$len <- ave(seq_along(x$V1), x$V1, x$V2, FUN=length)
> x
  V1 V2 len
1  A  1   2
2  A  1   2
3  A  2   1
4  B  2   1
5  C  0   1
>


On Dec 9, 2007 1:35 AM, christopher snow <snowch at coralms.com> wrote:
> I have a table with two columns:
>
> A   1
> A   1
> A   2
> B   2
> C   0
>
> I would like to produce a third column that contains the counts of each
> unique combination of col1 and col2:
>
> A   1  2
> A   1  2
> A   2  1
> B   2  1
> C   0  1
>
> How can I do this in R?
>
> Thanks in advance ...
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> ______________________________________________
> 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.
>



-- 
Jim Holtman
Cincinnati, OH
+1 513 646 9390

What is the problem you are trying to solve?