Analyzing Baseball Data with R

11Learning About Park Effects by Database Management Tools

Contents

1. 11.1 Introduction
2. 11.2 Installing MySQL and Creating a Database
3. 11.3 Connecting R to MySQL
   1. 11.3.1 Connecting using package RMySQL
   2. 11.3.2 Connecting using Package RODBC
4. 11.4 Filling a MySQL Game Log Database from R
   1. 11.4.1 From Retrosheet to R
   2. 11.4.2 From R to MySQL
5. 11.5 Querying Data from R
   1. 11.5.1 Introduction
   2. 11.5.2 Coors Field and run scoring
6. 11.6 Baseball Data as MySQL Dumps
   1. 11.6.1 Lahman's database
   2. 11.6.2 Retrosheet database
   3. 11.6.3 PITCHf/x database
7. 11.7 Calculating Basic Park Factors
   1. 11.7.1 Loading the data in R
   2. 11.7.2 Home run park factor
   3. 11.7.3 Assumptions of the proposed approach
   4. 11.7.4 Applying park factors
8. 11.8 Further Reading
9. 11.9 Exercises

11.1 Introduction

In this book, analyses were ...