PullData.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting pybaseball\n",
      "  Obtaining dependency information for pybaseball from https://files.pythonhosted.org/packages/bb/66/5ef47f5830570a30afbdfbd741cdf3e5a1a31c4c588514ab69bc074e8704/pybaseball-2.2.7-py3-none-any.whl.metadata\n",
      "  Downloading pybaseball-2.2.7-py3-none-any.whl.metadata (11 kB)\n",
      "Requirement already satisfied: numpy>=1.13.0 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pybaseball) (1.24.3)\n",
      "Requirement already satisfied: pandas>=1.0.3 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pybaseball) (1.5.3)\n",
      "Requirement already satisfied: beautifulsoup4>=4.4.0 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pybaseball) (4.12.2)\n",
      "Requirement already satisfied: requests>=2.18.1 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pybaseball) (2.31.0)\n",
      "Requirement already satisfied: lxml>=4.2.1 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pybaseball) (4.9.2)\n",
      "Requirement already satisfied: pyarrow>=1.0.1 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pybaseball) (11.0.0)\n",
      "Collecting pygithub>=1.51 (from pybaseball)\n",
      "  Obtaining dependency information for pygithub>=1.51 from https://files.pythonhosted.org/packages/84/2a/f7f72a06881493eeb763c207bea69f9ee4477c78200937b22b8b79f3acf9/PyGithub-2.3.0-py3-none-any.whl.metadata\n",
      "  Downloading PyGithub-2.3.0-py3-none-any.whl.metadata (3.8 kB)\n",
      "Requirement already satisfied: scipy>=1.4.0 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pybaseball) (1.10.1)\n",
      "Requirement already satisfied: matplotlib>=2.0.0 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pybaseball) (3.7.1)\n",
      "Requirement already satisfied: tqdm>=4.50.0 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pybaseball) (4.65.0)\n",
      "Requirement already satisfied: attrs>=20.3.0 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pybaseball) (22.1.0)\n",
      "Requirement already satisfied: soupsieve>1.2 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from beautifulsoup4>=4.4.0->pybaseball) (2.4)\n",
      "Requirement already satisfied: contourpy>=1.0.1 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from matplotlib>=2.0.0->pybaseball) (1.0.5)\n",
      "Requirement already satisfied: cycler>=0.10 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from matplotlib>=2.0.0->pybaseball) (0.11.0)\n",
      "Requirement already satisfied: fonttools>=4.22.0 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from matplotlib>=2.0.0->pybaseball) (4.25.0)\n",
      "Requirement already satisfied: kiwisolver>=1.0.1 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from matplotlib>=2.0.0->pybaseball) (1.4.4)\n",
      "Requirement already satisfied: packaging>=20.0 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from matplotlib>=2.0.0->pybaseball) (23.0)\n",
      "Requirement already satisfied: pillow>=6.2.0 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from matplotlib>=2.0.0->pybaseball) (9.4.0)\n",
      "Requirement already satisfied: pyparsing>=2.3.1 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from matplotlib>=2.0.0->pybaseball) (3.0.9)\n",
      "Requirement already satisfied: python-dateutil>=2.7 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from matplotlib>=2.0.0->pybaseball) (2.8.2)\n",
      "Requirement already satisfied: pytz>=2020.1 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pandas>=1.0.3->pybaseball) (2022.7)\n",
      "Collecting pynacl>=1.4.0 (from pygithub>=1.51->pybaseball)\n",
      "  Obtaining dependency information for pynacl>=1.4.0 from https://files.pythonhosted.org/packages/ce/75/0b8ede18506041c0bf23ac4d8e2971b4161cd6ce630b177d0a08eb0d8857/PyNaCl-1.5.0-cp36-abi3-macosx_10_10_universal2.whl.metadata\n",
      "  Downloading PyNaCl-1.5.0-cp36-abi3-macosx_10_10_universal2.whl.metadata (8.7 kB)\n",
      "Requirement already satisfied: pyjwt[crypto]>=2.4.0 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pygithub>=1.51->pybaseball) (2.4.0)\n",
      "Requirement already satisfied: typing-extensions>=4.0.0 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pygithub>=1.51->pybaseball) (4.7.1)\n",
      "Requirement already satisfied: urllib3>=1.26.0 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pygithub>=1.51->pybaseball) (1.26.16)\n",
      "Collecting Deprecated (from pygithub>=1.51->pybaseball)\n",
      "  Obtaining dependency information for Deprecated from https://files.pythonhosted.org/packages/20/8d/778b7d51b981a96554f29136cd59ca7880bf58094338085bcf2a979a0e6a/Deprecated-1.2.14-py2.py3-none-any.whl.metadata\n",
      "  Downloading Deprecated-1.2.14-py2.py3-none-any.whl.metadata (5.4 kB)\n",
      "Requirement already satisfied: charset-normalizer<4,>=2 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from requests>=2.18.1->pybaseball) (2.0.4)\n",
      "Requirement already satisfied: idna<4,>=2.5 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from requests>=2.18.1->pybaseball) (3.4)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from requests>=2.18.1->pybaseball) (2023.7.22)\n",
      "Requirement already satisfied: cryptography>=3.3.1 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pyjwt[crypto]>=2.4.0->pygithub>=1.51->pybaseball) (41.0.2)\n",
      "Requirement already satisfied: cffi>=1.4.1 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from pynacl>=1.4.0->pygithub>=1.51->pybaseball) (1.15.1)\n",
      "Requirement already satisfied: six>=1.5 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from python-dateutil>=2.7->matplotlib>=2.0.0->pybaseball) (1.16.0)\n",
      "Requirement already satisfied: wrapt<2,>=1.10 in /Users/nweil/anaconda3/lib/python3.11/site-packages (from Deprecated->pygithub>=1.51->pybaseball) (1.14.1)\n",
      "Requirement already satisfied: pycparser in /Users/nweil/anaconda3/lib/python3.11/site-packages (from cffi>=1.4.1->pynacl>=1.4.0->pygithub>=1.51->pybaseball) (2.21)\n",
      "Downloading pybaseball-2.2.7-py3-none-any.whl (426 kB)\n",
      "\u001b[2K   \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m426.1/426.1 kB\u001b[0m \u001b[31m4.2 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0ma \u001b[36m0:00:01\u001b[0m\n",
      "\u001b[?25hDownloading PyGithub-2.3.0-py3-none-any.whl (354 kB)\n",
      "\u001b[2K   \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m354.4/354.4 kB\u001b[0m \u001b[31m12.5 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
      "\u001b[?25hDownloading PyNaCl-1.5.0-cp36-abi3-macosx_10_10_universal2.whl (349 kB)\n",
      "\u001b[2K   \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m349.9/349.9 kB\u001b[0m \u001b[31m11.2 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
      "\u001b[?25hDownloading Deprecated-1.2.14-py2.py3-none-any.whl (9.6 kB)\n",
      "Installing collected packages: Deprecated, pynacl, pygithub, pybaseball\n",
      "Successfully installed Deprecated-1.2.14 pybaseball-2.2.7 pygithub-2.3.0 pynacl-1.5.0\n"
     ]
    }
   ],
   "source": [
    "!pip install pybaseball"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "from pybaseball import statcast"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "This is a large query, it may take a moment to complete\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/nweil/anaconda3/lib/python3.11/site-packages/pybaseball/statcast.py:50: UserWarning: \n",
      "That's a nice request you got there. It'd be a shame if something were to happen to it.\n",
      "We strongly recommend that you enable caching before running this. It's as simple as `pybaseball.cache.enable()`.\n",
      "Since the Statcast requests can take a *really* long time to run, if something were to happen, like: a disconnect;\n",
      "gremlins; computer repair by associates of Rudy Giuliani; electromagnetic interference from metal trash cans; etc.;\n",
      "you could lose a lot of progress. Enabling caching will allow you to immediately recover all the successful\n",
      "subqueries if that happens.\n",
      "  warnings.warn(_OVERSIZE_WARNING)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Skipping offseason dates\n",
      "Skipping offseason dates\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████| 708/708 [08:33<00:00,  1.38it/s]\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['pitch_type', 'game_date', 'release_speed', 'release_pos_x',\n",
      "       'release_pos_z', 'player_name', 'batter', 'pitcher', 'events',\n",
      "       'description', 'spin_dir', 'spin_rate_deprecated',\n",
      "       'break_angle_deprecated', 'break_length_deprecated', 'zone', 'des',\n",
      "       'game_type', 'stand', 'p_throws', 'home_team', 'away_team', 'type',\n",
      "       'hit_location', 'bb_type', 'balls', 'strikes', 'game_year', 'pfx_x',\n",
      "       'pfx_z', 'plate_x', 'plate_z', 'on_3b', 'on_2b', 'on_1b',\n",
      "       'outs_when_up', 'inning', 'inning_topbot', 'hc_x', 'hc_y',\n",
      "       'tfs_deprecated', 'tfs_zulu_deprecated', 'fielder_2', 'umpire', 'sv_id',\n",
      "       'vx0', 'vy0', 'vz0', 'ax', 'ay', 'az', 'sz_top', 'sz_bot',\n",
      "       'hit_distance_sc', 'launch_speed', 'launch_angle', 'effective_speed',\n",
      "       'release_spin_rate', 'release_extension', 'game_pk', 'pitcher.1',\n",
      "       'fielder_2.1', 'fielder_3', 'fielder_4', 'fielder_5', 'fielder_6',\n",
      "       'fielder_7', 'fielder_8', 'fielder_9', 'release_pos_y',\n",
      "       'estimated_ba_using_speedangle', 'estimated_woba_using_speedangle',\n",
      "       'woba_value', 'woba_denom', 'babip_value', 'iso_value',\n",
      "       'launch_speed_angle', 'at_bat_number', 'pitch_number', 'pitch_name',\n",
      "       'home_score', 'away_score', 'bat_score', 'fld_score', 'post_away_score',\n",
      "       'post_home_score', 'post_bat_score', 'post_fld_score',\n",
      "       'if_fielding_alignment', 'of_fielding_alignment', 'spin_axis',\n",
      "       'delta_home_win_exp', 'delta_run_exp', 'bat_speed', 'swing_length'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "# Fetch the data\n",
    "df = statcast(start_dt=\"2021-04-01\", end_dt=\"2023-11-02\")\n",
    "\n",
    "# Display the columns\n",
    "print(df.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>pitch_type</th>\n",
       "      <th>game_date</th>\n",
       "      <th>release_speed</th>\n",
       "      <th>release_pos_x</th>\n",
       "      <th>release_pos_z</th>\n",
       "      <th>player_name</th>\n",
       "      <th>batter</th>\n",
       "      <th>pitcher</th>\n",
       "      <th>events</th>\n",
       "      <th>description</th>\n",
       "      <th>...</th>\n",
       "      <th>post_home_score</th>\n",
       "      <th>post_bat_score</th>\n",
       "      <th>post_fld_score</th>\n",
       "      <th>if_fielding_alignment</th>\n",
       "      <th>of_fielding_alignment</th>\n",
       "      <th>spin_axis</th>\n",
       "      <th>delta_home_win_exp</th>\n",
       "      <th>delta_run_exp</th>\n",
       "      <th>bat_speed</th>\n",
       "      <th>swing_length</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>CU</td>\n",
       "      <td>2023-11-01</td>\n",
       "      <td>84.9</td>\n",
       "      <td>-1.19</td>\n",
       "      <td>6.12</td>\n",
       "      <td>Sborz, Josh</td>\n",
       "      <td>606466</td>\n",
       "      <td>622250</td>\n",
       "      <td>strikeout</td>\n",
       "      <td>called_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>Infield shade</td>\n",
       "      <td>Standard</td>\n",
       "      <td>26</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.09</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>FF</td>\n",
       "      <td>2023-11-01</td>\n",
       "      <td>96.6</td>\n",
       "      <td>-0.69</td>\n",
       "      <td>6.24</td>\n",
       "      <td>Sborz, Josh</td>\n",
       "      <td>606466</td>\n",
       "      <td>622250</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>Strategic</td>\n",
       "      <td>Standard</td>\n",
       "      <td>206</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.016</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>CU</td>\n",
       "      <td>2023-11-01</td>\n",
       "      <td>84.5</td>\n",
       "      <td>-1.27</td>\n",
       "      <td>6.11</td>\n",
       "      <td>Sborz, Josh</td>\n",
       "      <td>606466</td>\n",
       "      <td>622250</td>\n",
       "      <td>NaN</td>\n",
       "      <td>called_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>24</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.027</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>FF</td>\n",
       "      <td>2023-11-01</td>\n",
       "      <td>95.4</td>\n",
       "      <td>-0.8</td>\n",
       "      <td>6.23</td>\n",
       "      <td>Sborz, Josh</td>\n",
       "      <td>606466</td>\n",
       "      <td>622250</td>\n",
       "      <td>NaN</td>\n",
       "      <td>foul</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>204</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.022</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>FF</td>\n",
       "      <td>2023-11-01</td>\n",
       "      <td>95.6</td>\n",
       "      <td>-0.83</td>\n",
       "      <td>6.19</td>\n",
       "      <td>Sborz, Josh</td>\n",
       "      <td>606466</td>\n",
       "      <td>622250</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>207</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.016</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3510</th>\n",
       "      <td>FF</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>95.9</td>\n",
       "      <td>-1.92</td>\n",
       "      <td>6.15</td>\n",
       "      <td>Márquez, Germán</td>\n",
       "      <td>605141</td>\n",
       "      <td>608566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>called_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>212</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.077</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3613</th>\n",
       "      <td>FF</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>95.4</td>\n",
       "      <td>-1.69</td>\n",
       "      <td>6.17</td>\n",
       "      <td>Márquez, Germán</td>\n",
       "      <td>605141</td>\n",
       "      <td>608566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Strategic</td>\n",
       "      <td>Standard</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.113</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3791</th>\n",
       "      <td>FF</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>96.1</td>\n",
       "      <td>-1.76</td>\n",
       "      <td>6.27</td>\n",
       "      <td>Márquez, Germán</td>\n",
       "      <td>605141</td>\n",
       "      <td>608566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Strategic</td>\n",
       "      <td>Standard</td>\n",
       "      <td>208</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.052</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3883</th>\n",
       "      <td>FF</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>95.6</td>\n",
       "      <td>-2.04</td>\n",
       "      <td>6.03</td>\n",
       "      <td>Márquez, Germán</td>\n",
       "      <td>605141</td>\n",
       "      <td>608566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>foul</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>195</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.049</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4077</th>\n",
       "      <td>FF</td>\n",
       "      <td>2021-04-01</td>\n",
       "      <td>95.1</td>\n",
       "      <td>-1.95</td>\n",
       "      <td>6.11</td>\n",
       "      <td>Márquez, Germán</td>\n",
       "      <td>605141</td>\n",
       "      <td>608566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.038</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2265313 rows × 94 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     pitch_type  game_date  release_speed  release_pos_x  release_pos_z  \\\n",
       "119          CU 2023-11-01           84.9          -1.19           6.12   \n",
       "123          FF 2023-11-01           96.6          -0.69           6.24   \n",
       "129          CU 2023-11-01           84.5          -1.27           6.11   \n",
       "133          FF 2023-11-01           95.4           -0.8           6.23   \n",
       "137          FF 2023-11-01           95.6          -0.83           6.19   \n",
       "...         ...        ...            ...            ...            ...   \n",
       "3510         FF 2021-04-01           95.9          -1.92           6.15   \n",
       "3613         FF 2021-04-01           95.4          -1.69           6.17   \n",
       "3791         FF 2021-04-01           96.1          -1.76           6.27   \n",
       "3883         FF 2021-04-01           95.6          -2.04           6.03   \n",
       "4077         FF 2021-04-01           95.1          -1.95           6.11   \n",
       "\n",
       "          player_name  batter  pitcher     events    description  ...  \\\n",
       "119       Sborz, Josh  606466   622250  strikeout  called_strike  ...   \n",
       "123       Sborz, Josh  606466   622250        NaN           ball  ...   \n",
       "129       Sborz, Josh  606466   622250        NaN  called_strike  ...   \n",
       "133       Sborz, Josh  606466   622250        NaN           foul  ...   \n",
       "137       Sborz, Josh  606466   622250        NaN           ball  ...   \n",
       "...               ...     ...      ...        ...            ...  ...   \n",
       "3510  Márquez, Germán  605141   608566        NaN  called_strike  ...   \n",
       "3613  Márquez, Germán  605141   608566        NaN           ball  ...   \n",
       "3791  Márquez, Germán  605141   608566        NaN           ball  ...   \n",
       "3883  Márquez, Germán  605141   608566        NaN           foul  ...   \n",
       "4077  Márquez, Germán  605141   608566        NaN           ball  ...   \n",
       "\n",
       "      post_home_score  post_bat_score  post_fld_score  if_fielding_alignment  \\\n",
       "119                 0               0               5          Infield shade   \n",
       "123                 0               0               5              Strategic   \n",
       "129                 0               0               5               Standard   \n",
       "133                 0               0               5               Standard   \n",
       "137                 0               0               5               Standard   \n",
       "...               ...             ...             ...                    ...   \n",
       "3510                0               0               0               Standard   \n",
       "3613                0               0               0              Strategic   \n",
       "3791                0               0               0              Strategic   \n",
       "3883                0               0               0               Standard   \n",
       "4077                0               0               0               Standard   \n",
       "\n",
       "      of_fielding_alignment spin_axis delta_home_win_exp delta_run_exp  \\\n",
       "119                Standard        26                0.0         -0.09   \n",
       "123                Standard       206                0.0         0.016   \n",
       "129                Standard        24                0.0        -0.027   \n",
       "133                Standard       204                0.0        -0.022   \n",
       "137                Standard       207                0.0         0.016   \n",
       "...                     ...       ...                ...           ...   \n",
       "3510               Standard       212                0.0        -0.077   \n",
       "3613               Standard      <NA>                0.0         0.113   \n",
       "3791               Standard       208                0.0         0.052   \n",
       "3883               Standard       195                0.0        -0.049   \n",
       "4077               Standard      <NA>                0.0         0.038   \n",
       "\n",
       "     bat_speed swing_length  \n",
       "119       <NA>         <NA>  \n",
       "123       <NA>         <NA>  \n",
       "129       <NA>         <NA>  \n",
       "133       <NA>         <NA>  \n",
       "137       <NA>         <NA>  \n",
       "...        ...          ...  \n",
       "3510      <NA>         <NA>  \n",
       "3613      <NA>         <NA>  \n",
       "3791      <NA>         <NA>  \n",
       "3883      <NA>         <NA>  \n",
       "4077      <NA>         <NA>  \n",
       "\n",
       "[2265313 rows x 94 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "df.to_csv('pitch_data_21_22_23.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}