inst/examples/shinyExample.R

In agstudy/rpivot: Create Interactive pivot table the JavaScript 'orb' Library

library(rpivot)
library(shiny)
library(ggvis)
library(dplyr)

canData <- '
Candidate,Party,Province,Age,Gender
"Liu, Laurin",NDP,Quebec,22,Female
"Mourani, Maria",Bloc Quebecois,Quebec,43,Female
"Mars, Silvia",Bloc Quebecois,Quebec,34,Female
"Sellah, Djaouida",NDP,Quebec,,Female
"St-Denis, Lise",NDP,Quebec,72,Female
"Fry, Hedy",Liberal,British Columbia,71,Female
"Turmel, Nycole",NDP,Quebec,70,Female
"Sgro, Judy",Liberal,Ontario,68,Female
"Raynault, Francine",NDP,Quebec,67,Female
"Davidson, Patricia",Conservative,Ontario,66,Female
"Smith, Joy",Conservative,Manitoba,65,Female
"Wong, Alice",Conservative,British Columbia,64,Female
"ONeill Gordon, Tilly",Conservative,New Brunswick,63,Female
"Ablonczy, Diane",Conservative,Alberta,63,Female
"Duncan, Linda Francis",NDP,Alberta,63,Female
"Bennett, Carolyn",Liberal,Ontario,62,Female
"Nash, Peggy",NDP,Ontario,61,Female
"Mathyssen, Irene",NDP,Ontario,61,Female
"Sims, Jinny Jogindera",NDP,British Columbia,60,Female
"Foote, Judy",Liberal,Newfoundland,60,Female
"Crowder, Jean",NDP,British Columbia,60,Female
"Davies, Libby",NDP,British Columbia,59,Female
"Yelich, Lynne",Conservative,Saskatchewan,59,Female
"Day, Anne-Marie",NDP,Quebec,58,Female
"May, Elizabeth",Green,British Columbia,58,Female
"Murray, Joyce",Liberal,British Columbia,58,Female
"Findlay, Kerry-Lynne D.",Conservative,British Columbia,57,Female
"Brown, Lois",Conservative,Ontario,57,Female
"Boutin-Sweet, Marjolaine",NDP,Quebec,57,Female
"Crockatt, Joan",Conservative,Alberta,56,Female
"Chow, Olivia",NDP,Ontario,55,Female
"McLeod, Cathy",Conservative,British Columbia,55,Female
"Finley, Diane",Conservative,Ontario,55,Female
"LeBlanc, Helene",NDP,Quebec,54,Female
"Grewal, Nina",Conservative,British Columbia,54,Female
"Hughes, Carol",NDP,Ontario,54,Female
"Shea, Gail",Conservative,Prince Edward Island,53,Female
"Truppe, Susan",Conservative,Ontario,53,Female
"Young, Wai",Conservative,British Columbia,52,Female'
con <- textConnection(canData)
canadianElections <- read.csv(con, header=TRUE, stringsAsFactors = FALSE)
canadianElections$votes <- round(runif(nrow(canadianElections), min=500, max=15000))

# save(file="./data/canadianElections.rda",canadianElections )

ui = shinyUI(fluidPage(
  fluidRow( pivotOutput("pivot")
            # , fluidRow( ggvisOutput("lgraph") )
  )))

server = function(input, output, session) {
  reactive({
    canadianElections %>% select(Province,Party,votes) %>% group_by(Party, Province) %>% summarise(votes=sum(votes)) -> candf
    ggvis(canadianElections, ~Province, ~votes, fill = ~ Party) %>%
      layer_bars(width=0.4) %>%  scale_nominal("fill")
  }) %>%  bind_shiny("lgraph")

  output$pivot <- renderPivot({
    fields = list(
      list(name= 'Candidate', caption= 'Candidate' ),
      list(name= 'Party', caption= 'Party' ),
      list( name= 'Province', caption= 'Province', sort= list( order= 'asc' ) ),
      list( name= 'Age', caption= 'Age' ),
      list( name= 'Gender', caption= 'Gender', sort= list( order= 'desc' ) ),
      list(
        name= 'votes',
        caption= 'votes',
        dataSettings= list(
          aggregateFunc= 'avg',
          formatFunc = htmlwidgets::JS('function(value) {
            return value ? Number(value).toFixed(2) : \'\';
          }')
        )
      )
    )
    rpivot(dataSource =   canadianElections   ,fields=fields,  rows = list( "Province"),columns=list("Party"),
                data = list("votes"), width="50%", height="550px")
  })

}

shinyApp(ui = ui, server = server)