Things have been a little quiet, post wise here, of late, in part because of the holiday season… but I have been posting notes on a couple of charts in progress over on the F1DataJunkie blog. Here are links to the posts in chronological order – they capture the evolution of the chart design(s) to date:
- F1 2011 Progress Throughout the Year
- F1 2011 Review – Another Look at Fastest Laptime Evolution
- F1 2011 Review – Qualifying Progress
- F1 2011 Review – Grid/Final Classification Deltas
- F1 2011 Review – Grid vs FInal Classification, Redux
- F1 2011 Review – Driver and Race Position Charts
You can find a copy of the data I used to create the charts here: F1 2011 Year in Review spreadsheet.
I used R to generate the charts (scripts are provided and/or linked to from the posts, or included in the comments – I’ll tidy them and pop them into a proper Github repository if/when I get a chance), loading the data in to RStudio using this sort of call:
require(RCurl)
gsqAPI = function(key,query,gid=0){ return( read.csv( paste( sep="",'http://spreadsheets.google.com/tq?', 'tqx=out:csv','&tq=', curlEscape(query), '&key=', key, '&gid=', curlEscape(gid) ), na.strings = "null" ) ) }
key='0AmbQbL4Lrd61dEd0S1FqN2tDbTlnX0o4STFkNkc0NGc'
sheet=4
qualiResults2011=gsqAPI(key,'select *',sheet)
If any other folk out there are interested in using R to wrangle with F1 data, either from 2011 or looking forward to 2012, let me know and maybe we could get a script collection going on Github:-)
OUseful.Info, the blog... 