lol_data_eda.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Library\n",
    "%matplotlib inline\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import seaborn as sns\n",
    "\n",
    "import random\n",
    "from sklearn import *\n",
    "import statsmodels.api as sm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>gameId</th>\n",
       "      <th>gameDuraton</th>\n",
       "      <th>blueWins</th>\n",
       "      <th>blueFirstBlood</th>\n",
       "      <th>blueFirstTower</th>\n",
       "      <th>blueFirstBaron</th>\n",
       "      <th>blueFirstDragon</th>\n",
       "      <th>blueFirstInhibitor</th>\n",
       "      <th>blueDragonKills</th>\n",
       "      <th>blueBaronKills</th>\n",
       "      <th>...</th>\n",
       "      <th>redAssist</th>\n",
       "      <th>redChampionDamageDealt</th>\n",
       "      <th>redTotalGold</th>\n",
       "      <th>redTotalMinionKills</th>\n",
       "      <th>redTotalLevel</th>\n",
       "      <th>redAvgLevel</th>\n",
       "      <th>redJungleMinionKills</th>\n",
       "      <th>redKillingSpree</th>\n",
       "      <th>redTotalHeal</th>\n",
       "      <th>redObjectDamageDealt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4247263043</td>\n",
       "      <td>1323</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>68</td>\n",
       "      <td>73016</td>\n",
       "      <td>49832</td>\n",
       "      <td>533</td>\n",
       "      <td>64</td>\n",
       "      <td>12.8</td>\n",
       "      <td>138</td>\n",
       "      <td>8</td>\n",
       "      <td>38711</td>\n",
       "      <td>60463</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4247155821</td>\n",
       "      <td>1317</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>44218</td>\n",
       "      <td>37136</td>\n",
       "      <td>571</td>\n",
       "      <td>59</td>\n",
       "      <td>11.8</td>\n",
       "      <td>134</td>\n",
       "      <td>3</td>\n",
       "      <td>24829</td>\n",
       "      <td>14105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4243963257</td>\n",
       "      <td>932</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>20</td>\n",
       "      <td>30797</td>\n",
       "      <td>35364</td>\n",
       "      <td>400</td>\n",
       "      <td>50</td>\n",
       "      <td>10.0</td>\n",
       "      <td>89</td>\n",
       "      <td>5</td>\n",
       "      <td>12589</td>\n",
       "      <td>45201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4241678498</td>\n",
       "      <td>2098</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>72</td>\n",
       "      <td>125866</td>\n",
       "      <td>70528</td>\n",
       "      <td>832</td>\n",
       "      <td>84</td>\n",
       "      <td>16.8</td>\n",
       "      <td>205</td>\n",
       "      <td>9</td>\n",
       "      <td>65312</td>\n",
       "      <td>88202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4241538868</td>\n",
       "      <td>2344</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",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>83</td>\n",
       "      <td>131536</td>\n",
       "      <td>74596</td>\n",
       "      <td>794</td>\n",
       "      <td>85</td>\n",
       "      <td>17.0</td>\n",
       "      <td>227</td>\n",
       "      <td>7</td>\n",
       "      <td>86431</td>\n",
       "      <td>64141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26899</th>\n",
       "      <td>4143231833</td>\n",
       "      <td>1468</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>40</td>\n",
       "      <td>75531</td>\n",
       "      <td>46558</td>\n",
       "      <td>478</td>\n",
       "      <td>64</td>\n",
       "      <td>12.8</td>\n",
       "      <td>141</td>\n",
       "      <td>6</td>\n",
       "      <td>48596</td>\n",
       "      <td>42733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26900</th>\n",
       "      <td>4157911901</td>\n",
       "      <td>970</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>31</td>\n",
       "      <td>99837</td>\n",
       "      <td>70177</td>\n",
       "      <td>455</td>\n",
       "      <td>72</td>\n",
       "      <td>14.4</td>\n",
       "      <td>136</td>\n",
       "      <td>11</td>\n",
       "      <td>15817</td>\n",
       "      <td>50217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26901</th>\n",
       "      <td>3764171638</td>\n",
       "      <td>1480</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>34</td>\n",
       "      <td>55214</td>\n",
       "      <td>48849</td>\n",
       "      <td>636</td>\n",
       "      <td>66</td>\n",
       "      <td>13.2</td>\n",
       "      <td>175</td>\n",
       "      <td>6</td>\n",
       "      <td>25448</td>\n",
       "      <td>27675</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26902</th>\n",
       "      <td>4110201724</td>\n",
       "      <td>1837</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>29</td>\n",
       "      <td>88366</td>\n",
       "      <td>52625</td>\n",
       "      <td>660</td>\n",
       "      <td>70</td>\n",
       "      <td>14.0</td>\n",
       "      <td>168</td>\n",
       "      <td>5</td>\n",
       "      <td>25003</td>\n",
       "      <td>45455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26903</th>\n",
       "      <td>4100240254</td>\n",
       "      <td>948</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>16574</td>\n",
       "      <td>20972</td>\n",
       "      <td>351</td>\n",
       "      <td>40</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>7138</td>\n",
       "      <td>6808</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>26904 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           gameId  gameDuraton  blueWins  blueFirstBlood  blueFirstTower  \\\n",
       "0      4247263043         1323         0               1               0   \n",
       "1      4247155821         1317         1               0               0   \n",
       "2      4243963257          932         0               0               0   \n",
       "3      4241678498         2098         0               0               0   \n",
       "4      4241538868         2344         1               1               1   \n",
       "...           ...          ...       ...             ...             ...   \n",
       "26899  4143231833         1468         0               1               0   \n",
       "26900  4157911901          970         0               1               1   \n",
       "26901  3764171638         1480         0               1               1   \n",
       "26902  4110201724         1837         1               1               0   \n",
       "26903  4100240254          948         1               1               1   \n",
       "\n",
       "       blueFirstBaron  blueFirstDragon  blueFirstInhibitor  blueDragonKills  \\\n",
       "0                   0                0                   0                0   \n",
       "1                   0                1                   0                2   \n",
       "2                   0                0                   0                0   \n",
       "3                   1                1                   0                1   \n",
       "4                   1                1                   1                2   \n",
       "...               ...              ...                 ...              ...   \n",
       "26899               0                0                   0                1   \n",
       "26900               0                1                   0                3   \n",
       "26901               0                1                   0                1   \n",
       "26902               0                1                   0                3   \n",
       "26903               0                0                   0                1   \n",
       "\n",
       "       blueBaronKills  ...  redAssist  redChampionDamageDealt  redTotalGold  \\\n",
       "0                   0  ...         68                   73016         49832   \n",
       "1                   0  ...          8                   44218         37136   \n",
       "2                   0  ...         20                   30797         35364   \n",
       "3                   1  ...         72                  125866         70528   \n",
       "4                   2  ...         83                  131536         74596   \n",
       "...               ...  ...        ...                     ...           ...   \n",
       "26899               0  ...         40                   75531         46558   \n",
       "26900               0  ...         31                   99837         70177   \n",
       "26901               0  ...         34                   55214         48849   \n",
       "26902               0  ...         29                   88366         52625   \n",
       "26903               0  ...          3                   16574         20972   \n",
       "\n",
       "       redTotalMinionKills  redTotalLevel  redAvgLevel  redJungleMinionKills  \\\n",
       "0                      533             64         12.8                   138   \n",
       "1                      571             59         11.8                   134   \n",
       "2                      400             50         10.0                    89   \n",
       "3                      832             84         16.8                   205   \n",
       "4                      794             85         17.0                   227   \n",
       "...                    ...            ...          ...                   ...   \n",
       "26899                  478             64         12.8                   141   \n",
       "26900                  455             72         14.4                   136   \n",
       "26901                  636             66         13.2                   175   \n",
       "26902                  660             70         14.0                   168   \n",
       "26903                  351             40          8.0                    56   \n",
       "\n",
       "       redKillingSpree  redTotalHeal  redObjectDamageDealt  \n",
       "0                    8         38711                 60463  \n",
       "1                    3         24829                 14105  \n",
       "2                    5         12589                 45201  \n",
       "3                    9         65312                 88202  \n",
       "4                    7         86431                 64141  \n",
       "...                ...           ...                   ...  \n",
       "26899                6         48596                 42733  \n",
       "26900               11         15817                 50217  \n",
       "26901                6         25448                 27675  \n",
       "26902                5         25003                 45455  \n",
       "26903                0          7138                  6808  \n",
       "\n",
       "[26904 rows x 50 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# import dataframe\n",
    "df = pd.read_csv('data/Challenger_Ranked_Games.csv')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 26904 entries, 0 to 26903\n",
      "Data columns (total 50 columns):\n",
      " #   Column                   Non-Null Count  Dtype  \n",
      "---  ------                   --------------  -----  \n",
      " 0   gameId                   26904 non-null  int64  \n",
      " 1   gameDuraton              26904 non-null  int64  \n",
      " 2   blueWins                 26904 non-null  int64  \n",
      " 3   blueFirstBlood           26904 non-null  int64  \n",
      " 4   blueFirstTower           26904 non-null  int64  \n",
      " 5   blueFirstBaron           26904 non-null  int64  \n",
      " 6   blueFirstDragon          26904 non-null  int64  \n",
      " 7   blueFirstInhibitor       26904 non-null  int64  \n",
      " 8   blueDragonKills          26904 non-null  int64  \n",
      " 9   blueBaronKills           26904 non-null  int64  \n",
      " 10  blueTowerKills           26904 non-null  int64  \n",
      " 11  blueInhibitorKills       26904 non-null  int64  \n",
      " 12  blueWardPlaced           26904 non-null  int64  \n",
      " 13  blueWardkills            26904 non-null  int64  \n",
      " 14  blueKills                26904 non-null  int64  \n",
      " 15  blueDeath                26904 non-null  int64  \n",
      " 16  blueAssist               26904 non-null  int64  \n",
      " 17  blueChampionDamageDealt  26904 non-null  int64  \n",
      " 18  blueTotalGold            26904 non-null  int64  \n",
      " 19  blueTotalMinionKills     26904 non-null  int64  \n",
      " 20  blueTotalLevel           26904 non-null  int64  \n",
      " 21  blueAvgLevel             26904 non-null  float64\n",
      " 22  blueJungleMinionKills    26904 non-null  int64  \n",
      " 23  blueKillingSpree         26904 non-null  int64  \n",
      " 24  blueTotalHeal            26904 non-null  int64  \n",
      " 25  blueObjectDamageDealt    26904 non-null  int64  \n",
      " 26  redWins                  26904 non-null  int64  \n",
      " 27  redFirstBlood            26904 non-null  int64  \n",
      " 28  redFirstTower            26904 non-null  int64  \n",
      " 29  redFirstBaron            26904 non-null  int64  \n",
      " 30  redFirstDragon           26904 non-null  int64  \n",
      " 31  redFirstInhibitor        26904 non-null  int64  \n",
      " 32  redDragonKills           26904 non-null  int64  \n",
      " 33  redBaronKills            26904 non-null  int64  \n",
      " 34  redTowerKills            26904 non-null  int64  \n",
      " 35  redInhibitorKills        26904 non-null  int64  \n",
      " 36  redWardPlaced            26904 non-null  int64  \n",
      " 37  redWardkills             26904 non-null  int64  \n",
      " 38  redKills                 26904 non-null  int64  \n",
      " 39  redDeath                 26904 non-null  int64  \n",
      " 40  redAssist                26904 non-null  int64  \n",
      " 41  redChampionDamageDealt   26904 non-null  int64  \n",
      " 42  redTotalGold             26904 non-null  int64  \n",
      " 43  redTotalMinionKills      26904 non-null  int64  \n",
      " 44  redTotalLevel            26904 non-null  int64  \n",
      " 45  redAvgLevel              26904 non-null  float64\n",
      " 46  redJungleMinionKills     26904 non-null  int64  \n",
      " 47  redKillingSpree          26904 non-null  int64  \n",
      " 48  redTotalHeal             26904 non-null  int64  \n",
      " 49  redObjectDamageDealt     26904 non-null  int64  \n",
      "dtypes: float64(2), int64(48)\n",
      "memory usage: 10.3 MB\n"
     ]
    }
   ],
   "source": [
    "# description\n",
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 표본선택\n",
    "sample_record = []\n",
    "\n",
    "while (len(sample_record) != 200):\n",
    "    rand_num = random.randint(0,26903)\n",
    "    \n",
    "    if (rand_num in sample_record):\n",
    "        continue\n",
    "    else:\n",
    "        sample_record.append(rand_num)\n",
    "\n",
    "sample_df = df.loc[sample_record]\n",
    "sample_df.sort_index(ascending = True, inplace = True)"
   ]
  },
  {
   "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>gameId</th>\n",
       "      <th>gameDuraton</th>\n",
       "      <th>blueWins</th>\n",
       "      <th>blueFirstBlood</th>\n",
       "      <th>blueFirstTower</th>\n",
       "      <th>blueFirstBaron</th>\n",
       "      <th>blueFirstDragon</th>\n",
       "      <th>blueFirstInhibitor</th>\n",
       "      <th>blueDragonKills</th>\n",
       "      <th>blueBaronKills</th>\n",
       "      <th>...</th>\n",
       "      <th>redAssist</th>\n",
       "      <th>redChampionDamageDealt</th>\n",
       "      <th>redTotalGold</th>\n",
       "      <th>redTotalMinionKills</th>\n",
       "      <th>redTotalLevel</th>\n",
       "      <th>redAvgLevel</th>\n",
       "      <th>redJungleMinionKills</th>\n",
       "      <th>redKillingSpree</th>\n",
       "      <th>redTotalHeal</th>\n",
       "      <th>redObjectDamageDealt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>4174637416</td>\n",
       "      <td>1559</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>51</td>\n",
       "      <td>68695</td>\n",
       "      <td>53548</td>\n",
       "      <td>611</td>\n",
       "      <td>71</td>\n",
       "      <td>14.2</td>\n",
       "      <td>141</td>\n",
       "      <td>8</td>\n",
       "      <td>21609</td>\n",
       "      <td>62827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>4215316652</td>\n",
       "      <td>917</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>29260</td>\n",
       "      <td>23280</td>\n",
       "      <td>297</td>\n",
       "      <td>43</td>\n",
       "      <td>8.6</td>\n",
       "      <td>68</td>\n",
       "      <td>2</td>\n",
       "      <td>11173</td>\n",
       "      <td>3404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>547</th>\n",
       "      <td>4218540056</td>\n",
       "      <td>1656</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>50</td>\n",
       "      <td>101886</td>\n",
       "      <td>59335</td>\n",
       "      <td>599</td>\n",
       "      <td>74</td>\n",
       "      <td>14.8</td>\n",
       "      <td>155</td>\n",
       "      <td>6</td>\n",
       "      <td>39562</td>\n",
       "      <td>81523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>553</th>\n",
       "      <td>4214936649</td>\n",
       "      <td>1397</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>19</td>\n",
       "      <td>52542</td>\n",
       "      <td>38367</td>\n",
       "      <td>504</td>\n",
       "      <td>61</td>\n",
       "      <td>12.2</td>\n",
       "      <td>122</td>\n",
       "      <td>0</td>\n",
       "      <td>14542</td>\n",
       "      <td>10756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>969</th>\n",
       "      <td>4231893867</td>\n",
       "      <td>968</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>62</td>\n",
       "      <td>71858</td>\n",
       "      <td>48316</td>\n",
       "      <td>176</td>\n",
       "      <td>71</td>\n",
       "      <td>14.2</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>14096</td>\n",
       "      <td>1534</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25840</th>\n",
       "      <td>4089207099</td>\n",
       "      <td>692</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>51</td>\n",
       "      <td>67280</td>\n",
       "      <td>54405</td>\n",
       "      <td>263</td>\n",
       "      <td>54</td>\n",
       "      <td>10.8</td>\n",
       "      <td>17</td>\n",
       "      <td>11</td>\n",
       "      <td>18559</td>\n",
       "      <td>30593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26127</th>\n",
       "      <td>4182011572</td>\n",
       "      <td>932</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>19623</td>\n",
       "      <td>23857</td>\n",
       "      <td>340</td>\n",
       "      <td>45</td>\n",
       "      <td>9.0</td>\n",
       "      <td>69</td>\n",
       "      <td>2</td>\n",
       "      <td>9284</td>\n",
       "      <td>8169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26372</th>\n",
       "      <td>4058284538</td>\n",
       "      <td>638</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>103</td>\n",
       "      <td>56214</td>\n",
       "      <td>40505</td>\n",
       "      <td>135</td>\n",
       "      <td>62</td>\n",
       "      <td>12.4</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>7166</td>\n",
       "      <td>11740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26540</th>\n",
       "      <td>4115435930</td>\n",
       "      <td>2270</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>69</td>\n",
       "      <td>133124</td>\n",
       "      <td>74937</td>\n",
       "      <td>951</td>\n",
       "      <td>87</td>\n",
       "      <td>17.4</td>\n",
       "      <td>210</td>\n",
       "      <td>8</td>\n",
       "      <td>73891</td>\n",
       "      <td>92282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26598</th>\n",
       "      <td>4150564249</td>\n",
       "      <td>906</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>103</td>\n",
       "      <td>99377</td>\n",
       "      <td>51952</td>\n",
       "      <td>141</td>\n",
       "      <td>76</td>\n",
       "      <td>15.2</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>15470</td>\n",
       "      <td>9043</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           gameId  gameDuraton  blueWins  blueFirstBlood  blueFirstTower  \\\n",
       "327    4174637416         1559         0               1               1   \n",
       "494    4215316652          917         1               1               1   \n",
       "547    4218540056         1656         0               0               0   \n",
       "553    4214936649         1397         1               1               1   \n",
       "969    4231893867          968         1               0               1   \n",
       "...           ...          ...       ...             ...             ...   \n",
       "25840  4089207099          692         0               1               1   \n",
       "26127  4182011572          932         1               0               1   \n",
       "26372  4058284538          638         0               0               0   \n",
       "26540  4115435930         2270         0               0               0   \n",
       "26598  4150564249          906         0               0               0   \n",
       "\n",
       "       blueFirstBaron  blueFirstDragon  blueFirstInhibitor  blueDragonKills  \\\n",
       "327                 0                0                   0                1   \n",
       "494                 0                1                   0                2   \n",
       "547                 0                0                   0                0   \n",
       "553                 0                1                   0                3   \n",
       "969                 0                0                   1                0   \n",
       "...               ...              ...                 ...              ...   \n",
       "25840               0                1                   0                2   \n",
       "26127               0                0                   0                0   \n",
       "26372               0                0                   0                0   \n",
       "26540               1                0                   1                2   \n",
       "26598               0                0                   0                0   \n",
       "\n",
       "       blueBaronKills  ...  redAssist  redChampionDamageDealt  redTotalGold  \\\n",
       "327                 0  ...         51                   68695         53548   \n",
       "494                 0  ...         13                   29260         23280   \n",
       "547                 0  ...         50                  101886         59335   \n",
       "553                 0  ...         19                   52542         38367   \n",
       "969                 0  ...         62                   71858         48316   \n",
       "...               ...  ...        ...                     ...           ...   \n",
       "25840               0  ...         51                   67280         54405   \n",
       "26127               0  ...         11                   19623         23857   \n",
       "26372               0  ...        103                   56214         40505   \n",
       "26540               1  ...         69                  133124         74937   \n",
       "26598               0  ...        103                   99377         51952   \n",
       "\n",
       "       redTotalMinionKills  redTotalLevel  redAvgLevel  redJungleMinionKills  \\\n",
       "327                    611             71         14.2                   141   \n",
       "494                    297             43          8.6                    68   \n",
       "547                    599             74         14.8                   155   \n",
       "553                    504             61         12.2                   122   \n",
       "969                    176             71         14.2                     0   \n",
       "...                    ...            ...          ...                   ...   \n",
       "25840                  263             54         10.8                    17   \n",
       "26127                  340             45          9.0                    69   \n",
       "26372                  135             62         12.4                     0   \n",
       "26540                  951             87         17.4                   210   \n",
       "26598                  141             76         15.2                     0   \n",
       "\n",
       "       redKillingSpree  redTotalHeal  redObjectDamageDealt  \n",
       "327                  8         21609                 62827  \n",
       "494                  2         11173                  3404  \n",
       "547                  6         39562                 81523  \n",
       "553                  0         14542                 10756  \n",
       "969                  6         14096                  1534  \n",
       "...                ...           ...                   ...  \n",
       "25840               11         18559                 30593  \n",
       "26127                2          9284                  8169  \n",
       "26372               12          7166                 11740  \n",
       "26540                8         73891                 92282  \n",
       "26598               13         15470                  9043  \n",
       "\n",
       "[200 rows x 50 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "blue_sample = sample_df.loc[:,'blueWins':'blueObjectDamageDealt']\n",
    "red_sample = sample_df.loc[:,'redWins':'redObjectDamageDealt']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "blueWins                   1.000000\n",
       "blueFirstBlood             0.160464\n",
       "blueFirstTower             0.389860\n",
       "blueFirstBaron             0.206300\n",
       "blueFirstDragon            0.263416\n",
       "blueFirstInhibitor         0.643740\n",
       "blueDragonKills            0.385308\n",
       "blueBaronKills             0.231629\n",
       "blueTowerKills             0.661727\n",
       "blueInhibitorKills         0.594716\n",
       "blueWardPlaced             0.015630\n",
       "blueWardkills              0.006123\n",
       "blueKills                  0.381021\n",
       "blueDeath                 -0.439587\n",
       "blueAssist                 0.310048\n",
       "blueChampionDamageDealt    0.127209\n",
       "blueTotalGold              0.188135\n",
       "blueTotalMinionKills       0.041231\n",
       "blueTotalLevel             0.159951\n",
       "blueAvgLevel               0.159951\n",
       "blueJungleMinionKills      0.178448\n",
       "blueKillingSpree           0.399106\n",
       "blueTotalHeal              0.156261\n",
       "blueObjectDamageDealt      0.475951\n",
       "Name: blueWins, dtype: float64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 승패와 column간 상관관계 확인\n",
    "(blue_sample.select_dtypes(['int64', 'float64']).corr()).loc['blueWins']\n",
    "# (red_sample.select_dtypes(['int64', 'float64']).corr()).loc['redWins']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 승패와 column간 logistic regression\n",
    "regression_blue_df = blue_sample.drop(columns = ['blueFirstBlood', 'blueFirstTower', 'blueFirstDragon', 'blueFirstInhibitor'])\n",
    "regression_red_df = red_sample.drop(columns = ['redFirstBlood', 'redFirstTower', 'redFirstDragon', 'redFirstInhibitor'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'reg_df' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-9-848bb137d829>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mlogit\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0msm\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mLogit\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mregression_blue_df\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'blueWins'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mreg_df\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mreg_df\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtolist\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0;36m2\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m: name 'reg_df' is not defined"
     ]
    }
   ],
   "source": [
    "logit = sm.Logit(regression_blue_df['blueWins'],reg_df[reg_df.columns.tolist()[:-2]]) "
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}