Hello again Duncan, I am sorry it took me two days to get back to your response.
Regarding reshape - It is well presented here: http://www.jstatsoft.org/v21/i12 And there is also more information about it here: http://had.co.nz/reshape/ After playing around with it, I wrote a small "bridge" between {reshape} and {tables} in a function called "tabular.cast_df". I am attaching the code (with self contained examples) to this e-mail. I would be happy for any revisions from either you or anyone else on the list. While working on this, I found something which might be a bug in {tables} (either in the way I am using the function, or in the way that it works), please see example bellow: # loading libraries library(tables) library(reshape) # getting our data ready names(airquality) <- tolower(names(airquality)) airquality2 <- airquality airquality2$temp2 <- ifelse(airquality2$temp > median(airquality2$temp), "hot", "cold") aqm <- melt(airquality2, id=c("month", "day","temp2"), na.rm=TRUE) colnames(aqm)[4] <- "variable2" # because otherwise the function is having problem when relying on the melt function of the cast object head(aqm,4) # month day temp2 variable2 value # 1 5 1 cold ozone 41 # 2 5 2 cold ozone 36 # 3 5 3 cold ozone 12 # possible BUG ?! tabular(month*temp2~variable2*result_variable, data = m_xx) # this one gets the "temp2" header in the first 2 columns (instead of in only the second column). ----------------Contact Details:------------------------------------------------------- Contact me: tal.gal...@gmail.com | 972-52-7275845 Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) | www.r-statistics.com (English) ---------------------------------------------------------------------------------------------- On Fri, Dec 9, 2011 at 1:51 AM, Duncan Murdoch <murdoch.dun...@gmail.com>wrote: > On 11-12-08 1:37 PM, Tal Galili wrote: > >> Helloe dear Duncan, Gabor, Michael and others, >> >> Do you think it could be (reasonably) possible to create a bridge between >> a >> "cast_df" object from the {reshape} package into a table in Duncan's new >> {tables} package? >> > > I'm not that familiar with the reshape package (and neither it nor > reshape2 appears to have a vignette to give me an overview), so I don't > have any idea if that makes sense. The table package is made to work on > dataframes, and only dataframes. It converts them into matrices with lots > of attributes, so that the print methods can put nice labels on. But it's > strictly rectangular to rectangular in the kinds of conversions it does, > and from the little I know about reshape, it works on more general arrays, > converting them to and from dataframes. > > > > >> That would allow one to do pivot-table like operations on an object using >> {reshape}, and then display it (as it would have been in excel - or >> better) >> using the {tables} package. >> > > You'll have to give an example of what you want to do. > > Duncan Murdoch > > > >> >> >> >> >> >> ----------------Contact >> Details:----------------------**------------------------------**--- >> Contact me: tal.gal...@gmail.com | 972-52-7275845 >> Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) | >> www.r-statistics.com (English) >> ------------------------------**------------------------------** >> ------------------------------**---- >> >> >> >> >> On Thu, Dec 8, 2011 at 5:24 PM, Michael<comtech....@gmail.com> wrote: >> >> Hi folks, >>> >>> In addition to Excel style tables, it would be great to have Excel 2010 >>> Pivot Table in R... >>> >>> Any thoughts? >>> >>> Thanks a lot! >>> >>> On Thu, Dec 8, 2011 at 4:49 AM, Tal Galili<tal.gal...@gmail.com> wrote: >>> >>> I think it would be *great *if an extension of Duncan's new "tables" >>>> >>>> package could include themes and switches as are seen in the video Gabor >>>> just linked to. >>>> >>>> >>>> Tal >>>> >>>> >>>> On Thu, Dec 8, 2011 at 6:58 AM, Gabor Grothendieck< >>>> ggrothendi...@gmail.com> wrote: >>>> >>>> On Wed, Dec 7, 2011 at 11:42 PM, Michael<comtech....@gmail.com> >>>>> wrote: >>>>> >>>>>> Do you have an example...? Thanks a lot! >>>>>> >>>>> >>>>> See this video: >>>>> http://www.woopid.com/video/**1388/Format-as-Table<http://www.woopid.com/video/1388/Format-as-Table> >>>>> >>>>> -- >>>>> Statistics& Software Consulting >>>>> >>>>> GKX Group, GKX Associates Inc. >>>>> tel: 1-877-GKX-GROUP >>>>> email: ggrothendieck at gmail.com >>>>> >>>>> ______________________________**________________ >>>>> R-help@r-project.org mailing list >>>>> https://stat.ethz.ch/mailman/**listinfo/r-help<https://stat.ethz.ch/mailman/listinfo/r-help> >>>>> PLEASE do read the posting guide >>>>> http://www.R-project.org/**posting-guide.html<http://www.R-project.org/posting-guide.html> >>>>> <http://www.**r-project.org/posting-guide.**html<http://www.r-project.org/posting-guide.html> >>>>> > >>>>> >>>>> and provide commented, minimal, self-contained, reproducible code. >>>>> >>>>> >>>> >>>> >>> >> [[alternative HTML version deleted]] >> >> >> ______________________________**________________ >> R-help@r-project.org mailing list >> https://stat.ethz.ch/mailman/**listinfo/r-help<https://stat.ethz.ch/mailman/listinfo/r-help> >> PLEASE do read the posting guide http://www.R-project.org/** >> posting-guide.html <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.
