General guide for creating publication quality tables using R, Sweave, and LaTeX

78
votes

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?

5
rsweavextable
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
in fact I had the similar question a few months back as well: 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
I personnaly find Hmisc's latex function more flexible than xtable. The Booktabs (to fine-tune the spaces) and Datatool (to read CSV files) LaTeX packages may also be useful. - Vincent Zoonekynd
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
You might have better luck asking at tex.stackexchange.com - Lorin Hochstein

5 Answers

35
votes

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.

13
votes

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
votes

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.

3
votes

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

0
votes

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