About Citibike🗽

Citibike is a well-known bike sharing/renting system in New York City. It is privately owned by Lyft and operates in the boroughs of the Bronx, Brooklyn, Manhattan, Queens, Jersey City New Jersey, and Hoboken New Jersey. The system was proposed in 2008 but officially started in 2013 with 332 stations and 6,000 bikes. As of today, there are 17,000 bikes with approximately 50,000 rides on average daily.

About the sampled data👀

The official Citibike data is available on their website (https://citibikenyc.com/system-data) but they are huge and most of the data is divided into months. Thankfully, Google BigQuery has a united dataset for citibike under bigquery-public-data and it is freely available. But in this dataset, trips table has whopping 5 million rows of data! To get insights and practice data analysis, we do not need that much most of the time. So I queried the dataset with a few cleaning involved and randomly sampled 0.01 of the original data and exported it. Therefore, I acquired a sampled data table with about 470,000 rows and it is correctly representative of the 2013-2017 period. There are some citibike data on Kaggle right now but they do not have the time span as in this data. They are either big tables for about a few months or the months are separately uploaded so somewhat tedious to work with.