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 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?

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 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?

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

  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?

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/). 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?

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 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?

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 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?

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 = 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?

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- 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?

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 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?

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 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?

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

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

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

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

2011-12-14 Thread Richard M. Heiberger
On Wed, Dec 14, 2011 at 4:43 PM, Greg Snow greg.s...@imail.org wrote:

  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.


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?

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 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?

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 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?

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 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?

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 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?

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 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?

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}, 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?

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
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?

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 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?

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 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?

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?

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?

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 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?

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? 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?

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 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?

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
 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?

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 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?

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

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 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?

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 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?

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. 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?

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 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?

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 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?

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 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?

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 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?

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
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?

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 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?

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

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

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 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?

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 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.