York Ebor Sectionals Day 2

The following is an analysis of all sectional times from the second day of the 2014 York Ebor festival. Times provided by Turftrax. The DBS Premier Yearling Stakes A Class 2 race for 2 year-old horses over 6 furlongs. (Right click, View Image for a larger version) Horse FinPercent FinRank…

York Ebor Sectionals Day 1

The first day of York's 2014 Ebor Festival and five races are available for sectional analysis. Despite TurfTrax's previous assurances that all races would be covered and uploaded, Race 5 has not appeared on their website at the time of writing. (Edit: Race 5 now available from Turftrax and added…

Faster CSV Import with R

This article is inspired by a Twitter conversation with Jason Hathorn (@JJHeathview) and Tom (@UTVIlla), responding to an earlier post, Create an SQLite database with R. One of the key advantages in converting large CSV files to an SQLite database is the speed in which subsequent data queries can be…

Create an SQLite Database with R

Building an SQLite database using an R script is a reasonably straightforward process. However, depending on the dataset being used, it can be tedious and time consuming to perform correctly. Why build an SQL database? When dealing with large amounts of data it is often quicker to perform an SQL…

Goodwood Sectionals Aug 2nd

After enjoying an evening's rest, subsequent to a reasonably successful Glorious Goodwood, sectionals for the final day will be reviewed. TurfTrax have provided just three races to work with from Saturday, although they did belatedly publish a fourth race from Friday's action. Jaguar Stakes (Class 2) A 12 furlong handicap…

Goodwood Sectionals Aug 1st

TurfTrax have been good enough to upload just three sets of sectional data from today's meeting at Goodwood. The following analysis will use the recently developed Energy Distribution figure, in conjunction with line plots of sectional times and a calculation of Final Percentages. The Coutts Glorious Stakes (Group 3) A…