Hi All,

                I have a data frame like

a = data.frame(date = c(20081201, 20081202, 20081201), product = c("a b c d e", 
"a b c g h t", "d e h a c e h g"), sales = c(1, 2, 3))

                Now I want to aggregate the sales by part of the a$product. 
'Product' is the product name, a string separated by a space. The key in my 
aggregate function is first three items in "product" field. In my example, the 
key is "a b c", "a b c" and "d e h", respectively. Do you know how to do it? I 
thought an awkward way which needed several function calls (like strsplit, 
lapply, paste etc)  to manipulate the string in 'product' field. I guess there 
could be some more elegant way to do it.

                Thanks in advance.


HXD

        [[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.

Reply via email to