我想显示按store 类型(汽车或美容)分层的数据.使用gtsum包tbl_strata()函数可以很好地处理所有变量,但只有一个变量是美容店变量,因此对于汽车店来说完全没有这个变量.对于这一个问题变量,输出在顶行显示为零(NA%),这是我不希望看到的.下面我展示了一个小的、可重现的示例,其中只有几个问题变量的值来显示问题.
以下是我的rmarkdown代码:
library(gtsummary) # for tbl_strata() for more customizable demographics table
library(gt) # for making nice looking display tables
library(tidyverse) # for data wrangling
test.tb <- tibble(
auto_or_beauty = c("Beauty", "Beauty", "Beauty", "Beauty", "Beauty", "Auto", "Auto", "Beauty", "Beauty", "Beauty"),
specific_beauty_shop_type = c("Hair only", "Hair and nails", "Hair only", "Hair and nails", "Hair only", NA, NA, "Hair and nails", "Hair only", "Hair only"),
intervention_group = c("Delayed", "Delayed", "Delayed", "Immediate", "Immediate", "Delayed", "Immediate", "Delayed", "Immediate", "Immediate")
)
test.tb %>%
# create a tbl_summary() table within each level of auto_or_beauty
tbl_strata(
strata = auto_or_beauty,
.tbl_fun =
~ .x %>%
tbl_summary(by = intervention_group)) %>%
as_gt()
我不希望Auto下的顶部行的SPECIFICATE_WARTY_SHOP_TYPE变量为0(NA%)0(NA%).此外,我更希望未知变量的数量显示在变量级别之后的底部,而不是顶部:我将如何做到这一点?(对于我的所有其他变量,UNKNOWN默认为底部.)
谢谢!我刚开始学习gtsum,我很欣赏它的灵活性,因为它允许我准确地指定我想要的表的方式(它比我以前使用的包灵活得多).然而,当我遇到这样一个奇怪的 case 时,我正在苦苦挣扎着该怎么办.
EDIT:我的实际数据表也有其他变量和p值,每个p值都有单独的脚注.我能不能不让它为特定的_FAIETY_SHOP_TYPE变量计算Auto Shop的p值,并且在那里也不加脚注?以下是更新后的示例的代码:
test.tb <- tibble(
auto_or_beauty = c("Beauty", "Beauty", "Beauty", "Beauty", "Beauty", "Auto", "Auto", "Beauty", "Beauty", "Beauty"),
specific_beauty_shop_type = c("Hair only", "Hair and nails", "Hair only", "Hair and nails", "Hair only", NA, NA, "Hair and nails", "Hair only", "Hair only"),
intervention_group = c("Delayed", "Delayed", "Delayed", "Immediate", "Immediate", "Delayed", "Immediate", "Delayed", "Immediate", "Immediate"),
home_business = c("Yes", "Yes", "No", "No", "No", "Yes", "No", "Yes", "Yes", "No")
)
test.tb %>%
tbl_strata(
strata = auto_or_beauty,
.tbl_fun =
~ .x %>%
tbl_summary(by = intervention_group) %>%
add_p() %>%
separate_p_footnotes()
)