Select columns for reactive heatmap

Question

I'm building a Shiny app and want to reactivity control which columns get displayed in a heatmap. I'd like for all of the columns to be displayed at first and then be able to subset it by deselecting columns from a checkboxGroupInput.

When I run the code, the heatmap doesn't appear. I tried troubleshooting by looking at the df_select dataframe but it only has the "mpg" column when it should have all of them (mpg:carb) initially. Including View(df_select) throws an error so it is commented out below.

Any help would be greatly appreciated.

app.R

library(ggplot2)
library(d3heatmap)
library(dplyr)
library(shiny)

## ui.R
ui <- fluidPage(
  sidebarPanel(
    h5(strong("Dendrogram:")),
    checkboxInput("cluster_row", "Cluster Rows", value=FALSE),
    checkboxInput("cluster_col", "Cluster Columns", value=FALSE),
    checkboxGroupInput("col_list", "Select col to include:", names(mtcars), selected=names(mtcars)),
    h5(strong("Sort:")),
    checkboxInput("check_sort", "Sort (Yes/No)", value=FALSE),
    selectInput("sort", "Sort:", names(mtcars), selected="mpg")
  ),
  mainPanel(
    h4("Heatmap"),
    d3heatmapOutput("heatmap", width = "100%", height="600px")
  )
)

## server.R
server <- function(input, output) {

  df_select <- reactive({
    all <- names(mtcars)
    print(all) #debug
    selection <- input$col_list
    print(selection) #debug
    if("All" %in% input$col_list || length(input$col_list) == 0){
      selection <- all
    }else{
      selection <- input$col_list
    }
    df_select <- select_(mtcars, selection)
    #View(df_select) #debug
  })

  df_sort <- reactive({
    df_sort <- if(input$check_sort==FALSE) df_select() else arrange_(df_select(), input$sort)
  })

  output$heatmap <- renderD3heatmap({
    d3heatmap(df_sort(),
      colors = "Blues",
      if (input$cluster_row) RowV = TRUE else FALSE,
      if (input$cluster_col) ColV = TRUE else FALSE,
      yaxis_font_size = "7px"
    ) 
  })
}

shinyApp(ui = ui, server = server)

Answer 1

It is a standard evaluation issue. Use select_(mtcars, .dots=selection) (line number 38).