r - 如何调整使用 R kableExtra::add_header_above 创建的表中的标签?
问题描述
我如何(或我可以)调整使用创建的表格中的标签kableExtra::add_header_above()
?一个小例子:
library(knitr)
library(dplyr)
library(tidyr)
library(kableExtra)
df <- tibble(year = c(2017, 2018, 2017, 2018),
major_item = "M",
sub_item = c( "A", "A", "B", "B"),
n = c( 1:4))
df %>%
filter(sub_item == "A") %>%
select(-sub_item) %>%
spread(year,n) %>%
# now join with the part for which sub_item == "B"
left_join(df %>%
filter(sub_item == "B") %>%
select(-sub_item) %>%
spread(year,n),
by = c("major_item" = "major_item")) %>%
# now the nice header
kable("latex", booktabs = T) %>%
kable_styling() %>%
add_header_above(c(" " = 1, "A" = 2, "B" = 2))
结果是:
当然出现后缀.x是因为有同名的列,一组是不允许的。我该怎么做才能使 2017.x 和 2018.x 与其他列 2017 和 2018 相同?任何关于如何以更少的步骤获得结果表的提示也非常受欢迎。谢谢!
2019_09_26 更新:感谢 pivot_wider,我找到了一种优雅的表格结构方式,感谢 iago,它具有所需的列名:
df %>%
# the table structure
pivot_wider(names_from = c(year, sub_item),
values_from = n) %>%
# the nice headings
kable("latex", booktabs = T,
col.names = c("", "2017", "2018", "2017", "2018")) %>%
kable_styling() %>%
add_header_above(c(" " = 1, "A" = 2, "B" = 2))
解决方案
我会做:
library(knitr)
library(dplyr)
library(tidyr)
library(kableExtra)
df <- tibble(year = c(2017, 2018, 2017, 2018),
major_item = "M",
sub_item = c( "A", "A", "B", "B"),
n = c( 1:4))
df %>%
filter(sub_item == "A") %>%
select(-sub_item) %>%
spread(year,n) %>%
# now join with the part for which sub_item == "B"
left_join(df %>%
filter(sub_item == "B") %>%
select(-sub_item) %>%
spread(year,n),
by = c("major_item" = "major_item")) %>%
# now the nice header
kable("latex", booktabs = T, col.names = c("major_item","2017","2018","2017","2018")) %>%
kable_styling() %>%
add_header_above(c(" " = 1, "A" = 2, "B" = 2))
推荐阅读
- javascript - 反应:子组件中的切换功能未按预期工作
- javascript - 如何通过 JS 脚本或在 React Native 中运行 Monero CLI 命令?
- python - 无法设置 python 事件标志
- javascript - 包含链接的 div 的 Javascript dom 子项
- css - 用户向下滚动时扩展和更改导航栏
- java - 当基础 IAction 贡献项更新时刷新 IContributorManager
- html - z-index 堆叠指定之外的元素
- gps - 不同的结果来自 2 个相同的 gps 模块,在相同的位置使用相同的程序
- php - 在 PHP 中显示 MySQL 请求
- asp.net-mvc - 获取 web api 的属性值 Sharepoint 属性包