25.11 Formatting Tables Using Kable

REVIEW Including a typeset table based on a dataset can be accomplished using knitr::kable(). Here we will use the larger dataset from rattle (G. Williams 2021) setting it up as a dplyr::tibble() courtesy of (Wickham et al. 2021). We will then choose specific columns and a random selection of rows to include in the table. The source text we include in our .Rnw file is listed in the following code block.

<<example_kable, echo=TRUE, results="asis">>=
set.seed(42)
library(rattle)
nobs <- nrow(weatherAUS)
obs  <- sample(nobs, 5)
vars <- 2:6
ds   <- weatherAUS[obs, vars]
kable(ds)
@ 

The result (also showing the R code since we specified echo=TRUE) is then:

# Set the seed so that results are repeatable.

set.seed(42)

# Load the package from the local library into the R session.

library(rattle)

# Record metadata for a sample of the dataset.

nobs <- nrow(weatherAUS)
obs  <- sample(nobs, 5)
vars <- 2:6
ds   <- weatherAUS[obs, vars]

# Generate the appropriate LaTeX code to display the data.

kable(ds)
Location MinTemp MaxTemp Rainfall Evaporation
Canberra -5.4 13.2 0.0 NA
Williamtown 8.4 17.6 0.0 NA
Portland 12.7 23.1 1.4 4.2
Ballarat 7.0 11.1 1.0 NA
SydneyAirport 6.9 15.4 0.0 3.8

Since we are working with a random sample and we would like the sampling to be repeatable we have used base::set.seed() to initialise the random number generator to a fixed value.

References

Wickham, Hadley, Romain François, Lionel Henry, and Kirill Müller. 2021. Dplyr: A Grammar of Data Manipulation. https://CRAN.R-project.org/package=dplyr.
Williams, Graham. 2021. Rattle: Graphical User Interface for Data Science in r. https://rattle.togaware.com/.


Your donation will support ongoing development and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984.
Copyright © 1995-2021 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0.