Data Study of Velocity of Citi Bikes

Posted on May 2, 2016
The skills the author demoed here can be learned through taking Data Science with Machine Learning bootcamp with NYC Data Science Academy.
Contributed by Taraqur Rahman. He is currently in the NYC Data Science Academy 12 week full time Data Science Bootcamp program taking place between April 11th to July 1st, 2016. This post is based on his first class project - R visualization (due on the 2nd week of the program).

Introduction

Data shows bikes have become extremely popular type of transportation. It is healthy to ride bikes, no pollution is being released into the air, and the oil prices going up is not a concern. Citi Group saw the opportunity in this and teamed up with Motivate, a global bike sharing company, and launched the Citi Bike program in May 2013. I thought it would be interesting to find out what can be learned from this Citi Bike program.

The dataset that I worked on was the winter months of December 2015, January 2016, February 2016. After looking at the data set, I noticed that there were coordinates, and duration. Right away I was curious to see what the velocity of the Citi Bikes can tell us.

Engineering the velocity feature was simple using the coordinates and the trip duration. A histogram was generated to visually see  the frequency of the velocities. This represents the data of tripdurations equal to or under 45 minutes. The annual subscription had an unlimited rides for a time length of 45 minutes. Therefore the focus was within that time limit.

Data

Data Study of Velocity of Citi Bikes

Frequency of velocities <= 45 minutes. The average velocity is 5.76 mph.

Observations

The graph above shows two interesting points. The first point is that there are a few outliers to the right of the graph (barely visible). The max velocity was about 36.9 mph. The average velocity was about 5.752 mph. The next interesting point is the spike at zero. This was expected. If the velocity was zero, it does not mean that people did not ride it; it means that the bike ended up where it started. Once again, the velocity measures the ratio of displacement and time. This is a crucial concept to understand so I would like to take a little time to explain it.3

Screen Shot 2016-05-01 at 2.36.17 PM

The black line represents distance. The red represents displacement. Velocity is concerned with the displacement only.

Displacement

The displacement is the shortest distance from the starting doc station to the ending doc station. For instance in the map above, if a person picked up a bike at the south Williamsburg doc station, traveled over the Williamsburg Bridge, up a few Manhattan blocks, through the Midtown Tunnel and dropped it off North Williamsburg, then their distance would be the black line. However the velocity is concerned with the displacement, which is the shortest path from South to North Williamsburg, which would be the red line.

Duration

Now if the same person decided to doc his/her bike in South Williamsburg (the same station he/she started with), what would the displacement be? The displacement would be zero. Therefore (going back to Velocity histogram), that spike at zero is due to the people who made round trips with the bikes. To confirm this, I made a graph showing the trip duration throughout the day for the bikes with zero velocity.

zero_velocity

Looking at the duration, the bike is still being used even though the velocity is zero.

Even though they have zero velocity, they still travelled for a certain time throughout the day. People make more than twenty-five minute round trips during the times of 10:00 – 16:00. Unfortunately figuring out the velocity for this subset is impossible. But we can imply that these people might use the bikes for a quick workout, run errands, or just take a break and enjoy a bike ride.

Velocity by Time of Day

Speaking of times throughout the day, the box plot below displays the velocity throughout the day. Morning is the time from 4 am to 12 pm. Afternoon is from 12 pm to 8 pm. Night is from 8 pm to 4 am.

boxplot-time-of-day

Velocity throughout the day. Morning is 4 am -12pm, Afternoon is 12 pm - 8pm, Night is 8 pm - 4 am.

The velocity is almost constant throughout the day. Morning has the highest average velocity, which might make sense since people are rushing to go to work. Night has the next highest velocity. I would assume that during the night there is nobody around or no traffic so people tend to go faster.

Velocity by Age

Next is analyzing the age. Looking at the ages, I noticed that there were people who were 105, 115, 125 years old that rented bikes and there were many missing ages. I doubt that the ages were correct. It seems like people just inputed random birth year in the dropdown list when signing up. These age imposters did still ride the bikes so their data can be relevant.

velocity-by-age

According to the data, there are people who are 100+ that rides faster than anybody else, which is highly unlikely.

To fix this issue, I set 80 as the cut-off age. Ages greater than 80, I for the rest I entered the mean age (excluding the 81+ year olds) which is 38.6. Mean imputation was used because the mean velocity of the total population is similar to the mean velocity of those who are 80 and under. For the missing ages, random imputation was used. The mean velocity for missing age was 3.96 which is significantly lower than the mean velocity of the whole population. The graph below shows the Velocity by Age after the imputation.

vase2

The curve is basically the same as the curve in the graph before imputation if you look at ages less than 80.

Conclusion

One application I can think of with the velocity feature of the Citi Bikes is to see where are the ‘hotspots’ for the bikers.

