Hao Zhu | b1bc0aa | 2015-11-12 11:23:42 -0500 | [diff] [blame] | 1 | #' Add footnote |
| 2 | #' |
| 3 | #' @description Add footnote to your favorite kable output. So far this function |
| 4 | #' only works when you define \code{format} in your kable function or in the |
| 5 | #' global knitr option \code{knitr.table.format}. In latex, we are using the |
| 6 | #' \code{threeparttable} package so you need to import this package in your |
| 7 | #' \code{YAML} header. |
| 8 | #' |
| 9 | #' @param input The direct output of your \code{kable} function or your last |
| 10 | #' \code{kableExtra} function. |
| 11 | #' @param label A vector of footnotes you want to add. You don't need to add |
| 12 | #' notations in your notes. |
| 13 | #' @param notation You can select the format of your footnote notation from |
| 14 | #' "number", "alphabet" and "symbol". |
Will Beasley | 70aa3b2 | 2016-01-11 11:42:27 -0600 | [diff] [blame] | 15 | #' @param threeparttable Boolean value indicating if a \href{https://www.ctan.org/pkg/threeparttable}{threeparttable} scheme should be used. |
Hao Zhu | b1bc0aa | 2015-11-12 11:23:42 -0500 | [diff] [blame] | 16 | #' |
| 17 | #' @export |
Hao Zhu | e10cfd3 | 2017-02-21 16:41:14 -0500 | [diff] [blame] | 18 | add_footnote <- function(input, label = NULL, |
| 19 | notation = c("alphabet", "number", "symbol"), |
Hao Zhu | 2203f66 | 2015-11-20 11:53:39 -0500 | [diff] [blame] | 20 | threeparttable = FALSE) { |
Hao Zhu | e10cfd3 | 2017-02-21 16:41:14 -0500 | [diff] [blame] | 21 | if (is.null(label)) return(input) |
Hao Zhu | 8977a8a | 2015-11-19 16:52:21 -0500 | [diff] [blame] | 22 | |
Hao Zhu | e10cfd3 | 2017-02-21 16:41:14 -0500 | [diff] [blame] | 23 | notation <- match.arg(notation) |
| 24 | if (notation == "symbol") { |
| 25 | notation <- paste0(notation, ".", attr(input, "format")) |
Hao Zhu | b1bc0aa | 2015-11-12 11:23:42 -0500 | [diff] [blame] | 26 | } |
Hao Zhu | e10cfd3 | 2017-02-21 16:41:14 -0500 | [diff] [blame] | 27 | |
| 28 | ids.ops <- read.csv(system.file("symbol_index.csv", package = "kableExtra")) |
| 29 | ids <- ids.ops[, notation] |
Hao Zhu | db04e30 | 2015-11-15 16:57:38 -0500 | [diff] [blame] | 30 | ids.intable <- gsub("\\*", "\\\\*", ids) |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 31 | # ids.simple <- c( |
| 32 | # "*", "\u2020", "\u2021", "\u00A7", "\u00B6", |
| 33 | # "**", "\u2020\u2020", "\u2021\u2021", "\u00A7\u00A7", "\u00B6\u00B6", |
| 34 | # "***", "\u2020\u2020\u2020", "\u2021\u2021\u2021", |
| 35 | # "\u00A7\u00A7\u00A7", "\u00B6\u00B6\u00B6", |
| 36 | # "****", "\u2020\u2020\u2020\u2020", "\u2021\u2021\u2021\u2021", |
| 37 | # "\u00A7\u00A7\u00A7\u00A7", "\u00B6\u00B6\u00B6\u00B6" |
| 38 | # ) |
Hao Zhu | db04e30 | 2015-11-15 16:57:38 -0500 | [diff] [blame] | 39 | |
| 40 | #count the number of items in label and intable notation |
Hao Zhu | e10cfd3 | 2017-02-21 16:41:14 -0500 | [diff] [blame] | 41 | count.label <- length(label) |
| 42 | count.intablenote <- sum(str_count(input, "\\[note\\]")) |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 43 | if (count.intablenote != 0 & count.label != count.intablenote) { |
Hao Zhu | db04e30 | 2015-11-15 16:57:38 -0500 | [diff] [blame] | 44 | warning(paste("You entered", count.label, "labels but you put", |
Hao Zhu | e10cfd3 | 2017-02-21 16:41:14 -0500 | [diff] [blame] | 45 | count.intablenote, "[note] in your table.")) |
Hao Zhu | db04e30 | 2015-11-15 16:57:38 -0500 | [diff] [blame] | 46 | } |
Hao Zhu | b1bc0aa | 2015-11-12 11:23:42 -0500 | [diff] [blame] | 47 | |
Hao Zhu | 4adea85 | 2015-11-16 16:38:34 -0500 | [diff] [blame] | 48 | export <- input |
| 49 | |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 50 | # Find out if there are any extra in-table notations needed to be corrected |
Hao Zhu | 2203f66 | 2015-11-20 11:53:39 -0500 | [diff] [blame] | 51 | extra.notation <- unique(as.numeric( |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 52 | str_extract( |
| 53 | str_extract_all( |
| 54 | paste0(export, collapse = ""), "\\[note[0-9]{1,2}\\]" |
| 55 | )[[1]], |
Hao Zhu | 2203f66 | 2015-11-20 11:53:39 -0500 | [diff] [blame] | 56 | "[0-9]{1,2}"))) |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 57 | |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 58 | # Pandoc --------------------------- |
Hao Zhu | 4adea85 | 2015-11-16 16:38:34 -0500 | [diff] [blame] | 59 | # Footnote solution for markdown and pandoc. It is not perfect as |
| 60 | # markdown doesn't support complex table formats but this solution |
| 61 | # should be able to satisfy people who don't want to spend extra |
Hao Zhu | e10cfd3 | 2017-02-21 16:41:14 -0500 | [diff] [blame] | 62 | # time to define their `kable` format. |
| 63 | if (!attr(input, "format") %in% c("html", "latex")) { |
Hao Zhu | 4adea85 | 2015-11-16 16:38:34 -0500 | [diff] [blame] | 64 | # In table notation |
Hao Zhu | e10cfd3 | 2017-02-21 16:41:14 -0500 | [diff] [blame] | 65 | if (count.intablenote != 0) { |
| 66 | for (i in 1:count.intablenote) { |
| 67 | replace_note <- paste0("^", ids.intable[i], "^", |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 68 | paste0(rep(" ", 4 - ceiling(i/5)), collapse = "")) |
Hao Zhu | e10cfd3 | 2017-02-21 16:41:14 -0500 | [diff] [blame] | 69 | |
Hao Zhu | db04e30 | 2015-11-15 16:57:38 -0500 | [diff] [blame] | 70 | export[which(str_detect(export, "\\[note\\]"))[1]] <- |
Hao Zhu | e10cfd3 | 2017-02-21 16:41:14 -0500 | [diff] [blame] | 71 | sub("\\[note\\]", replace_note, |
| 72 | export[which(str_detect(export, "\\[note\\]"))[1]]) |
Hao Zhu | db04e30 | 2015-11-15 16:57:38 -0500 | [diff] [blame] | 73 | } |
Hao Zhu | b1bc0aa | 2015-11-12 11:23:42 -0500 | [diff] [blame] | 74 | } |
Hao Zhu | 4adea85 | 2015-11-16 16:38:34 -0500 | [diff] [blame] | 75 | # Fix extra in table notation |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 76 | for (i in extra.notation) { |
Hao Zhu | 4adea85 | 2015-11-16 16:38:34 -0500 | [diff] [blame] | 77 | export <- gsub(paste0("\\[note", i, "\\]"), |
| 78 | paste0("^", ids.intable[i], "^", |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 79 | paste0(rep(" ", 4 - ceiling(i/5)), collapse = "")), |
Hao Zhu | 4adea85 | 2015-11-16 16:38:34 -0500 | [diff] [blame] | 80 | export) |
| 81 | } |
Hao Zhu | b1bc0aa | 2015-11-12 11:23:42 -0500 | [diff] [blame] | 82 | |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 83 | export[length(export) + 1] <- "" |
| 84 | export[length(export) + 1] <- "__Note:__" |
| 85 | export[length(export) + 1] <- paste0( |
Hao Zhu | db04e30 | 2015-11-15 16:57:38 -0500 | [diff] [blame] | 86 | paste0("^", ids[1:length(label)], "^ ", label), collapse = " " |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 87 | ) |
| 88 | } |
Hao Zhu | db04e30 | 2015-11-15 16:57:38 -0500 | [diff] [blame] | 89 | |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 90 | # LaTeX Tables -------------------------------- |
| 91 | if (attr(input, "format") == "latex") { |
Hao Zhu | 2203f66 | 2015-11-20 11:53:39 -0500 | [diff] [blame] | 92 | # Clean the entry for labels |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 93 | label <- escape_latex(label) |
| 94 | label <- gsub("\\\\", "\\\\\\\\", label) |
Hao Zhu | 8977a8a | 2015-11-19 16:52:21 -0500 | [diff] [blame] | 95 | |
Hao Zhu | 4adea85 | 2015-11-16 16:38:34 -0500 | [diff] [blame] | 96 | kable_info <- magic_mirror(input) |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 97 | if (kable_info$tabular == "longtable") { |
| 98 | if (notation != "number") { |
| 99 | warning("Notation is set to 'number' and other formats are not supported.") |
| 100 | notation <- "number" |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 101 | } |
| 102 | # If longtable is used, then use page footnote instead of threeparttable |
| 103 | # as it makes more sense to see the footnote at the bottom of page if |
| 104 | # table is longer than one page. |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 105 | if (threeparttable == T) { |
| 106 | warning("Threeparttable does not support longtable.") |
| 107 | threeparttable = F |
| 108 | } |
Hao Zhu | 4adea85 | 2015-11-16 16:38:34 -0500 | [diff] [blame] | 109 | |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 110 | # Longtable doesn't support footnote in caption directly. |
| 111 | # See http://tex.stackexchange.com/questions/50151/footnotes-in-longtable-captions |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 112 | |
| 113 | count.in.caption.note <- 0 |
| 114 | if (!is.na(kable_info$caption)) { |
| 115 | count.in.caption.note <- str_count(kable_info$caption, "\\[note\\]") |
| 116 | } |
| 117 | if (count.in.caption.note != 0) { |
| 118 | caption.footnote <- paste0("\\\\addtocounter{footnote}{-", |
| 119 | count.in.caption.note, "}") |
| 120 | for (i in 1:count.in.caption.note) { |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 121 | export <- sub("\\[note\\]", "\\\\protect\\\\footnotemark ", export) |
| 122 | caption.footnote <- paste0( |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 123 | caption.footnote, "\n\\\\stepcounter{footnote}\\\\footnotetext{", |
| 124 | label[i], "}") |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 125 | } |
| 126 | |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 127 | if (str_detect(export, "\\\\toprule")) { |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 128 | export <- sub("\\\\toprule", |
| 129 | paste0("\\\\toprule\n", caption.footnote), export) |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 130 | } else { |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 131 | export <- sub("\\\\hline", |
| 132 | paste0("\\\\hline\n", caption.footnote), export) |
| 133 | } |
| 134 | } |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 135 | for (i in (count.in.caption.note + 1):count.intablenote) { |
Hao Zhu | 4adea85 | 2015-11-16 16:38:34 -0500 | [diff] [blame] | 136 | export <- sub("\\[note\\]", |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 137 | paste0("\\\\footnote[", i, "]{", label[i], "}"), export) |
| 138 | } |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 139 | for (i in extra.notation) { |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 140 | export <- gsub(paste0("\\[note", i, "\\]"), |
| 141 | paste0("\\\\footnotemark[", i, "]"), |
| 142 | export) |
Hao Zhu | db04e30 | 2015-11-15 16:57:38 -0500 | [diff] [blame] | 143 | } |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 144 | } else { |
Hao Zhu | db04e30 | 2015-11-15 16:57:38 -0500 | [diff] [blame] | 145 | # Replace in-table notation with appropriate symbol |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 146 | for (i in 1:count.intablenote) { |
| 147 | export <- sub("\\[note\\]", |
| 148 | paste0("\\\\textsuperscript{", ids.intable[i], "}"), |
| 149 | export) |
Hao Zhu | db04e30 | 2015-11-15 16:57:38 -0500 | [diff] [blame] | 150 | } |
Hao Zhu | b1bc0aa | 2015-11-12 11:23:42 -0500 | [diff] [blame] | 151 | |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 152 | # Fix extra in table notation |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 153 | for (i in extra.notation) { |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 154 | export <- gsub(paste0("\\[note", i, "\\]"), |
| 155 | paste0("\\\\textsuperscript{", ids.intable[i], "}"), |
| 156 | export) |
Hao Zhu | db04e30 | 2015-11-15 16:57:38 -0500 | [diff] [blame] | 157 | } |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 158 | if (threeparttable == T) { |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 159 | # generate footer with appropriate symbol |
| 160 | footer <- "" |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 161 | for (i in 1:count.label) { |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 162 | footer <- paste0(footer,"\\\\item [", ids[i], "] ", label[i], "\n") |
| 163 | } |
| 164 | |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 165 | if (grepl("\\\\caption\\{.*?\\}", export)) { |
| 166 | export <- sub("\\\\caption\\{", |
| 167 | "\\\\begin{threeparttable}\n\\\\caption{", |
| 168 | export) |
| 169 | } else { |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 170 | export <- sub("\\\\begin\\{tabular\\}", |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 171 | "\\\\begin{threeparttable}\n\\\\begin{tabular}", |
| 172 | export) |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 173 | } |
| 174 | export <- gsub( |
| 175 | "\\\\end\\{tabular\\}", |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 176 | paste0("\\\\end{tabular}\n\\\\begin{tablenotes}\n\\\\small\n", |
| 177 | footer, "\\\\end{tablenotes}\n\\\\end{threeparttable}"), |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 178 | export) |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 179 | } else { |
| 180 | table.width <- max(nchar( |
| 181 | str_replace_all( |
| 182 | str_replace_all(kable_info$contents, "\\[note\\]", ""), |
| 183 | "\\[note[0-9]{1,2}\\]", ""))) + 2 * (kable_info$ncol - 1) |
| 184 | footer <- "" |
| 185 | for (i in 1:count.label) { |
| 186 | label.wrap <- strwrap(label[i], table.width) |
| 187 | footer <- paste0(footer, "\\\\multicolumn{", kable_info$ncol, |
| 188 | "}{l}{\\\\textsuperscript{", ids[i], "} ", |
| 189 | label.wrap[1], "}\\\\\\\\\n") |
| 190 | if (length(label.wrap) > 1) { |
| 191 | for (j in 2:length(label.wrap)) { |
| 192 | footer <- paste0(footer, "\\\\multicolumn{", kable_info$ncol, |
| 193 | "}{l}{", label.wrap[j], "}\\\\\\\\\n") |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 194 | } |
| 195 | } |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 196 | } |
| 197 | export <- gsub("\\\\end\\{tabular\\}", |
| 198 | paste0(footer, "\\\\end{tabular}"), |
| 199 | export) |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 200 | } |
Hao Zhu | db04e30 | 2015-11-15 16:57:38 -0500 | [diff] [blame] | 201 | } |
Hao Zhu | b1bc0aa | 2015-11-12 11:23:42 -0500 | [diff] [blame] | 202 | } |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 203 | |
| 204 | # HTML Tables ------------------- |
| 205 | if (attr(input, "format") == "html") { |
Hao Zhu | 2203f66 | 2015-11-20 11:53:39 -0500 | [diff] [blame] | 206 | # Clean the entry for labels |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 207 | label <- escape_html(label) |
Hao Zhu | dc4b714 | 2015-11-19 10:37:53 -0500 | [diff] [blame] | 208 | |
Hao Zhu | 2203f66 | 2015-11-20 11:53:39 -0500 | [diff] [blame] | 209 | # Replace in-table notation with appropriate symbol |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 210 | for (i in 1:count.intablenote) { |
| 211 | export <- sub("\\[note\\]", |
| 212 | paste0("<sup>", ids.intable[i], "</sup>"), |
| 213 | export) |
Hao Zhu | 2203f66 | 2015-11-20 11:53:39 -0500 | [diff] [blame] | 214 | } |
| 215 | |
| 216 | # Fix extra in table notation |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 217 | for (i in extra.notation) { |
Hao Zhu | 2203f66 | 2015-11-20 11:53:39 -0500 | [diff] [blame] | 218 | export <- gsub(paste0("\\[note", i, "\\]"), |
| 219 | paste0("<sup>", ids.intable[i], "</sup>"), |
| 220 | export) |
| 221 | } |
| 222 | |
| 223 | # Build footer |
| 224 | footer <- "<tfoot>\n" |
Hao Zhu | c541563 | 2017-02-21 17:16:13 -0500 | [diff] [blame] | 225 | for (i in 1:count.label) { |
Hao Zhu | 2203f66 | 2015-11-20 11:53:39 -0500 | [diff] [blame] | 226 | footer <- paste0(footer, "<tr>\n<td style = 'padding: 0; border:0;' ", |
| 227 | "colspan='100%'><sup>", ids[i],"</sup> ", |
| 228 | label[i], "</td>\n</tr>\n") |
| 229 | } |
| 230 | footer <- paste0(footer, "</tfoot>\n") |
| 231 | |
| 232 | # Paste footer to the table |
| 233 | export[1] <- gsub("</tbody>\n", paste0("</tbody>\n", footer), export[1]) |
Hao Zhu | b1bc0aa | 2015-11-12 11:23:42 -0500 | [diff] [blame] | 234 | } |
| 235 | return(export) |
| 236 | } |