Skip to content

Instantly share code, notes, and snippets.

@dyerrington

dyerrington/sf_review.ipynb

Created September 17, 2018 01:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dyerrington/527e89eecd7c7f1cf81ea5781e5e373d to your computer and use it in GitHub Desktop.
Save dyerrington/527e89eecd7c7f1cf81ea5781e5e373d to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
sf_review.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd, numpy as np\n",
"from sklearn.tree import DecisionTreeClassifier\n",
"from sklearn.ensemble import RandomForestClassifier, AdaBoostClassifier, GradientBoostingClassifier\n",
"from sklearn.model_selection import train_test_split, cross_val_score\n",
"from sklearn.grid_search import GridSearchCV\n",
"from sklearn.pipeline import Pipeline, make_pipeline\n",
"from sklearn.feature_extraction.text import CountVectorizer, TfidfVectorizer\n",
"from sklearn.preprocessing import StandardScaler\n",
"import matplotlib.pyplot as plt\n",
"import seaborn as sns\n",
"\n",
"%matplotlib inline"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Data Set Information:\n",
"\n",
"-- We aggregated screen movements into screen-fixations using a Salvucci & Goldberg (2000) dispersion-threshold algorithm, and defined Perception Action Cycles (PACs) as fixations with at least one action.\n",
"\n",
"-- Time is recorded in terms of timestamps in the StarCraft 2 replay file. When the game is played on 'faster', 1 real-time second is equivalent to roughly 88.5 timestamps.\n",
"\n",
"-- List of possible game actions is discussed in Thompson, Blair, Chen, & Henrey (2013)\n",
"\n",
"\n",
"Attribute Information:\n",
"\n",
"1. GameID: Unique ID number for each game (integer)\n",
"2. LeagueIndex: Bronze, Silver, Gold, Platinum, Diamond, Master, GrandMaster, and Professional leagues coded 1-8 (Ordinal)\n",
"3. Age: Age of each player (integer)\n",
"4. HoursPerWeek: Reported hours spent playing per week (integer)\n",
"5. TotalHours: Reported total hours spent playing (integer)\n",
"6. APM: Action per minute (continuous)\n",
"7. SelectByHotkeys: Number of unit or building selections made using hotkeys per timestamp (continuous)\n",
"8. AssignToHotkeys: Number of units or buildings assigned to hotkeys per timestamp (continuous)\n",
"9. UniqueHotkeys: Number of unique hotkeys used per timestamp (continuous)\n",
"10. MinimapAttacks: Number of attack actions on minimap per timestamp (continuous)\n",
"11. MinimapRightClicks: number of right-clicks on minimap per timestamp (continuous)\n",
"12. NumberOfPACs: Number of PACs per timestamp (continuous)\n",
"13. GapBetweenPACs: Mean duration in milliseconds between PACs (continuous)\n",
"14. ActionLatency: Mean latency from the onset of a PACs to their first action in milliseconds (continuous)\n",
"15. ActionsInPAC: Mean number of actions within each PAC (continuous)\n",
"16. TotalMapExplored: The number of 24x24 game coordinate grids viewed by the player per timestamp (continuous)\n",
"17. WorkersMade: Number of SCVs, drones, and probes trained per timestamp (continuous)\n",
"18. UniqueUnitsMade: Unique unites made per timestamp (continuous)\n",
"19. ComplexUnitsMade: Number of ghosts, infestors, and high templars trained per timestamp (continuous)\n",
"20. ComplexAbilitiesUsed: Abilities requiring specific targeting instructions used per timestamp (continuous)"
]
},
{
"cell_type": "code",
"execution_count": 101,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'pandas.core.frame.DataFrame'>\n",
"RangeIndex: 3395 entries, 0 to 3394\n",
"Data columns (total 20 columns):\n",
"GameID 3395 non-null int64\n",
"LeagueIndex 3395 non-null int64\n",
"Age 3395 non-null object\n",
"HoursPerWeek 3395 non-null object\n",
"TotalHours 3395 non-null object\n",
"APM 3395 non-null float64\n",
"SelectByHotkeys 3395 non-null float64\n",
"AssignToHotkeys 3395 non-null float64\n",
"UniqueHotkeys 3395 non-null int64\n",
"MinimapAttacks 3395 non-null float64\n",
"MinimapRightClicks 3395 non-null float64\n",
"NumberOfPACs 3395 non-null float64\n",
"GapBetweenPACs 3395 non-null float64\n",
"ActionLatency 3395 non-null float64\n",
"ActionsInPAC 3395 non-null float64\n",
"TotalMapExplored 3395 non-null int64\n",
"WorkersMade 3395 non-null float64\n",
"UniqueUnitsMade 3395 non-null int64\n",
"ComplexUnitsMade 3395 non-null float64\n",
"ComplexAbilitiesUsed 3395 non-null float64\n",
"dtypes: float64(12), int64(5), object(3)\n",
"memory usage: 530.5+ KB\n"
]
}
],
"source": [
"df = pd.read_csv(\"./SkillCraft1_Dataset.csv\")\n",
"df.info()"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Age object\n",
"HoursPerWeek object\n",
"TotalHours object\n",
"dtype: object"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.dtypes[df.dtypes == \"object\"]"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"20 357\n",
"21 344\n",
"18 325\n",
"22 314\n",
"19 313\n",
"23 259\n",
"16 256\n",
"17 248\n",
"24 225\n",
"25 168\n",
"26 136\n",
"27 111\n",
"28 73\n",
"? 55\n",
"29 52\n",
"30 32\n",
"31 29\n",
"32 21\n",
"35 17\n",
"34 15\n",
"33 15\n",
"36 8\n",
"37 5\n",
"38 5\n",
"40 4\n",
"41 3\n",
"39 3\n",
"44 1\n",
"43 1\n",
"Name: Age, dtype: int64"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df['Age'].value_counts()"
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"10 411\n",
"8 390\n",
"20 335\n",
"12 331\n",
"6 323\n",
"28 280\n",
"24 233\n",
"16 223\n",
"4 219\n",
"14 181\n",
"2 108\n",
"42 92\n",
"? 56\n",
"30 54\n",
"36 50\n",
"56 33\n",
"18 24\n",
"40 12\n",
"70 9\n",
"48 7\n",
"50 5\n",
"32 5\n",
"84 2\n",
"60 2\n",
"96 2\n",
"90 1\n",
"72 1\n",
"112 1\n",
"168 1\n",
"0 1\n",
"80 1\n",
"98 1\n",
"140 1\n",
"Name: HoursPerWeek, dtype: int64"
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df['HoursPerWeek'].value_counts()"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"500 328\n",
"400 213\n",
"1000 210\n",
"300 202\n",
"600 187\n",
"800 186\n",
"700 170\n",
"200 168\n",
"730 123\n",
"100 116\n",
"450 97\n",
"250 85\n",
"150 73\n",
"900 71\n",
"750 70\n",
"350 66\n",
"1500 58\n",
"? 57\n",
"2000 55\n",
"650 47\n",
"1200 46\n",
"50 45\n",
"1260 28\n",
"120 26\n",
"550 23\n",
"850 22\n",
"1100 22\n",
"80 20\n",
"1400 18\n",
"60 18\n",
" ... \n",
"184 1\n",
"380 1\n",
"1148 1\n",
"848 1\n",
"1196 1\n",
"755 1\n",
"208 1\n",
"45 1\n",
"2600 1\n",
"575 1\n",
"94 1\n",
"10260 1\n",
"727 1\n",
"690 1\n",
"460 1\n",
"425 1\n",
"770 1\n",
"553 1\n",
"2160 1\n",
"3 1\n",
"1940 1\n",
"144 1\n",
"370 1\n",
"525 1\n",
"138 1\n",
"1024 1\n",
"639 1\n",
"77 1\n",
"9000 1\n",
"10000 1\n",
"Name: TotalHours, Length: 238, dtype: int64"
]
},
"execution_count": 16,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df['TotalHours'].value_counts()"
]
},
{
"cell_type": "code",
"execution_count": 35,
"metadata": {},
"outputs": [],
"source": [
"th = df[df['TotalHours'] !='?']['TotalHours'].astype(int)"
]
},
{
"cell_type": "code",
"execution_count": 57,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"(960.42180946674659, 500.0, 0 500\n",
" dtype: int64)"
]
},
"execution_count": 57,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAD4CAYAAADhNOGaAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAFKlJREFUeJzt3X2wXHV9x/F3kotgZi70qisdBXXU+v3D6WiDGkU0qagMRSY+VR0VLUwnY42WtEzFBzCx43QUganPWhBQqx0rESi1SDoiEJESRZzWpy8CKq1VeqEJuRIqJLn945yLm3A399yHs3vv/t6vGWb2/PZ3dr/fCbOf+zsPu8smJyeRJJVr+aALkCQNlkEgSYUzCCSpcAaBJBXOIJCkwhkEklS4kbZeOCJWABcAAewFTgWOAK4EflJP+2RmfikiNgEnAXuAjZm5/WCvPT4+MedrXsfGVrJjx+657r4k2XMZSuu5tH5h/j13OqPLphtvLQiAkwEy8/kRsRY4nyoEzs/M86YmRcQqYA2wGjga2AI8u62iRkZWtPXSi5Y9l6G0nkvrF9rrubVDQ5l5ObC+3nwicBdwDHBSRFwfEZ+JiFHgOGBrZk5m5p3ASER02qpLkrS/ZW3fWRwRnwVeAbwaeDzw75l5c0S8BxgDdgL3ZOYn6/nXA6dl5m29XnPPnr2TJf41IEnz1PdDQwBk5psj4kzgJuDYzPxF/dRlwEeBK4DRrl1GqcKhp3keI2N8fGLO+y9F9lyG0nourV+Yf8+dzui0460dGoqIUyLiXfXmbmAf8JWIeE49djxwM3ADcEJELI+IJwDLM/PutuqSJO2vzRXBV4CL60M9hwAbgf8EPhYRDwC/AtZn5q6I2AbcSBVMG1qsSZJ0gNaCIDPvA14zzVPHTjN3M7C5rVokSb15Q5kkFc4gkKTCGQSSVLjWLx8t2WkfuOahxxe980UDrESSenNFIEmFMwgkqXAGgSQVziCQpMIZBJJUOINAkgpnEEhS4QwCSSqcQSBJhTMIJKlwBoEkFc4gkKTCGQSSVDiDQJIKZxBIUuEMAkkqnEEgSYUzCCSpcAaBJBWutd8sjogVwAVAAHuBU4FlwCXAJPB9YENm7ouITcBJwB5gY2Zub6suSdL+2lwRnAyQmc8H3gucX/93Vma+gCoU1kXEKmANsBp4HfDxFmuSJB2gtSDIzMuB9fXmE4G7gGOA6+qxq4AXA8cBWzNzMjPvBEYiotNWXZKk/bV2aAggM/dExGeBVwCvBl6WmZP10xPAEcDhwD1du02Nj/d63bGxlYyMrJhzXZ3O6Jz3XUrvuZjefxDsefiV1i+003OrQQCQmW+OiDOBm4BHdj01CuwEdtWPDxzvaceO3XOup9MZZXx8Ys77z9Ug3nPKoHoeJHsefqX1C/PvuVeItHZoKCJOiYh31Zu7gX3AdyJibT12IrANuAE4ISKWR8QTgOWZeXdbdUmS9tfmiuArwMURcT1wCLAR+BFwQUQ8on58aWbujYhtwI1UwbShxZokSQdoLQgy8z7gNdM8tWaauZuBzW3VIknqzRvKJKlwBoEkFc4gkKTCGQSSVDiDQJIKZxBIUuEMAkkqnEEgSYUzCCSpcAaBJBXOIJCkwhkEklQ4g0CSCmcQSFLhDAJJKpxBIEmFMwgkqXAGgSQVziCQpMIZBJJUOINAkgpnEEhS4UbaeNGIOAS4CHgScCjwfuC/gCuBn9TTPpmZX4qITcBJwB5gY2Zub6MmSdL0WgkC4I3APZl5SkQ8GrgF+Gvg/Mw8b2pSRKwC1gCrgaOBLcCzW6pJkjSNtoLgy8ClXdt7gGOAiIh1VKuCjcBxwNbMnATujIiRiOhk5nhLdUmSDtDKOYLM/HVmTkTEKFUgnAVsB/4qM18I3AFsAg4H7u3adQI4oo2aJEnTa2tFQEQcDVwGfCIzvxgRv5OZO+unLwM+ClwBjHbtNgrsZAZjYysZGVkx59o6ndGZJy2wQbznYnr/QbDn4Vdav9BOz22dLD4S2Aq8LTO/Xg9fHRFvr08GHw/cDNwAnBMR5wJHAcsz8+6ZXn/Hjt1zrq3TGWV8fGLO+8/VIN5zyqB6HiR7Hn6l9Qvz77lXiLS1Ing3MAacHRFn12N/CfxtRDwA/ApYn5m7ImIbcCPVYaoNLdUjSeqhlSDIzNOB06d56thp5m4GNrdRhyRpZt5QJkmFMwgkqXAGgSQVziCQpMIZBJJUuNZuKCvJaR+45qHHF73zRQOsRJJmzxWBJBXOIJCkwhkEklQ4g0CSCmcQSFLhDAJJKpxBIEmFMwgkqXAGgSQVziCQpMI1+oqJiPgX4GLgisx8oN2StBC6v/biyvPWDbASSYtd0+8a+iDwJuBDEfFV4JLM/HZ7ZS1OfqeQpGHUKAgy8zrguoh4JPBqYEtE7AIuBD6Zmb9psUZJUosanyOIiLXAx4C/Ab4G/DlwJPBPrVQmSeqLpucIfg7cQXWe4G2ZeX89fi3wndaqkyS1rumK4EXAazPzcwAR8VSAzNyXmavaKk6S1L6mQXAS1eEggMcCV0bE+nZKkiT1U9OrhtYDqwEy8+cRcQxwE/B3002OiEOAi4AnAYcC7wd+CFwCTALfBzZk5r6I2EQVNHuAjZm5fa7NDBuvUpLUD02D4BCg+8qgB6g+0Ht5I3BPZp4SEY8GbgG+B5yVmddGxKeAdfW5hzVUIXM0sAV49ix7WHB+AEsqSdMguBy4JiL+kSoAXsXBrxb6MnBp1/Ye4Bjgunr7KuClQAJbM3MSuDMiRiKik5njs+hBkjQPTe8jODMiXk311/uDwEcy8/KDzP81QESMUgXCWcC59Qc+wARwBHA4cE/XrlPjBw2CsbGVjIysaFL6tDqd0XnPXajx+dbRr/2XInsefqX1C+303HRFAPAj4C5gGUBEvDAzr+81OSKOBi4DPpGZX4yIc7qeHgV2ArvqxweOH9SOHbtnUfb+Op1RxscnGs/vNXehxudbR7/2X2pm++88DErrubR+Yf499wqRpvcRfBw4Gbi9a3iS6rLS6eYfCWyluufg6/XwLRGxNjOvBU4EvgHcBpwTEecCRwHLM/PuJjVJkhZG0xXBS4GYupGsgXcDY8DZEXF2PXY68JGIeATV6uLSzNwbEduAG6kuZd3QvHRJ0kJoGgR3UB8SaiIzT6f64D/QmmnmbgY2N33tYeGVSZIWi6ZB8L/ADyPiW8D/TQ1m5mmtVKWHMTgktaVpEHyN395ZPDT8cJWk5pePfjYingQ8HbgaODozf9pmYZKk/mj0XUMR8VrgSuDDwKOAGyPijW0WJknqj6ZfOncmcCwwkZn/A/wB8K7WqpIk9U3TINibmQ/dxZCZvwT2tVOSJKmfmp4s/kFEvA04JCKeCbyV6kvkJElLXNMVwQbg8cD9VF8vvYsqDCRJS1zTq4buozon4HkBSRoyTb9raB8P//2BX2bmUQtfkiSpn5quCB46hFT/+tjLgee1VVTJum9yk6R+aHqO4CGZ+WBmfpke3zwqSVpamh4aelPX5jKqO4wfbKUiSVJfNb189A+7Hk8CdwOvXfhyJEn91vQcwaltFyJJGoymh4Z+ysOvGoLqMNFkZj55QauSJPVN00NDXwR+A1xAdW7gDcCzgfe0VJckqU+aBsEJmfmsru0PR8TNmfnzNoqSJPVP08tHl0XEi6c2IuJlVF8zIUla4pquCNYDn4uI36U6V/Bj4M2tVSVJ6pumVw3dDDw9Ih4D3F9/95AkaQg0/YWyJ0bEvwI3AqMRcU3905WSpCWu6TmCTwMfAn4N3AX8A/C5toqSJPVP0yB4TGZuBcjMycy8ADh8pp0iYnVEXFs/XhURv4iIa+v/XluPb4qI7RHxrYh4zhz7kCTNUdOTxfdHxFHUN5VFxHFU9xX0FBHvAE4Bps4nrALOz8zzuuasAtYAq4GjgS1U9ydIkvqkaRD8BfDPwFMi4nvAo4A/nmGf24FXAp+vt48BIiLWAT8BNgLHAVszcxK4MyJGIqKTmeOz7EOSNEdNg+BIqr/UnwasAH6cmQ8cbIfM3HLACeXtwIWZeXNEvAfYBOwE7umaMwEcARw0CMbGVjIysqJh6Q/X6Yw2GuvH+EzPLcT8ue6z1Nnz8CutX2in56ZBcE5mfhX4wTze67LM3Dn1GPgocAXQ3dUoVTgc1I4du+dcRKczyvj4xMPGpxvrx/hMzy3E/Lnus5T1+nceZqX1XFq/MP+ee4VI0yC4PSIuAm6i+gF7ADJzNlcOXR0Rb8/M7cDxwM3ADcA5EXEucBSwPDPvnsVrSpLm6aBBEBGPz8xfUB2+WQY8t+vpSWZ3CemfAR+LiAeAXwHrM3NXRGyjuj9hObBhNsVLkuZvphXBlcCqzDw1Is7ovuKnicz8GXV4ZOZ3gWOnmbMZ2Dyb15UkLZyZ7iNY1vX4DW0WIkkajJmCoPvHaJb1nCVJWrKa3lkM0/9CmSRpiZvpHMHTI+KO+vHjux77E5WSNCRmCoKn9aUKSdLAHDQI/ClKSRp+TW8oG3qnfeCaQZcgSQMxm5PFkqQhZBBIUuEMAkkqnEEgSYUzCCSpcAaBJBXOIJCkwnkfwQy8v0DSsHNFIEmFMwgkqXAeGlpgHkqStNS4IpCkwhkEklQ4g0CSCmcQSFLhWj1ZHBGrgQ9m5tqIeCpwCdVvH38f2JCZ+yJiE3ASsAfYmJnb26zp5DOuaPPlJWnJaW1FEBHvAC4EDquHzgfOyswXUP3m8bqIWAWsAVYDrwM+3lY9kqTptXlo6HbglV3bxwDX1Y+vAl4MHAdszczJzLwTGImITos1SZIO0FoQZOYW4MGuoWWZOVk/ngCOAA4H7u2aMzUuSeqTft5Qtq/r8SiwE9hVPz5w/KDGxlYyMrJiYaubpU5ndOZJDecv5Gst5D5LnT0Pv9L6hXZ67mcQ3BIRazPzWuBE4BvAbcA5EXEucBSwPDPvnumFduzY3WqhTYyPTyzY/IV8rYXcZynrdEbteciV1i/Mv+deIdLPIDgDuCAiHgH8CLg0M/dGxDbgRqrDVBv6WI8kiZaDIDN/Bjy3fnwr1RVCB87ZDGxusw5JUm/eUCZJhTMIJKlwBoEkFc7fI5gjf3dA0rBwRSBJhTMIJKlwBoEkFc4gkKTCGQSSVDiDQJIKZxBIUuG8j2CJ676f4aJ3vmiAlUhaqlwRSFLhDAJJKpxBIEmFMwgkqXCeLNaC8uS1tPS4IpCkwhkEklQ4Dw0tAv62gaRBckUgSYUzCCSpcAaBJBWu7+cIIuIW4N5686fAp4EPA3uArZn5vn7XpOHQfa7lyvPWDbASaWnpaxBExGEAmbm2a+x7wKuAO4CvRsSqzPxuP+uSpJL1e0XwDGBlRGyt33szcGhm3g4QEVcDxwMGgST1Sb+DYDdwLnAh8HvAVcDOrucngCfP9CJjYysZGVnRSoFt6XRGW3+tg73HTO9/8hlXPPR4oQ6rLGTPS/H9B6G0nkvrF9rpud9BcCtwW2ZOArdGxL3Ao7qeH2X/YJjWjh27WyqvPePjE62/1sHeYzbvv1C1LmTPS/H9+63TGS2q59L6hfn33CtE+h0EpwG/D7w1Ih4HrATui4inUJ0jOAHwZPEi4ncHScOv30HwGeCSiPgmMEkVDPuALwArqK4auqnPNUlS0foaBJn5APD6aZ56bj/rkCT9ljeUSVLhDAJJKpxBIEmFMwgkqXAGgSQVzh+m6RN/fEbSYuWKQJIK54pgCXJ1IWkhuSKQpMK5IiiM3x0k6UCuCCSpcAaBJBXOIJCkwhkEklQ4g0CSCudVQ5qTflx95BVOUn+4IpCkwrkikObJlYuWOlcEklQ4VwTqC/9qlhYvg2CItP1ldMP2ZXeGk1QxCKSGDA4NK4NADzNsf/kPs+5/qyvPWzfASrSULYogiIjlwCeAZwC/Af40M28bbFXD4+Qzrph2fKE+8OfzOgfu61/aOpgS/3/pR9gviiAAXg4clpnPi4jnAucB/nmjh8znsMxiO6Sz2OqRFksQHAd8DSAz/y0injXgetSi+a5EmuzfaxU029ecT+g0eZ2m8/t5IYDhVJ5lk5OTg66BiLgQ2JKZV9XbdwJPzsw9g61MkobfYrmhbBcw2rW93BCQpP5YLEFwA/BHAPU5gv8YbDmSVI7Fco7gMuAlEfEtYBlw6oDrkaRiLIpzBJKkwVksh4YkSQNiEEhS4RbLOYJWDfOdyxGxGvhgZq6NiKcClwCTwPeBDZm5LyI2AScBe4CNmbm919xB9NBURBwCXAQ8CTgUeD/wQ4a75xXABUAAe6nOny1jiHueEhGPBW4GXkLV0yUMcc8RcQtwb735U+DTwIepetuame/r9VlWX2Sz39zZvHcpK4KH7lwG3kl15/KSFxHvAC4EDquHzgfOyswXUH1YrIuIVcAaYDXwOuDjveb2s/Y5eiNwT13zicDHGP6eTwbIzOcD76XqYdh7ngr9TwP310ND3XNEHAaQmWvr/04FPgW8nuqG29V1v70+y6ab21gpQbDfncvAsNy5fDvwyq7tY4Dr6sdXAS+m6n1rZk5m5p3ASER0esxd7L4MnN21vYch7zkzLwfW15tPBO5iyHuunUv14fbf9faw9/wMYGVEbI2IayLihcChmXl7Zk4CVwPHM81nWUQc3mNuY6UEweH8dskFsDcilvxhsczcAjzYNbSs/h8BYAI4gof3PjU+3dxFLTN/nZkTETEKXAqcxZD3DJCZeyLis8BHqfoe6p4j4k+A8cy8umt4qHsGdlOF3wnAW4CL67EpvXreW4/tmmZuY6UEQSl3LncfBx0FdvLw3qfGp5u76EXE0cA3gM9n5hcpoGeAzHwz8DSq8wWP7HpqGHs+jeq+omuBZwKfAx7b9fww9nwr8Pf16uZWqg/7R3U936vn5dOMzbrnUoKglDuXb4mItfXjE4FtVL2fEBHLI+IJVCF4d4+5i1pEHAlsBc7MzIvq4WHv+ZSIeFe9uZvqQ+47w9xzZr4wM9dk5lrge8CbgKuGuWeq8DsPICIeB6wE7ouIp0TEMqqVwlTP+32WZeYu4IFp5ja25A+PNFTKnctnABdExCOAHwGXZubeiNgG3EgV/Bt6zR1EwbP0bmAMODsips4VnA58ZIh7/gpwcURcDxwCbKSqfZj/nacz7P9vfwa4JCK+SXW102lUof8FYAXVuZCbIuLbTP9Z9pYD587mzb2zWJIKV8qhIUlSDwaBJBXOIJCkwhkEklQ4g0CSCmcQSFLhDAJJKpxBIEmF+38MAFJk92MnBAAAAABJRU5ErkJggg==\n",
"text/plain": [
"<Figure size 432x288 with 1 Axes>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"th[th.between(0, 5000)].plot(kind=\"hist\", bins=100)\n",
"th.mean(), th.median(), th.mode()"
]
},
{
"cell_type": "code",
"execution_count": 49,
"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>LeagueIndex</th>\n",
" <th>Age</th>\n",
" <th>HoursPerWeek</th>\n",
" <th>TotalHours</th>\n",
" <th>APM</th>\n",
" <th>SelectByHotkeys</th>\n",
" <th>AssignToHotkeys</th>\n",
" <th>UniqueHotkeys</th>\n",
" <th>MinimapAttacks</th>\n",
" <th>MinimapRightClicks</th>\n",
" <th>NumberOfPACs</th>\n",
" <th>GapBetweenPACs</th>\n",
" <th>ActionLatency</th>\n",
" <th>ActionsInPAC</th>\n",
" <th>TotalMapExplored</th>\n",
" <th>WorkersMade</th>\n",
" <th>UniqueUnitsMade</th>\n",
" <th>ComplexUnitsMade</th>\n",
" <th>ComplexAbilitiesUsed</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>52</td>\n",
" <td>5</td>\n",
" <td>27</td>\n",
" <td>10</td>\n",
" <td>3000</td>\n",
" <td>143.7180</td>\n",
" <td>0.003515</td>\n",
" <td>0.000220</td>\n",
" <td>7</td>\n",
" <td>0.000110</td>\n",
" <td>0.000392</td>\n",
" <td>0.004849</td>\n",
" <td>32.6677</td>\n",
" <td>40.8673</td>\n",
" <td>4.7508</td>\n",
" <td>28</td>\n",
" <td>0.001397</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>55</td>\n",
" <td>5</td>\n",
" <td>23</td>\n",
" <td>10</td>\n",
" <td>5000</td>\n",
" <td>129.2322</td>\n",
" <td>0.003304</td>\n",
" <td>0.000259</td>\n",
" <td>4</td>\n",
" <td>0.000294</td>\n",
" <td>0.000432</td>\n",
" <td>0.004307</td>\n",
" <td>32.9194</td>\n",
" <td>42.3454</td>\n",
" <td>4.8434</td>\n",
" <td>22</td>\n",
" <td>0.001194</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000208</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>56</td>\n",
" <td>4</td>\n",
" <td>30</td>\n",
" <td>10</td>\n",
" <td>200</td>\n",
" <td>69.9612</td>\n",
" <td>0.001101</td>\n",
" <td>0.000336</td>\n",
" <td>4</td>\n",
" <td>0.000294</td>\n",
" <td>0.000461</td>\n",
" <td>0.002926</td>\n",
" <td>44.6475</td>\n",
" <td>75.3548</td>\n",
" <td>4.0430</td>\n",
" <td>22</td>\n",
" <td>0.000745</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000189</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>57</td>\n",
" <td>3</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" <td>400</td>\n",
" <td>107.6016</td>\n",
" <td>0.001034</td>\n",
" <td>0.000213</td>\n",
" <td>1</td>\n",
" <td>0.000053</td>\n",
" <td>0.000543</td>\n",
" <td>0.003783</td>\n",
" <td>29.2203</td>\n",
" <td>53.7352</td>\n",
" <td>4.9155</td>\n",
" <td>19</td>\n",
" <td>0.000426</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000384</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>58</td>\n",
" <td>3</td>\n",
" <td>32</td>\n",
" <td>10</td>\n",
" <td>500</td>\n",
" <td>122.8908</td>\n",
" <td>0.001136</td>\n",
" <td>0.000327</td>\n",
" <td>2</td>\n",
" <td>0.000000</td>\n",
" <td>0.001329</td>\n",
" <td>0.002368</td>\n",
" <td>22.6885</td>\n",
" <td>62.0813</td>\n",
" <td>9.3740</td>\n",
" <td>15</td>\n",
" <td>0.001174</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>0.000019</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>60</td>\n",
" <td>2</td>\n",
" <td>27</td>\n",
" <td>6</td>\n",
" <td>70</td>\n",
" <td>44.4570</td>\n",
" <td>0.000978</td>\n",
" <td>0.000255</td>\n",
" <td>2</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.002425</td>\n",
" <td>76.4405</td>\n",
" <td>98.7719</td>\n",
" <td>3.0965</td>\n",
" <td>16</td>\n",
" <td>0.000372</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>61</td>\n",
" <td>1</td>\n",
" <td>21</td>\n",
" <td>8</td>\n",
" <td>240</td>\n",
" <td>46.9962</td>\n",
" <td>0.000820</td>\n",
" <td>0.000169</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000045</td>\n",
" <td>0.001988</td>\n",
" <td>94.0227</td>\n",
" <td>90.5311</td>\n",
" <td>4.1017</td>\n",
" <td>15</td>\n",
" <td>0.000573</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>72</td>\n",
" <td>7</td>\n",
" <td>17</td>\n",
" <td>42</td>\n",
" <td>10000</td>\n",
" <td>212.6022</td>\n",
" <td>0.009040</td>\n",
" <td>0.000676</td>\n",
" <td>6</td>\n",
" <td>0.001164</td>\n",
" <td>0.001253</td>\n",
" <td>0.004952</td>\n",
" <td>24.6117</td>\n",
" <td>41.7671</td>\n",
" <td>6.6104</td>\n",
" <td>45</td>\n",
" <td>0.002277</td>\n",
" <td>9</td>\n",
" <td>0.000129</td>\n",
" <td>0.000249</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>77</td>\n",
" <td>4</td>\n",
" <td>20</td>\n",
" <td>14</td>\n",
" <td>2708</td>\n",
" <td>117.4884</td>\n",
" <td>0.002944</td>\n",
" <td>0.000527</td>\n",
" <td>2</td>\n",
" <td>0.000019</td>\n",
" <td>0.000414</td>\n",
" <td>0.005399</td>\n",
" <td>52.0140</td>\n",
" <td>46.4321</td>\n",
" <td>3.3746</td>\n",
" <td>29</td>\n",
" <td>0.001035</td>\n",
" <td>7</td>\n",
" <td>0.000273</td>\n",
" <td>0.000470</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>81</td>\n",
" <td>4</td>\n",
" <td>18</td>\n",
" <td>24</td>\n",
" <td>800</td>\n",
" <td>155.9856</td>\n",
" <td>0.005054</td>\n",
" <td>0.000524</td>\n",
" <td>8</td>\n",
" <td>0.000025</td>\n",
" <td>0.000399</td>\n",
" <td>0.003569</td>\n",
" <td>24.4632</td>\n",
" <td>52.1538</td>\n",
" <td>6.5664</td>\n",
" <td>27</td>\n",
" <td>0.001310</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>83</td>\n",
" <td>3</td>\n",
" <td>16</td>\n",
" <td>16</td>\n",
" <td>6000</td>\n",
" <td>153.8010</td>\n",
" <td>0.001677</td>\n",
" <td>0.000319</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>0.000822</td>\n",
" <td>0.003772</td>\n",
" <td>23.4107</td>\n",
" <td>48.0711</td>\n",
" <td>7.0044</td>\n",
" <td>24</td>\n",
" <td>0.001593</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000017</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>93</td>\n",
" <td>4</td>\n",
" <td>26</td>\n",
" <td>4</td>\n",
" <td>190</td>\n",
" <td>79.2948</td>\n",
" <td>0.000379</td>\n",
" <td>0.000255</td>\n",
" <td>3</td>\n",
" <td>0.000016</td>\n",
" <td>0.000165</td>\n",
" <td>0.003555</td>\n",
" <td>39.6381</td>\n",
" <td>65.5000</td>\n",
" <td>4.2269</td>\n",
" <td>19</td>\n",
" <td>0.000757</td>\n",
" <td>7</td>\n",
" <td>0.000107</td>\n",
" <td>0.000263</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>97</td>\n",
" <td>3</td>\n",
" <td>18</td>\n",
" <td>12</td>\n",
" <td>350</td>\n",
" <td>67.4754</td>\n",
" <td>0.000423</td>\n",
" <td>0.000169</td>\n",
" <td>1</td>\n",
" <td>0.000024</td>\n",
" <td>0.000145</td>\n",
" <td>0.002885</td>\n",
" <td>42.4370</td>\n",
" <td>68.0502</td>\n",
" <td>4.3222</td>\n",
" <td>16</td>\n",
" <td>0.000748</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000435</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>98</td>\n",
" <td>3</td>\n",
" <td>38</td>\n",
" <td>6</td>\n",
" <td>1000</td>\n",
" <td>119.4366</td>\n",
" <td>0.004952</td>\n",
" <td>0.000052</td>\n",
" <td>2</td>\n",
" <td>0.000087</td>\n",
" <td>0.000035</td>\n",
" <td>0.002728</td>\n",
" <td>54.8718</td>\n",
" <td>79.2102</td>\n",
" <td>6.2293</td>\n",
" <td>21</td>\n",
" <td>0.001494</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>100</td>\n",
" <td>5</td>\n",
" <td>16</td>\n",
" <td>30</td>\n",
" <td>5000</td>\n",
" <td>160.4754</td>\n",
" <td>0.004254</td>\n",
" <td>0.000432</td>\n",
" <td>2</td>\n",
" <td>0.000775</td>\n",
" <td>0.000406</td>\n",
" <td>0.004571</td>\n",
" <td>36.2897</td>\n",
" <td>46.8889</td>\n",
" <td>5.4361</td>\n",
" <td>28</td>\n",
" <td>0.001981</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>102</td>\n",
" <td>5</td>\n",
" <td>17</td>\n",
" <td>16</td>\n",
" <td>1500</td>\n",
" <td>81.7722</td>\n",
" <td>0.002333</td>\n",
" <td>0.000430</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>0.000249</td>\n",
" <td>0.002900</td>\n",
" <td>45.1654</td>\n",
" <td>64.7500</td>\n",
" <td>4.5312</td>\n",
" <td>15</td>\n",
" <td>0.001246</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000227</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>105</td>\n",
" <td>4</td>\n",
" <td>28</td>\n",
" <td>8</td>\n",
" <td>2000</td>\n",
" <td>50.8374</td>\n",
" <td>0.000664</td>\n",
" <td>0.000221</td>\n",
" <td>1</td>\n",
" <td>0.000018</td>\n",
" <td>0.000148</td>\n",
" <td>0.002656</td>\n",
" <td>45.7902</td>\n",
" <td>76.8889</td>\n",
" <td>3.5000</td>\n",
" <td>13</td>\n",
" <td>0.000664</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000295</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>106</td>\n",
" <td>5</td>\n",
" <td>20</td>\n",
" <td>10</td>\n",
" <td>120</td>\n",
" <td>160.6464</td>\n",
" <td>0.003430</td>\n",
" <td>0.000634</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000095</td>\n",
" <td>0.005535</td>\n",
" <td>28.3636</td>\n",
" <td>37.7947</td>\n",
" <td>4.7671</td>\n",
" <td>29</td>\n",
" <td>0.002768</td>\n",
" <td>10</td>\n",
" <td>0.000087</td>\n",
" <td>0.000102</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>118</td>\n",
" <td>5</td>\n",
" <td>16</td>\n",
" <td>14</td>\n",
" <td>350</td>\n",
" <td>107.9118</td>\n",
" <td>0.006701</td>\n",
" <td>0.000706</td>\n",
" <td>5</td>\n",
" <td>0.000013</td>\n",
" <td>0.000466</td>\n",
" <td>0.003237</td>\n",
" <td>67.0744</td>\n",
" <td>71.3251</td>\n",
" <td>4.3786</td>\n",
" <td>27</td>\n",
" <td>0.001332</td>\n",
" <td>9</td>\n",
" <td>0.000240</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>127</td>\n",
" <td>4</td>\n",
" <td>26</td>\n",
" <td>28</td>\n",
" <td>1100</td>\n",
" <td>114.7806</td>\n",
" <td>0.002630</td>\n",
" <td>0.000287</td>\n",
" <td>5</td>\n",
" <td>0.000244</td>\n",
" <td>0.000345</td>\n",
" <td>0.003650</td>\n",
" <td>40.4427</td>\n",
" <td>59.9370</td>\n",
" <td>4.9961</td>\n",
" <td>16</td>\n",
" <td>0.001581</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>132</td>\n",
" <td>5</td>\n",
" <td>21</td>\n",
" <td>10</td>\n",
" <td>800</td>\n",
" <td>115.1274</td>\n",
" <td>0.002651</td>\n",
" <td>0.000660</td>\n",
" <td>8</td>\n",
" <td>0.000099</td>\n",
" <td>0.000693</td>\n",
" <td>0.004147</td>\n",
" <td>30.7660</td>\n",
" <td>49.4854</td>\n",
" <td>4.6790</td>\n",
" <td>30</td>\n",
" <td>0.000825</td>\n",
" <td>8</td>\n",
" <td>0.000000</td>\n",
" <td>0.000517</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>138</td>\n",
" <td>6</td>\n",
" <td>21</td>\n",
" <td>6</td>\n",
" <td>500</td>\n",
" <td>133.7016</td>\n",
" <td>0.004500</td>\n",
" <td>0.000420</td>\n",
" <td>3</td>\n",
" <td>0.000019</td>\n",
" <td>0.000075</td>\n",
" <td>0.003874</td>\n",
" <td>21.4686</td>\n",
" <td>50.5253</td>\n",
" <td>5.4892</td>\n",
" <td>29</td>\n",
" <td>0.001008</td>\n",
" <td>10</td>\n",
" <td>0.000000</td>\n",
" <td>0.000560</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>139</td>\n",
" <td>5</td>\n",
" <td>18</td>\n",
" <td>20</td>\n",
" <td>800</td>\n",
" <td>99.5088</td>\n",
" <td>0.000734</td>\n",
" <td>0.000108</td>\n",
" <td>1</td>\n",
" <td>0.000024</td>\n",
" <td>0.000578</td>\n",
" <td>0.002695</td>\n",
" <td>22.7265</td>\n",
" <td>68.7321</td>\n",
" <td>6.7054</td>\n",
" <td>23</td>\n",
" <td>0.001961</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>140</td>\n",
" <td>5</td>\n",
" <td>26</td>\n",
" <td>10</td>\n",
" <td>500</td>\n",
" <td>83.9172</td>\n",
" <td>0.002854</td>\n",
" <td>0.000493</td>\n",
" <td>3</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0.004607</td>\n",
" <td>51.2082</td>\n",
" <td>52.0494</td>\n",
" <td>2.8663</td>\n",
" <td>31</td>\n",
" <td>0.000654</td>\n",
" <td>9</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>141</td>\n",
" <td>4</td>\n",
" <td>17</td>\n",
" <td>14</td>\n",
" <td>500</td>\n",
" <td>216.6936</td>\n",
" <td>0.012495</td>\n",
" <td>0.000482</td>\n",
" <td>4</td>\n",
" <td>0.000054</td>\n",
" <td>0.000107</td>\n",
" <td>0.004334</td>\n",
" <td>27.9255</td>\n",
" <td>45.1605</td>\n",
" <td>6.3395</td>\n",
" <td>18</td>\n",
" <td>0.001204</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>142</td>\n",
" <td>4</td>\n",
" <td>23</td>\n",
" <td>20</td>\n",
" <td>800</td>\n",
" <td>129.8598</td>\n",
" <td>0.002315</td>\n",
" <td>0.000334</td>\n",
" <td>5</td>\n",
" <td>0.000078</td>\n",
" <td>0.001008</td>\n",
" <td>0.003473</td>\n",
" <td>36.3934</td>\n",
" <td>57.5215</td>\n",
" <td>6.7587</td>\n",
" <td>36</td>\n",
" <td>0.000753</td>\n",
" <td>11</td>\n",
" <td>0.000284</td>\n",
" <td>0.001229</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>144</td>\n",
" <td>6</td>\n",
" <td>18</td>\n",
" <td>70</td>\n",
" <td>2520</td>\n",
" <td>267.5586</td>\n",
" <td>0.027815</td>\n",
" <td>0.000708</td>\n",
" <td>10</td>\n",
" <td>0.000000</td>\n",
" <td>0.000128</td>\n",
" <td>0.005616</td>\n",
" <td>34.6035</td>\n",
" <td>40.6025</td>\n",
" <td>4.1629</td>\n",
" <td>36</td>\n",
" <td>0.000856</td>\n",
" <td>12</td>\n",
" <td>0.000089</td>\n",
" <td>0.000197</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>149</td>\n",
" <td>5</td>\n",
" <td>25</td>\n",
" <td>6</td>\n",
" <td>800</td>\n",
" <td>74.1174</td>\n",
" <td>0.000875</td>\n",
" <td>0.000205</td>\n",
" <td>6</td>\n",
" <td>0.000018</td>\n",
" <td>0.000045</td>\n",
" <td>0.003518</td>\n",
" <td>46.4122</td>\n",
" <td>71.8173</td>\n",
" <td>3.7944</td>\n",
" <td>34</td>\n",
" <td>0.000929</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>154</td>\n",
" <td>5</td>\n",
" <td>25</td>\n",
" <td>20</td>\n",
" <td>700</td>\n",
" <td>101.6796</td>\n",
" <td>0.001406</td>\n",
" <td>0.000427</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000125</td>\n",
" <td>0.003453</td>\n",
" <td>26.7979</td>\n",
" <td>54.5979</td>\n",
" <td>5.3144</td>\n",
" <td>22</td>\n",
" <td>0.001032</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>0.000570</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>158</td>\n",
" <td>6</td>\n",
" <td>18</td>\n",
" <td>10</td>\n",
" <td>160</td>\n",
" <td>150.5004</td>\n",
" <td>0.005667</td>\n",
" <td>0.000632</td>\n",
" <td>6</td>\n",
" <td>0.000376</td>\n",
" <td>0.000410</td>\n",
" <td>0.004626</td>\n",
" <td>30.2222</td>\n",
" <td>45.5941</td>\n",
" <td>4.9077</td>\n",
" <td>14</td>\n",
" <td>0.001007</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</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",
" </tr>\n",
" <tr>\n",
" <th>3365</th>\n",
" <td>10050</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>211.9188</td>\n",
" <td>0.019817</td>\n",
" <td>0.000633</td>\n",
" <td>4</td>\n",
" <td>0.000201</td>\n",
" <td>0.000201</td>\n",
" <td>0.003912</td>\n",
" <td>31.8222</td>\n",
" <td>54.5588</td>\n",
" <td>5.0294</td>\n",
" <td>14</td>\n",
" <td>0.001409</td>\n",
" <td>3</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3366</th>\n",
" <td>10051</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>269.8998</td>\n",
" <td>0.024645</td>\n",
" <td>0.000642</td>\n",
" <td>10</td>\n",
" <td>0.000415</td>\n",
" <td>0.000491</td>\n",
" <td>0.004015</td>\n",
" <td>25.6352</td>\n",
" <td>43.3856</td>\n",
" <td>6.4922</td>\n",
" <td>21</td>\n",
" <td>0.000478</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000579</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3367</th>\n",
" <td>10052</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>190.2396</td>\n",
" <td>0.008720</td>\n",
" <td>0.000879</td>\n",
" <td>10</td>\n",
" <td>0.000171</td>\n",
" <td>0.000342</td>\n",
" <td>0.004971</td>\n",
" <td>17.9901</td>\n",
" <td>35.9509</td>\n",
" <td>5.5872</td>\n",
" <td>21</td>\n",
" <td>0.000904</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3368</th>\n",
" <td>10055</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>212.4972</td>\n",
" <td>0.014917</td>\n",
" <td>0.000767</td>\n",
" <td>10</td>\n",
" <td>0.000599</td>\n",
" <td>0.000273</td>\n",
" <td>0.005648</td>\n",
" <td>21.6687</td>\n",
" <td>41.2231</td>\n",
" <td>4.4680</td>\n",
" <td>28</td>\n",
" <td>0.001119</td>\n",
" <td>9</td>\n",
" <td>0.000035</td>\n",
" <td>0.000062</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3369</th>\n",
" <td>10059</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>219.3894</td>\n",
" <td>0.005926</td>\n",
" <td>0.000741</td>\n",
" <td>6</td>\n",
" <td>0.000440</td>\n",
" <td>0.000709</td>\n",
" <td>0.005185</td>\n",
" <td>17.0456</td>\n",
" <td>30.5342</td>\n",
" <td>6.6749</td>\n",
" <td>35</td>\n",
" <td>0.002072</td>\n",
" <td>9</td>\n",
" <td>0.000225</td>\n",
" <td>0.000064</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3370</th>\n",
" <td>10060</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>230.6694</td>\n",
" <td>0.010383</td>\n",
" <td>0.001242</td>\n",
" <td>10</td>\n",
" <td>0.000375</td>\n",
" <td>0.003328</td>\n",
" <td>0.006375</td>\n",
" <td>13.5028</td>\n",
" <td>31.4044</td>\n",
" <td>5.0533</td>\n",
" <td>32</td>\n",
" <td>0.001512</td>\n",
" <td>6</td>\n",
" <td>0.000035</td>\n",
" <td>0.000047</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3371</th>\n",
" <td>10061</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>284.2296</td>\n",
" <td>0.016069</td>\n",
" <td>0.000711</td>\n",
" <td>9</td>\n",
" <td>0.000355</td>\n",
" <td>0.000548</td>\n",
" <td>0.006680</td>\n",
" <td>9.4756</td>\n",
" <td>29.6851</td>\n",
" <td>5.3326</td>\n",
" <td>25</td>\n",
" <td>0.002459</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3372</th>\n",
" <td>10062</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>355.3518</td>\n",
" <td>0.037526</td>\n",
" <td>0.000600</td>\n",
" <td>7</td>\n",
" <td>0.001242</td>\n",
" <td>0.000514</td>\n",
" <td>0.004541</td>\n",
" <td>9.2871</td>\n",
" <td>41.9497</td>\n",
" <td>6.5063</td>\n",
" <td>22</td>\n",
" <td>0.001228</td>\n",
" <td>8</td>\n",
" <td>0.000000</td>\n",
" <td>0.000614</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3373</th>\n",
" <td>10063</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>364.8504</td>\n",
" <td>0.042576</td>\n",
" <td>0.000996</td>\n",
" <td>8</td>\n",
" <td>0.000176</td>\n",
" <td>0.000146</td>\n",
" <td>0.004687</td>\n",
" <td>19.9499</td>\n",
" <td>41.1417</td>\n",
" <td>5.6167</td>\n",
" <td>18</td>\n",
" <td>0.000674</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3374</th>\n",
" <td>10064</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>256.5888</td>\n",
" <td>0.019592</td>\n",
" <td>0.000580</td>\n",
" <td>8</td>\n",
" <td>0.000416</td>\n",
" <td>0.000357</td>\n",
" <td>0.005812</td>\n",
" <td>17.0462</td>\n",
" <td>34.3734</td>\n",
" <td>5.0563</td>\n",
" <td>19</td>\n",
" <td>0.001308</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3375</th>\n",
" <td>10065</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>248.4012</td>\n",
" <td>0.016018</td>\n",
" <td>0.000874</td>\n",
" <td>9</td>\n",
" <td>0.000388</td>\n",
" <td>0.000372</td>\n",
" <td>0.005987</td>\n",
" <td>16.3144</td>\n",
" <td>30.2486</td>\n",
" <td>5.0973</td>\n",
" <td>21</td>\n",
" <td>0.001197</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3376</th>\n",
" <td>10066</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>251.2284</td>\n",
" <td>0.022910</td>\n",
" <td>0.000946</td>\n",
" <td>5</td>\n",
" <td>0.001097</td>\n",
" <td>0.001173</td>\n",
" <td>0.005411</td>\n",
" <td>13.7404</td>\n",
" <td>35.7203</td>\n",
" <td>4.5524</td>\n",
" <td>22</td>\n",
" <td>0.000738</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000662</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3377</th>\n",
" <td>10067</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>318.3000</td>\n",
" <td>0.034851</td>\n",
" <td>0.000933</td>\n",
" <td>7</td>\n",
" <td>0.000187</td>\n",
" <td>0.000023</td>\n",
" <td>0.005225</td>\n",
" <td>26.0987</td>\n",
" <td>32.4464</td>\n",
" <td>4.8705</td>\n",
" <td>13</td>\n",
" <td>0.000933</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>0.000233</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3378</th>\n",
" <td>10068</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>288.9198</td>\n",
" <td>0.029322</td>\n",
" <td>0.001569</td>\n",
" <td>6</td>\n",
" <td>0.000118</td>\n",
" <td>0.000219</td>\n",
" <td>0.005213</td>\n",
" <td>23.2857</td>\n",
" <td>32.8026</td>\n",
" <td>4.7540</td>\n",
" <td>24</td>\n",
" <td>0.001130</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3379</th>\n",
" <td>10069</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>313.9080</td>\n",
" <td>0.019537</td>\n",
" <td>0.001214</td>\n",
" <td>4</td>\n",
" <td>0.000318</td>\n",
" <td>0.000607</td>\n",
" <td>0.005879</td>\n",
" <td>8.1642</td>\n",
" <td>26.0918</td>\n",
" <td>6.7885</td>\n",
" <td>26</td>\n",
" <td>0.001321</td>\n",
" <td>8</td>\n",
" <td>0.000106</td>\n",
" <td>0.000443</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3380</th>\n",
" <td>10072</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>243.7134</td>\n",
" <td>0.017195</td>\n",
" <td>0.000711</td>\n",
" <td>6</td>\n",
" <td>0.000666</td>\n",
" <td>0.000426</td>\n",
" <td>0.005594</td>\n",
" <td>21.8795</td>\n",
" <td>30.5722</td>\n",
" <td>5.1136</td>\n",
" <td>25</td>\n",
" <td>0.000576</td>\n",
" <td>8</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3381</th>\n",
" <td>10073</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>312.9804</td>\n",
" <td>0.026327</td>\n",
" <td>0.000266</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000207</td>\n",
" <td>0.005053</td>\n",
" <td>14.6118</td>\n",
" <td>30.7836</td>\n",
" <td>6.1930</td>\n",
" <td>10</td>\n",
" <td>0.001802</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>0.000030</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3382</th>\n",
" <td>10074</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>313.5762</td>\n",
" <td>0.030550</td>\n",
" <td>0.000560</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000206</td>\n",
" <td>0.004390</td>\n",
" <td>19.5405</td>\n",
" <td>35.4094</td>\n",
" <td>6.4228</td>\n",
" <td>12</td>\n",
" <td>0.001296</td>\n",
" <td>3</td>\n",
" <td>0.000000</td>\n",
" <td>0.000059</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3383</th>\n",
" <td>10075</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>274.6194</td>\n",
" <td>0.022497</td>\n",
" <td>0.000707</td>\n",
" <td>6</td>\n",
" <td>0.000163</td>\n",
" <td>0.000082</td>\n",
" <td>0.004053</td>\n",
" <td>20.6757</td>\n",
" <td>32.7785</td>\n",
" <td>6.9262</td>\n",
" <td>15</td>\n",
" <td>0.000626</td>\n",
" <td>3</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3384</th>\n",
" <td>10076</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>225.0678</td>\n",
" <td>0.014339</td>\n",
" <td>0.001627</td>\n",
" <td>7</td>\n",
" <td>0.000291</td>\n",
" <td>0.000911</td>\n",
" <td>0.005281</td>\n",
" <td>16.3502</td>\n",
" <td>33.2874</td>\n",
" <td>5.4713</td>\n",
" <td>26</td>\n",
" <td>0.000898</td>\n",
" <td>8</td>\n",
" <td>0.000000</td>\n",
" <td>0.000959</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3385</th>\n",
" <td>10079</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>254.2188</td>\n",
" <td>0.016608</td>\n",
" <td>0.000788</td>\n",
" <td>6</td>\n",
" <td>0.000926</td>\n",
" <td>0.000330</td>\n",
" <td>0.005408</td>\n",
" <td>14.9191</td>\n",
" <td>35.9921</td>\n",
" <td>5.7205</td>\n",
" <td>28</td>\n",
" <td>0.001128</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3386</th>\n",
" <td>10081</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>339.1524</td>\n",
" <td>0.033058</td>\n",
" <td>0.001017</td>\n",
" <td>10</td>\n",
" <td>0.000477</td>\n",
" <td>0.000509</td>\n",
" <td>0.004609</td>\n",
" <td>21.6389</td>\n",
" <td>37.1862</td>\n",
" <td>6.7103</td>\n",
" <td>16</td>\n",
" <td>0.001049</td>\n",
" <td>3</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3387</th>\n",
" <td>10082</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>310.0416</td>\n",
" <td>0.026873</td>\n",
" <td>0.001278</td>\n",
" <td>10</td>\n",
" <td>0.000319</td>\n",
" <td>0.000479</td>\n",
" <td>0.005517</td>\n",
" <td>16.5446</td>\n",
" <td>33.8174</td>\n",
" <td>5.7350</td>\n",
" <td>22</td>\n",
" <td>0.000922</td>\n",
" <td>8</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3388</th>\n",
" <td>10083</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>288.7608</td>\n",
" <td>0.024022</td>\n",
" <td>0.000628</td>\n",
" <td>6</td>\n",
" <td>0.000350</td>\n",
" <td>0.001051</td>\n",
" <td>0.005580</td>\n",
" <td>19.0108</td>\n",
" <td>30.0866</td>\n",
" <td>5.3831</td>\n",
" <td>30</td>\n",
" <td>0.000761</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000652</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3389</th>\n",
" <td>10084</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>151.4046</td>\n",
" <td>0.009732</td>\n",
" <td>0.000949</td>\n",
" <td>6</td>\n",
" <td>0.000028</td>\n",
" <td>0.000156</td>\n",
" <td>0.004363</td>\n",
" <td>27.4658</td>\n",
" <td>43.8052</td>\n",
" <td>4.3312</td>\n",
" <td>23</td>\n",
" <td>0.000949</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000099</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3390</th>\n",
" <td>10089</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>259.6296</td>\n",
" <td>0.020425</td>\n",
" <td>0.000743</td>\n",
" <td>9</td>\n",
" <td>0.000621</td>\n",
" <td>0.000146</td>\n",
" <td>0.004555</td>\n",
" <td>18.6059</td>\n",
" <td>42.8342</td>\n",
" <td>6.2754</td>\n",
" <td>46</td>\n",
" <td>0.000877</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3391</th>\n",
" <td>10090</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>314.6700</td>\n",
" <td>0.028043</td>\n",
" <td>0.001157</td>\n",
" <td>10</td>\n",
" <td>0.000246</td>\n",
" <td>0.001083</td>\n",
" <td>0.004259</td>\n",
" <td>14.3023</td>\n",
" <td>36.1156</td>\n",
" <td>7.1965</td>\n",
" <td>16</td>\n",
" <td>0.000788</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3392</th>\n",
" <td>10092</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>299.4282</td>\n",
" <td>0.028341</td>\n",
" <td>0.000860</td>\n",
" <td>7</td>\n",
" <td>0.000338</td>\n",
" <td>0.000169</td>\n",
" <td>0.004439</td>\n",
" <td>12.4028</td>\n",
" <td>39.5156</td>\n",
" <td>6.3979</td>\n",
" <td>19</td>\n",
" <td>0.001260</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3393</th>\n",
" <td>10094</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>375.8664</td>\n",
" <td>0.036436</td>\n",
" <td>0.000594</td>\n",
" <td>5</td>\n",
" <td>0.000204</td>\n",
" <td>0.000780</td>\n",
" <td>0.004346</td>\n",
" <td>11.6910</td>\n",
" <td>34.8547</td>\n",
" <td>7.9615</td>\n",
" <td>15</td>\n",
" <td>0.000613</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000631</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3394</th>\n",
" <td>10095</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>348.3576</td>\n",
" <td>0.029855</td>\n",
" <td>0.000811</td>\n",
" <td>4</td>\n",
" <td>0.000224</td>\n",
" <td>0.001315</td>\n",
" <td>0.005566</td>\n",
" <td>20.0537</td>\n",
" <td>33.5142</td>\n",
" <td>6.3719</td>\n",
" <td>27</td>\n",
" <td>0.001566</td>\n",
" <td>7</td>\n",
" <td>0.000457</td>\n",
" <td>0.000895</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>3395 rows × 20 columns</p>\n",
"</div>"
],
"text/plain": [
" GameID LeagueIndex Age HoursPerWeek TotalHours APM \\\n",
"0 52 5 27 10 3000 143.7180 \n",
"1 55 5 23 10 5000 129.2322 \n",
"2 56 4 30 10 200 69.9612 \n",
"3 57 3 19 20 400 107.6016 \n",
"4 58 3 32 10 500 122.8908 \n",
"5 60 2 27 6 70 44.4570 \n",
"6 61 1 21 8 240 46.9962 \n",
"7 72 7 17 42 10000 212.6022 \n",
"8 77 4 20 14 2708 117.4884 \n",
"9 81 4 18 24 800 155.9856 \n",
"10 83 3 16 16 6000 153.8010 \n",
"11 93 4 26 4 190 79.2948 \n",
"12 97 3 18 12 350 67.4754 \n",
"13 98 3 38 6 1000 119.4366 \n",
"14 100 5 16 30 5000 160.4754 \n",
"15 102 5 17 16 1500 81.7722 \n",
"16 105 4 28 8 2000 50.8374 \n",
"17 106 5 20 10 120 160.6464 \n",
"18 118 5 16 14 350 107.9118 \n",
"19 127 4 26 28 1100 114.7806 \n",
"20 132 5 21 10 800 115.1274 \n",
"21 138 6 21 6 500 133.7016 \n",
"22 139 5 18 20 800 99.5088 \n",
"23 140 5 26 10 500 83.9172 \n",
"24 141 4 17 14 500 216.6936 \n",
"25 142 4 23 20 800 129.8598 \n",
"26 144 6 18 70 2520 267.5586 \n",
"27 149 5 25 6 800 74.1174 \n",
"28 154 5 25 20 700 101.6796 \n",
"29 158 6 18 10 160 150.5004 \n",
"... ... ... .. ... ... ... \n",
"3365 10050 8 ? ? ? 211.9188 \n",
"3366 10051 8 ? ? ? 269.8998 \n",
"3367 10052 8 ? ? ? 190.2396 \n",
"3368 10055 8 ? ? ? 212.4972 \n",
"3369 10059 8 ? ? ? 219.3894 \n",
"3370 10060 8 ? ? ? 230.6694 \n",
"3371 10061 8 ? ? ? 284.2296 \n",
"3372 10062 8 ? ? ? 355.3518 \n",
"3373 10063 8 ? ? ? 364.8504 \n",
"3374 10064 8 ? ? ? 256.5888 \n",
"3375 10065 8 ? ? ? 248.4012 \n",
"3376 10066 8 ? ? ? 251.2284 \n",
"3377 10067 8 ? ? ? 318.3000 \n",
"3378 10068 8 ? ? ? 288.9198 \n",
"3379 10069 8 ? ? ? 313.9080 \n",
"3380 10072 8 ? ? ? 243.7134 \n",
"3381 10073 8 ? ? ? 312.9804 \n",
"3382 10074 8 ? ? ? 313.5762 \n",
"3383 10075 8 ? ? ? 274.6194 \n",
"3384 10076 8 ? ? ? 225.0678 \n",
"3385 10079 8 ? ? ? 254.2188 \n",
"3386 10081 8 ? ? ? 339.1524 \n",
"3387 10082 8 ? ? ? 310.0416 \n",
"3388 10083 8 ? ? ? 288.7608 \n",
"3389 10084 8 ? ? ? 151.4046 \n",
"3390 10089 8 ? ? ? 259.6296 \n",
"3391 10090 8 ? ? ? 314.6700 \n",
"3392 10092 8 ? ? ? 299.4282 \n",
"3393 10094 8 ? ? ? 375.8664 \n",
"3394 10095 8 ? ? ? 348.3576 \n",
"\n",
" SelectByHotkeys AssignToHotkeys UniqueHotkeys MinimapAttacks \\\n",
"0 0.003515 0.000220 7 0.000110 \n",
"1 0.003304 0.000259 4 0.000294 \n",
"2 0.001101 0.000336 4 0.000294 \n",
"3 0.001034 0.000213 1 0.000053 \n",
"4 0.001136 0.000327 2 0.000000 \n",
"5 0.000978 0.000255 2 0.000000 \n",
"6 0.000820 0.000169 6 0.000000 \n",
"7 0.009040 0.000676 6 0.001164 \n",
"8 0.002944 0.000527 2 0.000019 \n",
"9 0.005054 0.000524 8 0.000025 \n",
"10 0.001677 0.000319 4 0.000000 \n",
"11 0.000379 0.000255 3 0.000016 \n",
"12 0.000423 0.000169 1 0.000024 \n",
"13 0.004952 0.000052 2 0.000087 \n",
"14 0.004254 0.000432 2 0.000775 \n",
"15 0.002333 0.000430 4 0.000000 \n",
"16 0.000664 0.000221 1 0.000018 \n",
"17 0.003430 0.000634 7 0.000000 \n",
"18 0.006701 0.000706 5 0.000013 \n",
"19 0.002630 0.000287 5 0.000244 \n",
"20 0.002651 0.000660 8 0.000099 \n",
"21 0.004500 0.000420 3 0.000019 \n",
"22 0.000734 0.000108 1 0.000024 \n",
"23 0.002854 0.000493 3 0.000000 \n",
"24 0.012495 0.000482 4 0.000054 \n",
"25 0.002315 0.000334 5 0.000078 \n",
"26 0.027815 0.000708 10 0.000000 \n",
"27 0.000875 0.000205 6 0.000018 \n",
"28 0.001406 0.000427 5 0.000000 \n",
"29 0.005667 0.000632 6 0.000376 \n",
"... ... ... ... ... \n",
"3365 0.019817 0.000633 4 0.000201 \n",
"3366 0.024645 0.000642 10 0.000415 \n",
"3367 0.008720 0.000879 10 0.000171 \n",
"3368 0.014917 0.000767 10 0.000599 \n",
"3369 0.005926 0.000741 6 0.000440 \n",
"3370 0.010383 0.001242 10 0.000375 \n",
"3371 0.016069 0.000711 9 0.000355 \n",
"3372 0.037526 0.000600 7 0.001242 \n",
"3373 0.042576 0.000996 8 0.000176 \n",
"3374 0.019592 0.000580 8 0.000416 \n",
"3375 0.016018 0.000874 9 0.000388 \n",
"3376 0.022910 0.000946 5 0.001097 \n",
"3377 0.034851 0.000933 7 0.000187 \n",
"3378 0.029322 0.001569 6 0.000118 \n",
"3379 0.019537 0.001214 4 0.000318 \n",
"3380 0.017195 0.000711 6 0.000666 \n",
"3381 0.026327 0.000266 6 0.000000 \n",
"3382 0.030550 0.000560 5 0.000000 \n",
"3383 0.022497 0.000707 6 0.000163 \n",
"3384 0.014339 0.001627 7 0.000291 \n",
"3385 0.016608 0.000788 6 0.000926 \n",
"3386 0.033058 0.001017 10 0.000477 \n",
"3387 0.026873 0.001278 10 0.000319 \n",
"3388 0.024022 0.000628 6 0.000350 \n",
"3389 0.009732 0.000949 6 0.000028 \n",
"3390 0.020425 0.000743 9 0.000621 \n",
"3391 0.028043 0.001157 10 0.000246 \n",
"3392 0.028341 0.000860 7 0.000338 \n",
"3393 0.036436 0.000594 5 0.000204 \n",
"3394 0.029855 0.000811 4 0.000224 \n",
"\n",
" MinimapRightClicks NumberOfPACs GapBetweenPACs ActionLatency \\\n",
"0 0.000392 0.004849 32.6677 40.8673 \n",
"1 0.000432 0.004307 32.9194 42.3454 \n",
"2 0.000461 0.002926 44.6475 75.3548 \n",
"3 0.000543 0.003783 29.2203 53.7352 \n",
"4 0.001329 0.002368 22.6885 62.0813 \n",
"5 0.000000 0.002425 76.4405 98.7719 \n",
"6 0.000045 0.001988 94.0227 90.5311 \n",
"7 0.001253 0.004952 24.6117 41.7671 \n",
"8 0.000414 0.005399 52.0140 46.4321 \n",
"9 0.000399 0.003569 24.4632 52.1538 \n",
"10 0.000822 0.003772 23.4107 48.0711 \n",
"11 0.000165 0.003555 39.6381 65.5000 \n",
"12 0.000145 0.002885 42.4370 68.0502 \n",
"13 0.000035 0.002728 54.8718 79.2102 \n",
"14 0.000406 0.004571 36.2897 46.8889 \n",
"15 0.000249 0.002900 45.1654 64.7500 \n",
"16 0.000148 0.002656 45.7902 76.8889 \n",
"17 0.000095 0.005535 28.3636 37.7947 \n",
"18 0.000466 0.003237 67.0744 71.3251 \n",
"19 0.000345 0.003650 40.4427 59.9370 \n",
"20 0.000693 0.004147 30.7660 49.4854 \n",
"21 0.000075 0.003874 21.4686 50.5253 \n",
"22 0.000578 0.002695 22.7265 68.7321 \n",
"23 0.000000 0.004607 51.2082 52.0494 \n",
"24 0.000107 0.004334 27.9255 45.1605 \n",
"25 0.001008 0.003473 36.3934 57.5215 \n",
"26 0.000128 0.005616 34.6035 40.6025 \n",
"27 0.000045 0.003518 46.4122 71.8173 \n",
"28 0.000125 0.003453 26.7979 54.5979 \n",
"29 0.000410 0.004626 30.2222 45.5941 \n",
"... ... ... ... ... \n",
"3365 0.000201 0.003912 31.8222 54.5588 \n",
"3366 0.000491 0.004015 25.6352 43.3856 \n",
"3367 0.000342 0.004971 17.9901 35.9509 \n",
"3368 0.000273 0.005648 21.6687 41.2231 \n",
"3369 0.000709 0.005185 17.0456 30.5342 \n",
"3370 0.003328 0.006375 13.5028 31.4044 \n",
"3371 0.000548 0.006680 9.4756 29.6851 \n",
"3372 0.000514 0.004541 9.2871 41.9497 \n",
"3373 0.000146 0.004687 19.9499 41.1417 \n",
"3374 0.000357 0.005812 17.0462 34.3734 \n",
"3375 0.000372 0.005987 16.3144 30.2486 \n",
"3376 0.001173 0.005411 13.7404 35.7203 \n",
"3377 0.000023 0.005225 26.0987 32.4464 \n",
"3378 0.000219 0.005213 23.2857 32.8026 \n",
"3379 0.000607 0.005879 8.1642 26.0918 \n",
"3380 0.000426 0.005594 21.8795 30.5722 \n",
"3381 0.000207 0.005053 14.6118 30.7836 \n",
"3382 0.000206 0.004390 19.5405 35.4094 \n",
"3383 0.000082 0.004053 20.6757 32.7785 \n",
"3384 0.000911 0.005281 16.3502 33.2874 \n",
"3385 0.000330 0.005408 14.9191 35.9921 \n",
"3386 0.000509 0.004609 21.6389 37.1862 \n",
"3387 0.000479 0.005517 16.5446 33.8174 \n",
"3388 0.001051 0.005580 19.0108 30.0866 \n",
"3389 0.000156 0.004363 27.4658 43.8052 \n",
"3390 0.000146 0.004555 18.6059 42.8342 \n",
"3391 0.001083 0.004259 14.3023 36.1156 \n",
"3392 0.000169 0.004439 12.4028 39.5156 \n",
"3393 0.000780 0.004346 11.6910 34.8547 \n",
"3394 0.001315 0.005566 20.0537 33.5142 \n",
"\n",
" ActionsInPAC TotalMapExplored WorkersMade UniqueUnitsMade \\\n",
"0 4.7508 28 0.001397 6 \n",
"1 4.8434 22 0.001194 5 \n",
"2 4.0430 22 0.000745 6 \n",
"3 4.9155 19 0.000426 7 \n",
"4 9.3740 15 0.001174 4 \n",
"5 3.0965 16 0.000372 6 \n",
"6 4.1017 15 0.000573 5 \n",
"7 6.6104 45 0.002277 9 \n",
"8 3.3746 29 0.001035 7 \n",
"9 6.5664 27 0.001310 6 \n",
"10 7.0044 24 0.001593 7 \n",
"11 4.2269 19 0.000757 7 \n",
"12 4.3222 16 0.000748 7 \n",
"13 6.2293 21 0.001494 5 \n",
"14 5.4361 28 0.001981 7 \n",
"15 4.5312 15 0.001246 6 \n",
"16 3.5000 13 0.000664 6 \n",
"17 4.7671 29 0.002768 10 \n",
"18 4.3786 27 0.001332 9 \n",
"19 4.9961 16 0.001581 5 \n",
"20 4.6790 30 0.000825 8 \n",
"21 5.4892 29 0.001008 10 \n",
"22 6.7054 23 0.001961 7 \n",
"23 2.8663 31 0.000654 9 \n",
"24 6.3395 18 0.001204 5 \n",
"25 6.7587 36 0.000753 11 \n",
"26 4.1629 36 0.000856 12 \n",
"27 3.7944 34 0.000929 5 \n",
"28 5.3144 22 0.001032 4 \n",
"29 4.9077 14 0.001007 6 \n",
"... ... ... ... ... \n",
"3365 5.0294 14 0.001409 3 \n",
"3366 6.4922 21 0.000478 6 \n",
"3367 5.5872 21 0.000904 5 \n",
"3368 4.4680 28 0.001119 9 \n",
"3369 6.6749 35 0.002072 9 \n",
"3370 5.0533 32 0.001512 6 \n",
"3371 5.3326 25 0.002459 7 \n",
"3372 6.5063 22 0.001228 8 \n",
"3373 5.6167 18 0.000674 7 \n",
"3374 5.0563 19 0.001308 7 \n",
"3375 5.0973 21 0.001197 6 \n",
"3376 4.5524 22 0.000738 5 \n",
"3377 4.8705 13 0.000933 4 \n",
"3378 4.7540 24 0.001130 5 \n",
"3379 6.7885 26 0.001321 8 \n",
"3380 5.1136 25 0.000576 8 \n",
"3381 6.1930 10 0.001802 4 \n",
"3382 6.4228 12 0.001296 3 \n",
"3383 6.9262 15 0.000626 3 \n",
"3384 5.4713 26 0.000898 8 \n",
"3385 5.7205 28 0.001128 6 \n",
"3386 6.7103 16 0.001049 3 \n",
"3387 5.7350 22 0.000922 8 \n",
"3388 5.3831 30 0.000761 5 \n",
"3389 4.3312 23 0.000949 6 \n",
"3390 6.2754 46 0.000877 5 \n",
"3391 7.1965 16 0.000788 4 \n",
"3392 6.3979 19 0.001260 4 \n",
"3393 7.9615 15 0.000613 6 \n",
"3394 6.3719 27 0.001566 7 \n",
"\n",
" ComplexUnitsMade ComplexAbilitiesUsed \n",
"0 0.000000 0.000000 \n",
"1 0.000000 0.000208 \n",
"2 0.000000 0.000189 \n",
"3 0.000000 0.000384 \n",
"4 0.000000 0.000019 \n",
"5 0.000000 0.000000 \n",
"6 0.000000 0.000000 \n",
"7 0.000129 0.000249 \n",
"8 0.000273 0.000470 \n",
"9 0.000000 0.000000 \n",
"10 0.000000 0.000017 \n",
"11 0.000107 0.000263 \n",
"12 0.000000 0.000435 \n",
"13 0.000000 0.000000 \n",
"14 0.000000 0.000000 \n",
"15 0.000000 0.000227 \n",
"16 0.000000 0.000295 \n",
"17 0.000087 0.000102 \n",
"18 0.000240 0.000000 \n",
"19 0.000000 0.000000 \n",
"20 0.000000 0.000517 \n",
"21 0.000000 0.000560 \n",
"22 0.000000 0.000000 \n",
"23 0.000000 0.000000 \n",
"24 0.000000 0.000000 \n",
"25 0.000284 0.001229 \n",
"26 0.000089 0.000197 \n",
"27 0.000000 0.000000 \n",
"28 0.000000 0.000570 \n",
"29 0.000000 0.000000 \n",
"... ... ... \n",
"3365 0.000000 0.000000 \n",
"3366 0.000000 0.000579 \n",
"3367 0.000000 0.000000 \n",
"3368 0.000035 0.000062 \n",
"3369 0.000225 0.000064 \n",
"3370 0.000035 0.000047 \n",
"3371 0.000000 0.000000 \n",
"3372 0.000000 0.000614 \n",
"3373 0.000000 0.000000 \n",
"3374 0.000000 0.000000 \n",
"3375 0.000000 0.000000 \n",
"3376 0.000000 0.000662 \n",
"3377 0.000000 0.000233 \n",
"3378 0.000000 0.000000 \n",
"3379 0.000106 0.000443 \n",
"3380 0.000000 0.000000 \n",
"3381 0.000000 0.000030 \n",
"3382 0.000000 0.000059 \n",
"3383 0.000000 0.000000 \n",
"3384 0.000000 0.000959 \n",
"3385 0.000000 0.000000 \n",
"3386 0.000000 0.000000 \n",
"3387 0.000000 0.000000 \n",
"3388 0.000000 0.000652 \n",
"3389 0.000000 0.000099 \n",
"3390 0.000000 0.000000 \n",
"3391 0.000000 0.000000 \n",
"3392 0.000000 0.000000 \n",
"3393 0.000000 0.000631 \n",
"3394 0.000457 0.000895 \n",
"\n",
"[3395 rows x 20 columns]"
]
},
"execution_count": 49,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df[df['TotalHours'].between(0, 5000)]"
]
},
{
"cell_type": "code",
"execution_count": 62,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"328"
]
},
"execution_count": 62,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"sum(df['TotalHours'] == 500)"
]
},
{
"cell_type": "code",
"execution_count": 72,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"((57, 20), (328, 20))"
]
},
"execution_count": 72,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df['TotalHours'] = df['TotalHours'].replace('?','-1')\n",
"df['TotalHours'] = df['TotalHours'].astype(int)\n",
"# df.dtypes\n",
"# df['TotalHours'] = df['TotalHours'].replace(-1, 500)\n",
"df[df['TotalHours'] == -1].shape, df[df['TotalHours'] == 500].shape"
]
},
{
"cell_type": "code",
"execution_count": 78,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"((0, 20), (385, 20))"
]
},
"execution_count": 78,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"new_df = df\n",
"new_df['TotalHours'] = new_df['TotalHours'].replace(-1, 500)\n",
"new_df[new_df['TotalHours'] == -1].shape, new_df[new_df['TotalHours'] == 500].shape"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": 111,
"metadata": {
"scrolled": true
},
"outputs": [
{
"data": {
"text/plain": [
"[(1, 'Federation'), (2, 'Romulan'), (3, 'Ferengi'), (4, 'Vulcan'), (5, 'Borg')]"
]
},
"execution_count": 111,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"index = [1,2,3,4,5]\n",
"labels = [\"Federation\", \"Romulan\", \"Ferengi\", \"Vulcan\", \"Borg\"]\n",
"\n",
"list(zip(index, labels))"
]
},
{
"cell_type": "code",
"execution_count": 113,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['Federation', 'Romulan', 'Ferengi', 'Vulcan', 'Borg']"
]
},
"execution_count": 113,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"[labels[i-1] for i in index]"
]
},
{
"cell_type": "code",
"execution_count": 109,
"metadata": {},
"outputs": [],
"source": [
"# def convert_qmarks_to_avg(my_df, col_name):\n",
"def convert_qmarks_to_avg(my_df):\n",
" my_df = my_df.replace('?','-1')\n",
" my_df = my_df.astype(int)\n",
" col_avg = np.median(my_df)\n",
" my_df = my_df.replace(-1, col_avg)\n",
" return my_df\n",
" \n",
"df2 = df.copy()\n",
"df2[['TotalHours', 'Age', 'HoursPerWeek']].apply(convert_qmarks_to_avg)\n",
"\n",
"# convert_qmarks_to_avg(df2, 'TotalHours')\n",
"# df2[df2['TotalHours'] == -1].shape, df2[df2['TotalHours'] == 500].shape"
]
},
{
"cell_type": "code",
"execution_count": 110,
"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>TotalHours</th>\n",
" <th>Age</th>\n",
" <th>HoursPerWeek</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>3000</td>\n",
" <td>27</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5000</td>\n",
" <td>23</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>200</td>\n",
" <td>30</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>400</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>500</td>\n",
" <td>32</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>70</td>\n",
" <td>27</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>240</td>\n",
" <td>21</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>10000</td>\n",
" <td>17</td>\n",
" <td>42</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>2708</td>\n",
" <td>20</td>\n",
" <td>14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>800</td>\n",
" <td>18</td>\n",
" <td>24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>6000</td>\n",
" <td>16</td>\n",
" <td>16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>190</td>\n",
" <td>26</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>350</td>\n",
" <td>18</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>1000</td>\n",
" <td>38</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>5000</td>\n",
" <td>16</td>\n",
" <td>30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>1500</td>\n",
" <td>17</td>\n",
" <td>16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>2000</td>\n",
" <td>28</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>120</td>\n",
" <td>20</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>350</td>\n",
" <td>16</td>\n",
" <td>14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>1100</td>\n",
" <td>26</td>\n",
" <td>28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>800</td>\n",
" <td>21</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>800</td>\n",
" <td>18</td>\n",
" <td>20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>500</td>\n",
" <td>26</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>500</td>\n",
" <td>17</td>\n",
" <td>14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>800</td>\n",
" <td>23</td>\n",
" <td>20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>2520</td>\n",
" <td>18</td>\n",
" <td>70</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>800</td>\n",
" <td>25</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>700</td>\n",
" <td>25</td>\n",
" <td>20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>160</td>\n",
" <td>18</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3365</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3366</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3367</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3368</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3369</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3370</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3371</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3372</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3373</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3374</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3375</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3376</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3377</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3378</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3379</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3380</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3381</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3382</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3383</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3384</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3385</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3386</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3387</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3388</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3389</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3390</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3391</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3392</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3393</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3394</th>\n",
" <td>500</td>\n",
" <td>21</td>\n",
" <td>12</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>3395 rows × 3 columns</p>\n",
"</div>"
],
"text/plain": [
" TotalHours Age HoursPerWeek\n",
"0 3000 27 10\n",
"1 5000 23 10\n",
"2 200 30 10\n",
"3 400 19 20\n",
"4 500 32 10\n",
"5 70 27 6\n",
"6 240 21 8\n",
"7 10000 17 42\n",
"8 2708 20 14\n",
"9 800 18 24\n",
"10 6000 16 16\n",
"11 190 26 4\n",
"12 350 18 12\n",
"13 1000 38 6\n",
"14 5000 16 30\n",
"15 1500 17 16\n",
"16 2000 28 8\n",
"17 120 20 10\n",
"18 350 16 14\n",
"19 1100 26 28\n",
"20 800 21 10\n",
"21 500 21 6\n",
"22 800 18 20\n",
"23 500 26 10\n",
"24 500 17 14\n",
"25 800 23 20\n",
"26 2520 18 70\n",
"27 800 25 6\n",
"28 700 25 20\n",
"29 160 18 10\n",
"... ... ... ...\n",
"3365 500 21 12\n",
"3366 500 21 12\n",
"3367 500 21 12\n",
"3368 500 21 12\n",
"3369 500 21 12\n",
"3370 500 21 12\n",
"3371 500 21 12\n",
"3372 500 21 12\n",
"3373 500 21 12\n",
"3374 500 21 12\n",
"3375 500 21 12\n",
"3376 500 21 12\n",
"3377 500 21 12\n",
"3378 500 21 12\n",
"3379 500 21 12\n",
"3380 500 21 12\n",
"3381 500 21 12\n",
"3382 500 21 12\n",
"3383 500 21 12\n",
"3384 500 21 12\n",
"3385 500 21 12\n",
"3386 500 21 12\n",
"3387 500 21 12\n",
"3388 500 21 12\n",
"3389 500 21 12\n",
"3390 500 21 12\n",
"3391 500 21 12\n",
"3392 500 21 12\n",
"3393 500 21 12\n",
"3394 500 21 12\n",
"\n",
"[3395 rows x 3 columns]"
]
},
"execution_count": 110,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# df2['Age'] = df2['Age'].astype(int)\n",
"# df2['HoursPerWeek'] = df2['HoursPerWeek'].astype(int)\n",
"df2[['TotalHours', 'Age', 'HoursPerWeek']].apply(convert_qmarks_to_avg)"
]
},
{
"cell_type": "code",
"execution_count": 114,
"metadata": {},
"outputs": [],
"source": [
"#Dictionary for all the values with award categories\n",
"awards = {}\n",
"awards[1]= 'Bronze'\n",
"awards[2]= 'Silver'\n",
"awards[3]= 'Gold'\n",
"awards[4]= 'Platinum'\n",
"awards[5]= 'Diamond'\n",
"awards[6]= 'Master'\n",
"awards[7]= 'GrandMaster'\n",
"awards[8]= 'Professional Leagues'\n",
"\n",
"#Create new feature\n",
"df2[\"Category\"] = df2[\"LeagueIndex\"].map(awards)"
]
},
{
"cell_type": "code",
"execution_count": 117,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Platinum 811\n",
"Diamond 806\n",
"Master 621\n",
"Gold 553\n",
"Silver 347\n",
"Bronze 167\n",
"Professional Leagues 55\n",
"GrandMaster 35\n",
"Name: Category, dtype: int64"
]
},
"execution_count": 117,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df2[\"Category\"].value_counts()"
]
},
{
"cell_type": "code",
"execution_count": 118,
"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>LeagueIndex</th>\n",
" <th>Age</th>\n",
" <th>HoursPerWeek</th>\n",
" <th>TotalHours</th>\n",
" <th>APM</th>\n",
" <th>SelectByHotkeys</th>\n",
" <th>AssignToHotkeys</th>\n",
" <th>UniqueHotkeys</th>\n",
" <th>MinimapAttacks</th>\n",
" <th>...</th>\n",
" <th>NumberOfPACs</th>\n",
" <th>GapBetweenPACs</th>\n",
" <th>ActionLatency</th>\n",
" <th>ActionsInPAC</th>\n",
" <th>TotalMapExplored</th>\n",
" <th>WorkersMade</th>\n",
" <th>UniqueUnitsMade</th>\n",
" <th>ComplexUnitsMade</th>\n",
" <th>ComplexAbilitiesUsed</th>\n",
" <th>Category</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>52</td>\n",
" <td>5</td>\n",
" <td>27</td>\n",
" <td>10</td>\n",
" <td>3000</td>\n",
" <td>143.7180</td>\n",
" <td>0.003515</td>\n",
" <td>0.000220</td>\n",
" <td>7</td>\n",
" <td>0.000110</td>\n",
" <td>...</td>\n",
" <td>0.004849</td>\n",
" <td>32.6677</td>\n",
" <td>40.8673</td>\n",
" <td>4.7508</td>\n",
" <td>28</td>\n",
" <td>0.001397</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Diamond</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>55</td>\n",
" <td>5</td>\n",
" <td>23</td>\n",
" <td>10</td>\n",
" <td>5000</td>\n",
" <td>129.2322</td>\n",
" <td>0.003304</td>\n",
" <td>0.000259</td>\n",
" <td>4</td>\n",
" <td>0.000294</td>\n",
" <td>...</td>\n",
" <td>0.004307</td>\n",
" <td>32.9194</td>\n",
" <td>42.3454</td>\n",
" <td>4.8434</td>\n",
" <td>22</td>\n",
" <td>0.001194</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000208</td>\n",
" <td>Diamond</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>56</td>\n",
" <td>4</td>\n",
" <td>30</td>\n",
" <td>10</td>\n",
" <td>200</td>\n",
" <td>69.9612</td>\n",
" <td>0.001101</td>\n",
" <td>0.000336</td>\n",
" <td>4</td>\n",
" <td>0.000294</td>\n",
" <td>...</td>\n",
" <td>0.002926</td>\n",
" <td>44.6475</td>\n",
" <td>75.3548</td>\n",
" <td>4.0430</td>\n",
" <td>22</td>\n",
" <td>0.000745</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000189</td>\n",
" <td>Platinum</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>57</td>\n",
" <td>3</td>\n",
" <td>19</td>\n",
" <td>20</td>\n",
" <td>400</td>\n",
" <td>107.6016</td>\n",
" <td>0.001034</td>\n",
" <td>0.000213</td>\n",
" <td>1</td>\n",
" <td>0.000053</td>\n",
" <td>...</td>\n",
" <td>0.003783</td>\n",
" <td>29.2203</td>\n",
" <td>53.7352</td>\n",
" <td>4.9155</td>\n",
" <td>19</td>\n",
" <td>0.000426</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000384</td>\n",
" <td>Gold</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>58</td>\n",
" <td>3</td>\n",
" <td>32</td>\n",
" <td>10</td>\n",
" <td>500</td>\n",
" <td>122.8908</td>\n",
" <td>0.001136</td>\n",
" <td>0.000327</td>\n",
" <td>2</td>\n",
" <td>0.000000</td>\n",
" <td>...</td>\n",
" <td>0.002368</td>\n",
" <td>22.6885</td>\n",
" <td>62.0813</td>\n",
" <td>9.3740</td>\n",
" <td>15</td>\n",
" <td>0.001174</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>0.000019</td>\n",
" <td>Gold</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>60</td>\n",
" <td>2</td>\n",
" <td>27</td>\n",
" <td>6</td>\n",
" <td>70</td>\n",
" <td>44.4570</td>\n",
" <td>0.000978</td>\n",
" <td>0.000255</td>\n",
" <td>2</td>\n",
" <td>0.000000</td>\n",
" <td>...</td>\n",
" <td>0.002425</td>\n",
" <td>76.4405</td>\n",
" <td>98.7719</td>\n",
" <td>3.0965</td>\n",
" <td>16</td>\n",
" <td>0.000372</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Silver</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>61</td>\n",
" <td>1</td>\n",
" <td>21</td>\n",
" <td>8</td>\n",
" <td>240</td>\n",
" <td>46.9962</td>\n",
" <td>0.000820</td>\n",
" <td>0.000169</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>...</td>\n",
" <td>0.001988</td>\n",
" <td>94.0227</td>\n",
" <td>90.5311</td>\n",
" <td>4.1017</td>\n",
" <td>15</td>\n",
" <td>0.000573</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Bronze</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>72</td>\n",
" <td>7</td>\n",
" <td>17</td>\n",
" <td>42</td>\n",
" <td>10000</td>\n",
" <td>212.6022</td>\n",
" <td>0.009040</td>\n",
" <td>0.000676</td>\n",
" <td>6</td>\n",
" <td>0.001164</td>\n",
" <td>...</td>\n",
" <td>0.004952</td>\n",
" <td>24.6117</td>\n",
" <td>41.7671</td>\n",
" <td>6.6104</td>\n",
" <td>45</td>\n",
" <td>0.002277</td>\n",
" <td>9</td>\n",
" <td>0.000129</td>\n",
" <td>0.000249</td>\n",
" <td>GrandMaster</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>77</td>\n",
" <td>4</td>\n",
" <td>20</td>\n",
" <td>14</td>\n",
" <td>2708</td>\n",
" <td>117.4884</td>\n",
" <td>0.002944</td>\n",
" <td>0.000527</td>\n",
" <td>2</td>\n",
" <td>0.000019</td>\n",
" <td>...</td>\n",
" <td>0.005399</td>\n",
" <td>52.0140</td>\n",
" <td>46.4321</td>\n",
" <td>3.3746</td>\n",
" <td>29</td>\n",
" <td>0.001035</td>\n",
" <td>7</td>\n",
" <td>0.000273</td>\n",
" <td>0.000470</td>\n",
" <td>Platinum</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>81</td>\n",
" <td>4</td>\n",
" <td>18</td>\n",
" <td>24</td>\n",
" <td>800</td>\n",
" <td>155.9856</td>\n",
" <td>0.005054</td>\n",
" <td>0.000524</td>\n",
" <td>8</td>\n",
" <td>0.000025</td>\n",
" <td>...</td>\n",
" <td>0.003569</td>\n",
" <td>24.4632</td>\n",
" <td>52.1538</td>\n",
" <td>6.5664</td>\n",
" <td>27</td>\n",
" <td>0.001310</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Platinum</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>83</td>\n",
" <td>3</td>\n",
" <td>16</td>\n",
" <td>16</td>\n",
" <td>6000</td>\n",
" <td>153.8010</td>\n",
" <td>0.001677</td>\n",
" <td>0.000319</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>...</td>\n",
" <td>0.003772</td>\n",
" <td>23.4107</td>\n",
" <td>48.0711</td>\n",
" <td>7.0044</td>\n",
" <td>24</td>\n",
" <td>0.001593</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000017</td>\n",
" <td>Gold</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>93</td>\n",
" <td>4</td>\n",
" <td>26</td>\n",
" <td>4</td>\n",
" <td>190</td>\n",
" <td>79.2948</td>\n",
" <td>0.000379</td>\n",
" <td>0.000255</td>\n",
" <td>3</td>\n",
" <td>0.000016</td>\n",
" <td>...</td>\n",
" <td>0.003555</td>\n",
" <td>39.6381</td>\n",
" <td>65.5000</td>\n",
" <td>4.2269</td>\n",
" <td>19</td>\n",
" <td>0.000757</td>\n",
" <td>7</td>\n",
" <td>0.000107</td>\n",
" <td>0.000263</td>\n",
" <td>Platinum</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>97</td>\n",
" <td>3</td>\n",
" <td>18</td>\n",
" <td>12</td>\n",
" <td>350</td>\n",
" <td>67.4754</td>\n",
" <td>0.000423</td>\n",
" <td>0.000169</td>\n",
" <td>1</td>\n",
" <td>0.000024</td>\n",
" <td>...</td>\n",
" <td>0.002885</td>\n",
" <td>42.4370</td>\n",
" <td>68.0502</td>\n",
" <td>4.3222</td>\n",
" <td>16</td>\n",
" <td>0.000748</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000435</td>\n",
" <td>Gold</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>98</td>\n",
" <td>3</td>\n",
" <td>38</td>\n",
" <td>6</td>\n",
" <td>1000</td>\n",
" <td>119.4366</td>\n",
" <td>0.004952</td>\n",
" <td>0.000052</td>\n",
" <td>2</td>\n",
" <td>0.000087</td>\n",
" <td>...</td>\n",
" <td>0.002728</td>\n",
" <td>54.8718</td>\n",
" <td>79.2102</td>\n",
" <td>6.2293</td>\n",
" <td>21</td>\n",
" <td>0.001494</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Gold</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>100</td>\n",
" <td>5</td>\n",
" <td>16</td>\n",
" <td>30</td>\n",
" <td>5000</td>\n",
" <td>160.4754</td>\n",
" <td>0.004254</td>\n",
" <td>0.000432</td>\n",
" <td>2</td>\n",
" <td>0.000775</td>\n",
" <td>...</td>\n",
" <td>0.004571</td>\n",
" <td>36.2897</td>\n",
" <td>46.8889</td>\n",
" <td>5.4361</td>\n",
" <td>28</td>\n",
" <td>0.001981</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Diamond</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>102</td>\n",
" <td>5</td>\n",
" <td>17</td>\n",
" <td>16</td>\n",
" <td>1500</td>\n",
" <td>81.7722</td>\n",
" <td>0.002333</td>\n",
" <td>0.000430</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>...</td>\n",
" <td>0.002900</td>\n",
" <td>45.1654</td>\n",
" <td>64.7500</td>\n",
" <td>4.5312</td>\n",
" <td>15</td>\n",
" <td>0.001246</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000227</td>\n",
" <td>Diamond</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>105</td>\n",
" <td>4</td>\n",
" <td>28</td>\n",
" <td>8</td>\n",
" <td>2000</td>\n",
" <td>50.8374</td>\n",
" <td>0.000664</td>\n",
" <td>0.000221</td>\n",
" <td>1</td>\n",
" <td>0.000018</td>\n",
" <td>...</td>\n",
" <td>0.002656</td>\n",
" <td>45.7902</td>\n",
" <td>76.8889</td>\n",
" <td>3.5000</td>\n",
" <td>13</td>\n",
" <td>0.000664</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000295</td>\n",
" <td>Platinum</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>106</td>\n",
" <td>5</td>\n",
" <td>20</td>\n",
" <td>10</td>\n",
" <td>120</td>\n",
" <td>160.6464</td>\n",
" <td>0.003430</td>\n",
" <td>0.000634</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>...</td>\n",
" <td>0.005535</td>\n",
" <td>28.3636</td>\n",
" <td>37.7947</td>\n",
" <td>4.7671</td>\n",
" <td>29</td>\n",
" <td>0.002768</td>\n",
" <td>10</td>\n",
" <td>0.000087</td>\n",
" <td>0.000102</td>\n",
" <td>Diamond</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>118</td>\n",
" <td>5</td>\n",
" <td>16</td>\n",
" <td>14</td>\n",
" <td>350</td>\n",
" <td>107.9118</td>\n",
" <td>0.006701</td>\n",
" <td>0.000706</td>\n",
" <td>5</td>\n",
" <td>0.000013</td>\n",
" <td>...</td>\n",
" <td>0.003237</td>\n",
" <td>67.0744</td>\n",
" <td>71.3251</td>\n",
" <td>4.3786</td>\n",
" <td>27</td>\n",
" <td>0.001332</td>\n",
" <td>9</td>\n",
" <td>0.000240</td>\n",
" <td>0.000000</td>\n",
" <td>Diamond</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>127</td>\n",
" <td>4</td>\n",
" <td>26</td>\n",
" <td>28</td>\n",
" <td>1100</td>\n",
" <td>114.7806</td>\n",
" <td>0.002630</td>\n",
" <td>0.000287</td>\n",
" <td>5</td>\n",
" <td>0.000244</td>\n",
" <td>...</td>\n",
" <td>0.003650</td>\n",
" <td>40.4427</td>\n",
" <td>59.9370</td>\n",
" <td>4.9961</td>\n",
" <td>16</td>\n",
" <td>0.001581</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Platinum</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>132</td>\n",
" <td>5</td>\n",
" <td>21</td>\n",
" <td>10</td>\n",
" <td>800</td>\n",
" <td>115.1274</td>\n",
" <td>0.002651</td>\n",
" <td>0.000660</td>\n",
" <td>8</td>\n",
" <td>0.000099</td>\n",
" <td>...</td>\n",
" <td>0.004147</td>\n",
" <td>30.7660</td>\n",
" <td>49.4854</td>\n",
" <td>4.6790</td>\n",
" <td>30</td>\n",
" <td>0.000825</td>\n",
" <td>8</td>\n",
" <td>0.000000</td>\n",
" <td>0.000517</td>\n",
" <td>Diamond</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>138</td>\n",
" <td>6</td>\n",
" <td>21</td>\n",
" <td>6</td>\n",
" <td>500</td>\n",
" <td>133.7016</td>\n",
" <td>0.004500</td>\n",
" <td>0.000420</td>\n",
" <td>3</td>\n",
" <td>0.000019</td>\n",
" <td>...</td>\n",
" <td>0.003874</td>\n",
" <td>21.4686</td>\n",
" <td>50.5253</td>\n",
" <td>5.4892</td>\n",
" <td>29</td>\n",
" <td>0.001008</td>\n",
" <td>10</td>\n",
" <td>0.000000</td>\n",
" <td>0.000560</td>\n",
" <td>Master</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>139</td>\n",
" <td>5</td>\n",
" <td>18</td>\n",
" <td>20</td>\n",
" <td>800</td>\n",
" <td>99.5088</td>\n",
" <td>0.000734</td>\n",
" <td>0.000108</td>\n",
" <td>1</td>\n",
" <td>0.000024</td>\n",
" <td>...</td>\n",
" <td>0.002695</td>\n",
" <td>22.7265</td>\n",
" <td>68.7321</td>\n",
" <td>6.7054</td>\n",
" <td>23</td>\n",
" <td>0.001961</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Diamond</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>140</td>\n",
" <td>5</td>\n",
" <td>26</td>\n",
" <td>10</td>\n",
" <td>500</td>\n",
" <td>83.9172</td>\n",
" <td>0.002854</td>\n",
" <td>0.000493</td>\n",
" <td>3</td>\n",
" <td>0.000000</td>\n",
" <td>...</td>\n",
" <td>0.004607</td>\n",
" <td>51.2082</td>\n",
" <td>52.0494</td>\n",
" <td>2.8663</td>\n",
" <td>31</td>\n",
" <td>0.000654</td>\n",
" <td>9</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Diamond</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>141</td>\n",
" <td>4</td>\n",
" <td>17</td>\n",
" <td>14</td>\n",
" <td>500</td>\n",
" <td>216.6936</td>\n",
" <td>0.012495</td>\n",
" <td>0.000482</td>\n",
" <td>4</td>\n",
" <td>0.000054</td>\n",
" <td>...</td>\n",
" <td>0.004334</td>\n",
" <td>27.9255</td>\n",
" <td>45.1605</td>\n",
" <td>6.3395</td>\n",
" <td>18</td>\n",
" <td>0.001204</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Platinum</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>142</td>\n",
" <td>4</td>\n",
" <td>23</td>\n",
" <td>20</td>\n",
" <td>800</td>\n",
" <td>129.8598</td>\n",
" <td>0.002315</td>\n",
" <td>0.000334</td>\n",
" <td>5</td>\n",
" <td>0.000078</td>\n",
" <td>...</td>\n",
" <td>0.003473</td>\n",
" <td>36.3934</td>\n",
" <td>57.5215</td>\n",
" <td>6.7587</td>\n",
" <td>36</td>\n",
" <td>0.000753</td>\n",
" <td>11</td>\n",
" <td>0.000284</td>\n",
" <td>0.001229</td>\n",
" <td>Platinum</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>144</td>\n",
" <td>6</td>\n",
" <td>18</td>\n",
" <td>70</td>\n",
" <td>2520</td>\n",
" <td>267.5586</td>\n",
" <td>0.027815</td>\n",
" <td>0.000708</td>\n",
" <td>10</td>\n",
" <td>0.000000</td>\n",
" <td>...</td>\n",
" <td>0.005616</td>\n",
" <td>34.6035</td>\n",
" <td>40.6025</td>\n",
" <td>4.1629</td>\n",
" <td>36</td>\n",
" <td>0.000856</td>\n",
" <td>12</td>\n",
" <td>0.000089</td>\n",
" <td>0.000197</td>\n",
" <td>Master</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>149</td>\n",
" <td>5</td>\n",
" <td>25</td>\n",
" <td>6</td>\n",
" <td>800</td>\n",
" <td>74.1174</td>\n",
" <td>0.000875</td>\n",
" <td>0.000205</td>\n",
" <td>6</td>\n",
" <td>0.000018</td>\n",
" <td>...</td>\n",
" <td>0.003518</td>\n",
" <td>46.4122</td>\n",
" <td>71.8173</td>\n",
" <td>3.7944</td>\n",
" <td>34</td>\n",
" <td>0.000929</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Diamond</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>154</td>\n",
" <td>5</td>\n",
" <td>25</td>\n",
" <td>20</td>\n",
" <td>700</td>\n",
" <td>101.6796</td>\n",
" <td>0.001406</td>\n",
" <td>0.000427</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>...</td>\n",
" <td>0.003453</td>\n",
" <td>26.7979</td>\n",
" <td>54.5979</td>\n",
" <td>5.3144</td>\n",
" <td>22</td>\n",
" <td>0.001032</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>0.000570</td>\n",
" <td>Diamond</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>158</td>\n",
" <td>6</td>\n",
" <td>18</td>\n",
" <td>10</td>\n",
" <td>160</td>\n",
" <td>150.5004</td>\n",
" <td>0.005667</td>\n",
" <td>0.000632</td>\n",
" <td>6</td>\n",
" <td>0.000376</td>\n",
" <td>...</td>\n",
" <td>0.004626</td>\n",
" <td>30.2222</td>\n",
" <td>45.5941</td>\n",
" <td>4.9077</td>\n",
" <td>14</td>\n",
" <td>0.001007</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Master</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>3365</th>\n",
" <td>10050</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>211.9188</td>\n",
" <td>0.019817</td>\n",
" <td>0.000633</td>\n",
" <td>4</td>\n",
" <td>0.000201</td>\n",
" <td>...</td>\n",
" <td>0.003912</td>\n",
" <td>31.8222</td>\n",
" <td>54.5588</td>\n",
" <td>5.0294</td>\n",
" <td>14</td>\n",
" <td>0.001409</td>\n",
" <td>3</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3366</th>\n",
" <td>10051</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>269.8998</td>\n",
" <td>0.024645</td>\n",
" <td>0.000642</td>\n",
" <td>10</td>\n",
" <td>0.000415</td>\n",
" <td>...</td>\n",
" <td>0.004015</td>\n",
" <td>25.6352</td>\n",
" <td>43.3856</td>\n",
" <td>6.4922</td>\n",
" <td>21</td>\n",
" <td>0.000478</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000579</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3367</th>\n",
" <td>10052</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>190.2396</td>\n",
" <td>0.008720</td>\n",
" <td>0.000879</td>\n",
" <td>10</td>\n",
" <td>0.000171</td>\n",
" <td>...</td>\n",
" <td>0.004971</td>\n",
" <td>17.9901</td>\n",
" <td>35.9509</td>\n",
" <td>5.5872</td>\n",
" <td>21</td>\n",
" <td>0.000904</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3368</th>\n",
" <td>10055</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>212.4972</td>\n",
" <td>0.014917</td>\n",
" <td>0.000767</td>\n",
" <td>10</td>\n",
" <td>0.000599</td>\n",
" <td>...</td>\n",
" <td>0.005648</td>\n",
" <td>21.6687</td>\n",
" <td>41.2231</td>\n",
" <td>4.4680</td>\n",
" <td>28</td>\n",
" <td>0.001119</td>\n",
" <td>9</td>\n",
" <td>0.000035</td>\n",
" <td>0.000062</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3369</th>\n",
" <td>10059</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>219.3894</td>\n",
" <td>0.005926</td>\n",
" <td>0.000741</td>\n",
" <td>6</td>\n",
" <td>0.000440</td>\n",
" <td>...</td>\n",
" <td>0.005185</td>\n",
" <td>17.0456</td>\n",
" <td>30.5342</td>\n",
" <td>6.6749</td>\n",
" <td>35</td>\n",
" <td>0.002072</td>\n",
" <td>9</td>\n",
" <td>0.000225</td>\n",
" <td>0.000064</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3370</th>\n",
" <td>10060</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>230.6694</td>\n",
" <td>0.010383</td>\n",
" <td>0.001242</td>\n",
" <td>10</td>\n",
" <td>0.000375</td>\n",
" <td>...</td>\n",
" <td>0.006375</td>\n",
" <td>13.5028</td>\n",
" <td>31.4044</td>\n",
" <td>5.0533</td>\n",
" <td>32</td>\n",
" <td>0.001512</td>\n",
" <td>6</td>\n",
" <td>0.000035</td>\n",
" <td>0.000047</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3371</th>\n",
" <td>10061</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>284.2296</td>\n",
" <td>0.016069</td>\n",
" <td>0.000711</td>\n",
" <td>9</td>\n",
" <td>0.000355</td>\n",
" <td>...</td>\n",
" <td>0.006680</td>\n",
" <td>9.4756</td>\n",
" <td>29.6851</td>\n",
" <td>5.3326</td>\n",
" <td>25</td>\n",
" <td>0.002459</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3372</th>\n",
" <td>10062</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>355.3518</td>\n",
" <td>0.037526</td>\n",
" <td>0.000600</td>\n",
" <td>7</td>\n",
" <td>0.001242</td>\n",
" <td>...</td>\n",
" <td>0.004541</td>\n",
" <td>9.2871</td>\n",
" <td>41.9497</td>\n",
" <td>6.5063</td>\n",
" <td>22</td>\n",
" <td>0.001228</td>\n",
" <td>8</td>\n",
" <td>0.000000</td>\n",
" <td>0.000614</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3373</th>\n",
" <td>10063</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>364.8504</td>\n",
" <td>0.042576</td>\n",
" <td>0.000996</td>\n",
" <td>8</td>\n",
" <td>0.000176</td>\n",
" <td>...</td>\n",
" <td>0.004687</td>\n",
" <td>19.9499</td>\n",
" <td>41.1417</td>\n",
" <td>5.6167</td>\n",
" <td>18</td>\n",
" <td>0.000674</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3374</th>\n",
" <td>10064</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>256.5888</td>\n",
" <td>0.019592</td>\n",
" <td>0.000580</td>\n",
" <td>8</td>\n",
" <td>0.000416</td>\n",
" <td>...</td>\n",
" <td>0.005812</td>\n",
" <td>17.0462</td>\n",
" <td>34.3734</td>\n",
" <td>5.0563</td>\n",
" <td>19</td>\n",
" <td>0.001308</td>\n",
" <td>7</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3375</th>\n",
" <td>10065</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>248.4012</td>\n",
" <td>0.016018</td>\n",
" <td>0.000874</td>\n",
" <td>9</td>\n",
" <td>0.000388</td>\n",
" <td>...</td>\n",
" <td>0.005987</td>\n",
" <td>16.3144</td>\n",
" <td>30.2486</td>\n",
" <td>5.0973</td>\n",
" <td>21</td>\n",
" <td>0.001197</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3376</th>\n",
" <td>10066</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>251.2284</td>\n",
" <td>0.022910</td>\n",
" <td>0.000946</td>\n",
" <td>5</td>\n",
" <td>0.001097</td>\n",
" <td>...</td>\n",
" <td>0.005411</td>\n",
" <td>13.7404</td>\n",
" <td>35.7203</td>\n",
" <td>4.5524</td>\n",
" <td>22</td>\n",
" <td>0.000738</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000662</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3377</th>\n",
" <td>10067</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>318.3000</td>\n",
" <td>0.034851</td>\n",
" <td>0.000933</td>\n",
" <td>7</td>\n",
" <td>0.000187</td>\n",
" <td>...</td>\n",
" <td>0.005225</td>\n",
" <td>26.0987</td>\n",
" <td>32.4464</td>\n",
" <td>4.8705</td>\n",
" <td>13</td>\n",
" <td>0.000933</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>0.000233</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3378</th>\n",
" <td>10068</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>288.9198</td>\n",
" <td>0.029322</td>\n",
" <td>0.001569</td>\n",
" <td>6</td>\n",
" <td>0.000118</td>\n",
" <td>...</td>\n",
" <td>0.005213</td>\n",
" <td>23.2857</td>\n",
" <td>32.8026</td>\n",
" <td>4.7540</td>\n",
" <td>24</td>\n",
" <td>0.001130</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3379</th>\n",
" <td>10069</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>313.9080</td>\n",
" <td>0.019537</td>\n",
" <td>0.001214</td>\n",
" <td>4</td>\n",
" <td>0.000318</td>\n",
" <td>...</td>\n",
" <td>0.005879</td>\n",
" <td>8.1642</td>\n",
" <td>26.0918</td>\n",
" <td>6.7885</td>\n",
" <td>26</td>\n",
" <td>0.001321</td>\n",
" <td>8</td>\n",
" <td>0.000106</td>\n",
" <td>0.000443</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3380</th>\n",
" <td>10072</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>243.7134</td>\n",
" <td>0.017195</td>\n",
" <td>0.000711</td>\n",
" <td>6</td>\n",
" <td>0.000666</td>\n",
" <td>...</td>\n",
" <td>0.005594</td>\n",
" <td>21.8795</td>\n",
" <td>30.5722</td>\n",
" <td>5.1136</td>\n",
" <td>25</td>\n",
" <td>0.000576</td>\n",
" <td>8</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3381</th>\n",
" <td>10073</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>312.9804</td>\n",
" <td>0.026327</td>\n",
" <td>0.000266</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>...</td>\n",
" <td>0.005053</td>\n",
" <td>14.6118</td>\n",
" <td>30.7836</td>\n",
" <td>6.1930</td>\n",
" <td>10</td>\n",
" <td>0.001802</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>0.000030</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3382</th>\n",
" <td>10074</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>313.5762</td>\n",
" <td>0.030550</td>\n",
" <td>0.000560</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>...</td>\n",
" <td>0.004390</td>\n",
" <td>19.5405</td>\n",
" <td>35.4094</td>\n",
" <td>6.4228</td>\n",
" <td>12</td>\n",
" <td>0.001296</td>\n",
" <td>3</td>\n",
" <td>0.000000</td>\n",
" <td>0.000059</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3383</th>\n",
" <td>10075</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>274.6194</td>\n",
" <td>0.022497</td>\n",
" <td>0.000707</td>\n",
" <td>6</td>\n",
" <td>0.000163</td>\n",
" <td>...</td>\n",
" <td>0.004053</td>\n",
" <td>20.6757</td>\n",
" <td>32.7785</td>\n",
" <td>6.9262</td>\n",
" <td>15</td>\n",
" <td>0.000626</td>\n",
" <td>3</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3384</th>\n",
" <td>10076</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>225.0678</td>\n",
" <td>0.014339</td>\n",
" <td>0.001627</td>\n",
" <td>7</td>\n",
" <td>0.000291</td>\n",
" <td>...</td>\n",
" <td>0.005281</td>\n",
" <td>16.3502</td>\n",
" <td>33.2874</td>\n",
" <td>5.4713</td>\n",
" <td>26</td>\n",
" <td>0.000898</td>\n",
" <td>8</td>\n",
" <td>0.000000</td>\n",
" <td>0.000959</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3385</th>\n",
" <td>10079</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>254.2188</td>\n",
" <td>0.016608</td>\n",
" <td>0.000788</td>\n",
" <td>6</td>\n",
" <td>0.000926</td>\n",
" <td>...</td>\n",
" <td>0.005408</td>\n",
" <td>14.9191</td>\n",
" <td>35.9921</td>\n",
" <td>5.7205</td>\n",
" <td>28</td>\n",
" <td>0.001128</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3386</th>\n",
" <td>10081</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>339.1524</td>\n",
" <td>0.033058</td>\n",
" <td>0.001017</td>\n",
" <td>10</td>\n",
" <td>0.000477</td>\n",
" <td>...</td>\n",
" <td>0.004609</td>\n",
" <td>21.6389</td>\n",
" <td>37.1862</td>\n",
" <td>6.7103</td>\n",
" <td>16</td>\n",
" <td>0.001049</td>\n",
" <td>3</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3387</th>\n",
" <td>10082</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>310.0416</td>\n",
" <td>0.026873</td>\n",
" <td>0.001278</td>\n",
" <td>10</td>\n",
" <td>0.000319</td>\n",
" <td>...</td>\n",
" <td>0.005517</td>\n",
" <td>16.5446</td>\n",
" <td>33.8174</td>\n",
" <td>5.7350</td>\n",
" <td>22</td>\n",
" <td>0.000922</td>\n",
" <td>8</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3388</th>\n",
" <td>10083</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>288.7608</td>\n",
" <td>0.024022</td>\n",
" <td>0.000628</td>\n",
" <td>6</td>\n",
" <td>0.000350</td>\n",
" <td>...</td>\n",
" <td>0.005580</td>\n",
" <td>19.0108</td>\n",
" <td>30.0866</td>\n",
" <td>5.3831</td>\n",
" <td>30</td>\n",
" <td>0.000761</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000652</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3389</th>\n",
" <td>10084</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>151.4046</td>\n",
" <td>0.009732</td>\n",
" <td>0.000949</td>\n",
" <td>6</td>\n",
" <td>0.000028</td>\n",
" <td>...</td>\n",
" <td>0.004363</td>\n",
" <td>27.4658</td>\n",
" <td>43.8052</td>\n",
" <td>4.3312</td>\n",
" <td>23</td>\n",
" <td>0.000949</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000099</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3390</th>\n",
" <td>10089</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>259.6296</td>\n",
" <td>0.020425</td>\n",
" <td>0.000743</td>\n",
" <td>9</td>\n",
" <td>0.000621</td>\n",
" <td>...</td>\n",
" <td>0.004555</td>\n",
" <td>18.6059</td>\n",
" <td>42.8342</td>\n",
" <td>6.2754</td>\n",
" <td>46</td>\n",
" <td>0.000877</td>\n",
" <td>5</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3391</th>\n",
" <td>10090</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>314.6700</td>\n",
" <td>0.028043</td>\n",
" <td>0.001157</td>\n",
" <td>10</td>\n",
" <td>0.000246</td>\n",
" <td>...</td>\n",
" <td>0.004259</td>\n",
" <td>14.3023</td>\n",
" <td>36.1156</td>\n",
" <td>7.1965</td>\n",
" <td>16</td>\n",
" <td>0.000788</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3392</th>\n",
" <td>10092</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>299.4282</td>\n",
" <td>0.028341</td>\n",
" <td>0.000860</td>\n",
" <td>7</td>\n",
" <td>0.000338</td>\n",
" <td>...</td>\n",
" <td>0.004439</td>\n",
" <td>12.4028</td>\n",
" <td>39.5156</td>\n",
" <td>6.3979</td>\n",
" <td>19</td>\n",
" <td>0.001260</td>\n",
" <td>4</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3393</th>\n",
" <td>10094</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>375.8664</td>\n",
" <td>0.036436</td>\n",
" <td>0.000594</td>\n",
" <td>5</td>\n",
" <td>0.000204</td>\n",
" <td>...</td>\n",
" <td>0.004346</td>\n",
" <td>11.6910</td>\n",
" <td>34.8547</td>\n",
" <td>7.9615</td>\n",
" <td>15</td>\n",
" <td>0.000613</td>\n",
" <td>6</td>\n",
" <td>0.000000</td>\n",
" <td>0.000631</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3394</th>\n",
" <td>10095</td>\n",
" <td>8</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>?</td>\n",
" <td>348.3576</td>\n",
" <td>0.029855</td>\n",
" <td>0.000811</td>\n",
" <td>4</td>\n",
" <td>0.000224</td>\n",
" <td>...</td>\n",
" <td>0.005566</td>\n",
" <td>20.0537</td>\n",
" <td>33.5142</td>\n",
" <td>6.3719</td>\n",
" <td>27</td>\n",
" <td>0.001566</td>\n",
" <td>7</td>\n",
" <td>0.000457</td>\n",
" <td>0.000895</td>\n",
" <td>Professional Leagues</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>3395 rows × 21 columns</p>\n",
"</div>"
],
"text/plain": [
" GameID LeagueIndex Age HoursPerWeek TotalHours APM \\\n",
"0 52 5 27 10 3000 143.7180 \n",
"1 55 5 23 10 5000 129.2322 \n",
"2 56 4 30 10 200 69.9612 \n",
"3 57 3 19 20 400 107.6016 \n",
"4 58 3 32 10 500 122.8908 \n",
"5 60 2 27 6 70 44.4570 \n",
"6 61 1 21 8 240 46.9962 \n",
"7 72 7 17 42 10000 212.6022 \n",
"8 77 4 20 14 2708 117.4884 \n",
"9 81 4 18 24 800 155.9856 \n",
"10 83 3 16 16 6000 153.8010 \n",
"11 93 4 26 4 190 79.2948 \n",
"12 97 3 18 12 350 67.4754 \n",
"13 98 3 38 6 1000 119.4366 \n",
"14 100 5 16 30 5000 160.4754 \n",
"15 102 5 17 16 1500 81.7722 \n",
"16 105 4 28 8 2000 50.8374 \n",
"17 106 5 20 10 120 160.6464 \n",
"18 118 5 16 14 350 107.9118 \n",
"19 127 4 26 28 1100 114.7806 \n",
"20 132 5 21 10 800 115.1274 \n",
"21 138 6 21 6 500 133.7016 \n",
"22 139 5 18 20 800 99.5088 \n",
"23 140 5 26 10 500 83.9172 \n",
"24 141 4 17 14 500 216.6936 \n",
"25 142 4 23 20 800 129.8598 \n",
"26 144 6 18 70 2520 267.5586 \n",
"27 149 5 25 6 800 74.1174 \n",
"28 154 5 25 20 700 101.6796 \n",
"29 158 6 18 10 160 150.5004 \n",
"... ... ... .. ... ... ... \n",
"3365 10050 8 ? ? ? 211.9188 \n",
"3366 10051 8 ? ? ? 269.8998 \n",
"3367 10052 8 ? ? ? 190.2396 \n",
"3368 10055 8 ? ? ? 212.4972 \n",
"3369 10059 8 ? ? ? 219.3894 \n",
"3370 10060 8 ? ? ? 230.6694 \n",
"3371 10061 8 ? ? ? 284.2296 \n",
"3372 10062 8 ? ? ? 355.3518 \n",
"3373 10063 8 ? ? ? 364.8504 \n",
"3374 10064 8 ? ? ? 256.5888 \n",
"3375 10065 8 ? ? ? 248.4012 \n",
"3376 10066 8 ? ? ? 251.2284 \n",
"3377 10067 8 ? ? ? 318.3000 \n",
"3378 10068 8 ? ? ? 288.9198 \n",
"3379 10069 8 ? ? ? 313.9080 \n",
"3380 10072 8 ? ? ? 243.7134 \n",
"3381 10073 8 ? ? ? 312.9804 \n",
"3382 10074 8 ? ? ? 313.5762 \n",
"3383 10075 8 ? ? ? 274.6194 \n",
"3384 10076 8 ? ? ? 225.0678 \n",
"3385 10079 8 ? ? ? 254.2188 \n",
"3386 10081 8 ? ? ? 339.1524 \n",
"3387 10082 8 ? ? ? 310.0416 \n",
"3388 10083 8 ? ? ? 288.7608 \n",
"3389 10084 8 ? ? ? 151.4046 \n",
"3390 10089 8 ? ? ? 259.6296 \n",
"3391 10090 8 ? ? ? 314.6700 \n",
"3392 10092 8 ? ? ? 299.4282 \n",
"3393 10094 8 ? ? ? 375.8664 \n",
"3394 10095 8 ? ? ? 348.3576 \n",
"\n",
" SelectByHotkeys AssignToHotkeys UniqueHotkeys MinimapAttacks \\\n",
"0 0.003515 0.000220 7 0.000110 \n",
"1 0.003304 0.000259 4 0.000294 \n",
"2 0.001101 0.000336 4 0.000294 \n",
"3 0.001034 0.000213 1 0.000053 \n",
"4 0.001136 0.000327 2 0.000000 \n",
"5 0.000978 0.000255 2 0.000000 \n",
"6 0.000820 0.000169 6 0.000000 \n",
"7 0.009040 0.000676 6 0.001164 \n",
"8 0.002944 0.000527 2 0.000019 \n",
"9 0.005054 0.000524 8 0.000025 \n",
"10 0.001677 0.000319 4 0.000000 \n",
"11 0.000379 0.000255 3 0.000016 \n",
"12 0.000423 0.000169 1 0.000024 \n",
"13 0.004952 0.000052 2 0.000087 \n",
"14 0.004254 0.000432 2 0.000775 \n",
"15 0.002333 0.000430 4 0.000000 \n",
"16 0.000664 0.000221 1 0.000018 \n",
"17 0.003430 0.000634 7 0.000000 \n",
"18 0.006701 0.000706 5 0.000013 \n",
"19 0.002630 0.000287 5 0.000244 \n",
"20 0.002651 0.000660 8 0.000099 \n",
"21 0.004500 0.000420 3 0.000019 \n",
"22 0.000734 0.000108 1 0.000024 \n",
"23 0.002854 0.000493 3 0.000000 \n",
"24 0.012495 0.000482 4 0.000054 \n",
"25 0.002315 0.000334 5 0.000078 \n",
"26 0.027815 0.000708 10 0.000000 \n",
"27 0.000875 0.000205 6 0.000018 \n",
"28 0.001406 0.000427 5 0.000000 \n",
"29 0.005667 0.000632 6 0.000376 \n",
"... ... ... ... ... \n",
"3365 0.019817 0.000633 4 0.000201 \n",
"3366 0.024645 0.000642 10 0.000415 \n",
"3367 0.008720 0.000879 10 0.000171 \n",
"3368 0.014917 0.000767 10 0.000599 \n",
"3369 0.005926 0.000741 6 0.000440 \n",
"3370 0.010383 0.001242 10 0.000375 \n",
"3371 0.016069 0.000711 9 0.000355 \n",
"3372 0.037526 0.000600 7 0.001242 \n",
"3373 0.042576 0.000996 8 0.000176 \n",
"3374 0.019592 0.000580 8 0.000416 \n",
"3375 0.016018 0.000874 9 0.000388 \n",
"3376 0.022910 0.000946 5 0.001097 \n",
"3377 0.034851 0.000933 7 0.000187 \n",
"3378 0.029322 0.001569 6 0.000118 \n",
"3379 0.019537 0.001214 4 0.000318 \n",
"3380 0.017195 0.000711 6 0.000666 \n",
"3381 0.026327 0.000266 6 0.000000 \n",
"3382 0.030550 0.000560 5 0.000000 \n",
"3383 0.022497 0.000707 6 0.000163 \n",
"3384 0.014339 0.001627 7 0.000291 \n",
"3385 0.016608 0.000788 6 0.000926 \n",
"3386 0.033058 0.001017 10 0.000477 \n",
"3387 0.026873 0.001278 10 0.000319 \n",
"3388 0.024022 0.000628 6 0.000350 \n",
"3389 0.009732 0.000949 6 0.000028 \n",
"3390 0.020425 0.000743 9 0.000621 \n",
"3391 0.028043 0.001157 10 0.000246 \n",
"3392 0.028341 0.000860 7 0.000338 \n",
"3393 0.036436 0.000594 5 0.000204 \n",
"3394 0.029855 0.000811 4 0.000224 \n",
"\n",
" ... NumberOfPACs GapBetweenPACs ActionLatency \\\n",
"0 ... 0.004849 32.6677 40.8673 \n",
"1 ... 0.004307 32.9194 42.3454 \n",
"2 ... 0.002926 44.6475 75.3548 \n",
"3 ... 0.003783 29.2203 53.7352 \n",
"4 ... 0.002368 22.6885 62.0813 \n",
"5 ... 0.002425 76.4405 98.7719 \n",
"6 ... 0.001988 94.0227 90.5311 \n",
"7 ... 0.004952 24.6117 41.7671 \n",
"8 ... 0.005399 52.0140 46.4321 \n",
"9 ... 0.003569 24.4632 52.1538 \n",
"10 ... 0.003772 23.4107 48.0711 \n",
"11 ... 0.003555 39.6381 65.5000 \n",
"12 ... 0.002885 42.4370 68.0502 \n",
"13 ... 0.002728 54.8718 79.2102 \n",
"14 ... 0.004571 36.2897 46.8889 \n",
"15 ... 0.002900 45.1654 64.7500 \n",
"16 ... 0.002656 45.7902 76.8889 \n",
"17 ... 0.005535 28.3636 37.7947 \n",
"18 ... 0.003237 67.0744 71.3251 \n",
"19 ... 0.003650 40.4427 59.9370 \n",
"20 ... 0.004147 30.7660 49.4854 \n",
"21 ... 0.003874 21.4686 50.5253 \n",
"22 ... 0.002695 22.7265 68.7321 \n",
"23 ... 0.004607 51.2082 52.0494 \n",
"24 ... 0.004334 27.9255 45.1605 \n",
"25 ... 0.003473 36.3934 57.5215 \n",
"26 ... 0.005616 34.6035 40.6025 \n",
"27 ... 0.003518 46.4122 71.8173 \n",
"28 ... 0.003453 26.7979 54.5979 \n",
"29 ... 0.004626 30.2222 45.5941 \n",
"... ... ... ... ... \n",
"3365 ... 0.003912 31.8222 54.5588 \n",
"3366 ... 0.004015 25.6352 43.3856 \n",
"3367 ... 0.004971 17.9901 35.9509 \n",
"3368 ... 0.005648 21.6687 41.2231 \n",
"3369 ... 0.005185 17.0456 30.5342 \n",
"3370 ... 0.006375 13.5028 31.4044 \n",
"3371 ... 0.006680 9.4756 29.6851 \n",
"3372 ... 0.004541 9.2871 41.9497 \n",
"3373 ... 0.004687 19.9499 41.1417 \n",
"3374 ... 0.005812 17.0462 34.3734 \n",
"3375 ... 0.005987 16.3144 30.2486 \n",
"3376 ... 0.005411 13.7404 35.7203 \n",
"3377 ... 0.005225 26.0987 32.4464 \n",
"3378 ... 0.005213 23.2857 32.8026 \n",
"3379 ... 0.005879 8.1642 26.0918 \n",
"3380 ... 0.005594 21.8795 30.5722 \n",
"3381 ... 0.005053 14.6118 30.7836 \n",
"3382 ... 0.004390 19.5405 35.4094 \n",
"3383 ... 0.004053 20.6757 32.7785 \n",
"3384 ... 0.005281 16.3502 33.2874 \n",
"3385 ... 0.005408 14.9191 35.9921 \n",
"3386 ... 0.004609 21.6389 37.1862 \n",
"3387 ... 0.005517 16.5446 33.8174 \n",
"3388 ... 0.005580 19.0108 30.0866 \n",
"3389 ... 0.004363 27.4658 43.8052 \n",
"3390 ... 0.004555 18.6059 42.8342 \n",
"3391 ... 0.004259 14.3023 36.1156 \n",
"3392 ... 0.004439 12.4028 39.5156 \n",
"3393 ... 0.004346 11.6910 34.8547 \n",
"3394 ... 0.005566 20.0537 33.5142 \n",
"\n",
" ActionsInPAC TotalMapExplored WorkersMade UniqueUnitsMade \\\n",
"0 4.7508 28 0.001397 6 \n",
"1 4.8434 22 0.001194 5 \n",
"2 4.0430 22 0.000745 6 \n",
"3 4.9155 19 0.000426 7 \n",
"4 9.3740 15 0.001174 4 \n",
"5 3.0965 16 0.000372 6 \n",
"6 4.1017 15 0.000573 5 \n",
"7 6.6104 45 0.002277 9 \n",
"8 3.3746 29 0.001035 7 \n",
"9 6.5664 27 0.001310 6 \n",
"10 7.0044 24 0.001593 7 \n",
"11 4.2269 19 0.000757 7 \n",
"12 4.3222 16 0.000748 7 \n",
"13 6.2293 21 0.001494 5 \n",
"14 5.4361 28 0.001981 7 \n",
"15 4.5312 15 0.001246 6 \n",
"16 3.5000 13 0.000664 6 \n",
"17 4.7671 29 0.002768 10 \n",
"18 4.3786 27 0.001332 9 \n",
"19 4.9961 16 0.001581 5 \n",
"20 4.6790 30 0.000825 8 \n",
"21 5.4892 29 0.001008 10 \n",
"22 6.7054 23 0.001961 7 \n",
"23 2.8663 31 0.000654 9 \n",
"24 6.3395 18 0.001204 5 \n",
"25 6.7587 36 0.000753 11 \n",
"26 4.1629 36 0.000856 12 \n",
"27 3.7944 34 0.000929 5 \n",
"28 5.3144 22 0.001032 4 \n",
"29 4.9077 14 0.001007 6 \n",
"... ... ... ... ... \n",
"3365 5.0294 14 0.001409 3 \n",
"3366 6.4922 21 0.000478 6 \n",
"3367 5.5872 21 0.000904 5 \n",
"3368 4.4680 28 0.001119 9 \n",
"3369 6.6749 35 0.002072 9 \n",
"3370 5.0533 32 0.001512 6 \n",
"3371 5.3326 25 0.002459 7 \n",
"3372 6.5063 22 0.001228 8 \n",
"3373 5.6167 18 0.000674 7 \n",
"3374 5.0563 19 0.001308 7 \n",
"3375 5.0973 21 0.001197 6 \n",
"3376 4.5524 22 0.000738 5 \n",
"3377 4.8705 13 0.000933 4 \n",
"3378 4.7540 24 0.001130 5 \n",
"3379 6.7885 26 0.001321 8 \n",
"3380 5.1136 25 0.000576 8 \n",
"3381 6.1930 10 0.001802 4 \n",
"3382 6.4228 12 0.001296 3 \n",
"3383 6.9262 15 0.000626 3 \n",
"3384 5.4713 26 0.000898 8 \n",
"3385 5.7205 28 0.001128 6 \n",
"3386 6.7103 16 0.001049 3 \n",
"3387 5.7350 22 0.000922 8 \n",
"3388 5.3831 30 0.000761 5 \n",
"3389 4.3312 23 0.000949 6 \n",
"3390 6.2754 46 0.000877 5 \n",
"3391 7.1965 16 0.000788 4 \n",
"3392 6.3979 19 0.001260 4 \n",
"3393 7.9615 15 0.000613 6 \n",
"3394 6.3719 27 0.001566 7 \n",
"\n",
" ComplexUnitsMade ComplexAbilitiesUsed Category \n",
"0 0.000000 0.000000 Diamond \n",
"1 0.000000 0.000208 Diamond \n",
"2 0.000000 0.000189 Platinum \n",
"3 0.000000 0.000384 Gold \n",
"4 0.000000 0.000019 Gold \n",
"5 0.000000 0.000000 Silver \n",
"6 0.000000 0.000000 Bronze \n",
"7 0.000129 0.000249 GrandMaster \n",
"8 0.000273 0.000470 Platinum \n",
"9 0.000000 0.000000 Platinum \n",
"10 0.000000 0.000017 Gold \n",
"11 0.000107 0.000263 Platinum \n",
"12 0.000000 0.000435 Gold \n",
"13 0.000000 0.000000 Gold \n",
"14 0.000000 0.000000 Diamond \n",
"15 0.000000 0.000227 Diamond \n",
"16 0.000000 0.000295 Platinum \n",
"17 0.000087 0.000102 Diamond \n",
"18 0.000240 0.000000 Diamond \n",
"19 0.000000 0.000000 Platinum \n",
"20 0.000000 0.000517 Diamond \n",
"21 0.000000 0.000560 Master \n",
"22 0.000000 0.000000 Diamond \n",
"23 0.000000 0.000000 Diamond \n",
"24 0.000000 0.000000 Platinum \n",
"25 0.000284 0.001229 Platinum \n",
"26 0.000089 0.000197 Master \n",
"27 0.000000 0.000000 Diamond \n",
"28 0.000000 0.000570 Diamond \n",
"29 0.000000 0.000000 Master \n",
"... ... ... ... \n",
"3365 0.000000 0.000000 Professional Leagues \n",
"3366 0.000000 0.000579 Professional Leagues \n",
"3367 0.000000 0.000000 Professional Leagues \n",
"3368 0.000035 0.000062 Professional Leagues \n",
"3369 0.000225 0.000064 Professional Leagues \n",
"3370 0.000035 0.000047 Professional Leagues \n",
"3371 0.000000 0.000000 Professional Leagues \n",
"3372 0.000000 0.000614 Professional Leagues \n",
"3373 0.000000 0.000000 Professional Leagues \n",
"3374 0.000000 0.000000 Professional Leagues \n",
"3375 0.000000 0.000000 Professional Leagues \n",
"3376 0.000000 0.000662 Professional Leagues \n",
"3377 0.000000 0.000233 Professional Leagues \n",
"3378 0.000000 0.000000 Professional Leagues \n",
"3379 0.000106 0.000443 Professional Leagues \n",
"3380 0.000000 0.000000 Professional Leagues \n",
"3381 0.000000 0.000030 Professional Leagues \n",
"3382 0.000000 0.000059 Professional Leagues \n",
"3383 0.000000 0.000000 Professional Leagues \n",
"3384 0.000000 0.000959 Professional Leagues \n",
"3385 0.000000 0.000000 Professional Leagues \n",
"3386 0.000000 0.000000 Professional Leagues \n",
"3387 0.000000 0.000000 Professional Leagues \n",
"3388 0.000000 0.000652 Professional Leagues \n",
"3389 0.000000 0.000099 Professional Leagues \n",
"3390 0.000000 0.000000 Professional Leagues \n",
"3391 0.000000 0.000000 Professional Leagues \n",
"3392 0.000000 0.000000 Professional Leagues \n",
"3393 0.000000 0.000631 Professional Leagues \n",
"3394 0.000457 0.000895 Professional Leagues \n",
"\n",
"[3395 rows x 21 columns]"
]
},
"execution_count": 118,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df2"
]
},
{
"cell_type": "code",
"execution_count": 124,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x1a23447748>"
]
},
"execution_count": 124,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAdMAAAD3CAYAAABGtL45AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAHAhJREFUeJzt3XmYHXWZ9vFvByKLNBjxaGBYBbwBAVlkGwHDori8MYiXsgiIKAjKNjAKIrIpbu+AI4qoiAZkC4xoxAVQQiCAGFlVAndEFINDNChLQAVC9/xR1dK26eRA9dnvz3Vx9an1PE/Kmfv8qurU6RscHCQiIiJeuHGtLiAiIqLTJUwjIiIqSphGRERUlDCNiIioKGEaERFR0bKtLiCab9GiZwcfeeSvrS6jaSZMWJFe6beXeoX0283asddarb9vtGUZmfagZZddptUlNFUv9dtLvUL67Wad1mvCNCIioqKEaUREREUJ04iIiIoSphERERUlTCMiIirKV2N60ORjp7e6hIiIpvvG8bs0bN8ZmUZERFSUMI2IiKgoYRoREVFRQ66ZSpoEXAbMAQaBFYCLbH+xzu23Ab4JfM/2RyvUMRE4yfYHX+g+Ruxvvu2JI+b9DtjQ9t/H4j0iIqLzNPIGpBm29waQtBxgSd+y/Wgd274R+Eq94Tsa2/OBMQnSiIiI0TTrbt5+4FlgkaSZwAJgAvBW4OvAesAywJnAb4H3A09LehD4C3B6uf1vgA8A6wJTgWeARcABwNPANIpT1+OBQ4GFwKW2t5P0BuCTwN+BPwMHAZsDx5XbrgtMs326pE3KWsYBLwGOtH1zvc1KWgU4D1i1nHWk7V9KOhzYs6zvsfL1MsAFwOrAPGAn26uX/06H2r5X0qHARNunSDoC2JdixH+p7bMk7Vn28QzwO+AA2wP11hsREdU0Mkx3KQNhgOL/yR9h+wlJABfb/k4ZLg/b3l9SP3A7sD1FUM4HvgsY2MH2nyR9AjgQeBFwG3AMsCNFMK9NEVD7AhsDK1OEKZL6gK+V+/mDpKOAE4Hvl9ttBiwH/C9FcL8aOLYMwH2B9wJ1hylwAnCt7XMkbQB8U9JOFOG6m+0BSVcDWwOvBX5r+52SNgTuHm2nkjYG9gJ2oAjTn5T72Qf4vO1LJR1Q9l7PGYCIiJ5Rq/U3bN9NOc27GC7/bgT8BMD2QklzKEapQ2rAasBlZQivAFxDEXjHAVdRBOgJwI+ADYDpFOH9yWH7eRnwuO0/lNM3AJ+iCNNf2l5EMWr+W7n8D8DHy+l+4PHn2fumFB8m9iqnJ5QB+jRwiaQngDUoRqgblX1QjkIXLGZ/Qz/7swlF+F87tF9gfYoPFR+VdBhwD8WHkIiIGGbBgoWVtl9SGLfqbt6hU5D3UIwsKUemm1Kc5h3yMPAgMMX2JIoQvQ6YAsyyvStwOUWwTgIesv1GiiD91Ij9rCxptXL69cDc8vXgYuo7CzjZ9nuAX/JcmNXrXoqR4iTgXcBFkjYD9rC9F3AExb99H/AritE4ktajCH4oTkcP1btl+dcUI9edy31PLes7BDjF9uvLfb79edYbEREVtPoJSF8DzpV0I8Wo89TydC4A5WjuKOAHksZRjBAPoBgtXihpEUUw/wfwADBN0tEU11dPG3oT24OSDgaukDQAPEJxuniTUeq6EJgu6Y8UYf6yUdYbcpOkoVC+mCL0z5N0CMUp11OA+4AnJd0KPAU8RHGd9DxgqqQbyh6G7go+Czhb0jyKkTK275J0LXBjeVPX7HLZbODHkv5McWr7+0upNyIixlDf4ODiBmbRLJL+HVjJ9jXl9dWrbK+3tO2qmHzs9Bz0iOg5VR8nWKv1j3qWstUj04D7Ka6jnkxxDfVDLa4nIiKep4Rpi5Xfhd251XVERMQLl9O8vWmw6l1tnaRW6698F1+n6KVeIf12s3bsdUmnefNs3oiIiIoSphERERUlTCMiIipKmEZERFSUMI2IiKgoYRoREVFRwjQiIqKihGlERERFCdOIiIiKEqYREREVJUwjIiIqSphGRERUlF+N6UGTj53e6hIiel7V39aM9pKRaUREREUJ04iIiIoSphERERX15DVTSa8EPgesAfwV+BvwEdt3j9H+LwW+Uk5eB+xte9qw5b8Abrd94PPc7+G2vzQWNUZExNjpuZGppBWB7wFn2N7O9i7AqcDZDXrLe4F9hr3/psCLX+C+ThyTiiIiYkz14sh0MjDD9k+HZtieLWlnSVOBVcv/JgOfBdYsp39k++PlOk8B6wCrAQfavl3Sh4D3Aw8BLx/2fncBr5L0EtuPAvsBFwFrQTHaBPYExgOPla/XAaYCzwCLgAOAA4GXSvoycBTFyHcDig9EJ9qeKelXwFzgKdv/CPCIiGisXgzTdYH7hiYkTQdWoQjGecAPbH9e0jrALbbfL2l54EHg4+VmD9j+gKSDgUMkHUcRcJsCA8BtI97zCuDtZRBvQxHSa0kaRxHUu9kekHQ1sDWwebmPY4AdgQm2T5d0hO0PSjoMeNj2+yStCtwAvBpYCfiE7TvG7p8rIhqhVutv6nadqJN67cUwnQe8dmjC9hQASbdQBKbLRX8Btpa0M/A4sNywfQyF1TzgdcCGwN22nyr3NXvEe14MnAPcD8wa9t4Dkp4GLpH0BMU13PHAecBxwFUUo9UTRuxvU2BHSduW08uWocqw+iOijS1YsPB5b1Or9b+g7TpRO/a6pHDvuWumwHRgN0nbDc2QtD5FkK1NMbKE4rTqo7bfDZwBrCipr1w2OGKf9wMbS1pB0jLAFsMX2r6f4jrpkcCFw953M2AP23sBR1Acjz5gCjDL9q7A5RTBSrkMiuuwl9ieBLy5XOeRctlQ/RER0SQ9F6a2n6C4Hnq0pOsl3UQxEjwEeGDYqtcCb5F0M8Wo8tfA6qPscwFwEnAz8CPgycWsNg1Y0/bcYfPuA56UdCvwY4rrrasDtwKnS5oFHAp8sVx/jqQLga8CG0q6vnzPB2wnRCMiWqRvcHDkICu63eRjp+egR7TYC3mcYDue+myUduy1VuvvG21Zz41MIyIixlrCNCIioqJevJu35115xpS2O33SSO14uqhReqlX6L1+o31lZBoREVFRwjQiIqKihGlERERFCdOIiIiKEqYREREVJUwjIiIqSphGRERUlDCNiIioKGEaERFRUcI0IiKiooRpRERERQnTiIiIihKmERERFeVXY3rQwT+8vdUlRDTVp7beoNUlRJfLyDQiIqKihGlERERFCdOIiIiKEqYNJmmSpEFJe42Y/wtJU5/nvg4f0+IiImJMJEyb415gn6EJSZsCL34B+zlxzCqKiIgxk7t5m+Mu4FWSXmL7UWA/4CJgrXK0uScwHnisfL0OMBV4BlgEHAAcCLxU0peBo4CvABtQfCA60fZMSb8C5gJP2f5HeEf0ulqtv9UljJlu6mVpOqnXhGnzXAG8vTy1uw3wWYrQXBXYzfaApKuBrYHNgduAY4AdgQm2T5d0hO0PSjoMeNj2+yStCtwAvBpYCfiE7Tua3FtEW1uwYGGrSxgTtVp/1/SyNO3Y65LCPWHaPBcD5wD3A7PKeQPA08Alkp4A1qAYoZ4HHAdcRTFaPWHEvjYFdpS0bTm9bBmqAG5YBxERsVi5Ztoktu+nuE56JHBhOXtlYA/bewFHUByPPmAKMMv2rsDlFMFKuQyKa7CX2J4EvLlc55Fy2UBjO4mIiJESps01DVjT9txyehHwpKRbgR8DDwGrA7cCp0uaBRwKfLFcf46kC4GvAhtKuh64GXjAdkI0IqJF+gYHB1tdQzTZwT+8PQc9ekq3PE6wHa8jNko79lqr9feNtiwj04iIiIpyA1IPOvctW7bdJ75GasdPuI3SS71C7/Ub7Ssj04iIiIoSphERERUlTCMiIipKmEZERFSUMI2IiKgoYRoREVFRwjQiIqKihGlERERFCdOIiIiKEqYREREVJUwjIiIqSphGRERUlDCNiIioqK5fjZF0NjDV9s8bXE80wW3XfLjVJTTV71tdQBO1a69rbXFSq0uIaKh6f4JtNvAZSS8HLgC+ZXt+48qKiIjoHHWd5rV9vu1dgbcAfcDNkr4vaY+GVhcREdEB6r5mKmld4MDyv/uAK4B3SbqgIZVFRER0iHqvmd4ITATOB95k+/fl/AuAPzSuvPYmaRJwGTCHYsQ+HvhvYC7wNtuntaCmQ4GJtk9p9ntHRPSqeq+Zfs7290bOtL0IeMXYltRxZtjeG0DSSsD1wPtaEaQREdEa9Ybpp4F/CdP4Z7afkPRV4EuSHrS9t6TDgT0pRq2Pla/3BSYDKwCrAV8ApgCbAP9pe7qkdwNHA08BvwYOAd5Ncd16RWA94LO2p0raodzHX4BngVua1XNEPWq1/o7cdzvqpX47qdd6w/Q3kr4B/Az429BM27le+q/+CLwMeFDSOGBVYDfbA5KuBrYu1+u3/UZJewP/AWwHTAKOKk+rnwpsYXuhpM8DHwCeAFaxvbukDYArganA54F9bM+VdE7TOo2o04IFCxuy31qtv2H7bke91G879rqkcK/3BqQ/U1wT3A7YufxvUtXCutTawIUAtgeAp4FLJJ0HrEExQgW4o/z7KHCP7UHgEWB54JXA3baH/pd0A/Dq8vWd5d955boA/2Z7bvn6pjHvKCIilqjer8a8l+I04xkUpxMPtn1QIwvrRJL6gYOBBeX0ZsAetvcCjqD49+4rVx9cwq5+C2ws6cXl9Ospbmoabbv5kjYqX2+9mOUREdFA9d7NuxXwbYoR6jjgFZLebvtnjSyuQ+wiaSbFtcplgZMprl3uTPEVoicl3Upx7fMhYPWl7dD2w5JOBq6TNFDu53hg71E22Q84X9JCYCHFCDciIpqkb3BwSQOkgqSbgGOGwlPSdsBZtrdpcH3RALdd8+GlH/SIMdSoxwm243W1Ruqlftux11qtv2+0ZfVeM11p+CjU9i08d70uIiKip9V7N+9fJE2xPR2gfIzgnxtXVjTSVm/8/233ia+R2vETbqP0Uq8R7aTeMP0A8K3y6zEAvwH2b0xJERERnaWuMC2/drFteXfpuGFf2YiIiOh59d7Nex3DvpIhaZDi4Q33AJ+ynbtHIyKiZ9V7mncO8AwwdJp3X4oHEPwvcB7FI/IiIiJ6Ur1hup3trYZN/0LSz23vJ+mARhQWERHRKer9asx4SUOPs6N8vYykFYAXNaSyiIiIDlHvyPRI4EeS/ggsA7yE4m7eU4A87D4iInpavXfzzpT0SmBTisfm3WP7GUk3lw9oj4iI6Fl1neaVNAE4h+JB9w8CX5U0IUEaERFR/zXTc4GfU/w25xMUD2y/sFFFRUREdJJ6w3Rd218DBmw/bftjFF+NiYiI6Hn1hukiSatQPrhB0gbAQMOqioiI6CD13s17MjATWEvSd4Htgfw4eEREBPXfzXtV+QPX21J8NeYD5AeoO9Zpx17Z6hKiBQ47flKrS4joWvU+m/entrcHflBOjwPuoviqTERERE9bYphKmgFMKl8P8NzD7p8FvtfQyiIiIjrEEsPU9i4Akr5g+6jmlBQREdFZ6r0B6ThJbwdWAvoorpuua/ukhlXWISRNAi6j+GWdQWAF4CLgHcChtu8dZbudgEdt/0LSFbbzyzsRER2q3jC9GJgArA/MAnYGbmxUUR1ohu29ASQtBxh4dCnbHARcCvwiQRoR0dnqDdPNgA2AL1D8pumJwLRGFdXh+imuKS8CkLQGxaMYl6d4gtRpwDzgTcCWkuYAs21PlDQTuBPYBFgZeCfFmYBLbW9X7u8WYG/gQIoPNy8DXgp8mWI0/CrgPbZvaUKvERFB/WH6J9uDku4FNrN9gaT89NpzdimDcIDiR9SPAD5SLtsQOKP8sYB/B061/QZJV1GE5O8lDd/XbNtHSzod2Idi9Dqav9l+k6TjgbfYnizpvRRhmzCNf1Kr9be6hIbo1r5G00v9dlKv9YbpryR9kWKEdZGk1SlGTFH4x2neIZKGwvQh4ERJ76O4pjp+Kfu6o/w7D5i4mOXD/91vL/8+SnHNForv/y5fZ93RQxYsWNjqEsZcrdbflX2Nppf6bcdelxTuS32cYPmLMR8DLrM9h+JpSGsC+45VgV3uE8AFtvcHruO5MBxg8f/+I3+J5+/AyyUtI+klwLpLWDciIlpgiWEqaQuKEc9WtmeVs7cF9ljatvEPlwNnSZoFvIHiGifAz4DPSNpoSRvbng/8mOJXe74G3NfAWiMi4gXoGxwcfXAj6VrgE7Znjpi/O/Bh27s1trxohNOOvTIj2h7UjY8TbMdTgY3US/22Y6+1Wv+olzeXNrqcMDJIAWxfzXMjrIiIiJ62tBuQxksaZ/uffm6tfDZv7ubtUCedMbntPvE1Ujt+wm2UXuo1op0sbWR6PcUNRyOdCNw69uVERER0nqWNTD8K/FDSeygeJvB3YEvgT8DbGlxbRERER1jag+4Xls+Q3RnYguLrHGcPu7M3IiKi5y31oQ22B4EZ5X8RERExQr4rGhERUVHCNCIioqKEaUREREUJ04iIiIoSphERERUlTCMiIipKmEZERFSUMI2IiKgoYRoREVHRUp+AFN3npinvaHUJTTW31QVU8KqvT211CRFRh4xMIyIiKkqYRkREVJQwjYiIqCjXTNuEpFcCnwPWAP4K/A34iO27R1l/vu2JI+YdCky0fUqDy42IiGESpm1A0orA94CDbf+0nLcNcDYwqYWlRUREHRKm7WEyMGMoSAFsz5a0s6R1gPOA8cAgcKTtu4bWk7QD8AXgL8CzwC3NLDwiIhKm7WJd4L6hCUnTgVWA1YB5wFm2p0vanCJYXzts288D+9ieK+mcJtYcTVCr9Tdlm06WfrtXJ/WaMG0P8xgWkLanAEi6BdgeeGc5/05Ja47Y9t9sD32V8iZg/caXG82yYMHC57V+rdb/vLfpZOm3e7Vjr0sK99zN2x6mA7tJ2m5ohqT1KW5Gmg3sWM7bHJg/Ytv5kjYqX2/dhFojImKEjEzbgO0nJE0GPiNpNYrjsgg4BJgDnCvpPymum75vxOb7AedLWggsBB5pXuUREQEJ07Zh+3fA3qMsfsNi1p9Y/p0DbNO4yiIiYmlymjciIqKihGlERERFOc3bg143/dttd5dcI7XjXYER0V0yMo2IiKgoYRoREVFRwjQiIqKihGlERERFCdOIiIiKEqYREREVJUwjIiIqSphGRERUlDCNiIioKGEaERFRUcI0IiKiooRpRERERXnQfQ9617TDWl1C1zt7l8+1uoSIaKKMTCMiIipKmEZERFSUMI2IiKgo10xbSNLxwG7AADAInADsD5wJHATMt/2V1lUYERH1SJi2iKSNgbcBr7M9KGlz4HzbrymXt7S+iIioX8K0df4ErAUcJOkq23dK2kbSTODQoZUknQncZft8SROBH9jeStKngZ0oTtWfafvyctsFwARgd9vPNrmniIielDBtEdsPS3obcDhwsqS/Ah9bzKrnAmcD51OcAv6mpDcD69p+naTlgVsk/bhc/2Lb32lCC7EEtVp/T753K6Tf7tVJvSZMW0TS+sDjtg8qp18L/BCYP3w92/dIWlbS2sBeFNdYDwG2KkeiAOOBtYc2aUL5sRQLFixsyfvWav0te+9WSL/dqx17XVK4527e1tkMOKccWQLMBR4DFndq9jzgc8Ac248C9wLX2Z4E7AJcBtxfrjvQyKIjIuJfJUxbxPYVwEzgZ5JuAq4GPkwRqCNdDuwOfL2cvhJ4QtIs4DZg0HZ7fYSLiOghfYODg62uIZrsXdMOy0FvsFY9TrAdT401UvrtXu3Ya63W3zfasoxMIyIiKkqYRkREVJS7eXvQZXud03anTxqpHU8XRUR3ycg0IiKiooRpRERERQnTiIiIihKmERERFSVMIyIiKkqYRkREVJQwjYiIqChhGhERUVHCNCIioqKEaUREREUJ04iIiIoSphERERXlQfc9aPKx01tdQtv6xvG7tLqEiOhAGZlGRERUlDCNiIioKGEaERFRUcI0IiKiotyA1ECSJgGXAXOAPmA8cJDte1tZV0REjK2EaePNsL03gKQ3Av8F/L/WlhQREWMpYdpcE4DfSZoJLCin3wp8HVgPWAY40/a0cp07gU2AlYF3AqsDny739TLgxbbXlXQEsC8wCFxq+6ymddRlarX+VpdQWTf08Hyk3+7VSb0mTBtvlzIYlwM2owjPTYCLbX9H0uHAw7b3l9QP3C7p2nLb2baPlnQ6sI/tzwCTJL0U+D5wgKSNgb2AHSjC9CeSrrbtpnbZJRYsWNjqEiqp1fo7vofnI/12r3bsdUnhnhuQGm+G7Um2twe2BK4AVgCGwm4j4AYA2wsprq+uVy67o/w7D1geQNJKwHeBk2zfThHMawPXAjOAVYH1G9xTREQMkzBtrj8Oez1Q/r0H2BGgHJluCvy2XDY4fGNJLwK+DZxt+yflbAN3AzvbngRMBX7ZgNojImIUOc3beEOneZ8F+oFjgAOHLf8acK6kGylGrKfa/pOkxe3rKIrR7bKSDivn7UkxKr1R0nLAbOAPDegjIiJG0Tc4OLj0taKrTD52eg76KDr92bzteJ2pkdJv92rHXmu1/r7RluU0b0REREU5zduDrjxjStt94mukdvyEGxHdJSPTiIiIihKmERERFSVMIyIiKkqYRkREVJQwjYiIqChhGhERUVEe2hAREVFRRqYREREVJUwjIiIqSphGRERUlDCNiIioKGEaERFRUcI0IiKiooRpRERERfkJth4iaRzwZeA1wFPA+23f19qqxp6kO4DHysnfAl8FvgAsAq6xfWqrahsrkrYFPmt7kqT1ganAIPAr4EO2BySdDLyVou+jbc9uWcEVjeh3S+BK4Nfl4nNsT+uGfiWNB74BrAMsB3wSmEMXHt9Ren2QDj22CdPesgewvO3tJW0HnAFMaXFNY0rS8gC2Jw2bdyfwDuB+4AeStrR9e2sqrE7SR4D9gSfLWWcCJ9qeKekrwBRJDwCvB7YF1gS+DWzdinqrWky/WwJn2j5j2Dpb0h397gf82fb+klYF7gDupDuP7+J6PY0OPbY5zdtbdgCuArB9C/Da1pbTEK8BVpR0jaQZknYClrP9G9uDwNXArq0tsbLfAHsOm94KuL58/SNgN4pjfY3tQdu/B5aVVGtumWNmcf2+VdINks6T1E/39Hs58PFh04vo3uM7Wq8deWwTpr1lZZ47/QnwrKRuOzvxV+C/gN2BQ4FvlvOGLARWaUFdY8b2t4Fnhs3qKz8owHP9jTzWHdv3YvqdDXzY9k4UZxtOpkv6tf2E7YVliPwPcCJdenxH6bVjj23CtLc8DvQPmx5ne1GrimmQucCF5afYuRT/R/jSYcv7gUdbUlnjDAx7PdTfyGPdTX1/x/ZtQ6+BLeiifiWtCVwHfMv2xXTx8V1Mrx17bBOmveUm4C0A5TXTX7a2nIY4iOJaMJJWB1YEnpS0nqQ+ihHrrBbW1wh3SJpUvn4zRX83AbtLGidpLYoPTg+3qsAxdrWkbcrXuwK30SX9SnoFcA1wnO1vlLO78viO0mvHHttuO8UXS/Yd4A2Sbgb6gPe2uJ5GOA+YKulGirsfD6L4ZH8RsAzFtZeftbC+RjgWOFfSi4B7gP+x/aykWcBPKT40f6iVBY6xw4AvSXoamA8cYvvxLun3BGAC8HFJQ9cTjwLO6sLju7hejwH+uxOPbX6CLSIioqKc5o2IiKgoYRoREVFRwjQiIqKihGlERERFCdOIiIiKEqYREREVJUwjIiIq+j/+1iJPMsJkvgAAAABJRU5ErkJggg==\n",
"text/plain": [
"<Figure size 432x288 with 1 Axes>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"df2.groupby(\"Category\")['APM'].mean().sort_values().plot(kind=\"barh\")"
]
},
{
"cell_type": "code",
"execution_count": 127,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Category\n",
"Bronze AxesSubplot(0.125,0.125;0.775x0.755)\n",
"Diamond AxesSubplot(0.125,0.125;0.775x0.755)\n",
"Gold AxesSubplot(0.125,0.125;0.775x0.755)\n",
"GrandMaster AxesSubplot(0.125,0.125;0.775x0.755)\n",
"Master AxesSubplot(0.125,0.125;0.775x0.755)\n",
"Platinum AxesSubplot(0.125,0.125;0.775x0.755)\n",
"Professional Leagues AxesSubplot(0.125,0.125;0.775x0.755)\n",
"Silver AxesSubplot(0.125,0.125;0.775x0.755)\n",
"Name: APM, dtype: object"
]
},
"execution_count": 127,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYQAAAD3CAYAAAAdfCMIAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAFt5JREFUeJzt3X+QJPV53/H3zO7ewi4rOOyFYHRAgaTHLlUK+zBGdiRxCTZYIS5UklNKxcKOqISKjR2IVRFlGQrsUqUKR1DWL0sqSQhLsVyKwIAJQVxSEuiMibARVCwLPaADc0hC+O644+72Trrdnc0f0wfD3cxs7+z0zOzd+/UP3T3940Pv3jz77W/3t2tLS0tIklQfdgBJ0miwIEiSAAuCJKlgQZAkARYESVJhfNgBerF9+96RvDVq/fopdu3aP+wYy1oLOc3YP2shpxn7p1vO2dmZWrdtbSH00fj42LAjlLIWcpqxf9ZCTjP2z2pyWhAkSYAFQZJUsCBIkgALgiSpYEGQJAEWBElSwYIgSQIsCJKkggVBkgSs0aErBPc+vbnnbademGT/3I9KrXvp2Rf3fBxJa4stBEkSYEGQJBUquWQUERPArcBZwCTwAeC7wD3AU8VqH8/ML0bEDcClwAJwTWY+UkUm9WY1l6ZWystT0nBV1YfwbmBnZl4eET8GPAb8IXBLZt58aKWI2AhcCFwAbADuAM6vKJMkqYuqCsKXgNtb5heA84CIiMtothKuAd4MbM7MJWBbRIxHxGxmbq8olySpg0oKQmbuA4iIGZqF4Tqal44+nZmPRsTvAzcAu4GdLZvuBU4EuhaE9eunRnZs8tnZmYEcZ+qFydVtP7267atw+Lkb1LlcjbWQEdZGTjP2T685K7vtNCI2AHcCf5KZX4iIkzJzd/HxncBHgLuB1uQzNItEV6P61qLZ2Rm2b987kGOVvW20nanp8redDlLruRvkuezVWsgIayOnGfunW87lCkUldxlFxKnAZuDazLy1WHx/RPxcMX0R8CjwEHBJRNQj4gygnpk7qsgkSequqhbC+4H1wPURcX2x7HeBP46Ig8APgCszc09EbAEeplmcrqoojyRpGVX1IVwNXN3mo19os+6NwI1V5JAkleeDaZIkwIIgSSpYECRJgAVBklSwIEiSAAuCJKlgQZAkARYESVLBgiBJAiwIkqSCBUGSBFgQJEkFC4IkCbAgSJIKFgRJEmBBkCQVLAiSJMCCIEkqWBAkSYAFQZJUsCBIkgALgiSpYEGQJAEwPuwAGo5t+09a9T7OmNrdhySSRoUtBEkSYEGQJBUsCJIkwIIgSSpYECRJgAVBklSwIEiSAAuCJKlgQZAkARU9qRwRE8CtwFnAJPAB4FvAbcAS8E3gqsxsRMQNwKXAAnBNZj5SRSZJUndVtRDeDezMzLcAbwM+CtwCXFcsqwGXRcRG4ELgAuDfAB+rKI8kaRlVjWX0JeD2lvkF4DzgwWL+PuBiIIHNmbkEbIuI8YiYzczt3Xa+fv0U4+NjFcRevdnZmYEcZ+qFyVVtPzGx+h/91PTqMhzu8HM3qHO5GmshI6yNnGbsn15zVlIQMnMfQETM0CwM1wEfLL74AfYCJwKvAXa2bHpoedeCsGvX/n5H7ovZ2Rm2b987kGPtn/tRz9tOTU8yP78w1AzttJ67QZ7LXq2FjLA2cpqxf7rlXK5QVNapHBEbgK8Cn8/MLwCNlo9ngN3AnmL68OWSpAGrpCBExKnAZuDazLy1WPxYRGwqpt8GbAEeAi6JiHpEnAHUM3NHFZkkSd1V1YfwfmA9cH1EXF8suxr4cESsA54Abs/MxYjYAjxMszhdVVEeSdIyqupDuJpmATjchW3WvRG4sYockqTyfDBNkgRYECRJBQuCJAmwIEiSChYESRJgQZAkFSwIkiTAgiBJKlT1pLIq8n++1xwLcNv+k3rex8T8OM0BaCXpFbYQJEmABUGSVPCSkSpxyg+fW/E2u59/4OXp+Zcmmdu//PsWTjpt04qPI6k9WwiSJMCCIEkqWBAkSYAFQZJUsCBIkgALgiSpYEGQJAEWBElSwYIgSQIsCJKkggVBkgSUHMsoIv4X8Fng7sw8WG0kSdIwlG0h3AT8MvBkRHwsIs6vMJMkaQhKtRAy80HgwYg4HvhV4I6I2AN8Gvh4Zi4/LKUkaaSV7kOIiE3AR4H/CnwZ+E/AqcBfVpJMkjRQZfsQngWeptmP8NuZeaBY/gDwt5WlkyQNTNkWwr8A3pWZnwOIiNcBZGYjMzdWFU6SNDhlC8KlNC8TAZwC3BMRV1YTSZI0DGULwpXAWwAy81ngPOB3qgolSRq8su9UngBa7yQ6CCz1P86xbcfddy67zv6ZUwA4/sCLR3x24MxT+55J0rGjbEG4C/hKRPwPmoXgnZS4uygiLgBuysxNEbERuAd4qvj445n5xYi4geYlqQXgmsx8ZKX/E5Kk1Sv7HMK1EfGrwIXAPPDhzLyr2zYR8T7gcmCuWLQRuCUzb25ZZ2OxzwuADcAdgA+9SdIQlG0hADwBvADUACLirZn5tS7rbwXeAXy+mD+vuVlcRrOVcA3wZmBzZi4B2yJiPCJmM3N7tyDr108xPj62guiDMzs70/Gzv3zy+123fenk05bd/7riv/WDR3b/TEyU/3GuZN1OpqYnO+9/ceX7n56a7DrfTrfzPQjDPn5ZayGnGfun15xln0P4GPArNL/kD1mieTtqW5l5R0Sc1bLoEeDTmfloRPw+cAOwG9jZss5e4ESga0HYtWt/mdgDNzs7w/btezt+Pre/+zBQB+cXSx+rsdg4Ytn8/EKpbScmxkuv283+uc4PqJ/Qw/7n9r+yv+mpyVfNd9LtfFdtuZ/3qFgLOc3YP91yLlcoyv4ZdzEQhx5I69Gdmbn70DTwEeBuoDXhDM0iIUkasLIF4WmKS0WrcH9E/E7RaXwR8CjwEPBHEfFB4LVAPTN3rPI4WqOe2vVKA3RiX7lWzD8e6G3w3UvPvrin7aSjWdmC8CLwrYj4a+CHhxZm5hUrONZvAh+NiIPAD4ArM3NPRGwBHqb5TMRVK9ifJKmPyhaEL/PKk8qlZeY/AG8qpr8B/EKbdW4EblzpviVJ/VX2ttM/LTqI3wjcD2zIzGeqDCZJGqxSQ1dExLtoPlT2IeBk4OGIeHeVwSRJg1V2LKNraV7u2ZuZ/wj8DPB7laWSJA1c2YKwmJkv39iamc8DR94IL0las8p2Kv99RPw2MBERPw38FvB4dbEkSYNWtoVwFXA6cAC4FdhDsyhIko4SZe8ymqPZZ2C/gSQdpcqOZdTgyPcfPJ+Zr+1/JEnSMJRtIbx8aSkiJoC3Az9fVSiprFN++FxP2+1+/oEVb3PSaZt6Opa0Vqx4jOLMnAe+VIxYqjVkemEPAPVGnXWN1d8k1uuXsaTRVPaS0a+3zNZoPrE8X0ki9ez4Z1/o+vn4Cc3hteu1Go2l9m9AXTjxhL7nkrQ2lG0h/POW6SVgB/Cu/seRJA1L2T6E91QdRJI0XGUvGT3DkXcZQfPy0VJmnt3XVJKkgSt7yegLwI+AT9HsO/g14HzAjmVJOkqULQiXZObPtsx/KCIezcxnqwglSRq8skNX1CLiFw/NRMS/ojl8hSTpKFG2hXAl8LmI+Cc0+xK+DfxGZakkSQNX9i6jR4E3RsSPAweKsY0kSUeRsm9MOzMi/jfwMDATEV8pXqkpSTpKlO1D+CTw34B9wAvAnwOfqyqUJGnwyvYh/Hhmbo6ImzJzCfhURFxVZTCNvicOntmX/fzUOm9Wk0ZB2RbCgYh4LcXDaRHxZprPJUiSjhJlWwj/GfifwDkR8ThwMvCvK0slSRq4sgXhVJpPJr8BGAO+nZkHK0slSRq4sgXhjzLzXuDvqwwjSRqesgVha0TcCnwdOHBoYWZ6p5EkHSW6FoSIOD0zvwfspDmy6ZtaPl7CW09fZduff5G5uc597ftnThlgGklameVaCPcAGzPzPRHx3sy8eRChJEmDt9xtp7WW6V+rMogkabiWKwitL8WpdVxLkrTmlX0wDdq/MU2SdJRYrg/hjRHxdDF9est0qVdnRsQFwE2ZuSkiXgfcRrOwfBO4KjMbEXEDcCmwAFyTmY/0+P8iSVqF5QrCG3rdcUS8D7gcODRU9i3AdZn5QER8ArgsIp4FLgQuADYAd9B8AE6SNGBdC8IqX5G5FXgH8Pli/jzgwWL6PuBiIIHNxYB52yJiPCJmM3P7Ko4rSepB2QfTViwz7zjsnQm14osfYC9wIvAams84cNjyrgVh/fopxsfH+pi2P7YB09OTHT9fN9G/zPWDK+n+KbapNVqm298jUK+vfL+rNTHR/tew0/J+mJ7q/HPqZHZ2ptSyUbQWcpqxf3rNWd2/uCM1WqZngN0038s802Z5V7t27e9vsj7q9mDawfpi347TWGwsv9Lh2yw163G9Vnt5+oh1Givf72rNzy8csWxiYrzt8n6Z27/ywXq3b9/7qvnZ2Zkjlo2itZDTjP3TLedyhWKQfw4+FhGbium3AVuAh4BLIqIeEWcA9czcMcBMkqTCIFsI76X5Yp11wBPA7Zm5GBFbaL6asw740h1JGpJKC0Jm/gPF+EeZ+STNO4oOX+dG4MYqc0iSljf4HkRJ0kga5CWjY9JX1z338vRzvFhqm9fxk1XFkaSObCFIkgALgiSpYEGQJAEWBElSwYIgSQIsCJKkggVBkgRYECRJBQuCJAnwSeWR9B2+vew6B8YPvDx9+sKZVcaRdIywhSBJAiwIkqSCBUGSBFgQJEkFO5WlknY//8Cr5udfmuzp3cxlnHTapkr2K3VjC0GSBFgQJEkFC4IkCbAgSJIKFgRJEuBdRjrM+Ev7VrX9wokn9CmJpEGzhSBJAiwIkqSCl4xW4N6nN3f9fL72DPPrFgeURpL6yxaCJAmwIEiSCl4yKuGuLU8DsHVxV9f1xnb8gEZjianj2p/WA/Vq6u/3xp8ttd5YowFAjRob6hsqySJp7bKFIEkCLAiSpIKXjHRMemrX1lXvY2LfOPPzC8uu9/r156z6WNIgDLwgRMRjwEvF7DPAJ4EPAQvA5sz8g0FnkiQNuCBExHEAmbmpZdnjwDuBp4F7I2JjZn5jkLkkSYNvIZwLTEXE5uLYNwKTmbkVICLuBy4CjpmCMLauMewIkgQMviDsBz4IfBp4PXAfsLvl873A2cvtZP36KcbHxyoJ2M709CQAEwe6n64GUK/XGBtr31dfq9eOXMaRywahXqvmuPUebq2dmGh/XjstHyVlMk5PTa54v7OzM73EGdj+qmDG/uk156D/xT0JfCczl4AnI+Il4OSWz2d4dYFoa9eu/RXFa29urvne3PnF7h2IY0CjscTiYvu/+pcaS0cu48hlVatRo7FUzXEbjZW3eP7f3OlHLKvX6yva10+tK/csRj9NTJTrVO7lvcvbt+/tJVJbs7Mzfd1fFczYP91yLlcoBl0QrgD+KfBbEfETwBQwFxHn0OxDuAQYuU7l7443v5j2LPMlWpuZBeBAhxaCJI2yQReEzwC3RcRfAUs0C0QD+DOaf2BvzsyvDziTJIkBF4TMPAj82zYfvWmQOSRJR/LahiQJsCBIkgoWBEkSYEGQJBUsCJIkwIIgSSqM/tgAWlPGX9q3qu0XTjyhT0kkrZQtBEkSYAvhZTvuvrPjZ9ON5vgfuye7D7O0/Kg2kjS6LAgVmO8wuF1bxYB3Y21GQpWkQfKSkSQJsIUwMhbbDI3djS2Ko9vu5x/o277mX5rsOgT3Sadt6tuxtLZZEHRUeOLgmavexzDeqSCNEi8ZSZIAC4IkqWBBkCQBFgRJUsGCIEkCjsG7jO7a8nTb5bPbdnXe6LUzFaWRpNFhC0GSBByDLQQ1bWtsW/E2Z9TPqCDJ0e+pXVsHcpzXrz9nIMfR0csWgiQJOIZbCFsX/+ZV88/Pbu+47s7Jg1XHkYamn8NkLMdhMkbbMVsQ1jrHPpLUbxYElTaIfodDb1yr12o0llZW9MA3rkmrYR+CJAmwhSC9bKUjptYX6jQaR74MyVFTtVbZQpAkAbYQjhmtndC1GiyVuD6/1juiF+Z6zz8+vfL+i0P+btdZqz5umVbG33z7pFfPs7PtevWxOo1lXut6/k92f1/44bo98/Dlxzsf67jvtB8pYHp6krm5zi/x6Ye3v+XsSvd/NLCFIEkCbCFIy3rmqfYtjWZL68jPGvOd93Xm6l/sJlXGgqCj0jNP1bp+MXdTW1hkrL748nynZnQNaHdhqVFf19uBh+jwy0/Lrt/h8tSyDrQfRLL+YufLWicfv76nQx13wlk9bXcsG4mCEBF14E+Ac4EfAf8+M78z3FRqtbjU26/KM4vfZ6y2sKJtWp9dOLg4uaJtG0W/Qa/F4JDFxtiy63QqCLXGYpulTduWGdZorL5IY3Id+8ZW9gWt5XUa6bisqvo5RqlvYyQKAvB24LjM/PmIeBNwM3DZkDNphTp1VC8sdf5yrdVeueSye09zeifPr/jY03sOdXI2v4zXanf4YmOMpXl4Yb63glCfePX87NjKOot7VWUH/osdWhXLmZvv3pF+uNevH50v5mEZlYLwZuDLAJn5fyPiZ4ecRyOq081R+2Y6/+lda/Nd9UoB0dFqeuGlFa3//e2Pdf2822WtlWq9DLb7+fIjAFQ9FtSoFITXAK0/vcWIGM/MttcaZmdnev5z5D+849xi6tyu60nSWjU729tLvUblttM9QOv/Qb1TMZAkVWNUCsJDwL8EKPoQ/m64cSTp2DMql4zuBH4pIv6aZn/ge4acR5KOObUyQxhIko5+o3LJSJI0ZBYESRJgQZAkFUalU3lNiojHeOX5iWeATwIfAhaAzZn5B0PMdgFwU2ZuiojXAbfRHGnhm8BVmdmIiBuAS4u812TmI0POuRG4B3iq+PjjmfnFYeWMiAngVuAsYBL4APAtRuxcdsj5XUbrXI4BnwKC5uPk76F5A8ltjNa5bJfzREboXLZkPQV4FPilIsNtrPJcWhB6FBHHAWTmppZljwPvBJ4G7o2IjZn5jSFkex9wOTBXLLoFuC4zH4iITwCXRcSzwIXABcAG4A7g/CHn3Ajckpk3t6yzcYg53w3szMzLI+LHgMeAxxm9c9ku5x8yWufyVwAy859FxCaav5M1Ru9ctst5D6N1Lg/9EfBJ4ECxqC//xr1k1LtzgamI2BwRX4mItwKTmbk1M5eA+4GLhpRtK/COlvnzgAeL6fuAX6Q5XMjmzFzKzG3AeETMDjZm25yXRsTXIuIzETEz5JxfAq5vmV9gNM9lp5wjcy4z8y7gymL2TOAFRvBcdsk5Muey8EHgE8D3i/m+nEsLQu/20/yhXAL8R+CzxbJD9tJsag5cZt4BtI73WSuKFLyS6/DhQgaet03OR4D/kplvpdnKuoEh5szMfZm5t/gCuB24jhE8lx1yjtS5LHIuRMSfAh8pco7cueyQc6TOZUT8O2B7Zt7fsrgv59KC0Lsngf9eVN8naZ74k1s+nwEGM9Tk8lpH5DqU6/DhQkYh752Z+eihaeBnGHLOiNgAfBX4fGZ+gRE9l21yjty5BMjM3wDeQPM6/fFtsgw9IxyRc/OIncsraD7I+wDw08DngFPaZFlxRgtC766gOUw3EfETwBQwFxHnRESNZsthyxDztXqsuB4K8DaauR4CLomIekScQXP8qB3DCli4PyJ+rpi+iGaH2dByRsSpwGbg2sy8tVg8cueyQ85RO5eXR8TvFbP7aRbWvx3Bc9ku51+M0rnMzLdm5oVF/+XjwK8D9/XjXNqp3LvPALdFxF/R7Nm/guYvz58BYzT/qvj6EPO1ei/wqYhYBzwB3J6ZixGxBXiY5h8GVw0zYOE3gY9GxEHgB8CVmblniDnfD6wHro+IQ9forwY+PGLnsl3O3wX+eITO5V8An42IrwETwDU0z9+o/V62y/kco/V72U5f/o07dIUkCfCSkSSpYEGQJAEWBElSwYIgSQIsCJKkggVBkgRYECRJhf8PLzek7aQtVv0AAAAASUVORK5CYII=\n",
"text/plain": [
"<Figure size 432x288 with 1 Axes>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"df2.groupby(\"Category\")['APM'].plot(kind=\"hist\", alpha=.5)"
]
},
{
"cell_type": "code",
"execution_count": 130,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Category\n",
"Bronze 167\n",
"Diamond 806\n",
"Gold 553\n",
"GrandMaster 35\n",
"Master 621\n",
"Platinum 811\n",
"Professional Leagues 55\n",
"Silver 347\n",
"dtype: int64"
]
},
"execution_count": 130,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df2.groupby(\"Category\").size() # / df2.shape[0]"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": 131,
"metadata": {},
"outputs": [],
"source": [
"import patsy\n",
"\n",
"formula = \"\"\n"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"X = combined.drop(columns=['Category','LeagueIndex'])\n",
"y = combined['LeagueIndex']\n",
"X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=.33, random_state=42)\n",
"\n",
"lr = LogisticRegression()\n",
"lr.fit(X_train, y_train)\n",
"print(lr.score(X_train, y_train))\n",
"print(lr.score(X_test, y_test))\n",
"lr.co"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python [conda env:dsi]",
"language": "python",
"name": "conda-env-dsi-py"
},
"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.5"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment