Accuracy.py.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import math\n",
    "from sklearn.metrics import mean_absolute_error, mean_squared_error"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = pd.read_csv('allPredictions2019.csv', index_col=0)\n",
    "ndf = df.dropna()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# ndf = ndf.rename(columns={'RBIsActuals': 'RBIsActual', 'AVGActuals': 'AVGActual', 'OpsActuals': 'OpsActual'})\n",
    "# ndf = ndf.rename(columns={'rbi': 'RBIsActual', 'avg': 'AVGActual', 'ops': 'OpsActual'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# cols = ['runs', 'HRs', 'RBIs', 'AVG', 'Ops']\n",
    "actualCols = ['runs', 'hr', 'rbi', 'avg', 'ops']\n",
    "predictedCols = ['runsPredicted', 'HRsPredicted', 'RBIsPredicted', 'AVGPredicted', 'opsPredicted']\n",
    "# predictedCols = ['linearSVRRuns', 'linearSvrHR', 'linearSvrRBI', 'linearSvrAVG', 'linearSvrOPS']\n",
    "# predictedCols = ['svrRuns', 'SvrHR', 'svrRBI', 'svrAVG', 'svrOPS']\n",
    "# predictedCols = ['HuberRegressorRuns', 'HuberRegressorHR', 'HuberRegressorRBI', 'HuberRegressorAVG', 'HuberRegressorOPS']\n",
    "# predictedCols = ['RidgeRuns', 'RidgeHR', 'RidgeRBI', 'RidgeAVG', 'RidgeOPS', ]\n",
    "mae = {}\n",
    "rmse = {}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "runs\n",
      "hr\n",
      "rbi\n",
      "avg\n",
      "ops\n",
      "runs\n",
      "hr\n",
      "rbi\n",
      "avg\n",
      "ops\n",
      "runs\n",
      "hr\n",
      "rbi\n",
      "avg\n",
      "ops\n"
     ]
    }
   ],
   "source": [
    "files = ['allPredictions2017.csv', 'allPredictions2018.csv', 'allPredictions2019.csv']\n",
    "maeObj = { 'runs': [], 'hr': [], 'rbi': [], 'avg': [], 'ops': []}\n",
    "rmseObj = { 'runs': [], 'hr': [], 'rbi': [], 'avg': [], 'ops': []}\n",
    "for file in files:\n",
    "    df = pd.read_csv(file, index_col=0)\n",
    "    ndf = df.dropna()\n",
    "\n",
    "    # cols = ['runs', 'HRs', 'RBIs', 'AVG', 'Ops']\n",
    "    actualCols = ['runs', 'hr', 'rbi', 'avg', 'ops']\n",
    "#     predictedCols = ['runsPredicted', 'HRsPredicted', 'RBIsPredicted', 'AVGPredicted', 'opsPredicted']\n",
    "#     predictedCols = ['linearSVRRuns', 'linearSvrHR', 'linearSvrRBI', 'linearSvrAVG', 'linearSvrOPS']\n",
    "#     predictedCols = ['svrRuns', 'SvrHR', 'svrRBI', 'svrAVG', 'svrOPS']\n",
    "#     predictedCols = ['HuberRegressorRuns', 'HuberRegressorHR', 'HuberRegressorRBI', 'HuberRegressorAVG', 'HuberRegressorOPS']\n",
    "    predictedCols = ['RidgeRuns', 'RidgeHR', 'RidgeRBI', 'RidgeAVG', 'RidgeOPS', ]\n",
    "    for i, col in enumerate(actualCols):\n",
    "        print(col)\n",
    "        predCol = predictedCols[i]\n",
    "        maeObj[col].append(mean_absolute_error(ndf[col], ndf[predCol]))\n",
    "        rmseObj[col].append(math.sqrt(mean_squared_error(ndf[col], ndf[predCol])))\n",
    "\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "18.0344063889\n",
      "6.55202858012\n",
      "18.1716970086\n",
      "0.0256959393016\n",
      "0.0763834525906\n"
     ]
    }
   ],
   "source": [
    "for cat in maeObj:\n",
    "    print(sum(maeObj[cat]) / 3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "22.823442431852666\n",
      "8.466604992286234\n",
      "22.86761086264818\n",
      "0.032890791467379686\n",
      "0.0973958561850371\n"
     ]
    }
   ],
   "source": [
    "for cat in rmseObj:\n",
    "    print(sum(rmseObj[cat]) / 3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'runs': 24.64998091000106, 'hr': 9.04043993714824, 'rbi': 23.974881498261727, 'avg': 0.0354717348613815, 'ops': 0.10619381141447645}\n"
     ]
    }
   ],
   "source": [
    "print(rmse)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Team</th>\n",
       "      <th>PA</th>\n",
       "      <th>HR</th>\n",
       "      <th>R</th>\n",
       "      <th>RBI</th>\n",
       "      <th>AVG</th>\n",
       "      <th>OPS</th>\n",
       "      <th>playerid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Christian Yelich</td>\n",
       "      <td>Brewers</td>\n",
       "      <td>580</td>\n",
       "      <td>44</td>\n",
       "      <td>100</td>\n",
       "      <td>97</td>\n",
       "      <td>0.329</td>\n",
       "      <td>1.100</td>\n",
       "      <td>11477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mike Trout</td>\n",
       "      <td>Angels</td>\n",
       "      <td>600</td>\n",
       "      <td>45</td>\n",
       "      <td>110</td>\n",
       "      <td>104</td>\n",
       "      <td>0.291</td>\n",
       "      <td>1.083</td>\n",
       "      <td>10155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Yordan Alvarez</td>\n",
       "      <td>Astros</td>\n",
       "      <td>369</td>\n",
       "      <td>27</td>\n",
       "      <td>58</td>\n",
       "      <td>78</td>\n",
       "      <td>0.313</td>\n",
       "      <td>1.067</td>\n",
       "      <td>19556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Alex Bregman</td>\n",
       "      <td>Astros</td>\n",
       "      <td>690</td>\n",
       "      <td>41</td>\n",
       "      <td>122</td>\n",
       "      <td>112</td>\n",
       "      <td>0.296</td>\n",
       "      <td>1.015</td>\n",
       "      <td>17678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Nelson Cruz</td>\n",
       "      <td>Twins</td>\n",
       "      <td>521</td>\n",
       "      <td>41</td>\n",
       "      <td>81</td>\n",
       "      <td>108</td>\n",
       "      <td>0.311</td>\n",
       "      <td>1.031</td>\n",
       "      <td>2434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>David Freese</td>\n",
       "      <td>Dodgers</td>\n",
       "      <td>186</td>\n",
       "      <td>11</td>\n",
       "      <td>35</td>\n",
       "      <td>29</td>\n",
       "      <td>0.315</td>\n",
       "      <td>1.002</td>\n",
       "      <td>9549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Cody Bellinger</td>\n",
       "      <td>Dodgers</td>\n",
       "      <td>660</td>\n",
       "      <td>47</td>\n",
       "      <td>121</td>\n",
       "      <td>115</td>\n",
       "      <td>0.305</td>\n",
       "      <td>1.035</td>\n",
       "      <td>15998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Anthony Rendon</td>\n",
       "      <td>Nationals</td>\n",
       "      <td>646</td>\n",
       "      <td>34</td>\n",
       "      <td>117</td>\n",
       "      <td>126</td>\n",
       "      <td>0.319</td>\n",
       "      <td>1.010</td>\n",
       "      <td>12861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ketel Marte</td>\n",
       "      <td>Diamondbacks</td>\n",
       "      <td>628</td>\n",
       "      <td>32</td>\n",
       "      <td>97</td>\n",
       "      <td>92</td>\n",
       "      <td>0.329</td>\n",
       "      <td>0.981</td>\n",
       "      <td>13613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Mitch Garver</td>\n",
       "      <td>Twins</td>\n",
       "      <td>359</td>\n",
       "      <td>31</td>\n",
       "      <td>70</td>\n",
       "      <td>67</td>\n",
       "      <td>0.273</td>\n",
       "      <td>0.995</td>\n",
       "      <td>15161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Joey Gallo</td>\n",
       "      <td>Rangers</td>\n",
       "      <td>297</td>\n",
       "      <td>22</td>\n",
       "      <td>54</td>\n",
       "      <td>49</td>\n",
       "      <td>0.253</td>\n",
       "      <td>0.986</td>\n",
       "      <td>14128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>George Springer</td>\n",
       "      <td>Astros</td>\n",
       "      <td>556</td>\n",
       "      <td>39</td>\n",
       "      <td>96</td>\n",
       "      <td>96</td>\n",
       "      <td>0.292</td>\n",
       "      <td>0.974</td>\n",
       "      <td>12856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Howie Kendrick</td>\n",
       "      <td>Nationals</td>\n",
       "      <td>370</td>\n",
       "      <td>17</td>\n",
       "      <td>61</td>\n",
       "      <td>62</td>\n",
       "      <td>0.344</td>\n",
       "      <td>0.966</td>\n",
       "      <td>4229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Fernando Tatis Jr.</td>\n",
       "      <td>Padres</td>\n",
       "      <td>372</td>\n",
       "      <td>22</td>\n",
       "      <td>61</td>\n",
       "      <td>53</td>\n",
       "      <td>0.317</td>\n",
       "      <td>0.969</td>\n",
       "      <td>19709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Juan Soto</td>\n",
       "      <td>Nationals</td>\n",
       "      <td>659</td>\n",
       "      <td>34</td>\n",
       "      <td>110</td>\n",
       "      <td>110</td>\n",
       "      <td>0.282</td>\n",
       "      <td>0.949</td>\n",
       "      <td>20123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Nolan Arenado</td>\n",
       "      <td>Rockies</td>\n",
       "      <td>662</td>\n",
       "      <td>41</td>\n",
       "      <td>102</td>\n",
       "      <td>118</td>\n",
       "      <td>0.315</td>\n",
       "      <td>0.962</td>\n",
       "      <td>9777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Anthony Rizzo</td>\n",
       "      <td>Cubs</td>\n",
       "      <td>613</td>\n",
       "      <td>27</td>\n",
       "      <td>89</td>\n",
       "      <td>94</td>\n",
       "      <td>0.293</td>\n",
       "      <td>0.924</td>\n",
       "      <td>3473</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Xander Bogaerts</td>\n",
       "      <td>Red Sox</td>\n",
       "      <td>698</td>\n",
       "      <td>33</td>\n",
       "      <td>110</td>\n",
       "      <td>117</td>\n",
       "      <td>0.309</td>\n",
       "      <td>0.939</td>\n",
       "      <td>12161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Keston Hiura</td>\n",
       "      <td>Brewers</td>\n",
       "      <td>348</td>\n",
       "      <td>19</td>\n",
       "      <td>51</td>\n",
       "      <td>49</td>\n",
       "      <td>0.303</td>\n",
       "      <td>0.938</td>\n",
       "      <td>20003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Charlie Blackmon</td>\n",
       "      <td>Rockies</td>\n",
       "      <td>634</td>\n",
       "      <td>32</td>\n",
       "      <td>112</td>\n",
       "      <td>86</td>\n",
       "      <td>0.314</td>\n",
       "      <td>0.940</td>\n",
       "      <td>7859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Freddie Freeman</td>\n",
       "      <td>Braves</td>\n",
       "      <td>692</td>\n",
       "      <td>38</td>\n",
       "      <td>113</td>\n",
       "      <td>121</td>\n",
       "      <td>0.295</td>\n",
       "      <td>0.938</td>\n",
       "      <td>5361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>J.D. Martinez</td>\n",
       "      <td>Red Sox</td>\n",
       "      <td>657</td>\n",
       "      <td>36</td>\n",
       "      <td>98</td>\n",
       "      <td>105</td>\n",
       "      <td>0.304</td>\n",
       "      <td>0.939</td>\n",
       "      <td>6184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Mark Canha</td>\n",
       "      <td>Athletics</td>\n",
       "      <td>497</td>\n",
       "      <td>26</td>\n",
       "      <td>80</td>\n",
       "      <td>58</td>\n",
       "      <td>0.273</td>\n",
       "      <td>0.913</td>\n",
       "      <td>11445</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Jeff McNeil</td>\n",
       "      <td>Mets</td>\n",
       "      <td>567</td>\n",
       "      <td>23</td>\n",
       "      <td>83</td>\n",
       "      <td>75</td>\n",
       "      <td>0.318</td>\n",
       "      <td>0.916</td>\n",
       "      <td>15362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Bo Bichette</td>\n",
       "      <td>Blue Jays</td>\n",
       "      <td>212</td>\n",
       "      <td>11</td>\n",
       "      <td>32</td>\n",
       "      <td>21</td>\n",
       "      <td>0.311</td>\n",
       "      <td>0.930</td>\n",
       "      <td>19612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Peter Alonso</td>\n",
       "      <td>Mets</td>\n",
       "      <td>693</td>\n",
       "      <td>53</td>\n",
       "      <td>103</td>\n",
       "      <td>120</td>\n",
       "      <td>0.260</td>\n",
       "      <td>0.941</td>\n",
       "      <td>19251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Jordan Luplow</td>\n",
       "      <td>Indians</td>\n",
       "      <td>261</td>\n",
       "      <td>15</td>\n",
       "      <td>42</td>\n",
       "      <td>38</td>\n",
       "      <td>0.276</td>\n",
       "      <td>0.923</td>\n",
       "      <td>16424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Aaron Judge</td>\n",
       "      <td>Yankees</td>\n",
       "      <td>447</td>\n",
       "      <td>27</td>\n",
       "      <td>75</td>\n",
       "      <td>55</td>\n",
       "      <td>0.272</td>\n",
       "      <td>0.921</td>\n",
       "      <td>15640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Eugenio Suarez</td>\n",
       "      <td>Reds</td>\n",
       "      <td>662</td>\n",
       "      <td>49</td>\n",
       "      <td>87</td>\n",
       "      <td>103</td>\n",
       "      <td>0.271</td>\n",
       "      <td>0.930</td>\n",
       "      <td>12552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Carlos Correa</td>\n",
       "      <td>Astros</td>\n",
       "      <td>321</td>\n",
       "      <td>21</td>\n",
       "      <td>42</td>\n",
       "      <td>59</td>\n",
       "      <td>0.279</td>\n",
       "      <td>0.926</td>\n",
       "      <td>14162</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>J.T. Riddle</td>\n",
       "      <td>Marlins</td>\n",
       "      <td>139</td>\n",
       "      <td>6</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "      <td>0.189</td>\n",
       "      <td>0.601</td>\n",
       "      <td>17642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>Isan Diaz</td>\n",
       "      <td>Marlins</td>\n",
       "      <td>201</td>\n",
       "      <td>5</td>\n",
       "      <td>17</td>\n",
       "      <td>23</td>\n",
       "      <td>0.173</td>\n",
       "      <td>0.566</td>\n",
       "      <td>17922</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>Travis Shaw</td>\n",
       "      <td>Brewers</td>\n",
       "      <td>270</td>\n",
       "      <td>7</td>\n",
       "      <td>22</td>\n",
       "      <td>16</td>\n",
       "      <td>0.157</td>\n",
       "      <td>0.551</td>\n",
       "      <td>11982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>Bubba Starling</td>\n",
       "      <td>Royals</td>\n",
       "      <td>197</td>\n",
       "      <td>4</td>\n",
       "      <td>26</td>\n",
       "      <td>12</td>\n",
       "      <td>0.215</td>\n",
       "      <td>0.572</td>\n",
       "      <td>13356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>Lucas Duda</td>\n",
       "      <td>Royals</td>\n",
       "      <td>119</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>0.171</td>\n",
       "      <td>0.576</td>\n",
       "      <td>2502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>Martin Prado</td>\n",
       "      <td>Marlins</td>\n",
       "      <td>260</td>\n",
       "      <td>2</td>\n",
       "      <td>26</td>\n",
       "      <td>15</td>\n",
       "      <td>0.233</td>\n",
       "      <td>0.559</td>\n",
       "      <td>3312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>Austin Hedges</td>\n",
       "      <td>Padres</td>\n",
       "      <td>347</td>\n",
       "      <td>11</td>\n",
       "      <td>28</td>\n",
       "      <td>36</td>\n",
       "      <td>0.176</td>\n",
       "      <td>0.563</td>\n",
       "      <td>12976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>Grayson Greiner</td>\n",
       "      <td>Tigers</td>\n",
       "      <td>224</td>\n",
       "      <td>5</td>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "      <td>0.202</td>\n",
       "      <td>0.559</td>\n",
       "      <td>17062</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>Jose Rondon</td>\n",
       "      <td>- - -</td>\n",
       "      <td>157</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>0.196</td>\n",
       "      <td>0.543</td>\n",
       "      <td>14140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>Scooter Gennett</td>\n",
       "      <td>- - -</td>\n",
       "      <td>139</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>0.226</td>\n",
       "      <td>0.568</td>\n",
       "      <td>10339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>Sandy Leon</td>\n",
       "      <td>Red Sox</td>\n",
       "      <td>191</td>\n",
       "      <td>5</td>\n",
       "      <td>14</td>\n",
       "      <td>19</td>\n",
       "      <td>0.192</td>\n",
       "      <td>0.548</td>\n",
       "      <td>5273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432</th>\n",
       "      <td>Daniel Descalso</td>\n",
       "      <td>Cubs</td>\n",
       "      <td>194</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>15</td>\n",
       "      <td>0.173</td>\n",
       "      <td>0.521</td>\n",
       "      <td>8392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>Meibrys Viloria</td>\n",
       "      <td>Royals</td>\n",
       "      <td>148</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>0.211</td>\n",
       "      <td>0.544</td>\n",
       "      <td>17109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>434</th>\n",
       "      <td>Mike Zunino</td>\n",
       "      <td>Rays</td>\n",
       "      <td>289</td>\n",
       "      <td>9</td>\n",
       "      <td>30</td>\n",
       "      <td>32</td>\n",
       "      <td>0.165</td>\n",
       "      <td>0.544</td>\n",
       "      <td>13265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>Eduardo Nunez</td>\n",
       "      <td>Red Sox</td>\n",
       "      <td>174</td>\n",
       "      <td>2</td>\n",
       "      <td>13</td>\n",
       "      <td>20</td>\n",
       "      <td>0.228</td>\n",
       "      <td>0.548</td>\n",
       "      <td>6848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>Mac Williamson</td>\n",
       "      <td>- - -</td>\n",
       "      <td>144</td>\n",
       "      <td>4</td>\n",
       "      <td>13</td>\n",
       "      <td>17</td>\n",
       "      <td>0.156</td>\n",
       "      <td>0.508</td>\n",
       "      <td>14158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>437</th>\n",
       "      <td>Keon Broxton</td>\n",
       "      <td>- - -</td>\n",
       "      <td>228</td>\n",
       "      <td>6</td>\n",
       "      <td>24</td>\n",
       "      <td>16</td>\n",
       "      <td>0.167</td>\n",
       "      <td>0.517</td>\n",
       "      <td>9253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>438</th>\n",
       "      <td>Tomas Nido</td>\n",
       "      <td>Mets</td>\n",
       "      <td>144</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>14</td>\n",
       "      <td>0.191</td>\n",
       "      <td>0.547</td>\n",
       "      <td>13755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>Jedd Gyorko</td>\n",
       "      <td>- - -</td>\n",
       "      <td>101</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>0.174</td>\n",
       "      <td>0.498</td>\n",
       "      <td>10816</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>440</th>\n",
       "      <td>Humberto Arteaga</td>\n",
       "      <td>Royals</td>\n",
       "      <td>135</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>4</td>\n",
       "      <td>0.197</td>\n",
       "      <td>0.487</td>\n",
       "      <td>13595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>441</th>\n",
       "      <td>Yonathan Daza</td>\n",
       "      <td>Rockies</td>\n",
       "      <td>105</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>0.206</td>\n",
       "      <td>0.494</td>\n",
       "      <td>15794</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>Jake Rogers</td>\n",
       "      <td>Tigers</td>\n",
       "      <td>128</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "      <td>0.125</td>\n",
       "      <td>0.481</td>\n",
       "      <td>19452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>Josh Harrison</td>\n",
       "      <td>Tigers</td>\n",
       "      <td>147</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>0.175</td>\n",
       "      <td>0.480</td>\n",
       "      <td>8202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>Lewis Brinson</td>\n",
       "      <td>Marlins</td>\n",
       "      <td>248</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>0.173</td>\n",
       "      <td>0.457</td>\n",
       "      <td>14352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>Chris Owings</td>\n",
       "      <td>- - -</td>\n",
       "      <td>196</td>\n",
       "      <td>3</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>0.139</td>\n",
       "      <td>0.443</td>\n",
       "      <td>10030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>Luke Maile</td>\n",
       "      <td>Blue Jays</td>\n",
       "      <td>129</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0.151</td>\n",
       "      <td>0.440</td>\n",
       "      <td>13355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>447</th>\n",
       "      <td>Nick Williams</td>\n",
       "      <td>Phillies</td>\n",
       "      <td>112</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>0.151</td>\n",
       "      <td>0.442</td>\n",
       "      <td>14330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>Jeff Mathis</td>\n",
       "      <td>Rangers</td>\n",
       "      <td>244</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>12</td>\n",
       "      <td>0.158</td>\n",
       "      <td>0.433</td>\n",
       "      <td>3448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>Max Stassi</td>\n",
       "      <td>- - -</td>\n",
       "      <td>147</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>0.136</td>\n",
       "      <td>0.378</td>\n",
       "      <td>10059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Zack Cozart</td>\n",
       "      <td>Angels</td>\n",
       "      <td>107</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>0.124</td>\n",
       "      <td>0.322</td>\n",
       "      <td>2616</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>451 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Name          Team   PA  HR    R  RBI    AVG    OPS  \\\n",
       "0      Christian Yelich       Brewers  580  44  100   97  0.329  1.100   \n",
       "1            Mike Trout        Angels  600  45  110  104  0.291  1.083   \n",
       "2        Yordan Alvarez        Astros  369  27   58   78  0.313  1.067   \n",
       "3          Alex Bregman        Astros  690  41  122  112  0.296  1.015   \n",
       "4           Nelson Cruz         Twins  521  41   81  108  0.311  1.031   \n",
       "5          David Freese       Dodgers  186  11   35   29  0.315  1.002   \n",
       "6        Cody Bellinger       Dodgers  660  47  121  115  0.305  1.035   \n",
       "7        Anthony Rendon     Nationals  646  34  117  126  0.319  1.010   \n",
       "8           Ketel Marte  Diamondbacks  628  32   97   92  0.329  0.981   \n",
       "9          Mitch Garver         Twins  359  31   70   67  0.273  0.995   \n",
       "10           Joey Gallo       Rangers  297  22   54   49  0.253  0.986   \n",
       "11      George Springer        Astros  556  39   96   96  0.292  0.974   \n",
       "12       Howie Kendrick     Nationals  370  17   61   62  0.344  0.966   \n",
       "13   Fernando Tatis Jr.        Padres  372  22   61   53  0.317  0.969   \n",
       "14            Juan Soto     Nationals  659  34  110  110  0.282  0.949   \n",
       "15        Nolan Arenado       Rockies  662  41  102  118  0.315  0.962   \n",
       "16        Anthony Rizzo          Cubs  613  27   89   94  0.293  0.924   \n",
       "17      Xander Bogaerts       Red Sox  698  33  110  117  0.309  0.939   \n",
       "18         Keston Hiura       Brewers  348  19   51   49  0.303  0.938   \n",
       "19     Charlie Blackmon       Rockies  634  32  112   86  0.314  0.940   \n",
       "20      Freddie Freeman        Braves  692  38  113  121  0.295  0.938   \n",
       "21        J.D. Martinez       Red Sox  657  36   98  105  0.304  0.939   \n",
       "22           Mark Canha     Athletics  497  26   80   58  0.273  0.913   \n",
       "23          Jeff McNeil          Mets  567  23   83   75  0.318  0.916   \n",
       "24          Bo Bichette     Blue Jays  212  11   32   21  0.311  0.930   \n",
       "25         Peter Alonso          Mets  693  53  103  120  0.260  0.941   \n",
       "26        Jordan Luplow       Indians  261  15   42   38  0.276  0.923   \n",
       "27          Aaron Judge       Yankees  447  27   75   55  0.272  0.921   \n",
       "28       Eugenio Suarez          Reds  662  49   87  103  0.271  0.930   \n",
       "29        Carlos Correa        Astros  321  21   42   59  0.279  0.926   \n",
       "..                  ...           ...  ...  ..  ...  ...    ...    ...   \n",
       "421         J.T. Riddle       Marlins  139   6   15   12  0.189  0.601   \n",
       "422           Isan Diaz       Marlins  201   5   17   23  0.173  0.566   \n",
       "423         Travis Shaw       Brewers  270   7   22   16  0.157  0.551   \n",
       "424      Bubba Starling        Royals  197   4   26   12  0.215  0.572   \n",
       "425          Lucas Duda        Royals  119   4    7   15  0.171  0.576   \n",
       "426        Martin Prado       Marlins  260   2   26   15  0.233  0.559   \n",
       "427       Austin Hedges        Padres  347  11   28   36  0.176  0.563   \n",
       "428     Grayson Greiner        Tigers  224   5   18   19  0.202  0.559   \n",
       "429         Jose Rondon         - - -  157   3   10    9  0.196  0.543   \n",
       "430     Scooter Gennett         - - -  139   2   15   11  0.226  0.568   \n",
       "431          Sandy Leon       Red Sox  191   5   14   19  0.192  0.548   \n",
       "432     Daniel Descalso          Cubs  194   2   20   15  0.173  0.521   \n",
       "433     Meibrys Viloria        Royals  148   1    7   15  0.211  0.544   \n",
       "434         Mike Zunino          Rays  289   9   30   32  0.165  0.544   \n",
       "435       Eduardo Nunez       Red Sox  174   2   13   20  0.228  0.548   \n",
       "436      Mac Williamson         - - -  144   4   13   17  0.156  0.508   \n",
       "437        Keon Broxton         - - -  228   6   24   16  0.167  0.517   \n",
       "438          Tomas Nido          Mets  144   4    9   14  0.191  0.547   \n",
       "439         Jedd Gyorko         - - -  101   2    6    9  0.174  0.498   \n",
       "440    Humberto Arteaga        Royals  135   0   11    4  0.197  0.487   \n",
       "441       Yonathan Daza       Rockies  105   0    7    3  0.206  0.494   \n",
       "442         Jake Rogers        Tigers  128   4   11    8  0.125  0.481   \n",
       "443       Josh Harrison        Tigers  147   1   10    8  0.175  0.480   \n",
       "444       Lewis Brinson       Marlins  248   0   15   15  0.173  0.457   \n",
       "445        Chris Owings         - - -  196   3   13   14  0.139  0.443   \n",
       "446          Luke Maile     Blue Jays  129   2    9    9  0.151  0.440   \n",
       "447       Nick Williams      Phillies  112   2    9    5  0.151  0.442   \n",
       "448         Jeff Mathis       Rangers  244   2   17   12  0.158  0.433   \n",
       "449          Max Stassi         - - -  147   1    7    5  0.136  0.378   \n",
       "450         Zack Cozart        Angels  107   0    4    7  0.124  0.322   \n",
       "\n",
       "     playerid  \n",
       "0       11477  \n",
       "1       10155  \n",
       "2       19556  \n",
       "3       17678  \n",
       "4        2434  \n",
       "5        9549  \n",
       "6       15998  \n",
       "7       12861  \n",
       "8       13613  \n",
       "9       15161  \n",
       "10      14128  \n",
       "11      12856  \n",
       "12       4229  \n",
       "13      19709  \n",
       "14      20123  \n",
       "15       9777  \n",
       "16       3473  \n",
       "17      12161  \n",
       "18      20003  \n",
       "19       7859  \n",
       "20       5361  \n",
       "21       6184  \n",
       "22      11445  \n",
       "23      15362  \n",
       "24      19612  \n",
       "25      19251  \n",
       "26      16424  \n",
       "27      15640  \n",
       "28      12552  \n",
       "29      14162  \n",
       "..        ...  \n",
       "421     17642  \n",
       "422     17922  \n",
       "423     11982  \n",
       "424     13356  \n",
       "425      2502  \n",
       "426      3312  \n",
       "427     12976  \n",
       "428     17062  \n",
       "429     14140  \n",
       "430     10339  \n",
       "431      5273  \n",
       "432      8392  \n",
       "433     17109  \n",
       "434     13265  \n",
       "435      6848  \n",
       "436     14158  \n",
       "437      9253  \n",
       "438     13755  \n",
       "439     10816  \n",
       "440     13595  \n",
       "441     15794  \n",
       "442     19452  \n",
       "443      8202  \n",
       "444     14352  \n",
       "445     10030  \n",
       "446     13355  \n",
       "447     14330  \n",
       "448      3448  \n",
       "449     10059  \n",
       "450      2616  \n",
       "\n",
       "[451 rows x 9 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}