If we use the average velocity as the standard velocity and see where in the route’s people’s velocity is below the average, then that means that people are taking their time, cruising through that area. This can have a marketing application. Areas where the velocity is small (people are most likely going for a casual ride), the advertisement can be more focused on laid-back advertisements such as drinking Corona at a beach. On the other hand, when the velocity is big (people are riding fast to their destination), there can be face-paced advertisement such as Usain Bolt running with Pumas.

For further analysis, I would like to consider a whole year worth of data. This way we can see trends throughout seasons. I would assume velocity would decrease during the summer time because more people would like to ride casually to enjoy the weather. Also more people would ride the bikes during the summer. During the winter, people will try to get their destination as soon as possible to avoid the cold weather so the velocity would be higher.

About Author

Taraqur Rahman

During his career as a Sales Associate, Taraqur analyzed data to help support both the sales and marketing teams. Seeing through his own eyes how much data can influence decisions, Taraqur joined NYCDSA as a data scientist in...
View all posts by Taraqur Rahman >

Related Articles

Leave a Comment

Google July 18, 2021
Google Here are a number of the sites we recommend for our visitors.
Google June 27, 2021
Google One of our visitors a short while ago suggested the following website.
Google May 16, 2020
Google We came across a cool site that you simply may delight in. Take a search should you want.
Google December 31, 2019
Google Please visit the sites we adhere to, including this 1, as it represents our picks through the web.
Wendi August 21, 2017
Great line up. We'll be linking to this great post on our website. Keep up the good writing.
Madge August 20, 2017
This really answered my issue, thank you!
Charline August 19, 2017
Greetings! Really helpful advice on this article! It truly is the small changes that make the largest changes. Thanks a lot for sharing!
Eartha July 25, 2017
Thank you for the effort, keep up the great work Great work.
Antje July 24, 2017
Hello , I do believe this is a great blog. I stumbled upon it on Yahoo , I'll return once again.
Collin July 24, 2017
The article has really peaks my interest. Iwill bookmark your site and keep checking for new information.
Freeman July 24, 2017
Thanks for the excellent advice, it really is useful.
Barrett July 23, 2017
Great info. Lucky me I reach on your site by accident, I bookmarked it.
Dorie July 18, 2017
Great post. I 'm facing a couple of these difficulties.
Austin July 16, 2017
You should participate in a contest for one of the finest websites on the internet. I am going to recommend this website!
Lizette July 16, 2017
Greetings! Really helpful advice on this post! It truly is the small changes that make the biggest changes. Thanks a lot for sharing!
Alyssa July 15, 2017
Thanks for the outstanding advice, it really is useful.
Sam July 15, 2017
Thanks for the excellent information, it actually is useful.
June July 13, 2017
This is a topic close to my heart cheers. Thanks
Virginia June 20, 2017
Greetings! Really helpful advice on this post! It is the little changes that make the biggest changes. Thanks a lot for sharing!
Joan June 19, 2017
Really excellent post, I definitely adore this website, keep on it.
Ralf June 4, 2017
You should participate in a contest for one of the finest sites on the internet. I am going to recommend this website!
Trina June 4, 2017
Fairly! This was a really amazing post. Thank you for your provided information
Emil June 4, 2017
Great line up. We will be linking to this amazing post on our website. Keep up the great writing.
Vicki June 4, 2017
Really excellent post, I certainly adore this site, keep on it.
Julissa June 4, 2017
It’s difficult to locate well informed people on this subject, but you sound like you comprehend what you’re talking about! Thanks
Clinton June 4, 2017
The post has really peaks my interest. I'm going to bookmark your website and keep checking for new information.
Yukiko June 3, 2017
Hi , I do consider this is a superior website. I stumbled upon it on Yahoo , I shall return once again.
Ima May 19, 2017
This is an extremely great tips especially to those new to blogosphere, short and precise info... Thanks for sharing this one. A must read post.
Ethel May 17, 2017
This is a matter close to my heart cheers. Thanks
Marcy May 11, 2017
The article has actually peaks my interest. Iwill bookmark your website and keep checking for new info.
Eli May 11, 2017
Thanks for the outstanding information, it actually is useful.
Catalina May 11, 2017
It’s difficult to find well informed folks on this issue, but you sound like you comprehend what you’re talking about! Thanks
Carin May 10, 2017
This is a very good hints particularly to those new to blogosphere, brief and accurate information... Thanks for sharing this one. A must read post.
gameroids.com May 10, 2017
This is a very great hints particularly to those new to blogosphere, short and exact info... Thanks for sharing this one. A must read article.
Augustina May 9, 2017
Quite! This was a really wonderful post. Thank you for your provided information
Rosella May 8, 2017
Really fine post, I definitely adore this site, keep on it.
Veta May 6, 2017
Rather! This was a really excellent post. Thank you for your provided information
http://www.gameroids.com/ May 6, 2017
Thanks for the excellent information, it really is useful.
Trista April 29, 2017
The post has really peaks my interest. I'm going to bookmark your website and keep checking for new info.
Wade April 28, 2017
Saved as a favorite, I actually like your site!
lords mobile hack April 23, 2017
I was waiting for this type of issue. Thank you very much for the location.
darkhacks24.com April 23, 2017
Greetings! Quite helpful advice on this post! It truly is the small changes that make the biggest changes. Thanks a lot for sharing!
Desmond April 23, 2017
It’s challenging to find well informed folks on this subject, but you seem like you comprehend what you’re talking about! Thanks
Ralf April 21, 2017
Rather! This was a really amazing post. Thank you for your provided information
Colette April 20, 2017
Pretty! This was a truly excellent post. Thank you for your supplied advice
dream league soccer hack April 20, 2017
It’s difficult to locate well-informed folks on this issue, but you seem like you realize what you’re talking about! Thanks
Traci April 20, 2017
You should participate in a competition for one of the finest websites on the internet. I 'm going to recommend this website!
Nicholas April 19, 2017
Thank you for the attempt, keep up the great work Great work.
Felipa April 19, 2017
Really excellent post, I certainly adore this website, keep on it.
www.darkhacks24.com April 15, 2017
Really great post, I definitely adore this site, keep on it.
http://www.realhacks24.com/magic-rush-heroes-hack September 24, 2016
Greetings! Quite helpful guidance on this article! It's the small changes that make the largest changes. Thanks a lot for sharing!
gods of rome hack September 18, 2016
You should participate in a competition for one of the finest sites online. I am going to recommend this website!
Emory September 17, 2016
You should participate in a competition for one of the finest sites on the web. I am going to recommend this website!
Elaine September 15, 2016
This really answered my dilemma, thank you!
Cole September 15, 2016
Hello , I do consider this is an excellent site. I stumbled upon it on Yahoo , I'll come back once again.
Ulrich September 9, 2016
This is the correct website for anyone who needs to find out about this issue. You recognize so much its almost hard to argue with you (not that I really would desire… HaHa). You undoubtedly set a brand new spin on a subject thats been written about for years. Amazing items, simply excellent!
Kourtney September 8, 2016
Thanks for the excellent information, it really is useful.
nfl 17 coins August 20, 2016
Thanks with regard to supplying such awesome post nfl 17 coins http://ashbur827.kikooboo.com/fr/page/cheap-nhl-17-coins-enjoy-watching
nba 2k17 August 19, 2016
Wow, attractive website. Thnx .. nba 2k17 http://zrupy.com/index.php?dll=profile&sub=blogview&item_id=230006&item2_id=2116
Www.Hacksgen.Org May 26, 2016
This is the correct site for anyone who desires to learn about this topic. You recognize so much its almost difficult to argue with you (not that I actually would want… HaHa). You definitely set a new spin on a subject thats been written about for years. Excellent items, simply excellent!
marvel contest of champions hack May 24, 2016
I was waiting for this kind of subject. Thank you very much for the place.
Www.Porthacks.Com May 23, 2016
Really nice post, I certainly love this website, keep on it.

