r - 如何从 kableExtra kbl 表中删除 NA？

Question

当我运行这段代码时:

library(kableExtra)

table %>%
  kbl(caption ="Table 3: Data for Difference Equation Estimation.",col.names = c("Location",
                           "Year",
                           "Price",
                           "Per Capita Quantity",
                           "$\\Delta{P}$",
                           "$\\Delta{Q}$")) %>%
  kable_styling(full_width = F, position = "left")

我得到以下信息:

如何删除 NA？

Answer 1

knitr::kable() 是 kableExtra::kbl() 的基础。如果您查看 knitr::kable() 的帮助文档，它说:

Missing values (NA) in the table are displayed as NA by default. If you want to display them with other characters, you can set the option knitr.kable.NA, e.g. options(knitr.kable.NA = '') to hide NA values.

因此你可以尝试:

options(knitr.kable.NA = '')

table %>%
  kbl(caption = "Table 3: Data for Difference Equation Estimation.",
      col.names = c("Location",
                    "Year",
                    "Price",
                    "Per Capita Quantity",
                    "$\\Delta{P}$",
                    "$\\Delta{Q}$")) %>%
  kable_styling(full_width = F, 
                position = "left")