blob: 1bf5c2459af869f8c80c4a71daa37d021b1e8eac [file] [log] [blame]
Hao Zhu014d6212017-08-07 04:20:23 +08001---
2title: "Create Awesome LaTeX Table with knitr::kable and kableExtra"
3author: "Hao Zhu"
4date: "`r Sys.Date()`"
5output:
6 pdf_document:
7 toc: true
8 toc_depth: 2
9header-includes:
10 - \usepackage{booktabs}
11 - \usepackage{longtable}
12 - \usepackage{array}
13 - \usepackage{multirow}
Hao Zhu014d6212017-08-07 04:20:23 +080014 - \usepackage{wrapfig}
Hao Zhu53e240f2017-09-04 20:04:29 -040015 - \usepackage{float}
16 - \usepackage{colortbl}
17 - \usepackage{pdflscape}
18 - \usepackage{tabu}
19 - \usepackage{threeparttable}
Hao Zhu5e4dd502018-04-05 12:01:58 -040020 - \usepackage{threeparttablex}
Hao Zhub9da01c2018-01-14 21:01:57 -050021 - \usepackage[normalem]{ulem}
Hao Zhu5e4dd502018-04-05 12:01:58 -040022 - \usepackage{makecell}
Hao Zhu62f50312019-01-15 15:19:29 -060023 - \usepackage{xcolor}
Hao Zhu014d6212017-08-07 04:20:23 +080024vignette: >
25 %\VignetteIndexEntry{Create Awesome PDF Table with knitr::kable and kableExtra}
26 %\VignetteEngine{knitr::rmarkdown}
27 %\VignetteEncoding{UTF-8}
28---
29
Hao Zhu6a1cbb52017-10-24 15:54:50 -040030\clearpage
31
Hao Zhu53e240f2017-09-04 20:04:29 -040032> Please see the package [documentation site](http://haozhu233.github.io/kableExtra) for how to use this package in HTML and more.
Hao Zhu014d6212017-08-07 04:20:23 +080033
34# Overview
Hao Zhudda2f722018-05-21 00:38:11 -040035\begin{wrapfigure}{r}{0.2\textwidth}\centering
36 \includegraphics{kableExtra_sm.png}
37\end{wrapfigure}
Hao Zhu6107f372018-05-21 00:23:26 -040038The goal of `kableExtra` is to help you build common complex tables and manipulate table styles. It imports the pipe `%>%` symbol from `magrittr` and verbalizes all the functions, so basically you can add "layers" to a kable output in a way that is similar with `ggplot2` and `plotly`.
Hao Zhu014d6212017-08-07 04:20:23 +080039
Hao Zhu62f50312019-01-15 15:19:29 -060040To learn how to generate complex tables in HTML, please visit [http://haozhu233.github.io/kableExtra/awesome_table_in_html.html](http://haozhu233.github.io/kableExtra/awesome_table_in_html.html).
Hao Zhu014d6212017-08-07 04:20:23 +080041
42# Installation
43```r
44install.packages("kableExtra")
45
46# For dev version
47# install.packages("devtools")
48devtools::install_github("haozhu233/kableExtra")
49```
50
51# Getting Started
52Here we are using the first few columns and rows from dataset `mtcars`
Hao Zhu62f50312019-01-15 15:19:29 -060053```{r, echo = F}
54options(kableExtra.latex.load_packages = F)
55```
56
Hao Zhu014d6212017-08-07 04:20:23 +080057```{r}
58library(knitr)
59library(kableExtra)
60dt <- mtcars[1:5, 1:6]
61```
62
Hao Zhu6107f372018-05-21 00:23:26 -040063When you are using `kable()`, if you don't specify `format`, by default it will generate a markdown table and let pandoc handle the conversion from markdown to HTML/PDF. This is the most favorable approach to render most simple tables as it is format independent. If you switch from HTML to pdf, you basically don't need to change anything in your code. However, markdown doesn't support complex table. For example, if you want to have a double-row header table, markdown just cannot provide you the functionality you need. As a result, when you have such a need, you should **define `format` in `kable()`** as either "html" or "latex". *You can also define a global option at the beginning using `options(knitr.table.format = "latex")` so you don't repeat the step every time.* **In this tutorial, I’ll still put format="latex" in the function in
64case users just want to quickly replicate the results. In practice, you don't need to define those formats.**
65
66**Starting from `kableExtra` 0.9.0**, when you load this package (`library(kableExtra)`), `r text_spec("it will automatically set up the global option 'knitr.table.format' based on your current environment", bold = T, color = "red")`. Unless you are rendering a PDF, `kableExtra` will try to render a HTML table for you. **You no longer need to manually set either the global option or the `format` option in each `kable()` function**. I'm still including the explanation above here in this vignette so you can understand what is going on behind the scene. Note that this is only an global option. You can manually set any format in `kable()` whenever you want. I just hope you can enjoy a peace of mind in most of your time.
67
68You can disable this behavior by setting `options(kableExtra.auto_format = FALSE)` before you load `kableExtra`.
Hao Zhu014d6212017-08-07 04:20:23 +080069
70```{r}
Hao Zhu6107f372018-05-21 00:23:26 -040071# If you are using kableExtra < 0.9.0, you are recommended to set a global option first.
72# options(knitr.table.format = "latex")
Hao Zhu014d6212017-08-07 04:20:23 +080073## If you don't define format here, you'll need put `format = "latex"`
74## in every kable function.
75```
76
Hao Zhu53e240f2017-09-04 20:04:29 -040077## LaTeX packages used in this package
78If you are using a recent version of rmarkdown, you are recommended to load this package entirely via `library(kableExtra)` or `require(kableExtra)` because this package will load all necessary LaTeX packages, such as `booktabs` or `multirow`, for you automatically. Note that, if you are calling functions from `kableExtra` via `kableExtra::kable_styling()` or if you put `library(kableExtra)` in a separate R file that is **sourced** by the rmarkdown document, these packages won't be loaded. Furthermore, you can suppress this auto-loading behavior by setting a global option `kableExtra.latex.load_packages` to be `FALSE` before you load `kableExtra`.
79
80```{r, eval = FALSE}
81# Not evaluated. Ilustration purpose
Hao Zhu5e4dd502018-04-05 12:01:58 -040082options(kableExtra.latex.load_packages = FALSE)
Hao Zhu53e240f2017-09-04 20:04:29 -040083library(kableExtra)
84```
85
Hao Zhu6107f372018-05-21 00:23:26 -040086If you are using R Sweave, beamer, R package vignette template, tufte or some customized rmarkdown templates, you can put the following meta data into the `yaml` section. If you are familar with LaTeX and you know what you are doing, feel free to remove unnecessary packages from the list.
Hao Zhu53e240f2017-09-04 20:04:29 -040087
Hao Zhu6290fdd2017-10-24 00:10:32 -040088```
Hao Zhu53e240f2017-09-04 20:04:29 -040089header-includes:
90 - \usepackage{booktabs}
91 - \usepackage{longtable}
92 - \usepackage{array}
93 - \usepackage{multirow}
Hao Zhu53e240f2017-09-04 20:04:29 -040094 - \usepackage{wrapfig}
95 - \usepackage{float}
96 - \usepackage{colortbl}
97 - \usepackage{pdflscape}
98 - \usepackage{tabu}
99 - \usepackage{threeparttable}
Hao Zhu5e4dd502018-04-05 12:01:58 -0400100 - \usepackage{threeparttablex}
Hao Zhub9da01c2018-01-14 21:01:57 -0500101 - \usepackage[normalem]{ulem}
Hao Zhu5e4dd502018-04-05 12:01:58 -0400102 - \usepackage{makecell}
Hao Zhu62f50312019-01-15 15:19:29 -0600103 - \usepackage{xcolor}
Hao Zhu53e240f2017-09-04 20:04:29 -0400104```
105
Hao Zhu62f50312019-01-15 15:19:29 -0600106Note: `kableExtra` was using `xcolor` for alternative row color before 1.0. However, the recent updates in `fancyvbr` causes a clash in `xcolor` option. Therefore, we removed the `xcolor` dependency in version 1.0 and started to rely on `colortbl` completely. If you experience any issues, please report on github.
107
Hao Zhu014d6212017-08-07 04:20:23 +0800108## Plain LaTeX
109Plain LaTeX table looks relatively ugly in 2017.
110```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400111# Again, with kableExtra >= 0.9.0, `format = "latex"` is automatically defined
112# when this package gets loaded. Otherwise, you still need to define formats
113kable(dt)
114# Same: kable(dt, "latex")
Hao Zhu014d6212017-08-07 04:20:23 +0800115```
116
117## LaTeX table with booktabs
Hao Zhu6107f372018-05-21 00:23:26 -0400118Similar to Bootstrap in HTML, in LaTeX, you can also use a trick to make your table look prettier as well. The different part is that, this time you don't need to pipe kable outputs to another function. Instead, you should call `booktabs = T` directly in `kable()`.
119
Hao Zhu014d6212017-08-07 04:20:23 +0800120```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400121kable(dt, "latex", booktabs = T)
Hao Zhu014d6212017-08-07 04:20:23 +0800122```
123
124# Table Styles
125`kable_styling` in LaTeX uses the same syntax and structure as `kable_styling` in HTML. However, instead of `bootstrap_options`, you should specify `latex_options` instead.
126
127## LaTeX options
128Similar with `bootstap_options`, `latex_options` is also a charter vector with a bunch of options including `striped`, `hold_position` and `scale_down`.
129
130### Striped
131Even though in the LaTeX world, people usually call it `alternative row colors` but here I'm using its bootstrap name for consistency. Note that to make it happen, LaTeX package `xcolor` is required to be loaded. In an environment like rmarkdown::pdf_document (rmarkdown 1.4.0 +), `kable_styling` will load it automatically if `striped` is enabled. However, in other cases, you probably need to import that package by yourself.
132```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400133kable(dt, "latex", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800134 kable_styling(latex_options = "striped")
135```
136
137### Hold position
Hao Zhu4840bc92017-09-15 15:55:05 -0400138If you provide a table caption in `kable()`, it will put your LaTeX tabular in a `table` environment, unless you are using `longtable`. A `table` environment will automatically find the best place (it thinks) to put your table. However, in many cases, you do want your table to appear in a position you want it to be. In this case, you can use this `hold_position` options here.
Hao Zhu014d6212017-08-07 04:20:23 +0800139```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400140kable(dt, "latex", caption = "Demo table", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800141 kable_styling(latex_options = c("striped", "hold_position"))
142```
143
jjchern3dca6f42018-04-24 17:53:50 -0500144If you find `hold_position` is not powerful enough to literally PIN your table in the exact position, you may want to use `HOLD_position`, which is a more powerful version of this feature. For those who are familiar with LaTeX, `hold_position` uses `[!h]` and `HOLD_position` uses `[H]` and the `float` package.
Hao Zhu4840bc92017-09-15 15:55:05 -0400145
Hao Zhu014d6212017-08-07 04:20:23 +0800146### Scale down
jjchern3dca6f42018-04-24 17:53:50 -0500147When you have a wide table that will normally go out of the page, and you want to scale down the table to fit the page, you can use the `scale_down` option here. Note that, if your table is too small, it will also scale up your table. It was named in this way only because scaling up isn't very useful in most cases.
Hao Zhu014d6212017-08-07 04:20:23 +0800148```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400149kable(cbind(dt, dt, dt), "latex", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800150 kable_styling(latex_options = c("striped", "scale_down"))
151```
152```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400153kable(cbind(dt), "latex", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800154 kable_styling(latex_options = c("striped", "scale_down"))
155```
156
157### Repeat header in longtable
jjchern3dca6f42018-04-24 17:53:50 -0500158In `kableExtra` 0.3.0 or above, a new option `repeat_header` was introduced into `kable_styling`. It will add header rows to longtables spanning multiple pages. For table captions on following pages, it will append *"continued"* to the caption to differentiate. If you need texts other than *"(continued)"* (for example, other languages), you can specify it using `kable_styling(..., repeat_header_text = "xxx")`. If you want to completely replace the table caption instead of appending, you can specify it in the option `repeat_header_method`.
Hao Zhu014d6212017-08-07 04:20:23 +0800159```{r}
160long_dt <- rbind(mtcars, mtcars)
161
Hao Zhu6107f372018-05-21 00:23:26 -0400162kable(long_dt, "latex", longtable = T, booktabs = T, caption = "Longtable") %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800163 add_header_above(c(" ", "Group 1" = 5, "Group 2" = 6)) %>%
164 kable_styling(latex_options = c("repeat_header"))
165```
166
167
168## Full width?
Hao Zhu4840bc92017-09-15 15:55:05 -0400169If you have a small table and you want it to spread wide on the page, you can try the `full_width` option. Unlike `scale_down`, it won't change your font size. You can use `column_spec`, which will be explained later, together with `full_width` to achieve the best result.
Hao Zhu014d6212017-08-07 04:20:23 +0800170```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400171kable(dt, "latex", booktabs = T) %>%
Hao Zhu4840bc92017-09-15 15:55:05 -0400172 kable_styling(full_width = T) %>%
173 column_spec(1, width = "8cm")
Hao Zhu014d6212017-08-07 04:20:23 +0800174```
175
176## Position
177Table Position only matters when the table doesn't have `full_width`. You can choose to align the table to `center` or `left` side of the page. The default value of position is `center`.
178
179Note that even though you can select to `right` align your table but the table will actually be centered. Somehow it is very difficult to right align a table in LaTeX (since it's not very useful in the real world?). If you know how to do it, please send out an issue or PR and let me know.
180```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400181kable(dt, "latex", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800182 kable_styling(position = "center")
183```
184
185Becides these three common options, you can also wrap text around the table using the `float-left` or `float-right` options. Note that, like `striped`, this feature will load another non-default LaTeX package `wrapfig` which requires rmarkdown 1.4.0 +. If you rmarkdown version < 1.4.0, you need to load the package through a customed LaTeX template file.
186```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400187kable(dt, "latex", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800188 kable_styling(position = "float_right")
189```
190Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras sit amet mauris in ex ultricies elementum vel rutrum dolor. Phasellus tempor convallis dui, in hendrerit mauris placerat scelerisque. Maecenas a accumsan enim, a maximus velit. Pellentesque in risus eget est faucibus convallis nec at nulla. Phasellus nec lacinia justo. Morbi fermentum, orci id varius accumsan, nibh neque porttitor ipsum, consectetur luctus risus arcu ac ex. Aenean a luctus augue. Suspendisse et auctor nisl. Suspendisse cursus ultrices quam non vulputate. Phasellus et pharetra neque, vel feugiat erat. Sed feugiat elit at mauris commodo consequat. Sed congue lectus id mattis hendrerit. Mauris turpis nisl, congue eget velit sed, imperdiet convallis magna. Nam accumsan urna risus, non feugiat odio vehicula eget.
191
192## Font Size
193If one of your tables is huge and you want to use a smaller font size for that specific table, you can use the `font_size` option.
194```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400195kable(dt, "latex", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800196 kable_styling(font_size = 7)
197```
198
199# Column / Row Specification
200## Column spec
jjchern3dca6f42018-04-24 17:53:50 -0500201When you have a table with lots of explanatory texts, you may want to specify the column width for different column, since the auto adjust in HTML may not work in its best way while basic LaTeX table is really bad at handling text wrapping. Also, sometimes, you may want to highlight a column (e.g., a "Total" column) by making it bold. In these scenarios, you can use `column_spec()`. You can find an example below.
Hao Zhu014d6212017-08-07 04:20:23 +0800202```{r}
203text_tbl <- data.frame(
204 Items = c("Item 1", "Item 2", "Item 3"),
205 Features = c(
206 "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin vehicula tempor ex. Morbi malesuada sagittis turpis, at venenatis nisl luctus a. ",
207 "In eu urna at magna luctus rhoncus quis in nisl. Fusce in velit varius, posuere risus et, cursus augue. Duis eleifend aliquam ante, a aliquet ex tincidunt in. ",
208 "Vivamus venenatis egestas eros ut tempus. Vivamus id est nisi. Aliquam molestie erat et sollicitudin venenatis. In ac lacus at velit scelerisque mattis. "
209 )
210)
211
Hao Zhu6107f372018-05-21 00:23:26 -0400212kable(text_tbl, "latex", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800213 kable_styling(full_width = F) %>%
Hao Zhufb0a6d42017-09-07 17:21:02 -0400214 column_spec(1, bold = T, color = "red") %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800215 column_spec(2, width = "30em")
216```
217
218## Row spec
jjchern3dca6f42018-04-24 17:53:50 -0500219Similar with `column_spec`, you can define specifications for rows. Currently, you can either bold or italicize an entire row. Note that, similar to other row-related functions in `kableExtra`, for the position of the target row, you don't need to count in header rows or the group labeling rows.
Hao Zhu014d6212017-08-07 04:20:23 +0800220
221```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400222kable(dt, "latex", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800223 kable_styling("striped", full_width = F) %>%
Hao Zhu834cf562017-09-07 17:54:32 -0400224 column_spec(7, border_left = T, bold = T) %>%
Hao Zhub9da01c2018-01-14 21:01:57 -0500225 row_spec(1, strikeout = T) %>%
Hao Zhu4840bc92017-09-15 15:55:05 -0400226 row_spec(3:5, bold = T, color = "white", background = "black")
Hao Zhu014d6212017-08-07 04:20:23 +0800227```
228
Hao Zhu6290fdd2017-10-24 00:10:32 -0400229## Header Rows
230One special case of `row_spec` is that you can specify the format of the header row via `row_spec(row = 0, ...)`.
231```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400232kable(dt, "latex", booktabs = T, align = "c") %>%
Hao Zhu6290fdd2017-10-24 00:10:32 -0400233 kable_styling(latex_options = "striped", full_width = F) %>%
234 row_spec(0, angle = 45)
235```
236
237
238
239# Cell/Text Specification
jjchern3dca6f42018-04-24 17:53:50 -0500240Function `cell_spec` is introduced in version 0.6.0 of `kableExtra`. Unlike `column_spec` and `row_spec`, **this function is designed to be used before the data.frame gets into the `kable` function**. Comparing with figuring out a list of 2 dimensional indexes for targeted cells, this design is way easier to learn and use, and it fits perfectly well with `dplyr`'s `mutate` and `summarize` functions. With this design, there are two things to be noted:
Hao Zhu6290fdd2017-10-24 00:10:32 -0400241* Since `cell_spec` generates raw `HTML` or `LaTeX` code, make sure you remember to put `escape = FALSE` in `kable`. At the same time, you have to escape special symbols including `%` manually by yourself
242* `cell_spec` needs a way to know whether you want `html` or `latex`. You can specify it locally in function or globally via the `options(knitr.table.format = "latex")` method as suggested at the beginning. If you don't provide anything, this function will output as HTML by default.
243
244Currently, `cell_spec` supports features including bold, italic, monospace, text color, background color, align, font size & rotation angle. More features may be added in the future. Please see function documentations as reference.
245
246## Conditional logic
247It is very easy to use `cell_spec` with conditional logic. Here is an example.
248```{r, message=FALSE, warning=FALSE}
249library(dplyr)
250mtcars[1:10, 1:2] %>%
251 mutate(
252 car = row.names(.),
253 # You don't need format = "latex" if you have ever defined options(knitr.table.format)
254 mpg = cell_spec(mpg, "latex", color = ifelse(mpg > 20, "red", "blue")),
255 cyl = cell_spec(cyl, "latex", color = "white", align = "c", angle = 45,
256 background = factor(cyl, c(4, 6, 8),
257 c("#666666", "#999999", "#BBBBBB")))
258 ) %>%
259 select(car, mpg, cyl) %>%
260 kable("latex", escape = F, booktabs = T, linesep = "")
261```
262
263## Visualize data with Viridis Color
Hao Zhu07305132017-10-24 15:41:49 -0400264This package also comes with a few helper functions, including `spec_color`, `spec_font_size` & `spec_angle`. These functions can rescale continuous variables to certain scales. For example, function `spec_color` would map a continuous variable to any [viridis color palettes](https://CRAN.R-project.org/package=viridisLite). It offers a very visually impactful representation in a tabular format.
Hao Zhu6290fdd2017-10-24 00:10:32 -0400265
266```{r}
267iris[1:10, ] %>%
268 mutate_if(is.numeric, function(x) {
269 cell_spec(x, "latex", bold = T, color = spec_color(x, end = 0.9),
270 font_size = spec_font_size(x))
271 }) %>%
272 mutate(Species = cell_spec(
273 Species, "latex", color = "white", bold = T,
274 background = spec_color(1:10, end = 0.9, option = "A", direction = -1)
275 )) %>%
276 kable("latex", escape = F, booktabs = T, linesep = "", align = "c")
277```
278
279In the example above, I'm using the `mutate` functions from `dplyr`. You don't have to use it. Base R solutions like `iris$Species <- cell_spec(iris$Species, color = "red")` also works.
280
281## Text Specification
282If you check the results of `cell_spec`, you will find that this function does nothing more than wrapping the text with appropriate HTML/LaTeX formatting syntax. The result of this function is just a vector of character strings. As a result, when you are writing a `rmarkdown` document or write some text in shiny apps, if you need extra markups other than **bold** or *italic*, you may use this function to `r text_spec("color", color = "red")`, `r text_spec("change font size ", font_size = 16)` or `r text_spec("rotate", angle = 30)` your text.
283
284An aliased function `text_spec` is also provided for a more literal writing experience. The only difference is that in LaTeX, unless you specify `latex_background_in_cell = FALSE` (default is `TRUE`) in `cell_spec`, it will define cell background color as `\cellcolor{}`, which doesn't work outside of a table, while for `text_spec`, the default value for `latex_background_in_cell` is `FALSE`.
285
286```{r}
287sometext <- strsplit(paste0(
288 "You can even try to make some crazy things like this paragraph. ",
Hao Zhu6a1cbb52017-10-24 15:54:50 -0400289 "It may seem like a useless feature right now but it's so cool ",
290 "and nobody can resist. ;)"
Hao Zhu6290fdd2017-10-24 00:10:32 -0400291), " ")[[1]]
292text_formatted <- paste(
293 text_spec(sometext, "latex", color = spec_color(1:length(sometext), end = 0.9),
294 font_size = spec_font_size(1:length(sometext), begin = 5, end = 20)),
295 collapse = " ")
296
297# To display the text, type `r text_formatted` outside of the chunk
298```
299`r text_formatted`
300
Hao Zhu014d6212017-08-07 04:20:23 +0800301# Grouped Columns / Rows
302## Add header rows to group columns
303Tables with multi-row headers can be very useful to demonstrate grouped data. To do that, you can pipe your kable object into `add_header_above()`. The header variable is supposed to be a named character with the names as new column names and values as column span. For your convenience, if column span equals to 1, you can ignore the `=1` part so the function below can be written as `add_header_above(c(" ", "Group 1" = 2, "Group 2" = 2, "Group 3" = 2)).
304```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400305kable(dt, "latex", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800306 kable_styling() %>%
307 add_header_above(c(" " = 1, "Group 1" = 2, "Group 2" = 2, "Group 3" = 2))
308```
309
Hao Zhu6290fdd2017-10-24 00:10:32 -0400310In fact, if you want to add another row of header on top, please feel free to do so. Also, since kableExtra 0.3.0, you can specify `bold` & `italic` as you do in `row_spec()`.
Hao Zhu014d6212017-08-07 04:20:23 +0800311```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400312kable(dt, "latex", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800313 kable_styling(latex_options = "striped") %>%
314 add_header_above(c(" ", "Group 1" = 2, "Group 2" = 2, "Group 3" = 2)) %>%
315 add_header_above(c(" ", "Group 4" = 4, "Group 5" = 2)) %>%
316 add_header_above(c(" ", "Group 6" = 6), bold = T, italic = T)
317```
318
319## Group rows via labeling
320Sometimes we want a few rows of the table being grouped together. They might be items under the same topic (e.g., animals in one species) or just different data groups for a categorical variable (e.g., age < 40, age > 40). With the new function `group_rows()` in `kableExtra`, this kind of task can be completed in one line. Please see the example below. Note that when you count for the start/end rows of the group, you don't need to count for the header rows nor other group label rows. You only need to think about the row numbers in the "original R dataframe".
321```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400322kable(mtcars[1:10, 1:6], "latex", caption = "Group Rows", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800323 kable_styling() %>%
324 group_rows("Group 1", 4, 7) %>%
325 group_rows("Group 2", 8, 10)
326```
327
328In case some users need it, you can define your own gapping spaces between the group labeling row and previous rows. The default value is `0.5em`.
329```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400330kable(dt, "latex", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800331 group_rows("Group 1", 4, 5, latex_gap_space = "2em")
332```
333
Hao Zhu4840bc92017-09-15 15:55:05 -0400334If you prefer to build multiple groups in one step, you can use the short-hand `index` option. Basically, you can use it in the same way as you use `add_header_above`. However, since `group_row` only support one layer of grouping, you can't add multiple layers of grouping header as you can do in `add_header_above`.
335```{r, eval=FALSE}
Hao Zhu6107f372018-05-21 00:23:26 -0400336kable(mtcars[1:10, 1:6], "latex", caption = "Group Rows", booktabs = T) %>%
Hao Zhu4840bc92017-09-15 15:55:05 -0400337 kable_styling() %>%
338 group_rows(index=c(" " = 3, "Group 1" = 4, "Group 2" = 3))
339# Not evaluated. The code above should have the same result as the first example in this section.
340```
341
Hao Zhu5e4dd502018-04-05 12:01:58 -0400342Note that `kable` has a relatively special feature to handle `align` and it may bring troubles to you if you are not using it correctly. In the documentation of the `align` argument of `kable`, it says:
343
344> If `length(align) == 1L`, the string will be expanded to a vector of individual letters, e.g. `'clc'` becomes `c('c', 'l', 'c')`, **unless the output format is LaTeX**.
345
346For example,
347```{r, eval=F}
348kable(mtcars[1:2, 1:2], "latex", align = c("cl"))
349# \begin{tabular}{l|cl|cl} # Note the column alignment here
350# \hline
351# & mpg & cyl\\
352# ...
353```
354
jjchern3dca6f42018-04-24 17:53:50 -0500355LaTeX, somehow shows surprisingly high tolerance on that, which is quite unusual. As a result, it won't throw an error if you are just using `kable` to make some simple tables. However, when you use `kableExtra` to make some advanced modification, it will start to throw some bugs. As a result, please try to form a habit of using a vector in the `align` argument for `kable` (tip: you can use `rep` function to replicate elements. For example, `c("c", rep("l", 10))`).
Hao Zhu5e4dd502018-04-05 12:01:58 -0400356
Hao Zhu014d6212017-08-07 04:20:23 +0800357## Row indentation
Hao Zhu6107f372018-05-21 00:23:26 -0400358Unlike `group_rows()`, which will insert a labeling row, sometimes we want to list a few sub groups under a total one. In that case, `add_indent()` is probably more appropriate.
Hao Zhu014d6212017-08-07 04:20:23 +0800359For advanced users, you can even define your own css for the group labeling.
360```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400361kable(dt, "latex", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800362 add_indent(c(1, 3, 5))
363```
364
365## Group rows via multi-row cell
Hao Zhu6107f372018-05-21 00:23:26 -0400366Function `group_rows` is great for showing simple structural information on rows but sometimes people may need to show structural information with multiple layers. When it happens, you may consider using `collapse_rows` instead, which will put repeating cells in columns into multi-row cells.
Hao Zhub9da01c2018-01-14 21:01:57 -0500367
Hao Zhuec169362018-05-21 01:05:29 -0400368In LaTeX, `collapse_rows` adds some extra hlines to help differentiate groups. You can customize this behavior using the `latex_hline` argument. You can choose from `full` (default), `major` and `none`. Vertical alignment of cells is controlled by the `valign` option. You can choose from "top", "middle"(default) and "bottom". Be cautious that the vertical alignment option was only introduced in multirow in 2016. If you are using a legacy LaTeX distribution, you will run into trouble if you set `valign` to be either "top" or "bottom".
Hao Zhu014d6212017-08-07 04:20:23 +0800369
370```{r}
371collapse_rows_dt <- data.frame(C1 = c(rep("a", 10), rep("b", 5)),
372 C2 = c(rep("c", 7), rep("d", 3), rep("c", 2), rep("d", 3)),
373 C3 = 1:15,
374 C4 = sample(c(0,1), 15, replace = TRUE))
Hao Zhu6107f372018-05-21 00:23:26 -0400375kable(collapse_rows_dt, "latex", booktabs = T, align = "c") %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800376 column_spec(1, bold=T) %>%
Hao Zhuec169362018-05-21 01:05:29 -0400377 collapse_rows(columns = 1:2, latex_hline = "major", valign = "middle")
Hao Zhu014d6212017-08-07 04:20:23 +0800378```
379
Hao Zhu62f50312019-01-15 15:19:29 -0600380Right now, you can't automatically make striped rows based on collapsed rows but you can do it manually via the `extra_latex_after` option in `row_spec`. This feature is not officially supported. I'm only document it here if you want to give it a try.
Hao Zhu014d6212017-08-07 04:20:23 +0800381```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400382kable(collapse_rows_dt[-1], "latex", align = "c", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800383 column_spec(1, bold = T, width = "5em") %>%
Hao Zhu6107f372018-05-21 00:23:26 -0400384 row_spec(c(1:7, 11:12) - 1, extra_latex_after = "\\rowcolor{gray!6}") %>%
385 collapse_rows(1, latex_hline = "none")
Hao Zhu014d6212017-08-07 04:20:23 +0800386```
387
georgeguieaeb0cd2018-03-30 17:39:46 -0500388When there are too many layers, sometimes the table can become too wide. You can choose to stack the first few layers by setting `row_group_label_position` to `stack`.
389
390
391```{r}
392collapse_rows_dt <- expand.grid(
393 Country = sprintf('Country with a long name %s', c('A', 'B')),
394 State = sprintf('State %s', c('a', 'b')),
395 City = sprintf('City %s', c('1', '2')),
396 District = sprintf('District %s', c('1', '2'))
397) %>% arrange(Country, State, City) %>%
398 mutate_all(as.character) %>%
399 mutate(C1 = rnorm(n()),
400 C2 = rnorm(n()))
401
Hao Zhu6107f372018-05-21 00:23:26 -0400402kable(collapse_rows_dt, "latex",
georgeguieaeb0cd2018-03-30 17:39:46 -0500403 booktabs = T, align = "c", linesep = '') %>%
404 collapse_rows(1:3, row_group_label_position = 'stack')
405```
406
Hao Zhu62f50312019-01-15 15:19:29 -0600407To better distinguish different layers, you can format the each layer using `row_group_label_fonts`. You can also customize the hlines to better differentiate groups.
georgeguieaeb0cd2018-03-30 17:39:46 -0500408
409```{r}
410row_group_label_fonts <- list(
411 list(bold = T, italic = T),
412 list(bold = F, italic = F)
413 )
Hao Zhu6107f372018-05-21 00:23:26 -0400414kable(collapse_rows_dt, "latex",
georgeguieaeb0cd2018-03-30 17:39:46 -0500415 booktabs = T, align = "c", linesep = '') %>%
416 column_spec(1, bold=T) %>%
417 collapse_rows(1:3, latex_hline = 'custom', custom_latex_hline = 1:3,
418 row_group_label_position = 'stack',
419 row_group_label_fonts = row_group_label_fonts)
420```
421
Hao Zhu014d6212017-08-07 04:20:23 +0800422# Table Footnote
Hao Zhu014d6212017-08-07 04:20:23 +0800423
Hao Zhub9da01c2018-01-14 21:01:57 -0500424> Now it's recommended to use the new `footnote` function instead of `add_footnote` to make table footnotes.
425
426Documentations for `add_footnote` can be found [here](http://haozhu233.github.io/kableExtra/legacy_features#add_footnote).
427
Hao Zhu6107f372018-05-21 00:23:26 -0400428There are four notation systems in `footnote`, namely `general`, `number`, `alphabet` and `symbol`. The last three types of footnotes will be labeled with corresponding marks while `general` won't be labeled. You can pick any one of these systems or choose to display them all for fulfilling the APA table footnotes requirements.
Hao Zhu014d6212017-08-07 04:20:23 +0800429```{r}
Hao Zhub9da01c2018-01-14 21:01:57 -0500430kable(dt, "latex", align = "c") %>%
431 kable_styling(full_width = F) %>%
432 footnote(general = "Here is a general comments of the table. ",
433 number = c("Footnote 1; ", "Footnote 2; "),
434 alphabet = c("Footnote A; ", "Footnote B; "),
435 symbol = c("Footnote Symbol 1; ", "Footnote Symbol 2")
436 )
Hao Zhu014d6212017-08-07 04:20:23 +0800437```
438
Hao Zhu6107f372018-05-21 00:23:26 -0400439You can also specify title for each category by using the `***_title` arguments. Default value for `general_title` is "Note: " and "" for the rest three. You can also change the order using `footnote_order`. You can even display footnote as chunk texts (default is as a list) using `footnote_as_chunk`. The font format of the titles are controlled by `title_format` with options including "italic" (default), "bold" and "underline".
Hao Zhub9da01c2018-01-14 21:01:57 -0500440
Hao Zhu014d6212017-08-07 04:20:23 +0800441```{r}
Hao Zhub9da01c2018-01-14 21:01:57 -0500442kable(dt, "latex", align = "c", booktabs = T) %>%
443 footnote(general = "Here is a general comments of the table. ",
444 number = c("Footnote 1; ", "Footnote 2; "),
445 alphabet = c("Footnote A; ", "Footnote B; "),
446 symbol = c("Footnote Symbol 1; ", "Footnote Symbol 2"),
447 general_title = "General: ", number_title = "Type I: ",
448 alphabet_title = "Type II: ", symbol_title = "Type III: ",
Hao Zhu6107f372018-05-21 00:23:26 -0400449 footnote_as_chunk = T, title_format = c("italic", "underline")
Hao Zhub9da01c2018-01-14 21:01:57 -0500450 )
Hao Zhu014d6212017-08-07 04:20:23 +0800451```
452
jjchern3dca6f42018-04-24 17:53:50 -0500453If you need to add footnote marks in a table, you need to do it manually (no fancy) using `footnote_marker_***()`. Remember that similar with `cell_spec`, you need to tell this function whether you want it to do it in `HTML` (default) or `LaTeX`. You can set it for all using the `knitr.table.format` global option. Also, if you have ever used `footnote_marker_***()`, you need to put `escape = F` in your `kable` function to avoid escaping of special characters. Note that if you want to use these `footnote_marker` functions in `kableExtra` functions like `group_rows` (for the row label) or `add_header_above`, you need to set `double_escape = T` and `escape = F` in those functions. I'm trying to find other ways around. Please let me know if you have a good idea and are willing to contribute.
Hao Zhu014d6212017-08-07 04:20:23 +0800454
Hao Zhu014d6212017-08-07 04:20:23 +0800455```{r}
Hao Zhub9da01c2018-01-14 21:01:57 -0500456dt_footnote <- dt
457names(dt_footnote)[2] <- paste0(names(dt_footnote)[2],
458 # That "latex" can be eliminated if defined in global
459 footnote_marker_symbol(1, "latex"))
460row.names(dt_footnote)[4] <- paste0(row.names(dt_footnote)[4],
461 footnote_marker_alphabet(1))
462kable(dt_footnote, "latex", align = "c", booktabs = T,
463 # Remember this escape = F
464 escape = F) %>%
465 footnote(alphabet = "Footnote A; ",
466 symbol = "Footnote Symbol 1; ",
467 alphabet_title = "Type II: ", symbol_title = "Type III: ",
468 footnote_as_chunk = T)
Hao Zhu014d6212017-08-07 04:20:23 +0800469```
470
Hao Zhu5e4dd502018-04-05 12:01:58 -0400471If your table footnote is very long, please consider to put your table in a `ThreePartTable` frame. Note that, in kableExtra version <= 0.7.0, we were using `threeparttable` but since kableExtra 0.8.0, we start to use `ThreePartTable` from `threeparttablex` instead. `ThreePartTable` supports both the `longtable` and `tabu` environments.
472
473```{r}
474kable(dt, "latex", align = "c", booktabs = T, caption = "s") %>%
475 footnote(general = "Here is a very very very very very very very very very very very very very very very very very very very very long footnote",
476 threeparttable = T)
477```
478
Hao Zhu014d6212017-08-07 04:20:23 +0800479# LaTeX Only Features
Hao Zhu5e4dd502018-04-05 12:01:58 -0400480## Linebreak processor
jjchern3dca6f42018-04-24 17:53:50 -0500481Unlike in HTML, where you can use `<br>` at any time, in LaTeX, it's actually quite difficult to make a linebreak in a table. Therefore I created the `linebreak` function to facilitate this process. Please see the [Best Practice for Newline in LaTeX Table](http://haozhu233.github.io/kableExtra/best_practice_for_newline_in_latex_table.pdf) for details.
Hao Zhu5e4dd502018-04-05 12:01:58 -0400482
483```{r}
484dt_lb <- data.frame(
485 Item = c("Hello\nWorld", "This\nis a cat"),
486 Value = c(10, 100)
487)
488
489dt_lb %>%
490 mutate_all(linebreak) %>%
491 kable("latex", booktabs = T, escape = F,
492 col.names = linebreak(c("Item\n(Name)", "Value\n(Number)"), align = "c"))
493```
494
495At the same time, since `kableExtra 0.8.0`, all `kableExtra` functions that have some contents input (such as `footnote` or `group_rows`) will automatically convert `\n` to linebreaks for you in both LaTeX and HTML.
496
497
Hao Zhu014d6212017-08-07 04:20:23 +0800498## Table on a Landscape Page
499Sometimes when we have a wide table, we want it to sit on a designated landscape page. The new function `landscape()` can help you on that. Unlike other functions, this little function only serves LaTeX and doesn't have a HTML side.
500```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400501kable(dt, "latex", caption = "Demo Table (Landscape)[note]", booktabs = T) %>%
Hao Zhu014d6212017-08-07 04:20:23 +0800502 kable_styling(latex_options = c("hold_position")) %>%
503 add_header_above(c(" ", "Group 1[note]" = 3, "Group 2[note]" = 3)) %>%
504 add_footnote(c("This table is from mtcars",
505 "Group 1 contains mpg, cyl and disp",
506 "Group 2 contains hp, drat and wt"),
507 notation = "symbol") %>%
508 group_rows("Group 1", 4, 5) %>%
509 landscape()
510```
Hao Zhu4840bc92017-09-15 15:55:05 -0400511
512## Use LaTeX table in HTML or Word
jjchern3dca6f42018-04-24 17:53:50 -0500513If you want to include a LaTeX rendered table in your HTML or Word document, or if you just want to save table as an image, you may consider using `kable_as_image()`. Note that this feature requires you to have [magick](https://github.com/ropensci/magick) installed (`install.packages("magick")`). Also, if you are planning to use it on Windows, you need to install [Ghostscript](https://www.ghostscript.com/). This feature may not work if you are using tinytex. If you are using tinytex, please consider using other alternatives to this function.
Hao Zhu4840bc92017-09-15 15:55:05 -0400514
515```{r, eval = F}
516# Not evaluated.
517
518# The code below will automatically include the image in the rmarkdown document
519kable(dt, "latex", booktabs = T) %>%
520 column_spec(1, bold = T) %>%
521 kable_as_image()
522
523# If you want to save the image locally, just provide a name
524kable(dt, "latex", booktabs = T) %>%
525 column_spec(1, bold = T) %>%
526 kable_as_image("my_latex_table")
527```
Hao Zhu6107f372018-05-21 00:23:26 -0400528
529# From other packages
530Since the structure of `kable` is relatively simple, it shouldn't be too difficult to convert HTML or LaTeX tables generated by other packages to a `kable` object and then use `kableExtra` to modify the outputs. If you are a package author, feel free to reach out to me and we can collaborate.
531
532## `tables`
Hao Zhuec169362018-05-21 01:05:29 -0400533The latest version of [`tables`](https://CRAN.R-project.org/package=tables) comes with a `toKable()` function, which is compatiable with functions in `kableExtra` (>=0.9.0).