Project1 : Proposal Outline

Group Members

1. Rubalpreet Bhullar
2. Myfanwy Brown-Robinson
3. Sharanvika Jegatheeswaran
4. Manisha Lal
5. Catherine Tratnik

Topic: Bike Share Program

Data Sources:

1. Toronto 2019 January to December
2. Vancouver 2019 January to December

Dataset Summary (What are we targeting for with this dataset?)

With this dataset, we are aiming to look at if the bike share program is a necessity that can be implemented in other cities. By analyzing patterns of ridership usage, it allows us to interpret the data. Which, in return, suggests a better comprehension of the trends concerning the Bike Share program. The Bike Share Toronto Ridership data contains trip data, including: trip start time, trip end time, trip duration, trip start station, trip end station, and user type between the cities Toronto and Vancouver in 2019. An analysis of the effectiveness and efficiency of the bike share program in Toronto and Vancouver will onset the decision to implement this program in other cities as an eco and user-friendly program promoting health, eco-friendly transportation and tourism.

Key Questions

1. How many individuals use the Bikeshare program? What is the total number of trips taken within the year 2019?
2. In which season is the bike share usage most popular?
3. What are the users' primary motive for use of Bikeshare? What is the most popular station? From the placement of the station, can you determine the purpose of use for the bike (i.e. commuter, leisure, recreational)?
4. Do individuals tend to stay within the basic 30-minute allotted time, given that usage fees apply after 30 minutes? What is the average trip duration? What is the average trip duration on a quarterly basis?
5. What is the peak time of use for Bikeshare?
6. Which of these user types are more frequent users of the Bikeshare program? What percentage of the Bikeshare users are club members vs. public users?

Analysis

1. There are a total of 2,439,517 trips in Toronto and 891,051 in Vancover for the whole of 2019. Majority of these trips are made in the third quarter of the year when the weather is warmer.
2. In the course of the year, the highest bikeshare usage is in the summer months, specifically in August. Bikeshare usage is highest on Wednesdays for both Toronto and Vancouver.
3. Generally, the most popular station in Toronto is at station number 7076 located at York St/Queensway W. It is interesting to note that, for annual members, this location is the popular destination for bike users starting from the Sherbourne / Wellesley station while for casual users, the union station and this York St/Queensway W station is the most popular starting point and end point.
   In Vancouver, the most popular station is located at Stanley Park Information booth.
4. The average trip duration varies per quarter for both cities; the longest in the third quarter for Toronto and in the second quarter for Vancouver.
5. In the course of a whole day for both cities, more members use the bikeshare program between 3pm to 6pm.
6. In Toronto, casual members make up 89% of the total bikeshare program users and 11% are annual members. However, the majority of the trips are taken by annual members. Data shows that annual members have the highest usage all days of the week but drops in the weekends. Bikeshare usage for casual members goes up on the weekends.
   • Due to the limitations of our Vancouver data set, the number of users per membership type cannot be quantified. That being said, annual members have the highest frequency of using the bikeshare program.

Summary Findings

In summary, as the Ministry of Transportation of the regional municipality of Waterloo, we hoped to gather data on the Bikeshare program from two cities, Toronto & Vancouver. Insight into the efficiency and effectiveness in the usage of the program will reiterate means of implementing a similar program within our municipality. The data analysis of the two cities suggests the bikes share usage is most prevalent during the week as a mean of commuter transportation and tourist attraction. By looking at the frequency in use of specific station locations, time frame, usage of the bike share, and the user types, we can conclude that the bike share is a useful program to implement. It is a great program that brings awareness to local tourism, pushes to be eco friendly and improve daily live style (i.e. through exercise), and brings in the form of revenue that can be put towards improving our municipality.

Limitations

• Due to GitHub's upload file size limit of 100MB, files in Resources/Toronto folder are stored in .gitignore
• Membership ID information is not included in the Vancouver data set, we cannot quantify how many individuals are registered in the bikeshare program.

inclusions

1. this README.md file
2. BikeShare2019.ipynb - Toronto notebook
3. BikeShare2019Vancouver.ipynb - Vancouver notebook
4. Project-BikeShare2019.ipynb - execute this notebook to run Toronto and Vancouver notebooks
5. Project-Proposal-Outline.docx
6. Datasets
   • Toronto file in Resources/Toronto folder
   • Vancouver file in Resources/Vancouver folder
7. Plots in Images folder
   • Images/Toronto
   • Images/Vancouver