dh_main.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2020 DH Advanced Statistics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import formulas as f\n",
    "import streamlit as st\n",
    "import plotly.express as px"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Team Stats"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Team Hitting"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>avg</th>\n",
       "      <th>G</th>\n",
       "      <th>ab</th>\n",
       "      <th>r</th>\n",
       "      <th>h</th>\n",
       "      <th>2b</th>\n",
       "      <th>3b</th>\n",
       "      <th>hr</th>\n",
       "      <th>rbi</th>\n",
       "      <th>tb</th>\n",
       "      <th>slg%</th>\n",
       "      <th>bb</th>\n",
       "      <th>hbp</th>\n",
       "      <th>so</th>\n",
       "      <th>gdp</th>\n",
       "      <th>ob%</th>\n",
       "      <th>sf</th>\n",
       "      <th>sh</th>\n",
       "      <th>sb-att</th>\n",
       "      <th>sb_att</th>\n",
       "      <th>po</th>\n",
       "      <th>a</th>\n",
       "      <th>e</th>\n",
       "      <th>fld%</th>\n",
       "      <th>wOBA</th>\n",
       "      <th>wRAA</th>\n",
       "      <th>wRC</th>\n",
       "      <th>OPS</th>\n",
       "      <th>ISO</th>\n",
       "      <th>BABIP</th>\n",
       "      <th>SO%</th>\n",
       "      <th>BB%</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Team</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>MARLINS</th>\n",
       "      <td>378</td>\n",
       "      <td>16</td>\n",
       "      <td>572</td>\n",
       "      <td>195</td>\n",
       "      <td>216</td>\n",
       "      <td>51</td>\n",
       "      <td>6</td>\n",
       "      <td>44</td>\n",
       "      <td>177</td>\n",
       "      <td>411</td>\n",
       "      <td>719</td>\n",
       "      <td>99</td>\n",
       "      <td>13</td>\n",
       "      <td>89</td>\n",
       "      <td>7</td>\n",
       "      <td>477</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>32</td>\n",
       "      <td>372</td>\n",
       "      <td>119</td>\n",
       "      <td>10</td>\n",
       "      <td>980</td>\n",
       "      <td>0.679</td>\n",
       "      <td>84.7</td>\n",
       "      <td>217.0</td>\n",
       "      <td>1.372</td>\n",
       "      <td>0.341</td>\n",
       "      <td>0.517</td>\n",
       "      <td>15.6</td>\n",
       "      <td>17.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASTROS</th>\n",
       "      <td>328</td>\n",
       "      <td>18</td>\n",
       "      <td>586</td>\n",
       "      <td>179</td>\n",
       "      <td>192</td>\n",
       "      <td>45</td>\n",
       "      <td>4</td>\n",
       "      <td>26</td>\n",
       "      <td>149</td>\n",
       "      <td>323</td>\n",
       "      <td>551</td>\n",
       "      <td>136</td>\n",
       "      <td>27</td>\n",
       "      <td>129</td>\n",
       "      <td>19</td>\n",
       "      <td>469</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>15</td>\n",
       "      <td>21</td>\n",
       "      <td>438</td>\n",
       "      <td>190</td>\n",
       "      <td>12</td>\n",
       "      <td>981</td>\n",
       "      <td>0.576</td>\n",
       "      <td>39.5</td>\n",
       "      <td>175.0</td>\n",
       "      <td>1.148</td>\n",
       "      <td>0.224</td>\n",
       "      <td>0.490</td>\n",
       "      <td>22.0</td>\n",
       "      <td>23.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAN INAZIO</th>\n",
       "      <td>317</td>\n",
       "      <td>14</td>\n",
       "      <td>460</td>\n",
       "      <td>108</td>\n",
       "      <td>146</td>\n",
       "      <td>29</td>\n",
       "      <td>2</td>\n",
       "      <td>14</td>\n",
       "      <td>86</td>\n",
       "      <td>221</td>\n",
       "      <td>480</td>\n",
       "      <td>75</td>\n",
       "      <td>12</td>\n",
       "      <td>111</td>\n",
       "      <td>13</td>\n",
       "      <td>421</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>17</td>\n",
       "      <td>21</td>\n",
       "      <td>348</td>\n",
       "      <td>116</td>\n",
       "      <td>25</td>\n",
       "      <td>949</td>\n",
       "      <td>0.509</td>\n",
       "      <td>6.8</td>\n",
       "      <td>113.0</td>\n",
       "      <td>0.999</td>\n",
       "      <td>0.163</td>\n",
       "      <td>0.477</td>\n",
       "      <td>24.1</td>\n",
       "      <td>16.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VILADECANS</th>\n",
       "      <td>307</td>\n",
       "      <td>18</td>\n",
       "      <td>600</td>\n",
       "      <td>136</td>\n",
       "      <td>184</td>\n",
       "      <td>28</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>106</td>\n",
       "      <td>245</td>\n",
       "      <td>408</td>\n",
       "      <td>104</td>\n",
       "      <td>30</td>\n",
       "      <td>139</td>\n",
       "      <td>10</td>\n",
       "      <td>427</td>\n",
       "      <td>10</td>\n",
       "      <td>12</td>\n",
       "      <td>51</td>\n",
       "      <td>69</td>\n",
       "      <td>469</td>\n",
       "      <td>195</td>\n",
       "      <td>30</td>\n",
       "      <td>957</td>\n",
       "      <td>0.465</td>\n",
       "      <td>-11.7</td>\n",
       "      <td>127.0</td>\n",
       "      <td>0.902</td>\n",
       "      <td>0.102</td>\n",
       "      <td>0.446</td>\n",
       "      <td>23.2</td>\n",
       "      <td>17.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C B BARCELONA</th>\n",
       "      <td>300</td>\n",
       "      <td>18</td>\n",
       "      <td>626</td>\n",
       "      <td>155</td>\n",
       "      <td>188</td>\n",
       "      <td>41</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>126</td>\n",
       "      <td>294</td>\n",
       "      <td>470</td>\n",
       "      <td>89</td>\n",
       "      <td>23</td>\n",
       "      <td>119</td>\n",
       "      <td>7</td>\n",
       "      <td>402</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>40</td>\n",
       "      <td>52</td>\n",
       "      <td>465</td>\n",
       "      <td>185</td>\n",
       "      <td>20</td>\n",
       "      <td>970</td>\n",
       "      <td>0.501</td>\n",
       "      <td>5.4</td>\n",
       "      <td>150.0</td>\n",
       "      <td>0.976</td>\n",
       "      <td>0.169</td>\n",
       "      <td>0.440</td>\n",
       "      <td>19.0</td>\n",
       "      <td>14.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BEISBOL NAVARRA</th>\n",
       "      <td>294</td>\n",
       "      <td>18</td>\n",
       "      <td>591</td>\n",
       "      <td>126</td>\n",
       "      <td>174</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>107</td>\n",
       "      <td>265</td>\n",
       "      <td>448</td>\n",
       "      <td>101</td>\n",
       "      <td>13</td>\n",
       "      <td>156</td>\n",
       "      <td>14</td>\n",
       "      <td>407</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>18</td>\n",
       "      <td>27</td>\n",
       "      <td>432</td>\n",
       "      <td>165</td>\n",
       "      <td>28</td>\n",
       "      <td>955</td>\n",
       "      <td>0.485</td>\n",
       "      <td>-2.3</td>\n",
       "      <td>134.0</td>\n",
       "      <td>0.944</td>\n",
       "      <td>0.154</td>\n",
       "      <td>0.450</td>\n",
       "      <td>26.4</td>\n",
       "      <td>17.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SANT BOI</th>\n",
       "      <td>281</td>\n",
       "      <td>16</td>\n",
       "      <td>513</td>\n",
       "      <td>122</td>\n",
       "      <td>144</td>\n",
       "      <td>29</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>110</td>\n",
       "      <td>222</td>\n",
       "      <td>433</td>\n",
       "      <td>97</td>\n",
       "      <td>13</td>\n",
       "      <td>118</td>\n",
       "      <td>9</td>\n",
       "      <td>403</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>24</td>\n",
       "      <td>27</td>\n",
       "      <td>389</td>\n",
       "      <td>147</td>\n",
       "      <td>29</td>\n",
       "      <td>949</td>\n",
       "      <td>0.476</td>\n",
       "      <td>-5.6</td>\n",
       "      <td>113.0</td>\n",
       "      <td>0.926</td>\n",
       "      <td>0.152</td>\n",
       "      <td>0.413</td>\n",
       "      <td>23.0</td>\n",
       "      <td>18.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CBS RIVAS</th>\n",
       "      <td>262</td>\n",
       "      <td>18</td>\n",
       "      <td>554</td>\n",
       "      <td>111</td>\n",
       "      <td>145</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>91</td>\n",
       "      <td>218</td>\n",
       "      <td>394</td>\n",
       "      <td>88</td>\n",
       "      <td>19</td>\n",
       "      <td>162</td>\n",
       "      <td>13</td>\n",
       "      <td>378</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>18</td>\n",
       "      <td>23</td>\n",
       "      <td>416</td>\n",
       "      <td>166</td>\n",
       "      <td>38</td>\n",
       "      <td>939</td>\n",
       "      <td>0.449</td>\n",
       "      <td>-17.8</td>\n",
       "      <td>110.0</td>\n",
       "      <td>0.859</td>\n",
       "      <td>0.132</td>\n",
       "      <td>0.439</td>\n",
       "      <td>29.2</td>\n",
       "      <td>15.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CBS MIRALBUENO</th>\n",
       "      <td>251</td>\n",
       "      <td>18</td>\n",
       "      <td>558</td>\n",
       "      <td>89</td>\n",
       "      <td>140</td>\n",
       "      <td>24</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>77</td>\n",
       "      <td>196</td>\n",
       "      <td>351</td>\n",
       "      <td>63</td>\n",
       "      <td>19</td>\n",
       "      <td>140</td>\n",
       "      <td>18</td>\n",
       "      <td>343</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>420</td>\n",
       "      <td>160</td>\n",
       "      <td>35</td>\n",
       "      <td>943</td>\n",
       "      <td>0.397</td>\n",
       "      <td>-40.6</td>\n",
       "      <td>88.0</td>\n",
       "      <td>0.759</td>\n",
       "      <td>0.100</td>\n",
       "      <td>0.384</td>\n",
       "      <td>25.1</td>\n",
       "      <td>11.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CBS ANTORCHA</th>\n",
       "      <td>202</td>\n",
       "      <td>18</td>\n",
       "      <td>554</td>\n",
       "      <td>78</td>\n",
       "      <td>112</td>\n",
       "      <td>18</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>62</td>\n",
       "      <td>153</td>\n",
       "      <td>276</td>\n",
       "      <td>75</td>\n",
       "      <td>19</td>\n",
       "      <td>188</td>\n",
       "      <td>8</td>\n",
       "      <td>316</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>26</td>\n",
       "      <td>30</td>\n",
       "      <td>445</td>\n",
       "      <td>159</td>\n",
       "      <td>35</td>\n",
       "      <td>945</td>\n",
       "      <td>0.344</td>\n",
       "      <td>-63.4</td>\n",
       "      <td>65.0</td>\n",
       "      <td>0.641</td>\n",
       "      <td>0.074</td>\n",
       "      <td>0.353</td>\n",
       "      <td>33.9</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Totals</th>\n",
       "      <td>292</td>\n",
       "      <td>172</td>\n",
       "      <td>5614</td>\n",
       "      <td>1299</td>\n",
       "      <td>1641</td>\n",
       "      <td>332</td>\n",
       "      <td>34</td>\n",
       "      <td>169</td>\n",
       "      <td>1091</td>\n",
       "      <td>2548</td>\n",
       "      <td>454</td>\n",
       "      <td>927</td>\n",
       "      <td>188</td>\n",
       "      <td>1351</td>\n",
       "      <td>118</td>\n",
       "      <td>406</td>\n",
       "      <td>62</td>\n",
       "      <td>60</td>\n",
       "      <td>244</td>\n",
       "      <td>310</td>\n",
       "      <td>4194</td>\n",
       "      <td>1602</td>\n",
       "      <td>262</td>\n",
       "      <td>957</td>\n",
       "      <td>0.490</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1297.0</td>\n",
       "      <td>0.955</td>\n",
       "      <td>0.162</td>\n",
       "      <td>0.442</td>\n",
       "      <td>24.1</td>\n",
       "      <td>16.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 avg    G    ab     r     h   2b  3b   hr   rbi    tb  slg%  \\\n",
       "Team                                                                          \n",
       "MARLINS          378   16   572   195   216   51   6   44   177   411   719   \n",
       "ASTROS           328   18   586   179   192   45   4   26   149   323   551   \n",
       "SAN INAZIO       317   14   460   108   146   29   2   14    86   221   480   \n",
       "VILADECANS       307   18   600   136   184   28   3    9   106   245   408   \n",
       "C B BARCELONA    300   18   626   155   188   41   7   17   126   294   470   \n",
       "BEISBOL NAVARRA  294   18   591   126   174   32   1   19   107   265   448   \n",
       "SANT BOI         281   16   513   122   144   29   2   15   110   222   433   \n",
       "CBS RIVAS        262   18   554   111   145   35   1   12    91   218   394   \n",
       "CBS MIRALBUENO   251   18   558    89   140   24   4    8    77   196   351   \n",
       "CBS ANTORCHA     202   18   554    78   112   18   4    5    62   153   276   \n",
       "Totals           292  172  5614  1299  1641  332  34  169  1091  2548   454   \n",
       "\n",
       "                  bb  hbp    so  gdp  ob%  sf  sh  sb-att  sb_att    po     a  \\\n",
       "Team                                                                            \n",
       "MARLINS           99   13    89    7  477   4   0      28      32   372   119   \n",
       "ASTROS           136   27   129   19  469   8   4      15      21   438   190   \n",
       "SAN INAZIO        75   12   111   13  421   7   6      17      21   348   116   \n",
       "VILADECANS       104   30   139   10  427  10  12      51      69   469   195   \n",
       "C B BARCELONA     89   23   119    7  402   8   6      40      52   465   185   \n",
       "BEISBOL NAVARRA  101   13   156   14  407   2   8      18      27   432   165   \n",
       "SANT BOI          97   13   118    9  403   7   5      24      27   389   147   \n",
       "CBS RIVAS         88   19   162   13  378   5   8      18      23   416   166   \n",
       "CBS MIRALBUENO    63   19   140   18  343   7   3       7       8   420   160   \n",
       "CBS ANTORCHA      75   19   188    8  316   4   8      26      30   445   159   \n",
       "Totals           927  188  1351  118  406  62  60     244     310  4194  1602   \n",
       "\n",
       "                   e  fld%   wOBA  wRAA     wRC    OPS    ISO  BABIP   SO%  \\\n",
       "Team                                                                         \n",
       "MARLINS           10   980  0.679  84.7   217.0  1.372  0.341  0.517  15.6   \n",
       "ASTROS            12   981  0.576  39.5   175.0  1.148  0.224  0.490  22.0   \n",
       "SAN INAZIO        25   949  0.509   6.8   113.0  0.999  0.163  0.477  24.1   \n",
       "VILADECANS        30   957  0.465 -11.7   127.0  0.902  0.102  0.446  23.2   \n",
       "C B BARCELONA     20   970  0.501   5.4   150.0  0.976  0.169  0.440  19.0   \n",
       "BEISBOL NAVARRA   28   955  0.485  -2.3   134.0  0.944  0.154  0.450  26.4   \n",
       "SANT BOI          29   949  0.476  -5.6   113.0  0.926  0.152  0.413  23.0   \n",
       "CBS RIVAS         38   939  0.449 -17.8   110.0  0.859  0.132  0.439  29.2   \n",
       "CBS MIRALBUENO    35   943  0.397 -40.6    88.0  0.759  0.100  0.384  25.1   \n",
       "CBS ANTORCHA      35   945  0.344 -63.4    65.0  0.641  0.074  0.353  33.9   \n",
       "Totals           262   957  0.490   0.0  1297.0  0.955  0.162  0.442  24.1   \n",
       "\n",
       "                  BB%  \n",
       "Team                   \n",
       "MARLINS          17.3  \n",
       "ASTROS           23.2  \n",
       "SAN INAZIO       16.3  \n",
       "VILADECANS       17.3  \n",
       "C B BARCELONA    14.2  \n",
       "BEISBOL NAVARRA  17.1  \n",
       "SANT BOI         18.9  \n",
       "CBS RIVAS        15.9  \n",
       "CBS MIRALBUENO   11.3  \n",
       "CBS ANTORCHA     13.5  \n",
       "Totals           16.5  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# importing teams hitting stats\n",
    "dh_team_hitting = pd.read_csv(\"data/hitting/dh_league_woba.csv\").set_index(keys=\"Team\")\n",
    "\n",
    "# selecting just totals\n",
    "totals = dh_team_hitting.loc[\"Totals\":]\n",
    "\n",
    "# woba weights - using D3 weights from 2019\n",
    "bb_w = 0.78\n",
    "hbp_w = 0.81\n",
    "h_w = 0.97\n",
    "do_w = 1.39\n",
    "tr_w = 1.69\n",
    "hr_w = 2.02\n",
    "\n",
    "# woba scale\n",
    "woba_scale = ((bb_w+hbp_w+h_w+do_w+tr_w+hr_w)/6)\n",
    "\n",
    "# new df \n",
    "teams_stats = dh_team_hitting.copy()\n",
    "\n",
    "# calling and applying woba function to the teams df\n",
    "f.league_woba(teams_stats)\n",
    "league_woba = f.league_woba(totals)\n",
    "\n",
    "# calling league runs function\n",
    "f.league_runs_pa(teams_stats)\n",
    "league_runs = f.league_runs_pa(totals)\n",
    "\n",
    "# applying league woba to team stats\n",
    "teams_stats[\"wOBA\"] = teams_stats.apply(f.league_woba, axis=1)\n",
    "\n",
    "# applying wRAA to team stats\n",
    "f.wraa_col(teams_stats, league_woba, woba_scale)\n",
    "teams_stats[\"wRAA\"] = teams_stats.apply(f.wraa_col, args=(league_woba, woba_scale), axis=1)\n",
    "\n",
    "# applying wRC to team stats\n",
    "f.wrc_col(teams_stats, league_woba, woba_scale, league_runs)\n",
    "teams_stats[\"wRC\"] = teams_stats.apply(f.wrc_col, args=(league_woba, woba_scale, league_runs), axis=1)\n",
    "\n",
    "# applying OPS to team stats\n",
    "f.ops_col(teams_stats)\n",
    "teams_stats[\"OPS\"] = teams_stats.apply(f.ops_col, axis=1)\n",
    "\n",
    "# applying ISO to team stats\n",
    "f.iso_col(teams_stats)\n",
    "teams_stats[\"ISO\"] = teams_stats.apply(f.iso_col, axis=1)\n",
    "\n",
    "# applying BABIP to team stats\n",
    "f.babip_col(teams_stats)\n",
    "teams_stats[\"BABIP\"] = teams_stats.apply(f.babip_col, axis=1)\n",
    "\n",
    "# applying SO% to team stats\n",
    "f.k_percentage(teams_stats)\n",
    "teams_stats[\"SO%\"] = teams_stats.apply(f.k_percentage, axis=1)\n",
    "\n",
    "# applying BB% to team stats\n",
    "f.bb_percentage(teams_stats)\n",
    "teams_stats[\"BB%\"] = teams_stats.apply(f.bb_percentage, axis=1)\n",
    "\n",
    "\n",
    "teams_stats.head(pd.set_option(\"display.max_columns\", None))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Team Pitching"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>era</th>\n",
       "      <th>w-l</th>\n",
       "      <th>g</th>\n",
       "      <th>cg</th>\n",
       "      <th>sho</th>\n",
       "      <th>sv</th>\n",
       "      <th>ip</th>\n",
       "      <th>h</th>\n",
       "      <th>r</th>\n",
       "      <th>er</th>\n",
       "      <th>bb</th>\n",
       "      <th>so</th>\n",
       "      <th>2b</th>\n",
       "      <th>3b</th>\n",
       "      <th>hr</th>\n",
       "      <th>ab</th>\n",
       "      <th>b/avg</th>\n",
       "      <th>wp</th>\n",
       "      <th>hbp</th>\n",
       "      <th>bk</th>\n",
       "      <th>sfa</th>\n",
       "      <th>sha</th>\n",
       "      <th>FIP</th>\n",
       "      <th>WHIP</th>\n",
       "      <th>BABIP</th>\n",
       "      <th>SO/9</th>\n",
       "      <th>BB/9</th>\n",
       "      <th>HR/9</th>\n",
       "      <th>K/BB</th>\n",
       "      <th>K%</th>\n",
       "      <th>BB%</th>\n",
       "      <th>K%-BB%</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Team</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ASTROS</th>\n",
       "      <td>3.14</td>\n",
       "      <td>17-1</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>0/0</td>\n",
       "      <td>4</td>\n",
       "      <td>146.0</td>\n",
       "      <td>136</td>\n",
       "      <td>61</td>\n",
       "      <td>51</td>\n",
       "      <td>37</td>\n",
       "      <td>169</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>554</td>\n",
       "      <td>245</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4.28</td>\n",
       "      <td>1.18</td>\n",
       "      <td>0.416</td>\n",
       "      <td>18.78</td>\n",
       "      <td>4.11</td>\n",
       "      <td>0.89</td>\n",
       "      <td>4.57</td>\n",
       "      <td>30.5</td>\n",
       "      <td>6.7</td>\n",
       "      <td>23.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARLINS</th>\n",
       "      <td>3.70</td>\n",
       "      <td>14-2</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>2/2</td>\n",
       "      <td>3</td>\n",
       "      <td>124.0</td>\n",
       "      <td>105</td>\n",
       "      <td>64</td>\n",
       "      <td>51</td>\n",
       "      <td>57</td>\n",
       "      <td>146</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>460</td>\n",
       "      <td>228</td>\n",
       "      <td>11</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>5.92</td>\n",
       "      <td>1.31</td>\n",
       "      <td>0.371</td>\n",
       "      <td>16.22</td>\n",
       "      <td>6.33</td>\n",
       "      <td>1.67</td>\n",
       "      <td>2.56</td>\n",
       "      <td>31.7</td>\n",
       "      <td>12.4</td>\n",
       "      <td>19.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>C B BARCELONA</th>\n",
       "      <td>4.88</td>\n",
       "      <td>12-6</td>\n",
       "      <td>18</td>\n",
       "      <td>3</td>\n",
       "      <td>0/0</td>\n",
       "      <td>1</td>\n",
       "      <td>155.0</td>\n",
       "      <td>160</td>\n",
       "      <td>99</td>\n",
       "      <td>84</td>\n",
       "      <td>90</td>\n",
       "      <td>149</td>\n",
       "      <td>33</td>\n",
       "      <td>4</td>\n",
       "      <td>14</td>\n",
       "      <td>596</td>\n",
       "      <td>268</td>\n",
       "      <td>22</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>6.13</td>\n",
       "      <td>1.61</td>\n",
       "      <td>0.423</td>\n",
       "      <td>16.56</td>\n",
       "      <td>10.00</td>\n",
       "      <td>1.56</td>\n",
       "      <td>1.66</td>\n",
       "      <td>25.0</td>\n",
       "      <td>15.1</td>\n",
       "      <td>9.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VILADECANS</th>\n",
       "      <td>4.95</td>\n",
       "      <td>12-6</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>0/0</td>\n",
       "      <td>3</td>\n",
       "      <td>156.1</td>\n",
       "      <td>153</td>\n",
       "      <td>118</td>\n",
       "      <td>86</td>\n",
       "      <td>82</td>\n",
       "      <td>140</td>\n",
       "      <td>29</td>\n",
       "      <td>6</td>\n",
       "      <td>15</td>\n",
       "      <td>590</td>\n",
       "      <td>259</td>\n",
       "      <td>34</td>\n",
       "      <td>21</td>\n",
       "      <td>2</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>6.37</td>\n",
       "      <td>1.51</td>\n",
       "      <td>0.398</td>\n",
       "      <td>15.56</td>\n",
       "      <td>9.11</td>\n",
       "      <td>1.67</td>\n",
       "      <td>1.71</td>\n",
       "      <td>23.7</td>\n",
       "      <td>13.9</td>\n",
       "      <td>9.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAN INAZIO</th>\n",
       "      <td>5.20</td>\n",
       "      <td>10-4</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>3/1</td>\n",
       "      <td>2</td>\n",
       "      <td>116.0</td>\n",
       "      <td>126</td>\n",
       "      <td>82</td>\n",
       "      <td>67</td>\n",
       "      <td>62</td>\n",
       "      <td>161</td>\n",
       "      <td>22</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>471</td>\n",
       "      <td>268</td>\n",
       "      <td>23</td>\n",
       "      <td>16</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>4.63</td>\n",
       "      <td>1.62</td>\n",
       "      <td>0.477</td>\n",
       "      <td>17.89</td>\n",
       "      <td>6.89</td>\n",
       "      <td>0.44</td>\n",
       "      <td>2.60</td>\n",
       "      <td>34.2</td>\n",
       "      <td>13.2</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SANT BOI</th>\n",
       "      <td>7.43</td>\n",
       "      <td>6-10</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>1/0</td>\n",
       "      <td>1</td>\n",
       "      <td>129.2</td>\n",
       "      <td>112</td>\n",
       "      <td>127</td>\n",
       "      <td>107</td>\n",
       "      <td>133</td>\n",
       "      <td>99</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>484</td>\n",
       "      <td>231</td>\n",
       "      <td>30</td>\n",
       "      <td>18</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>8.02</td>\n",
       "      <td>1.90</td>\n",
       "      <td>0.321</td>\n",
       "      <td>11.00</td>\n",
       "      <td>14.78</td>\n",
       "      <td>1.22</td>\n",
       "      <td>0.74</td>\n",
       "      <td>20.5</td>\n",
       "      <td>27.5</td>\n",
       "      <td>-7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BEISBOL NAVARRA</th>\n",
       "      <td>7.50</td>\n",
       "      <td>7-11</td>\n",
       "      <td>18</td>\n",
       "      <td>3</td>\n",
       "      <td>1/1</td>\n",
       "      <td>3</td>\n",
       "      <td>144.0</td>\n",
       "      <td>177</td>\n",
       "      <td>145</td>\n",
       "      <td>120</td>\n",
       "      <td>100</td>\n",
       "      <td>147</td>\n",
       "      <td>43</td>\n",
       "      <td>3</td>\n",
       "      <td>23</td>\n",
       "      <td>580</td>\n",
       "      <td>305</td>\n",
       "      <td>20</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>11</td>\n",
       "      <td>7.58</td>\n",
       "      <td>1.92</td>\n",
       "      <td>0.488</td>\n",
       "      <td>16.33</td>\n",
       "      <td>11.11</td>\n",
       "      <td>2.56</td>\n",
       "      <td>1.47</td>\n",
       "      <td>25.3</td>\n",
       "      <td>17.2</td>\n",
       "      <td>8.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CBS ANTORCHA</th>\n",
       "      <td>9.53</td>\n",
       "      <td>3-15</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>148.1</td>\n",
       "      <td>222</td>\n",
       "      <td>193</td>\n",
       "      <td>157</td>\n",
       "      <td>114</td>\n",
       "      <td>102</td>\n",
       "      <td>47</td>\n",
       "      <td>2</td>\n",
       "      <td>27</td>\n",
       "      <td>649</td>\n",
       "      <td>342</td>\n",
       "      <td>30</td>\n",
       "      <td>18</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>8.61</td>\n",
       "      <td>2.27</td>\n",
       "      <td>0.469</td>\n",
       "      <td>11.33</td>\n",
       "      <td>12.67</td>\n",
       "      <td>3.00</td>\n",
       "      <td>0.89</td>\n",
       "      <td>15.7</td>\n",
       "      <td>17.6</td>\n",
       "      <td>-1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CBS RIVAS</th>\n",
       "      <td>10.64</td>\n",
       "      <td>2-16</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>138.2</td>\n",
       "      <td>213</td>\n",
       "      <td>192</td>\n",
       "      <td>164</td>\n",
       "      <td>118</td>\n",
       "      <td>142</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>33</td>\n",
       "      <td>605</td>\n",
       "      <td>352</td>\n",
       "      <td>46</td>\n",
       "      <td>34</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>9.29</td>\n",
       "      <td>2.40</td>\n",
       "      <td>0.516</td>\n",
       "      <td>15.78</td>\n",
       "      <td>13.11</td>\n",
       "      <td>3.67</td>\n",
       "      <td>1.20</td>\n",
       "      <td>23.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CBS MIRALBUENO</th>\n",
       "      <td>12.66</td>\n",
       "      <td>3-15</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>237</td>\n",
       "      <td>218</td>\n",
       "      <td>197</td>\n",
       "      <td>134</td>\n",
       "      <td>96</td>\n",
       "      <td>55</td>\n",
       "      <td>9</td>\n",
       "      <td>19</td>\n",
       "      <td>625</td>\n",
       "      <td>379</td>\n",
       "      <td>30</td>\n",
       "      <td>21</td>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "      <td>8.65</td>\n",
       "      <td>2.65</td>\n",
       "      <td>0.553</td>\n",
       "      <td>10.67</td>\n",
       "      <td>14.89</td>\n",
       "      <td>2.11</td>\n",
       "      <td>0.72</td>\n",
       "      <td>15.4</td>\n",
       "      <td>21.4</td>\n",
       "      <td>-6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Totals</th>\n",
       "      <td>6.98</td>\n",
       "      <td>86-86</td>\n",
       "      <td>172</td>\n",
       "      <td>19</td>\n",
       "      <td>7/4</td>\n",
       "      <td>17</td>\n",
       "      <td>1398.0</td>\n",
       "      <td>1641</td>\n",
       "      <td>1299</td>\n",
       "      <td>1084</td>\n",
       "      <td>927</td>\n",
       "      <td>1351</td>\n",
       "      <td>332</td>\n",
       "      <td>34</td>\n",
       "      <td>169</td>\n",
       "      <td>5614</td>\n",
       "      <td>292</td>\n",
       "      <td>252</td>\n",
       "      <td>188</td>\n",
       "      <td>36</td>\n",
       "      <td>62</td>\n",
       "      <td>60</td>\n",
       "      <td>6.97</td>\n",
       "      <td>1.84</td>\n",
       "      <td>0.449</td>\n",
       "      <td>150.11</td>\n",
       "      <td>103.00</td>\n",
       "      <td>18.78</td>\n",
       "      <td>1.46</td>\n",
       "      <td>24.1</td>\n",
       "      <td>16.5</td>\n",
       "      <td>7.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   era    w-l    g  cg  sho  sv      ip     h     r    er  \\\n",
       "Team                                                                        \n",
       "ASTROS            3.14   17-1   18   1  0/0   4   146.0   136    61    51   \n",
       "MARLINS           3.70   14-2   16   1  2/2   3   124.0   105    64    51   \n",
       "C B BARCELONA     4.88   12-6   18   3  0/0   1   155.0   160    99    84   \n",
       "VILADECANS        4.95   12-6   18   2  0/0   3   156.1   153   118    86   \n",
       "SAN INAZIO        5.20   10-4   14   4  3/1   2   116.0   126    82    67   \n",
       "SANT BOI          7.43   6-10   16   2  1/0   1   129.2   112   127   107   \n",
       "BEISBOL NAVARRA   7.50   7-11   18   3  1/1   3   144.0   177   145   120   \n",
       "CBS ANTORCHA      9.53   3-15   18   1  0/0   0   148.1   222   193   157   \n",
       "CBS RIVAS        10.64   2-16   18   2  0/0   0   138.2   213   192   164   \n",
       "CBS MIRALBUENO   12.66   3-15   18   0  0/0   0   140.0   237   218   197   \n",
       "Totals            6.98  86-86  172  19  7/4  17  1398.0  1641  1299  1084   \n",
       "\n",
       "                  bb    so   2b  3b   hr    ab  b/avg   wp  hbp  bk  sfa  sha  \\\n",
       "Team                                                                            \n",
       "ASTROS            37   169   28   1    8   554    245    6    9   5    1    2   \n",
       "MARLINS           57   146   20   1   15   460    228   11   16   0    5    4   \n",
       "C B BARCELONA     90   149   33   4   14   596    268   22   10   1    4    4   \n",
       "VILADECANS        82   140   29   6   15   590    259   34   21   2   13   14   \n",
       "SAN INAZIO        62   161   22   2    4   471    268   23   16   3    1    4   \n",
       "SANT BOI         133    99   18   1   11   484    231   30   18   3    5    2   \n",
       "BEISBOL NAVARRA  100   147   43   3   23   580    305   20   25   3    5   11   \n",
       "CBS ANTORCHA     114   102   47   2   27   649    342   30   18   5    8    4   \n",
       "CBS RIVAS        118   142   37   5   33   605    352   46   34   8    8    7   \n",
       "CBS MIRALBUENO   134    96   55   9   19   625    379   30   21   6   12    8   \n",
       "Totals           927  1351  332  34  169  5614    292  252  188  36   62   60   \n",
       "\n",
       "                  FIP  WHIP  BABIP    SO/9    BB/9   HR/9  K/BB    K%   BB%  \\\n",
       "Team                                                                          \n",
       "ASTROS           4.28  1.18  0.416   18.78    4.11   0.89  4.57  30.5   6.7   \n",
       "MARLINS          5.92  1.31  0.371   16.22    6.33   1.67  2.56  31.7  12.4   \n",
       "C B BARCELONA    6.13  1.61  0.423   16.56   10.00   1.56  1.66  25.0  15.1   \n",
       "VILADECANS       6.37  1.51  0.398   15.56    9.11   1.67  1.71  23.7  13.9   \n",
       "SAN INAZIO       4.63  1.62  0.477   17.89    6.89   0.44  2.60  34.2  13.2   \n",
       "SANT BOI         8.02  1.90  0.321   11.00   14.78   1.22  0.74  20.5  27.5   \n",
       "BEISBOL NAVARRA  7.58  1.92  0.488   16.33   11.11   2.56  1.47  25.3  17.2   \n",
       "CBS ANTORCHA     8.61  2.27  0.469   11.33   12.67   3.00  0.89  15.7  17.6   \n",
       "CBS RIVAS        9.29  2.40  0.516   15.78   13.11   3.67  1.20  23.5  19.5   \n",
       "CBS MIRALBUENO   8.65  2.65  0.553   10.67   14.89   2.11  0.72  15.4  21.4   \n",
       "Totals           6.97  1.84  0.449  150.11  103.00  18.78  1.46  24.1  16.5   \n",
       "\n",
       "                 K%-BB%  \n",
       "Team                     \n",
       "ASTROS             23.8  \n",
       "MARLINS            19.3  \n",
       "C B BARCELONA       9.9  \n",
       "VILADECANS          9.8  \n",
       "SAN INAZIO         21.0  \n",
       "SANT BOI           -7.0  \n",
       "BEISBOL NAVARRA     8.1  \n",
       "CBS ANTORCHA       -1.9  \n",
       "CBS RIVAS           4.0  \n",
       "CBS MIRALBUENO     -6.0  \n",
       "Totals              7.6  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# importing teams pitching stats\n",
    "dh_league_pitching = pd.read_csv(\"data/pitching/dh_2020_league_pitching_stats.csv\").set_index(keys=\"Team\")\n",
    "\n",
    "# selecting just the totals row to create fip constant\n",
    "league_totals = dh_league_pitching.loc[\"Totals\":]\n",
    "\n",
    "# calling and applying fip constant function to the teams df\n",
    "f.fip_constant(league_totals)\n",
    "fip_constant = f.fip_constant(league_totals)\n",
    "\n",
    "\"\"\" NEW COLUMNS \"\"\"\n",
    "\n",
    "# FIP \n",
    "f.fip_col(dh_league_pitching)\n",
    "dh_league_pitching[\"FIP\"] = dh_league_pitching.apply(f.fip_col, axis=1)\n",
    "\n",
    "# WHIP\n",
    "f.walk_hit(dh_league_pitching)\n",
    "dh_league_pitching[\"WHIP\"] = dh_league_pitching.apply(f.walk_hit, axis=1)\n",
    "\n",
    "# BABIP - removing SF as it is not provided for pitchers\n",
    "f.pitch_babip_col(dh_league_pitching)\n",
    "dh_league_pitching[\"BABIP\"] = dh_league_pitching.apply(f.pitch_babip_col, axis=1)\n",
    "\n",
    "# S0/9\n",
    "f.so_9(dh_league_pitching)\n",
    "dh_league_pitching[\"SO/9\"] = dh_league_pitching.apply(f.so_9, axis=1)\n",
    "\n",
    "# BB/9\n",
    "f.bb_9(dh_league_pitching)\n",
    "dh_league_pitching[\"BB/9\"] = dh_league_pitching.apply(f.bb_9, axis=1)\n",
    "\n",
    "# HR/9\n",
    "f.hr_9(dh_league_pitching)\n",
    "dh_league_pitching[\"HR/9\"] = dh_league_pitching.apply(f.hr_9, axis=1)\n",
    "\n",
    "# K/BB\n",
    "f.k_bb(dh_league_pitching)\n",
    "dh_league_pitching[\"K/BB\"] = dh_league_pitching.apply(f.k_bb, axis=1)\n",
    "    \n",
    "# K%\n",
    "f.k_percentage(dh_league_pitching)\n",
    "dh_league_pitching[\"K%\"] = dh_league_pitching.apply(f.k_percentage, axis=1)\n",
    "\n",
    "# BB%\n",
    "f.bb_percentage(dh_league_pitching)\n",
    "dh_league_pitching[\"BB%\"] = dh_league_pitching.apply(f.bb_percentage, axis=1)\n",
    "\n",
    "#K%-BB%\n",
    "dh_league_pitching[\"K%-BB%\"] = dh_league_pitching[\"K%\"]-dh_league_pitching[\"BB%\"]\n",
    "\n",
    "dh_league_pitching"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Individual Stats"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Individual Hitting"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "\"\"\" DATA TRANSFORMATIONS \"\"\"\n",
    "\n",
    "# importing individual players hitting stats\n",
    "dh_individual_hitting = pd.read_csv(\"data/hitting/dh_2020_hitting_stats.csv\")\n",
    "\n",
    "# selecting players with 18 or more ab, 1 ab per game played\n",
    "dh_individual_hitting = dh_individual_hitting.query(\"ab >= 18\")\n",
    "\n",
    "# converting slg% to int\n",
    "dh_individual_hitting[\"slg%\"] = round(dh_individual_hitting[\"slg%\"].astype(\"float64\"))\n",
    "\n",
    "# fixing value with thousand separator\n",
    "dh_individual_hitting[\"slg%\"].replace({1.0: 1074.0}, inplace=True)\n",
    "\n",
    "# splitting player column in two to have player name and team in two different columns\n",
    "dh_individual_hitting[['Player','Equipo']] = dh_individual_hitting['Player'].str.split(',',expand=True)\n",
    "\n",
    "# re-arrenging columns\n",
    "dh_individual_hitting = dh_individual_hitting[['Player', 'Equipo', 'avg', 'gp-gs', 'ab', 'r', 'h', '2b', '3b', 'hr', 'rbi', 'tb',\n",
    "       'slg%', 'bb', 'hbp', 'so', 'gdp', 'ob%', 'sf', 'sh', 'sb-att']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "\"\"\" NEW COLUMNS \"\"\"\n",
    "\n",
    "# wOBA\n",
    "# calling and applying woba function to individual players\n",
    "f.individual_woba(dh_individual_hitting)\n",
    "dh_individual_hitting[\"wOBA\"] = dh_individual_hitting.apply(f.individual_woba, axis=1)\n",
    "\n",
    "# wRAA\n",
    "f.wraa_col(dh_individual_hitting, league_woba, woba_scale)\n",
    "dh_individual_hitting[\"wRAA\"] = dh_individual_hitting.apply(f.wraa_col, args=(league_woba, woba_scale), axis=1)\n",
    "\n",
    "# wRC\n",
    "f.wrc_col(dh_individual_hitting, league_woba, woba_scale, league_runs)\n",
    "dh_individual_hitting[\"wRC\"] = dh_individual_hitting.apply(f.wrc_col, args=(league_woba, woba_scale, league_runs), axis=1)\n",
    "\n",
    "# OPS\n",
    "f.ops_col(dh_individual_hitting)\n",
    "dh_individual_hitting[\"OPS\"] = dh_individual_hitting.apply(f.ops_col, axis=1)\n",
    "\n",
    "# ISO\n",
    "f.iso_col(dh_individual_hitting)\n",
    "dh_individual_hitting[\"ISO\"] = dh_individual_hitting.apply(f.iso_col, axis=1)\n",
    "\n",
    "# BABIP\n",
    "f.babip_col(dh_individual_hitting)\n",
    "dh_individual_hitting[\"BABIP\"] = dh_individual_hitting.apply(f.babip_col, axis=1)\n",
    "\n",
    "# SO%\n",
    "f.k_percentage(dh_individual_hitting)\n",
    "dh_individual_hitting[\"SO%\"] = dh_individual_hitting.apply(f.k_percentage, axis=1)\n",
    "\n",
    "# BB%\n",
    "dh_individual_hitting[\"BB%\"] = dh_individual_hitting.apply(f.bb_percentage, axis=1)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Equipo</th>\n",
       "      <th>avg</th>\n",
       "      <th>gp-gs</th>\n",
       "      <th>ab</th>\n",
       "      <th>r</th>\n",
       "      <th>h</th>\n",
       "      <th>2b</th>\n",
       "      <th>3b</th>\n",
       "      <th>hr</th>\n",
       "      <th>rbi</th>\n",
       "      <th>tb</th>\n",
       "      <th>slg%</th>\n",
       "      <th>bb</th>\n",
       "      <th>hbp</th>\n",
       "      <th>so</th>\n",
       "      <th>gdp</th>\n",
       "      <th>ob%</th>\n",
       "      <th>sf</th>\n",
       "      <th>sh</th>\n",
       "      <th>sb-att</th>\n",
       "      <th>wOBA</th>\n",
       "      <th>wRAA</th>\n",
       "      <th>wRC</th>\n",
       "      <th>OPS</th>\n",
       "      <th>ISO</th>\n",
       "      <th>BABIP</th>\n",
       "      <th>SO%</th>\n",
       "      <th>BB%</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>RODRIGUEZ Michel</td>\n",
       "      <td>AST</td>\n",
       "      <td>500.0</td>\n",
       "      <td>17-16</td>\n",
       "      <td>56</td>\n",
       "      <td>24</td>\n",
       "      <td>28</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>54</td>\n",
       "      <td>964.0</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>613.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0-0</td>\n",
       "      <td>0.831</td>\n",
       "      <td>15.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>1.792</td>\n",
       "      <td>0.464</td>\n",
       "      <td>0.619</td>\n",
       "      <td>14.3</td>\n",
       "      <td>32.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SANTANA Nestor</td>\n",
       "      <td>MIR</td>\n",
       "      <td>500.0</td>\n",
       "      <td>14-14</td>\n",
       "      <td>50</td>\n",
       "      <td>13</td>\n",
       "      <td>25</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>38</td>\n",
       "      <td>760.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>536.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0-0</td>\n",
       "      <td>0.749</td>\n",
       "      <td>10.1</td>\n",
       "      <td>22.0</td>\n",
       "      <td>1.476</td>\n",
       "      <td>0.260</td>\n",
       "      <td>0.711</td>\n",
       "      <td>10.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GALVAN Lesther</td>\n",
       "      <td>MAR</td>\n",
       "      <td>441.0</td>\n",
       "      <td>16-16</td>\n",
       "      <td>68</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>32</td>\n",
       "      <td>73</td>\n",
       "      <td>1074.0</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>519.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0-0</td>\n",
       "      <td>0.880</td>\n",
       "      <td>20.8</td>\n",
       "      <td>36.0</td>\n",
       "      <td>1.843</td>\n",
       "      <td>0.632</td>\n",
       "      <td>0.429</td>\n",
       "      <td>8.8</td>\n",
       "      <td>14.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>RODRIGUEZ Luis</td>\n",
       "      <td>MAR</td>\n",
       "      <td>433.0</td>\n",
       "      <td>16-16</td>\n",
       "      <td>67</td>\n",
       "      <td>30</td>\n",
       "      <td>29</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>21</td>\n",
       "      <td>53</td>\n",
       "      <td>791.0</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>536.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5-6</td>\n",
       "      <td>0.728</td>\n",
       "      <td>12.5</td>\n",
       "      <td>28.0</td>\n",
       "      <td>1.506</td>\n",
       "      <td>0.358</td>\n",
       "      <td>0.547</td>\n",
       "      <td>13.4</td>\n",
       "      <td>20.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>LOPEZ Frederman</td>\n",
       "      <td>RIV</td>\n",
       "      <td>432.0</td>\n",
       "      <td>16-15</td>\n",
       "      <td>44</td>\n",
       "      <td>10</td>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>13</td>\n",
       "      <td>28</td>\n",
       "      <td>636.0</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>569.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0-0</td>\n",
       "      <td>0.648</td>\n",
       "      <td>5.4</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.319</td>\n",
       "      <td>0.205</td>\n",
       "      <td>0.606</td>\n",
       "      <td>20.5</td>\n",
       "      <td>29.5</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",
       "      <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>142</th>\n",
       "      <td>FLORES Jeifer</td>\n",
       "      <td>VIL</td>\n",
       "      <td>91.0</td>\n",
       "      <td>11-7</td>\n",
       "      <td>22</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>91.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>259.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2-2</td>\n",
       "      <td>0.216</td>\n",
       "      <td>-4.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.350</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.200</td>\n",
       "      <td>54.5</td>\n",
       "      <td>22.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>BORDANOBA Joan</td>\n",
       "      <td>SBO</td>\n",
       "      <td>83.0</td>\n",
       "      <td>9-8</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>83.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0-0</td>\n",
       "      <td>0.109</td>\n",
       "      <td>-7.2</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.203</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.154</td>\n",
       "      <td>45.8</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>LOPEZ Uriel</td>\n",
       "      <td>VIL</td>\n",
       "      <td>53.0</td>\n",
       "      <td>14-5</td>\n",
       "      <td>19</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>105.0</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1-1</td>\n",
       "      <td>0.262</td>\n",
       "      <td>-3.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.408</td>\n",
       "      <td>0.053</td>\n",
       "      <td>0.222</td>\n",
       "      <td>52.6</td>\n",
       "      <td>21.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>PORRES Adrian</td>\n",
       "      <td>ANT</td>\n",
       "      <td>50.0</td>\n",
       "      <td>12-8</td>\n",
       "      <td>20</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>50.0</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>394.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0-0</td>\n",
       "      <td>0.315</td>\n",
       "      <td>-2.7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.444</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.100</td>\n",
       "      <td>55.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>OLIVEROS Franklin</td>\n",
       "      <td>RIV</td>\n",
       "      <td>28.0</td>\n",
       "      <td>13-12</td>\n",
       "      <td>36</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>28.0</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>182.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0-2</td>\n",
       "      <td>0.147</td>\n",
       "      <td>-9.7</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.210</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.050</td>\n",
       "      <td>47.2</td>\n",
       "      <td>13.9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>114 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Player Equipo    avg  gp-gs  ab   r   h  2b  3b  hr  rbi  tb  \\\n",
       "0     RODRIGUEZ Michel    AST  500.0  17-16  56  24  28   5   0   7   17  54   \n",
       "1       SANTANA Nestor    MIR  500.0  14-14  50  13  25   6   2   1   15  38   \n",
       "2       GALVAN Lesther    MAR  441.0  16-16  68  30  30   4   0  13   32  73   \n",
       "3       RODRIGUEZ Luis    MAR  433.0  16-16  67  30  29   6   0   6   21  53   \n",
       "4      LOPEZ Frederman    RIV  432.0  16-15  44  10  19   3   0   2   13  28   \n",
       "..                 ...    ...    ...    ...  ..  ..  ..  ..  ..  ..  ...  ..   \n",
       "142      FLORES Jeifer    VIL   91.0   11-7  22   3   2   0   0   0    0   2   \n",
       "144     BORDANOBA Joan    SBO   83.0    9-8  24   1   2   0   0   0    1   2   \n",
       "149        LOPEZ Uriel    VIL   53.0   14-5  19   6   1   1   0   0    1   2   \n",
       "150      PORRES Adrian    ANT   50.0   12-8  20   4   1   0   0   0    3   1   \n",
       "151  OLIVEROS Franklin    RIV   28.0  13-12  36   3   1   0   0   0    4   1   \n",
       "\n",
       "       slg%  bb  hbp  so  gdp    ob%  sf  sh sb-att   wOBA  wRAA   wRC    OPS  \\\n",
       "0     964.0  18    0   8    3  613.0   1   0    0-0  0.831  15.0  28.0  1.792   \n",
       "1     760.0   3    2   5    4  536.0   1   0    0-0  0.749  10.1  22.0  1.476   \n",
       "2    1074.0  10    1   6    0  519.0   0   0    0-0  0.880  20.8  36.0  1.843   \n",
       "3     791.0  14    2   9    0  536.0   1   0    5-6  0.728  12.5  28.0  1.506   \n",
       "4     636.0  13    1   9    1  569.0   0   0    0-0  0.648   5.4  16.0  1.319   \n",
       "..      ...  ..  ...  ..  ...    ...  ..  ..    ...    ...   ...   ...    ...   \n",
       "142    91.0   5    0  12    0  259.0   0   0    2-2  0.216  -4.7   0.0  0.350   \n",
       "144    83.0   1    0  11    0  120.0   0   0    0-0  0.109  -7.2  -2.0  0.203   \n",
       "149   105.0   4    1  10    0  250.0   0   0    1-1  0.262  -3.4   1.0  0.408   \n",
       "150    50.0  10    2  11    1  394.0   1   0    0-0  0.315  -2.7   2.0  0.444   \n",
       "151    28.0   5    2  17    1  182.0   1   0    0-2  0.147  -9.7  -1.0  0.210   \n",
       "\n",
       "       ISO  BABIP   SO%   BB%  \n",
       "0    0.464  0.619  14.3  32.1  \n",
       "1    0.260  0.711  10.0   6.0  \n",
       "2    0.632  0.429   8.8  14.7  \n",
       "3    0.358  0.547  13.4  20.9  \n",
       "4    0.205  0.606  20.5  29.5  \n",
       "..     ...    ...   ...   ...  \n",
       "142  0.000  0.200  54.5  22.7  \n",
       "144  0.000  0.154  45.8   4.2  \n",
       "149  0.053  0.222  52.6  21.1  \n",
       "150  0.000  0.100  55.0  50.0  \n",
       "151  0.000  0.050  47.2  13.9  \n",
       "\n",
       "[114 rows x 29 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dh_individual_hitting.sort_values(\"avg\", ascending=False).head((pd.set_option(\"display.max_columns\", None)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "#dh_individual_hitting.to_csv(\"data/dh_individual_hitting.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Individual Pitching"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "\"\"\" DATA TRANSFORMATIONS \"\"\"\n",
    "\n",
    "# importing individual players pitching stats\n",
    "dh_individual_pitching = pd.read_csv(\"data/pitching/dh_2020_individual_pitching_stats.csv\")\n",
    "\n",
    "# filtering pitchers with at least one inning pitch\n",
    "dh_individual_pitching = dh_individual_pitching.query(\"ip >= 1\")\n",
    "\n",
    "# splitting player column in two to have player name and team in two different columns\n",
    "dh_individual_pitching[['Player','Equipo']] = dh_individual_pitching['Player'].str.split(',',expand=True)\n",
    "\n",
    "# re-arrenging columns\n",
    "dh_individual_pitching = dh_individual_pitching[['Player' ,\n",
    "       'Equipo', 'era', 'w-l', 'app-gs', 'cg', 'sho', 'sv', 'ip', 'h', 'r',\n",
    "       'er', 'bb', 'so', '2b', '3b', 'hr', 'ab', 'b/avg', 'wp', 'hbp', 'bk']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "\"\"\" NEW COLUMNS \"\"\"\n",
    "\n",
    "# FIP \n",
    "f.fip_col(dh_individual_pitching)\n",
    "dh_individual_pitching[\"FIP\"] = dh_individual_pitching.apply(f.fip_col, axis=1)\n",
    "\n",
    "# WHIP\n",
    "f.walk_hit(dh_individual_pitching)\n",
    "dh_individual_pitching[\"WHIP\"] = dh_individual_pitching.apply(f.walk_hit, axis=1)\n",
    "\n",
    "# BABIP - removing SF as it is not provided for pitchers\n",
    "f.pitch_babip_col(dh_individual_pitching)\n",
    "dh_individual_pitching[\"BABIP\"] = dh_individual_pitching.apply(f.pitch_babip_col, axis=1)\n",
    "\n",
    "# S0/9\n",
    "f.so_9(dh_individual_pitching)\n",
    "dh_individual_pitching[\"SO/9\"] = dh_individual_pitching.apply(f.so_9, axis=1)\n",
    "\n",
    "# BB/9\n",
    "f.bb_9(dh_individual_pitching)\n",
    "dh_individual_pitching[\"BB/9\"] = dh_individual_pitching.apply(f.bb_9, axis=1)\n",
    "\n",
    "# HR/9\n",
    "f.hr_9(dh_individual_pitching)\n",
    "dh_individual_pitching[\"HR/9\"] = dh_individual_pitching.apply(f.hr_9, axis=1)\n",
    "\n",
    "# K/BB\n",
    "f.k_bb(dh_individual_pitching)\n",
    "dh_individual_pitching[\"K/BB\"] = dh_individual_pitching.apply(f.k_bb, axis=1)\n",
    "    \n",
    "# K%\n",
    "f.k_percentage(dh_individual_pitching)\n",
    "dh_individual_pitching[\"K%\"] = dh_individual_pitching.apply(f.k_percentage, axis=1)\n",
    "\n",
    "# BB%\n",
    "f.bb_percentage(dh_individual_pitching)\n",
    "dh_individual_pitching[\"BB%\"] = dh_individual_pitching.apply(f.bb_percentage, axis=1)\n",
    "\n",
    "#K%-BB%\n",
    "dh_individual_pitching[\"K%-BB%\"] = dh_individual_pitching[\"K%\"]-dh_individual_pitching[\"BB%\"]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Equipo</th>\n",
       "      <th>era</th>\n",
       "      <th>w-l</th>\n",
       "      <th>app-gs</th>\n",
       "      <th>cg</th>\n",
       "      <th>sho</th>\n",
       "      <th>sv</th>\n",
       "      <th>ip</th>\n",
       "      <th>h</th>\n",
       "      <th>r</th>\n",
       "      <th>er</th>\n",
       "      <th>bb</th>\n",
       "      <th>so</th>\n",
       "      <th>2b</th>\n",
       "      <th>3b</th>\n",
       "      <th>hr</th>\n",
       "      <th>ab</th>\n",
       "      <th>b/avg</th>\n",
       "      <th>wp</th>\n",
       "      <th>hbp</th>\n",
       "      <th>bk</th>\n",
       "      <th>FIP</th>\n",
       "      <th>WHIP</th>\n",
       "      <th>BABIP</th>\n",
       "      <th>SO/9</th>\n",
       "      <th>BB/9</th>\n",
       "      <th>HR/9</th>\n",
       "      <th>K/BB</th>\n",
       "      <th>K%</th>\n",
       "      <th>BB%</th>\n",
       "      <th>K%-BB%</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SILVA Elio E.</td>\n",
       "      <td>INA</td>\n",
       "      <td>2.01</td>\n",
       "      <td>6-0</td>\n",
       "      <td>7-7</td>\n",
       "      <td>4</td>\n",
       "      <td>2/1</td>\n",
       "      <td>0</td>\n",
       "      <td>58.1</td>\n",
       "      <td>41</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>17</td>\n",
       "      <td>98</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>213</td>\n",
       "      <td>192.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2.77</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.439</td>\n",
       "      <td>10.89</td>\n",
       "      <td>1.89</td>\n",
       "      <td>0.11</td>\n",
       "      <td>5.76</td>\n",
       "      <td>46.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>RIBEIRO Yulman A.</td>\n",
       "      <td>AST</td>\n",
       "      <td>2.10</td>\n",
       "      <td>3-0</td>\n",
       "      <td>9-3</td>\n",
       "      <td>1</td>\n",
       "      <td>0/0</td>\n",
       "      <td>1</td>\n",
       "      <td>30.0</td>\n",
       "      <td>21</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>35</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>110</td>\n",
       "      <td>191.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>4.07</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.329</td>\n",
       "      <td>3.89</td>\n",
       "      <td>0.33</td>\n",
       "      <td>0.22</td>\n",
       "      <td>11.67</td>\n",
       "      <td>31.8</td>\n",
       "      <td>2.7</td>\n",
       "      <td>29.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>TORRES Yosbany</td>\n",
       "      <td>AST</td>\n",
       "      <td>3.26</td>\n",
       "      <td>7-0</td>\n",
       "      <td>9-7</td>\n",
       "      <td>0</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>49.2</td>\n",
       "      <td>53</td>\n",
       "      <td>24</td>\n",
       "      <td>18</td>\n",
       "      <td>8</td>\n",
       "      <td>60</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>193</td>\n",
       "      <td>275.0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>3.76</td>\n",
       "      <td>1.24</td>\n",
       "      <td>0.427</td>\n",
       "      <td>6.67</td>\n",
       "      <td>0.89</td>\n",
       "      <td>0.22</td>\n",
       "      <td>7.50</td>\n",
       "      <td>31.1</td>\n",
       "      <td>4.1</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>MILIANI Eduardo</td>\n",
       "      <td>MAR</td>\n",
       "      <td>3.27</td>\n",
       "      <td>7-0</td>\n",
       "      <td>8-8</td>\n",
       "      <td>0</td>\n",
       "      <td>0/1</td>\n",
       "      <td>0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>46</td>\n",
       "      <td>22</td>\n",
       "      <td>16</td>\n",
       "      <td>11</td>\n",
       "      <td>49</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>174</td>\n",
       "      <td>264.0</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>5.71</td>\n",
       "      <td>1.30</td>\n",
       "      <td>0.420</td>\n",
       "      <td>5.44</td>\n",
       "      <td>1.22</td>\n",
       "      <td>0.67</td>\n",
       "      <td>4.45</td>\n",
       "      <td>28.2</td>\n",
       "      <td>6.3</td>\n",
       "      <td>21.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BALBOA Jorge</td>\n",
       "      <td>VIL</td>\n",
       "      <td>3.49</td>\n",
       "      <td>5-0</td>\n",
       "      <td>9-9</td>\n",
       "      <td>2</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>69.2</td>\n",
       "      <td>52</td>\n",
       "      <td>39</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>93</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>253</td>\n",
       "      <td>206.0</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>4.39</td>\n",
       "      <td>1.14</td>\n",
       "      <td>0.410</td>\n",
       "      <td>10.33</td>\n",
       "      <td>3.00</td>\n",
       "      <td>0.44</td>\n",
       "      <td>3.44</td>\n",
       "      <td>36.8</td>\n",
       "      <td>10.7</td>\n",
       "      <td>26.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>83</th>\n",
       "      <td>ALBES Ander</td>\n",
       "      <td>NAV</td>\n",
       "      <td>27.00</td>\n",
       "      <td>0-1</td>\n",
       "      <td>3-0</td>\n",
       "      <td>0</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>615.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13.94</td>\n",
       "      <td>5.50</td>\n",
       "      <td>0.800</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.33</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.67</td>\n",
       "      <td>15.4</td>\n",
       "      <td>23.1</td>\n",
       "      <td>-7.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>LACASA Jorge</td>\n",
       "      <td>MIR</td>\n",
       "      <td>31.50</td>\n",
       "      <td>0-0</td>\n",
       "      <td>1-0</td>\n",
       "      <td>0</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>400.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>11.94</td>\n",
       "      <td>3.50</td>\n",
       "      <td>0.750</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.33</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.67</td>\n",
       "      <td>20.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>-10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>TORRES Fidel</td>\n",
       "      <td>RIV</td>\n",
       "      <td>45.00</td>\n",
       "      <td>0-1</td>\n",
       "      <td>2-1</td>\n",
       "      <td>0</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>538.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>14.44</td>\n",
       "      <td>6.00</td>\n",
       "      <td>0.750</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.20</td>\n",
       "      <td>7.7</td>\n",
       "      <td>38.5</td>\n",
       "      <td>-30.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>MENDOZA Jefferson</td>\n",
       "      <td>MIR</td>\n",
       "      <td>54.00</td>\n",
       "      <td>0-0</td>\n",
       "      <td>3-0</td>\n",
       "      <td>0</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>500.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>38.94</td>\n",
       "      <td>7.00</td>\n",
       "      <td>0.667</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>-125.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>CHACON Earglind</td>\n",
       "      <td>MIR</td>\n",
       "      <td>81.00</td>\n",
       "      <td>0-1</td>\n",
       "      <td>3-0</td>\n",
       "      <td>0</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>750.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>17.94</td>\n",
       "      <td>11.00</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.20</td>\n",
       "      <td>12.5</td>\n",
       "      <td>62.5</td>\n",
       "      <td>-50.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>87 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               Player Equipo    era  w-l app-gs  cg  sho  sv    ip   h   r  \\\n",
       "0       SILVA Elio E.    INA   2.01  6-0    7-7   4  2/1   0  58.1  41  13   \n",
       "1   RIBEIRO Yulman A.    AST   2.10  3-0    9-3   1  0/0   1  30.0  21   8   \n",
       "2      TORRES Yosbany    AST   3.26  7-0    9-7   0  0/0   0  49.2  53  24   \n",
       "3     MILIANI Eduardo    MAR   3.27  7-0    8-8   0  0/1   0  44.0  46  22   \n",
       "4        BALBOA Jorge    VIL   3.49  5-0    9-9   2  0/0   0  69.2  52  39   \n",
       "..                ...    ...    ...  ...    ...  ..  ...  ..   ...  ..  ..   \n",
       "83        ALBES Ander    NAV  27.00  0-1    3-0   0  0/0   0   2.0   8   6   \n",
       "84       LACASA Jorge    MIR  31.50  0-0    1-0   0  0/0   0   2.0   4   7   \n",
       "85       TORRES Fidel    RIV  45.00  0-1    2-1   0  0/0   0   2.0   7  11   \n",
       "86  MENDOZA Jefferson    MIR  54.00  0-0    3-0   0  0/0   0   1.0   2   6   \n",
       "87    CHACON Earglind    MIR  81.00  0-1    3-0   0  0/0   0   1.0   6   9   \n",
       "\n",
       "    er  bb  so  2b  3b  hr   ab  b/avg  wp  hbp  bk    FIP   WHIP  BABIP  \\\n",
       "0   13  17  98   9   1   1  213  192.0   3    2   2   2.77   1.00  0.439   \n",
       "1    7   3  35   5   0   2  110  191.0   0    3   0   4.07   0.80  0.329   \n",
       "2   18   8  60   5   0   2  193  275.0   1    4   3   3.76   1.24  0.427   \n",
       "3   16  11  49   9   1   6  174  264.0   2    7   0   5.71   1.30  0.420   \n",
       "4   27  27  93  14   2   4  253  206.0  14    5   0   4.39   1.14  0.410   \n",
       "..  ..  ..  ..  ..  ..  ..  ...    ...  ..  ...  ..    ...    ...    ...   \n",
       "83   6   3   2   1   0   1   13  615.0   1    0   0  13.94   5.50  0.800   \n",
       "84   7   3   2   2   0   0   10  400.0   0    3   0  11.94   3.50  0.750   \n",
       "85  10   5   1   2   0   0   13  538.0   1    2   0  14.44   6.00  0.750   \n",
       "86   6   5   0   1   0   1    4  500.0   3    2   1  38.94   7.00  0.667   \n",
       "87   9   5   1   1   0   0    8  750.0   1    0   1  17.94  11.00  1.000   \n",
       "\n",
       "     SO/9  BB/9  HR/9   K/BB    K%    BB%  K%-BB%  \n",
       "0   10.89  1.89  0.11   5.76  46.0    8.0    38.0  \n",
       "1    3.89  0.33  0.22  11.67  31.8    2.7    29.1  \n",
       "2    6.67  0.89  0.22   7.50  31.1    4.1    27.0  \n",
       "3    5.44  1.22  0.67   4.45  28.2    6.3    21.9  \n",
       "4   10.33  3.00  0.44   3.44  36.8   10.7    26.1  \n",
       "..    ...   ...   ...    ...   ...    ...     ...  \n",
       "83   0.22  0.33  0.11   0.67  15.4   23.1    -7.7  \n",
       "84   0.22  0.33  0.00   0.67  20.0   30.0   -10.0  \n",
       "85   0.11  0.56  0.00   0.20   7.7   38.5   -30.8  \n",
       "86   0.00  0.56  0.11   0.00   0.0  125.0  -125.0  \n",
       "87   0.11  0.56  0.00   0.20  12.5   62.5   -50.0  \n",
       "\n",
       "[87 rows x 32 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dh_individual_pitching"
   ]
  }
 ],
 "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.8.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}