9.1. Predicting Bike Rentals

The data we will use in this chapter is used with the permission of Capital Bikeshare. You can download the data from their website We are using a prepared version of this data that has already been augmented with additional weather data which you can download from the UCI Machine Learning Repository

Predicting bike rental trends is very important from both an operational and planning perspective. Bike share companies need to stay up to date on rental trends to know where they should add new facilities, and they need to reposition bikes every day to get them to the locations with the highest demand. They do not want to wait until all of the bikes are rented at a particular location before moving additional bikes into position as that is lost revenue for them.

Both hour.csv and day.csv have the following fields, except hr which is not available in day.csv

You can read about UCI’s work with this data set here: Fanaee-T, Hadi, and Gama, Joao, “Event labeling combining ensemble detectors and background knowledge”, Progress in Artificial Intelligence (2013): pp. 1-15, Springer Berlin Heidelberg, doi:10.1007/s13748-013-0040-3.

Next Section - 9.2. Exploring Bike Rental Data with SQL