blob: 2a7250a1dfd4ee82784a2ab1155cb749d49246af [file] [log] [blame]
Hao Zhu1fc48a62017-03-01 14:07:54 -05001---
2title: "Create Awesome HTML Table with knitr::kable and kableExtra"
3author: "Hao Zhu"
4date: "`r Sys.Date()`"
5output:
6 html_document:
Hao Zhuaf646602017-03-01 19:22:18 -05007 theme: simplex
Hao Zhu1fc48a62017-03-01 14:07:54 -05008 toc: true
9 toc_depth: 2
10 toc_float: true
11vignette: >
12 %\VignetteIndexEntry{Create Awesome HTML Table with knitr::kable and kableExtra}
13 %\VignetteEngine{knitr::rmarkdown}
14 %\VignetteEncoding{UTF-8}
15---
16
Hao Zhu33b865f2020-08-18 02:10:43 -040017<script>
18$(document).ready(function(){
19 $('[data-toggle="popover"]').popover();
20});
21</script>
22
Hao Zhudda2f722018-05-21 00:38:11 -040023<img src="kableExtra_sm.png" align="right" alt="logo" width="80" height = "93" style = "border: none; float: right;">
24
Hao Zhu0a0e8332017-08-03 13:21:29 -040025> Please see the package [documentation site](http://haozhu233.github.io/kableExtra/) for how to use this package in LaTeX.
Hao Zhu6ce29212017-05-22 16:29:56 -040026
Hao Zhu1fc48a62017-03-01 14:07:54 -050027# Overview
28The goal of `kableExtra` is to help you build common complex tables and manipulate table styles. It imports the pipe `%>%` symbol from `magrittr` and verbalize all the functions, so basically you can add "layers" to a kable output in a way that is similar with `ggplot2` and `plotly`.
29
Hao Zhu4b0c51e2017-08-01 15:21:07 -040030To learn how to generate complex tables in LaTeX, please visit [http://haozhu233.github.io/kableExtra/awesome_table_in_pdf.pdf](http://haozhu233.github.io/kableExtra/awesome_table_in_pdf.pdf)
31
Hao Zhu6107f372018-05-21 00:23:26 -040032There is also a Chinese version of this vignette. You can find it [here](http://haozhu233.github.io/kableExtra/awesome_table_in_html_cn.html)
33
Hao Zhu1fc48a62017-03-01 14:07:54 -050034# Installation
Hao Zhu1fc48a62017-03-01 14:07:54 -050035```r
Hao Zhu74eb6ad2017-03-04 09:32:37 -050036install.packages("kableExtra")
37
Hao Zhu1fc48a62017-03-01 14:07:54 -050038# For dev version
Hao Zhuf9aa4c42017-05-22 15:53:35 -040039# install.packages("devtools")
Hao Zhu1fc48a62017-03-01 14:07:54 -050040devtools::install_github("haozhu233/kableExtra")
41```
42# Getting Started
43Here we are using the first few columns and rows from dataset `mtcars`
44```{r}
45library(knitr)
46library(kableExtra)
47dt <- mtcars[1:5, 1:6]
48```
49
Hao Zhuf2be4822020-08-18 07:44:10 -040050> **Key Update:** In the latest version of this package (1.2+), we provide a wrapper funciton to the original
51
Hao Zhu6107f372018-05-21 00:23:26 -040052When 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 = "html")` so you don't repeat the step everytime.*
53
Hao Zhuf2be4822020-08-18 07:44:10 -040054**Starting from `kableExtra` 0.9.0**, when you load this package (`library(kableExtra)`), it will automatically set up the global option 'knitr.table.format' based on your current environment. 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.
Hao Zhu6107f372018-05-21 00:23:26 -040055
56You can disable this behavior by setting `options(kableExtra.auto_format = FALSE)` before you load `kableExtra`.
Hao Zhu1fc48a62017-03-01 14:07:54 -050057
58```{r}
Hao Zhu6107f372018-05-21 00:23:26 -040059# If you are using kableExtra < 0.9.0, you are recommended to set a global option first.
60# options(knitr.table.format = "html")
Hao Zhu1fc48a62017-03-01 14:07:54 -050061## If you don't define format here, you'll need put `format = "html"` in every kable function.
62```
63
Hao Zhu4b0c51e2017-08-01 15:21:07 -040064## Basic HTML table
Hao Zhu1fc48a62017-03-01 14:07:54 -050065Basic HTML output of `kable` looks very crude. To the end, it's just a plain HTML table without any love from css.
66```{r}
Hao Zhu6107f372018-05-21 00:23:26 -040067kable(dt)
Hao Zhu1fc48a62017-03-01 14:07:54 -050068```
69
Hao Zhu4b0c51e2017-08-01 15:21:07 -040070## Bootstrap theme
Hao Zhu1fc48a62017-03-01 14:07:54 -050071When used on a HTML table, `kable_styling()` will automatically apply twitter bootstrap theme to the table. Now it should looks the same as the original pandoc output (the one when you don't specify `format` in `kable()`) but this time, you are controlling it.
72```{r}
Hao Zhuf03decd2017-09-13 10:45:44 -040073dt %>%
Hao Zhu6107f372018-05-21 00:23:26 -040074 kable() %>%
Hao Zhu1fc48a62017-03-01 14:07:54 -050075 kable_styling()
76```
77
Hao Zhud7762a42020-08-10 09:05:47 -040078## Alternative themes
Hao Zhu33b865f2020-08-18 02:10:43 -040079`kableExtra` also offers a few in-house alternative HTML table themes other than the default bootstrap theme. Right now there are 6 of them: `kable_paper`, `kable_classic`, `kable_classic_2`, `kable_minimal`, `kable_material` and `kable_material_dark`. These functions are alternatives to `kable_styling`, which means that you can specify any additional formatting options in `kable_styling` in these functions too. The only difference is that `bootstrap_options` (as discussed in the next section) is replaced with `lightable_options` at the same location with only two choices `striped` and `hover` available.
80
81```{r}
82dt %>%
83 kable() %>%
84 kable_paper("hover")
85```
Hao Zhud7762a42020-08-10 09:05:47 -040086
87```{r}
88dt %>%
89 kable() %>%
90 kable_classic()
91```
92
93```{r}
94dt %>%
95 kable() %>%
Hao Zhud8a2e332020-08-11 01:26:32 -040096 kable_classic_2()
97```
98
99```{r}
100dt %>%
101 kable() %>%
Hao Zhud7762a42020-08-10 09:05:47 -0400102 kable_minimal()
103```
104
105```{r}
106dt %>%
107 kable() %>%
108 kable_material(c("striped", "hover"))
109```
110
Hao Zhu9bf19982020-08-11 00:50:33 -0400111```{r}
112dt %>%
113 kable() %>%
114 kable_material_dark()
115```
116
Hao Zhud7762a42020-08-10 09:05:47 -0400117
118
Hao Zhu1fc48a62017-03-01 14:07:54 -0500119# Table Styles
Hao Zhu462b4492017-08-03 11:31:42 -0400120`kable_styling` offers a few other ways to customize the look of a HTML table.
Hao Zhu1fc48a62017-03-01 14:07:54 -0500121
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400122## Bootstrap table classes
Hao Zhue2706b32017-03-07 02:36:17 -0500123If you are familiar with twitter bootstrap, you probably have already known its predefined classes, including `striped`, `bordered`, `hover`, `condensed` and `responsive`. If you are not familiar, no worries, you can take a look at their [documentation site](http://getbootstrap.com/css/#tables) to get a sense of how they look like. All of these options are available here.
Hao Zhu1fc48a62017-03-01 14:07:54 -0500124
125For example, to add striped lines (alternative row colors) to your table and you want to highlight the hovered row, you can simply type:
126```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400127kable(dt) %>%
Hao Zhu1fc48a62017-03-01 14:07:54 -0500128 kable_styling(bootstrap_options = c("striped", "hover"))
129```
130
131The option `condensed` can also be handy in many cases when you don't want your table to be too large. It has slightly shorter row height.
132```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400133kable(dt) %>%
Hao Zhu1fc48a62017-03-01 14:07:54 -0500134 kable_styling(bootstrap_options = c("striped", "hover", "condensed"))
135```
136
137Tables with option `responsive` looks the same with others on a large screen. However, on a small screen like phone, they are horizontally scrollable. Please resize your window to see the result.
138```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400139kable(dt) %>%
Hao Zhu1fc48a62017-03-01 14:07:54 -0500140 kable_styling(bootstrap_options = c("striped", "hover", "condensed", "responsive"))
141```
142
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400143## Full width?
Hao Zhubf4cdc62017-03-02 22:26:29 -0500144By default, a bootstrap table takes 100% of the width. It is supposed to use together with its grid system to scale the table properly. However, when you are writing a rmarkdown document, you probably don't want to write your own css/or grid. For some small tables with only few columns, a page wide table looks awful. To make it easier, you can specify whether you want the table to have `full_width` or not in `kable_styling`. By default, `full_width` is set to be `TRUE` for HTML tables (note that for LaTeX, the default is `FALSE` since I don't want to change the "common" looks unless you specified it.)
Hao Zhu1fc48a62017-03-01 14:07:54 -0500145```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400146kable(dt) %>%
Hao Zhu33b865f2020-08-18 02:10:43 -0400147 kable_paper(bootstrap_options = "striped", full_width = F)
Hao Zhu1fc48a62017-03-01 14:07:54 -0500148```
149
150## Position
151Table Position only matters when the table doesn't have `full_width`. You can choose to align the table to `center`, `left` or `right` side of the page
152```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400153kable(dt) %>%
Hao Zhu1fc48a62017-03-01 14:07:54 -0500154 kable_styling(bootstrap_options = "striped", full_width = F, position = "left")
155```
156
157Becides these three common options, you can also wrap text around the table using the `float-left` or `float-right` options.
158```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400159kable(dt) %>%
Hao Zhu1fc48a62017-03-01 14:07:54 -0500160 kable_styling(bootstrap_options = "striped", full_width = F, position = "float_right")
161```
162Lorem 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.
163
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400164## Font size
Hao Zhu1fc48a62017-03-01 14:07:54 -0500165If 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.
166```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400167kable(dt) %>%
Hao Zhu1fc48a62017-03-01 14:07:54 -0500168 kable_styling(bootstrap_options = "striped", font_size = 7)
169```
170
Hao Zhu72917f92019-03-15 18:41:42 -0400171## Fixed Table Header Row
172If you happened to have a very long table, you may consider to use this `fixed_header` option to fix the header row on top as your readers scroll. By default, the background is set to white. If you need a different color, you can set `fixed_header = list(enabled = T, background = "red")`.
173
174```{r}
175kable(mtcars[1:10, 1:5]) %>%
176 kable_styling(fixed_thead = T)
177```
178
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400179# Column / Row Specification
180## Column spec
Hao Zhu4840bc92017-09-15 15:55:05 -0400181When you have a table with lots of explanatory texts, you may want to specified 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 scenario, you can use `column_spec()`. You can find an example below.
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400182
183Warning: If you have a super long table, you should be cautious when you use `column_spec` as the xml node modification takes time.
184
185```{r}
186text_tbl <- data.frame(
187 Items = c("Item 1", "Item 2", "Item 3"),
188 Features = c(
189 "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin vehicula tempor ex. Morbi malesuada sagittis turpis, at venenatis nisl luctus a. ",
190 "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. ",
191 "Vivamus venenatis egestas eros ut tempus. Vivamus id est nisi. Aliquam molestie erat et sollicitudin venenatis. In ac lacus at velit scelerisque mattis. "
192 )
193)
194
Hao Zhu6107f372018-05-21 00:23:26 -0400195kable(text_tbl) %>%
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400196 kable_styling(full_width = F) %>%
Hao Zhua44e3752017-09-05 12:56:19 -0400197 column_spec(1, bold = T, border_right = T) %>%
198 column_spec(2, width = "30em", background = "yellow")
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400199```
200
Hao Zhu33b865f2020-08-18 02:10:43 -0400201> **Key Update**: I understand the need of doing conditional formatting and the previous solution `cell_spec` is relatively hard to use. Therefore in kableExtra 1.2, I improved the functionality of `column_spec` so it can take vectorized input for most of its arguments (except `width`, `border_left` and `border_right`). It is really easy right now to format a column based on other values.
202
203```{r}
204mtcars[1:8, 1:8] %>%
205 kable() %>%
206 kable_paper(full_width = F) %>%
207 column_spec(2, color = spec_color(mtcars$mpg[1:8]),
208 link = "https://haozhu233.github.io/kableExtra") %>%
209 column_spec(6, color = "white",
210 background = spec_color(mtcars$drat[1:8], end = 0.7),
211 popover = paste("am:", mtcars$am[1:8]))
212```
213
214You can still use the `spec_***` helper functions to help you define color. See the documentation [below](#visualize-data-with-viridis-color).
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400215
Hao Zhu0a0e8332017-08-03 13:21:29 -0400216## Row spec
Hao Zhu33b865f2020-08-18 02:10:43 -0400217Similar with `column_spec`, you can define specifications for rows. Currently, you can either bold or italicize an entire row. Note that, similar with 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 Zhu4b0c51e2017-08-01 15:21:07 -0400218
219```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400220kable(dt) %>%
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400221 kable_styling("striped", full_width = F) %>%
Hao Zhu4840bc92017-09-15 15:55:05 -0400222 column_spec(5:7, bold = T) %>%
223 row_spec(3:5, bold = T, color = "white", background = "#D7261E")
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400224```
225
Hao Zhu9ce317e2017-10-12 18:19:55 -0400226
Hao Zhu6f362bb2017-10-23 23:21:38 -0400227
228## Header Rows
229One special case of `row_spec` is that you can specify the format of the header row via `row_spec(row = 0, ...)`.
230```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400231kable(dt) %>%
Hao Zhu6f362bb2017-10-23 23:21:38 -0400232 kable_styling("striped", full_width = F) %>%
233 row_spec(0, angle = -45)
Hao Zhu9ce317e2017-10-12 18:19:55 -0400234```
235
Hao Zhu6f362bb2017-10-23 23:21:38 -0400236# Cell/Text Specification
Hao Zhu33b865f2020-08-18 02:10:43 -0400237
238>**Key Update: As said before, if you are using kableExtra 1.2+, you are now recommended to used `column_spec` to do conditional formatting**.
239
Hao Zhu6f362bb2017-10-23 23:21:38 -0400240Function `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 dimentional index 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:
241* 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(.),
Hao Zhu76762d82018-07-25 20:56:52 -0400253 mpg = cell_spec(mpg, "html", color = ifelse(mpg > 20, "red", "blue")),
254 cyl = cell_spec(cyl, "html", color = "white", align = "c", angle = 45,
Hao Zhu6f362bb2017-10-23 23:21:38 -0400255 background = factor(cyl, c(4, 6, 8),
256 c("#666666", "#999999", "#BBBBBB")))
257 ) %>%
258 select(car, mpg, cyl) %>%
Hao Zhu76762d82018-07-25 20:56:52 -0400259 kable(format = "html", escape = F) %>%
Hao Zhu6f362bb2017-10-23 23:21:38 -0400260 kable_styling("striped", full_width = F)
261```
262
263## Visualize data with Viridis Color
Hao Zhu33b865f2020-08-18 02:10:43 -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 impressive representation in a tabular format.
Hao Zhu6f362bb2017-10-23 23:21:38 -0400265
266```{r}
267iris[1:10, ] %>%
268 mutate_if(is.numeric, function(x) {
Hao Zhu6107f372018-05-21 00:23:26 -0400269 cell_spec(x, bold = T,
Hao Zhu5ece06e2018-01-19 23:18:02 -0500270 color = spec_color(x, end = 0.9),
Hao Zhu6f362bb2017-10-23 23:21:38 -0400271 font_size = spec_font_size(x))
272 }) %>%
273 mutate(Species = cell_spec(
Hao Zhu6107f372018-05-21 00:23:26 -0400274 Species, color = "white", bold = T,
Hao Zhu6f362bb2017-10-23 23:21:38 -0400275 background = spec_color(1:10, end = 0.9, option = "A", direction = -1)
276 )) %>%
Hao Zhu6107f372018-05-21 00:23:26 -0400277 kable(escape = F, align = "c") %>%
Hao Zhu222cd7e2018-04-10 14:27:19 -0400278 kable_styling(c("striped", "condensed"), full_width = F)
Hao Zhu6f362bb2017-10-23 23:21:38 -0400279```
280
281In 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.
282
283## Text Specification
284If 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.
285
286An aliased function `text_spec` is also provided for a more literal writing experience. In HTML, there is no difference between these two functions.
287
288```{r}
289sometext <- strsplit(paste0(
Hao Zhu6290fdd2017-10-24 00:10:32 -0400290 "You can even try to make some crazy things like this paragraph. ",
Hao Zhu6a1cbb52017-10-24 15:54:50 -0400291 "It may seem like a useless feature right now but it's so cool ",
292 "and nobody can resist. ;)"
Hao Zhu6f362bb2017-10-23 23:21:38 -0400293), " ")[[1]]
294text_formatted <- paste(
Hao Zhu6107f372018-05-21 00:23:26 -0400295 text_spec(sometext, color = spec_color(1:length(sometext), end = 0.9),
Hao Zhu6f362bb2017-10-23 23:21:38 -0400296 font_size = spec_font_size(1:length(sometext), begin = 5, end = 20)),
297 collapse = " ")
298
299# To display the text, type `r text_formatted` outside of the chunk
300```
301`r text_formatted`
302
303## Tooltip
304It's very easy to add a tooltip to text via `cell_spec`. For example, `text_spec("tooltip", color = "red", tooltip = "Hello World")` will give you something like `r text_spec("Hover over me", color = "red", tooltip = "Hello World")` (you need to wait for a few seconds before your browser renders it).
305
306Note that the original browser-based tooltip is slow. If you want to have a faster response, you may want to initialize bootstrap's tooltip by putting the following HTML code on the page.
307```
308<script>
309$(document).ready(function(){
310 $('[data-toggle="tooltip"]').tooltip();
311});
312</script>
313```
314
315In a rmarkdown document, you can just drop it outside of any R chunks. Unfortunately however, for rmarkdown pages with a **floating TOC** (like this page), you can't use bootstrap tooltips because there is a conflict in namespace between Bootstrap and JQueryUI (tocify.js). As a result, I can't provide a live demo here. If you want to have a tooltip together with a floating TOC, you should use `popover` which has a very similar effect.
316
317
318
319## Popover Message
320The popover message looks very similar with tooltip but it can hold more contents. Unlike tooltip which can minimally work without you manually enable that module, you **have to** enable the `popover` module to get it work. The upper side is that there is no conflict between Bootstrap & JQueryUI this time, you can use it without any concern.
321
322```
323<script>
324$(document).ready(function(){
325 $('[data-toggle="popover"]').popover();
326});
327</script>
328```
329
Hao Zhu6f362bb2017-10-23 23:21:38 -0400330```{r}
331popover_dt <- data.frame(
332 position = c("top", "bottom", "right", "left"),
333 stringsAsFactors = FALSE
334)
335popover_dt$`Hover over these items` <- cell_spec(
336 paste("Message on", popover_dt$position), # Cell texts
337 popover = spec_popover(
338 content = popover_dt$position,
339 title = NULL, # title will add a Title Panel on top
340 position = popover_dt$position
341 ))
Hao Zhu6107f372018-05-21 00:23:26 -0400342kable(popover_dt, escape = FALSE) %>%
Hao Zhu6f362bb2017-10-23 23:21:38 -0400343 kable_styling("striped", full_width = FALSE)
344```
345
346## Links
Hao Zhu9567e632017-10-24 09:51:09 -0400347You can add links to text via `text_spec("Google", link = "https://google.com")`: `r text_spec("Google", link = "https://google.com")`. If you want your hover message to be more obvious, it might be a good idea to put a `#` (go back to the top of the page) or `javascript:void(0)` (literally do nothing) in the `link` option.
348`text_spec("Hover on me", link = "javascript:void(0)", popover = "Hello")`:
349`r text_spec("Hover on me", link = "javascript:void(0)", popover = "Hello")`
Hao Zhu6f362bb2017-10-23 23:21:38 -0400350
Hao Zhu8b32b192017-10-24 14:51:48 -0400351## Integration with `formattable`
352You can combine the good parts from `kableExtra` & `formattable` together into one piece. Read more at http://haozhu233.github.io/kableExtra/use_kableExtra_with_formattable.html
353```{r, message = FALSE, warning=FALSE}
354library(formattable)
355mtcars[1:5, 1:4] %>%
356 mutate(
357 car = row.names(.),
358 mpg = color_tile("white", "orange")(mpg),
Hao Zhu6107f372018-05-21 00:23:26 -0400359 cyl = cell_spec(cyl, angle = (1:5)*60,
Hao Zhu8b32b192017-10-24 14:51:48 -0400360 background = "red", color = "white", align = "center"),
361 disp = ifelse(disp > 200,
Hao Zhu6107f372018-05-21 00:23:26 -0400362 cell_spec(disp, color = "red", bold = T),
363 cell_spec(disp, color = "green", italic = T)),
Hao Zhu8b32b192017-10-24 14:51:48 -0400364 hp = color_bar("lightgreen")(hp)
365 ) %>%
366 select(car, everything()) %>%
Hao Zhu6107f372018-05-21 00:23:26 -0400367 kable(escape = F) %>%
Hao Zhu8b32b192017-10-24 14:51:48 -0400368 kable_styling("hover", full_width = F) %>%
369 column_spec(5, width = "3cm") %>%
370 add_header_above(c(" ", "Hello" = 2, "World" = 2))
371```
372
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400373# Grouped Columns / Rows
374## Add header rows to group columns
Hao Zhu1fc48a62017-03-01 14:07:54 -0500375Tables 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)).
376```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400377kable(dt) %>%
Hao Zhu1fc48a62017-03-01 14:07:54 -0500378 kable_styling("striped") %>%
379 add_header_above(c(" " = 1, "Group 1" = 2, "Group 2" = 2, "Group 3" = 2))
380```
381
Hao Zhu916c3662017-06-21 15:55:05 -0400382In fact, if you want to add another row of header on top, please feel free to do so.
Hao Zhu1fc48a62017-03-01 14:07:54 -0500383```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400384kable(dt) %>%
Hao Zhu1fc48a62017-03-01 14:07:54 -0500385 kable_styling(c("striped", "bordered")) %>%
386 add_header_above(c(" ", "Group 1" = 2, "Group 2" = 2, "Group 3" = 2)) %>%
387 add_header_above(c(" ", "Group 4" = 4, "Group 5" = 2)) %>%
388 add_header_above(c(" ", "Group 6" = 6))
389```
390
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400391## Group rows via labeling
Hao Zhu72917f92019-03-15 18:41:42 -0400392Sometimes 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 function `group_rows()`/`pack_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".
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400393```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400394kable(mtcars[1:10, 1:6], caption = "Group Rows") %>%
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400395 kable_styling("striped", full_width = F) %>%
Hao Zhu72917f92019-03-15 18:41:42 -0400396 pack_rows("Group 1", 4, 7) %>%
397 pack_rows("Group 2", 8, 10)
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400398```
399
Hao Zhu72917f92019-03-15 18:41:42 -0400400Another way to use `pack_rows` is to provide an grouping index, similar with `add_header_above()`. This feature is only available in kableExtra > 0.5.2.
Hao Zhu4840bc92017-09-15 15:55:05 -0400401```{r, eval = F}
402# Not evaluated. This example generates the same table as above.
Hao Zhu6107f372018-05-21 00:23:26 -0400403kable(mtcars[1:10, 1:6], caption = "Group Rows") %>%
Hao Zhu4840bc92017-09-15 15:55:05 -0400404 kable_styling("striped", full_width = F) %>%
Hao Zhu72917f92019-03-15 18:41:42 -0400405 pack_rows(index = c(" " = 3, "Group 1" = 4, "Group 2" = 3))
Hao Zhu4840bc92017-09-15 15:55:05 -0400406```
407
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400408For advanced users, you can even define your own css for the group labeling.
409```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400410kable(dt) %>%
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400411 kable_styling("striped", full_width = F) %>%
Hao Zhu72917f92019-03-15 18:41:42 -0400412 pack_rows("Group 1", 3, 5, label_row_css = "background-color: #666; color: #fff;")
413```
414
415`r text_spec("Important Note!", bold = T, color = "#D7261E")`
416
417Note that `dplyr` 0.8.0+ introduced a `group_rows` function as well for a trivial feature. Therefore, I'm create this `pack_rows` function as an alias to the original `group_rows`. In the future, **I recommend all kableExtra users to use `pack_rows` instead of `group_rows` to get rid of the NAMESPACE conflict.**
418
419Alternatively, for pre-existing codes, you have two ways to solve this. You can either load `kableExtra` after `dplyr` or `tidyverse`, or to use the `conflicted` package. Here is an example.
420
421```{r, eval=F}
422# Method 1
423pack_rows() # instead of group_rows()
424
425# Method 2
426library(dplyr)
427library(kableExtra)
428
429# Method 3
430conflicted::conflict_prefer("group_rows", "kableExtra", "dplyr")
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400431```
432
433## Row indentation
Hao Zhu72917f92019-03-15 18:41:42 -0400434Unlike `pack_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 apporiate.
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400435For advanced users, you can even define your own css for the group labeling.
436```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400437kable(dt) %>%
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400438 kable_styling("striped", full_width = F) %>%
439 add_indent(c(1, 3, 5))
440```
441
442## Group rows via multi-row cell
Hao Zhu72917f92019-03-15 18:41:42 -0400443Function `pack_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 to use `collapse_rows` instead, which will put repeating cells in columns into multi-row cells. The vertical allignment of the cell is controlled by `valign` with default as "top".
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400444
445```{r}
446collapse_rows_dt <- data.frame(C1 = c(rep("a", 10), rep("b", 5)),
447 C2 = c(rep("c", 7), rep("d", 3), rep("c", 2), rep("d", 3)),
448 C3 = 1:15,
449 C4 = sample(c(0,1), 15, replace = TRUE))
Hao Zhu6107f372018-05-21 00:23:26 -0400450kable(collapse_rows_dt, align = "c") %>%
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400451 kable_styling(full_width = F) %>%
452 column_spec(1, bold = T) %>%
Hao Zhu6107f372018-05-21 00:23:26 -0400453 collapse_rows(columns = 1:2, valign = "top")
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400454```
455
456# Table Footnote
Hao Zhu1fc48a62017-03-01 14:07:54 -0500457
Hao Zhu4f8eaa22018-01-11 16:14:25 -0500458> Now it's recommended to use the new `footnote` function instead of `add_footnote` to make table footnotes.
459
460Documentations for `add_footnote` can be found [here](http://haozhu233.github.io/kableExtra/legacy_features#add_footnote).
461
462There 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 fulfill the APA table footnotes requirements.
Hao Zhu1fc48a62017-03-01 14:07:54 -0500463```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400464kable(dt, align = "c") %>%
Hao Zhu4f8eaa22018-01-11 16:14:25 -0500465 kable_styling(full_width = F) %>%
466 footnote(general = "Here is a general comments of the table. ",
467 number = c("Footnote 1; ", "Footnote 2; "),
468 alphabet = c("Footnote A; ", "Footnote B; "),
469 symbol = c("Footnote Symbol 1; ", "Footnote Symbol 2")
470 )
Hao Zhu1fc48a62017-03-01 14:07:54 -0500471```
472
Hao Zhu6107f372018-05-21 00:23:26 -0400473You 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 Zhu4f8eaa22018-01-11 16:14:25 -0500474
Hao Zhu1fc48a62017-03-01 14:07:54 -0500475```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400476kable(dt, align = "c") %>%
Hao Zhu4f8eaa22018-01-11 16:14:25 -0500477 kable_styling(full_width = F) %>%
478 footnote(general = "Here is a general comments of the table. ",
479 number = c("Footnote 1; ", "Footnote 2; "),
480 alphabet = c("Footnote A; ", "Footnote B; "),
481 symbol = c("Footnote Symbol 1; ", "Footnote Symbol 2"),
482 general_title = "General: ", number_title = "Type I: ",
483 alphabet_title = "Type II: ", symbol_title = "Type III: ",
Hao Zhu6107f372018-05-21 00:23:26 -0400484 footnote_as_chunk = T, title_format = c("italic", "underline")
Hao Zhu4f8eaa22018-01-11 16:14:25 -0500485 )
Hao Zhu1fc48a62017-03-01 14:07:54 -0500486```
487
Hao Zhu4f8eaa22018-01-11 16:14:25 -0500488If you need to add footnote marks in table, you need to do it manually (no fancy) using `footnote_mark_***()`. 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 use `footnote_mark_***()`, you need to put `escape = F` in your `kable` function to avoid escaping of special characters.
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400489
Hao Zhu1fc48a62017-03-01 14:07:54 -0500490```{r}
Hao Zhu4f8eaa22018-01-11 16:14:25 -0500491dt_footnote <- dt
492names(dt_footnote)[2] <- paste0(names(dt_footnote)[2],
493 footnote_marker_symbol(1))
494row.names(dt_footnote)[4] <- paste0(row.names(dt_footnote)[4],
495 footnote_marker_alphabet(1))
Hao Zhu6107f372018-05-21 00:23:26 -0400496kable(dt_footnote, align = "c",
Hao Zhu4f8eaa22018-01-11 16:14:25 -0500497 # Remember this escape = F
498 escape = F) %>%
499 kable_styling(full_width = F) %>%
500 footnote(alphabet = "Footnote A; ",
501 symbol = "Footnote Symbol 1; ",
502 alphabet_title = "Type II: ", symbol_title = "Type III: ",
503 footnote_as_chunk = T)
Hao Zhu1fc48a62017-03-01 14:07:54 -0500504```
Hao Zhuf9aa4c42017-05-22 15:53:35 -0400505
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400506# HTML Only Features
507## Scroll box
508If you have a huge table and you don't want to reduce the font size to unreadable, you may want to put your HTML table in a scroll box, of which users can pick the part they like to read. Note that scroll box isn't printer friendly, so be aware of that when you use this feature.
Hao Zhuf9aa4c42017-05-22 15:53:35 -0400509
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400510When you use `scroll_box`, you can specify either `height` or `width`. When you specify `height`, you will get a vertically scrollable box and vice versa. If you specify both, you will get a two-way scrollable box.
Hao Zhu6ff9d502017-06-13 17:13:03 -0400511
512```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400513kable(cbind(mtcars, mtcars)) %>%
Hao Zhu4b0c51e2017-08-01 15:21:07 -0400514 kable_styling() %>%
515 scroll_box(width = "500px", height = "200px")
Hao Zhu6ff9d502017-06-13 17:13:03 -0400516```
Irene62a3b362018-04-17 15:20:43 -0700517
518<br>
519
520You can also specify width using a percentage.
521
522```{r}
Hao Zhu6107f372018-05-21 00:23:26 -0400523kable(cbind(mtcars, mtcars)) %>%
Hao Zhu72917f92019-03-15 18:41:42 -0400524 add_header_above(c("a" = 5, "b" = 18)) %>%
Irene62a3b362018-04-17 15:20:43 -0700525 kable_styling() %>%
526 scroll_box(width = "100%", height = "200px")
527```
Hao Zhu6107f372018-05-21 00:23:26 -0400528
Hao Zhu72917f92019-03-15 18:41:42 -0400529Starting from version 1.1.0, if you have a fixed-height box, the header row is fixed
530
Hao Zhu6107f372018-05-21 00:23:26 -0400531## Save HTML table directly
532If you need to save those HTML tables but you don't want to generate them through rmarkdown, you can try to use the `save_kable()` function. You can choose whether to let those HTML files be self contained (default is yes). Self contained files packed CSS into the HTML file so they are quite large when there are many.
533```{r, eval=FALSE}
534kable(mtcars) %>%
535 kable_styling() %>%
536 save_kable(file = "table1.html", self_contained = T)
537```
538
539# From other packages
540Since 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.
541
542## `tables`
Hao Zhuec169362018-05-21 01:05:29 -0400543The 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).
Hao Zhua171b452019-01-15 17:14:34 -0600544
545## `xtable`
546For `xtable` users, if you want to use `kableExtra` functions on that, check out this `xtable2kable()` function shipped with kableExtra 1.0.
547
548```{r, eval=F}
549# Not evaluating
550xtable::xtable(mtcars[1:4, 1:4], caption = "Hello xtable") %>%
551 xtable2kable() %>%
552 column_spec(1, color = "red")
553```