bs_predictor.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "# importar paquetes a ocupar\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import pycaret\n",
    "import itertools\n",
    "\n",
    "from pycaret.classification import *"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Transformation Pipeline and Model Successfully Loaded\n"
     ]
    }
   ],
   "source": [
    "model = load_model('models/lightgbm_less_columns')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [],
   "source": [
    "brawlers_stats = pd.read_csv('datasets/brawlers/brawlers_stats.csv', index_col=0)\n",
    "players = pd.read_csv('datasets/players/players.csv', index_col=0)\n",
    "battlelog = pd.read_csv('datasets/teams/battlelog_teams.csv', index_col=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event.mode</th>\n",
       "      <th>event.map</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Center Stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>heist</td>\n",
       "      <td>Pit Stop</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>gemGrab</td>\n",
       "      <td>Double Swoosh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>gemGrab</td>\n",
       "      <td>Minecart Madness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>knockout</td>\n",
       "      <td>Belle's Rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Backyard Bowl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>knockout</td>\n",
       "      <td>Goldarm Gulch</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>bounty</td>\n",
       "      <td>Hideout</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>bounty</td>\n",
       "      <td>Shooting Star</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Sneaky Fields</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Pinhole Punt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Super Beach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>hotZone</td>\n",
       "      <td>Dueling Beetles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>hotZone</td>\n",
       "      <td>Ring of Fire</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>hotZone</td>\n",
       "      <td>Quarter Pounder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>heist</td>\n",
       "      <td>Safe Zone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>heist</td>\n",
       "      <td>Bridge Too Far</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>gemGrab</td>\n",
       "      <td>Hard Rock Mine</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>bounty</td>\n",
       "      <td>Canal Grande</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>bounty</td>\n",
       "      <td>Layer Cake</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>gemGrab</td>\n",
       "      <td>Crystal Arcade</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>knockout</td>\n",
       "      <td>Out in the Open</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>hotZone</td>\n",
       "      <td>Open Zone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Beach Ball</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>heist</td>\n",
       "      <td>Snaked Assault</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>bounty</td>\n",
       "      <td>Temple Ruins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>knockout</td>\n",
       "      <td>Riverside</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>heist</td>\n",
       "      <td>Hot Potato</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>bounty</td>\n",
       "      <td>Dry Season</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>hotZone</td>\n",
       "      <td>Controller Chaos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>gemGrab</td>\n",
       "      <td>Deep Diner</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>gemGrab</td>\n",
       "      <td>Undermine</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>heist</td>\n",
       "      <td>Kaboom Canyon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>knockout</td>\n",
       "      <td>Flaring Phoenix</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Sunny Soccer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>gemGrab</td>\n",
       "      <td>Gem Fort</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>knockout</td>\n",
       "      <td>Belle`s Rock</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>bounty</td>\n",
       "      <td>Excel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>knockout</td>\n",
       "      <td>X Marks the Spot</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>knockout</td>\n",
       "      <td>New Perspective</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>heist</td>\n",
       "      <td>Tornado Ring</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>hotZone</td>\n",
       "      <td>Split</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>hotZone</td>\n",
       "      <td>Parallel Plays</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   event.mode         event.map\n",
       "0   brawlBall      Center Stage\n",
       "1       heist          Pit Stop\n",
       "2     gemGrab     Double Swoosh\n",
       "3     gemGrab  Minecart Madness\n",
       "4    knockout      Belle's Rock\n",
       "5   brawlBall     Backyard Bowl\n",
       "6    knockout     Goldarm Gulch\n",
       "7      bounty           Hideout\n",
       "8      bounty     Shooting Star\n",
       "9   brawlBall     Sneaky Fields\n",
       "10  brawlBall      Pinhole Punt\n",
       "11  brawlBall       Super Beach\n",
       "12    hotZone   Dueling Beetles\n",
       "13    hotZone      Ring of Fire\n",
       "14    hotZone   Quarter Pounder\n",
       "15      heist         Safe Zone\n",
       "16      heist    Bridge Too Far\n",
       "17    gemGrab    Hard Rock Mine\n",
       "18     bounty      Canal Grande\n",
       "19     bounty        Layer Cake\n",
       "20    gemGrab    Crystal Arcade\n",
       "21   knockout   Out in the Open\n",
       "22    hotZone         Open Zone\n",
       "23  brawlBall        Beach Ball\n",
       "24      heist    Snaked Assault\n",
       "25     bounty      Temple Ruins\n",
       "26   knockout         Riverside\n",
       "27      heist        Hot Potato\n",
       "28     bounty        Dry Season\n",
       "29    hotZone  Controller Chaos\n",
       "30    gemGrab        Deep Diner\n",
       "31    gemGrab         Undermine\n",
       "32      heist     Kaboom Canyon\n",
       "33   knockout   Flaring Phoenix\n",
       "34  brawlBall      Sunny Soccer\n",
       "35    gemGrab          Gem Fort\n",
       "36   knockout      Belle`s Rock\n",
       "37     bounty             Excel\n",
       "38   knockout  X Marks the Spot\n",
       "39   knockout   New Perspective\n",
       "40      heist      Tornado Ring\n",
       "41    hotZone             Split\n",
       "42    hotZone    Parallel Plays"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mode_map = battlelog[['event.mode','event.map']].drop_duplicates().reset_index(drop=True)\n",
    "mode_map"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "trophies           32622.569317\n",
       "highestTrophies    33130.258136\n",
       "expLevel             211.054804\n",
       "dtype: float64"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "avg_rank = players[['trophies','highestTrophies','expLevel']].agg(np.mean)\n",
    "avg_rank"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "623.2829978068022"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "avg_trophies = pd.concat([\n",
    "\tbattlelog['battle.team1.player1.brawler.trophies'], \n",
    "\tbattlelog['battle.team1.player2.brawler.trophies'], \n",
    "\tbattlelog['battle.team1.player3.brawler.trophies'], \n",
    "\tbattlelog['battle.team2.player1.brawler.trophies'], \n",
    "\tbattlelog['battle.team2.player2.brawler.trophies'], \n",
    "\tbattlelog['battle.team2.player3.brawler.trophies']]).agg(np.mean)\n",
    "avg_trophies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "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>battle.player1.brawler.name</th>\n",
       "      <th>battle.player2.brawler.name</th>\n",
       "      <th>battle.player3.brawler.name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>BULL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>BROCK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>RICO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>SPIKE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>BARLEY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41659</th>\n",
       "      <td>GUS</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>MANDY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41660</th>\n",
       "      <td>BUSTER</td>\n",
       "      <td>CHESTER</td>\n",
       "      <td>GRAY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41661</th>\n",
       "      <td>BUSTER</td>\n",
       "      <td>CHESTER</td>\n",
       "      <td>MANDY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41662</th>\n",
       "      <td>BUSTER</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>MANDY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41663</th>\n",
       "      <td>CHESTER</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>MANDY</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>41664 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      battle.player1.brawler.name battle.player2.brawler.name  \\\n",
       "0                          SHELLY                        COLT   \n",
       "1                          SHELLY                        COLT   \n",
       "2                          SHELLY                        COLT   \n",
       "3                          SHELLY                        COLT   \n",
       "4                          SHELLY                        COLT   \n",
       "...                           ...                         ...   \n",
       "41659                         GUS                        GRAY   \n",
       "41660                      BUSTER                     CHESTER   \n",
       "41661                      BUSTER                     CHESTER   \n",
       "41662                      BUSTER                        GRAY   \n",
       "41663                     CHESTER                        GRAY   \n",
       "\n",
       "      battle.player3.brawler.name  \n",
       "0                            BULL  \n",
       "1                           BROCK  \n",
       "2                            RICO  \n",
       "3                           SPIKE  \n",
       "4                          BARLEY  \n",
       "...                           ...  \n",
       "41659                       MANDY  \n",
       "41660                        GRAY  \n",
       "41661                       MANDY  \n",
       "41662                       MANDY  \n",
       "41663                       MANDY  \n",
       "\n",
       "[41664 rows x 3 columns]"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "combinations = pd.DataFrame(itertools.combinations(brawlers_stats['name'], 3))\n",
    "combinations.columns = ['battle.player1.brawler.name', 'battle.player2.brawler.name', 'battle.player3.brawler.name']\n",
    "combinations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "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>battle.player1.brawler.name</th>\n",
       "      <th>battle.player2.brawler.name</th>\n",
       "      <th>battle.player3.brawler.name</th>\n",
       "      <th>event.mode</th>\n",
       "      <th>event.map</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>BULL</td>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Center Stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>BROCK</td>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Center Stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>RICO</td>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Center Stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>SPIKE</td>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Center Stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>BARLEY</td>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Center Stage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791547</th>\n",
       "      <td>GUS</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>MANDY</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>Parallel Plays</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791548</th>\n",
       "      <td>BUSTER</td>\n",
       "      <td>CHESTER</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>Parallel Plays</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791549</th>\n",
       "      <td>BUSTER</td>\n",
       "      <td>CHESTER</td>\n",
       "      <td>MANDY</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>Parallel Plays</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791550</th>\n",
       "      <td>BUSTER</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>MANDY</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>Parallel Plays</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791551</th>\n",
       "      <td>CHESTER</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>MANDY</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>Parallel Plays</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1791552 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        battle.player1.brawler.name battle.player2.brawler.name  \\\n",
       "0                            SHELLY                        COLT   \n",
       "1                            SHELLY                        COLT   \n",
       "2                            SHELLY                        COLT   \n",
       "3                            SHELLY                        COLT   \n",
       "4                            SHELLY                        COLT   \n",
       "...                             ...                         ...   \n",
       "1791547                         GUS                        GRAY   \n",
       "1791548                      BUSTER                     CHESTER   \n",
       "1791549                      BUSTER                     CHESTER   \n",
       "1791550                      BUSTER                        GRAY   \n",
       "1791551                     CHESTER                        GRAY   \n",
       "\n",
       "        battle.player3.brawler.name event.mode       event.map  \n",
       "0                              BULL  brawlBall    Center Stage  \n",
       "1                             BROCK  brawlBall    Center Stage  \n",
       "2                              RICO  brawlBall    Center Stage  \n",
       "3                             SPIKE  brawlBall    Center Stage  \n",
       "4                            BARLEY  brawlBall    Center Stage  \n",
       "...                             ...        ...             ...  \n",
       "1791547                       MANDY    hotZone  Parallel Plays  \n",
       "1791548                        GRAY    hotZone  Parallel Plays  \n",
       "1791549                       MANDY    hotZone  Parallel Plays  \n",
       "1791550                       MANDY    hotZone  Parallel Plays  \n",
       "1791551                       MANDY    hotZone  Parallel Plays  \n",
       "\n",
       "[1791552 rows x 5 columns]"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "predictor = pd.DataFrame()\n",
    "\n",
    "for i, item in enumerate(mode_map['event.mode']):\n",
    "\tcombinations['event.mode'] = mode_map.loc[i, 'event.mode']\n",
    "\tcombinations['event.map'] = mode_map.loc[i, 'event.map']\n",
    "\tpredictor = pd.concat([predictor, combinations], ignore_index=True)\n",
    "\n",
    "predictor.reset_index(drop=True)\n",
    "predictor"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [],
   "source": [
    "predictor['battle.mode'] = predictor['event.mode']\n",
    "predictor['battle.type'] = 'ranked'\n",
    "predictor['battle.player1.trophies'] = avg_rank.trophies\n",
    "predictor['battle.player1.brawler.trophies'] = avg_trophies\n",
    "predictor['battle.player1.brawler.power'] = 11\n",
    "predictor['battle.player2.trophies'] = avg_rank.trophies\n",
    "predictor['battle.player2.brawler.trophies'] = avg_trophies\n",
    "predictor['battle.player2.brawler.power'] = 11\n",
    "predictor['battle.player3.trophies'] = avg_rank.trophies\n",
    "predictor['battle.player3.brawler.trophies'] = avg_trophies\n",
    "predictor['battle.player3.brawler.power'] = 11"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [],
   "source": [
    "predictor = predictor.merge(brawlers_stats.add_prefix('battle.player1.brawler.'), on='battle.player1.brawler.name')\n",
    "predictor = predictor.merge(brawlers_stats.add_prefix('battle.player2.brawler.'), on='battle.player2.brawler.name')\n",
    "predictor = predictor.merge(brawlers_stats.add_prefix('battle.player3.brawler.'), on='battle.player3.brawler.name')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "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>battle.player1.brawler.name</th>\n",
       "      <th>battle.player2.brawler.name</th>\n",
       "      <th>battle.player3.brawler.name</th>\n",
       "      <th>event.mode</th>\n",
       "      <th>event.map</th>\n",
       "      <th>battle.mode</th>\n",
       "      <th>battle.type</th>\n",
       "      <th>battle.player1.trophies</th>\n",
       "      <th>battle.player1.brawler.trophies</th>\n",
       "      <th>battle.player1.brawler.power</th>\n",
       "      <th>battle.player2.trophies</th>\n",
       "      <th>battle.player2.brawler.trophies</th>\n",
       "      <th>battle.player2.brawler.power</th>\n",
       "      <th>battle.player3.trophies</th>\n",
       "      <th>battle.player3.brawler.trophies</th>\n",
       "      <th>battle.player3.brawler.power</th>\n",
       "      <th>battle.player1.brawler.id</th>\n",
       "      <th>battle.player1.brawler.role</th>\n",
       "      <th>battle.player1.brawler.range</th>\n",
       "      <th>battle.player1.brawler.speed</th>\n",
       "      <th>battle.player1.brawler.health</th>\n",
       "      <th>battle.player2.brawler.id</th>\n",
       "      <th>battle.player2.brawler.role</th>\n",
       "      <th>battle.player2.brawler.range</th>\n",
       "      <th>battle.player2.brawler.speed</th>\n",
       "      <th>battle.player2.brawler.health</th>\n",
       "      <th>battle.player3.brawler.id</th>\n",
       "      <th>battle.player3.brawler.role</th>\n",
       "      <th>battle.player3.brawler.range</th>\n",
       "      <th>battle.player3.brawler.speed</th>\n",
       "      <th>battle.player3.brawler.health</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>BULL</td>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Center Stage</td>\n",
       "      <td>brawlBall</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000000</td>\n",
       "      <td>tank stopper</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5320</td>\n",
       "      <td>16000001</td>\n",
       "      <td>ranged dps</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>3920</td>\n",
       "      <td>16000002</td>\n",
       "      <td>close quarters</td>\n",
       "      <td>short</td>\n",
       "      <td>fast</td>\n",
       "      <td>7000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>BULL</td>\n",
       "      <td>heist</td>\n",
       "      <td>Pit Stop</td>\n",
       "      <td>heist</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000000</td>\n",
       "      <td>tank stopper</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5320</td>\n",
       "      <td>16000001</td>\n",
       "      <td>ranged dps</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>3920</td>\n",
       "      <td>16000002</td>\n",
       "      <td>close quarters</td>\n",
       "      <td>short</td>\n",
       "      <td>fast</td>\n",
       "      <td>7000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>BULL</td>\n",
       "      <td>gemGrab</td>\n",
       "      <td>Double Swoosh</td>\n",
       "      <td>gemGrab</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000000</td>\n",
       "      <td>tank stopper</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5320</td>\n",
       "      <td>16000001</td>\n",
       "      <td>ranged dps</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>3920</td>\n",
       "      <td>16000002</td>\n",
       "      <td>close quarters</td>\n",
       "      <td>short</td>\n",
       "      <td>fast</td>\n",
       "      <td>7000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>BULL</td>\n",
       "      <td>gemGrab</td>\n",
       "      <td>Minecart Madness</td>\n",
       "      <td>gemGrab</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000000</td>\n",
       "      <td>tank stopper</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5320</td>\n",
       "      <td>16000001</td>\n",
       "      <td>ranged dps</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>3920</td>\n",
       "      <td>16000002</td>\n",
       "      <td>close quarters</td>\n",
       "      <td>short</td>\n",
       "      <td>fast</td>\n",
       "      <td>7000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SHELLY</td>\n",
       "      <td>COLT</td>\n",
       "      <td>BULL</td>\n",
       "      <td>knockout</td>\n",
       "      <td>Belle's Rock</td>\n",
       "      <td>knockout</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000000</td>\n",
       "      <td>tank stopper</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5320</td>\n",
       "      <td>16000001</td>\n",
       "      <td>ranged dps</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>3920</td>\n",
       "      <td>16000002</td>\n",
       "      <td>close quarters</td>\n",
       "      <td>short</td>\n",
       "      <td>fast</td>\n",
       "      <td>7000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791547</th>\n",
       "      <td>CHESTER</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>MANDY</td>\n",
       "      <td>knockout</td>\n",
       "      <td>X Marks the Spot</td>\n",
       "      <td>knockout</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000063</td>\n",
       "      <td>assassin</td>\n",
       "      <td>long</td>\n",
       "      <td>fast</td>\n",
       "      <td>4785</td>\n",
       "      <td>16000064</td>\n",
       "      <td>sniper</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>4785</td>\n",
       "      <td>16000065</td>\n",
       "      <td>sniper</td>\n",
       "      <td>very long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791548</th>\n",
       "      <td>CHESTER</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>MANDY</td>\n",
       "      <td>knockout</td>\n",
       "      <td>New Perspective</td>\n",
       "      <td>knockout</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000063</td>\n",
       "      <td>assassin</td>\n",
       "      <td>long</td>\n",
       "      <td>fast</td>\n",
       "      <td>4785</td>\n",
       "      <td>16000064</td>\n",
       "      <td>sniper</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>4785</td>\n",
       "      <td>16000065</td>\n",
       "      <td>sniper</td>\n",
       "      <td>very long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791549</th>\n",
       "      <td>CHESTER</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>MANDY</td>\n",
       "      <td>heist</td>\n",
       "      <td>Tornado Ring</td>\n",
       "      <td>heist</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000063</td>\n",
       "      <td>assassin</td>\n",
       "      <td>long</td>\n",
       "      <td>fast</td>\n",
       "      <td>4785</td>\n",
       "      <td>16000064</td>\n",
       "      <td>sniper</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>4785</td>\n",
       "      <td>16000065</td>\n",
       "      <td>sniper</td>\n",
       "      <td>very long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791550</th>\n",
       "      <td>CHESTER</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>MANDY</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>Split</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000063</td>\n",
       "      <td>assassin</td>\n",
       "      <td>long</td>\n",
       "      <td>fast</td>\n",
       "      <td>4785</td>\n",
       "      <td>16000064</td>\n",
       "      <td>sniper</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>4785</td>\n",
       "      <td>16000065</td>\n",
       "      <td>sniper</td>\n",
       "      <td>very long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1791551</th>\n",
       "      <td>CHESTER</td>\n",
       "      <td>GRAY</td>\n",
       "      <td>MANDY</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>Parallel Plays</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000063</td>\n",
       "      <td>assassin</td>\n",
       "      <td>long</td>\n",
       "      <td>fast</td>\n",
       "      <td>4785</td>\n",
       "      <td>16000064</td>\n",
       "      <td>sniper</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>4785</td>\n",
       "      <td>16000065</td>\n",
       "      <td>sniper</td>\n",
       "      <td>very long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5600</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1791552 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        battle.player1.brawler.name battle.player2.brawler.name  \\\n",
       "0                            SHELLY                        COLT   \n",
       "1                            SHELLY                        COLT   \n",
       "2                            SHELLY                        COLT   \n",
       "3                            SHELLY                        COLT   \n",
       "4                            SHELLY                        COLT   \n",
       "...                             ...                         ...   \n",
       "1791547                     CHESTER                        GRAY   \n",
       "1791548                     CHESTER                        GRAY   \n",
       "1791549                     CHESTER                        GRAY   \n",
       "1791550                     CHESTER                        GRAY   \n",
       "1791551                     CHESTER                        GRAY   \n",
       "\n",
       "        battle.player3.brawler.name event.mode         event.map battle.mode  \\\n",
       "0                              BULL  brawlBall      Center Stage   brawlBall   \n",
       "1                              BULL      heist          Pit Stop       heist   \n",
       "2                              BULL    gemGrab     Double Swoosh     gemGrab   \n",
       "3                              BULL    gemGrab  Minecart Madness     gemGrab   \n",
       "4                              BULL   knockout      Belle's Rock    knockout   \n",
       "...                             ...        ...               ...         ...   \n",
       "1791547                       MANDY   knockout  X Marks the Spot    knockout   \n",
       "1791548                       MANDY   knockout   New Perspective    knockout   \n",
       "1791549                       MANDY      heist      Tornado Ring       heist   \n",
       "1791550                       MANDY    hotZone             Split     hotZone   \n",
       "1791551                       MANDY    hotZone    Parallel Plays     hotZone   \n",
       "\n",
       "        battle.type  battle.player1.trophies  battle.player1.brawler.trophies  \\\n",
       "0            ranked             32622.569317                       623.282998   \n",
       "1            ranked             32622.569317                       623.282998   \n",
       "2            ranked             32622.569317                       623.282998   \n",
       "3            ranked             32622.569317                       623.282998   \n",
       "4            ranked             32622.569317                       623.282998   \n",
       "...             ...                      ...                              ...   \n",
       "1791547      ranked             32622.569317                       623.282998   \n",
       "1791548      ranked             32622.569317                       623.282998   \n",
       "1791549      ranked             32622.569317                       623.282998   \n",
       "1791550      ranked             32622.569317                       623.282998   \n",
       "1791551      ranked             32622.569317                       623.282998   \n",
       "\n",
       "         battle.player1.brawler.power  battle.player2.trophies  \\\n",
       "0                                  11             32622.569317   \n",
       "1                                  11             32622.569317   \n",
       "2                                  11             32622.569317   \n",
       "3                                  11             32622.569317   \n",
       "4                                  11             32622.569317   \n",
       "...                               ...                      ...   \n",
       "1791547                            11             32622.569317   \n",
       "1791548                            11             32622.569317   \n",
       "1791549                            11             32622.569317   \n",
       "1791550                            11             32622.569317   \n",
       "1791551                            11             32622.569317   \n",
       "\n",
       "         battle.player2.brawler.trophies  battle.player2.brawler.power  \\\n",
       "0                             623.282998                            11   \n",
       "1                             623.282998                            11   \n",
       "2                             623.282998                            11   \n",
       "3                             623.282998                            11   \n",
       "4                             623.282998                            11   \n",
       "...                                  ...                           ...   \n",
       "1791547                       623.282998                            11   \n",
       "1791548                       623.282998                            11   \n",
       "1791549                       623.282998                            11   \n",
       "1791550                       623.282998                            11   \n",
       "1791551                       623.282998                            11   \n",
       "\n",
       "         battle.player3.trophies  battle.player3.brawler.trophies  \\\n",
       "0                   32622.569317                       623.282998   \n",
       "1                   32622.569317                       623.282998   \n",
       "2                   32622.569317                       623.282998   \n",
       "3                   32622.569317                       623.282998   \n",
       "4                   32622.569317                       623.282998   \n",
       "...                          ...                              ...   \n",
       "1791547             32622.569317                       623.282998   \n",
       "1791548             32622.569317                       623.282998   \n",
       "1791549             32622.569317                       623.282998   \n",
       "1791550             32622.569317                       623.282998   \n",
       "1791551             32622.569317                       623.282998   \n",
       "\n",
       "         battle.player3.brawler.power  battle.player1.brawler.id  \\\n",
       "0                                  11                   16000000   \n",
       "1                                  11                   16000000   \n",
       "2                                  11                   16000000   \n",
       "3                                  11                   16000000   \n",
       "4                                  11                   16000000   \n",
       "...                               ...                        ...   \n",
       "1791547                            11                   16000063   \n",
       "1791548                            11                   16000063   \n",
       "1791549                            11                   16000063   \n",
       "1791550                            11                   16000063   \n",
       "1791551                            11                   16000063   \n",
       "\n",
       "        battle.player1.brawler.role battle.player1.brawler.range  \\\n",
       "0                      tank stopper                         long   \n",
       "1                      tank stopper                         long   \n",
       "2                      tank stopper                         long   \n",
       "3                      tank stopper                         long   \n",
       "4                      tank stopper                         long   \n",
       "...                             ...                          ...   \n",
       "1791547                    assassin                         long   \n",
       "1791548                    assassin                         long   \n",
       "1791549                    assassin                         long   \n",
       "1791550                    assassin                         long   \n",
       "1791551                    assassin                         long   \n",
       "\n",
       "        battle.player1.brawler.speed  battle.player1.brawler.health  \\\n",
       "0                             normal                           5320   \n",
       "1                             normal                           5320   \n",
       "2                             normal                           5320   \n",
       "3                             normal                           5320   \n",
       "4                             normal                           5320   \n",
       "...                              ...                            ...   \n",
       "1791547                         fast                           4785   \n",
       "1791548                         fast                           4785   \n",
       "1791549                         fast                           4785   \n",
       "1791550                         fast                           4785   \n",
       "1791551                         fast                           4785   \n",
       "\n",
       "         battle.player2.brawler.id battle.player2.brawler.role  \\\n",
       "0                         16000001                  ranged dps   \n",
       "1                         16000001                  ranged dps   \n",
       "2                         16000001                  ranged dps   \n",
       "3                         16000001                  ranged dps   \n",
       "4                         16000001                  ranged dps   \n",
       "...                            ...                         ...   \n",
       "1791547                   16000064                      sniper   \n",
       "1791548                   16000064                      sniper   \n",
       "1791549                   16000064                      sniper   \n",
       "1791550                   16000064                      sniper   \n",
       "1791551                   16000064                      sniper   \n",
       "\n",
       "        battle.player2.brawler.range battle.player2.brawler.speed  \\\n",
       "0                               long                       normal   \n",
       "1                               long                       normal   \n",
       "2                               long                       normal   \n",
       "3                               long                       normal   \n",
       "4                               long                       normal   \n",
       "...                              ...                          ...   \n",
       "1791547                         long                       normal   \n",
       "1791548                         long                       normal   \n",
       "1791549                         long                       normal   \n",
       "1791550                         long                       normal   \n",
       "1791551                         long                       normal   \n",
       "\n",
       "         battle.player2.brawler.health  battle.player3.brawler.id  \\\n",
       "0                                 3920                   16000002   \n",
       "1                                 3920                   16000002   \n",
       "2                                 3920                   16000002   \n",
       "3                                 3920                   16000002   \n",
       "4                                 3920                   16000002   \n",
       "...                                ...                        ...   \n",
       "1791547                           4785                   16000065   \n",
       "1791548                           4785                   16000065   \n",
       "1791549                           4785                   16000065   \n",
       "1791550                           4785                   16000065   \n",
       "1791551                           4785                   16000065   \n",
       "\n",
       "        battle.player3.brawler.role battle.player3.brawler.range  \\\n",
       "0                    close quarters                        short   \n",
       "1                    close quarters                        short   \n",
       "2                    close quarters                        short   \n",
       "3                    close quarters                        short   \n",
       "4                    close quarters                        short   \n",
       "...                             ...                          ...   \n",
       "1791547                      sniper                    very long   \n",
       "1791548                      sniper                    very long   \n",
       "1791549                      sniper                    very long   \n",
       "1791550                      sniper                    very long   \n",
       "1791551                      sniper                    very long   \n",
       "\n",
       "        battle.player3.brawler.speed  battle.player3.brawler.health  \n",
       "0                               fast                           7000  \n",
       "1                               fast                           7000  \n",
       "2                               fast                           7000  \n",
       "3                               fast                           7000  \n",
       "4                               fast                           7000  \n",
       "...                              ...                            ...  \n",
       "1791547                       normal                           5600  \n",
       "1791548                       normal                           5600  \n",
       "1791549                       normal                           5600  \n",
       "1791550                       normal                           5600  \n",
       "1791551                       normal                           5600  \n",
       "\n",
       "[1791552 rows x 31 columns]"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "predictor"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [],
   "source": [
    "predictions = predict_model(model, data = predictor, raw_score=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "n    1791552\n",
       "Name: Label, dtype: int64"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "predictions['Label'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "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>battle.player1.brawler.name</th>\n",
       "      <th>battle.player2.brawler.name</th>\n",
       "      <th>battle.player3.brawler.name</th>\n",
       "      <th>event.mode</th>\n",
       "      <th>event.map</th>\n",
       "      <th>battle.mode</th>\n",
       "      <th>battle.type</th>\n",
       "      <th>battle.player1.trophies</th>\n",
       "      <th>battle.player1.brawler.trophies</th>\n",
       "      <th>battle.player1.brawler.power</th>\n",
       "      <th>battle.player2.trophies</th>\n",
       "      <th>battle.player2.brawler.trophies</th>\n",
       "      <th>battle.player2.brawler.power</th>\n",
       "      <th>battle.player3.trophies</th>\n",
       "      <th>battle.player3.brawler.trophies</th>\n",
       "      <th>battle.player3.brawler.power</th>\n",
       "      <th>battle.player1.brawler.id</th>\n",
       "      <th>battle.player1.brawler.role</th>\n",
       "      <th>battle.player1.brawler.range</th>\n",
       "      <th>battle.player1.brawler.speed</th>\n",
       "      <th>battle.player1.brawler.health</th>\n",
       "      <th>battle.player2.brawler.id</th>\n",
       "      <th>battle.player2.brawler.role</th>\n",
       "      <th>battle.player2.brawler.range</th>\n",
       "      <th>battle.player2.brawler.speed</th>\n",
       "      <th>battle.player2.brawler.health</th>\n",
       "      <th>battle.player3.brawler.id</th>\n",
       "      <th>battle.player3.brawler.role</th>\n",
       "      <th>battle.player3.brawler.range</th>\n",
       "      <th>battle.player3.brawler.speed</th>\n",
       "      <th>battle.player3.brawler.health</th>\n",
       "      <th>Label</th>\n",
       "      <th>Score_n</th>\n",
       "      <th>Score_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1784754</th>\n",
       "      <td>ROSA</td>\n",
       "      <td>BUSTER</td>\n",
       "      <td>MANDY</td>\n",
       "      <td>knockout</td>\n",
       "      <td>New Perspective</td>\n",
       "      <td>knockout</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000024</td>\n",
       "      <td>tank</td>\n",
       "      <td>short</td>\n",
       "      <td>fast</td>\n",
       "      <td>7830</td>\n",
       "      <td>16000062</td>\n",
       "      <td>area control</td>\n",
       "      <td>normal</td>\n",
       "      <td>fast</td>\n",
       "      <td>6960</td>\n",
       "      <td>16000065</td>\n",
       "      <td>sniper</td>\n",
       "      <td>very long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5600</td>\n",
       "      <td>n</td>\n",
       "      <td>0.5334</td>\n",
       "      <td>0.4666</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1782217</th>\n",
       "      <td>ROSA</td>\n",
       "      <td>GUS</td>\n",
       "      <td>MANDY</td>\n",
       "      <td>knockout</td>\n",
       "      <td>New Perspective</td>\n",
       "      <td>knockout</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000024</td>\n",
       "      <td>tank</td>\n",
       "      <td>short</td>\n",
       "      <td>fast</td>\n",
       "      <td>7830</td>\n",
       "      <td>16000061</td>\n",
       "      <td>healer</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>4480</td>\n",
       "      <td>16000065</td>\n",
       "      <td>sniper</td>\n",
       "      <td>very long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5600</td>\n",
       "      <td>n</td>\n",
       "      <td>0.5380</td>\n",
       "      <td>0.4620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1784566</th>\n",
       "      <td>FRANK</td>\n",
       "      <td>BUSTER</td>\n",
       "      <td>MANDY</td>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Beach Ball</td>\n",
       "      <td>brawlBall</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000020</td>\n",
       "      <td>tank</td>\n",
       "      <td>normal</td>\n",
       "      <td>fast</td>\n",
       "      <td>10150</td>\n",
       "      <td>16000062</td>\n",
       "      <td>area control</td>\n",
       "      <td>normal</td>\n",
       "      <td>fast</td>\n",
       "      <td>6960</td>\n",
       "      <td>16000065</td>\n",
       "      <td>sniper</td>\n",
       "      <td>very long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5600</td>\n",
       "      <td>n</td>\n",
       "      <td>0.5451</td>\n",
       "      <td>0.4549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1785872</th>\n",
       "      <td>ASH</td>\n",
       "      <td>BUSTER</td>\n",
       "      <td>MANDY</td>\n",
       "      <td>knockout</td>\n",
       "      <td>New Perspective</td>\n",
       "      <td>knockout</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000051</td>\n",
       "      <td>tank</td>\n",
       "      <td>short</td>\n",
       "      <td>normal</td>\n",
       "      <td>7830</td>\n",
       "      <td>16000062</td>\n",
       "      <td>area control</td>\n",
       "      <td>normal</td>\n",
       "      <td>fast</td>\n",
       "      <td>6960</td>\n",
       "      <td>16000065</td>\n",
       "      <td>sniper</td>\n",
       "      <td>very long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5600</td>\n",
       "      <td>n</td>\n",
       "      <td>0.5481</td>\n",
       "      <td>0.4519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1786216</th>\n",
       "      <td>SAM</td>\n",
       "      <td>BUSTER</td>\n",
       "      <td>MANDY</td>\n",
       "      <td>knockout</td>\n",
       "      <td>New Perspective</td>\n",
       "      <td>knockout</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000060</td>\n",
       "      <td>tank</td>\n",
       "      <td>short</td>\n",
       "      <td>fast</td>\n",
       "      <td>7560</td>\n",
       "      <td>16000062</td>\n",
       "      <td>area control</td>\n",
       "      <td>normal</td>\n",
       "      <td>fast</td>\n",
       "      <td>6960</td>\n",
       "      <td>16000065</td>\n",
       "      <td>sniper</td>\n",
       "      <td>very long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5600</td>\n",
       "      <td>n</td>\n",
       "      <td>0.5481</td>\n",
       "      <td>0.4519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23973</th>\n",
       "      <td>MORTIS</td>\n",
       "      <td>BO</td>\n",
       "      <td>PIPER</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>Open Zone</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000011</td>\n",
       "      <td>assassin</td>\n",
       "      <td>short</td>\n",
       "      <td>very fast</td>\n",
       "      <td>5700</td>\n",
       "      <td>16000014</td>\n",
       "      <td>area control</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5220</td>\n",
       "      <td>16000015</td>\n",
       "      <td>sniper</td>\n",
       "      <td>very long</td>\n",
       "      <td>normal</td>\n",
       "      <td>3360</td>\n",
       "      <td>n</td>\n",
       "      <td>0.8360</td>\n",
       "      <td>0.1640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23965</th>\n",
       "      <td>MORTIS</td>\n",
       "      <td>BO</td>\n",
       "      <td>PIPER</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>Quarter Pounder</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000011</td>\n",
       "      <td>assassin</td>\n",
       "      <td>short</td>\n",
       "      <td>very fast</td>\n",
       "      <td>5700</td>\n",
       "      <td>16000014</td>\n",
       "      <td>area control</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5220</td>\n",
       "      <td>16000015</td>\n",
       "      <td>sniper</td>\n",
       "      <td>very long</td>\n",
       "      <td>normal</td>\n",
       "      <td>3360</td>\n",
       "      <td>n</td>\n",
       "      <td>0.8360</td>\n",
       "      <td>0.1640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23963</th>\n",
       "      <td>MORTIS</td>\n",
       "      <td>BO</td>\n",
       "      <td>PIPER</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>Dueling Beetles</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000011</td>\n",
       "      <td>assassin</td>\n",
       "      <td>short</td>\n",
       "      <td>very fast</td>\n",
       "      <td>5700</td>\n",
       "      <td>16000014</td>\n",
       "      <td>area control</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5220</td>\n",
       "      <td>16000015</td>\n",
       "      <td>sniper</td>\n",
       "      <td>very long</td>\n",
       "      <td>normal</td>\n",
       "      <td>3360</td>\n",
       "      <td>n</td>\n",
       "      <td>0.8360</td>\n",
       "      <td>0.1640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23964</th>\n",
       "      <td>MORTIS</td>\n",
       "      <td>BO</td>\n",
       "      <td>PIPER</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>Ring of Fire</td>\n",
       "      <td>hotZone</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000011</td>\n",
       "      <td>assassin</td>\n",
       "      <td>short</td>\n",
       "      <td>very fast</td>\n",
       "      <td>5700</td>\n",
       "      <td>16000014</td>\n",
       "      <td>area control</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5220</td>\n",
       "      <td>16000015</td>\n",
       "      <td>sniper</td>\n",
       "      <td>very long</td>\n",
       "      <td>normal</td>\n",
       "      <td>3360</td>\n",
       "      <td>n</td>\n",
       "      <td>0.8360</td>\n",
       "      <td>0.1640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33506</th>\n",
       "      <td>NITA</td>\n",
       "      <td>BO</td>\n",
       "      <td>TARA</td>\n",
       "      <td>brawlBall</td>\n",
       "      <td>Sneaky Fields</td>\n",
       "      <td>brawlBall</td>\n",
       "      <td>ranked</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>32622.569317</td>\n",
       "      <td>623.282998</td>\n",
       "      <td>11</td>\n",
       "      <td>16000008</td>\n",
       "      <td>area control</td>\n",
       "      <td>short</td>\n",
       "      <td>normal</td>\n",
       "      <td>5800</td>\n",
       "      <td>16000014</td>\n",
       "      <td>area control</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>5220</td>\n",
       "      <td>16000017</td>\n",
       "      <td>area control</td>\n",
       "      <td>long</td>\n",
       "      <td>normal</td>\n",
       "      <td>4800</td>\n",
       "      <td>n</td>\n",
       "      <td>0.8361</td>\n",
       "      <td>0.1639</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1791552 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        battle.player1.brawler.name battle.player2.brawler.name  \\\n",
       "1784754                        ROSA                      BUSTER   \n",
       "1782217                        ROSA                         GUS   \n",
       "1784566                       FRANK                      BUSTER   \n",
       "1785872                         ASH                      BUSTER   \n",
       "1786216                         SAM                      BUSTER   \n",
       "...                             ...                         ...   \n",
       "23973                        MORTIS                          BO   \n",
       "23965                        MORTIS                          BO   \n",
       "23963                        MORTIS                          BO   \n",
       "23964                        MORTIS                          BO   \n",
       "33506                          NITA                          BO   \n",
       "\n",
       "        battle.player3.brawler.name event.mode        event.map battle.mode  \\\n",
       "1784754                       MANDY   knockout  New Perspective    knockout   \n",
       "1782217                       MANDY   knockout  New Perspective    knockout   \n",
       "1784566                       MANDY  brawlBall       Beach Ball   brawlBall   \n",
       "1785872                       MANDY   knockout  New Perspective    knockout   \n",
       "1786216                       MANDY   knockout  New Perspective    knockout   \n",
       "...                             ...        ...              ...         ...   \n",
       "23973                         PIPER    hotZone        Open Zone     hotZone   \n",
       "23965                         PIPER    hotZone  Quarter Pounder     hotZone   \n",
       "23963                         PIPER    hotZone  Dueling Beetles     hotZone   \n",
       "23964                         PIPER    hotZone     Ring of Fire     hotZone   \n",
       "33506                          TARA  brawlBall    Sneaky Fields   brawlBall   \n",
       "\n",
       "        battle.type  battle.player1.trophies  battle.player1.brawler.trophies  \\\n",
       "1784754      ranked             32622.569317                       623.282998   \n",
       "1782217      ranked             32622.569317                       623.282998   \n",
       "1784566      ranked             32622.569317                       623.282998   \n",
       "1785872      ranked             32622.569317                       623.282998   \n",
       "1786216      ranked             32622.569317                       623.282998   \n",
       "...             ...                      ...                              ...   \n",
       "23973        ranked             32622.569317                       623.282998   \n",
       "23965        ranked             32622.569317                       623.282998   \n",
       "23963        ranked             32622.569317                       623.282998   \n",
       "23964        ranked             32622.569317                       623.282998   \n",
       "33506        ranked             32622.569317                       623.282998   \n",
       "\n",
       "         battle.player1.brawler.power  battle.player2.trophies  \\\n",
       "1784754                            11             32622.569317   \n",
       "1782217                            11             32622.569317   \n",
       "1784566                            11             32622.569317   \n",
       "1785872                            11             32622.569317   \n",
       "1786216                            11             32622.569317   \n",
       "...                               ...                      ...   \n",
       "23973                              11             32622.569317   \n",
       "23965                              11             32622.569317   \n",
       "23963                              11             32622.569317   \n",
       "23964                              11             32622.569317   \n",
       "33506                              11             32622.569317   \n",
       "\n",
       "         battle.player2.brawler.trophies  battle.player2.brawler.power  \\\n",
       "1784754                       623.282998                            11   \n",
       "1782217                       623.282998                            11   \n",
       "1784566                       623.282998                            11   \n",
       "1785872                       623.282998                            11   \n",
       "1786216                       623.282998                            11   \n",
       "...                                  ...                           ...   \n",
       "23973                         623.282998                            11   \n",
       "23965                         623.282998                            11   \n",
       "23963                         623.282998                            11   \n",
       "23964                         623.282998                            11   \n",
       "33506                         623.282998                            11   \n",
       "\n",
       "         battle.player3.trophies  battle.player3.brawler.trophies  \\\n",
       "1784754             32622.569317                       623.282998   \n",
       "1782217             32622.569317                       623.282998   \n",
       "1784566             32622.569317                       623.282998   \n",
       "1785872             32622.569317                       623.282998   \n",
       "1786216             32622.569317                       623.282998   \n",
       "...                          ...                              ...   \n",
       "23973               32622.569317                       623.282998   \n",
       "23965               32622.569317                       623.282998   \n",
       "23963               32622.569317                       623.282998   \n",
       "23964               32622.569317                       623.282998   \n",
       "33506               32622.569317                       623.282998   \n",
       "\n",
       "         battle.player3.brawler.power  battle.player1.brawler.id  \\\n",
       "1784754                            11                   16000024   \n",
       "1782217                            11                   16000024   \n",
       "1784566                            11                   16000020   \n",
       "1785872                            11                   16000051   \n",
       "1786216                            11                   16000060   \n",
       "...                               ...                        ...   \n",
       "23973                              11                   16000011   \n",
       "23965                              11                   16000011   \n",
       "23963                              11                   16000011   \n",
       "23964                              11                   16000011   \n",
       "33506                              11                   16000008   \n",
       "\n",
       "        battle.player1.brawler.role battle.player1.brawler.range  \\\n",
       "1784754                        tank                        short   \n",
       "1782217                        tank                        short   \n",
       "1784566                        tank                       normal   \n",
       "1785872                        tank                        short   \n",
       "1786216                        tank                        short   \n",
       "...                             ...                          ...   \n",
       "23973                      assassin                        short   \n",
       "23965                      assassin                        short   \n",
       "23963                      assassin                        short   \n",
       "23964                      assassin                        short   \n",
       "33506                  area control                        short   \n",
       "\n",
       "        battle.player1.brawler.speed  battle.player1.brawler.health  \\\n",
       "1784754                         fast                           7830   \n",
       "1782217                         fast                           7830   \n",
       "1784566                         fast                          10150   \n",
       "1785872                       normal                           7830   \n",
       "1786216                         fast                           7560   \n",
       "...                              ...                            ...   \n",
       "23973                      very fast                           5700   \n",
       "23965                      very fast                           5700   \n",
       "23963                      very fast                           5700   \n",
       "23964                      very fast                           5700   \n",
       "33506                         normal                           5800   \n",
       "\n",
       "         battle.player2.brawler.id battle.player2.brawler.role  \\\n",
       "1784754                   16000062                area control   \n",
       "1782217                   16000061                      healer   \n",
       "1784566                   16000062                area control   \n",
       "1785872                   16000062                area control   \n",
       "1786216                   16000062                area control   \n",
       "...                            ...                         ...   \n",
       "23973                     16000014                area control   \n",
       "23965                     16000014                area control   \n",
       "23963                     16000014                area control   \n",
       "23964                     16000014                area control   \n",
       "33506                     16000014                area control   \n",
       "\n",
       "        battle.player2.brawler.range battle.player2.brawler.speed  \\\n",
       "1784754                       normal                         fast   \n",
       "1782217                         long                       normal   \n",
       "1784566                       normal                         fast   \n",
       "1785872                       normal                         fast   \n",
       "1786216                       normal                         fast   \n",
       "...                              ...                          ...   \n",
       "23973                           long                       normal   \n",
       "23965                           long                       normal   \n",
       "23963                           long                       normal   \n",
       "23964                           long                       normal   \n",
       "33506                           long                       normal   \n",
       "\n",
       "         battle.player2.brawler.health  battle.player3.brawler.id  \\\n",
       "1784754                           6960                   16000065   \n",
       "1782217                           4480                   16000065   \n",
       "1784566                           6960                   16000065   \n",
       "1785872                           6960                   16000065   \n",
       "1786216                           6960                   16000065   \n",
       "...                                ...                        ...   \n",
       "23973                             5220                   16000015   \n",
       "23965                             5220                   16000015   \n",
       "23963                             5220                   16000015   \n",
       "23964                             5220                   16000015   \n",
       "33506                             5220                   16000017   \n",
       "\n",
       "        battle.player3.brawler.role battle.player3.brawler.range  \\\n",
       "1784754                      sniper                    very long   \n",
       "1782217                      sniper                    very long   \n",
       "1784566                      sniper                    very long   \n",
       "1785872                      sniper                    very long   \n",
       "1786216                      sniper                    very long   \n",
       "...                             ...                          ...   \n",
       "23973                        sniper                    very long   \n",
       "23965                        sniper                    very long   \n",
       "23963                        sniper                    very long   \n",
       "23964                        sniper                    very long   \n",
       "33506                  area control                         long   \n",
       "\n",
       "        battle.player3.brawler.speed  battle.player3.brawler.health Label  \\\n",
       "1784754                       normal                           5600     n   \n",
       "1782217                       normal                           5600     n   \n",
       "1784566                       normal                           5600     n   \n",
       "1785872                       normal                           5600     n   \n",
       "1786216                       normal                           5600     n   \n",
       "...                              ...                            ...   ...   \n",
       "23973                         normal                           3360     n   \n",
       "23965                         normal                           3360     n   \n",
       "23963                         normal                           3360     n   \n",
       "23964                         normal                           3360     n   \n",
       "33506                         normal                           4800     n   \n",
       "\n",
       "         Score_n  Score_y  \n",
       "1784754   0.5334   0.4666  \n",
       "1782217   0.5380   0.4620  \n",
       "1784566   0.5451   0.4549  \n",
       "1785872   0.5481   0.4519  \n",
       "1786216   0.5481   0.4519  \n",
       "...          ...      ...  \n",
       "23973     0.8360   0.1640  \n",
       "23965     0.8360   0.1640  \n",
       "23963     0.8360   0.1640  \n",
       "23964     0.8360   0.1640  \n",
       "33506     0.8361   0.1639  \n",
       "\n",
       "[1791552 rows x 34 columns]"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "predictions.sort_values(by='Score_y', ascending=False)\n",
    "\n",
    "#SE DEBE ELIMINAR TROPHIES DEL MODELO"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.6 (tags/v3.8.6:db45529, Sep 23 2020, 15:52:53) [MSC v.1927 64 bit (AMD64)]"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "5d5af72915014b523270dad1d750ededc2937d535a8c3784804f81f7507c8e83"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}