Looking at this data, the first thing I thought was untidy. There has to be a better way. When I think of tidy data, I think of the tidyr package, which is used to help make data tidy, easier to work with. Specifically, I thought of the
spread()function, where I could break things up. Once data was spread into appropriate columns, I figure I can operate on the data a bit better.
Sarah has also made the data set available in case you’re interested in following along.