Tools for making latex tables in R

Question

On general request  a community wiki on producing latex tables in R  In this post I ll give an overview of the most commonly used packages and blogs with code for producing latex tables from less straight-forward objects  Please feel free to add any I missed  and or give tips  hints and little tricks on how to produce nicely formatted latex tables with R   Packages     xtable   for standard tables of most simple objects  A nice gallery with examples can be found here  memisc   tool for management of survey data  contains some tools for latex tables of  basic  regression model estimates  Hmisc contains a function latex   that creates a tex file containing the object of choice  It is pretty flexible  and can also output longtable latex tables  There s a lot of info in the help file  latex miscFuncs has a neat function  latextable  that converts matrix data with mixed alphabetic and numeric entries into a LaTeX table and prints them to the console  so they can be copied and pasted into a LaTeX document  texreg package  JSS paper  converts statistical model output into LaTeX tables  Merges multiple models  Can cope with about 50 different model types  including network models and multilevel models  lme and lme4   reporttools package  JSS paper  is another option for descriptive statistics on continuous  categorical and date variables  tables package is perhaps the most general LaTeX table making package in R for descriptive statistics stargazer package makes nice comparative statistical model summary tables   Blogs and code snippets   There is the outreg function of Paul Johnson that gives Stata-like tables in Latex for the output of regressions  This one works great  As given in an earlier question  there s a code snippet to adapt the memisc package for lme4 objects     Related questions     Suggestion for R LaTeX table creation package Rreport LaTeX quality output package sorting a table for latex output with xtable Any way to produce a LaTeX table from an lme4 mer model fit object  R data frame with stacked specified titles for latex output with xtable Automating adding tables fast to latex from R  with a very flexible and interesting syntax using the formula language

User · Answer

and Trick  3 Multiline entries in an Xtable  Generate some more data  moredata lt -data frame Nominal c 1 5   n rep 5 5            MeanLinBias signif rnorm 5  mean 0  sd 10   digits 4            LinCI paste     signif rnorm 5 mean -2  sd 5   digits 4                         signif rnorm 5  mean 2  sd 5   digits 4      sep              MeanQuadBias signif rnorm 5  mean 0  sd 10   digits 4            QuadCI paste     signif rnorm 5 mean -2  sd 5   digits 4                         signif rnorm 5  mean 2  sd 5   digits 4      sep       names moredata  lt -c  Nominal    n   Linear Model  nBias   Linear  nCI    Quadratic Model  nBias    Quadratic  nCI     Now produce our xtable  using the sanitize function to replace column names with the correct Latex newline commands  including double backslashes so R is happy    lt  lt label multilinetable  results tex  echo FALSE gt  gt   foo lt -xtable moredata  align foo   lt - c  rep  c  3   p 1 8in    p 2in    p 1 8in    p 2in     print foo               floating FALSE               include rownames FALSE              sanitize text function   function str                    str lt -gsub   n          str  fixed TRUE                   return str                              sanitize colnames function   function str                    str lt -c  Nominal    n     centering Linear Model         Bias     centering Linear      95   CI      centering Quadratic Model        Bias      centering Quadratic      95   CI   tabularnewline                   return str                        although this isn t perfect  as we need  tabularnewline so the table is formatted correctly  and Xtable still puts in a final    so we end up with a blank line below the table header

User · Answer

You can also use the latextable function from the R package micsFuncs   http   cran r-project org web packages miscFuncs index html  latextable M  where M is a matrix with mixed alphabetic and numeric entries outputs a basic LaTeX table onto screen  which can be copied and pasted into a LaTeX document  Where there are small numbers  it also replaces these with index notation  eg 1 2x10  -3

User · Answer

