preprocessing_and_fighter_data_3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Scraping all fight data: \n",
      "Progress: |██████████████████████████████████████████████████| 100.00% Complete\n"
     ]
    }
   ],
   "source": [
    "from createdata.scrape_fight_links import get_this_event_fight_links\n",
    "from createdata.scrape_fight_data import create_fight_data_csv\n",
    "\n",
    "event_links = ['http://ufcstats.com/event-details/b16a7e6a627e9789', 'http://ufcstats.com/event-details/c0c1bc0766df4c00',\n",
    "              'http://ufcstats.com/event-details/6c9383ffab2725a5', 'http://ufcstats.com/event-details/2f8f3c69522db931',\n",
    "              'http://ufcstats.com/event-details/9e0f28d1f639ad73', 'http://ufcstats.com/event-details/abcf7e55a0a9ed89']\n",
    "event_links.reverse()\n",
    "event_and_fight_links = get_this_event_fight_links(event_links)\n",
    "create_fight_data_csv(event_and_fight_links, 'new_data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import math\n",
    "\n",
    "df_orig = pd.read_csv('data/total_fight_data.csv', sep=';')\n",
    "df = pd.read_csv('data/new_data.csv', sep=';')\n",
    "fighter_details = pd.read_csv('data/fighter_details.csv', index_col='fighter_name')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.concat([df, df_orig]).reset_index(drop=True)"
   ]
  },
  {
   "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>R_fighter</th>\n",
       "      <th>B_fighter</th>\n",
       "      <th>R_KD</th>\n",
       "      <th>B_KD</th>\n",
       "      <th>R_SIG_STR.</th>\n",
       "      <th>B_SIG_STR.</th>\n",
       "      <th>R_SIG_STR_pct</th>\n",
       "      <th>B_SIG_STR_pct</th>\n",
       "      <th>R_TOTAL_STR.</th>\n",
       "      <th>B_TOTAL_STR.</th>\n",
       "      <th>...</th>\n",
       "      <th>B_GROUND</th>\n",
       "      <th>win_by</th>\n",
       "      <th>last_round</th>\n",
       "      <th>last_round_time</th>\n",
       "      <th>Format</th>\n",
       "      <th>Referee</th>\n",
       "      <th>date</th>\n",
       "      <th>location</th>\n",
       "      <th>Fight_type</th>\n",
       "      <th>Winner</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Max Holloway</td>\n",
       "      <td>Frankie Edgar</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>129 of 328</td>\n",
       "      <td>96 of 264</td>\n",
       "      <td>39%</td>\n",
       "      <td>36%</td>\n",
       "      <td>131 of 330</td>\n",
       "      <td>96 of 264</td>\n",
       "      <td>...</td>\n",
       "      <td>1 of 2</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>5</td>\n",
       "      <td>5:00</td>\n",
       "      <td>5 Rnd (5-5-5-5-5)</td>\n",
       "      <td>Herb Dean</td>\n",
       "      <td>July 27, 2019</td>\n",
       "      <td>Edmonton, Alberta, Canada</td>\n",
       "      <td>UFC Featherweight Title Bout</td>\n",
       "      <td>Max Holloway</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Cris Cyborg</td>\n",
       "      <td>Felicia Spencer</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>122 of 216</td>\n",
       "      <td>38 of 85</td>\n",
       "      <td>56%</td>\n",
       "      <td>44%</td>\n",
       "      <td>138 of 234</td>\n",
       "      <td>64 of 115</td>\n",
       "      <td>...</td>\n",
       "      <td>4 of 6</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Yves Lavigne</td>\n",
       "      <td>July 27, 2019</td>\n",
       "      <td>Edmonton, Alberta, Canada</td>\n",
       "      <td>Women's Featherweight Bout</td>\n",
       "      <td>Cris Cyborg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Geoff Neal</td>\n",
       "      <td>Niko Price</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>41 of 61</td>\n",
       "      <td>24 of 57</td>\n",
       "      <td>67%</td>\n",
       "      <td>42%</td>\n",
       "      <td>53 of 73</td>\n",
       "      <td>42 of 79</td>\n",
       "      <td>...</td>\n",
       "      <td>4 of 10</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>2</td>\n",
       "      <td>2:39</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Dan Miragliotta</td>\n",
       "      <td>July 27, 2019</td>\n",
       "      <td>Edmonton, Alberta, Canada</td>\n",
       "      <td>Welterweight Bout</td>\n",
       "      <td>Geoff Neal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Olivier Aubin-Mercier</td>\n",
       "      <td>Arman Tsarukyan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>23 of 48</td>\n",
       "      <td>47 of 105</td>\n",
       "      <td>47%</td>\n",
       "      <td>44%</td>\n",
       "      <td>36 of 61</td>\n",
       "      <td>110 of 174</td>\n",
       "      <td>...</td>\n",
       "      <td>22 of 29</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Marc Goddard</td>\n",
       "      <td>July 27, 2019</td>\n",
       "      <td>Edmonton, Alberta, Canada</td>\n",
       "      <td>Lightweight Bout</td>\n",
       "      <td>Arman Tsarukyan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Marc-Andre Barriault</td>\n",
       "      <td>Krzysztof Jotko</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>39 of 77</td>\n",
       "      <td>40 of 117</td>\n",
       "      <td>50%</td>\n",
       "      <td>34%</td>\n",
       "      <td>62 of 102</td>\n",
       "      <td>98 of 181</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Decision - Split</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Herb Dean</td>\n",
       "      <td>July 27, 2019</td>\n",
       "      <td>Edmonton, Alberta, Canada</td>\n",
       "      <td>Middleweight Bout</td>\n",
       "      <td>Krzysztof Jotko</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Alexis Davis</td>\n",
       "      <td>Viviane Araujo</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>68 of 137</td>\n",
       "      <td>67 of 148</td>\n",
       "      <td>49%</td>\n",
       "      <td>45%</td>\n",
       "      <td>134 of 213</td>\n",
       "      <td>79 of 162</td>\n",
       "      <td>...</td>\n",
       "      <td>1 of 1</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Yves Lavigne</td>\n",
       "      <td>July 27, 2019</td>\n",
       "      <td>Edmonton, Alberta, Canada</td>\n",
       "      <td>Women's Flyweight Bout</td>\n",
       "      <td>Viviane Araujo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Hakeem Dawodu</td>\n",
       "      <td>Yoshinori Horie</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>80 of 154</td>\n",
       "      <td>39 of 79</td>\n",
       "      <td>51%</td>\n",
       "      <td>49%</td>\n",
       "      <td>89 of 166</td>\n",
       "      <td>41 of 81</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>3</td>\n",
       "      <td>4:09</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Kyle Cardinal</td>\n",
       "      <td>July 27, 2019</td>\n",
       "      <td>Edmonton, Alberta, Canada</td>\n",
       "      <td>Featherweight Bout</td>\n",
       "      <td>Hakeem Dawodu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Gavin Tucker</td>\n",
       "      <td>SeungWoo Choi</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>37 of 62</td>\n",
       "      <td>23 of 96</td>\n",
       "      <td>59%</td>\n",
       "      <td>23%</td>\n",
       "      <td>49 of 77</td>\n",
       "      <td>42 of 116</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Submission</td>\n",
       "      <td>3</td>\n",
       "      <td>3:17</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Marc Goddard</td>\n",
       "      <td>July 27, 2019</td>\n",
       "      <td>Edmonton, Alberta, Canada</td>\n",
       "      <td>Featherweight Bout</td>\n",
       "      <td>Gavin Tucker</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Alexandre Pantoja</td>\n",
       "      <td>Deiveson Figueiredo</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>61 of 151</td>\n",
       "      <td>67 of 113</td>\n",
       "      <td>40%</td>\n",
       "      <td>59%</td>\n",
       "      <td>68 of 160</td>\n",
       "      <td>71 of 117</td>\n",
       "      <td>...</td>\n",
       "      <td>10 of 16</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Dan Miragliotta</td>\n",
       "      <td>July 27, 2019</td>\n",
       "      <td>Edmonton, Alberta, Canada</td>\n",
       "      <td>Flyweight Bout</td>\n",
       "      <td>Deiveson Figueiredo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Gillian Robertson</td>\n",
       "      <td>Sarah Frota</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>29 of 42</td>\n",
       "      <td>9 of 20</td>\n",
       "      <td>69%</td>\n",
       "      <td>45%</td>\n",
       "      <td>51 of 64</td>\n",
       "      <td>33 of 46</td>\n",
       "      <td>...</td>\n",
       "      <td>6 of 12</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>2</td>\n",
       "      <td>4:13</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Kyle Cardinal</td>\n",
       "      <td>July 27, 2019</td>\n",
       "      <td>Edmonton, Alberta, Canada</td>\n",
       "      <td>Women's Flyweight Bout</td>\n",
       "      <td>Gillian Robertson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Erik Koch</td>\n",
       "      <td>Kyle Stewart</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>37 of 63</td>\n",
       "      <td>23 of 64</td>\n",
       "      <td>58%</td>\n",
       "      <td>35%</td>\n",
       "      <td>67 of 99</td>\n",
       "      <td>68 of 119</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Marc Goddard</td>\n",
       "      <td>July 27, 2019</td>\n",
       "      <td>Edmonton, Alberta, Canada</td>\n",
       "      <td>Welterweight Bout</td>\n",
       "      <td>Erik Koch</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Rafael Dos Anjos</td>\n",
       "      <td>Leon Edwards</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>81 of 169</td>\n",
       "      <td>92 of 215</td>\n",
       "      <td>47%</td>\n",
       "      <td>42%</td>\n",
       "      <td>129 of 219</td>\n",
       "      <td>113 of 244</td>\n",
       "      <td>...</td>\n",
       "      <td>3 of 6</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>5</td>\n",
       "      <td>5:00</td>\n",
       "      <td>5 Rnd (5-5-5-5-5)</td>\n",
       "      <td>Dan Miragliotta</td>\n",
       "      <td>July 20, 2019</td>\n",
       "      <td>San Antonio, Texas, USA</td>\n",
       "      <td>Welterweight Bout</td>\n",
       "      <td>Leon Edwards</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Aleksei Oleinik</td>\n",
       "      <td>Walt Harris</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1 of 3</td>\n",
       "      <td>4 of 7</td>\n",
       "      <td>33%</td>\n",
       "      <td>57%</td>\n",
       "      <td>1 of 3</td>\n",
       "      <td>4 of 7</td>\n",
       "      <td>...</td>\n",
       "      <td>2 of 2</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>0:12</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Jacob Montalvo</td>\n",
       "      <td>July 20, 2019</td>\n",
       "      <td>San Antonio, Texas, USA</td>\n",
       "      <td>Heavyweight Bout</td>\n",
       "      <td>Walt Harris</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Greg Hardy</td>\n",
       "      <td>Juan Adams</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>36 of 38</td>\n",
       "      <td>3 of 7</td>\n",
       "      <td>94%</td>\n",
       "      <td>42%</td>\n",
       "      <td>36 of 38</td>\n",
       "      <td>3 of 7</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>0:45</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Dan Miragliotta</td>\n",
       "      <td>July 20, 2019</td>\n",
       "      <td>San Antonio, Texas, USA</td>\n",
       "      <td>Heavyweight Bout</td>\n",
       "      <td>Greg Hardy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>James Vick</td>\n",
       "      <td>Dan Hooker</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>7 of 23</td>\n",
       "      <td>22 of 41</td>\n",
       "      <td>30%</td>\n",
       "      <td>53%</td>\n",
       "      <td>7 of 23</td>\n",
       "      <td>22 of 41</td>\n",
       "      <td>...</td>\n",
       "      <td>3 of 3</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>2:33</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Kerry Hatley</td>\n",
       "      <td>July 20, 2019</td>\n",
       "      <td>San Antonio, Texas, USA</td>\n",
       "      <td>Lightweight Bout</td>\n",
       "      <td>Dan Hooker</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Alexander Hernandez</td>\n",
       "      <td>Francisco Trinaldo</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25 of 91</td>\n",
       "      <td>25 of 52</td>\n",
       "      <td>27%</td>\n",
       "      <td>48%</td>\n",
       "      <td>26 of 92</td>\n",
       "      <td>28 of 55</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Frank Collazo</td>\n",
       "      <td>July 20, 2019</td>\n",
       "      <td>San Antonio, Texas, USA</td>\n",
       "      <td>Lightweight Bout</td>\n",
       "      <td>Alexander Hernandez</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Andrei Arlovski</td>\n",
       "      <td>Ben Rothwell</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>152 of 263</td>\n",
       "      <td>70 of 177</td>\n",
       "      <td>57%</td>\n",
       "      <td>39%</td>\n",
       "      <td>160 of 272</td>\n",
       "      <td>75 of 183</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Kerry Hatley</td>\n",
       "      <td>July 20, 2019</td>\n",
       "      <td>San Antonio, Texas, USA</td>\n",
       "      <td>Heavyweight Bout</td>\n",
       "      <td>Andrei Arlovski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Alex Caceres</td>\n",
       "      <td>Steven Peterson</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>94 of 197</td>\n",
       "      <td>67 of 218</td>\n",
       "      <td>47%</td>\n",
       "      <td>30%</td>\n",
       "      <td>95 of 198</td>\n",
       "      <td>87 of 241</td>\n",
       "      <td>...</td>\n",
       "      <td>2 of 4</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Dan Miragliotta</td>\n",
       "      <td>July 20, 2019</td>\n",
       "      <td>San Antonio, Texas, USA</td>\n",
       "      <td>Featherweight Bout</td>\n",
       "      <td>Alex Caceres</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Raquel Pennington</td>\n",
       "      <td>Irene Aldana</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>47 of 137</td>\n",
       "      <td>52 of 184</td>\n",
       "      <td>34%</td>\n",
       "      <td>28%</td>\n",
       "      <td>86 of 181</td>\n",
       "      <td>75 of 208</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Decision - Split</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Frank Collazo</td>\n",
       "      <td>July 20, 2019</td>\n",
       "      <td>San Antonio, Texas, USA</td>\n",
       "      <td>Women's Bantamweight Bout</td>\n",
       "      <td>Raquel Pennington</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Sam Alvey</td>\n",
       "      <td>Klidson Abreu</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>28 of 77</td>\n",
       "      <td>36 of 89</td>\n",
       "      <td>36%</td>\n",
       "      <td>40%</td>\n",
       "      <td>67 of 117</td>\n",
       "      <td>61 of 115</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Jacob Montalvo</td>\n",
       "      <td>July 20, 2019</td>\n",
       "      <td>San Antonio, Texas, USA</td>\n",
       "      <td>Light Heavyweight Bout</td>\n",
       "      <td>Klidson Abreu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Roxanne Modafferi</td>\n",
       "      <td>Jennifer Maia</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>29 of 110</td>\n",
       "      <td>83 of 174</td>\n",
       "      <td>26%</td>\n",
       "      <td>47%</td>\n",
       "      <td>76 of 161</td>\n",
       "      <td>111 of 205</td>\n",
       "      <td>...</td>\n",
       "      <td>1 of 4</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Jacob Montalvo</td>\n",
       "      <td>July 20, 2019</td>\n",
       "      <td>San Antonio, Texas, USA</td>\n",
       "      <td>Women's Flyweight Bout</td>\n",
       "      <td>Jennifer Maia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Ray Borg</td>\n",
       "      <td>Gabriel Silva</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15 of 23</td>\n",
       "      <td>8 of 16</td>\n",
       "      <td>65%</td>\n",
       "      <td>50%</td>\n",
       "      <td>23 of 34</td>\n",
       "      <td>58 of 76</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Dan Miragliotta</td>\n",
       "      <td>July 20, 2019</td>\n",
       "      <td>San Antonio, Texas, USA</td>\n",
       "      <td>Bantamweight Bout</td>\n",
       "      <td>Ray Borg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Mario Bautista</td>\n",
       "      <td>Jinsoo Son</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>129 of 248</td>\n",
       "      <td>95 of 200</td>\n",
       "      <td>52%</td>\n",
       "      <td>47%</td>\n",
       "      <td>179 of 301</td>\n",
       "      <td>106 of 213</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Kerry Hatley</td>\n",
       "      <td>July 20, 2019</td>\n",
       "      <td>San Antonio, Texas, USA</td>\n",
       "      <td>Bantamweight Bout</td>\n",
       "      <td>Mario Bautista</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Domingo Pilarte</td>\n",
       "      <td>Felipe Colares</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11 of 21</td>\n",
       "      <td>23 of 42</td>\n",
       "      <td>52%</td>\n",
       "      <td>54%</td>\n",
       "      <td>69 of 89</td>\n",
       "      <td>92 of 132</td>\n",
       "      <td>...</td>\n",
       "      <td>7 of 14</td>\n",
       "      <td>Decision - Split</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Frank Collazo</td>\n",
       "      <td>July 20, 2019</td>\n",
       "      <td>San Antonio, Texas, USA</td>\n",
       "      <td>Bantamweight Bout</td>\n",
       "      <td>Felipe Colares</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Germaine de Randamie</td>\n",
       "      <td>Aspen Ladd</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>4 of 5</td>\n",
       "      <td>0 of 4</td>\n",
       "      <td>80%</td>\n",
       "      <td>0%</td>\n",
       "      <td>4 of 5</td>\n",
       "      <td>0 of 4</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>0:16</td>\n",
       "      <td>5 Rnd (5-5-5-5-5)</td>\n",
       "      <td>Herb Dean</td>\n",
       "      <td>July 13, 2019</td>\n",
       "      <td>Sacramento, California, USA</td>\n",
       "      <td>Women's Bantamweight Bout</td>\n",
       "      <td>Germaine de Randamie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Urijah Faber</td>\n",
       "      <td>Ricky Simon</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>11 of 15</td>\n",
       "      <td>4 of 8</td>\n",
       "      <td>73%</td>\n",
       "      <td>50%</td>\n",
       "      <td>11 of 15</td>\n",
       "      <td>4 of 8</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>0:46</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Mike Beltran</td>\n",
       "      <td>July 13, 2019</td>\n",
       "      <td>Sacramento, California, USA</td>\n",
       "      <td>Bantamweight Bout</td>\n",
       "      <td>Urijah Faber</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Josh Emmett</td>\n",
       "      <td>Mirsad Bektic</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>27 of 52</td>\n",
       "      <td>10 of 65</td>\n",
       "      <td>51%</td>\n",
       "      <td>15%</td>\n",
       "      <td>33 of 60</td>\n",
       "      <td>10 of 65</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>4:25</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Jason Herzog</td>\n",
       "      <td>July 13, 2019</td>\n",
       "      <td>Sacramento, California, USA</td>\n",
       "      <td>Featherweight Bout</td>\n",
       "      <td>Josh Emmett</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Karl Roberson</td>\n",
       "      <td>Wellington Turman</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>50 of 80</td>\n",
       "      <td>25 of 51</td>\n",
       "      <td>62%</td>\n",
       "      <td>49%</td>\n",
       "      <td>79 of 113</td>\n",
       "      <td>38 of 67</td>\n",
       "      <td>...</td>\n",
       "      <td>12 of 18</td>\n",
       "      <td>Decision - Split</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Blake Grice</td>\n",
       "      <td>July 13, 2019</td>\n",
       "      <td>Sacramento, California, USA</td>\n",
       "      <td>Middleweight Bout</td>\n",
       "      <td>Karl Roberson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Marvin Vettori</td>\n",
       "      <td>Cezar Ferreira</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>78 of 148</td>\n",
       "      <td>39 of 88</td>\n",
       "      <td>52%</td>\n",
       "      <td>44%</td>\n",
       "      <td>106 of 176</td>\n",
       "      <td>41 of 90</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Herb Dean</td>\n",
       "      <td>July 13, 2019</td>\n",
       "      <td>Sacramento, California, USA</td>\n",
       "      <td>Middleweight Bout</td>\n",
       "      <td>Marvin Vettori</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Mike Rodriguez</td>\n",
       "      <td>John Allan</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>70 of 161</td>\n",
       "      <td>55 of 128</td>\n",
       "      <td>43%</td>\n",
       "      <td>42%</td>\n",
       "      <td>95 of 186</td>\n",
       "      <td>75 of 154</td>\n",
       "      <td>...</td>\n",
       "      <td>15 of 19</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Mike Beltran</td>\n",
       "      <td>July 13, 2019</td>\n",
       "      <td>Sacramento, California, USA</td>\n",
       "      <td>Light Heavyweight Bout</td>\n",
       "      <td>John Allan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Renato Moicano</td>\n",
       "      <td>Chan Sung Jung</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0 of 3</td>\n",
       "      <td>16 of 24</td>\n",
       "      <td>0%</td>\n",
       "      <td>66%</td>\n",
       "      <td>0 of 3</td>\n",
       "      <td>18 of 26</td>\n",
       "      <td>...</td>\n",
       "      <td>13 of 18</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>0:58</td>\n",
       "      <td>5 Rnd (5-5-5-5-5)</td>\n",
       "      <td>Blake Grice</td>\n",
       "      <td>June 22, 2019</td>\n",
       "      <td>Greenville, South Carolina, USA</td>\n",
       "      <td>Featherweight Bout</td>\n",
       "      <td>Chan Sung Jung</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Bryan Barberena</td>\n",
       "      <td>Randy Brown</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>47 of 101</td>\n",
       "      <td>89 of 152</td>\n",
       "      <td>46%</td>\n",
       "      <td>58%</td>\n",
       "      <td>122 of 178</td>\n",
       "      <td>91 of 154</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>3</td>\n",
       "      <td>2:54</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Dan Miragliotta</td>\n",
       "      <td>June 22, 2019</td>\n",
       "      <td>Greenville, South Carolina, USA</td>\n",
       "      <td>Welterweight Bout</td>\n",
       "      <td>Randy Brown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Andre Ewell</td>\n",
       "      <td>Anderson Dos Santos</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>73 of 173</td>\n",
       "      <td>35 of 132</td>\n",
       "      <td>42%</td>\n",
       "      <td>26%</td>\n",
       "      <td>74 of 174</td>\n",
       "      <td>63 of 163</td>\n",
       "      <td>...</td>\n",
       "      <td>2 of 5</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Gary Copeland</td>\n",
       "      <td>June 22, 2019</td>\n",
       "      <td>Greenville, South Carolina, USA</td>\n",
       "      <td>Bantamweight Bout</td>\n",
       "      <td>Andre Ewell</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Andrea Lee</td>\n",
       "      <td>Montana De La Rosa</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>73 of 126</td>\n",
       "      <td>14 of 107</td>\n",
       "      <td>57%</td>\n",
       "      <td>13%</td>\n",
       "      <td>82 of 135</td>\n",
       "      <td>40 of 136</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 1</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Gary Copeland</td>\n",
       "      <td>June 22, 2019</td>\n",
       "      <td>Greenville, South Carolina, USA</td>\n",
       "      <td>Women's Flyweight Bout</td>\n",
       "      <td>Andrea Lee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Kevin Holland</td>\n",
       "      <td>Alessio Di Chirico</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>58 of 117</td>\n",
       "      <td>51 of 84</td>\n",
       "      <td>49%</td>\n",
       "      <td>60%</td>\n",
       "      <td>192 of 253</td>\n",
       "      <td>62 of 97</td>\n",
       "      <td>...</td>\n",
       "      <td>1 of 1</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Blake Grice</td>\n",
       "      <td>June 22, 2019</td>\n",
       "      <td>Greenville, South Carolina, USA</td>\n",
       "      <td>Middleweight Bout</td>\n",
       "      <td>Kevin Holland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Dan Ige</td>\n",
       "      <td>Kevin Aguilar</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>71 of 125</td>\n",
       "      <td>33 of 104</td>\n",
       "      <td>56%</td>\n",
       "      <td>31%</td>\n",
       "      <td>92 of 146</td>\n",
       "      <td>65 of 136</td>\n",
       "      <td>...</td>\n",
       "      <td>7 of 11</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Jimmy Neely</td>\n",
       "      <td>June 22, 2019</td>\n",
       "      <td>Greenville, South Carolina, USA</td>\n",
       "      <td>Featherweight Bout</td>\n",
       "      <td>Dan Ige</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Ashley Yoder</td>\n",
       "      <td>Syuri Kondo</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>75 of 100</td>\n",
       "      <td>23 of 40</td>\n",
       "      <td>75%</td>\n",
       "      <td>57%</td>\n",
       "      <td>147 of 194</td>\n",
       "      <td>35 of 56</td>\n",
       "      <td>...</td>\n",
       "      <td>3 of 3</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Gary Copeland</td>\n",
       "      <td>June 22, 2019</td>\n",
       "      <td>Greenville, South Carolina, USA</td>\n",
       "      <td>Women's Strawweight Bout</td>\n",
       "      <td>Ashley Yoder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Matt Wiman</td>\n",
       "      <td>Luis Pena</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24 of 42</td>\n",
       "      <td>87 of 148</td>\n",
       "      <td>57%</td>\n",
       "      <td>58%</td>\n",
       "      <td>28 of 46</td>\n",
       "      <td>98 of 160</td>\n",
       "      <td>...</td>\n",
       "      <td>60 of 91</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>3</td>\n",
       "      <td>1:14</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Dan Miragliotta</td>\n",
       "      <td>June 22, 2019</td>\n",
       "      <td>Greenville, South Carolina, USA</td>\n",
       "      <td>Lightweight Bout</td>\n",
       "      <td>Luis Pena</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Allen Crowder</td>\n",
       "      <td>Jairzinho Rozenstruik</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0 of 1</td>\n",
       "      <td>4 of 4</td>\n",
       "      <td>0%</td>\n",
       "      <td>100%</td>\n",
       "      <td>0 of 1</td>\n",
       "      <td>4 of 4</td>\n",
       "      <td>...</td>\n",
       "      <td>3 of 3</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>0:09</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Blake Grice</td>\n",
       "      <td>June 22, 2019</td>\n",
       "      <td>Greenville, South Carolina, USA</td>\n",
       "      <td>Heavyweight Bout</td>\n",
       "      <td>Jairzinho Rozenstruik</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Ariane Lipski</td>\n",
       "      <td>Molly McCann</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>68 of 271</td>\n",
       "      <td>108 of 213</td>\n",
       "      <td>25%</td>\n",
       "      <td>50%</td>\n",
       "      <td>68 of 271</td>\n",
       "      <td>109 of 214</td>\n",
       "      <td>...</td>\n",
       "      <td>8 of 15</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Jimmy Neely</td>\n",
       "      <td>June 22, 2019</td>\n",
       "      <td>Greenville, South Carolina, USA</td>\n",
       "      <td>Women's Flyweight Bout</td>\n",
       "      <td>Molly McCann</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Deron Winn</td>\n",
       "      <td>Eric Spicely</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>169 of 367</td>\n",
       "      <td>108 of 224</td>\n",
       "      <td>46%</td>\n",
       "      <td>48%</td>\n",
       "      <td>171 of 369</td>\n",
       "      <td>108 of 224</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Dan Miragliotta</td>\n",
       "      <td>June 22, 2019</td>\n",
       "      <td>Greenville, South Carolina, USA</td>\n",
       "      <td>Middleweight Bout</td>\n",
       "      <td>Deron Winn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Henry Cejudo</td>\n",
       "      <td>Marlon Moraes</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90 of 171</td>\n",
       "      <td>57 of 119</td>\n",
       "      <td>52%</td>\n",
       "      <td>47%</td>\n",
       "      <td>99 of 182</td>\n",
       "      <td>59 of 121</td>\n",
       "      <td>...</td>\n",
       "      <td>1 of 1</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>3</td>\n",
       "      <td>4:51</td>\n",
       "      <td>5 Rnd (5-5-5-5-5)</td>\n",
       "      <td>Marc Goddard</td>\n",
       "      <td>June 08, 2019</td>\n",
       "      <td>Chicago, Illinois, USA</td>\n",
       "      <td>UFC Bantamweight Title Bout</td>\n",
       "      <td>Henry Cejudo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Valentina Shevchenko</td>\n",
       "      <td>Jessica Eye</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>8 of 11</td>\n",
       "      <td>2 of 12</td>\n",
       "      <td>72%</td>\n",
       "      <td>16%</td>\n",
       "      <td>37 of 40</td>\n",
       "      <td>42 of 52</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>2</td>\n",
       "      <td>0:26</td>\n",
       "      <td>5 Rnd (5-5-5-5-5)</td>\n",
       "      <td>Robert Madrigal</td>\n",
       "      <td>June 08, 2019</td>\n",
       "      <td>Chicago, Illinois, USA</td>\n",
       "      <td>UFC Women's Flyweight Title Bout</td>\n",
       "      <td>Valentina Shevchenko</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Tony Ferguson</td>\n",
       "      <td>Donald Cerrone</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>104 of 200</td>\n",
       "      <td>68 of 185</td>\n",
       "      <td>52%</td>\n",
       "      <td>36%</td>\n",
       "      <td>104 of 200</td>\n",
       "      <td>68 of 185</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>TKO - Doctor's Stoppage</td>\n",
       "      <td>2</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Dan Miragliotta</td>\n",
       "      <td>June 08, 2019</td>\n",
       "      <td>Chicago, Illinois, USA</td>\n",
       "      <td>Lightweight Bout</td>\n",
       "      <td>Tony Ferguson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Jimmie Rivera</td>\n",
       "      <td>Petr Yan</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>73 of 192</td>\n",
       "      <td>56 of 189</td>\n",
       "      <td>38%</td>\n",
       "      <td>29%</td>\n",
       "      <td>76 of 195</td>\n",
       "      <td>58 of 192</td>\n",
       "      <td>...</td>\n",
       "      <td>4 of 10</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Kevin MacDonald</td>\n",
       "      <td>June 08, 2019</td>\n",
       "      <td>Chicago, Illinois, USA</td>\n",
       "      <td>Bantamweight Bout</td>\n",
       "      <td>Petr Yan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Tai Tuivasa</td>\n",
       "      <td>Blagoy Ivanov</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>64 of 144</td>\n",
       "      <td>73 of 123</td>\n",
       "      <td>44%</td>\n",
       "      <td>59%</td>\n",
       "      <td>66 of 146</td>\n",
       "      <td>81 of 131</td>\n",
       "      <td>...</td>\n",
       "      <td>6 of 6</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Dan Miragliotta</td>\n",
       "      <td>June 08, 2019</td>\n",
       "      <td>Chicago, Illinois, USA</td>\n",
       "      <td>Heavyweight Bout</td>\n",
       "      <td>Blagoy Ivanov</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Tatiana Suarez</td>\n",
       "      <td>Nina Ansaroff</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>75 of 142</td>\n",
       "      <td>48 of 99</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>95 of 166</td>\n",
       "      <td>54 of 105</td>\n",
       "      <td>...</td>\n",
       "      <td>5 of 5</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Robert Madrigal</td>\n",
       "      <td>June 08, 2019</td>\n",
       "      <td>Chicago, Illinois, USA</td>\n",
       "      <td>Women's Strawweight Bout</td>\n",
       "      <td>Tatiana Suarez</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Aljamain Sterling</td>\n",
       "      <td>Pedro Munhoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>174 of 349</td>\n",
       "      <td>105 of 265</td>\n",
       "      <td>49%</td>\n",
       "      <td>39%</td>\n",
       "      <td>175 of 350</td>\n",
       "      <td>108 of 269</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Marc Goddard</td>\n",
       "      <td>June 08, 2019</td>\n",
       "      <td>Chicago, Illinois, USA</td>\n",
       "      <td>Bantamweight Bout</td>\n",
       "      <td>Aljamain Sterling</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Karolina Kowalkiewicz</td>\n",
       "      <td>Alexa Grasso</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90 of 232</td>\n",
       "      <td>148 of 369</td>\n",
       "      <td>38%</td>\n",
       "      <td>40%</td>\n",
       "      <td>92 of 234</td>\n",
       "      <td>163 of 384</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Kevin MacDonald</td>\n",
       "      <td>June 08, 2019</td>\n",
       "      <td>Chicago, Illinois, USA</td>\n",
       "      <td>Women's Strawweight Bout</td>\n",
       "      <td>Alexa Grasso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Ricardo Lamas</td>\n",
       "      <td>Calvin Kattar</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>12 of 29</td>\n",
       "      <td>22 of 41</td>\n",
       "      <td>41%</td>\n",
       "      <td>53%</td>\n",
       "      <td>12 of 29</td>\n",
       "      <td>22 of 41</td>\n",
       "      <td>...</td>\n",
       "      <td>4 of 5</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>4:06</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Dan Miragliotta</td>\n",
       "      <td>June 08, 2019</td>\n",
       "      <td>Chicago, Illinois, USA</td>\n",
       "      <td>Featherweight Bout</td>\n",
       "      <td>Calvin Kattar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Yan Xiaonan</td>\n",
       "      <td>Angela Hill</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>94 of 249</td>\n",
       "      <td>71 of 144</td>\n",
       "      <td>37%</td>\n",
       "      <td>49%</td>\n",
       "      <td>105 of 264</td>\n",
       "      <td>78 of 151</td>\n",
       "      <td>...</td>\n",
       "      <td>2 of 2</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Robert Madrigal</td>\n",
       "      <td>June 08, 2019</td>\n",
       "      <td>Chicago, Illinois, USA</td>\n",
       "      <td>Women's Strawweight Bout</td>\n",
       "      <td>Yan Xiaonan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Bevon Lewis</td>\n",
       "      <td>Darren Stewart</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>31 of 84</td>\n",
       "      <td>30 of 73</td>\n",
       "      <td>36%</td>\n",
       "      <td>41%</td>\n",
       "      <td>45 of 98</td>\n",
       "      <td>40 of 84</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Marc Goddard</td>\n",
       "      <td>June 08, 2019</td>\n",
       "      <td>Chicago, Illinois, USA</td>\n",
       "      <td>Middleweight Bout</td>\n",
       "      <td>Darren Stewart</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Eddie Wineland</td>\n",
       "      <td>Grigorii Popov</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>74 of 171</td>\n",
       "      <td>55 of 150</td>\n",
       "      <td>43%</td>\n",
       "      <td>36%</td>\n",
       "      <td>74 of 171</td>\n",
       "      <td>55 of 150</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>2</td>\n",
       "      <td>4:47</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Kevin MacDonald</td>\n",
       "      <td>June 08, 2019</td>\n",
       "      <td>Chicago, Illinois, USA</td>\n",
       "      <td>Bantamweight Bout</td>\n",
       "      <td>Eddie Wineland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Katlyn Chookagian</td>\n",
       "      <td>Joanne Calderwood</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>82 of 221</td>\n",
       "      <td>112 of 266</td>\n",
       "      <td>37%</td>\n",
       "      <td>42%</td>\n",
       "      <td>108 of 250</td>\n",
       "      <td>141 of 300</td>\n",
       "      <td>...</td>\n",
       "      <td>1 of 2</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Dan Miragliotta</td>\n",
       "      <td>June 08, 2019</td>\n",
       "      <td>Chicago, Illinois, USA</td>\n",
       "      <td>Women's Flyweight Bout</td>\n",
       "      <td>Katlyn Chookagian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Alexander Gustafsson</td>\n",
       "      <td>Anthony Smith</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>72 of 151</td>\n",
       "      <td>49 of 104</td>\n",
       "      <td>47%</td>\n",
       "      <td>47%</td>\n",
       "      <td>73 of 152</td>\n",
       "      <td>51 of 107</td>\n",
       "      <td>...</td>\n",
       "      <td>5 of 5</td>\n",
       "      <td>Submission</td>\n",
       "      <td>4</td>\n",
       "      <td>2:38</td>\n",
       "      <td>5 Rnd (5-5-5-5-5)</td>\n",
       "      <td>Marc Goddard</td>\n",
       "      <td>June 01, 2019</td>\n",
       "      <td>Stockholm, Sweden</td>\n",
       "      <td>Light Heavyweight Bout</td>\n",
       "      <td>Anthony Smith</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Jimi Manuwa</td>\n",
       "      <td>Aleksandar Rakic</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2 of 3</td>\n",
       "      <td>2 of 7</td>\n",
       "      <td>66%</td>\n",
       "      <td>28%</td>\n",
       "      <td>2 of 3</td>\n",
       "      <td>2 of 7</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>KO/TKO</td>\n",
       "      <td>1</td>\n",
       "      <td>0:47</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Kevin Sataki</td>\n",
       "      <td>June 01, 2019</td>\n",
       "      <td>Stockholm, Sweden</td>\n",
       "      <td>Light Heavyweight Bout</td>\n",
       "      <td>Aleksandar Rakic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Makwan Amirkhani</td>\n",
       "      <td>Chris Fishgold</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9 of 27</td>\n",
       "      <td>16 of 52</td>\n",
       "      <td>33%</td>\n",
       "      <td>30%</td>\n",
       "      <td>18 of 36</td>\n",
       "      <td>16 of 52</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Submission</td>\n",
       "      <td>2</td>\n",
       "      <td>4:25</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Marc Goddard</td>\n",
       "      <td>June 01, 2019</td>\n",
       "      <td>Stockholm, Sweden</td>\n",
       "      <td>Featherweight Bout</td>\n",
       "      <td>Makwan Amirkhani</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Damir Hadzovic</td>\n",
       "      <td>Christos Giagos</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24 of 61</td>\n",
       "      <td>47 of 113</td>\n",
       "      <td>39%</td>\n",
       "      <td>41%</td>\n",
       "      <td>42 of 87</td>\n",
       "      <td>67 of 141</td>\n",
       "      <td>...</td>\n",
       "      <td>3 of 12</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Rich Mitchell</td>\n",
       "      <td>June 01, 2019</td>\n",
       "      <td>Stockholm, Sweden</td>\n",
       "      <td>Lightweight Bout</td>\n",
       "      <td>Christos Giagos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Daniel Teymur</td>\n",
       "      <td>Sung Bin Jo</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40 of 83</td>\n",
       "      <td>21 of 63</td>\n",
       "      <td>48%</td>\n",
       "      <td>33%</td>\n",
       "      <td>49 of 93</td>\n",
       "      <td>23 of 65</td>\n",
       "      <td>...</td>\n",
       "      <td>1 of 1</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Rebin Saber</td>\n",
       "      <td>June 01, 2019</td>\n",
       "      <td>Stockholm, Sweden</td>\n",
       "      <td>Featherweight Bout</td>\n",
       "      <td>Daniel Teymur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Rostem Akman</td>\n",
       "      <td>Sergey Khandozhko</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>39 of 100</td>\n",
       "      <td>60 of 149</td>\n",
       "      <td>39%</td>\n",
       "      <td>40%</td>\n",
       "      <td>40 of 103</td>\n",
       "      <td>60 of 151</td>\n",
       "      <td>...</td>\n",
       "      <td>0 of 0</td>\n",
       "      <td>Decision - Unanimous</td>\n",
       "      <td>3</td>\n",
       "      <td>5:00</td>\n",
       "      <td>3 Rnd (5-5-5)</td>\n",
       "      <td>Leon Roberts</td>\n",
       "      <td>June 01, 2019</td>\n",
       "      <td>Stockholm, Sweden</td>\n",
       "      <td>Welterweight Bout</td>\n",
       "      <td>Sergey Khandozhko</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>90 rows × 41 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                R_fighter              B_fighter  R_KD  B_KD  R_SIG_STR.  \\\n",
       "0            Max Holloway          Frankie Edgar     0     0  129 of 328   \n",
       "1             Cris Cyborg        Felicia Spencer     0     0  122 of 216   \n",
       "2              Geoff Neal             Niko Price     0     1    41 of 61   \n",
       "3   Olivier Aubin-Mercier        Arman Tsarukyan     0     0    23 of 48   \n",
       "4    Marc-Andre Barriault        Krzysztof Jotko     0     0    39 of 77   \n",
       "5            Alexis Davis         Viviane Araujo     0     0   68 of 137   \n",
       "6           Hakeem Dawodu        Yoshinori Horie     1     0   80 of 154   \n",
       "7            Gavin Tucker          SeungWoo Choi     0     0    37 of 62   \n",
       "8       Alexandre Pantoja    Deiveson Figueiredo     0     1   61 of 151   \n",
       "9       Gillian Robertson            Sarah Frota     0     0    29 of 42   \n",
       "10              Erik Koch           Kyle Stewart     0     0    37 of 63   \n",
       "11       Rafael Dos Anjos           Leon Edwards     0     0   81 of 169   \n",
       "12        Aleksei Oleinik            Walt Harris     0     1      1 of 3   \n",
       "13             Greg Hardy             Juan Adams     0     0    36 of 38   \n",
       "14             James Vick             Dan Hooker     0     1     7 of 23   \n",
       "15    Alexander Hernandez     Francisco Trinaldo     0     0    25 of 91   \n",
       "16        Andrei Arlovski           Ben Rothwell     0     0  152 of 263   \n",
       "17           Alex Caceres        Steven Peterson     0     0   94 of 197   \n",
       "18      Raquel Pennington           Irene Aldana     0     0   47 of 137   \n",
       "19              Sam Alvey          Klidson Abreu     0     0    28 of 77   \n",
       "20      Roxanne Modafferi          Jennifer Maia     0     0   29 of 110   \n",
       "21               Ray Borg          Gabriel Silva     0     0    15 of 23   \n",
       "22         Mario Bautista             Jinsoo Son     0     0  129 of 248   \n",
       "23        Domingo Pilarte         Felipe Colares     0     0    11 of 21   \n",
       "24   Germaine de Randamie             Aspen Ladd     1     0      4 of 5   \n",
       "25           Urijah Faber            Ricky Simon     1     0    11 of 15   \n",
       "26            Josh Emmett          Mirsad Bektic     1     0    27 of 52   \n",
       "27          Karl Roberson      Wellington Turman     0     0    50 of 80   \n",
       "28         Marvin Vettori         Cezar Ferreira     0     0   78 of 148   \n",
       "29         Mike Rodriguez             John Allan     0     0   70 of 161   \n",
       "..                    ...                    ...   ...   ...         ...   \n",
       "60         Renato Moicano         Chan Sung Jung     0     1      0 of 3   \n",
       "61        Bryan Barberena            Randy Brown     0     1   47 of 101   \n",
       "62            Andre Ewell    Anderson Dos Santos     0     0   73 of 173   \n",
       "63             Andrea Lee     Montana De La Rosa     0     0   73 of 126   \n",
       "64          Kevin Holland     Alessio Di Chirico     0     0   58 of 117   \n",
       "65                Dan Ige          Kevin Aguilar     1     0   71 of 125   \n",
       "66           Ashley Yoder            Syuri Kondo     0     0   75 of 100   \n",
       "67             Matt Wiman              Luis Pena     0     0    24 of 42   \n",
       "68          Allen Crowder  Jairzinho Rozenstruik     0     1      0 of 1   \n",
       "69          Ariane Lipski           Molly McCann     0     0   68 of 271   \n",
       "70             Deron Winn           Eric Spicely     0     0  169 of 367   \n",
       "71           Henry Cejudo          Marlon Moraes     0     0   90 of 171   \n",
       "72   Valentina Shevchenko            Jessica Eye     1     0     8 of 11   \n",
       "73          Tony Ferguson         Donald Cerrone     0     0  104 of 200   \n",
       "74          Jimmie Rivera               Petr Yan     0     2   73 of 192   \n",
       "75            Tai Tuivasa          Blagoy Ivanov     0     1   64 of 144   \n",
       "76         Tatiana Suarez          Nina Ansaroff     0     0   75 of 142   \n",
       "77      Aljamain Sterling           Pedro Munhoz     0     0  174 of 349   \n",
       "78  Karolina Kowalkiewicz           Alexa Grasso     0     0   90 of 232   \n",
       "79          Ricardo Lamas          Calvin Kattar     0     1    12 of 29   \n",
       "80            Yan Xiaonan            Angela Hill     0     0   94 of 249   \n",
       "81            Bevon Lewis         Darren Stewart     0     0    31 of 84   \n",
       "82         Eddie Wineland         Grigorii Popov     2     0   74 of 171   \n",
       "83      Katlyn Chookagian      Joanne Calderwood     0     0   82 of 221   \n",
       "84   Alexander Gustafsson          Anthony Smith     0     0   72 of 151   \n",
       "85            Jimi Manuwa       Aleksandar Rakic     0     1      2 of 3   \n",
       "86       Makwan Amirkhani         Chris Fishgold     0     0     9 of 27   \n",
       "87         Damir Hadzovic        Christos Giagos     0     0    24 of 61   \n",
       "88          Daniel Teymur            Sung Bin Jo     0     0    40 of 83   \n",
       "89           Rostem Akman      Sergey Khandozhko     0     1   39 of 100   \n",
       "\n",
       "    B_SIG_STR. R_SIG_STR_pct B_SIG_STR_pct R_TOTAL_STR. B_TOTAL_STR.  \\\n",
       "0    96 of 264           39%           36%   131 of 330    96 of 264   \n",
       "1     38 of 85           56%           44%   138 of 234    64 of 115   \n",
       "2     24 of 57           67%           42%     53 of 73     42 of 79   \n",
       "3    47 of 105           47%           44%     36 of 61   110 of 174   \n",
       "4    40 of 117           50%           34%    62 of 102    98 of 181   \n",
       "5    67 of 148           49%           45%   134 of 213    79 of 162   \n",
       "6     39 of 79           51%           49%    89 of 166     41 of 81   \n",
       "7     23 of 96           59%           23%     49 of 77    42 of 116   \n",
       "8    67 of 113           40%           59%    68 of 160    71 of 117   \n",
       "9      9 of 20           69%           45%     51 of 64     33 of 46   \n",
       "10    23 of 64           58%           35%     67 of 99    68 of 119   \n",
       "11   92 of 215           47%           42%   129 of 219   113 of 244   \n",
       "12      4 of 7           33%           57%       1 of 3       4 of 7   \n",
       "13      3 of 7           94%           42%     36 of 38       3 of 7   \n",
       "14    22 of 41           30%           53%      7 of 23     22 of 41   \n",
       "15    25 of 52           27%           48%     26 of 92     28 of 55   \n",
       "16   70 of 177           57%           39%   160 of 272    75 of 183   \n",
       "17   67 of 218           47%           30%    95 of 198    87 of 241   \n",
       "18   52 of 184           34%           28%    86 of 181    75 of 208   \n",
       "19    36 of 89           36%           40%    67 of 117    61 of 115   \n",
       "20   83 of 174           26%           47%    76 of 161   111 of 205   \n",
       "21     8 of 16           65%           50%     23 of 34     58 of 76   \n",
       "22   95 of 200           52%           47%   179 of 301   106 of 213   \n",
       "23    23 of 42           52%           54%     69 of 89    92 of 132   \n",
       "24      0 of 4           80%            0%       4 of 5       0 of 4   \n",
       "25      4 of 8           73%           50%     11 of 15       4 of 8   \n",
       "26    10 of 65           51%           15%     33 of 60     10 of 65   \n",
       "27    25 of 51           62%           49%    79 of 113     38 of 67   \n",
       "28    39 of 88           52%           44%   106 of 176     41 of 90   \n",
       "29   55 of 128           43%           42%    95 of 186    75 of 154   \n",
       "..         ...           ...           ...          ...          ...   \n",
       "60    16 of 24            0%           66%       0 of 3     18 of 26   \n",
       "61   89 of 152           46%           58%   122 of 178    91 of 154   \n",
       "62   35 of 132           42%           26%    74 of 174    63 of 163   \n",
       "63   14 of 107           57%           13%    82 of 135    40 of 136   \n",
       "64    51 of 84           49%           60%   192 of 253     62 of 97   \n",
       "65   33 of 104           56%           31%    92 of 146    65 of 136   \n",
       "66    23 of 40           75%           57%   147 of 194     35 of 56   \n",
       "67   87 of 148           57%           58%     28 of 46    98 of 160   \n",
       "68      4 of 4            0%          100%       0 of 1       4 of 4   \n",
       "69  108 of 213           25%           50%    68 of 271   109 of 214   \n",
       "70  108 of 224           46%           48%   171 of 369   108 of 224   \n",
       "71   57 of 119           52%           47%    99 of 182    59 of 121   \n",
       "72     2 of 12           72%           16%     37 of 40     42 of 52   \n",
       "73   68 of 185           52%           36%   104 of 200    68 of 185   \n",
       "74   56 of 189           38%           29%    76 of 195    58 of 192   \n",
       "75   73 of 123           44%           59%    66 of 146    81 of 131   \n",
       "76    48 of 99           52%           48%    95 of 166    54 of 105   \n",
       "77  105 of 265           49%           39%   175 of 350   108 of 269   \n",
       "78  148 of 369           38%           40%    92 of 234   163 of 384   \n",
       "79    22 of 41           41%           53%     12 of 29     22 of 41   \n",
       "80   71 of 144           37%           49%   105 of 264    78 of 151   \n",
       "81    30 of 73           36%           41%     45 of 98     40 of 84   \n",
       "82   55 of 150           43%           36%    74 of 171    55 of 150   \n",
       "83  112 of 266           37%           42%   108 of 250   141 of 300   \n",
       "84   49 of 104           47%           47%    73 of 152    51 of 107   \n",
       "85      2 of 7           66%           28%       2 of 3       2 of 7   \n",
       "86    16 of 52           33%           30%     18 of 36     16 of 52   \n",
       "87   47 of 113           39%           41%     42 of 87    67 of 141   \n",
       "88    21 of 63           48%           33%     49 of 93     23 of 65   \n",
       "89   60 of 149           39%           40%    40 of 103    60 of 151   \n",
       "\n",
       "            ...            B_GROUND                   win_by last_round  \\\n",
       "0           ...              1 of 2     Decision - Unanimous          5   \n",
       "1           ...              4 of 6     Decision - Unanimous          3   \n",
       "2           ...             4 of 10                   KO/TKO          2   \n",
       "3           ...            22 of 29     Decision - Unanimous          3   \n",
       "4           ...              0 of 0         Decision - Split          3   \n",
       "5           ...              1 of 1     Decision - Unanimous          3   \n",
       "6           ...              0 of 0                   KO/TKO          3   \n",
       "7           ...              0 of 0               Submission          3   \n",
       "8           ...            10 of 16     Decision - Unanimous          3   \n",
       "9           ...             6 of 12                   KO/TKO          2   \n",
       "10          ...              0 of 0     Decision - Unanimous          3   \n",
       "11          ...              3 of 6     Decision - Unanimous          5   \n",
       "12          ...              2 of 2                   KO/TKO          1   \n",
       "13          ...              0 of 0                   KO/TKO          1   \n",
       "14          ...              3 of 3                   KO/TKO          1   \n",
       "15          ...              0 of 0     Decision - Unanimous          3   \n",
       "16          ...              0 of 0     Decision - Unanimous          3   \n",
       "17          ...              2 of 4     Decision - Unanimous          3   \n",
       "18          ...              0 of 0         Decision - Split          3   \n",
       "19          ...              0 of 0     Decision - Unanimous          3   \n",
       "20          ...              1 of 4     Decision - Unanimous          3   \n",
       "21          ...              0 of 0     Decision - Unanimous          3   \n",
       "22          ...              0 of 0     Decision - Unanimous          3   \n",
       "23          ...             7 of 14         Decision - Split          3   \n",
       "24          ...              0 of 0                   KO/TKO          1   \n",
       "25          ...              0 of 0                   KO/TKO          1   \n",
       "26          ...              0 of 0                   KO/TKO          1   \n",
       "27          ...            12 of 18         Decision - Split          3   \n",
       "28          ...              0 of 0     Decision - Unanimous          3   \n",
       "29          ...            15 of 19     Decision - Unanimous          3   \n",
       "..          ...                 ...                      ...        ...   \n",
       "60          ...            13 of 18                   KO/TKO          1   \n",
       "61          ...              0 of 0                   KO/TKO          3   \n",
       "62          ...              2 of 5     Decision - Unanimous          3   \n",
       "63          ...              0 of 1     Decision - Unanimous          3   \n",
       "64          ...              1 of 1     Decision - Unanimous          3   \n",
       "65          ...             7 of 11     Decision - Unanimous          3   \n",
       "66          ...              3 of 3     Decision - Unanimous          3   \n",
       "67          ...            60 of 91                   KO/TKO          3   \n",
       "68          ...              3 of 3                   KO/TKO          1   \n",
       "69          ...             8 of 15     Decision - Unanimous          3   \n",
       "70          ...              0 of 0     Decision - Unanimous          3   \n",
       "71          ...              1 of 1                   KO/TKO          3   \n",
       "72          ...              0 of 0                   KO/TKO          2   \n",
       "73          ...              0 of 0  TKO - Doctor's Stoppage          2   \n",
       "74          ...             4 of 10     Decision - Unanimous          3   \n",
       "75          ...              6 of 6     Decision - Unanimous          3   \n",
       "76          ...              5 of 5     Decision - Unanimous          3   \n",
       "77          ...              0 of 0     Decision - Unanimous          3   \n",
       "78          ...              0 of 0     Decision - Unanimous          3   \n",
       "79          ...              4 of 5                   KO/TKO          1   \n",
       "80          ...              2 of 2     Decision - Unanimous          3   \n",
       "81          ...              0 of 0     Decision - Unanimous          3   \n",
       "82          ...              0 of 0                   KO/TKO          2   \n",
       "83          ...              1 of 2     Decision - Unanimous          3   \n",
       "84          ...              5 of 5               Submission          4   \n",
       "85          ...              0 of 0                   KO/TKO          1   \n",
       "86          ...              0 of 0               Submission          2   \n",
       "87          ...             3 of 12     Decision - Unanimous          3   \n",
       "88          ...              1 of 1     Decision - Unanimous          3   \n",
       "89          ...              0 of 0     Decision - Unanimous          3   \n",
       "\n",
       "   last_round_time             Format          Referee           date  \\\n",
       "0             5:00  5 Rnd (5-5-5-5-5)        Herb Dean  July 27, 2019   \n",
       "1             5:00      3 Rnd (5-5-5)     Yves Lavigne  July 27, 2019   \n",
       "2             2:39      3 Rnd (5-5-5)  Dan Miragliotta  July 27, 2019   \n",
       "3             5:00      3 Rnd (5-5-5)     Marc Goddard  July 27, 2019   \n",
       "4             5:00      3 Rnd (5-5-5)        Herb Dean  July 27, 2019   \n",
       "5             5:00      3 Rnd (5-5-5)     Yves Lavigne  July 27, 2019   \n",
       "6             4:09      3 Rnd (5-5-5)    Kyle Cardinal  July 27, 2019   \n",
       "7             3:17      3 Rnd (5-5-5)     Marc Goddard  July 27, 2019   \n",
       "8             5:00      3 Rnd (5-5-5)  Dan Miragliotta  July 27, 2019   \n",
       "9             4:13      3 Rnd (5-5-5)    Kyle Cardinal  July 27, 2019   \n",
       "10            5:00      3 Rnd (5-5-5)     Marc Goddard  July 27, 2019   \n",
       "11            5:00  5 Rnd (5-5-5-5-5)  Dan Miragliotta  July 20, 2019   \n",
       "12            0:12      3 Rnd (5-5-5)   Jacob Montalvo  July 20, 2019   \n",
       "13            0:45      3 Rnd (5-5-5)  Dan Miragliotta  July 20, 2019   \n",
       "14            2:33      3 Rnd (5-5-5)     Kerry Hatley  July 20, 2019   \n",
       "15            5:00      3 Rnd (5-5-5)    Frank Collazo  July 20, 2019   \n",
       "16            5:00      3 Rnd (5-5-5)     Kerry Hatley  July 20, 2019   \n",
       "17            5:00      3 Rnd (5-5-5)  Dan Miragliotta  July 20, 2019   \n",
       "18            5:00      3 Rnd (5-5-5)    Frank Collazo  July 20, 2019   \n",
       "19            5:00      3 Rnd (5-5-5)   Jacob Montalvo  July 20, 2019   \n",
       "20            5:00      3 Rnd (5-5-5)   Jacob Montalvo  July 20, 2019   \n",
       "21            5:00      3 Rnd (5-5-5)  Dan Miragliotta  July 20, 2019   \n",
       "22            5:00      3 Rnd (5-5-5)     Kerry Hatley  July 20, 2019   \n",
       "23            5:00      3 Rnd (5-5-5)    Frank Collazo  July 20, 2019   \n",
       "24            0:16  5 Rnd (5-5-5-5-5)        Herb Dean  July 13, 2019   \n",
       "25            0:46      3 Rnd (5-5-5)     Mike Beltran  July 13, 2019   \n",
       "26            4:25      3 Rnd (5-5-5)     Jason Herzog  July 13, 2019   \n",
       "27            5:00      3 Rnd (5-5-5)      Blake Grice  July 13, 2019   \n",
       "28            5:00      3 Rnd (5-5-5)        Herb Dean  July 13, 2019   \n",
       "29            5:00      3 Rnd (5-5-5)     Mike Beltran  July 13, 2019   \n",
       "..             ...                ...              ...            ...   \n",
       "60            0:58  5 Rnd (5-5-5-5-5)      Blake Grice  June 22, 2019   \n",
       "61            2:54      3 Rnd (5-5-5)  Dan Miragliotta  June 22, 2019   \n",
       "62            5:00      3 Rnd (5-5-5)    Gary Copeland  June 22, 2019   \n",
       "63            5:00      3 Rnd (5-5-5)    Gary Copeland  June 22, 2019   \n",
       "64            5:00      3 Rnd (5-5-5)      Blake Grice  June 22, 2019   \n",
       "65            5:00      3 Rnd (5-5-5)      Jimmy Neely  June 22, 2019   \n",
       "66            5:00      3 Rnd (5-5-5)    Gary Copeland  June 22, 2019   \n",
       "67            1:14      3 Rnd (5-5-5)  Dan Miragliotta  June 22, 2019   \n",
       "68            0:09      3 Rnd (5-5-5)      Blake Grice  June 22, 2019   \n",
       "69            5:00      3 Rnd (5-5-5)      Jimmy Neely  June 22, 2019   \n",
       "70            5:00      3 Rnd (5-5-5)  Dan Miragliotta  June 22, 2019   \n",
       "71            4:51  5 Rnd (5-5-5-5-5)     Marc Goddard  June 08, 2019   \n",
       "72            0:26  5 Rnd (5-5-5-5-5)  Robert Madrigal  June 08, 2019   \n",
       "73            5:00      3 Rnd (5-5-5)  Dan Miragliotta  June 08, 2019   \n",
       "74            5:00      3 Rnd (5-5-5)  Kevin MacDonald  June 08, 2019   \n",
       "75            5:00      3 Rnd (5-5-5)  Dan Miragliotta  June 08, 2019   \n",
       "76            5:00      3 Rnd (5-5-5)  Robert Madrigal  June 08, 2019   \n",
       "77            5:00      3 Rnd (5-5-5)     Marc Goddard  June 08, 2019   \n",
       "78            5:00      3 Rnd (5-5-5)  Kevin MacDonald  June 08, 2019   \n",
       "79            4:06      3 Rnd (5-5-5)  Dan Miragliotta  June 08, 2019   \n",
       "80            5:00      3 Rnd (5-5-5)  Robert Madrigal  June 08, 2019   \n",
       "81            5:00      3 Rnd (5-5-5)     Marc Goddard  June 08, 2019   \n",
       "82            4:47      3 Rnd (5-5-5)  Kevin MacDonald  June 08, 2019   \n",
       "83            5:00      3 Rnd (5-5-5)  Dan Miragliotta  June 08, 2019   \n",
       "84            2:38  5 Rnd (5-5-5-5-5)     Marc Goddard  June 01, 2019   \n",
       "85            0:47      3 Rnd (5-5-5)     Kevin Sataki  June 01, 2019   \n",
       "86            4:25      3 Rnd (5-5-5)     Marc Goddard  June 01, 2019   \n",
       "87            5:00      3 Rnd (5-5-5)    Rich Mitchell  June 01, 2019   \n",
       "88            5:00      3 Rnd (5-5-5)      Rebin Saber  June 01, 2019   \n",
       "89            5:00      3 Rnd (5-5-5)     Leon Roberts  June 01, 2019   \n",
       "\n",
       "                           location                        Fight_type  \\\n",
       "0         Edmonton, Alberta, Canada      UFC Featherweight Title Bout   \n",
       "1         Edmonton, Alberta, Canada        Women's Featherweight Bout   \n",
       "2         Edmonton, Alberta, Canada                 Welterweight Bout   \n",
       "3         Edmonton, Alberta, Canada                  Lightweight Bout   \n",
       "4         Edmonton, Alberta, Canada                 Middleweight Bout   \n",
       "5         Edmonton, Alberta, Canada            Women's Flyweight Bout   \n",
       "6         Edmonton, Alberta, Canada                Featherweight Bout   \n",
       "7         Edmonton, Alberta, Canada                Featherweight Bout   \n",
       "8         Edmonton, Alberta, Canada                    Flyweight Bout   \n",
       "9         Edmonton, Alberta, Canada            Women's Flyweight Bout   \n",
       "10        Edmonton, Alberta, Canada                 Welterweight Bout   \n",
       "11          San Antonio, Texas, USA                 Welterweight Bout   \n",
       "12          San Antonio, Texas, USA                  Heavyweight Bout   \n",
       "13          San Antonio, Texas, USA                  Heavyweight Bout   \n",
       "14          San Antonio, Texas, USA                  Lightweight Bout   \n",
       "15          San Antonio, Texas, USA                  Lightweight Bout   \n",
       "16          San Antonio, Texas, USA                  Heavyweight Bout   \n",
       "17          San Antonio, Texas, USA                Featherweight Bout   \n",
       "18          San Antonio, Texas, USA         Women's Bantamweight Bout   \n",
       "19          San Antonio, Texas, USA            Light Heavyweight Bout   \n",
       "20          San Antonio, Texas, USA            Women's Flyweight Bout   \n",
       "21          San Antonio, Texas, USA                 Bantamweight Bout   \n",
       "22          San Antonio, Texas, USA                 Bantamweight Bout   \n",
       "23          San Antonio, Texas, USA                 Bantamweight Bout   \n",
       "24      Sacramento, California, USA         Women's Bantamweight Bout   \n",
       "25      Sacramento, California, USA                 Bantamweight Bout   \n",
       "26      Sacramento, California, USA                Featherweight Bout   \n",
       "27      Sacramento, California, USA                 Middleweight Bout   \n",
       "28      Sacramento, California, USA                 Middleweight Bout   \n",
       "29      Sacramento, California, USA            Light Heavyweight Bout   \n",
       "..                              ...                               ...   \n",
       "60  Greenville, South Carolina, USA                Featherweight Bout   \n",
       "61  Greenville, South Carolina, USA                 Welterweight Bout   \n",
       "62  Greenville, South Carolina, USA                 Bantamweight Bout   \n",
       "63  Greenville, South Carolina, USA            Women's Flyweight Bout   \n",
       "64  Greenville, South Carolina, USA                 Middleweight Bout   \n",
       "65  Greenville, South Carolina, USA                Featherweight Bout   \n",
       "66  Greenville, South Carolina, USA          Women's Strawweight Bout   \n",
       "67  Greenville, South Carolina, USA                  Lightweight Bout   \n",
       "68  Greenville, South Carolina, USA                  Heavyweight Bout   \n",
       "69  Greenville, South Carolina, USA            Women's Flyweight Bout   \n",
       "70  Greenville, South Carolina, USA                 Middleweight Bout   \n",
       "71           Chicago, Illinois, USA       UFC Bantamweight Title Bout   \n",
       "72           Chicago, Illinois, USA  UFC Women's Flyweight Title Bout   \n",
       "73           Chicago, Illinois, USA                  Lightweight Bout   \n",
       "74           Chicago, Illinois, USA                 Bantamweight Bout   \n",
       "75           Chicago, Illinois, USA                  Heavyweight Bout   \n",
       "76           Chicago, Illinois, USA          Women's Strawweight Bout   \n",
       "77           Chicago, Illinois, USA                 Bantamweight Bout   \n",
       "78           Chicago, Illinois, USA          Women's Strawweight Bout   \n",
       "79           Chicago, Illinois, USA                Featherweight Bout   \n",
       "80           Chicago, Illinois, USA          Women's Strawweight Bout   \n",
       "81           Chicago, Illinois, USA                 Middleweight Bout   \n",
       "82           Chicago, Illinois, USA                 Bantamweight Bout   \n",
       "83           Chicago, Illinois, USA            Women's Flyweight Bout   \n",
       "84                Stockholm, Sweden            Light Heavyweight Bout   \n",
       "85                Stockholm, Sweden            Light Heavyweight Bout   \n",
       "86                Stockholm, Sweden                Featherweight Bout   \n",
       "87                Stockholm, Sweden                  Lightweight Bout   \n",
       "88                Stockholm, Sweden                Featherweight Bout   \n",
       "89                Stockholm, Sweden                 Welterweight Bout   \n",
       "\n",
       "                   Winner  \n",
       "0            Max Holloway  \n",
       "1             Cris Cyborg  \n",
       "2              Geoff Neal  \n",
       "3         Arman Tsarukyan  \n",
       "4         Krzysztof Jotko  \n",
       "5          Viviane Araujo  \n",
       "6           Hakeem Dawodu  \n",
       "7            Gavin Tucker  \n",
       "8     Deiveson Figueiredo  \n",
       "9       Gillian Robertson  \n",
       "10              Erik Koch  \n",
       "11           Leon Edwards  \n",
       "12            Walt Harris  \n",
       "13             Greg Hardy  \n",
       "14             Dan Hooker  \n",
       "15    Alexander Hernandez  \n",
       "16        Andrei Arlovski  \n",
       "17           Alex Caceres  \n",
       "18      Raquel Pennington  \n",
       "19          Klidson Abreu  \n",
       "20          Jennifer Maia  \n",
       "21               Ray Borg  \n",
       "22         Mario Bautista  \n",
       "23         Felipe Colares  \n",
       "24   Germaine de Randamie  \n",
       "25           Urijah Faber  \n",
       "26            Josh Emmett  \n",
       "27          Karl Roberson  \n",
       "28         Marvin Vettori  \n",
       "29             John Allan  \n",
       "..                    ...  \n",
       "60         Chan Sung Jung  \n",
       "61            Randy Brown  \n",
       "62            Andre Ewell  \n",
       "63             Andrea Lee  \n",
       "64          Kevin Holland  \n",
       "65                Dan Ige  \n",
       "66           Ashley Yoder  \n",
       "67              Luis Pena  \n",
       "68  Jairzinho Rozenstruik  \n",
       "69           Molly McCann  \n",
       "70             Deron Winn  \n",
       "71           Henry Cejudo  \n",
       "72   Valentina Shevchenko  \n",
       "73          Tony Ferguson  \n",
       "74               Petr Yan  \n",
       "75          Blagoy Ivanov  \n",
       "76         Tatiana Suarez  \n",
       "77      Aljamain Sterling  \n",
       "78           Alexa Grasso  \n",
       "79          Calvin Kattar  \n",
       "80            Yan Xiaonan  \n",
       "81         Darren Stewart  \n",
       "82         Eddie Wineland  \n",
       "83      Katlyn Chookagian  \n",
       "84          Anthony Smith  \n",
       "85       Aleksandar Rakic  \n",
       "86       Makwan Amirkhani  \n",
       "87        Christos Giagos  \n",
       "88          Daniel Teymur  \n",
       "89      Sergey Khandozhko  \n",
       "\n",
       "[90 rows x 41 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[:90]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "weight_classes = ['Women\\'s Strawweight', 'Women\\'s Bantamweight', \n",
    "                  'Women\\'s Featherweight', 'Women\\'s Flyweight', 'Lightweight', \n",
    "                  'Welterweight', 'Middleweight','Light Heavyweight', \n",
    "                  'Heavyweight', 'Featherweight','Bantamweight', 'Flyweight', 'Open Weight']\n",
    "columns = ['R_SIG_STR.', 'B_SIG_STR.', 'R_TOTAL_STR.', 'B_TOTAL_STR.',\n",
    "       'R_TD', 'B_TD', 'R_HEAD', 'B_HEAD', 'R_BODY','B_BODY', 'R_LEG', 'B_LEG', \n",
    "        'R_DISTANCE', 'B_DISTANCE', 'R_CLINCH','B_CLINCH', 'R_GROUND', 'B_GROUND']\n",
    "\n",
    "pct_columns = ['R_SIG_STR_pct','B_SIG_STR_pct', 'R_TD_pct', 'B_TD_pct']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "def make_weight_class(X):\n",
    "    for weight_class in weight_classes:\n",
    "        if weight_class in X:\n",
    "            return weight_class\n",
    "    if X == 'Catch Weight Bout' or 'Catchweight Bout':\n",
    "        return 'Catch Weight'\n",
    "    else:\n",
    "        return 'Open Weight'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_total_time(row):\n",
    "    if row['Format'] in time_in_first_round.keys():\n",
    "        return (row['last_round'] - 1) * time_in_first_round[row['Format']] + row['last_round_time']\n",
    "    elif row['Format'] in exception_format_time.keys():\n",
    "        if (row['last_round'] - 1) >= 2:\n",
    "            return exception_format_time[row['Format']][0] + (row['last_round'] - 2) * \\\n",
    "                    exception_format_time[row['Format']][1] + row['last_round_time']\n",
    "        else:\n",
    "            return (row['last_round'] - 1) * exception_format_time[row['Format']][0] + row['last_round_time']\n",
    "    \n",
    "# So if the fight ended in round 1, we only need last_round_time. \n",
    "# If it ended in round 2, we need the full time of round 1 and the last_round_time\n",
    "# This works for fights with same time in each round and fights with only two rounds."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_no_of_rounds(X):\n",
    "    if X == 'No Time Limit':\n",
    "        return 1\n",
    "    else:\n",
    "        return len(X.split('(')[1].replace(')', '').split('-'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "attempt_suffix = '_att'\n",
    "landed_suffix = '_landed'\n",
    "\n",
    "for column in columns:\n",
    "    df[column+attempt_suffix] = df[column].apply(lambda X: int(X.split('of')[1]))\n",
    "    df[column+landed_suffix] = df[column].apply(lambda X: int(X.split('of')[0]))\n",
    "    \n",
    "df.drop(columns, axis=1, inplace=True)\n",
    "df['Winner'].fillna('Draw', inplace=True)\n",
    "\n",
    "for column in pct_columns:\n",
    "    df[column] = df[column].apply(lambda X: float(X.replace('%', ''))/100)\n",
    "    \n",
    "df['title_bout'] = df['Fight_type'].apply(lambda X: True if 'Title Bout' in X else False)\n",
    "df['weight_class'] = df['Fight_type'].apply(make_weight_class)\n",
    "\n",
    "time_in_first_round = {'3 Rnd (5-5-5)': 5*60, '5 Rnd (5-5-5-5-5)': 5*60, '1 Rnd + OT (12-3)': 12*60,\n",
    "       'No Time Limit': 1, '3 Rnd + OT (5-5-5-5)': 5*60, '1 Rnd (20)': 1*20,\n",
    "       '2 Rnd (5-5)': 5*60, '1 Rnd (15)': 15*60, '1 Rnd (10)': 10*60,\n",
    "       '1 Rnd (12)':12*60, '1 Rnd + OT (30-5)': 30*60, '1 Rnd (18)': 18*60, '1 Rnd + OT (15-3)': 15*60,\n",
    "       '1 Rnd (30)': 30*60, '1 Rnd + OT (31-5)': 31*5,\n",
    "       '1 Rnd + OT (27-3)': 27*60, '1 Rnd + OT (30-3)': 30*60}\n",
    "\n",
    "exception_format_time = {'1 Rnd + 2OT (15-3-3)': [15*60, 3*60], '1 Rnd + 2OT (24-3-3)': [24*60, 3*60]}\n",
    "\n",
    "df['last_round_time'] = df['last_round_time'].apply(lambda X: int(X.split(':')[0])*60 + int(X.split(':')[1]))\n",
    "\n",
    "df['total_time_fought(seconds)'] = df.apply(get_total_time, axis=1)\n",
    "\n",
    "df['no_of_rounds'] = df['Format'].apply(get_no_of_rounds)\n",
    "\n",
    "df2 = df.copy()\n",
    "df2.drop(['Format', 'Fight_type', 'last_round_time','R_KD', 'B_KD', 'R_SIG_STR_pct',\n",
    "       'B_SIG_STR_pct', 'R_TD_pct', 'B_TD_pct', 'R_SUB_ATT', 'B_SUB_ATT',\n",
    "       'R_PASS', 'B_PASS', 'R_REV', 'B_REV', 'win_by', 'last_round', \n",
    "        'R_SIG_STR._att', 'R_SIG_STR._landed',\n",
    "       'B_SIG_STR._att', 'B_SIG_STR._landed', 'R_TOTAL_STR._att',\n",
    "       'R_TOTAL_STR._landed', 'B_TOTAL_STR._att', 'B_TOTAL_STR._landed',\n",
    "       'R_TD_att', 'R_TD_landed', 'B_TD_att', 'B_TD_landed', 'R_HEAD_att',\n",
    "       'R_HEAD_landed', 'B_HEAD_att', 'B_HEAD_landed', 'R_BODY_att',\n",
    "       'R_BODY_landed', 'B_BODY_att', 'B_BODY_landed', 'R_LEG_att',\n",
    "       'R_LEG_landed', 'B_LEG_att', 'B_LEG_landed', 'R_DISTANCE_att',\n",
    "       'R_DISTANCE_landed', 'B_DISTANCE_att', 'B_DISTANCE_landed',\n",
    "       'R_CLINCH_att', 'R_CLINCH_landed', 'B_CLINCH_att', 'B_CLINCH_landed',\n",
    "       'R_GROUND_att', 'R_GROUND_landed', 'B_GROUND_att', 'B_GROUND_landed',\n",
    "        'total_time_fought(seconds)'], axis = 1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "red_fighters = df['R_fighter'].value_counts().index\n",
    "blue_fighters = df['B_fighter'].value_counts().index\n",
    "\n",
    "fighters = list(set(red_fighters) | set(blue_fighters))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_renamed_winner(row):\n",
    "    if row['R_fighter'] == row['Winner']:\n",
    "        return 'Red'\n",
    "    elif row['B_fighter'] == row['Winner']:\n",
    "        return 'Blue'\n",
    "    elif row['Winner'] == 'Draw':\n",
    "        return 'Draw'\n",
    "\n",
    "df2['Winner'] = df2[['R_fighter', 'B_fighter', 'Winner']].apply(get_renamed_winner, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.concat([df,pd.get_dummies(df['win_by'], prefix='win_by')],axis=1)\n",
    "df.drop(['win_by'],axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "Numerical_columns = ['hero_KD', 'opp_KD', 'hero_SIG_STR_pct',\n",
    "       'opp_SIG_STR_pct', 'hero_TD_pct', 'opp_TD_pct', 'hero_SUB_ATT', 'opp_SUB_ATT',\n",
    "       'hero_PASS', 'opp_PASS', 'hero_REV', 'opp_REV', 'hero_SIG_STR._att', 'hero_SIG_STR._landed',\n",
    "       'opp_SIG_STR._att', 'opp_SIG_STR._landed', 'hero_TOTAL_STR._att',\n",
    "       'hero_TOTAL_STR._landed', 'opp_TOTAL_STR._att', 'opp_TOTAL_STR._landed',\n",
    "       'hero_TD_att', 'hero_TD_landed', 'opp_TD_att', 'opp_TD_landed', 'hero_HEAD_att',\n",
    "       'hero_HEAD_landed', 'opp_HEAD_att', 'opp_HEAD_landed', 'hero_BODY_att',\n",
    "       'hero_BODY_landed', 'opp_BODY_att', 'opp_BODY_landed', 'hero_LEG_att',\n",
    "       'hero_LEG_landed', 'opp_LEG_att', 'opp_LEG_landed', 'hero_DISTANCE_att',\n",
    "       'hero_DISTANCE_landed', 'opp_DISTANCE_att', 'opp_DISTANCE_landed',\n",
    "       'hero_CLINCH_att', 'hero_CLINCH_landed', 'opp_CLINCH_att', 'opp_CLINCH_landed',\n",
    "       'hero_GROUND_att', 'hero_GROUND_landed', 'opp_GROUND_att', 'opp_GROUND_landed',\n",
    "       'total_time_fought(seconds)']\n",
    "\n",
    "Categorical_columns = ['win_by', 'last_round',\n",
    "        'Winner', 'title_bout']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "import re\n",
    "\n",
    "def lreplace(pattern, sub, string):\n",
    "    \"\"\"\n",
    "    Replaces 'pattern' in 'string' with 'sub' if 'pattern' starts 'string'.\n",
    "    \"\"\"\n",
    "    return re.sub('^%s' % pattern, sub, string)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "red = df.groupby('R_fighter')\n",
    "blue = df.groupby('B_fighter')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "def get_fighter_red(fighter_name):\n",
    "    try:\n",
    "        fighter_red = red.get_group(fighter_name)\n",
    "    except:\n",
    "        return None\n",
    "    rename_columns = {}\n",
    "    for column in fighter_red.columns:\n",
    "        if re.search('^R_', column) is not None:\n",
    "            rename_columns[column] = lreplace('R_', 'hero_', column)\n",
    "        elif re.search('^B_', column) is not None:\n",
    "            rename_columns[column] = lreplace('B_', 'opp_', column)\n",
    "    fighter_red = fighter_red.rename(rename_columns, axis='columns')\n",
    "    return fighter_red"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_fighter_blue(fighter_name):\n",
    "    try:\n",
    "        fighter_blue = blue.get_group(fighter_name)\n",
    "    except:\n",
    "        return None\n",
    "    rename_columns = {}\n",
    "    for column in fighter_blue.columns:\n",
    "        if re.search('^B_', column) is not None:\n",
    "            rename_columns[column] = lreplace('B_', 'hero_', column)\n",
    "        elif re.search('^R_', column) is not None:\n",
    "            rename_columns[column] = lreplace('R_', 'opp_', column)\n",
    "    fighter_blue = fighter_blue.rename(rename_columns, axis='columns')\n",
    "    return fighter_blue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_result_stats(result_list):\n",
    "    result_list.reverse() # To get it in ascending order\n",
    "    current_win_streak = 0\n",
    "    current_lose_streak = 0\n",
    "    longest_win_streak = 0\n",
    "    wins = 0\n",
    "    losses = 0\n",
    "    draw = 0\n",
    "    for result in result_list:\n",
    "        if result == 'hero':\n",
    "            wins += 1\n",
    "            current_win_streak += 1\n",
    "            current_lose_streak = 0\n",
    "            if longest_win_streak < current_win_streak:\n",
    "                longest_win_streak += 1\n",
    "        elif result == 'opp':\n",
    "            losses += 1\n",
    "            current_win_streak = 0\n",
    "            current_lose_streak += 1\n",
    "        elif result == 'draw':\n",
    "            draw += 1\n",
    "            current_lose_streak = 0\n",
    "            current_win_streak = 0\n",
    "            \n",
    "    return current_win_streak, current_lose_streak, longest_win_streak, wins, losses, draw"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "win_by_columns = ['win_by_Decision - Majority', 'win_by_Decision - Split',\n",
    "       'win_by_Decision - Unanimous', 'win_by_KO/TKO','win_by_Submission',\n",
    "       'win_by_TKO - Doctor\\'s Stoppage']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp_blue_frame = pd.DataFrame()\n",
    "temp_red_frame = pd.DataFrame()\n",
    "latest_fighter_stats = pd.DataFrame()\n",
    "result_stats = ['current_win_streak', 'current_lose_streak', 'longest_win_streak', 'wins', 'losses', 'draw']\n",
    "\n",
    "for fighter_name in fighters:\n",
    "    fighter_red = get_fighter_red(fighter_name)\n",
    "    fighter_blue = get_fighter_blue(fighter_name)\n",
    "    fighter_index = None\n",
    "\n",
    "    if fighter_red is None:\n",
    "        fighter = fighter_blue\n",
    "        fighter_index = 'blue'\n",
    "    elif fighter_blue is None:\n",
    "        fighter = fighter_red\n",
    "        fighter_index = 'red'\n",
    "    else:\n",
    "        fighter = pd.concat([fighter_red, fighter_blue]).sort_index()\n",
    "\n",
    "    fighter['Winner'] = fighter['Winner'].apply(lambda X: 'hero' if X == fighter_name else 'opp')\n",
    "\n",
    "    latest = fighter[Numerical_columns].mean()\n",
    "    latest['total_rounds_fought'] = fighter['last_round'].sum()\n",
    "    latest['total_title_bouts'] = fighter[fighter['title_bout']==True]['title_bout'].count()\n",
    "    latest['hero_fighter'] = fighter_name\n",
    "    results = get_result_stats(list(fighter['Winner']))\n",
    "    for result_stat, result in zip(result_stats, results):\n",
    "        latest[result_stat] = result\n",
    "    win_by_results = fighter[fighter['Winner'] == 'hero'][win_by_columns].sum()\n",
    "    for win_by_column,win_by_result in zip(win_by_columns, win_by_results):\n",
    "        latest[win_by_column] = win_by_result\n",
    "    latest.name = fighter_name\n",
    "\n",
    "    latest_fighter_stats = latest_fighter_stats.append(latest)\n",
    "    \n",
    "    for i, index in enumerate(fighter.index):\n",
    "        fighter_slice = fighter[(i+1):]\n",
    "        s = fighter_slice[Numerical_columns].mean()\n",
    "        s['total_rounds_fought'] = fighter_slice['last_round'].sum()\n",
    "        s['total_title_bouts'] = fighter_slice[fighter_slice['title_bout']==True]['title_bout'].count()\n",
    "        s['hero_fighter'] = fighter_name\n",
    "        results = get_result_stats(list(fighter_slice['Winner']))\n",
    "        for result_stat, result in zip(result_stats, results):\n",
    "            s[result_stat] = result\n",
    "        win_by_results = fighter_slice[fighter_slice['Winner'] == 'hero'][win_by_columns].sum()\n",
    "        for win_by_column,win_by_result in zip(win_by_columns, win_by_results):\n",
    "            s[win_by_column] = win_by_result\n",
    "        s.name = index\n",
    "\n",
    "        if fighter_index is None:\n",
    "            if index in fighter_blue.index:\n",
    "                temp_blue_frame = temp_blue_frame.append(s)\n",
    "            elif index in fighter_red.index:\n",
    "                temp_red_frame = temp_red_frame.append(s)\n",
    "        elif fighter_index == 'blue':\n",
    "            temp_blue_frame = temp_blue_frame.append(s)\n",
    "        elif fighter_index == 'red':\n",
    "            temp_red_frame = temp_red_frame.append(s)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "fighter_details = fighter_details[fighter_details.index.isin(fighters)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "def convert_to_cms(X):\n",
    "    if X is np.NaN:\n",
    "        return X\n",
    "    elif len(X.split(\"'\")) == 2:\n",
    "        feet = float(X.split(\"'\")[0])\n",
    "        inches = int(X.split(\"'\")[1].replace(' ', '').replace('\"',''))\n",
    "        return (feet * 30.48) + (inches * 2.54)\n",
    "    else:\n",
    "        return float(X.replace('\"','')) * 2.54"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "fighter_details['Height_cms'] = fighter_details['Height'].apply(convert_to_cms)\n",
    "fighter_details['Reach_cms'] = fighter_details['Reach'].apply(convert_to_cms)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "fighter_details['Weight_lbs'] = fighter_details['Weight'].apply(lambda X: float(X.replace(' lbs.', '')) if X is not np.NaN else X)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "fighter_details.drop(['Height', 'Weight', 'Reach'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "fighter_details.reset_index(inplace=True)\n",
    "latest_fighter_stats.reset_index(inplace=True)\n",
    "temp_red_frame.reset_index(inplace=True)\n",
    "temp_blue_frame.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp_blue_frame = temp_blue_frame.merge(fighter_details, left_on='hero_fighter', right_on='fighter_name', how='left')\n",
    "temp_blue_frame.set_index('index', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "latest_fighter_stats = latest_fighter_stats.merge(fighter_details, left_on='index', right_on='fighter_name', how='left')\n",
    "latest_fighter_stats.set_index('index', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp_red_frame = temp_red_frame.merge(fighter_details, left_on='hero_fighter', right_on='fighter_name', how='left')\n",
    "temp_red_frame.set_index('index', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "temp_blue_frame.drop('fighter_name', axis=1, inplace=True)\n",
    "temp_red_frame.drop('fighter_name', axis=1, inplace=True)\n",
    "latest_fighter_stats.drop('fighter_name', axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "blue_frame = temp_blue_frame.add_prefix('B_')\n",
    "red_frame = temp_red_frame.add_prefix('R_')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "frame = blue_frame.join(red_frame, how='outer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "rename_cols = {}\n",
    "for col in frame.columns:\n",
    "    if 'hero' in col:\n",
    "        rename_cols[col] = col.replace('_hero_', '_avg_').replace('.', '')\n",
    "    if 'opp' in col:\n",
    "        rename_cols[col] = col.replace('_opp_', '_avg_opp_').replace('.', '')\n",
    "    if 'win_by' in col:\n",
    "        rename_cols[col] = col.replace(' ', '').replace('-', '_').replace('\\'s', '_')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "fs_rename_cols = {}\n",
    "for col in latest_fighter_stats.columns:\n",
    "    if 'hero' in col:\n",
    "        fs_rename_cols[col] = col.replace('hero_', 'avg_').replace('.', '')\n",
    "    if 'opp' in col:\n",
    "        fs_rename_cols[col] = col.replace('opp_', 'avg_opp_').replace('.', '')\n",
    "    if 'win_by' in col:\n",
    "        fs_rename_cols[col] = col.replace(' ', '').replace('-', '_').replace('\\'s', '_')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "frame.rename(rename_cols, axis='columns', inplace=True)\n",
    "latest_fighter_stats.rename(fs_rename_cols, axis='columns', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "frame.drop(['R_avg_fighter','B_avg_fighter'], axis=1, inplace=True)\n",
    "latest_fighter_stats.drop(['avg_fighter'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = df2.join(frame, how='outer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2['R_DOB'] = pd.to_datetime(df2['R_DOB'])\n",
    "df2['B_DOB'] = pd.to_datetime(df2['B_DOB'])\n",
    "df2['date'] = pd.to_datetime(df2['date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_age(row):\n",
    "    B_age = (row['date'] - row['B_DOB']).days\n",
    "    R_age = (row['date'] - row['R_DOB']).days\n",
    "    if np.isnan(B_age)!=True:\n",
    "        B_age = math.floor(B_age/365.25)\n",
    "    if np.isnan(R_age)!=True:\n",
    "        R_age = math.floor(R_age/365.25)\n",
    "    return pd.Series([B_age, R_age], index=['B_age', 'R_age'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2[['B_age', 'R_age']]= df2[['date', 'R_DOB', 'B_DOB']].apply(get_age, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2['R_Reach_cms'].fillna(df2['R_Height_cms'], inplace=True)\n",
    "df2['B_Reach_cms'].fillna(df2['B_Height_cms'], inplace=True)\n",
    "df2.fillna(df2.median(), inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "latest_fighter_stats['Reach_cms'].fillna(latest_fighter_stats['Height_cms'], inplace=True)\n",
    "latest_fighter_stats.fillna(latest_fighter_stats.median(), inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2['R_Stance'].fillna('Orthodox', inplace=True)\n",
    "df2['B_Stance'].fillna('Orthodox', inplace=True)\n",
    "latest_fighter_stats['Stance'].fillna('Orthodox', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = pd.concat([df2, pd.get_dummies(df2[['weight_class', 'B_Stance', 'R_Stance']])], axis=1)\n",
    "df2.drop(columns=['weight_class', 'B_Stance', 'R_Stance', \n",
    "                  'location', 'date', 'R_fighter', 'B_fighter', 'R_DOB', 'B_DOB', 'Referee'], inplace=True)\n",
    "df2.drop(df2.index[df2['Winner'] == 'Draw'], inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "latest_fighter_stats = pd.concat([latest_fighter_stats, pd.get_dummies(latest_fighter_stats[['Stance']])], axis=1)\n",
    "latest_fighter_stats.drop(columns=['Stance'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [],
   "source": [
    "rename_cols = {}\n",
    "for col in df2.columns:\n",
    "    rename_cols[col] = col.replace(' ', '').replace('-', '_').replace('\\'s', '_')\n",
    "lfs_rename_cols = {}\n",
    "for col in latest_fighter_stats.columns:\n",
    "    lfs_rename_cols[col] = col.replace(' ', '').replace('-', '_').replace('\\'s', '_')\n",
    "df2.rename(rename_cols, axis='columns', inplace=True)\n",
    "latest_fighter_stats.rename(lfs_rename_cols, axis='columns', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2.to_csv('data/new_preprocessed_data.csv', index=False)\n",
    "latest_fighter_stats.to_csv('data/latest_fighter_stats.csv', index=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### I have to now deal with \n",
    "* `dob` to `age`, \n",
    "* adding `weight_class` as dummies,  \n",
    "* adding `title_bout`, \n",
    "* adding `no_of_rounds`, \n",
    "* adding `R_` and `B_`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import math\n",
    "\n",
    "df_orig = pd.read_csv('data/total_fight_data.csv', sep=';')\n",
    "df = pd.read_csv('data/new_data.csv', sep=';')\n",
    "fighter_details = pd.read_csv('data/fighter_details.csv', index_col='fighter_name')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.concat([df, df_orig]).reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "weight_classes = ['Women\\'s Strawweight', 'Women\\'s Bantamweight', \n",
    "                  'Women\\'s Featherweight', 'Women\\'s Flyweight', 'Lightweight', \n",
    "                  'Welterweight', 'Middleweight','Light Heavyweight', \n",
    "                  'Heavyweight', 'Featherweight','Bantamweight', 'Flyweight', 'Open Weight']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "def make_weight_class(X):\n",
    "    for weight_class in weight_classes:\n",
    "        if weight_class in X:\n",
    "            return weight_class\n",
    "    if X == 'Catch Weight Bout' or 'Catchweight Bout':\n",
    "        return 'Catch Weight'\n",
    "    else:\n",
    "        return 'Open Weight'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['weight_class'] = df['Fight_type'].apply(make_weight_class)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df[['R_fighter', 'B_fighter', 'weight_class']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = df[['R_fighter', 'weight_class']].rename(index=str, columns={'R_fighter':'fighter'})\n",
    "df2 = df[['B_fighter', 'weight_class']].rename(index=str, columns={'B_fighter':'fighter'})\n",
    "\n",
    "                                               \n",
    "df3 = pd.concat([df1,df2]).reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "df3 = df3.drop_duplicates().reset_index(drop=True)\n",
    "\n",
    "df3.to_csv('data/weight_classes.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import pickle\n",
    "import numpy as np\n",
    "import math\n",
    "\n",
    "df = pd.read_csv('data/latest_fighter_stats.csv', index_col='index')\n",
    "with open('data/cols.list', 'rb') as c:\n",
    "    cols = pickle.load(c)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_weight_classes = {'Flyweight':'weight_class_Flyweight',\n",
    " 'Bantamweight':'weight_class_Bantamweight',\n",
    " 'Featherweight':'weight_class_Featherweight',\n",
    " 'Lightweight':'weight_class_Lightweight',\n",
    " 'Welterweight':'weight_class_Welterweight',\n",
    " 'Middleweight':'weight_class_Middleweight',\n",
    " 'Light Heavyweight':'weight_class_LightHeavyweight',\n",
    " 'Heavyweight':'weight_class_Heavyweight',\n",
    " 'Women\\'s Strawweight':'weight_class_Women_Strawweight',\n",
    " 'Women\\'s Flyweight':'weight_class_Women_Flyweight',\n",
    " 'Women\\'s Bantamweight':'weight_class_Women_Bantamweight',\n",
    "'Women\\'s Featherweight':'weight_class_Women_Featherweight',\n",
    " 'Catch Weight':'weight_class_CatchWeight',\n",
    " 'Open Weight':'weight_class_OpenWeight'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_age(X):\n",
    "\n",
    "    median_age = 29\n",
    "\n",
    "    DOB = pd.to_datetime(X)\n",
    "    today = pd.to_datetime('today')\n",
    "\n",
    "    if pd.isnull(DOB):\n",
    "        return median_age\n",
    "    else:\n",
    "        age = math.floor((today-DOB).days/365.25)\n",
    "        return age"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "title_bout = True\n",
    "no_of_rounds = 5\n",
    "weightclass = 'Middleweight'\n",
    "\n",
    "cols_dict = {df_weight_classes[k]:(1 if weightclass==k else 0) for k in df_weight_classes.keys()}\n",
    "cols_dict.update({'title_bout':title_bout, 'no_of_rounds':no_of_rounds})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "extra_cols = pd.DataFrame([list(cols_dict.values())], columns=cols_dict.keys())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['age'] = df['DOB'].apply(get_age)\n",
    "df.drop(columns=['DOB'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "r = df.loc[['Alex Perez']].add_prefix('R_').reset_index(drop=True)\n",
    "b = df.loc[['Frank Hamaker']].add_prefix('B_').reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "final = pd.concat([r,b,extra_cols], axis=1)[cols]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>title_bout</th>\n",
       "      <th>no_of_rounds</th>\n",
       "      <th>B_current_lose_streak</th>\n",
       "      <th>B_current_win_streak</th>\n",
       "      <th>B_draw</th>\n",
       "      <th>B_avg_BODY_att</th>\n",
       "      <th>B_avg_BODY_landed</th>\n",
       "      <th>B_avg_CLINCH_att</th>\n",
       "      <th>B_avg_CLINCH_landed</th>\n",
       "      <th>B_avg_DISTANCE_att</th>\n",
       "      <th>...</th>\n",
       "      <th>B_Stance_OpenStance</th>\n",
       "      <th>B_Stance_Orthodox</th>\n",
       "      <th>B_Stance_Sideways</th>\n",
       "      <th>B_Stance_Southpaw</th>\n",
       "      <th>B_Stance_Switch</th>\n",
       "      <th>R_Stance_OpenStance</th>\n",
       "      <th>R_Stance_Orthodox</th>\n",
       "      <th>R_Stance_Sideways</th>\n",
       "      <th>R_Stance_Southpaw</th>\n",
       "      <th>R_Stance_Switch</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 160 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   title_bout  no_of_rounds  B_current_lose_streak  B_current_win_streak  \\\n",
       "0        True             5                    0.0                   1.0   \n",
       "\n",
       "   B_draw  B_avg_BODY_att  B_avg_BODY_landed  B_avg_CLINCH_att  \\\n",
       "0     0.0             0.0                0.0               0.0   \n",
       "\n",
       "   B_avg_CLINCH_landed  B_avg_DISTANCE_att       ...         \\\n",
       "0                  0.0                 1.0       ...          \n",
       "\n",
       "   B_Stance_OpenStance  B_Stance_Orthodox  B_Stance_Sideways  \\\n",
       "0                    0                  1                  0   \n",
       "\n",
       "   B_Stance_Southpaw  B_Stance_Switch  R_Stance_OpenStance  R_Stance_Orthodox  \\\n",
       "0                  0                0                    0                  1   \n",
       "\n",
       "   R_Stance_Sideways  R_Stance_Southpaw  R_Stance_Switch  \n",
       "0                  0                  0                0  \n",
       "\n",
       "[1 rows x 160 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('data/xgb-model-1.sav', 'rb') as mdl:\n",
    "    model = pickle.load(mdl)\n",
    "with open('data/standard.scaler', 'rb') as ss:\n",
    "    scaler = pickle.load(ss)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "XGBClassifier(base_score=0.5, booster='gbtree', colsample_bylevel=1,\n",
       "       colsample_bytree=0.8, gamma=0.1, learning_rate=0.1,\n",
       "       max_delta_step=0, max_depth=4, min_child_weight=1, missing=nan,\n",
       "       n_estimators=244, n_jobs=1, nthread=None,\n",
       "       objective='binary:logistic', random_state=0, reg_alpha=0,\n",
       "       reg_lambda=1, scale_pos_weight=1, seed=None, silent=True,\n",
       "       subsample=0.8)"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "def normalize(df: pd.DataFrame, scaler) -> pd.DataFrame:\n",
    "    df_num = df.select_dtypes(include=[np.float, np.int])\n",
    "    df[list(df_num.columns)] = scaler.transform(df[list(df_num.columns)])\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[ 0.51440406,  0.48559597]], dtype=float32)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from xgboost import XGBClassifier\n",
    "from sklearn.preprocessing import StandardScaler\n",
    "\n",
    "model.predict_proba(np.array(normalize(final, scaler)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 0.05455363,  0.94544637], dtype=float32)"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from xgboost import XGBClassifier\n",
    "from sklearn.preprocessing import StandardScaler\n",
    "\n",
    "model.predict_proba(np.array(normalize(final, scaler)))[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}