接着上一节的内容，自己挖的坑跪着也要填上。
嗯......我是负责任的好孩子。
那么，直接进入正题。

states <- readOGR(dsn="...",
                  layer = "cb_2016_us_state_500k",verbose = FALSE)
states <- states %>% select(-STATEFP)

mean_rating_state <- user_rating %>% group_by(state) %>%
                     mutate(mean_rating_by_state = mean(rating)) %>%
                     select(state,mean_rating_by_state) %>%
                     unique

rating_state <- inner_join(states,mean_rating_state,by=c("STUSPS"="state"))

bins <- c(quantile(rating_state$mean_rating_by_state,probs = c(0,0.1,0.2,0.4,0.6,0.8,1)))
pal <- colorBin("YlOrRd", domain = rating_state$mean_rating_by_state, bins = bins)
labels <- sprintf(
  "<strong>%s</strong><br/>%g ",
  rating_state$STUSPS , rating_state$mean_rating_by_state) %>% lapply(htmltools::HTML)

m <- rating_state %>% leaflet() %>%
  setView(-100.2727, 37.8716,4) %>%
  addTiles() %>%
  addPolygons(
    fillColor = ~pal(mean_rating_by_state),
    weight = 2,
    opacity = 1,
    color = "white",
    dashArray = "3",
    fillOpacity = 0.7,
    highlight = highlightOptions(
      weight = 5,
      color = "#666",
      dashArray = "",
      fillOpacity = 0.7,
      bringToFront = TRUE),
    label = labels, 
    labelOptions = labelOptions(
    style = list("font-weight" = "normal", padding = "3px 8px"),
    textsize = "15px",
    direction = "auto"))%>% 
  addLegend(pal = pal, values = ~mean_rating_by_state, opacity = 0.7, title = NULL,
  position = "bottomleft") %>%
  addCircleMarkers(lng = -122.2727, lat = 37.8716)

data_male_animation <- all %>% filter(gender == "M") %>%
                      filter(str_detect(genres,"Animation")== TRUE) %>%
                      group_by(age) %>%
                      mutate(mean_rating_ma = mean(rating)) %>%
                      select(age,mean_rating_ma,occupation) %>%
                      unique

ggplot(data_male_animation,aes(age,mean_rating_ma))+
  geom_point()+
  geom_line(aes(group = occupation, color = as.factor(occupation) ))+
  labs(x='age',y='mean ratings',title='mean rating for drama movie by male by age') +
    theme(plot.title = element_text(hjust = 0.5))+
  labs(color = "Occupation")+
  scale_color_discrete(labels=c( "other or not specified","academic/educator","artist","clerical/admin","college/grad student","customer service","doctor/health care","executive/managerial","farmer","homemaker","K-12 student","lawyer","programmer","retired","sales/marketing","scientist","self-employed","technician/engineer","tradesman/craftsman","unemployed","writer"))

# ui.R

library(shiny)
library(ggplot2)

shinyUI(fluidPage(
  titlePanel("Reactive lines of ratings of movies by Gender and Genres"),
  sidebarLayout(sidebarPanel(
    selectInput("GenderSelector",
                label = "Select Plot Gender:",
                choice = c("Male","Female"),
                selected = "Male"),
    selectInput("GenresSelector",
                label = "Select Plot Genres:",
                choice = c("Action","Adventure","Animation","Children's","Comedy","Crime","Documentary","Drama","Film-Noir","Horror","Musical","Mystery","Romance","Sci-Fi","Thriller","War","Western"                ),
                selected = "Action")),
    mainPanel(
      textOutput("showTitle"),
      plotOutput("showThePlot")
    )
  )
))

# server.R

library(shiny)
library(tidyverse)
library(ggplot2)
library(dplyr)
library(lubridate)
library(stringr)

users <- read_delim("users.dat",col_names = FALSE,delim = "::")
users <- users %>% select(-X2,-X4,-X6,-X8) %>% 
  rename(user_id = X1, gender = X3,age = X5,occupation = X7,zip_code = X9)
users <- users %>% mutate(zip_code2 = substr(zip_code,1,5)) %>% 
  select(-zip_code) %>% rename(zip_code = zip_code2) %>%
  mutate(zip_code3 = substr(zip_code,1,3))
zipcode <- read_csv("zipcode.csv")
zipcode <- zipcode %>% select(-X3)
user_zipcode <- inner_join(users,zipcode,by=c("zip_code3"="zipcode"))
ratings <- read_delim("ratings.dat",col_names = FALSE,delim = "::")
ratings <- ratings %>% select(-X2,-X4,-X6) %>% 
  rename(user_id = X1, movie_id = X3,rating = X5,timestamp = X7)
ratings <- ratings %>% mutate(time = ymd_hms("1970-1-1 00:00:00")+seconds(timestamp)) %>%             select(-timestamp) %>%
  mutate(hour = hour(time))
user_rating <- inner_join(x=user_zipcode,y=ratings,by = "user_id") 

movie <- read_delim("movies.dat",col_names = FALSE,delim = "::")
movie <- movie %>% mutate(title1 = paste(X3,X4, sep = ":" )) %>%
  mutate(title = gsub(":NA","",title1)) %>%
  select(-X2,-X3,-X4,-title1) %>%
  rename(movie_id = X1, genres = X5) %>%
  mutate(year = str_match(title,"[0-9][0-9][0-9][0-9]"))
all <- inner_join(movie,user_rating)

data_selected <- function(x,y){
  ds<- all %>% filter(gender == x) %>%
    filter(str_detect(genres,y)== TRUE) %>%
    group_by(age) %>%
    mutate(mean_rating = mean(rating)) %>%
    select(age,mean_rating,occupation) %>%
    unique
  ds}

shinyServer(function(input, output) {
  
  output$showTitle <- renderText({
    paste("The lines plot of mean rating of",input$GenresSelector,"movies by",input$GenderSelector,"by age")
  })
  output$showThePlot <- renderPlot({
    gender <- switch(input$GenderSelector,
                   "Male"= "M",
                   "Female" = "F")
    
      ggplot(data_selected(gender,input$GenresSelector),aes(age,mean_rating))+
      geom_point()+
      geom_line(aes(group = occupation, color = as.factor(occupation) ))+
      labs(x='age',y='mean ratings') +
      theme(plot.title = element_text(hjust = 0.5))+
      labs(color = "Occupation")+
      scale_color_discrete(labels=c( "other or not specified","academic/educator","artist","clerical/admin","college/grad student","customer service","doctor/health care","executive/managerial","farmer","homemaker","K-12 student","lawyer","programmer","retired","sales/marketing","scientist","self-employed","technician/engineer","tradesman/craftsman","unemployed","writer"))
    
  }
  )
})