R help - Jan 2004 - How to generate a report with graphics and tables?

Hello R-Users,

I have some data sets which change on a daily bases. So far I have 
imported  these sets into R, done all my evaluations resulting in a 
couple of plots, charts and tables of numbers which I copy&pasted via 
clipboard into Powerpoint.
The procedure is always the same and I wonder, whether there is no 
easier way for doing so. Is there some type of "report generator" 
available or some HowTo on this.

Can anybody give me a hint on where to look for?

Regards,

Olaf B?rger

If you don't mind pdf report generated from LaTeX, Sweave would probably
work nicely for you.  See the two articles on it in R News, which you can
find on the R web site.

One other possibility is to use the R2HTML package (and maybe the xtable
package, too) to write the `report' in HTML.

HTH,
Andy
> From: Olaf B?rger
> 
> Hello R-Users,
> 
> I have some data sets which change on a daily bases. So far I have 
> imported  these sets into R, done all my evaluations resulting in a 
> couple of plots, charts and tables of numbers which I copy&pasted via 
> clipboard into Powerpoint.
> The procedure is always the same and I wonder, whether there is no 
> easier way for doing so. Is there some type of "report generator"
> available or some HowTo on this.
> 
> Can anybody give me a hint on where to look for?
> 
> Regards,
> 
> Olaf B?rger
> 
 


------------------------------------------------------------------------------
Notice:  This e-mail message, together with any attachments,...{{dropped}}

On Wed, 28 Jan 2004 22:01:05 +0100
Olaf B?rger <obuerger at ginko.de> wrote:
> Hello R-Users,
> 
> I have some data sets which change on a daily bases. So far I have 
> imported  these sets into R, done all my evaluations resulting in a 
> couple of plots, charts and tables of numbers which I copy&pasted via 
> clipboard into Powerpoint.
> The procedure is always the same and I wonder, whether there is no 
> easier way for doing so. Is there some type of "report generator"
> available or some HowTo on this.
> 
> Can anybody give me a hint on where to look for?
> 
> Regards,
> 
> Olaf B?rger
>
For many reports Sweave (part of the tools package in R) is what you want,
in conjunction with LaTeX.  For customized reports see
http://hesweb1.med.virginia.edu/biostat/s/LiveDoc.html

LaTeX is necessary to do the job right, in my opinion.
---
Frank E Harrell Jr   Professor and Chair           School of Medicine
                     Department of Biostatistics   Vanderbilt University

You may want to have a look at Sweave at
http://www.ci.tuwien.ac.at/~leisch/Sweave/
and R-NEWS

P.J.


On Wed, 28 Jan 2004, Olaf B?rger wrote:
> Hello R-Users,
>
> I have some data sets which change on a daily bases. So far I have
> imported  these sets into R, done all my evaluations resulting in a
> couple of plots, charts and tables of numbers which I copy&pasted via
> clipboard into Powerpoint.
> The procedure is always the same and I wonder, whether there is no
> easier way for doing so. Is there some type of "report generator"
> available or some HowTo on this.
>
> Can anybody give me a hint on where to look for?
>
> Regards,
>
> Olaf B?rger
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html
>
>
Paulo Justiniano Ribeiro Jr
Departamento de Estat?stica
Universidade Federal do Paran?
Caixa Postal 19.081
CEP 81.531-990
Curitiba, PR  -  Brasil
Tel: (+55) 41 361 3471
Fax: (+55) 41 361 3141
e-mail: pj at est.ufpr.br
http://www.est.ufpr.br/~paulojus

On Wed, 2004-01-28 at 15:01, Olaf B?rger wrote:
> Hello R-Users,
> 
> I have some data sets which change on a daily bases. So far I have 
> imported  these sets into R, done all my evaluations resulting in a 
> couple of plots, charts and tables of numbers which I copy&pasted via 
> clipboard into Powerpoint.
> The procedure is always the same and I wonder, whether there is no 
> easier way for doing so. Is there some type of "report generator"
> available or some HowTo on this.
> 
> Can anybody give me a hint on where to look for?
> 
> Regards,
> 
> Olaf B?rger

You might want to look at Sweave, which is perfect where you have
standardized output formats, based upon changing datasets.

More information is available here:

http://www.ci.tuwien.ac.at/~leisch/Sweave/

and you can search the r-help archives for additional information.

HTH,

Marc Schwartz

On Windows you could use a macro recorder/playback program to automate your
session.

There is a free script interpreter called autoit at:

   http://www.hiddensoft.com/AutoIt/

that can handle about 90 different commands.  This may seem complex
but you may be able to use it without much of a learning curve 
by using the AutoScriptWriter recorder program found in the Files section of

   http://groups.yahoo.com/group/autoit/

to record key and mouse actions to create the script and then, if desired, make
changes to the script it produces using a text editor.

You startup autoscriptwriter and then press record and perform your actions. 
The actions could startup R, perform various
commands, start up powerpoint, do various activities, etc.  
Then press stop and press save to save the script.  You can then 
edit the script as desired in a text editor.   At this point 
the commands in the script will mostly be obvious and you
might be able to edit them even without reference to the documentation.  You 
can run the script using autoit itself.

I have used it a bit but not extensively; however, if you have
questions there is a yahoo group on it at the link cited above.

There are also numerous shareware and commercial keystroke and macro 
recorders that you can find using google.

On Wed, 28 Jan 2004 22:01:05 +0100
Olaf Bürger <obuerger at ginko.de> wrote:
> Hello R-Users,
> 
> I have some data sets which change on a daily bases. So far I have 
> imported these sets into R, done all my evaluations resulting in a 
> couple of plots, charts and tables of numbers which I copy&pasted via 
> clipboard into Powerpoint.
> The procedure is always the same and I wonder, whether there is no 
> easier way for doing so. Is there some type of "report generator"
> available or some HowTo on this.
> 
> Can anybody give me a hint on where to look for?
> 
> Regards,
> 
> Olaf Bürger
>

> 
> Hello R-Users,
> 
> I have some data sets which change on a daily bases. So far I have 
> imported  these sets into R, done all my evaluations resulting in a 
> couple of plots, charts and tables of numbers which I copy&pasted via 
> clipboard into Powerpoint.
                 ^^^^^^^^^^
Hello Olaf,

if you follow the previously given advices, i.e using Sweave/LaTeX, you
might consider the package "pdfscreen" and/or an utility program
"ppower",
to enhance your "LaTeX-presentation".

HTH,
Bernhard

http://www.tp4.ruhr-uni-bochum.de/SoftwareDocs/pdfsc/pdfscr-doc.html

http://www.ctan.org/tex-archive/support/ppower4/?action=/tex-archive/support
/  

> The procedure is always the same and I wonder, whether there is no 
> easier way for doing so. Is there some type of "report generator"
> available or some HowTo on this.
> 
> Can anybody give me a hint on where to look for?
> 
> Regards,
> 
> Olaf B?rger
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! 
http://www.R-project.org/posting-guide.html


--------------------------------------------------------------------------------
The information contained herein is confidential and is intended solely for the
addressee. Access by any other party is unauthorised without the express 
written permission of the sender. If you are not the intended recipient, please 
contact the sender either via the company switchboard on +44 (0)20 7623 8000, or
via e-mail return. If you have received this e-mail in error or wish to read our
e-mail disclaimer statement and monitoring policy, please refer to 
http://www.drkw.com/disc/email/ or contact the sender.

> From: Pfaff, Bernhard
> > 
> > Hello R-Users,
> > 
> > I have some data sets which change on a daily bases. So far I have 
> > imported  these sets into R, done all my evaluations resulting in a 
> > couple of plots, charts and tables of numbers which I 
> copy&pasted via 
> > clipboard into Powerpoint.
>                  ^^^^^^^^^^
> Hello Olaf,
> 
> if you follow the previously given advices, i.e using 
> Sweave/LaTeX, you
> might consider the package "pdfscreen" and/or an utility 
> program "ppower",
> to enhance your "LaTeX-presentation".
or even prosper:  http://prosper.sourceforge.net/

Andy
 
> HTH,
> Bernhard
> 
http://www.tp4.ruhr-uni-bochum.de/SoftwareDocs/pdfsc/pdfscr-doc.html

http://www.ctan.org/tex-archive/support/ppower4/?action=/tex-archive/support


------------------------------------------------------------------------------
Notice:  This e-mail message, together with any attachments,...{{dropped}}

Depending on how much post-processing you do in 
Powerpoint, you might try importing the chart 
using a "link".

Have R save the chart in a file. Then go into 
Powerpoint, use the Insert Picture from File menu 
item, and in the dialog box that comes up select 
"Link to File".

-Don

At 10:01 PM +0100 1/28/04, Olaf B?rger wrote:
>Hello R-Users,
>
>I have some data sets which change on a daily 
>bases. So far I have imported  these sets into 
>R, done all my evaluations resulting in a couple 
>of plots, charts and tables of numbers which I 
>copy&pasted via clipboard into Powerpoint.
>The procedure is always the same and I wonder, 
>whether there is no easier way for doing so. Is 
>there some type of "report generator" available 
>or some HowTo on this.
>
>Can anybody give me a hint on where to look for?
>
>Regards,
>
>Olaf B?rger
>
>______________________________________________
>R-help at stat.math.ethz.ch mailing list
>https://www.stat.math.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html

-- 
--------------------------------------
Don MacQueen
Environmental Protection Department
Lawrence Livermore National Laboratory
Livermore, CA, USA

Just to expand on an earlier suggestion:
> > I have some data sets which change on a daily bases. So far I have 
> > imported these sets into R, done all my evaluations resulting in a 
> > couple of plots, charts and tables of numbers which I copy&pasted
via>
  > clipboard into Powerpoint. 
> > The procedure is always the same and I wonder, whether there is no 
> > easier way for doing so. Is there some type of "report
generator"
> > available or some HowTo on this. 
> > 
> > Can anybody give me a hint on where to look for? 
> > 
> > Regards, 
> > 
> > Olaf B?rger 
...
> One other possibility is to use the R2HTML package (and maybe the
xtable>
  package, too) to write the `report' in HTML. 
