Joanne Demmler Joanne Demmler - 3 months ago 16
R Question

Manipulating xtable entry and print sideways

I have successfully created a table, that I can run as follows:

library(xtable)
print(x, floating.environment='sidewaystable', inlude.rownames=F)


Please note, that the table only fits onto the page if it is rotated sideways.

I would now like to manipulate the entries to add a
databar
(see here) command around the percentages in the table

For example:

x <- print(xtable(x, caption="My table"), include.rownames=F
x <- gsub("(\\d{1,3}\\.\\d{2})","\\\\databar{\\1}",x)


The problem is that
x
is now a character vector and I can't use
print(x, floating.environment='sidewaystable', inlude.rownames=F)
any more.

I can plot the table using
cat(x, '\n')
, but of course it won't be rotated sideways then.

Any ideas?

Answer

a solution could be to put the databar before using the xtable function, like this :

d1 <- data.frame(x1 = c("A", "B", "C", "D", "E", "F"), x2 = runif(6)*100)

d1
#   x1         x2
# 1  A  0.2890781
# 2  B 99.9268717
# 3  C 70.0964751
# 4  D 90.7419767
# 5  E 58.6721176
# 6  F 38.5582817

d1$x3 <- paste0("\\databar{", round(d1$x2, 2), "}")
d1
#   x1         x2               x3
# 1  A  0.2890781  \\databar{0.29}
# 2  B 99.9268717 \\databar{99.93}
# 3  C 70.0964751  \\databar{70.1}
# 4  D 90.7419767 \\databar{90.74}
# 5  E 58.6721176 \\databar{58.67}
# 6  F 38.5582817 \\databar{38.56}

library(xtable)
print(xtable(d1), sanitize.text.function=function(x) x)
# \begin{table}[ht]
# \centering
# \begin{tabular}{rlrl}
# \hline
#  & x1 & x2 & x3 \\ 
# \hline
# 1 & A & 0.29 & \databar{0.29} \\ 
# 2 & B & 99.93 & \databar{99.93} \\ 
# 3 & C & 70.10 & \databar{70.1} \\ 
# 4 & D & 90.74 & \databar{90.74} \\ 
# 5 & E & 58.67 & \databar{58.67} \\ 
# 6 & F & 38.56 & \databar{38.56} \\ 
# \hline
# \end{tabular}
# \end{table}

Note that you have to redefine the sanitize.text.function parameter, so be careful to special characters.