Build_Choices.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import sqlalchemy\n",
    "con = sqlalchemy.create_engine('postgres://localhost/baseball')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>game_id</th>\n",
       "      <th>bat_id</th>\n",
       "      <th>bat_home_id</th>\n",
       "      <th>bat_lineup_id</th>\n",
       "      <th>array_agg</th>\n",
       "      <th>count</th>\n",
       "      <th>best_hit</th>\n",
       "      <th>num_hits</th>\n",
       "      <th>num_singles</th>\n",
       "      <th>num_doubles</th>\n",
       "      <th>num_triples</th>\n",
       "      <th>num_hrs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>aybae001</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, L, R, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>cainl001</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>calhk001</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>cowgc001</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R]</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>cronc002</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>escoa003</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>freed001</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>giavj001</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>[R, R, R]</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>gorda001</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>hosme001</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>[L, L, L, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>iannc001</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>infao001</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>morak001</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>mousm001</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>[L, L, L, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>peres002</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>pujoa001</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>riosa002</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>troum001</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>aybae001</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>buted001</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R]</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>cainl001</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>calhk001</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>escoa003</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>freed001</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>giavj001</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>[R, R, R]</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>gorda001</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>[L, L, L, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>hosme001</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>[L, L, L, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>infao001</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>joycm001</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>morak001</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>[L, R, R, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41248</th>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>blana001</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>[L, L, R, R, R, R]</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41249</th>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>dendm001</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41250</th>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>desmi001</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, R, R]</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41251</th>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>escoy001</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41252</th>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>franj004</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41253</th>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>galvf001</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, L, R, R, R, L]</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41254</th>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>harpb003</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41255</th>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>krate001</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41256</th>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>lobaj001</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41257</th>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>renda001</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41258</th>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>robic001</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41259</th>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>ruf-d001</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41260</th>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>ruppc001</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41261</th>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>taylm002</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41262</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>barnt001</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>[L, L, L]</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41263</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>boesb001</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>[L, L, L]</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41264</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>brucj001</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41265</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>dejei002</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41266</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>dendm001</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41267</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>frazt001</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41268</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>moort002</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41269</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>ramow001</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41270</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>renda001</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41271</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>robic001</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41272</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>schus001</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41273</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>suare001</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, R, R]</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41274</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>taylm002</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41275</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>turnt001</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41276</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>uggld001</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41277</th>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>vottj001</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>41278 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            game_id    bat_id bat_home_id bat_lineup_id           array_agg  \\\n",
       "0      ANA201504100  aybae001           1             6        [R, L, R, L]   \n",
       "1      ANA201504100  cainl001           0             3     [R, R, R, R, R]   \n",
       "2      ANA201504100  calhk001           1             1        [L, L, L, L]   \n",
       "3      ANA201504100  cowgc001           1             8              [R, R]   \n",
       "4      ANA201504100  cronc002           1             5        [R, R, R, R]   \n",
       "5      ANA201504100  escoa003           0             1     [R, R, R, R, R]   \n",
       "6      ANA201504100  freed001           1             4        [R, R, R, R]   \n",
       "7      ANA201504100  giavj001           1             9           [R, R, R]   \n",
       "8      ANA201504100  gorda001           0             6        [L, L, L, L]   \n",
       "9      ANA201504100  hosme001           0             4     [L, L, L, L, L]   \n",
       "10     ANA201504100  iannc001           1             7        [R, R, R, R]   \n",
       "11     ANA201504100  infao001           0             9        [R, R, R, R]   \n",
       "12     ANA201504100  morak001           0             5     [R, R, R, R, R]   \n",
       "13     ANA201504100  mousm001           0             2     [L, L, L, L, L]   \n",
       "14     ANA201504100  peres002           0             8        [R, R, R, R]   \n",
       "15     ANA201504100  pujoa001           1             3        [R, R, R, R]   \n",
       "16     ANA201504100  riosa002           0             7        [R, R, R, R]   \n",
       "17     ANA201504100  troum001           1             2        [R, R, R, R]   \n",
       "18     ANA201504110  aybae001           1             6        [L, L, L, L]   \n",
       "19     ANA201504110  buted001           1             8              [R, R]   \n",
       "20     ANA201504110  cainl001           0             3     [R, R, R, R, R]   \n",
       "21     ANA201504110  calhk001           1             1        [L, L, L, L]   \n",
       "22     ANA201504110  escoa003           0             1     [R, R, R, R, R]   \n",
       "23     ANA201504110  freed001           1             5        [R, R, R, R]   \n",
       "24     ANA201504110  giavj001           1             9           [R, R, R]   \n",
       "25     ANA201504110  gorda001           0             6     [L, L, L, L, L]   \n",
       "26     ANA201504110  hosme001           0             4     [L, L, L, L, L]   \n",
       "27     ANA201504110  infao001           0             9        [R, R, R, R]   \n",
       "28     ANA201504110  joycm001           1             4        [L, L, L, L]   \n",
       "29     ANA201504110  morak001           0             5     [L, R, R, L, L]   \n",
       "...             ...       ...         ...           ...                 ...   \n",
       "41248  WAS201509270  blana001           0             2  [L, L, R, R, R, R]   \n",
       "41249  WAS201509270  dendm001           1             7        [L, L, L, L]   \n",
       "41250  WAS201509270  desmi001           1             6           [R, R, R]   \n",
       "41251  WAS201509270  escoy001           1             4        [R, R, R, R]   \n",
       "41252  WAS201509270  franj004           0             5     [R, R, R, R, R]   \n",
       "41253  WAS201509270  galvf001           0             1  [R, L, R, R, R, L]   \n",
       "41254  WAS201509270  harpb003           1             3        [L, L, L, L]   \n",
       "41255  WAS201509270  krate001           0             6        [R, R, R, R]   \n",
       "41256  WAS201509270  lobaj001           1             8        [L, L, L, L]   \n",
       "41257  WAS201509270  renda001           1             2        [R, R, R, R]   \n",
       "41258  WAS201509270  robic001           1             5        [L, L, L, L]   \n",
       "41259  WAS201509270  ruf-d001           0             4     [R, R, R, R, R]   \n",
       "41260  WAS201509270  ruppc001           0             8     [R, R, R, R, R]   \n",
       "41261  WAS201509270  taylm002           1             1        [R, R, R, R]   \n",
       "41262  WAS201509280  barnt001           0             8           [L, L, L]   \n",
       "41263  WAS201509280  boesb001           0             7           [L, L, L]   \n",
       "41264  WAS201509280  brucj001           0             5        [L, L, L, L]   \n",
       "41265  WAS201509280  dejei002           0             2        [R, R, R, R]   \n",
       "41266  WAS201509280  dendm001           1             7        [L, L, L, L]   \n",
       "41267  WAS201509280  frazt001           0             4        [R, R, R, R]   \n",
       "41268  WAS201509280  moort002           1             6        [R, R, R, R]   \n",
       "41269  WAS201509280  ramow001           1             5        [R, R, R, R]   \n",
       "41270  WAS201509280  renda001           1             3        [R, R, R, R]   \n",
       "41271  WAS201509280  robic001           1             4        [L, L, L, L]   \n",
       "41272  WAS201509280  schus001           0             1        [L, L, L, L]   \n",
       "41273  WAS201509280  suare001           0             6           [R, R, R]   \n",
       "41274  WAS201509280  taylm002           1             1     [R, R, R, R, R]   \n",
       "41275  WAS201509280  turnt001           1             2        [R, R, R, R]   \n",
       "41276  WAS201509280  uggld001           1             8        [R, R, R, R]   \n",
       "41277  WAS201509280  vottj001           0             3        [L, L, L, L]   \n",
       "\n",
       "       count best_hit  num_hits  num_singles  num_doubles  num_triples  \\\n",
       "0          4        0         0            0            0            0   \n",
       "1          5        2         2            1            1            0   \n",
       "2          4        2         1            0            1            0   \n",
       "3          2        1         1            1            0            0   \n",
       "4          4        0         0            0            0            0   \n",
       "5          5        1         1            1            0            0   \n",
       "6          4        4         2            1            0            0   \n",
       "7          3        0         0            0            0            0   \n",
       "8          4        0         0            0            0            0   \n",
       "9          5        1         1            1            0            0   \n",
       "10         4        0         0            0            0            0   \n",
       "11         4        1         1            1            0            0   \n",
       "12         5        4         2            1            0            0   \n",
       "13         5        1         1            1            0            0   \n",
       "14         4        1         1            1            0            0   \n",
       "15         4        0         0            0            0            0   \n",
       "16         4        0         0            0            0            0   \n",
       "17         4        1         2            2            0            0   \n",
       "18         4        1         1            1            0            0   \n",
       "19         2        1         1            1            0            0   \n",
       "20         5        1         1            1            0            0   \n",
       "21         4        4         2            0            1            0   \n",
       "22         5        1         1            1            0            0   \n",
       "23         4        0         0            0            0            0   \n",
       "24         3        0         0            0            0            0   \n",
       "25         5        0         0            0            0            0   \n",
       "26         5        1         1            1            0            0   \n",
       "27         4        1         1            1            0            0   \n",
       "28         4        0         0            0            0            0   \n",
       "29         5        2         3            2            1            0   \n",
       "...      ...      ...       ...          ...          ...          ...   \n",
       "41248      6        4         3            2            0            0   \n",
       "41249      4        4         4            2            1            0   \n",
       "41250      3        4         3            2            0            0   \n",
       "41251      4        0         0            0            0            0   \n",
       "41252      5        4         3            1            1            0   \n",
       "41253      6        1         3            3            0            0   \n",
       "41254      4        0         0            0            0            0   \n",
       "41255      4        1         1            1            0            0   \n",
       "41256      4        2         1            0            1            0   \n",
       "41257      4        0         0            0            0            0   \n",
       "41258      4        0         0            0            0            0   \n",
       "41259      5        0         0            0            0            0   \n",
       "41260      5        1         1            1            0            0   \n",
       "41261      4        0         0            0            0            0   \n",
       "41262      3        1         1            1            0            0   \n",
       "41263      3        0         0            0            0            0   \n",
       "41264      4        0         0            0            0            0   \n",
       "41265      4        0         0            0            0            0   \n",
       "41266      4        4         3            0            2            0   \n",
       "41267      4        0         0            0            0            0   \n",
       "41268      4        1         1            1            0            0   \n",
       "41269      4        4         1            0            0            0   \n",
       "41270      4        2         1            0            1            0   \n",
       "41271      4        1         1            1            0            0   \n",
       "41272      4        1         1            1            0            0   \n",
       "41273      3        0         0            0            0            0   \n",
       "41274      5        1         2            2            0            0   \n",
       "41275      4        1         1            1            0            0   \n",
       "41276      4        0         0            0            0            0   \n",
       "41277      4        1         1            1            0            0   \n",
       "\n",
       "       num_hrs  \n",
       "0            0  \n",
       "1            0  \n",
       "2            0  \n",
       "3            0  \n",
       "4            0  \n",
       "5            0  \n",
       "6            1  \n",
       "7            0  \n",
       "8            0  \n",
       "9            0  \n",
       "10           0  \n",
       "11           0  \n",
       "12           1  \n",
       "13           0  \n",
       "14           0  \n",
       "15           0  \n",
       "16           0  \n",
       "17           0  \n",
       "18           0  \n",
       "19           0  \n",
       "20           0  \n",
       "21           1  \n",
       "22           0  \n",
       "23           0  \n",
       "24           0  \n",
       "25           0  \n",
       "26           0  \n",
       "27           0  \n",
       "28           0  \n",
       "29           0  \n",
       "...        ...  \n",
       "41248        1  \n",
       "41249        1  \n",
       "41250        1  \n",
       "41251        0  \n",
       "41252        1  \n",
       "41253        0  \n",
       "41254        0  \n",
       "41255        0  \n",
       "41256        0  \n",
       "41257        0  \n",
       "41258        0  \n",
       "41259        0  \n",
       "41260        0  \n",
       "41261        0  \n",
       "41262        0  \n",
       "41263        0  \n",
       "41264        0  \n",
       "41265        0  \n",
       "41266        1  \n",
       "41267        0  \n",
       "41268        0  \n",
       "41269        1  \n",
       "41270        0  \n",
       "41271        0  \n",
       "41272        0  \n",
       "41273        0  \n",
       "41274        0  \n",
       "41275        0  \n",
       "41276        0  \n",
       "41277        0  \n",
       "\n",
       "[41278 rows x 12 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "view = '''\n",
    "create view choices as\n",
    "select \n",
    "    game_id,\n",
    "    bat_id,\n",
    "    BAT_HOME_ID,\n",
    "    BAT_LINEUP_ID,\n",
    "    array_agg(BAT_HAND_CD),\n",
    "    count(event_id), \n",
    "    max(h_cd) as best_hit, \n",
    "    count(case h_cd when '0' then null else 1 end) as num_hits, \n",
    "    count(case h_cd when '1' then 1 else null end) as num_singles,\n",
    "    count(case h_cd when '2' then 1 else null end) as num_doubles, \n",
    "    count(case h_cd when '3' then 1 else null end) as num_triples,\n",
    "    count(case h_cd when '4' then 1 else null end) as num_hrs \n",
    "    from vw_events \n",
    "        inner join vw_games using (game_id) \n",
    "    where \n",
    "        bat_start_fl='T' \n",
    "        and BAT_EVENT_FL='T'\n",
    "        and bat_fld_cd != '1'\n",
    "    group by game_id, bat_id, BAT_HOME_ID, BAT_LINEUP_ID\n",
    "'''\n",
    "con.execute(\"drop view if exists choices cascade;\")\n",
    "con.execute(view)\n",
    "pd.read_sql(\"select * from choices\", con)\n",
    "# should be: 41278\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>game_date</th>\n",
       "      <th>first_name_tx</th>\n",
       "      <th>last_name_tx</th>\n",
       "      <th>game_id</th>\n",
       "      <th>bat_id</th>\n",
       "      <th>bat_home_id</th>\n",
       "      <th>bat_lineup_id</th>\n",
       "      <th>array_agg</th>\n",
       "      <th>count</th>\n",
       "      <th>best_hit</th>\n",
       "      <th>...</th>\n",
       "      <th>away_start_pit_id</th>\n",
       "      <th>home_start_pit_id</th>\n",
       "      <th>attend_park_ct</th>\n",
       "      <th>temp_park_ct</th>\n",
       "      <th>wind_speed_park_ct</th>\n",
       "      <th>field_park_cd</th>\n",
       "      <th>precip_park_cd</th>\n",
       "      <th>sky_park_cd</th>\n",
       "      <th>bat_hand</th>\n",
       "      <th>pit_hand_cd</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Erick</td>\n",
       "      <td>Aybar</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>aybae001</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, L, R, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>B</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Lorenzo</td>\n",
       "      <td>Cain</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>cainl001</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Kole</td>\n",
       "      <td>Calhoun</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>calhk001</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>L</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Collin</td>\n",
       "      <td>Cowgill</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>cowgc001</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R]</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>C.J.</td>\n",
       "      <td>Cron</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>cronc002</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Alcides</td>\n",
       "      <td>Escobar</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>escoa003</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>David</td>\n",
       "      <td>Freese</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>freed001</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Johnny</td>\n",
       "      <td>Giavotella</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>giavj001</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>[R, R, R]</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Gordon</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>gorda001</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>L</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Eric</td>\n",
       "      <td>Hosmer</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>hosme001</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>[L, L, L, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>L</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Chris</td>\n",
       "      <td>Iannetta</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>iannc001</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Omar</td>\n",
       "      <td>Infante</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>infao001</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Kendrys</td>\n",
       "      <td>Morales</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>morak001</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>B</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Mike</td>\n",
       "      <td>Moustakas</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>mousm001</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>[L, L, L, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>L</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Salvador</td>\n",
       "      <td>Perez</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>peres002</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Albert</td>\n",
       "      <td>Pujols</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>pujoa001</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Rios</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>riosa002</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Mike</td>\n",
       "      <td>Trout</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>troum001</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>vargj001</td>\n",
       "      <td>santh001</td>\n",
       "      <td>44489</td>\n",
       "      <td>67</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Erick</td>\n",
       "      <td>Aybar</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>aybae001</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>guthj001</td>\n",
       "      <td>weavj003</td>\n",
       "      <td>44154</td>\n",
       "      <td>68</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>B</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Drew</td>\n",
       "      <td>Butera</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>buted001</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R]</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>guthj001</td>\n",
       "      <td>weavj003</td>\n",
       "      <td>44154</td>\n",
       "      <td>68</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>R</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Lorenzo</td>\n",
       "      <td>Cain</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>cainl001</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>guthj001</td>\n",
       "      <td>weavj003</td>\n",
       "      <td>44154</td>\n",
       "      <td>68</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>R</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Kole</td>\n",
       "      <td>Calhoun</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>calhk001</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>guthj001</td>\n",
       "      <td>weavj003</td>\n",
       "      <td>44154</td>\n",
       "      <td>68</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>L</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Alcides</td>\n",
       "      <td>Escobar</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>escoa003</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>guthj001</td>\n",
       "      <td>weavj003</td>\n",
       "      <td>44154</td>\n",
       "      <td>68</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>R</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>David</td>\n",
       "      <td>Freese</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>freed001</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>guthj001</td>\n",
       "      <td>weavj003</td>\n",
       "      <td>44154</td>\n",
       "      <td>68</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>R</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Johnny</td>\n",
       "      <td>Giavotella</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>giavj001</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>[R, R, R]</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>guthj001</td>\n",
       "      <td>weavj003</td>\n",
       "      <td>44154</td>\n",
       "      <td>68</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>R</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Gordon</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>gorda001</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>[L, L, L, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>guthj001</td>\n",
       "      <td>weavj003</td>\n",
       "      <td>44154</td>\n",
       "      <td>68</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>L</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Eric</td>\n",
       "      <td>Hosmer</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>hosme001</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>[L, L, L, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>guthj001</td>\n",
       "      <td>weavj003</td>\n",
       "      <td>44154</td>\n",
       "      <td>68</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>L</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Omar</td>\n",
       "      <td>Infante</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>infao001</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>guthj001</td>\n",
       "      <td>weavj003</td>\n",
       "      <td>44154</td>\n",
       "      <td>68</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>R</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Matthew</td>\n",
       "      <td>Joyce</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>joycm001</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>guthj001</td>\n",
       "      <td>weavj003</td>\n",
       "      <td>44154</td>\n",
       "      <td>68</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>L</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Kendrys</td>\n",
       "      <td>Morales</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>morak001</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, L, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>guthj001</td>\n",
       "      <td>weavj003</td>\n",
       "      <td>44154</td>\n",
       "      <td>68</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>B</td>\n",
       "      <td>R</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>41248</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Andres</td>\n",
       "      <td>Blanco</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>blana001</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>[L, R, R, R, R, L]</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>haraa001</td>\n",
       "      <td>gonzg003</td>\n",
       "      <td>28661</td>\n",
       "      <td>69</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>B</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41249</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Matt</td>\n",
       "      <td>den Dekker</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>dendm001</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>haraa001</td>\n",
       "      <td>gonzg003</td>\n",
       "      <td>28661</td>\n",
       "      <td>69</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>L</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41250</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Ian</td>\n",
       "      <td>Desmond</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>desmi001</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, R, R]</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>haraa001</td>\n",
       "      <td>gonzg003</td>\n",
       "      <td>28661</td>\n",
       "      <td>69</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41251</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Yunel</td>\n",
       "      <td>Escobar</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>escoy001</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>haraa001</td>\n",
       "      <td>gonzg003</td>\n",
       "      <td>28661</td>\n",
       "      <td>69</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41252</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Jeff</td>\n",
       "      <td>Francoeur</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>franj004</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>haraa001</td>\n",
       "      <td>gonzg003</td>\n",
       "      <td>28661</td>\n",
       "      <td>69</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41253</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Freddy</td>\n",
       "      <td>Galvis</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>galvf001</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, L, R, R, L, R]</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>haraa001</td>\n",
       "      <td>gonzg003</td>\n",
       "      <td>28661</td>\n",
       "      <td>69</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>B</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41254</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Bryce</td>\n",
       "      <td>Harper</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>harpb003</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>haraa001</td>\n",
       "      <td>gonzg003</td>\n",
       "      <td>28661</td>\n",
       "      <td>69</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>L</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41255</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Erik</td>\n",
       "      <td>Kratz</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>krate001</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>haraa001</td>\n",
       "      <td>gonzg003</td>\n",
       "      <td>28661</td>\n",
       "      <td>69</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41256</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Jose</td>\n",
       "      <td>Lobaton</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>lobaj001</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>haraa001</td>\n",
       "      <td>gonzg003</td>\n",
       "      <td>28661</td>\n",
       "      <td>69</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>B</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41257</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>Rendon</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>renda001</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>haraa001</td>\n",
       "      <td>gonzg003</td>\n",
       "      <td>28661</td>\n",
       "      <td>69</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41258</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Clint</td>\n",
       "      <td>Robinson</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>robic001</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>haraa001</td>\n",
       "      <td>gonzg003</td>\n",
       "      <td>28661</td>\n",
       "      <td>69</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>L</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41259</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Darin</td>\n",
       "      <td>Ruf</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>ruf-d001</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>haraa001</td>\n",
       "      <td>gonzg003</td>\n",
       "      <td>28661</td>\n",
       "      <td>69</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41260</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Cameron</td>\n",
       "      <td>Rupp</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>ruppc001</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>haraa001</td>\n",
       "      <td>gonzg003</td>\n",
       "      <td>28661</td>\n",
       "      <td>69</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41261</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Michael</td>\n",
       "      <td>Taylor</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>taylm002</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>haraa001</td>\n",
       "      <td>gonzg003</td>\n",
       "      <td>28661</td>\n",
       "      <td>69</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41262</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Tucker</td>\n",
       "      <td>Barnhart</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>barnt001</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>[L, L, L]</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>B</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41263</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Brennan</td>\n",
       "      <td>Boesch</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>boesb001</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>[L, L, L]</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>L</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41264</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Jay</td>\n",
       "      <td>Bruce</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>brucj001</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>L</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41265</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Ivan</td>\n",
       "      <td>De Jesus</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>dejei002</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41266</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Matt</td>\n",
       "      <td>den Dekker</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>dendm001</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>L</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41267</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Todd</td>\n",
       "      <td>Frazier</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>frazt001</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41268</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Tyler</td>\n",
       "      <td>Moore</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>moort002</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41269</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Wilson</td>\n",
       "      <td>Ramos</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>ramow001</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41270</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>Rendon</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>renda001</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41271</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Clint</td>\n",
       "      <td>Robinson</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>robic001</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>L</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41272</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Skip</td>\n",
       "      <td>Schumaker</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>schus001</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>L</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41273</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Eugenio</td>\n",
       "      <td>Suarez</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>suare001</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, R, R]</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41274</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Michael</td>\n",
       "      <td>Taylor</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>taylm002</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41275</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Trea</td>\n",
       "      <td>Turner</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>turnt001</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41276</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Dan</td>\n",
       "      <td>Uggla</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>uggld001</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>R</td>\n",
       "      <td>L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41277</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Joey</td>\n",
       "      <td>Votto</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>vottj001</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>finnb001</td>\n",
       "      <td>schem001</td>\n",
       "      <td>24420</td>\n",
       "      <td>80</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>L</td>\n",
       "      <td>R</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>41278 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        game_date first_name_tx last_name_tx       game_id    bat_id  \\\n",
       "0      2015-04-10         Erick        Aybar  ANA201504100  aybae001   \n",
       "1      2015-04-10       Lorenzo         Cain  ANA201504100  cainl001   \n",
       "2      2015-04-10          Kole      Calhoun  ANA201504100  calhk001   \n",
       "3      2015-04-10        Collin      Cowgill  ANA201504100  cowgc001   \n",
       "4      2015-04-10          C.J.         Cron  ANA201504100  cronc002   \n",
       "5      2015-04-10       Alcides      Escobar  ANA201504100  escoa003   \n",
       "6      2015-04-10         David       Freese  ANA201504100  freed001   \n",
       "7      2015-04-10        Johnny   Giavotella  ANA201504100  giavj001   \n",
       "8      2015-04-10          Alex       Gordon  ANA201504100  gorda001   \n",
       "9      2015-04-10          Eric       Hosmer  ANA201504100  hosme001   \n",
       "10     2015-04-10         Chris     Iannetta  ANA201504100  iannc001   \n",
       "11     2015-04-10          Omar      Infante  ANA201504100  infao001   \n",
       "12     2015-04-10       Kendrys      Morales  ANA201504100  morak001   \n",
       "13     2015-04-10          Mike    Moustakas  ANA201504100  mousm001   \n",
       "14     2015-04-10      Salvador        Perez  ANA201504100  peres002   \n",
       "15     2015-04-10        Albert       Pujols  ANA201504100  pujoa001   \n",
       "16     2015-04-10          Alex         Rios  ANA201504100  riosa002   \n",
       "17     2015-04-10          Mike        Trout  ANA201504100  troum001   \n",
       "18     2015-04-11         Erick        Aybar  ANA201504110  aybae001   \n",
       "19     2015-04-11          Drew       Butera  ANA201504110  buted001   \n",
       "20     2015-04-11       Lorenzo         Cain  ANA201504110  cainl001   \n",
       "21     2015-04-11          Kole      Calhoun  ANA201504110  calhk001   \n",
       "22     2015-04-11       Alcides      Escobar  ANA201504110  escoa003   \n",
       "23     2015-04-11         David       Freese  ANA201504110  freed001   \n",
       "24     2015-04-11        Johnny   Giavotella  ANA201504110  giavj001   \n",
       "25     2015-04-11          Alex       Gordon  ANA201504110  gorda001   \n",
       "26     2015-04-11          Eric       Hosmer  ANA201504110  hosme001   \n",
       "27     2015-04-11          Omar      Infante  ANA201504110  infao001   \n",
       "28     2015-04-11       Matthew        Joyce  ANA201504110  joycm001   \n",
       "29     2015-04-11       Kendrys      Morales  ANA201504110  morak001   \n",
       "...           ...           ...          ...           ...       ...   \n",
       "41248  2015-09-27        Andres       Blanco  WAS201509270  blana001   \n",
       "41249  2015-09-27          Matt   den Dekker  WAS201509270  dendm001   \n",
       "41250  2015-09-27           Ian      Desmond  WAS201509270  desmi001   \n",
       "41251  2015-09-27         Yunel      Escobar  WAS201509270  escoy001   \n",
       "41252  2015-09-27          Jeff    Francoeur  WAS201509270  franj004   \n",
       "41253  2015-09-27        Freddy       Galvis  WAS201509270  galvf001   \n",
       "41254  2015-09-27         Bryce       Harper  WAS201509270  harpb003   \n",
       "41255  2015-09-27          Erik        Kratz  WAS201509270  krate001   \n",
       "41256  2015-09-27          Jose      Lobaton  WAS201509270  lobaj001   \n",
       "41257  2015-09-27       Anthony       Rendon  WAS201509270  renda001   \n",
       "41258  2015-09-27         Clint     Robinson  WAS201509270  robic001   \n",
       "41259  2015-09-27         Darin          Ruf  WAS201509270  ruf-d001   \n",
       "41260  2015-09-27       Cameron         Rupp  WAS201509270  ruppc001   \n",
       "41261  2015-09-27       Michael       Taylor  WAS201509270  taylm002   \n",
       "41262  2015-09-28        Tucker     Barnhart  WAS201509280  barnt001   \n",
       "41263  2015-09-28       Brennan       Boesch  WAS201509280  boesb001   \n",
       "41264  2015-09-28           Jay        Bruce  WAS201509280  brucj001   \n",
       "41265  2015-09-28          Ivan     De Jesus  WAS201509280  dejei002   \n",
       "41266  2015-09-28          Matt   den Dekker  WAS201509280  dendm001   \n",
       "41267  2015-09-28          Todd      Frazier  WAS201509280  frazt001   \n",
       "41268  2015-09-28         Tyler        Moore  WAS201509280  moort002   \n",
       "41269  2015-09-28        Wilson        Ramos  WAS201509280  ramow001   \n",
       "41270  2015-09-28       Anthony       Rendon  WAS201509280  renda001   \n",
       "41271  2015-09-28         Clint     Robinson  WAS201509280  robic001   \n",
       "41272  2015-09-28          Skip    Schumaker  WAS201509280  schus001   \n",
       "41273  2015-09-28       Eugenio       Suarez  WAS201509280  suare001   \n",
       "41274  2015-09-28       Michael       Taylor  WAS201509280  taylm002   \n",
       "41275  2015-09-28          Trea       Turner  WAS201509280  turnt001   \n",
       "41276  2015-09-28           Dan        Uggla  WAS201509280  uggld001   \n",
       "41277  2015-09-28          Joey        Votto  WAS201509280  vottj001   \n",
       "\n",
       "      bat_home_id bat_lineup_id           array_agg  count best_hit  \\\n",
       "0               1             6        [R, L, R, L]      4        0   \n",
       "1               0             3     [R, R, R, R, R]      5        2   \n",
       "2               1             1        [L, L, L, L]      4        2   \n",
       "3               1             8              [R, R]      2        1   \n",
       "4               1             5        [R, R, R, R]      4        0   \n",
       "5               0             1     [R, R, R, R, R]      5        1   \n",
       "6               1             4        [R, R, R, R]      4        4   \n",
       "7               1             9           [R, R, R]      3        0   \n",
       "8               0             6        [L, L, L, L]      4        0   \n",
       "9               0             4     [L, L, L, L, L]      5        1   \n",
       "10              1             7        [R, R, R, R]      4        0   \n",
       "11              0             9        [R, R, R, R]      4        1   \n",
       "12              0             5     [R, R, R, R, R]      5        4   \n",
       "13              0             2     [L, L, L, L, L]      5        1   \n",
       "14              0             8        [R, R, R, R]      4        1   \n",
       "15              1             3        [R, R, R, R]      4        0   \n",
       "16              0             7        [R, R, R, R]      4        0   \n",
       "17              1             2        [R, R, R, R]      4        1   \n",
       "18              1             6        [L, L, L, L]      4        1   \n",
       "19              1             8              [R, R]      2        1   \n",
       "20              0             3     [R, R, R, R, R]      5        1   \n",
       "21              1             1        [L, L, L, L]      4        4   \n",
       "22              0             1     [R, R, R, R, R]      5        1   \n",
       "23              1             5        [R, R, R, R]      4        0   \n",
       "24              1             9           [R, R, R]      3        0   \n",
       "25              0             6     [L, L, L, L, L]      5        0   \n",
       "26              0             4     [L, L, L, L, L]      5        1   \n",
       "27              0             9        [R, R, R, R]      4        1   \n",
       "28              1             4        [L, L, L, L]      4        0   \n",
       "29              0             5     [R, R, L, L, L]      5        2   \n",
       "...           ...           ...                 ...    ...      ...   \n",
       "41248           0             2  [L, R, R, R, R, L]      6        4   \n",
       "41249           1             7        [L, L, L, L]      4        4   \n",
       "41250           1             6           [R, R, R]      3        4   \n",
       "41251           1             4        [R, R, R, R]      4        0   \n",
       "41252           0             5     [R, R, R, R, R]      5        4   \n",
       "41253           0             1  [R, L, R, R, L, R]      6        1   \n",
       "41254           1             3        [L, L, L, L]      4        0   \n",
       "41255           0             6        [R, R, R, R]      4        1   \n",
       "41256           1             8        [L, L, L, L]      4        2   \n",
       "41257           1             2        [R, R, R, R]      4        0   \n",
       "41258           1             5        [L, L, L, L]      4        0   \n",
       "41259           0             4     [R, R, R, R, R]      5        0   \n",
       "41260           0             8     [R, R, R, R, R]      5        1   \n",
       "41261           1             1        [R, R, R, R]      4        0   \n",
       "41262           0             8           [L, L, L]      3        1   \n",
       "41263           0             7           [L, L, L]      3        0   \n",
       "41264           0             5        [L, L, L, L]      4        0   \n",
       "41265           0             2        [R, R, R, R]      4        0   \n",
       "41266           1             7        [L, L, L, L]      4        4   \n",
       "41267           0             4        [R, R, R, R]      4        0   \n",
       "41268           1             6        [R, R, R, R]      4        1   \n",
       "41269           1             5        [R, R, R, R]      4        4   \n",
       "41270           1             3        [R, R, R, R]      4        2   \n",
       "41271           1             4        [L, L, L, L]      4        1   \n",
       "41272           0             1        [L, L, L, L]      4        1   \n",
       "41273           0             6           [R, R, R]      3        0   \n",
       "41274           1             1     [R, R, R, R, R]      5        1   \n",
       "41275           1             2        [R, R, R, R]      4        1   \n",
       "41276           1             8        [R, R, R, R]      4        0   \n",
       "41277           0             3        [L, L, L, L]      4        1   \n",
       "\n",
       "          ...      away_start_pit_id  home_start_pit_id  attend_park_ct  \\\n",
       "0         ...               vargj001           santh001           44489   \n",
       "1         ...               vargj001           santh001           44489   \n",
       "2         ...               vargj001           santh001           44489   \n",
       "3         ...               vargj001           santh001           44489   \n",
       "4         ...               vargj001           santh001           44489   \n",
       "5         ...               vargj001           santh001           44489   \n",
       "6         ...               vargj001           santh001           44489   \n",
       "7         ...               vargj001           santh001           44489   \n",
       "8         ...               vargj001           santh001           44489   \n",
       "9         ...               vargj001           santh001           44489   \n",
       "10        ...               vargj001           santh001           44489   \n",
       "11        ...               vargj001           santh001           44489   \n",
       "12        ...               vargj001           santh001           44489   \n",
       "13        ...               vargj001           santh001           44489   \n",
       "14        ...               vargj001           santh001           44489   \n",
       "15        ...               vargj001           santh001           44489   \n",
       "16        ...               vargj001           santh001           44489   \n",
       "17        ...               vargj001           santh001           44489   \n",
       "18        ...               guthj001           weavj003           44154   \n",
       "19        ...               guthj001           weavj003           44154   \n",
       "20        ...               guthj001           weavj003           44154   \n",
       "21        ...               guthj001           weavj003           44154   \n",
       "22        ...               guthj001           weavj003           44154   \n",
       "23        ...               guthj001           weavj003           44154   \n",
       "24        ...               guthj001           weavj003           44154   \n",
       "25        ...               guthj001           weavj003           44154   \n",
       "26        ...               guthj001           weavj003           44154   \n",
       "27        ...               guthj001           weavj003           44154   \n",
       "28        ...               guthj001           weavj003           44154   \n",
       "29        ...               guthj001           weavj003           44154   \n",
       "...       ...                    ...                ...             ...   \n",
       "41248     ...               haraa001           gonzg003           28661   \n",
       "41249     ...               haraa001           gonzg003           28661   \n",
       "41250     ...               haraa001           gonzg003           28661   \n",
       "41251     ...               haraa001           gonzg003           28661   \n",
       "41252     ...               haraa001           gonzg003           28661   \n",
       "41253     ...               haraa001           gonzg003           28661   \n",
       "41254     ...               haraa001           gonzg003           28661   \n",
       "41255     ...               haraa001           gonzg003           28661   \n",
       "41256     ...               haraa001           gonzg003           28661   \n",
       "41257     ...               haraa001           gonzg003           28661   \n",
       "41258     ...               haraa001           gonzg003           28661   \n",
       "41259     ...               haraa001           gonzg003           28661   \n",
       "41260     ...               haraa001           gonzg003           28661   \n",
       "41261     ...               haraa001           gonzg003           28661   \n",
       "41262     ...               finnb001           schem001           24420   \n",
       "41263     ...               finnb001           schem001           24420   \n",
       "41264     ...               finnb001           schem001           24420   \n",
       "41265     ...               finnb001           schem001           24420   \n",
       "41266     ...               finnb001           schem001           24420   \n",
       "41267     ...               finnb001           schem001           24420   \n",
       "41268     ...               finnb001           schem001           24420   \n",
       "41269     ...               finnb001           schem001           24420   \n",
       "41270     ...               finnb001           schem001           24420   \n",
       "41271     ...               finnb001           schem001           24420   \n",
       "41272     ...               finnb001           schem001           24420   \n",
       "41273     ...               finnb001           schem001           24420   \n",
       "41274     ...               finnb001           schem001           24420   \n",
       "41275     ...               finnb001           schem001           24420   \n",
       "41276     ...               finnb001           schem001           24420   \n",
       "41277     ...               finnb001           schem001           24420   \n",
       "\n",
       "       temp_park_ct  wind_speed_park_ct field_park_cd precip_park_cd  \\\n",
       "0                67                   7             0              0   \n",
       "1                67                   7             0              0   \n",
       "2                67                   7             0              0   \n",
       "3                67                   7             0              0   \n",
       "4                67                   7             0              0   \n",
       "5                67                   7             0              0   \n",
       "6                67                   7             0              0   \n",
       "7                67                   7             0              0   \n",
       "8                67                   7             0              0   \n",
       "9                67                   7             0              0   \n",
       "10               67                   7             0              0   \n",
       "11               67                   7             0              0   \n",
       "12               67                   7             0              0   \n",
       "13               67                   7             0              0   \n",
       "14               67                   7             0              0   \n",
       "15               67                   7             0              0   \n",
       "16               67                   7             0              0   \n",
       "17               67                   7             0              0   \n",
       "18               68                   6             0              0   \n",
       "19               68                   6             0              0   \n",
       "20               68                   6             0              0   \n",
       "21               68                   6             0              0   \n",
       "22               68                   6             0              0   \n",
       "23               68                   6             0              0   \n",
       "24               68                   6             0              0   \n",
       "25               68                   6             0              0   \n",
       "26               68                   6             0              0   \n",
       "27               68                   6             0              0   \n",
       "28               68                   6             0              0   \n",
       "29               68                   6             0              0   \n",
       "...             ...                 ...           ...            ...   \n",
       "41248            69                   6             0              0   \n",
       "41249            69                   6             0              0   \n",
       "41250            69                   6             0              0   \n",
       "41251            69                   6             0              0   \n",
       "41252            69                   6             0              0   \n",
       "41253            69                   6             0              0   \n",
       "41254            69                   6             0              0   \n",
       "41255            69                   6             0              0   \n",
       "41256            69                   6             0              0   \n",
       "41257            69                   6             0              0   \n",
       "41258            69                   6             0              0   \n",
       "41259            69                   6             0              0   \n",
       "41260            69                   6             0              0   \n",
       "41261            69                   6             0              0   \n",
       "41262            80                   2             0              0   \n",
       "41263            80                   2             0              0   \n",
       "41264            80                   2             0              0   \n",
       "41265            80                   2             0              0   \n",
       "41266            80                   2             0              0   \n",
       "41267            80                   2             0              0   \n",
       "41268            80                   2             0              0   \n",
       "41269            80                   2             0              0   \n",
       "41270            80                   2             0              0   \n",
       "41271            80                   2             0              0   \n",
       "41272            80                   2             0              0   \n",
       "41273            80                   2             0              0   \n",
       "41274            80                   2             0              0   \n",
       "41275            80                   2             0              0   \n",
       "41276            80                   2             0              0   \n",
       "41277            80                   2             0              0   \n",
       "\n",
       "      sky_park_cd bat_hand pit_hand_cd  \n",
       "0               2        B           L  \n",
       "1               2        R           L  \n",
       "2               2        L           L  \n",
       "3               2        R           L  \n",
       "4               2        R           L  \n",
       "5               2        R           L  \n",
       "6               2        R           L  \n",
       "7               2        R           L  \n",
       "8               2        L           L  \n",
       "9               2        L           L  \n",
       "10              2        R           L  \n",
       "11              2        R           L  \n",
       "12              2        B           L  \n",
       "13              2        L           L  \n",
       "14              2        R           L  \n",
       "15              2        R           L  \n",
       "16              2        R           L  \n",
       "17              2        R           L  \n",
       "18              1        B           R  \n",
       "19              1        R           R  \n",
       "20              1        R           R  \n",
       "21              1        L           R  \n",
       "22              1        R           R  \n",
       "23              1        R           R  \n",
       "24              1        R           R  \n",
       "25              1        L           R  \n",
       "26              1        L           R  \n",
       "27              1        R           R  \n",
       "28              1        L           R  \n",
       "29              1        B           R  \n",
       "...           ...      ...         ...  \n",
       "41248           0        B           L  \n",
       "41249           0        L           R  \n",
       "41250           0        R           R  \n",
       "41251           0        R           R  \n",
       "41252           0        R           L  \n",
       "41253           0        B           L  \n",
       "41254           0        L           R  \n",
       "41255           0        R           L  \n",
       "41256           0        B           R  \n",
       "41257           0        R           R  \n",
       "41258           0        L           R  \n",
       "41259           0        R           L  \n",
       "41260           0        R           L  \n",
       "41261           0        R           R  \n",
       "41262           0        B           R  \n",
       "41263           0        L           R  \n",
       "41264           0        L           R  \n",
       "41265           0        R           R  \n",
       "41266           0        L           L  \n",
       "41267           0        R           R  \n",
       "41268           0        R           L  \n",
       "41269           0        R           L  \n",
       "41270           0        R           L  \n",
       "41271           0        L           L  \n",
       "41272           0        L           R  \n",
       "41273           0        R           R  \n",
       "41274           0        R           L  \n",
       "41275           0        R           L  \n",
       "41276           0        R           L  \n",
       "41277           0        L           R  \n",
       "\n",
       "[41278 rows x 32 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "sql = '''\n",
    "select distinct on (game_id, choices.bat_id)\n",
    "    game_date,\n",
    "    batter.first_name_tx,\n",
    "    batter.last_name_tx,\n",
    "    choices.*,\n",
    "    BAT_HOME_ID as batter_home,\n",
    "    case BAT_HOME_ID when '0' then HOME_START_PIT_ID else AWAY_START_PIT_ID end as opposing_pitcher_id,\n",
    "    case BAT_HOME_ID when '1' then HOME_TEAM_ID else AWAY_TEAM_ID end as team_id,\n",
    "    case BAT_HOME_ID when '0' then HOME_TEAM_ID else AWAY_TEAM_ID end as opposing_team_id,\n",
    "    DH_FL,\n",
    "    DAYNIGHT_PARK_CD,\n",
    "    PARK_ID,\n",
    "    AWAY_START_PIT_ID,\n",
    "    HOME_START_PIT_ID,\n",
    "    ATTEND_PARK_CT,\n",
    "    TEMP_PARK_CT,\n",
    "    WIND_SPEED_PARK_CT,\n",
    "    FIELD_PARK_CD,\n",
    "    PRECIP_PARK_CD,\n",
    "    SKY_PARK_CD,\n",
    "    batter.bat_hand_cd as bat_hand,\n",
    "    opposing_pitcher.pit_hand_cd\n",
    "from choices \n",
    "    inner join vw_games using (game_id)\n",
    "    inner join rosters as batter on (choices.bat_id = batter.player_id)\n",
    "    inner join rosters as opposing_pitcher on ((case BAT_HOME_ID when '0' then HOME_START_PIT_ID else AWAY_START_PIT_ID end) = opposing_pitcher.player_id)\n",
    "'''\n",
    "\n",
    "choices = pd.read_sql(sql, con)\n",
    "choices"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "def calculate_previous_batter_games(frame):\n",
    "    game_date = frame['game_date']\n",
    "    player_id = frame['bat_id']\n",
    "    \n",
    "    sql = '''\n",
    "    select event_cd,count(*) from vw_events \n",
    "        where BAT_EVENT_FL='T' and bat_id='{}' and game_date < '{}' \n",
    "        group by event_cd\n",
    "    '''.format(player_id, game_date)\n",
    "    \n",
    "    games = pd.read_sql(sql, con)\n",
    "    return games.set_index(games.event_cd)['count'].add_prefix('previous_batter_')\n",
    "\n",
    "def calculate_previous_pitcher_games(frame):\n",
    "    game_date = frame['game_date']\n",
    "    player_id = frame['opposing_pitcher_id']\n",
    "    \n",
    "    sql = '''\n",
    "    select event_cd,count(*) from vw_events \n",
    "        where BAT_EVENT_FL='T' and pit_id='{}' and game_date < '{}' \n",
    "        group by event_cd\n",
    "    '''.format(player_id, game_date)\n",
    "    \n",
    "    games = pd.read_sql(sql, con)\n",
    "    return games.set_index(games.event_cd)['count'].add_prefix('previous_pitcher_')\n",
    "\n",
    "def calculate_pitcher_against_hand(frame):\n",
    "    bat_hand_cd = frame['bat_hand']\n",
    "    game_date = frame['game_date']\n",
    "    player_id = frame['opposing_pitcher_id']\n",
    "\n",
    "    sql = '''\n",
    "    select event_cd,count(*) from vw_events \n",
    "        inner join rosters on (rosters.bat_hand_cd = '{}' and rosters.player_id = vw_events.bat_id)\n",
    "        where BAT_EVENT_FL='T' and pit_id='{}' and game_date < '{}'\n",
    "        group by event_cd\n",
    "\n",
    "    '''.format(bat_hand_cd, player_id, game_date)\n",
    "\n",
    "    games = pd.read_sql(sql, con)\n",
    "    return games.set_index(games.event_cd)['count'].add_prefix('pitcher_against_hand_')\n",
    "    \n",
    "def calculate_batter_against_hand(frame):\n",
    "    pit_hand_cd = frame['pit_hand_cd']\n",
    "    game_date = frame['game_date']\n",
    "    player_id = frame['bat_id']\n",
    "\n",
    "    sql = '''\n",
    "    select event_cd,count(*) from vw_events \n",
    "        where BAT_EVENT_FL='T' and pit_hand_cd='{}' and bat_id='{}' and game_date < '{}' \n",
    "        group by event_cd\n",
    "    '''.format(pit_hand_cd, player_id, game_date)\n",
    "\n",
    "    games = pd.read_sql(sql, con)\n",
    "    return games.set_index(games.event_cd)['count'].add_prefix('batter_against_hand_')\n",
    "\n",
    "bull_cache = dict()\n",
    "def calculate_bullpen(frame):\n",
    "    pit_team = frame['opposing_team_id']\n",
    "    game_date = frame['game_date']\n",
    "    \n",
    "    if(bull_cache.get((pit_team, game_date), None) is not None):\n",
    "        return bull_cache.get((pit_team, game_date))\n",
    "    \n",
    "    sql = '''\n",
    "    select event_cd,count(*) from vw_events \n",
    "        where BAT_EVENT_FL='T' and game_date < '{}' and fld_team_id='{}' and PIT_START_FL='F'\n",
    "        group by event_cd\n",
    "    '''.format(game_date, pit_team)\n",
    "\n",
    "    games = pd.read_sql(sql, con)\n",
    "    result = games.set_index(games.event_cd)['count'].add_prefix('bullpen_')\n",
    "    bull_cache[(pit_team, game_date)] = result\n",
    "    \n",
    "    return result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>game_date</th>\n",
       "      <th>first_name_tx</th>\n",
       "      <th>last_name_tx</th>\n",
       "      <th>game_id</th>\n",
       "      <th>bat_id</th>\n",
       "      <th>bat_home_id</th>\n",
       "      <th>bat_lineup_id</th>\n",
       "      <th>array_agg</th>\n",
       "      <th>count</th>\n",
       "      <th>best_hit</th>\n",
       "      <th>...</th>\n",
       "      <th>batter_against_hand_16</th>\n",
       "      <th>batter_against_hand_17</th>\n",
       "      <th>batter_against_hand_18</th>\n",
       "      <th>batter_against_hand_19</th>\n",
       "      <th>batter_against_hand_2</th>\n",
       "      <th>batter_against_hand_20</th>\n",
       "      <th>batter_against_hand_21</th>\n",
       "      <th>batter_against_hand_22</th>\n",
       "      <th>batter_against_hand_23</th>\n",
       "      <th>batter_against_hand_3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Erick</td>\n",
       "      <td>Aybar</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>aybae001</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, L, R, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Lorenzo</td>\n",
       "      <td>Cain</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>cainl001</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Kole</td>\n",
       "      <td>Calhoun</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>calhk001</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Collin</td>\n",
       "      <td>Cowgill</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>cowgc001</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R]</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>C.J.</td>\n",
       "      <td>Cron</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>cronc002</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Alcides</td>\n",
       "      <td>Escobar</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>escoa003</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>David</td>\n",
       "      <td>Freese</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>freed001</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Johnny</td>\n",
       "      <td>Giavotella</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>giavj001</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>[R, R, R]</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Gordon</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>gorda001</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Eric</td>\n",
       "      <td>Hosmer</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>hosme001</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>[L, L, L, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Chris</td>\n",
       "      <td>Iannetta</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>iannc001</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Omar</td>\n",
       "      <td>Infante</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>infao001</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Kendrys</td>\n",
       "      <td>Morales</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>morak001</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Mike</td>\n",
       "      <td>Moustakas</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>mousm001</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>[L, L, L, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Salvador</td>\n",
       "      <td>Perez</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>peres002</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Albert</td>\n",
       "      <td>Pujols</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>pujoa001</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Rios</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>riosa002</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2015-04-10</td>\n",
       "      <td>Mike</td>\n",
       "      <td>Trout</td>\n",
       "      <td>ANA201504100</td>\n",
       "      <td>troum001</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Erick</td>\n",
       "      <td>Aybar</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>aybae001</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Drew</td>\n",
       "      <td>Butera</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>buted001</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R]</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Lorenzo</td>\n",
       "      <td>Cain</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>cainl001</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Kole</td>\n",
       "      <td>Calhoun</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>calhk001</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Alcides</td>\n",
       "      <td>Escobar</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>escoa003</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>David</td>\n",
       "      <td>Freese</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>freed001</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Johnny</td>\n",
       "      <td>Giavotella</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>giavj001</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>[R, R, R]</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Gordon</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>gorda001</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>[L, L, L, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Eric</td>\n",
       "      <td>Hosmer</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>hosme001</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>[L, L, L, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Omar</td>\n",
       "      <td>Infante</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>infao001</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Matthew</td>\n",
       "      <td>Joyce</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>joycm001</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2015-04-11</td>\n",
       "      <td>Kendrys</td>\n",
       "      <td>Morales</td>\n",
       "      <td>ANA201504110</td>\n",
       "      <td>morak001</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, L, L, L]</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</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>41248</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Andres</td>\n",
       "      <td>Blanco</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>blana001</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>[L, R, R, R, R, L]</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41249</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Matt</td>\n",
       "      <td>den Dekker</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>dendm001</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41250</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Ian</td>\n",
       "      <td>Desmond</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>desmi001</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, R, R]</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>197.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>148.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41251</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Yunel</td>\n",
       "      <td>Escobar</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>escoy001</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>218.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>49.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41252</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Jeff</td>\n",
       "      <td>Francoeur</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>franj004</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41253</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Freddy</td>\n",
       "      <td>Galvis</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>galvf001</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, L, R, R, L, R]</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>80.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41254</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Bryce</td>\n",
       "      <td>Harper</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>harpb003</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>134.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>93.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41255</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Erik</td>\n",
       "      <td>Kratz</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>krate001</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41256</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Jose</td>\n",
       "      <td>Lobaton</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>lobaj001</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>54.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41257</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>Rendon</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>renda001</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>51.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41258</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Clint</td>\n",
       "      <td>Robinson</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>robic001</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>40.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41259</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Darin</td>\n",
       "      <td>Ruf</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>ruf-d001</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41260</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Cameron</td>\n",
       "      <td>Rupp</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>ruppc001</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41261</th>\n",
       "      <td>2015-09-27</td>\n",
       "      <td>Michael</td>\n",
       "      <td>Taylor</td>\n",
       "      <td>WAS201509270</td>\n",
       "      <td>taylm002</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>118.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41262</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Tucker</td>\n",
       "      <td>Barnhart</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>barnt001</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>[L, L, L]</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>102.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41263</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Brennan</td>\n",
       "      <td>Boesch</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>boesb001</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>[L, L, L]</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41264</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Jay</td>\n",
       "      <td>Bruce</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>brucj001</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>212.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>98.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41265</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Ivan</td>\n",
       "      <td>De Jesus</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>dejei002</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>63.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>36.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41266</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Matt</td>\n",
       "      <td>den Dekker</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>dendm001</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41267</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Todd</td>\n",
       "      <td>Frazier</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>frazt001</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>243.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>93.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41268</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Tyler</td>\n",
       "      <td>Moore</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>moort002</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41269</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Wilson</td>\n",
       "      <td>Ramos</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>ramow001</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41270</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>Rendon</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>renda001</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41271</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Clint</td>\n",
       "      <td>Robinson</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>robic001</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41272</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Skip</td>\n",
       "      <td>Schumaker</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>schus001</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>117.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41273</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Eugenio</td>\n",
       "      <td>Suarez</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>suare001</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>[R, R, R]</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>132.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>66.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41274</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Michael</td>\n",
       "      <td>Taylor</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>taylm002</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[R, R, R, R, R]</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41275</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Trea</td>\n",
       "      <td>Turner</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>turnt001</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41276</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Dan</td>\n",
       "      <td>Uggla</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>uggld001</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>[R, R, R, R]</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41277</th>\n",
       "      <td>2015-09-28</td>\n",
       "      <td>Joey</td>\n",
       "      <td>Votto</td>\n",
       "      <td>WAS201509280</td>\n",
       "      <td>vottj001</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>[L, L, L, L]</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>159.0</td>\n",
       "      <td>71.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>41278 rows × 80 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        game_date first_name_tx last_name_tx       game_id    bat_id  \\\n",
       "0      2015-04-10         Erick        Aybar  ANA201504100  aybae001   \n",
       "1      2015-04-10       Lorenzo         Cain  ANA201504100  cainl001   \n",
       "2      2015-04-10          Kole      Calhoun  ANA201504100  calhk001   \n",
       "3      2015-04-10        Collin      Cowgill  ANA201504100  cowgc001   \n",
       "4      2015-04-10          C.J.         Cron  ANA201504100  cronc002   \n",
       "5      2015-04-10       Alcides      Escobar  ANA201504100  escoa003   \n",
       "6      2015-04-10         David       Freese  ANA201504100  freed001   \n",
       "7      2015-04-10        Johnny   Giavotella  ANA201504100  giavj001   \n",
       "8      2015-04-10          Alex       Gordon  ANA201504100  gorda001   \n",
       "9      2015-04-10          Eric       Hosmer  ANA201504100  hosme001   \n",
       "10     2015-04-10         Chris     Iannetta  ANA201504100  iannc001   \n",
       "11     2015-04-10          Omar      Infante  ANA201504100  infao001   \n",
       "12     2015-04-10       Kendrys      Morales  ANA201504100  morak001   \n",
       "13     2015-04-10          Mike    Moustakas  ANA201504100  mousm001   \n",
       "14     2015-04-10      Salvador        Perez  ANA201504100  peres002   \n",
       "15     2015-04-10        Albert       Pujols  ANA201504100  pujoa001   \n",
       "16     2015-04-10          Alex         Rios  ANA201504100  riosa002   \n",
       "17     2015-04-10          Mike        Trout  ANA201504100  troum001   \n",
       "18     2015-04-11         Erick        Aybar  ANA201504110  aybae001   \n",
       "19     2015-04-11          Drew       Butera  ANA201504110  buted001   \n",
       "20     2015-04-11       Lorenzo         Cain  ANA201504110  cainl001   \n",
       "21     2015-04-11          Kole      Calhoun  ANA201504110  calhk001   \n",
       "22     2015-04-11       Alcides      Escobar  ANA201504110  escoa003   \n",
       "23     2015-04-11         David       Freese  ANA201504110  freed001   \n",
       "24     2015-04-11        Johnny   Giavotella  ANA201504110  giavj001   \n",
       "25     2015-04-11          Alex       Gordon  ANA201504110  gorda001   \n",
       "26     2015-04-11          Eric       Hosmer  ANA201504110  hosme001   \n",
       "27     2015-04-11          Omar      Infante  ANA201504110  infao001   \n",
       "28     2015-04-11       Matthew        Joyce  ANA201504110  joycm001   \n",
       "29     2015-04-11       Kendrys      Morales  ANA201504110  morak001   \n",
       "...           ...           ...          ...           ...       ...   \n",
       "41248  2015-09-27        Andres       Blanco  WAS201509270  blana001   \n",
       "41249  2015-09-27          Matt   den Dekker  WAS201509270  dendm001   \n",
       "41250  2015-09-27           Ian      Desmond  WAS201509270  desmi001   \n",
       "41251  2015-09-27         Yunel      Escobar  WAS201509270  escoy001   \n",
       "41252  2015-09-27          Jeff    Francoeur  WAS201509270  franj004   \n",
       "41253  2015-09-27        Freddy       Galvis  WAS201509270  galvf001   \n",
       "41254  2015-09-27         Bryce       Harper  WAS201509270  harpb003   \n",
       "41255  2015-09-27          Erik        Kratz  WAS201509270  krate001   \n",
       "41256  2015-09-27          Jose      Lobaton  WAS201509270  lobaj001   \n",
       "41257  2015-09-27       Anthony       Rendon  WAS201509270  renda001   \n",
       "41258  2015-09-27         Clint     Robinson  WAS201509270  robic001   \n",
       "41259  2015-09-27         Darin          Ruf  WAS201509270  ruf-d001   \n",
       "41260  2015-09-27       Cameron         Rupp  WAS201509270  ruppc001   \n",
       "41261  2015-09-27       Michael       Taylor  WAS201509270  taylm002   \n",
       "41262  2015-09-28        Tucker     Barnhart  WAS201509280  barnt001   \n",
       "41263  2015-09-28       Brennan       Boesch  WAS201509280  boesb001   \n",
       "41264  2015-09-28           Jay        Bruce  WAS201509280  brucj001   \n",
       "41265  2015-09-28          Ivan     De Jesus  WAS201509280  dejei002   \n",
       "41266  2015-09-28          Matt   den Dekker  WAS201509280  dendm001   \n",
       "41267  2015-09-28          Todd      Frazier  WAS201509280  frazt001   \n",
       "41268  2015-09-28         Tyler        Moore  WAS201509280  moort002   \n",
       "41269  2015-09-28        Wilson        Ramos  WAS201509280  ramow001   \n",
       "41270  2015-09-28       Anthony       Rendon  WAS201509280  renda001   \n",
       "41271  2015-09-28         Clint     Robinson  WAS201509280  robic001   \n",
       "41272  2015-09-28          Skip    Schumaker  WAS201509280  schus001   \n",
       "41273  2015-09-28       Eugenio       Suarez  WAS201509280  suare001   \n",
       "41274  2015-09-28       Michael       Taylor  WAS201509280  taylm002   \n",
       "41275  2015-09-28          Trea       Turner  WAS201509280  turnt001   \n",
       "41276  2015-09-28           Dan        Uggla  WAS201509280  uggld001   \n",
       "41277  2015-09-28          Joey        Votto  WAS201509280  vottj001   \n",
       "\n",
       "      bat_home_id bat_lineup_id           array_agg  count best_hit  \\\n",
       "0               1             6        [R, L, R, L]      4        0   \n",
       "1               0             3     [R, R, R, R, R]      5        2   \n",
       "2               1             1        [L, L, L, L]      4        2   \n",
       "3               1             8              [R, R]      2        1   \n",
       "4               1             5        [R, R, R, R]      4        0   \n",
       "5               0             1     [R, R, R, R, R]      5        1   \n",
       "6               1             4        [R, R, R, R]      4        4   \n",
       "7               1             9           [R, R, R]      3        0   \n",
       "8               0             6        [L, L, L, L]      4        0   \n",
       "9               0             4     [L, L, L, L, L]      5        1   \n",
       "10              1             7        [R, R, R, R]      4        0   \n",
       "11              0             9        [R, R, R, R]      4        1   \n",
       "12              0             5     [R, R, R, R, R]      5        4   \n",
       "13              0             2     [L, L, L, L, L]      5        1   \n",
       "14              0             8        [R, R, R, R]      4        1   \n",
       "15              1             3        [R, R, R, R]      4        0   \n",
       "16              0             7        [R, R, R, R]      4        0   \n",
       "17              1             2        [R, R, R, R]      4        1   \n",
       "18              1             6        [L, L, L, L]      4        1   \n",
       "19              1             8              [R, R]      2        1   \n",
       "20              0             3     [R, R, R, R, R]      5        1   \n",
       "21              1             1        [L, L, L, L]      4        4   \n",
       "22              0             1     [R, R, R, R, R]      5        1   \n",
       "23              1             5        [R, R, R, R]      4        0   \n",
       "24              1             9           [R, R, R]      3        0   \n",
       "25              0             6     [L, L, L, L, L]      5        0   \n",
       "26              0             4     [L, L, L, L, L]      5        1   \n",
       "27              0             9        [R, R, R, R]      4        1   \n",
       "28              1             4        [L, L, L, L]      4        0   \n",
       "29              0             5     [R, R, L, L, L]      5        2   \n",
       "...           ...           ...                 ...    ...      ...   \n",
       "41248           0             2  [L, R, R, R, R, L]      6        4   \n",
       "41249           1             7        [L, L, L, L]      4        4   \n",
       "41250           1             6           [R, R, R]      3        4   \n",
       "41251           1             4        [R, R, R, R]      4        0   \n",
       "41252           0             5     [R, R, R, R, R]      5        4   \n",
       "41253           0             1  [R, L, R, R, L, R]      6        1   \n",
       "41254           1             3        [L, L, L, L]      4        0   \n",
       "41255           0             6        [R, R, R, R]      4        1   \n",
       "41256           1             8        [L, L, L, L]      4        2   \n",
       "41257           1             2        [R, R, R, R]      4        0   \n",
       "41258           1             5        [L, L, L, L]      4        0   \n",
       "41259           0             4     [R, R, R, R, R]      5        0   \n",
       "41260           0             8     [R, R, R, R, R]      5        1   \n",
       "41261           1             1        [R, R, R, R]      4        0   \n",
       "41262           0             8           [L, L, L]      3        1   \n",
       "41263           0             7           [L, L, L]      3        0   \n",
       "41264           0             5        [L, L, L, L]      4        0   \n",
       "41265           0             2        [R, R, R, R]      4        0   \n",
       "41266           1             7        [L, L, L, L]      4        4   \n",
       "41267           0             4        [R, R, R, R]      4        0   \n",
       "41268           1             6        [R, R, R, R]      4        1   \n",
       "41269           1             5        [R, R, R, R]      4        4   \n",
       "41270           1             3        [R, R, R, R]      4        2   \n",
       "41271           1             4        [L, L, L, L]      4        1   \n",
       "41272           0             1        [L, L, L, L]      4        1   \n",
       "41273           0             6           [R, R, R]      3        0   \n",
       "41274           1             1     [R, R, R, R, R]      5        1   \n",
       "41275           1             2        [R, R, R, R]      4        1   \n",
       "41276           1             8        [R, R, R, R]      4        0   \n",
       "41277           0             3        [L, L, L, L]      4        1   \n",
       "\n",
       "               ...           batter_against_hand_16  batter_against_hand_17  \\\n",
       "0              ...                              NaN                     NaN   \n",
       "1              ...                              1.0                     NaN   \n",
       "2              ...                              NaN                     NaN   \n",
       "3              ...                              NaN                     NaN   \n",
       "4              ...                              NaN                     NaN   \n",
       "5              ...                              NaN                     NaN   \n",
       "6              ...                              NaN                     NaN   \n",
       "7              ...                              NaN                     NaN   \n",
       "8              ...                              NaN                     NaN   \n",
       "9              ...                              NaN                     NaN   \n",
       "10             ...                              NaN                     NaN   \n",
       "11             ...                              NaN                     NaN   \n",
       "12             ...                              NaN                     NaN   \n",
       "13             ...                              1.0                     NaN   \n",
       "14             ...                              NaN                     NaN   \n",
       "15             ...                              NaN                     NaN   \n",
       "16             ...                              NaN                     NaN   \n",
       "17             ...                              NaN                     NaN   \n",
       "18             ...                              1.0                     NaN   \n",
       "19             ...                              NaN                     NaN   \n",
       "20             ...                              1.0                     NaN   \n",
       "21             ...                              NaN                     NaN   \n",
       "22             ...                              NaN                     NaN   \n",
       "23             ...                              NaN                     NaN   \n",
       "24             ...                              NaN                     NaN   \n",
       "25             ...                              1.0                     NaN   \n",
       "26             ...                              NaN                     NaN   \n",
       "27             ...                              NaN                     NaN   \n",
       "28             ...                              NaN                     NaN   \n",
       "29             ...                              NaN                     NaN   \n",
       "...            ...                              ...                     ...   \n",
       "41248          ...                              2.0                     NaN   \n",
       "41249          ...                              NaN                     NaN   \n",
       "41250          ...                              3.0                     NaN   \n",
       "41251          ...                              8.0                     NaN   \n",
       "41252          ...                              NaN                     NaN   \n",
       "41253          ...                              NaN                     NaN   \n",
       "41254          ...                              3.0                     NaN   \n",
       "41255          ...                              NaN                     NaN   \n",
       "41256          ...                              1.0                     NaN   \n",
       "41257          ...                              4.0                     NaN   \n",
       "41258          ...                              5.0                     NaN   \n",
       "41259          ...                              2.0                     NaN   \n",
       "41260          ...                              NaN                     NaN   \n",
       "41261          ...                              1.0                     NaN   \n",
       "41262          ...                              2.0                     NaN   \n",
       "41263          ...                              1.0                     NaN   \n",
       "41264          ...                              1.0                     NaN   \n",
       "41265          ...                              1.0                     NaN   \n",
       "41266          ...                              NaN                     NaN   \n",
       "41267          ...                              7.0                     NaN   \n",
       "41268          ...                              1.0                     NaN   \n",
       "41269          ...                              NaN                     NaN   \n",
       "41270          ...                              NaN                     NaN   \n",
       "41271          ...                              NaN                     NaN   \n",
       "41272          ...                              NaN                     NaN   \n",
       "41273          ...                              3.0                     NaN   \n",
       "41274          ...                              NaN                     NaN   \n",
       "41275          ...                              NaN                     NaN   \n",
       "41276          ...                              NaN                     NaN   \n",
       "41277          ...                              3.0                     NaN   \n",
       "\n",
       "       batter_against_hand_18  batter_against_hand_19  batter_against_hand_2  \\\n",
       "0                         NaN                     NaN                    2.0   \n",
       "1                         NaN                     NaN                    4.0   \n",
       "2                         NaN                     NaN                    2.0   \n",
       "3                         NaN                     NaN                    2.0   \n",
       "4                         NaN                     NaN                    2.0   \n",
       "5                         NaN                     NaN                    4.0   \n",
       "6                         NaN                     NaN                    1.0   \n",
       "7                         NaN                     NaN                    1.0   \n",
       "8                         NaN                     NaN                    1.0   \n",
       "9                         NaN                     NaN                    3.0   \n",
       "10                        NaN                     NaN                    1.0   \n",
       "11                        NaN                     NaN                    3.0   \n",
       "12                        NaN                     NaN                    4.0   \n",
       "13                        NaN                     1.0                    3.0   \n",
       "14                        NaN                     NaN                    4.0   \n",
       "15                        NaN                     NaN                    2.0   \n",
       "16                        NaN                     NaN                    4.0   \n",
       "17                        NaN                     NaN                    2.0   \n",
       "18                        1.0                     NaN                    4.0   \n",
       "19                        NaN                     NaN                    NaN   \n",
       "20                        NaN                     NaN                    3.0   \n",
       "21                        NaN                     NaN                    6.0   \n",
       "22                        NaN                     NaN                    5.0   \n",
       "23                        NaN                     NaN                    5.0   \n",
       "24                        NaN                     NaN                    3.0   \n",
       "25                        NaN                     NaN                    2.0   \n",
       "26                        NaN                     NaN                    4.0   \n",
       "27                        1.0                     NaN                    5.0   \n",
       "28                        NaN                     NaN                    5.0   \n",
       "29                        NaN                     NaN                    2.0   \n",
       "...                       ...                     ...                    ...   \n",
       "41248                     1.0                     NaN                   38.0   \n",
       "41249                     NaN                     NaN                   40.0   \n",
       "41250                     7.0                     3.0                  197.0   \n",
       "41251                     6.0                     2.0                  218.0   \n",
       "41252                     3.0                     NaN                   60.0   \n",
       "41253                     1.0                     NaN                   80.0   \n",
       "41254                     1.0                     NaN                  134.0   \n",
       "41255                     NaN                     NaN                    5.0   \n",
       "41256                     2.0                     NaN                   54.0   \n",
       "41257                     1.0                     1.0                  118.0   \n",
       "41258                     3.0                     1.0                  143.0   \n",
       "41259                     NaN                     NaN                   42.0   \n",
       "41260                     2.0                     1.0                   23.0   \n",
       "41261                     5.0                     2.0                  147.0   \n",
       "41262                     3.0                     NaN                  102.0   \n",
       "41263                     NaN                     NaN                   42.0   \n",
       "41264                     2.0                     NaN                  212.0   \n",
       "41265                     2.0                     NaN                   63.0   \n",
       "41266                     NaN                     NaN                   10.0   \n",
       "41267                     3.0                     2.0                  243.0   \n",
       "41268                     1.0                     1.0                   27.0   \n",
       "41269                     NaN                     NaN                   65.0   \n",
       "41270                     NaN                     NaN                   32.0   \n",
       "41271                     NaN                     NaN                    9.0   \n",
       "41272                     1.0                     1.0                  117.0   \n",
       "41273                     3.0                     NaN                  132.0   \n",
       "41274                     NaN                     NaN                   43.0   \n",
       "41275                     NaN                     NaN                    3.0   \n",
       "41276                     1.0                     NaN                   13.0   \n",
       "41277                     1.0                     1.0                  159.0   \n",
       "\n",
       "      batter_against_hand_20 batter_against_hand_21 batter_against_hand_22  \\\n",
       "0                        1.0                    NaN                    NaN   \n",
       "1                        1.0                    1.0                    NaN   \n",
       "2                        1.0                    NaN                    NaN   \n",
       "3                        NaN                    NaN                    NaN   \n",
       "4                        NaN                    NaN                    NaN   \n",
       "5                        1.0                    1.0                    NaN   \n",
       "6                        NaN                    NaN                    NaN   \n",
       "7                        1.0                    NaN                    NaN   \n",
       "8                        1.0                    NaN                    NaN   \n",
       "9                        2.0                    NaN                    NaN   \n",
       "10                       NaN                    NaN                    NaN   \n",
       "11                       1.0                    NaN                    NaN   \n",
       "12                       1.0                    1.0                    NaN   \n",
       "13                       NaN                    1.0                    NaN   \n",
       "14                       2.0                    NaN                    NaN   \n",
       "15                       NaN                    1.0                    NaN   \n",
       "16                       2.0                    NaN                    NaN   \n",
       "17                       NaN                    NaN                    NaN   \n",
       "18                       2.0                    NaN                    NaN   \n",
       "19                       NaN                    NaN                    NaN   \n",
       "20                       2.0                    NaN                    NaN   \n",
       "21                       NaN                    NaN                    NaN   \n",
       "22                       3.0                    1.0                    NaN   \n",
       "23                       NaN                    1.0                    NaN   \n",
       "24                       3.0                    NaN                    NaN   \n",
       "25                       NaN                    NaN                    NaN   \n",
       "26                       2.0                    NaN                    NaN   \n",
       "27                       1.0                    NaN                    NaN   \n",
       "28                       1.0                    1.0                    NaN   \n",
       "29                       NaN                    1.0                    NaN   \n",
       "...                      ...                    ...                    ...   \n",
       "41248                   15.0                    8.0                    NaN   \n",
       "41249                   11.0                    2.0                    1.0   \n",
       "41250                   68.0                   19.0                    2.0   \n",
       "41251                  100.0                   22.0                    1.0   \n",
       "41252                   21.0                    5.0                    NaN   \n",
       "41253                   37.0                    4.0                    NaN   \n",
       "41254                   63.0                   22.0                    1.0   \n",
       "41255                    2.0                    1.0                    NaN   \n",
       "41256                   18.0                    3.0                    NaN   \n",
       "41257                   45.0                   10.0                    NaN   \n",
       "41258                   42.0                   13.0                    1.0   \n",
       "41259                   23.0                    4.0                    NaN   \n",
       "41260                   10.0                    5.0                    1.0   \n",
       "41261                   57.0                   12.0                    2.0   \n",
       "41262                   37.0                    8.0                    NaN   \n",
       "41263                    9.0                    2.0                    NaN   \n",
       "41264                   43.0                   25.0                    2.0   \n",
       "41265                   23.0                    7.0                    2.0   \n",
       "41266                    NaN                    NaN                    NaN   \n",
       "41267                   63.0                   31.0                    1.0   \n",
       "41268                    4.0                    3.0                    NaN   \n",
       "41269                   21.0                    2.0                    NaN   \n",
       "41270                   15.0                    4.0                    NaN   \n",
       "41271                    9.0                    2.0                    NaN   \n",
       "41272                   34.0                   17.0                    NaN   \n",
       "41273                   50.0                   15.0                    2.0   \n",
       "41274                   18.0                    2.0                    NaN   \n",
       "41275                    2.0                    NaN                    NaN   \n",
       "41276                    6.0                    2.0                    1.0   \n",
       "41277                   71.0                   21.0                    1.0   \n",
       "\n",
       "      batter_against_hand_23 batter_against_hand_3  \n",
       "0                        NaN                   NaN  \n",
       "1                        NaN                   NaN  \n",
       "2                        NaN                   2.0  \n",
       "3                        NaN                   NaN  \n",
       "4                        NaN                   1.0  \n",
       "5                        NaN                   NaN  \n",
       "6                        1.0                   1.0  \n",
       "7                        NaN                   NaN  \n",
       "8                        NaN                   1.0  \n",
       "9                        1.0                   1.0  \n",
       "10                       NaN                   1.0  \n",
       "11                       NaN                   2.0  \n",
       "12                       NaN                   1.0  \n",
       "13                       NaN                   NaN  \n",
       "14                       1.0                   NaN  \n",
       "15                       NaN                   NaN  \n",
       "16                       NaN                   1.0  \n",
       "17                       NaN                   1.0  \n",
       "18                       NaN                   1.0  \n",
       "19                       NaN                   NaN  \n",
       "20                       1.0                   1.0  \n",
       "21                       NaN                   3.0  \n",
       "22                       NaN                   NaN  \n",
       "23                       NaN                   3.0  \n",
       "24                       NaN                   2.0  \n",
       "25                       NaN                   1.0  \n",
       "26                       NaN                   1.0  \n",
       "27                       NaN                   NaN  \n",
       "28                       NaN                   3.0  \n",
       "29                       NaN                   1.0  \n",
       "...                      ...                   ...  \n",
       "41248                    2.0                  12.0  \n",
       "41249                    3.0                  14.0  \n",
       "41250                   13.0                 148.0  \n",
       "41251                    7.0                  49.0  \n",
       "41252                    3.0                  33.0  \n",
       "41253                    NaN                  22.0  \n",
       "41254                   34.0                  93.0  \n",
       "41255                    NaN                   3.0  \n",
       "41256                    3.0                  34.0  \n",
       "41257                    5.0                  51.0  \n",
       "41258                    8.0                  40.0  \n",
       "41259                    7.0                  15.0  \n",
       "41260                    3.0                  12.0  \n",
       "41261                   10.0                 118.0  \n",
       "41262                    3.0                  35.0  \n",
       "41263                    1.0                  21.0  \n",
       "41264                   22.0                  98.0  \n",
       "41265                    2.0                  36.0  \n",
       "41266                    NaN                   NaN  \n",
       "41267                   21.0                  93.0  \n",
       "41268                    3.0                  12.0  \n",
       "41269                    3.0                  24.0  \n",
       "41270                    NaN                   7.0  \n",
       "41271                    NaN                   8.0  \n",
       "41272                    1.0                  44.0  \n",
       "41273                    9.0                  66.0  \n",
       "41274                    4.0                  34.0  \n",
       "41275                    NaN                   1.0  \n",
       "41276                    NaN                  13.0  \n",
       "41277                   22.0                  90.0  \n",
       "\n",
       "[41278 rows x 80 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "choices = choices.join(choices.apply(calculate_previous_batter_games, axis=1))\n",
    "choices.to_csv('step1.csv')\n",
    "choices = choices.join(choices.apply(calculate_previous_pitcher_games, axis=1))\n",
    "choices.to_csv('step2.csv')\n",
    "\n",
    "choices = choices.join(choices.apply(calculate_pitcher_against_hand, axis=1))\n",
    "choices.to_csv('step3.csv')\n",
    "\n",
    "choices = choices.join(choices.apply(calculate_batter_against_hand, axis=1))\n",
    "choices.to_csv('step4.csv')\n",
    "\n",
    "choices = choices.join(choices.apply(calculate_bullpen, axis=1))\n",
    "choices.to_csv('step5.csv')\n",
    "\n",
    "choices"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4800"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(bull_cache)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}