Hi,
You could try this:
dat3<-read.table(text="
product min_price max_price mean_price country price_band
11 34 50 40 VN 0-300
22 10 30 15 VN 0-300
",sep="",header=TRUE,stringsAsFactors=FALSE)
library(reshape2)
SubsetPrice<-dat3[grep("price",names(dat3))]
dat3$newPrice<-paste(SubsetPrice[,3],paste("[",SubsetPrice[,1],",",SubsetPrice[,2],"]",sep=""),sep="
")
dcast(dat3,product+price_band~country,value.var="newPrice")
# product price_band VN
#1 11 0-300 40 [34,50]
#2 22 0-300 15 [10,30]
A.K.
----- Original Message -----
From: Tammy Ma <metal_lical...@live.com>
To: "r-help@r-project.org" <r-help@r-project.org>
Cc:
Sent: Thursday, December 13, 2012 5:42 AM
Subject: [R] how to aggregate the dataset
HI,
Sorry for messing up..
I want to transform the following dataset:
product min_price max_price mean_price country price_band
11 34 50 40 VN 0-300
22 10 30 15 VN 0-300
Into:
product VN price_band
11 40 0-300
[34,50]
22 15 0-300
[10,30]
How can I do this in r? I have large dataset like this. I want to transform all
into that one. Thanks a lot.
Kind regards,
Tammy
[[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.
______________________________________________
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.
