我的问题类似于这个previous post,因为我想有条件地格式化某些值,而忽略NA.我发现NA被cell_spec()
后面的单元规范覆盖,结果options(knitr.kable.NA = '')
不工作.有人能帮忙吗?示例数据如下.
library(tidyverse)
library(kableExtra)
df <- data.frame(
name = paste("Name", LETTERS[1:10]),
var1 = c(0.5, -1.3, NA, 3.4, -2.6, 0.8, NA, 0.3, 2, -1.6)
)
df_fill <- df %>%
mutate(var1 = cell_spec(
var1,
background = case_when(
var1 >= 1 ~ "#FEDCDA",
var1 <= -1 ~ "#E5F8E0",
.default = "white")
)
)
options(knitr.kable.NA = '')
kbl(df_fill,
booktabs = TRUE,
escape = FALSE,
linesep = "") %>%
kable_styling(latex_options = c("HOLD_position"),
font_size = 8)