如何在R中设置表滤波器?

发布于 2025-02-08 07:41:45 字数 464 浏览 3 评论 0原文

我将RMD文件编织到HTML中,为了将表放入HTML文件中,我使用KableExtra函数。现在,我想知道是否可以将过滤器添加到该表(例如在Excel中)以使其更具交互性并让用户过滤某些参数本身?

df <- data.frame (origin = c("A","B","C","D","E","F","G","H","I","J"),
              Percentage = c(23,16,32,71,3,60,15,21,44,60),
              rate = c(10,12,20,200,-25,12,13,90,-105,23),
              change = c(10,12,-5,12,6,8,0.5,-2,5,-2))

library(kableExtra)
df %>%
  kbl() %>%
  kable_material(c("striped", "hover"))

I knit my rmd file into HTML and in order to put my table in HTML file, I use the kableExtra function. Now, I wonder if it's possible to add a filter to this table (like in Excel) to make it more interactive and let user filter some parameters itself?

df <- data.frame (origin = c("A","B","C","D","E","F","G","H","I","J"),
              Percentage = c(23,16,32,71,3,60,15,21,44,60),
              rate = c(10,12,20,200,-25,12,13,90,-105,23),
              change = c(10,12,-5,12,6,8,0.5,-2,5,-2))

library(kableExtra)
df %>%
  kbl() %>%
  kable_material(c("striped", "hover"))

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

盗琴音 2025-02-15 07:41:45

您可能会在过滤和其他互动方面有更好的运气

df %>% DT::datatable(rownames=F, filter="top")

使用dt :: dataTable()有很多选项, ;例如,设置字体尺寸:

df %>% DT::datatable(rownames=F, filter="top") %>% 
  DT::formatStyle(columns = colnames(df), fontSize = '150%', color = 'red')

有关选项的全面处理,请参见 rstudio.github.github.io/dt/ options.html 和其他文档来源

You may have better luck with filtering and other interaction using DT::datatable()

df %>% DT::datatable(rownames=F, filter="top")

There are lots of options; for example, setting font size:

df %>% DT::datatable(rownames=F, filter="top") %>% 
  DT::formatStyle(columns = colnames(df), fontSize = '150%', color = 'red')

For full treatment of options, see rstudio.github.io/DT/options.html and other documentation sources

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文