Re: [R] adding group totals to a table

From: Anders Schwartz Corr <corr_at_fas.harvard.edu>
Date: Mon, 10 Dec 2007 05:02:38 -0500 (EST)

Hi Chris, This is a very rough first conceptual program you could use -- double check all the syntax as I know it won't work at first go. It's untested but can be jiggered to work! Good luck! Anders

Use unique() to get your unique combinations, then loop or vectorize through each unique combination to count the combos.

unique(data)->x
thirdcol<-NULL
for(i in 1:dim(data)[1]){

 	for(k in 1:dim(x)[1]{
 	thirdcol<-cbind(thirdcol,dim(data[data[i,] %in% x[k,]])[1])
}}

newdata<-cbind(data,thirdcol)

On Sun, 9 Dec 2007, christopher snow 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.
>



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. Received on Mon 10 Dec 2007 - 10:26:12 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 10 Dec 2007 - 10:30:18 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.