Compare R vs Clojure CSV Import

Various reasons have lead me to the world of Clojure. Learning a new programming language is, for me, not something to be undertaken lightly. It took much research and hefty deliberation before settling on Clojure. A few key reasons include: I wanted to learn a functional language and I thought…

R Data Frames - dplyr vs sqldf

In my previous post I looked at the speed of importing data using five different methods. The fastest of these was fread from the data.table package, which outperformed base R read.csv, base R readRDS, read_csv from Hadley Wickham's readr and also importing the same data from an…

Faster Import with R Redux

Sometime ago I wrote a post comparing the speed of importing datasets based on their format. In that post I compared read.csv and fread, from the data.table package, for importing CSV files and also an R SQL query to read the same data from an SQLite database. The…

My Life with FRED

Who? FRED. The FormBet Race Database. Over the last month I've been quite busy building an online database search tool for the FormBet ratings service. While proprietor Dave McAuley wanted to focus on developing the best UK and Irish horse racing ratings service, many of his subscribers were eager for…

Tech Bits - Digital Ocean and RStudio

Originally this blog was meant to focus mostly on data analysis of horse racing. My methods for achieving this are primarily through the R statistical programming language. However, as I've spent more and more time writing code in recent weeks, I have more and more to say of a technical…

York Ebor Sectionals Day 3

The following is an analysis of all sectional times from the second day of the 2014 York Ebor festival. Times provided by Turftrax. The Sky Bet Transfer Fund Stakes A Class 2 handicap over 12 furlongs, for horses 3 years old and older, with an official handicap mark between 0…