[Tex/LaTex] How to use a table generated by R in LaTeX

rtables

I have a LaTeX table generated like this,

\begin{table}[ht]
\begin{center}
\begin{tabular}{rrrrrrr}
\hline
& 1 & 2 & 3 & 4 & 5 & 6 \\ 
\hline
1 & 181.21 & 169.01 & 130.03 & 135.93 & 142.31 & 108.11 \\ 
2 & 106.80 & 130.71 & 186.43 & 126.46 & 167.28 & 137.91 \\ 
3 & 162.69 & 198.98 & 188.33 & 184.30 & 147.02 & 197.38 \\ 
4 & 132.42 & 150.50 & 148.69 & 134.31 & 129.52 & 172.72 \\ 
\hline
\end{tabular}
\end{center}
\end{table}

but when i compile it in MiKTeX I am getting the following error

! Undefined control sequence.
l.1 \begin
          {table}[ht]
? 
Process interrupted by user

I want a table generated from this i am compiling under pdfTeX. I am using LaTeX for first time, can anyone please give a suggestion?

Best Answer

Since you are generating the table from R, I'll assume that you are using R's xtable package to generate the table. This package has some deficiencies, but it is still quite usable.

Here's a sample R session showing how to use the package.

R-session

data(tli)
## Demonstrate aov
 ## Taken from help(aov) in R 1.1.1
 ## From Venables and Ripley (1997) p.210.
 N <- c(0,1,0,1,1,1,0,0,0,1,1,0,1,1,0,0,1,0,1,0,1,1,0,0)
 P <- c(1,1,0,0,0,1,0,1,1,1,0,0,0,1,0,1,1,0,0,1,0,1,1,0)
 K <- c(1,0,0,1,0,1,1,0,0,1,0,1,0,1,1,0,0,0,1,1,1,0,1,0)
 yield <- c(49.5,62.8,46.8,57.0,59.8,58.5,55.5,56.0,62.8,55.8,69.5,55.0,
+            62.0,48.8,45.5,44.2,52.0,51.5,49.8,48.8,57.2,59.0,53.2,56.0)
 npk <- data.frame(block=gl(6,4), N=factor(N), P=factor(P), K=factor(K), yield=yield)
 npk.aov <- aov(yield ~ block + N*P*K, npk)
 op <- options(contrasts=c("contr.helmert", "contr.treatment"))
 npk.aovE <- aov(yield ~  N*P*K + Error(block), npk)
 options(op)

Using xtable to produce the table

## Standard xtable use
print(xtable(summary(npk.aov)))

% latex table generated in R 2.12.2 by xtable 1.5-6 package
% Fri Aug 12 16:00:48 2011
\begin{table}[ht]
\begin{center}
\begin{tabular}{lrrrrr}
  \hline
 & Df & Sum Sq & Mean Sq & F value & Pr($>$F) \\ 
  \hline
block       & 5 & 343.29 & 68.66 & 4.45 & 0.0159 \\ 
  N           & 1 & 189.28 & 189.28 & 12.26 & 0.0044 \\ 
  P           & 1 & 8.40 & 8.40 & 0.54 & 0.4749 \\ 
  K           & 1 & 95.20 & 95.20 & 6.17 & 0.0288 \\ 
  N:P         & 1 & 21.28 & 21.28 & 1.38 & 0.2632 \\ 
  N:K         & 1 & 33.13 & 33.13 & 2.15 & 0.1686 \\ 
  P:K         & 1 & 0.48 & 0.48 & 0.03 & 0.8628 \\ 
  Residuals   & 12 & 185.29 & 15.44 &  &  \\ 
   \hline
\end{tabular}
\end{center}
\end{table}

The output of this command is a fragment of LaTeX code, not a complete working document. It is designed to be cut and pasted into an existing LaTeX document. This is why you got the error that you got. Minimally, the document should look like the following:

\documentclass{article}
\begin{document}
...
\end{document}

And you would insert your table code in the ... spot. You then compile this with pdflatex.

This produces the following table:

output of code

Problems with the standard xtable output

There are a number of problems with the standard xtable output.

It generates a floating {table} environment
It encloses the tabular in a {center} environment
It uses standard \hline as a separator

Although the floating table environment is useful when you are including the table into a larger LaTeX document, if you are generating a single table, it's not necessary. Furthermore, as a consequence of the floating environment, xtable encloses the table in a {center} environment, which leaves too much extra space between the table and other elements of your document. Finally, it uses \hline for the table rules, which leads to a cramped looking table.

Most of these problems are solvable, although with some loss of auto-generation.

The first two problems are connected. The print.xtable function has two arguments, one to say whether the table should be floating or not, and another to define the environment to wrap the table in. So we can modify our initial command to print the table in the following way to suppress both of these:

## Revised R print command
print(xtable(summary(npk.aov)),floating=FALSE,latex.environments=NULL)

This produces the following LaTeX code:

