Best Bottom Combo of 2017 Season.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['stats1.csv', 'champs.csv', 'stats2.csv', 'participants.csv', 'matches.csv', 'teamstats.csv', 'teambans.csv']\n"
     ]
    }
   ],
   "source": [
    "import numpy as np # linear algebra\n",
    "import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "import os\n",
    "\n",
    "print(os.listdir(\"./ranked-matches\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "CHAMP = pd.read_csv(\"./ranked-matches/champs.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{1: 'Annie',\n",
       " 2: 'Olaf',\n",
       " 3: 'Galio',\n",
       " 4: 'Twisted Fate',\n",
       " 5: 'Xin Zhao',\n",
       " 6: 'Urgot',\n",
       " 7: 'LeBlanc',\n",
       " 8: 'Vladimir',\n",
       " 9: 'Fiddlesticks',\n",
       " 10: 'Kayle',\n",
       " 11: 'Master Yi',\n",
       " 12: 'Alistar',\n",
       " 13: 'Ryze',\n",
       " 14: 'Sion',\n",
       " 15: 'Sivir',\n",
       " 16: 'Soraka',\n",
       " 17: 'Teemo',\n",
       " 18: 'Tristana',\n",
       " 19: 'Warwick',\n",
       " 20: 'Nunu',\n",
       " 21: 'Miss Fortune',\n",
       " 22: 'Ashe',\n",
       " 23: 'Tryndamere',\n",
       " 24: 'Jax',\n",
       " 25: 'Morgana',\n",
       " 26: 'Zilean',\n",
       " 27: 'Singed',\n",
       " 28: 'Evelynn',\n",
       " 29: 'Twitch',\n",
       " 30: 'Karthus',\n",
       " 31: 'ChoGath',\n",
       " 32: 'Amumu',\n",
       " 33: 'Rammus',\n",
       " 34: 'Anivia',\n",
       " 35: 'Shaco',\n",
       " 36: 'DrMundo',\n",
       " 37: 'Sona',\n",
       " 38: 'Kassadin',\n",
       " 39: 'Irelia',\n",
       " 40: 'Janna',\n",
       " 41: 'Gangplank',\n",
       " 42: 'Corki',\n",
       " 43: 'Karma',\n",
       " 44: 'Taric',\n",
       " 45: 'Veigar',\n",
       " 48: 'Trundle',\n",
       " 50: 'Swain',\n",
       " 51: 'Caitlyn',\n",
       " 53: 'Blitzcrank',\n",
       " 54: 'Malphite',\n",
       " 55: 'Katarina',\n",
       " 56: 'Nocturne',\n",
       " 57: 'Maokai',\n",
       " 58: 'Renekton',\n",
       " 59: 'Jarvan IV',\n",
       " 60: 'Elise',\n",
       " 61: 'Orianna',\n",
       " 62: 'Wukong',\n",
       " 63: 'Brand',\n",
       " 64: 'Lee Sin',\n",
       " 67: 'Vayne',\n",
       " 68: 'Rumble',\n",
       " 69: 'Cassiopeia',\n",
       " 72: 'Skarner',\n",
       " 74: 'Heimerdinger',\n",
       " 75: 'Nasus',\n",
       " 76: 'Nidalee',\n",
       " 77: 'Udyr',\n",
       " 78: 'Poppy',\n",
       " 79: 'Gragas',\n",
       " 80: 'Pantheon',\n",
       " 81: 'Ezreal',\n",
       " 82: 'Mordekaiser',\n",
       " 83: 'Yorick',\n",
       " 84: 'Akali',\n",
       " 85: 'Kennen',\n",
       " 86: 'Garen',\n",
       " 89: 'Leona',\n",
       " 90: 'Malzahar',\n",
       " 91: 'Talon',\n",
       " 92: 'Riven',\n",
       " 96: 'KogMaw',\n",
       " 98: 'Shen',\n",
       " 99: 'Lux',\n",
       " 101: 'Xerath',\n",
       " 102: 'Shyvana',\n",
       " 103: 'Ahri',\n",
       " 104: 'Graves',\n",
       " 105: 'Fizz',\n",
       " 106: 'Volibear',\n",
       " 107: 'Rengar',\n",
       " 110: 'Varus',\n",
       " 111: 'Nautilus',\n",
       " 112: 'Viktor',\n",
       " 113: 'Sejuani',\n",
       " 114: 'Fiora',\n",
       " 115: 'Ziggs',\n",
       " 117: 'Lulu',\n",
       " 119: 'Draven',\n",
       " 120: 'Hecarim',\n",
       " 121: 'KhaZix',\n",
       " 122: 'Darius',\n",
       " 126: 'Jayce',\n",
       " 127: 'Lissandra',\n",
       " 131: 'Diana',\n",
       " 133: 'Quinn',\n",
       " 134: 'Syndra',\n",
       " 136: 'Aurelion Sol',\n",
       " 141: 'Kayn',\n",
       " 143: 'Zyra',\n",
       " 150: 'Gnar',\n",
       " 154: 'Zac',\n",
       " 157: 'Yasuo',\n",
       " 161: 'VelKoz',\n",
       " 163: 'Taliyah',\n",
       " 164: 'Camille',\n",
       " 201: 'Braum',\n",
       " 202: 'Jhin',\n",
       " 203: 'Kindred',\n",
       " 222: 'Jinx',\n",
       " 223: 'Tahm Kench',\n",
       " 236: 'Lucian',\n",
       " 238: 'Zed',\n",
       " 240: 'Kled',\n",
       " 245: 'Ekko',\n",
       " 254: 'Vi',\n",
       " 266: 'Aatrox',\n",
       " 267: 'Nami',\n",
       " 268: 'Azir',\n",
       " 412: 'Thresh',\n",
       " 420: 'Illaoi',\n",
       " 421: 'RekSai',\n",
       " 427: 'Ivern',\n",
       " 429: 'Kalista',\n",
       " 432: 'Bard',\n",
       " 497: 'Rakan',\n",
       " 498: 'Xayah',\n",
       " 516: 'Ornn'}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "champ_id = CHAMP.set_index('id')['name'].to_dict()\n",
    "champ_id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1834520 entries, 0 to 1834519\n",
      "Data columns (total 8 columns):\n",
      "id            int64\n",
      "matchid       int64\n",
      "player        int64\n",
      "championid    int64\n",
      "ss1           int64\n",
      "ss2           int64\n",
      "role          object\n",
      "position      object\n",
      "dtypes: int64(6), object(2)\n",
      "memory usage: 112.0+ MB\n"
     ]
    }
   ],
   "source": [
    "PLAYERS = pd.read_csv(\"./ranked-matches//participants.csv\")\n",
    "PLAYERS.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>matchid</th>\n",
       "      <th>player</th>\n",
       "      <th>championid</th>\n",
       "      <th>ss1</th>\n",
       "      <th>ss2</th>\n",
       "      <th>role</th>\n",
       "      <th>position</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>267</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>DUO_SUPPORT</td>\n",
       "      <td>BOT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>119</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>DUO_CARRY</td>\n",
       "      <td>BOT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>17</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>222</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>DUO_CARRY</td>\n",
       "      <td>BOT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>18</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>161</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>DUO_SUPPORT</td>\n",
       "      <td>BOT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>19</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>115</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>DUO_SUPPORT</td>\n",
       "      <td>BOT</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    id  matchid  player  championid  ss1  ss2         role position\n",
       "1   10       10       2         267    3    4  DUO_SUPPORT      BOT\n",
       "2   11       10       3         119    7    4    DUO_CARRY      BOT\n",
       "8   17       10       9         222    7    4    DUO_CARRY      BOT\n",
       "9   18       10      10         161   14    4  DUO_SUPPORT      BOT\n",
       "10  19       11       1         115    3    4  DUO_SUPPORT      BOT"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bottom = PLAYERS[PLAYERS[\"position\"] == \"BOT\"]\n",
    "bottom.reset_index(drop = True)\n",
    "bottom.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>id</th>\n",
       "      <th>matchid</th>\n",
       "      <th>player</th>\n",
       "      <th>championid</th>\n",
       "      <th>ss1</th>\n",
       "      <th>ss2</th>\n",
       "      <th>role</th>\n",
       "      <th>position</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>267</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>DUO_SUPPORT</td>\n",
       "      <td>BOT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>119</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>DUO_CARRY</td>\n",
       "      <td>BOT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>17</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>222</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>DUO_CARRY</td>\n",
       "      <td>BOT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>18</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>161</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>DUO_SUPPORT</td>\n",
       "      <td>BOT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>19</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>115</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>DUO_SUPPORT</td>\n",
       "      <td>BOT</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    id  matchid  player  championid  ss1  ss2         role position\n",
       "1   10       10       2         267    3    4  DUO_SUPPORT      BOT\n",
       "2   11       10       3         119    7    4    DUO_CARRY      BOT\n",
       "8   17       10       9         222    7    4    DUO_CARRY      BOT\n",
       "9   18       10      10         161   14    4  DUO_SUPPORT      BOT\n",
       "10  19       11       1         115    3    4  DUO_SUPPORT      BOT"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bt_cnt = bottom.reset_index(drop=True).groupby('matchid').count()\n",
    "not_4 = bt_cnt[bt_cnt['player'] != 4].reset_index()\n",
    "bottom = bottom[~bottom['matchid'].isin(not_4['matchid'])]\n",
    "bottom.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 176840 entries, 0 to 176839\n",
      "Data columns (total 1 columns):\n",
      "matchid    176840 non-null int64\n",
      "dtypes: int64(1)\n",
      "memory usage: 1.3 MB\n"
     ]
    }
   ],
   "source": [
    "new_matches = pd.DataFrame()\n",
    "new_matches['matchid'] = bottom['matchid'].drop_duplicates()\n",
    "new_matches = new_matches.reset_index(drop = True)\n",
    "new_matches.info()\n",
    "# 각 게임에 대한 정보이므로 중복 matchid는 드랍"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "a = pd.DataFrame(bottom['championid'].values.reshape((-1, 2)))\n",
    "a = a.replace(champ_id).apply(', '.join, axis=1)\n",
    "# 바텀 조합 구한 뒤 챔피언 이름으로 변경"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>matchid</th>\n",
       "      <th>Blue_Team</th>\n",
       "      <th>Red_Team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10</td>\n",
       "      <td>Nami, Draven</td>\n",
       "      <td>Jinx, VelKoz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11</td>\n",
       "      <td>Ziggs, Cassiopeia</td>\n",
       "      <td>Caitlyn, Karma</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12</td>\n",
       "      <td>Draven, Janna</td>\n",
       "      <td>Nami, Twitch</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13</td>\n",
       "      <td>Jinx, Zed</td>\n",
       "      <td>Tristana, Rakan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>14</td>\n",
       "      <td>Caitlyn, Zac</td>\n",
       "      <td>Lucian, Karma</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>15</td>\n",
       "      <td>Miss Fortune, Thresh</td>\n",
       "      <td>Nami, Ziggs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>16</td>\n",
       "      <td>Lucian, Taric</td>\n",
       "      <td>Leona, Twitch</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176836</th>\n",
       "      <td>187585</td>\n",
       "      <td>Tristana, Rammus</td>\n",
       "      <td>Lucian, Braum</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176837</th>\n",
       "      <td>187586</td>\n",
       "      <td>Braum, Kindred</td>\n",
       "      <td>Janna, Ashe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176838</th>\n",
       "      <td>187587</td>\n",
       "      <td>Blitzcrank, Quinn</td>\n",
       "      <td>Jinx, Sona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176839</th>\n",
       "      <td>187588</td>\n",
       "      <td>Tristana, Morgana</td>\n",
       "      <td>Jinx, Blitzcrank</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        matchid             Blue_Team          Red_Team\n",
       "0            10          Nami, Draven      Jinx, VelKoz\n",
       "1            11     Ziggs, Cassiopeia    Caitlyn, Karma\n",
       "2            12         Draven, Janna      Nami, Twitch\n",
       "3            13             Jinx, Zed   Tristana, Rakan\n",
       "4            14          Caitlyn, Zac     Lucian, Karma\n",
       "5            15  Miss Fortune, Thresh       Nami, Ziggs\n",
       "6            16         Lucian, Taric     Leona, Twitch\n",
       "176836   187585      Tristana, Rammus     Lucian, Braum\n",
       "176837   187586        Braum, Kindred       Janna, Ashe\n",
       "176838   187587     Blitzcrank, Quinn        Jinx, Sona\n",
       "176839   187588     Tristana, Morgana  Jinx, Blitzcrank"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_matches.insert(loc = 1, column = 'Blue_Team', value = a[::2].reset_index(drop = True))\n",
    "new_matches.insert(loc = 2, column = 'Red_Team', value = a[1::2].reset_index(drop = True))\n",
    "# 각 팀 바텀 조합 new_matches에 입력\n",
    "new_matches.iloc[np.r_[0:7, -4:0]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# stas.csv - id 로 승리 팀 구분"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "STATS_1 = pd.read_csv(\"./ranked-matches/stats1.csv\", low_memory=False)\n",
    "STATS_2 = pd.read_csv(\"./ranked-matches/stats2.csv\", low_memory=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "STATS = pd.concat([STATS_1, STATS_2])\n",
    "STATS = STATS[STATS[\"id\"].isin(bottom[\"id\"])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "arr = STATS.values\n",
    "arr = arr.reshape(176840, 4, 56)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>Blue_1</th>\n",
       "      <th>Blue_2</th>\n",
       "      <th>Red_1</th>\n",
       "      <th>Red_2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>17</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>19</td>\n",
       "      <td>20</td>\n",
       "      <td>24</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>29</td>\n",
       "      <td>30</td>\n",
       "      <td>37</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40</td>\n",
       "      <td>43</td>\n",
       "      <td>44</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>52</td>\n",
       "      <td>53</td>\n",
       "      <td>54</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Blue_1 Blue_2 Red_1 Red_2\n",
       "0     10     11    17    18\n",
       "1     19     20    24    27\n",
       "2     29     30    37    38\n",
       "3     40     43    44    47\n",
       "4     52     53    54    56"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(\n",
    "    {\n",
    "        'Blue_1': arr[:][:, 0][:, 0],\n",
    "        'Blue_2': arr[:][:, 1][:, 0],\n",
    "        'Red_1': arr[:][:, 2][:, 0],\n",
    "        'Red_2': arr[:][:, 3][:, 0]\n",
    "    }\n",
    ").head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "win = pd.DataFrame(STATS['win'].astype(str).values.reshape(-1, 4)).apply(''.join,axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "win_combo = pd.DataFrame(\n",
    "    {\n",
    "        'Blue_1 id': arr[:][:, 0][:, 0],\n",
    "        'Blue_2 id': arr[:][:, 1][:, 0],\n",
    "        'Red_1 id': arr[:][:, 2][:, 0],\n",
    "        'Red_2 id': arr[:][:, 3][:, 0],\n",
    "        'Win': win\n",
    "    }\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_matches = pd.concat([new_matches, win_combo], axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_matches = new_matches[new_matches[\"Win\"].isin([\"1100\", \"0011\"])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "winner_dict = {\n",
    "    \"0011\" : \"RED\",\n",
    "    \"1100\" : \"BLUE\"\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_matches[\"Win\"] = new_matches[\"Win\"].replace(winner_dict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "WinRate = new_matches.groupby(\"Win\").count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Win\n",
       "BLUE    0.51335\n",
       "RED     0.48665\n",
       "Name: matchid, dtype: float64"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "WinRate[\"matchid\"] / WinRate[\"matchid\"].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1a9ea2c320>"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAATYAAAElCAYAAABu/s6cAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAGORJREFUeJzt3XmYZFV9xvHvYfa1GBgYZkblPiJG3IiKCygu4BOXwhVcMCoJJJq4MC6QXE2IlwhaJmoEn6ACRpk8GmJQiXiVaBAXBkQWh8ijggKloCL2LHdmmH3m5I9T47RDd09Vd1X97j33/TxPPT3d1pRvT1Nvn3vvuec47z0iIjE5wDqAiEi/qdhEJDoqNhGJjopNRKKjYhOR6KjYRCQ6KjYRiY6KTUSio2ITkeio2EQkOio2EYmOik1EoqNiE5HoqNhEJDoqNhGJjopNRKKjYhOR6KjYRCQ6KjYRiY6KTUSio2ITkeio2OT3nHO7nHOrnXO3Oedudc4d1/l64py7fYznf9s5d8yoz3//POfcc51zRef19jyeP7zvRupsunUAKZUt3vs/BnDOvQD4IPCcKbze97z3J/UlmUgPNGKT8SwE1lmHEJkMjdhktDnOudXAbGApcMIUX+/4zuvtcbL3/q4pvqbIfqnYZLTRh6LHAiudc4+f4Pl+P1/ToaiY0KGojMl7fwOwGDhkgqetARaN+vwgYGSQuUS6oWKTMTnnHgNMI5TXeL4NvN455zqfnwZcO+BoIvulQ1EZbc6oc2IOOM17v6vTW3/knLtv1HPfCVwMPAa4zTnngZuB94x6zr7n2M7z3l8xuPgigfN+rNMkIiLVpUNREYmOik1EoqNiE5HoqNhEJDoqNhGJjopNRKKjeWwyUEmazwQahJvqG8BcYBYwc9TH6cAWoNj30W41txvElorTPDaZkiTNFwOP2udxBJAABxJuqJ+Kbewtug3AeuBe4KfATzof72q3mrum+P8jEVGxSVeSND8KeBrwaP6wwBqWuTq2A3cRSm504f203WputAwmNlRs8hBJmh8AHA08u/M4nolvhi+znwLfAq4Brm23mlpjrgZUbEKS5jOAY9hbZM+kHCOxftsNrGZv0X2v3Wo+aBtJBkHFVlNJmh8MnAKcTCiyubaJTOwAbmRv0a3Subo4qNhqJEnz+cDLgFOBPwFm2CYqnQeALwD/AdzQbjX15qgoFVvkOtMtXgS8DjiJeo7MJuMXwOXAynar+WPrMNIbFVuEOif/n0cYmZ1MmHYhk3cjcClwebvV3GQdRvZPxRaRJM0XAH8BnEmYRyb99SDhUPUT7VbzJuswMj4VWwSSND8cWAGcQZjhL4N3DfD+dqv5Hesg8lAqtgpL0vwJwHuBVxH2J5Dh+x5wfrvV/B/rILKXiq2CkjR/CnAO8FLC3gRi7ybgPOAqXU21p2KrkCTNnwacC7zQOouM6zbgA8AV7VZzt3WYulKxVUCS5kuADwFvRCO0qvgpcG671bzcOkgdqdhKLEnz6YQrnO9DFwWq6lvAW9qt5h3WQepExVZSSZqfCFwIPNY6i0zZduCfgfPareZW6zB1oGIrmSTNHwF8hHAfp8TlbuBt7Vbz69ZBYqdiK4kkzWcBZxN2UtdtT3H7IrCi3Wr+yjpIrFRsJZCk+fHAZwgLN0o9bCScO71QK4r0n4rNUOeeznM6D02wrafbgNe3W83brYPERMVmJEnzZcDngOcaRxF7m4G/breaK62DxELFZiBJ8xcDlwGLrbNIqVwKvF1XTqdOxTZEnbXRWsA70ERbGdttwCntVvPn1kGqTMU2JEmaH0FYuPAY6yxSehuA09ut5hetg1SVim0IkjR/LfApdPeA9OYC4Ox2q7nDOkjVqNgGLEnzDxDmpolMxveBV7dbzXutg1SJim1AkjSfBlwMnG6dRSpvBHhJu9X8vnWQqlCxDUCS5nMIS0ifZJ1ForGZMHLLrYNUwQHWAWKTpPlBhGWjVWrST3OBK5M0/zPrIFWgYuujJM0fDlwHHGudRaI0HfhMkuapdZCyU7H1SZLmjwduAI6yziLR+2CS5h+0DlFmOsfWB0maPwu4Cu3fKcN1QbvVfId1iDJSsU1RkuYvAr4EzLbOIrX0ScIKvXojj6Jim4IkzZ8NXA3Msc4itfZZ4AxtHrOXzrFNUpLmTyYcfqrUxNqfEVZdlg6N2CYhSfOjgO+i1TmkXFa0W80LrUOUgYqtR50pHdcDD7POIrKP3cDJ7VbzSusg1lRsPUjSvAGsAh5nnUVkHFuA57VbzRutg1jSObYuJWk+g3D1U6UmZTYHuKqzTFZtqdi692ngBOsQIl04BPh6kuYHWwexomLrQpLmGfAG6xwiPTgS+O8kzWs5v1Ln2PYjSfMXAF9HS3lLNV1BWBWkVm90jdgmkKT5YcBKVGpSXacAf28dYtg0YhtHZ8/PbwAnWmcRmaKdwLPqdKVUI7bxpajUJA7Tgc8laT7fOsiwqNjGkKT5ccC51jlE+ugIoDZ3JehQdB9Jmi8CVgOPsM4iMgCvareaV1iHGDSN2B7q06jUJF4XJ2ke/e2AKrZRkjR/K/AK6xwiA7QIuCxJ86iv9KvYOpI0fxzwYescIkNwAnCWdYhBUrHtdRFaBVfq47wkzZ9kHWJQVGxAkuavBZ5tnUNkiGYSdryKsgOi/KZ6kaT5PHQIKvV0NHC6dYhBqH2xAX8HLLcOIWLkvCTNF1iH6LdaF1tnzap3WecQMbQEeI91iH6rdbEBHwNmWYcQMfbOJM0Ptw7RT7UttiTNXwycZJ1DpARmAy3rEP1Uy1uqkjSfCdxOWIxPRILj2q3mDdYh+qGuI7Z3oVIT2de/xHJHQu2KrbPTVHQnS0X64OnAqdYh+qF2xQa8GVhoHUKkpFox7JNQq2LrnFtbYZ1DpMQeDpxmHWKqalVswJ8Cy6xDiJTcu6t+q1Wlw/eic1I06hUNRPrkSODl1iGmojbFBjSBx1qHEKmIs60DTEWdiq3SPyiRIXtGkubPsg4xWbUotiTNn46WJRLp1ZnWASarFsWGRmsik/GKJM0rebEt+mJL0vxRaB8DkcmYDrzJOsRkRF9shAm5dfg+RQbhTUmaz7AO0auo3/CduTivs84hUmFLqeART9TFRtiNp5LnCERKpHKDg9iL7fXWAUQi8CedvUEqI9piS9J8DvBK6xwiEZgDvMg6RC+iLTbCnQbRbVIhYqRSg4SYi+1k6wAiEWl2VsephCiLLUnzWYQRm4j0x0Lg+dYhuhVlsRF+ADoMFemvyhyOxlpslfkBiFTIS5M0n2YdohvRFVtn3bWXWOcQidAhwPHWIboRXbEBRxF+ACLSf5U4Goqx2I6zDiASsUpclFOxiUgvHpmk+WLrEPsTY7E90zqASOSeah1gf6IqtiTNDwYebZ1DJHJPsw6wP1EVGzoMFRkGjdiGTIehIoNX/WJzzs11zp3jnLuk8/mRzrmTBh9tUjRiExm8Q5M0T6xDTKSbEdtngG3AsZ3P7wPOG1iiSeosX1z63yQikSj1e62bYjvCe/9PwA4A7/0WwA001eQ8GZhtHUKkJkp9AaGbYtvunJsDeADn3BGEEVzZPMk6gEiNVH7ElgFXAw93zn0OuAb420GGmqTEOoBIjTyls1lSKU3f3xO8999wzt0CPINwCLrCez8y8GS9O9w6gEiNzAceBvzSOshYurkqeo33fo33Pvfef9V7P+Kcu2YY4XqkYhMZruXWAcYz7ojNOTcbmAssds4tYu8Fg4WUc0u7xDqASM1Ur9gIO6i/g1Bit7C32DYA/zrgXD3pLAV+mHUOkZop4wAHmKDYvPcXABc4597uvf/4EDNNxsMp5xQUkZhVcsQGgPf+4865xwOPZdQ8Me/9ykEG65HOr4kMX/VGbHs4594HPJdQbF8jbJx6HaBiE6m30o7YupmHcgpwInC/9/7PgaOBWQNN1TsVm8jwVbrYtnjvdwM7nXMLgQeARw42Vs9UbCLDV9pD0W6K7Wbn3IHAJYSro7cCPxhoqt6VfqlikQjNT9J8oXWIsXRz8eAtnT9+0jl3NbDQe/9/g43VsxnWAURqahlhClip9HSvl/e+DWzbszZbiey3oEVkIEo5Yhu32JxzT3TOfcM5d7tz7jzn3BLn3BcJN8H/eHgRu6IRm4iNUg4qJhqxXQJ8HjgZ+B3h3NrdwKO89/8yhGy9KOU/rkgNlHJQMVEhzPLef7bz5zucc2cBqfd+1+Bj9ayU/7giNVDK995ExTbbOfck9t6qtAl4onPOAXjvbx10uB5oxCZio5TvvYlC/Qb46KjP7x/1uQdOGFSoSSjlP64E09i1czHF2iVuXbHUrdm03K3ZstyN7Fjq1vhD3foDZrBT9/lW1D3+sF3QtI7xEBPdBP+8YQaZolIOh2M1kx3bDmH92iVuXbHMrXlwuRvZutyN7OwU1bSD2DBzods8Zw7bF0xn5yIHDec4FDjUOrv019HcPc06w1hiGenE8n2YmMeWTYe49esOc2s3LGfN5uVuZNsyN7JzqVvLIW799EVu06z5bJk7m+0Lp7PrQOdYACztPKTedloHGEsshaAR2ygL2VQsCUW1cbkb2bzcjWxf5tbsOoy1brErpi9ym2bNY8u8WexoTGP3Qc4xn7DUs0ivdlgHGEssxVbGXbP6wrF79yI2rlvi1q8P56dGtnSKavcSt84tppjRcA/OnsfW+TPZ0TgAf5BzNICGdXapheqO2Jxzywk3mv/++d777w4q1CSssw7Qrens3LGYDWuXuLV7TqRvXe5Gdixza/yhbt0BB3fOT81l2/wZ7DzQ4Rc5x8HAwdbZRcZQzRGbc+5DwGsIdxvsmcPmARUbMIvtWw9xxdrDWFssDSfSt/3BiXS3ceYCNs+dw/YFM9i5qDOaWtJ5iFTd76wDjKWbEdvLgT/y3pf5cG9tv15oHls2HurWrVvq1m5c5tY8uIyR7cvcmvFOpC/qnJ9aRomXcBEZoF9bBxhLN8V2N+HkfAWLzfsGDxZL3Lo9J9K37Hsi/UC3afZ8ts6bGU6kL+pc8Vsw1PQi1bSOrChlL3RTbJuB1Z29RH//TXjvzxxYqh6dM33lz59wwD3fWcyGGQ23ac5cto0+kX4gcKB1RpEIlXK0Bt0V21c6j9I6Y/rVW4HnWOcQqZnfWAcYTzcLTV42jCBTVNrfHCIRK+37bqKd4L/gvX+1c+5HhKugf8B7/8SBJuvNr6wDiNRQJUdsKzofTxpGkCkq7W8OkYhVsthe45xbBfzQe1/K2cWj/JYwAzqWOylEqqC0A4qJVtB9GHAB8IBz7tvOuQ8455rOuYOGlK17WbEbuMM6hkjNlHbENm6xee/P8t4fBxwGvJcwV+x04HbnXNn2PABYbR1ApGbutA4wnm52qZpD2Ilmz43VvwZuHGSoSVKxiQzPfWTFA9YhxjPRVdGLgccBGwlFdj3wUe99WW84V7GJDM8t1gEmMtGI7RHALMKS4L8C7gPWDyPUJKnYRIanmsXmvX8h8FTgw50vvRu4qbPX6LnDCNeTrBhB89lEhqXUxTbh9AjvvSdcLFgPFJ3HScDTgPcNPl7PbgOWW4cQqYFSF9tEO8Gf6Zy73Dl3L2HttZMIUypeCZRvykegw1GRwfsVWfFb6xATmWjElgBXAO/03pd2vso+VGwig3ezdYD9mWj7vXcNM0if/NA6gEgNlPowFLqbx1Yld1Hi2dAikVCxDVVWeODr1jFEIrYL+L51iP2Jq9iCr1kHEInY9WRF3/YYGZQYi+2blHRLMJEIXGUdoBvxFVtWbACus44hEqlSbxOwR3zFFuTWAUQidCdZUYnlwWItNp1nE+m/ShyGQqzFlhU/Ae6xjiESmUochkKsxRZo1CbSP2uBVdYhuhVzsek8m0j/fI2s2GUdolsxF9s1wO+sQ4hEojKHoRBzsWXFduCz1jFEIrCBip3aibfYgksYY7NnEenJSrLiQesQvYi72LLiZ8C3rWOIVNwnrAP0Ku5iCy62DiBSYd8hK8q43eaE6lBsX0IXEUQm6yLrAJMRf7GFiwiXWccQqaD7gS9bh5iM+Ist0OGoSO8uJSsquVJOPYpNFxFEerWLCg8I6lFsQeWu7IgY+ipZca91iMmqU7FdAVTu6o6IkX+1DjAV9Sm2rNgN/IN1DJEKWEVWfNM6xFTUp9iCLwG3WocQKbnUOsBU1avYwi5WGrWJjO9rZEXll9avV7EBZEUO3GAdQ6SEPPBe6xD9UL9iC/7eOoBICV1OVtxmHaIf6llsWfEt4FrrGCIlsgM4xzpEv9Sz2AKN2kT2upSsuMs6RL/Ut9iy4noqtnieyIBsBv7ROkQ/1bfYghXAFusQIsYuICvutw7RT/Uutqz4OZBZxxAxdA9wvnWIfqt3sQUfQZN2pZ48cEbVlv3uhootbCl2BrDTOorIkH2KrIhydoCKDSArVgMfto4hMkS/AM62DjEoKra9zgXutA4hMiR/SVZssg4xKCq2PbJiK/CXaLs+id+lVV+9Y39UbKNlxXep8KqhIl24F3i3dYhBU7E91N8Av7QOITIgbyIrNliHGDQV277CD/2VwFbrKCJ9dilZcbV1iGFQsY0lK24B3mIdQ6SPbgLebh1iWFRs48mKzwCftI4h0ge/BV7ZuUBWCyq2ia1Ai1JKtW0HTiYr7rMOMkwqtomEXeRPIeyILVJFbyMrVlmHGDYV2/5kxa+BVxEW4hOpkk+QFZdYh7CgYutG2Nwi+rk/EpXvEU6l1JLzXhPtu5Y1LgPeaB1DZD9+CTyVrHjAOogVjdh68xdAbh1CZAKbgVfUudRAxdabrNhBuJhwjXUUkTFsJ5Ra7dcXVLH1KswFehlQ+U1lJSo7gdeQFd+wDlIGKrbJCCuONgmzuUWs7QZOIyuutA5SFiq2yQr3lL4AiGKDWaksD7yZrPi8dZAy0VXRqcoahwDfAY6yjiK14wkLRn7aOkjZqNj6IWssA74LHGEdRWpjN3A6WXGZdZAy0qFoP4S7E04EfmYdRWphF/BGldr4VGz9khW/AI4DbrSOIlHbCpxKVnzOOkiZ6VC037LGXOBy4CXWUSQ69wMvIyt+YB2k7DRi67esCDO/4VPWUSQqqwm3SanUuqAR2yBljXcD/4R+gcjUfBl4Q4w7tg+K3nCDlBUfAV4KbLSOIpX1QcJCkSq1HmjENgxZ43HAV4BHWkeRythGmKP279ZBqkjFNixZ42BgJfBi6yhSeg8Qbma/3jpIVanYhi1rvAX4MDDHOoqU0rWE+z7vtQ5SZTrHNmxZcRHwFOCH1lGkVLYC7wROVKlNnUZsVrLGDOD9wNnoF0zd3Uy4k+An1kFioWKzljWeQzj39gjrKDJ0O4HzgPPJip3WYWKiYiuDrHEgcBFwqnUUGZqfEEZpN1sHiZGKrUyyxmuBjwJLraPIwHjgAuA9ddqZfdhUbGWTNeYDKWG7v9nGaaS/bgTepWkcg6diK6uscTjhdqxXW0eRKWsDKVnxn9ZB6kLFVnZZ45nAx4BjrKNIz9YD5wMfJyu2WYepExVbFWQNR9io+QPAMuM0sn87gE8C55IVa6zD1JGKrUqyxjzC+bcVwALjNDK2K4G/ISu0mrIhFVsVhekhbwbORCO4MtgNXAX8M1mxyjqMqNiqLdy98DrCFdQnGKepo03AvwEXkhV3WYeRvVRsscgaLwDOAp5vHaUGfgFcCHyarCisw8hDqdhikzWOJhTca4AZxmlis4pwhfrLZMUu6zAyPhVbrLLGYYQ5cK8FjjVOU2XrCBcEPkFW3GQdRrqjYquDrJEQRnCnAkfbhqmEPWX2X8D/khU7jPNIj1RsdZM1HkMYxZ0KPNo4TZnsKbMvANeozKpNxVZnWeNJwCnACYQ7G6bbBhq6EcI0DZVZZFRsEoTJv8cCzwaeAzwdmGWaqf9+DlxHuAhwHXAHWaE3QIRUbDK2rDGLUG57iu5YYJ5ppt7sAG5lb4mtIisesI0kw6Jik+5kjemE7QOPJJybe/SoPz8McEbJCuCuzuPuzsc7gJvIii1GmcSYik2mLmvMIZTcnqJLgAbhftaFY3yc2cWrbiaU1obOxwK4l73lFYpMN5nLGFRsMnxZYyah4BYC0wibA28f9XGrJsDKVKjYRCQ62vZNRKKjYhOR6KjYRCQ6KjYRiU7dbqGRCnHO7QJ+RPjv9B7gDd779c65hLDh8B2jnv5R7/1K51wb2Nj52jTgS8D7vffaTKVGdFVUSss5t8l7P7/z58uAO73353eK7ave+8eP8XfawDHe+xHn3HzgYmCH9/604SUXaxqxSVXcADyxl7/gvd/knPsr4F7n3EHe+7WDiSZlo3NsUnrOuWnAicBXRn35COfc6lGP48f6u977DYTD2COHEFVKQiM2KbM5zrnVhFu0bgG+Oep/u8t7/8ddvo7VfaxiRCM2KbMtnfI6nHB/6Vt7fQHn3AJCMd7Z32hSZio2KT3vfUHYQ/Us51zXG9R0Lh5cBFzpvV83qHxSPio2qQTv/Q+B2wjLmsNDz7GdOerp1zrnbgd+APySsLm01Iime4hIdDRiE5HoqNhEJDoqNhGJjopNRKKjYhOR6KjYRCQ6KjYRiY6KTUSio2ITkeio2EQkOio2EYmOik1EoqNiE5HoqNhEJDoqNhGJjopNRKKjYhOR6KjYRCQ6KjYRiY6KTUSio2ITkeio2EQkOio2EYnO/wPuTo6kCyBXUQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1a0983b080>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "WinRate[\"matchid\"].plot.pie(figsize = (5,5), label= \"Win Rate\")"
   ]
  },
  {
   "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>matchid</th>\n",
       "      <th>Red_Team</th>\n",
       "      <th>Blue_1 id</th>\n",
       "      <th>Blue_2 id</th>\n",
       "      <th>Red_1 id</th>\n",
       "      <th>Red_2 id</th>\n",
       "      <th>Win</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Blue_Team</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aatrox, Caitlyn</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aatrox, Jhin</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aatrox, Xayah</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Alistar</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Ashe</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Bard</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Braum</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Camille</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Draven</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Ezreal</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Galio</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Jhin</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Jinx</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Kalista</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Karma</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Leona</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Lucian</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Malzahar</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Maokai</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Miss Fortune</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Morgana</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Nami</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Nautilus</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Riven</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Sona</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Soraka</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Teemo</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Thresh</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Tristana</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ahri, Twitch</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Draven</th>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Ezreal</th>\n",
       "      <td>210</td>\n",
       "      <td>210</td>\n",
       "      <td>210</td>\n",
       "      <td>210</td>\n",
       "      <td>210</td>\n",
       "      <td>210</td>\n",
       "      <td>210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Fiddlesticks</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Graves</th>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Heimerdinger</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Jayce</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Jhin</th>\n",
       "      <td>132</td>\n",
       "      <td>132</td>\n",
       "      <td>132</td>\n",
       "      <td>132</td>\n",
       "      <td>132</td>\n",
       "      <td>132</td>\n",
       "      <td>132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Jinx</th>\n",
       "      <td>174</td>\n",
       "      <td>174</td>\n",
       "      <td>174</td>\n",
       "      <td>174</td>\n",
       "      <td>174</td>\n",
       "      <td>174</td>\n",
       "      <td>174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Kalista</th>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Karma</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Karthus</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Kennen</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Kindred</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, KogMaw</th>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Lee Sin</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Lucian</th>\n",
       "      <td>346</td>\n",
       "      <td>346</td>\n",
       "      <td>346</td>\n",
       "      <td>346</td>\n",
       "      <td>346</td>\n",
       "      <td>346</td>\n",
       "      <td>346</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Miss Fortune</th>\n",
       "      <td>140</td>\n",
       "      <td>140</td>\n",
       "      <td>140</td>\n",
       "      <td>140</td>\n",
       "      <td>140</td>\n",
       "      <td>140</td>\n",
       "      <td>140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Quinn</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Ryze</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Sivir</th>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Teemo</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Tristana</th>\n",
       "      <td>69</td>\n",
       "      <td>69</td>\n",
       "      <td>69</td>\n",
       "      <td>69</td>\n",
       "      <td>69</td>\n",
       "      <td>69</td>\n",
       "      <td>69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Twisted Fate</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Twitch</th>\n",
       "      <td>148</td>\n",
       "      <td>148</td>\n",
       "      <td>148</td>\n",
       "      <td>148</td>\n",
       "      <td>148</td>\n",
       "      <td>148</td>\n",
       "      <td>148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Urgot</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Varus</th>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Vayne</th>\n",
       "      <td>213</td>\n",
       "      <td>213</td>\n",
       "      <td>213</td>\n",
       "      <td>213</td>\n",
       "      <td>213</td>\n",
       "      <td>213</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Veigar</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Xayah</th>\n",
       "      <td>216</td>\n",
       "      <td>216</td>\n",
       "      <td>216</td>\n",
       "      <td>216</td>\n",
       "      <td>216</td>\n",
       "      <td>216</td>\n",
       "      <td>216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zyra, Ziggs</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3959 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    matchid  Red_Team  Blue_1 id  Blue_2 id  Red_1 id  \\\n",
       "Blue_Team                                                               \n",
       "Aatrox, Caitlyn           2         2          2          2         2   \n",
       "Aatrox, Jhin              1         1          1          1         1   \n",
       "Aatrox, Xayah             1         1          1          1         1   \n",
       "Ahri, Alistar             1         1          1          1         1   \n",
       "Ahri, Ashe                1         1          1          1         1   \n",
       "Ahri, Bard                1         1          1          1         1   \n",
       "Ahri, Braum               2         2          2          2         2   \n",
       "Ahri, Camille             1         1          1          1         1   \n",
       "Ahri, Draven              3         3          3          3         3   \n",
       "Ahri, Ezreal              2         2          2          2         2   \n",
       "Ahri, Galio               1         1          1          1         1   \n",
       "Ahri, Jhin                3         3          3          3         3   \n",
       "Ahri, Jinx                1         1          1          1         1   \n",
       "Ahri, Kalista             1         1          1          1         1   \n",
       "Ahri, Karma               2         2          2          2         2   \n",
       "Ahri, Leona               1         1          1          1         1   \n",
       "Ahri, Lucian              6         6          6          6         6   \n",
       "Ahri, Malzahar            1         1          1          1         1   \n",
       "Ahri, Maokai              1         1          1          1         1   \n",
       "Ahri, Miss Fortune        1         1          1          1         1   \n",
       "Ahri, Morgana             1         1          1          1         1   \n",
       "Ahri, Nami                1         1          1          1         1   \n",
       "Ahri, Nautilus            2         2          2          2         2   \n",
       "Ahri, Riven               1         1          1          1         1   \n",
       "Ahri, Sona                1         1          1          1         1   \n",
       "Ahri, Soraka              1         1          1          1         1   \n",
       "Ahri, Teemo               1         1          1          1         1   \n",
       "Ahri, Thresh              2         2          2          2         2   \n",
       "Ahri, Tristana            1         1          1          1         1   \n",
       "Ahri, Twitch              4         4          4          4         4   \n",
       "...                     ...       ...        ...        ...       ...   \n",
       "Zyra, Draven            127       127        127        127       127   \n",
       "Zyra, Ezreal            210       210        210        210       210   \n",
       "Zyra, Fiddlesticks        1         1          1          1         1   \n",
       "Zyra, Graves             11        11         11         11        11   \n",
       "Zyra, Heimerdinger        1         1          1          1         1   \n",
       "Zyra, Jayce               1         1          1          1         1   \n",
       "Zyra, Jhin              132       132        132        132       132   \n",
       "Zyra, Jinx              174       174        174        174       174   \n",
       "Zyra, Kalista            31        31         31         31        31   \n",
       "Zyra, Karma               1         1          1          1         1   \n",
       "Zyra, Karthus             1         1          1          1         1   \n",
       "Zyra, Kennen              3         3          3          3         3   \n",
       "Zyra, Kindred             4         4          4          4         4   \n",
       "Zyra, KogMaw             16        16         16         16        16   \n",
       "Zyra, Lee Sin             1         1          1          1         1   \n",
       "Zyra, Lucian            346       346        346        346       346   \n",
       "Zyra, Miss Fortune      140       140        140        140       140   \n",
       "Zyra, Quinn               3         3          3          3         3   \n",
       "Zyra, Ryze                1         1          1          1         1   \n",
       "Zyra, Sivir              39        39         39         39        39   \n",
       "Zyra, Teemo               5         5          5          5         5   \n",
       "Zyra, Tristana           69        69         69         69        69   \n",
       "Zyra, Twisted Fate        3         3          3          3         3   \n",
       "Zyra, Twitch            148       148        148        148       148   \n",
       "Zyra, Urgot               2         2          2          2         2   \n",
       "Zyra, Varus              70        70         70         70        70   \n",
       "Zyra, Vayne             213       213        213        213       213   \n",
       "Zyra, Veigar              1         1          1          1         1   \n",
       "Zyra, Xayah             216       216        216        216       216   \n",
       "Zyra, Ziggs              12        12         12         12        12   \n",
       "\n",
       "                    Red_2 id  Win  \n",
       "Blue_Team                          \n",
       "Aatrox, Caitlyn            2    2  \n",
       "Aatrox, Jhin               1    1  \n",
       "Aatrox, Xayah              1    1  \n",
       "Ahri, Alistar              1    1  \n",
       "Ahri, Ashe                 1    1  \n",
       "Ahri, Bard                 1    1  \n",
       "Ahri, Braum                2    2  \n",
       "Ahri, Camille              1    1  \n",
       "Ahri, Draven               3    3  \n",
       "Ahri, Ezreal               2    2  \n",
       "Ahri, Galio                1    1  \n",
       "Ahri, Jhin                 3    3  \n",
       "Ahri, Jinx                 1    1  \n",
       "Ahri, Kalista              1    1  \n",
       "Ahri, Karma                2    2  \n",
       "Ahri, Leona                1    1  \n",
       "Ahri, Lucian               6    6  \n",
       "Ahri, Malzahar             1    1  \n",
       "Ahri, Maokai               1    1  \n",
       "Ahri, Miss Fortune         1    1  \n",
       "Ahri, Morgana              1    1  \n",
       "Ahri, Nami                 1    1  \n",
       "Ahri, Nautilus             2    2  \n",
       "Ahri, Riven                1    1  \n",
       "Ahri, Sona                 1    1  \n",
       "Ahri, Soraka               1    1  \n",
       "Ahri, Teemo                1    1  \n",
       "Ahri, Thresh               2    2  \n",
       "Ahri, Tristana             1    1  \n",
       "Ahri, Twitch               4    4  \n",
       "...                      ...  ...  \n",
       "Zyra, Draven             127  127  \n",
       "Zyra, Ezreal             210  210  \n",
       "Zyra, Fiddlesticks         1    1  \n",
       "Zyra, Graves              11   11  \n",
       "Zyra, Heimerdinger         1    1  \n",
       "Zyra, Jayce                1    1  \n",
       "Zyra, Jhin               132  132  \n",
       "Zyra, Jinx               174  174  \n",
       "Zyra, Kalista             31   31  \n",
       "Zyra, Karma                1    1  \n",
       "Zyra, Karthus              1    1  \n",
       "Zyra, Kennen               3    3  \n",
       "Zyra, Kindred              4    4  \n",
       "Zyra, KogMaw              16   16  \n",
       "Zyra, Lee Sin              1    1  \n",
       "Zyra, Lucian             346  346  \n",
       "Zyra, Miss Fortune       140  140  \n",
       "Zyra, Quinn                3    3  \n",
       "Zyra, Ryze                 1    1  \n",
       "Zyra, Sivir               39   39  \n",
       "Zyra, Teemo                5    5  \n",
       "Zyra, Tristana            69   69  \n",
       "Zyra, Twisted Fate         3    3  \n",
       "Zyra, Twitch             148  148  \n",
       "Zyra, Urgot                2    2  \n",
       "Zyra, Varus               70   70  \n",
       "Zyra, Vayne              213  213  \n",
       "Zyra, Veigar               1    1  \n",
       "Zyra, Xayah              216  216  \n",
       "Zyra, Ziggs               12   12  \n",
       "\n",
       "[3959 rows x 7 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_matches.groupby(\"Blue_Team\").count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "MATCHES = pd.read_csv(\"./ranked-matches/matches.csv\")\n",
    "MATCHES[MATCHES[\"seasonid\"].isnull().values]\n",
    "MATCHES = MATCHES[MATCHES[\"id\"].isin(new_matches[\"matchid\"])].reset_index(drop = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>matchid</th>\n",
       "      <th>Blue_Team</th>\n",
       "      <th>Red_Team</th>\n",
       "      <th>Blue_1 id</th>\n",
       "      <th>Blue_2 id</th>\n",
       "      <th>Red_1 id</th>\n",
       "      <th>Red_2 id</th>\n",
       "      <th>Win</th>\n",
       "      <th>season</th>\n",
       "      <th>platform</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10</td>\n",
       "      <td>Nami, Draven</td>\n",
       "      <td>Jinx, VelKoz</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>17</td>\n",
       "      <td>18</td>\n",
       "      <td>RED</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11</td>\n",
       "      <td>Ziggs, Cassiopeia</td>\n",
       "      <td>Caitlyn, Karma</td>\n",
       "      <td>19</td>\n",
       "      <td>20</td>\n",
       "      <td>24</td>\n",
       "      <td>27</td>\n",
       "      <td>RED</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12</td>\n",
       "      <td>Draven, Janna</td>\n",
       "      <td>Nami, Twitch</td>\n",
       "      <td>29</td>\n",
       "      <td>30</td>\n",
       "      <td>37</td>\n",
       "      <td>38</td>\n",
       "      <td>RED</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>13</td>\n",
       "      <td>Jinx, Zed</td>\n",
       "      <td>Tristana, Rakan</td>\n",
       "      <td>40</td>\n",
       "      <td>43</td>\n",
       "      <td>44</td>\n",
       "      <td>47</td>\n",
       "      <td>RED</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>14</td>\n",
       "      <td>Caitlyn, Zac</td>\n",
       "      <td>Lucian, Karma</td>\n",
       "      <td>52</td>\n",
       "      <td>53</td>\n",
       "      <td>54</td>\n",
       "      <td>56</td>\n",
       "      <td>RED</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>15</td>\n",
       "      <td>Miss Fortune, Thresh</td>\n",
       "      <td>Nami, Ziggs</td>\n",
       "      <td>59</td>\n",
       "      <td>62</td>\n",
       "      <td>64</td>\n",
       "      <td>67</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>16</td>\n",
       "      <td>Lucian, Taric</td>\n",
       "      <td>Leona, Twitch</td>\n",
       "      <td>72</td>\n",
       "      <td>73</td>\n",
       "      <td>76</td>\n",
       "      <td>77</td>\n",
       "      <td>RED</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>17</td>\n",
       "      <td>Thresh, Jinx</td>\n",
       "      <td>VelKoz, Caitlyn</td>\n",
       "      <td>80</td>\n",
       "      <td>81</td>\n",
       "      <td>86</td>\n",
       "      <td>87</td>\n",
       "      <td>RED</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>18</td>\n",
       "      <td>Ashe, Zilean</td>\n",
       "      <td>Thresh, Caitlyn</td>\n",
       "      <td>90</td>\n",
       "      <td>91</td>\n",
       "      <td>94</td>\n",
       "      <td>98</td>\n",
       "      <td>RED</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>19</td>\n",
       "      <td>KogMaw, Janna</td>\n",
       "      <td>Lucian, Blitzcrank</td>\n",
       "      <td>101</td>\n",
       "      <td>102</td>\n",
       "      <td>105</td>\n",
       "      <td>106</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>20</td>\n",
       "      <td>Janna, Lucian</td>\n",
       "      <td>Xayah, Rakan</td>\n",
       "      <td>109</td>\n",
       "      <td>110</td>\n",
       "      <td>115</td>\n",
       "      <td>116</td>\n",
       "      <td>RED</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>21</td>\n",
       "      <td>Draven, Janna</td>\n",
       "      <td>Rakan, Xayah</td>\n",
       "      <td>120</td>\n",
       "      <td>123</td>\n",
       "      <td>124</td>\n",
       "      <td>125</td>\n",
       "      <td>RED</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>22</td>\n",
       "      <td>Alistar, Tristana</td>\n",
       "      <td>Caitlyn, Karma</td>\n",
       "      <td>130</td>\n",
       "      <td>133</td>\n",
       "      <td>135</td>\n",
       "      <td>136</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>23</td>\n",
       "      <td>Caitlyn, Bard</td>\n",
       "      <td>Lucian, Janna</td>\n",
       "      <td>141</td>\n",
       "      <td>142</td>\n",
       "      <td>146</td>\n",
       "      <td>148</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>24</td>\n",
       "      <td>Bard, Vayne</td>\n",
       "      <td>Morgana, Twitch</td>\n",
       "      <td>150</td>\n",
       "      <td>151</td>\n",
       "      <td>154</td>\n",
       "      <td>158</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>25</td>\n",
       "      <td>Nami, Caitlyn</td>\n",
       "      <td>Vayne, Brand</td>\n",
       "      <td>161</td>\n",
       "      <td>162</td>\n",
       "      <td>165</td>\n",
       "      <td>166</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>26</td>\n",
       "      <td>Miss Fortune, Leona</td>\n",
       "      <td>Draven, Thresh</td>\n",
       "      <td>169</td>\n",
       "      <td>170</td>\n",
       "      <td>174</td>\n",
       "      <td>177</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>27</td>\n",
       "      <td>Leona, Vayne</td>\n",
       "      <td>Bard, Tristana</td>\n",
       "      <td>179</td>\n",
       "      <td>180</td>\n",
       "      <td>186</td>\n",
       "      <td>188</td>\n",
       "      <td>RED</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>28</td>\n",
       "      <td>Blitzcrank, Draven</td>\n",
       "      <td>Leona, Twitch</td>\n",
       "      <td>191</td>\n",
       "      <td>192</td>\n",
       "      <td>195</td>\n",
       "      <td>196</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>29</td>\n",
       "      <td>Bard, Xayah</td>\n",
       "      <td>Miss Fortune, Leona</td>\n",
       "      <td>200</td>\n",
       "      <td>201</td>\n",
       "      <td>205</td>\n",
       "      <td>207</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>30</td>\n",
       "      <td>Braum, Jinx</td>\n",
       "      <td>Zyra, Xayah</td>\n",
       "      <td>209</td>\n",
       "      <td>211</td>\n",
       "      <td>217</td>\n",
       "      <td>218</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>31</td>\n",
       "      <td>Rakan, Xayah</td>\n",
       "      <td>Braum, Kalista</td>\n",
       "      <td>220</td>\n",
       "      <td>222</td>\n",
       "      <td>224</td>\n",
       "      <td>226</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>32</td>\n",
       "      <td>Janna, Caitlyn</td>\n",
       "      <td>Twitch, Blitzcrank</td>\n",
       "      <td>230</td>\n",
       "      <td>231</td>\n",
       "      <td>234</td>\n",
       "      <td>236</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>33</td>\n",
       "      <td>Jhin, Braum</td>\n",
       "      <td>Morgana, Teemo</td>\n",
       "      <td>241</td>\n",
       "      <td>242</td>\n",
       "      <td>246</td>\n",
       "      <td>247</td>\n",
       "      <td>RED</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>34</td>\n",
       "      <td>Alistar, Lucian</td>\n",
       "      <td>Varus, Thresh</td>\n",
       "      <td>251</td>\n",
       "      <td>253</td>\n",
       "      <td>254</td>\n",
       "      <td>257</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>35</td>\n",
       "      <td>Morgana, Miss Fortune</td>\n",
       "      <td>Braum, Lucian</td>\n",
       "      <td>260</td>\n",
       "      <td>262</td>\n",
       "      <td>264</td>\n",
       "      <td>265</td>\n",
       "      <td>RED</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>36</td>\n",
       "      <td>Thresh, Caitlyn</td>\n",
       "      <td>Lucian, Taric</td>\n",
       "      <td>269</td>\n",
       "      <td>271</td>\n",
       "      <td>275</td>\n",
       "      <td>277</td>\n",
       "      <td>RED</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>37</td>\n",
       "      <td>Morgana, Jinx</td>\n",
       "      <td>Ezreal, Sona</td>\n",
       "      <td>279</td>\n",
       "      <td>283</td>\n",
       "      <td>287</td>\n",
       "      <td>288</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>39</td>\n",
       "      <td>Xayah, Nautilus</td>\n",
       "      <td>Ashe, Sona</td>\n",
       "      <td>299</td>\n",
       "      <td>301</td>\n",
       "      <td>306</td>\n",
       "      <td>308</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>40</td>\n",
       "      <td>Caitlyn, Nami</td>\n",
       "      <td>Jayce, Thresh</td>\n",
       "      <td>312</td>\n",
       "      <td>313</td>\n",
       "      <td>316</td>\n",
       "      <td>317</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>8</td>\n",
       "      <td>EUW1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176709</th>\n",
       "      <td>187558</td>\n",
       "      <td>Nautilus, Tristana</td>\n",
       "      <td>Nami, Varus</td>\n",
       "      <td>1865297</td>\n",
       "      <td>1865298</td>\n",
       "      <td>1865300</td>\n",
       "      <td>1865304</td>\n",
       "      <td>RED</td>\n",
       "      <td>7</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176710</th>\n",
       "      <td>187559</td>\n",
       "      <td>Tristana, Janna</td>\n",
       "      <td>Miss Fortune, Thresh</td>\n",
       "      <td>1865305</td>\n",
       "      <td>1865307</td>\n",
       "      <td>1865310</td>\n",
       "      <td>1865313</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>7</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176711</th>\n",
       "      <td>187560</td>\n",
       "      <td>Braum, Tristana</td>\n",
       "      <td>Miss Fortune, Alistar</td>\n",
       "      <td>1865317</td>\n",
       "      <td>1865319</td>\n",
       "      <td>1865321</td>\n",
       "      <td>1865323</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>7</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176712</th>\n",
       "      <td>187561</td>\n",
       "      <td>Janna, Sivir</td>\n",
       "      <td>Alistar, Corki</td>\n",
       "      <td>1865325</td>\n",
       "      <td>1865328</td>\n",
       "      <td>1865333</td>\n",
       "      <td>1865334</td>\n",
       "      <td>RED</td>\n",
       "      <td>7</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176713</th>\n",
       "      <td>187562</td>\n",
       "      <td>Morgana, Caitlyn</td>\n",
       "      <td>Jinx, Janna</td>\n",
       "      <td>1865337</td>\n",
       "      <td>1865339</td>\n",
       "      <td>1865341</td>\n",
       "      <td>1865342</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>7</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176714</th>\n",
       "      <td>187563</td>\n",
       "      <td>Jinx, Malphite</td>\n",
       "      <td>Shen, Tristana</td>\n",
       "      <td>1865345</td>\n",
       "      <td>1865348</td>\n",
       "      <td>1865350</td>\n",
       "      <td>1865351</td>\n",
       "      <td>RED</td>\n",
       "      <td>7</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176715</th>\n",
       "      <td>187564</td>\n",
       "      <td>Janna, Caitlyn</td>\n",
       "      <td>Miss Fortune, Blitzcrank</td>\n",
       "      <td>1865355</td>\n",
       "      <td>1865357</td>\n",
       "      <td>1865362</td>\n",
       "      <td>1865364</td>\n",
       "      <td>RED</td>\n",
       "      <td>7</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176716</th>\n",
       "      <td>187565</td>\n",
       "      <td>Thresh, Lucian</td>\n",
       "      <td>Janna, Vayne</td>\n",
       "      <td>1865365</td>\n",
       "      <td>1865367</td>\n",
       "      <td>1865371</td>\n",
       "      <td>1865373</td>\n",
       "      <td>RED</td>\n",
       "      <td>7</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176717</th>\n",
       "      <td>187566</td>\n",
       "      <td>Blitzcrank, Tristana</td>\n",
       "      <td>Lucian, Sona</td>\n",
       "      <td>1865376</td>\n",
       "      <td>1865378</td>\n",
       "      <td>1865381</td>\n",
       "      <td>1865384</td>\n",
       "      <td>RED</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176718</th>\n",
       "      <td>187567</td>\n",
       "      <td>Poppy, Ezreal</td>\n",
       "      <td>Janna, Vayne</td>\n",
       "      <td>1865387</td>\n",
       "      <td>1865388</td>\n",
       "      <td>1865392</td>\n",
       "      <td>1865394</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176719</th>\n",
       "      <td>187568</td>\n",
       "      <td>Alistar, Vayne</td>\n",
       "      <td>Tristana, Leona</td>\n",
       "      <td>1865398</td>\n",
       "      <td>1865399</td>\n",
       "      <td>1865401</td>\n",
       "      <td>1865402</td>\n",
       "      <td>RED</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176720</th>\n",
       "      <td>187569</td>\n",
       "      <td>Lucian, Blitzcrank</td>\n",
       "      <td>Janna, Ezreal</td>\n",
       "      <td>1865405</td>\n",
       "      <td>1865408</td>\n",
       "      <td>1865410</td>\n",
       "      <td>1865412</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176721</th>\n",
       "      <td>187570</td>\n",
       "      <td>Tristana, Morgana</td>\n",
       "      <td>Lucian, Blitzcrank</td>\n",
       "      <td>1865416</td>\n",
       "      <td>1865419</td>\n",
       "      <td>1865422</td>\n",
       "      <td>1865423</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176722</th>\n",
       "      <td>187572</td>\n",
       "      <td>Braum, Lucian</td>\n",
       "      <td>Vayne, Morgana</td>\n",
       "      <td>1865435</td>\n",
       "      <td>1865436</td>\n",
       "      <td>1865441</td>\n",
       "      <td>1865443</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176723</th>\n",
       "      <td>187573</td>\n",
       "      <td>Janna, Jinx</td>\n",
       "      <td>Graves, Blitzcrank</td>\n",
       "      <td>1865446</td>\n",
       "      <td>1865448</td>\n",
       "      <td>1865453</td>\n",
       "      <td>1865454</td>\n",
       "      <td>RED</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176724</th>\n",
       "      <td>187574</td>\n",
       "      <td>Miss Fortune, Janna</td>\n",
       "      <td>Vayne, Thresh</td>\n",
       "      <td>1865457</td>\n",
       "      <td>1865459</td>\n",
       "      <td>1865460</td>\n",
       "      <td>1865463</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176725</th>\n",
       "      <td>187575</td>\n",
       "      <td>Tristana, Sona</td>\n",
       "      <td>Jinx, Thresh</td>\n",
       "      <td>1865467</td>\n",
       "      <td>1865469</td>\n",
       "      <td>1865471</td>\n",
       "      <td>1865472</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176726</th>\n",
       "      <td>187576</td>\n",
       "      <td>Sona, Caitlyn</td>\n",
       "      <td>Thresh, Tristana</td>\n",
       "      <td>1865475</td>\n",
       "      <td>1865479</td>\n",
       "      <td>1865481</td>\n",
       "      <td>1865483</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176727</th>\n",
       "      <td>187577</td>\n",
       "      <td>Sivir, Malphite</td>\n",
       "      <td>Tristana, Leona</td>\n",
       "      <td>1865486</td>\n",
       "      <td>1865489</td>\n",
       "      <td>1865490</td>\n",
       "      <td>1865493</td>\n",
       "      <td>RED</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176728</th>\n",
       "      <td>187578</td>\n",
       "      <td>Tristana, Blitzcrank</td>\n",
       "      <td>Jinx, Thresh</td>\n",
       "      <td>1865495</td>\n",
       "      <td>1865499</td>\n",
       "      <td>1865500</td>\n",
       "      <td>1865503</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176729</th>\n",
       "      <td>187579</td>\n",
       "      <td>Alistar, Kindred</td>\n",
       "      <td>Ezreal, Leona</td>\n",
       "      <td>1865506</td>\n",
       "      <td>1865508</td>\n",
       "      <td>1865511</td>\n",
       "      <td>1865514</td>\n",
       "      <td>RED</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176730</th>\n",
       "      <td>187580</td>\n",
       "      <td>Poppy, Jinx</td>\n",
       "      <td>Tristana, Thresh</td>\n",
       "      <td>1865515</td>\n",
       "      <td>1865516</td>\n",
       "      <td>1865521</td>\n",
       "      <td>1865522</td>\n",
       "      <td>RED</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176731</th>\n",
       "      <td>187581</td>\n",
       "      <td>Tristana, Braum</td>\n",
       "      <td>Ashe, Lux</td>\n",
       "      <td>1865525</td>\n",
       "      <td>1865526</td>\n",
       "      <td>1865530</td>\n",
       "      <td>1865531</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176732</th>\n",
       "      <td>187582</td>\n",
       "      <td>Ezreal, ChoGath</td>\n",
       "      <td>Braum, Tristana</td>\n",
       "      <td>1865537</td>\n",
       "      <td>1865539</td>\n",
       "      <td>1865541</td>\n",
       "      <td>1865543</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176733</th>\n",
       "      <td>187583</td>\n",
       "      <td>Tristana, Morgana</td>\n",
       "      <td>Janna, Vayne</td>\n",
       "      <td>1865547</td>\n",
       "      <td>1865548</td>\n",
       "      <td>1865550</td>\n",
       "      <td>1865551</td>\n",
       "      <td>RED</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176734</th>\n",
       "      <td>187584</td>\n",
       "      <td>Bard, Vayne</td>\n",
       "      <td>Tryndamere, Sivir</td>\n",
       "      <td>1865558</td>\n",
       "      <td>1865559</td>\n",
       "      <td>1865560</td>\n",
       "      <td>1865562</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176735</th>\n",
       "      <td>187585</td>\n",
       "      <td>Tristana, Rammus</td>\n",
       "      <td>Lucian, Braum</td>\n",
       "      <td>1865565</td>\n",
       "      <td>1865569</td>\n",
       "      <td>1865571</td>\n",
       "      <td>1865573</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176736</th>\n",
       "      <td>187586</td>\n",
       "      <td>Braum, Kindred</td>\n",
       "      <td>Janna, Ashe</td>\n",
       "      <td>1865577</td>\n",
       "      <td>1865578</td>\n",
       "      <td>1865580</td>\n",
       "      <td>1865583</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>6</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176737</th>\n",
       "      <td>187587</td>\n",
       "      <td>Blitzcrank, Quinn</td>\n",
       "      <td>Jinx, Sona</td>\n",
       "      <td>1865586</td>\n",
       "      <td>1865588</td>\n",
       "      <td>1865590</td>\n",
       "      <td>1865593</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>5</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176738</th>\n",
       "      <td>187588</td>\n",
       "      <td>Tristana, Morgana</td>\n",
       "      <td>Jinx, Blitzcrank</td>\n",
       "      <td>1865596</td>\n",
       "      <td>1865599</td>\n",
       "      <td>1865600</td>\n",
       "      <td>1865602</td>\n",
       "      <td>BLUE</td>\n",
       "      <td>5</td>\n",
       "      <td>NA1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>176739 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        matchid              Blue_Team                  Red_Team Blue_1 id  \\\n",
       "0            10           Nami, Draven              Jinx, VelKoz        10   \n",
       "1            11      Ziggs, Cassiopeia            Caitlyn, Karma        19   \n",
       "2            12          Draven, Janna              Nami, Twitch        29   \n",
       "3            13              Jinx, Zed           Tristana, Rakan        40   \n",
       "4            14           Caitlyn, Zac             Lucian, Karma        52   \n",
       "5            15   Miss Fortune, Thresh               Nami, Ziggs        59   \n",
       "6            16          Lucian, Taric             Leona, Twitch        72   \n",
       "7            17           Thresh, Jinx           VelKoz, Caitlyn        80   \n",
       "8            18           Ashe, Zilean           Thresh, Caitlyn        90   \n",
       "9            19          KogMaw, Janna        Lucian, Blitzcrank       101   \n",
       "10           20          Janna, Lucian              Xayah, Rakan       109   \n",
       "11           21          Draven, Janna              Rakan, Xayah       120   \n",
       "12           22      Alistar, Tristana            Caitlyn, Karma       130   \n",
       "13           23          Caitlyn, Bard             Lucian, Janna       141   \n",
       "14           24            Bard, Vayne           Morgana, Twitch       150   \n",
       "15           25          Nami, Caitlyn              Vayne, Brand       161   \n",
       "16           26    Miss Fortune, Leona            Draven, Thresh       169   \n",
       "17           27           Leona, Vayne            Bard, Tristana       179   \n",
       "18           28     Blitzcrank, Draven             Leona, Twitch       191   \n",
       "19           29            Bard, Xayah       Miss Fortune, Leona       200   \n",
       "20           30            Braum, Jinx               Zyra, Xayah       209   \n",
       "21           31           Rakan, Xayah            Braum, Kalista       220   \n",
       "22           32         Janna, Caitlyn        Twitch, Blitzcrank       230   \n",
       "23           33            Jhin, Braum            Morgana, Teemo       241   \n",
       "24           34        Alistar, Lucian             Varus, Thresh       251   \n",
       "25           35  Morgana, Miss Fortune             Braum, Lucian       260   \n",
       "26           36        Thresh, Caitlyn             Lucian, Taric       269   \n",
       "27           37          Morgana, Jinx              Ezreal, Sona       279   \n",
       "28           39        Xayah, Nautilus                Ashe, Sona       299   \n",
       "29           40          Caitlyn, Nami             Jayce, Thresh       312   \n",
       "...         ...                    ...                       ...       ...   \n",
       "176709   187558     Nautilus, Tristana               Nami, Varus   1865297   \n",
       "176710   187559        Tristana, Janna      Miss Fortune, Thresh   1865305   \n",
       "176711   187560        Braum, Tristana     Miss Fortune, Alistar   1865317   \n",
       "176712   187561           Janna, Sivir            Alistar, Corki   1865325   \n",
       "176713   187562       Morgana, Caitlyn               Jinx, Janna   1865337   \n",
       "176714   187563         Jinx, Malphite            Shen, Tristana   1865345   \n",
       "176715   187564         Janna, Caitlyn  Miss Fortune, Blitzcrank   1865355   \n",
       "176716   187565         Thresh, Lucian              Janna, Vayne   1865365   \n",
       "176717   187566   Blitzcrank, Tristana              Lucian, Sona   1865376   \n",
       "176718   187567          Poppy, Ezreal              Janna, Vayne   1865387   \n",
       "176719   187568         Alistar, Vayne           Tristana, Leona   1865398   \n",
       "176720   187569     Lucian, Blitzcrank             Janna, Ezreal   1865405   \n",
       "176721   187570      Tristana, Morgana        Lucian, Blitzcrank   1865416   \n",
       "176722   187572          Braum, Lucian            Vayne, Morgana   1865435   \n",
       "176723   187573            Janna, Jinx        Graves, Blitzcrank   1865446   \n",
       "176724   187574    Miss Fortune, Janna             Vayne, Thresh   1865457   \n",
       "176725   187575         Tristana, Sona              Jinx, Thresh   1865467   \n",
       "176726   187576          Sona, Caitlyn          Thresh, Tristana   1865475   \n",
       "176727   187577        Sivir, Malphite           Tristana, Leona   1865486   \n",
       "176728   187578   Tristana, Blitzcrank              Jinx, Thresh   1865495   \n",
       "176729   187579       Alistar, Kindred             Ezreal, Leona   1865506   \n",
       "176730   187580            Poppy, Jinx          Tristana, Thresh   1865515   \n",
       "176731   187581        Tristana, Braum                 Ashe, Lux   1865525   \n",
       "176732   187582        Ezreal, ChoGath           Braum, Tristana   1865537   \n",
       "176733   187583      Tristana, Morgana              Janna, Vayne   1865547   \n",
       "176734   187584            Bard, Vayne         Tryndamere, Sivir   1865558   \n",
       "176735   187585       Tristana, Rammus             Lucian, Braum   1865565   \n",
       "176736   187586         Braum, Kindred               Janna, Ashe   1865577   \n",
       "176737   187587      Blitzcrank, Quinn                Jinx, Sona   1865586   \n",
       "176738   187588      Tristana, Morgana          Jinx, Blitzcrank   1865596   \n",
       "\n",
       "       Blue_2 id Red_1 id Red_2 id   Win  season platform  \n",
       "0             11       17       18   RED       8     EUW1  \n",
       "1             20       24       27   RED       8     EUW1  \n",
       "2             30       37       38   RED       8     EUW1  \n",
       "3             43       44       47   RED       8     EUW1  \n",
       "4             53       54       56   RED       8     EUW1  \n",
       "5             62       64       67  BLUE       8     EUW1  \n",
       "6             73       76       77   RED       8     EUW1  \n",
       "7             81       86       87   RED       8     EUW1  \n",
       "8             91       94       98   RED       8     EUW1  \n",
       "9            102      105      106  BLUE       8     EUW1  \n",
       "10           110      115      116   RED       8     EUW1  \n",
       "11           123      124      125   RED       8     EUW1  \n",
       "12           133      135      136  BLUE       8     EUW1  \n",
       "13           142      146      148  BLUE       8     EUW1  \n",
       "14           151      154      158  BLUE       8     EUW1  \n",
       "15           162      165      166  BLUE       8     EUW1  \n",
       "16           170      174      177  BLUE       8     EUW1  \n",
       "17           180      186      188   RED       8     EUW1  \n",
       "18           192      195      196  BLUE       8     EUW1  \n",
       "19           201      205      207  BLUE       8     EUW1  \n",
       "20           211      217      218  BLUE       8     EUW1  \n",
       "21           222      224      226  BLUE       8     EUW1  \n",
       "22           231      234      236  BLUE       8     EUW1  \n",
       "23           242      246      247   RED       8     EUW1  \n",
       "24           253      254      257  BLUE       8     EUW1  \n",
       "25           262      264      265   RED       8     EUW1  \n",
       "26           271      275      277   RED       8     EUW1  \n",
       "27           283      287      288  BLUE       8     EUW1  \n",
       "28           301      306      308  BLUE       8     EUW1  \n",
       "29           313      316      317  BLUE       8     EUW1  \n",
       "...          ...      ...      ...   ...     ...      ...  \n",
       "176709   1865298  1865300  1865304   RED       7      NA1  \n",
       "176710   1865307  1865310  1865313  BLUE       7      NA1  \n",
       "176711   1865319  1865321  1865323  BLUE       7      NA1  \n",
       "176712   1865328  1865333  1865334   RED       7      NA1  \n",
       "176713   1865339  1865341  1865342  BLUE       7      NA1  \n",
       "176714   1865348  1865350  1865351   RED       7      NA1  \n",
       "176715   1865357  1865362  1865364   RED       7      NA1  \n",
       "176716   1865367  1865371  1865373   RED       7      NA1  \n",
       "176717   1865378  1865381  1865384   RED       6      NA1  \n",
       "176718   1865388  1865392  1865394  BLUE       6      NA1  \n",
       "176719   1865399  1865401  1865402   RED       6      NA1  \n",
       "176720   1865408  1865410  1865412  BLUE       6      NA1  \n",
       "176721   1865419  1865422  1865423  BLUE       6      NA1  \n",
       "176722   1865436  1865441  1865443  BLUE       6      NA1  \n",
       "176723   1865448  1865453  1865454   RED       6      NA1  \n",
       "176724   1865459  1865460  1865463  BLUE       6      NA1  \n",
       "176725   1865469  1865471  1865472  BLUE       6      NA1  \n",
       "176726   1865479  1865481  1865483  BLUE       6      NA1  \n",
       "176727   1865489  1865490  1865493   RED       6      NA1  \n",
       "176728   1865499  1865500  1865503  BLUE       6      NA1  \n",
       "176729   1865508  1865511  1865514   RED       6      NA1  \n",
       "176730   1865516  1865521  1865522   RED       6      NA1  \n",
       "176731   1865526  1865530  1865531  BLUE       6      NA1  \n",
       "176732   1865539  1865541  1865543  BLUE       6      NA1  \n",
       "176733   1865548  1865550  1865551   RED       6      NA1  \n",
       "176734   1865559  1865560  1865562  BLUE       6      NA1  \n",
       "176735   1865569  1865571  1865573  BLUE       6      NA1  \n",
       "176736   1865578  1865580  1865583  BLUE       6      NA1  \n",
       "176737   1865588  1865590  1865593  BLUE       5      NA1  \n",
       "176738   1865599  1865600  1865602  BLUE       5      NA1  \n",
       "\n",
       "[176739 rows x 10 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_matches = new_matches.reset_index(drop=True)\n",
    "new_matches[\"season\"] = MATCHES[\"seasonid\"]\n",
    "new_matches[\"platform\"] = MATCHES[\"platformid\"]\n",
    "new_matches"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_matches[\"Blue_Team\"] = new_matches[\"Blue_Team\"].apply(lambda x: ', '.join(sorted(x.split(', '))))\n",
    "new_matches[\"Red_Team\"] = new_matches[\"Red_Team\"].apply(lambda x: ', '.join(sorted(x.split(', '))))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>matchid</th>\n",
       "      <th>Blue_Team</th>\n",
       "      <th>Red_Team</th>\n",
       "      <th>Blue_1 id</th>\n",
       "      <th>Blue_2 id</th>\n",
       "      <th>Red_1 id</th>\n",
       "      <th>Red_2 id</th>\n",
       "      <th>Win</th>\n",
       "      <th>platform</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>season</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1829</td>\n",
       "      <td>1829</td>\n",
       "      <td>1829</td>\n",
       "      <td>1829</td>\n",
       "      <td>1829</td>\n",
       "      <td>1829</td>\n",
       "      <td>1829</td>\n",
       "      <td>1829</td>\n",
       "      <td>1829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>340</td>\n",
       "      <td>340</td>\n",
       "      <td>340</td>\n",
       "      <td>340</td>\n",
       "      <td>340</td>\n",
       "      <td>340</td>\n",
       "      <td>340</td>\n",
       "      <td>340</td>\n",
       "      <td>340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>3062</td>\n",
       "      <td>3062</td>\n",
       "      <td>3062</td>\n",
       "      <td>3062</td>\n",
       "      <td>3062</td>\n",
       "      <td>3062</td>\n",
       "      <td>3062</td>\n",
       "      <td>3062</td>\n",
       "      <td>3062</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>487</td>\n",
       "      <td>487</td>\n",
       "      <td>487</td>\n",
       "      <td>487</td>\n",
       "      <td>487</td>\n",
       "      <td>487</td>\n",
       "      <td>487</td>\n",
       "      <td>487</td>\n",
       "      <td>487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3899</td>\n",
       "      <td>3899</td>\n",
       "      <td>3899</td>\n",
       "      <td>3899</td>\n",
       "      <td>3899</td>\n",
       "      <td>3899</td>\n",
       "      <td>3899</td>\n",
       "      <td>3899</td>\n",
       "      <td>3899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>167122</td>\n",
       "      <td>167122</td>\n",
       "      <td>167122</td>\n",
       "      <td>167122</td>\n",
       "      <td>167122</td>\n",
       "      <td>167122</td>\n",
       "      <td>167122</td>\n",
       "      <td>167122</td>\n",
       "      <td>167122</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        matchid  Blue_Team  Red_Team  Blue_1 id  Blue_2 id  Red_1 id  \\\n",
       "season                                                                 \n",
       "3          1829       1829      1829       1829       1829      1829   \n",
       "4           340        340       340        340        340       340   \n",
       "5          3062       3062      3062       3062       3062      3062   \n",
       "6           487        487       487        487        487       487   \n",
       "7          3899       3899      3899       3899       3899      3899   \n",
       "8        167122     167122    167122     167122     167122    167122   \n",
       "\n",
       "        Red_2 id     Win  platform  \n",
       "season                              \n",
       "3           1829    1829      1829  \n",
       "4            340     340       340  \n",
       "5           3062    3062      3062  \n",
       "6            487     487       487  \n",
       "7           3899    3899      3899  \n",
       "8         167122  167122    167122  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#new_matches[new_matches[\"season\"] == 8].groupby(\"Blue_Team\").count().sort_values(\"matchid\", ascending = False)[:-1][\"matchid\"]\n",
    "new_matches.groupby(\"season\").count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_matches = new_matches[new_matches[\"season\"] == 8]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "blue_pick = new_matches.groupby(\"Blue_Team\").count()[\"matchid\"].sort_values(ascending = False)\n",
    "red_pick = new_matches.groupby(\"Red_Team\").count()[\"matchid\"].sort_values(ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "combo_pick = blue_pick.add(red_pick, fill_value=0).sort_values(ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "red_win = new_matches[new_matches[\"Win\"] == \"RED\"]\n",
    "blue_win = new_matches[new_matches[\"Win\"] == \"BLUE\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "red_win = red_win.groupby(\"Red_Team\").count()[\"matchid\"].sort_values(ascending = False)\n",
    "blue_win = blue_win.groupby(\"Blue_Team\").count()[\"matchid\"].sort_values(ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "combo_winrate = blue_win.add(red_win, fill_value=0).sort_values(ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Aatrox, Ashe        0.500000\n",
       "Aatrox, Caitlyn     0.333333\n",
       "Aatrox, Draven      1.000000\n",
       "Aatrox, Jhin        1.000000\n",
       "Aatrox, Lucian      1.000000\n",
       "Aatrox, Sona        0.000000\n",
       "Aatrox, Tristana    0.000000\n",
       "Aatrox, Xayah       0.000000\n",
       "Ahri, Alistar       1.000000\n",
       "Ahri, Ashe          0.000000\n",
       "Ahri, Bard          0.000000\n",
       "Ahri, Blitzcrank    0.500000\n",
       "Ahri, Brand         0.333333\n",
       "Ahri, Braum         0.500000\n",
       "Ahri, Caitlyn       0.250000\n",
       "Ahri, Camille       1.000000\n",
       "Ahri, Corki         0.000000\n",
       "Ahri, Draven        0.166667\n",
       "Ahri, Ezreal        0.454545\n",
       "Ahri, Galio         0.000000\n",
       "Ahri, Janna         1.000000\n",
       "Ahri, Jhin          0.714286\n",
       "Ahri, Jinx          0.333333\n",
       "Ahri, Kalista       0.500000\n",
       "Ahri, Karma         0.666667\n",
       "Ahri, Katarina      0.000000\n",
       "Ahri, Kennen        1.000000\n",
       "Ahri, LeBlanc       0.000000\n",
       "Ahri, Leona         0.000000\n",
       "Ahri, Lucian        0.409091\n",
       "                      ...   \n",
       "Vladimir, Zilean    0.000000\n",
       "Volibear, Xayah     0.176471\n",
       "Warwick, Xayah      0.666667\n",
       "Warwick, Zilean     0.000000\n",
       "Wukong, Xayah       1.000000\n",
       "Wukong, Yasuo       0.000000\n",
       "Wukong, Zyra        0.000000\n",
       "Xayah, Xerath       0.409091\n",
       "Xayah, Xin Zhao     0.000000\n",
       "Xayah, Yasuo        0.285714\n",
       "Xayah, Yorick       1.000000\n",
       "Xayah, Zac          0.350000\n",
       "Xayah, Zed          0.428571\n",
       "Xayah, Ziggs        0.450000\n",
       "Xayah, Zilean       0.458015\n",
       "Xayah, Zyra         0.489362\n",
       "Xerath, Xin Zhao    0.000000\n",
       "Xerath, Ziggs       0.000000\n",
       "Xin Zhao, Yasuo     1.000000\n",
       "Yasuo, Yorick       1.000000\n",
       "Yasuo, Zac          0.000000\n",
       "Yasuo, Zed          1.000000\n",
       "Yasuo, Ziggs        0.000000\n",
       "Yasuo, Zilean       0.750000\n",
       "Yasuo, Zyra         0.714286\n",
       "Yorick, Ziggs       0.000000\n",
       "Zac, Ziggs          0.500000\n",
       "Zed, Zyra           1.000000\n",
       "Ziggs, Zilean       0.642857\n",
       "Ziggs, Zyra         0.600000\n",
       "Name: matchid, Length: 3181, dtype: float64"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# combo_winrate\n",
    "# combo_pick\n",
    "combo_winrate.div(combo_pick, fill_value=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "combo_win_df = pd.DataFrame(combo_winrate).reset_index()\n",
    "combo_win_df = combo_win_df.rename(columns = {\"index\": \"combo\", \"matchid\": \"win\"})\n",
    "combo_pick_df = pd.DataFrame(combo_pick).reset_index()\n",
    "combo_pick_df = combo_pick_df.rename(columns = {\"index\": \"combo\", \"matchid\": \"pick\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [],
   "source": [
    "combo_pick_df = combo_pick_df[combo_pick_df['pick'] > 100]\n",
    "combo_pick_df = combo_pick_df.sort_values(by='combo').reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [],
   "source": [
    "combo_win_df = combo_win_df[combo_win_df['combo'].isin(combo_pick_df['combo'])]\n",
    "combo_win_df = combo_win_df.sort_values(by='combo').reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "combo = pd.DataFrame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [],
   "source": [
    "combo['combo'] = combo_win_df['combo']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [],
   "source": [
    "combo['win rate'] = combo_win_df['win'].div(combo_pick_df['pick'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [],
   "source": [
    "combo['pick rate'] = combo_pick_df['pick'].div(combo_pick_df['pick'].sum()) * 100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [],
   "source": [
    "combo['pick'] = combo_pick_df['pick']\n",
    "combo['win'] = combo_win_df['win']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Scatter Plot Using Seaborn\n",
    "plt.rc('font', size = 16)\n",
    "sns.set_style('white')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAVMAAAFTCAYAAACES+90AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAIABJREFUeJzs3X18VOWd8P/POfOQZGaSEBICmoABCqQFTWMrEHxobCiibm13X7qru9zeoF3s/StwdwVBiQhb+zLSpaloMYQq7q7d7a2yVn2plS5EhF152K0trq5pKRBNcCEJhDAPmczDuX5/nJlDhjyQwGQSwve9Lxc955qZc4bmm+tc1/f6XppSSiGEEOKi6EN9AUIIMRJIMBVCiCSQYCqEEEkgwVQIIZLgsg+mkUiEpqYmIpHIUF+KEOISdtkH0+PHj1NRUcHx48eH+lKEEJewyz6YCiFEMkgwFUKIJJBgKoQQSSDBVAghkkCCqRBCJIEEUyGESAIJpkIIkQQSTIUQIgkkmAohRBLYh/oChLjc7Kpvpnb3ERrbAozPcfHATZMoL84f6ssSF0l6pkKk0K76Zh5742OavUFGZTho9gZ57I2P2VXfPNSXJi6SBFMhUqh29xEcNg2X046mmX86bBq1u48M9aWJiyTBVIgUamwLkOGwJRzLcNhoagsM0RWJZJFgKkQKjc9x0RGOJhzrCEcpzHEN0RWJZJFgKkQKPXDTJMJRRSAUQSnzz3BU8cBNk4b60sRFkmAqRAqVF+fzgzumk5+ZTntHmPzMdH5wx3SZzR8BUpoatX//fu69995ez9fV1XHllVeyefNmXnrpJdra2rj22mt59NFHmTx5stUuFAqxYcMG3nrrLQKBADfeeCOVlZWMHTvWatPe3k5VVRXvvvsuhmEwb948HnnkETwez6DeoxDnU16cL8FzBEppMJ0+fTovvfRSwrHOzk6WLVvG9OnTueKKK9i0aRNbtmxhxYoVFBQUUFNTw8KFC3n77bfJzMwEYO3atdTV1bFq1SpcLhfV1dUsXryYV199FZvNHNxfunQpTU1NrFu3jmAwyI9+9CNaW1upra1N5S0LcVEkJ/USoobYD3/4QzVr1ix18uRJ5fV61Ze//GVVW1trnT99+rQqLS1VW7duVUop9emnn6ri4mL11ltvWW2OHj2qpk2bprZv366UUmrv3r1q6tSp6ne/+53V5v3331dTp05VH330UcLnNzY2qqlTp6rGxsbBvE0hBuzdT06oG9fXqa9veFfdvnG3+vqGd9WN6+vUu5+cGOpLEz0Y0jHTP/7xj/zTP/0T3//+9xk9ejQHDx4kEAhQUVFhtcnOzmbmzJns2bMHgH379gFQXl5utSkqKmLKlClWm71795Kbm0tJSYnVZtasWXg8HquNEMOd5KReWoY0mP7kJz+hqKiIP//zPwegoaEBgPHjxye0KywstM4dPXqUvLw8XC5Xn20mTJiQcF7XdQoKCqw2Qgx3kpN6aRmyYNrY2EhdXR2LFi1C183L8Pl8OJ1OnE5nQlu3243P5wPA7/fjdru7vd9A2wgx3ElO6qVlyILpK6+8QlZWFt/61resY0opNE3rsX38eG9tuh7vq008cAsx3ElO6qVlyCLLjh07mDt3bkIvNDMzk1AoRDgcTmjr9/utmXyPx4Pf7+/2foFAoF9tJDVKXCokJ/XSMiQl+D7//HMOHz7MqlWrEo5fddVVKKVoampi4sSJ1vGu/11UVERrayvBYJD09PSENl/5ylesNh988EHCexuGwbFjx/jmN785WLclRNJJTuqlY0h6ph9++CEA11xzTcLx0tJS0tLS2LFjh3Wsvb2dAwcOUFZWBkBZWRnRaJS6ujqrTUNDA4cOHUpo09LSYn0OmAsGfD6f1UYIIZJpSHqmhw4dIicnh5ycnITjbrebBQsWsHHjRnRdp6ioiM2bN+PxeLjrrrsAmDBhAvPnz2fNmjX4fD6ysrKorq5m2rRpzJ07F4DZs2dTUlLCkiVLWLlyJZFIhPXr11NeXs6MGTNSfr9CiJFvSILpyZMnycrK6vHcgw8+iK7rbN26lUAgQGlpKU8++aQ1HgpQVVVFVVUVGzZswDAM5syZQ2VlpbX6SdM0ampqePzxx1mzZg1Op5OKigpWr16dkvsTQlx+NKWUGuqLGEpNTU1UVFSwc+dOCgsLh/pyhBCXKMkTEkKIJJBgKoQQSSDBVAghkkCCqRBCJIEEUyGESAIJpkIIkQQSTIUQIgkkmAohRBJIMBVCiCSQYCqEEEkgwVQIIZJAgqkQQiSBBFMhhEgCCaZCCJEEEkyFECIJJJgKIUQSSDAVQogkkGAqhBBJIMFUCCGSQIKpEEIkgQRTIYRIAgmmQgiRBBJMhRAiCYYkmO7du5e77rqLa665hptvvpmnn36aaDQKgFKKmpoaysvLKSkpYdGiRRw+fDjh9aFQiCeeeILrr7+e0tJSli1bxokTJxLatLe38/DDDzNr1iyuu+46Kisr8fl8KbtHIcTlJeXB9De/+Q1//dd/zeTJk6mtreWv/uqv+NnPfkZNTQ0AmzZtoqamhvvuu4/q6mq8Xi8LFy7E6/Va77F27Vpef/11li9fTlVVFfX19SxevNgKyABLly7lwIEDrFu3jtWrV1NXV8fy5ctTfbtCiMuFSrF77rlHLV68OOHY3/3d36kFCxYor9ervvzlL6va2lrr3OnTp1VpaanaunWrUkqpTz/9VBUXF6u33nrLanP06FE1bdo0tX37dqWUUnv37lVTp05Vv/vd76w277//vpo6dar66KOPEj67sbFRTZ06VTU2Nib9XsXI8e4nJ9TdtXvV9U/uVHfX7lXvfnJiqC9JDDMp7ZmeOnWKDz74gD//8z9POL5ixQpefPFFDh48SCAQoKKiwjqXnZ3NzJkz2bNnDwD79u0DoLy83GpTVFTElClTrDZ79+4lNzeXkpISq82sWbPweDxWGyH6a1d9M4+98THN3iCjMhw0e4M89sbH7KpvHupLE8NISoPp73//e5RSuFwuvvvd73L11VdTVlbGM888g2EYNDQ0ADB+/PiE1xUWFlrnjh49Sl5eHi6Xq882EyZMSDiv6zoFBQVWGyH6q3b3ERw2DZfTjqaZfzpsGrW7jwz1pYlhxJ7KD2trawNg5cqV/Mmf/AkLFy7kP/7jP6ipqSEtLQ2lFE6nE6fTmfA6t9ttTR75/X7cbne393a73Rw/fvy8bWQSSgxUY1uAURmOhGMZDhtNbYEhuiIxHKU0mIbDYQBuuOEGVq1aBcDs2bNpa2ujpqaGxYsXo2laj6+NH1dK9dim63GlFLrevdPd23Eh+jI+x0WzN4jLefbHpSMcpTDH1cerxOUmpZEl3lu88cYbE47PmTOHQCBAVlYWoVDICrpxfr+fzMxMADweD36/v9t7BwKBfrXxeDxJuRdx+XjgpkmEo4pAKIJS5p/hqOKBmyYN9aWJYSSlwTQ+jnlusIxEIgDY7XaUUjQ1NSWcb2pqYuLEiYA52dTa2kowGOyzTWNjY8J5wzA4duyY1UaI/iovzucHd0wnPzOd9o4w+Znp/OCO6ZQX5w/1pYlhJKXB9Atf+AJjx47lnXfeSTj+3nvvkZ+fz+23305aWho7duywzrW3t3PgwAHKysoAKCsrIxqNUldXZ7VpaGjg0KFDCW1aWlr48MMPrTb79+/H5/NZbYQYiPLifH6xeDZ7Vn2dXyyeLYFUdJPSMVNd13nwwQdZtWoVa9euZf78+bz//vv88pe/ZN26dXg8HhYsWMDGjRvRdZ2ioiI2b96Mx+PhrrvuAsze7fz581mzZg0+n4+srCyqq6uZNm0ac+fOBcxx2JKSEpYsWcLKlSuJRCKsX7+e8vJyZsyYkcpbFkJcJjSllEr1h7755pvU1tbS0NDAFVdcwf33389f/MVfAOYj/1NPPcUvf/lLAoEApaWlVFZWMnnyZOv1gUCAqqoqtm/fjmEYzJkzh8rKSsaOHWu1OXnyJI8//jjvvfceTqeTiooKVq9e3W3MtKmpiYqKCnbu3ElhYWFqvgAhxIgzJMF0OJFgKoRIBskTEkKIJJBgKoQQSSDBVAghkkCCqRBCJIEEUyGESAIJpkIIkQQSTIUQIgkkmAohRBJIMBVCiCSQYCqEEEkgwVQIIZJAgqkQQiSBBFMhhEgCCaZCCJEEEkyFECIJJJgKIUQSSDAVQogkkGAqhBBJIMFUCCGSQIKpEEIkgQRTIYRIAgmmQgiRBBJMhRAiCSSYCiFEEqQ8mLa1tTFt2rRu/yxbtgwApRQ1NTWUl5dTUlLCokWLOHz4cMJ7hEIhnnjiCa6//npKS0tZtmwZJ06cSGjT3t7Oww8/zKxZs7juuuuorKzE5/Ol7D6FEJcXe6o/sL6+HoDnn38ej8djHR81ahQAmzZtYsuWLaxYsYKCggJqampYuHAhb7/9NpmZmQCsXbuWuro6Vq1ahcvlorq6msWLF/Pqq69is9kAWLp0KU1NTaxbt45gMMiPfvQjWltbqa2tTfEdCyEuCyrFXnjhBTVnzpwez3m9XvXlL39Z1dbWWsdOnz6tSktL1datW5VSSn366aequLhYvfXWW1abo0ePqmnTpqnt27crpZTau3evmjp1qvrd735ntXn//ffV1KlT1UcffZTwmY2NjWrq1KmqsbExafcohLj8pPwx//e//z3Tpk3r8dzBgwcJBAJUVFRYx7Kzs5k5cyZ79uwBYN++fQCUl5dbbYqKipgyZYrVZu/eveTm5lJSUmK1mTVrFh6Px2ojhBDJNCTBtKOjg7vvvpurr76am266iZ/97GcopWhoaABg/PjxCa8pLCy0zh09epS8vDxcLlefbSZMmJBwXtd1CgoKrDZCCJFMKR0zNQyDw4cPk5GRwapVq7jiiit47733qK6uprOzE4fDgdPpxOl0JrzO7XZbk0d+vx+3293tvd1uN8ePHz9vG5mEEkIMhpQGU6UUmzdv5sorr+Sqq64CYPbs2QQCAZ577jm++93vomlaj6+NH1dK9dim63GlFLrevdPd23EhhLhYKY0sNpuNsrIyK5DG3XjjjXR0dJCRkUEoFCIcDiec9/v91ky+x+PB7/d3e+9AINCvNl0zCIQQIllSGkxPnDjBSy+9xKlTpxKOd3Z2AuZkk1KKpqamhPNNTU1MnDgRMCebWltbCQaDfbZpbGxMOG8YBseOHbPaCCFEMqU0mIZCIR577DHeeOONhOPbt2+nqKiIb3zjG6SlpbFjxw7rXHt7OwcOHKCsrAyAsrIyotEodXV1VpuGhgYOHTqU0KalpYUPP/zQarN//358Pp/VRgghkimlY6bjx4/nT/7kT9i4cSOapjF58mTeeecdfv3rX7Np0ybcbjcLFixg48aN6LpOUVERmzdvxuPxcNdddwEwYcIE5s+fz5o1a/D5fGRlZVFdXc20adOYO3cuYI7DlpSUsGTJElauXEkkEmH9+vWUl5czY8aMVN6yEOIyoSmlVCo/MBgM8uyzz/Lmm2/S0tLC5MmT+d73vsc3vvENACKRCE899RS//OUvCQQClJaWUllZyeTJk633CAQCVFVVsX37dgzDYM6cOVRWVjJ27FirzcmTJ3n88cd57733cDqdVFRUsHr16m5jpk1NTVRUVLBz504KCwtT8yUIIUaclAfT4UaCqRAiGSRPSAghkkCCqRBCJIEEUyGESAIJpkIIkQQSTIUQIgkkmAohRBJIMBVCiCSQYCqEEEkgwVQIIZJAgqkQQiSBBFMhhEgCCaZCCJEEEkyFECIJJJgKIUQSSDAVQogkkGAqhBBJIMFUCCGSQIKpEEIkgQRTIYRIAgmmQgiRBBJMhRAiCSSYCiFEEtiH+gKEuFzsqm+mdvcRGtsCjM9x8cBNkygvzh/qyxJJIj1TIVJgV30zj73xMc3eIKMyHDR7gzz2xsfsqm8e6ksTSTJkwTQUCnHrrbfy8MMPW8eUUtTU1FBeXk5JSQmLFi3i8OHD3V73xBNPcP3111NaWsqyZcs4ceJEQpv29nYefvhhZs2axXXXXUdlZSU+ny8l9yVET2p3H8Fh03A57Wia+afDplG7+8hQX5pIkiELpj/96U85ciTxf0ibNm2ipqaG++67j+rqarxeLwsXLsTr9Vpt1q5dy+uvv87y5cupqqqivr6exYsXE41GrTZLly7lwIEDrFu3jtWrV1NXV8fy5ctTdm9CnKuxLUCGw5ZwLMNho6ktMERXJJJtSMZM//u//5sXX3yRnJwc65jP5+P5559nyZIl3HvvvQB89atf5eabb2bbtm0sWrSIzz77jNdee40f//jH3HbbbQAUFxczf/58du7cybx589i3bx/79+/n5ZdfpqSkBIBx48axcOFCPv74Y6ZPn576GxaXvfE5Lpq9QVzOsz9yHeEohTmuIbwqkUwp75lGIhFWr17N/fffz9ixY63jBw8eJBAIUFFRYR3Lzs5m5syZ7NmzB4B9+/YBUF5ebrUpKipiypQpVpu9e/eSm5trBVKAWbNm4fF4rDZCpNoDN00iHFUEQhGUMv8MRxUP3DRpqC9NJEnKg+nPfvYzwuEwixcvTjje0NAAwPjx4xOOFxYWWueOHj1KXl4eLperzzYTJkxIOK/rOgUFBVYbIVKtvDifH9wxnfzMdNo7wuRnpvODO6bLbP4IkrTH/DNnzpCVldVnm8OHD7N582b+/u//HqfTmXDO5/PhdDq7HXe73dbkkd/vx+12d3tft9vN8ePHz9tGJqHEUCovzpfgOYL1u2f67LPP9nrutdde49Zbb+3z9YZhUFlZyZ133klpaWm380opNE3r8bXx47216Xq8rza6LplgQojB0e+e6aZNmwgEAqxYscI61tDQwLp169i3bx9lZWV9vv7FF1/k888/p7a2lkgkYh1XShGJRMjMzCQUChEOh3E4HNZ5v99PZmYmAB6PB7/f3+29A4FAQpuWlpYe23g8nv7erhAjgiwUSJ1+d9U2btzIiy++yN/+7d/S2dnJ008/zR133MGnn37KU089xQsvvNDn63fs2MGJEyeYOXMm06dPZ/r06dTX1/Paa68xffp07HY7SimampoSXtfU1MTEiRMBc7KptbWVYDDYZ5vGxsaE84ZhcOzYMauNEJcDWSiQWv0OpnPnzuW5557jzTff5IYbbuC5555j4cKFvP3228yfP/+8r//bv/1btm3blvBPUVGRlfp0++23k5aWxo4dO6zXtLe3c+DAAavXW1ZWRjQapa6uzmrT0NDAoUOHEtq0tLTw4YcfWm3279+Pz+c7b+9ZiJFEFgqk1oAmoK677jp+/vOf853vfIcZM2awdOnShEfyvkya1D0FJD09nVGjRnH11VcDsGDBAjZu3Iiu6xQVFbF582Y8Hg933XUXABMmTGD+/PmsWbMGn89HVlYW1dXVTJs2jblz5wIwe/ZsSkpKWLJkCStXriQSibB+/XrKy8uZMWPGQG5XiEtaY1uAURmJP5+yUGDw9BlMv/nNb/Z4XCnFvn37mDdvnjUOqWkab7zxxkVdzIMPPoiu62zdupVAIEBpaSlPPvmkNR4KUFVVRVVVFRs2bMAwDObMmUNlZSU2m826jpqaGh5//HHWrFmD0+mkoqKC1atXX9S1CXGpkYUCqaUppVRvJx9++OFeZ9h7UlVVlZSLSqWmpiYqKirYuXMnhYWFQ305QiRNfMzUYdPIcNjoCEcJR5Xktw6SPnumTz75ZLdjXVOPgsEghmF0S6IXQgy98uJ8foA5dtrUFqBQZvMHVb/HTOPVmj7++GNeeeUVAD744AO++93vsmDBApYvX249agshhgdZKJA6/Z7N/8lPfsKbb77Jt7/9bevY9OnTefjhh/mXf/kXNm/ePCgXKIQQl4J+B9O3336bRx55hL/6q7+yjmVnZ/OXf/mXLF++nH/5l38ZlAsUQohLQb8f88+cOUNeXl6P56644gpOnjyZtIsSYqSTlUkjT797ptOnT+ell16ip8n/l19+mS9+8YtJvTAhRipZmTQy9btnunTpUu6//35uvfVWvva1r5Gbm8upU6fYvXs3n332GVu3bh3M6xRixOi6MgnA5bQTCEWo3X1EeqeXsH4H01mzZvHP//zP1NbW8uabb9Le3o7H46G0tJSqqqqEYsxCiN7JyqSRaUDLSa+55ho2bdo0WNcixGVBViaNTH0G01//+tfMnj2brKwsfv3rX5/3zebNm5e0CxNipHrgpkk89sbHBEKRhJVJsoXJpa3PYLps2TJefvllrrnmGpYtW9bnG2maxieffJLUixNiJJKVSSNTn8F0586djBkzxvp3IUT/9ZX+JCuTRp4+g2lBQUGP/37ixAna29sZPXp0r7mnQlzOuhYZ6Zr+9APoFkT7CrqSj3rpGNAE1CuvvEJtbS3Hjh2zjk2aNInvf//7fOMb30j6xQlxqepv+lNfQRfod0AWQ6/fwfSf/umfePzxx7nllltYtmwZo0eP5uTJk+zYsYP/+3//L0899ZRMQAkR09/0p76CLiD5qJeQfgfTrVu3smjRIlatWpVw/Fvf+hY//OEPeeaZZySYChHT3/SnvoKuAslHvYT0eznpyZMnuf7663s8d/PNN3fbxE6Iy9kDN00iHFUEQhGUMv/sKf1pfI6LjnA04Vg86PZ1Tgw//Q6mc+bM4fXXX+/xXF1dHdddd13SLkqIS115cT4/uGM6+ZnptHeEyc9M77HCfV9Bt78BOW5XfTP3bNnHDevruGfLPlnrn2L9fsz/2te+xo9//GPuvvtubr/9dvLy8jh9+jS7du1iz549fOc737G2e9Y0jYULFw7WNQtxSThf+lN8pj4QiuDvjBCJKnRdY1Ke23p9f/NRB5I9IAZHn3tAdVVcXNz/N72EEvhlDygxFLoGv0jU4NjpIAAFo9Kx2/QB79V0z5Z93cZoA6EI+Znp/GLx7EG5B5Go3z3T+vr6wbwOIS4rXWfxj7T4sGkaaNDqCzFpjGfAs/ZSPGXoDSjPVIhLwaWQ6N41+IWihhVMQ1EDGHgglOIpQ6/fE1BCXApSWXj5YiZ8us7UO206SoFS5r/DwAPhQCerRPJJMBUjStfHZ00z/3TYNCsJPlkuNmh3DX55HidRpYgaijyP84ICYX+zB8TgSfljfigUYtOmTbzxxhu0tbVxzTXXsGrVKqZPnw6AUorNmzfz0ksv0dbWxrXXXsujjz7K5MmTE95jw4YNvPXWWwQCAW688UYqKysZO3as1aa9vZ2qqireffddDMNg3rx5PPLII3g8nlTfskihVI0dXmy1/HNn6r8wxo2mafg6zUmj/gxN9DScIZNNQyflPdOqqipefPFF/vqv/5qf/vSnZGRkcO+991rr/Tdt2kRNTQ333Xcf1dXVeL1eFi5ciNfrtd5j7dq1vP766yxfvpyqqirq6+tZvHgx0ejZBOelS5dy4MAB1q1bx+rVq6mrq2P58uWpvl2RYqlKdG9sC5DhsCUcG2jQLi/O5xeLZ7Nn1dd5+NYvMsrlpF+pNZiB9KFtB/ntZ20cb+/gt5+18dC2g5JbOoRSGky9Xi+vvPIKS5cu5S//8i+54YYb2LhxI5FIhNdffx2fz8fzzz/PkiVLuPfee6moqOD555/H7/ezbds2AD777DNee+011q5dy5/92Z8xf/58tmzZwu9//3urTOC+ffvYv38/P/nJT7j11lv50z/9U6qrq9m1axcff/xxKm9ZpFiqxg6TGbQvZMhg/Tv1tAXCKMBu01FAWyDM+nck62aopDSYZmRk8PLLL/Nnf/Zn1jG73RzbCoVCHDx4kEAgQEVFhXU+OzubmTNnsmfPHsAMlADl5eVWm6KiIqZMmWK12bt3L7m5uQn7Us2aNQuPx2O1ESNTqsYOkxm0L2Sc90irH10DXdPQ0NA1DV0zj4uhkdIxU7vdzpe+9CUADMPg2LFjPPPMM2iaxh133MHevXsBGD9+fMLrCgsLqaurA+Do0aPk5eXhcrm6tWloaLDaTJgwIeG8rusUFBRYbcTIlYrCy8msli85oiPDkOWZPvvsszzzzDOAuT3KpEmT+Nd//VecTidOpzOhrdvtxufzAeD3+3G73d3ez+12c/z48fO2ib+PEBcrWUH7QnJEJ+a6+GOLH81QaJqZVmUo+EKe5JUOlSELpnPnzmXmzJns37+fZ599lnA4THp6Opqm9dg+flwp1WObrseVUuh69xGM3o4LMZQuZIO9h2/9Iiu2HcTXGSFqKGy6xqg0Bw/f+sUUXrnoasiCaXyt/8yZM/H7/Tz//POsWLGCUChEOBzG4Tj72OP3+8nMzATA4/Hg93cfFwoEAgltWlpaemwjqVFiuLmQIYPy4nw23FmSlGGGS2HF2KUgpcG0paWF3bt3c8sttyQEtS9+8YuEQiGys7NRStHU1MTEiROt813/u6ioiNbWVoLBIOnp6QltvvKVr1htPvjgg4TPjo/RfvOb3xzMWxTignQdMogHt0df/6jP4JaMYQapNpU8KX3mPXPmDKtXr2b79u0Jx//93/+d3Nxc5s6dS1paGjt27LDOtbe3c+DAAcrKygAoKysjGo1aE1IADQ0NHDp0KKFNS0sLH374odVm//79+Hw+q40Qw1Eql8NC6laMXQ5S2jOdPHkyt9xyC+vXryccDjN+/Hh+/etf8/rrr/PEE0/g8XhYsGABGzduRNd1ioqK2Lx5Mx6Ph7vuuguACRMmMH/+fNasWYPP5yMrK4vq6mqmTZvG3LlzAZg9ezYlJSUsWbKElStXEolEWL9+PeXl5cyYMSOVtyzEgFzsyqqBkkyC5En5mOn69ev56U9/ypYtW2hubuYLX/gCGzduZP78+QA8+OCD6LrO1q1bCQQClJaW8uSTT1rjoWCuoqqqqmLDhg0YhsGcOXOorKzEZjNXpGiaRk1NDY8//jhr1qzB6XRSUVHB6tWrU327QgxIqoObVJtKnn4Xhx6ppDi0GE5SXeS565hp10wCKZIycJInJMQwkupSelJtKnmkZyo9U5EkyUoxir9PU1sAt9OGpml4OyOStjTMSc9UiCRI5ix8vJrU49+aQSBsEIoaKZnZFxdHgqkQSTAYKUaStnRpkWAqRBIko75pKt5TDB4JpkIkwWAUpU5VoWuRHBJMhUjfXMTLAAAgAElEQVSCwZiFl03yLi2y1bO4LCW7uEcy65sO5nuKwSOpUZIaddmRRHUxGKRnKi5ZF9q7TPX6d3F5kDFTcUm6mLxOmSUXg0F6puKSdDG9y5FY3EMKPA896ZmKS9LF9C5H2ix5qmugip5JMBWXpIvJwRxpxT1kpdTwII/54pJ0IZvQdZWK7aBTRQo8Dw/SMxWXpJHWu7wYslJqeJCeqbhkjaTe5cW42F66SA4JpkJcAvqarZeVUsODBFMhhrFd9c2sf6eePzT7cNg0xmam9bgds/TSh56MmQoxTMVTno62+rFpoAz4vD1IJKpktn4YkmAqxDAVT3mKKoVSirBhEI4qGtsCRKKGzNYPM/KYL0SKDHSVUjzlSQc6jbPHDQXHTgf5whj3oHyuuDDSMxUiBS5klVI85UnTNAC0+D/mf1rHk/254sKkPJhGo1FeeOEFbr31Vr785S9z22238fOf/5x4JUClFDU1NZSXl1NSUsKiRYs4fPhwwnuEQiGeeOIJrr/+ekpLS1m2bBknTpxIaNPe3s7DDz/MrFmzuO6666isrMTn86XsPoXo6kJWKcWXvUYMhSP2k6qANJtOwah0fJ2RQflccWFSHkyfffZZqqurueOOO6ipqeHWW2/liSee4LnnngNg06ZN1NTUcN9991FdXY3X62XhwoV4vV7rPdauXcvrr7/O8uXLqaqqor6+nsWLFxONnk1cXrp0KQcOHGDdunWsXr2auro6li9fnurbFQK4sFoC8YUJLqcNA3A5bRTlupgyNhO7Te9XUr5UyEqdlI6ZGobBCy+8wP3338//+T//B4CysjJOnTrF1q1bueeee3j++edZsmQJ9957LwBf/epXufnmm9m2bRuLFi3is88+47XXXuPHP/4xt912GwDFxcXMnz+fnTt3Mm/ePPbt28f+/ft5+eWXKSkpAWDcuHEsXLiQjz/+mOnTp6fytoW44EpV5cX5PH13aUIx61ZfkFP+MKcDIe7Zsq/PMdCRWCFruEppz9Tr9fLtb3+befPmJRyfOHEip06dYt++fQQCASoqKqxz2dnZzJw5kz179gCwb98+AMrLy602RUVFTJkyxWqzd+9ecnNzrUAKMGvWLDwej9VGiFS6mEpVXZfOHj9jBtIcl4MrsjPOOwY60ipkDWcpDabZ2dk89thjfOlLX0o4/u677zJu3Dhr3HP8+PEJ5wsLC2loaADg6NGj5OXl4XK5+mwzYcKEhPO6rlNQUGC1ESKVLraWQHlxPr9YPJsp+ZkU5mQwJjO9X2OgUsMgdYY8NeqVV17h/fff59FHH8Xn8+F0OnE6nQlt3G63NXnk9/txu7unhLjdbo4fP37eNjIJJYbKQFYp9ZbO1NgWwKbBkRYfoaiB06aT53Ged+y16+fuqm/mni37JFUqyYY0NeqNN95g7dq13HLLLSxYsAClVK/pHvHjvbXperyvNrou2WBieOsrnSkzzc6x00EihsKma0QMxbHTQTxp/esXSarU4BmyyPL3f//3rFy5kvLycjZs2ICmaWRmZhIKhQiHwwlt/X4/mZmZAHg8Hvx+f7f3CwQC/Wrj8XgG4W6ESJ6e0pnC0SjL/t9vOdTsJWIoooYy86Riewv3d5NhSZUaPEMSTKurq6mqquJb3/oWTz/9tPVYf9VVV6GUoqmpKaF9U1MTEydOBMzJptbWVoLBYJ9tGhsbE84bhsGxY8esNkIMV+emM3mDYVq9IQIhM4HfpkHUUISiBmHDwDAUR08GZDPBIZbyYPoP//AP1NbWcu+99/Lkk09it599PCktLSUtLY0dO3ZYx9rb2zlw4ABlZWWAmUoVjUapq6uz2jQ0NHDo0KGENi0tLXz44YdWm/379+Pz+aw2QgxX5xZ7bvF2EjbM5P1wVBGNd0oVOGw6dpuGptGvx3UpJD14UjoB1dzczIYNG5g6dSq33347Bw8eTDg/Y8YMFixYwMaNG9F1naKiIjZv3ozH4+Guu+4CYMKECcyfP581a9bg8/nIysqiurqaadOmMXfuXABmz55NSUkJS5YsYeXKlUQiEdavX095eTkzZsxI5S0LMWDnFnv2h6I9tlOx/6eAsZnp2GOP631NJkkh6cGjqf4OtiTBq6++yiOPPNLr+b1795KVlcVTTz3FL3/5SwKBAKWlpVRWVjJ58mSrXSAQoKqqiu3bt2MYBnPmzKGyspKxY8dabU6ePMnjjz/Oe++9h9PppKKigtWrV3cbM21qaqKiooKdO3dSWFiY/JsW4gLEZ/Ob2gI0tnUAZ9fkxwMogNtpI8+TRlaGA6UU7R1h9qz6er/fWwpJJ09Kg+lwJMFUDLXzVXWa9MhbGMoscoJGQjC9uiDbahcIRcjPTOcXi2en8vJFjOQJCTGE+pOq5EmzY9NjPVNl/qlr5p+ysmn4kGAqxBDqT6rSd26YCGjYdA2n3fxT0zS+XXJF0lY2xRP5b1hfxz1b9kne6QUY8hVQQlzOzrfn/a76ZvYeOUWGQ6MjbOaXetLsfOeGiSybO/WCPvPcYYWySaP5x32f4uuMEDUUrb5OVmw7yIY7S2QsdQAkmIoRbbhXme+rqlN8CMBh0yjK9Vgz7xfbA42/Z3xY4em6QygFdl3HpmkoA04Hwjz5q0+G1Xc13MljvhixLoWlk31VdRqM1Uo9vWfEMLdC0WPDB7quoWtw9KQk8g+EBFMxYl0KSyf7quo0GKuVenrP2LyWuEjymC9GrPONR8LAhgEGa8igt2pS5yvsfCHXk5lm54/NPqJK4bTpjMlMw2HTCEUVhlJomrmyylAwpZ8b9gmT9EzFiHW+pZMDGQZIxpDBQGfM40MArb4gh5u9/Pf/tNPU1kHZpNEXdD276ptp8XUSMRQaEI4aNLV1kG7Xyc6wowGRqIEG5LgcrJpf3O97ExJMxQh2virzAxkGuNghg/4Gv64Bt3b3Eb4yIZtT/jChqCLdbiPH5WDbB8dY/079gK+ndvcRsjMcFIzKwGHTUYDdpnHlqAw2/kUppRNyuCI7g9IJOfydzOQPmDzmixGrvDifH0CvSyf7MwwQ11fb/jxudw3G3mCYFm8nwYhZVu/pu0spL85nV30zD207iDcYIWIYtHo7iSpFrtvJmMx0670CoQhHWv1Myff0eD29id+D5tTIit1LfAnqQApXi55JMBUjWl9BwuO08ccWH1FDxSrWp2G3aT1WUOo6fnmmI0yrr5POiIHTrrNi20GyMxwJPc4fxD4bzN7mB5+1ETUM7LpuFXa26xqBUNRqv/6detoCYfOcTUcpCEcVbYFwQjCNRA1CUYNPjp8h3W5jTGYamemO81Z/ks31Bpc85ovL0tM7/sDhVj/BsEE4quiMRDl2uoP2jnCPSzLjQwYt3iCft3cQio0tRqIGpwNhIlHV4+N2/PHeXAKq0Rk1iBgKpQClkWbXrfZHWv3osXYaGnqssklnxLCu40xHmGOng9hj7UJRg2NtHbT6gtYQRm9js7K53uCSYCouO7vqm9m06zAAzlgt0Ihhrncf40nrsScbT2EKhKIYsZnwgpwMosos1PzZqQBHWnyc6QgnPG7HH+/HZqZbNUjBnPwxUOR50vp8PLfHfkLjAfCE1yyKXpDjYlSGg6ihCBuKZm+IO68tAOh1bFY21xtc8pgvLju1u48QNRT2WJK6TQdDKWwa+Dojvb6uvDifrAwHE0a70DSN5jNBc/uQmM5wlM/bO8iNOJmYZ45ndh2njP93/CVXZmeQleEgEIpQmOPC7bTxxxY/mnE2RQk0CrOd5Gem09QWQCkoGJWOUnC6I4xD10EzC0dv++AYb//X/1hjswAup51AKGLVOZWx0cEjwVRcdhrbAqTZ9dijuXlM06Azapx3/DA+7hg1FM3ezoRzEQW6YY5xPhl7dB6f46LhpI8zHRFCUQNHbBM8h00HFIdOeAlFDT4/3YHDpqNpYCiDeGGTUWkOfvin11gB8J4t+2j2BjneHkTHXK1kKEiPDRccPRkY8MSUSA55zBeXnfE5LjLT7RgoDEOhlIr1VPXzjh/Gxx2Ptwd7XTWUmW63gl/ZpNE0e0OEoga6BgZmQrwn3U7T6SBG7Lk/Yig6QlEy0+zouk52up3S8Tndio3EP78zYoBmJtorBWMy06yVTbItydCQnqkYcc6XqhTfuiPX7cQbjNAZMbDpGt8rn3zeR+B4utUDP/+NVazZrsVn383H7Sn5mVb7vUdOMcZjfk58n/tct51AKEpRrovj7UE0VKyHaQbJwpyMXos8xz9/2f/7Lf5QhHS7bs3mB0IRJuW58Yei3bYlKZs0mnu27Bu2BV9GAgmmYkSIB9BDzV68wQg5Lgdpdp3fNrZx/z/+J1PzPayaX2yNGfaVf3o+5cX5XDshh4aTPk76wub4JoqoMlOeuvZuG9sC5HnSElKblFJ8ctzLBIeNUNTAFhtr0DQIRY3z5q+WF+fz9N2lVvWnDIfNmplfc7u5amn9O/UcavYBMMbj5Gd7jhCObREtJfYGh2xbItuWXPK6lpX7n9MdhA2Focyg5dB1FApd08jPSt7sdfwzw9Eo7YEwnVEzh/R75ZO5pnCUFQTPdIRxOW3dku5bvJ2MyUzjeHuQSPRsz9Sua4zLTsdp0/GHolawbPV10hYIk5luZ0p+ZsIqrnN/IXT9PjIcNv5wwksoqrBrWPmrUaX4whg37/zN1857n8O5hOFwImOm4oINl+rsXVcXhWMJ8UYsl1PXzUmaqFJJrRgVTzMaleEkGqsFOjHXHJfsmprkTrPR4gvR4g0m5HZ+54aJhKPKGruNGAaGocjKsBOOmuO4Z1dMRTjpD2EoRaAzYqU7fdh0Guhe8encpa/hqNnCgAGV2LsUShgOJxJMxQUZTj9oXcvKOWM9L8XZIKOUeXwwZrX9oSiFORlMyfcQNhSbdh0mHI1agSzPk05+ppNAKGrldt55bQF7j5wiEIoQCEVJt5s9yGyXg6JcDz+4Yzq+UNS6p+PtHUSiinBU0RE2Yv8eZdOuwz1+/12/jzMdYet7MJS5yKC/LoUShsOJjJmKC9L1Bw265zOmUtdlkmMy0/j8tJnYrmHmj5qVkHTqj3txOW1WwL/Yx9eevoOooWgPhMnzmI/13mA4NgygmH5lNmWTRrPtg2M4bBrjstJ7rZ4/frd5T5GoojOa2Pf8vL0DTSkMev7+499HJKr4vL0j4bVhQ6GIAtp5S+wNpHaBkJ6puECDUbj4QnVdJulJs5PrceCwmZM6hmGAZo4RaoA7zcZD2w6yYtvBi+5V9/QdpNl1OmO9P28wzOeng4QNRbpdp9kb7NZz7drb21XfzK1P7Wbao7/iQMMpDrf4+fTU2e9TAxw2HR2NkGF+Vlfx7z/+fZzwBmOv0azXg9lD7U+JvfOVMBSJJJiKCzKcftDOXSZZlOvhZ//rq7yw8DoyYj23+PLPPE863mAEX2fkoh9fe/oOMtPt2HWdQChC85kgKvaQnedJS+i5dpXhsHGo2ctD2w5yqNlH1DASVlbFmeO/WO+ZmZ74YBn//uPfh1nk2Vz6OjYzDZfThl03A3J/SuzJWv6BGdLH/J07d7JixQp++9vfWseUUmzevJmXXnqJtrY2rr32Wh599FEmT55stQmFQmzYsIG33nqLQCDAjTfeSGVlJWPHjrXatLe3U1VVxbvvvothGMybN49HHnkEjydxdYi4MPFczXPzGYfqB623ZZJdl3/GRQwj4b+h5151f/NVu34HTruN75VPYO+RUzScDJBuN6tRxUvepdl1gpGoVYbPKpgSy0DQYnuIdN1KRANzUk0pogbYNI3xOelomtbr9x9P3+paJSofM5MgPzO9X0MaF5tCdrkZsmD6wQcf8NBDD3U7vmnTJrZs2cKKFSsoKCigpqaGhQsX8vbbb5OZaSZDr127lrq6OlatWoXL5aK6uprFixfz6quvYrOZj11Lly6lqamJdevWEQwG+dGPfkRrayu1tbUpvc+R6lL5Qeup7Jxd188+88ac26vuaRfPc0vr9fUdLOPs0s+un52ZbifkNyvc65rZeQh3mROKJyp2vTyFWUxF12DCaJc1xkovnx1XNmk0m3YdJmIYpNl0sl0OHDbbgH7hyVr+/kt5MA2FQvzDP/wDGzduxOVyEQ6ffeTx+Xw8//zzLFmyhHvvvReAr371q9x8881s27aNRYsW8dlnn/Haa6/x4x//mNtuuw2A4uJi5s+fz86dO5k3bx779u1j//79vPzyy5SUlAAwbtw4Fi5cyMcff8z06dNTfdsj0qXwg9ZT7zEz3Y7C7KVFogYnznQSNsx18/HqSv2dYOvrO+j62ZGowQlvJ+GoWVDFTPQ3q1X1pKfk72gsK2HN7cUJAb0nu+qb2fbBMXJcDmuV1yl/mO+VTxj2f2eXqpSPme7evZstW7awcuVKFixYkHDu4MGDBAIBKioqrGPZ2dnMnDmTPXv2ALBv3z4AysvLrTZFRUVMmTLFarN3715yc3OtQAowa9YsPB6P1UZcHnoqO/d3d5aw4c4SnDadptNB0KBwVAZhQ/WYXhTX21BAb7m28c926BpNpztAQeGodKLKHPU8d6a8N3Zdw2HTuSI7jVEuZ7+CYfyXwZjMdCaN8fDFK7IY7Xbw3L8dHXBe8HDJJx7uUt4zvfrqq9m5cydZWVk888wzCecaGhoAGD9+fMLxwsJC6urqADh69Ch5eXm4XK5ubeKvP3r0KBMmTEg4r+s6BQUFVhtx+eit97j+nXocuhZbYhmydursml7UV1X6/g4F1O4+QpGhrPdK94UIhKK0+ELnvXa7bhaQHpOZhifN3u9tUs5Na/IGw7R6QyjMoYKerrWrnpbn5nnSzvu6y1nKe6Zjx44lKyurx3M+nw+n04nT6Uw47na78fnMdcZ+vx+3u3t+3EDbiJGvrx7Vrvpm/tDsM+uYxsrifX46SCRqJKQX9TWTvf6deprPBPnsVIA/Nvs41tbBsdMBlv2/3yZ81rm9XE+a/bz71GuYgfSLV2QxaYzH2pbE7bT1a7HEuZkGLd5O0MwJsPNlMHRdkBHojGAoxUl/CG8wIon7fRhWqVFKqW6zrHHx47216Xq8rza6PqxuWQyS863Qij8Gx/9P18yK+yfOdCakF/VWlb5rMNaAYMQgGDGIGuANRlix7aD1WecGtr4KUMe5nDo2XbOCeVObnyOtfupP+GhqC+DtCPcZFM/9ZRCMmJ+f50kDzJVRx9uDHGg41e0XTU/Lc3U0Wn1m/VZJ3O/ZsIosmZmZhEKhhEkpMHua8Zl8j8eD3+/v9tpAINCvNpIadXk431LIxrYAYzPTEmqamjPrRkJ60S8Wz2bPqq/zi8WzEx5ruwbjULR7P/N0IMyTv/oE6DmwaXRLKEgQMeB75ZPJz0zn05N+2gIR64fVUNDsC3Eitrqpp+B27i8Dt9NOrttJVoaDMx1hax+rNJvW7RdNT8tz4xWtQBL3ezOsgulVV11l/hZuako43tTUxMSJEwFzsqm1tZVgMNhnm8bGxoTzhmFw7Ngxq40Y2fqaQNpV32xtTKcDBmYd0XDUTHDv7/vHg/G5HDY9oZBIT4EtO6PvR/1w1GDvkVM8cNMkNE3DYdNw2m3o2tkg3OwLUX/8DH9s9uFJ6z790fWXwdN3l+K0m6X64j1MDbOS1rm/aLr2pMdkpllVppw2XRL3+zCsgmlpaSlpaWns2LHDOtbe3s6BAwcoKysDoKysjGg0ak1IgTlxdejQoYQ2LS0tfPjhh1ab/fv34/P5rDZiZOtthVZ8zNGdZrOS5cOx7UvsusYol6NfS0s9ThsnvJ30sFCpR+cGNsd5gnZ8+eljb3yMNxhBj0VQu64nBOH4PbT4OtlV39zrOHHXgB6MmGlgV45KJzPdnKSKRA0++KyNG9bXcToQor0jnLA8V9c0Mhx6j8MdMtNvGlaFTtxuNwsWLGDjxo3ouk5RURGbN2/G4/Fw1113ATBhwgTmz5/PmjVr8Pl8ZGVlUV1dzbRp05g7dy4As2fPpqSkhCVLlrBy5UoikQjr16+nvLycGTNmDOUtihTpbYWW02bulZSdkY5hwInYPk6Ggjy3gzxP+nkLtuyqb+akP0Q4YtDDE36s4DNMHdvzkFJ5cT65bienA6GEhP04u272GKOGii1Jhc6Iwmkzxy+1aPfVUacDYf6/f/4Al9NGdoajx+yC+D/xxQRRQ3GkxUdHOIqhzJ1aR2WYE10a4NA1a3lu1Z92zxjoTzbD5WRYBVOABx98EF3X2bp1K4FAgNLSUp588klrPBSgqqqKqqoqNmzYgGEYzJkzh8rKSmv1k6Zp1NTU8Pjjj7NmzRqcTicVFRWsXr16qG5LpFh8ddKTv/rEqjg/Kc9Ni6+TcVnpeINh2s5ZI9/WESbDaScz3c5Hx9q4Zt12/CGzN1tRPIbjZ0JWwef4zqbWkqVzGApunTGu1zSmFl8nTruNaDhqlQyMU8Dx9iDhqLmdiq6Z7xeKGji6tM1OsxGIGOgKbDoEQlFCEQO3047m1HpdaPDATZN4aNtB2gLh2Cqss9fs64xYvdUcdxrv/E3i1ild7yde+Do7w6yQNZSVw4YDqbQvlfaHrf5Wee+t3bkV5zvCUZraOhjtdnCmIxJ7xDcwFOgaOHQdu80cnzzdEcFhMwNZxDDXxI/KsFOY46L+uDe2w6hGJGoupO/6U6Rhvt9otxMFZGc4EnrHd15bwKZdh2PbS2soBWHDsIYMHLpGuMv4QbpdJyvdTqs/hKHMnmhWuo1QRCVU6Q9FDBw2M8F/0hizV6yUor0jzJ5VX0/4zub/5D0aTgWIGuZ72GNFtO26xqQxnh5fd+73+cnxM+iaZm1Z3dfnXQ6G1ZipEHH9LT7dV7ueZvRzXA5O+cOxVCFzOxMwgx+aORHVHoxg083xSV3TrUB5JhhB0zSr9F00tr895wRSp10n3WHrtTrVc/92lNFuBxrmDgBdA6mukRBIwZyMcqXZ+dIVWYzPyeD5e79KZrqTjnCUUNQw/4wY2GOl9kJdCkD3NvPuC0X5whgPxeOycDltVmpYXzP2536f6XbzSTA+odXX510OJJiKYam/Vd77atfTjH6eJ43MNBtup51orCZovsdJmt1GxFC4nObElA50RqIEY+OJgPVnnictVnjarOCUEPpivdQxmWlEeiill+Gw4Q9FyXWnkeNyEImqhEmsnia0NE3js1MBPjl+hvYOc2jizmsLug0PGLEN82y6dt6SeV0n6PI8ZlZC1FA4YrmtPb2up8UH4ajCH4pyuNlLqy94Wc/0SzAVw1J/18b31a6nGf1WXyehqMJpN5PiM9Pt5GelMy47nYJRLp6+u5R0u42w0X04NJ6SlJXhIDvDbhUrSbPr1rk0m27Nktt18zPOdIQ50uIz05hafDhtGh3hKL7OCLb4NP057PrZgs7x8nxRAzpCER7adpBXftPUvbJULLhqwCfHvbR4O7nz2oIeh0a65r6CufAgHFWEYwG1p40Hu36fzWeCNHvP9kjjhVR6+7zLgQRTMSz1t/h0X+3OTZZv8QZp8YVwp9kYl5XOaLeDtkCY4+0dCSk/o92x8T8Se37xknmBUISsDCd/UzGF64pGk5+ZxrSxHsZ4nBTkZOBJMydiMtPtoBSfngrgD5njpeGIgdOu094RpiMcJdJLblUk3sPscsyhmzUm2gJhmto6zPHd2ARVfBGAocwx2nS7TiBk7hP19I4/dHv/c4uw6JpGvseJTdM41OLjyV990m1IJf59tvqCnPB2Wtdm18Gm64x2O9h75FQvf6Mjn23dunXrhvoihtKZM2f4x3/8R/73//7fvdYMEMmzq76ZR179L57a8Qf+9b9PkOd2UpTXvY5CntvJzvpma/vj+OTNQ/OmJbTvrd0tXxrLa7/7nBNngniDETpCEYIRI1awI90aEshw2pgw2s0vFs+23nfrvzeQZtcIhs2UfF2DrDQbBuYEzRXZGTw0bxp/MXMCd36lkPtumMiCsiKm5mdSH+sRXpGdwe1XX8G+o6e6Pbq7nDZcTjtngn0vK52Qk0F7h9kmHigNdXanUZuuYbfp2HUdu023AnNnxECpswWl//PTNq6+Mrvb91yU5+at/zqOw6bjTrObhVdigbk9GOFAQxsTc93W64ry3EzMdfPGwc/pjBjoWryilQ1DKc50RPi8Pci+wye7/b329+/9UiY9U5EyA9nR9Hxr4/tqd+e1BWz74BhHW310hKIEQlG8nWbvNdedlvD6noYOxue4yMpwMv3KbMZmpqGA9s4onRFzsqfN38mjr3/UY8m9rstP9x45ZY2Zdl0+eipgrosfl5V4LV3Fg2dcvJdsKKzcVkNhLYU1DGU94uuYM/OapsWKuBi9FiaJD5O0eDvRNNA1s05B1Oh5a+zy4nyyMhy4nbZY9oNuZQQoEhcbxL+b4bST7WAadnmmYuQa6I6m/S0+fW67e7bsIxSJctIfQhkKA4hEzJn6z093UNBlqCA+JPD0jj/w3L8dxR+KkmbTsetm78/Xee6Ya4hT/hDjczL6TFLfVd/MB5+1JfZK49FUQUQpct1p/E97Jz3JdTvYs+rrfGnNOwRiSfScfTlpNo3MDAe+zog16WRXWFufRKIGUaWstK9DJ870mEIWLzUYiuW0QnyMVvHZqQBNbR1Wwey48TkuIlGDk/4QGGa2QTyQx/e66vr3Opx2sh1M0jMVKZPsHU17W8rY2BbAG4ygDEVEJfbwTgXC/P74GT75n3YOnfBypiPMuCwnT+08xJmgGZgC4ShnOqPdAmmcocyg2luGQbwn1rVwmcKc0FKx/Z00BX844e313gIhM0XJlWbDFuvWdh3D7YwqMhw28lzmUk+l4IrsDGy6RihqEDbOZglomvnYvmLbQY62+mjzh/iPhlM88PPfMC7LGav+r2HE8m4jhkLnbG/63F7kAzdNwmm3ket2YrdpXQKp08o37fr3Opx2sh1MEkxFyiRrR9P4lsj3/+N/8tvGNmwaCY+O4zlGY0wAABmVSURBVHNcdEYM4tmWmpb4mB0xYiUaYwHq7Y9OmD06Etv1xR+KcqTFZ9U/7SreE8vsofhInKbTY7WpuPh20XluZyzVqXubxrYOmto7cTl1puR7cNp1Muxn82J1zdzm2aaZ2QZnOsKc9IesJH1DKd7+6AR3XlvAxDw30diYrE0Dm80Mp+Oy07v9wogPrUzM8zDa7SQr3SzcEghFqT9+hiMtPlp9ndbf63DayXYwSTAVF+RCClwkY+vgeK/vaKsfmwbKgM/bg0SiZ8f4HrhpUmzyJfaicwKRTdcoHpfFlPxMsjMcdMY3YhpINMUMysdOB62KTU/v+APXrNvO3iMnOdLi77WSvrlBXt/vbSjFDVU7ONTi6zPoApwOnF0cMCYrHbuu4XKYaVnOWKqWocyCLj2Np+49copfff8mnr/3qzhsulX0JZ7i1VuJv/j48HdumIi301xAoMcS/1t8IcomjQYuny2jJZiKAbvQCYX+Tir1Jd7riyoV20f+bOHi+A99eXE+3yufbD1maxrW46hdJ6HM3rmPnwMRn1xSSvH0jj+wse6PVpGQi12jrRQ0tXf2GnTPHUJoieV8RqIGEaXojBo4beZ2J/Gc126vU2ADq1pU7e4jTMx1cVWu26ruD+fvRe49cor8TCdOmx4rmKKTn+m00qSS8fd+KZAJKDFgFzOhcLE7msb3NjJXKBnmHvMahKLwx2YfCnMC6oGbJvE3FVOsrY4dumbNkMerzYMZKJy6RshQ3R6l9djsdl+5oBpQf8JH/YlD6IDdYUNDJSzpHAxdrzXeG4zXaLVrgGaOnR5r6yAv09yRNRIIEVUKTZnJ+fH3cGrK+qV4piNMMBwl3GU1lSfNzprbv9TrtTS2Bch1p5HnSe9yfSqhN3sp7GR7saRnKgZsKCcUxue4aPV1mqt91Nl0IQWEIgbjss5u+nZN4ShqF3yFmUW55HrSmDzGwyiXw+yldnncXPL1L5CVZrNqhsbzSr9fMYVRGX33NxKWc4JV6amfIwVJYSizOMoJr1kwvSDHxZXZGWaVfKC9I0Ku20mGw0Y4qghFlTURFn99fJjApmsEY7+kVOwLPt+9XC5joucjwVQM2GD/8PQ1HvvATZNoC4TRNLP+ZtcfdIddJyvDmTDLXl6czwM3TaIwx4W3M8IYT5pVpzP+uLls7lSevudaZk3MZXxOBrMm5vL0PdeybO7U845XnitiKDoj0YTH6cFiDfFq4EqzoxQUjEpHqfiyWTOwd4TMnuZVuW4c+tkaqAA2zayi/+nJAEdafLQFwhhKMWVsJl+8IpspYzPJynD0uYHe5TImej4STMWADeYPz/nGY8uL88lMt+OILbV0Oc/2kDsjBh9/3s6J9o6ELUoe2naQ33x6iqa2Dj457uX3J3ycDiRODnWdUHngpknU7j7CjLW/Ou8qpZ4YqueCJcmka2d7xZlpdv7z0W9w7YQcOiMGTac7rOWrnREzB/RMbAM+YlugpNt1nHbdXAAQ69mbvwgM7F1+E3iDYf7ndEePG+/FXS5joucj9UylnukFsfZVP3HGKhwyJT+z15qj/RWvAt91v/pAKEJ+ZroV5D74rA0NGJedTqAzQnMPs+Y2Dew2HZummZWfevis0S4H/lAUT5qNqWOzrF8Gj73xMWc6QpzuGHggPVcyJqN64oj1yuM95+KxHm67+gqeefePhHvpTcerSWkQm7gz81Xj1+m06WYBapvGtHFZeINhPj8dRGHuUDAuO51wVPU7UPa3Hu1IIcH0Mg6mF/s/9p6KLw/kh60nN6yvY1SGI2GrbqUUx9s7cKU5YgWZDY6dDqKU6rZtSNfgddXoDD491dHrZ5lBBWv3TbuuM8bjJM1h42ir/4J6l/keJ2OzMzjS4iMYGwoZ4EjBgNk0c4gjPzOdY6c7upX9i4s/3kcMhUMHYon6hjKDa7pdx+XUORUIU5Tr/v/bO/fgqOqzj3/27CWX3SQQzE0wAtIQICQGIRCRyMW2VhztUASttrWlmlqdzMvoW3CKjdNIC/qqkQRaX3FA6wilKUPHim87GYQSqkCAomBLmkLCRSAxgZDNJrt79pz3j5M92c2NZNlNNsnvM5PJ5LebPc/vl5PveX6X53m4eLVVz63qTQDtcMlYjBKjoi293je+94bsUbh8zYlbUfhago3V35oyLEVVTPODzFApMBaMeOnOuUS9NYvy3zsScN87r8dea3VTXW+nweGm7ppWtyg2ykJ8tLlbsfNtutTU1vUNnd7rUdo3cIwSbo/C+att1DQ4/KKH+kN0+5nTmEiT5hn3kGIvWEhotntj6b2JULq7qndsNPHVEkKbjRK3jolmakosExNsxEZZ+FqCjcSYSJztNbN8M+nLHoWqOvt17xv9CJuicrFJyzBlNBioaXQMy7h8EGIaVIZSQoe+Jl/uDd9dfe+UUFG1uO5A++67Hnut1cWFq61aaQ6DJhRfXm2juc1Ni8uD2dghGd4oJ1+cfXQJJQN4fJI0+3p2/Z231TY4+MrehsVkbD/rGtqdfQVok7Uk1OcaWnR7ezLbo6iMsVoYY7Xw5mN3kBgb2SWZ9OpvTWHbk3PIGR9PclykLqQAl685+3Tf9JZAxSV7KNh+7IYcjnB0WsQ50yAylBI6eM9r+tL5eJPvMoDNYsTulPWonok3WbFZtKl9tMWk/9OgGvQxCKTv3kJ43rVRk6SFNNY3O/V6S/XNTpyyckOi54tvarsbxXuAPiUuis0VZzqiq0KMooLrOl3wllS51iaTnRjjN9bnrzj0HLDev1e3FV4VhXGjovw+t6fMWzUNdhwubZbhFVSjARpaXCiqSmp8dEAVTff+q47nyo7rSV6+sjt5ruw4/7M0a1D/z4SYBpG+CFS44M0W5LvR43u8yXfNy2iAqst2FLQIIslg4N91dqwRRr3+u1P2aAk3QD+83Ze+d163zZ0YzyenG/l3XTMuj4JB1cTJJBlwuDxa2eNQDEgQkRUtbj7c0JKtqMiqSu7EeB7530/1cS96MKP79Ib4i23nYn/Q/bG43InxHKpp1D1ktf2BZWifTUSajLpn29+H7rqP/slVhxujwaCVjVHgqsPNuo/+qX/GYGx+CTENItcTqHCip7ry3h1tXy/7dL1d/6fwri8aVBWnW+HmuChGRVs4f6UVgwGSYjqmhdfre2fBrqxp4JPTDRgl2g+NawLgreveF0K1ex5O3Egf3R4VW4SkR4ZFGCU8isJzZcdJsEXQ7JT9xKdz5JL3b+ZdhmlocaOocLGpjQ3lVRTckwZoIaYJNgtXHW4tCMDn+kYDJIzqiELrr8NxpsGhRad5S7sYQFVUzjQ4/Gw0Gw1+y2398X4DQYhpELmeQPWVgXiqXm+K5+tlu9rzVYImpk65o9Z7vd3JR/+Vp9/A3uii7vreuV9XWpx+mxSyvmapfTe17zz3Z1d9uAsptItHgB1VgWanglFq37hSoe6a5uvb22QmJdqoabCT/94RvyNjn52/6pfvVTKo2NvTBJolLfLrjT3VABTck8a5Kw5uskUQaTZy/op2wqAnk4PtcAzWcpsQ0yByPYHqCwP5VO0tXtrXy7YYJWSPx2/K5qW5TdaTB/fW9+76VdPQwrhRUXxld3VbMllR1W6nlSMZCW2ZxaCqdJ9ttW94lPYIMoO2iYWqRULZnTINdjcqKm1uhbrmNgq2HcXu8mgJqCVwKwpuj3ZeNdInrFhWFDZXnKHgnjT9/qlvdmKUtFMDiqJFCHhU7aSFLcIUkMMx8SYr/66zY1BV/cGiqPC1BK0MymAttw1rMd2xYwebN2/m0qVLTJkyhdWrV5OdnR3Sa95oQodw2cTy9bJvslk419jaIabt302SgdHRZt223vreXb/MksTlZqeeUKOzx6Wq3qmc1igZOqb+IxEtP6mkxcubDHiCtLmlJzwxSh2772iJUqItJuwubZkloj3zlGQAt8/D1de+lvYNJ+/90yZ7tNypCiio3BwXBahcuuakqdUdkMOx6t50/rvsOM1tMrJHwSRJjI42s+redGDwltuG7dGoXbt2UVhYyAMPPEBJSQkxMTGsWLGCc+fODbZpvRIuWcl9QwQVFdKSbH7Z1yNNEmNHRXGTLaJPtnXXr6TYCL8s796b0eiTVV5BW2MD7WYdiJj3cMVbksTQHk+faLP0+N6ehsm33Vs/ytuWEBOhbfq1P7S8qQr7OjFQVLC2h/d67x+rxYRH0VIges+rmowSM1JH67Wy+uskzE9P5JWlWWSnjiYlLors1NG84rOTP1i5AoalZ6qqKhs2bGDZsmU888wzANx5553ce++9vPPOO6xZs2aQLeyZcNrE6q62Unehnn2xrbt+mYwSaYk2AKrq7JhNEqMjjDQ7PaiyQqTZSLRZIiEmkvNXHLgVFVeA3lioN6a8guSNMAr2tb0JTdT2p4zFKJEUF4XUfsohLsqMLcJEdb29x3BS3wgoY3uOV6esrZ9aI7SMUb7LKt5TGZKhq6BKaMsDsqLorysq/PiuCfp75qcnsuHhbL8ouWAJW2+zoGAstwXCsBTT2tpaLly4wMKFC/U2s9nM/Pnz2b9//yBadn2CtYkVbrb19LsvLE5nfnqivjl1/oqDSYmxXW5+39etFiMtLg91zU48ioKEJgAqXf/xJYOPp+uTgMTg8z4tc1J7OxBpbi+brKooaF6zAbBFSDQ7O4rHxURIuBRthzot0caqe/37cuLCVZqdHn15wvsY6Hw9o6Qdp+oNyQBjrBYaHW4Akm0RWminyci6JZn6WG0or/KLz/e9lrc0szXCSEpsJC0ujy40oIlPU6ub5jaZ0dFmYiK1JSabxYjd5fETToNkIPfWUZy82EyLy4PVYuTHd03Qd/O9DJawDUb+1GEZm793717y8/P5y1/+wvjx4/X2rVu3sn79ek6cOIHRqE1HwjE231c4Burm6ys3Ylso+7X3X3Ws/79/cfqrFgAmjIlm9bemAL1viq376J/6kZqJN1m7CKJXvA0GA3an5oV7z8L2pR++VU+NaCIkKypWi5FF6Qlcuubi/BUHtggT56+00OzsUFXvGmmCzUJMpFaJ1BZhQlVVPyHsLi7edywSrGZioiy6/dcb9+7+Tr67+T0J50hnWIrpn//8Z5599lkqKipISEjQ2//whz+wZs0ajhw5gs2mTS/DUUwFAsHQY1huQHmfD4ZOuxU9tQsEAsGNMizFNCYmBoCWlha/dofDgSRJREeHX0SSQCAY2gxLMb311lsBuhyDOnfuHBMmTBCeqUAgCDrDUkzHjx9PSkoK5eXlepvb7Wbv3r3k5uYOomUCgWC4MiyPRhkMBp544gmKioqIi4tjxowZvPfee1y5coXHH398sM0TCATDkGEppgCPPvooTqeTd999l61btzJlyhTefvttbrnllsE2TSAQDEOG5dGo/iCORgkEgmAwbD3TvuLxaIkZLl26NMiWCASCoUJycjImk798jngxra+vB7RlAYFAIOgL3c1kR/w0v62tjRMnTpCQkKCHmAoEAkFvdOeZjngxFQgEgmAwLM+ZCgQCwUAjxFQgEAiCgBBTQRd27NjBN77xDTIzM1m+fDnHjh3r8++WlJQwefLkEFoX/vR3/PLz85k8eXKXr865JUYC/R27xsZGfvazn5GTk8PMmTP5yU9+MmjVNMSaqcCPXbt28fzzz/P0008zffp0fve733H06FH+9Kc/XTfgoaqqiiVLluB2uzl16tQAWRxeBDJ+8+fP5+tf/zqLFy/2a8/MzESSRo6/09+xc7vdLF26FKfTycqVKzEajbz++uvIsswHH3yAxdJzWZeQoAoE7SiKoi5YsED9xS9+obe5XC514cKFalFRUa+/K8uyunTpUnXevHlqWlpaqE0NSwIZv6amJjUtLU3dt2/fQJkZlgQydjt27FAzMzPVCxcu6G1ffPGFOnfuXPXzzz8Puc2dGTmPPcF1uZFyL1u3bsVut/PYY4+F2sywJZDx83rwI31pJJCxKy8vZ968edx8881625QpU6ioqCAjIyPkNndGiKlAp6amBuhIYejllltu4ezZs3q0WGdqa2spLS2lqKho4KdWYUQg43fq1CksFgvFxcXMnj2brKwsCgoK9GCSkUKgYzdx4kRKS0uZO3cuGRkZPPnkk3z55ZcDYXIXhJgKdOx2OwBWq9Wv3Wq1oigKra2tXX5HVVXWrFnDAw88wMyZMwfEznAlkPE7deoULpcLq9VKaWkphYWF/OMf/+AHP/gBLpdrQOwOBwIZu8bGRnbu3Mn+/ftZu3YtL7/8MtXV1eTn5yPL8oDY7cuIDycVdKAGUO5l+/bt1NbW8pvf/Cb0BoY5gYzf448/zuLFi5kzZw4As2bN4rbbbmPZsmXs3r2bb3/72yG2OjwIZOxkWcbtdvPWW28RGxsLaJ7s0qVL+etf/8p9990XYqv9EZ6pQKe/5V4uXrzIK6+8ws9//nMiIyORZVm/+WVZRlECq3E/VAmkXM5tt92mC6mXrKwsYmNjR9SJiEDGLjo6mszMTF1IAaZPn05sbCxVVVWhNbgbhJgKdPpb7uWTTz6hpaWFgoICpk2bxrRp01i3bh0A06ZNY+PGjQNjeJgQSLmcDz/8kMOHD/u1qaqKy+Vi9OjRoTM2zAhk7FJTU3G73V3aZVkelNJEQkwFOv0t97JgwQLKysr8vn74wx8CUFZWxrJlywbM9nAgkHI527ZtY+3atX5e/L59+2hraxtRa9CBjN1dd93F0aNHuXz5st526NAhHA4H2dnZIbe5M8YXX3zxxQG/qiAsMRgMmM1mNm3ahNvtxuVy8etf/5rTp0+zfv164uLiOHv2LGfOnCE5OZmoqCiSkpL8vqqrq6moqKCoqAibzTbYXRpQ+jt+AAkJCWzZsoWamhpsNhv79+/npZdeYv78+fzoRz8a5B4NHIGM3eTJk/njH/9IeXk5CQkJnDx5ksLCQtLS0li5cuXAe6cDfrJVEPa8/fbb6t13361mZmaqy5cvV48ePaq/tmrVql4P5W/ZsmXEHtr30t/x27Nnj/qd73xHzcrKUufOnauuW7dObW1tHWizw4L+jl1tba361FNPqbfffrs6a9YsddWqVWpTU9NAm62qqqqKcFKBQCAIAmLNVCAQCIKAEFOBQCAIAkJMBQKBIAgIMRUIBIIgIMRUIBAIgoAQU4EghIjDMiMHIaaCYUtJScmgRMJ4KS0t5f333x+06wsGFiGmgmHLQw89xDvvvDNo1y8pKaGtrW3Qri8YWEQKPsGwJTk5WQ89FAhCjfBMBUOGBx98kNWrV+s/NzU1kZ6ezqpVq/S2xsZG0tPT2bdvX5dp/uTJk9m5cycrV64kOzub2bNns3bt2l4TCa9evZqf/vSnPPvss8yYMYOVK1cCcPr0aQoKCpgzZw4ZGRksXLiQjRs36muk3jIkL7/8sl8pjgMHDvDQQw+RmZlJXl4eb7zxRo8VDARDCyGmgiHDvHnzOHjwoP7z4cOHUVWVyspKve3AgQNYLBZmz57d7Wf86le/Ij4+nk2bNvHoo4/y7rvvsmPHjl6vu2/fPpxOJxs3bmT58uW0tLTw/e9/n6tXr7J+/XrefPNNZs+ezYYNG/j4448B+P3vfw/A9773PUpLSwEtZeETTzzBuHHjKC0tZcWKFWzZsoWXXnrphsZFEB6Iab5gyJCXl8dbb73F2bNnSU1N5eDBg0ydOpUvvviCy5cvk5SUxIEDB8jJySEyMrLbz8jOzuaFF14AIDc3l48//pi//e1vfPe73+3xurIs88tf/pL4+HgATpw4QWpqKsXFxXpbbm4u5eXlHD58mIULF3L77bcDkJKSwtSpUwEoLi4mKyuL119/Xe9PXFwczz//PCtWrGDcuHHBGSjBoCA8U8GQITs7G5vNxqeffgpouSsffvhhrFYrR44cATTP9O677+7xM7Kysvx+TkpKwuFw9Hrd+Ph4XTQBMjIyeP/994mJiaG6upry8nJKS0uRZbnHuk2tra189tlnLFiwAFmW9a+8vDwURfHzuAVDE+GZCoYMZrOZ3NxcDh48yDe/+U2qqqrIyckhOzubyspKJk2aRF1dXa9iGhUV5fezJEnXPQs6ZsyYLm2//e1v2bx5M83NzYwdO5bs7GxMJlOPn3Xt2jUUReHVV1/l1Vdf7fL6SKtGOhwRYioYUsybN4+SkhIqKysZM2YMEyZMYNasWezevZvU1FTGjx9PampqSG3YtWsXxcXFFBYWcv/99+v1i3rKCA8dVTefeuopFi1a1OX1xMTE0BgrGDDENF8wpMjLy6O+vp6ysjLuuOMOAGbOnElVVRW7d+8mLy8v5DYcO3aM5ORkHnnkEV1IT548SWNjo59nKkkd/142m4309HTOnTvH9OnT9S+z2cxrr73GpUuXQm63ILQIMRUMKVJSUpg0aRJ79uxh1qxZAGRmZmKxWDh+/HivU/xgMX36dC5evEhpaSmHDh1i27Zt5OfnYzAY/A7px8bGcuTIEY4fPw5AQUEBH374IYWFhVRUVPDBBx/w9NNPc/78edLS0kJutyC0iGm+YMiRl5dHdXW1XnDOYrGQlZXF559/Tk5OTsivv2TJEs6cOcP27dvZvHkzY8eOZcWKFfznP//RN8IAnnnmGYqLi6msrOTvf/87ixYtYtOmTWzcuJGdO3dis9m48847ee6557qs5QqGHqJsiUAgEAQBMc0XCASCICDEVCAQCIKAEFOBQCAIAkJMBQKBIAgIMRUIBIIgIMRUIBAIgoAQU4FAIAgCQkwFAoEgCPw/tnF98iG5we4AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1a9af895f8>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "facet = sns.lmplot(data=combo, x='win rate', y='pick', \n",
    "                   fit_reg=False, legend=True, legend_out=True)"
   ]
  },
  {
   "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}