DHSAlumni ESPN Fantasy Analytics.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# DHS Alumni Fantasy Analytics\n",
    "\n",
    "In this notebook, I'll aim to start with the following analyses for the DHSAlumni fantasy league:\n",
    "- All-time records, and season by seaason records\n",
    "- Plot a season by lucky vs unlucky records\n",
    "- Best picks relative to draft position in any given year"
   ]
  },
  {
   "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": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://fantasy.espn.com/apis/v3/games/ffl/leagueHistory/470074?seasonId=2012\n"
     ]
    }
   ],
   "source": [
    "#Requesting data from DHSAlumni league starting with 2012\n",
    "\n",
    "league_id = 470074\n",
    "year = 2012\n",
    "url = \"https://fantasy.espn.com/apis/v3/games/ffl/leagueHistory/\" + \\\n",
    "      str(league_id) + \"?seasonId=\" + str(year)\n",
    "\n",
    "print(url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Setting swid and espn_s2 for our private league\n",
    "\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\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#requesting data from our private league\n",
    "\n",
    "r = requests.get(url,\n",
    "                 cookies={\"swid\": \"{0E55E5A5-3637-4BE0-86CF-E2E39B9938C9}\",\n",
    "                          \"espn_s2\": \"AEAZNuutax36J%2BmmE9X0oeTTRyhq0DrK2gcqVGB7Cxc75XXs4TJxz73ekvnJdz33IFF4fJXslPhu7SEmT9Q4c%2Fv1jXfA%2B4Kl6scPVRUks%2B5xLpe4XvomcuqovBxd6ZoSDpzoMJ%2FpjoUsuzVflGKkdgv6ZlBsl%2Bc7s3VgBprIHx6juy5SV9ac3PVT%2F5Su%2FAb51g7p60Ebxw6Qi%2FaGj%2B7Y8sq4sPlNsqW32UXk2xJJH%2BP5%2B14PFH2ky%2BHeNwRewSBDMa3zsdLPlWnw9kbm6GLdvesu\"})\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'gameId': 1,\n",
       " 'id': 470074,\n",
       " 'members': [{'displayName': 'sklein414',\n",
       "   'id': '{05A6DF7E-1741-4FDD-B375-419DEE85EC2D}',\n",
       "   'isLeagueManager': False},\n",
       "  {'displayName': 'JBerko11',\n",
       "   'id': '{0E55E5A5-3637-4BE0-86CF-E2E39B9938C9}',\n",
       "   'isLeagueManager': True},\n",
       "  {'displayName': 'Lirtz18',\n",
       "   'id': '{1C427F2E-81A6-461B-97D4-E9631B6B92BD}',\n",
       "   'isLeagueManager': False},\n",
       "  {'displayName': 'Greg6354',\n",
       "   'id': '{50788F32-880C-424E-A4B2-8559A9870D3B}',\n",
       "   'isLeagueManager': False},\n",
       "  {'displayName': 'brad2186',\n",
       "   'id': '{52D81102-758F-4AC0-8A7C-1FAE1B504238}',\n",
       "   'isLeagueManager': False},\n",
       "  {'displayName': 'aet015',\n",
       "   'id': '{5D23DE4F-0131-46D4-B332-8AFFBBE4E4DB}',\n",
       "   'isLeagueManager': False},\n",
       "  {'displayName': 'pokeystein',\n",
       "   'id': '{7D508B60-CD5E-4118-85D4-9A72AA063395}',\n",
       "   'isLeagueManager': False},\n",
       "  {'displayName': 'jrosenberg703',\n",
       "   'id': '{A48B1E1D-476B-4877-AE6F-61EA9BEC38AC}',\n",
       "   'isLeagueManager': False},\n",
       "  {'displayName': 'TheZwick',\n",
       "   'id': '{B815DE56-C961-43F8-B904-B82DC95C4F39}',\n",
       "   'isLeagueManager': False},\n",
       "  {'displayName': 'kogan4',\n",
       "   'id': '{F570025D-D594-4A8B-B4EB-ABDC9F4F892D}',\n",
       "   'isLeagueManager': False}],\n",
       " 'scoringPeriodId': 16,\n",
       " 'seasonId': 2012,\n",
       " 'segmentId': 0,\n",
       " 'settings': {'name': 'DHSAlumni'},\n",
       " 'status': {'currentMatchupPeriod': 16,\n",
       "  'isActive': True,\n",
       "  'latestScoringPeriod': 18},\n",
       " 'teams': [{'abbrev': 'ZWIC',\n",
       "   'id': 1,\n",
       "   'location': 'Kevan',\n",
       "   'nickname': 'Barlow',\n",
       "   'owners': ['{B815DE56-C961-43F8-B904-B82DC95C4F39}']},\n",
       "  {'abbrev': 'TRES',\n",
       "   'id': 2,\n",
       "   'location': \"That's\",\n",
       "   'nickname': 'My Bush',\n",
       "   'owners': ['{5D23DE4F-0131-46D4-B332-8AFFBBE4E4DB}']},\n",
       "  {'abbrev': 'BOOB',\n",
       "   'id': 3,\n",
       "   'location': 'Earlravius',\n",
       "   'nickname': 'Nellums',\n",
       "   'owners': ['{1C427F2E-81A6-461B-97D4-E9631B6B92BD}']},\n",
       "  {'abbrev': 'KLEI',\n",
       "   'id': 5,\n",
       "   'location': 'Team',\n",
       "   'nickname': 'Klein',\n",
       "   'owners': ['{05A6DF7E-1741-4FDD-B375-419DEE85EC2D}']},\n",
       "  {'abbrev': 'WOAH',\n",
       "   'id': 6,\n",
       "   'location': 'Lord',\n",
       "   'nickname': 'Rosenberg',\n",
       "   'owners': ['{A48B1E1D-476B-4877-AE6F-61EA9BEC38AC}']},\n",
       "  {'abbrev': 'KATZ',\n",
       "   'id': 7,\n",
       "   'location': \"Sippin' on some\",\n",
       "   'nickname': 'Cruzan ',\n",
       "   'owners': ['{50788F32-880C-424E-A4B2-8559A9870D3B}']},\n",
       "  {'abbrev': 'STEI',\n",
       "   'id': 8,\n",
       "   'location': 'Kogan is a Dog',\n",
       "   'nickname': 'Shit Lawyer...',\n",
       "   'owners': ['{7D508B60-CD5E-4118-85D4-9A72AA063395}']},\n",
       "  {'abbrev': 'BERK',\n",
       "   'id': 9,\n",
       "   'location': 'The Muscle',\n",
       "   'nickname': 'Hamsters',\n",
       "   'owners': ['{0E55E5A5-3637-4BE0-86CF-E2E39B9938C9}']},\n",
       "  {'abbrev': 'KOGA',\n",
       "   'id': 11,\n",
       "   'location': 'The Bar Mitzvah',\n",
       "   'nickname': 'Snowball Boners',\n",
       "   'owners': ['{F570025D-D594-4A8B-B4EB-ABDC9F4F892D}']},\n",
       "  {'abbrev': 'WSOX',\n",
       "   'id': 12,\n",
       "   'location': 'CROWN',\n",
       "   'nickname': 'US',\n",
       "   'owners': ['{52D81102-758F-4AC0-8A7C-1FAE1B504238}']}]}"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Displaying basic data about our league\n",
    "teams_info = r.json()[0]\n",
    "teams_info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>abbrev</th>\n",
       "      <th>id</th>\n",
       "      <th>location</th>\n",
       "      <th>nickname</th>\n",
       "      <th>owners</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ZWIC</td>\n",
       "      <td>1</td>\n",
       "      <td>Kevan</td>\n",
       "      <td>Barlow</td>\n",
       "      <td>{B815DE56-C961-43F8-B904-B82DC95C4F39}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TRES</td>\n",
       "      <td>2</td>\n",
       "      <td>That's</td>\n",
       "      <td>My Bush</td>\n",
       "      <td>{5D23DE4F-0131-46D4-B332-8AFFBBE4E4DB}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BOOB</td>\n",
       "      <td>3</td>\n",
       "      <td>Earlravius</td>\n",
       "      <td>Nellums</td>\n",
       "      <td>{1C427F2E-81A6-461B-97D4-E9631B6B92BD}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>KLEI</td>\n",
       "      <td>5</td>\n",
       "      <td>Team</td>\n",
       "      <td>Klein</td>\n",
       "      <td>{05A6DF7E-1741-4FDD-B375-419DEE85EC2D}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>WOAH</td>\n",
       "      <td>6</td>\n",
       "      <td>Lord</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>{A48B1E1D-476B-4877-AE6F-61EA9BEC38AC}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>KATZ</td>\n",
       "      <td>7</td>\n",
       "      <td>Sippin' on some</td>\n",
       "      <td>Cruzan</td>\n",
       "      <td>{50788F32-880C-424E-A4B2-8559A9870D3B}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>STEI</td>\n",
       "      <td>8</td>\n",
       "      <td>Kogan is a Dog</td>\n",
       "      <td>Shit Lawyer...</td>\n",
       "      <td>{7D508B60-CD5E-4118-85D4-9A72AA063395}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BERK</td>\n",
       "      <td>9</td>\n",
       "      <td>The Muscle</td>\n",
       "      <td>Hamsters</td>\n",
       "      <td>{0E55E5A5-3637-4BE0-86CF-E2E39B9938C9}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>KOGA</td>\n",
       "      <td>11</td>\n",
       "      <td>The Bar Mitzvah</td>\n",
       "      <td>Snowball Boners</td>\n",
       "      <td>{F570025D-D594-4A8B-B4EB-ABDC9F4F892D}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>WSOX</td>\n",
       "      <td>12</td>\n",
       "      <td>CROWN</td>\n",
       "      <td>US</td>\n",
       "      <td>{52D81102-758F-4AC0-8A7C-1FAE1B504238}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  abbrev  id         location         nickname  \\\n",
       "0   ZWIC   1            Kevan           Barlow   \n",
       "1   TRES   2           That's          My Bush   \n",
       "2   BOOB   3       Earlravius          Nellums   \n",
       "3   KLEI   5             Team            Klein   \n",
       "4   WOAH   6             Lord        Rosenberg   \n",
       "5   KATZ   7  Sippin' on some          Cruzan    \n",
       "6   STEI   8   Kogan is a Dog   Shit Lawyer...   \n",
       "7   BERK   9       The Muscle         Hamsters   \n",
       "8   KOGA  11  The Bar Mitzvah  Snowball Boners   \n",
       "9   WSOX  12            CROWN               US   \n",
       "\n",
       "                                   owners  \n",
       "0  {B815DE56-C961-43F8-B904-B82DC95C4F39}  \n",
       "1  {5D23DE4F-0131-46D4-B332-8AFFBBE4E4DB}  \n",
       "2  {1C427F2E-81A6-461B-97D4-E9631B6B92BD}  \n",
       "3  {05A6DF7E-1741-4FDD-B375-419DEE85EC2D}  \n",
       "4  {A48B1E1D-476B-4877-AE6F-61EA9BEC38AC}  \n",
       "5  {50788F32-880C-424E-A4B2-8559A9870D3B}  \n",
       "6  {7D508B60-CD5E-4118-85D4-9A72AA063395}  \n",
       "7  {0E55E5A5-3637-4BE0-86CF-E2E39B9938C9}  \n",
       "8  {F570025D-D594-4A8B-B4EB-ABDC9F4F892D}  \n",
       "9  {52D81102-758F-4AC0-8A7C-1FAE1B504238}  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Putting teams data into a dataframe\n",
    "# for team in teams_info[\"teams\"]:\n",
    "#     print(team)\n",
    "    \n",
    "teams_lst = [team for team in teams_info[\"teams\"]]\n",
    "teams_df = pd.DataFrame(teams_lst)\n",
    "teams_df[\"owners\"] = teams_df[\"owners\"].str[0]\n",
    "teams_df"
   ]
  },
  {
   "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>displayName</th>\n",
       "      <th>owners</th>\n",
       "      <th>isLeagueManager</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>sklein414</td>\n",
       "      <td>{05A6DF7E-1741-4FDD-B375-419DEE85EC2D}</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>JBerko11</td>\n",
       "      <td>{0E55E5A5-3637-4BE0-86CF-E2E39B9938C9}</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Lirtz18</td>\n",
       "      <td>{1C427F2E-81A6-461B-97D4-E9631B6B92BD}</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Greg6354</td>\n",
       "      <td>{50788F32-880C-424E-A4B2-8559A9870D3B}</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>brad2186</td>\n",
       "      <td>{52D81102-758F-4AC0-8A7C-1FAE1B504238}</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>aet015</td>\n",
       "      <td>{5D23DE4F-0131-46D4-B332-8AFFBBE4E4DB}</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>pokeystein</td>\n",
       "      <td>{7D508B60-CD5E-4118-85D4-9A72AA063395}</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>jrosenberg703</td>\n",
       "      <td>{A48B1E1D-476B-4877-AE6F-61EA9BEC38AC}</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>TheZwick</td>\n",
       "      <td>{B815DE56-C961-43F8-B904-B82DC95C4F39}</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>kogan4</td>\n",
       "      <td>{F570025D-D594-4A8B-B4EB-ABDC9F4F892D}</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     displayName                                  owners  isLeagueManager\n",
       "0      sklein414  {05A6DF7E-1741-4FDD-B375-419DEE85EC2D}            False\n",
       "1       JBerko11  {0E55E5A5-3637-4BE0-86CF-E2E39B9938C9}             True\n",
       "2        Lirtz18  {1C427F2E-81A6-461B-97D4-E9631B6B92BD}            False\n",
       "3       Greg6354  {50788F32-880C-424E-A4B2-8559A9870D3B}            False\n",
       "4       brad2186  {52D81102-758F-4AC0-8A7C-1FAE1B504238}            False\n",
       "5         aet015  {5D23DE4F-0131-46D4-B332-8AFFBBE4E4DB}            False\n",
       "6     pokeystein  {7D508B60-CD5E-4118-85D4-9A72AA063395}            False\n",
       "7  jrosenberg703  {A48B1E1D-476B-4877-AE6F-61EA9BEC38AC}            False\n",
       "8       TheZwick  {B815DE56-C961-43F8-B904-B82DC95C4F39}            False\n",
       "9         kogan4  {F570025D-D594-4A8B-B4EB-ABDC9F4F892D}            False"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "members_lst = [member for member in teams_info[\"members\"]]\n",
    "members_df = pd.DataFrame(members_lst)\n",
    "members_df.columns = [\"displayName\", \"owners\", \"isLeagueManager\"]\n",
    "members_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>abbrev</th>\n",
       "      <th>id</th>\n",
       "      <th>location</th>\n",
       "      <th>nickname</th>\n",
       "      <th>owners</th>\n",
       "      <th>displayName</th>\n",
       "      <th>isLeagueManager</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ZWIC</td>\n",
       "      <td>1</td>\n",
       "      <td>Kevan</td>\n",
       "      <td>Barlow</td>\n",
       "      <td>{B815DE56-C961-43F8-B904-B82DC95C4F39}</td>\n",
       "      <td>TheZwick</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TRES</td>\n",
       "      <td>2</td>\n",
       "      <td>That's</td>\n",
       "      <td>My Bush</td>\n",
       "      <td>{5D23DE4F-0131-46D4-B332-8AFFBBE4E4DB}</td>\n",
       "      <td>aet015</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BOOB</td>\n",
       "      <td>3</td>\n",
       "      <td>Earlravius</td>\n",
       "      <td>Nellums</td>\n",
       "      <td>{1C427F2E-81A6-461B-97D4-E9631B6B92BD}</td>\n",
       "      <td>Lirtz18</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>KLEI</td>\n",
       "      <td>5</td>\n",
       "      <td>Team</td>\n",
       "      <td>Klein</td>\n",
       "      <td>{05A6DF7E-1741-4FDD-B375-419DEE85EC2D}</td>\n",
       "      <td>sklein414</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>WOAH</td>\n",
       "      <td>6</td>\n",
       "      <td>Lord</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>{A48B1E1D-476B-4877-AE6F-61EA9BEC38AC}</td>\n",
       "      <td>jrosenberg703</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>KATZ</td>\n",
       "      <td>7</td>\n",
       "      <td>Sippin' on some</td>\n",
       "      <td>Cruzan</td>\n",
       "      <td>{50788F32-880C-424E-A4B2-8559A9870D3B}</td>\n",
       "      <td>Greg6354</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>STEI</td>\n",
       "      <td>8</td>\n",
       "      <td>Kogan is a Dog</td>\n",
       "      <td>Shit Lawyer...</td>\n",
       "      <td>{7D508B60-CD5E-4118-85D4-9A72AA063395}</td>\n",
       "      <td>pokeystein</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BERK</td>\n",
       "      <td>9</td>\n",
       "      <td>The Muscle</td>\n",
       "      <td>Hamsters</td>\n",
       "      <td>{0E55E5A5-3637-4BE0-86CF-E2E39B9938C9}</td>\n",
       "      <td>JBerko11</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>KOGA</td>\n",
       "      <td>11</td>\n",
       "      <td>The Bar Mitzvah</td>\n",
       "      <td>Snowball Boners</td>\n",
       "      <td>{F570025D-D594-4A8B-B4EB-ABDC9F4F892D}</td>\n",
       "      <td>kogan4</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>WSOX</td>\n",
       "      <td>12</td>\n",
       "      <td>CROWN</td>\n",
       "      <td>US</td>\n",
       "      <td>{52D81102-758F-4AC0-8A7C-1FAE1B504238}</td>\n",
       "      <td>brad2186</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  abbrev  id         location         nickname  \\\n",
       "0   ZWIC   1            Kevan           Barlow   \n",
       "1   TRES   2           That's          My Bush   \n",
       "2   BOOB   3       Earlravius          Nellums   \n",
       "3   KLEI   5             Team            Klein   \n",
       "4   WOAH   6             Lord        Rosenberg   \n",
       "5   KATZ   7  Sippin' on some          Cruzan    \n",
       "6   STEI   8   Kogan is a Dog   Shit Lawyer...   \n",
       "7   BERK   9       The Muscle         Hamsters   \n",
       "8   KOGA  11  The Bar Mitzvah  Snowball Boners   \n",
       "9   WSOX  12            CROWN               US   \n",
       "\n",
       "                                   owners    displayName  isLeagueManager  \n",
       "0  {B815DE56-C961-43F8-B904-B82DC95C4F39}       TheZwick            False  \n",
       "1  {5D23DE4F-0131-46D4-B332-8AFFBBE4E4DB}         aet015            False  \n",
       "2  {1C427F2E-81A6-461B-97D4-E9631B6B92BD}        Lirtz18            False  \n",
       "3  {05A6DF7E-1741-4FDD-B375-419DEE85EC2D}      sklein414            False  \n",
       "4  {A48B1E1D-476B-4877-AE6F-61EA9BEC38AC}  jrosenberg703            False  \n",
       "5  {50788F32-880C-424E-A4B2-8559A9870D3B}       Greg6354            False  \n",
       "6  {7D508B60-CD5E-4118-85D4-9A72AA063395}     pokeystein            False  \n",
       "7  {0E55E5A5-3637-4BE0-86CF-E2E39B9938C9}       JBerko11             True  \n",
       "8  {F570025D-D594-4A8B-B4EB-ABDC9F4F892D}         kogan4            False  \n",
       "9  {52D81102-758F-4AC0-8A7C-1FAE1B504238}       brad2186            False  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "teams_df = teams_df.merge(members_df, on=\"owners\")\n",
    "teams_df"
   ]
  },
  {
   "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>abbrev</th>\n",
       "      <th>id</th>\n",
       "      <th>location</th>\n",
       "      <th>nickname</th>\n",
       "      <th>owners</th>\n",
       "      <th>displayName</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ZWIC</td>\n",
       "      <td>1</td>\n",
       "      <td>Kevan</td>\n",
       "      <td>Barlow</td>\n",
       "      <td>{B815DE56-C961-43F8-B904-B82DC95C4F39}</td>\n",
       "      <td>TheZwick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TRES</td>\n",
       "      <td>2</td>\n",
       "      <td>That's</td>\n",
       "      <td>My Bush</td>\n",
       "      <td>{5D23DE4F-0131-46D4-B332-8AFFBBE4E4DB}</td>\n",
       "      <td>aet015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BOOB</td>\n",
       "      <td>3</td>\n",
       "      <td>Earlravius</td>\n",
       "      <td>Nellums</td>\n",
       "      <td>{1C427F2E-81A6-461B-97D4-E9631B6B92BD}</td>\n",
       "      <td>Lirtz18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>KLEI</td>\n",
       "      <td>5</td>\n",
       "      <td>Team</td>\n",
       "      <td>Klein</td>\n",
       "      <td>{05A6DF7E-1741-4FDD-B375-419DEE85EC2D}</td>\n",
       "      <td>sklein414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>WOAH</td>\n",
       "      <td>6</td>\n",
       "      <td>Lord</td>\n",
       "      <td>Rosenberg</td>\n",
       "      <td>{A48B1E1D-476B-4877-AE6F-61EA9BEC38AC}</td>\n",
       "      <td>jrosenberg703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>KATZ</td>\n",
       "      <td>7</td>\n",
       "      <td>Sippin' on some</td>\n",
       "      <td>Cruzan</td>\n",
       "      <td>{50788F32-880C-424E-A4B2-8559A9870D3B}</td>\n",
       "      <td>Greg6354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>STEI</td>\n",
       "      <td>8</td>\n",
       "      <td>Kogan is a Dog</td>\n",
       "      <td>Shit Lawyer...</td>\n",
       "      <td>{7D508B60-CD5E-4118-85D4-9A72AA063395}</td>\n",
       "      <td>pokeystein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BERK</td>\n",
       "      <td>9</td>\n",
       "      <td>The Muscle</td>\n",
       "      <td>Hamsters</td>\n",
       "      <td>{0E55E5A5-3637-4BE0-86CF-E2E39B9938C9}</td>\n",
       "      <td>JBerko11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>KOGA</td>\n",
       "      <td>11</td>\n",
       "      <td>The Bar Mitzvah</td>\n",
       "      <td>Snowball Boners</td>\n",
       "      <td>{F570025D-D594-4A8B-B4EB-ABDC9F4F892D}</td>\n",
       "      <td>kogan4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>WSOX</td>\n",
       "      <td>12</td>\n",
       "      <td>CROWN</td>\n",
       "      <td>US</td>\n",
       "      <td>{52D81102-758F-4AC0-8A7C-1FAE1B504238}</td>\n",
       "      <td>brad2186</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  abbrev  id         location         nickname  \\\n",
       "0   ZWIC   1            Kevan           Barlow   \n",
       "1   TRES   2           That's          My Bush   \n",
       "2   BOOB   3       Earlravius          Nellums   \n",
       "3   KLEI   5             Team            Klein   \n",
       "4   WOAH   6             Lord        Rosenberg   \n",
       "5   KATZ   7  Sippin' on some          Cruzan    \n",
       "6   STEI   8   Kogan is a Dog   Shit Lawyer...   \n",
       "7   BERK   9       The Muscle         Hamsters   \n",
       "8   KOGA  11  The Bar Mitzvah  Snowball Boners   \n",
       "9   WSOX  12            CROWN               US   \n",
       "\n",
       "                                   owners    displayName  \n",
       "0  {B815DE56-C961-43F8-B904-B82DC95C4F39}       TheZwick  \n",
       "1  {5D23DE4F-0131-46D4-B332-8AFFBBE4E4DB}         aet015  \n",
       "2  {1C427F2E-81A6-461B-97D4-E9631B6B92BD}        Lirtz18  \n",
       "3  {05A6DF7E-1741-4FDD-B375-419DEE85EC2D}      sklein414  \n",
       "4  {A48B1E1D-476B-4877-AE6F-61EA9BEC38AC}  jrosenberg703  \n",
       "5  {50788F32-880C-424E-A4B2-8559A9870D3B}       Greg6354  \n",
       "6  {7D508B60-CD5E-4118-85D4-9A72AA063395}     pokeystein  \n",
       "7  {0E55E5A5-3637-4BE0-86CF-E2E39B9938C9}       JBerko11  \n",
       "8  {F570025D-D594-4A8B-B4EB-ABDC9F4F892D}         kogan4  \n",
       "9  {52D81102-758F-4AC0-8A7C-1FAE1B504238}       brad2186  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "teams_df = teams_df.drop(\"isLeagueManager\", axis=1)\n",
    "teams_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Pulling mMatchup data\n",
    "r = requests.get(url, cookies={\"swid\": swid, \"espn_s2\": espn_s2}, params={\"view\": \"mMatchup\"})\n",
    "\n",
    "matchup_json = r.json()[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>Team1</th>\n",
       "      <th>Score1</th>\n",
       "      <th>Team2</th>\n",
       "      <th>Score2</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>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>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>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>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>Regular</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Week  Team1  Score1  Team2  Score2     Type\n",
       "0     1      2  143.40      1  146.60  Regular\n",
       "1     1     12  146.46      3  107.60  Regular\n",
       "2     1     11  118.46      5  140.56  Regular\n",
       "3     1      9  139.98      6  128.00  Regular\n",
       "4     1      8  126.36      7  131.32  Regular"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "game_lst = [[game['matchupPeriodId'],\n",
    "            game['home']['teamId'], game['home']['totalPoints'],\n",
    "            game['away']['teamId'], game['away']['totalPoints']\n",
    "           ] for game in matchup_json['schedule']]\n",
    "\n",
    "games_df = pd.DataFrame(game_lst, columns=['Week', 'Team1', 'Score1', 'Team2', 'Score2'])\n",
    "games_df[\"Type\"] = [\"Regular\" if w <=14 else \"Playoff\" for w in games_df[\"Week\"]]\n",
    "games_df.head()"
   ]
  },
  {
   "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>Team1</th>\n",
       "      <th>Score1</th>\n",
       "      <th>Team2</th>\n",
       "      <th>Score2</th>\n",
       "      <th>Type</th>\n",
       "      <th>Winner</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>Regular</td>\n",
       "      <td>1</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>Regular</td>\n",
       "      <td>12</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>Regular</td>\n",
       "      <td>5</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>Regular</td>\n",
       "      <td>9</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>Regular</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Week  Team1  Score1  Team2  Score2     Type  Winner\n",
       "0     1      2  143.40      1  146.60  Regular       1\n",
       "1     1     12  146.46      3  107.60  Regular      12\n",
       "2     1     11  118.46      5  140.56  Regular       5\n",
       "3     1      9  139.98      6  128.00  Regular       9\n",
       "4     1      8  126.36      7  131.32  Regular       7"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "games_df[\"Winner\"] = np.where(games_df[\"Score1\"] > games_df[\"Score2\"], games_df[\"Team1\"], games_df[\"Team2\"])\n",
    "games_df.head()"
   ]
  },
  {
   "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
}