I have a few tricks and work arounds to interesting  features  of xtable and Latex that I ll share here   Trick  1  Removing Duplicates in Columns and Trick  2  Using Booktabs  First  load packages and define my clean function   lt  lt label first  include FALSE  echo FALSE gt  gt        library xtable      library plyr       cleanf  lt - function x                oldx  lt - c FALSE  x -1   x -length x                is the value equal to the previous              res  lt - x         res oldx   lt - NA         return res      Now generate some fake data  data lt -data frame animal sample c  elephant    dog    cat    fish    snake    100 replace TRUE               colour sample c  red    blue    green    yellow    100 replace TRUE               size rnorm 100 mean 500  sd 150               age rlnorm 100  meanlog 3  sdlog 0 5         generate a table     datatable lt -ddply data    animal  colour   function df                    return data frame size mean df size   age mean df age                     Now we can generate a table  and use the clean function to remove duplicate entries in the label columns      cleandata lt -datatable cleandata animal lt -cleanf cleandata animal  cleandata colour lt -cleanf cleandata colour       this is a normal xtable   lt  lt label normal  results tex  echo FALSE gt  gt   print      xtable          datatable                    tabular environment  longtable           latex environments c  center             floating FALSE           include rownames FALSE            this is a normal xtable where a custom function has turned duplicates to NA   lt  lt label cleandata  results tex  echo FALSE gt  gt   print      xtable          cleandata                    tabular environment  longtable           latex environments c  center             floating FALSE           include rownames FALSE            This table uses the booktab package  and needs a  usepackage booktabs  in the headers    begin table   h            centering          caption table using booktabs            label tab mytable   lt  lt label booktabs  echo F results tex gt  gt                mat  lt - xtable cleandata digits rep 2 ncol cleandata  1               foo lt -0  length mat animal               bar lt -foo  is na mat animal               print mat                     sanitize text function   function x  x                     floating FALSE                    include rownames FALSE                    hline after NULL                     add to row list pos list -1 bar nrow mat                       command c    toprule       midrule       bottomrule         could extend this with  cmidrule to have a partial line over    a sub category column and  addlinespace to add space before a total row

User · Answer

Two utilities in package taRifx can be used in concert to produce multi-row tables of nested heirarchies   library datasets  library taRifx  library xtable   test by  lt - bytable ChickWeight weight  list  ChickWeight Chick  ChickWeight Diet    colnames test by   lt - c  Diet   Chick   Mean Weight   print latex table by test by   include rownames   FALSE  include colnames   TRUE  sanitize text function   force      then add  usepackage multirow  to the preamble of your LaTeX document     for longtable support  add  tabular environment  longtable  to the print command  plus add in  floating FALSE   then  usepackage longtable  to the LaTeX preamble

User · Answer

Thanks Joris for creating this question  Hopefully  it will be made into a community wiki    The booktabs packages in latex produces nice looking tables  Here is a blog post on how to use xtable to create latex tables that use booktabs  I would also add the apsrtable package to the mix as it produces nice looking regression tables   Another Idea  Some of these packages  esp  memisc and apsrtable  allow easy extensions of the code to produce tables for different regression objects  One such example is the lme4 memisc code shown in the question  It might make sense to start a github repository to collect such code snippets  and over time maybe even add it to the memisc package  Any takers

User · Answer

I d like to add a mention of the  brew  package  You can write a brew template file which would be LaTeX with placeholders  and then  brew  it up to create a  tex file to  include or  input into your LaTeX  Something like    begin tabular  l l  A  amp   lt    fit A   gt     B  amp   lt    fit B   gt      end tabular    The brew syntax can also handle loops  so you can create a table row for each row of a dataframe

User · Answer

The stargazer package is another good option  It supports objects from many commonly used functions and packages  lm  glm  svyreg  survival  pscl  AER   as well as from zelig  In addition to regression tables  it can also output summary statistics for data frames  or directly output the content of data frames

User · Answer

Another R package for aggregating multiple regression models into LaTeX tables is texreg

[r] Tools for making latex tables in R

Examples related to r

Examples related to latex