This post is a little bit of an experiment, in two areas:
 Playing with some of my own data, using a language that I'm quite familiar with (Python) and a mixture of tools which are old and new to me; and
 Publishing that investigation directly on my blog, as a static IPython Notebook export.
The data I'll be using is information about my exercise that I've been tracking over the last few years using RunKeeper. RunKeeper allows you to export and download your full exercise history, including GPX files showing where you went on each activity, and a couple of summary files in CSV format. It's this latter that I'm going to take a look at; just an initial survey to see if there's anything interesting that jumps out.
I'm not expecting any massive insights just yet, but I hope you find this a useful introduction to some very valuable data wrangling and analysis tools.
Looking at the data¶
First up, we need to do some basic setup:
%matplotlib inline
import numpy as np
import pandas as pd
from IPython.display import display
This imports some Python packages that we'll need:

matplotlib: makes pretty plots (the
%matplotlib inline
bit is some IPython Notebook magic to make plots appear inline)  numpy: allows some maths and stats functions
 pandas: loads and manipulates tabular data
Next, let's check what files we have to work with:
%ls data/*.csv
I'm interested in cardioActivities.csv
, which contains a summary of each activity in my RunKeeper history. Loading it up gives us this:
cardio = pd.read_csv('data/cardioActivities.csv',
parse_dates=[0, 4, 5],
index_col=0)
display(cardio.head())
Although my last few activities are runs, there are actually several different possible values for the "Type" column. We can take a look like this:
cardio['Type'] = cardio['Type'].astype('category')
print(cardio['Type'].cat.categories)
From this you can see there are four types: Cycling, Hiking, Running and Walking. Right now, I'm only interested in my runs, so let's select those and do an initial plot.
runs = cardio[cardio['Type'] == 'Running']
runs['Distance (mi)'].plot()
We can notice two things straight away:
 There's a gap at the start of 2014: this is probably where RunKeeper hasn't got information about the distance because my GPS watch didn't work right or something, and I don't want to include these in my analysis.
 There's a big spike from where I did the 12 Labours of Hercules ultramarathon, which isn't really an ordinary run so I don't want to include that either.
Let's do some filtering (excluding those, and some runs with "unreasonable" speeds that might be mislabelled runs or cycles) and try again.
runs = runs[(runs['Distance (mi)'] <= 15)
& runs['Average Speed (mph)'].between(3.5, 10)]
runs['Distance (mi)'].plot()
That looks much better. Now we can clearly see the break I took between late 2012 and early 2014 (problems with my iliotibial band), followed by a gradual return to training and an increase in distance leading up to my recent halfmarathon.
There are other types of plot we can look at too. How about a histogram of my run distances?
runs['Distance (mi)'].hist(bins=30)
You can clearly see here the divide between my usual weekday runs (usually around 3–5 miles) and my longer weekend runs. I've only been running >7 miles very recently, but I suspect as time goes on this graph will start to show two distinct peaks. There also seem to be peaks around whole numbers of miles: it looks like I have a tendency to finish my runs shortly after the distance readout on my watch ticks over! The smaller peak around 1 mile is where I run to the gym as a warmup before a strength workout.
How fast do I run? Let's take a look.
runs['Average Speed (mph)'].hist(bins=30)
Looks like another bimodal distribution. There's not really enough data here to be sure, but this could well be a distinction between longer, slower runs and shorter, faster ones. Let's try plotting distance against speed to get a better idea.
runs.plot(kind='scatter', x='Distance (mi)', y='Average Speed (mph)')
Hmm, no clear trend here. Maybe that's because when I first started running I was nowhere near so fit as I am now, so those early runs were both short and slow! What if we restrict it just to this year?
runs = runs.loc[runs.index > '20150101']
runs.plot(kind='scatter', x='Distance (mi)', y='Average Speed (mph)')
That's better: now it's clear to see that, in general, the further I go, the slower I run!
So, as expected, no major insights. Now that I'm over my knee injury and back to training regularly, I'm hoping that I'll be able to collect more data and learn a bit more about how I exercise and maybe even make some improvements.
How about you? What data do you have that might be worth exploring? If you haven't anything of your own, try browsing through one of these: