R help - Mar 2009 - Reshape question.

This hopefully is trivial. I am trying to reshape the data using the reshape
package.

First I read in the data:

a2009 <- read.csv("Total2009.dat", header = TRUE)

Then I trim it so that it only contains the columns that I have interested in:

m2009 <- melt(a2009,
id.var=c("DayOfYear","Category","SubCategory","Sku"),
measure.var=c("Quantity"), na.rm=TRUE)

Then I start to formulate the data that I will process:

c2009 <- cast(m2009, DayOfYear ~ variable | Category, sum)

Finally I aggregate the data:

t2009 <- cast(m2009, DayOfYear ~ variable, sum)

My question is on the third step above (repeated here)

c2009 <- cast(m2009, DayOfYear ~ variable | Category, sum)

This gets the data assocated with a unique 'Category' name. I want to
get the data grouped by 'Category' and 'SubCategory'. The
'SubCategory' is not unique but the combination 'Category' and
'SubCategory' form a unique pair. What would be the formula that would
give me the data grouped by Category AND SubCategory? Would it be as simple as:

c2009 <- cast(m2009, DayOfYear ~ variable | Category & SubCategory, sum)

?

Thank you for your suggestions.

Kevin

how about:
c2009 <- cast(m2009, Category + SubCategory +DayOfYear ~ variable , sum)
?


p.s: toy data would be nice to have :)






On Wed, Mar 11, 2009 at 9:47 PM, <rkevinburton@charter.net> wrote:
> This hopefully is trivial. I am trying to reshape the data using the
> reshape package.
>
> First I read in the data:
>
> a2009 <- read.csv("Total2009.dat", header = TRUE)
>
> Then I trim it so that it only contains the columns that I have interested
> in:
>
> m2009 <- melt(a2009,
id.var=c("DayOfYear","Category","SubCategory","Sku"),
> measure.var=c("Quantity"), na.rm=TRUE)
>
> Then I start to formulate the data that I will process:
>
> c2009 <- cast(m2009, DayOfYear ~ variable | Category, sum)
>
> Finally I aggregate the data:
>
> t2009 <- cast(m2009, DayOfYear ~ variable, sum)
>
> My question is on the third step above (repeated here)
>
> c2009 <- cast(m2009, DayOfYear ~ variable | Category, sum)
>
> This gets the data assocated with a unique 'Category' name. I want
to get
> the data grouped by 'Category' and 'SubCategory'. The
'SubCategory' is not
> unique but the combination 'Category' and 'SubCategory'
form a unique pair.
> What would be the formula that would give me the data grouped by Category
> AND SubCategory? Would it be as simple as:
>
> c2009 <- cast(m2009, DayOfYear ~ variable | Category & SubCategory,
sum)
>
> ?
>
> Thank you for your suggestions.
>
> Kevin
>
> ______________________________________________
> 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.
>


-- 
----------------------------------------------


My contact information:
Tal Galili
Phone number: 972-50-3373767
FaceBook: Tal Galili
My Blogs:
www.talgalili.com
www.biostatistics.co.il

	[[alternative HTML version deleted]]