How to create dynamic filtering in data science reports and dashboards

Reading time:

time

min

January 5, 2017

R has long ago stopped to be a language only for statistical analysis. It’s also a great tool for communicating the results of data scientist’s work. With RMarkdown and Shiny it’s very easy to quickly design great reports and applications. We want to share few tricks to make your reports and apps more interactive and show you how components can talk to each other. <h2 id="what-is-crossfiltering">What is crossfiltering?</h2> Let’s take a look at crossfiltering, which is filtering for coordinated views. Simply by interacting with one component the related element, like chart or table, can update automatically. For example you can zoom a map or select subrange in a plot and get your whole interface reflect that immediately as in Business Intelligence tools. <h2 id="htmlwidgets-and-crosstalk">Htmlwidgets and Crosstalk</h2> First let’s have a look at a <a href="https://github.com/rstudio/crosstalk">crosstalk</a> package that allows us to crossfilter between different <a href="http://www.htmlwidgets.org/" target="_blank" rel="noopener noreferrer">htmlwidgets</a>. Currently only available on Github. We need to install crosstalk: <figure class="highlight"> <pre><code class="language-r" data-lang="r">devtools::install_github("rstudio/crosstalk")</code></pre> </figure> We use htmlwidgets from leaflet and DT packages that are compatible with crosstalk. <figure class="highlight"> <pre><code class="language-r" data-lang="r">devtools::install_github("rstudio/DT") devtools::install_github("rstudio/leaflet")</code></pre> </figure> We need developer versions for components to enable crosstalk. In our example we use marine data for Baltic Sea area that contains ship name, speed and its location (latitude and longitude). We display the ships coordinates on a leaflet map and provide additional information in a DT table. Using the crop button on the map we can filter the data in the table. <figure class="highlight"> <pre><code class="language-text" data-lang="text">## Error in library(crosstalk): there is no package called 'crosstalk'</code></pre> </figure> <figure class="highlight"> <pre><code class="language-text" data-lang="text">## Error in library(leaflet): there is no package called 'leaflet'</code></pre> </figure> <figure class="highlight"> <pre><code class="language-text" data-lang="text">## Error in library(DT): there is no package called 'DT'</code></pre> </figure> <figure class="highlight"> <pre><code class="language-text" data-lang="text">## Error in eval(expr, envir, enclos): object 'SharedData' not found</code></pre> </figure> <figure class="highlight"> <pre><code class="language-text" data-lang="text">## Error in bscols(leaflet(ships_shared) %>% addTiles() %>% addMarkers(), : could not find function "bscols"</code></pre> </figure> Unfortunately table filter does not update dynamically when we navigate map using drag and drop or mouse scroll. An alternative to crosstalk is <a href="https://github.com/ramnathv/robservable" target="_blank" rel="noopener noreferrer">robservable</a> an R package that brings observables to htmlwidgets, allowing for shiny-like interactivity in the browser. <h2 id="crossfilter-in-shiny">Crossfilter in Shiny</h2> In Shiny we can filter table when zooming or changing the area of the map. In order to do that we need to use <code class="highlighter-rouge">bounds</code> which are input from the leaflet map. From leaflet R package documentation we know that <code class="highlighter-rouge">input$MAPID_bounds</code> provides the latitude/longitude bounds of the currently visible map area. Below we have an example of how to create a coordinated map and table in Shiny. In our case we create a new reactive variable containing filtered data, where we filter latitude and longitude on bounds elements (<code class="highlighter-rouge">east, west, north, south</code>). UI of the app is straightforward. Core logic is the dynamic filtering of table where we use reactive value of <code class="highlighter-rouge">input$map_bounds</code>. <figure class="highlight"> <pre><code class="language-r" data-lang="r">library(shiny) library(magrittr) ships <- read.csv("https://raw.githubusercontent.com/Appsilon/crossfilter-demo/master/app/ships.csv") ui <- shinyUI(fluidPage( fluidRow( column(6, leaflet::leafletOutput("map")), column(6, DT::dataTableOutput("tbl")) ) )) server <- shinyServer(function(input, output) { output$map <- leaflet::renderLeaflet({ leaflet::leaflet(ships) %>% leaflet::addTiles() %>% leaflet::addMarkers() }) in_bounding_box <- function(data, lat, long, bounds) { data %>% dplyr::filter(lat > bounds$south & lat < bounds$north & long < bounds$east & long > bounds$west) } data_map <- reactive({ if (is.null(input$map_bounds)){ ships } else { bounds <- input$map_bounds in_bounding_box(ships, lat, long, bounds) } }) output$tbl <- DT::renderDataTable({ DT::datatable(data_map(), extensions = "Scroller", style = "bootstrap", class = "compact", width = "100%", options = list(deferRender = TRUE, scrollY = 300, scroller = TRUE, dom = 'tp')) }) }) shinyApp(ui = ui, server = server)</code></pre> </figure>  <iframe src="http://demo.appsilon.com/crossfilter-demo/" width="100%" height="400" frameborder="0" scrolling="yes"></iframe>  <h2 id="summary">Summary</h2> We showed you two simple examples of how to build coordinated leaflet map and DT table in RMarkdown and Shiny. We highly encourage you to try it yourself and also look at more examples available on <a href="https://github.com/rstudio/crosstalk" target="_blank" rel="noopener noreferrer">crosstalk</a> page. Shiny app code used in this example is also available on <a href="https://github.com/Appsilon/crossfilter-demo" target="_blank" rel="noopener noreferrer">Github</a>.