View Posts by Categories


Our Recent Popular Posts


View Posts by Tags

#python #trainwithnycdsa 2019 2020 Revenue 3-points agriculture air quality airbnb airline alcohol Alex Baransky algorithm alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus ames dataset ames housing dataset apartment rent API Application artist aws bank loans beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep boston safety Bundles cake recipe California Cancer Research capstone car price Career Career Day citibike classic cars classpass clustering Coding Course Demo Course Report covid 19 credit credit card crime frequency crops D3.js data data analysis Data Analyst data analytics data for tripadvisor reviews data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization database Deep Learning Demo Day Discount disney dplyr drug data e-commerce economy employee employee burnout employer networking environment feature engineering Finance Financial Data Science fitness studio Flask flight delay gbm Get Hired ggplot2 googleVis H20 Hadoop hallmark holiday movie happiness healthcare frauds higgs boson Hiring hiring partner events Hiring Partners hotels housing housing data housing predictions housing price hy-vee Income Industry Experts Injuries Instructor Blog Instructor Interview insurance italki Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter las vegas airport lasso regression Lead Data Scienctist Lead Data Scientist leaflet league linear regression Logistic Regression machine learning Maps market matplotlib Medical Research Meet the team meetup methal health miami beach movie music Napoli NBA netflix Networking neural network Neural networks New Courses NHL nlp NYC NYC Data Science nyc data science academy NYC Open Data nyc property NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time performance phoenix pollutants Portfolio Development precision measurement prediction Prework Programming public safety PwC python Python Data Analysis python machine learning python scrapy python web scraping python webscraping Python Workshop R R Data Analysis R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn seafood type Selenium sentiment analysis sentiment classification Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau teachers team team performance TensorFlow Testimonial tf-idf Top Data Science Bootcamp Top manufacturing companies Transfers tweets twitter videos visualization wallstreet wallstreetbets web scraping Weekend Course What to expect whiskey whiskeyadvocate wildfire word cloud word2vec XGBoost yelp youtube trending ZORI