Re: [R] What is the best way to have R output tables in an MS Word format? (shaping R core)
chrish...@psyctc.org wrote: I've changed the subject line a bit here as Max is asking such a fundamental question. Max Kuhn sent the following at 01/05/2010 19:22: Chris, ... Why is it R Core's job to fulfill your wants and desires? I have a hard time thinking that very busy people would spend extra time doing something that they may or may not have a direct need for. Write it yourself or get a group of people together to do it. That what we did with odfWeave (for better or worse). If the task is beyond what you feel you can do, fund it. Ouch. OK. I'm hugely grateful for your work on odfWeave Max and sorry that Open Office isn't a solution for me at the moment. However, I don't think I'm being unreasonable or selfish. 1) Certainbly it's not R core's job to fulfil my wants and desires and they will have ways to discuss what would strengthen R for lots of us. Clearly I can submit a wishlist item to the R bugzilla and I should but that's very particulate: how can the team find out of wishes are common or would help increase use of R? There are files of key R core team members' wish lists on the R site but almost none relate in any way to output and some appear to be years old. I've worked with R (about 14 years I think) and as I look particularly at the recent release notes, I see a lot of work went into changing the help system which is one sort of output from R and a huge amount of work went into transitions in the object orientation (S3 to S4). I think that what I am suggesting is about a core issue of seeing a set of object properties for numeric output as including insertion of tabs, ideally as providing flexible presenting and viewing of all matrices, data frames and lists, and, some day, cross linkage of graphics into output. Ideally, as with the capacity of R to export its graphics in a number of formats, I'd love to see this capitalising on the work you have done for ODF and others have done for TeX etc. These strike me as central object handling issues, not things that should for ever be offloaded to the libraries/packages. I don't think that because something is important it needs to be in the part of R that R Core handles. The things that need to be there are things that can't be anywhere else. Things that can be elsewhere should be elsewhere, because the more that is in base R, the more time R Core spends on maintenance, and the less time on development of base R or on the other things we do (e.g. the things our employers pay us to do). We don't always follow this rule: in some cases, things that could be elsewhere are in base R because an R Core member doesn't mind taking on the maintenance, and it is easier to put them in base R than to create a new package for them. (Sweave is an example of this; there has been talk of moving it out of the base, but that hasn't happened yet.) But I don't think any members of R Core use any of those word processors called MS Word, and I don't see any need for core support for producing output for them. R already produces structured objects with all the semantics of XML objects (though it doesn't use that format to store them); it is simply a matter of deciding what format you'd like things to be displayed in, and then figuring out how to produce something in that format in a way that MS Word will understand. The first task is definitely something within the range of an R user. Getting it into some version of .doc or .docx or whatever is not at all easy, but it really has very little to do with R. It would make more sense to ask Microsoft to handle that part than it makes to ask R Core to do it. Duncan Murdoch 2) Do it myself: I wish! I'm a terrible programmer and work 50-70 hoursa week in my main jobs (I'm so outspoken here at the moment partly because I'm off work post-op.) I'm quite a good psychotherapist and capable of working in several different modes of psychotherapy and with individuals, couples, groups and families and I'm a fairly competent researcher and clinical director. I wish I'd been born or learned to be a better programmer as I wish I'd been more musical and able to dance but I'm not. I can contribute ideas, help debug things and hope to contribute much more of this when I retire from the main jobs. I have no links with programmers at work nor in my university location so I have no colleagues with whom I can form a team to do this. 3) Pay for it myself: I was pretty ignorant about ways of paying for R things. I can't see me persuading my NHS employer to pay as we're contracting rapidly and don't officially use R. If we had the outputting I'm describing in the R core I think I might be able to get us to stop paying some thousands of pounds a year for SPSS and might be able to shift say 1k in gratitude to R though NHS purchasing rules don't make that easy. (That, I think, is one of the huge challenges to open source s'ware, if someone can tell me about ways to
Re: [R] What is the best way to have R output tables in an MS Word format? (shaping R core)
Well, there's always RExcel to get all your R stuff into something M$ Ruffice can understand. And they're even working on a Word link if I got it right. Cheers Joris On Fri, May 7, 2010 at 12:24 PM, Duncan Murdoch murdoch.dun...@gmail.comwrote: chrish...@psyctc.org wrote: I've changed the subject line a bit here as Max is asking such a fundamental question. Max Kuhn sent the following at 01/05/2010 19:22: Chris, ... Why is it R Core's job to fulfill your wants and desires? I have a hard time thinking that very busy people would spend extra time doing something that they may or may not have a direct need for. Write it yourself or get a group of people together to do it. That what we did with odfWeave (for better or worse). If the task is beyond what you feel you can do, fund it. Ouch. OK. I'm hugely grateful for your work on odfWeave Max and sorry that Open Office isn't a solution for me at the moment. However, I don't think I'm being unreasonable or selfish. 1) Certainbly it's not R core's job to fulfil my wants and desires and they will have ways to discuss what would strengthen R for lots of us. Clearly I can submit a wishlist item to the R bugzilla and I should but that's very particulate: how can the team find out of wishes are common or would help increase use of R? There are files of key R core team members' wish lists on the R site but almost none relate in any way to output and some appear to be years old. I've worked with R (about 14 years I think) and as I look particularly at the recent release notes, I see a lot of work went into changing the help system which is one sort of output from R and a huge amount of work went into transitions in the object orientation (S3 to S4). I think that what I am suggesting is about a core issue of seeing a set of object properties for numeric output as including insertion of tabs, ideally as providing flexible presenting and viewing of all matrices, data frames and lists, and, some day, cross linkage of graphics into output. Ideally, as with the capacity of R to export its graphics in a number of formats, I'd love to see this capitalising on the work you have done for ODF and others have done for TeX etc. These strike me as central object handling issues, not things that should for ever be offloaded to the libraries/packages. I don't think that because something is important it needs to be in the part of R that R Core handles. The things that need to be there are things that can't be anywhere else. Things that can be elsewhere should be elsewhere, because the more that is in base R, the more time R Core spends on maintenance, and the less time on development of base R or on the other things we do (e.g. the things our employers pay us to do). We don't always follow this rule: in some cases, things that could be elsewhere are in base R because an R Core member doesn't mind taking on the maintenance, and it is easier to put them in base R than to create a new package for them. (Sweave is an example of this; there has been talk of moving it out of the base, but that hasn't happened yet.) But I don't think any members of R Core use any of those word processors called MS Word, and I don't see any need for core support for producing output for them. R already produces structured objects with all the semantics of XML objects (though it doesn't use that format to store them); it is simply a matter of deciding what format you'd like things to be displayed in, and then figuring out how to produce something in that format in a way that MS Word will understand. The first task is definitely something within the range of an R user. Getting it into some version of .doc or .docx or whatever is not at all easy, but it really has very little to do with R. It would make more sense to ask Microsoft to handle that part than it makes to ask R Core to do it. Duncan Murdoch 2) Do it myself: I wish! I'm a terrible programmer and work 50-70 hoursa week in my main jobs (I'm so outspoken here at the moment partly because I'm off work post-op.) I'm quite a good psychotherapist and capable of working in several different modes of psychotherapy and with individuals, couples, groups and families and I'm a fairly competent researcher and clinical director. I wish I'd been born or learned to be a better programmer as I wish I'd been more musical and able to dance but I'm not. I can contribute ideas, help debug things and hope to contribute much more of this when I retire from the main jobs. I have no links with programmers at work nor in my university location so I have no colleagues with whom I can form a team to do this. 3) Pay for it myself: I was pretty ignorant about ways of paying for R things. I can't see me persuading my NHS employer to pay as we're contracting rapidly and don't officially use R. If we had the outputting I'm describing in the R core I think I might
Re: [R] What is the best way to have R output tables in an MS Word format? (shaping R core)
For simply doing tables xtable has done some nice work for me. --- On Fri, 5/7/10, Joris Meys jorism...@gmail.com wrote: From: Joris Meys jorism...@gmail.com Subject: Re: [R] What is the best way to have R output tables in an MS Word format? (shaping R core) To: Duncan Murdoch murdoch.dun...@gmail.com Cc: r-h...@stat.math.ethz.ch Received: Friday, May 7, 2010, 6:48 AM Well, there's always RExcel to get all your R stuff into something M$ Ruffice can understand. And they're even working on a Word link if I got it right. Cheers Joris On Fri, May 7, 2010 at 12:24 PM, Duncan Murdoch murdoch.dun...@gmail.comwrote: chrish...@psyctc.org wrote: I've changed the subject line a bit here as Max is asking such a fundamental question. Max Kuhn sent the following at 01/05/2010 19:22: Chris, ... Why is it R Core's job to fulfill your wants and desires? I have a hard time thinking that very busy people would spend extra time doing something that they may or may not have a direct need for. Write it yourself or get a group of people together to do it. That what we did with odfWeave (for better or worse). If the task is beyond what you feel you can do, fund it. Ouch. OK. I'm hugely grateful for your work on odfWeave Max and sorry that Open Office isn't a solution for me at the moment. However, I don't think I'm being unreasonable or selfish. 1) Certainbly it's not R core's job to fulfil my wants and desires and they will have ways to discuss what would strengthen R for lots of us. Clearly I can submit a wishlist item to the R bugzilla and I should but that's very particulate: how can the team find out of wishes are common or would help increase use of R? There are files of key R core team members' wish lists on the R site but almost none relate in any way to output and some appear to be years old. I've worked with R (about 14 years I think) and as I look particularly at the recent release notes, I see a lot of work went into changing the help system which is one sort of output from R and a huge amount of work went into transitions in the object orientation (S3 to S4). I think that what I am suggesting is about a core issue of seeing a set of object properties for numeric output as including insertion of tabs, ideally as providing flexible presenting and viewing of all matrices, data frames and lists, and, some day, cross linkage of graphics into output. Ideally, as with the capacity of R to export its graphics in a number of formats, I'd love to see this capitalising on the work you have done for ODF and others have done for TeX etc. These strike me as central object handling issues, not things that should for ever be offloaded to the libraries/packages. I don't think that because something is important it needs to be in the part of R that R Core handles. The things that need to be there are things that can't be anywhere else. Things that can be elsewhere should be elsewhere, because the more that is in base R, the more time R Core spends on maintenance, and the less time on development of base R or on the other things we do (e.g. the things our employers pay us to do). We don't always follow this rule: in some cases, things that could be elsewhere are in base R because an R Core member doesn't mind taking on the maintenance, and it is easier to put them in base R than to create a new package for them. (Sweave is an example of this; there has been talk of moving it out of the base, but that hasn't happened yet.) But I don't think any members of R Core use any of those word processors called MS Word, and I don't see any need for core support for producing output for them. R already produces structured objects with all the semantics of XML objects (though it doesn't use that format to store them); it is simply a matter of deciding what format you'd like things to be displayed in, and then figuring out how to produce something in that format in a way that MS Word will understand. The first task is definitely something within the range of an R user. Getting it into some version of .doc or .docx or whatever is not at all easy, but it really has very little to do with R. It would make more sense to ask Microsoft to handle that part than it makes to ask R Core to do it. Duncan Murdoch 2) Do it myself: I wish! I'm a terrible programmer and work 50-70 hoursa week in my main jobs (I'm so outspoken here at the moment partly because I'm off work post-op.) I'm quite a good psychotherapist and capable of working in several different modes of psychotherapy and with individuals, couples, groups and families and I'm a fairly competent researcher and clinical director. I wish I'd been born or learned to be a better programmer as I wish I'd been more musical and able to
Re: [R] What is the best way to have R output tables in an MS Word format?
Hi Chris, Following this thread, I started experimenting with the R2wd package myself. I wrote to the developer who gave me some promising news (that is - that an updated package is expected to be released in the next couple of months) I wrote about this, and gave an example session on what I found can be done with R2wd here: http://www.r-statistics.com/2010/05/exporting-r-output-to-ms-word-with-r2wd-an-example-session/ This package is in it's early stages, but can still function well (though probably much less then what a Latex person can do with Sweave) 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 Mon, May 3, 2010 at 4:47 PM, Chris Evans chrish...@psyctc.org wrote: Thanks Tal Thomas, I am now experimenting with both SWord and R2wd and both are certainly a huge step forward for me, tied as I am to Word and the Windoze/M$ world for now. Chris Tal Galili sent the following at 01/05/2010 09:44: Hi all, I forwarded this question to the r-com mailing list, and received the following reply from Thomas Baier : Hi Tal, two solutions immediately come to my mind: SWord (http://rcom.univie.ac.at) and R2wd (from CRAN). If creating a paper in Word, then SWord may be the better choice, if you want to create reports controlled from R, R2wd might be the better one. Best, Thomas They both look potentially very useful and can do wonderful embedding of tabulated data frames and graphics to judge form the help page for R2wd and that works on my set up. However, I'm crash R2wd and hange R passing lm output with: lm.D9 - lm(weight ~ group) # from the lm help page wdBody(lm.D9) I'll try to link up with whoever I should (Thomas, Christian?) to debug this (and, of course, it may be particular to my set up) but I still argue there's a problem letting these output capabilities go to packages and not putting them in the core: a) it's easy for us not to know of them, I didn't know of R2wd nor ascii for example, b) surely to have provided really excellent graphic output in the core is a bit incongruent with having even provided tabs for matrices and tables? I'll pick up more in response to Max Kuhn's message. Very best, Chris -- Chris Evans ch...@psyctc.org Skype: chris-psyctc Consultant Psychiatrist in Psychotherapy, Notts. PDD network; Trust Research Governance Lead and Clinical Director, Psychological Therapies Directorate in Local Services, Nottinghamshire NHS Trust; Professor, Psychotherapy, Nottingham University *If I am writing from one of those roles, it will be clear. Otherwise* *my views are my own and not representative of those institutions* If you have difficulty Emailing me on this address or getting a reply, send again but cc to: chris dot evans at nottshc dot nhs dot uk and to: c dot evans at nottingham dot ac dot uk __ 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] What is the best way to have R output tables in an MS Word format?
I remembered this post too: https://stat.ethz.ch/pipermail/r-help/2009-September/212084.html I wonder if there is a beta version of Duncan's package. Thanks, Max On Thu, May 6, 2010 at 12:33 PM, Tal Galili tal.gal...@gmail.com wrote: Hi Chris, Following this thread, I started experimenting with the R2wd package myself. I wrote to the developer who gave me some promising news (that is - that an updated package is expected to be released in the next couple of months) I wrote about this, and gave an example session on what I found can be done with R2wd here: http://www.r-statistics.com/2010/05/exporting-r-output-to-ms-word-with-r2wd-an-example-session/ This package is in it's early stages, but can still function well (though probably much less then what a Latex person can do with Sweave) 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 Mon, May 3, 2010 at 4:47 PM, Chris Evans chrish...@psyctc.org wrote: Thanks Tal Thomas, I am now experimenting with both SWord and R2wd and both are certainly a huge step forward for me, tied as I am to Word and the Windoze/M$ world for now. Chris Tal Galili sent the following at 01/05/2010 09:44: Hi all, I forwarded this question to the r-com mailing list, and received the following reply from Thomas Baier : Hi Tal, two solutions immediately come to my mind: SWord (http://rcom.univie.ac.at) and R2wd (from CRAN). If creating a paper in Word, then SWord may be the better choice, if you want to create reports controlled from R, R2wd might be the better one. Best, Thomas They both look potentially very useful and can do wonderful embedding of tabulated data frames and graphics to judge form the help page for R2wd and that works on my set up. However, I'm crash R2wd and hange R passing lm output with: lm.D9 - lm(weight ~ group) # from the lm help page wdBody(lm.D9) I'll try to link up with whoever I should (Thomas, Christian?) to debug this (and, of course, it may be particular to my set up) but I still argue there's a problem letting these output capabilities go to packages and not putting them in the core: a) it's easy for us not to know of them, I didn't know of R2wd nor ascii for example, b) surely to have provided really excellent graphic output in the core is a bit incongruent with having even provided tabs for matrices and tables? I'll pick up more in response to Max Kuhn's message. Very best, Chris -- Chris Evans ch...@psyctc.org Skype: chris-psyctc Consultant Psychiatrist in Psychotherapy, Notts. PDD network; Trust Research Governance Lead and Clinical Director, Psychological Therapies Directorate in Local Services, Nottinghamshire NHS Trust; Professor, Psychotherapy, Nottingham University *If I am writing from one of those roles, it will be clear. Otherwise* *my views are my own and not representative of those institutions * If you have difficulty Emailing me on this address or getting a reply, send again but cc to: chris dot evans at nottshc dot nhs dot uk and to: c dot evans at nottingham dot ac dot uk __ 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. -- Max __ 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] What is the best way to have R output tables in an MS Word format?
Tal Galili sent the following at 06/05/2010 17:33: Hi Chris, Following this thread, I started experimenting with the R2wd package myself. I wrote to the developer who gave me some promising news (that is - that an updated package is expected to be released in the next couple of months) That's good news, I haven't followed the problem I was having up with the author yet ... I wrote about this, and gave an example session on what I found can be done with R2wd here: http://www.r-statistics.com/2010/05/exporting-r-output-to-ms-word-with-r2wd-an-example-session/ OK, I see that you've written a workaround that gets lm output to Word: impressive. However, I think this beautifully supports my wish that we move toward better formatted text output in the R core and that we do that by moving through allowing, and encouraging, the tab character to be put into routine R text output as the output from lm is, of course, the raw monospaced font style output aligned using monospace font spaces. Wonderfully statistically powerful and correct and cosmetically and humanly ugly and time consuming to reformat. This package is in it's early stages, but can still function well (though probably much less then what a Latex person can do with Sweave) Agreed! Many thanks again for this and great to see interest in the issues, I do think they are important. Very best to all, Chris -- Chris Evans ch...@psyctc.org Skype: chris-psyctc Consultant Psychiatrist in Psychotherapy, Notts. PDD network; Trust Research Governance Lead and Clinical Director, Psychological Therapies Directorate in Local Services, Nottinghamshire NHS Trust; Professor, Psychotherapy, Nottingham University *If I am writing from one of those roles, it will be clear. Otherwise* *my views are my own and not representative of those institutions* If you have difficulty Emailing me on this address or getting a reply, send again but cc to: chris dot evans at nottshc dot nhs dot uk and to: c dot evans at nottingham dot ac dot uk __ 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] What is the best way to have R output tables in an MS Word format? (shaping R core)
I've changed the subject line a bit here as Max is asking such a fundamental question. Max Kuhn sent the following at 01/05/2010 19:22: Chris, ... Why is it R Core's job to fulfill your wants and desires? I have a hard time thinking that very busy people would spend extra time doing something that they may or may not have a direct need for. Write it yourself or get a group of people together to do it. That what we did with odfWeave (for better or worse). If the task is beyond what you feel you can do, fund it. Ouch. OK. I'm hugely grateful for your work on odfWeave Max and sorry that Open Office isn't a solution for me at the moment. However, I don't think I'm being unreasonable or selfish. 1) Certainbly it's not R core's job to fulfil my wants and desires and they will have ways to discuss what would strengthen R for lots of us. Clearly I can submit a wishlist item to the R bugzilla and I should but that's very particulate: how can the team find out of wishes are common or would help increase use of R? There are files of key R core team members' wish lists on the R site but almost none relate in any way to output and some appear to be years old. I've worked with R (about 14 years I think) and as I look particularly at the recent release notes, I see a lot of work went into changing the help system which is one sort of output from R and a huge amount of work went into transitions in the object orientation (S3 to S4). I think that what I am suggesting is about a core issue of seeing a set of object properties for numeric output as including insertion of tabs, ideally as providing flexible presenting and viewing of all matrices, data frames and lists, and, some day, cross linkage of graphics into output. Ideally, as with the capacity of R to export its graphics in a number of formats, I'd love to see this capitalising on the work you have done for ODF and others have done for TeX etc. These strike me as central object handling issues, not things that should for ever be offloaded to the libraries/packages. 2) Do it myself: I wish! I'm a terrible programmer and work 50-70 hours a week in my main jobs (I'm so outspoken here at the moment partly because I'm off work post-op.) I'm quite a good psychotherapist and capable of working in several different modes of psychotherapy and with individuals, couples, groups and families and I'm a fairly competent researcher and clinical director. I wish I'd been born or learned to be a better programmer as I wish I'd been more musical and able to dance but I'm not. I can contribute ideas, help debug things and hope to contribute much more of this when I retire from the main jobs. I have no links with programmers at work nor in my university location so I have no colleagues with whom I can form a team to do this. 3) Pay for it myself: I was pretty ignorant about ways of paying for R things. I can't see me persuading my NHS employer to pay as we're contracting rapidly and don't officially use R. If we had the outputting I'm describing in the R core I think I might be able to get us to stop paying some thousands of pounds a year for SPSS and might be able to shift say 1k in gratitude to R though NHS purchasing rules don't make that easy. (That, I think, is one of the huge challenges to open source s'ware, if someone can tell me about ways to get organisations who have to justify their purchasing as we do manage to pay for open source development, I'd like to hear and I'll try to make it happen.) Prompted by your Email I have found the R project membership form and 'faxed it off with payment and will probably donate some more on top of that 25 euros. However, I would love a way to make a donation that would encourage someone to do this bit of work but I'm currently unlikely, personally, to have the money to pay for all that's needed. Hope this helps explain my position. I'm genuinely keen to hear others' views. Very best to all, Chris -- Chris Evans ch...@psyctc.org Skype: chris-psyctc Consultant Psychiatrist in Psychotherapy, Notts. PDD network; Trust Research Governance Lead and Clinical Director, Psychological Therapies Directorate in Local Services, Nottinghamshire NHS Trust; Professor, Psychotherapy, Nottingham University *If I am writing from one of those roles, it will be clear. Otherwise* *my views are my own and not representative of those institutions* If you have difficulty Emailing me on this address or getting a reply, send again but cc to: chris dot evans at nottshc dot nhs dot uk and to: c dot evans at nottingham dot ac dot uk __ 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] What is the best way to have R output tables in an MS Word format?
Hi Max, It looks like most of answers were towards to the statisticians you work with (i.e. R - Word). For yourself, if you just worry about converting the PDF reports from your statisticians to Word, here is another link with a more comprehensive review besides the two online apps Prof. Harrell's mentioned on his webpage. http://www.freewaregenius.com/2010/03/06/how-to-convert-pdf-to-word-doc-for-free-a-comparative-test/ Also, Adobe Acrobat 9.0 can do PDF-Word, but I haven't tried it personally. ...Tao On Fri, Apr 30, 2010 at 5:13 PM, Max Gunther max.gunt...@vanderbilt.eduwrote: Dear R list, Our statisticians usually give us results back in a PDF format. I would like to be able to copy and past tables from R output directly into a Microsoft Word table since this will save us tons of time, be more accurate to minimize human copying errors and help us update data in our papers more easily. Do people have suggestions for the best way to do this? I am a novice to R but I do work with a couple of very knowledgeable statisticians who do most of the heavy statistical lifting for our research group. Many thanks, Max Max Gunther, PhD Vanderbilt University - Radiology Institute of Imaging Sciences - VUIIS Center for Health Services Research Nashville, TN www.ICUdelirium.org _ Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox. N:WL:en-US:WM_HMP:042010_1 __ 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] What is the best way to have R output tables in an MS Word format?
Thanks Tal Thomas, I am now experimenting with both SWord and R2wd and both are certainly a huge step forward for me, tied as I am to Word and the Windoze/M$ world for now. Chris Tal Galili sent the following at 01/05/2010 09:44: Hi all, I forwarded this question to the r-com mailing list, and received the following reply from Thomas Baier : Hi Tal, two solutions immediately come to my mind: SWord (http://rcom.univie.ac.at) and R2wd (from CRAN). If creating a paper in Word, then SWord may be the better choice, if you want to create reports controlled from R, R2wd might be the better one. Best, Thomas They both look potentially very useful and can do wonderful embedding of tabulated data frames and graphics to judge form the help page for R2wd and that works on my set up. However, I'm crash R2wd and hange R passing lm output with: lm.D9 - lm(weight ~ group) # from the lm help page wdBody(lm.D9) I'll try to link up with whoever I should (Thomas, Christian?) to debug this (and, of course, it may be particular to my set up) but I still argue there's a problem letting these output capabilities go to packages and not putting them in the core: a) it's easy for us not to know of them, I didn't know of R2wd nor ascii for example, b) surely to have provided really excellent graphic output in the core is a bit incongruent with having even provided tabs for matrices and tables? I'll pick up more in response to Max Kuhn's message. Very best, Chris -- Chris Evans ch...@psyctc.org Skype: chris-psyctc Consultant Psychiatrist in Psychotherapy, Notts. PDD network; Trust Research Governance Lead and Clinical Director, Psychological Therapies Directorate in Local Services, Nottinghamshire NHS Trust; Professor, Psychotherapy, Nottingham University *If I am writing from one of those roles, it will be clear. Otherwise* *my views are my own and not representative of those institutions* If you have difficulty Emailing me on this address or getting a reply, send again but cc to: chris dot evans at nottshc dot nhs dot uk and to: c dot evans at nottingham dot ac dot uk __ 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] What is the best way to have R output tables in an MS Word format?
On 05/03/2010 08:47 AM, Chris Evans wrote: Thanks Tal Thomas, I am now experimenting with both SWord and R2wd and both are certainly a huge step forward for me, tied as I am to Word and the Windoze/M$ world for now. Chris Note that many of the general solutions offered produce documents (.doc, .html, .rtf) that can be then converted to formats Word can take as described at http://biostat.mc.vanderbilt.edu/SweaveConvert. That page has an example where pdflatex is used to produce a complex table containing graphics in some of the cells, and I used a web service to convert to .doc. Frank Tal Galili sent the following at 01/05/2010 09:44: Hi all, I forwarded this question to the r-com mailing list, and received the following reply from Thomas Baier : Hi Tal, two solutions immediately come to my mind: SWord (http://rcom.univie.ac.at) and R2wd (from CRAN). If creating a paper in Word, then SWord may be the better choice, if you want to create reports controlled from R, R2wd might be the better one. Best, Thomas They both look potentially very useful and can do wonderful embedding of tabulated data frames and graphics to judge form the help page for R2wd and that works on my set up. However, I'm crash R2wd and hange R passing lm output with: lm.D9- lm(weight ~ group) # from the lm help page wdBody(lm.D9) I'll try to link up with whoever I should (Thomas, Christian?) to debug this (and, of course, it may be particular to my set up) but I still argue there's a problem letting these output capabilities go to packages and not putting them in the core: a) it's easy for us not to know of them, I didn't know of R2wd nor ascii for example, b) surely to have provided really excellent graphic output in the core is a bit incongruent with having even provided tabs for matrices and tables? I'll pick up more in response to Max Kuhn's message. Very best, Chris -- Frank E Harrell Jr Professor and ChairmanSchool of Medicine Department of Biostatistics Vanderbilt University __ 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] What is the best way to have R output tables in an MS Word format?
On 05/01/2010 08:13 AM, Max Gunther wrote: Dear R list, Our statisticians usually give us results back in a PDF format. I would like to be able to copy and past tables from R output directly into a Microsoft Word table since this will save us tons of time, be more accurate to minimize human copying errors and help us update data in our papers more easily. Do people have suggestions for the best way to do this? I am a novice to R but I do work with a couple of very knowledgeable statisticians who do most of the heavy statistical lifting for our research group. Hi Max, In addition to all the other suggestions, htmlize in the prettyR package will produce HTML output with embedded plots, and delim.table in the same package will output tables in a variety of formats if you only want tables. Jim __ 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] What is the best way to have R output tables in an MS Word format?
It's interesting to see this coming up quite soon after my posting asking for light formatting (tabs, simple tables, one day embedded graphics) in a default output pane in R. Greg Snow kindly pointed me to sword and I've tried it and it seems to work and is a bit friendlier than ODFweave or the xtable, hwriter and R2HTML options that I also know. Sweave and the whole transition to TeX/LaTeX, though I'd love it, just isn't a realistic option for me as my statistical/numerical work is done in a world in which pretty literally no-one uses TeX and I and many others who are part time with R will never have time to learn to go that way. (I promise myself I'll give it one determined try when I retire but even then all papers I submit to journals will have to be in Word or RTF.) Greg also kindly pointed me to the R-Plus GUI by Xlsolutions corp (http://www.youtube.com/watch?v=1qsv1MdB4tk) (thanks Greg) and that clearly has some of the formatted table output I'd like but it is also a huge shift towards the whole SPSS style pull down menus for everything and I really don't want that (and can't justify the price!) Come on R core team: I am sure there are a large number of users like Max Gunther and myself who would find this a huge help and I'm equally sure there are an even larger number of potential users who would change to R if we had formatted tables in the output window and the option to save that to HTML, TeX, ODF and ideally RTF. I think three quarters of the export/save primitives needed are there in these various add ons to R that alread exist and all that's needed on top of them is a simple screen rendering that would handle tables. (Graphics later or even never would be fine by me.) Yours in hope and huge appreciation for what we already have which I have been using a bit this last week and, as ever, marvelling at its power and simplicity ... and I didn't need tables from it for once! Very best all, Chris Frank E Harrell Jr sent the following at 01/05/2010 04:35: On 04/30/2010 05:45 PM, Marc Schwartz wrote: On Apr 30, 2010, at 5:13 PM, Max Gunther wrote: Dear R list, Our statisticians usually give us results back in a PDF format. I would like to be able to copy and past tables from R output directly into a Microsoft Word table since this will save us tons of time, be more accurate to minimize human copying errors and help us update data in our papers more easily. Do people have suggestions for the best way to do this? I am a novice to R but I do work with a couple of very knowledgeable statisticians who do most of the heavy statistical lifting for our research group. Many thanks, Max Max, I would urge you to consider using Sweave. It enables the use of R and LaTeX to facilitate reproducible research, which seems to be your goal here. You might want to talk to your campus neighbor Frank Harrell, who has extensive information on the Vanderbilt Biostatistics department web site on this: And note Max that we have an R clinic every Thursday at 2pm. LaTeX and Sweave are frequently discussed during the clinic. Frank http://biostat.mc.vanderbilt.edu/twiki/bin/view/Main/StatReport Frank also has some pointers for converting between various formats: http://biostat.mc.vanderbilt.edu/twiki/bin/view/Main/SweaveConvert HTH, Marc Schwartz __ 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. -- Chris Evans ch...@psyctc.org Skype: chris-psyctc Consultant Psychiatrist in Psychotherapy, Notts. PDD network; Trust Research Governance Lead and Clinical Director, Psychological Therapies Directorate in Local Services, Nottinghamshire NHS Trust; Professor, Psychotherapy, Nottingham University *If I am writing from one of those roles, it will be clear. Otherwise* *my views are my own and not representative of those institutions* If you have difficulty Emailing me on this address or getting a reply, send again but cc to: chris dot evans at nottshc dot nhs dot uk and to: c dot evans at nottingham dot ac dot uk __ 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] What is the best way to have R output tables in an MS Word format?
Hi all, I forwarded this question to the r-com mailing list, and received the following reply from Thomas Baier : Hi Tal, two solutions immediately come to my mind: SWord (http://rcom.univie.ac.at) and R2wd (from CRAN). If creating a paper in Word, then SWord may be the better choice, if you want to create reports controlled from R, R2wd might be the better one. Best, Thomas 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 Sat, May 1, 2010 at 10:18 AM, Jim Lemon j...@bitwrit.com.au wrote: On 05/01/2010 08:13 AM, Max Gunther wrote: Dear R list, Our statisticians usually give us results back in a PDF format. I would like to be able to copy and past tables from R output directly into a Microsoft Word table since this will save us tons of time, be more accurate to minimize human copying errors and help us update data in our papers more easily. Do people have suggestions for the best way to do this? I am a novice to R but I do work with a couple of very knowledgeable statisticians who do most of the heavy statistical lifting for our research group. Hi Max, In addition to all the other suggestions, htmlize in the prettyR package will produce HTML output with embedded plots, and delim.table in the same package will output tables in a variety of formats if you only want tables. Jim __ 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] What is the best way to have R output tables in an MS Word format?
On Sat, May 1, 2010 at 3:41 AM, Chris Evans chrish...@psyctc.org wrote: It's interesting to see this coming up quite soon after my posting asking for light formatting (tabs, simple tables, one day embedded graphics) in a default output pane in R. Greg Snow kindly pointed me to sword and I've tried it and it seems to work and is a bit friendlier than ODFweave or the xtable, hwriter and R2HTML options that I also know. Sweave and the whole transition to TeX/LaTeX, though I'd love it, just isn't a realistic option for me as my statistical/numerical work is done in a world in which pretty literally no-one uses TeX and I and many others who are part time with R will never have time to learn to go that way. (I promise myself I'll give it one determined try when I retire but even then all papers I submit to journals will have to be in Word or RTF.) Greg also kindly pointed me to the R-Plus GUI by Xlsolutions corp (http://www.youtube.com/watch?v=1qsv1MdB4tk) (thanks Greg) and that clearly has some of the formatted table output I'd like but it is also a huge shift towards the whole SPSS style pull down menus for everything and I really don't want that (and can't justify the price!) Come on R core team: I am sure there are a large number of users like Max Gunther and myself who would find this a huge help and I'm equally sure there are an even larger number of potential users who would change to R if we had formatted tables in the output window and the option to save that to HTML, TeX, ODF and ideally RTF. I think three quarters of the export/save primitives needed are there in these various add ons to R that alread exist and all that's needed on top of them is a simple screen rendering that would handle tables. (Graphics later or even never would be fine by me.) Yours in hope and huge appreciation for what we already have which I have been using a bit this last week and, as ever, marvelling at its power and simplicity ... and I didn't need tables from it for once! Regarding RTF, note that the Microsoft document that defines RTF was actually the subject of a dispute with competitors of Microsoft who claimed that it is so vague that it effectively imposes too high a barrier for others to climb to realistically interface to Word via RTF. One can only do it by supplementing the spec with substantial trial and error so its not so straight forward to develop RTF software. Having written such software for my commercial R package, RTFgen, which generates RTF from R I am quite aware of the problems. Since other commercial packages are being mentioned here I will add some info on this one too. The package is similar in concept to the hwriter and R2HTML packages on CRAN except that instead of generating HTML like those packages do it generates RTF that is directly readable by Word. Its single pass, i.e. it generates RTF directly so there is no intermediate document that might otherwise need to debugged during the development of a report. It is written in 100% R and requires no non-R software, not even Word, to generate reports making it trivial to deploy. __ 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] What is the best way to have R output tables in an MS Word format?
Another option is to use ascii package http://eusebe.github.com/ascii/. Just choose your favorite markup language (asciidochttp://www.methods.co.nz/asciidoc/, txt2tags http://txt2tags.sourceforge.net/, restructuredtexthttp://docutils.sourceforge.net/rst.html, org-mode http://orgmode.org/ or textilehttp://textism.com/tools/textile/). They all have several output options (html, latex, xml...). ascii package provides a new generic function to format R output to all these markup languages, and corresponding Sweave drivers. For example: - http://www.ncfaculty.net/dogle/fishR/bookex/AIFFD/AIFFD.html (using asciidoc) - http://learnr.wordpress.com/ (using asciidoc) - http://mpastell.com/2010/03/25/create-odf-pdf-and-html-report-from-a-single-sweave-document/ (using restructuredtext) I am using ascii package with asciidoc, html output can be converted to .doc or .odf with microsoft word or openoffice, but you can also obtain xml output. Best, david 2010/5/1 Gabor Grothendieck ggrothendi...@gmail.com On Sat, May 1, 2010 at 3:41 AM, Chris Evans chrish...@psyctc.org wrote: It's interesting to see this coming up quite soon after my posting asking for light formatting (tabs, simple tables, one day embedded graphics) in a default output pane in R. Greg Snow kindly pointed me to sword and I've tried it and it seems to work and is a bit friendlier than ODFweave or the xtable, hwriter and R2HTML options that I also know. Sweave and the whole transition to TeX/LaTeX, though I'd love it, just isn't a realistic option for me as my statistical/numerical work is done in a world in which pretty literally no-one uses TeX and I and many others who are part time with R will never have time to learn to go that way. (I promise myself I'll give it one determined try when I retire but even then all papers I submit to journals will have to be in Word or RTF.) Greg also kindly pointed me to the R-Plus GUI by Xlsolutions corp (http://www.youtube.com/watch?v=1qsv1MdB4tk) (thanks Greg) and that clearly has some of the formatted table output I'd like but it is also a huge shift towards the whole SPSS style pull down menus for everything and I really don't want that (and can't justify the price!) Come on R core team: I am sure there are a large number of users like Max Gunther and myself who would find this a huge help and I'm equally sure there are an even larger number of potential users who would change to R if we had formatted tables in the output window and the option to save that to HTML, TeX, ODF and ideally RTF. I think three quarters of the export/save primitives needed are there in these various add ons to R that alread exist and all that's needed on top of them is a simple screen rendering that would handle tables. (Graphics later or even never would be fine by me.) Yours in hope and huge appreciation for what we already have which I have been using a bit this last week and, as ever, marvelling at its power and simplicity ... and I didn't need tables from it for once! Regarding RTF, note that the Microsoft document that defines RTF was actually the subject of a dispute with competitors of Microsoft who claimed that it is so vague that it effectively imposes too high a barrier for others to climb to realistically interface to Word via RTF. One can only do it by supplementing the spec with substantial trial and error so its not so straight forward to develop RTF software. Having written such software for my commercial R package, RTFgen, which generates RTF from R I am quite aware of the problems. Since other commercial packages are being mentioned here I will add some info on this one too. The package is similar in concept to the hwriter and R2HTML packages on CRAN except that instead of generating HTML like those packages do it generates RTF that is directly readable by Word. Its single pass, i.e. it generates RTF directly so there is no intermediate document that might otherwise need to debugged during the development of a report. It is written in 100% R and requires no non-R software, not even Word, to generate reports making it trivial to deploy. __ 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] What is the best way to have R output tables in an MS Word format?
Chris, Come on R core team: I am sure there are a large number of users like Max Gunther and myself who would find this a huge help and I'm equally sure there are an even larger number of potential users who would change to R if we had formatted tables in the output window and the option to save that to HTML, TeX, ODF and ideally RTF. I think three quarters of the export/save primitives needed are there in these various add ons to R that alread exist and all that's needed on top of them is a simple screen rendering that would handle tables. (Graphics later or even never would be fine by me.) Why is it R Core's job to fulfill your wants and desires? I have a hard time thinking that very busy people would spend extra time doing something that they may or may not have a direct need for. Write it yourself or get a group of people together to do it. That what we did with odfWeave (for better or worse). If the task is beyond what you feel you can do, fund it. Yours in hope and huge appreciation for what we already have Max __ 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] What is the best way to have R output tables in an MS Word format?
I normally do not post thank-yous to listservs but this is really quite a remarkable response and I really appreciate the guidance. I am certain that this will increase the accuracy and productivity of our research. Best of wishes, Max Max Gunther, PhD Vanderbilt University Medical Center Departments of Psychiatry and Medicine Center for Health Services Research Nashville, TN www.ICUdelirium.org On Fri, Apr 30, 2010 at 5:13 PM, Max Gunther max.gunt...@vanderbilt.eduwrote: Dear R list, Our statisticians usually give us results back in a PDF format. I would like to be able to copy and past tables from R output directly into a Microsoft Word table since this will save us tons of time, be more accurate to minimize human copying errors and help us update data in our papers more easily. Do people have suggestions for the best way to do this? I am a novice to R but I do work with a couple of very knowledgeable statisticians who do most of the heavy statistical lifting for our research group. Many thanks, Max Max Gunther, PhD Vanderbilt University - Radiology Institute of Imaging Sciences - VUIIS Center for Health Services Research Nashville, TN www.ICUdelirium.org [[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] What is the best way to have R output tables in an MS Word format?
Dear R list, Our statisticians usually give us results back in a PDF format. I would like to be able to copy and past tables from R output directly into a Microsoft Word table since this will save us tons of time, be more accurate to minimize human copying errors and help us update data in our papers more easily. Do people have suggestions for the best way to do this? I am a novice to R but I do work with a couple of very knowledgeable statisticians who do most of the heavy statistical lifting for our research group. Many thanks, Max Max Gunther, PhD Vanderbilt University - Radiology Institute of Imaging Sciences - VUIIS Center for Health Services Research Nashville, TN www.ICUdelirium.org [[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] What is the best way to have R output tables in an MS Word format?
On Apr 30, 2010, at 6:13 PM, Max Gunther wrote: Dear R list, Our statisticians usually give us results back in a PDF format. I would like to be able to copy and past tables from R output directly into a Microsoft Word table since this will save us tons of time, be more accurate to minimize human copying errors and help us update data in our papers more easily. Do people have suggestions for the best way to do this? I am a novice to R but I do work with a couple of very knowledgeable statisticians who do most of the heavy statistical lifting for our research group. print.xtable in xtable package would allow output as html format. Not sure about copy-pastable into MSWord, but MSWord can surely import them. Excel is quite good about pasting HTML formated tables. Many thanks, Max Max Gunther, PhD -- David Winsemius, MD West Hartford, CT __ 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] What is the best way to have R output tables in an MS Word format?
On Fri, Apr 30, 2010 at 11:13 PM, Max Gunther max.gunt...@vanderbilt.edu wrote: Dear R list, Our statisticians usually give us results back in a PDF format. I would like to be able to copy and past tables from R output directly into a Microsoft Word table since this will save us tons of time, be more accurate to minimize human copying errors and help us update data in our papers more easily. Do people have suggestions for the best way to do this? Learn to use Sweave for your documents, and then you can create dynamic reports with the R code mixed in with your text. New data comes in? Just run Sweave again, it does the R analysis, redoes the tables, graphs etc, and out pops an updated PDF. Obviously if the conclusions change you might have to rewrite some paragraphs. It will save you tons of time, be more accurate to minimise copy-and-paste errors, and help you update everything in your papers more easily. http://www.stat.uni-muenchen.de/~leisch/Sweave/ Barry __ 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] What is the best way to have R output tables in an MS Word format?
On 04/30/2010 05:13 PM, Max Gunther wrote: Dear R list, Our statisticians usually give us results back in a PDF format. I would like to be able to copy and past tables from R output directly into a Microsoft Word table since this will save us tons of time, be more accurate to minimize human copying errors and help us update data in our papers more easily. Do people have suggestions for the best way to do this? I am a novice to R but I do work with a couple of very knowledgeable statisticians who do most of the heavy statistical lifting for our research group. Many thanks, Max Max Gunther, PhD Vanderbilt University - Radiology Institute of Imaging Sciences - VUIIS Center for Health Services Research Nashville, TN www.ICUdelirium.org [[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. See http://biostat.mc.vanderbilt.edu/SweaveConvert -- Frank E Harrell Jr Professor and ChairmanSchool of Medicine Department of Biostatistics Vanderbilt University __ 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] What is the best way to have R output tables in an MS Word format?
On Apr 30, 2010, at 5:13 PM, Max Gunther wrote: Dear R list, Our statisticians usually give us results back in a PDF format. I would like to be able to copy and past tables from R output directly into a Microsoft Word table since this will save us tons of time, be more accurate to minimize human copying errors and help us update data in our papers more easily. Do people have suggestions for the best way to do this? I am a novice to R but I do work with a couple of very knowledgeable statisticians who do most of the heavy statistical lifting for our research group. Many thanks, Max Max, I would urge you to consider using Sweave. It enables the use of R and LaTeX to facilitate reproducible research, which seems to be your goal here. You might want to talk to your campus neighbor Frank Harrell, who has extensive information on the Vanderbilt Biostatistics department web site on this: http://biostat.mc.vanderbilt.edu/twiki/bin/view/Main/StatReport Frank also has some pointers for converting between various formats: http://biostat.mc.vanderbilt.edu/twiki/bin/view/Main/SweaveConvert HTH, Marc Schwartz __ 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] What is the best way to have R output tables in an MS Word format?
When I work with clients who want to cut and paste to word or powerpoint I usually use the odfWeave package, set up a template file with the tables and graphs (possibly other output), then I run that through odfWeave and then use openoffice to save the results as a word file that I can send to the client (and they happily copy and paste from it). There is also development on Sword (still in beta) from the people who brought us Rexcel. It works similarly, but directly with word, I will probably start using it more in the future. Hope this helps, -- Gregory (Greg) L. Snow Ph.D. Statistical Data Center Intermountain Healthcare greg.s...@imail.org 801.408.8111 -Original Message- From: r-help-boun...@r-project.org [mailto:r-help-boun...@r- project.org] On Behalf Of Max Gunther Sent: Friday, April 30, 2010 4:13 PM To: r-help@r-project.org Subject: [R] What is the best way to have R output tables in an MS Word format? Dear R list, Our statisticians usually give us results back in a PDF format. I would like to be able to copy and past tables from R output directly into a Microsoft Word table since this will save us tons of time, be more accurate to minimize human copying errors and help us update data in our papers more easily. Do people have suggestions for the best way to do this? I am a novice to R but I do work with a couple of very knowledgeable statisticians who do most of the heavy statistical lifting for our research group. Many thanks, Max Max Gunther, PhD Vanderbilt University - Radiology Institute of Imaging Sciences - VUIIS Center for Health Services Research Nashville, TN www.ICUdelirium.org [[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] What is the best way to have R output tables in an MS Word format?
odfWeave might be a less daunting option here, as it can output results in some .doc formats. I have no idea how well tables would survive the translations, however. -- Bert Bert Gunter Genentech Nonclinical Statistics -Original Message- From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of Marc Schwartz Sent: Friday, April 30, 2010 3:46 PM To: Max Gunther Cc: r-help@r-project.org Subject: Re: [R] What is the best way to have R output tables in an MS Word format? On Apr 30, 2010, at 5:13 PM, Max Gunther wrote: Dear R list, Our statisticians usually give us results back in a PDF format. I would like to be able to copy and past tables from R output directly into a Microsoft Word table since this will save us tons of time, be more accurate to minimize human copying errors and help us update data in our papers more easily. Do people have suggestions for the best way to do this? I am a novice to R but I do work with a couple of very knowledgeable statisticians who do most of the heavy statistical lifting for our research group. Many thanks, Max Max, I would urge you to consider using Sweave. It enables the use of R and LaTeX to facilitate reproducible research, which seems to be your goal here. You might want to talk to your campus neighbor Frank Harrell, who has extensive information on the Vanderbilt Biostatistics department web site on this: http://biostat.mc.vanderbilt.edu/twiki/bin/view/Main/StatReport Frank also has some pointers for converting between various formats: http://biostat.mc.vanderbilt.edu/twiki/bin/view/Main/SweaveConvert HTH, Marc Schwartz __ 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] What is the best way to have R output tables in an MS Word format?
Greg Snow wrote: When I work with clients who want to cut and paste to word or powerpoint I usually use the odfWeave package, set up a template file with the tables and graphs (possibly other output), then I run that through odfWeave and then use openoffice to save the results as a word file that I can send to the client (and they happily copy and paste from it). There is also development on Sword (still in beta) from the people who brought us Rexcel. It works similarly, but directly with word, I will probably start using it more in the future. Hope this helps, Another option if you don't want to go the whole route of learning odfWeave is hwriter. Not sure how it works for a lot of text, but if you just want graphs and tables, it is very straightforward. I just used it recently and found it pretty simple. Another option for producing html is R2html but I didn't try it because I tried hwriter first and it worked for what I wanted. The advantages supplying in this form for those who just live in the Microsoft World are that you can output graphs in windows metafile format and they can see them in IE (not Firefox), and copy and paste into MS Office applications. David Scott -- _ David Scott Department of Statistics The University of Auckland, PB 92019 Auckland 1142,NEW ZEALAND Phone: +64 9 923 5055, or +64 9 373 7599 ext 85055 Email: d.sc...@auckland.ac.nz, Fax: +64 9 373 7018 Director of Consulting, Department of Statistics __ 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] What is the best way to have R output tables in an MS Word format?
Greg Snow wrote: When I work with clients who want to cut and paste to word or powerpoint I usually use the odfWeave package, set up a template file with the tables and graphs (possibly other output), then I run that through odfWeave and then use openoffice to save the results as a word file that I can send to the client (and they happily copy and paste from it). There is also development on Sword (still in beta) from the people who brought us Rexcel. It works similarly, but directly with word, I will probably start using it more in the future. Hope this helps, Another option if you don't want to go the whole route of learning odfWeave is hwriter. Not sure how it works for a lot of text, but if you just want graphs and tables, it is very straightforward. I just used it recently and found it pretty simple. Another option for producing html is R2html but I didn't try it because I tried hwriter first and it worked for what I wanted. The advantages supplying in this form for those who just live in the Microsoft World are that you can output graphs in windows metafile format and they can see them in IE (not Firefox), and copy and paste into MS Office applications. David Scott _ David Scott Department of Statistics The University of Auckland, PB 92019 Auckland 1142,NEW ZEALAND Phone: +64 9 923 5055, or +64 9 373 7599 ext 85055 Email: d.sc...@auckland.ac.nz, Fax: +64 9 373 7018 Director of Consulting, Department of Statistics __ 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] What is the best way to have R output tables in an MS Word format?
On 04/30/2010 05:45 PM, Marc Schwartz wrote: On Apr 30, 2010, at 5:13 PM, Max Gunther wrote: Dear R list, Our statisticians usually give us results back in a PDF format. I would like to be able to copy and past tables from R output directly into a Microsoft Word table since this will save us tons of time, be more accurate to minimize human copying errors and help us update data in our papers more easily. Do people have suggestions for the best way to do this? I am a novice to R but I do work with a couple of very knowledgeable statisticians who do most of the heavy statistical lifting for our research group. Many thanks, Max Max, I would urge you to consider using Sweave. It enables the use of R and LaTeX to facilitate reproducible research, which seems to be your goal here. You might want to talk to your campus neighbor Frank Harrell, who has extensive information on the Vanderbilt Biostatistics department web site on this: And note Max that we have an R clinic every Thursday at 2pm. LaTeX and Sweave are frequently discussed during the clinic. Frank http://biostat.mc.vanderbilt.edu/twiki/bin/view/Main/StatReport Frank also has some pointers for converting between various formats: http://biostat.mc.vanderbilt.edu/twiki/bin/view/Main/SweaveConvert HTH, Marc Schwartz __ 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. -- Frank E Harrell Jr Professor and ChairmanSchool of Medicine Department of Biostatistics Vanderbilt University __ 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.