Winter 2017 trip

Function for season

#########season function
Season <- function(data2) {
  d<- as.Date(strptime(data2$Start.Date,format="%d/%m/%Y %H:%M",tz="UTC"))
  WS <- as.Date("21/12/2017", format = "%d/%m/%Y") # Winter 
  SE <- as.Date("20/3/2017",  format = "%d/%m/%Y") # Spring 
  SS <- as.Date("21/6/2017",  format = "%d/%m/%Y") # Summer 
  FE <- as.Date("22/9/2017",  format = "%d/%m/%Y") # Fall
  
  ifelse (d >= WS | d < SE, "Winter",
          ifelse (d >= SE & d < SS, "Spring",
                  ifelse (d >= SS & d < FE, "Summer", "Autumn")))
}

Function to get data manipulated

seasonweekdata<- function(data1,coordinates=coor){
  data1<-data1 %>% select("StartStation.Id","EndStation.Id","Start.Date","StartStation.Name",
                          "EndStation.Name")
  
  ###merge coordinate
  #########################################################################
  a<- coor
  colnames(a)<- c("StartStation.Id","s.lat","s.lon")
  x<-join(data1,a)
  aa<- coor
  colnames(aa)<- c("EndStation.Id","e.lat","e.lon")
  #a<-setnames(coor,old=c("id","lat","long"),new=c("EndStation.Id","e.lat","e.lon"))
  #aa<-setnames(coor,old=c("id","lat","long"),new=c("StartStation.Id","s.lat","s.lon"))
  z<-join(x,aa)
  z<- na.omit(z)
  x<- count(z,vars = c("StartStation.Id","EndStation.Id"))
  data1<- join(z,x)
  #################weekdays############################################################
  data1$weekdays<-weekdays(
    strptime(data1$Start.Date,format="%d/%m/%Y %H:%M",tz="UTC")
  )
  data1$season<-Season(data2=data1)
  
  ########################################seasons
  return(data1)
  ##########same start and end stations #########################################
  #attach(bikedata)
  # bikedata$samestation<- rep(0,nrow(bikedata))
  #head(bikedata)
  #bikedata$samestation[which((StartStation.Id==EndStation.Id))]<- bikedata$freq[which((StartStation.Id==EndStation.Id))]
  str(data1)
  
}

Function for plots

wfullplot<- function(data5, source="google",maptype="roadmap",zoom=11){

  
  q<- seasonweekdata(data1 = bikedata)
  Winter<- q[q$season=="Winter",]

  map<- get_map(location = c(lon =mean(q$s.lon),lat = mean(q$s.lat)),
                source=source,maptype=maptype,zoom = zoom)
    ######################################winter
  plot<-ggmap(map)+
    geom_segment(data=Winter,aes(x=s.lon,y=s.lat,xend=e.lon, yend=e.lat,alpha=freq),
                 colour= "black",size=0.00001)+
    scale_alpha_continuous(range = c(0, 0.01))+
    ggtitle("2017 Winter bicycle trips")+
    xlim(range(q$s.lon))+
    ylim(range(q$s.lat))+
    geom_point(data=Winter,aes(x=s.lon,y=s.lat),size=0.001,alpha=0.3)+
    geom_label_repel(data=data5, aes(x=s.lon,y=s.lat,label=StartStation.Name),
                    color="blue",nudge_y = 0.03,nudge_x = -0.1,label.size = 0.05,
                    size=3,alpha=0.4
                    )+
                #    arrow =arrow(length =unit(0.5,"cm")))+
    geom_label_repel(data=data5, aes(x=e.lon,y=e.lat,label=EndStation.Name),
                    color="red",segment.size = 0.5,segment.colour = "red",
                    #arrow = arrow(length = unit(0.5,"cm")),
                  nudge_y = -0.03,nudge_x = 0.15,size=3,alpha=0.4)

  ############################################################summer
  
  return(plot)

  
}

Creating a frequency data

q<- seasonweekdata(data1 = bikedata)

## Joining by: StartStation.Id

## Joining by: EndStation.Id

## Joining by: StartStation.Id, EndStation.Id

Winter<- q[q$season=="Winter",]
Spring<- q[q$season=="Spring",]
Summer<- q[q$season=="Summer",]
Autumn<- q[q$season=="Autumn",]

topplace<- function(data4){
  top<- dplyr::select(data4,"s.lat","s.lon","StartStation.Name","EndStation.Name",
                      "freq",
               "e.lat","e.lon")
  top<-top[!duplicated(top),]
  top<-top_n(top, 5, freq)
  top<-arrange(top,desc(freq))
  return(top)

}

#sfullplot(zoom = 11,
 #        data5= topplace(data4 = Summer))

wfullplot(zoom = 11,
         data5= topplace(data4 = Winter))

## Joining by: StartStation.Id

## Joining by: EndStation.Id

## Joining by: StartStation.Id, EndStation.Id

## Map from URL : http://maps.googleapis.com/maps/api/staticmap?center=51.509149,-0.126408&zoom=11&size=640x640&scale=2&maptype=roadmap&language=en-EN&sensor=false

## Scale for 'x' is already present. Adding another scale for 'x', which
## will replace the existing scale.

## Scale for 'y' is already present. Adding another scale for 'y', which
## will replace the existing scale.