New Dataset Revised for Period #1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "63001d10",
   "metadata": {},
   "outputs": [],
   "source": [
    "### Game Date for only periods 1 ###"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "id": "cf5fe8f1",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "pd.set_option(\"display.max_rows\", None)\n",
    "pd.set_option('display.max_columns', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "id": "57eadfdf",
   "metadata": {},
   "outputs": [],
   "source": [
    "gd = pd.read_csv(\"/Users/matthewbuttlerives/Downloads/game.csv\")\n",
    "gp = pd.read_csv(\"/Users/matthewbuttlerives/Downloads/game_plays.csv\")\n",
    "gts = pd.read_csv(\"/Users/matthewbuttlerives/Downloads/game_teams_stats.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "id": "49b28ba7",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Selecting data for first and second \n",
    "Period_1 = gp[(gp.period == 1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "id": "22c7a9e8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Game Scheduled', 'Period Ready', 'Period Start', 'Faceoff',\n",
       "       'Shot', 'Goal', 'Takeaway', 'Hit', 'Stoppage', 'Blocked Shot',\n",
       "       'Giveaway', 'Missed Shot', 'Penalty', 'Period End',\n",
       "       'Period Official', 'Official Challenge',\n",
       "       'Early Intermission Start', 'Early Intermission End'], dtype=object)"
      ]
     },
     "execution_count": 130,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "column_values = Period_1[\"event\"].values.ravel()\n",
    "unique_values =  pd.unique(column_values)\n",
    "unique_values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "id": "0888f592",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([nan, 'Wrist Shot', 'Wrap-around', 'Slap Shot', 'Hooking', 'Tip-In',\n",
       "       'Snap Shot', 'Backhand', 'Closing hand on puck', 'Interference',\n",
       "       'Roughing', 'Hi-sticking', 'Slashing', 'Fighting',\n",
       "       'Cross checking', 'Too many men on the ice', 'Holding', 'Boarding',\n",
       "       'Game misconduct', 'Tripping', 'Deflected', 'Holding the stick',\n",
       "       'Delaying Game - Puck over glass', 'Illegal equipment',\n",
       "       'Embellishment', 'Interference - Goalkeeper',\n",
       "       'Instigator - Misconduct', 'Instigator', 'Match penalty',\n",
       "       'Charging', 'Unsportsmanlike conduct', 'PS - Hooking on breakaway',\n",
       "       'Delaying Game - Illegal play by goalie', 'Illegal check to head',\n",
       "       'Misconduct', 'Delay of game', 'Kneeing', 'Bench', 'Elbowing',\n",
       "       'Hi stick - double minor', 'Clipping', 'Abusive language',\n",
       "       'Face-off violation', 'PS - Tripping on breakaway',\n",
       "       'Instigator - face shield', 'Delay Gm - Face-off Violation',\n",
       "       'Broken stick', 'Throwing stick',\n",
       "       'Delaying Game - Smothering puck', 'Delaying the game',\n",
       "       'PS - Slash on breakaway', 'Illegal stick',\n",
       "       'PS - Holding on breakaway', 'Concealing puck', 'Spearing',\n",
       "       'Diving', 'Abuse of Officials', 'Checking from behind',\n",
       "       'Butt ending', \"Leaving player's/penalty bench\", 'Head butting',\n",
       "       'PS - Thow object at puck', 'PS - Covering puck in crease',\n",
       "       'Illegal substitution', 'Spearing - double minor',\n",
       "       'Goalie leave crease', 'Cross check - double minor',\n",
       "       'Holding - Obstruction', 'Hooking - Obstruction',\n",
       "       'Unsportsmanlike conduct - Coach', 'Holding stick - Obstruction',\n",
       "       'Interference - Obstruction', 'Tripping - Obstruction',\n",
       "       'Attempt to injure', 'Deliberate injury', 'Gross misconduct',\n",
       "       'Objects on ice', 'Missing key [PD_151]',\n",
       "       'Playing without a helmet'], dtype=object)"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "column_values = Period_1[\"secondaryType\"].values.ravel()\n",
    "unique_values =  pd.unique(column_values)\n",
    "unique_values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "id": "f058c807",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Preparing to group data together\n",
    "test = Period_1[[\"game_id\",\"team_id_for\",\"event\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "id": "eebe6bb0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1687828, 3)"
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "id": "d6c7f4a1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "game_id             0\n",
       "team_id_for    301873\n",
       "event               0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Many missing null values do not have a team associated to them such as Period Ready or Period Start\n",
    "test.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "id": "163e7b16",
   "metadata": {},
   "outputs": [],
   "source": [
    "test = test.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "id": "e8f38aeb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1385955, 3)"
      ]
     },
     "execution_count": 136,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "id": "f8370a72",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Creating dataframe of shots on net\n",
    "test = test[(test.event == \"Shot\")|\n",
    "             (test.event == \"Goal\")|(test.event == \"Takeaway\")|\n",
    "             (test.event == \"Hit\")|(test.event == \"Blocked Shot\")|\n",
    "            (test.event == \"Giveaway\")|(test.event == \"Missed Shot\")|\n",
    "                    (test.event == \"Penalty\")|(test.event == \"Faceoff\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "id": "fb2089f4",
   "metadata": {},
   "outputs": [],
   "source": [
    "Shot_test = test[(test.event == \"Shot\")]\n",
    "tq = Shot_test.groupby([\"game_id\",\"team_id_for\"]).size()\n",
    "tq = pd.DataFrame(tq)\n",
    "tq = tq.reset_index()\n",
    "tq = tq.rename(columns={0: \"Shots\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "id": "39c350ee",
   "metadata": {},
   "outputs": [],
   "source": [
    "Goal_test = test[(test.event == \"Goal\")]\n",
    "tq2 = Goal_test.groupby([\"game_id\",\"team_id_for\"]).size()\n",
    "tq2 = pd.DataFrame(tq2)\n",
    "tq2 = tq2.reset_index()\n",
    "tq2 = tq2.rename(columns={0: \"Goals\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "id": "8640dfe5",
   "metadata": {},
   "outputs": [],
   "source": [
    "Take_test = test[(test.event == \"Takeaway\")]\n",
    "tq3 = Take_test.groupby([\"game_id\",\"team_id_for\"]).size()\n",
    "tq3 = pd.DataFrame(tq3)\n",
    "tq3 = tq3.reset_index()\n",
    "tq3 = tq3.rename(columns={0: \"Takeaways\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "id": "149c17ed",
   "metadata": {},
   "outputs": [],
   "source": [
    "Hit_test = test[(test.event == \"Hit\")]\n",
    "tq4 = Hit_test.groupby([\"game_id\",\"team_id_for\"]).size()\n",
    "tq4 = pd.DataFrame(tq4)\n",
    "tq4 = tq4.reset_index()\n",
    "tq4 = tq4.rename(columns={0: \"Hits\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "id": "d9e6d17d",
   "metadata": {},
   "outputs": [],
   "source": [
    "Block_test = test[(test.event == \"Blocked Shot\")]\n",
    "tq5 = Block_test.groupby([\"game_id\",\"team_id_for\"]).size()\n",
    "tq5 = pd.DataFrame(tq5)\n",
    "tq5 = tq5.reset_index()\n",
    "tq5 = tq5.rename(columns={0: \"Blocked Shots\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "id": "1e1e34f2",
   "metadata": {},
   "outputs": [],
   "source": [
    "Give_test = test[(test.event == \"Giveaway\")]\n",
    "tq6 = Give_test.groupby([\"game_id\",\"team_id_for\"]).size()\n",
    "tq6 = pd.DataFrame(tq6)\n",
    "tq6 = tq6.reset_index()\n",
    "tq6 = tq6.rename(columns={0: \"Giveaways\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "id": "0256c265",
   "metadata": {},
   "outputs": [],
   "source": [
    "Miss_test = test[(test.event == \"Missed Shot\")]\n",
    "tq7 = Miss_test.groupby([\"game_id\",\"team_id_for\"]).size()\n",
    "tq7 = pd.DataFrame(tq7)\n",
    "tq7 = tq7.reset_index()\n",
    "tq7 = tq7.rename(columns={0: \"Missed Shots\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "id": "1e1b760c",
   "metadata": {},
   "outputs": [],
   "source": [
    "Penality_test = test[(test.event == \"Penalty\")]\n",
    "tq8 = Penality_test.groupby([\"game_id\",\"team_id_for\"]).size()\n",
    "tq8 = pd.DataFrame(tq8)\n",
    "tq8 = tq8.reset_index()\n",
    "tq8 = tq8.rename(columns={0: \"Penalities\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "id": "6eb11aba",
   "metadata": {},
   "outputs": [],
   "source": [
    "Face_test = test[(test.event == \"Faceoff\")]\n",
    "tq9 = Face_test.groupby([\"game_id\",\"team_id_for\"]).size()\n",
    "tq9 = pd.DataFrame(tq9)\n",
    "tq9 = tq9.reset_index()\n",
    "tq9 = tq9.rename(columns={0: \"#Won Faceoffs\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "id": "efa2f5da",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Renaming columns to prepare for left join merge\n",
    "gts = gts.rename(columns={'team_id': \"team_id_for\"})\n",
    "new_df = pd.merge(gts,tq,how='left', left_on=['game_id','team_id_for'], right_on=['game_id','team_id_for'])\n",
    "new_df = pd.merge(new_df,tq2,how='left', left_on=['game_id','team_id_for'], right_on=['game_id','team_id_for'])\n",
    "new_df = pd.merge(new_df,tq3,how='left', left_on=['game_id','team_id_for'], right_on=['game_id','team_id_for'])\n",
    "new_df = pd.merge(new_df,tq4,how='left', left_on=['game_id','team_id_for'], right_on=['game_id','team_id_for'])\n",
    "new_df = pd.merge(new_df,tq5,how='left', left_on=['game_id','team_id_for'], right_on=['game_id','team_id_for'])\n",
    "new_df = pd.merge(new_df,tq6,how='left', left_on=['game_id','team_id_for'], right_on=['game_id','team_id_for'])\n",
    "new_df = pd.merge(new_df,tq7,how='left', left_on=['game_id','team_id_for'], right_on=['game_id','team_id_for'])\n",
    "new_df = pd.merge(new_df,tq8,how='left', left_on=['game_id','team_id_for'], right_on=['game_id','team_id_for'])\n",
    "new_df = pd.merge(new_df,tq9,how='left', left_on=['game_id','team_id_for'], right_on=['game_id','team_id_for'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "id": "d3f50c44",
   "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>game_id</th>\n",
       "      <th>team_id_for</th>\n",
       "      <th>HoA</th>\n",
       "      <th>won</th>\n",
       "      <th>settled_in</th>\n",
       "      <th>head_coach</th>\n",
       "      <th>goals</th>\n",
       "      <th>shots</th>\n",
       "      <th>hits</th>\n",
       "      <th>pim</th>\n",
       "      <th>powerPlayOpportunities</th>\n",
       "      <th>powerPlayGoals</th>\n",
       "      <th>faceOffWinPercentage</th>\n",
       "      <th>giveaways</th>\n",
       "      <th>takeaways</th>\n",
       "      <th>blocked</th>\n",
       "      <th>startRinkSide</th>\n",
       "      <th>Shots</th>\n",
       "      <th>Goals</th>\n",
       "      <th>Takeaways</th>\n",
       "      <th>Hits</th>\n",
       "      <th>Blocked Shots</th>\n",
       "      <th>Giveaways</th>\n",
       "      <th>Missed Shots</th>\n",
       "      <th>Penalities</th>\n",
       "      <th>#Won Faceoffs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016020045</td>\n",
       "      <td>4</td>\n",
       "      <td>away</td>\n",
       "      <td>False</td>\n",
       "      <td>REG</td>\n",
       "      <td>Dave Hakstol</td>\n",
       "      <td>4.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>50.9</td>\n",
       "      <td>12.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>left</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016020045</td>\n",
       "      <td>16</td>\n",
       "      <td>home</td>\n",
       "      <td>True</td>\n",
       "      <td>REG</td>\n",
       "      <td>Joel Quenneville</td>\n",
       "      <td>7.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>49.1</td>\n",
       "      <td>16.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>left</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017020812</td>\n",
       "      <td>24</td>\n",
       "      <td>away</td>\n",
       "      <td>True</td>\n",
       "      <td>OT</td>\n",
       "      <td>Randy Carlyle</td>\n",
       "      <td>4.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>43.8</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>right</td>\n",
       "      <td>11.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017020812</td>\n",
       "      <td>7</td>\n",
       "      <td>home</td>\n",
       "      <td>False</td>\n",
       "      <td>OT</td>\n",
       "      <td>Phil Housley</td>\n",
       "      <td>3.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>56.2</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>right</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015020314</td>\n",
       "      <td>21</td>\n",
       "      <td>away</td>\n",
       "      <td>True</td>\n",
       "      <td>REG</td>\n",
       "      <td>Patrick Roy</td>\n",
       "      <td>4.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>45.7</td>\n",
       "      <td>13.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>left</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2015020314</td>\n",
       "      <td>52</td>\n",
       "      <td>home</td>\n",
       "      <td>False</td>\n",
       "      <td>REG</td>\n",
       "      <td>Paul Maurice</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54.3</td>\n",
       "      <td>13.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>left</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2015020849</td>\n",
       "      <td>52</td>\n",
       "      <td>away</td>\n",
       "      <td>False</td>\n",
       "      <td>REG</td>\n",
       "      <td>Paul Maurice</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.4</td>\n",
       "      <td>4.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>left</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2015020849</td>\n",
       "      <td>12</td>\n",
       "      <td>home</td>\n",
       "      <td>True</td>\n",
       "      <td>REG</td>\n",
       "      <td>Bill Peters</td>\n",
       "      <td>2.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>68.6</td>\n",
       "      <td>12.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>left</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017020586</td>\n",
       "      <td>20</td>\n",
       "      <td>away</td>\n",
       "      <td>False</td>\n",
       "      <td>REG</td>\n",
       "      <td>Glen Gulutzan</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54.7</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>right</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017020586</td>\n",
       "      <td>24</td>\n",
       "      <td>home</td>\n",
       "      <td>True</td>\n",
       "      <td>REG</td>\n",
       "      <td>Randy Carlyle</td>\n",
       "      <td>2.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>45.3</td>\n",
       "      <td>13.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>right</td>\n",
       "      <td>19.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      game_id  team_id_for   HoA    won settled_in        head_coach  goals  \\\n",
       "0  2016020045            4  away  False        REG      Dave Hakstol    4.0   \n",
       "1  2016020045           16  home   True        REG  Joel Quenneville    7.0   \n",
       "2  2017020812           24  away   True         OT     Randy Carlyle    4.0   \n",
       "3  2017020812            7  home  False         OT      Phil Housley    3.0   \n",
       "4  2015020314           21  away   True        REG       Patrick Roy    4.0   \n",
       "5  2015020314           52  home  False        REG      Paul Maurice    1.0   \n",
       "6  2015020849           52  away  False        REG      Paul Maurice    1.0   \n",
       "7  2015020849           12  home   True        REG       Bill Peters    2.0   \n",
       "8  2017020586           20  away  False        REG     Glen Gulutzan    1.0   \n",
       "9  2017020586           24  home   True        REG     Randy Carlyle    2.0   \n",
       "\n",
       "   shots  hits   pim  powerPlayOpportunities  powerPlayGoals  \\\n",
       "0   27.0  30.0   6.0                     4.0             2.0   \n",
       "1   28.0  20.0   8.0                     3.0             2.0   \n",
       "2   34.0  16.0   6.0                     3.0             1.0   \n",
       "3   33.0  17.0   8.0                     2.0             1.0   \n",
       "4   29.0  17.0   9.0                     3.0             1.0   \n",
       "5   21.0  22.0  11.0                     2.0             0.0   \n",
       "6   21.0  21.0  10.0                     4.0             0.0   \n",
       "7   29.0  16.0   8.0                     5.0             2.0   \n",
       "8   23.0  20.0  19.0                     3.0             0.0   \n",
       "9   41.0  15.0  13.0                     6.0             1.0   \n",
       "\n",
       "   faceOffWinPercentage  giveaways  takeaways  blocked startRinkSide  Shots  \\\n",
       "0                  50.9       12.0        9.0     11.0          left    8.0   \n",
       "1                  49.1       16.0        8.0      9.0          left    8.0   \n",
       "2                  43.8        7.0        4.0     14.0         right   11.0   \n",
       "3                  56.2        5.0        6.0     14.0         right   12.0   \n",
       "4                  45.7       13.0        5.0     20.0          left    9.0   \n",
       "5                  54.3       13.0        7.0      9.0          left    8.0   \n",
       "6                  31.4        4.0       14.0     16.0          left    4.0   \n",
       "7                  68.6       12.0       11.0     13.0          left    8.0   \n",
       "8                  54.7       10.0        4.0      7.0         right    5.0   \n",
       "9                  45.3       13.0        4.0     21.0         right   19.0   \n",
       "\n",
       "   Goals  Takeaways  Hits  Blocked Shots  Giveaways  Missed Shots  Penalities  \\\n",
       "0    NaN        1.0  14.0            3.0        6.0           4.0         1.0   \n",
       "1    3.0        3.0   5.0            3.0        7.0           NaN         1.0   \n",
       "2    NaN        NaN   4.0            6.0        2.0           6.0         1.0   \n",
       "3    1.0        2.0   4.0            8.0        NaN           3.0         3.0   \n",
       "4    NaN        3.0   4.0            7.0        7.0           3.0         2.0   \n",
       "5    1.0        2.0   5.0            1.0        5.0           8.0         1.0   \n",
       "6    NaN        5.0  12.0            3.0        2.0           3.0         1.0   \n",
       "7    1.0        5.0   5.0            4.0        2.0           3.0         3.0   \n",
       "8    NaN        2.0   9.0            3.0        4.0           2.0         5.0   \n",
       "9    1.0        4.0   6.0            3.0        5.0           6.0         3.0   \n",
       "\n",
       "   #Won Faceoffs  \n",
       "0           10.0  \n",
       "1           12.0  \n",
       "2           11.0  \n",
       "3            9.0  \n",
       "4            7.0  \n",
       "5           11.0  \n",
       "6            5.0  \n",
       "7           12.0  \n",
       "8            7.0  \n",
       "9           11.0  "
      ]
     },
     "execution_count": 148,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "id": "4e888dee",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Nan values represent zero so just replace those\n",
    "new_df[['Shots','Goals','Takeaways','Hits','Blocked Shots','Giveaways','Missed Shots','Penalities',\"#Won Faceoffs\"]] = new_df[['Shots','Goals','Takeaways','Hits','Blocked Shots','Giveaways','Missed Shots','Penalities',\"#Won Faceoffs\"]].fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "id": "99d33af1",
   "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>game_id</th>\n",
       "      <th>team_id_for</th>\n",
       "      <th>HoA</th>\n",
       "      <th>won</th>\n",
       "      <th>settled_in</th>\n",
       "      <th>head_coach</th>\n",
       "      <th>goals</th>\n",
       "      <th>shots</th>\n",
       "      <th>hits</th>\n",
       "      <th>pim</th>\n",
       "      <th>powerPlayOpportunities</th>\n",
       "      <th>powerPlayGoals</th>\n",
       "      <th>faceOffWinPercentage</th>\n",
       "      <th>giveaways</th>\n",
       "      <th>takeaways</th>\n",
       "      <th>blocked</th>\n",
       "      <th>startRinkSide</th>\n",
       "      <th>Shots</th>\n",
       "      <th>Goals</th>\n",
       "      <th>Takeaways</th>\n",
       "      <th>Hits</th>\n",
       "      <th>Blocked Shots</th>\n",
       "      <th>Giveaways</th>\n",
       "      <th>Missed Shots</th>\n",
       "      <th>Penalities</th>\n",
       "      <th>#Won Faceoffs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016020045</td>\n",
       "      <td>4</td>\n",
       "      <td>away</td>\n",
       "      <td>False</td>\n",
       "      <td>REG</td>\n",
       "      <td>Dave Hakstol</td>\n",
       "      <td>4.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>50.9</td>\n",
       "      <td>12.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>left</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016020045</td>\n",
       "      <td>16</td>\n",
       "      <td>home</td>\n",
       "      <td>True</td>\n",
       "      <td>REG</td>\n",
       "      <td>Joel Quenneville</td>\n",
       "      <td>7.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>49.1</td>\n",
       "      <td>16.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>left</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017020812</td>\n",
       "      <td>24</td>\n",
       "      <td>away</td>\n",
       "      <td>True</td>\n",
       "      <td>OT</td>\n",
       "      <td>Randy Carlyle</td>\n",
       "      <td>4.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>43.8</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>right</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017020812</td>\n",
       "      <td>7</td>\n",
       "      <td>home</td>\n",
       "      <td>False</td>\n",
       "      <td>OT</td>\n",
       "      <td>Phil Housley</td>\n",
       "      <td>3.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>56.2</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>right</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015020314</td>\n",
       "      <td>21</td>\n",
       "      <td>away</td>\n",
       "      <td>True</td>\n",
       "      <td>REG</td>\n",
       "      <td>Patrick Roy</td>\n",
       "      <td>4.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>45.7</td>\n",
       "      <td>13.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>left</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2015020314</td>\n",
       "      <td>52</td>\n",
       "      <td>home</td>\n",
       "      <td>False</td>\n",
       "      <td>REG</td>\n",
       "      <td>Paul Maurice</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54.3</td>\n",
       "      <td>13.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>left</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2015020849</td>\n",
       "      <td>52</td>\n",
       "      <td>away</td>\n",
       "      <td>False</td>\n",
       "      <td>REG</td>\n",
       "      <td>Paul Maurice</td>\n",
       "      <td>1.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31.4</td>\n",
       "      <td>4.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>left</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2015020849</td>\n",
       "      <td>12</td>\n",
       "      <td>home</td>\n",
       "      <td>True</td>\n",
       "      <td>REG</td>\n",
       "      <td>Bill Peters</td>\n",
       "      <td>2.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>68.6</td>\n",
       "      <td>12.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>left</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017020586</td>\n",
       "      <td>20</td>\n",
       "      <td>away</td>\n",
       "      <td>False</td>\n",
       "      <td>REG</td>\n",
       "      <td>Glen Gulutzan</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54.7</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>right</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017020586</td>\n",
       "      <td>24</td>\n",
       "      <td>home</td>\n",
       "      <td>True</td>\n",
       "      <td>REG</td>\n",
       "      <td>Randy Carlyle</td>\n",
       "      <td>2.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>45.3</td>\n",
       "      <td>13.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>right</td>\n",
       "      <td>19.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2016020610</td>\n",
       "      <td>15</td>\n",
       "      <td>away</td>\n",
       "      <td>True</td>\n",
       "      <td>REG</td>\n",
       "      <td>Barry Trotz</td>\n",
       "      <td>4.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>46.6</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>left</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2016020610</td>\n",
       "      <td>8</td>\n",
       "      <td>home</td>\n",
       "      <td>False</td>\n",
       "      <td>REG</td>\n",
       "      <td>Michel Therrien</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>53.4</td>\n",
       "      <td>12.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>left</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2015020606</td>\n",
       "      <td>10</td>\n",
       "      <td>away</td>\n",
       "      <td>False</td>\n",
       "      <td>REG</td>\n",
       "      <td>Mike Babcock</td>\n",
       "      <td>1.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>56.9</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>left</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2015020606</td>\n",
       "      <td>26</td>\n",
       "      <td>home</td>\n",
       "      <td>True</td>\n",
       "      <td>REG</td>\n",
       "      <td>Darryl Sutter</td>\n",
       "      <td>2.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>43.1</td>\n",
       "      <td>12.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>left</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2017020240</td>\n",
       "      <td>23</td>\n",
       "      <td>away</td>\n",
       "      <td>False</td>\n",
       "      <td>REG</td>\n",
       "      <td>Travis Green</td>\n",
       "      <td>1.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>47.5</td>\n",
       "      <td>13.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>right</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2017020240</td>\n",
       "      <td>24</td>\n",
       "      <td>home</td>\n",
       "      <td>True</td>\n",
       "      <td>REG</td>\n",
       "      <td>Randy Carlyle</td>\n",
       "      <td>4.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>52.5</td>\n",
       "      <td>11.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>right</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2017020624</td>\n",
       "      <td>29</td>\n",
       "      <td>away</td>\n",
       "      <td>False</td>\n",
       "      <td>REG</td>\n",
       "      <td>John Tortorella</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57.6</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>left</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2017020624</td>\n",
       "      <td>21</td>\n",
       "      <td>home</td>\n",
       "      <td>True</td>\n",
       "      <td>REG</td>\n",
       "      <td>Jared Bednar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>42.4</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>left</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2015020346</td>\n",
       "      <td>22</td>\n",
       "      <td>away</td>\n",
       "      <td>True</td>\n",
       "      <td>OT</td>\n",
       "      <td>Todd McLellan</td>\n",
       "      <td>2.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>50.6</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>right</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2015020346</td>\n",
       "      <td>5</td>\n",
       "      <td>home</td>\n",
       "      <td>False</td>\n",
       "      <td>OT</td>\n",
       "      <td>Mike Johnston</td>\n",
       "      <td>2.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>49.4</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>right</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       game_id  team_id_for   HoA    won settled_in        head_coach  goals  \\\n",
       "0   2016020045            4  away  False        REG      Dave Hakstol    4.0   \n",
       "1   2016020045           16  home   True        REG  Joel Quenneville    7.0   \n",
       "2   2017020812           24  away   True         OT     Randy Carlyle    4.0   \n",
       "3   2017020812            7  home  False         OT      Phil Housley    3.0   \n",
       "4   2015020314           21  away   True        REG       Patrick Roy    4.0   \n",
       "5   2015020314           52  home  False        REG      Paul Maurice    1.0   \n",
       "6   2015020849           52  away  False        REG      Paul Maurice    1.0   \n",
       "7   2015020849           12  home   True        REG       Bill Peters    2.0   \n",
       "8   2017020586           20  away  False        REG     Glen Gulutzan    1.0   \n",
       "9   2017020586           24  home   True        REG     Randy Carlyle    2.0   \n",
       "10  2016020610           15  away   True        REG       Barry Trotz    4.0   \n",
       "11  2016020610            8  home  False        REG   Michel Therrien    1.0   \n",
       "12  2015020606           10  away  False        REG      Mike Babcock    1.0   \n",
       "13  2015020606           26  home   True        REG     Darryl Sutter    2.0   \n",
       "14  2017020240           23  away  False        REG      Travis Green    1.0   \n",
       "15  2017020240           24  home   True        REG     Randy Carlyle    4.0   \n",
       "16  2017020624           29  away  False        REG   John Tortorella    0.0   \n",
       "17  2017020624           21  home   True        REG      Jared Bednar    2.0   \n",
       "18  2015020346           22  away   True         OT     Todd McLellan    2.0   \n",
       "19  2015020346            5  home  False         OT     Mike Johnston    2.0   \n",
       "\n",
       "    shots  hits   pim  powerPlayOpportunities  powerPlayGoals  \\\n",
       "0    27.0  30.0   6.0                     4.0             2.0   \n",
       "1    28.0  20.0   8.0                     3.0             2.0   \n",
       "2    34.0  16.0   6.0                     3.0             1.0   \n",
       "3    33.0  17.0   8.0                     2.0             1.0   \n",
       "4    29.0  17.0   9.0                     3.0             1.0   \n",
       "5    21.0  22.0  11.0                     2.0             0.0   \n",
       "6    21.0  21.0  10.0                     4.0             0.0   \n",
       "7    29.0  16.0   8.0                     5.0             2.0   \n",
       "8    23.0  20.0  19.0                     3.0             0.0   \n",
       "9    41.0  15.0  13.0                     6.0             1.0   \n",
       "10   39.0  19.0   8.0                     2.0             1.0   \n",
       "11   23.0  27.0   4.0                     4.0             1.0   \n",
       "12   26.0  24.0  19.0                     4.0             1.0   \n",
       "13   41.0  23.0  10.0                     2.0             0.0   \n",
       "14   20.0  11.0  27.0                     5.0             0.0   \n",
       "15   35.0  10.0  15.0                     6.0             3.0   \n",
       "16   34.0  12.0   8.0                     3.0             0.0   \n",
       "17   32.0  20.0   8.0                     3.0             1.0   \n",
       "18   36.0  31.0   8.0                     4.0             1.0   \n",
       "19   41.0  36.0   8.0                     4.0             1.0   \n",
       "\n",
       "    faceOffWinPercentage  giveaways  takeaways  blocked startRinkSide  Shots  \\\n",
       "0                   50.9       12.0        9.0     11.0          left    8.0   \n",
       "1                   49.1       16.0        8.0      9.0          left    8.0   \n",
       "2                   43.8        7.0        4.0     14.0         right   11.0   \n",
       "3                   56.2        5.0        6.0     14.0         right   12.0   \n",
       "4                   45.7       13.0        5.0     20.0          left    9.0   \n",
       "5                   54.3       13.0        7.0      9.0          left    8.0   \n",
       "6                   31.4        4.0       14.0     16.0          left    4.0   \n",
       "7                   68.6       12.0       11.0     13.0          left    8.0   \n",
       "8                   54.7       10.0        4.0      7.0         right    5.0   \n",
       "9                   45.3       13.0        4.0     21.0         right   19.0   \n",
       "10                  46.6        8.0        5.0     24.0          left   11.0   \n",
       "11                  53.4       12.0        7.0     18.0          left    7.0   \n",
       "12                  56.9        6.0        2.0      7.0          left    6.0   \n",
       "13                  43.1       12.0        2.0     14.0          left   16.0   \n",
       "14                  47.5       13.0        5.0     15.0         right    5.0   \n",
       "15                  52.5       11.0        6.0     12.0         right   15.0   \n",
       "16                  57.6        3.0        8.0     14.0          left    7.0   \n",
       "17                  42.4        5.0        5.0     13.0          left   14.0   \n",
       "18                  50.6        5.0        2.0     17.0         right   11.0   \n",
       "19                  49.4       10.0        5.0     12.0         right   14.0   \n",
       "\n",
       "    Goals  Takeaways  Hits  Blocked Shots  Giveaways  Missed Shots  \\\n",
       "0     0.0        1.0  14.0            3.0        6.0           4.0   \n",
       "1     3.0        3.0   5.0            3.0        7.0           0.0   \n",
       "2     0.0        0.0   4.0            6.0        2.0           6.0   \n",
       "3     1.0        2.0   4.0            8.0        0.0           3.0   \n",
       "4     0.0        3.0   4.0            7.0        7.0           3.0   \n",
       "5     1.0        2.0   5.0            1.0        5.0           8.0   \n",
       "6     0.0        5.0  12.0            3.0        2.0           3.0   \n",
       "7     1.0        5.0   5.0            4.0        2.0           3.0   \n",
       "8     0.0        2.0   9.0            3.0        4.0           2.0   \n",
       "9     1.0        4.0   6.0            3.0        5.0           6.0   \n",
       "10    1.0        1.0   9.0            7.0        4.0           1.0   \n",
       "11    0.0        0.0  15.0            5.0        3.0           3.0   \n",
       "12    0.0        1.0  12.0            2.0        4.0           0.0   \n",
       "13    0.0        0.0  10.0            0.0        3.0           8.0   \n",
       "14    1.0        3.0   5.0            9.0        4.0           1.0   \n",
       "15    1.0        2.0   5.0            3.0        5.0           7.0   \n",
       "16    0.0        4.0   7.0            9.0        1.0           7.0   \n",
       "17    0.0        1.0   9.0            2.0        3.0           3.0   \n",
       "18    2.0        0.0  14.0            8.0        0.0           3.0   \n",
       "19    0.0        1.0  14.0            1.0        2.0           8.0   \n",
       "\n",
       "    Penalities  #Won Faceoffs  \n",
       "0          1.0           10.0  \n",
       "1          1.0           12.0  \n",
       "2          1.0           11.0  \n",
       "3          3.0            9.0  \n",
       "4          2.0            7.0  \n",
       "5          1.0           11.0  \n",
       "6          1.0            5.0  \n",
       "7          3.0           12.0  \n",
       "8          5.0            7.0  \n",
       "9          3.0           11.0  \n",
       "10         0.0            6.0  \n",
       "11         0.0           10.0  \n",
       "12         3.0            7.0  \n",
       "13         1.0           12.0  \n",
       "14         3.0           10.0  \n",
       "15         0.0           12.0  \n",
       "16         2.0           12.0  \n",
       "17         2.0            9.0  \n",
       "18         1.0           16.0  \n",
       "19         1.0           13.0  "
      ]
     },
     "execution_count": 150,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c611656d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c5acddf1",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}