Hi, folks,
Please first look at the codes:
plan_a=c('apple','orange','apple','apple','pear','bread')
plan_b=c('bread','bread','orange','bread','bread','yogurt')
value=1:6
data=data.frame(plan_a,plan_b,value)
library(plyr)
library(reshape)
mm=melt(data, id=c('plan_a','plan_b'))
sum_plan_a=cast(mm,plan_a~variable,sum)
### I would like to add a new column to the data.frame named 'data', with
the same sum of value for the same type of plan_a
### The result should come up like this:
plan_a plan_b value sum_plan_a
1 apple bread 1 8
2 orange bread 2 2
3 apple orange 3 8
4 apple bread 4 8
5 pear bread 5 5
6 bread yogurt 6 6
Any tips?
Thank you.
[[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.
