One of the, err, side projects I’ve been looking at with a couple of people from the OBU has been bouncing around a few ideas about how we might “wrap” coverage of Formula One races with some open educational resources.
So with the first race of the new season over, I thought I’d have a quick play with some of the results data…
First off, where to get the results info? An API source doesn’t seem to be available anywhere that I’ve found as a free service, but the FIA media centre do publish a lot of the data (albeit in a PDF format): F1 Media Centre – Melbourne Grand Prix, 2009.
To get the data into an appropriate form required a little bit of processing (for example, recasting the race lap chart to provide the ranking per lap ordered by driver) but as ever, most of the charts fell out easily enough (although a couple more issues were raised – like being able to specify the minimum y-axis range value on a bar chart, for example).
Anyway, you can find the charts linked to from here: Australia Lap Times visualisation.
In the meantime, here are some examples (click through to reach the interactive original).
First up, a scatter plot to compare lap times for each driver across the race:
Secondly, a line chart to compare time series lap times across different drivers:
This bar chart views lets you compare the lap times for each driver over a subset of laps:
A “traditional” drivers standings chart for each lap:
Finally, this bar chart can be run as an animation (sort of) to show the rank of each driver for each lap during the race:
There are a few more data sets (e.g. pitting behaviour) that I haven’t had a look at yet, but if and when I do, I will link to them from the Australia Lap Times visualisation page on Many Eyes Wikified.
PS If you’re really into thinking about the data, maybe you’d like to help me think around how to improve the “Pit stop strategist” spreadsheet I started messing around with too?! ;-)
PPS It’s now time for the 2010 season, and this year, there’s some Mclaren car telemetry data to play with. For example, here’s a video preview of my interactive Mclaren data explorer.