The xtable package creating decimal places from nowhere?

Question

I have a data frame looks like:

         Month alpha  beta cov_td Q_BAS T_BAS volume
1 January 2008  0.18  0.23  -0.49  0.31  0.23  70533
2     February  0.22  0.25  -0.38  0.33  0.25  48367
3        March  0.41  0.05  -0.38  0.35  0.25  70584
4        April  0.37  0.15  -0.30  0.35  0.25  46666
5          May  0.27  0.15  -0.45  0.34  0.24  72829
6         June  0.72 -0.22  -0.28  0.40  0.28  60437

When I try to make this a table from the Latex with the code:

xtable(a)

The xtable generated the following output:

% latex table generated in R 3.2.1 by xtable 1.7-4 package
% Wed Aug 05 22:04:58 2015
\begin{table}[ht]
\centering
\begin{tabular}{rlrrrrrr}
  \hline
 & Month & alpha & beta & cov\_td & Q\_BAS & T\_BAS & volume \\ 
  \hline
1 & January 2008 & 0.18 & 0.23 & -0.49 & 0.31 & 0.23 & 70532.85 \\ 
  2 & February & 0.22 & 0.25 & -0.38 & 0.33 & 0.25 & 48367.30 \\ 
  3 & March & 0.41 & 0.05 & -0.38 & 0.35 & 0.25 & 70583.80 \\ 
  4 & April & 0.37 & 0.15 & -0.30 & 0.35 & 0.25 & 46665.68 \\ 
  5 & May & 0.27 & 0.15 & -0.45 & 0.34 & 0.24 & 72829.43 \\ 
  6 & June & 0.72 & -0.22 & -0.28 & 0.40 & 0.28 & 60437.14 \\

In my df, the last column are purely integers, but i am not sure why the xtable package create me two decimal places (from no where) for my integers.

The entire table is big so I can not manually correct them.

vaettchen vaettchen · Accepted Answer · 2015-08-06T04:47:24

Try

xtable( a, digits = c( 0, 0, 2, 2, 2, 2, 2, 0 ) )

% latex table generated in R 3.2.1 by xtable 1.7-4 package
% Thu Aug  6 08:36:53 2015
\begin{table}[ht]
\centering
\begin{tabular}{rlrrrrrr}
  \hline
  & Month & alpha & beta & cov\_td & Q\_BAS & T\_BAS & volume \\ 
  \hline
  1 & January 2008 & 0.18 & 0.23 & -0.49 & 0.31 & 0.23 & 70533 \\ 
  2 & February & 0.22 & 0.25 & -0.38 & 0.33 & 0.25 & 48367 \\ 
  3 & March & 0.41 & 0.05 & -0.38 & 0.35 & 0.25 & 70584 \\ 
  4 & April & 0.37 & 0.15 & -0.30 & 0.35 & 0.25 & 46666 \\ 
  5 & May & 0.27 & 0.15 & -0.45 & 0.34 & 0.24 & 72829 \\ 
  6 & June & 0.72 & -0.22 & -0.28 & 0.40 & 0.28 & 60437 \\ 
  \hline
\end{tabular}
\end{table}

As described in the xtable documentation:

digits

Numeric vector of length equal to one (in which case it will be replicated as necessary) or to the number of columns of the resulting table or matrix of thes ame size as the resulting table indicating the number of digits to display in the corresponding columns. Since the row names are printed in the first column, the length of the vector digits or the number of columns of the matrix digits is one greater than ncol(x) if x is a data.frame. Default depends of class of x.

If values of digits are negative, the corresponding values of x are displayed in scientific format with abs(digits) digits.

The xtable package creating decimal places from nowhere?

1 Answers