[xtable.git] / pkg / vignettes / xtableGallery.Rnw

%\VignetteIndexEntry{xtable Gallery}\r
%\VignetteDepends{xtable}\r
%\VignetteKeywords{LaTeX, HTML, table}\r
%\VignettePackage{xtable}\r
% !Rnw weave = knitr\r
% \VignetteEngine{knitr::knitr}\r
%**************************************************************************\r
\documentclass{article}\r
\usepackage[a4paper,height=24cm]{geometry}\r
\usepackage{parskip}\r
\usepackage{titlesec}\r
\titleformat\subsubsection{\bfseries\itshape}{}{0pt}{}\r
\usepackage{booktabs}\r
\usepackage{longtable}\r
\usepackage{rotating}\r
\usepackage{tabularx}\r
\newcommand\code[1]{\texttt{#1}}\r
\newcommand\p{\vspace{2ex}}\r
\setcounter{tocdepth}{2}\r
\begin{document}\r
\r
\title{The xtable Gallery}\r
\author{Jonathan Swinton and others}\r
\maketitle\r
\r
\tableofcontents\r
\r
\newpage\r
\r
<<include=FALSE>>=\r
library(knitr)\r
opts_chunk$set(fig.path='figdir/fig', debug=TRUE, echo=TRUE)\r
@\r
\r
\section{Gallery}\r
\subsection{Data frame}\r
<<results='asis'>>=\r
library(xtable)\r
options(xtable.floating = FALSE)\r
data(tli)\r
xtable(tli[1:10, ])\r
@\r
\r
\subsection{Matrix}\r
<<results='asis'>>=\r
design.matrix <- model.matrix(~ sex*grade, data = tli[1:10, ])\r
xtable(design.matrix, digits = 0)\r
@\r
\r
\subsection{aov}\r
<<results='asis'>>=\r
fm1 <- aov(tlimth ~ sex + ethnicty + grade + disadvg, data = tli)\r
xtable(fm1)\r
@\r
\r
\newpage\r
\r
\subsection{lm}\r
<<results='asis'>>=\r
fm2 <- lm(tlimth ~ sex*ethnicty, data = tli)\r
xtable(fm2)\r
@\r
\r
\subsubsection{Anova table (one model)}\r
<<results='asis'>>=\r
xtable(anova(fm2))\r
@\r
\r
\subsubsection{Anova table (two models)}\r
<<results='asis'>>=\r
fm2b <- lm(tlimth ~ ethnicty, data = tli)\r
xtable(anova(fm2b, fm2))\r
@\r
\r
\subsection{glm}\r
<<results='asis'>>=\r
fm3 <- glm(disadvg ~ ethnicty*grade, data = tli, family = binomial)\r
xtable(fm3)\r
@\r
\r
\p\r
<<results='asis'>>=\r
xtable(anova(fm3))\r
@\r
\r
\subsection{prcomp}\r
<<results='asis'>>=\r
pr1 <- prcomp(USArrests)\r
xtable(pr1)\r
@\r
\r
\p\r
<<results='asis'>>=\r
xtable(summary(pr1))\r
@\r
\r
<<include=FALSE>>=\r
# pr2 <- princomp(USArrests)\r
# xtable(pr2)\r
@\r
\r
\subsection{Time series}\r
<<results='asis'>>=\r
temp.ts <- ts(cumsum(1 + round(rnorm(100), 0)),\r
              start = c(1954, 7), frequency = 12)\r
temp.table <- xtable(temp.ts, digits = 0)\r
temp.table\r
@\r
\r
<<include=FALSE>>=\r
# ## Demonstrate saving to file\r
# for(i in c("latex", "html")) {\r
#   outFileName <- paste("xtable.", ifelse(i=="latex", "tex", i), sep = "")\r
#   print(xtable(lm.D9), type = i, file = outFileName, append = TRUE,\r
#         latex.environments = NULL)\r
#   print(xtable(lm.D9), type = i, file = outFileName, append = TRUE,\r
#         latex.environments = "")\r
#   print(xtable(lm.D9), type = i, file = outFileName, append = TRUE,\r
#         latex.environments = "center")\r
#   print(xtable(anova(glm.D93, test = "Chisq")),\r
#         type = i, file = outFileName,\r
#         append = TRUE)\r
#   print(xtable(anova(glm.D93)), hline.after = c(1),\r
#         size = "small", type = i,\r
#         file = outFileName, append = TRUE)\r
#   # print(xtable(pr2), type = i, file = outFileName, append = TRUE)\r
# }\r
@\r
\r
\newpage\r
\r
\section{Helper functions for formatting}\r
The functions \code{xalign}, \code{xdigits}, and \code{xdisplay} are useful for\r
formatting tables in a sensible way. Consider the output produced by the default\r
formatting.\r
\r
<<results='asis'>>=\r
dat <- mtcars[1:3, 1:6]\r
x <- xtable(dat)\r
x\r
@\r
\r
\p\r
Now change the default alignment, digits and display using helper functions\r
\code{xalign}, \code{xdigits}, and \code{xdisplay}. This produces a better\r
format as shown below.\r
\r
<<results='asis'>>=\r
align(x) <- xalign(x)\r
digits(x) <- xdigits(x)\r
display(x) <- xdisplay(x)\r
x\r
@\r
\r
\newpage\r
\r
\section{Sanitization}\r
<<results='asis'>>=\r
insane <- data.frame(Name = c("Ampersand","Greater than","Less than",\r
                            "Underscore","Per cent","Dollar",\r
                            "Backslash","Hash","Caret","Tilde",\r
                            "Left brace","Right brace"),\r
                     Character = I(c("&",">","<","_","%","$",\r
                                     "\\","#","^","~","{","}")))\r
colnames(insane)[2] <- paste(insane[, 2], collapse = "")\r
xtable(insane)\r
@\r
\r
\p\r
Sometimes you might want to have your own sanitization function.\r
\r
<<results='asis'>>=\r
wanttex <- xtable(data.frame(Column =\r
                             paste("Value_is $10^{-",1:3,"}$", sep = "")))\r
print(wanttex, sanitize.text.function =\r
      function(str) gsub("_", "\\_", str, fixed = TRUE))\r
@\r
\r
\newpage\r
\r
\subsection{Markup in tables}\r
Markup can be included in tables, including in column and row names, by using\r
a custom \code{sanitize.text.function}.\r
\r
<<results='asis'>>=\r
mat <- round(matrix(c(0.9, 0.89, 200, 0.045, 2.0), c(1, 5)), 4)\r
rownames(mat) <- "$y_{t-1}$"\r
colnames(mat) <- c("$R^2$", "$\\bar{x}$", "F-stat", "S.E.E", "DW")\r
mat <- xtable(mat)\r
print(mat, sanitize.text.function = function(x) {x})\r
@\r
\r
% By David Dahl to demonstrate contribution from David Whitting, 2007-10-09.\r
\p\r
You can also have sanitize functions that are specific to column or\r
row names.  In the table below, the row name is not sanitized but\r
column names and table elements are.\r
\r
<<results='asis'>>=\r
money <- matrix(c("$1,000","$900","$100"), ncol = 3,\r
                dimnames = list("$\\alpha$",\r
                                c("Income (US$)","Expenses (US$)",\r
                                  "Profit (US$)")))\r
print(xtable(money), sanitize.rownames.function = function(x) {x})\r
@\r
\r
\section{Format examples}\r
\subsection{Adding a centering environment}\r
<<results='asis'>>=\r
print(xtable(anova(fm3), caption = "\\tt latex.environments = \"\""),\r
      floating = TRUE, latex.environments = "")\r
print(xtable(anova(fm3), caption = "\\tt latex.environments = \"center\""),\r
      floating = TRUE, latex.environments = "center")\r
@\r
\r
\newpage\r
\r
\subsection{Column alignment}\r
<<results='asis'>>=\r
tli.table <- xtable(tli[1:10, ])\r
align(tli.table) <- rep("r", 6)\r
tli.table\r
@\r
\r
\subsubsection{Left aligned strings with column lines}\r
<<results='asis'>>=\r
align(tli.table) <- "|rrl|l|lr|"\r
tli.table\r
@\r
\r
\subsubsection{Fixed width columns}\r
<<results='asis'>>=\r
align(tli.table) <- "|rr|lp{3cm}l|r|"\r
tli.table\r
@\r
\r
\newpage\r
\r
\subsection{Number of digits}\r
One number for all columns,\r
<<results='asis'>>=\r
display(tli.table)[c(2,6)] <- "f"\r
digits(tli.table) <- 3\r
tli.table\r
@\r
\r
\p\r
or one for each column, including the row names,\r
<<results='asis'>>=\r
digits(tli.table) <- 1:(ncol(tli)+1)\r
tli.table\r
@\r
\r
\p\r
or as a full matrix.\r
<<results='asis'>>=\r
digits(tli.table) <- matrix(0:4, nrow = 10, ncol = ncol(tli)+1)\r
tli.table\r
@\r
\r
\newpage\r
\r
\subsection{Suppress row/column names}\r
\subsubsection{Suppress row names}\r
<<results='asis'>>=\r
tli.table <- xtable(tli[1:10, ])\r
print(tli.table, include.rownames = FALSE)\r
@\r
\r
\p\r
If you want a vertical line on the left, you need to change the \code{align}\r
attribute.\r
<<results='asis'>>=\r
align(tli.table) <- "|r|r|lp{3cm}l|r|"\r
print(tli.table, include.rownames = FALSE)\r
@\r
\r
\p\r
Revert the alignment to what is was before.\r
<<>>=\r
align(tli.table) <- "|rr|lp{3cm}l|r|"\r
@\r
\r
\newpage\r
\r
\subsubsection{Suppress column names}\r
<<results='asis'>>=\r
print(tli.table, include.colnames = FALSE)\r
@\r
\r
\p\r
Note the doubled header lines which can be suppressed.\r
<<results='asis'>>=\r
print(tli.table, include.colnames = FALSE,\r
      hline.after = c(0,nrow(tli.table)))\r
@\r
\r
\subsubsection{Suppress row and column names}\r
<<results='asis'>>=\r
print(tli.table, include.colnames = FALSE, include.rownames = FALSE)\r
@\r
\r
\newpage\r
\r
\subsection{Rotate row/column names}\r
The \code{rotate.rownames} and \code{rotate.colnames} arguments can be used to\r
rotate the row and/or column names. This requires \verb|\usepackage{rotating}|\r
in the \LaTeX\ preamble.\r
\r
<<results='asis'>>=\r
print(tli.table, rotate.rownames = TRUE, rotate.colnames = TRUE)\r
@\r
\r
\newpage\r
\r
\subsection{Horizontal lines}\r
\subsubsection{Line locations}\r
Use the \code{hline.after} argument to specify the position of the\r
horizontal lines.\r
\r
<<results='asis'>>=\r
print(xtable(anova(fm3)), hline.after = c(1))\r
@\r
\r
\subsubsection{Line styles}\r
Specifying \code{booktabs = TRUE} will generate three line types. By default,\r
when no value is given for \code{hline.after}, a \verb|\toprule| will be drawn\r
above the table, a \verb|\midrule| after the table headings and a\r
\verb|\bottomrule| below the table. This requires \verb|\usepackage{booktabs}|\r
in the \LaTeX\ preamble.\r
\r
\p\r
The top and bottom rules are slightly thicker than the mid rule. The thickness\r
of the lines can be set via the \LaTeX\ lengths \verb|\heavyrulewidth| and\r
\verb|\lightrulewidth|.\r
\r
<<results='asis'>>=\r
tli.table <- xtable(tli[1:10, ])\r
print(tli.table, include.rownames = FALSE, booktabs = TRUE)\r
@\r
\r
\p\r
If \code{hline.after} includes \code{-1}, a \verb|\toprule| will be\r
drawn above the table. If \code{hline.after} includes the number of\r
rows in the table, a \verb|\bottomrule| will be drawn below the\r
table. For any other values specified in \code{hline.after}, a\r
\verb|\midrule| will be drawn after that line of the table.\r
\r
\p\r
The following table has more than one \verb|\midrule|.\r
\r
<<results='asis'>>=\r
bktbs <- xtable(matrix(1:10, ncol = 2))\r
hlines <- c(-1, 0, 1, nrow(bktbs))\r
print(bktbs, booktabs = TRUE, hline.after = hlines)\r
@\r
\r
\subsection{Table level commands}\r
<<results='asis'>>=\r
print(xtable(anova(fm3)), size = "large")\r
@\r
\r
\p\r
<<results='asis'>>=\r
print(xtable(anova(fm3)), size = "\\setlength{\\tabcolsep}{12pt}")\r
@\r
\r
\subsection{Long tables}\r
Requires \verb|\usepackage{longtable}| in the \LaTeX\ preamble.\r
\r
<<results='asis'>>=\r
x <- matrix(rnorm(1000), ncol = 10)\r
x.big <- xtable(x, caption = 'A \\code{longtable} spanning several pages')\r
print(x.big, hline.after=c(-1, 0), tabular.environment = 'longtable')\r
@\r
\r
%% The column name alignment is off in the following example.\r
%% It needs some revision before exposing it. - CR, 7/2/2012\r
%\r
%\subsubsection{Long tables with the header on each page}\r
%The \code{add.to.row} argument can be used to display the header\r
%for a long table on each page, and to add a "continued" footer\r
%on all pages except the last page.\r
%\r
%<<results=tex>>=\r
%library(xtable)\r
%x<-matrix(rnorm(1000), ncol = 10)\r
%addtorow<-list()\r
%addtorow$pos<-list()\r
%addtorow$pos[[1]]<-c(0)\r
%addtorow$command<-c(paste(\r
%    "\\hline \n",\r
%    "  \\endhead \n",\r
%    "  \\hline \n",\r
%    "  {\\footnotesize Continued on next page} \n",\r
%    "  \\endfoot \n",\r
%    "  \\endlastfoot \n", sep = ""))\r
%x.big2 <- xtable(x, label = "tabbig2",\r
%    caption = "Example of longtable with the header on each page")\r
%print(x.big2, tabular.environment = "longtable",\r
%include.rownames = FALSE, add.to.row = addtorow, hline.after = c(-1))\r
%@\r
\r
\subsection{Sideways tables}\r
Requires \verb|\usepackage{rotating}| in the LaTeX\r
preamble.  Sideways tables can't be forced in place with the \code{[H]}\r
specifier, but you can use the \verb|\clearpage| command to get them\r
fairly nearby.\r
\r
<<results='asis'>>=\r
x <- x[1:30, ]\r
x.side <- xtable(x, caption = 'A sideways table')\r
print(x.side, floating = TRUE, floating.environment = 'sidewaystable')\r
@\r
\clearpage\r
\r
\subsection{Rescaled tables}\r
Specify a \code{scalebox} value to rescale the table.\r
<<results='asis'>>=\r
x <- x[1:20, ]\r
x.rescale <- xtable(x)\r
print(x.rescale, scalebox = 0.7)\r
@\r
\r
\subsection{Table width}\r
The \code{tabularx} environment is for typesetting tables whose overall width is\r
fixed. The column alignment code \code{X} denotes columns that will be stretched\r
to achieve the desired table width. Requires \verb|\usepackage{tabularx}| in the\r
\LaTeX\ preamble.\r
\r
<<results='asis'>>=\r
df.width <- data.frame(One = c("item 1", "A"), Two = c("item 2", "B"),\r
                       Three = c("item 3", "C"), Four = c("item 4", "D"))\r
x.width <- xtable(df.width)\r
align(x.width) <- "|l|X|l|l|l|"\r
print(x.width, tabular.environment = "tabularx", width = "\\textwidth")\r
@\r
\r
\newpage\r
\r
\section{Suppressing printing}\r
By default the \code{print} method will print the \LaTeX\ or HTML to standard\r
output and also return the character strings invisibly.  The printing to\r
standard output can be suppressed by specifying \code{print.results = FALSE}.\r
\r
<<>>=\r
x.out <- print(tli.table, print.results = FALSE)\r
@\r
\r
Formatted output can also be captured without printing with the\r
\code{toLatex} method.  This function returns an object of class\r
\code{"Latex"}.\r
\r
<<>>=\r
x.ltx <- toLatex(tli.table)\r
class(x.ltx)\r
x.ltx\r
@\r
\r
\section{Acknowledgements}\r
Most of the examples in this gallery are taken from the \code{xtable}\r
documentation.\r
\r
\section{R session information}\r
<<results='asis'>>=\r
toLatex(sessionInfo())\r
@\r
\r
\end{document}\r