78

There are a range of tools available for creating publication quality tables using R, Sweave, and LaTeX. In particular, there are helper functions like latex in the Hmisc package, and xtable in the xtable package. I've also often written my own code so that I could have complete control over table formatting (e.g., see this example).

However, when preparing publication quality tables a range of issues often arise:

  • how and when to apply numeric formatting
  • how to precisely control alignment of columns and cells
  • how to precisely control cell borders
  • how to convert variable labels to variable names
  • and so on

Beyond the high level issues of specifying the desired table format, there are issues of implementation.

  • When should a helper function such as xtable be used?
  • Which helper function should be used in a given situation?
  • How can the default output of helper functions be customised to particular requirements?

Question

It seems to me that the above issues are deserving of a detailed textbook-style introduction.

Are there any online or offline resources that provide a detailed overview of how to produce publication quality tables using R, Sweave, and LaTeX, and that address the issues discussed above?

Jeromy Anglim
  • 33,939
  • 30
  • 115
  • 173
  • 1
    I would add `knitr` to the list. It seems to solve a lot of the integration issues with Sweave and cacheing and tikz. But good q. – Ari B. Friedman Mar 12 '12 at 02:32
  • in fact I had the similar question a few months back as well: https://github.com/yihui/knitr/issues/53 I'm eager to see how other people answer it. For me, I almost always avoid tables... when I have to use tables, I almost always use `xtable`. – Yihui Xie Mar 12 '12 at 03:31
  • I personnaly find `Hmisc`'s [`latex`](http://biostat.mc.vanderbilt.edu/wiki/pub/Main/StatReport/summary.pdf) function more flexible than `xtable`. The [Booktabs](http://www.ece.cmu.edu/~pueschel/teaching/guides/guide-tables.pdf) (to fine-tune the spaces) and [Datatool](http://www.ctan.org/tex-archive/macros/latex/contrib/datatool) (to read CSV files) LaTeX packages may also be useful. – Vincent Zoonekynd Mar 12 '12 at 07:32
  • I find `latex` from Hmisc far too complicated. Everything that I generally need to be able to do is done in `print.xtable()` and `xtable()`. If you're creating something for publication, you are ALWAYS going to have to massage anything that's generated automatically. You can create wrapper functions for xtable, print.xtable and latex that suit particular situations. – Brandon Bertelsen Mar 12 '12 at 18:29
  • 2
    You might have better luck asking at http://tex.stackexchange.com – Lorin Hochstein Apr 06 '12 at 12:29
  • I found [this PDF](http://www.statistik.tuwien.ac.at/public/filz/students/SweaveExa.pdf) and [this one](http://stat.epfl.ch/webdav/site/stat/shared/Regression/EPFL-Sweave-powerdot.pdf) to be greatly informative on the referenced issues. Unfortunately, I cannot find anything within this space that's as full-bodied and complete as [the LaTeX reference manual](http://svn.gna.org/viewcvs/*checkout*/latexrefman/trunk/latex2e.html) or the documentation on my favorite editor, [AUCTeX](https://www.gnu.org/software/auctex/manual/auctex/index.html). A style guide would also be very nice. – MrGomez Apr 06 '12 at 22:55
  • I would also add 'Brew'. I though this was a great post for learning the basics: http://learnr.wordpress.com/2009/09/09/brew-creating-repetitive-reports/ – zach Apr 11 '12 at 00:48

5 Answers5

35

Just to tie this up with a nice little bow at the time of current writing, the best existant tutorials on publication-quality tables and usage scenarios appear to be an amalgamation of these documents:

Going beyond the scope of what currently exists, you may want to ask the author of The Joy of Sweave for a document on publication-quality tables specifically. It seems like he's gone above and beyond this problem in his research. In addition to the questions you've raised, this space specifically could use a style guide that, flatly, does not currently exist.

And, as mentioned in the question errata, this is a perfect example of a question for https://tex.stackexchange.com/. I encourage you to continue to ask specific questions there when you run into any difficulties in your current projects.

Community
  • 1
  • 1
MrGomez
  • 23,788
  • 45
  • 72
13

The package stargazer can create publication-quality - incl. using templates designed to resemble existing academic journals - from commonly used R statistical functions and packages (lm, glm, plm, svyglm, survival, pscl, AER, and others). Also good for creating summary statistics tables, and can directly output data frame content as well.

4

There is a tabular function in the tables package which addresses formatting, alignment and label operations. The package has a vignette which is a good starting point.

Karsten W.
  • 17,826
  • 11
  • 69
  • 103
3

xtable has worked fine for me so far. In combination with siunitx, and when necessary, longtable, it can produce pretty effective tables, in my opinion. With packages like booktabs and caption, the aesthetics can be pleasing too.

I am not sure this level of detail was asked for by the OP, but for what it's worth, the basic implementation could be something along these lines: https://tex.stackexchange.com/questions/41067/caption-for-longtable-in-sweave/41183#41183 (my own answer to another question).

Community
  • 1
  • 1
solarchemist
  • 438
  • 3
  • 13
0

I highly recommend ConTeXt which makes use of the TABLE package. There is a Table overview in contextgarden and an exhaustive manual.

helcim
  • 789
  • 13
  • 27