Aggregation - R-help | R Mailing Lists

arun

Thu, Feb 13, 2014 1:27 PM #

HI Farnoosh,

You can use ?dcast()
library(plyr)

?dcast(DataA,ID~Var1,value.var="Var2")
#? ID?? A?? B
#1? 1 100? 50
#2? 2 200 100
A.K.

On Thursday, February 13, 2014 2:59 PM, farnoosh sheikhi <farnoosh_81 at yahoo.com> wrote:

Hi Arun,

I hope all is well. I need to aggregate a data like below:

DataA

ID ? ? ? Var1 ? Var2
1? ? ? ? A100
1B50
2? ? ? ? A200
2B100


The transformed data should be like below:
ID ? AB
1100 ? 50
2200100


Thanks a lot.

Regards,?Farnoosh Sheikhi

arun

Thu, Feb 13, 2014 1:29 PM #

Sorry, the library should be 
library(reshape2)

On Thursday, February 13, 2014 4:27 PM, arun <smartpink111 at yahoo.com> wrote:

HI Farnoosh,

You can use ?dcast()
library(plyr)

?dcast(DataA,ID~Var1,value.var="Var2")
#? ID?? A?? B
#1? 1 100? 50
#2? 2 200 100
A.K.

On Thursday, February 13, 2014 2:59 PM, farnoosh sheikhi <farnoosh_81 at yahoo.com> wrote:

Hi Arun,

I hope all is well. I need to aggregate a data like below:

DataA

ID ? ? ? Var1 ? Var2
1? ? ? ? A100
1B50
2? ? ? ? A200
2B100


The transformed data should be like below:
ID ? AB
1100 ? 50
2200100


Thanks a lot.

Regards,?Farnoosh Sheikhi

Farnoosh Sheikhi

Thu, Feb 13, 2014 1:39 PM #

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20140213/f576e5d6/attachment.pl>