[R] Aggregating two or more vaiables

Uwe Ligges ligges at statistik.tu-dortmund.de
Wed Nov 23 10:26:44 CET 2011



On 23.11.2011 09:33, aa99 wrote:
> hey;
>
> i am new to R and require some help. i have below table data and i would
> like to aggregate Retail and QSold by BrandName.
>
>
> BrandName	Segment	Retail	QSlod
> Oral B	        Whitening	10	2
> Colgate	Sensitive	20	4
> Colgate	Sensitive	30	6
> Oral B	        Whitening	40	8
> Close Up	Whitening	50	10
> Oral B	        Whitening	60	12
>
>
> OutPut I would like:
>
> BrandName	Retail 	QSlod
> Oral B	        sum(Retail)	Sum (Qsold)
> Colgate		
> Close Up		
>


aggregate(cbind(Retail, QSlod) ~ BrandName, data=dat, sum)

Uwe Ligges


>
>
>
> --
> View this message in context: http://r.789695.n4.nabble.com/Aggregating-two-or-more-vaiables-tp4098855p4098855.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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