> 
> 
> HTH, 
> Andy 
> 
> 
R2HTML is not (yet) as far along as Sweave, but depending on how much
sympathy you have for your clients, html can be a very nice solution. An
important requirement for many reports is that computer-naive clients be
able to edit and copy from the reports to an MS application, preferably
without severe font and formatting problems and without needing to
install/understand <foo>2<bar> type applications. See comments to
this
effect in the recent R2HTML article by the package author, Eric Lecoutre in
the most recent R News (vol 3/3). As Andy noted, xtable is nice to use in
conjunction with R2HTML (just write a little xtable method like the one
following this message):

In particular, a naive user viewing the html file with Internet Explorer (I
know v. 5.5 or greater will work) will have an option, under the File menu
to "Edit with Microsoft Word for Windows". This assumes they have set
MS
Word as their HTML editor within IE. It also assumes some minimal formatting
requirements for the HTML file (but you can worry about this, the client
won't have to). 

I find this solution keeps everyone happy:
1. I can auto-generate text source for my documents;
2. clients without proprietary software can view the report; 
3. clients with standard MS software but without a clue can easily edit and
copy. 

Cheers,
Jim 

HTML.xtable <- function(x, file = .HTML.file, append = TRUE) {
  sink(file = file, append = append)
  print(x, type = "html")
  sink()
}

James A. Rogers 
Manager, Nonclinical Statistics
PGR&D Groton Labs
Eastern Point Road (MS 8260-1331)
Groton, CT 06340
office: (860) 686-0786
fax: (860) 715-5445
 










LEGAL NOTICE\ Unless expressly stated otherwise, this messag...{{dropped}}