preprocessing.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# read data for fights and fighters\n",
    "bouts = pd.read_csv(\"ufc_bouts.csv\", index_col = 0)\n",
    "fighters = pd.read_csv(\"ufc_fighters.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Next, We will perform a series of steps to clean up the datasets."
   ]
  },
  {
   "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>event_name</th>\n",
       "      <th>date</th>\n",
       "      <th>location</th>\n",
       "      <th>attendance</th>\n",
       "      <th>result</th>\n",
       "      <th>fighter1</th>\n",
       "      <th>fighter2</th>\n",
       "      <th>winner</th>\n",
       "      <th>weight_class</th>\n",
       "      <th>title_fight</th>\n",
       "      <th>method</th>\n",
       "      <th>end_round</th>\n",
       "      <th>end_time</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bout_id</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>1</th>\n",
       "      <td>UFC Fight Night: Magny vs. Ponzinibbio</td>\n",
       "      <td>2018-11-17</td>\n",
       "      <td>Buenos Aires, Buenos Aires, Argentina</td>\n",
       "      <td>10245.0</td>\n",
       "      <td>win</td>\n",
       "      <td>Santiago Ponzinibbio</td>\n",
       "      <td>Neil Magny</td>\n",
       "      <td>Santiago Ponzinibbio</td>\n",
       "      <td>Welterweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO-Punch</td>\n",
       "      <td>4</td>\n",
       "      <td>2:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>UFC Fight Night: Magny vs. Ponzinibbio</td>\n",
       "      <td>2018-11-17</td>\n",
       "      <td>Buenos Aires, Buenos Aires, Argentina</td>\n",
       "      <td>10245.0</td>\n",
       "      <td>win</td>\n",
       "      <td>Ricardo Lamas</td>\n",
       "      <td>Darren Elkins</td>\n",
       "      <td>Ricardo Lamas</td>\n",
       "      <td>Featherweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO-Elbows</td>\n",
       "      <td>3</td>\n",
       "      <td>4:09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>UFC Fight Night: Magny vs. Ponzinibbio</td>\n",
       "      <td>2018-11-17</td>\n",
       "      <td>Buenos Aires, Buenos Aires, Argentina</td>\n",
       "      <td>10245.0</td>\n",
       "      <td>win</td>\n",
       "      <td>Johnny Walker</td>\n",
       "      <td>Khalil Rountree Jr.</td>\n",
       "      <td>Johnny Walker</td>\n",
       "      <td>Light Heavyweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO-Elbow</td>\n",
       "      <td>1</td>\n",
       "      <td>1:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>UFC Fight Night: Magny vs. Ponzinibbio</td>\n",
       "      <td>2018-11-17</td>\n",
       "      <td>Buenos Aires, Buenos Aires, Argentina</td>\n",
       "      <td>10245.0</td>\n",
       "      <td>win</td>\n",
       "      <td>Ian Heinisch</td>\n",
       "      <td>Cezar Ferreira</td>\n",
       "      <td>Ian Heinisch</td>\n",
       "      <td>Middleweight</td>\n",
       "      <td>f</td>\n",
       "      <td>DEC-Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>UFC Fight Night: Magny vs. Ponzinibbio</td>\n",
       "      <td>2018-11-17</td>\n",
       "      <td>Buenos Aires, Buenos Aires, Argentina</td>\n",
       "      <td>10245.0</td>\n",
       "      <td>win</td>\n",
       "      <td>Marlon Vera</td>\n",
       "      <td>Guido Cannetti</td>\n",
       "      <td>Marlon Vera</td>\n",
       "      <td>Bantamweight</td>\n",
       "      <td>f</td>\n",
       "      <td>SUB-Rear Naked Choke</td>\n",
       "      <td>2</td>\n",
       "      <td>1:31</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     event_name        date  \\\n",
       "bout_id                                                       \n",
       "1        UFC Fight Night: Magny vs. Ponzinibbio  2018-11-17   \n",
       "2        UFC Fight Night: Magny vs. Ponzinibbio  2018-11-17   \n",
       "3        UFC Fight Night: Magny vs. Ponzinibbio  2018-11-17   \n",
       "4        UFC Fight Night: Magny vs. Ponzinibbio  2018-11-17   \n",
       "5        UFC Fight Night: Magny vs. Ponzinibbio  2018-11-17   \n",
       "\n",
       "                                      location  attendance  result  \\\n",
       "bout_id                                                              \n",
       "1        Buenos Aires, Buenos Aires, Argentina      10245.0    win   \n",
       "2        Buenos Aires, Buenos Aires, Argentina      10245.0    win   \n",
       "3        Buenos Aires, Buenos Aires, Argentina      10245.0    win   \n",
       "4        Buenos Aires, Buenos Aires, Argentina      10245.0    win   \n",
       "5        Buenos Aires, Buenos Aires, Argentina      10245.0    win   \n",
       "\n",
       "                     fighter1             fighter2                winner  \\\n",
       "bout_id                                                                    \n",
       "1        Santiago Ponzinibbio           Neil Magny  Santiago Ponzinibbio   \n",
       "2               Ricardo Lamas        Darren Elkins         Ricardo Lamas   \n",
       "3               Johnny Walker  Khalil Rountree Jr.         Johnny Walker   \n",
       "4                Ian Heinisch       Cezar Ferreira          Ian Heinisch   \n",
       "5                 Marlon Vera       Guido Cannetti           Marlon Vera   \n",
       "\n",
       "              weight_class title_fight                method  end_round  \\\n",
       "bout_id                                                                   \n",
       "1             Welterweight           f          KO/TKO-Punch          4   \n",
       "2            Featherweight           f         KO/TKO-Elbows          3   \n",
       "3        Light Heavyweight           f          KO/TKO-Elbow          1   \n",
       "4             Middleweight           f         DEC-Unanimous          3   \n",
       "5             Bantamweight           f  SUB-Rear Naked Choke          2   \n",
       "\n",
       "        end_time  \n",
       "bout_id           \n",
       "1           2:36  \n",
       "2           4:09  \n",
       "3           1:57  \n",
       "4           5:00  \n",
       "5           1:31  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bouts.head()"
   ]
  },
  {
   "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>fighter_id</th>\n",
       "      <th>name</th>\n",
       "      <th>win</th>\n",
       "      <th>lose</th>\n",
       "      <th>draw</th>\n",
       "      <th>nc</th>\n",
       "      <th>height</th>\n",
       "      <th>weight</th>\n",
       "      <th>reach</th>\n",
       "      <th>stance</th>\n",
       "      <th>dob</th>\n",
       "      <th>SLpM</th>\n",
       "      <th>Str_Acc</th>\n",
       "      <th>SApM</th>\n",
       "      <th>Str_Def</th>\n",
       "      <th>TD_Avg</th>\n",
       "      <th>TD_Acc</th>\n",
       "      <th>TD_Def</th>\n",
       "      <th>Sub_Avg</th>\n",
       "      <th>last_updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Luciano Azevedo</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6' 3\"</td>\n",
       "      <td>161 lbs.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Jun 25, 1981</td>\n",
       "      <td>0.76</td>\n",
       "      <td>45%</td>\n",
       "      <td>1.97</td>\n",
       "      <td>27%</td>\n",
       "      <td>2.28</td>\n",
       "      <td>11%</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 19:35:04.893952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Michael Byrnes</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5' 11\"</td>\n",
       "      <td>155 lbs.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jul 17, 1990</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0%</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 19:35:09.304165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Gleidson Cutis</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5' 9\"</td>\n",
       "      <td>155 lbs.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Feb 07, 1989</td>\n",
       "      <td>2.99</td>\n",
       "      <td>52%</td>\n",
       "      <td>8.28</td>\n",
       "      <td>59%</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0%</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 19:35:11.211072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Rolando Dy</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5' 8\"</td>\n",
       "      <td>145 lbs.</td>\n",
       "      <td>69\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Aug 11, 1990</td>\n",
       "      <td>3.04</td>\n",
       "      <td>37%</td>\n",
       "      <td>4.47</td>\n",
       "      <td>52%</td>\n",
       "      <td>0.30</td>\n",
       "      <td>20%</td>\n",
       "      <td>68%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 19:35:14.677808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Jessica Eye</td>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5' 6\"</td>\n",
       "      <td>125 lbs.</td>\n",
       "      <td>66\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Jul 27, 1986</td>\n",
       "      <td>3.42</td>\n",
       "      <td>36%</td>\n",
       "      <td>3.32</td>\n",
       "      <td>59%</td>\n",
       "      <td>0.59</td>\n",
       "      <td>71%</td>\n",
       "      <td>60%</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2018-11-21 19:35:17.495278</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   fighter_id             name  win  lose  draw  nc  height    weight reach  \\\n",
       "0           1  Luciano Azevedo   16     9     1   0   6' 3\"  161 lbs.   NaN   \n",
       "1           2   Michael Byrnes    5     2     0   0  5' 11\"  155 lbs.   NaN   \n",
       "2           3   Gleidson Cutis    7     3     0   0   5' 9\"  155 lbs.   NaN   \n",
       "3           4       Rolando Dy    9     7     1   1   5' 8\"  145 lbs.   69\"   \n",
       "4           5      Jessica Eye   13     6     0   1   5' 6\"  125 lbs.   66\"   \n",
       "\n",
       "     stance           dob  SLpM Str_Acc  SApM Str_Def  TD_Avg TD_Acc TD_Def  \\\n",
       "0  Orthodox  Jun 25, 1981  0.76     45%  1.97     27%    2.28    11%     0%   \n",
       "1       NaN  Jul 17, 1990  0.00      0%  0.00      0%    0.00     0%     0%   \n",
       "2  Orthodox  Feb 07, 1989  2.99     52%  8.28     59%    0.00     0%     0%   \n",
       "3  Orthodox  Aug 11, 1990  3.04     37%  4.47     52%    0.30    20%    68%   \n",
       "4  Orthodox  Jul 27, 1986  3.42     36%  3.32     59%    0.59    71%    60%   \n",
       "\n",
       "   Sub_Avg                last_updated  \n",
       "0      0.0  2018-11-21 19:35:04.893952  \n",
       "1      0.0  2018-11-21 19:35:09.304165  \n",
       "2      0.0  2018-11-21 19:35:11.211072  \n",
       "3      0.0  2018-11-21 19:35:14.677808  \n",
       "4      0.8  2018-11-21 19:35:17.495278  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fighters.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>fighter_id</th>\n",
       "      <th>name</th>\n",
       "      <th>win</th>\n",
       "      <th>lose</th>\n",
       "      <th>draw</th>\n",
       "      <th>nc</th>\n",
       "      <th>height</th>\n",
       "      <th>weight</th>\n",
       "      <th>reach</th>\n",
       "      <th>stance</th>\n",
       "      <th>dob</th>\n",
       "      <th>SLpM</th>\n",
       "      <th>Str_Acc</th>\n",
       "      <th>SApM</th>\n",
       "      <th>Str_Def</th>\n",
       "      <th>TD_Avg</th>\n",
       "      <th>TD_Acc</th>\n",
       "      <th>TD_Def</th>\n",
       "      <th>Sub_Avg</th>\n",
       "      <th>last_updated</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>511</th>\n",
       "      <td>512</td>\n",
       "      <td>Michael McDonald</td>\n",
       "      <td>17</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5' 9\"</td>\n",
       "      <td>135 lbs.</td>\n",
       "      <td>70\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Jan 15, 1991</td>\n",
       "      <td>2.69</td>\n",
       "      <td>42%</td>\n",
       "      <td>2.76</td>\n",
       "      <td>57%</td>\n",
       "      <td>1.09</td>\n",
       "      <td>66%</td>\n",
       "      <td>52%</td>\n",
       "      <td>1.4</td>\n",
       "      <td>2018-11-21 20:06:32.497948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>513</th>\n",
       "      <td>514</td>\n",
       "      <td>Michael McDonald</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5' 11\"</td>\n",
       "      <td>205 lbs.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Feb 06, 1965</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.40</td>\n",
       "      <td>50%</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0%</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 20:06:39.825372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>845</th>\n",
       "      <td>845</td>\n",
       "      <td>Dong Hyun Kim</td>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>5' 11\"</td>\n",
       "      <td>155 lbs.</td>\n",
       "      <td>70\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Sep 09, 1988</td>\n",
       "      <td>3.77</td>\n",
       "      <td>45%</td>\n",
       "      <td>4.53</td>\n",
       "      <td>53%</td>\n",
       "      <td>1.67</td>\n",
       "      <td>60%</td>\n",
       "      <td>33%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 20:26:57.805101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>852</th>\n",
       "      <td>852</td>\n",
       "      <td>Dong Hyun Kim</td>\n",
       "      <td>22</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6' 2\"</td>\n",
       "      <td>170 lbs.</td>\n",
       "      <td>76\"</td>\n",
       "      <td>Southpaw</td>\n",
       "      <td>Nov 17, 1981</td>\n",
       "      <td>2.12</td>\n",
       "      <td>49%</td>\n",
       "      <td>1.89</td>\n",
       "      <td>58%</td>\n",
       "      <td>2.93</td>\n",
       "      <td>43%</td>\n",
       "      <td>71%</td>\n",
       "      <td>0.6</td>\n",
       "      <td>2018-11-21 20:27:20.82459</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>946</th>\n",
       "      <td>947</td>\n",
       "      <td>Tony Johnson</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6' 1\"</td>\n",
       "      <td>265 lbs.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.00</td>\n",
       "      <td>53%</td>\n",
       "      <td>4.73</td>\n",
       "      <td>31%</td>\n",
       "      <td>2.00</td>\n",
       "      <td>22%</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 20:33:09.727428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>954</th>\n",
       "      <td>955</td>\n",
       "      <td>Tony Johnson</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>185 lbs.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0%</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 20:33:41.289451</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1674</th>\n",
       "      <td>1674</td>\n",
       "      <td>Mike Davis</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6' 0\"</td>\n",
       "      <td>145 lbs.</td>\n",
       "      <td>72\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Oct 07, 1992</td>\n",
       "      <td>5.13</td>\n",
       "      <td>49%</td>\n",
       "      <td>7.40</td>\n",
       "      <td>48%</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0%</td>\n",
       "      <td>100%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 21:17:43.856431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1679</th>\n",
       "      <td>1679</td>\n",
       "      <td>Mike Davis</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0%</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 21:18:02.161503</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      fighter_id              name  win  lose  draw  nc  height    weight  \\\n",
       "511          512  Michael McDonald   17     4     0   0   5' 9\"  135 lbs.   \n",
       "513          514  Michael McDonald    1     1     0   0  5' 11\"  205 lbs.   \n",
       "845          845     Dong Hyun Kim   16     8     3   0  5' 11\"  155 lbs.   \n",
       "852          852     Dong Hyun Kim   22     4     1   1   6' 2\"  170 lbs.   \n",
       "946          947      Tony Johnson   11     3     0   0   6' 1\"  265 lbs.   \n",
       "954          955      Tony Johnson    4     2     0   0     NaN  185 lbs.   \n",
       "1674        1674        Mike Davis    5     1     0   0   6' 0\"  145 lbs.   \n",
       "1679        1679        Mike Davis    2     0     0   0     NaN       NaN   \n",
       "\n",
       "     reach    stance           dob  SLpM Str_Acc  SApM Str_Def  TD_Avg TD_Acc  \\\n",
       "511    70\"  Orthodox  Jan 15, 1991  2.69     42%  2.76     57%    1.09    66%   \n",
       "513    NaN  Orthodox  Feb 06, 1965  0.00      0%  0.40     50%    0.00     0%   \n",
       "845    70\"  Orthodox  Sep 09, 1988  3.77     45%  4.53     53%    1.67    60%   \n",
       "852    76\"  Southpaw  Nov 17, 1981  2.12     49%  1.89     58%    2.93    43%   \n",
       "946    NaN       NaN           NaN  2.00     53%  4.73     31%    2.00    22%   \n",
       "954    NaN       NaN           NaN  0.00      0%  0.00      0%    0.00     0%   \n",
       "1674   72\"  Orthodox  Oct 07, 1992  5.13     49%  7.40     48%    0.00     0%   \n",
       "1679   NaN       NaN           NaN  0.00      0%  0.00      0%    0.00     0%   \n",
       "\n",
       "     TD_Def  Sub_Avg                last_updated  \n",
       "511     52%      1.4  2018-11-21 20:06:32.497948  \n",
       "513      0%      0.0  2018-11-21 20:06:39.825372  \n",
       "845     33%      0.0  2018-11-21 20:26:57.805101  \n",
       "852     71%      0.6   2018-11-21 20:27:20.82459  \n",
       "946      0%      0.0  2018-11-21 20:33:09.727428  \n",
       "954      0%      0.0  2018-11-21 20:33:41.289451  \n",
       "1674   100%      0.0  2018-11-21 21:17:43.856431  \n",
       "1679     0%      0.0  2018-11-21 21:18:02.161503  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# check if there are fighters with the same name\n",
    "fighters[fighters.duplicated(subset=\"name\", keep=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# note that we have several fighters who have the same names\n",
    "# Fortunately, they belong to different weight classes\n",
    "fighters.iloc[513, 1] = \"Michael McDonald 205\"\n",
    "fighters.iloc[845, 1] = \"Dong Hyun Kim 155\"\n",
    "fighters.iloc[954, 1] = \"Tony Johnson 185\"\n",
    "fighters.iloc[1674, 1] = \"Mike Davis 145\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# use fighter names as index\n",
    "fighters.drop(\"fighter_id\", axis=1, inplace=True)\n",
    "fighters.set_index(\"name\", inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Some fighters do not have statistics available, and we will remove those fighters.\n",
    "fighers_clean = fighters.loc[~((fighters[\"SLpM\"] == 0) &\n",
    "                               (fighters[\"Str_Acc\"] == \"0%\") & \n",
    "                               (fighters[\"SApM\"] == 0) &\n",
    "                               (fighters[\"Str_Def\"] == \"0%\") &\n",
    "                               (fighters[\"TD_Avg\"] == 0) &\n",
    "                               (fighters[\"TD_Acc\"] == \"0%\") &\n",
    "                               (fighters[\"TD_Def\"] == \"0%\") &\n",
    "                               (fighters[\"Sub_Avg\"] == 0))].copy()                        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3187 fighers in total, after clean up: 2559 fighers\n"
     ]
    }
   ],
   "source": [
    "print(\"{0} fighers in total, after clean up: {1} fighers\".format(len(fighters), len(fighers_clean)))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Note:\n",
    "* SLpM - Significant Strikes Landed per Minute\n",
    "* Str_Acc - Significant Striking Accuracy\n",
    "* SApM - Significant Strikes Absorbed per Minute\n",
    "* Str_Def - Significant Strike Defence (the % of opponents strikes that did not land)\n",
    "* TD_Avg - Average Takedowns Landed per 15 minutes\n",
    "* TD_Acc - Takedown Accuracy\n",
    "* TD_Def - Takedown Defense (the % of opponents TD attempts that did not land)\n",
    "* Sub_Avg - Average Submissions Attempted per 15 minutes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# add winning percentages\n",
    "fighers_clean[\"win%\"] = 100 * (fighers_clean[\"win\"] / (fighers_clean[\"win\"] +\n",
    "                                                 fighers_clean[\"lose\"] +\n",
    "                                                 fighers_clean[\"draw\"] +\n",
    "                                                 fighers_clean[\"nc\"]))\n",
    "# change datatypes\n",
    "percentages = [\"Str_Acc\", \"Str_Def\", \"TD_Acc\", \"TD_Def\"]\n",
    "statistics = [\"SLpM\", \"Str_Acc\", \"SApM\", \"Str_Def\", \"TD_Avg\", \"TD_Acc\", \"TD_Def\", \"Sub_Avg\", \"win%\"]\n",
    "\n",
    "fighers_clean.loc[:, percentages] = fighers_clean.loc[:, percentages].applymap(\n",
    "    lambda x: x.replace(\"%\", \"\"))\n",
    "\n",
    "fighers_clean.loc[:, statistics] = fighers_clean.loc[:, statistics].astype(np.float32)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>win</th>\n",
       "      <th>lose</th>\n",
       "      <th>draw</th>\n",
       "      <th>nc</th>\n",
       "      <th>height</th>\n",
       "      <th>weight</th>\n",
       "      <th>reach</th>\n",
       "      <th>stance</th>\n",
       "      <th>dob</th>\n",
       "      <th>SLpM</th>\n",
       "      <th>Str_Acc</th>\n",
       "      <th>SApM</th>\n",
       "      <th>Str_Def</th>\n",
       "      <th>TD_Avg</th>\n",
       "      <th>TD_Acc</th>\n",
       "      <th>TD_Def</th>\n",
       "      <th>Sub_Avg</th>\n",
       "      <th>last_updated</th>\n",
       "      <th>win%</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</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>Luciano Azevedo</th>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6' 3\"</td>\n",
       "      <td>161 lbs.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Jun 25, 1981</td>\n",
       "      <td>0.76</td>\n",
       "      <td>45.0</td>\n",
       "      <td>1.97</td>\n",
       "      <td>27.0</td>\n",
       "      <td>2.28</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 19:35:04.893952</td>\n",
       "      <td>61.53846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gleidson Cutis</th>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5' 9\"</td>\n",
       "      <td>155 lbs.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Feb 07, 1989</td>\n",
       "      <td>2.99</td>\n",
       "      <td>52.0</td>\n",
       "      <td>8.28</td>\n",
       "      <td>59.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 19:35:11.211072</td>\n",
       "      <td>70.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rolando Dy</th>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5' 8\"</td>\n",
       "      <td>145 lbs.</td>\n",
       "      <td>69\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Aug 11, 1990</td>\n",
       "      <td>3.04</td>\n",
       "      <td>37.0</td>\n",
       "      <td>4.47</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.30</td>\n",
       "      <td>20.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 19:35:14.677808</td>\n",
       "      <td>50.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jessica Eye</th>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5' 6\"</td>\n",
       "      <td>125 lbs.</td>\n",
       "      <td>66\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Jul 27, 1986</td>\n",
       "      <td>3.42</td>\n",
       "      <td>36.0</td>\n",
       "      <td>3.32</td>\n",
       "      <td>59.0</td>\n",
       "      <td>0.59</td>\n",
       "      <td>71.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2018-11-21 19:35:17.495278</td>\n",
       "      <td>65.00000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Katsuaki Furuki</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6' 0\"</td>\n",
       "      <td>168 lbs.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nov 10, 1980</td>\n",
       "      <td>0.27</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.67</td>\n",
       "      <td>39.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2018-11-21 19:35:21.053769</td>\n",
       "      <td>50.00000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 win  lose  draw  nc height    weight reach    stance  \\\n",
       "name                                                                    \n",
       "Luciano Azevedo   16     9     1   0  6' 3\"  161 lbs.   NaN  Orthodox   \n",
       "Gleidson Cutis     7     3     0   0  5' 9\"  155 lbs.   NaN  Orthodox   \n",
       "Rolando Dy         9     7     1   1  5' 8\"  145 lbs.   69\"  Orthodox   \n",
       "Jessica Eye       13     6     0   1  5' 6\"  125 lbs.   66\"  Orthodox   \n",
       "Katsuaki Furuki    1     1     0   0  6' 0\"  168 lbs.   NaN       NaN   \n",
       "\n",
       "                          dob  SLpM  Str_Acc  SApM  Str_Def  TD_Avg  TD_Acc  \\\n",
       "name                                                                          \n",
       "Luciano Azevedo  Jun 25, 1981  0.76     45.0  1.97     27.0    2.28    11.0   \n",
       "Gleidson Cutis   Feb 07, 1989  2.99     52.0  8.28     59.0    0.00     0.0   \n",
       "Rolando Dy       Aug 11, 1990  3.04     37.0  4.47     52.0    0.30    20.0   \n",
       "Jessica Eye      Jul 27, 1986  3.42     36.0  3.32     59.0    0.59    71.0   \n",
       "Katsuaki Furuki  Nov 10, 1980  0.27     10.0  2.67     39.0    0.00     0.0   \n",
       "\n",
       "                 TD_Def  Sub_Avg                last_updated      win%  \n",
       "name                                                                    \n",
       "Luciano Azevedo     0.0      0.0  2018-11-21 19:35:04.893952  61.53846  \n",
       "Gleidson Cutis      0.0      0.0  2018-11-21 19:35:11.211072  70.00000  \n",
       "Rolando Dy         68.0      0.0  2018-11-21 19:35:14.677808  50.00000  \n",
       "Jessica Eye        60.0      0.8  2018-11-21 19:35:17.495278  65.00000  \n",
       "Katsuaki Furuki     0.0      3.0  2018-11-21 19:35:21.053769  50.00000  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fighers_clean.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# use born year only\n",
    "def get_year(dob):\n",
    "    if pd.isna(dob):\n",
    "        return \"unk\"\n",
    "    return dob.split(\", \")[-1]\n",
    "\n",
    "fighers_clean[\"born_year\"] = fighers_clean[\"dob\"].map(lambda dob: get_year(dob))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>win</th>\n",
       "      <th>lose</th>\n",
       "      <th>draw</th>\n",
       "      <th>nc</th>\n",
       "      <th>height</th>\n",
       "      <th>weight</th>\n",
       "      <th>reach</th>\n",
       "      <th>stance</th>\n",
       "      <th>dob</th>\n",
       "      <th>SLpM</th>\n",
       "      <th>Str_Acc</th>\n",
       "      <th>SApM</th>\n",
       "      <th>Str_Def</th>\n",
       "      <th>TD_Avg</th>\n",
       "      <th>TD_Acc</th>\n",
       "      <th>TD_Def</th>\n",
       "      <th>Sub_Avg</th>\n",
       "      <th>last_updated</th>\n",
       "      <th>win%</th>\n",
       "      <th>born_year</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</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>Luciano Azevedo</th>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6' 3\"</td>\n",
       "      <td>161 lbs.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Jun 25, 1981</td>\n",
       "      <td>0.76</td>\n",
       "      <td>45.0</td>\n",
       "      <td>1.97</td>\n",
       "      <td>27.0</td>\n",
       "      <td>2.28</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 19:35:04.893952</td>\n",
       "      <td>61.53846</td>\n",
       "      <td>1981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gleidson Cutis</th>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5' 9\"</td>\n",
       "      <td>155 lbs.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Feb 07, 1989</td>\n",
       "      <td>2.99</td>\n",
       "      <td>52.0</td>\n",
       "      <td>8.28</td>\n",
       "      <td>59.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 19:35:11.211072</td>\n",
       "      <td>70.00000</td>\n",
       "      <td>1989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rolando Dy</th>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5' 8\"</td>\n",
       "      <td>145 lbs.</td>\n",
       "      <td>69\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Aug 11, 1990</td>\n",
       "      <td>3.04</td>\n",
       "      <td>37.0</td>\n",
       "      <td>4.47</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.30</td>\n",
       "      <td>20.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-11-21 19:35:14.677808</td>\n",
       "      <td>50.00000</td>\n",
       "      <td>1990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jessica Eye</th>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5' 6\"</td>\n",
       "      <td>125 lbs.</td>\n",
       "      <td>66\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>Jul 27, 1986</td>\n",
       "      <td>3.42</td>\n",
       "      <td>36.0</td>\n",
       "      <td>3.32</td>\n",
       "      <td>59.0</td>\n",
       "      <td>0.59</td>\n",
       "      <td>71.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2018-11-21 19:35:17.495278</td>\n",
       "      <td>65.00000</td>\n",
       "      <td>1986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Katsuaki Furuki</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6' 0\"</td>\n",
       "      <td>168 lbs.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nov 10, 1980</td>\n",
       "      <td>0.27</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.67</td>\n",
       "      <td>39.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2018-11-21 19:35:21.053769</td>\n",
       "      <td>50.00000</td>\n",
       "      <td>1980</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 win  lose  draw  nc height    weight reach    stance  \\\n",
       "name                                                                    \n",
       "Luciano Azevedo   16     9     1   0  6' 3\"  161 lbs.   NaN  Orthodox   \n",
       "Gleidson Cutis     7     3     0   0  5' 9\"  155 lbs.   NaN  Orthodox   \n",
       "Rolando Dy         9     7     1   1  5' 8\"  145 lbs.   69\"  Orthodox   \n",
       "Jessica Eye       13     6     0   1  5' 6\"  125 lbs.   66\"  Orthodox   \n",
       "Katsuaki Furuki    1     1     0   0  6' 0\"  168 lbs.   NaN       NaN   \n",
       "\n",
       "                          dob  SLpM  Str_Acc  SApM  Str_Def  TD_Avg  TD_Acc  \\\n",
       "name                                                                          \n",
       "Luciano Azevedo  Jun 25, 1981  0.76     45.0  1.97     27.0    2.28    11.0   \n",
       "Gleidson Cutis   Feb 07, 1989  2.99     52.0  8.28     59.0    0.00     0.0   \n",
       "Rolando Dy       Aug 11, 1990  3.04     37.0  4.47     52.0    0.30    20.0   \n",
       "Jessica Eye      Jul 27, 1986  3.42     36.0  3.32     59.0    0.59    71.0   \n",
       "Katsuaki Furuki  Nov 10, 1980  0.27     10.0  2.67     39.0    0.00     0.0   \n",
       "\n",
       "                 TD_Def  Sub_Avg                last_updated      win%  \\\n",
       "name                                                                     \n",
       "Luciano Azevedo     0.0      0.0  2018-11-21 19:35:04.893952  61.53846   \n",
       "Gleidson Cutis      0.0      0.0  2018-11-21 19:35:11.211072  70.00000   \n",
       "Rolando Dy         68.0      0.0  2018-11-21 19:35:14.677808  50.00000   \n",
       "Jessica Eye        60.0      0.8  2018-11-21 19:35:17.495278  65.00000   \n",
       "Katsuaki Furuki     0.0      3.0  2018-11-21 19:35:21.053769  50.00000   \n",
       "\n",
       "                born_year  \n",
       "name                       \n",
       "Luciano Azevedo      1981  \n",
       "Gleidson Cutis       1989  \n",
       "Rolando Dy           1990  \n",
       "Jessica Eye          1986  \n",
       "Katsuaki Furuki      1980  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fighers_clean.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# remove unused columns\n",
    "fighers_clean.drop([\"weight\", \"dob\", \"last_updated\"], inplace=True, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>win</th>\n",
       "      <th>lose</th>\n",
       "      <th>draw</th>\n",
       "      <th>nc</th>\n",
       "      <th>height</th>\n",
       "      <th>reach</th>\n",
       "      <th>stance</th>\n",
       "      <th>SLpM</th>\n",
       "      <th>Str_Acc</th>\n",
       "      <th>SApM</th>\n",
       "      <th>Str_Def</th>\n",
       "      <th>TD_Avg</th>\n",
       "      <th>TD_Acc</th>\n",
       "      <th>TD_Def</th>\n",
       "      <th>Sub_Avg</th>\n",
       "      <th>win%</th>\n",
       "      <th>born_year</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</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>Luciano Azevedo</th>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6' 3\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>0.76</td>\n",
       "      <td>45.0</td>\n",
       "      <td>1.97</td>\n",
       "      <td>27.0</td>\n",
       "      <td>2.28</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>61.53846</td>\n",
       "      <td>1981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gleidson Cutis</th>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5' 9\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>2.99</td>\n",
       "      <td>52.0</td>\n",
       "      <td>8.28</td>\n",
       "      <td>59.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70.00000</td>\n",
       "      <td>1989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rolando Dy</th>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5' 8\"</td>\n",
       "      <td>69\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>3.04</td>\n",
       "      <td>37.0</td>\n",
       "      <td>4.47</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.30</td>\n",
       "      <td>20.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.00000</td>\n",
       "      <td>1990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jessica Eye</th>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5' 6\"</td>\n",
       "      <td>66\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>3.42</td>\n",
       "      <td>36.0</td>\n",
       "      <td>3.32</td>\n",
       "      <td>59.0</td>\n",
       "      <td>0.59</td>\n",
       "      <td>71.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>65.00000</td>\n",
       "      <td>1986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Katsuaki Furuki</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6' 0\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.27</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.67</td>\n",
       "      <td>39.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>50.00000</td>\n",
       "      <td>1980</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 win  lose  draw  nc height reach    stance  SLpM  Str_Acc  \\\n",
       "name                                                                         \n",
       "Luciano Azevedo   16     9     1   0  6' 3\"   NaN  Orthodox  0.76     45.0   \n",
       "Gleidson Cutis     7     3     0   0  5' 9\"   NaN  Orthodox  2.99     52.0   \n",
       "Rolando Dy         9     7     1   1  5' 8\"   69\"  Orthodox  3.04     37.0   \n",
       "Jessica Eye       13     6     0   1  5' 6\"   66\"  Orthodox  3.42     36.0   \n",
       "Katsuaki Furuki    1     1     0   0  6' 0\"   NaN       NaN  0.27     10.0   \n",
       "\n",
       "                 SApM  Str_Def  TD_Avg  TD_Acc  TD_Def  Sub_Avg      win%  \\\n",
       "name                                                                        \n",
       "Luciano Azevedo  1.97     27.0    2.28    11.0     0.0      0.0  61.53846   \n",
       "Gleidson Cutis   8.28     59.0    0.00     0.0     0.0      0.0  70.00000   \n",
       "Rolando Dy       4.47     52.0    0.30    20.0    68.0      0.0  50.00000   \n",
       "Jessica Eye      3.32     59.0    0.59    71.0    60.0      0.8  65.00000   \n",
       "Katsuaki Furuki  2.67     39.0    0.00     0.0     0.0      3.0  50.00000   \n",
       "\n",
       "                born_year  \n",
       "name                       \n",
       "Luciano Azevedo      1981  \n",
       "Gleidson Cutis       1989  \n",
       "Rolando Dy           1990  \n",
       "Jessica Eye          1986  \n",
       "Katsuaki Furuki      1980  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fighers_clean.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now, let's work on the fights dataset."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>event_name</th>\n",
       "      <th>date</th>\n",
       "      <th>location</th>\n",
       "      <th>attendance</th>\n",
       "      <th>result</th>\n",
       "      <th>fighter1</th>\n",
       "      <th>fighter2</th>\n",
       "      <th>winner</th>\n",
       "      <th>weight_class</th>\n",
       "      <th>title_fight</th>\n",
       "      <th>method</th>\n",
       "      <th>end_round</th>\n",
       "      <th>end_time</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bout_id</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>1</th>\n",
       "      <td>UFC Fight Night: Magny vs. Ponzinibbio</td>\n",
       "      <td>2018-11-17</td>\n",
       "      <td>Buenos Aires, Buenos Aires, Argentina</td>\n",
       "      <td>10245.0</td>\n",
       "      <td>win</td>\n",
       "      <td>Santiago Ponzinibbio</td>\n",
       "      <td>Neil Magny</td>\n",
       "      <td>Santiago Ponzinibbio</td>\n",
       "      <td>Welterweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO-Punch</td>\n",
       "      <td>4</td>\n",
       "      <td>2:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>UFC Fight Night: Magny vs. Ponzinibbio</td>\n",
       "      <td>2018-11-17</td>\n",
       "      <td>Buenos Aires, Buenos Aires, Argentina</td>\n",
       "      <td>10245.0</td>\n",
       "      <td>win</td>\n",
       "      <td>Ricardo Lamas</td>\n",
       "      <td>Darren Elkins</td>\n",
       "      <td>Ricardo Lamas</td>\n",
       "      <td>Featherweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO-Elbows</td>\n",
       "      <td>3</td>\n",
       "      <td>4:09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>UFC Fight Night: Magny vs. Ponzinibbio</td>\n",
       "      <td>2018-11-17</td>\n",
       "      <td>Buenos Aires, Buenos Aires, Argentina</td>\n",
       "      <td>10245.0</td>\n",
       "      <td>win</td>\n",
       "      <td>Johnny Walker</td>\n",
       "      <td>Khalil Rountree Jr.</td>\n",
       "      <td>Johnny Walker</td>\n",
       "      <td>Light Heavyweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO-Elbow</td>\n",
       "      <td>1</td>\n",
       "      <td>1:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>UFC Fight Night: Magny vs. Ponzinibbio</td>\n",
       "      <td>2018-11-17</td>\n",
       "      <td>Buenos Aires, Buenos Aires, Argentina</td>\n",
       "      <td>10245.0</td>\n",
       "      <td>win</td>\n",
       "      <td>Ian Heinisch</td>\n",
       "      <td>Cezar Ferreira</td>\n",
       "      <td>Ian Heinisch</td>\n",
       "      <td>Middleweight</td>\n",
       "      <td>f</td>\n",
       "      <td>DEC-Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>UFC Fight Night: Magny vs. Ponzinibbio</td>\n",
       "      <td>2018-11-17</td>\n",
       "      <td>Buenos Aires, Buenos Aires, Argentina</td>\n",
       "      <td>10245.0</td>\n",
       "      <td>win</td>\n",
       "      <td>Marlon Vera</td>\n",
       "      <td>Guido Cannetti</td>\n",
       "      <td>Marlon Vera</td>\n",
       "      <td>Bantamweight</td>\n",
       "      <td>f</td>\n",
       "      <td>SUB-Rear Naked Choke</td>\n",
       "      <td>2</td>\n",
       "      <td>1:31</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     event_name        date  \\\n",
       "bout_id                                                       \n",
       "1        UFC Fight Night: Magny vs. Ponzinibbio  2018-11-17   \n",
       "2        UFC Fight Night: Magny vs. Ponzinibbio  2018-11-17   \n",
       "3        UFC Fight Night: Magny vs. Ponzinibbio  2018-11-17   \n",
       "4        UFC Fight Night: Magny vs. Ponzinibbio  2018-11-17   \n",
       "5        UFC Fight Night: Magny vs. Ponzinibbio  2018-11-17   \n",
       "\n",
       "                                      location  attendance  result  \\\n",
       "bout_id                                                              \n",
       "1        Buenos Aires, Buenos Aires, Argentina      10245.0    win   \n",
       "2        Buenos Aires, Buenos Aires, Argentina      10245.0    win   \n",
       "3        Buenos Aires, Buenos Aires, Argentina      10245.0    win   \n",
       "4        Buenos Aires, Buenos Aires, Argentina      10245.0    win   \n",
       "5        Buenos Aires, Buenos Aires, Argentina      10245.0    win   \n",
       "\n",
       "                     fighter1             fighter2                winner  \\\n",
       "bout_id                                                                    \n",
       "1        Santiago Ponzinibbio           Neil Magny  Santiago Ponzinibbio   \n",
       "2               Ricardo Lamas        Darren Elkins         Ricardo Lamas   \n",
       "3               Johnny Walker  Khalil Rountree Jr.         Johnny Walker   \n",
       "4                Ian Heinisch       Cezar Ferreira          Ian Heinisch   \n",
       "5                 Marlon Vera       Guido Cannetti           Marlon Vera   \n",
       "\n",
       "              weight_class title_fight                method  end_round  \\\n",
       "bout_id                                                                   \n",
       "1             Welterweight           f          KO/TKO-Punch          4   \n",
       "2            Featherweight           f         KO/TKO-Elbows          3   \n",
       "3        Light Heavyweight           f          KO/TKO-Elbow          1   \n",
       "4             Middleweight           f         DEC-Unanimous          3   \n",
       "5             Bantamweight           f  SUB-Rear Naked Choke          2   \n",
       "\n",
       "        end_time  \n",
       "bout_id           \n",
       "1           2:36  \n",
       "2           4:09  \n",
       "3           1:57  \n",
       "4           5:00  \n",
       "5           1:31  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bouts.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "win     4796\n",
       "nc        48\n",
       "draw      34\n",
       "Name: result, dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bouts[\"result\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "# use matches that have a winner, ignore nc, draws\n",
    "bouts = bouts.loc[bouts[\"result\"] == \"win\"].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "bouts[\"fight_year\"] = bouts[\"date\"].map(lambda d: d[:4])\n",
    "bouts[\"method\"] = bouts[\"method\"].map(lambda m: m.split(\"-\")[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "# remove unused columns\n",
    "bouts.drop([\"event_name\", \"date\", \"location\", \"attendance \", \"result\", \"end_time\"],\n",
    "          axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>fighter1</th>\n",
       "      <th>fighter2</th>\n",
       "      <th>winner</th>\n",
       "      <th>weight_class</th>\n",
       "      <th>title_fight</th>\n",
       "      <th>method</th>\n",
       "      <th>end_round</th>\n",
       "      <th>fight_year</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bout_id</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>1</th>\n",
       "      <td>Santiago Ponzinibbio</td>\n",
       "      <td>Neil Magny</td>\n",
       "      <td>Santiago Ponzinibbio</td>\n",
       "      <td>Welterweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>4</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ricardo Lamas</td>\n",
       "      <td>Darren Elkins</td>\n",
       "      <td>Ricardo Lamas</td>\n",
       "      <td>Featherweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>3</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Johnny Walker</td>\n",
       "      <td>Khalil Rountree Jr.</td>\n",
       "      <td>Johnny Walker</td>\n",
       "      <td>Light Heavyweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ian Heinisch</td>\n",
       "      <td>Cezar Ferreira</td>\n",
       "      <td>Ian Heinisch</td>\n",
       "      <td>Middleweight</td>\n",
       "      <td>f</td>\n",
       "      <td>DEC</td>\n",
       "      <td>3</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Marlon Vera</td>\n",
       "      <td>Guido Cannetti</td>\n",
       "      <td>Marlon Vera</td>\n",
       "      <td>Bantamweight</td>\n",
       "      <td>f</td>\n",
       "      <td>SUB</td>\n",
       "      <td>2</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     fighter1             fighter2                winner  \\\n",
       "bout_id                                                                    \n",
       "1        Santiago Ponzinibbio           Neil Magny  Santiago Ponzinibbio   \n",
       "2               Ricardo Lamas        Darren Elkins         Ricardo Lamas   \n",
       "3               Johnny Walker  Khalil Rountree Jr.         Johnny Walker   \n",
       "4                Ian Heinisch       Cezar Ferreira          Ian Heinisch   \n",
       "5                 Marlon Vera       Guido Cannetti           Marlon Vera   \n",
       "\n",
       "              weight_class title_fight  method  end_round fight_year  \n",
       "bout_id                                                               \n",
       "1             Welterweight           f  KO/TKO          4       2018  \n",
       "2            Featherweight           f  KO/TKO          3       2018  \n",
       "3        Light Heavyweight           f  KO/TKO          1       2018  \n",
       "4             Middleweight           f     DEC          3       2018  \n",
       "5             Bantamweight           f     SUB          2       2018  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bouts.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# winner is always fighter 1 \n",
    "bouts[\"fighter1\"].equals(bouts[\"winner\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "# randomly swap fighter1 and fighter2 for half of the dataset to create \"negative cases\"\n",
    "swap_indices = np.random.choice(len(bouts), size = len(bouts) // 2, replace = False)\n",
    "bouts.iloc[swap_indices, [0, 1]] = bouts.iloc[swap_indices, [1, 0]].values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1    2398\n",
       "0    2398\n",
       "Name: winner, dtype: int64"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bouts[\"winner\"] = bouts[\"winner\"] == bouts[\"fighter1\"]\n",
    "bouts[\"winner\"] = bouts[\"winner\"].astype(int)\n",
    "bouts[\"winner\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>fighter1</th>\n",
       "      <th>fighter2</th>\n",
       "      <th>winner</th>\n",
       "      <th>weight_class</th>\n",
       "      <th>title_fight</th>\n",
       "      <th>method</th>\n",
       "      <th>end_round</th>\n",
       "      <th>fight_year</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bout_id</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>4874</th>\n",
       "      <td>Chas Skelly</td>\n",
       "      <td>Bobby Moffett</td>\n",
       "      <td>0</td>\n",
       "      <td>Featherweight</td>\n",
       "      <td>f</td>\n",
       "      <td>SUB</td>\n",
       "      <td>2</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4875</th>\n",
       "      <td>Davi Ramos</td>\n",
       "      <td>John Gunther</td>\n",
       "      <td>1</td>\n",
       "      <td>Lightweight</td>\n",
       "      <td>f</td>\n",
       "      <td>SUB</td>\n",
       "      <td>1</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4876</th>\n",
       "      <td>Julian Erosa</td>\n",
       "      <td>Devonte Smith</td>\n",
       "      <td>0</td>\n",
       "      <td>Lightweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4877</th>\n",
       "      <td>Eric Shelton</td>\n",
       "      <td>Joseph Morales</td>\n",
       "      <td>1</td>\n",
       "      <td>Flyweight</td>\n",
       "      <td>f</td>\n",
       "      <td>DEC</td>\n",
       "      <td>3</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4878</th>\n",
       "      <td>Mark De La Rosa</td>\n",
       "      <td>Joby Sanchez</td>\n",
       "      <td>1</td>\n",
       "      <td>Bantamweight</td>\n",
       "      <td>f</td>\n",
       "      <td>DEC</td>\n",
       "      <td>3</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                fighter1        fighter2  winner   weight_class title_fight  \\\n",
       "bout_id                                                                       \n",
       "4874         Chas Skelly   Bobby Moffett       0  Featherweight           f   \n",
       "4875          Davi Ramos    John Gunther       1    Lightweight           f   \n",
       "4876        Julian Erosa   Devonte Smith       0    Lightweight           f   \n",
       "4877        Eric Shelton  Joseph Morales       1      Flyweight           f   \n",
       "4878     Mark De La Rosa    Joby Sanchez       1   Bantamweight           f   \n",
       "\n",
       "         method  end_round fight_year  \n",
       "bout_id                                \n",
       "4874        SUB          2       2018  \n",
       "4875        SUB          1       2018  \n",
       "4876     KO/TKO          1       2018  \n",
       "4877        DEC          3       2018  \n",
       "4878        DEC          3       2018  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bouts.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>fighter1</th>\n",
       "      <th>fighter2</th>\n",
       "      <th>winner</th>\n",
       "      <th>weight_class</th>\n",
       "      <th>title_fight</th>\n",
       "      <th>method</th>\n",
       "      <th>end_round</th>\n",
       "      <th>fight_year</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bout_id</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>144</th>\n",
       "      <td>Dong Hyun Kim</td>\n",
       "      <td>Takanori Gomi</td>\n",
       "      <td>1</td>\n",
       "      <td>Lightweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1193</th>\n",
       "      <td>Dong Hyun Kim</td>\n",
       "      <td>Matt Brown</td>\n",
       "      <td>1</td>\n",
       "      <td>Welterweight</td>\n",
       "      <td>f</td>\n",
       "      <td>DEC</td>\n",
       "      <td>3</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1382</th>\n",
       "      <td>Dong Hyun Kim</td>\n",
       "      <td>TJ Grant</td>\n",
       "      <td>1</td>\n",
       "      <td>Welterweight</td>\n",
       "      <td>f</td>\n",
       "      <td>DEC</td>\n",
       "      <td>3</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1582</th>\n",
       "      <td>Dong Hyun Kim</td>\n",
       "      <td>Amir Sadollah</td>\n",
       "      <td>1</td>\n",
       "      <td>Welterweight</td>\n",
       "      <td>f</td>\n",
       "      <td>DEC</td>\n",
       "      <td>3</td>\n",
       "      <td>2010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1739</th>\n",
       "      <td>Dong Hyun Kim</td>\n",
       "      <td>Nate Diaz</td>\n",
       "      <td>1</td>\n",
       "      <td>Welterweight</td>\n",
       "      <td>f</td>\n",
       "      <td>DEC</td>\n",
       "      <td>3</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1876</th>\n",
       "      <td>Dong Hyun Kim</td>\n",
       "      <td>Carlos Condit</td>\n",
       "      <td>0</td>\n",
       "      <td>Welterweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2650</th>\n",
       "      <td>Dong Hyun Kim</td>\n",
       "      <td>Erick Silva</td>\n",
       "      <td>1</td>\n",
       "      <td>Welterweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>2</td>\n",
       "      <td>2013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2831</th>\n",
       "      <td>Dong Hyun Kim</td>\n",
       "      <td>John Hathaway</td>\n",
       "      <td>1</td>\n",
       "      <td>Welterweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>3</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3443</th>\n",
       "      <td>Dong Hyun Kim</td>\n",
       "      <td>Joshua Burkman</td>\n",
       "      <td>1</td>\n",
       "      <td>Welterweight</td>\n",
       "      <td>f</td>\n",
       "      <td>SUB</td>\n",
       "      <td>3</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156</th>\n",
       "      <td>Dong Hyun Kim</td>\n",
       "      <td>Brendan O'Reilly</td>\n",
       "      <td>1</td>\n",
       "      <td>Lightweight</td>\n",
       "      <td>f</td>\n",
       "      <td>DEC</td>\n",
       "      <td>3</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              fighter1          fighter2  winner  weight_class title_fight  \\\n",
       "bout_id                                                                      \n",
       "144      Dong Hyun Kim     Takanori Gomi       1   Lightweight           f   \n",
       "1193     Dong Hyun Kim        Matt Brown       1  Welterweight           f   \n",
       "1382     Dong Hyun Kim          TJ Grant       1  Welterweight           f   \n",
       "1582     Dong Hyun Kim     Amir Sadollah       1  Welterweight           f   \n",
       "1739     Dong Hyun Kim         Nate Diaz       1  Welterweight           f   \n",
       "1876     Dong Hyun Kim     Carlos Condit       0  Welterweight           f   \n",
       "2650     Dong Hyun Kim       Erick Silva       1  Welterweight           f   \n",
       "2831     Dong Hyun Kim     John Hathaway       1  Welterweight           f   \n",
       "3443     Dong Hyun Kim    Joshua Burkman       1  Welterweight           f   \n",
       "4156     Dong Hyun Kim  Brendan O'Reilly       1   Lightweight           f   \n",
       "\n",
       "         method  end_round fight_year  \n",
       "bout_id                                \n",
       "144      KO/TKO          1       2017  \n",
       "1193        DEC          3       2008  \n",
       "1382        DEC          3       2009  \n",
       "1582        DEC          3       2010  \n",
       "1739        DEC          3       2011  \n",
       "1876     KO/TKO          1       2011  \n",
       "2650     KO/TKO          2       2013  \n",
       "2831     KO/TKO          3       2014  \n",
       "3443        SUB          3       2015  \n",
       "4156        DEC          3       2016  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bouts[bouts[\"fighter1\"]==\"Dong Hyun Kim\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "# again, handel duplicate names\n",
    "bouts_clean = bouts.copy()\n",
    "for col in [\"fighter1\", \"fighter2\"]:\n",
    "    bouts_clean.loc[(bouts_clean[col] == \"Michael McDonald\") &\n",
    "                    (bouts_clean[\"weight_class\"] == \"Light Heavyweight\"), col] = \"Michael McDonald 205\"\n",
    "    \n",
    "    bouts_clean.loc[(bouts_clean[col] == \"Dong Hyun Kim\") &\n",
    "                    (bouts_clean[\"weight_class\"] == \"Lightweight\"), col]= \"Dong Hyun Kim 155\"\n",
    "    \n",
    "    bouts_clean.loc[(bouts_clean[col] == \"Tony Johnson\") &\n",
    "                    (bouts_clean[\"weight_class\"] == \"Middleweight\"), col] = \"Tony Johnson 185\"\n",
    "    \n",
    "    bouts_clean.loc[(bouts_clean[col] == \"Mike Davis\") &\n",
    "                    (bouts_clean[\"weight_class\"] == \"Featherweight\"), col] = \"Mike Davis 145\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>fighter1</th>\n",
       "      <th>fighter2</th>\n",
       "      <th>winner</th>\n",
       "      <th>weight_class</th>\n",
       "      <th>title_fight</th>\n",
       "      <th>method</th>\n",
       "      <th>end_round</th>\n",
       "      <th>fight_year</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bout_id</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>144</th>\n",
       "      <td>Dong Hyun Kim 155</td>\n",
       "      <td>Takanori Gomi</td>\n",
       "      <td>1</td>\n",
       "      <td>Lightweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>2017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156</th>\n",
       "      <td>Dong Hyun Kim 155</td>\n",
       "      <td>Brendan O'Reilly</td>\n",
       "      <td>1</td>\n",
       "      <td>Lightweight</td>\n",
       "      <td>f</td>\n",
       "      <td>DEC</td>\n",
       "      <td>3</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  fighter1          fighter2  winner weight_class title_fight  \\\n",
       "bout_id                                                                         \n",
       "144      Dong Hyun Kim 155     Takanori Gomi       1  Lightweight           f   \n",
       "4156     Dong Hyun Kim 155  Brendan O'Reilly       1  Lightweight           f   \n",
       "\n",
       "         method  end_round fight_year  \n",
       "bout_id                                \n",
       "144      KO/TKO          1       2017  \n",
       "4156        DEC          3       2016  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bouts_clean[bouts_clean[\"fighter1\"] == \"Dong Hyun Kim 155\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Next, we need to fuse these two datasets together."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "# make sure all fighters are in the figher database\n",
    "# otherwise remove the corresponding bout\n",
    "all_fighter_names = fighers_clean.index.values.tolist()\n",
    "\n",
    "bouts_clean = bouts_clean.loc[(bouts_clean[\"fighter1\"].isin(all_fighter_names)) &\n",
    "                              (bouts_clean[\"fighter2\"].isin(all_fighter_names))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "bouts_clean.reset_index(inplace=True, drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>fighter1</th>\n",
       "      <th>fighter2</th>\n",
       "      <th>winner</th>\n",
       "      <th>weight_class</th>\n",
       "      <th>title_fight</th>\n",
       "      <th>method</th>\n",
       "      <th>end_round</th>\n",
       "      <th>fight_year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Santiago Ponzinibbio</td>\n",
       "      <td>Neil Magny</td>\n",
       "      <td>1</td>\n",
       "      <td>Welterweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>4</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ricardo Lamas</td>\n",
       "      <td>Darren Elkins</td>\n",
       "      <td>1</td>\n",
       "      <td>Featherweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>3</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Johnny Walker</td>\n",
       "      <td>Khalil Rountree Jr.</td>\n",
       "      <td>1</td>\n",
       "      <td>Light Heavyweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Cezar Ferreira</td>\n",
       "      <td>Ian Heinisch</td>\n",
       "      <td>0</td>\n",
       "      <td>Middleweight</td>\n",
       "      <td>f</td>\n",
       "      <td>DEC</td>\n",
       "      <td>3</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Marlon Vera</td>\n",
       "      <td>Guido Cannetti</td>\n",
       "      <td>1</td>\n",
       "      <td>Bantamweight</td>\n",
       "      <td>f</td>\n",
       "      <td>SUB</td>\n",
       "      <td>2</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               fighter1             fighter2  winner       weight_class  \\\n",
       "0  Santiago Ponzinibbio           Neil Magny       1       Welterweight   \n",
       "1         Ricardo Lamas        Darren Elkins       1      Featherweight   \n",
       "2         Johnny Walker  Khalil Rountree Jr.       1  Light Heavyweight   \n",
       "3        Cezar Ferreira         Ian Heinisch       0       Middleweight   \n",
       "4           Marlon Vera       Guido Cannetti       1       Bantamweight   \n",
       "\n",
       "  title_fight  method  end_round fight_year  \n",
       "0           f  KO/TKO          4       2018  \n",
       "1           f  KO/TKO          3       2018  \n",
       "2           f  KO/TKO          1       2018  \n",
       "3           f     DEC          3       2018  \n",
       "4           f     SUB          2       2018  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bouts_clean.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "4796 bouts in total, after clean up: 4591 bouts\n"
     ]
    }
   ],
   "source": [
    "print(\"{0} bouts in total, after clean up: {1} bouts\".format(len(bouts), len(bouts_clean)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "fighter1_data = fighers_clean.loc[bouts_clean[\"fighter1\"]]\n",
    "fighter1_data = fighter1_data.add_suffix('_fighter1')\n",
    "fighter2_data = fighers_clean.loc[bouts_clean[\"fighter2\"]]\n",
    "fighter2_data = fighter2_data.add_suffix('_fighter2')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>win_fighter1</th>\n",
       "      <th>lose_fighter1</th>\n",
       "      <th>draw_fighter1</th>\n",
       "      <th>nc_fighter1</th>\n",
       "      <th>height_fighter1</th>\n",
       "      <th>reach_fighter1</th>\n",
       "      <th>stance_fighter1</th>\n",
       "      <th>SLpM_fighter1</th>\n",
       "      <th>Str_Acc_fighter1</th>\n",
       "      <th>SApM_fighter1</th>\n",
       "      <th>Str_Def_fighter1</th>\n",
       "      <th>TD_Avg_fighter1</th>\n",
       "      <th>TD_Acc_fighter1</th>\n",
       "      <th>TD_Def_fighter1</th>\n",
       "      <th>Sub_Avg_fighter1</th>\n",
       "      <th>win%_fighter1</th>\n",
       "      <th>born_year_fighter1</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</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>Santiago Ponzinibbio</th>\n",
       "      <td>28</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6' 0\"</td>\n",
       "      <td>73\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>4.27</td>\n",
       "      <td>39.0</td>\n",
       "      <td>4.02</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.54</td>\n",
       "      <td>44.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>90.322578</td>\n",
       "      <td>1986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ricardo Lamas</th>\n",
       "      <td>19</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5' 8\"</td>\n",
       "      <td>71\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>2.87</td>\n",
       "      <td>45.0</td>\n",
       "      <td>2.61</td>\n",
       "      <td>59.0</td>\n",
       "      <td>1.66</td>\n",
       "      <td>32.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>73.076920</td>\n",
       "      <td>1982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Johnny Walker</th>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6' 5\"</td>\n",
       "      <td>82\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>5.37</td>\n",
       "      <td>70.0</td>\n",
       "      <td>3.36</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.89</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>83.333336</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cezar Ferreira</th>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6' 1\"</td>\n",
       "      <td>78\"</td>\n",
       "      <td>Southpaw</td>\n",
       "      <td>1.83</td>\n",
       "      <td>42.0</td>\n",
       "      <td>2.14</td>\n",
       "      <td>55.0</td>\n",
       "      <td>2.97</td>\n",
       "      <td>59.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>66.666664</td>\n",
       "      <td>1985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Marlon Vera</th>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5' 8\"</td>\n",
       "      <td>70\"</td>\n",
       "      <td>Switch</td>\n",
       "      <td>3.23</td>\n",
       "      <td>44.0</td>\n",
       "      <td>3.93</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.78</td>\n",
       "      <td>37.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>66.666664</td>\n",
       "      <td>1992</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      win_fighter1  lose_fighter1  draw_fighter1  nc_fighter1  \\\n",
       "name                                                                            \n",
       "Santiago Ponzinibbio            28              3              0            0   \n",
       "Ricardo Lamas                   19              7              0            0   \n",
       "Johnny Walker                   15              3              0            0   \n",
       "Cezar Ferreira                  14              7              0            0   \n",
       "Marlon Vera                     12              5              1            0   \n",
       "\n",
       "                     height_fighter1 reach_fighter1 stance_fighter1  \\\n",
       "name                                                                  \n",
       "Santiago Ponzinibbio           6' 0\"            73\"        Orthodox   \n",
       "Ricardo Lamas                  5' 8\"            71\"        Orthodox   \n",
       "Johnny Walker                  6' 5\"            82\"        Orthodox   \n",
       "Cezar Ferreira                 6' 1\"            78\"        Southpaw   \n",
       "Marlon Vera                    5' 8\"            70\"          Switch   \n",
       "\n",
       "                      SLpM_fighter1  Str_Acc_fighter1  SApM_fighter1  \\\n",
       "name                                                                   \n",
       "Santiago Ponzinibbio           4.27              39.0           4.02   \n",
       "Ricardo Lamas                  2.87              45.0           2.61   \n",
       "Johnny Walker                  5.37              70.0           3.36   \n",
       "Cezar Ferreira                 1.83              42.0           2.14   \n",
       "Marlon Vera                    3.23              44.0           3.93   \n",
       "\n",
       "                      Str_Def_fighter1  TD_Avg_fighter1  TD_Acc_fighter1  \\\n",
       "name                                                                       \n",
       "Santiago Ponzinibbio              64.0             0.54             44.0   \n",
       "Ricardo Lamas                     59.0             1.66             32.0   \n",
       "Johnny Walker                     25.0             0.89            100.0   \n",
       "Cezar Ferreira                    55.0             2.97             59.0   \n",
       "Marlon Vera                       52.0             0.78             37.0   \n",
       "\n",
       "                      TD_Def_fighter1  Sub_Avg_fighter1  win%_fighter1  \\\n",
       "name                                                                     \n",
       "Santiago Ponzinibbio             60.0               0.0      90.322578   \n",
       "Ricardo Lamas                    47.0               1.0      73.076920   \n",
       "Johnny Walker                   100.0               2.6      83.333336   \n",
       "Cezar Ferreira                   90.0               0.5      66.666664   \n",
       "Marlon Vera                      68.0               1.3      66.666664   \n",
       "\n",
       "                     born_year_fighter1  \n",
       "name                                     \n",
       "Santiago Ponzinibbio               1986  \n",
       "Ricardo Lamas                      1982  \n",
       "Johnny Walker                      1992  \n",
       "Cezar Ferreira                     1985  \n",
       "Marlon Vera                        1992  "
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fighter1_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>win_fighter2</th>\n",
       "      <th>lose_fighter2</th>\n",
       "      <th>draw_fighter2</th>\n",
       "      <th>nc_fighter2</th>\n",
       "      <th>height_fighter2</th>\n",
       "      <th>reach_fighter2</th>\n",
       "      <th>stance_fighter2</th>\n",
       "      <th>SLpM_fighter2</th>\n",
       "      <th>Str_Acc_fighter2</th>\n",
       "      <th>SApM_fighter2</th>\n",
       "      <th>Str_Def_fighter2</th>\n",
       "      <th>TD_Avg_fighter2</th>\n",
       "      <th>TD_Acc_fighter2</th>\n",
       "      <th>TD_Def_fighter2</th>\n",
       "      <th>Sub_Avg_fighter2</th>\n",
       "      <th>win%_fighter2</th>\n",
       "      <th>born_year_fighter2</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</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>Neil Magny</th>\n",
       "      <td>21</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6' 3\"</td>\n",
       "      <td>80\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>3.86</td>\n",
       "      <td>46.0</td>\n",
       "      <td>2.22</td>\n",
       "      <td>56.0</td>\n",
       "      <td>2.62</td>\n",
       "      <td>46.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>72.413795</td>\n",
       "      <td>1987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Darren Elkins</th>\n",
       "      <td>25</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5' 10\"</td>\n",
       "      <td>71\"</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>3.36</td>\n",
       "      <td>37.0</td>\n",
       "      <td>2.83</td>\n",
       "      <td>53.0</td>\n",
       "      <td>2.68</td>\n",
       "      <td>35.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>78.125000</td>\n",
       "      <td>1984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Khalil Rountree Jr.</th>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>6' 1\"</td>\n",
       "      <td>76\"</td>\n",
       "      <td>Southpaw</td>\n",
       "      <td>2.30</td>\n",
       "      <td>34.0</td>\n",
       "      <td>3.29</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>66.666664</td>\n",
       "      <td>1990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ian Heinisch</th>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5' 11\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Orthodox</td>\n",
       "      <td>3.49</td>\n",
       "      <td>58.0</td>\n",
       "      <td>1.67</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.81</td>\n",
       "      <td>14.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>92.307693</td>\n",
       "      <td>1988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Guido Cannetti</th>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5' 6\"</td>\n",
       "      <td>68\"</td>\n",
       "      <td>Southpaw</td>\n",
       "      <td>2.80</td>\n",
       "      <td>52.0</td>\n",
       "      <td>1.95</td>\n",
       "      <td>51.0</td>\n",
       "      <td>2.80</td>\n",
       "      <td>50.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>61.538460</td>\n",
       "      <td>1979</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     win_fighter2  lose_fighter2  draw_fighter2  nc_fighter2  \\\n",
       "name                                                                           \n",
       "Neil Magny                     21              8              0            0   \n",
       "Darren Elkins                  25              7              0            0   \n",
       "Khalil Rountree Jr.             8              2              0            2   \n",
       "Ian Heinisch                   12              1              0            0   \n",
       "Guido Cannetti                  8              5              0            0   \n",
       "\n",
       "                    height_fighter2 reach_fighter2 stance_fighter2  \\\n",
       "name                                                                 \n",
       "Neil Magny                    6' 3\"            80\"        Orthodox   \n",
       "Darren Elkins                5' 10\"            71\"        Orthodox   \n",
       "Khalil Rountree Jr.           6' 1\"            76\"        Southpaw   \n",
       "Ian Heinisch                 5' 11\"            NaN        Orthodox   \n",
       "Guido Cannetti                5' 6\"            68\"        Southpaw   \n",
       "\n",
       "                     SLpM_fighter2  Str_Acc_fighter2  SApM_fighter2  \\\n",
       "name                                                                  \n",
       "Neil Magny                    3.86              46.0           2.22   \n",
       "Darren Elkins                 3.36              37.0           2.83   \n",
       "Khalil Rountree Jr.           2.30              34.0           3.29   \n",
       "Ian Heinisch                  3.49              58.0           1.67   \n",
       "Guido Cannetti                2.80              52.0           1.95   \n",
       "\n",
       "                     Str_Def_fighter2  TD_Avg_fighter2  TD_Acc_fighter2  \\\n",
       "name                                                                      \n",
       "Neil Magny                       56.0             2.62             46.0   \n",
       "Darren Elkins                    53.0             2.68             35.0   \n",
       "Khalil Rountree Jr.              38.0             0.00              0.0   \n",
       "Ian Heinisch                     52.0             0.81             14.0   \n",
       "Guido Cannetti                   51.0             2.80             50.0   \n",
       "\n",
       "                     TD_Def_fighter2  Sub_Avg_fighter2  win%_fighter2  \\\n",
       "name                                                                    \n",
       "Neil Magny                      60.0               0.3      72.413795   \n",
       "Darren Elkins                   57.0               1.3      78.125000   \n",
       "Khalil Rountree Jr.             50.0               0.3      66.666664   \n",
       "Ian Heinisch                    50.0               1.6      92.307693   \n",
       "Guido Cannetti                  75.0               0.3      61.538460   \n",
       "\n",
       "                    born_year_fighter2  \n",
       "name                                    \n",
       "Neil Magny                        1987  \n",
       "Darren Elkins                     1984  \n",
       "Khalil Rountree Jr.               1990  \n",
       "Ian Heinisch                      1988  \n",
       "Guido Cannetti                    1979  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fighter2_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4591, 4591)"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(fighter1_data), len(fighter2_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "# now join the two datasets together\n",
    "fighter1_data.reset_index(inplace=True, drop=True)\n",
    "fighter2_data.reset_index(inplace=True, drop=True)\n",
    "combined = pd.concat([bouts_clean, fighter1_data, fighter2_data], axis=1, sort=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>fighter1</th>\n",
       "      <th>fighter2</th>\n",
       "      <th>winner</th>\n",
       "      <th>weight_class</th>\n",
       "      <th>title_fight</th>\n",
       "      <th>method</th>\n",
       "      <th>end_round</th>\n",
       "      <th>fight_year</th>\n",
       "      <th>win_fighter1</th>\n",
       "      <th>lose_fighter1</th>\n",
       "      <th>...</th>\n",
       "      <th>SLpM_fighter2</th>\n",
       "      <th>Str_Acc_fighter2</th>\n",
       "      <th>SApM_fighter2</th>\n",
       "      <th>Str_Def_fighter2</th>\n",
       "      <th>TD_Avg_fighter2</th>\n",
       "      <th>TD_Acc_fighter2</th>\n",
       "      <th>TD_Def_fighter2</th>\n",
       "      <th>Sub_Avg_fighter2</th>\n",
       "      <th>win%_fighter2</th>\n",
       "      <th>born_year_fighter2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Santiago Ponzinibbio</td>\n",
       "      <td>Neil Magny</td>\n",
       "      <td>1</td>\n",
       "      <td>Welterweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>4</td>\n",
       "      <td>2018</td>\n",
       "      <td>28</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>3.86</td>\n",
       "      <td>46.0</td>\n",
       "      <td>2.22</td>\n",
       "      <td>56.0</td>\n",
       "      <td>2.62</td>\n",
       "      <td>46.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>72.413795</td>\n",
       "      <td>1987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ricardo Lamas</td>\n",
       "      <td>Darren Elkins</td>\n",
       "      <td>1</td>\n",
       "      <td>Featherweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>3</td>\n",
       "      <td>2018</td>\n",
       "      <td>19</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>3.36</td>\n",
       "      <td>37.0</td>\n",
       "      <td>2.83</td>\n",
       "      <td>53.0</td>\n",
       "      <td>2.68</td>\n",
       "      <td>35.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>78.125000</td>\n",
       "      <td>1984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Johnny Walker</td>\n",
       "      <td>Khalil Rountree Jr.</td>\n",
       "      <td>1</td>\n",
       "      <td>Light Heavyweight</td>\n",
       "      <td>f</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>2018</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>2.30</td>\n",
       "      <td>34.0</td>\n",
       "      <td>3.29</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>66.666664</td>\n",
       "      <td>1990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Cezar Ferreira</td>\n",
       "      <td>Ian Heinisch</td>\n",
       "      <td>0</td>\n",
       "      <td>Middleweight</td>\n",
       "      <td>f</td>\n",
       "      <td>DEC</td>\n",
       "      <td>3</td>\n",
       "      <td>2018</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>3.49</td>\n",
       "      <td>58.0</td>\n",
       "      <td>1.67</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.81</td>\n",
       "      <td>14.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>92.307693</td>\n",
       "      <td>1988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Marlon Vera</td>\n",
       "      <td>Guido Cannetti</td>\n",
       "      <td>1</td>\n",
       "      <td>Bantamweight</td>\n",
       "      <td>f</td>\n",
       "      <td>SUB</td>\n",
       "      <td>2</td>\n",
       "      <td>2018</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>2.80</td>\n",
       "      <td>52.0</td>\n",
       "      <td>1.95</td>\n",
       "      <td>51.0</td>\n",
       "      <td>2.80</td>\n",
       "      <td>50.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>0.3</td>\n",
       "      <td>61.538460</td>\n",
       "      <td>1979</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               fighter1             fighter2  winner       weight_class  \\\n",
       "0  Santiago Ponzinibbio           Neil Magny       1       Welterweight   \n",
       "1         Ricardo Lamas        Darren Elkins       1      Featherweight   \n",
       "2         Johnny Walker  Khalil Rountree Jr.       1  Light Heavyweight   \n",
       "3        Cezar Ferreira         Ian Heinisch       0       Middleweight   \n",
       "4           Marlon Vera       Guido Cannetti       1       Bantamweight   \n",
       "\n",
       "  title_fight  method  end_round fight_year  win_fighter1  lose_fighter1  \\\n",
       "0           f  KO/TKO          4       2018            28              3   \n",
       "1           f  KO/TKO          3       2018            19              7   \n",
       "2           f  KO/TKO          1       2018            15              3   \n",
       "3           f     DEC          3       2018            14              7   \n",
       "4           f     SUB          2       2018            12              5   \n",
       "\n",
       "          ...          SLpM_fighter2  Str_Acc_fighter2 SApM_fighter2  \\\n",
       "0         ...                   3.86              46.0          2.22   \n",
       "1         ...                   3.36              37.0          2.83   \n",
       "2         ...                   2.30              34.0          3.29   \n",
       "3         ...                   3.49              58.0          1.67   \n",
       "4         ...                   2.80              52.0          1.95   \n",
       "\n",
       "  Str_Def_fighter2 TD_Avg_fighter2  TD_Acc_fighter2  TD_Def_fighter2  \\\n",
       "0             56.0            2.62             46.0             60.0   \n",
       "1             53.0            2.68             35.0             57.0   \n",
       "2             38.0            0.00              0.0             50.0   \n",
       "3             52.0            0.81             14.0             50.0   \n",
       "4             51.0            2.80             50.0             75.0   \n",
       "\n",
       "   Sub_Avg_fighter2  win%_fighter2  born_year_fighter2  \n",
       "0               0.3      72.413795                1987  \n",
       "1               1.3      78.125000                1984  \n",
       "2               0.3      66.666664                1990  \n",
       "3               1.6      92.307693                1988  \n",
       "4               0.3      61.538460                1979  \n",
       "\n",
       "[5 rows x 42 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combined.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4591"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(combined)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "combined.to_csv(\"ufc_combined.csv\")"
   ]
  }
 ],
 "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.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}