### Re: [R] nice report generator?

Hi Michael I have seen that this post has taken omn quite a life of it's own. Just for the record I want to add another very neat package that I didn't see mentioned elsewhere: reporttools regrads Christiaan On 7 December 2011 20:14, Michael comtech@gmail.com wrote: Hi all, I am looking for recommendations/pointers about best report generator you think that are currently available? i.e. the package that can help turn console output into nice-looking neat report to send to bosses? thanks a lot! [[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. -- Christiaan Pauw Nova Institute www.nova.org.za __ 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.

### Re: [R] nice report generator?

On 12-02-13 2:27 PM, Duncan Murdoch wrote: On 06/02/2012 4:12 PM, Hadley Wickham wrote: 2. It's more flexible to construct the language object as a language object, rather than pasting something together and parsing it. For one thing, that allows non-syntactic variable names; I think it's also easier to read. So your code txt- paste(tabular(value*v*, LEFT , ~ ,RIGHT ,, data = m_xx, suppressLabels = 2,...), sep = ) eval(parse(text = txt )) could be rewritten as formula- substitute( value*v*LEFT ~ RIGHT, list(LEFT=LEFT, RIGHT=RIGHT)) tabular(formula, data = m_xx, suppressLabels = 2, ...) To be strictly correct, shouldn't that be: formula- eval(substitute( value*v*LEFT ~ RIGHT, list(LEFT=LEFT, RIGHT=RIGHT))) ? It might make sense to put something like this into the tables package, but I don't want to have a dependency on reshape. Would you consider making tabular generic? I have now made tabular() into a generic function, but because of the problems at R-forge, can't commit the changes immediately. The old tabular() function is now the tabular.formula() method; the default method tries to coerce the object to a formula to call that. I think both my suggestion and yours would likely have problems in the new system (as they did in the old one) because the environment associated with the formula would be wrong. It's a little tricky, but now tabular() works a lot more like model.frame(), which I think has to be considered to be the standard way to do this. The new version 0.5.30 with the generic tabular function is now on R-forge. I'll likely push it to CRAN in a couple of days. Duncan Murdoch __ 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.

### Re: [R] nice report generator?

On 06/02/2012 4:12 PM, Hadley Wickham wrote: 2. It's more flexible to construct the language object as a language object, rather than pasting something together and parsing it. For one thing, that allows non-syntactic variable names; I think it's also easier to read. So your code txt- paste(tabular(value*v*, LEFT , ~ ,RIGHT ,, data = m_xx, suppressLabels = 2,...), sep = ) eval(parse(text = txt )) could be rewritten as formula- substitute( value*v*LEFT ~ RIGHT, list(LEFT=LEFT, RIGHT=RIGHT)) tabular(formula, data = m_xx, suppressLabels = 2, ...) To be strictly correct, shouldn't that be: formula- eval(substitute( value*v*LEFT ~ RIGHT, list(LEFT=LEFT, RIGHT=RIGHT))) ? It might make sense to put something like this into the tables package, but I don't want to have a dependency on reshape. Would you consider making tabular generic? I have now made tabular() into a generic function, but because of the problems at R-forge, can't commit the changes immediately. The old tabular() function is now the tabular.formula() method; the default method tries to coerce the object to a formula to call that. I think both my suggestion and yours would likely have problems in the new system (as they did in the old one) because the environment associated with the formula would be wrong. It's a little tricky, but now tabular() works a lot more like model.frame(), which I think has to be considered to be the standard way to do this. Duncan Murdoch __ 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.

### Re: [R] nice report generator?

Hi guys, AFAICT, this conversation now discusses some domain-specific issues. However, in reply to OP and OQ, I'll shamelessly advertise the package that Gergely Daróczi and I have released recently. It's named rapport, and you can grab it from CRAN or GitHub (https://github.com/aL3xa/rapport/). Check it out, as its purpose is to deliver reports in bosses-friendly format. It relies on pandoc, so you can easily convert it to external formats like ODT, DOCX, PDF, LaTeX, etc. Check out the project homepage for more details: http://rapport-package.info/ Cheers, aL3xa On Tue, Feb 7, 2012 at 16:45, Martin Studer martin.remo.stu...@gmail.comwrote: Hi Michael, Hi all, an alternative for reading/writing tables from/to Excel is the package XLConnect. It is platform-independent and therefore runs under Windows, UNIX/Linux Mac. It supports reading/writing worksheets as well as named ranges. In addition, for reporting purposes, there is support for cell styles. You can find an example here: http://miraisolutions.wordpress.com/2011/08/31/xlconnect-a-platform-independent-interface-to-excel/ XLConnect A platform-independent interface to Excel . With respect to cell styles: you either completely code up the styling according to your needs using /setCellStyle/ (which can be cumbersome if you need to apply a lot of styling) or you can use so-called style actions controlled via /setStyleAction/. See the XLConnect reference manual for more information. Best regards, Martin -- View this message in context: http://r.789695.n4.nabble.com/nice-report-generator-tp4169939p4365144.html Sent from the R help mailing list archive at Nabble.com. __ 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. [[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.

### Re: [R] nice report generator?

To be strictly correct, shouldn't that be: formula- eval(substitute( value*v*LEFT ~ RIGHT, list(LEFT=LEFT, RIGHT=RIGHT))) ? I think it probably doesn't matter. The difference is that mine gives a pure language object, whereas yours gives a formula object. The formula object has a class which means some methods will work differently, and it also has an environment attached, which defines where the variables in it should be resolved. I suspect the variables shouldn't be resolved in the environment where formula was being created, so it's probably better not to attach an environment at all, but the tabular function ignores the environment of the formula (it uses its data argument for that), so it doesn't make a big difference. Yes, sorry, I was probably being excessively picky :/ Formula semantics are tricky though! Hadley -- Assistant Professor / Dobelman Family Junior Chair Department of Statistics / Rice University 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.

### Re: [R] nice report generator?

Hi Michael, Hi all, an alternative for reading/writing tables from/to Excel is the package XLConnect. It is platform-independent and therefore runs under Windows, UNIX/Linux Mac. It supports reading/writing worksheets as well as named ranges. In addition, for reporting purposes, there is support for cell styles. You can find an example here: http://miraisolutions.wordpress.com/2011/08/31/xlconnect-a-platform-independent-interface-to-excel/ XLConnect – A platform-independent interface to Excel . With respect to cell styles: you either completely code up the styling according to your needs using /setCellStyle/ (which can be cumbersome if you need to apply a lot of styling) or you can use so-called style actions controlled via /setStyleAction/. See the XLConnect reference manual for more information. Best regards, Martin -- View this message in context: http://r.789695.n4.nabble.com/nice-report-generator-tp4169939p4365144.html Sent from the R help mailing list archive at Nabble.com. __ 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.

### Re: [R] nice report generator?

2. It's more flexible to construct the language object as a language object, rather than pasting something together and parsing it. For one thing, that allows non-syntactic variable names; I think it's also easier to read. So your code txt- paste(tabular(value*v*, LEFT , ~ ,RIGHT ,, data = m_xx, suppressLabels = 2,...), sep = ) eval(parse(text = txt )) could be rewritten as formula- substitute( value*v*LEFT ~ RIGHT, list(LEFT=LEFT, RIGHT=RIGHT)) tabular(formula, data = m_xx, suppressLabels = 2, ...) To be strictly correct, shouldn't that be: formula- eval(substitute( value*v*LEFT ~ RIGHT, list(LEFT=LEFT, RIGHT=RIGHT))) ? It might make sense to put something like this into the tables package, but I don't want to have a dependency on reshape. Would you consider making tabular generic? Hadley -- Assistant Professor / Dobelman Family Junior Chair Department of Statistics / Rice University 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.

### Re: [R] nice report generator?

On 12-02-06 4:12 PM, Hadley Wickham wrote: 2. It's more flexible to construct the language object as a language object, rather than pasting something together and parsing it. For one thing, that allows non-syntactic variable names; I think it's also easier to read. So your code txt- paste(tabular(value*v*, LEFT , ~ ,RIGHT ,, data = m_xx, suppressLabels = 2,...), sep = ) eval(parse(text = txt )) could be rewritten as formula- substitute( value*v*LEFT ~ RIGHT, list(LEFT=LEFT, RIGHT=RIGHT)) tabular(formula, data = m_xx, suppressLabels = 2, ...) To be strictly correct, shouldn't that be: formula- eval(substitute( value*v*LEFT ~ RIGHT, list(LEFT=LEFT, RIGHT=RIGHT))) ? I think it probably doesn't matter. The difference is that mine gives a pure language object, whereas yours gives a formula object. The formula object has a class which means some methods will work differently, and it also has an environment attached, which defines where the variables in it should be resolved. I suspect the variables shouldn't be resolved in the environment where formula was being created, so it's probably better not to attach an environment at all, but the tabular function ignores the environment of the formula (it uses its data argument for that), so it doesn't make a big difference. It might make sense to put something like this into the tables package, but I don't want to have a dependency on reshape. Would you consider making tabular generic? Yes, that wouldn't cost much. Duncan Murdoch __ 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.

### Re: [R] nice report generator?

Helloe dear Duncan, Gabor, Michael and others, After taking some time, I wrote a bridge function between a cast_df object from the {reshape} package into a table in Duncan's new {tables} package. The motivation was to make cast_df table prettier in the R terminal, as well as allow us to export a pretty version of the table to latex (using Hmisc::latex, on the output of tabular.cast_df) The code is now available on: http://www.r-statistics.com/2012/01/printing-nested-tables-in-r-bridging-between-the-reshape-and-tables-packages/ I would be happy for any input/revisions/suggestions from you. With regards, Tal 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 8:37 PM, Tal Galili tal.gal...@gmail.com wrote: reasonably [[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.

### Re: [R] nice report generator?

On 30/01/2012 6:59 AM, Tal Galili wrote: Helloe dear Duncan, Gabor, Michael and others, After taking some time, I wrote a bridge function between a cast_df object from the {reshape} package into a table in Duncan's new {tables} package. The motivation was to make cast_df table prettier in the R terminal, as well as allow us to export a pretty version of the table to latex (using Hmisc::latex, on the output of tabular.cast_df) The code is now available on: http://www.r-statistics.com/2012/01/printing-nested-tables-in-r-bridging-between-the-reshape-and-tables-packages/ I would be happy for any input/revisions/suggestions from you. Seems like a nice idea. Two comments: 1. I did add a Factor() function as described in the message you quote from me, so you might be able to use that and simplify things a little. 2. It's more flexible to construct the language object as a language object, rather than pasting something together and parsing it. For one thing, that allows non-syntactic variable names; I think it's also easier to read. So your code txt- paste(tabular(value*v*, LEFT , ~ ,RIGHT ,, data = m_xx, suppressLabels = 2,...), sep = ) eval(parse(text = txt )) could be rewritten as formula- substitute( value*v*LEFT ~ RIGHT, list(LEFT=LEFT, RIGHT=RIGHT)) tabular(formula, data = m_xx, suppressLabels = 2, ...) It might make sense to put something like this into the tables package, but I don't want to have a dependency on reshape. Duncan Murdoch __ 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.

### Re: [R] nice report generator?

Duncan, If you are taking suggestions for expanding the tables package (looks great) then I would suggest some way to get the tables into MS products. If I create a full output/report myself then I am happy to work in LaTeX, but much of what I do is to produce tables and graphs to clients that don't know LaTeX and just want something that they can copy and paste into powerpoint or word. For this I have been using the R2wd package (and the wdTable function for the tables). I would love to have some toolset that I could use your tables package to create the main table, then transfer it fairly simply to word or excel. I don't care much about the fluff of how the table looks (coloring rows or columns, line widths, etc.) just getting it into a table (not just the text version). One possibility is just an as.matrix method that would produce something that I could feed to wdTable. Or just a textual representation of the table with columns separated by tabs so that it could be copied to the clipboard then pasted into excel or word (I would then let the client deal with all the tweaks on the appearance). Thanks, -Original Message- From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of Duncan Murdoch Sent: Thursday, December 08, 2011 4:52 PM To: Tal Galili Cc: r-help Subject: Re: [R] nice report generator? 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, Michaelcomtech@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 Galilital.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, Michaelcomtech@gmail.com wrote: Do you have an example...? Thanks a lot! See this video: 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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.htmlhttp://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 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. __ 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.

### Re: [R] nice report generator?

Greg, Please look at the SWord package. This package integrates MS Word with R in a manner similar to the SWeave integration of LaTeX with R. Download SWord from rcom.univie.ac.at If you have a recent download of RExcel from the RAndFriends installer, then you will already have SWord on your machine. Rich On Wed, Dec 14, 2011 at 12:39 PM, Greg Snow greg.s...@imail.org wrote: Duncan, If you are taking suggestions for expanding the tables package (looks great) then I would suggest some way to get the tables into MS products. If I create a full output/report myself then I am happy to work in LaTeX, but much of what I do is to produce tables and graphs to clients that don't know LaTeX and just want something that they can copy and paste into powerpoint or word. For this I have been using the R2wd package (and the wdTable function for the tables). I would love to have some toolset that I could use your tables package to create the main table, then transfer it fairly simply to word or excel. I don't care much about the fluff of how the table looks (coloring rows or columns, line widths, etc.) just getting it into a table (not just the text version). One possibility is just an as.matrix method that would produce something that I could feed to wdTable. Or just a textual representation of the table with columns separated by tabs so that it could be copied to the clipboard then pasted into excel or word (I would then let the client deal with all the tweaks on the appearance). Thanks, -Original Message- From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of Duncan Murdoch Sent: Thursday, December 08, 2011 4:52 PM To: Tal Galili Cc: r-help Subject: Re: [R] nice report generator? 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, Michaelcomtech@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 Galilital.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, Michaelcomtech@gmail.com wrote: Do you have an example...? Thanks a lot! See this video: 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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.htmlhttp://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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.htmlhttp://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

### Re: [R] nice report generator?

Richard, I have looked at SWord before, but to my knowledge it does not deal directly with the tabular objects created by the tables package (please correct me if I am wrong). These objects do have a matrix as the main data, but the attributes are different from the usual dimnames. There are functions in tables that will then take this structure and print it out in a nice way with the headers, or work with the latex function to create a nice table for LaTeX, but there are not (yet) tools for doing this in MS products. SWord and R2wd (and other tools) could transfer the data just fine, but then the column and row names/headers would still need to be put in by hand, which negates the whole convenience of using these tools. One option would be to have a function in tables that converted to a regular matrix with some form of meaningful dimnames that could then be used with R2wd or SWord or odfWeave or other tools (that was one of my suggestions). -- Gregory (Greg) L. Snow Ph.D. Statistical Data Center Intermountain Healthcare greg.s...@imail.org 801.408.8111 From: Richard M. Heiberger [mailto:r...@temple.edu] Sent: Wednesday, December 14, 2011 11:20 AM To: Greg Snow Cc: Duncan Murdoch; Tal Galili; r-help Subject: Re: [R] nice report generator? Greg, Please look at the SWord package. This package integrates MS Word with R in a manner similar to the SWeave integration of LaTeX with R. Download SWord from rcom.univie.ac.athttp://rcom.univie.ac.at If you have a recent download of RExcel from the RAndFriends installer, then you will already have SWord on your machine. Rich On Wed, Dec 14, 2011 at 12:39 PM, Greg Snow greg.s...@imail.orgmailto:greg.s...@imail.org wrote: Duncan, If you are taking suggestions for expanding the tables package (looks great) then I would suggest some way to get the tables into MS products. If I create a full output/report myself then I am happy to work in LaTeX, but much of what I do is to produce tables and graphs to clients that don't know LaTeX and just want something that they can copy and paste into powerpoint or word. For this I have been using the R2wd package (and the wdTable function for the tables). I would love to have some toolset that I could use your tables package to create the main table, then transfer it fairly simply to word or excel. I don't care much about the fluff of how the table looks (coloring rows or columns, line widths, etc.) just getting it into a table (not just the text version). One possibility is just an as.matrix method that would produce something that I could feed to wdTable. Or just a textual representation of the table with columns separated by tabs so that it could be copied to the clipboard then pasted into excel or word (I would then let the client deal with all the tweaks on the appearance). Thanks, -Original Message- From: r-help-boun...@r-project.orgmailto:r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.orgmailto:r-help-boun...@r-project.org] On Behalf Of Duncan Murdoch Sent: Thursday, December 08, 2011 4:52 PM To: Tal Galili Cc: r-help Subject: Re: [R] nice report generator? 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.commailto:tal.gal...@gmail.com | 972-52-7275845 Read me: www.talgalili.comhttp://www.talgalili.com/ (Hebrew) | www.biostatistics.co.ilhttp://www.biostatistics.co.il/ (Hebrew) | www.r-statistics.comhttp://www.r-statistics.com/ (English) -- On Thu, Dec 8, 2011 at 5:24 PM, Michaelcomtech@gmail.commailto: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 Galilital.gal

### Re: [R] nice report generator?

There is also the problem that SWord's license does not allow for commercial use. R2wd, write.table, and odfWeave don't have this restriction. -- Gregory (Greg) L. Snow Ph.D. Statistical Data Center Intermountain Healthcare greg.s...@imail.org 801.408.8111 From: Richard M. Heiberger [mailto:r...@temple.edu] Sent: Wednesday, December 14, 2011 11:20 AM To: Greg Snow Cc: Duncan Murdoch; Tal Galili; r-help Subject: Re: [R] nice report generator? Greg, Please look at the SWord package. This package integrates MS Word with R in a manner similar to the SWeave integration of LaTeX with R. Download SWord from rcom.univie.ac.athttp://rcom.univie.ac.at If you have a recent download of RExcel from the RAndFriends installer, then you will already have SWord on your machine. Rich On Wed, Dec 14, 2011 at 12:39 PM, Greg Snow greg.s...@imail.orgmailto:greg.s...@imail.org wrote: Duncan, If you are taking suggestions for expanding the tables package (looks great) then I would suggest some way to get the tables into MS products. If I create a full output/report myself then I am happy to work in LaTeX, but much of what I do is to produce tables and graphs to clients that don't know LaTeX and just want something that they can copy and paste into powerpoint or word. For this I have been using the R2wd package (and the wdTable function for the tables). I would love to have some toolset that I could use your tables package to create the main table, then transfer it fairly simply to word or excel. I don't care much about the fluff of how the table looks (coloring rows or columns, line widths, etc.) just getting it into a table (not just the text version). One possibility is just an as.matrix method that would produce something that I could feed to wdTable. Or just a textual representation of the table with columns separated by tabs so that it could be copied to the clipboard then pasted into excel or word (I would then let the client deal with all the tweaks on the appearance). Thanks, -Original Message- From: r-help-boun...@r-project.orgmailto:r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.orgmailto:r-help-boun...@r-project.org] On Behalf Of Duncan Murdoch Sent: Thursday, December 08, 2011 4:52 PM To: Tal Galili Cc: r-help Subject: Re: [R] nice report generator? 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.commailto:tal.gal...@gmail.com | 972-52-7275845 Read me: www.talgalili.comhttp://www.talgalili.com/ (Hebrew) | www.biostatistics.co.ilhttp://www.biostatistics.co.il/ (Hebrew) | www.r-statistics.comhttp://www.r-statistics.com/ (English) -- On Thu, Dec 8, 2011 at 5:24 PM, Michaelcomtech@gmail.commailto: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 Galilital.gal...@gmail.commailto: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.commailto:ggrothendi...@gmail.com wrote: On Wed, Dec 7, 2011 at 11:42 PM, Michaelcomtech@gmail.commailto:comtech@gmail.com wrote: Do you have an example...? Thanks a lot! See this video: 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.comhttp://gmail.com/ __ R-help@r-project.orgmailto:R-help@r-project.org mailing list https://stat.ethz.ch/mailman

### Re: [R] nice report generator?

On Wed, Dec 14, 2011 at 4:43 PM, Greg Snow greg.s...@imail.org wrote: There is also the problem that SWords license does not allow for commercial use. R2wd, write.table, and odfWeave dont have this restriction. The free license for SWord does have the commercial use restriction. There is also a commerical license available. You will need to write to Thomas Baier tho...@statconn.com for details. You will also need to discuss with Thomas what would be involved in making the tables package work smoothly with SWord. Rich ** ** -- Gregory (Greg) L. Snow Ph.D. Statistical Data Center Intermountain Healthcare greg.s...@imail.org 801.408.8111 ** ** *From:* Richard M. Heiberger [mailto:r...@temple.edu] *Sent:* Wednesday, December 14, 2011 11:20 AM *To:* Greg Snow *Cc:* Duncan Murdoch; Tal Galili; r-help *Subject:* Re: [R] nice report generator? ** ** Greg, Please look at the SWord package. This package integrates MS Word with R* *** in a manner similar to the SWeave integration of LaTeX with R. Download SWord from rcom.univie.ac.at If you have a recent download of RExcel from the RAndFriends installer, then you will already have SWord on your machine. Rich On Wed, Dec 14, 2011 at 12:39 PM, Greg Snow greg.s...@imail.org wrote:** ** Duncan, If you are taking suggestions for expanding the tables package (looks great) then I would suggest some way to get the tables into MS products. If I create a full output/report myself then I am happy to work in LaTeX, but much of what I do is to produce tables and graphs to clients that don't know LaTeX and just want something that they can copy and paste into powerpoint or word. For this I have been using the R2wd package (and the wdTable function for the tables). I would love to have some toolset that I could use your tables package to create the main table, then transfer it fairly simply to word or excel. I don't care much about the fluff of how the table looks (coloring rows or columns, line widths, etc.) just getting it into a table (not just the text version). One possibility is just an as.matrix method that would produce something that I could feed to wdTable. Or just a textual representation of the table with columns separated by tabs so that it could be copied to the clipboard then pasted into excel or word (I would then let the client deal with all the tweaks on the appearance). Thanks, -Original Message- From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of Duncan Murdoch Sent: Thursday, December 08, 2011 4:52 PM To: Tal Galili Cc: r-help Subject: Re: [R] nice report generator? 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, Michaelcomtech@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 Galilital.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, Michaelcomtech@gmail.com wrote: Do you have an example...? Thanks a lot! See this video: http://www.woopid.com/video/1388/Format-as-Table

### Re: [R] nice report generator?

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 ozone41 # 2 5 2 cold ozone36 # 3 5 3 cold ozone12 # 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.comwrote: 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, Michaelcomtech@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 Galilital.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, Michaelcomtech@gmail.com wrote: Do you have an example...? Thanks a lot! See this video: http://www.woopid.com/video/**1388/Format-as-Tablehttp://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-helphttps://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/**posting-guide.htmlhttp://www.R-project.org/posting-guide.html http://www.**r-project.org/posting-guide.**htmlhttp://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-helphttps://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/**

### Re: [R] nice report generator?

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.comwrote: 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 -- 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 PLEASE do read the posting guide 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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.

### Re: [R] nice report generator?

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 -- 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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.htmlhttp://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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.

### Re: [R] nice report generator?

Michael, Pivot tables in Excel can be sent directly to R with RExcel. rcom.univie.ac.at See our paper at UseR! 2011 for an example and application. The Pivot Table transfer is illustrated on page 4. Heiberger, R., Neuwirth, E., UserR! 2011, Graphical Syntax for Structables and their Mosaic Plots, University of Warwick and R Foundation for Statistical Computing, Coventry, England. (August 2011). http://www.warwick.ac.uk/statsdept/user-2011/TalkSlides/Contributed/16Aug_1600_FocusII_3-Visual_2-Heiberger.pdf Rich On Thu, Dec 8, 2011 at 10:24 AM, 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 -- 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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.htmlhttp://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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.htmlhttp://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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.

### Re: [R] nice report generator?

On 07/12/2011 11:58 PM, Gabor Grothendieck wrote: On Wed, Dec 7, 2011 at 11:42 PM, Michaelcomtech@gmail.com wrote: Do you have an example...? Thanks a lot! See this video: http://www.woopid.com/video/1388/Format-as-Table That shows how to manipulate tables in Excel, but it doesn't really end up with something that I would consider good enough for printing. Excel is pretty nice at some database operations (selecting subsets by checkboxes, etc.) and with some work it can do whatever you want, but I don't think it is easy to produce a table that I would use in a paper or presentation. (Nor is it really easy in R, but I think it is easier, given that I know R and LaTeX. No question that it takes time to learn those.) Duncan Murdoch __ 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.

### Re: [R] nice report generator?

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? 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. 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 -- 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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.htmlhttp://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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.

### Re: [R] nice report generator?

Hi Michael, If you are talking about organizing the data - then google and read more about the reshape package. If you want THE pivot table done in excel from R - you'll need to follow the RExcel path. (I personally prefer reshape) 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 11:02 PM, Michael comtech@gmail.com wrote: How to directly generate Pivot tables in R, or generate Pivot tables in Excel from R ? Thx On Thu, Dec 8, 2011 at 12:37 PM, Tal Galili tal.gal...@gmail.com 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? 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. 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.comwrote: 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 -- 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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.htmlhttp://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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.

### Re: [R] nice report generator?

How to directly generate Pivot tables in R, or generate Pivot tables in Excel from R ? Thx On Thu, Dec 8, 2011 at 12:37 PM, Tal Galili tal.gal...@gmail.com 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? 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. 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 -- 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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.htmlhttp://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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.

### Re: [R] nice report generator?

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, Michaelcomtech@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 Galilital.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, Michaelcomtech@gmail.com wrote: Do you have an example...? Thanks a lot! See this video: 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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.htmlhttp://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 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.

### Re: [R] nice report generator?

Hi, On Wed, Dec 7, 2011 at 1:14 PM, Michael comtech@gmail.com wrote: Hi all, I am looking for recommendations/pointers about best report generator you think that are currently available? i.e. the package that can help turn console output into nice-looking neat report to send to bosses? Perhaps you should turn your analysis into a Sweave document? There are many refs you can follow up on Sweave online -- here's one: http://www.stat.uni-muenchen.de/~leisch/Sweave/ HTH, -steve -- Steve Lianoglou Graduate Student: Computational Systems Biology | Memorial Sloan-Kettering Cancer Center | Weill Medical College of Cornell University Contact Info: http://cbio.mskcc.org/~lianos/contact __ 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.

### Re: [R] nice report generator?

Sweave. Or ODFWeave, if Sweave/LaTeX are too much overhead. But really, it depends on what kind of report output you need to deliver. Printed? HTML? PDF? Sarah On Wed, Dec 7, 2011 at 1:14 PM, Michael comtech@gmail.com wrote: Hi all, I am looking for recommendations/pointers about best report generator you think that are currently available? i.e. the package that can help turn console output into nice-looking neat report to send to bosses? thanks a lot! . -- Sarah Goslee http://www.functionaldiversity.org __ 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.

### Re: [R] nice report generator?

I like knitr. IMHO Yihui really came up with a killer package there: http://yihui.github.com/knitr/ On 07.12.2011 19:19, Sarah Goslee wrote: Sweave. Or ODFWeave, if Sweave/LaTeX are too much overhead. But really, it depends on what kind of report output you need to deliver. Printed? HTML? PDF? Sarah On Wed, Dec 7, 2011 at 1:14 PM, Michaelcomtech@gmail.com wrote: Hi all, I am looking for recommendations/pointers about best report generator you think that are currently available? i.e. the package that can help turn console output into nice-looking neat report to send to bosses? thanks a lot! . __ 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.

### Re: [R] nice report generator?

Thanks a lot! Typically the console output will be something like this: Analysis of Variance Table Response: as.double(my.delta) Df Sum Sq Mean Sq F value Pr(F) my.factor1 0 0.005 2e-04 0.988 Residuals 1484 32630 21.988 I am looking for a report-generator to make this look nicer and tabularize it... It doesn't matter if the outputs are in HTML, PDF, etc. As long as it looks fantastic, that's what we are looking for ... and also the convenience is important... we dont' want to create Latex document with manual insertaion of tables and plots... These need automation... thx a lot! On 12/7/11, Janko Thyson janko.thyson.rst...@googlemail.com wrote: I like knitr. IMHO Yihui really came up with a killer package there: http://yihui.github.com/knitr/ On 07.12.2011 19:19, Sarah Goslee wrote: Sweave. Or ODFWeave, if Sweave/LaTeX are too much overhead. But really, it depends on what kind of report output you need to deliver. Printed? HTML? PDF? Sarah On Wed, Dec 7, 2011 at 1:14 PM, Michaelcomtech@gmail.com wrote: Hi all, I am looking for recommendations/pointers about best report generator you think that are currently available? i.e. the package that can help turn console output into nice-looking neat report to send to bosses? thanks a lot! . __ 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.

### Re: [R] nice report generator?

On Wed, Dec 7, 2011 at 1:50 PM, Michael comtech@gmail.com wrote: Thanks a lot! Typically the console output will be something like this: Analysis of Variance Table Response: as.double(my.delta) Df Sum Sq Mean Sq F value Pr(F) my.factor 1 0 0.005 2e-04 0.988 Residuals 1484 32630 21.988 I am looking for a report-generator to make this look nicer and tabularize it... It doesn't matter if the outputs are in HTML, PDF, etc. As long as it looks fantastic, that's what we are looking for ... and also the convenience is important... we dont' want to create Latex document with manual insertaion of tables and plots... These need automation... thx a lot! That's what sweave is *for* - automation and reproducible research. It takes care of the heavy lifting of generating and inserting tables and figures. You will almost certainly need some tweaking to match your own definition of looks fantastic though. Sarah On 07.12.2011 19:19, Sarah Goslee wrote: Sweave. Or ODFWeave, if Sweave/LaTeX are too much overhead. But really, it depends on what kind of report output you need to deliver. Printed? HTML? PDF? Sarah On Wed, Dec 7, 2011 at 1:14 PM, Michaelcomtech@gmail.com wrote: Hi all, I am looking for recommendations/pointers about best report generator you think that are currently available? i.e. the package that can help turn console output into nice-looking neat report to send to bosses? thanks a lot! . -- Sarah Goslee http://www.functionaldiversity.org __ 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.

### Re: [R] nice report generator?

On 07/12/2011 1:14 PM, Michael wrote: Hi all, I am looking for recommendations/pointers about best report generator you think that are currently available? i.e. the package that can help turn console output into nice-looking neat report to send to bosses? You might find the latex() command in Hmisc or the equivalent in the xtable package does what you want. For simple reports in a single table you don't need Sweave; for more complex ones it would make your life easier. My tables package (now on CRAN) might simplify the production of the table. It is set up to work with Hmisc currently. Duncan Murdoch __ 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.

### Re: [R] nice report generator?

With any sort of reproducible report, you'll have to 'manually place' all of the tables and figures at least once. If done well, however, you'll only have to ever do it once. I'm not an Sweave expert (yet, regrettably), but using lazyWeave, you could generate a customized ANOVA table using the code below. If you're familiar with Sweave, I'd recommend using it. library(lazyWeave) #*** Function to produce the latex code for an ANOVA table anova.table - function(aov.object, caption=, ...){ out - data.frame(Source = rownames(anova(aov.object)), SS = anova(aov.object)[, 2], D.F. = anova(aov.object)[, 1], stringsAsFactors=FALSE) out$MS - out$SS / out$D.F. out$F - NA out$F[-nrow(out)] - out$MS[-nrow(out)] / out$MS[nrow(out)] out$p - 1 - pf(out$F, out$D.F., out$D.F.[nrow(out)]) out - rbind(out, data.frame(Source = Total, SS=sum(out$SS), D.F.=sum(out$D.F.), MS=NA, F=NA, p=NA)) out$SS - round(out$SS, 3) out$MS - round(out$MS, 3) out$F - round(out$F, 3) rownames(out) - NULL out[is.na(out)] - paste(lazy.table(colnames(out), rborder=c(0, 0, 1), open=TRUE, close=FALSE, caption=caption), lazy.table(out, rborder=2, open=FALSE, close=TRUE), sep=\n) } #*** #*** Analysis of Variance m1 - aov(mpg ~ cyl, data=mtcars) #*** #*** Write the result to a file lazy.write( lazy.file.start(), anova.table(m1, caption=An example ANOVA table from the dataset \\tt mtcars\\rm.), lazy.file.end(), OutFile=TestFile.tex) lazy.build(TestFile.tex) Benjamin Nutter | Biostatistician | Quantitative Health Sciences Cleveland Clinic | 9500 Euclid Ave. | Cleveland, OH 44195 | (216) 445-1365 -Original Message- From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of Sarah Goslee Sent: Wednesday, December 07, 2011 2:34 PM Cc: r-help; Janko Thyson Subject: Re: [R] nice report generator? On Wed, Dec 7, 2011 at 1:50 PM, Michael comtech@gmail.com wrote: Thanks a lot! Typically the console output will be something like this: Analysis of Variance Table Response: as.double(my.delta) Df Sum Sq Mean Sq F value Pr(F) my.factor 1 0 0.005 2e-04 0.988 Residuals 1484 32630 21.988 I am looking for a report-generator to make this look nicer and tabularize it... It doesn't matter if the outputs are in HTML, PDF, etc. As long as it looks fantastic, that's what we are looking for ... and also the convenience is important... we dont' want to create Latex document with manual insertaion of tables and plots... These need automation... thx a lot! That's what sweave is *for* - automation and reproducible research. It takes care of the heavy lifting of generating and inserting tables and figures. You will almost certainly need some tweaking to match your own definition of looks fantastic though. Sarah On 07.12.2011 19:19, Sarah Goslee wrote: Sweave. Or ODFWeave, if Sweave/LaTeX are too much overhead. But really, it depends on what kind of report output you need to deliver. Printed? HTML? PDF? Sarah On Wed, Dec 7, 2011 at 1:14 PM, Michaelcomtech@gmail.com wrote: Hi all, I am looking for recommendations/pointers about best report generator you think that are currently available? i.e. the package that can help turn console output into nice-looking neat report to send to bosses? thanks a lot! . -- Sarah Goslee http://www.functionaldiversity.org __ 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. === Please consider the environment before printing this e-mail Cleveland Clinic is ranked one of the top hospitals in America by U.S.News World Report (2010). Visit us online at http://www.clevelandclinic.org for a complete listing of our services, staff and locations. Confidentiality Note: This message is intended for use\...{{dropped:13}} __ 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.

### Re: [R] nice report generator?

Thanks a lot Duncan! I did some home-work and found out that in terms of table looks, it's neater to generate Excel 2010 style colorful tables, not the Latex style plain/math-geek tables... Therefore, a report generator would hopefully generate Excel 2010 style tables, plus R plots, etc. Any thoughts? Thanks a lot! On 12/7/11, Duncan Murdoch murdoch.dun...@gmail.com wrote: On 07/12/2011 1:14 PM, Michael wrote: Hi all, I am looking for recommendations/pointers about best report generator you think that are currently available? i.e. the package that can help turn console output into nice-looking neat report to send to bosses? You might find the latex() command in Hmisc or the equivalent in the xtable package does what you want. For simple reports in a single table you don't need Sweave; for more complex ones it would make your life easier. My tables package (now on CRAN) might simplify the production of the table. It is set up to work with Hmisc currently. Duncan Murdoch __ 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.

### Re: [R] nice report generator?

Sarah Goslee might want to chime in, but using odfWeave and appropriate LibreOffice templates, you can generate beautifully formatted tables, possibly in the style you wish, in LibreOffice, as well as add R figures. The R2wd package (which has a proprietary component) will also generate tables directly in Word (on windows machines) and their default theme is pretty attractive to me. I'm pretty sure even that is customizable. You can also put R plots directly into Word that way as well. Abhijit On 12/7/2011 3:21 PM, Michael wrote: Thanks a lot Duncan! I did some home-work and found out that in terms of table looks, it's neater to generate Excel 2010 style colorful tables, not the Latex style plain/math-geek tables... Therefore, a report generator would hopefully generate Excel 2010 style tables, plus R plots, etc. Any thoughts? Thanks a lot! On 12/7/11, Duncan Murdochmurdoch.dun...@gmail.com wrote: On 07/12/2011 1:14 PM, Michael wrote: Hi all, I am looking for recommendations/pointers about best report generator you think that are currently available? i.e. the package that can help turn console output into nice-looking neat report to send to bosses? You might find the latex() command in Hmisc or the equivalent in the xtable package does what you want. For simple reports in a single table you don't need Sweave; for more complex ones it would make your life easier. My tables package (now on CRAN) might simplify the production of the table. It is set up to work with Hmisc currently. Duncan Murdoch __ 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. [[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.

### Re: [R] nice report generator?

On Wed, Dec 7, 2011 at 7:43 PM, Janko Thyson janko.thyson.rst...@googlemail.com wrote: I like knitr. IMHO Yihui really came up with a killer package there: http://yihui.github.com/knitr/ If we're talking about nice, I'll chip in for LyX. It has support for Sweave, and will soon support knitr. This eliminates (most of) the burden of learning LaTeX. Liviu __ 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.

### Re: [R] nice report generator?

Thanks Liviu. I actually knew Latex... so it's not a problem for me. But honestly Latex tables cannot compete with Excel 2010 tables in looks... the latter are for business users and for managers... I am looking for a fast/convenient way to generate those tables... Thanks! On 12/7/11, Liviu Andronic landronim...@gmail.com wrote: On Wed, Dec 7, 2011 at 7:43 PM, Janko Thyson janko.thyson.rst...@googlemail.com wrote: I like knitr. IMHO Yihui really came up with a killer package there: http://yihui.github.com/knitr/ If we're talking about nice, I'll chip in for LyX. It has support for Sweave, and will soon support knitr. This eliminates (most of) the burden of learning LaTeX. Liviu __ 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.

### Re: [R] nice report generator?

Michael, that is a challenge. I accept it and suggest that it be a contest on the R-help list. Please post a pdf file showing some (more than one) tables that you think look better in Excel than in LaTeX. I,and probably some others, will send our versions of the tables. I think a new email thread with an appropriate catchy title would be the way to do it. Rich On Wed, Dec 7, 2011 at 5:17 PM, Michael comtech@gmail.com wrote: Thanks Liviu. I actually knew Latex... so it's not a problem for me. But honestly Latex tables cannot compete with Excel 2010 tables in looks... the latter are for business users and for managers... I am looking for a fast/convenient way to generate those tables... Thanks! On 12/7/11, Liviu Andronic landronim...@gmail.com wrote: On Wed, Dec 7, 2011 at 7:43 PM, Janko Thyson janko.thyson.rst...@googlemail.com wrote: I like knitr. IMHO Yihui really came up with a killer package there: http://yihui.github.com/knitr/ If we're talking about nice, I'll chip in for LyX. It has support for Sweave, and will soon support knitr. This eliminates (most of) the burden of learning LaTeX. Liviu __ 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.htmlhttp://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.htmlhttp://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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.

### Re: [R] nice report generator?

Could you show us a few screenshots of what you believe are good-looking Excel 2010 tables? (e.g. via imgur.com) Sorry I do not have Excel 2010. I feel this post is more like a matter of style, so it is likely to be a personal matter of taste. Anyway, I'd like to see what is a beautiful table in your eyes. Regards, Yihui -- Yihui Xie xieyi...@gmail.com Phone: 515-294-2465 Web: http://yihui.name Department of Statistics, Iowa State University 2215 Snedecor Hall, Ames, IA On Wed, Dec 7, 2011 at 4:17 PM, Michael comtech@gmail.com wrote: Thanks Liviu. I actually knew Latex... so it's not a problem for me. But honestly Latex tables cannot compete with Excel 2010 tables in looks... the latter are for business users and for managers... I am looking for a fast/convenient way to generate those tables... Thanks! On 12/7/11, Liviu Andronic landronim...@gmail.com wrote: On Wed, Dec 7, 2011 at 7:43 PM, Janko Thyson janko.thyson.rst...@googlemail.com wrote: I like knitr. IMHO Yihui really came up with a killer package there: http://yihui.github.com/knitr/ If we're talking about nice, I'll chip in for LyX. It has support for Sweave, and will soon support knitr. This eliminates (most of) the burden of learning LaTeX. Liviu __ 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.

### Re: [R] nice report generator?

On Wed, Dec 7, 2011 at 5:26 PM, Richard M. Heiberger r...@temple.edu wrote: Michael, that is a challenge. I accept it and suggest that it be a contest on the R-help list. Please post a pdf file showing some (more than one) tables that you think look better in Excel than in LaTeX. I,and probably some others, will send our versions of the tables. I think a new email thread with an appropriate catchy title would be the way to do it. The problem is that its drop dead easy in Excel but its not readily accessible in R and latex (as opposed to the problem being raw capability). Simply exhibiting how to do it is not enough. What is needed is a function, accessible from CRAN, with a bunch of built in themes that are easy to apply: latex(DF, theme = cherry orchard) -- 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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.

### Re: [R] nice report generator?

On 11-12-07 5:43 PM, Gabor Grothendieck wrote: On Wed, Dec 7, 2011 at 5:26 PM, Richard M. Heibergerr...@temple.edu wrote: Michael, that is a challenge. I accept it and suggest that it be a contest on the R-help list. Please post a pdf file showing some (more than one) tables that you think look better in Excel than in LaTeX. I,and probably some others, will send our versions of the tables. I think a new email thread with an appropriate catchy title would be the way to do it. The problem is that its drop dead easy in Excel but its not readily accessible in R and latex (as opposed to the problem being raw capability). Simply exhibiting how to do it is not enough. What is needed is a function, accessible from CRAN, with a bunch of built in themes that are easy to apply: latex(DF, theme = cherry orchard) I don't believe you. Show us some examples. Duncan Murdoch __ 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.

### Re: [R] nice report generator?

On Wed, Dec 7, 2011 at 5:58 PM, Duncan Murdoch murdoch.dun...@gmail.com wrote: On 11-12-07 5:43 PM, Gabor Grothendieck wrote: On Wed, Dec 7, 2011 at 5:26 PM, Richard M. Heibergerr...@temple.edu wrote: Michael, that is a challenge. I accept it and suggest that it be a contest on the R-help list. Please post a pdf file showing some (more than one) tables that you think look better in Excel than in LaTeX. I,and probably some others, will send our versions of the tables. I think a new email thread with an appropriate catchy title would be the way to do it. The problem is that its drop dead easy in Excel but its not readily accessible in R and latex (as opposed to the problem being raw capability). Simply exhibiting how to do it is not enough. What is needed is a function, accessible from CRAN, with a bunch of built in themes that are easy to apply: latex(DF, theme = cherry orchard) I don't believe you. Show us some examples. As I mentioned, its not just a matter of replicating the output. Its a matter of how easy it is to generate it. With Excel 2007 enter a table into the cells, select it and on the Home tab in the Styles group of the ribbon click on Format a Table. Select any of the templates that are presented and that's it. I have produced quite fancy tables with R and latex beyond what the above instructions could do in Excel but I did not regard that effort as easy although it did produce very nice looking tables. There is a new tables package that just appeared on CRAN in the last few days. I haven't seriously used it yet but perhaps it has some of these capabilities (or if not will evolve into providing not only the tabular content but also the presentation aspects that are important to some users) or perhaps some other CRAN package has already gone in this direction. -- 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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.

### Re: [R] nice report generator?

... or perhaps some other CRAN package has already gone in this direction. The tableGrob function in the gridExtra package probably is one of them. Original-Nachricht Datum: Wed, 7 Dec 2011 19:29:54 -0500 Von: Gabor Grothendieck ggrothendi...@gmail.com An: Duncan Murdoch murdoch.dun...@gmail.com CC: r-help r-h...@stat.math.ethz.ch, Janko Thyson janko.thyson.rst...@googlemail.com Betreff: Re: [R] nice report generator? On Wed, Dec 7, 2011 at 5:58 PM, Duncan Murdoch murdoch.dun...@gmail.com wrote: On 11-12-07 5:43 PM, Gabor Grothendieck wrote: On Wed, Dec 7, 2011 at 5:26 PM, Richard M. Heibergerr...@temple.edu wrote: Michael, that is a challenge. I accept it and suggest that it be a contest on the R-help list. Please post a pdf file showing some (more than one) tables that you think look better in Excel than in LaTeX. I,and probably some others, will send our versions of the tables. I think a new email thread with an appropriate catchy title would be the way to do it. The problem is that its drop dead easy in Excel but its not readily accessible in R and latex (as opposed to the problem being raw capability). Simply exhibiting how to do it is not enough. What is needed is a function, accessible from CRAN, with a bunch of built in themes that are easy to apply: latex(DF, theme = cherry orchard) I don't believe you. Show us some examples. As I mentioned, its not just a matter of replicating the output. Its a matter of how easy it is to generate it. With Excel 2007 enter a table into the cells, select it and on the Home tab in the Styles group of the ribbon click on Format a Table. Select any of the templates that are presented and that's it. I have produced quite fancy tables with R and latex beyond what the above instructions could do in Excel but I did not regard that effort as easy although it did produce very nice looking tables. There is a new tables package that just appeared on CRAN in the last few days. I haven't seriously used it yet but perhaps it has some of these capabilities (or if not will evolve into providing not only the tabular content but also the presentation aspects that are important to some users) or perhaps some other CRAN package has already gone in this direction. -- 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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. -- --- Gentoo Linux with KDE __ 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.

### Re: [R] nice report generator?

Do you have an example...? Thanks a lot! On Wed, Dec 7, 2011 at 9:55 PM, Rainer Schuermann rainer.schuerm...@gmx.net wrote: ... or perhaps some other CRAN package has already gone in this direction. The tableGrob function in the gridExtra package probably is one of them. Original-Nachricht Datum: Wed, 7 Dec 2011 19:29:54 -0500 Von: Gabor Grothendieck ggrothendi...@gmail.com An: Duncan Murdoch murdoch.dun...@gmail.com CC: r-help r-h...@stat.math.ethz.ch, Janko Thyson janko.thyson.rst...@googlemail.com Betreff: Re: [R] nice report generator? On Wed, Dec 7, 2011 at 5:58 PM, Duncan Murdoch murdoch.dun...@gmail.com wrote: On 11-12-07 5:43 PM, Gabor Grothendieck wrote: On Wed, Dec 7, 2011 at 5:26 PM, Richard M. Heibergerr...@temple.edu wrote: Michael, that is a challenge. I accept it and suggest that it be a contest on the R-help list. Please post a pdf file showing some (more than one) tables that you think look better in Excel than in LaTeX. I,and probably some others, will send our versions of the tables. I think a new email thread with an appropriate catchy title would be the way to do it. The problem is that its drop dead easy in Excel but its not readily accessible in R and latex (as opposed to the problem being raw capability). Simply exhibiting how to do it is not enough. What is needed is a function, accessible from CRAN, with a bunch of built in themes that are easy to apply: latex(DF, theme = cherry orchard) I don't believe you. Show us some examples. As I mentioned, its not just a matter of replicating the output. Its a matter of how easy it is to generate it. With Excel 2007 enter a table into the cells, select it and on the Home tab in the Styles group of the ribbon click on Format a Table. Select any of the templates that are presented and that's it. I have produced quite fancy tables with R and latex beyond what the above instructions could do in Excel but I did not regard that effort as easy although it did produce very nice looking tables. There is a new tables package that just appeared on CRAN in the last few days. I haven't seriously used it yet but perhaps it has some of these capabilities (or if not will evolve into providing not only the tabular content but also the presentation aspects that are important to some users) or perhaps some other CRAN package has already gone in this direction. -- 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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. -- --- Gentoo Linux with KDE __ 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. [[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.

### Re: [R] nice report generator?

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 -- 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 PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.

### Re: [R] nice report generator?

And for tableGrob, you can see some very basic functionality by typing library(gridExtra) example(tableGrob) Michael On Wed, Dec 7, 2011 at 11:58 PM, 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 -- 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 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.