Citi Bike is New York City’s public bicycle sharing system that was launched in May 2013. It is the largest in the nation and currently serving the New York City boroughs of the Bronx, Brooklyn, Manhattan, and Queens, as well as Jersey City, New Jersey. More details about an interesting Citi Bike story can be found in About Citi Bike and Wikipedia.
Citi Bike Program has implemented a robust infrastructure for collecting data on the program’s utilization. Through the team’s efforts, each month bike data is collected, organized, and made public on the Citi Bike Data webpage.
The purpose of this project was to aggregate data found in the Citi Bike History Logs and find several interesting insights from data. Due to enormous amount of data we focused on Jersey City data from 2018 to 2020. This notebook contains code to prepare data to be used in Tableau Public.
The following designed visualizations were used to assemble dashboards and finally our Story:
- Several data breakdowns – rides, age, gender, user type
- Time distribution of rides
- Bike utilization and maintenance
- Start stations and end stations mapping
- COVID-19 impact
The Story can be seen in my Tableau profile and the workbook can be downloaded from GitHub.
- Tools/techniques used: Tableau, Python, Pandas, Jupyter Notebook
GitHub Repository for this project.