Shiny selectInput from column DF

Question

Currently i am working on my own shinydashboard. And i would like to ask you for help. I would like to show Data_Location()$Address in my inputbox that is corresponding to Data_Location()$Location_skey. Normally you can do it like this:

selectInput("KPI", "Choose a KPI:", choices = c("Aantal Sessies Aansluiting"="AantalSessiesAansluiting",
                                                                               "Aantal Unieke RFIDS Aansluitingg"="AantalUniekeRFIDsAansluiting",
                                                                               "Beschikbare Dagen Aansluiting"="BeschikbareDagenAansluiting",selected="")

The difference is that I want to use a dataframe column.

head(Data_Location()$Location_skey)
[1] -1  
[2]  1  
[3]  2  
[4]  3  
[5]  4 

head(Data_Location()$Address)
[1] onbekend
[2] Putstraat 86
[3] 1e De Riemerstraat 1   
[4] Van Spaenstraat 23     
[5] Suze Groeneweglaan 323 

selectInput("location", "Selected a charge point",choices =c("",Data_Location()$Location_skey), selected="")

I would like to thank you for reading this post and I would be very pleased if you could help me out.

Thanks!

Mike Wise Mike Wise · Accepted Answer · 2016-06-08T10:33:32

I think this is what you want:

library(shiny)

ui <- fluidPage(
    selectInput("sip","select",choices=1:3)
) 

server <- function(input,output,session){
  df <- data.frame(cnames=c("a","b","c"),keys=c(1,2,3))
  chlst <- df$keys
  names(chlst) <- df$cnames
  updateSelectInput(session,"sip",label="label",choices=chlst)
} 
shinyApp(ui,server)

yielding:

Shiny selectInput from column DF

1 Answers