Re: [R] nice report generator?

2012-03-12 Thread christiaan pauw
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

Re: [R] nice report generator?

2012-02-14 Thread Duncan Murdoch
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

Re: [R] nice report generator?

2012-02-13 Thread Duncan Murdoch
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

Re: [R] nice report generator?

2012-02-10 Thread Aleksandar Blagotić
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/).

Re: [R] nice report generator?

2012-02-10 Thread Hadley Wickham
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

Re: [R] nice report generator?

2012-02-07 Thread Martin Studer
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

Re: [R] nice report generator?

2012-02-06 Thread Hadley Wickham
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 =

Re: [R] nice report generator?

2012-02-06 Thread Duncan Murdoch
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-

Re: [R] nice report generator?

2012-01-30 Thread Tal Galili
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

Re: [R] nice report generator?

2012-01-30 Thread Duncan Murdoch
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

Re: [R] nice report generator?

2011-12-14 Thread Greg Snow
-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

Re: [R] nice report generator?

2011-12-14 Thread Richard M. Heiberger
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

Re: [R] nice report generator?

2011-12-14 Thread Greg Snow
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

Re: [R] nice report generator?

2011-12-14 Thread Greg Snow
...@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

Re: [R] nice report generator?

2011-12-14 Thread Richard M. Heiberger
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

Re: [R] nice report generator?

2011-12-10 Thread Tal Galili
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

Re: [R] nice report generator?

2011-12-08 Thread Tal Galili
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

Re: [R] nice report generator?

2011-12-08 Thread Michael
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

Re: [R] nice report generator?

2011-12-08 Thread Richard M. Heiberger
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

Re: [R] nice report generator?

2011-12-08 Thread Duncan Murdoch
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

Re: [R] nice report generator?

2011-12-08 Thread Tal Galili
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},

Re: [R] nice report generator?

2011-12-08 Thread Tal Galili
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

Re: [R] nice report generator?

2011-12-08 Thread Michael
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

Re: [R] nice report generator?

2011-12-08 Thread Duncan Murdoch
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

Re: [R] nice report generator?

2011-12-07 Thread Steve Lianoglou
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?

Re: [R] nice report generator?

2011-12-07 Thread Sarah Goslee
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

Re: [R] nice report generator?

2011-12-07 Thread Janko Thyson
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?

Re: [R] nice report generator?

2011-12-07 Thread Michael
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

Re: [R] nice report generator?

2011-12-07 Thread Sarah Goslee
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

Re: [R] nice report generator?

2011-12-07 Thread Duncan Murdoch
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

Re: [R] nice report generator?

2011-12-07 Thread Nutter, Benjamin
-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

Re: [R] nice report generator?

2011-12-07 Thread Michael
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

Re: [R] nice report generator?

2011-12-07 Thread Abhijit Dasgupta
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

Re: [R] nice report generator?

2011-12-07 Thread Liviu Andronic
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.

Re: [R] nice report generator?

2011-12-07 Thread Michael
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

Re: [R] nice report generator?

2011-12-07 Thread Richard M. Heiberger
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

Re: [R] nice report generator?

2011-12-07 Thread Yihui Xie
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

Re: [R] nice report generator?

2011-12-07 Thread Gabor Grothendieck
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

Re: [R] nice report generator?

2011-12-07 Thread Duncan Murdoch
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

Re: [R] nice report generator?

2011-12-07 Thread Gabor Grothendieck
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

Re: [R] nice report generator?

2011-12-07 Thread Rainer Schuermann
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

Re: [R] nice report generator?

2011-12-07 Thread Michael
. 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

Re: [R] nice report generator?

2011-12-07 Thread Gabor Grothendieck
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

Re: [R] nice report generator?

2011-12-07 Thread R. Michael Weylandt
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