Back to Parent

Outcome


Dataset

I used datasets made available by the Western Pennsylvania Regional Data Center (WPRDC) for the Healthy Ride Trip Data. Available at https://data.wprdc.org/dataset/healthyride-trip-data. My dataset ranges from 07/01/2015 to 09/30/2015 and includes 38,109 trips taken from 492 bikes from 51 stations in the Pittsburgh region. On average a trip lasted 59 minutes with a maximum length of 1.99 days and the shortest ride lasting just 50 seconds. 


Initial Analysis

There are 50 bike stations in Pittsburgh with an average of 18.12 racks (min = 12, max = 35). The S Euclid Ave & Centre Ave, Centre Ave & Kirkpatrick St and Federal St & E North Ave are the least resourced stations and with 2 stations having the most racks (Centre Ave and Consol, North Shore Trail & Ft Duquesne Bridge). The next large resourced racks (with 21 racks) are Liberty Ave & Baum Blvd, 37th St & Butler St, Bigelow Blvd & Fifth Ave, and Ross St & Sixth Ave.

Exploration

The most popular station which the most trips are from are Healthy Ride Club and it is also the most popular station which the most trips are to. And the popularity does not correspond to the resources of the racks.

Show Advanced Options
222.png.thumb
Show Advanced Options
333.png.thumb
Show Advanced Options

There is a rhythm of the total count of trips with an increase during the weekend and a decrease towards Wednesday.  And overall the number of trips are decreasing with time with a sharp drop after 09/21/2015.

Week.png.thumb
Show Advanced Options
Days.png.thumb
Show Advanced Options
Day of week.png.thumb
Show Advanced Options

Future Work

I further investigated the trip duration in terms of days, weeks, and days of the week. I would integrate the weather data and events calendar. I think it will be interesting to see the relationship between the number of trips and events. Also, there might be a correlation between the weather and the duration of trips. 

Trip duration day of the week.png.thumb
Show Advanced Options
Trip duration daymin.png.thumb
Show Advanced Options
Trip duration daymax.png.thumb
Show Advanced Options
Trip duration dayavg.png.thumb
Show Advanced Options
Drop files here or click to select

You can upload files of up to 20MB using this form.