% latex table generated in R 2.12.2 by xtable 1.5-6 package
% Fri Aug 12 16:29:29 2011
\begin{tabular}{lrrrrr}
  \hline
 & Df & Sum Sq & Mean Sq & F value & Pr($>$F) \\ 
  \hline
block       & 5 & 343.29 & 68.66 & 4.45 & 0.0159 \\ 
  N           & 1 & 189.28 & 189.28 & 12.26 & 0.0044 \\ 
  P           & 1 & 8.40 & 8.40 & 0.54 & 0.4749 \\ 
  K           & 1 & 95.20 & 95.20 & 6.17 & 0.0288 \\ 
  N:P         & 1 & 21.28 & 21.28 & 1.38 & 0.2632 \\ 
  N:K         & 1 & 33.13 & 33.13 & 2.15 & 0.1686 \\ 
  P:K         & 1 & 0.48 & 0.48 & 0.03 & 0.8628 \\ 
  Residuals   & 12 & 185.29 & 15.44 &  &  \\ 
   \hline
\end{tabular}

If you have need for the table to float, then you should eliminate the floating=FALSE argument from the command, but leave the latex.environments=NULL.

However, this still leaves us with the cramped looking table.

Using `booktabs` to produce the table

The gold standard for high quality tables is the booktabs package, and xtable provides a boolean to do exactly that.

Final R print command

print(xtable(summary(npk.aov)),floating=FALSE,latex.environments=NULL,booktabs=TRUE)

This produces the following, much nicer table: (you need to add \usepackage{booktabs} to the preamble of your LaTeX document.)

If you want the table to float, (because you are including it in a larger LaTeX document, the you should eliminate the floating=FALSE argument, and add latex.environments=NULL). In your LaTeX source, you will need to manually add \centering right after \begin{table} to center the table.

Code:

\documentclass[a4paper,12pt]{article} 
%\usepackage{tabls} 
%\usepackage{ctable} 
\usepackage{booktabs} 
%\usepackage{longtable}

\newcommand*{\head}[1]{\textbf{#1}}%

\begin{document} \section{Table 1}

\begin{tabular}{ccc}

\multicolumn{2}{c}{\head{Input}} & \multicolumn{1}{c}{Output}\\
\head{Group A} & \head{Group B} & \head{Group C} \\
\cmidrule[2pt](lr{0.75em}){1-2} \cmidrule[1pt](r){3-3}
30 & 50 & 80\\
10 & 20 & 30\\
 1 &  5 &  6\\
\bottomrule[1.5pt]
\end{tabular} 
\end{document}

[Tex/LaTex] eqparbox causes error for \hline and \hdashline

Just adjust the loading order so that eqparbox comes before arydshln:

Sample output

\documentclass[12pt]{report}
\usepackage{algorithm}
\usepackage{algpseudocode}
\usepackage{trimspaces}
\usepackage{eqparbox}
\usepackage{arydshln}
\renewcommand{\algorithmiccomment}[1]{\hfill\eqparbox{COMMENT}{\% #1}}

\begin{document}

\begin{table}[htbp]
\caption{A simple table with horizontal and dashed horizontal lines.}
\label{tab:Simple}
\begin{center}
\begin{tabular}{l|c|c|c|c|c|c|}
      & \textbf{A} & \textbf{B} & \textbf{C} & \textbf{D} & \textbf{E} & \textbf{F} \\
    \hline
    \textbf{A} & 0 & 1 & 0 & 0 & 1 & 1 \\
    \hdashline
    \textbf{B} & 1 & 0 & 1 & 0 & 1 & 0 \\
    \hdashline
    \textbf{C} & 0 & 1 & 0 & 1 & 0 & 0 \\
    \hdashline
    \textbf{D} & 0 & 0 & 1 & 0 & 1 & 0 \\
    \hdashline
    \textbf{E} & 1 & 1 & 0 & 1 & 0 & 0 \\
    \hdashline
    \textbf{F} & 1 & 0 & 0 & 0 & 0 & 0 \\
    \hline
\end{tabular}
\end{center}
\end{table}

\begin{algorithm}
\caption{Euclid's algorithm}\label{alg:Euclid}
\begin{algorithmic}[1]
\Procedure{Euclid}{$a,b$}
\Comment{The g.c.d.\ of $a$ and $b$}
\State $r \gets a \bmod b$
\While{$r \neq 0$}
\Comment{We have the answer if $r$ is $0$}
    \State $a \gets b$
    \State $b \gets r$
    \State $r \gets a \bmod b$
\EndWhile\label{euclidendwhile}
\State \textbf{return} $b$
\Comment{The g.c.d.\ is $b$}
\EndProcedure
\end{algorithmic}
\end{algorithm}

\end{document}

Note I have also fixed the markup in your particular comments adding math mode and fixing spacing after an abbreviation dot.

Best Answer

Problems with the standard xtable output

Using booktabs to produce the table

Final R print command

Related Solutions

[Tex/LaTex] Help in creating tables, errors in code

Code:

[Tex/LaTex] eqparbox causes error for \hline and \hdashline

Related Question

Using `booktabs` to produce the table