Grab a Bike App

by Fig & Co

  • Noraisha Yusuf (WQD180008)
  • Low Tsu Siang (WQD180072)
  • Kaveenaasvini (WQD180017)
  • Prabavathi (WQD180030)

Behind the scenes

Inspiration

Q: Where and When did the bikers loved to ride rental bikes in 2017?

Scope

  • Dataset source: Divvy Bike Sharing System (Est. 2013)

  • Location: Chicago City

  • Year: 2017

Targeted app users

  • Bikers Find less crowded time, popular stations (e.g. touristic destination)

  • Businesses Targeted adverts, find new business location

  • Bike company Scheduling maintenance plan

Preparing the dataset

  • Extracted & transformed relevant features e.g. extracted hour from stop time

  • Computed total number of trips based on the chosen features

Final Dataset 

[1] 1537545       7
arr_date arr_hour to_station_name latitude longitude gender total_trips
795797 2017-07-22 12 State St & Randolph St 41.88473 -87.62773 Female 1
565225 2017-06-12 23 Woodlawn Ave & 55th St 41.79526 -87.59647 Male 1
481774 2017-05-29 19 Larrabee St & Oak St 41.90022 -87.64299 Female 1
1199868 2017-09-27 18 Greenwood Ave & 47th St 41.80983 -87.59938 Male 1
1078389 2017-09-07 14 Calumet Ave & 18th St 41.85761 -87.61941 Male 1
1335675 2017-10-24 18 McClurg Ct & Erie St 41.89450 -87.61785 Female 1

EDA: Cycling trips at its peak

Mid June - October of 2017 plot of chunk unnamed-chunk-2

Around 8 a.m. & 5 p.m. plot of chunk unnamed-chunk-3

Check out our App!

Even better, Grab a Bike app will provide micro view of bike trips at every 592 stations , based on any date, hour range and gender

g

capture

For source code, visit: