Divvy is a bike-sharing system in Chicago, owned by the Chicago Department of Transportation. It was launched in 2013 and purchased by Lyft in 2019. Divvy is considered one of the primary bike-share system in Chicago, with over 400,000 new riders and 5.5 million rides taken in 2021. Divvy has two primary group users, which are annual membership riders and casual riders. One of Divvy’s goals is to increase the number of annual membership riders. This project will focus on in-depth analysis of Divvy’s rider behavior and how external factors impact its ridership.
Through this project, Divvy wants to understand more about their both group riders and which factors that may impact their ridership so they can improve their
bike-sharing system and bike allocation, as well as develop marketing strategies to the bike-sharing system and attract more annual membership riders.
Particularly, Divvy leadership want to understand the ridership and bicycle allocation by stations, like which stations tend to have the most riders and bikes or
bike docks. Weather conditions such as temperature, precipitation, snow, or windspeed can be key factors that influence Divvy ridership.
In terms of riders, we want to understand more about the rider regarding user groups and demographic (population, age).
We will also analyze their behaviors based on their average using time and average traveling distance, day of the week or time of the day has the highest number
of riders, etc.
- Trip data from the Divvy: https://divvy-tripdata.s3.amazonaws.com/index.html
- Station data from Chicago Data Portal: https://data.cityofchicago.org/Transportation/Divvy-Bicycle-Stations/bbyy-e7gq/data
- Weather data from National Weather Service: https://www.weather.gov/wrh/climate?wfo=lot
- Population data from Chicago Data Portal: https://data.cityofchicago.org/Health-Human-Services/Chicago-Population-Counts/85cm-7uqa
MySQL, Google Cloud Platforms, Excel, Python, R, Tableau