Baseball Data Wrangling with Vagrant, R, and Retrosheet
- Students will need to have R and RStudio installed on their own computers.
This course is for those interested in doing baseball analytics with the Retrosheet game-by-game and play-by-play data. The main tools for working with such data are in the Chadwick software. We install a virtual Linux machine, on which we will install the Chadwick software. We will then learn how to extract baseball data with the Chadwick software, how to further filter the data with dplyr in R, and how to plot our results with ggplot.
For the first part of the course, in which we install the virtual Linux machine and learn how to work with the Chadwick software, there are no prerequisites. To follow the second part of the course, knowledge of dplyr is necessary. This can be obtained through my course "Baseball Database Queries with SQL and dplyr".
At a relaxed pace, the course should take two to three weeks to complete.
- This course is for those interested in doing baseball analytics with Retrosheet files.
- No background is needed for the first part of the course. A background in the R package dplyr is necessary to follow the second part of the course.
- Installing VirtualBox00:57
- Installing Vagrant00:38
- Creating a Project Folder03:17
- Vagrant Up03:11
- Directory Structure04:34
- Downloading the Chadwick Software06:50
- Installing the Chadwick Software08:46
- The Retrosheet Files03:55
- cwevent and cwgame06:06
- Data Extraction11:08
- Reading our data into R06:23
- The Result Column05:07
- The Date Column03:39
- The Date Column Part II04:29
- The Player Data Frames06:46
- ggplot Crash Course08:22
- Cumulative Home Run Plots02:25
- Colors and Legend05:25
- Project Description03:20
- Data Extraction03:02
- Reading the data into R03:41
- The Date Column03:18
- The Result and AB Columns03:15
- The Player Data Frames09:41
- The Plots03:54
- The Four-Hundred Line04:31
- The Marchi/Albert Book and Course Wrap-Up01:30
Dr. Charles Redmond is a professor in the Tom Ridge School of Intelligence Studies and Information Science at Mercyhurst University. He has been a member of the Department of Mathematics and Computer Systems at Mercyhurst for 21 years and has recently completed a term as chair of the department. Dr. Redmond received his PhD in mathematics from Lehigh University in 1993 and has published in the Annals of Applied Probability, the Journal of Stochastic Processes and Their Applications, Mathematics Magazine, the College Mathematics Journal, and Mathematics Teacher. In his spare time he enjoys making music and computer generated art, reading, and owning a Clumber Spaniel.