September 3, 2014

Looking at Data: My Cycling Training Data


Looks like I’ve been slacking on the bike so far this week, compared to last week! This week’s data is the darker colored stuff, last week’s data is the lighter colored stuff.

I pulled the data from my Cycling Analytics account using their API. I then massaged it with a Python script I wrote to augment some of the charting I felt was missing in the Cycling Analytics dashboard (I know this stuff is available out of the box from TrainingPeaks, but 1) it was fun to program the API myself, and 2) I refuse to pay for TrainingPeaks).

August 22, 2014

Looking at Data: 2014 Tour of Utah

It’s been a while since I posted anything in my Looking at Data series, but with the 2014 edition of the Larry H. Miller Tour of Utah wrapping up last week I thought I’d take a look at the data, since I’m, you know, into cycling, and this race took place in my back yard, so to speak.

First off, where do the riders hail from?

Not too surprising for a Tier-2 race, most riders come from the host country, in this case the U.S.

Second up, the stage results:

Finally, some meat and potatoes:

It’s interesting to note that the spread in time by the end of the race (stage 7) is quite large. The rider with the cumulatively slowest time was over 1.5 hours behind the overall winner, Tom Danielson. Perhaps its due to a particularly poor showing in stages 4, 6, and 7? If you look at the box and whisker plot of time spread, you’ll notice that those stages have large spreads in times. Stage 4, from Ogden to Powder Mountain, was a pretty hilly stage, with a nasty climb to the mountain top finish. Stage 6, from Salt Lake City to Snowbird, was also a grueling stage, with over 12,000 ft of elevation gain, and Stage 7, although a little shorter, featured two really hard climbs at Wolf Creek Pass and Empire Pass. The common denominator, besides the endless vertical racked up over the course of the stages, was the high altitude. Most of the mountain finishes, and the hard climbs, took place above 8000 feet in elevation. I bet a lot of riders weren’t used to that…

All that climbing is probably also why you see attrition increasing throughout the race, especially after stages 5 and 6. There was a 7% dropoff in the number of riders starting stage 7 compared to stage 6!