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/2016", format = "%d/%m/%Y") # Winter
SE <- as.Date("20/3/2016", format = "%d/%m/%Y") # Spring
SS <- as.Date("21/6/2016", format = "%d/%m/%Y") # Summer
FE <- as.Date("22/9/2016", format = "%d/%m/%Y") # Fall
ifelse (d >= WS | d < SE, "Winter",
ifelse (d >= SE & d < SS, "Spring",
ifelse (d >= SS & d < FE, "Summer", "Autumn")))
}
seasonweekdata<- function(data1,coordinates=coor){
data1<-data1 %>% select("StartStation.Id","EndStation.Id","Start.Date")
###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 to get data manipulated
fullplot<- function(data,source="google",maptype="roadmap",zoom = 11
){
attach(data)
map<- get_map(location = c(lon = mean(data$s.lon),lat = mean(data$s.lat)),
source="google",maptype="roadmap",zoom = 11)
##############spring
plot<-ggmap(map)+
geom_curve(data=data,aes(x=s.lon, y=s.lat, xend=e.lon, yend=e.lat, alpha=freq),
colour= "black",size=0.01,curvature = 0.2)+
ggtitle("Spring 2016 bicycle trip")+
# scale_alpha_continuous(range = c(0, 0.5))+
xlim(range(s.lon))+
ylim(range(s.lat))+
geom_point(data=data,
aes(x=s.lon,y=s.lat),size=0.001,alpha=0.3)
return(plot)
}
fullplot(data = seasonweekdata(data1=bikedata))
## 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.509415,-0.124894&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.
## Warning: Removed 1 rows containing missing values (geom_rect).
## Warning: geom_curve is not implemented for non-linear coordinates
