Bike Share in Mexico City

Playing with open data for public bike usage in Mexico City!

Check the optimized dashboard here

For this observation, I downloaded some of the open data provided by Ecobici in Mexico City. I specifically used the December 2016 results which are available as a CSV archive that contains information of 688,657 trips. Although December may be atypical because of the holidays, some interesting observations result from the exploration of the data:

• The busiest time of the week is Thursdays 8am.
• The busiest origin stations are not necessarily the same as the busiest destination stations.

Origin Trips REFORMA-HAVRE 8,319 REFORMA-RIO SENA 5,837 RIO BALSAS-RIO SENA 5,482 AV. CENTRAL-J. MENESES                  5,443 REFORMA-LIEJA 5,268

Destination Trips REFORMA-HAVRE 8,335 AV. JESÚS GARCIA-CARLOS J. MENESES 6,061 REFORMA-RIO SENA 5,882 RIO BALSAS-RIO SENA 5,605 AVENIDA MEXICO-SONORA 5,390

• It is also interesting to observe that the daily origin heatmap varies for each station:
• If the heatmap is skewed towards the morning, probably the location corresponds to a residential area where users are riding from home to work (or school, or wherever people begin their daily activities).
  For example, select station 266 AV. JESÚS GARCIA-CARLOS J. MENESES (don't forget to click the filtered station on the origin map).
• If the heatmap is more active around 18hrs, this may signify that more offices are located around the zone and are using the station to leave from work.
  For example, filter by station 27 REFORMA-HAVRE.
• The longest trip in December was of 10.36km (note that this is just a straight line approximation) and it took place from 244 EJERCITO NACIONAL-F.C. DE CUERNAVACA to 445 RIFF-AVENIDA RIO CHURUBUSCO. However, the average trip is just 1.639km and the average time of usage is 14.5mins, does this mean the average speed is only 6.78km/h?