Shiny/Rmarkdown/Flexdashboard中无需用户输入操作响应式数据框的方法
解决方案
Shiny中响应式函数执行myData()后返回的就是普通数据框,你可以直接对返回结果使用任意数据框操作语法实现列选择、行过滤,无需额外适配。
1 更稳妥的列选择方案
不推荐用列索引选择,一旦后续接口返回的列顺序调整,会导致选择的列错位。建议直接用列名选择,和你在myData内部的dplyr::select用法一致:
renderDT({ # 先确保myData已经生成,避免空值报错 req(myData()) # 按列名选择需要展示的字段 display_df <- myData() %>% dplyr::select(var2, var3, var4) DT::datatable(data = display_df, extensions = "Buttons", options = list( # 注意这里的索引是展示列的索引,从0开始计数 columnDefs = list(list(className = 'dt-center', targets = c(0,1,2))), pageLength = 10, searchHighlight = TRUE, language = list(url = '//cdn.datatables.net/plug-ins/1.10.11/i18n/Spanish.json'), buttons = list("copy", "print", list( extend = "collection", buttons = c("csv","excel","pdf"), text = "Descargar" )), dom = "Bftip" )) })
2 行过滤实现方法
和列选择逻辑一致,直接对myData()返回的普通数据框使用过滤语法即可,比如你要筛选var3大于100、var6等于"生效"的行:
renderDT({ req(myData()) # 先过滤行,再选择需要展示的列 display_df <- myData() %>% dplyr::filter(var3 > 100, var6 == "生效") %>% dplyr::select(var2, var3, var4) DT::datatable(data = display_df, extensions = "Buttons", options = list( columnDefs = list(list(className = 'dt-center', targets = c(0,1,2))), pageLength = 10, searchHighlight = TRUE, language = list(url = '//cdn.datatables.net/plug-ins/1.10.11/i18n/Spanish.json'), buttons = list("copy", "print", list( extend = "collection", buttons = c("csv","excel","pdf"), text = "Descargar" )), dom = "Bftip" )) })
3 复用处理后的数据
如果多个地方需要用到处理后的数据,可以单独封装成新的响应式变量,避免重复写过滤、选择逻辑:
# 放在server函数内,和myData同级 processedData <- reactive({ req(myData()) myData() %>% dplyr::filter(var3 > 100, var6 == "生效") %>% dplyr::select(var1, var2, var3, var4, var6) }) # 后续renderDT直接调用即可 renderDT({ DT::datatable(data = processedData(), extensions = "Buttons", # 其余配置保持不变 ) })
内容的提问来源于stack exchange,提问作者Wolkuz
相关产品推荐
相关产品推荐

