I haven’t taken a look or done much of anything with the NFL play-level data in a while. Most of what I did involved getting it into MySQL. Since then, I’ve been terribly busy with work and personal life, and so analytics have gone to the wayside. But over the past week or so, I’ve […]
Archive for the ‘databases’ Tag
Back in the analytic groove Leave a comment
More Working with MySQL Leave a comment
In my previous post, I talked about setting up the SQL database based on Dennis Erny’s NFL play-by-play dataset. I spent some time generating a script that did the appropriate ALTER TABLE statements to ensure that the character encodings and collations are utf-8, not latin1_swedish_ci as in the last post. I started doing it manually […]
A Toe Dipped into Sports Analytics 1 comment
One of the things I’m trying to do is to write about my experiences learning about sports analytics. I am learning more about it because it’s at the intersection of sports, data analysis, and statistical methods, three things I’m interested in. Recently, I read Scorecasting by Moskowitz and Wertheim, a rather interesting book about the “conventional […]