Because of machine memory restrictions I think I need to go with a vector by
vector approach. When I concatenate I get:
> m <- melt(t, id.var=c("DayOfYear","Category","SubCategory","Sku"),
> measure.var=c("Quantity"))
Error: cannot allocate vector of size 7.8 Mb
Kevin
---- hadley wickham <[EMAIL PROTECTED]> wrote:
> Hi Kevin,
>
> I think easiest way would be to create a single dataset with both
> years in, and then work from that:
>
> t2008$year <- 2008
> t2007$year <- 2007
>
> tall <- rbind(t2007, t2008)
> mall <- melt(tall,
> id.var=c("DayOfYear","Category","SubCategory","Sku", "year"),
> measure.var=c("Quantity")
>
> cast(mall, DayOfYear ~ variable | Sku, sum)
> cast(mall, Year + DayOfYear ~ variable | Sku, sum)
>
> Hadley
>
>
> On Sat, Aug 9, 2008 at 11:44 AM, <[EMAIL PROTECTED]> wrote:
> > I have mange to use the library reshape to give me data structures that I
> > want. Specifically:
> >
> > m2008 <- melt(t2008, id.var=c("DayOfYear","Category","SubCategory","Sku"),
> > measure.var=c("Quantity"))
> > m2007 <- melt(t2007, id.var=c("DayOfYear","Category","SubCategory","Sku"),
> > measure.var=c("Quantity"))
> >
> > r2008 <- cast(m2008, DayOfYear ~ variable | Sku, sum)
> > r2007 <- cast(m2007, DayOfYear ~ variable | Sku, sum)
> >
> > Now I would like to union the two lists. So I start out with an empty
> > master list that will contain (when I am done) the merge (union) of r2008
> > and r2007. By "union" I mean that if the Sku exists in r2007 and r2008 I
> > would like to create a new data frame that has the lists for DayOfYear and
> > Quantity "merged" and append it to 'master'. If the Sku is not common to
> > both objects then just copy or append to the 'master'.
> >
> > Is it possible to come up with an expression and aggregate function that
> > will do this? Is this better handle with aggregate functions or lapply?
> > Being new to 'R' it is hard for me to tell.
> >
> > Thank you.
> >
> > 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.
> >
>
>
>
> --
> http://had.co.nz/
______________________________________________
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.
