DHS_Alumni_Functions.ipynb

{
 "cells": [
  {
   "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"
   ]
  },
  {
   "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]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "def build_matchups_df(years, owners_df, regular_season=True):\n",
    "    '''Function for building out regular season data for DHS Alumni League\n",
    "    :param years: list of years - can be single or multiple years, must be list\n",
    "    :param owners_df: dataframe of owners and IDs. Column order is owner_id, owner_name.\n",
    "    : return df: data frame of wins and losses'''\n",
    "    \n",
    "    matchups = pd.DataFrame()\n",
    "    \n",
    "    for year in years:\n",
    "        if year != 2019:\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 = \"AEB683YIFe%2B786%2BNKKZ2kKo05EAr4hqITemjED05C1hVaZmO5lvWwanduw64hL7sfOIclzgE2LcmmSoPM1WyS0IfZLKDG7gYc34Ig%2BrnwJr6tZ8uHYgKyplSEbGJCF0gieXa95jUvZugp4VViIVWHn9h%2FJ8qlfvwioLDqUJCh4Xf2E1FBm8v%2BzSMlKhABKJ85zFiWCDjE7bdTgDnAMLZ08WBns0w68zsG2vTe%2Ba70qnpQJo1DJsyhQmq9LwjNKiJCRxZ5F8NqFVsx%2B6S5K%2FtLaRC\"\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)\n",
    "        else:\n",
    "            url = \"https://fantasy.espn.com/apis/v3/games/ffl/seasons/\" + str(year) + \"/segments/0/leagues/\" + str(league_id)\n",
    "            swid = \"{0E55E5A5-3637-4BE0-86CF-E2E39B9938C9}\"\n",
    "            espn_s2 = \"AEB683YIFe%2B786%2BNKKZ2kKo05EAr4hqITemjED05C1hVaZmO5lvWwanduw64hL7sfOIclzgE2LcmmSoPM1WyS0IfZLKDG7gYc34Ig%2BrnwJr6tZ8uHYgKyplSEbGJCF0gieXa95jUvZugp4VViIVWHn9h%2FJ8qlfvwioLDqUJCh4Xf2E1FBm8v%2BzSMlKhABKJ85zFiWCDjE7bdTgDnAMLZ08WBns0w68zsG2vTe%2Ba70qnpQJo1DJsyhQmq9LwjNKiJCRxZ5F8NqFVsx%2B6S5K%2FtLaRC\"\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()\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",
    "            matchups = matchups.append(game_lst, ignore_index=True)\n",
    "        \n",
    "        \n",
    "    matchups.columns = [\"Week\", \"HomeTeam\", \"HomeScore\", \"AwayTeam\", \"AwayScore\", \"Year\"]\n",
    "    matchups[\"Type\"] = [\"Regular\" if w <=14 else \"Playoff\" for w in matchups[\"Week\"]]\n",
    "    \n",
    "    merged = pd.merge(matchups, owners_df, how=\"left\", left_on=\"AwayTeam\", right_on=\"owner_id\")\n",
    "    merged = merged.drop([\"owner_id\"], axis=1)\n",
    "    merged = merged.rename(columns={\"owner_name\": \"AwayTeamName\"})\n",
    "    merged = pd.merge(merged, owners_df, how=\"left\", left_on=\"HomeTeam\", right_on=\"owner_id\")\n",
    "    merged = merged.drop([\"owner_id\"], axis=1)\n",
    "    merged = merged.rename(columns={\"owner_name\": \"HomeTeamName\"})\n",
    "    \n",
    "    merged[\"Winner\"] = np.where(merged[\"HomeScore\"] > merged[\"AwayScore\"], merged[\"HomeTeamName\"], merged[\"AwayTeamName\"])\n",
    "    merged[\"Loser\"] = np.where(merged[\"HomeScore\"] > merged[\"AwayScore\"], merged[\"AwayTeamName\"], merged[\"HomeTeamName\"])\n",
    "    \n",
    "    \n",
    "    \n",
    "    if regular_season==True:\n",
    "        regular_season = merged[merged[\"Type\"] == \"Regular\"]\n",
    "        df = regular_season\n",
    "        return df\n",
    "    else:\n",
    "        df = merged\n",
    "        return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [],
   "source": [
    "regular_season = build_matchups_df([2012,2013,2014,2015,2016,2017,2018,2019], owners_df, regular_season=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "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",
       "  </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            Winner       Loser  \n",
       "0        Treshansky             Zwick  Treshansky  \n",
       "1  B.Stein/Kaminski  B.Stein/Kaminski    Lirtzman  \n",
       "2             Kogan             Klein       Kogan  \n",
       "3         Berkowitz         Berkowitz   Rosenberg  \n",
       "4           J.Stein              Katz     J.Stein  "
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "regular_season.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "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>625</th>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>148.08</td>\n",
       "      <td>3</td>\n",
       "      <td>110.16</td>\n",
       "      <td>2019</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Lirtzman</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Treshansky</td>\n",
       "      <td>Lirtzman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>626</th>\n",
       "      <td>14</td>\n",
       "      <td>8</td>\n",
       "      <td>142.00</td>\n",
       "      <td>6</td>\n",
       "      <td>145.52</td>\n",
       "      <td>2019</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>627</th>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>137.02</td>\n",
       "      <td>12</td>\n",
       "      <td>144.06</td>\n",
       "      <td>2019</td>\n",
       "      <td>Regular</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>628</th>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>122.16</td>\n",
       "      <td>11</td>\n",
       "      <td>137.14</td>\n",
       "      <td>2019</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Zwick</td>\n",
       "      <td>Kogan</td>\n",
       "      <td>Zwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>629</th>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>95.46</td>\n",
       "      <td>9</td>\n",
       "      <td>148.26</td>\n",
       "      <td>2019</td>\n",
       "      <td>Regular</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Klein</td>\n",
       "      <td>Berkowitz</td>\n",
       "      <td>Klein</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Week  HomeTeam  HomeScore  AwayTeam  AwayScore  Year     Type  \\\n",
       "625    14         2     148.08         3     110.16  2019  Regular   \n",
       "626    14         8     142.00         6     145.52  2019  Regular   \n",
       "627    14         7     137.02        12     144.06  2019  Regular   \n",
       "628    14         1     122.16        11     137.14  2019  Regular   \n",
       "629    14         5      95.46         9     148.26  2019  Regular   \n",
       "\n",
       "         AwayTeamName HomeTeamName            Winner     Loser  \n",
       "625          Lirtzman   Treshansky        Treshansky  Lirtzman  \n",
       "626         Rosenberg      J.Stein         Rosenberg   J.Stein  \n",
       "627  B.Stein/Kaminski         Katz  B.Stein/Kaminski      Katz  \n",
       "628             Kogan        Zwick             Kogan     Zwick  \n",
       "629         Berkowitz        Klein         Berkowitz     Klein  "
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "regular_season.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Katz                66\n",
       "Zwick               62\n",
       "Berkowitz           61\n",
       "J.Stein             59\n",
       "Klein               58\n",
       "Lirtzman            56\n",
       "Treshansky          55\n",
       "B.Stein/Kaminski    54\n",
       "Rosenberg           53\n",
       "Kogan               36\n",
       "Name: Winner, dtype: int64"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "regular_season[\"Winner\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_total_wins_and_losses(df, years=[i for i in range(2012, 2020)]):\n",
    "    '''Function for aggregating wins and losses by team by year'''\n",
    "    totals = pd.DataFrame(columns = [\"Wins\", \"Losses\", \"WinPct\"])\n",
    "    if len(years) == 1:\n",
    "        mask = df[\"Year\"] == min(years)\n",
    "        df = df.loc[mask].copy()\n",
    "        totals[\"Wins\"] = df[\"Winner\"].value_counts()\n",
    "        totals[\"Losses\"] = df[\"Loser\"].value_counts()\n",
    "        totals[\"WinPct\"] = totals[\"Wins\"] / (totals[\"Wins\"] + totals[\"Losses\"])\n",
    "        return totals\n",
    "    else:\n",
    "        mask = (regular_season[\"Year\"] >= min(years)) & (regular_season[\"Year\"] <= max(years))\n",
    "        df = df.loc[mask].copy()\n",
    "        df = df[(df[\"Year\"] >= min(years)) & (df[\"Year\"] <= max(years))]\n",
    "        totals[\"Wins\"] = df[\"Winner\"].value_counts()\n",
    "        totals[\"Losses\"] = df[\"Loser\"].value_counts()\n",
    "        totals[\"WinPct\"] = totals[\"Wins\"] / (totals[\"Wins\"] + totals[\"Losses\"])\n",
    "        return totals"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [],
   "source": [
    "totals = get_total_wins_and_losses(regular_season)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "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",
       "      <th>WinPct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Katz</th>\n",
       "      <td>66</td>\n",
       "      <td>46</td>\n",
       "      <td>0.589286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zwick</th>\n",
       "      <td>62</td>\n",
       "      <td>50</td>\n",
       "      <td>0.553571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Berkowitz</th>\n",
       "      <td>61</td>\n",
       "      <td>51</td>\n",
       "      <td>0.544643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>J.Stein</th>\n",
       "      <td>59</td>\n",
       "      <td>53</td>\n",
       "      <td>0.526786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Klein</th>\n",
       "      <td>58</td>\n",
       "      <td>54</td>\n",
       "      <td>0.517857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lirtzman</th>\n",
       "      <td>56</td>\n",
       "      <td>56</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Treshansky</th>\n",
       "      <td>55</td>\n",
       "      <td>57</td>\n",
       "      <td>0.491071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B.Stein/Kaminski</th>\n",
       "      <td>54</td>\n",
       "      <td>58</td>\n",
       "      <td>0.482143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rosenberg</th>\n",
       "      <td>53</td>\n",
       "      <td>59</td>\n",
       "      <td>0.473214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kogan</th>\n",
       "      <td>36</td>\n",
       "      <td>76</td>\n",
       "      <td>0.321429</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Wins  Losses    WinPct\n",
       "Katz                66      46  0.589286\n",
       "Zwick               62      50  0.553571\n",
       "Berkowitz           61      51  0.544643\n",
       "J.Stein             59      53  0.526786\n",
       "Klein               58      54  0.517857\n",
       "Lirtzman            56      56  0.500000\n",
       "Treshansky          55      57  0.491071\n",
       "B.Stein/Kaminski    54      58  0.482143\n",
       "Rosenberg           53      59  0.473214\n",
       "Kogan               36      76  0.321429"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "totals"
   ]
  },
  {
   "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
}