DayOne.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2023-nwbc-data.csv',\n",
       " '2023-nwbc-raw-data.csv',\n",
       " '2023-nwbc-reds.csv',\n",
       " 'nw-version-reds.xlsx',\n",
       " '2023-nwbc-reds.xlsx']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "\n",
    "os.listdir('mats')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2.2.2'"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.__version__"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "x =1 \n",
    "y = 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3\n"
     ]
    }
   ],
   "source": [
    "print(x + y)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# opening the dataframe (the dataset .csv)\n",
    "df = pd.read_csv('mats/2023-nwbc-reds.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "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>pitcher_name</th>\n",
       "      <th>batter</th>\n",
       "      <th>pitcher</th>\n",
       "      <th>events</th>\n",
       "      <th>description</th>\n",
       "      <th>...</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>attack_zone</th>\n",
       "      <th>swing</th>\n",
       "      <th>batter_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.8</td>\n",
       "      <td>2.39</td>\n",
       "      <td>5.44</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>field_out</td>\n",
       "      <td>hit_into_play</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.083</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.3</td>\n",
       "      <td>2.30</td>\n",
       "      <td>5.51</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>132.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.014</td>\n",
       "      <td>shadow</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SL</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>84.3</td>\n",
       "      <td>2.45</td>\n",
       "      <td>5.21</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>216.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.011</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.8</td>\n",
       "      <td>2.32</td>\n",
       "      <td>5.48</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>called_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.023</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>94.1</td>\n",
       "      <td>2.34</td>\n",
       "      <td>5.54</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>swinging_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.017</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 95 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  pitch_type   game_date  release_speed  release_pos_x  release_pos_z  \\\n",
       "0         FF  2022-10-05           93.8           2.39           5.44   \n",
       "1         FF  2022-10-05           93.3           2.30           5.51   \n",
       "2         SL  2022-10-05           84.3           2.45           5.21   \n",
       "3         FF  2022-10-05           93.8           2.32           5.48   \n",
       "4         FF  2022-10-05           94.1           2.34           5.54   \n",
       "\n",
       "      pitcher_name  batter  pitcher     events      description  ...  \\\n",
       "0  Hughes, Brandon  605244   676714  field_out    hit_into_play  ...   \n",
       "1  Hughes, Brandon  605244   676714        NaN             ball  ...   \n",
       "2  Hughes, Brandon  605244   676714        NaN             ball  ...   \n",
       "3  Hughes, Brandon  605244   676714        NaN    called_strike  ...   \n",
       "4  Hughes, Brandon  605244   676714        NaN  swinging_strike  ...   \n",
       "\n",
       "   post_bat_score  post_fld_score  if_fielding_alignment  \\\n",
       "0               2              15               Standard   \n",
       "1               2              15               Standard   \n",
       "2               2              15               Standard   \n",
       "3               2              15               Standard   \n",
       "4               2              15               Standard   \n",
       "\n",
       "   of_fielding_alignment  spin_axis delta_home_win_exp delta_run_exp  \\\n",
       "0               Standard      133.0                0.0        -0.083   \n",
       "1               Standard      132.0                0.0         0.014   \n",
       "2               Standard      216.0                0.0         0.011   \n",
       "3               Standard      133.0                0.0        -0.023   \n",
       "4               Standard      133.0                0.0        -0.017   \n",
       "\n",
       "  attack_zone swing     batter_name  \n",
       "0       heart     0  garcia, aramis  \n",
       "1      shadow     0  garcia, aramis  \n",
       "2       waste     0  garcia, aramis  \n",
       "3       heart     0  garcia, aramis  \n",
       "4       heart     0  garcia, aramis  \n",
       "\n",
       "[5 rows x 95 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['pitch_type', 'game_date', 'release_speed', 'release_pos_x',\n",
       "       'release_pos_z', 'pitcher_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', 'attack_zone', 'swing',\n",
       "       'batter_name'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        15\n",
       "1        15\n",
       "2        15\n",
       "3        15\n",
       "4        15\n",
       "         ..\n",
       "49033     0\n",
       "49034     0\n",
       "49035     0\n",
       "49036     0\n",
       "49037     0\n",
       "Name: away_score, Length: 49038, dtype: int64"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['away_score']\n",
    "# there is a not a df.[ ]  it is just df['column name']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        17\n",
       "1        17\n",
       "2        17\n",
       "3        17\n",
       "4        17\n",
       "         ..\n",
       "49033     0\n",
       "49034     0\n",
       "49035     0\n",
       "49036     0\n",
       "49037     0\n",
       "Length: 49038, dtype: int64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['home_score'] + df['away_score']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['total_score'] = df['home_score'] + df['away_score']\n",
    "# you simply state the column name you would like to add in the predetermined list.\n",
    "# set it to equal the additoin of columns youd like to combine to make a new feature."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "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>pitcher_name</th>\n",
       "      <th>batter</th>\n",
       "      <th>pitcher</th>\n",
       "      <th>events</th>\n",
       "      <th>description</th>\n",
       "      <th>...</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>attack_zone</th>\n",
       "      <th>swing</th>\n",
       "      <th>batter_name</th>\n",
       "      <th>total_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.8</td>\n",
       "      <td>2.39</td>\n",
       "      <td>5.44</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>field_out</td>\n",
       "      <td>hit_into_play</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.083</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.3</td>\n",
       "      <td>2.30</td>\n",
       "      <td>5.51</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>132.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.014</td>\n",
       "      <td>shadow</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SL</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>84.3</td>\n",
       "      <td>2.45</td>\n",
       "      <td>5.21</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>216.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.011</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.8</td>\n",
       "      <td>2.32</td>\n",
       "      <td>5.48</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>called_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.023</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>94.1</td>\n",
       "      <td>2.34</td>\n",
       "      <td>5.54</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>swinging_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.017</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 96 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  pitch_type   game_date  release_speed  release_pos_x  release_pos_z  \\\n",
       "0         FF  2022-10-05           93.8           2.39           5.44   \n",
       "1         FF  2022-10-05           93.3           2.30           5.51   \n",
       "2         SL  2022-10-05           84.3           2.45           5.21   \n",
       "3         FF  2022-10-05           93.8           2.32           5.48   \n",
       "4         FF  2022-10-05           94.1           2.34           5.54   \n",
       "\n",
       "      pitcher_name  batter  pitcher     events      description  ...  \\\n",
       "0  Hughes, Brandon  605244   676714  field_out    hit_into_play  ...   \n",
       "1  Hughes, Brandon  605244   676714        NaN             ball  ...   \n",
       "2  Hughes, Brandon  605244   676714        NaN             ball  ...   \n",
       "3  Hughes, Brandon  605244   676714        NaN    called_strike  ...   \n",
       "4  Hughes, Brandon  605244   676714        NaN  swinging_strike  ...   \n",
       "\n",
       "   post_fld_score  if_fielding_alignment  of_fielding_alignment  spin_axis  \\\n",
       "0              15               Standard               Standard      133.0   \n",
       "1              15               Standard               Standard      132.0   \n",
       "2              15               Standard               Standard      216.0   \n",
       "3              15               Standard               Standard      133.0   \n",
       "4              15               Standard               Standard      133.0   \n",
       "\n",
       "   delta_home_win_exp delta_run_exp attack_zone swing     batter_name  \\\n",
       "0                 0.0        -0.083       heart     0  garcia, aramis   \n",
       "1                 0.0         0.014      shadow     0  garcia, aramis   \n",
       "2                 0.0         0.011       waste     0  garcia, aramis   \n",
       "3                 0.0        -0.023       heart     0  garcia, aramis   \n",
       "4                 0.0        -0.017       heart     0  garcia, aramis   \n",
       "\n",
       "  total_score  \n",
       "0          17  \n",
       "1          17  \n",
       "2          17  \n",
       "3          17  \n",
       "4          17  \n",
       "\n",
       "[5 rows x 96 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['hit_into_play', 'ball', 'called_strike', 'swinging_strike',\n",
       "       'foul', 'blocked_ball', 'swinging_strike_blocked', 'hit_by_pitch',\n",
       "       'foul_tip', 'foul_bunt', 'missed_bunt', 'bunt_foul_tip',\n",
       "       'pitchout'], dtype=object)"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['description'].unique()\n",
    "# dont for get the () at the end of the method."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "strike_events = ['called_strike', 'swinging_strike','foul', 'swinging_strike_blocked','foul_tip', 'foul_bunt', 'missed_bunt', 'bunt_foul_tip']\n",
    "# this is a list you created as strike events.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "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>pitcher_name</th>\n",
       "      <th>batter</th>\n",
       "      <th>pitcher</th>\n",
       "      <th>events</th>\n",
       "      <th>description</th>\n",
       "      <th>...</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>attack_zone</th>\n",
       "      <th>swing</th>\n",
       "      <th>batter_name</th>\n",
       "      <th>total_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.8</td>\n",
       "      <td>2.39</td>\n",
       "      <td>5.44</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>field_out</td>\n",
       "      <td>hit_into_play</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.083</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.3</td>\n",
       "      <td>2.30</td>\n",
       "      <td>5.51</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>132.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.014</td>\n",
       "      <td>shadow</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SL</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>84.3</td>\n",
       "      <td>2.45</td>\n",
       "      <td>5.21</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>216.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.011</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.8</td>\n",
       "      <td>2.32</td>\n",
       "      <td>5.48</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>called_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.023</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>94.1</td>\n",
       "      <td>2.34</td>\n",
       "      <td>5.54</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>swinging_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.017</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 96 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  pitch_type   game_date  release_speed  release_pos_x  release_pos_z  \\\n",
       "0         FF  2022-10-05           93.8           2.39           5.44   \n",
       "1         FF  2022-10-05           93.3           2.30           5.51   \n",
       "2         SL  2022-10-05           84.3           2.45           5.21   \n",
       "3         FF  2022-10-05           93.8           2.32           5.48   \n",
       "4         FF  2022-10-05           94.1           2.34           5.54   \n",
       "\n",
       "      pitcher_name  batter  pitcher     events      description  ...  \\\n",
       "0  Hughes, Brandon  605244   676714  field_out    hit_into_play  ...   \n",
       "1  Hughes, Brandon  605244   676714        NaN             ball  ...   \n",
       "2  Hughes, Brandon  605244   676714        NaN             ball  ...   \n",
       "3  Hughes, Brandon  605244   676714        NaN    called_strike  ...   \n",
       "4  Hughes, Brandon  605244   676714        NaN  swinging_strike  ...   \n",
       "\n",
       "   post_fld_score  if_fielding_alignment  of_fielding_alignment  spin_axis  \\\n",
       "0              15               Standard               Standard      133.0   \n",
       "1              15               Standard               Standard      132.0   \n",
       "2              15               Standard               Standard      216.0   \n",
       "3              15               Standard               Standard      133.0   \n",
       "4              15               Standard               Standard      133.0   \n",
       "\n",
       "   delta_home_win_exp delta_run_exp attack_zone swing     batter_name  \\\n",
       "0                 0.0        -0.083       heart     0  garcia, aramis   \n",
       "1                 0.0         0.014      shadow     0  garcia, aramis   \n",
       "2                 0.0         0.011       waste     0  garcia, aramis   \n",
       "3                 0.0        -0.023       heart     0  garcia, aramis   \n",
       "4                 0.0        -0.017       heart     0  garcia, aramis   \n",
       "\n",
       "  total_score  \n",
       "0          17  \n",
       "1          17  \n",
       "2          17  \n",
       "3          17  \n",
       "4          17  \n",
       "\n",
       "[5 rows x 96 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "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>pitcher_name</th>\n",
       "      <th>batter</th>\n",
       "      <th>pitcher</th>\n",
       "      <th>events</th>\n",
       "      <th>description</th>\n",
       "      <th>...</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>attack_zone</th>\n",
       "      <th>swing</th>\n",
       "      <th>batter_name</th>\n",
       "      <th>total_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SI</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.4</td>\n",
       "      <td>2.36</td>\n",
       "      <td>5.41</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>641584</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>foul</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>132.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.066</td>\n",
       "      <td>chase</td>\n",
       "      <td>0</td>\n",
       "      <td>fraley, jake</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>FC</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>88.1</td>\n",
       "      <td>-3.07</td>\n",
       "      <td>5.74</td>\n",
       "      <td>Strickland, Hunter</td>\n",
       "      <td>663845</td>\n",
       "      <td>519326</td>\n",
       "      <td>NaN</td>\n",
       "      <td>foul</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>Infield shift</td>\n",
       "      <td>Standard</td>\n",
       "      <td>104.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.036</td>\n",
       "      <td>shadow</td>\n",
       "      <td>0</td>\n",
       "      <td>rivas, alfonso</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>95.1</td>\n",
       "      <td>-0.71</td>\n",
       "      <td>5.91</td>\n",
       "      <td>Wick, Rowan</td>\n",
       "      <td>519222</td>\n",
       "      <td>592858</td>\n",
       "      <td>NaN</td>\n",
       "      <td>foul</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>197.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.049</td>\n",
       "      <td>chase</td>\n",
       "      <td>0</td>\n",
       "      <td>romine, austin</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>SI</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>89.8</td>\n",
       "      <td>3.32</td>\n",
       "      <td>5.04</td>\n",
       "      <td>Sanmartin, Reiver</td>\n",
       "      <td>623520</td>\n",
       "      <td>665665</td>\n",
       "      <td>NaN</td>\n",
       "      <td>foul</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>119.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.058</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>bote, david</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>96.0</td>\n",
       "      <td>-1.93</td>\n",
       "      <td>5.61</td>\n",
       "      <td>Rucker, Michael</td>\n",
       "      <td>668715</td>\n",
       "      <td>621074</td>\n",
       "      <td>NaN</td>\n",
       "      <td>foul</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Strategic</td>\n",
       "      <td>221.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.150</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>steer, spencer</td>\n",
       "      <td>15</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>48979</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Velasquez, Vince</td>\n",
       "      <td>606157</td>\n",
       "      <td>592826</td>\n",
       "      <td>NaN</td>\n",
       "      <td>foul</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>aquino, aristides</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48982</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Farmer, Buck</td>\n",
       "      <td>543281</td>\n",
       "      <td>571656</td>\n",
       "      <td>NaN</td>\n",
       "      <td>foul</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>harrison, josh</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49018</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kopech, Michael</td>\n",
       "      <td>502054</td>\n",
       "      <td>656629</td>\n",
       "      <td>NaN</td>\n",
       "      <td>foul</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>pham, tommy</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49028</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Greene, Hunter</td>\n",
       "      <td>518735</td>\n",
       "      <td>668881</td>\n",
       "      <td>NaN</td>\n",
       "      <td>foul</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>grandal, yasmani</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49033</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Greene, Hunter</td>\n",
       "      <td>673357</td>\n",
       "      <td>668881</td>\n",
       "      <td>NaN</td>\n",
       "      <td>foul</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>robert, luis</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8673 rows × 96 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      pitch_type   game_date  release_speed  release_pos_x  release_pos_z  \\\n",
       "9             SI  2022-10-05           93.4           2.36           5.41   \n",
       "16            FC  2022-10-05           88.1          -3.07           5.74   \n",
       "28            FF  2022-10-05           95.1          -0.71           5.91   \n",
       "40            SI  2022-10-05           89.8           3.32           5.04   \n",
       "59            FF  2022-10-05           96.0          -1.93           5.61   \n",
       "...          ...         ...            ...            ...            ...   \n",
       "48979        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "48982        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "49018        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "49028        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "49033        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "\n",
       "             pitcher_name  batter  pitcher events description  ...  \\\n",
       "9         Hughes, Brandon  641584   676714    NaN        foul  ...   \n",
       "16     Strickland, Hunter  663845   519326    NaN        foul  ...   \n",
       "28            Wick, Rowan  519222   592858    NaN        foul  ...   \n",
       "40      Sanmartin, Reiver  623520   665665    NaN        foul  ...   \n",
       "59        Rucker, Michael  668715   621074    NaN        foul  ...   \n",
       "...                   ...     ...      ...    ...         ...  ...   \n",
       "48979    Velasquez, Vince  606157   592826    NaN        foul  ...   \n",
       "48982        Farmer, Buck  543281   571656    NaN        foul  ...   \n",
       "49018     Kopech, Michael  502054   656629    NaN        foul  ...   \n",
       "49028      Greene, Hunter  518735   668881    NaN        foul  ...   \n",
       "49033      Greene, Hunter  673357   668881    NaN        foul  ...   \n",
       "\n",
       "       post_fld_score  if_fielding_alignment  of_fielding_alignment  \\\n",
       "9                  15               Standard               Standard   \n",
       "16                  2          Infield shift               Standard   \n",
       "28                 15               Standard               Standard   \n",
       "40                  2               Standard               Standard   \n",
       "59                 13               Standard              Strategic   \n",
       "...               ...                    ...                    ...   \n",
       "48979               7                    NaN                    NaN   \n",
       "48982               1                    NaN                    NaN   \n",
       "49018               2                    NaN                    NaN   \n",
       "49028               0                    NaN                    NaN   \n",
       "49033               0                    NaN                    NaN   \n",
       "\n",
       "       spin_axis  delta_home_win_exp delta_run_exp attack_zone swing  \\\n",
       "9          132.0                 0.0        -0.066       chase     0   \n",
       "16         104.0                 0.0        -0.036      shadow     0   \n",
       "28         197.0                 0.0        -0.049       chase     0   \n",
       "40         119.0                 0.0        -0.058       heart     0   \n",
       "59         221.0                 0.0        -0.150       heart     0   \n",
       "...          ...                 ...           ...         ...   ...   \n",
       "48979        NaN                 0.0           NaN       waste     0   \n",
       "48982        NaN                 0.0           NaN       waste     0   \n",
       "49018        NaN                 0.0           NaN       waste     0   \n",
       "49028        NaN                 0.0           NaN       waste     0   \n",
       "49033        NaN                 0.0           NaN       waste     0   \n",
       "\n",
       "             batter_name total_score  \n",
       "9           fraley, jake          17  \n",
       "16        rivas, alfonso          17  \n",
       "28        romine, austin          17  \n",
       "40           bote, david          17  \n",
       "59        steer, spencer          15  \n",
       "...                  ...         ...  \n",
       "48979  aquino, aristides           8  \n",
       "48982     harrison, josh           8  \n",
       "49018        pham, tommy           3  \n",
       "49028   grandal, yasmani           0  \n",
       "49033       robert, luis           0  \n",
       "\n",
       "[8673 rows x 96 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# loc method to locating information based on if statements\n",
    "df.loc[df['description']=='foul']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "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>pitcher_name</th>\n",
       "      <th>batter</th>\n",
       "      <th>pitcher</th>\n",
       "      <th>events</th>\n",
       "      <th>description</th>\n",
       "      <th>...</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>attack_zone</th>\n",
       "      <th>swing</th>\n",
       "      <th>batter_name</th>\n",
       "      <th>total_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.8</td>\n",
       "      <td>2.32</td>\n",
       "      <td>5.48</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>called_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.023</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>94.1</td>\n",
       "      <td>2.34</td>\n",
       "      <td>5.54</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>swinging_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.017</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>94.5</td>\n",
       "      <td>2.25</td>\n",
       "      <td>5.47</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>608703</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>called_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>124.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.024</td>\n",
       "      <td>shadow</td>\n",
       "      <td>0</td>\n",
       "      <td>reynolds, matt</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SI</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.4</td>\n",
       "      <td>2.36</td>\n",
       "      <td>5.41</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>641584</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>foul</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>132.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.066</td>\n",
       "      <td>chase</td>\n",
       "      <td>0</td>\n",
       "      <td>fraley, jake</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>92.7</td>\n",
       "      <td>2.45</td>\n",
       "      <td>5.40</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>641584</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>called_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>130.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.034</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>fraley, jake</td>\n",
       "      <td>17</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>49033</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Greene, Hunter</td>\n",
       "      <td>673357</td>\n",
       "      <td>668881</td>\n",
       "      <td>NaN</td>\n",
       "      <td>foul</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>robert, luis</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49034</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Greene, Hunter</td>\n",
       "      <td>673357</td>\n",
       "      <td>668881</td>\n",
       "      <td>NaN</td>\n",
       "      <td>swinging_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>robert, luis</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49035</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Greene, Hunter</td>\n",
       "      <td>641313</td>\n",
       "      <td>668881</td>\n",
       "      <td>strikeout</td>\n",
       "      <td>foul_tip</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>anderson, tim</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49036</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Greene, Hunter</td>\n",
       "      <td>641313</td>\n",
       "      <td>668881</td>\n",
       "      <td>NaN</td>\n",
       "      <td>called_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>anderson, tim</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49037</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Greene, Hunter</td>\n",
       "      <td>641313</td>\n",
       "      <td>668881</td>\n",
       "      <td>NaN</td>\n",
       "      <td>swinging_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>anderson, tim</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>22928 rows × 96 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      pitch_type   game_date  release_speed  release_pos_x  release_pos_z  \\\n",
       "3             FF  2022-10-05           93.8           2.32           5.48   \n",
       "4             FF  2022-10-05           94.1           2.34           5.54   \n",
       "6             FF  2022-10-05           94.5           2.25           5.47   \n",
       "9             SI  2022-10-05           93.4           2.36           5.41   \n",
       "12            FF  2022-10-05           92.7           2.45           5.40   \n",
       "...          ...         ...            ...            ...            ...   \n",
       "49033        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "49034        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "49035        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "49036        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "49037        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "\n",
       "          pitcher_name  batter  pitcher     events      description  ...  \\\n",
       "3      Hughes, Brandon  605244   676714        NaN    called_strike  ...   \n",
       "4      Hughes, Brandon  605244   676714        NaN  swinging_strike  ...   \n",
       "6      Hughes, Brandon  608703   676714        NaN    called_strike  ...   \n",
       "9      Hughes, Brandon  641584   676714        NaN             foul  ...   \n",
       "12     Hughes, Brandon  641584   676714        NaN    called_strike  ...   \n",
       "...                ...     ...      ...        ...              ...  ...   \n",
       "49033   Greene, Hunter  673357   668881        NaN             foul  ...   \n",
       "49034   Greene, Hunter  673357   668881        NaN  swinging_strike  ...   \n",
       "49035   Greene, Hunter  641313   668881  strikeout         foul_tip  ...   \n",
       "49036   Greene, Hunter  641313   668881        NaN    called_strike  ...   \n",
       "49037   Greene, Hunter  641313   668881        NaN  swinging_strike  ...   \n",
       "\n",
       "       post_fld_score  if_fielding_alignment  of_fielding_alignment  \\\n",
       "3                  15               Standard               Standard   \n",
       "4                  15               Standard               Standard   \n",
       "6                  15               Standard               Standard   \n",
       "9                  15               Standard               Standard   \n",
       "12                 15               Standard               Standard   \n",
       "...               ...                    ...                    ...   \n",
       "49033               0                    NaN                    NaN   \n",
       "49034               0                    NaN                    NaN   \n",
       "49035               0                    NaN                    NaN   \n",
       "49036               0                    NaN                    NaN   \n",
       "49037               0                    NaN                    NaN   \n",
       "\n",
       "       spin_axis  delta_home_win_exp delta_run_exp attack_zone swing  \\\n",
       "3          133.0               0.000        -0.023       heart     0   \n",
       "4          133.0               0.000        -0.017       heart     0   \n",
       "6          124.0               0.000        -0.024      shadow     0   \n",
       "9          132.0               0.000        -0.066       chase     0   \n",
       "12         130.0               0.000        -0.034       heart     0   \n",
       "...          ...                 ...           ...         ...   ...   \n",
       "49033        NaN               0.000           NaN       waste     0   \n",
       "49034        NaN               0.000           NaN       waste     0   \n",
       "49035        NaN               0.022           NaN       waste     0   \n",
       "49036        NaN               0.000           NaN       waste     0   \n",
       "49037        NaN               0.000           NaN       waste     0   \n",
       "\n",
       "          batter_name total_score  \n",
       "3      garcia, aramis          17  \n",
       "4      garcia, aramis          17  \n",
       "6      reynolds, matt          17  \n",
       "9        fraley, jake          17  \n",
       "12       fraley, jake          17  \n",
       "...               ...         ...  \n",
       "49033    robert, luis           0  \n",
       "49034    robert, luis           0  \n",
       "49035   anderson, tim           0  \n",
       "49036   anderson, tim           0  \n",
       "49037   anderson, tim           0  \n",
       "\n",
       "[22928 rows x 96 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df['description'].isin(strike_events)]\n",
    "# using the .isin method to call a list that was created."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['is_strike'] = 0\n",
    "# The above creates another new column and sets the value to 0\n",
    "\n",
    "df.loc[df['description'].isin(strike_events), 'is_strike'] = 1\n",
    "# changes the column to show is_strike column all 0, but, using the created list whenever that \n",
    "# strike is true, the value then is set to one.\n",
    "# pandas if statment?\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        0\n",
       "1        0\n",
       "2        0\n",
       "3        1\n",
       "4        1\n",
       "        ..\n",
       "49033    1\n",
       "49034    1\n",
       "49035    1\n",
       "49036    1\n",
       "49037    1\n",
       "Name: is_strike, Length: 49038, dtype: int64"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['is_strike']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "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>pitcher_name</th>\n",
       "      <th>batter</th>\n",
       "      <th>pitcher</th>\n",
       "      <th>events</th>\n",
       "      <th>description</th>\n",
       "      <th>...</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>attack_zone</th>\n",
       "      <th>swing</th>\n",
       "      <th>batter_name</th>\n",
       "      <th>total_score</th>\n",
       "      <th>is_strike</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.8</td>\n",
       "      <td>2.39</td>\n",
       "      <td>5.44</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>field_out</td>\n",
       "      <td>hit_into_play</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.083</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.3</td>\n",
       "      <td>2.30</td>\n",
       "      <td>5.51</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>132.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.014</td>\n",
       "      <td>shadow</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SL</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>84.3</td>\n",
       "      <td>2.45</td>\n",
       "      <td>5.21</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>216.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.011</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.8</td>\n",
       "      <td>2.32</td>\n",
       "      <td>5.48</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>called_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.023</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>94.1</td>\n",
       "      <td>2.34</td>\n",
       "      <td>5.54</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>swinging_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.017</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.8</td>\n",
       "      <td>2.33</td>\n",
       "      <td>5.50</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>608703</td>\n",
       "      <td>676714</td>\n",
       "      <td>field_out</td>\n",
       "      <td>hit_into_play</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>126.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.132</td>\n",
       "      <td>shadow</td>\n",
       "      <td>0</td>\n",
       "      <td>reynolds, matt</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>94.5</td>\n",
       "      <td>2.25</td>\n",
       "      <td>5.47</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>608703</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>called_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>124.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.024</td>\n",
       "      <td>shadow</td>\n",
       "      <td>0</td>\n",
       "      <td>reynolds, matt</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>92.8</td>\n",
       "      <td>2.48</td>\n",
       "      <td>5.40</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>641584</td>\n",
       "      <td>676714</td>\n",
       "      <td>field_out</td>\n",
       "      <td>hit_into_play</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>130.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.299</td>\n",
       "      <td>shadow</td>\n",
       "      <td>0</td>\n",
       "      <td>fraley, jake</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>94.7</td>\n",
       "      <td>2.32</td>\n",
       "      <td>5.55</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>641584</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>Standard</td>\n",
       "      <td>134.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.103</td>\n",
       "      <td>chase</td>\n",
       "      <td>0</td>\n",
       "      <td>fraley, jake</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9 rows × 97 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  pitch_type   game_date  release_speed  release_pos_x  release_pos_z  \\\n",
       "0         FF  2022-10-05           93.8           2.39           5.44   \n",
       "1         FF  2022-10-05           93.3           2.30           5.51   \n",
       "2         SL  2022-10-05           84.3           2.45           5.21   \n",
       "3         FF  2022-10-05           93.8           2.32           5.48   \n",
       "4         FF  2022-10-05           94.1           2.34           5.54   \n",
       "5         FF  2022-10-05           93.8           2.33           5.50   \n",
       "6         FF  2022-10-05           94.5           2.25           5.47   \n",
       "7         FF  2022-10-05           92.8           2.48           5.40   \n",
       "8         FF  2022-10-05           94.7           2.32           5.55   \n",
       "\n",
       "      pitcher_name  batter  pitcher     events      description  ...  \\\n",
       "0  Hughes, Brandon  605244   676714  field_out    hit_into_play  ...   \n",
       "1  Hughes, Brandon  605244   676714        NaN             ball  ...   \n",
       "2  Hughes, Brandon  605244   676714        NaN             ball  ...   \n",
       "3  Hughes, Brandon  605244   676714        NaN    called_strike  ...   \n",
       "4  Hughes, Brandon  605244   676714        NaN  swinging_strike  ...   \n",
       "5  Hughes, Brandon  608703   676714  field_out    hit_into_play  ...   \n",
       "6  Hughes, Brandon  608703   676714        NaN    called_strike  ...   \n",
       "7  Hughes, Brandon  641584   676714  field_out    hit_into_play  ...   \n",
       "8  Hughes, Brandon  641584   676714        NaN             ball  ...   \n",
       "\n",
       "   if_fielding_alignment  of_fielding_alignment  spin_axis  \\\n",
       "0               Standard               Standard      133.0   \n",
       "1               Standard               Standard      132.0   \n",
       "2               Standard               Standard      216.0   \n",
       "3               Standard               Standard      133.0   \n",
       "4               Standard               Standard      133.0   \n",
       "5               Standard               Standard      126.0   \n",
       "6               Standard               Standard      124.0   \n",
       "7               Standard               Standard      130.0   \n",
       "8               Standard               Standard      134.0   \n",
       "\n",
       "   delta_home_win_exp  delta_run_exp attack_zone swing     batter_name  \\\n",
       "0                 0.0         -0.083       heart     0  garcia, aramis   \n",
       "1                 0.0          0.014      shadow     0  garcia, aramis   \n",
       "2                 0.0          0.011       waste     0  garcia, aramis   \n",
       "3                 0.0         -0.023       heart     0  garcia, aramis   \n",
       "4                 0.0         -0.017       heart     0  garcia, aramis   \n",
       "5                 0.0         -0.132      shadow     0  reynolds, matt   \n",
       "6                 0.0         -0.024      shadow     0  reynolds, matt   \n",
       "7                 0.0         -0.299      shadow     0    fraley, jake   \n",
       "8                 0.0          0.103       chase     0    fraley, jake   \n",
       "\n",
       "  total_score is_strike  \n",
       "0          17         0  \n",
       "1          17         0  \n",
       "2          17         0  \n",
       "3          17         1  \n",
       "4          17         1  \n",
       "5          17         0  \n",
       "6          17         1  \n",
       "7          17         0  \n",
       "8          17         0  \n",
       "\n",
       "[9 rows x 97 columns]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(9)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['is_2_strikes'] = 0\n",
    "df.loc[df['strikes']==2, 'is_2_strikes'] = 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "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>pitcher_name</th>\n",
       "      <th>batter</th>\n",
       "      <th>pitcher</th>\n",
       "      <th>events</th>\n",
       "      <th>description</th>\n",
       "      <th>...</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>attack_zone</th>\n",
       "      <th>swing</th>\n",
       "      <th>batter_name</th>\n",
       "      <th>total_score</th>\n",
       "      <th>is_strike</th>\n",
       "      <th>is_2_strikes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.8</td>\n",
       "      <td>2.39</td>\n",
       "      <td>5.44</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>field_out</td>\n",
       "      <td>hit_into_play</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.083</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.3</td>\n",
       "      <td>2.30</td>\n",
       "      <td>5.51</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>132.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.014</td>\n",
       "      <td>shadow</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SL</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>84.3</td>\n",
       "      <td>2.45</td>\n",
       "      <td>5.21</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>216.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.011</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>92.8</td>\n",
       "      <td>2.48</td>\n",
       "      <td>5.40</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>641584</td>\n",
       "      <td>676714</td>\n",
       "      <td>field_out</td>\n",
       "      <td>hit_into_play</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>130.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.299</td>\n",
       "      <td>shadow</td>\n",
       "      <td>0</td>\n",
       "      <td>fraley, jake</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>94.7</td>\n",
       "      <td>2.32</td>\n",
       "      <td>5.55</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>641584</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>134.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.103</td>\n",
       "      <td>chase</td>\n",
       "      <td>0</td>\n",
       "      <td>fraley, jake</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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>49023</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Greene, Hunter</td>\n",
       "      <td>650391</td>\n",
       "      <td>668881</td>\n",
       "      <td>strikeout</td>\n",
       "      <td>called_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>jiménez, eloy</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49026</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Greene, Hunter</td>\n",
       "      <td>518735</td>\n",
       "      <td>668881</td>\n",
       "      <td>home_run</td>\n",
       "      <td>hit_into_play</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.190</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>grandal, yasmani</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49027</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Greene, Hunter</td>\n",
       "      <td>518735</td>\n",
       "      <td>668881</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>grandal, yasmani</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49032</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Greene, Hunter</td>\n",
       "      <td>673357</td>\n",
       "      <td>668881</td>\n",
       "      <td>strikeout</td>\n",
       "      <td>swinging_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.015</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>robert, luis</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49035</th>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-03-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Greene, Hunter</td>\n",
       "      <td>641313</td>\n",
       "      <td>668881</td>\n",
       "      <td>strikeout</td>\n",
       "      <td>foul_tip</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>anderson, tim</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>14542 rows × 98 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      pitch_type   game_date  release_speed  release_pos_x  release_pos_z  \\\n",
       "0             FF  2022-10-05           93.8           2.39           5.44   \n",
       "1             FF  2022-10-05           93.3           2.30           5.51   \n",
       "2             SL  2022-10-05           84.3           2.45           5.21   \n",
       "7             FF  2022-10-05           92.8           2.48           5.40   \n",
       "8             FF  2022-10-05           94.7           2.32           5.55   \n",
       "...          ...         ...            ...            ...            ...   \n",
       "49023        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "49026        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "49027        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "49032        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "49035        NaN  2022-03-31            NaN            NaN            NaN   \n",
       "\n",
       "          pitcher_name  batter  pitcher     events      description  ...  \\\n",
       "0      Hughes, Brandon  605244   676714  field_out    hit_into_play  ...   \n",
       "1      Hughes, Brandon  605244   676714        NaN             ball  ...   \n",
       "2      Hughes, Brandon  605244   676714        NaN             ball  ...   \n",
       "7      Hughes, Brandon  641584   676714  field_out    hit_into_play  ...   \n",
       "8      Hughes, Brandon  641584   676714        NaN             ball  ...   \n",
       "...                ...     ...      ...        ...              ...  ...   \n",
       "49023   Greene, Hunter  650391   668881  strikeout    called_strike  ...   \n",
       "49026   Greene, Hunter  518735   668881   home_run    hit_into_play  ...   \n",
       "49027   Greene, Hunter  518735   668881        NaN             ball  ...   \n",
       "49032   Greene, Hunter  673357   668881  strikeout  swinging_strike  ...   \n",
       "49035   Greene, Hunter  641313   668881  strikeout         foul_tip  ...   \n",
       "\n",
       "       of_fielding_alignment  spin_axis  delta_home_win_exp  delta_run_exp  \\\n",
       "0                   Standard      133.0               0.000         -0.083   \n",
       "1                   Standard      132.0               0.000          0.014   \n",
       "2                   Standard      216.0               0.000          0.011   \n",
       "7                   Standard      130.0               0.000         -0.299   \n",
       "8                   Standard      134.0               0.000          0.103   \n",
       "...                      ...        ...                 ...            ...   \n",
       "49023                    NaN        NaN               0.007            NaN   \n",
       "49026                    NaN        NaN              -0.190            NaN   \n",
       "49027                    NaN        NaN               0.000            NaN   \n",
       "49032                    NaN        NaN               0.015            NaN   \n",
       "49035                    NaN        NaN               0.022            NaN   \n",
       "\n",
       "       attack_zone swing       batter_name total_score is_strike is_2_strikes  \n",
       "0            heart     0    garcia, aramis          17         0            1  \n",
       "1           shadow     0    garcia, aramis          17         0            1  \n",
       "2            waste     0    garcia, aramis          17         0            1  \n",
       "7           shadow     0      fraley, jake          17         0            1  \n",
       "8            chase     0      fraley, jake          17         0            1  \n",
       "...            ...   ...               ...         ...       ...          ...  \n",
       "49023        waste     0     jiménez, eloy           2         1            1  \n",
       "49026        waste     0  grandal, yasmani           0         0            1  \n",
       "49027        waste     0  grandal, yasmani           0         0            1  \n",
       "49032        waste     0      robert, luis           0         1            1  \n",
       "49035        waste     0     anderson, tim           0         1            1  \n",
       "\n",
       "[14542 rows x 98 columns]"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df['is_2_strikes'] == 1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "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>pitcher_name</th>\n",
       "      <th>batter</th>\n",
       "      <th>pitcher</th>\n",
       "      <th>events</th>\n",
       "      <th>description</th>\n",
       "      <th>...</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>attack_zone</th>\n",
       "      <th>swing</th>\n",
       "      <th>batter_name</th>\n",
       "      <th>total_score</th>\n",
       "      <th>is_strike</th>\n",
       "      <th>is_2_strikes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.8</td>\n",
       "      <td>2.39</td>\n",
       "      <td>5.44</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>field_out</td>\n",
       "      <td>hit_into_play</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.083</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.3</td>\n",
       "      <td>2.30</td>\n",
       "      <td>5.51</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>132.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.014</td>\n",
       "      <td>shadow</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SL</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>84.3</td>\n",
       "      <td>2.45</td>\n",
       "      <td>5.21</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ball</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>216.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.011</td>\n",
       "      <td>waste</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>93.8</td>\n",
       "      <td>2.32</td>\n",
       "      <td>5.48</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>called_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.023</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FF</td>\n",
       "      <td>2022-10-05</td>\n",
       "      <td>94.1</td>\n",
       "      <td>2.34</td>\n",
       "      <td>5.54</td>\n",
       "      <td>Hughes, Brandon</td>\n",
       "      <td>605244</td>\n",
       "      <td>676714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>swinging_strike</td>\n",
       "      <td>...</td>\n",
       "      <td>Standard</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.017</td>\n",
       "      <td>heart</td>\n",
       "      <td>0</td>\n",
       "      <td>garcia, aramis</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 98 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  pitch_type   game_date  release_speed  release_pos_x  release_pos_z  \\\n",
       "0         FF  2022-10-05           93.8           2.39           5.44   \n",
       "1         FF  2022-10-05           93.3           2.30           5.51   \n",
       "2         SL  2022-10-05           84.3           2.45           5.21   \n",
       "3         FF  2022-10-05           93.8           2.32           5.48   \n",
       "4         FF  2022-10-05           94.1           2.34           5.54   \n",
       "\n",
       "      pitcher_name  batter  pitcher     events      description  ...  \\\n",
       "0  Hughes, Brandon  605244   676714  field_out    hit_into_play  ...   \n",
       "1  Hughes, Brandon  605244   676714        NaN             ball  ...   \n",
       "2  Hughes, Brandon  605244   676714        NaN             ball  ...   \n",
       "3  Hughes, Brandon  605244   676714        NaN    called_strike  ...   \n",
       "4  Hughes, Brandon  605244   676714        NaN  swinging_strike  ...   \n",
       "\n",
       "   of_fielding_alignment  spin_axis  delta_home_win_exp  delta_run_exp  \\\n",
       "0               Standard      133.0                 0.0         -0.083   \n",
       "1               Standard      132.0                 0.0          0.014   \n",
       "2               Standard      216.0                 0.0          0.011   \n",
       "3               Standard      133.0                 0.0         -0.023   \n",
       "4               Standard      133.0                 0.0         -0.017   \n",
       "\n",
       "   attack_zone swing     batter_name total_score is_strike is_2_strikes  \n",
       "0        heart     0  garcia, aramis          17         0            1  \n",
       "1       shadow     0  garcia, aramis          17         0            1  \n",
       "2        waste     0  garcia, aramis          17         0            1  \n",
       "3        heart     0  garcia, aramis          17         1            0  \n",
       "4        heart     0  garcia, aramis          17         1            0  \n",
       "\n",
       "[5 rows x 98 columns]"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Home Work\n",
    "\n",
    "1. use the \"strikes\" column to find where there are 2 strikes and make a new column\n",
    "indicating whether the pitch was thrown in a 2 strike situation. \n",
    "\n",
    "Name this column: is_2_strikes\n",
    "\n",
    "\n",
    "2. use the release speend column to find when a pitch is thrown greater than 94 MPH\n",
    "The column is in MPH already, \n",
    "\n",
    "Name this: is_high_velo\n",
    "\n",
    "\n",
    "3. us the description column AND the attack_zone column to indicate when a pitch is thrown for a called or swinging\n",
    "strike  (not a foul) in the \"heart\" attack zone.\n",
    "This requires two conditional statements\n",
    "ask google or discord."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "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.12.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}