I have the following Rmarkdown Shiny:
---
title: "My Title"
runtime: shiny
output:
flexdashboard::flex_dashboard:
vertical_layout: scroll
theme: bootstrap
orientation: rows
---
```{r setup, include=FALSE}
library(flexdashboard)
```
Rows {data-height=700}
-----------------------------------------------------------------------
### Mate-pair Mapping Distribution
```{r mate_pair_distribution, echo=FALSE}
library(ggplot2)
library(tidyverse)
sidebarPanel(
selectInput("col_id", label = "Features",
choices = c("carat", "depth","price"), selected = "price"),
selectInput("op_id", label = "Quality:",
choices = c("All", "Ideal","Premium","Good","Very Good"), selected = "Good"),
sliderInput("n_breaks", label = "Number of bins:",
min = 20, max = 50, value = 30, step = 1)
)
#renderText(input$op_id)
mainPanel(
renderPlot({
# Prepare for the data
dat <- diamonds %>% filter(cut == input$op_id)
if(input$op_id == "All") {
dat <- diamonds
}
# Plotting
ggplot(dat, aes(dat %>% select(.,contains(input$col_id)))) +
ggtitle(input$op_id, subtitle = input$col_id) +
geom_histogram(bins = input$n_breaks) +
scale_x_continuous() +
xlab(input$col_id) +
theme_light()
}, height=400, width=400),
br(),
br(),
renderPrint({
dat <- diamonds %>% filter(cut == input$op_id)
if(input$op_id == "All") {
dat <- diamonds
}
dat %>%
select(.,contains(input$col_id)) %>%
summarise(mean = mean(input$col_id), sd=sd(input$col_id), n=n())
})
)
```
Which produce this output
As you can see the renderText()
show NA
in mean
and sd
values.
It's caused by this line
dat %>%
select(.,contains(input$col_id)) %>%
summarise(mean = mean(input$col_id), sd=sd(input$col_id), n=n())
So how can I make input$col_id
consumable for summarise()
?
What's the right way to do it?
Non-Shiny context the result is:
> diamonds %>% filter(cut=="Good") %>% select(price) %>% summarise(mean = mean(price), sd=sd(price), n=n())
# A tibble: 1 × 3
mean sd n
<dbl> <dbl> <int>
1 3928.864 3681.59 4906