df2latex: Convert a data frame, correlation matrix, or factor analysis output to a LaTeX table

Description

A set of handy helper functions to convert data frames or matrices to LaTeX tables. Although Sweave is the preferred means of converting R output to LaTeX, it is sometimes useful to go directly from a data.frame or matrix to a LaTeX table. cor2latex will find the correlations and then create a lower (or upper) triangular matrix for latex output. fa2latex will create the latex commands for showing the loadings and factor intercorrelations. As the default option, tables are prepared in an approximation of APA format.

Usage

df2latex(x,digits=2,rowlabels=TRUE,apa=TRUE,short.names=TRUE,font.size ="scriptsize",
       big.mark=NULL,drop.na=TRUE, heading="A table from the psych package in R",
   caption="df2latex",label="default", char=FALSE, 
    stars=FALSE,silent=FALSE,file=NULL,append=FALSE,cut=0,big=0,abbrev=NULL,long=FALSE)
cor2latex(x,use = "pairwise", method="pearson", adjust="holm",stars=FALSE,
       digits=2,rowlabels=TRUE,lower=TRUE,apa=TRUE,short.names=TRUE,
     font.size ="scriptsize", heading="A correlation table from the psych package in R.",
      caption="cor2latex",label="default",silent=FALSE,file=NULL,append=FALSE,cut=0,big=0)
fa2latex(f,digits=2,rowlabels=TRUE,apa=TRUE,short.names=FALSE,cumvar=FALSE,
       cut=0,big=.3,alpha=.05,font.size ="scriptsize",long=FALSE,
       heading="A factor analysis table from the psych package in R",
       caption="fa2latex",label="default",silent=FALSE,file=NULL,append=FALSE) 
omega2latex(f,digits=2,rowlabels=TRUE,apa=TRUE,short.names=FALSE,cumvar=FALSE,cut=.2,
        big=.3,font.size ="scriptsize", 
        heading="An omega analysis table from the psych package in R",
        caption="omega2latex",label="default",silent=FALSE,file=NULL,append=FALSE)
irt2latex(f,digits=2,rowlabels=TRUE,apa=TRUE,short.names=FALSE,
       font.size ="scriptsize", heading="An IRT factor analysis table from R",
       caption="fa2latex",label="default",silent=FALSE,file=NULL,append=FALSE)
ICC2latex(icc,digits=2,rowlabels=TRUE,apa=TRUE,ci=TRUE,
   font.size ="scriptsize",big.mark=NULL, drop.na=TRUE,
    heading="A table from the psych package in R",
   caption="ICC2latex",label="default",char=FALSE,silent=FALSE,file=NULL,append=FALSE)

Value

A LaTeX table. Note that if showing "stars" for correlations, then one needs to use the siunitx package in LaTex. The entire LaTeX output is also returned invisibly. If using Sweave to create tables, then the silent option should be set to TRUE and the returned object saved as a file. See the last example.

Finally, some users have asked for the ability to convert these output tables into HTML. This may be done using the tth package.

Arguments

x: A data frame or matrix to convert to LaTeX. If non-square, then correlations will be found prior to printing in cor2latex
digits: Round the output to digits of accuracy. NULL for formatting character data
abbrev: How many characters should be used in column names --defaults to digits + 3
rowlabels: If TRUE, use the row names from the matrix or data.frame
short.names: Name the columns with abbreviated rownames to save space
apa: If TRUE formats table in APA style
cumvar: For factor analyses, should we show the cumulative variance accounted for?
font.size: e.g., "scriptsize", "tiny" or anyother acceptable LaTeX font size.
heading: The label appearing at the top of the table
caption: The table caption
lower: in cor2latex, just show the lower triangular matrix
f: The object returned from a factor analysis using fa or irt.fa.
label: The label for the table
big.mark: Comma separate numbers large numbers (big.mark=",")
drop.na: Do not print NA values
method: When finding correlations, which method should be used (pearson)
use: use="pairwise" is the default when finding correlations in cor2latex
adjust: If showing probabilities, which adjustment should be used (holm)
stars: Should probability 'magic astericks' be displayed in cor2latex (FALSE)
char: char=TRUE allows printing tables with character information, but does not allow for putting in commas into numbers
cut: In omega2latex, df2latex and fa2latex, do not print abs(values) < cut
big: In fa2latex and df2latex boldface those abs(values) > big
alpha: If fa has returned confidence intervals, then what values of loadings should be boldfaced?
icc: Either the output of an ICC, or the data to be analyzed.
ci: Should confidence intervals of the ICC be displayed
silent: If TRUE, do not print any output, just return silently -- useful if using Sweave
file: If specified, write the output to this file
append: If file is specified, then should we append (append=TRUE) or just write to the file
long: if TRUE, then do long tables. (requires the longtables package in latex)

Author

William Revelle with suggestions from Jason French and David Condon and Davide Morselli

Examples

Run this code

df2latex(psych::Thurstone,rowlabels=FALSE,apa=FALSE,short.names=FALSE,
        caption="Thurstone Correlation matrix")
df2latex(psych::Thurstone,heading="Thurstone Correlation matrix in APA style")

df2latex(psych::describe(psych::sat.act)[2:10],short.names=FALSE)
cor2latex(psych::Thurstone)
cor2latex(psych::sat.act,short.names=FALSE)
fa2latex(psych::fa(psych::Thurstone,3),heading="Factor analysis from R in quasi APA style")


#To convert these latex tables to HTML

#f3.lat <- fa2latex(psych::fa(psych::Thurstone,3),
#    heading="Factor analysis from R in quasi APA style")
#library(tth)
#f3.ht <- tth(f3.lat)
#print(as.data.frame(f3.ht),row.names=FALSE)

###

 #If using Sweave to create a LateX table as a separate file then set silent=TRUE
#e.g., 
#LaTex preamble 
#....
#<>= 
#f3 <- fa(Thurstone,3)
#fa2latex(f3,silent=TRUE,file='testoutput.tex')
#@
#
#\input{testoutput.tex}