我正在使用DT包为由数字单元格值组成的频率表着色(df_numbered,见下文)。
库(DT)df_numbered< - data.frame(cat1 = 1:3, cat2 = …
您可以从绑定两个数据帧开始:
df_numbered <- data.frame(c1 = 1:3, c2 = 4:6, c3 = 7:9) df_labeled <- data.frame(cat1 = letters[1:3], cat2 = letters[4:6], cat3 = letters[7:9]) df <- cbind(df_labeled, df_numbered)
然后你可以这样格式化:
formatStyle(names(df_labeled), valueColumns = names(df_numbered), backgroundColor = styleInterval(brks, clrs))
但你不想要 df_numbered 列,所以隐藏它们:
df_numbered
datatable(df, options = list( columnDefs = list( list(visible = FALSE, targets = 4:6) ) )) %>% formatStyle(names(df_labeled), valueColumns = names(df_numbered), backgroundColor = styleInterval(brks, clrs))