DHSAlumni_ESPN_Fantasy_Analytics_v2.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Modularizing DHSAlumni Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Importing necessary libraries\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import requests\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>owner_id</th>\n",
       "      <th>owner_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>8</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>9</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>11</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>12</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   owner_id        owner_name\n",
       "0         1             Zwick\n",
       "1         2        Treshansky\n",
       "2         3          Lirtzman\n",
       "3         5             Klein\n",
       "4         6         Rosenberg\n",
       "5         7              Katz\n",
       "6         8           J.Stein\n",
       "7         9         Berkowitz\n",
       "8        11             Kogan\n",
       "9        12  B.Stein/Kaminski"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Custom Owner Metadata Dictionary\n",
    "\n",
    "owners_dict = {\"owner_id\": [1, 2, 3, 5, 6, 7, 8, 9, 11, 12],\n",
    "               \"owner_name\": [\"Zwick\", \"Treshansky\", \"Lirtzman\", \"Klein\", \"Rosenberg\", \"Katz\", \"J.Stein\", \"Berkowitz\", \n",
    "                              \"Kogan\", \"B.Stein/Kaminski\"]}\n",
    "\n",
    "owners_df = pd.DataFrame(owners_dict)\n",
    "owners_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Additional Parameters for Pinging API\n",
    "\n",
    "league_id = 470074\n",
    "years = [2012, 2013, 2014, 2015, 2016, 2017, 2018]\n",
    "#url = \"https://fantasy.espn.com/apis/v3/games/ffl/leagueHistory/\" + \\\n",
    "      #str(league_id) + \"?seasonId=\" + str(year)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Empty Matchup Dataframe\n",
    "matchups = pd.DataFrame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "for year in years:\n",
    "    \n",
    "    #Setting URL and cookie parameters\n",
    "    url = \"https://fantasy.espn.com/apis/v3/games/ffl/leagueHistory/\" + str(league_id) + \"?seasonId=\" + str(year)\n",
    "    swid = \"{0E55E5A5-3637-4BE0-86CF-E2E39B9938C9}\"\n",
    "    espn_s2 = \"AEAZNuutax36J%2BmmE9X0oeTTRyhq0DrK2gcqVGB7Cxc75XXs4TJxz73ekvnJdz33IFF4fJXslPhu\" + \\\n",
    "          \"n7SEmT9Q4c%2Fv1jXfA%2B4Kl6scPVRUks%2B5xLpe4XvomcuqovBxd6ZoSDpzoMJ%2FpjoUsuzVf\" + \\\n",
    "          \"lGKkdgv6ZlBsl%2Bc7s3VgBprIHx6juy5SV9ac3PVT%2F5Su%2FAb51g7p60Ebxw6Qi%2FaGj%2B7Y8sq4sPlNsqW32UXk2xJJH\" + \\\n",
    "          \"%2BP5%2B14PFH2ky%2BHeNwRewSBDMa3zsdLPlWnw9kbm6GLdvesu\"\n",
    "    \n",
    "    #Hitting API and getting Matchup View\n",
    "    r = requests.get(url, cookies={\"swid\": swid, \"espn_s2\": espn_s2}, params={\"view\": \"mMatchup\"})\n",
    "    m = r.json()[0]\n",
    "    \n",
    "    game_lst = [[game['matchupPeriodId'], game['home']['teamId'], game['home']['totalPoints'],\n",
    "                game['away']['teamId'], game['away']['totalPoints'], year] for game in m['schedule']]\n",
    "    \n",
    "    matchups = matchups.append(game_lst, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "matchups.columns = [\"Week\", \"HomeTeam\", \"HomeScore\", \"AwayTeam\", \"AwayScore\", \"Year\"]\n",
    "matchups[\"Type\"] = [\"Regular\" if w <=14 else \"Playoff\" for w in matchups[\"Week\"]]\n",
    "matchups[\"AwayTeamOwner\"] = matchups.AwayTeam.map(owners_df.owner_name)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Week</th>\n",
       "      <th>HomeTeam</th>\n",
       "      <th>HomeScore</th>\n",
       "      <th>AwayTeam</th>\n",
       "      <th>AwayScore</th>\n",
       "      <th>Year</th>\n",
       "      <th>Type</th>\n",
       "      <th>AwayTeamOwner</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>143.40</td>\n",
       "      <td>1</td>\n",
       "      <td>146.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>146.46</td>\n",
       "      <td>3</td>\n",
       "      <td>107.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>118.46</td>\n",
       "      <td>5</td>\n",
       "      <td>140.56</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>139.98</td>\n",
       "      <td>6</td>\n",
       "      <td>128.00</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>126.36</td>\n",
       "      <td>7</td>\n",
       "      <td>131.32</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Week  HomeTeam  HomeScore  AwayTeam  AwayScore  Year     Type AwayTeamOwner\n",
       "0     1         2     143.40         1     146.60  2012  Regular    Treshansky\n",
       "1     1        12     146.46         3     107.60  2012  Regular         Klein\n",
       "2     1        11     118.46         5     140.56  2012  Regular          Katz\n",
       "3     1         9     139.98         6     128.00  2012  Regular       J.Stein\n",
       "4     1         8     126.36         7     131.32  2012  Regular     Berkowitz"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matchups.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "matchups = matchups.drop([\"AwayTeamOwner\"], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": true
   },
   "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>Week</th>\n",
       "      <th>HomeTeam</th>\n",
       "      <th>HomeScore</th>\n",
       "      <th>AwayTeam</th>\n",
       "      <th>AwayScore</th>\n",
       "      <th>Year</th>\n",
       "      <th>Type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>143.40</td>\n",
       "      <td>1</td>\n",
       "      <td>146.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>146.46</td>\n",
       "      <td>3</td>\n",
       "      <td>107.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>118.46</td>\n",
       "      <td>5</td>\n",
       "      <td>140.56</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>139.98</td>\n",
       "      <td>6</td>\n",
       "      <td>128.00</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>126.36</td>\n",
       "      <td>7</td>\n",
       "      <td>131.32</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Week  HomeTeam  HomeScore  AwayTeam  AwayScore  Year     Type\n",
       "0     1         2     143.40         1     146.60  2012  Regular\n",
       "1     1        12     146.46         3     107.60  2012  Regular\n",
       "2     1        11     118.46         5     140.56  2012  Regular\n",
       "3     1         9     139.98         6     128.00  2012  Regular\n",
       "4     1         8     126.36         7     131.32  2012  Regular"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matchups.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>owner_id</th>\n",
       "      <th>owner_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>8</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>9</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>11</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>12</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   owner_id        owner_name\n",
       "0         1             Zwick\n",
       "1         2        Treshansky\n",
       "2         3          Lirtzman\n",
       "3         5             Klein\n",
       "4         6         Rosenberg\n",
       "5         7              Katz\n",
       "6         8           J.Stein\n",
       "7         9         Berkowitz\n",
       "8        11             Kogan\n",
       "9        12  B.Stein/Kaminski"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "owners_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>Week</th>\n",
       "      <th>HomeTeam</th>\n",
       "      <th>HomeScore</th>\n",
       "      <th>AwayTeam</th>\n",
       "      <th>AwayScore</th>\n",
       "      <th>Year</th>\n",
       "      <th>Type</th>\n",
       "      <th>owner_id</th>\n",
       "      <th>owner_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>143.40</td>\n",
       "      <td>1</td>\n",
       "      <td>146.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>1</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>146.46</td>\n",
       "      <td>3</td>\n",
       "      <td>107.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>3</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>118.46</td>\n",
       "      <td>5</td>\n",
       "      <td>140.56</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>5</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>139.98</td>\n",
       "      <td>6</td>\n",
       "      <td>128.00</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>6</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>126.36</td>\n",
       "      <td>7</td>\n",
       "      <td>131.32</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>7</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Week  HomeTeam  HomeScore  AwayTeam  AwayScore  Year     Type  owner_id  \\\n",
       "0     1         2     143.40         1     146.60  2012  Regular         1   \n",
       "1     1        12     146.46         3     107.60  2012  Regular         3   \n",
       "2     1        11     118.46         5     140.56  2012  Regular         5   \n",
       "3     1         9     139.98         6     128.00  2012  Regular         6   \n",
       "4     1         8     126.36         7     131.32  2012  Regular         7   \n",
       "\n",
       "  owner_name  \n",
       "0      Zwick  \n",
       "1   Lirtzman  \n",
       "2      Klein  \n",
       "3  Rosenberg  \n",
       "4       Katz  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged = pd.merge(matchups, owners_df, how=\"left\", left_on=\"AwayTeam\", right_on=\"owner_id\")\n",
    "merged.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged = merged.drop([\"owner_id\"], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>Week</th>\n",
       "      <th>HomeTeam</th>\n",
       "      <th>HomeScore</th>\n",
       "      <th>AwayTeam</th>\n",
       "      <th>AwayScore</th>\n",
       "      <th>Year</th>\n",
       "      <th>Type</th>\n",
       "      <th>owner_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>143.40</td>\n",
       "      <td>1</td>\n",
       "      <td>146.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>146.46</td>\n",
       "      <td>3</td>\n",
       "      <td>107.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>118.46</td>\n",
       "      <td>5</td>\n",
       "      <td>140.56</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>139.98</td>\n",
       "      <td>6</td>\n",
       "      <td>128.00</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>126.36</td>\n",
       "      <td>7</td>\n",
       "      <td>131.32</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Week  HomeTeam  HomeScore  AwayTeam  AwayScore  Year     Type owner_name\n",
       "0     1         2     143.40         1     146.60  2012  Regular      Zwick\n",
       "1     1        12     146.46         3     107.60  2012  Regular   Lirtzman\n",
       "2     1        11     118.46         5     140.56  2012  Regular      Klein\n",
       "3     1         9     139.98         6     128.00  2012  Regular  Rosenberg\n",
       "4     1         8     126.36         7     131.32  2012  Regular       Katz"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Week</th>\n",
       "      <th>HomeTeam</th>\n",
       "      <th>HomeScore</th>\n",
       "      <th>AwayTeam</th>\n",
       "      <th>AwayScore</th>\n",
       "      <th>Year</th>\n",
       "      <th>Type</th>\n",
       "      <th>AwayTeamName</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>143.40</td>\n",
       "      <td>1</td>\n",
       "      <td>146.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>146.46</td>\n",
       "      <td>3</td>\n",
       "      <td>107.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>118.46</td>\n",
       "      <td>5</td>\n",
       "      <td>140.56</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>139.98</td>\n",
       "      <td>6</td>\n",
       "      <td>128.00</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>126.36</td>\n",
       "      <td>7</td>\n",
       "      <td>131.32</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Week  HomeTeam  HomeScore  AwayTeam  AwayScore  Year     Type AwayTeamName\n",
       "0     1         2     143.40         1     146.60  2012  Regular        Zwick\n",
       "1     1        12     146.46         3     107.60  2012  Regular     Lirtzman\n",
       "2     1        11     118.46         5     140.56  2012  Regular        Klein\n",
       "3     1         9     139.98         6     128.00  2012  Regular    Rosenberg\n",
       "4     1         8     126.36         7     131.32  2012  Regular         Katz"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged = merged.rename(columns={\"owner_name\": \"AwayTeamName\"})\n",
    "merged.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>Week</th>\n",
       "      <th>HomeTeam</th>\n",
       "      <th>HomeScore</th>\n",
       "      <th>AwayTeam</th>\n",
       "      <th>AwayScore</th>\n",
       "      <th>Year</th>\n",
       "      <th>Type</th>\n",
       "      <th>AwayTeamName</th>\n",
       "      <th>owner_id</th>\n",
       "      <th>owner_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>143.40</td>\n",
       "      <td>1</td>\n",
       "      <td>146.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>2</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>146.46</td>\n",
       "      <td>3</td>\n",
       "      <td>107.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>12</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>118.46</td>\n",
       "      <td>5</td>\n",
       "      <td>140.56</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>11</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>139.98</td>\n",
       "      <td>6</td>\n",
       "      <td>128.00</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>9</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>126.36</td>\n",
       "      <td>7</td>\n",
       "      <td>131.32</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>8</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Week  HomeTeam  HomeScore  AwayTeam  AwayScore  Year     Type AwayTeamName  \\\n",
       "0     1         2     143.40         1     146.60  2012  Regular        Zwick   \n",
       "1     1        12     146.46         3     107.60  2012  Regular     Lirtzman   \n",
       "2     1        11     118.46         5     140.56  2012  Regular        Klein   \n",
       "3     1         9     139.98         6     128.00  2012  Regular    Rosenberg   \n",
       "4     1         8     126.36         7     131.32  2012  Regular         Katz   \n",
       "\n",
       "   owner_id        owner_name  \n",
       "0         2        Treshansky  \n",
       "1        12  B.Stein/Kaminski  \n",
       "2        11             Kogan  \n",
       "3         9         Berkowitz  \n",
       "4         8           J.Stein  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged2 = pd.merge(merged, owners_df, how=\"left\", left_on=\"HomeTeam\", right_on=\"owner_id\")\n",
    "merged2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged2 = merged2.drop([\"owner_id\"], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged2 = merged2.rename(columns={\"owner_name\": \"HomeTeamName\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>Week</th>\n",
       "      <th>HomeTeam</th>\n",
       "      <th>HomeScore</th>\n",
       "      <th>AwayTeam</th>\n",
       "      <th>AwayScore</th>\n",
       "      <th>Year</th>\n",
       "      <th>Type</th>\n",
       "      <th>AwayTeamName</th>\n",
       "      <th>HomeTeamName</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>143.40</td>\n",
       "      <td>1</td>\n",
       "      <td>146.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>146.46</td>\n",
       "      <td>3</td>\n",
       "      <td>107.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>118.46</td>\n",
       "      <td>5</td>\n",
       "      <td>140.56</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>139.98</td>\n",
       "      <td>6</td>\n",
       "      <td>128.00</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>126.36</td>\n",
       "      <td>7</td>\n",
       "      <td>131.32</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Week  HomeTeam  HomeScore  AwayTeam  AwayScore  Year     Type AwayTeamName  \\\n",
       "0     1         2     143.40         1     146.60  2012  Regular        Zwick   \n",
       "1     1        12     146.46         3     107.60  2012  Regular     Lirtzman   \n",
       "2     1        11     118.46         5     140.56  2012  Regular        Klein   \n",
       "3     1         9     139.98         6     128.00  2012  Regular    Rosenberg   \n",
       "4     1         8     126.36         7     131.32  2012  Regular         Katz   \n",
       "\n",
       "       HomeTeamName  \n",
       "0        Treshansky  \n",
       "1  B.Stein/Kaminski  \n",
       "2             Kogan  \n",
       "3         Berkowitz  \n",
       "4           J.Stein  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "merged2[\"Winner\"] = np.where(merged2[\"HomeScore\"] > merged2[\"AwayScore\"], merged2[\"HomeTeamName\"], merged2[\"AwayTeamName\"])\n",
    "merged2[\"Loser\"] = np.where(merged2[\"HomeScore\"] > merged2[\"AwayScore\"], merged2[\"AwayTeamName\"], merged2[\"HomeTeamName\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>Week</th>\n",
       "      <th>HomeTeam</th>\n",
       "      <th>HomeScore</th>\n",
       "      <th>AwayTeam</th>\n",
       "      <th>AwayScore</th>\n",
       "      <th>Year</th>\n",
       "      <th>Type</th>\n",
       "      <th>AwayTeamName</th>\n",
       "      <th>HomeTeamName</th>\n",
       "      <th>Winner</th>\n",
       "      <th>Loser</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>143.40</td>\n",
       "      <td>1</td>\n",
       "      <td>146.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>146.46</td>\n",
       "      <td>3</td>\n",
       "      <td>107.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>118.46</td>\n",
       "      <td>5</td>\n",
       "      <td>140.56</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>139.98</td>\n",
       "      <td>6</td>\n",
       "      <td>128.00</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>126.36</td>\n",
       "      <td>7</td>\n",
       "      <td>131.32</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Katz</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>137.74</td>\n",
       "      <td>3</td>\n",
       "      <td>113.66</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>128.36</td>\n",
       "      <td>2</td>\n",
       "      <td>126.10</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>180.44</td>\n",
       "      <td>12</td>\n",
       "      <td>125.86</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>173.50</td>\n",
       "      <td>11</td>\n",
       "      <td>124.94</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>86.88</td>\n",
       "      <td>9</td>\n",
       "      <td>123.92</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>182.72</td>\n",
       "      <td>1</td>\n",
       "      <td>153.44</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>106.58</td>\n",
       "      <td>6</td>\n",
       "      <td>152.00</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>139.90</td>\n",
       "      <td>7</td>\n",
       "      <td>79.74</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>130.42</td>\n",
       "      <td>8</td>\n",
       "      <td>111.92</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>115.88</td>\n",
       "      <td>9</td>\n",
       "      <td>122.34</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>156.08</td>\n",
       "      <td>6</td>\n",
       "      <td>154.86</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>139.34</td>\n",
       "      <td>5</td>\n",
       "      <td>154.28</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>175.70</td>\n",
       "      <td>3</td>\n",
       "      <td>150.10</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>90.52</td>\n",
       "      <td>2</td>\n",
       "      <td>130.52</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>121.38</td>\n",
       "      <td>12</td>\n",
       "      <td>185.80</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>181.48</td>\n",
       "      <td>1</td>\n",
       "      <td>95.38</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>116.84</td>\n",
       "      <td>8</td>\n",
       "      <td>127.00</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>170.54</td>\n",
       "      <td>9</td>\n",
       "      <td>144.68</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>150.30</td>\n",
       "      <td>11</td>\n",
       "      <td>143.28</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>132.26</td>\n",
       "      <td>12</td>\n",
       "      <td>114.68</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>143.54</td>\n",
       "      <td>8</td>\n",
       "      <td>129.64</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>152.92</td>\n",
       "      <td>7</td>\n",
       "      <td>123.98</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>107.32</td>\n",
       "      <td>6</td>\n",
       "      <td>154.70</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>93.90</td>\n",
       "      <td>5</td>\n",
       "      <td>148.20</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Klein</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>93.58</td>\n",
       "      <td>3</td>\n",
       "      <td>135.34</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Treshansky</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>530</th>\n",
       "      <td>11</td>\n",
       "      <td>7</td>\n",
       "      <td>177.00</td>\n",
       "      <td>12</td>\n",
       "      <td>102.72</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Katz</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>11</td>\n",
       "      <td>6</td>\n",
       "      <td>119.66</td>\n",
       "      <td>2</td>\n",
       "      <td>142.98</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>532</th>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "      <td>102.12</td>\n",
       "      <td>1</td>\n",
       "      <td>189.16</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>533</th>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>145.10</td>\n",
       "      <td>5</td>\n",
       "      <td>97.46</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>534</th>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>161.20</td>\n",
       "      <td>3</td>\n",
       "      <td>114.32</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>535</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>177.44</td>\n",
       "      <td>2</td>\n",
       "      <td>199.64</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536</th>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>162.14</td>\n",
       "      <td>7</td>\n",
       "      <td>160.06</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>537</th>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>121.26</td>\n",
       "      <td>6</td>\n",
       "      <td>147.08</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>538</th>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>122.54</td>\n",
       "      <td>8</td>\n",
       "      <td>115.02</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>539</th>\n",
       "      <td>12</td>\n",
       "      <td>9</td>\n",
       "      <td>127.10</td>\n",
       "      <td>11</td>\n",
       "      <td>128.20</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540</th>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>155.10</td>\n",
       "      <td>12</td>\n",
       "      <td>144.90</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541</th>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>151.72</td>\n",
       "      <td>5</td>\n",
       "      <td>93.28</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>542</th>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "      <td>155.30</td>\n",
       "      <td>3</td>\n",
       "      <td>150.88</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>543</th>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>105.22</td>\n",
       "      <td>9</td>\n",
       "      <td>84.20</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>544</th>\n",
       "      <td>13</td>\n",
       "      <td>8</td>\n",
       "      <td>125.40</td>\n",
       "      <td>11</td>\n",
       "      <td>151.84</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>545</th>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>97.52</td>\n",
       "      <td>5</td>\n",
       "      <td>134.12</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Klein</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>546</th>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>156.92</td>\n",
       "      <td>1</td>\n",
       "      <td>137.88</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>547</th>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>117.02</td>\n",
       "      <td>2</td>\n",
       "      <td>161.04</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>548</th>\n",
       "      <td>14</td>\n",
       "      <td>11</td>\n",
       "      <td>92.70</td>\n",
       "      <td>7</td>\n",
       "      <td>159.20</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>549</th>\n",
       "      <td>14</td>\n",
       "      <td>8</td>\n",
       "      <td>124.40</td>\n",
       "      <td>6</td>\n",
       "      <td>132.76</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>550</th>\n",
       "      <td>15</td>\n",
       "      <td>7</td>\n",
       "      <td>96.22</td>\n",
       "      <td>12</td>\n",
       "      <td>155.72</td>\n",
       "      <td>2018</td>\n",
       "      <td>Playoff</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Katz</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>551</th>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>111.50</td>\n",
       "      <td>9</td>\n",
       "      <td>140.50</td>\n",
       "      <td>2018</td>\n",
       "      <td>Playoff</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552</th>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>91.80</td>\n",
       "      <td>6</td>\n",
       "      <td>97.86</td>\n",
       "      <td>2018</td>\n",
       "      <td>Playoff</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>553</th>\n",
       "      <td>15</td>\n",
       "      <td>8</td>\n",
       "      <td>87.02</td>\n",
       "      <td>11</td>\n",
       "      <td>98.10</td>\n",
       "      <td>2018</td>\n",
       "      <td>Playoff</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>554</th>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>145.58</td>\n",
       "      <td>5</td>\n",
       "      <td>122.18</td>\n",
       "      <td>2018</td>\n",
       "      <td>Playoff</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>555</th>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>169.28</td>\n",
       "      <td>12</td>\n",
       "      <td>167.96</td>\n",
       "      <td>2018</td>\n",
       "      <td>Playoff</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>556</th>\n",
       "      <td>16</td>\n",
       "      <td>7</td>\n",
       "      <td>165.20</td>\n",
       "      <td>2</td>\n",
       "      <td>171.04</td>\n",
       "      <td>2018</td>\n",
       "      <td>Playoff</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>557</th>\n",
       "      <td>16</td>\n",
       "      <td>6</td>\n",
       "      <td>115.98</td>\n",
       "      <td>11</td>\n",
       "      <td>44.54</td>\n",
       "      <td>2018</td>\n",
       "      <td>Playoff</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>558</th>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>154.22</td>\n",
       "      <td>3</td>\n",
       "      <td>154.10</td>\n",
       "      <td>2018</td>\n",
       "      <td>Playoff</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>559</th>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "      <td>99.40</td>\n",
       "      <td>5</td>\n",
       "      <td>125.60</td>\n",
       "      <td>2018</td>\n",
       "      <td>Playoff</td>\n",
       "      <td>Klein</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Klein</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>560 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Week  HomeTeam  HomeScore  AwayTeam  AwayScore  Year     Type  \\\n",
       "0       1         2     143.40         1     146.60  2012  Regular   \n",
       "1       1        12     146.46         3     107.60  2012  Regular   \n",
       "2       1        11     118.46         5     140.56  2012  Regular   \n",
       "3       1         9     139.98         6     128.00  2012  Regular   \n",
       "4       1         8     126.36         7     131.32  2012  Regular   \n",
       "5       2         1     137.74         3     113.66  2012  Regular   \n",
       "6       2         5     128.36         2     126.10  2012  Regular   \n",
       "7       2         6     180.44        12     125.86  2012  Regular   \n",
       "8       2         7     173.50        11     124.94  2012  Regular   \n",
       "9       2         8      86.88         9     123.92  2012  Regular   \n",
       "10      3         5     182.72         1     153.44  2012  Regular   \n",
       "11      3         3     106.58         6     152.00  2012  Regular   \n",
       "12      3         2     139.90         7      79.74  2012  Regular   \n",
       "13      3        12     130.42         8     111.92  2012  Regular   \n",
       "14      3        11     115.88         9     122.34  2012  Regular   \n",
       "15      4         1     156.08         6     154.86  2012  Regular   \n",
       "16      4         7     139.34         5     154.28  2012  Regular   \n",
       "17      4         8     175.70         3     150.10  2012  Regular   \n",
       "18      4         9      90.52         2     130.52  2012  Regular   \n",
       "19      4        11     121.38        12     185.80  2012  Regular   \n",
       "20      5         7     181.48         1      95.38  2012  Regular   \n",
       "21      5         6     116.84         8     127.00  2012  Regular   \n",
       "22      5         5     170.54         9     144.68  2012  Regular   \n",
       "23      5         3     150.30        11     143.28  2012  Regular   \n",
       "24      5         2     132.26        12     114.68  2012  Regular   \n",
       "25      6         1     143.54         8     129.64  2012  Regular   \n",
       "26      6         9     152.92         7     123.98  2012  Regular   \n",
       "27      6        11     107.32         6     154.70  2012  Regular   \n",
       "28      6        12      93.90         5     148.20  2012  Regular   \n",
       "29      6         2      93.58         3     135.34  2012  Regular   \n",
       "..    ...       ...        ...       ...        ...   ...      ...   \n",
       "530    11         7     177.00        12     102.72  2018  Regular   \n",
       "531    11         6     119.66         2     142.98  2018  Regular   \n",
       "532    11         8     102.12         1     189.16  2018  Regular   \n",
       "533    11        11     145.10         5      97.46  2018  Regular   \n",
       "534    11         9     161.20         3     114.32  2018  Regular   \n",
       "535    12        12     177.44         2     199.64  2018  Regular   \n",
       "536    12         1     162.14         7     160.06  2018  Regular   \n",
       "537    12         5     121.26         6     147.08  2018  Regular   \n",
       "538    12         3     122.54         8     115.02  2018  Regular   \n",
       "539    12         9     127.10        11     128.20  2018  Regular   \n",
       "540    13         1     155.10        12     144.90  2018  Regular   \n",
       "541    13         2     151.72         5      93.28  2018  Regular   \n",
       "542    13         7     155.30         3     150.88  2018  Regular   \n",
       "543    13         6     105.22         9      84.20  2018  Regular   \n",
       "544    13         8     125.40        11     151.84  2018  Regular   \n",
       "545    14        12      97.52         5     134.12  2018  Regular   \n",
       "546    14         3     156.92         1     137.88  2018  Regular   \n",
       "547    14         9     117.02         2     161.04  2018  Regular   \n",
       "548    14        11      92.70         7     159.20  2018  Regular   \n",
       "549    14         8     124.40         6     132.76  2018  Regular   \n",
       "550    15         7      96.22        12     155.72  2018  Playoff   \n",
       "551    15         2     111.50         9     140.50  2018  Playoff   \n",
       "552    15         1      91.80         6      97.86  2018  Playoff   \n",
       "553    15         8      87.02        11      98.10  2018  Playoff   \n",
       "554    15         3     145.58         5     122.18  2018  Playoff   \n",
       "555    16         9     169.28        12     167.96  2018  Playoff   \n",
       "556    16         7     165.20         2     171.04  2018  Playoff   \n",
       "557    16         6     115.98        11      44.54  2018  Playoff   \n",
       "558    16         1     154.22         3     154.10  2018  Playoff   \n",
       "559    16         8      99.40         5     125.60  2018  Playoff   \n",
       "\n",
       "         AwayTeamName      HomeTeamName            Winner             Loser  \n",
       "0               Zwick        Treshansky             Zwick        Treshansky  \n",
       "1            Lirtzman  B.Stein/Kaminski  B.Stein/Kaminski          Lirtzman  \n",
       "2               Klein             Kogan             Klein             Kogan  \n",
       "3           Rosenberg         Berkowitz         Berkowitz         Rosenberg  \n",
       "4                Katz           J.Stein              Katz           J.Stein  \n",
       "5            Lirtzman             Zwick             Zwick          Lirtzman  \n",
       "6          Treshansky             Klein             Klein        Treshansky  \n",
       "7    B.Stein/Kaminski         Rosenberg         Rosenberg  B.Stein/Kaminski  \n",
       "8               Kogan              Katz              Katz             Kogan  \n",
       "9           Berkowitz           J.Stein         Berkowitz           J.Stein  \n",
       "10              Zwick             Klein             Klein             Zwick  \n",
       "11          Rosenberg          Lirtzman         Rosenberg          Lirtzman  \n",
       "12               Katz        Treshansky        Treshansky              Katz  \n",
       "13            J.Stein  B.Stein/Kaminski  B.Stein/Kaminski           J.Stein  \n",
       "14          Berkowitz             Kogan         Berkowitz             Kogan  \n",
       "15          Rosenberg             Zwick             Zwick         Rosenberg  \n",
       "16              Klein              Katz             Klein              Katz  \n",
       "17           Lirtzman           J.Stein           J.Stein          Lirtzman  \n",
       "18         Treshansky         Berkowitz        Treshansky         Berkowitz  \n",
       "19   B.Stein/Kaminski             Kogan  B.Stein/Kaminski             Kogan  \n",
       "20              Zwick              Katz              Katz             Zwick  \n",
       "21            J.Stein         Rosenberg           J.Stein         Rosenberg  \n",
       "22          Berkowitz             Klein             Klein         Berkowitz  \n",
       "23              Kogan          Lirtzman          Lirtzman             Kogan  \n",
       "24   B.Stein/Kaminski        Treshansky        Treshansky  B.Stein/Kaminski  \n",
       "25            J.Stein             Zwick             Zwick           J.Stein  \n",
       "26               Katz         Berkowitz         Berkowitz              Katz  \n",
       "27          Rosenberg             Kogan         Rosenberg             Kogan  \n",
       "28              Klein  B.Stein/Kaminski             Klein  B.Stein/Kaminski  \n",
       "29           Lirtzman        Treshansky          Lirtzman        Treshansky  \n",
       "..                ...               ...               ...               ...  \n",
       "530  B.Stein/Kaminski              Katz              Katz  B.Stein/Kaminski  \n",
       "531        Treshansky         Rosenberg        Treshansky         Rosenberg  \n",
       "532             Zwick           J.Stein             Zwick           J.Stein  \n",
       "533             Klein             Kogan             Kogan             Klein  \n",
       "534          Lirtzman         Berkowitz         Berkowitz          Lirtzman  \n",
       "535        Treshansky  B.Stein/Kaminski        Treshansky  B.Stein/Kaminski  \n",
       "536              Katz             Zwick             Zwick              Katz  \n",
       "537         Rosenberg             Klein         Rosenberg             Klein  \n",
       "538           J.Stein          Lirtzman          Lirtzman           J.Stein  \n",
       "539             Kogan         Berkowitz             Kogan         Berkowitz  \n",
       "540  B.Stein/Kaminski             Zwick             Zwick  B.Stein/Kaminski  \n",
       "541             Klein        Treshansky        Treshansky             Klein  \n",
       "542          Lirtzman              Katz              Katz          Lirtzman  \n",
       "543         Berkowitz         Rosenberg         Rosenberg         Berkowitz  \n",
       "544             Kogan           J.Stein             Kogan           J.Stein  \n",
       "545             Klein  B.Stein/Kaminski             Klein  B.Stein/Kaminski  \n",
       "546             Zwick          Lirtzman          Lirtzman             Zwick  \n",
       "547        Treshansky         Berkowitz        Treshansky         Berkowitz  \n",
       "548              Katz             Kogan              Katz             Kogan  \n",
       "549         Rosenberg           J.Stein         Rosenberg           J.Stein  \n",
       "550  B.Stein/Kaminski              Katz  B.Stein/Kaminski              Katz  \n",
       "551         Berkowitz        Treshansky         Berkowitz        Treshansky  \n",
       "552         Rosenberg             Zwick         Rosenberg             Zwick  \n",
       "553             Kogan           J.Stein             Kogan           J.Stein  \n",
       "554             Klein          Lirtzman          Lirtzman             Klein  \n",
       "555  B.Stein/Kaminski         Berkowitz         Berkowitz  B.Stein/Kaminski  \n",
       "556        Treshansky              Katz        Treshansky              Katz  \n",
       "557             Kogan         Rosenberg         Rosenberg             Kogan  \n",
       "558          Lirtzman             Zwick             Zwick          Lirtzman  \n",
       "559             Klein           J.Stein             Klein           J.Stein  \n",
       "\n",
       "[560 rows x 11 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>Week</th>\n",
       "      <th>HomeTeam</th>\n",
       "      <th>HomeScore</th>\n",
       "      <th>AwayTeam</th>\n",
       "      <th>AwayScore</th>\n",
       "      <th>Year</th>\n",
       "      <th>Type</th>\n",
       "      <th>AwayTeamName</th>\n",
       "      <th>HomeTeamName</th>\n",
       "      <th>Winner</th>\n",
       "      <th>Loser</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>143.40</td>\n",
       "      <td>1</td>\n",
       "      <td>146.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>146.46</td>\n",
       "      <td>3</td>\n",
       "      <td>107.60</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>118.46</td>\n",
       "      <td>5</td>\n",
       "      <td>140.56</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>139.98</td>\n",
       "      <td>6</td>\n",
       "      <td>128.00</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>126.36</td>\n",
       "      <td>7</td>\n",
       "      <td>131.32</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Katz</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>137.74</td>\n",
       "      <td>3</td>\n",
       "      <td>113.66</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>128.36</td>\n",
       "      <td>2</td>\n",
       "      <td>126.10</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>180.44</td>\n",
       "      <td>12</td>\n",
       "      <td>125.86</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>173.50</td>\n",
       "      <td>11</td>\n",
       "      <td>124.94</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>86.88</td>\n",
       "      <td>9</td>\n",
       "      <td>123.92</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>182.72</td>\n",
       "      <td>1</td>\n",
       "      <td>153.44</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>106.58</td>\n",
       "      <td>6</td>\n",
       "      <td>152.00</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>139.90</td>\n",
       "      <td>7</td>\n",
       "      <td>79.74</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>130.42</td>\n",
       "      <td>8</td>\n",
       "      <td>111.92</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>115.88</td>\n",
       "      <td>9</td>\n",
       "      <td>122.34</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>156.08</td>\n",
       "      <td>6</td>\n",
       "      <td>154.86</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>139.34</td>\n",
       "      <td>5</td>\n",
       "      <td>154.28</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>175.70</td>\n",
       "      <td>3</td>\n",
       "      <td>150.10</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>90.52</td>\n",
       "      <td>2</td>\n",
       "      <td>130.52</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>121.38</td>\n",
       "      <td>12</td>\n",
       "      <td>185.80</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>181.48</td>\n",
       "      <td>1</td>\n",
       "      <td>95.38</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>116.84</td>\n",
       "      <td>8</td>\n",
       "      <td>127.00</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>170.54</td>\n",
       "      <td>9</td>\n",
       "      <td>144.68</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>150.30</td>\n",
       "      <td>11</td>\n",
       "      <td>143.28</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>132.26</td>\n",
       "      <td>12</td>\n",
       "      <td>114.68</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>143.54</td>\n",
       "      <td>8</td>\n",
       "      <td>129.64</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>152.92</td>\n",
       "      <td>7</td>\n",
       "      <td>123.98</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>107.32</td>\n",
       "      <td>6</td>\n",
       "      <td>154.70</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>6</td>\n",
       "      <td>12</td>\n",
       "      <td>93.90</td>\n",
       "      <td>5</td>\n",
       "      <td>148.20</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Klein</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>93.58</td>\n",
       "      <td>3</td>\n",
       "      <td>135.34</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Treshansky</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>159.28</td>\n",
       "      <td>12</td>\n",
       "      <td>99.18</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>521</th>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>129.02</td>\n",
       "      <td>6</td>\n",
       "      <td>111.66</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>173.16</td>\n",
       "      <td>7</td>\n",
       "      <td>128.54</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>523</th>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>126.22</td>\n",
       "      <td>2</td>\n",
       "      <td>154.36</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>524</th>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>149.40</td>\n",
       "      <td>1</td>\n",
       "      <td>128.60</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>525</th>\n",
       "      <td>10</td>\n",
       "      <td>12</td>\n",
       "      <td>148.34</td>\n",
       "      <td>6</td>\n",
       "      <td>163.40</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>526</th>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>147.60</td>\n",
       "      <td>8</td>\n",
       "      <td>131.78</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Katz</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>527</th>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>208.26</td>\n",
       "      <td>11</td>\n",
       "      <td>139.54</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>145.84</td>\n",
       "      <td>9</td>\n",
       "      <td>171.10</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>123.04</td>\n",
       "      <td>3</td>\n",
       "      <td>94.62</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>530</th>\n",
       "      <td>11</td>\n",
       "      <td>7</td>\n",
       "      <td>177.00</td>\n",
       "      <td>12</td>\n",
       "      <td>102.72</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Katz</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>11</td>\n",
       "      <td>6</td>\n",
       "      <td>119.66</td>\n",
       "      <td>2</td>\n",
       "      <td>142.98</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>532</th>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "      <td>102.12</td>\n",
       "      <td>1</td>\n",
       "      <td>189.16</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>533</th>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>145.10</td>\n",
       "      <td>5</td>\n",
       "      <td>97.46</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>534</th>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>161.20</td>\n",
       "      <td>3</td>\n",
       "      <td>114.32</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>535</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>177.44</td>\n",
       "      <td>2</td>\n",
       "      <td>199.64</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536</th>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>162.14</td>\n",
       "      <td>7</td>\n",
       "      <td>160.06</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>537</th>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>121.26</td>\n",
       "      <td>6</td>\n",
       "      <td>147.08</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>538</th>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>122.54</td>\n",
       "      <td>8</td>\n",
       "      <td>115.02</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>539</th>\n",
       "      <td>12</td>\n",
       "      <td>9</td>\n",
       "      <td>127.10</td>\n",
       "      <td>11</td>\n",
       "      <td>128.20</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>540</th>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>155.10</td>\n",
       "      <td>12</td>\n",
       "      <td>144.90</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541</th>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>151.72</td>\n",
       "      <td>5</td>\n",
       "      <td>93.28</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>542</th>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "      <td>155.30</td>\n",
       "      <td>3</td>\n",
       "      <td>150.88</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>543</th>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>105.22</td>\n",
       "      <td>9</td>\n",
       "      <td>84.20</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>544</th>\n",
       "      <td>13</td>\n",
       "      <td>8</td>\n",
       "      <td>125.40</td>\n",
       "      <td>11</td>\n",
       "      <td>151.84</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>545</th>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>97.52</td>\n",
       "      <td>5</td>\n",
       "      <td>134.12</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Klein</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>546</th>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>156.92</td>\n",
       "      <td>1</td>\n",
       "      <td>137.88</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>547</th>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>117.02</td>\n",
       "      <td>2</td>\n",
       "      <td>161.04</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>548</th>\n",
       "      <td>14</td>\n",
       "      <td>11</td>\n",
       "      <td>92.70</td>\n",
       "      <td>7</td>\n",
       "      <td>159.20</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>549</th>\n",
       "      <td>14</td>\n",
       "      <td>8</td>\n",
       "      <td>124.40</td>\n",
       "      <td>6</td>\n",
       "      <td>132.76</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>490 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Week  HomeTeam  HomeScore  AwayTeam  AwayScore  Year     Type  \\\n",
       "0       1         2     143.40         1     146.60  2012  Regular   \n",
       "1       1        12     146.46         3     107.60  2012  Regular   \n",
       "2       1        11     118.46         5     140.56  2012  Regular   \n",
       "3       1         9     139.98         6     128.00  2012  Regular   \n",
       "4       1         8     126.36         7     131.32  2012  Regular   \n",
       "5       2         1     137.74         3     113.66  2012  Regular   \n",
       "6       2         5     128.36         2     126.10  2012  Regular   \n",
       "7       2         6     180.44        12     125.86  2012  Regular   \n",
       "8       2         7     173.50        11     124.94  2012  Regular   \n",
       "9       2         8      86.88         9     123.92  2012  Regular   \n",
       "10      3         5     182.72         1     153.44  2012  Regular   \n",
       "11      3         3     106.58         6     152.00  2012  Regular   \n",
       "12      3         2     139.90         7      79.74  2012  Regular   \n",
       "13      3        12     130.42         8     111.92  2012  Regular   \n",
       "14      3        11     115.88         9     122.34  2012  Regular   \n",
       "15      4         1     156.08         6     154.86  2012  Regular   \n",
       "16      4         7     139.34         5     154.28  2012  Regular   \n",
       "17      4         8     175.70         3     150.10  2012  Regular   \n",
       "18      4         9      90.52         2     130.52  2012  Regular   \n",
       "19      4        11     121.38        12     185.80  2012  Regular   \n",
       "20      5         7     181.48         1      95.38  2012  Regular   \n",
       "21      5         6     116.84         8     127.00  2012  Regular   \n",
       "22      5         5     170.54         9     144.68  2012  Regular   \n",
       "23      5         3     150.30        11     143.28  2012  Regular   \n",
       "24      5         2     132.26        12     114.68  2012  Regular   \n",
       "25      6         1     143.54         8     129.64  2012  Regular   \n",
       "26      6         9     152.92         7     123.98  2012  Regular   \n",
       "27      6        11     107.32         6     154.70  2012  Regular   \n",
       "28      6        12      93.90         5     148.20  2012  Regular   \n",
       "29      6         2      93.58         3     135.34  2012  Regular   \n",
       "..    ...       ...        ...       ...        ...   ...      ...   \n",
       "520     9         8     159.28        12      99.18  2018  Regular   \n",
       "521     9        11     129.02         6     111.66  2018  Regular   \n",
       "522     9         9     173.16         7     128.54  2018  Regular   \n",
       "523     9         3     126.22         2     154.36  2018  Regular   \n",
       "524     9         5     149.40         1     128.60  2018  Regular   \n",
       "525    10        12     148.34         6     163.40  2018  Regular   \n",
       "526    10         7     147.60         8     131.78  2018  Regular   \n",
       "527    10         2     208.26        11     139.54  2018  Regular   \n",
       "528    10         1     145.84         9     171.10  2018  Regular   \n",
       "529    10         5     123.04         3      94.62  2018  Regular   \n",
       "530    11         7     177.00        12     102.72  2018  Regular   \n",
       "531    11         6     119.66         2     142.98  2018  Regular   \n",
       "532    11         8     102.12         1     189.16  2018  Regular   \n",
       "533    11        11     145.10         5      97.46  2018  Regular   \n",
       "534    11         9     161.20         3     114.32  2018  Regular   \n",
       "535    12        12     177.44         2     199.64  2018  Regular   \n",
       "536    12         1     162.14         7     160.06  2018  Regular   \n",
       "537    12         5     121.26         6     147.08  2018  Regular   \n",
       "538    12         3     122.54         8     115.02  2018  Regular   \n",
       "539    12         9     127.10        11     128.20  2018  Regular   \n",
       "540    13         1     155.10        12     144.90  2018  Regular   \n",
       "541    13         2     151.72         5      93.28  2018  Regular   \n",
       "542    13         7     155.30         3     150.88  2018  Regular   \n",
       "543    13         6     105.22         9      84.20  2018  Regular   \n",
       "544    13         8     125.40        11     151.84  2018  Regular   \n",
       "545    14        12      97.52         5     134.12  2018  Regular   \n",
       "546    14         3     156.92         1     137.88  2018  Regular   \n",
       "547    14         9     117.02         2     161.04  2018  Regular   \n",
       "548    14        11      92.70         7     159.20  2018  Regular   \n",
       "549    14         8     124.40         6     132.76  2018  Regular   \n",
       "\n",
       "         AwayTeamName      HomeTeamName            Winner             Loser  \n",
       "0               Zwick        Treshansky             Zwick        Treshansky  \n",
       "1            Lirtzman  B.Stein/Kaminski  B.Stein/Kaminski          Lirtzman  \n",
       "2               Klein             Kogan             Klein             Kogan  \n",
       "3           Rosenberg         Berkowitz         Berkowitz         Rosenberg  \n",
       "4                Katz           J.Stein              Katz           J.Stein  \n",
       "5            Lirtzman             Zwick             Zwick          Lirtzman  \n",
       "6          Treshansky             Klein             Klein        Treshansky  \n",
       "7    B.Stein/Kaminski         Rosenberg         Rosenberg  B.Stein/Kaminski  \n",
       "8               Kogan              Katz              Katz             Kogan  \n",
       "9           Berkowitz           J.Stein         Berkowitz           J.Stein  \n",
       "10              Zwick             Klein             Klein             Zwick  \n",
       "11          Rosenberg          Lirtzman         Rosenberg          Lirtzman  \n",
       "12               Katz        Treshansky        Treshansky              Katz  \n",
       "13            J.Stein  B.Stein/Kaminski  B.Stein/Kaminski           J.Stein  \n",
       "14          Berkowitz             Kogan         Berkowitz             Kogan  \n",
       "15          Rosenberg             Zwick             Zwick         Rosenberg  \n",
       "16              Klein              Katz             Klein              Katz  \n",
       "17           Lirtzman           J.Stein           J.Stein          Lirtzman  \n",
       "18         Treshansky         Berkowitz        Treshansky         Berkowitz  \n",
       "19   B.Stein/Kaminski             Kogan  B.Stein/Kaminski             Kogan  \n",
       "20              Zwick              Katz              Katz             Zwick  \n",
       "21            J.Stein         Rosenberg           J.Stein         Rosenberg  \n",
       "22          Berkowitz             Klein             Klein         Berkowitz  \n",
       "23              Kogan          Lirtzman          Lirtzman             Kogan  \n",
       "24   B.Stein/Kaminski        Treshansky        Treshansky  B.Stein/Kaminski  \n",
       "25            J.Stein             Zwick             Zwick           J.Stein  \n",
       "26               Katz         Berkowitz         Berkowitz              Katz  \n",
       "27          Rosenberg             Kogan         Rosenberg             Kogan  \n",
       "28              Klein  B.Stein/Kaminski             Klein  B.Stein/Kaminski  \n",
       "29           Lirtzman        Treshansky          Lirtzman        Treshansky  \n",
       "..                ...               ...               ...               ...  \n",
       "520  B.Stein/Kaminski           J.Stein           J.Stein  B.Stein/Kaminski  \n",
       "521         Rosenberg             Kogan             Kogan         Rosenberg  \n",
       "522              Katz         Berkowitz         Berkowitz              Katz  \n",
       "523        Treshansky          Lirtzman        Treshansky          Lirtzman  \n",
       "524             Zwick             Klein             Klein             Zwick  \n",
       "525         Rosenberg  B.Stein/Kaminski         Rosenberg  B.Stein/Kaminski  \n",
       "526           J.Stein              Katz              Katz           J.Stein  \n",
       "527             Kogan        Treshansky        Treshansky             Kogan  \n",
       "528         Berkowitz             Zwick         Berkowitz             Zwick  \n",
       "529          Lirtzman             Klein             Klein          Lirtzman  \n",
       "530  B.Stein/Kaminski              Katz              Katz  B.Stein/Kaminski  \n",
       "531        Treshansky         Rosenberg        Treshansky         Rosenberg  \n",
       "532             Zwick           J.Stein             Zwick           J.Stein  \n",
       "533             Klein             Kogan             Kogan             Klein  \n",
       "534          Lirtzman         Berkowitz         Berkowitz          Lirtzman  \n",
       "535        Treshansky  B.Stein/Kaminski        Treshansky  B.Stein/Kaminski  \n",
       "536              Katz             Zwick             Zwick              Katz  \n",
       "537         Rosenberg             Klein         Rosenberg             Klein  \n",
       "538           J.Stein          Lirtzman          Lirtzman           J.Stein  \n",
       "539             Kogan         Berkowitz             Kogan         Berkowitz  \n",
       "540  B.Stein/Kaminski             Zwick             Zwick  B.Stein/Kaminski  \n",
       "541             Klein        Treshansky        Treshansky             Klein  \n",
       "542          Lirtzman              Katz              Katz          Lirtzman  \n",
       "543         Berkowitz         Rosenberg         Rosenberg         Berkowitz  \n",
       "544             Kogan           J.Stein             Kogan           J.Stein  \n",
       "545             Klein  B.Stein/Kaminski             Klein  B.Stein/Kaminski  \n",
       "546             Zwick          Lirtzman          Lirtzman             Zwick  \n",
       "547        Treshansky         Berkowitz        Treshansky         Berkowitz  \n",
       "548              Katz             Kogan              Katz             Kogan  \n",
       "549         Rosenberg           J.Stein         Rosenberg           J.Stein  \n",
       "\n",
       "[490 rows x 11 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "regular_season = merged2[merged2[\"Type\"] == \"Regular\"]\n",
    "regular_season"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Katz                60\n",
       "Zwick               60\n",
       "Berkowitz           56\n",
       "J.Stein             54\n",
       "Klein               53\n",
       "B.Stein/Kaminski    47\n",
       "Treshansky          46\n",
       "Lirtzman            45\n",
       "Rosenberg           41\n",
       "Kogan               28\n",
       "Name: Winner, dtype: int64"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "regular_season[\"Winner\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Kogan               70\n",
       "Rosenberg           57\n",
       "Lirtzman            53\n",
       "Treshansky          52\n",
       "B.Stein/Kaminski    51\n",
       "Klein               45\n",
       "J.Stein             44\n",
       "Berkowitz           42\n",
       "Katz                38\n",
       "Zwick               38\n",
       "Name: Loser, dtype: int64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "regular_season[\"Loser\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Wins</th>\n",
       "      <th>Losses</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Wins, Losses]\n",
       "Index: []"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "totals = pd.DataFrame(columns=[\"Wins\", \"Losses\"])\n",
    "totals"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>Wins</th>\n",
       "      <th>Losses</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Katz</th>\n",
       "      <td>60</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zwick</th>\n",
       "      <td>60</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Berkowitz</th>\n",
       "      <td>56</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>J.Stein</th>\n",
       "      <td>54</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Klein</th>\n",
       "      <td>53</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B.Stein/Kaminski</th>\n",
       "      <td>47</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Treshansky</th>\n",
       "      <td>46</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lirtzman</th>\n",
       "      <td>45</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rosenberg</th>\n",
       "      <td>41</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kogan</th>\n",
       "      <td>28</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Wins Losses\n",
       "Katz                60    NaN\n",
       "Zwick               60    NaN\n",
       "Berkowitz           56    NaN\n",
       "J.Stein             54    NaN\n",
       "Klein               53    NaN\n",
       "B.Stein/Kaminski    47    NaN\n",
       "Treshansky          46    NaN\n",
       "Lirtzman            45    NaN\n",
       "Rosenberg           41    NaN\n",
       "Kogan               28    NaN"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "totals[\"Wins\"] = regular_season[\"Winner\"].value_counts()\n",
    "totals"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Wins</th>\n",
       "      <th>Losses</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Katz</th>\n",
       "      <td>60</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zwick</th>\n",
       "      <td>60</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Berkowitz</th>\n",
       "      <td>56</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>J.Stein</th>\n",
       "      <td>54</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Klein</th>\n",
       "      <td>53</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B.Stein/Kaminski</th>\n",
       "      <td>47</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Treshansky</th>\n",
       "      <td>46</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lirtzman</th>\n",
       "      <td>45</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rosenberg</th>\n",
       "      <td>41</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kogan</th>\n",
       "      <td>28</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Wins  Losses\n",
       "Katz                60      38\n",
       "Zwick               60      38\n",
       "Berkowitz           56      42\n",
       "J.Stein             54      44\n",
       "Klein               53      45\n",
       "B.Stein/Kaminski    47      51\n",
       "Treshansky          46      52\n",
       "Lirtzman            45      53\n",
       "Rosenberg           41      57\n",
       "Kogan               28      70"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "totals[\"Losses\"] = regular_season[\"Loser\"].value_counts()\n",
    "totals"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Total Regular Season Wins and Losses 2012-2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>Wins</th>\n",
       "      <th>Losses</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Katz</th>\n",
       "      <td>60</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zwick</th>\n",
       "      <td>60</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Berkowitz</th>\n",
       "      <td>56</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>J.Stein</th>\n",
       "      <td>54</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Klein</th>\n",
       "      <td>53</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B.Stein/Kaminski</th>\n",
       "      <td>47</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Treshansky</th>\n",
       "      <td>46</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lirtzman</th>\n",
       "      <td>45</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rosenberg</th>\n",
       "      <td>41</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kogan</th>\n",
       "      <td>28</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Wins  Losses\n",
       "Katz                60      38\n",
       "Zwick               60      38\n",
       "Berkowitz           56      42\n",
       "J.Stein             54      44\n",
       "Klein               53      45\n",
       "B.Stein/Kaminski    47      51\n",
       "Treshansky          46      52\n",
       "Lirtzman            45      53\n",
       "Rosenberg           41      57\n",
       "Kogan               28      70"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "totals"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Winner            Loser           \n",
       "B.Stein/Kaminski  Berkowitz            3\n",
       "                  J.Stein              5\n",
       "                  Katz                 5\n",
       "                  Klein                5\n",
       "                  Kogan               11\n",
       "                  Lirtzman             6\n",
       "                  Rosenberg            5\n",
       "                  Treshansky           3\n",
       "                  Zwick                4\n",
       "Berkowitz         B.Stein/Kaminski     4\n",
       "                  J.Stein              4\n",
       "                  Katz                 5\n",
       "                  Klein                7\n",
       "                  Kogan                8\n",
       "                  Lirtzman             6\n",
       "                  Rosenberg            8\n",
       "                  Treshansky          10\n",
       "                  Zwick                4\n",
       "J.Stein           B.Stein/Kaminski     7\n",
       "                  Berkowitz            7\n",
       "                  Katz                 5\n",
       "                  Klein                6\n",
       "                  Kogan                5\n",
       "                  Lirtzman             7\n",
       "                  Rosenberg            8\n",
       "                  Treshansky           6\n",
       "                  Zwick                3\n",
       "Katz              B.Stein/Kaminski     6\n",
       "                  Berkowitz            5\n",
       "                  J.Stein              7\n",
       "                                      ..\n",
       "Lirtzman          Rosenberg            5\n",
       "                  Treshansky           6\n",
       "                  Zwick                8\n",
       "Rosenberg         B.Stein/Kaminski     9\n",
       "                  Berkowitz            2\n",
       "                  J.Stein              3\n",
       "                  Katz                 2\n",
       "                  Klein                5\n",
       "                  Kogan                7\n",
       "                  Lirtzman             7\n",
       "                  Treshansky           4\n",
       "                  Zwick                2\n",
       "Treshansky        B.Stein/Kaminski     7\n",
       "                  Berkowitz            3\n",
       "                  J.Stein              4\n",
       "                  Katz                 5\n",
       "                  Klein                7\n",
       "                  Kogan                8\n",
       "                  Lirtzman             4\n",
       "                  Rosenberg            6\n",
       "                  Zwick                2\n",
       "Zwick             B.Stein/Kaminski     8\n",
       "                  Berkowitz            7\n",
       "                  J.Stein              7\n",
       "                  Katz                 7\n",
       "                  Klein                4\n",
       "                  Kogan                5\n",
       "                  Lirtzman             5\n",
       "                  Rosenberg            9\n",
       "                  Treshansky           8\n",
       "Length: 89, dtype: int64"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "regular_season.groupby([\"Winner\", \"Loser\"]).size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "berk = regular_season[(regular_season[\"HomeTeamName\"] == \"Berkowitz\") | (regular_season[\"AwayTeamName\"] == \"Berkowitz\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>Week</th>\n",
       "      <th>HomeTeam</th>\n",
       "      <th>HomeScore</th>\n",
       "      <th>AwayTeam</th>\n",
       "      <th>AwayScore</th>\n",
       "      <th>Year</th>\n",
       "      <th>Type</th>\n",
       "      <th>AwayTeamName</th>\n",
       "      <th>HomeTeamName</th>\n",
       "      <th>Winner</th>\n",
       "      <th>Loser</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>139.98</td>\n",
       "      <td>6</td>\n",
       "      <td>128.00</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>86.88</td>\n",
       "      <td>9</td>\n",
       "      <td>123.92</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>115.88</td>\n",
       "      <td>9</td>\n",
       "      <td>122.34</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>90.52</td>\n",
       "      <td>2</td>\n",
       "      <td>130.52</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>170.54</td>\n",
       "      <td>9</td>\n",
       "      <td>144.68</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>152.92</td>\n",
       "      <td>7</td>\n",
       "      <td>123.98</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>133.12</td>\n",
       "      <td>1</td>\n",
       "      <td>139.04</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>162.96</td>\n",
       "      <td>9</td>\n",
       "      <td>142.12</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>191.94</td>\n",
       "      <td>3</td>\n",
       "      <td>133.16</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>168.58</td>\n",
       "      <td>9</td>\n",
       "      <td>156.46</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>127.00</td>\n",
       "      <td>8</td>\n",
       "      <td>133.04</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>12</td>\n",
       "      <td>9</td>\n",
       "      <td>142.46</td>\n",
       "      <td>11</td>\n",
       "      <td>120.88</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>81.22</td>\n",
       "      <td>9</td>\n",
       "      <td>146.88</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>134.76</td>\n",
       "      <td>5</td>\n",
       "      <td>88.64</td>\n",
       "      <td>2012</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>146.90</td>\n",
       "      <td>6</td>\n",
       "      <td>115.14</td>\n",
       "      <td>2013</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>151.54</td>\n",
       "      <td>9</td>\n",
       "      <td>136.82</td>\n",
       "      <td>2013</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>128.32</td>\n",
       "      <td>9</td>\n",
       "      <td>140.70</td>\n",
       "      <td>2013</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>159.72</td>\n",
       "      <td>2</td>\n",
       "      <td>144.42</td>\n",
       "      <td>2013</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>184.92</td>\n",
       "      <td>9</td>\n",
       "      <td>121.26</td>\n",
       "      <td>2013</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>132.28</td>\n",
       "      <td>7</td>\n",
       "      <td>140.88</td>\n",
       "      <td>2013</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>133.90</td>\n",
       "      <td>1</td>\n",
       "      <td>153.30</td>\n",
       "      <td>2013</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>80.04</td>\n",
       "      <td>9</td>\n",
       "      <td>138.02</td>\n",
       "      <td>2013</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>200.94</td>\n",
       "      <td>3</td>\n",
       "      <td>100.44</td>\n",
       "      <td>2013</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>132.36</td>\n",
       "      <td>9</td>\n",
       "      <td>139.48</td>\n",
       "      <td>2013</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>116.50</td>\n",
       "      <td>8</td>\n",
       "      <td>157.52</td>\n",
       "      <td>2013</td>\n",
       "      <td>Regular</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>12</td>\n",
       "      <td>9</td>\n",
       "      <td>169.34</td>\n",
       "      <td>11</td>\n",
       "      <td>87.58</td>\n",
       "      <td>2013</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>195.88</td>\n",
       "      <td>9</td>\n",
       "      <td>185.48</td>\n",
       "      <td>2013</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>156.40</td>\n",
       "      <td>5</td>\n",
       "      <td>132.56</td>\n",
       "      <td>2013</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>91.26</td>\n",
       "      <td>1</td>\n",
       "      <td>150.82</td>\n",
       "      <td>2014</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>157.58</td>\n",
       "      <td>9</td>\n",
       "      <td>153.22</td>\n",
       "      <td>2014</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Berkowitz</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>13</td>\n",
       "      <td>9</td>\n",
       "      <td>173.02</td>\n",
       "      <td>5</td>\n",
       "      <td>106.14</td>\n",
       "      <td>2016</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>131.26</td>\n",
       "      <td>9</td>\n",
       "      <td>136.82</td>\n",
       "      <td>2016</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403</th>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>103.34</td>\n",
       "      <td>9</td>\n",
       "      <td>108.26</td>\n",
       "      <td>2017</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>125.46</td>\n",
       "      <td>1</td>\n",
       "      <td>135.04</td>\n",
       "      <td>2017</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>138.70</td>\n",
       "      <td>2</td>\n",
       "      <td>100.20</td>\n",
       "      <td>2017</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>140.56</td>\n",
       "      <td>9</td>\n",
       "      <td>101.26</td>\n",
       "      <td>2017</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>112.44</td>\n",
       "      <td>3</td>\n",
       "      <td>134.54</td>\n",
       "      <td>2017</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>82.92</td>\n",
       "      <td>9</td>\n",
       "      <td>126.18</td>\n",
       "      <td>2017</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432</th>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>154.52</td>\n",
       "      <td>8</td>\n",
       "      <td>112.74</td>\n",
       "      <td>2017</td>\n",
       "      <td>Regular</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>J.Stein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>146.64</td>\n",
       "      <td>9</td>\n",
       "      <td>138.74</td>\n",
       "      <td>2017</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>440</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>139.16</td>\n",
       "      <td>5</td>\n",
       "      <td>112.32</td>\n",
       "      <td>2017</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>130.30</td>\n",
       "      <td>7</td>\n",
       "      <td>158.38</td>\n",
       "      <td>2017</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>100.40</td>\n",
       "      <td>9</td>\n",
       "      <td>163.86</td>\n",
       "      <td>2017</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>126.50</td>\n",
       "      <td>9</td>\n",
       "      <td>137.88</td>\n",
       "      <td>2017</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>464</th>\n",
       "      <td>13</td>\n",
       "      <td>11</td>\n",
       "      <td>130.52</td>\n",
       "      <td>9</td>\n",
       "      <td>119.66</td>\n",
       "      <td>2017</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>176.48</td>\n",
       "      <td>3</td>\n",
       "      <td>128.06</td>\n",
       "      <td>2017</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>156.66</td>\n",
       "      <td>1</td>\n",
       "      <td>121.88</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>489</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>151.82</td>\n",
       "      <td>9</td>\n",
       "      <td>124.72</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>142.06</td>\n",
       "      <td>9</td>\n",
       "      <td>119.56</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>146.16</td>\n",
       "      <td>6</td>\n",
       "      <td>114.00</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Rosenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>502</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>126.14</td>\n",
       "      <td>9</td>\n",
       "      <td>139.14</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>165.28</td>\n",
       "      <td>5</td>\n",
       "      <td>144.04</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>141.42</td>\n",
       "      <td>12</td>\n",
       "      <td>119.66</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>B.Stein/Kaminski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>134.12</td>\n",
       "      <td>9</td>\n",
       "      <td>94.12</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>J.Stein</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>173.16</td>\n",
       "      <td>7</td>\n",
       "      <td>128.54</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Katz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Katz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>145.84</td>\n",
       "      <td>9</td>\n",
       "      <td>171.10</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>534</th>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>161.20</td>\n",
       "      <td>3</td>\n",
       "      <td>114.32</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>539</th>\n",
       "      <td>12</td>\n",
       "      <td>9</td>\n",
       "      <td>127.10</td>\n",
       "      <td>11</td>\n",
       "      <td>128.20</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>543</th>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>105.22</td>\n",
       "      <td>9</td>\n",
       "      <td>84.20</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>547</th>\n",
       "      <td>14</td>\n",
       "      <td>9</td>\n",
       "      <td>117.02</td>\n",
       "      <td>2</td>\n",
       "      <td>161.04</td>\n",
       "      <td>2018</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Berkowitz</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>98 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Week  HomeTeam  HomeScore  AwayTeam  AwayScore  Year     Type  \\\n",
       "3       1         9     139.98         6     128.00  2012  Regular   \n",
       "9       2         8      86.88         9     123.92  2012  Regular   \n",
       "14      3        11     115.88         9     122.34  2012  Regular   \n",
       "18      4         9      90.52         2     130.52  2012  Regular   \n",
       "22      5         5     170.54         9     144.68  2012  Regular   \n",
       "26      6         9     152.92         7     123.98  2012  Regular   \n",
       "30      7         9     133.12         1     139.04  2012  Regular   \n",
       "36      8        12     162.96         9     142.12  2012  Regular   \n",
       "42      9         9     191.94         3     133.16  2012  Regular   \n",
       "48     10         6     168.58         9     156.46  2012  Regular   \n",
       "54     11         9     127.00         8     133.04  2012  Regular   \n",
       "59     12         9     142.46        11     120.88  2012  Regular   \n",
       "63     13         2      81.22         9     146.88  2012  Regular   \n",
       "67     14         9     134.76         5      88.64  2012  Regular   \n",
       "83      1         9     146.90         6     115.14  2013  Regular   \n",
       "89      2         8     151.54         9     136.82  2013  Regular   \n",
       "94      3        11     128.32         9     140.70  2013  Regular   \n",
       "98      4         9     159.72         2     144.42  2013  Regular   \n",
       "102     5         5     184.92         9     121.26  2013  Regular   \n",
       "106     6         9     132.28         7     140.88  2013  Regular   \n",
       "110     7         9     133.90         1     153.30  2013  Regular   \n",
       "116     8        12      80.04         9     138.02  2013  Regular   \n",
       "122     9         9     200.94         3     100.44  2013  Regular   \n",
       "128    10         6     132.36         9     139.48  2013  Regular   \n",
       "134    11         9     116.50         8     157.52  2013  Regular   \n",
       "139    12         9     169.34        11      87.58  2013  Regular   \n",
       "143    13         2     195.88         9     185.48  2013  Regular   \n",
       "147    14         9     156.40         5     132.56  2013  Regular   \n",
       "160     1         9      91.26         1     150.82  2014  Regular   \n",
       "167     2         3     157.58         9     153.22  2014  Regular   \n",
       "..    ...       ...        ...       ...        ...   ...      ...   \n",
       "380    13         9     173.02         5     106.14  2016  Regular   \n",
       "386    14         2     131.26         9     136.82  2016  Regular   \n",
       "403     1         7     103.34         9     108.26  2017  Regular   \n",
       "407     2         9     125.46         1     135.04  2017  Regular   \n",
       "414     3         9     138.70         2     100.20  2017  Regular   \n",
       "415     4        11     140.56         9     101.26  2017  Regular   \n",
       "421     5         9     112.44         3     134.54  2017  Regular   \n",
       "429     6         6      82.92         9     126.18  2017  Regular   \n",
       "432     7         9     154.52         8     112.74  2017  Regular   \n",
       "439     8        12     146.64         9     138.74  2017  Regular   \n",
       "440     9         9     139.16         5     112.32  2017  Regular   \n",
       "448    10         9     130.30         7     158.38  2017  Regular   \n",
       "453    11         1     100.40         9     163.86  2017  Regular   \n",
       "459    12         2     126.50         9     137.88  2017  Regular   \n",
       "464    13        11     130.52         9     119.66  2017  Regular   \n",
       "468    14         9     176.48         3     128.06  2017  Regular   \n",
       "483     1         9     156.66         1     121.88  2018  Regular   \n",
       "489     2         3     151.82         9     124.72  2018  Regular   \n",
       "494     3        11     142.06         9     119.56  2018  Regular   \n",
       "498     4         9     146.16         6     114.00  2018  Regular   \n",
       "502     5         2     126.14         9     139.14  2018  Regular   \n",
       "506     6         9     165.28         5     144.04  2018  Regular   \n",
       "510     7         9     141.42        12     119.66  2018  Regular   \n",
       "516     8         8     134.12         9      94.12  2018  Regular   \n",
       "522     9         9     173.16         7     128.54  2018  Regular   \n",
       "528    10         1     145.84         9     171.10  2018  Regular   \n",
       "534    11         9     161.20         3     114.32  2018  Regular   \n",
       "539    12         9     127.10        11     128.20  2018  Regular   \n",
       "543    13         6     105.22         9      84.20  2018  Regular   \n",
       "547    14         9     117.02         2     161.04  2018  Regular   \n",
       "\n",
       "         AwayTeamName      HomeTeamName            Winner             Loser  \n",
       "3           Rosenberg         Berkowitz         Berkowitz         Rosenberg  \n",
       "9           Berkowitz           J.Stein         Berkowitz           J.Stein  \n",
       "14          Berkowitz             Kogan         Berkowitz             Kogan  \n",
       "18         Treshansky         Berkowitz        Treshansky         Berkowitz  \n",
       "22          Berkowitz             Klein             Klein         Berkowitz  \n",
       "26               Katz         Berkowitz         Berkowitz              Katz  \n",
       "30              Zwick         Berkowitz             Zwick         Berkowitz  \n",
       "36          Berkowitz  B.Stein/Kaminski  B.Stein/Kaminski         Berkowitz  \n",
       "42           Lirtzman         Berkowitz         Berkowitz          Lirtzman  \n",
       "48          Berkowitz         Rosenberg         Rosenberg         Berkowitz  \n",
       "54            J.Stein         Berkowitz           J.Stein         Berkowitz  \n",
       "59              Kogan         Berkowitz         Berkowitz             Kogan  \n",
       "63          Berkowitz        Treshansky         Berkowitz        Treshansky  \n",
       "67              Klein         Berkowitz         Berkowitz             Klein  \n",
       "83          Rosenberg         Berkowitz         Berkowitz         Rosenberg  \n",
       "89          Berkowitz           J.Stein           J.Stein         Berkowitz  \n",
       "94          Berkowitz             Kogan         Berkowitz             Kogan  \n",
       "98         Treshansky         Berkowitz         Berkowitz        Treshansky  \n",
       "102         Berkowitz             Klein             Klein         Berkowitz  \n",
       "106              Katz         Berkowitz              Katz         Berkowitz  \n",
       "110             Zwick         Berkowitz             Zwick         Berkowitz  \n",
       "116         Berkowitz  B.Stein/Kaminski         Berkowitz  B.Stein/Kaminski  \n",
       "122          Lirtzman         Berkowitz         Berkowitz          Lirtzman  \n",
       "128         Berkowitz         Rosenberg         Berkowitz         Rosenberg  \n",
       "134           J.Stein         Berkowitz           J.Stein         Berkowitz  \n",
       "139             Kogan         Berkowitz         Berkowitz             Kogan  \n",
       "143         Berkowitz        Treshansky        Treshansky         Berkowitz  \n",
       "147             Klein         Berkowitz         Berkowitz             Klein  \n",
       "160             Zwick         Berkowitz             Zwick         Berkowitz  \n",
       "167         Berkowitz          Lirtzman          Lirtzman         Berkowitz  \n",
       "..                ...               ...               ...               ...  \n",
       "380             Klein         Berkowitz         Berkowitz             Klein  \n",
       "386         Berkowitz        Treshansky         Berkowitz        Treshansky  \n",
       "403         Berkowitz              Katz         Berkowitz              Katz  \n",
       "407             Zwick         Berkowitz             Zwick         Berkowitz  \n",
       "414        Treshansky         Berkowitz         Berkowitz        Treshansky  \n",
       "415         Berkowitz             Kogan             Kogan         Berkowitz  \n",
       "421          Lirtzman         Berkowitz          Lirtzman         Berkowitz  \n",
       "429         Berkowitz         Rosenberg         Berkowitz         Rosenberg  \n",
       "432           J.Stein         Berkowitz         Berkowitz           J.Stein  \n",
       "439         Berkowitz  B.Stein/Kaminski  B.Stein/Kaminski         Berkowitz  \n",
       "440             Klein         Berkowitz         Berkowitz             Klein  \n",
       "448              Katz         Berkowitz              Katz         Berkowitz  \n",
       "453         Berkowitz             Zwick         Berkowitz             Zwick  \n",
       "459         Berkowitz        Treshansky         Berkowitz        Treshansky  \n",
       "464         Berkowitz             Kogan             Kogan         Berkowitz  \n",
       "468          Lirtzman         Berkowitz         Berkowitz          Lirtzman  \n",
       "483             Zwick         Berkowitz         Berkowitz             Zwick  \n",
       "489         Berkowitz          Lirtzman          Lirtzman         Berkowitz  \n",
       "494         Berkowitz             Kogan             Kogan         Berkowitz  \n",
       "498         Rosenberg         Berkowitz         Berkowitz         Rosenberg  \n",
       "502         Berkowitz        Treshansky         Berkowitz        Treshansky  \n",
       "506             Klein         Berkowitz         Berkowitz             Klein  \n",
       "510  B.Stein/Kaminski         Berkowitz         Berkowitz  B.Stein/Kaminski  \n",
       "516         Berkowitz           J.Stein           J.Stein         Berkowitz  \n",
       "522              Katz         Berkowitz         Berkowitz              Katz  \n",
       "528         Berkowitz             Zwick         Berkowitz             Zwick  \n",
       "534          Lirtzman         Berkowitz         Berkowitz          Lirtzman  \n",
       "539             Kogan         Berkowitz             Kogan         Berkowitz  \n",
       "543         Berkowitz         Rosenberg         Rosenberg         Berkowitz  \n",
       "547        Treshansky         Berkowitz        Treshansky         Berkowitz  \n",
       "\n",
       "[98 rows x 11 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "berk"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Winner            Loser           \n",
       "B.Stein/Kaminski  Berkowitz            3\n",
       "Berkowitz         B.Stein/Kaminski     4\n",
       "                  J.Stein              4\n",
       "                  Katz                 5\n",
       "                  Klein                7\n",
       "                  Kogan                8\n",
       "                  Lirtzman             6\n",
       "                  Rosenberg            8\n",
       "                  Treshansky          10\n",
       "                  Zwick                4\n",
       "J.Stein           Berkowitz            7\n",
       "Katz              Berkowitz            5\n",
       "Klein             Berkowitz            5\n",
       "Kogan             Berkowitz            5\n",
       "Lirtzman          Berkowitz            5\n",
       "Rosenberg         Berkowitz            2\n",
       "Treshansky        Berkowitz            3\n",
       "Zwick             Berkowitz            7\n",
       "dtype: int64"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "berk.groupby([\"Winner\", \"Loser\"]).size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}