Baseball Data Wrangling with Vagrant, R, and Retrosheet

Analytics with the Chadwick tools, dplyr, and ggplot.
Rating: 4.4 out of 5 (140 ratings)
10,297 students
Baseball Data Wrangling with Vagrant, R, and Retrosheet
Rating: 4.4 out of 5 (140 ratings)
10,297 students
install VirtualBox and Vagrant
run a virtual Linux machine
install the Chadwick software tools
extract game and play-by-play baseball data from Retrosheet files
produce graphs with ggplot

Requirements

  • Students will need to have R and RStudio installed on their own computers.
Description

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.

Who this course is for:
  • 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.
Curriculum
4 sections • 28 lectures • 2h 9m total length
  • Introduction
  • Installing VirtualBox
  • Installing Vagrant
  • Creating a Project Folder
  • Vagrant Up
  • Directory Structure
  • Downloading the Chadwick Software
  • Installing the Chadwick Software
  • The Retrosheet Files
  • cwevent and cwgame
  • Data Extraction
  • Reading our data into R
  • The Result Column
  • The Date Column
  • The Date Column Part II
  • The Player Data Frames
  • ggplot Crash Course
  • Cumulative Home Run Plots
  • Colors and Legend
  • Project Description
  • Data Extraction
  • Reading the data into R
  • The Date Column
  • The Result and AB Columns
  • The Player Data Frames
  • The Plots
  • The Four-Hundred Line
  • The Marchi/Albert Book and Course Wrap-Up

Instructor
Professor at Mercyhurst University
Charles Redmond
  • 4.5 Instructor Rating
  • 5,522 Reviews
  • 66,861 Students
  • 7 Courses

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.