FF_2021_nb.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This is a retrospective data analysis of our ESPN Fantasy Football league data at the end of Week 17 for the 2021 season. The code can be re-used for any past season using the same ESPN API.\n",
    "\n",
    "I used the [sportsipy API](https://sportsreference.readthedocs.io/en/stable/nfl.html) for NFL schedules and [Christian Wendt's ESPN Fantasy Football API](https://github.com/cwendt94/espn-api) to extract ESPN league-specific data.\n",
    "\n",
    "For data visualization, I used the [Altair Data Visualization Library](https://altair-viz.github.io/). Altair was chosen for its interactivity, especially for its ability to display hover data and the compatibility of interactive plots with GitHub Pages."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import plotly.express as px\n",
    "import plotly.io as pio\n",
    "import plotly.graph_objects as go\n",
    "import altair as alt\n",
    "\n",
    "from datetime import date\n",
    "from datetime import datetime, timedelta\n",
    "\n",
    "import requests\n",
    "import espn_api\n",
    "from espn_api.football import League\n",
    "from espn_api.football import activity\n",
    "\n",
    "import sportsipy.nfl\n",
    "from sportsipy.nfl.boxscore import Boxscore\n",
    "from sportsipy.nfl.schedule import Schedule\n",
    "from sportsipy.nfl.teams import Teams\n",
    "import nfl_data_py as nfl"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Establish year and length of regular season (number of weeks)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {},
   "outputs": [],
   "source": [
    "year_of_interest = 2021\n",
    "games_all_season = 18"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Perform conversion between sportsipy and ESPN API team abbreviation conventions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_games = nfl.import_schedules([year_of_interest])\n",
    "\n",
    "teams = Teams()\n",
    "\n",
    "df_team_names = pd.DataFrame(columns = ['Pro Team Name' , 'Abbrev'])\n",
    "abbrev_ls = []\n",
    "team_name_ls = []\n",
    "\n",
    "for team in teams:\n",
    "    abbrev_ls.append(team.abbreviation)\n",
    "    team_name_ls.append(team.name)\n",
    "    \n",
    "df_team_names['Pro Team Name'] = team_name_ls\n",
    "df_team_names['Abbrev'] = abbrev_ls\n",
    "\n",
    "df_team_names.sort_values('Pro Team Name',ascending=True,inplace=True)\n",
    "\n",
    "df_team_names.to_csv('abbrev_names.csv')\n",
    "\n",
    "df_team_name_convert = pd.read_csv('team_abbrev_conversion.csv').set_index('Abbrev_sportsipy')\n",
    "\n",
    "conv_dict = df_team_name_convert['Abbrev'].to_dict()\n",
    "\n",
    "df_proteam_schedule = pd.read_csv('team_abbrev.csv' , index_col=False).drop(['Unnamed: 0'],axis=1).set_index('Abbrev_sportsipy')\n",
    "\n",
    "pro_team_ls = df_proteam_schedule.index.tolist()\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Build NFL team schedules with dates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [],
   "source": [
    "# series for each NFL team:\n",
    "\n",
    "wk_ls = [i+1 for i in list(range(games_all_season))]\n",
    "\n",
    "df_proteam_schedules = pd.DataFrame(data=[], index=wk_ls , columns = pro_team_ls)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in pro_team_ls:\n",
    "    proteam_schedule = Schedule(i)\n",
    "    \n",
    "    for game in proteam_schedule:\n",
    "        game_time = game.datetime.date()\n",
    "        wk = game.week\n",
    "        \n",
    "        df_proteam_schedules.loc[wk,i] = game_time\n",
    "        \n",
    "df_proteam_schedules.fillna('BYE',inplace=True)\n",
    "\n",
    "df_proteam_schedules.rename(columns = conv_dict , inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "NFL team schedules with rows representing NFL Week and columns representing NFL Team"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "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>ARI</th>\n",
       "      <th>ATL</th>\n",
       "      <th>BAL</th>\n",
       "      <th>BUF</th>\n",
       "      <th>CAR</th>\n",
       "      <th>CHI</th>\n",
       "      <th>CIN</th>\n",
       "      <th>CLE</th>\n",
       "      <th>DAL</th>\n",
       "      <th>DEN</th>\n",
       "      <th>...</th>\n",
       "      <th>NO</th>\n",
       "      <th>NYG</th>\n",
       "      <th>NYJ</th>\n",
       "      <th>PHI</th>\n",
       "      <th>PIT</th>\n",
       "      <th>SF</th>\n",
       "      <th>SEA</th>\n",
       "      <th>TB</th>\n",
       "      <th>TEN</th>\n",
       "      <th>WSH</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-13</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-09</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-09</td>\n",
       "      <td>2021-09-12</td>\n",
       "      <td>2021-09-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-16</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-19</td>\n",
       "      <td>2021-09-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-23</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-27</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-27</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-26</td>\n",
       "      <td>2021-09-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-09-30</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "      <td>2021-10-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-11</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>...</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-07</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-10</td>\n",
       "      <td>2021-10-10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          ARI         ATL         BAL         BUF         CAR         CHI  \\\n",
       "1  2021-09-12  2021-09-12  2021-09-13  2021-09-12  2021-09-12  2021-09-12   \n",
       "2  2021-09-19  2021-09-19  2021-09-19  2021-09-19  2021-09-19  2021-09-19   \n",
       "3  2021-09-26  2021-09-26  2021-09-26  2021-09-26  2021-09-23  2021-09-26   \n",
       "4  2021-10-03  2021-10-03  2021-10-03  2021-10-03  2021-10-03  2021-10-03   \n",
       "5  2021-10-10  2021-10-10  2021-10-11  2021-10-10  2021-10-10  2021-10-10   \n",
       "\n",
       "          CIN         CLE         DAL         DEN  ...          NO  \\\n",
       "1  2021-09-12  2021-09-12  2021-09-09  2021-09-12  ...  2021-09-12   \n",
       "2  2021-09-19  2021-09-19  2021-09-19  2021-09-19  ...  2021-09-19   \n",
       "3  2021-09-26  2021-09-26  2021-09-27  2021-09-26  ...  2021-09-26   \n",
       "4  2021-09-30  2021-10-03  2021-10-03  2021-10-03  ...  2021-10-03   \n",
       "5  2021-10-10  2021-10-10  2021-10-10  2021-10-10  ...  2021-10-10   \n",
       "\n",
       "          NYG         NYJ         PHI         PIT          SF         SEA  \\\n",
       "1  2021-09-12  2021-09-12  2021-09-12  2021-09-12  2021-09-12  2021-09-12   \n",
       "2  2021-09-16  2021-09-19  2021-09-19  2021-09-19  2021-09-19  2021-09-19   \n",
       "3  2021-09-26  2021-09-26  2021-09-27  2021-09-26  2021-09-26  2021-09-26   \n",
       "4  2021-10-03  2021-10-03  2021-10-03  2021-10-03  2021-10-03  2021-10-03   \n",
       "5  2021-10-10  2021-10-10  2021-10-10  2021-10-10  2021-10-10  2021-10-07   \n",
       "\n",
       "           TB         TEN         WSH  \n",
       "1  2021-09-09  2021-09-12  2021-09-12  \n",
       "2  2021-09-19  2021-09-19  2021-09-16  \n",
       "3  2021-09-26  2021-09-26  2021-09-26  \n",
       "4  2021-10-03  2021-10-03  2021-10-03  \n",
       "5  2021-10-10  2021-10-10  2021-10-10  \n",
       "\n",
       "[5 rows x 32 columns]"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_proteam_schedules.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [],
   "source": [
    "season_start_date = pd.melt(df_proteam_schedules)[~pd.melt(df_proteam_schedules)['value'].isin(['BYE'])]['value'].min()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Import data from ESPN Fantasy Football"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [],
   "source": [
    "league_id = 1\n",
    "year = year_of_interest # e.g. 2021\n",
    "SWID=\"\"\n",
    "\n",
    "s2=\"\"\n",
    "\n",
    "league = League(league_id=league_id, year=year, espn_s2=s2, swid=SWID)\n",
    "\n",
    "# arbitarily pass in a large number to get all recent activity\n",
    "activity_ls = league.recent_activity(1000)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Build Acquisitions Dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [],
   "source": [
    "import datetime\n",
    "\n",
    "# Function handling trade data\n",
    "\n",
    "def get_trade_data(j):\n",
    "    \"Function for parsing Recent Activities trade data into ADD and DROP events\"\n",
    "    \n",
    "    acq_data_ls = []\n",
    "\n",
    "    date1 = j.date\n",
    "\n",
    "    team_transaction_ls = []\n",
    "    \n",
    "    for k in j.actions:\n",
    "        (team1, action1, _ , _ ) = k\n",
    "        team_id = team1.team_name\n",
    "        team_transaction_ls.append(team_id)\n",
    "\n",
    "        # determine if trade or waiver acquisition type\n",
    "\n",
    "    # establish other team involved in trade\n",
    "    teams_in_trade = list(set(team_transaction_ls))\n",
    "\n",
    "    for k in j.actions:\n",
    "        (team1, action1, player_name, bid_amount) = k\n",
    "        team_id = team1.team_name\n",
    "\n",
    "        if teams_in_trade.index(team_id) == 1:\n",
    "            team_id_received = teams_in_trade[0]\n",
    "        else:\n",
    "            team_id_received = teams_in_trade[1]\n",
    "\n",
    "        # Build new tuple for TRADE ADDED\n",
    "        player_id = player_name.name\n",
    "        ProTeam = player_name.proTeam\n",
    "        action1 = 'TRADE ADDED'\n",
    "\n",
    "        # Build a second tuple for TRADE DROPPED\n",
    "        action2 = 'TRADE DROPPED'\n",
    "\n",
    "        acq_data1 = (date1 , player_id , ProTeam , team_id_received , action1, bid_amount)\n",
    "        drop_data1 = (date1 , player_id , ProTeam , team_id , action2, bid_amount)\n",
    "\n",
    "        acq_data_ls.append(acq_data1)\n",
    "        acq_data_ls.append(drop_data1)\n",
    "        \n",
    "    return acq_data_ls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function handling waiver data\n",
    "def get_waiver_data(j):\n",
    "    \n",
    "    waiver_data_ls = []\n",
    "\n",
    "    for k in j.actions:\n",
    "        (team1, action1, player_name, bid_amount) = k\n",
    "        team_id = team1.team_name\n",
    "        player_id = player_name.name\n",
    "        ProTeam = player_name.proTeam\n",
    "        \n",
    "        waiver_data1 = (date1 , player_id , ProTeam , team_id , action1 , bid_amount)\n",
    "        waiver_data_ls.append(waiver_data1)\n",
    "        \n",
    "    return waiver_data_ls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {},
   "outputs": [],
   "source": [
    "def flatten_list(_2d_list):\n",
    "    flat_list = []\n",
    "    # Iterate through the outer list\n",
    "    for element in _2d_list:\n",
    "        if type(element) is list:\n",
    "            # If the element is of type list, iterate through the sublist\n",
    "            for item in element:\n",
    "                flat_list.append(item)\n",
    "        else:\n",
    "            flat_list.append(element)\n",
    "    return flat_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Loop thru Recent Activities data, creating a DataFrame for all acquisitions\n",
    "# Conditional for trade or waiver acquisitions\n",
    "\n",
    "acq_data_ls = []\n",
    "\n",
    "# loop through each activity item\n",
    "for idx, j in enumerate(activity_ls):\n",
    "    date1 = j.date\n",
    "    team_transaction_ls = []\n",
    "    for k in j.actions:\n",
    "        (team1, action1, _ , _ ) = k\n",
    "        team_id = team1.team_name\n",
    "        team_transaction_ls.append(team_id)\n",
    "        \n",
    "        # determine if trade or waiver acquisition type        \n",
    "        ls = []\n",
    "        \n",
    "        if action1 == 'TRADED':\n",
    "            ls = get_trade_data(j)\n",
    "\n",
    "        else:\n",
    "            ls = get_waiver_data(j)\n",
    "\n",
    "    acq_data_ls.append(ls)\n",
    "      \n",
    "\n",
    "acq_data_flat_ls = flatten_list(acq_data_ls)\n",
    "\n",
    "df_acq = pd.DataFrame(acq_data_flat_ls)\n",
    "\n",
    "df_acq.columns = ['Timestamp','Player','ProTeam','Team','Action','Bid Amount ($)']\n",
    "\n",
    "# converts from milliseconds to date\n",
    "def convert_to_date(date1):\n",
    "    d2=datetime.date.fromtimestamp(date1 / 1000.0)\n",
    "    return d2\n",
    "\n",
    "df_acq['Action Timestamp'] = df_acq['Timestamp'].apply(lambda x : convert_to_date(x))\n",
    "\n",
    "df_acq = df_acq.sort_values(by=['Timestamp'],ascending=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp</th>\n",
       "      <th>Player</th>\n",
       "      <th>ProTeam</th>\n",
       "      <th>Team</th>\n",
       "      <th>Action</th>\n",
       "      <th>Bid Amount ($)</th>\n",
       "      <th>Action Timestamp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>598</th>\n",
       "      <td>1631199616099</td>\n",
       "      <td>Dolphins D/ST</td>\n",
       "      <td>MIA</td>\n",
       "      <td>Ice City USA</td>\n",
       "      <td>DROPPED</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-09-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>590</th>\n",
       "      <td>1631199616099</td>\n",
       "      <td>Rodrigo Blankenship</td>\n",
       "      <td>IND</td>\n",
       "      <td>Fumble .</td>\n",
       "      <td>DROPPED</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-09-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>591</th>\n",
       "      <td>1631199616099</td>\n",
       "      <td>T.Y. Hilton</td>\n",
       "      <td>IND</td>\n",
       "      <td>Fumble .</td>\n",
       "      <td>WAIVER ADDED</td>\n",
       "      <td>1</td>\n",
       "      <td>2021-09-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>592</th>\n",
       "      <td>1631199616099</td>\n",
       "      <td>Deshaun Watson</td>\n",
       "      <td>HOU</td>\n",
       "      <td>Frankel's Cankles</td>\n",
       "      <td>DROPPED</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-09-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>597</th>\n",
       "      <td>1631199616099</td>\n",
       "      <td>Vikings D/ST</td>\n",
       "      <td>MIN</td>\n",
       "      <td>Ice City USA</td>\n",
       "      <td>WAIVER ADDED</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-09-09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Timestamp               Player ProTeam               Team  \\\n",
       "598  1631199616099        Dolphins D/ST     MIA       Ice City USA   \n",
       "590  1631199616099  Rodrigo Blankenship     IND           Fumble .   \n",
       "591  1631199616099          T.Y. Hilton     IND           Fumble .   \n",
       "592  1631199616099       Deshaun Watson     HOU  Frankel's Cankles   \n",
       "597  1631199616099         Vikings D/ST     MIN       Ice City USA   \n",
       "\n",
       "           Action  Bid Amount ($) Action Timestamp  \n",
       "598       DROPPED               0       2021-09-09  \n",
       "590       DROPPED               0       2021-09-09  \n",
       "591  WAIVER ADDED               1       2021-09-09  \n",
       "592       DROPPED               0       2021-09-09  \n",
       "597  WAIVER ADDED               0       2021-09-09  "
      ]
     },
     "execution_count": 118,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_acq.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get Draft Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "metadata": {},
   "outputs": [],
   "source": [
    "draft_ls = []\n",
    "\n",
    "for i in league.draft:    \n",
    "    team_id = i.team.team_name\n",
    "    player_id = i.playerName\n",
    "    bid_amount = i.bid_amount\n",
    "    action = 'DRAFT ADDED'\n",
    "    draft_ls.append((player_id, team_id,action,bid_amount))\n",
    "\n",
    "df_draft = pd.DataFrame(draft_ls)\n",
    "  \n",
    "df_draft.columns = ['Player', 'Acquired by' , 'Action' , 'Bid Amount ($)']\n",
    "\n",
    "df_draft.set_index('Player',inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get total points of rostered players Dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Get data of all currently fantasy league rostered players"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {},
   "outputs": [],
   "source": [
    "rostered_players_ls = []\n",
    "for i in league.teams:\n",
    "    team_name = i.team_name\n",
    "    for player in i.roster:\n",
    "        player_name = player.name\n",
    "        player_pos = player.position\n",
    "        player_pro_team = player.proTeam\n",
    "        player_total_pts = player.total_points\n",
    "        player_tup = (player_name , player_pos, player_pro_team, player_total_pts , team_name)\n",
    "        rostered_players_ls.append(player_tup)\n",
    "\n",
    "df_rostered = pd.DataFrame(rostered_players_ls)\n",
    "col_ls = ['Player' , 'Position' , 'Pro Team', 'Total points', 'Current Team']\n",
    "df_rostered.columns = col_ls\n",
    "\n",
    "df_rostered.set_index('Player',inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get total points of free agent players Dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "metadata": {},
   "outputs": [],
   "source": [
    "from datetime import datetime\n",
    "\n",
    "free_agent_ls = league.free_agents(size=1000)\n",
    "\n",
    "FA_players_ls = []\n",
    "name_ls = []\n",
    "for i in free_agent_ls:\n",
    "    team_name = 'Free agent'\n",
    "    player_name = i.name\n",
    "    player_pos = i.position\n",
    "    player_pro_team = i.proTeam\n",
    "    player_total_pts = i.total_points\n",
    "\n",
    "    player_tup = (player_name , player_pos, player_pro_team, player_total_pts , team_name)\n",
    "    FA_players_ls.append(player_tup)\n",
    "    \n",
    "    name_ls.append(player_name)\n",
    "\n",
    "\n",
    "df_FA = pd.DataFrame(FA_players_ls)\n",
    "col_ls = ['Player' , 'Position' , 'Pro Team', 'Total points', 'Current Team']\n",
    "df_FA.columns=col_ls\n",
    "df_FA.set_index('Player',inplace=True)\n",
    "\n",
    "# Generate all player stats dataframe, including all Free Agents\n",
    "df_player_stats = pd.concat([df_rostered,df_FA],axis=0)\n",
    "\n",
    "df_draft_acq = df_draft.join(df_player_stats)\n",
    "\n",
    "df_draft_acq['Player'] = df_draft_acq.index\n",
    "\n",
    "col_new = ['Player' , 'Pro Team' , 'Acquired by' , 'Action' , 'Bid Amount ($)']\n",
    "\n",
    "df_draft_acq = df_draft_acq[col_new]\n",
    "\n",
    "df_draft_acq.rename(columns = {'Pro Team' : 'ProTeam' , 'Acquired by' : 'Team'} , inplace = True)\n",
    "\n",
    "\n",
    "# Establish Draft Date\n",
    "# Draft Date just needs to be before the first game of the season, \n",
    "# By default, we set this arbitrarily as one day before the first game of the NFL season\n",
    "\n",
    "draft_date1 = season_start_date - timedelta(days=1)\n",
    "\n",
    "draft_date_str = draft_date1.strftime('%d %b %Y')\n",
    "\n",
    "draft_date = datetime.strptime(draft_date_str, '%d %b %Y').date()\n",
    "\n",
    "draft_date_ms = int(datetime.strptime(draft_date_str, '%d %b %Y').timestamp() * 1000)\n",
    "\n",
    "df_draft_acq['Action Timestamp'] = draft_date\n",
    "\n",
    "df_draft_acq['Timestamp'] = draft_date_ms\n",
    "\n",
    "df_acq_final = pd.concat([df_draft_acq , df_acq] , axis=0)\n",
    "\n",
    "df_acq_final.reset_index(inplace=True)\n",
    "\n",
    "df_acq_final.drop('index' , inplace=True ,axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "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>Position</th>\n",
       "      <th>Pro Team</th>\n",
       "      <th>Total points</th>\n",
       "      <th>Current Team</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Player</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Austin Ekeler</th>\n",
       "      <td>RB</td>\n",
       "      <td>LAC</td>\n",
       "      <td>308.8</td>\n",
       "      <td>Don't Ekele Me</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>George Kittle</th>\n",
       "      <td>TE</td>\n",
       "      <td>SF</td>\n",
       "      <td>162.5</td>\n",
       "      <td>Don't Ekele Me</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Diontae Johnson</th>\n",
       "      <td>WR</td>\n",
       "      <td>PIT</td>\n",
       "      <td>220.9</td>\n",
       "      <td>Don't Ekele Me</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Josh Allen</th>\n",
       "      <td>QB</td>\n",
       "      <td>BUF</td>\n",
       "      <td>401.1</td>\n",
       "      <td>Don't Ekele Me</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Brandin Cooks</th>\n",
       "      <td>WR</td>\n",
       "      <td>HOU</td>\n",
       "      <td>186.8</td>\n",
       "      <td>Don't Ekele Me</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Position Pro Team  Total points    Current Team\n",
       "Player                                                         \n",
       "Austin Ekeler         RB      LAC         308.8  Don't Ekele Me\n",
       "George Kittle         TE       SF         162.5  Don't Ekele Me\n",
       "Diontae Johnson       WR      PIT         220.9  Don't Ekele Me\n",
       "Josh Allen            QB      BUF         401.1  Don't Ekele Me\n",
       "Brandin Cooks         WR      HOU         186.8  Don't Ekele Me"
      ]
     },
     "execution_count": 123,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_player_stats.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "metadata": {},
   "outputs": [],
   "source": [
    "# For now, drop players who were rostered, but are not on a ProTeam currently, example: 'Henry Ruggs'\n",
    "# There can be a next feature to handle these exceptions\n",
    "\n",
    "df_acq_final1 = df_acq_final[~(df_acq_final['ProTeam'] == 'None')]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get player points from every week's matchup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "metadata": {},
   "outputs": [],
   "source": [
    "# league object has attribue current week, this will always update from the ESPN API\n",
    "\n",
    "current_week = league.current_week\n",
    "\n",
    "# construct a reverse dictionary to map to box_score index\n",
    "wk_ls = [i+1 for i in range(current_week)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Retrieve data on all players on all weeks played from box_scores class\n",
    "\n",
    "df_player_box_scores = pd.DataFrame(data=[], columns = ['Player' , 'Position' , 'Week' , 'Team' , 'Total points'])\n",
    "\n",
    "# initiate counter\n",
    "n = 0\n",
    "\n",
    "for wk in wk_ls:\n",
    "    for matchup in league.box_scores(wk):\n",
    "        if matchup.away_team == 0:\n",
    "            team_name_q = matchup.home_team.team_name\n",
    "            for q in matchup.home_lineup:\n",
    "                n += 1\n",
    "                df_player_box_scores.loc[n,'Player'] = q.name\n",
    "                df_player_box_scores.loc[n,'Position'] = q.position\n",
    "                df_player_box_scores.loc[n,'Week'] = wk\n",
    "                df_player_box_scores.loc[n,'Team'] = team_name_q\n",
    "                df_player_box_scores.loc[n,'Total points'] = q.points\n",
    "                \n",
    "        else:       \n",
    "            team_name_p = matchup.away_team.team_name\n",
    "            team_name_q = matchup.home_team.team_name\n",
    "\n",
    "            for p in matchup.away_lineup:\n",
    "                n += 1\n",
    "                df_player_box_scores.loc[n,'Player'] = p.name\n",
    "                df_player_box_scores.loc[n,'Position'] = p.position\n",
    "                df_player_box_scores.loc[n,'Week'] = wk\n",
    "                df_player_box_scores.loc[n,'Team'] = team_name_p\n",
    "                df_player_box_scores.loc[n,'Total points'] = p.points\n",
    "\n",
    "            for q in matchup.home_lineup:\n",
    "                n += 1\n",
    "                df_player_box_scores.loc[n,'Player'] = q.name\n",
    "                df_player_box_scores.loc[n,'Position'] = q.position\n",
    "                df_player_box_scores.loc[n,'Week'] = wk\n",
    "                df_player_box_scores.loc[n,'Team'] = team_name_q\n",
    "                df_player_box_scores.loc[n,'Total points'] = q.points\n",
    "            "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "metadata": {},
   "outputs": [],
   "source": [
    "# df_player_box_scores is a Dataframe of each player's score from each Week  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 128,
   "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>Player</th>\n",
       "      <th>Position</th>\n",
       "      <th>Week</th>\n",
       "      <th>Team</th>\n",
       "      <th>Total points</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Christian McCaffrey</td>\n",
       "      <td>RB</td>\n",
       "      <td>1</td>\n",
       "      <td>Tasteful Dak Piks, by CMC</td>\n",
       "      <td>23.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Davante Adams</td>\n",
       "      <td>WR</td>\n",
       "      <td>1</td>\n",
       "      <td>Tasteful Dak Piks, by CMC</td>\n",
       "      <td>8.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Justin Jefferson</td>\n",
       "      <td>WR</td>\n",
       "      <td>1</td>\n",
       "      <td>Tasteful Dak Piks, by CMC</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Steelers D/ST</td>\n",
       "      <td>D/ST</td>\n",
       "      <td>1</td>\n",
       "      <td>Tasteful Dak Piks, by CMC</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Dak Prescott</td>\n",
       "      <td>QB</td>\n",
       "      <td>1</td>\n",
       "      <td>Tasteful Dak Piks, by CMC</td>\n",
       "      <td>29.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Player Position Week                       Team Total points\n",
       "1  Christian McCaffrey       RB    1  Tasteful Dak Piks, by CMC         23.2\n",
       "2        Davante Adams       WR    1  Tasteful Dak Piks, by CMC          8.1\n",
       "3     Justin Jefferson       WR    1  Tasteful Dak Piks, by CMC         10.0\n",
       "4        Steelers D/ST     D/ST    1  Tasteful Dak Piks, by CMC         13.0\n",
       "5         Dak Prescott       QB    1  Tasteful Dak Piks, by CMC         29.3"
      ]
     },
     "execution_count": 128,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_player_box_scores.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Map acquisition data to NFL schedule info, create Stints Dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_stint_info(proteam, df_test_acq , df_proteam_schedules_one_team , n , idx , is_current):\n",
    "    \n",
    "    # get start and end dates d1 and d2          \n",
    "    d1 = df_test_acq.loc[idx , 'Action Timestamp']\n",
    "    action1 = df_test_acq.loc[idx ,'Action']\n",
    "    \n",
    "    # If player is currently on a fantasy team\n",
    "    if is_current:\n",
    "        d2 = date.today()\n",
    "    else:\n",
    "        d2 = df_test_acq.loc[idx+1 , 'Action Timestamp']\n",
    "        \n",
    "    bid_amount = df_test_acq.loc[idx , 'Bid Amount ($)']\n",
    "\n",
    "    weeks_bool = (df_proteam_schedules_one_team['Game Date'] >= d1) & (df_proteam_schedules_one_team['Game Date'] < d2)\n",
    "    stint_wks_ls = df_proteam_schedules_one_team[weeks_bool]['Week'].tolist()  \n",
    "\n",
    "\n",
    "    df_stints.loc[n ,'Stint (wks)' ] = stint_wks_ls\n",
    "\n",
    "    df_stints.loc[n , 'Player'] = player_test\n",
    "\n",
    "    df_stints.loc[n , 'ProTeam'] = proteam\n",
    "    df_stints.loc[n , 'Team'] = df_test_acq.loc[idx , 'Team']\n",
    "    df_stints.loc[n, 'Action'] = action1.split(' ')[0]\n",
    "    df_stints.loc[n , 'Bid Amount ($)'] = bid_amount\n",
    "    \n",
    "    return df_stints\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {},
   "outputs": [],
   "source": [
    "# define get_df_stints\n",
    "\n",
    "def get_df_stints(player_test , df_acq_final):\n",
    "    df_test_acq = df_acq_final[df_acq_final['Player'] == player_test]\n",
    "\n",
    "    df_test_acq.reset_index(inplace=True)\n",
    "\n",
    "    df_test_acq.index.name = 'ordered_index'\n",
    "    \n",
    "    proteam = df_test_acq.loc[0,'ProTeam']\n",
    "\n",
    "    # import datetime\n",
    "    # Convert microseconds to date\n",
    "\n",
    "    df_proteam_schedules_one_team = pd.DataFrame(data=df_proteam_schedules.loc[:,proteam])\n",
    "\n",
    "    df_proteam_schedules_one_team['Week'] = df_proteam_schedules_one_team.index\n",
    "\n",
    "    df_proteam_schedules_one_team.rename(columns = {proteam:'Game Date'} , inplace=True)\n",
    "\n",
    "    df_proteam_schedules_one_team = df_proteam_schedules_one_team[df_proteam_schedules_one_team['Game Date'] != 'BYE']\n",
    "\n",
    "    cols = ['Player' , 'ProTeam' , 'Team' , 'Action' , 'Bid Amount ($)' , 'Stint (wks)']\n",
    "\n",
    "    df_stints = pd.DataFrame(data=[] , columns = cols)\n",
    "\n",
    "    max_idx = df_test_acq.index[-1]\n",
    "\n",
    "    n = 0\n",
    "\n",
    "    for idx , row in df_test_acq.iterrows():\n",
    "\n",
    "        if idx < max_idx:\n",
    "            cond_1 = 'ADDED' in df_test_acq.loc[idx , 'Action']\n",
    "            cond_2 = 'DROPPED' in df_test_acq.loc[idx+1 , 'Action']\n",
    "\n",
    "            if cond_1 and cond_2:\n",
    "\n",
    "                n += 1            \n",
    "                df_stints = get_stint_info(proteam, df_test_acq , df_proteam_schedules_one_team , n , idx, \n",
    "                                          is_current = False)\n",
    "\n",
    "    # in case if the player is still on a team, get current stint:\n",
    "    if 'ADDED' in df_test_acq.loc[max_idx , 'Action']:\n",
    "        n = n+1\n",
    "        df_stints = get_stint_info(proteam, df_test_acq , df_proteam_schedules_one_team , n , max_idx, \n",
    "                                          is_current = True)\n",
    "        \n",
    "    return df_stints"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Player', 'ProTeam', 'Team', 'Action', 'Bid Amount ($)',\n",
       "       'Action Timestamp', 'Timestamp'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_acq_final1.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('int64')"
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_acq_final1['Timestamp'].dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "metadata": {},
   "outputs": [],
   "source": [
    "# get all players who have been involved in the fantasy league\n",
    "import datetime\n",
    "# from datetime import date\n",
    "\n",
    "\n",
    "df_ls = []\n",
    "all_player_ls = list(set(df_acq_final1['Player'].tolist()))\n",
    "\n",
    "cols = ['Player' , 'ProTeam' , 'Team' , 'Action' , 'Bid Amount ($)' , 'Stint (wks)']\n",
    "\n",
    "for player_test in all_player_ls:\n",
    "    df_stints = pd.DataFrame(data=[] , columns = cols)\n",
    "    df_stints = get_df_stints(player_test , df_acq_final1)\n",
    "    df_ls.append(df_stints)\n",
    "    \n",
    "df_stints_f = pd.concat(df_ls,axis=0)\n",
    "\n",
    "df_stints_f.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "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>index</th>\n",
       "      <th>Player</th>\n",
       "      <th>ProTeam</th>\n",
       "      <th>Team</th>\n",
       "      <th>Action</th>\n",
       "      <th>Bid Amount ($)</th>\n",
       "      <th>Stint (wks)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Christian Kirk</td>\n",
       "      <td>ARI</td>\n",
       "      <td>Repeat Donger</td>\n",
       "      <td>WAIVER</td>\n",
       "      <td>3</td>\n",
       "      <td>[7, 8, 9]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Christian Kirk</td>\n",
       "      <td>ARI</td>\n",
       "      <td>Frankel's Cankles</td>\n",
       "      <td>WAIVER</td>\n",
       "      <td>1</td>\n",
       "      <td>[11, 13]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Christian Kirk</td>\n",
       "      <td>ARI</td>\n",
       "      <td>Tier 2 never felt so good</td>\n",
       "      <td>WAIVER</td>\n",
       "      <td>7</td>\n",
       "      <td>[16, 17, 18, 19]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>Russell Wilson</td>\n",
       "      <td>SEA</td>\n",
       "      <td>Repeat Donger</td>\n",
       "      <td>DRAFT</td>\n",
       "      <td>4</td>\n",
       "      <td>[1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>Zach Ertz</td>\n",
       "      <td>ARI</td>\n",
       "      <td>Tasteful Dak Piks, by CMC</td>\n",
       "      <td>WAIVER</td>\n",
       "      <td>3</td>\n",
       "      <td>[7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index          Player ProTeam                       Team  Action  \\\n",
       "0      1  Christian Kirk     ARI              Repeat Donger  WAIVER   \n",
       "1      2  Christian Kirk     ARI          Frankel's Cankles  WAIVER   \n",
       "2      3  Christian Kirk     ARI  Tier 2 never felt so good  WAIVER   \n",
       "3      1  Russell Wilson     SEA              Repeat Donger   DRAFT   \n",
       "4      1       Zach Ertz     ARI  Tasteful Dak Piks, by CMC  WAIVER   \n",
       "\n",
       "  Bid Amount ($)                                        Stint (wks)  \n",
       "0              3                                          [7, 8, 9]  \n",
       "1              1                                           [11, 13]  \n",
       "2              7                                   [16, 17, 18, 19]  \n",
       "3              4  [1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 1...  \n",
       "4              3      [7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19]  "
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_stints_f.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Get total fantasy points scored into Stints Dataframe "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Build position dict:\n",
    "# Dictionary of all players' positions\n",
    "ls1 = df_player_stats.index.tolist()\n",
    "ls2 = df_player_stats['Position'].tolist()\n",
    "\n",
    "position_dict = dict(zip(ls1,ls2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_stints_f['Position'] = df_stints_f['Player'].map(position_dict)\n",
    "\n",
    "for idx, row in df_stints_f.iterrows():\n",
    "    player_test = row['Player']\n",
    "    stint_wk_ls = row['Stint (wks)']\n",
    "    \n",
    "    cond_a = df_player_box_scores['Player'] == player_test\n",
    "\n",
    "    # if not an empty list\n",
    "    if stint_wk_ls:\n",
    "        cond_b = df_player_box_scores['Week'].isin(stint_wk_ls)\n",
    "\n",
    "        df_player_box_scores[cond_a & cond_b]['Total points'].sum()\n",
    "        df_stints_f.loc[idx,'Total points'] = df_player_box_scores[cond_a & cond_b]['Total points'].sum()\n",
    "        \n",
    "    else:\n",
    "        df_stints_f.loc[idx,'Total points'] = 0\n",
    "\n",
    "df_stints_f = df_stints_f.sort_values(by=['Total points'],ascending=False)\n",
    "\n",
    "df_stints_f.reset_index(inplace=True)\n",
    "\n",
    "df_stints_f= df_stints_f[['Player','Position','Team','ProTeam','Action','Bid Amount ($)', 'Stint (wks)', 'Total points']]\n",
    "\n",
    "df_stints_f.index.name = 'Stint'\n",
    "\n",
    "df_stints_f['Total points'] = df_stints_f['Total points'].round(1)\n",
    "\n",
    "df_stints_f['Player-info'] = df_stints_f['Player'] + ', ' + df_stints_f['Position'] + ' (' + df_stints_f['ProTeam'] + ')'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "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>Player</th>\n",
       "      <th>Position</th>\n",
       "      <th>Team</th>\n",
       "      <th>ProTeam</th>\n",
       "      <th>Action</th>\n",
       "      <th>Bid Amount ($)</th>\n",
       "      <th>Stint (wks)</th>\n",
       "      <th>Total points</th>\n",
       "      <th>Player-info</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Stint</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Josh Allen</td>\n",
       "      <td>QB</td>\n",
       "      <td>Don't Ekele Me</td>\n",
       "      <td>BUF</td>\n",
       "      <td>DRAFT</td>\n",
       "      <td>13</td>\n",
       "      <td>[1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 1...</td>\n",
       "      <td>377.4</td>\n",
       "      <td>Josh Allen, QB (BUF)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Tom Brady</td>\n",
       "      <td>QB</td>\n",
       "      <td>Fumble .</td>\n",
       "      <td>TB</td>\n",
       "      <td>DRAFT</td>\n",
       "      <td>1</td>\n",
       "      <td>[1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 1...</td>\n",
       "      <td>354.5</td>\n",
       "      <td>Tom Brady, QB (TB)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Justin Herbert</td>\n",
       "      <td>QB</td>\n",
       "      <td>Frankel's Cankles</td>\n",
       "      <td>LAC</td>\n",
       "      <td>DRAFT</td>\n",
       "      <td>3</td>\n",
       "      <td>[1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 1...</td>\n",
       "      <td>352.3</td>\n",
       "      <td>Justin Herbert, QB (LAC)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Cooper Kupp</td>\n",
       "      <td>WR</td>\n",
       "      <td>Fumble .</td>\n",
       "      <td>LAR</td>\n",
       "      <td>DRAFT</td>\n",
       "      <td>29</td>\n",
       "      <td>[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15...</td>\n",
       "      <td>343.9</td>\n",
       "      <td>Cooper Kupp, WR (LAR)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jonathan Taylor</td>\n",
       "      <td>RB</td>\n",
       "      <td>Godwin's Memorial</td>\n",
       "      <td>IND</td>\n",
       "      <td>DRAFT</td>\n",
       "      <td>58</td>\n",
       "      <td>[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15...</td>\n",
       "      <td>342.1</td>\n",
       "      <td>Jonathan Taylor, RB (IND)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Player Position               Team ProTeam Action  \\\n",
       "Stint                                                               \n",
       "0           Josh Allen       QB     Don't Ekele Me     BUF  DRAFT   \n",
       "1            Tom Brady       QB           Fumble .      TB  DRAFT   \n",
       "2       Justin Herbert       QB  Frankel's Cankles     LAC  DRAFT   \n",
       "3          Cooper Kupp       WR           Fumble .     LAR  DRAFT   \n",
       "4      Jonathan Taylor       RB  Godwin's Memorial     IND  DRAFT   \n",
       "\n",
       "      Bid Amount ($)                                        Stint (wks)  \\\n",
       "Stint                                                                     \n",
       "0                 13  [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 1...   \n",
       "1                  1  [1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 1...   \n",
       "2                  3  [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 1...   \n",
       "3                 29  [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15...   \n",
       "4                 58  [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15...   \n",
       "\n",
       "       Total points                Player-info  \n",
       "Stint                                           \n",
       "0             377.4       Josh Allen, QB (BUF)  \n",
       "1             354.5         Tom Brady, QB (TB)  \n",
       "2             352.3   Justin Herbert, QB (LAC)  \n",
       "3             343.9      Cooper Kupp, WR (LAR)  \n",
       "4             342.1  Jonathan Taylor, RB (IND)  "
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_stints_f.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Apply team alias:\n",
    "\n",
    "# Create alias team name\n",
    "team_name_ls = [i[1].team_name for i in league.power_rankings()]\n",
    "team_name_ls.sort()\n",
    "team_name_alias_ls = [('Team'+str(i+1)) for i in range(len(team_name_ls))]\n",
    "team_name_alias_dict = dict(zip(team_name_ls,team_name_alias_ls))\n",
    "\n",
    "df_stints_f['Team'] = df_stints_f['Team'].map(team_name_alias_dict)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Scatterplots"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Filter for stints >= 3\n",
    "def get_bool_len(x):\n",
    "    z = len(x) >= 2\n",
    "    return z"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_stints_f_draft = df_stints_f[df_stints_f['Action'] == 'DRAFT']\n",
    "df_stints_f_draft = df_stints_f_draft.sort_values(by = ['Bid Amount ($)'],ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {},
   "outputs": [],
   "source": [
    "def generate_acquisitions_scatterplot(df , position_subset , acquisition_method):\n",
    "    \n",
    "    position_subset1 = ''.join(position_subset)\n",
    "    plot_title = position_subset1 + ' ' + acquisition_method + ' Spending vs. Total Fantasy Points'\n",
    "\n",
    "    selection = alt.selection_multi(fields=['Team'], bind = 'legend')\n",
    "    \n",
    "    color = alt.condition(selection, \n",
    "                        alt.Color('Team:N', \n",
    "                        scale=alt.Scale(scheme='tableau20'), sort=team_name_alias_ls), alt.value('lightgray'))\n",
    "\n",
    "    chart = alt.Chart(df).mark_circle(size=40).encode(\n",
    "        alt.X('Bid Amount ($)', axis=alt.Axis(grid=False)),\n",
    "        alt.Y('Total points' , axis=alt.Axis(grid=False)),\n",
    "        color=color,\n",
    "        opacity=alt.condition(selection, alt.value(1), alt.value(0.1)),\n",
    "        tooltip=['Player-info','Team','Bid Amount ($)','Total points','Stint (wks)']\n",
    "        ).add_selection(selection).properties(\n",
    "        width=450,\n",
    "        height=450,\n",
    "        title = plot_title\n",
    "        ).configure_axis(\n",
    "        labelFontSize=18,\n",
    "        titleFontSize=18\n",
    "        ).configure_title(fontSize=20).configure_legend(labelFontSize=14, titleFontSize=14)\n",
    "    \n",
    "    return chart"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Draft Scatterplots"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {},
   "outputs": [],
   "source": [
    "acquisition_method = 'Draft'\n",
    "\n",
    "position_subset = ['RB','WR','TE']\n",
    "\n",
    "df = df_stints_f_draft[df_stints_f_draft['Position'].isin(position_subset)]\n",
    "\n",
    "chart = generate_acquisitions_scatterplot(df , ' '.join(position_subset) , acquisition_method)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This is a scatterplot of Draft Auction Spending (x-axis) versus Total (Fantasy) Points (y-axis) on the whole 17 week season. Players in the upper left of the plot represent low cost, high value \"draft steals\", and players in the lower right of the plot represent high cost, low value \"busts\".\n",
    "\n",
    "Hover your cursor over the datapoint to learn more about the player, who drafted them, at what price, and their stint on the respective team that drafted them. The stint is the specific weeks in which the player was rostered on the fantasy team, but not necessarily started.\n",
    "\n",
    "Looking at the upper left part of the scatterplot, we see that Cooper Kupp, Ja'Marr Chase, and Leonard Fournette were huge steals in the draft. The biggest busts were Christian McCaffrey and Saquon Barkley."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-baa7fb7098fc45768d476920fc4a0766\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-baa7fb7098fc45768d476920fc4a0766\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-baa7fb7098fc45768d476920fc4a0766\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.8.1?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function loadScript(lib) {\n",
       "      return new Promise(function(resolve, reject) {\n",
       "        var s = document.createElement('script');\n",
       "        s.src = paths[lib];\n",
       "        s.async = true;\n",
       "        s.onload = () => resolve(paths[lib]);\n",
       "        s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "        document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "      });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else if (typeof vegaEmbed === \"function\") {\n",
       "      displayChart(vegaEmbed);\n",
       "    } else {\n",
       "      loadScript(\"vega\")\n",
       "        .then(() => loadScript(\"vega-lite\"))\n",
       "        .then(() => loadScript(\"vega-embed\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300}, \"axis\": {\"labelFontSize\": 18, \"titleFontSize\": 18}, \"legend\": {\"labelFontSize\": 14, \"titleFontSize\": 14}, \"title\": {\"fontSize\": 20}}, \"data\": {\"name\": \"data-5f46aa601d0e5045f79a2876f4592bba\"}, \"mark\": {\"type\": \"circle\", \"size\": 40}, \"encoding\": {\"color\": {\"condition\": {\"type\": \"nominal\", \"field\": \"Team\", \"scale\": {\"scheme\": \"tableau20\"}, \"sort\": [\"Team1\", \"Team2\", \"Team3\", \"Team4\", \"Team5\", \"Team6\", \"Team7\", \"Team8\", \"Team9\", \"Team10\", \"Team11\", \"Team12\"], \"selection\": \"selector010\"}, \"value\": \"lightgray\"}, \"opacity\": {\"condition\": {\"value\": 1, \"selection\": \"selector010\"}, \"value\": 0.1}, \"tooltip\": [{\"type\": \"nominal\", \"field\": \"Player-info\"}, {\"type\": \"nominal\", \"field\": \"Team\"}, {\"type\": \"quantitative\", \"field\": \"Bid Amount ($)\"}, {\"type\": \"quantitative\", \"field\": \"Total points\"}, {\"type\": \"nominal\", \"field\": \"Stint (wks)\"}], \"x\": {\"type\": \"quantitative\", \"axis\": {\"grid\": false}, \"field\": \"Bid Amount ($)\"}, \"y\": {\"type\": \"quantitative\", \"axis\": {\"grid\": false}, \"field\": \"Total points\"}}, \"height\": 450, \"selection\": {\"selector010\": {\"type\": \"multi\", \"fields\": [\"Team\"], \"bind\": \"legend\"}}, \"title\": \"RB WR TE Draft Spending vs. Total Fantasy Points\", \"width\": 450, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.8.1.json\", \"datasets\": {\"data-5f46aa601d0e5045f79a2876f4592bba\": [{\"Player\": \"Derrick Henry\", \"Position\": \"RB\", \"Team\": \"Team7\", \"ProTeam\": \"TEN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 84, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8], \"Total points\": 184.3, \"Player-info\": \"Derrick Henry, RB (TEN)\"}, {\"Player\": \"Christian McCaffrey\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"CAR\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 83, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12], \"Total points\": 109.0, \"Player-info\": \"Christian McCaffrey, RB (CAR)\"}, {\"Player\": \"Ezekiel Elliott\", \"Position\": \"RB\", \"Team\": \"Team9\", \"ProTeam\": \"DAL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 70, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 218.9, \"Player-info\": \"Ezekiel Elliott, RB (DAL)\"}, {\"Player\": \"Dalvin Cook\", \"Position\": \"RB\", \"Team\": \"Team1\", \"ProTeam\": \"MIN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 70, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 184.6, \"Player-info\": \"Dalvin Cook, RB (MIN)\"}, {\"Player\": \"Alvin Kamara\", \"Position\": \"RB\", \"Team\": \"Team8\", \"ProTeam\": \"NO\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 68, \"Stint (wks)\": [1, 2, 3, 4, 5, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 194.0, \"Player-info\": \"Alvin Kamara, RB (NO)\"}, {\"Player\": \"Travis Kelce\", \"Position\": \"TE\", \"Team\": \"Team3\", \"ProTeam\": \"KC\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 67, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19, 20, 21], \"Total points\": 205.4, \"Player-info\": \"Travis Kelce, TE (KC)\"}, {\"Player\": \"Saquon Barkley\", \"Position\": \"RB\", \"Team\": \"Team3\", \"ProTeam\": \"NYG\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 63, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 121.7, \"Player-info\": \"Saquon Barkley, RB (NYG)\"}, {\"Player\": \"Davante Adams\", \"Position\": \"WR\", \"Team\": \"Team10\", \"ProTeam\": \"GB\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 63, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 20], \"Total points\": 278.3, \"Player-info\": \"Davante Adams, WR (GB)\"}, {\"Player\": \"Nick Chubb\", \"Position\": \"RB\", \"Team\": \"Team12\", \"ProTeam\": \"CLE\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 61, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18], \"Total points\": 198.8, \"Player-info\": \"Nick Chubb, RB (CLE)\"}, {\"Player\": \"Jonathan Taylor\", \"Position\": \"RB\", \"Team\": \"Team6\", \"ProTeam\": \"IND\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 58, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18], \"Total points\": 342.1, \"Player-info\": \"Jonathan Taylor, RB (IND)\"}, {\"Player\": \"Tyreek Hill\", \"Position\": \"WR\", \"Team\": \"Team5\", \"ProTeam\": \"KC\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 57, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19, 20, 21], \"Total points\": 240.3, \"Player-info\": \"Tyreek Hill, WR (KC)\"}, {\"Player\": \"Stefon Diggs\", \"Position\": \"WR\", \"Team\": \"Team9\", \"ProTeam\": \"BUF\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 57, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20], \"Total points\": 215.4, \"Player-info\": \"Stefon Diggs, WR (BUF)\"}, {\"Player\": \"Aaron Jones\", \"Position\": \"RB\", \"Team\": \"Team4\", \"ProTeam\": \"GB\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 56, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 20], \"Total points\": 203.0, \"Player-info\": \"Aaron Jones, RB (GB)\"}, {\"Player\": \"Austin Ekeler\", \"Position\": \"RB\", \"Team\": \"Team2\", \"ProTeam\": \"LAC\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 54, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 282.4, \"Player-info\": \"Austin Ekeler, RB (LAC)\"}, {\"Player\": \"Najee Harris\", \"Position\": \"RB\", \"Team\": \"Team11\", \"ProTeam\": \"PIT\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 51, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 256.2, \"Player-info\": \"Najee Harris, RB (PIT)\"}, {\"Player\": \"Antonio Gibson\", \"Position\": \"RB\", \"Team\": \"Team12\", \"ProTeam\": \"WSH\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 49, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 186.5, \"Player-info\": \"Antonio Gibson, RB (WSH)\"}, {\"Player\": \"DeAndre Hopkins\", \"Position\": \"WR\", \"Team\": \"Team11\", \"ProTeam\": \"ARI\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 45, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 126.2, \"Player-info\": \"DeAndre Hopkins, WR (ARI)\"}, {\"Player\": \"Calvin Ridley\", \"Position\": \"WR\", \"Team\": \"Team12\", \"ProTeam\": \"ATL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 43, \"Stint (wks)\": [1, 2, 3, 4, 5, 7, 8, 9, 10, 11, 12, 13], \"Total points\": 55.6, \"Player-info\": \"Calvin Ridley, WR (ATL)\"}, {\"Player\": \"Justin Jefferson\", \"Position\": \"WR\", \"Team\": \"Team10\", \"ProTeam\": \"MIN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 42, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 256.6, \"Player-info\": \"Justin Jefferson, WR (MIN)\"}, {\"Player\": \"DK Metcalf\", \"Position\": \"WR\", \"Team\": \"Team7\", \"ProTeam\": \"SEA\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 42, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 198.5, \"Player-info\": \"DK Metcalf, WR (SEA)\"}, {\"Player\": \"Joe Mixon\", \"Position\": \"RB\", \"Team\": \"Team11\", \"ProTeam\": \"CIN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 40, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], \"Total points\": 266.9, \"Player-info\": \"Joe Mixon, RB (CIN)\"}, {\"Player\": \"A.J. Brown\", \"Position\": \"WR\", \"Team\": \"Team6\", \"ProTeam\": \"TEN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 38, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 20], \"Total points\": 134.6, \"Player-info\": \"A.J. Brown, WR (TEN)\"}, {\"Player\": \"Keenan Allen\", \"Position\": \"WR\", \"Team\": \"Team1\", \"ProTeam\": \"LAC\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 37, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 196.6, \"Player-info\": \"Keenan Allen, WR (LAC)\"}, {\"Player\": \"Terry McLaurin\", \"Position\": \"WR\", \"Team\": \"Team5\", \"ProTeam\": \"WSH\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 36, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 163.7, \"Player-info\": \"Terry McLaurin, WR (WSH)\"}, {\"Player\": \"Clyde Edwards-Helaire\", \"Position\": \"RB\", \"Team\": \"Team1\", \"ProTeam\": \"KC\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 36, \"Stint (wks)\": [1], \"Total points\": 8.7, \"Player-info\": \"Clyde Edwards-Helaire, RB (KC)\"}, {\"Player\": \"Darren Waller\", \"Position\": \"TE\", \"Team\": \"Team8\", \"ProTeam\": \"OAK\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 35, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 102.8, \"Player-info\": \"Darren Waller, TE (OAK)\"}, {\"Player\": \"Robert Woods\", \"Position\": \"WR\", \"Team\": \"Team8\", \"ProTeam\": \"LAR\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 33, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10], \"Total points\": 114.7, \"Player-info\": \"Robert Woods, WR (LAR)\"}, {\"Player\": \"James Robinson\", \"Position\": \"RB\", \"Team\": \"Team1\", \"ProTeam\": \"JAX\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 33, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 158.4, \"Player-info\": \"James Robinson, RB (JAX)\"}, {\"Player\": \"George Kittle\", \"Position\": \"TE\", \"Team\": \"Team2\", \"ProTeam\": \"SF\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 32, \"Stint (wks)\": [1, 2, 3, 4, 5, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21], \"Total points\": 159.0, \"Player-info\": \"George Kittle, TE (SF)\"}, {\"Player\": \"CeeDee Lamb\", \"Position\": \"WR\", \"Team\": \"Team4\", \"ProTeam\": \"DAL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 32, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 187.8, \"Player-info\": \"CeeDee Lamb, WR (DAL)\"}, {\"Player\": \"David Montgomery\", \"Position\": \"RB\", \"Team\": \"Team7\", \"ProTeam\": \"CHI\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 30, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 165.1, \"Player-info\": \"David Montgomery, RB (CHI)\"}, {\"Player\": \"Mike Evans\", \"Position\": \"WR\", \"Team\": \"Team3\", \"ProTeam\": \"TB\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 30, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20], \"Total points\": 201.6, \"Player-info\": \"Mike Evans, WR (TB)\"}, {\"Player\": \"Miles Sanders\", \"Position\": \"RB\", \"Team\": \"Team2\", \"ProTeam\": \"PHI\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 30, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7], \"Total points\": 53.3, \"Player-info\": \"Miles Sanders, RB (PHI)\"}, {\"Player\": \"Cooper Kupp\", \"Position\": \"WR\", \"Team\": \"Team5\", \"ProTeam\": \"LAR\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 29, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], \"Total points\": 343.9, \"Player-info\": \"Cooper Kupp, WR (LAR)\"}, {\"Player\": \"D'Andre Swift\", \"Position\": \"RB\", \"Team\": \"Team5\", \"ProTeam\": \"DET\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 29, \"Stint (wks)\": [1], \"Total points\": 20.4, \"Player-info\": \"D'Andre Swift, RB (DET)\"}, {\"Player\": \"Allen Robinson II\", \"Position\": \"WR\", \"Team\": \"Team4\", \"ProTeam\": \"CHI\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 29, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14], \"Total points\": 57.3, \"Player-info\": \"Allen Robinson II, WR (CHI)\"}, {\"Player\": \"Amari Cooper\", \"Position\": \"WR\", \"Team\": \"Team2\", \"ProTeam\": \"DAL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 29, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 158.1, \"Player-info\": \"Amari Cooper, WR (DAL)\"}, {\"Player\": \"Chris Carson\", \"Position\": \"RB\", \"Team\": \"Team11\", \"ProTeam\": \"SEA\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 28, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 10, 11], \"Total points\": 45.1, \"Player-info\": \"Chris Carson, RB (SEA)\"}, {\"Player\": \"Tyler Lockett\", \"Position\": \"WR\", \"Team\": \"Team12\", \"ProTeam\": \"SEA\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 22, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 180.4, \"Player-info\": \"Tyler Lockett, WR (SEA)\"}, {\"Player\": \"Gus Edwards\", \"Position\": \"RB\", \"Team\": \"Team4\", \"ProTeam\": \"BAL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 22, \"Stint (wks)\": [1, 2, 3], \"Total points\": 0.0, \"Player-info\": \"Gus Edwards, RB (BAL)\"}, {\"Player\": \"Adam Thielen\", \"Position\": \"WR\", \"Team\": \"Team8\", \"ProTeam\": \"MIN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 21, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 166.3, \"Player-info\": \"Adam Thielen, WR (MIN)\"}, {\"Player\": \"Odell Beckham Jr.\", \"Position\": \"WR\", \"Team\": \"Team9\", \"ProTeam\": \"LAR\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 20, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], \"Total points\": 104.3, \"Player-info\": \"Odell Beckham Jr., WR (LAR)\"}, {\"Player\": \"Chris Godwin\", \"Position\": \"WR\", \"Team\": \"Team6\", \"ProTeam\": \"TB\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 19, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20], \"Total points\": 193.4, \"Player-info\": \"Chris Godwin, WR (TB)\"}, {\"Player\": \"Julio Jones\", \"Position\": \"WR\", \"Team\": \"Team11\", \"ProTeam\": \"TEN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 18, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15], \"Total points\": 49.4, \"Player-info\": \"Julio Jones, WR (TEN)\"}, {\"Player\": \"DJ Moore\", \"Position\": \"WR\", \"Team\": \"Team3\", \"ProTeam\": \"CAR\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 17, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18], \"Total points\": 177.5, \"Player-info\": \"DJ Moore, WR (CAR)\"}, {\"Player\": \"Diontae Johnson\", \"Position\": \"WR\", \"Team\": \"Team2\", \"ProTeam\": \"PIT\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 17, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 212.3, \"Player-info\": \"Diontae Johnson, WR (PIT)\"}, {\"Player\": \"Darrell Henderson Jr.\", \"Position\": \"RB\", \"Team\": \"Team6\", \"ProTeam\": \"LAR\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 17, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], \"Total points\": 148.9, \"Player-info\": \"Darrell Henderson Jr., RB (LAR)\"}, {\"Player\": \"Josh Jacobs\", \"Position\": \"RB\", \"Team\": \"Team9\", \"ProTeam\": \"OAK\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 16, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 177.6, \"Player-info\": \"Josh Jacobs, RB (OAK)\"}, {\"Player\": \"Mark Andrews\", \"Position\": \"TE\", \"Team\": \"Team7\", \"ProTeam\": \"BAL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 16, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 235.1, \"Player-info\": \"Mark Andrews, TE (BAL)\"}, {\"Player\": \"Tee Higgins\", \"Position\": \"WR\", \"Team\": \"Team4\", \"ProTeam\": \"CIN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 16, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], \"Total points\": 182.1, \"Player-info\": \"Tee Higgins, WR (CIN)\"}, {\"Player\": \"Myles Gaskin\", \"Position\": \"RB\", \"Team\": \"Team5\", \"ProTeam\": \"MIA\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 14, \"Stint (wks)\": [1], \"Total points\": 10.1, \"Player-info\": \"Myles Gaskin, RB (MIA)\"}, {\"Player\": \"DeVonta Smith\", \"Position\": \"WR\", \"Team\": \"Team7\", \"ProTeam\": \"PHI\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 12, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18, 19], \"Total points\": 148.0, \"Player-info\": \"DeVonta Smith, WR (PHI)\"}, {\"Player\": \"Mike Davis\", \"Position\": \"RB\", \"Team\": \"Team5\", \"ProTeam\": \"ATL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 12, \"Stint (wks)\": [1, 2, 3, 4, 5, 7, 8, 9, 10, 11, 12], \"Total points\": 71.6, \"Player-info\": \"Mike Davis, RB (ATL)\"}, {\"Player\": \"Kareem Hunt\", \"Position\": \"RB\", \"Team\": \"Team9\", \"ProTeam\": \"CLE\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 10, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18], \"Total points\": 99.0, \"Player-info\": \"Kareem Hunt, RB (CLE)\"}, {\"Player\": \"Tyler Boyd\", \"Position\": \"WR\", \"Team\": \"Team9\", \"ProTeam\": \"CIN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 10, \"Stint (wks)\": [1, 2, 3, 4, 5, 6], \"Total points\": 49.0, \"Player-info\": \"Tyler Boyd, WR (CIN)\"}, {\"Player\": \"Logan Thomas\", \"Position\": \"TE\", \"Team\": \"Team6\", \"ProTeam\": \"WSH\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 9, \"Stint (wks)\": [1, 2, 3, 4, 5], \"Total points\": 27.7, \"Player-info\": \"Logan Thomas, TE (WSH)\"}, {\"Player\": \"Kenny Golladay\", \"Position\": \"WR\", \"Team\": \"Team3\", \"ProTeam\": \"NYG\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 9, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 66.9, \"Player-info\": \"Kenny Golladay, WR (NYG)\"}, {\"Player\": \"Robby Anderson\", \"Position\": \"WR\", \"Team\": \"Team2\", \"ProTeam\": \"CAR\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 8, \"Stint (wks)\": [1, 2, 3], \"Total points\": 18.8, \"Player-info\": \"Robby Anderson, WR (CAR)\"}, {\"Player\": \"Courtland Sutton\", \"Position\": \"WR\", \"Team\": \"Team1\", \"ProTeam\": \"DEN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 8, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10], \"Total points\": 97.2, \"Player-info\": \"Courtland Sutton, WR (DEN)\"}, {\"Player\": \"Brandin Cooks\", \"Position\": \"WR\", \"Team\": \"Team2\", \"ProTeam\": \"HOU\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 8, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 182.7, \"Player-info\": \"Brandin Cooks, WR (HOU)\"}, {\"Player\": \"Chase Edmonds\", \"Position\": \"RB\", \"Team\": \"Team4\", \"ProTeam\": \"ARI\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 7, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 121.8, \"Player-info\": \"Chase Edmonds, RB (ARI)\"}, {\"Player\": \"Sony Michel\", \"Position\": \"RB\", \"Team\": \"Team6\", \"ProTeam\": \"LAR\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 7, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], \"Total points\": 130.4, \"Player-info\": \"Sony Michel, RB (LAR)\"}, {\"Player\": \"T.J. Hockenson\", \"Position\": \"TE\", \"Team\": \"Team4\", \"ProTeam\": \"DET\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 7, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 114.8, \"Player-info\": \"T.J. Hockenson, TE (DET)\"}, {\"Player\": \"Jerry Jeudy\", \"Position\": \"WR\", \"Team\": \"Team3\", \"ProTeam\": \"DEN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 7, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 62.0, \"Player-info\": \"Jerry Jeudy, WR (DEN)\"}, {\"Player\": \"JuJu Smith-Schuster\", \"Position\": \"WR\", \"Team\": \"Team4\", \"ProTeam\": \"PIT\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 6, \"Stint (wks)\": [1, 2, 3, 4, 5], \"Total points\": 27.3, \"Player-info\": \"JuJu Smith-Schuster, WR (PIT)\"}, {\"Player\": \"Raheem Mostert\", \"Position\": \"RB\", \"Team\": \"Team6\", \"ProTeam\": \"SF\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 6, \"Stint (wks)\": [1], \"Total points\": 2.0, \"Player-info\": \"Raheem Mostert, RB (SF)\"}, {\"Player\": \"Javonte Williams\", \"Position\": \"RB\", \"Team\": \"Team8\", \"ProTeam\": \"DEN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 6, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 176.0, \"Player-info\": \"Javonte Williams, RB (DEN)\"}, {\"Player\": \"William Fuller V\", \"Position\": \"WR\", \"Team\": \"Team4\", \"ProTeam\": \"MIA\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [1, 2, 3, 4], \"Total points\": 6.6, \"Player-info\": \"William Fuller V, WR (MIA)\"}, {\"Player\": \"Laviska Shenault Jr.\", \"Position\": \"WR\", \"Team\": \"Team12\", \"ProTeam\": \"JAX\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [1, 2, 3, 4, 5, 6], \"Total points\": 45.6, \"Player-info\": \"Laviska Shenault Jr., WR (JAX)\"}, {\"Player\": \"Damien Harris\", \"Position\": \"RB\", \"Team\": \"Team11\", \"ProTeam\": \"NE\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18, 19], \"Total points\": 185.8, \"Player-info\": \"Damien Harris, RB (NE)\"}, {\"Player\": \"Noah Fant\", \"Position\": \"TE\", \"Team\": \"Team9\", \"ProTeam\": \"DEN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8], \"Total points\": 68.5, \"Player-info\": \"Noah Fant, TE (DEN)\"}, {\"Player\": \"Chase Claypool\", \"Position\": \"WR\", \"Team\": \"Team8\", \"ProTeam\": \"PIT\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10], \"Total points\": 68.9, \"Player-info\": \"Chase Claypool, WR (PIT)\"}, {\"Player\": \"Melvin Gordon III\", \"Position\": \"RB\", \"Team\": \"Team5\", \"ProTeam\": \"DEN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 165.0, \"Player-info\": \"Melvin Gordon III, RB (DEN)\"}, {\"Player\": \"Michael Thomas\", \"Position\": \"WR\", \"Team\": \"Team6\", \"ProTeam\": \"NO\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [1, 2, 3, 4, 5, 7, 8], \"Total points\": 0.0, \"Player-info\": \"Michael Thomas, WR (NO)\"}, {\"Player\": \"Kyle Pitts\", \"Position\": \"TE\", \"Team\": \"Team6\", \"ProTeam\": \"ATL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [1, 2, 3, 4, 5, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 140.8, \"Player-info\": \"Kyle Pitts, TE (ATL)\"}, {\"Player\": \"Deebo Samuel\", \"Position\": \"WR\", \"Team\": \"Team1\", \"ProTeam\": \"SF\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 4, \"Stint (wks)\": [1], \"Total points\": 27.4, \"Player-info\": \"Deebo Samuel, WR (SF)\"}, {\"Player\": \"Jarvis Landry\", \"Position\": \"WR\", \"Team\": \"Team2\", \"ProTeam\": \"CLE\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [], \"Total points\": 0.0, \"Player-info\": \"Jarvis Landry, WR (CLE)\"}, {\"Player\": \"Kenyan Drake\", \"Position\": \"RB\", \"Team\": \"Team8\", \"ProTeam\": \"OAK\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [1, 2, 3, 4], \"Total points\": 24.9, \"Player-info\": \"Kenyan Drake, RB (OAK)\"}, {\"Player\": \"Trey Sermon\", \"Position\": \"RB\", \"Team\": \"Team12\", \"ProTeam\": \"SF\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [1, 2, 3, 4, 5], \"Total points\": 20.8, \"Player-info\": \"Trey Sermon, RB (SF)\"}, {\"Player\": \"Corey Davis\", \"Position\": \"WR\", \"Team\": \"Team1\", \"ProTeam\": \"NYJ\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [1, 2, 3, 4, 5, 7, 8, 9, 10, 11, 12], \"Total points\": 85.7, \"Player-info\": \"Corey Davis, WR (NYJ)\"}, {\"Player\": \"Michael Carter\", \"Position\": \"RB\", \"Team\": \"Team12\", \"ProTeam\": \"NYJ\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [1, 2, 3], \"Total points\": 16.2, \"Player-info\": \"Michael Carter, RB (NYJ)\"}, {\"Player\": \"Ja'Marr Chase\", \"Position\": \"WR\", \"Team\": \"Team12\", \"ProTeam\": \"CIN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], \"Total points\": 268.5, \"Player-info\": \"Ja'Marr Chase, WR (CIN)\"}, {\"Player\": \"Michael Gallup\", \"Position\": \"WR\", \"Team\": \"Team9\", \"ProTeam\": \"DAL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [1], \"Total points\": 5.6, \"Player-info\": \"Michael Gallup, WR (DAL)\"}, {\"Player\": \"DJ Chark Jr.\", \"Position\": \"WR\", \"Team\": \"Team7\", \"ProTeam\": \"JAX\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [1, 2], \"Total points\": 18.5, \"Player-info\": \"DJ Chark Jr., WR (JAX)\"}, {\"Player\": \"Ronald Jones II\", \"Position\": \"RB\", \"Team\": \"Team9\", \"ProTeam\": \"TB\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [1, 2], \"Total points\": 3.5, \"Player-info\": \"Ronald Jones II, RB (TB)\"}, {\"Player\": \"Michael Pittman Jr.\", \"Position\": \"WR\", \"Team\": \"Team7\", \"ProTeam\": \"IND\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [1], \"Total points\": 4.4, \"Player-info\": \"Michael Pittman Jr., WR (IND)\"}, {\"Player\": \"James Conner\", \"Position\": \"RB\", \"Team\": \"Team9\", \"ProTeam\": \"ARI\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [1, 2], \"Total points\": 7.9, \"Player-info\": \"James Conner, RB (ARI)\"}, {\"Player\": \"Marquise Brown\", \"Position\": \"WR\", \"Team\": \"Team2\", \"ProTeam\": \"BAL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [], \"Total points\": 0.0, \"Player-info\": \"Marquise Brown, WR (BAL)\"}, {\"Player\": \"Marvin Jones Jr.\", \"Position\": \"WR\", \"Team\": \"Team1\", \"ProTeam\": \"JAX\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [], \"Total points\": 0.0, \"Player-info\": \"Marvin Jones Jr., WR (JAX)\"}, {\"Player\": \"AJ Dillon\", \"Position\": \"RB\", \"Team\": \"Team11\", \"ProTeam\": \"GB\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 20], \"Total points\": 161.4, \"Player-info\": \"AJ Dillon, RB (GB)\"}, {\"Player\": \"Mike Williams\", \"Position\": \"WR\", \"Team\": \"Team8\", \"ProTeam\": \"LAC\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 186.2, \"Player-info\": \"Mike Williams, WR (LAC)\"}, {\"Player\": \"Cole Beasley\", \"Position\": \"WR\", \"Team\": \"Team3\", \"ProTeam\": \"BUF\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15], \"Total points\": 108.0, \"Player-info\": \"Cole Beasley, WR (BUF)\"}, {\"Player\": \"Mecole Hardman\", \"Position\": \"WR\", \"Team\": \"Team12\", \"ProTeam\": \"KC\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1], \"Total points\": 3.4, \"Player-info\": \"Mecole Hardman, WR (KC)\"}, {\"Player\": \"Jakobi Meyers\", \"Position\": \"WR\", \"Team\": \"Team3\", \"ProTeam\": \"NE\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18, 19], \"Total points\": 137.8, \"Player-info\": \"Jakobi Meyers, WR (NE)\"}, {\"Player\": \"Chuba Hubbard\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"CAR\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1], \"Total points\": 1.4, \"Player-info\": \"Chuba Hubbard, RB (CAR)\"}, {\"Player\": \"J.D. McKissic\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"WSH\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1], \"Total points\": 0.8, \"Player-info\": \"J.D. McKissic, RB (WSH)\"}, {\"Player\": \"Dallas Goedert\", \"Position\": \"TE\", \"Team\": \"Team1\", \"ProTeam\": \"PHI\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18, 19], \"Total points\": 137.0, \"Player-info\": \"Dallas Goedert, TE (PHI)\"}, {\"Player\": \"Nyheim Hines\", \"Position\": \"RB\", \"Team\": \"Team7\", \"ProTeam\": \"IND\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [], \"Total points\": 0.0, \"Player-info\": \"Nyheim Hines, RB (IND)\"}, {\"Player\": \"Jamison Crowder\", \"Position\": \"WR\", \"Team\": \"Team10\", \"ProTeam\": \"NYJ\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3], \"Total points\": 0.0, \"Player-info\": \"Jamison Crowder, WR (NYJ)\"}, {\"Player\": \"Curtis Samuel\", \"Position\": \"WR\", \"Team\": \"Team3\", \"ProTeam\": \"WSH\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1], \"Total points\": 0.0, \"Player-info\": \"Curtis Samuel, WR (WSH)\"}, {\"Player\": \"Marquez Callaway\", \"Position\": \"WR\", \"Team\": \"Team11\", \"ProTeam\": \"NO\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16], \"Total points\": 116.1, \"Player-info\": \"Marquez Callaway, WR (NO)\"}, {\"Player\": \"Mike Gesicki\", \"Position\": \"TE\", \"Team\": \"Team5\", \"ProTeam\": \"MIA\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1], \"Total points\": 0.0, \"Player-info\": \"Mike Gesicki, TE (MIA)\"}, {\"Player\": \"Russell Gage\", \"Position\": \"WR\", \"Team\": \"Team10\", \"ProTeam\": \"ATL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2], \"Total points\": 5.3, \"Player-info\": \"Russell Gage, WR (ATL)\"}, {\"Player\": \"Zack Moss\", \"Position\": \"RB\", \"Team\": \"Team3\", \"ProTeam\": \"BUF\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15], \"Total points\": 84.4, \"Player-info\": \"Zack Moss, RB (BUF)\"}, {\"Player\": \"Ty'Son Williams\", \"Position\": \"RB\", \"Team\": \"Team5\", \"ProTeam\": \"BAL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3], \"Total points\": 29.4, \"Player-info\": \"Ty'Son Williams, RB (BAL)\"}, {\"Player\": \"Jaylen Waddle\", \"Position\": \"WR\", \"Team\": \"Team7\", \"ProTeam\": \"MIA\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5], \"Total points\": 40.8, \"Player-info\": \"Jaylen Waddle, WR (MIA)\"}, {\"Player\": \"Robert Tonyan\", \"Position\": \"TE\", \"Team\": \"Team11\", \"ProTeam\": \"GB\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11], \"Total points\": 41.4, \"Player-info\": \"Robert Tonyan, TE (GB)\"}, {\"Player\": \"James White\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"NE\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3], \"Total points\": 25.2, \"Player-info\": \"James White, RB (NE)\"}, {\"Player\": \"Devin Singletary\", \"Position\": \"RB\", \"Team\": \"Team6\", \"ProTeam\": \"BUF\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6], \"Total points\": 47.4, \"Player-info\": \"Devin Singletary, RB (BUF)\"}, {\"Player\": \"Leonard Fournette\", \"Position\": \"RB\", \"Team\": \"Team7\", \"ProTeam\": \"TB\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20], \"Total points\": 221.1, \"Player-info\": \"Leonard Fournette, RB (TB)\"}, {\"Player\": \"Jamaal Williams\", \"Position\": \"RB\", \"Team\": \"Team2\", \"ProTeam\": \"DET\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6], \"Total points\": 55.4, \"Player-info\": \"Jamaal Williams, RB (DET)\"}, {\"Player\": \"David Johnson\", \"Position\": \"RB\", \"Team\": \"Team8\", \"ProTeam\": \"HOU\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2], \"Total points\": 16.0, \"Player-info\": \"David Johnson, RB (HOU)\"}, {\"Player\": \"Jalen Reagor\", \"Position\": \"WR\", \"Team\": \"Team8\", \"ProTeam\": \"PHI\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2], \"Total points\": 15.4, \"Player-info\": \"Jalen Reagor, WR (PHI)\"}, {\"Player\": \"Jonnu Smith\", \"Position\": \"TE\", \"Team\": \"Team10\", \"ProTeam\": \"NE\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3], \"Total points\": 13.0, \"Player-info\": \"Jonnu Smith, TE (NE)\"}, {\"Player\": \"Tyler Higbee\", \"Position\": \"TE\", \"Team\": \"Team12\", \"ProTeam\": \"LAR\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10], \"Total points\": 71.4, \"Player-info\": \"Tyler Higbee, TE (LAR)\"}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "chart"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Quarterbacks in Draft"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [],
   "source": [
    "acquisition_method = 'Draft'\n",
    "\n",
    "position_subset = ['QB']\n",
    "\n",
    "df = df_stints_f_draft[df_stints_f_draft['Position'].isin(position_subset)]\n",
    "\n",
    "chart = generate_acquisitions_scatterplot(df , ' '.join(position_subset) , acquisition_method)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The old fantasy draft advice of not spending big on QB held true this year as the return on investment on big pricetag QBs like Mahomes was marginal."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-47503d0d02974dc5b446354290119066\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-47503d0d02974dc5b446354290119066\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-47503d0d02974dc5b446354290119066\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.8.1?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function loadScript(lib) {\n",
       "      return new Promise(function(resolve, reject) {\n",
       "        var s = document.createElement('script');\n",
       "        s.src = paths[lib];\n",
       "        s.async = true;\n",
       "        s.onload = () => resolve(paths[lib]);\n",
       "        s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "        document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "      });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else if (typeof vegaEmbed === \"function\") {\n",
       "      displayChart(vegaEmbed);\n",
       "    } else {\n",
       "      loadScript(\"vega\")\n",
       "        .then(() => loadScript(\"vega-lite\"))\n",
       "        .then(() => loadScript(\"vega-embed\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300}, \"axis\": {\"labelFontSize\": 18, \"titleFontSize\": 18}, \"legend\": {\"labelFontSize\": 14, \"titleFontSize\": 14}, \"title\": {\"fontSize\": 20}}, \"data\": {\"name\": \"data-86fdf3a17de5a8906b76c03e76c839fa\"}, \"mark\": {\"type\": \"circle\", \"size\": 40}, \"encoding\": {\"color\": {\"condition\": {\"type\": \"nominal\", \"field\": \"Team\", \"scale\": {\"scheme\": \"tableau20\"}, \"sort\": [\"Team1\", \"Team2\", \"Team3\", \"Team4\", \"Team5\", \"Team6\", \"Team7\", \"Team8\", \"Team9\", \"Team10\", \"Team11\", \"Team12\"], \"selection\": \"selector011\"}, \"value\": \"lightgray\"}, \"opacity\": {\"condition\": {\"value\": 1, \"selection\": \"selector011\"}, \"value\": 0.1}, \"tooltip\": [{\"type\": \"nominal\", \"field\": \"Player-info\"}, {\"type\": \"nominal\", \"field\": \"Team\"}, {\"type\": \"quantitative\", \"field\": \"Bid Amount ($)\"}, {\"type\": \"quantitative\", \"field\": \"Total points\"}, {\"type\": \"nominal\", \"field\": \"Stint (wks)\"}], \"x\": {\"type\": \"quantitative\", \"axis\": {\"grid\": false}, \"field\": \"Bid Amount ($)\"}, \"y\": {\"type\": \"quantitative\", \"axis\": {\"grid\": false}, \"field\": \"Total points\"}}, \"height\": 450, \"selection\": {\"selector011\": {\"type\": \"multi\", \"fields\": [\"Team\"], \"bind\": \"legend\"}}, \"title\": \"QB Draft Spending vs. Total Fantasy Points\", \"width\": 450, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.8.1.json\", \"datasets\": {\"data-86fdf3a17de5a8906b76c03e76c839fa\": [{\"Player\": \"Patrick Mahomes\", \"Position\": \"QB\", \"Team\": \"Team8\", \"ProTeam\": \"KC\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 22, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19, 20, 21], \"Total points\": 338.3, \"Player-info\": \"Patrick Mahomes, QB (KC)\"}, {\"Player\": \"Josh Allen\", \"Position\": \"QB\", \"Team\": \"Team2\", \"ProTeam\": \"BUF\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 13, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20], \"Total points\": 377.4, \"Player-info\": \"Josh Allen, QB (BUF)\"}, {\"Player\": \"Lamar Jackson\", \"Position\": \"QB\", \"Team\": \"Team7\", \"ProTeam\": \"BAL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 6, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 241.1, \"Player-info\": \"Lamar Jackson, QB (BAL)\"}, {\"Player\": \"Aaron Rodgers\", \"Position\": \"QB\", \"Team\": \"Team6\", \"ProTeam\": \"GB\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 6, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 20], \"Total points\": 317.3, \"Player-info\": \"Aaron Rodgers, QB (GB)\"}, {\"Player\": \"Russell Wilson\", \"Position\": \"QB\", \"Team\": \"Team9\", \"ProTeam\": \"SEA\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 4, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 217.8, \"Player-info\": \"Russell Wilson, QB (SEA)\"}, {\"Player\": \"Justin Herbert\", \"Position\": \"QB\", \"Team\": \"Team4\", \"ProTeam\": \"LAC\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 352.3, \"Player-info\": \"Justin Herbert, QB (LAC)\"}, {\"Player\": \"Kyler Murray\", \"Position\": \"QB\", \"Team\": \"Team11\", \"ProTeam\": \"ARI\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 284.1, \"Player-info\": \"Kyler Murray, QB (ARI)\"}, {\"Player\": \"Dak Prescott\", \"Position\": \"QB\", \"Team\": \"Team10\", \"ProTeam\": \"DAL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 291.8, \"Player-info\": \"Dak Prescott, QB (DAL)\"}, {\"Player\": \"Ryan Tannehill\", \"Position\": \"QB\", \"Team\": \"Team12\", \"ProTeam\": \"TEN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [1, 2, 3, 4], \"Total points\": 68.7, \"Player-info\": \"Ryan Tannehill, QB (TEN)\"}, {\"Player\": \"Tom Brady\", \"Position\": \"QB\", \"Team\": \"Team5\", \"ProTeam\": \"TB\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20], \"Total points\": 354.5, \"Player-info\": \"Tom Brady, QB (TB)\"}, {\"Player\": \"Deshaun Watson\", \"Position\": \"QB\", \"Team\": \"Team4\", \"ProTeam\": \"HOU\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [], \"Total points\": 0.0, \"Player-info\": \"Deshaun Watson, QB (HOU)\"}, {\"Player\": \"Jalen Hurts\", \"Position\": \"QB\", \"Team\": \"Team1\", \"ProTeam\": \"PHI\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18, 19], \"Total points\": 310.8, \"Player-info\": \"Jalen Hurts, QB (PHI)\"}, {\"Player\": \"Matthew Stafford\", \"Position\": \"QB\", \"Team\": \"Team11\", \"ProTeam\": \"LAR\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], \"Total points\": 310.9, \"Player-info\": \"Matthew Stafford, QB (LAR)\"}, {\"Player\": \"Joe Burrow\", \"Position\": \"QB\", \"Team\": \"Team3\", \"ProTeam\": \"CIN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], \"Total points\": 319.2, \"Player-info\": \"Joe Burrow, QB (CIN)\"}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 149,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "chart"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Tight Ends in Draft"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "metadata": {},
   "outputs": [],
   "source": [
    "acquisition_method = 'Draft'\n",
    "\n",
    "position_subset = ['TE']\n",
    "\n",
    "df = df_stints_f_draft[df_stints_f_draft['Position'].isin(position_subset)]\n",
    "\n",
    "chart = generate_acquisitions_scatterplot(df , ' '.join(position_subset) , acquisition_method)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Travis Kelce was the consensus number 1 pick at tight end, but Mark Andrews turned out to be the best value and top scorer by end of season. Darren Waller was surprisingly a disappointing pick."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-93b7cc281be44882808beb1b12c7f8b1\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-93b7cc281be44882808beb1b12c7f8b1\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-93b7cc281be44882808beb1b12c7f8b1\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.8.1?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function loadScript(lib) {\n",
       "      return new Promise(function(resolve, reject) {\n",
       "        var s = document.createElement('script');\n",
       "        s.src = paths[lib];\n",
       "        s.async = true;\n",
       "        s.onload = () => resolve(paths[lib]);\n",
       "        s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "        document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "      });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else if (typeof vegaEmbed === \"function\") {\n",
       "      displayChart(vegaEmbed);\n",
       "    } else {\n",
       "      loadScript(\"vega\")\n",
       "        .then(() => loadScript(\"vega-lite\"))\n",
       "        .then(() => loadScript(\"vega-embed\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300}, \"axis\": {\"labelFontSize\": 18, \"titleFontSize\": 18}, \"legend\": {\"labelFontSize\": 14, \"titleFontSize\": 14}, \"title\": {\"fontSize\": 20}}, \"data\": {\"name\": \"data-d884752c817280b26ae332ea60fa0e1c\"}, \"mark\": {\"type\": \"circle\", \"size\": 40}, \"encoding\": {\"color\": {\"condition\": {\"type\": \"nominal\", \"field\": \"Team\", \"scale\": {\"scheme\": \"tableau20\"}, \"sort\": [\"Team1\", \"Team2\", \"Team3\", \"Team4\", \"Team5\", \"Team6\", \"Team7\", \"Team8\", \"Team9\", \"Team10\", \"Team11\", \"Team12\"], \"selection\": \"selector012\"}, \"value\": \"lightgray\"}, \"opacity\": {\"condition\": {\"value\": 1, \"selection\": \"selector012\"}, \"value\": 0.1}, \"tooltip\": [{\"type\": \"nominal\", \"field\": \"Player-info\"}, {\"type\": \"nominal\", \"field\": \"Team\"}, {\"type\": \"quantitative\", \"field\": \"Bid Amount ($)\"}, {\"type\": \"quantitative\", \"field\": \"Total points\"}, {\"type\": \"nominal\", \"field\": \"Stint (wks)\"}], \"x\": {\"type\": \"quantitative\", \"axis\": {\"grid\": false}, \"field\": \"Bid Amount ($)\"}, \"y\": {\"type\": \"quantitative\", \"axis\": {\"grid\": false}, \"field\": \"Total points\"}}, \"height\": 450, \"selection\": {\"selector012\": {\"type\": \"multi\", \"fields\": [\"Team\"], \"bind\": \"legend\"}}, \"title\": \"TE Draft Spending vs. Total Fantasy Points\", \"width\": 450, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.8.1.json\", \"datasets\": {\"data-d884752c817280b26ae332ea60fa0e1c\": [{\"Player\": \"Travis Kelce\", \"Position\": \"TE\", \"Team\": \"Team3\", \"ProTeam\": \"KC\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 67, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19, 20, 21], \"Total points\": 205.4, \"Player-info\": \"Travis Kelce, TE (KC)\"}, {\"Player\": \"Darren Waller\", \"Position\": \"TE\", \"Team\": \"Team8\", \"ProTeam\": \"OAK\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 35, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 102.8, \"Player-info\": \"Darren Waller, TE (OAK)\"}, {\"Player\": \"George Kittle\", \"Position\": \"TE\", \"Team\": \"Team2\", \"ProTeam\": \"SF\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 32, \"Stint (wks)\": [1, 2, 3, 4, 5, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21], \"Total points\": 159.0, \"Player-info\": \"George Kittle, TE (SF)\"}, {\"Player\": \"Mark Andrews\", \"Position\": \"TE\", \"Team\": \"Team7\", \"ProTeam\": \"BAL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 16, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 235.1, \"Player-info\": \"Mark Andrews, TE (BAL)\"}, {\"Player\": \"Logan Thomas\", \"Position\": \"TE\", \"Team\": \"Team6\", \"ProTeam\": \"WSH\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 9, \"Stint (wks)\": [1, 2, 3, 4, 5], \"Total points\": 27.7, \"Player-info\": \"Logan Thomas, TE (WSH)\"}, {\"Player\": \"T.J. Hockenson\", \"Position\": \"TE\", \"Team\": \"Team4\", \"ProTeam\": \"DET\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 7, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 114.8, \"Player-info\": \"T.J. Hockenson, TE (DET)\"}, {\"Player\": \"Noah Fant\", \"Position\": \"TE\", \"Team\": \"Team9\", \"ProTeam\": \"DEN\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8], \"Total points\": 68.5, \"Player-info\": \"Noah Fant, TE (DEN)\"}, {\"Player\": \"Kyle Pitts\", \"Position\": \"TE\", \"Team\": \"Team6\", \"ProTeam\": \"ATL\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [1, 2, 3, 4, 5, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 140.8, \"Player-info\": \"Kyle Pitts, TE (ATL)\"}, {\"Player\": \"Dallas Goedert\", \"Position\": \"TE\", \"Team\": \"Team1\", \"ProTeam\": \"PHI\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18, 19], \"Total points\": 137.0, \"Player-info\": \"Dallas Goedert, TE (PHI)\"}, {\"Player\": \"Mike Gesicki\", \"Position\": \"TE\", \"Team\": \"Team5\", \"ProTeam\": \"MIA\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1], \"Total points\": 0.0, \"Player-info\": \"Mike Gesicki, TE (MIA)\"}, {\"Player\": \"Robert Tonyan\", \"Position\": \"TE\", \"Team\": \"Team11\", \"ProTeam\": \"GB\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11], \"Total points\": 41.4, \"Player-info\": \"Robert Tonyan, TE (GB)\"}, {\"Player\": \"Jonnu Smith\", \"Position\": \"TE\", \"Team\": \"Team10\", \"ProTeam\": \"NE\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3], \"Total points\": 13.0, \"Player-info\": \"Jonnu Smith, TE (NE)\"}, {\"Player\": \"Tyler Higbee\", \"Position\": \"TE\", \"Team\": \"Team12\", \"ProTeam\": \"LAR\", \"Action\": \"DRAFT\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 7, 8, 9, 10], \"Total points\": 71.4, \"Player-info\": \"Tyler Higbee, TE (LAR)\"}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 151,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "chart"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RendererRegistry.enable('html')"
      ]
     },
     "execution_count": 152,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "alt.renderers.enable('html')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Waiver Wire "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_stints_f_waiver = df_stints_f[df_stints_f['Action'] == 'WAIVER']\n",
    "\n",
    "# Filter for minimum stints of at least 2 weeks\n",
    "df_stints_f_waiver = df_stints_f_waiver[df_stints_f_waiver['Stint (wks)'].apply(lambda x: get_bool_len(x))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "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>Player</th>\n",
       "      <th>Position</th>\n",
       "      <th>Team</th>\n",
       "      <th>ProTeam</th>\n",
       "      <th>Action</th>\n",
       "      <th>Bid Amount ($)</th>\n",
       "      <th>Stint (wks)</th>\n",
       "      <th>Total points</th>\n",
       "      <th>Player-info</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Stint</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Kirk Cousins</td>\n",
       "      <td>QB</td>\n",
       "      <td>Team12</td>\n",
       "      <td>MIN</td>\n",
       "      <td>WAIVER</td>\n",
       "      <td>3</td>\n",
       "      <td>[4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16]</td>\n",
       "      <td>205.1</td>\n",
       "      <td>Kirk Cousins, QB (MIN)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Cordarrelle Patterson</td>\n",
       "      <td>RB</td>\n",
       "      <td>Team8</td>\n",
       "      <td>ATL</td>\n",
       "      <td>WAIVER</td>\n",
       "      <td>12</td>\n",
       "      <td>[3, 4, 5, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16,...</td>\n",
       "      <td>177.8</td>\n",
       "      <td>Cordarrelle Patterson, RB (ATL)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>James Conner</td>\n",
       "      <td>RB</td>\n",
       "      <td>Team2</td>\n",
       "      <td>ARI</td>\n",
       "      <td>WAIVER</td>\n",
       "      <td>21</td>\n",
       "      <td>[5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18...</td>\n",
       "      <td>169.6</td>\n",
       "      <td>James Conner, RB (ARI)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Marquise Brown</td>\n",
       "      <td>WR</td>\n",
       "      <td>Team10</td>\n",
       "      <td>BAL</td>\n",
       "      <td>WAIVER</td>\n",
       "      <td>5</td>\n",
       "      <td>[2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, ...</td>\n",
       "      <td>160.2</td>\n",
       "      <td>Marquise Brown, WR (BAL)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Hunter Renfrow</td>\n",
       "      <td>WR</td>\n",
       "      <td>Team6</td>\n",
       "      <td>OAK</td>\n",
       "      <td>WAIVER</td>\n",
       "      <td>2</td>\n",
       "      <td>[4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 16, 17...</td>\n",
       "      <td>158.3</td>\n",
       "      <td>Hunter Renfrow, WR (OAK)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Player Position    Team ProTeam  Action Bid Amount ($)  \\\n",
       "Stint                                                                          \n",
       "28              Kirk Cousins       QB  Team12     MIN  WAIVER              3   \n",
       "45     Cordarrelle Patterson       RB   Team8     ATL  WAIVER             12   \n",
       "49              James Conner       RB   Team2     ARI  WAIVER             21   \n",
       "55            Marquise Brown       WR  Team10     BAL  WAIVER              5   \n",
       "58            Hunter Renfrow       WR   Team6     OAK  WAIVER              2   \n",
       "\n",
       "                                             Stint (wks)  Total points  \\\n",
       "Stint                                                                    \n",
       "28           [4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16]         205.1   \n",
       "45     [3, 4, 5, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16,...         177.8   \n",
       "49     [5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18...         169.6   \n",
       "55     [2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, ...         160.2   \n",
       "58     [4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 16, 17...         158.3   \n",
       "\n",
       "                           Player-info  \n",
       "Stint                                   \n",
       "28              Kirk Cousins, QB (MIN)  \n",
       "45     Cordarrelle Patterson, RB (ATL)  \n",
       "49              James Conner, RB (ARI)  \n",
       "55            Marquise Brown, WR (BAL)  \n",
       "58            Hunter Renfrow, WR (OAK)  "
      ]
     },
     "execution_count": 154,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_stints_f_waiver.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Waiver Spending"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "metadata": {},
   "outputs": [],
   "source": [
    "acquisition_method = 'Waiver'\n",
    "\n",
    "position_subset = ['RB','WR','TE']\n",
    "\n",
    "df = df_stints_f_waiver[df_stints_f_waiver['Position'].isin(position_subset)]\n",
    "\n",
    "chart = generate_acquisitions_scatterplot(df , ' '.join(position_subset) , acquisition_method)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The biggest steals on the waiver wire were Cordarrelle Patterson, Hollywood Brown, and Hunter Renfrow. The biggest runaway hype trains were Adrian Peterson, Rondale Moore, and Kadarius Toney. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<div id=\"altair-viz-d00aff9cd9264604a53a84309227e330\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-d00aff9cd9264604a53a84309227e330\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-d00aff9cd9264604a53a84309227e330\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.8.1?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function loadScript(lib) {\n",
       "      return new Promise(function(resolve, reject) {\n",
       "        var s = document.createElement('script');\n",
       "        s.src = paths[lib];\n",
       "        s.async = true;\n",
       "        s.onload = () => resolve(paths[lib]);\n",
       "        s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "        document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "      });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else if (typeof vegaEmbed === \"function\") {\n",
       "      displayChart(vegaEmbed);\n",
       "    } else {\n",
       "      loadScript(\"vega\")\n",
       "        .then(() => loadScript(\"vega-lite\"))\n",
       "        .then(() => loadScript(\"vega-embed\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300}, \"axis\": {\"labelFontSize\": 18, \"titleFontSize\": 18}, \"legend\": {\"labelFontSize\": 14, \"titleFontSize\": 14}, \"title\": {\"fontSize\": 20}}, \"data\": {\"name\": \"data-cf397547162b860c4b9bc349a9baa00e\"}, \"mark\": {\"type\": \"circle\", \"size\": 40}, \"encoding\": {\"color\": {\"condition\": {\"type\": \"nominal\", \"field\": \"Team\", \"scale\": {\"scheme\": \"tableau20\"}, \"sort\": [\"Team1\", \"Team2\", \"Team3\", \"Team4\", \"Team5\", \"Team6\", \"Team7\", \"Team8\", \"Team9\", \"Team10\", \"Team11\", \"Team12\"], \"selection\": \"selector013\"}, \"value\": \"lightgray\"}, \"opacity\": {\"condition\": {\"value\": 1, \"selection\": \"selector013\"}, \"value\": 0.1}, \"tooltip\": [{\"type\": \"nominal\", \"field\": \"Player-info\"}, {\"type\": \"nominal\", \"field\": \"Team\"}, {\"type\": \"quantitative\", \"field\": \"Bid Amount ($)\"}, {\"type\": \"quantitative\", \"field\": \"Total points\"}, {\"type\": \"nominal\", \"field\": \"Stint (wks)\"}], \"x\": {\"type\": \"quantitative\", \"axis\": {\"grid\": false}, \"field\": \"Bid Amount ($)\"}, \"y\": {\"type\": \"quantitative\", \"axis\": {\"grid\": false}, \"field\": \"Total points\"}}, \"height\": 450, \"selection\": {\"selector013\": {\"type\": \"multi\", \"fields\": [\"Team\"], \"bind\": \"legend\"}}, \"title\": \"RB WR TE Waiver Spending vs. Total Fantasy Points\", \"width\": 450, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.8.1.json\", \"datasets\": {\"data-cf397547162b860c4b9bc349a9baa00e\": [{\"Player\": \"Cordarrelle Patterson\", \"Position\": \"RB\", \"Team\": \"Team8\", \"ProTeam\": \"ATL\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 12, \"Stint (wks)\": [3, 4, 5, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 177.8, \"Player-info\": \"Cordarrelle Patterson, RB (ATL)\"}, {\"Player\": \"James Conner\", \"Position\": \"RB\", \"Team\": \"Team2\", \"ProTeam\": \"ARI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 21, \"Stint (wks)\": [5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 169.6, \"Player-info\": \"James Conner, RB (ARI)\"}, {\"Player\": \"Marquise Brown\", \"Position\": \"WR\", \"Team\": \"Team10\", \"ProTeam\": \"BAL\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 160.2, \"Player-info\": \"Marquise Brown, WR (BAL)\"}, {\"Player\": \"Hunter Renfrow\", \"Position\": \"WR\", \"Team\": \"Team6\", \"ProTeam\": \"OAK\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [4, 5, 6, 7, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 158.3, \"Player-info\": \"Hunter Renfrow, WR (OAK)\"}, {\"Player\": \"Elijah Mitchell\", \"Position\": \"RB\", \"Team\": \"Team5\", \"ProTeam\": \"SF\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 30, \"Stint (wks)\": [2, 3, 4, 5, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21], \"Total points\": 130.6, \"Player-info\": \"Elijah Mitchell, RB (SF)\"}, {\"Player\": \"Jaylen Waddle\", \"Position\": \"WR\", \"Team\": \"Team7\", \"ProTeam\": \"MIA\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 11, \"Stint (wks)\": [7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18], \"Total points\": 117.8, \"Player-info\": \"Jaylen Waddle, WR (MIA)\"}, {\"Player\": \"Michael Pittman Jr.\", \"Position\": \"WR\", \"Team\": \"Team4\", \"ProTeam\": \"IND\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18], \"Total points\": 114.6, \"Player-info\": \"Michael Pittman Jr., WR (IND)\"}, {\"Player\": \"Mike Gesicki\", \"Position\": \"TE\", \"Team\": \"Team5\", \"ProTeam\": \"MIA\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18], \"Total points\": 106.1, \"Player-info\": \"Mike Gesicki, TE (MIA)\"}, {\"Player\": \"Dawson Knox\", \"Position\": \"TE\", \"Team\": \"Team2\", \"ProTeam\": \"BUF\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20], \"Total points\": 105.1, \"Player-info\": \"Dawson Knox, TE (BUF)\"}, {\"Player\": \"Chuba Hubbard\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"CAR\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 33, \"Stint (wks)\": [4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18], \"Total points\": 100.7, \"Player-info\": \"Chuba Hubbard, RB (CAR)\"}, {\"Player\": \"Dalton Schultz\", \"Position\": \"TE\", \"Team\": \"Team9\", \"ProTeam\": \"DAL\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 10, \"Stint (wks)\": [6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 95.2, \"Player-info\": \"Dalton Schultz, TE (DAL)\"}, {\"Player\": \"Michael Carter\", \"Position\": \"RB\", \"Team\": \"Team2\", \"ProTeam\": \"NYJ\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 95.1, \"Player-info\": \"Michael Carter, RB (NYJ)\"}, {\"Player\": \"Myles Gaskin\", \"Position\": \"RB\", \"Team\": \"Team4\", \"ProTeam\": \"MIA\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 25, \"Stint (wks)\": [6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18], \"Total points\": 93.8, \"Player-info\": \"Myles Gaskin, RB (MIA)\"}, {\"Player\": \"Zach Ertz\", \"Position\": \"TE\", \"Team\": \"Team10\", \"ProTeam\": \"ARI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 91.9, \"Player-info\": \"Zach Ertz, TE (ARI)\"}, {\"Player\": \"Marvin Jones Jr.\", \"Position\": \"WR\", \"Team\": \"Team2\", \"ProTeam\": \"JAX\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 0, \"Stint (wks)\": [1, 2, 3, 4, 5, 6, 8, 9, 10, 11], \"Total points\": 87.6, \"Player-info\": \"Marvin Jones Jr., WR (JAX)\"}, {\"Player\": \"Brandon Aiyuk\", \"Position\": \"WR\", \"Team\": \"Team9\", \"ProTeam\": \"SF\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21], \"Total points\": 83.2, \"Player-info\": \"Brandon Aiyuk, WR (SF)\"}, {\"Player\": \"Devin Singletary\", \"Position\": \"RB\", \"Team\": \"Team4\", \"ProTeam\": \"BUF\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [11, 12, 13, 14, 15, 16, 17, 18, 19, 20], \"Total points\": 82.0, \"Player-info\": \"Devin Singletary, RB (BUF)\"}, {\"Player\": \"Tony Pollard\", \"Position\": \"RB\", \"Team\": \"Team12\", \"ProTeam\": \"DAL\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 81.5, \"Player-info\": \"Tony Pollard, RB (DAL)\"}, {\"Player\": \"A.J. Green\", \"Position\": \"WR\", \"Team\": \"Team9\", \"ProTeam\": \"ARI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 16, \"Stint (wks)\": [5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 81.2, \"Player-info\": \"A.J. Green, WR (ARI)\"}, {\"Player\": \"Darrel Williams\", \"Position\": \"RB\", \"Team\": \"Team9\", \"ProTeam\": \"KC\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 23, \"Stint (wks)\": [6, 7, 8, 9, 10, 11], \"Total points\": 80.1, \"Player-info\": \"Darrel Williams, RB (KC)\"}, {\"Player\": \"Darnell Mooney\", \"Position\": \"WR\", \"Team\": \"Team7\", \"ProTeam\": \"CHI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 77.1, \"Player-info\": \"Darnell Mooney, WR (CHI)\"}, {\"Player\": \"Rob Gronkowski\", \"Position\": \"TE\", \"Team\": \"Team9\", \"ProTeam\": \"TB\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20], \"Total points\": 76.1, \"Player-info\": \"Rob Gronkowski, TE (TB)\"}, {\"Player\": \"Devonta Freeman\", \"Position\": \"RB\", \"Team\": \"Team8\", \"ProTeam\": \"BAL\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 4, \"Stint (wks)\": [11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 71.5, \"Player-info\": \"Devonta Freeman, RB (BAL)\"}, {\"Player\": \"D'Onta Foreman\", \"Position\": \"RB\", \"Team\": \"Team5\", \"ProTeam\": \"TEN\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 4, \"Stint (wks)\": [11, 12, 14, 15, 16, 17, 18, 20], \"Total points\": 68.8, \"Player-info\": \"D'Onta Foreman, RB (TEN)\"}, {\"Player\": \"Van Jefferson\", \"Position\": \"WR\", \"Team\": \"Team8\", \"ProTeam\": \"LAR\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 11, \"Stint (wks)\": [10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], \"Total points\": 64.3, \"Player-info\": \"Van Jefferson, WR (LAR)\"}, {\"Player\": \"Elijah Moore\", \"Position\": \"WR\", \"Team\": \"Team12\", \"ProTeam\": \"NYJ\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [10, 11, 12, 13, 14, 15, 16], \"Total points\": 62.4, \"Player-info\": \"Elijah Moore, WR (NYJ)\"}, {\"Player\": \"Tony Pollard\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"DAL\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 0, \"Stint (wks)\": [1, 2, 3, 4, 5, 6], \"Total points\": 61.6, \"Player-info\": \"Tony Pollard, RB (DAL)\"}, {\"Player\": \"Rex Burkhead\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"HOU\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [13, 14, 15, 16, 17, 18], \"Total points\": 57.6, \"Player-info\": \"Rex Burkhead, RB (HOU)\"}, {\"Player\": \"D'Ernest Johnson\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"CLE\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [7, 8, 9, 10, 11], \"Total points\": 56.6, \"Player-info\": \"D'Ernest Johnson, RB (CLE)\"}, {\"Player\": \"Rashaad Penny\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"SEA\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [15, 16, 17, 18], \"Total points\": 56.4, \"Player-info\": \"Rashaad Penny, RB (SEA)\"}, {\"Player\": \"Michael Gallup\", \"Position\": \"WR\", \"Team\": \"Team11\", \"ProTeam\": \"DAL\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 8, \"Stint (wks)\": [12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 55.8, \"Player-info\": \"Michael Gallup, WR (DAL)\"}, {\"Player\": \"Amon-Ra St. Brown\", \"Position\": \"WR\", \"Team\": \"Team11\", \"ProTeam\": \"DET\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 22, \"Stint (wks)\": [16, 17, 18], \"Total points\": 52.9, \"Player-info\": \"Amon-Ra St. Brown, WR (DET)\"}, {\"Player\": \"Pat Freiermuth\", \"Position\": \"TE\", \"Team\": \"Team6\", \"ProTeam\": \"PIT\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 4, \"Stint (wks)\": [10, 11, 12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 51.4, \"Player-info\": \"Pat Freiermuth, TE (PIT)\"}, {\"Player\": \"Devontae Booker\", \"Position\": \"RB\", \"Team\": \"Team5\", \"ProTeam\": \"NYG\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 9, \"Stint (wks)\": [6, 7, 8, 9], \"Total points\": 51.2, \"Player-info\": \"Devontae Booker, RB (NYG)\"}, {\"Player\": \"Miles Sanders\", \"Position\": \"RB\", \"Team\": \"Team4\", \"ProTeam\": \"PHI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [8, 9, 10, 11, 12, 13, 15, 16, 17, 18, 19], \"Total points\": 50.9, \"Player-info\": \"Miles Sanders, RB (PHI)\"}, {\"Player\": \"Alexander Mattison\", \"Position\": \"RB\", \"Team\": \"Team1\", \"ProTeam\": \"MIN\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 50.7, \"Player-info\": \"Alexander Mattison, RB (MIN)\"}, {\"Player\": \"Alexander Mattison\", \"Position\": \"RB\", \"Team\": \"Team1\", \"ProTeam\": \"MIN\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 0, \"Stint (wks)\": [2, 3, 4, 5, 6, 8], \"Total points\": 50.2, \"Player-info\": \"Alexander Mattison, RB (MIN)\"}, {\"Player\": \"Jared Cook\", \"Position\": \"TE\", \"Team\": \"Team11\", \"ProTeam\": \"LAC\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [9, 10, 11, 12, 13, 14, 15, 16], \"Total points\": 48.9, \"Player-info\": \"Jared Cook, TE (LAC)\"}, {\"Player\": \"Noah Fant\", \"Position\": \"TE\", \"Team\": \"Team12\", \"ProTeam\": \"DEN\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [12, 13, 14, 15, 16, 17, 18], \"Total points\": 46.0, \"Player-info\": \"Noah Fant, TE (DEN)\"}, {\"Player\": \"Emmanuel Sanders\", \"Position\": \"WR\", \"Team\": \"Team7\", \"ProTeam\": \"BUF\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [5, 6, 8, 9, 10], \"Total points\": 45.1, \"Player-info\": \"Emmanuel Sanders, WR (BUF)\"}, {\"Player\": \"Khalil Herbert\", \"Position\": \"RB\", \"Team\": \"Team12\", \"ProTeam\": \"CHI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 22, \"Stint (wks)\": [6, 7, 8, 9, 11, 12], \"Total points\": 44.0, \"Player-info\": \"Khalil Herbert, RB (CHI)\"}, {\"Player\": \"Michael Pittman Jr.\", \"Position\": \"WR\", \"Team\": \"Team7\", \"ProTeam\": \"IND\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 6, \"Stint (wks)\": [3, 4, 5, 6], \"Total points\": 41.9, \"Player-info\": \"Michael Pittman Jr., WR (IND)\"}, {\"Player\": \"Chase Claypool\", \"Position\": \"WR\", \"Team\": \"Team1\", \"ProTeam\": \"PIT\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 40.8, \"Player-info\": \"Chase Claypool, WR (PIT)\"}, {\"Player\": \"Sterling Shepard\", \"Position\": \"WR\", \"Team\": \"Team10\", \"ProTeam\": \"NYG\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 13, \"Stint (wks)\": [2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15], \"Total points\": 38.9, \"Player-info\": \"Sterling Shepard, WR (NYG)\"}, {\"Player\": \"Justin Jackson\", \"Position\": \"RB\", \"Team\": \"Team1\", \"ProTeam\": \"LAC\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [16, 17, 18], \"Total points\": 37.8, \"Player-info\": \"Justin Jackson, RB (LAC)\"}, {\"Player\": \"Tyler Conklin\", \"Position\": \"TE\", \"Team\": \"Team8\", \"ProTeam\": \"MIN\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [8, 9, 10, 11], \"Total points\": 34.8, \"Player-info\": \"Tyler Conklin, TE (MIN)\"}, {\"Player\": \"Mark Ingram II\", \"Position\": \"RB\", \"Team\": \"Team1\", \"ProTeam\": \"NO\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [10, 11, 12, 13], \"Total points\": 34.2, \"Player-info\": \"Mark Ingram II, RB (NO)\"}, {\"Player\": \"Christian Kirk\", \"Position\": \"WR\", \"Team\": \"Team9\", \"ProTeam\": \"ARI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [7, 8, 9], \"Total points\": 32.9, \"Player-info\": \"Christian Kirk, WR (ARI)\"}, {\"Player\": \"J.D. McKissic\", \"Position\": \"RB\", \"Team\": \"Team1\", \"ProTeam\": \"WSH\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 21, \"Stint (wks)\": [7, 8, 10, 11], \"Total points\": 32.3, \"Player-info\": \"J.D. McKissic, RB (WSH)\"}, {\"Player\": \"Jeff Wilson Jr.\", \"Position\": \"RB\", \"Team\": \"Team12\", \"ProTeam\": \"SF\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [15, 16, 17, 18, 19, 20, 21], \"Total points\": 32.1, \"Player-info\": \"Jeff Wilson Jr., RB (SF)\"}, {\"Player\": \"Tim Patrick\", \"Position\": \"WR\", \"Team\": \"Team12\", \"ProTeam\": \"DEN\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [2, 3, 4], \"Total points\": 28.9, \"Player-info\": \"Tim Patrick, WR (DEN)\"}, {\"Player\": \"Dontrell Hilliard\", \"Position\": \"RB\", \"Team\": \"Team7\", \"ProTeam\": \"TEN\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [14, 15, 16, 17, 18, 20], \"Total points\": 26.9, \"Player-info\": \"Dontrell Hilliard, RB (TEN)\"}, {\"Player\": \"Foster Moreau\", \"Position\": \"TE\", \"Team\": \"Team8\", \"ProTeam\": \"OAK\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [13, 14, 15, 16, 17, 18, 19], \"Total points\": 26.8, \"Player-info\": \"Foster Moreau, TE (OAK)\"}, {\"Player\": \"Jalen Guyton\", \"Position\": \"WR\", \"Team\": \"Team8\", \"ProTeam\": \"LAC\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [14, 15, 16, 17, 18], \"Total points\": 26.3, \"Player-info\": \"Jalen Guyton, WR (LAC)\"}, {\"Player\": \"Kenyan Drake\", \"Position\": \"RB\", \"Team\": \"Team6\", \"ProTeam\": \"OAK\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19], \"Total points\": 25.8, \"Player-info\": \"Kenyan Drake, RB (OAK)\"}, {\"Player\": \"Alex Collins\", \"Position\": \"RB\", \"Team\": \"Team12\", \"ProTeam\": \"SEA\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 13, \"Stint (wks)\": [6, 7, 8], \"Total points\": 25.6, \"Player-info\": \"Alex Collins, RB (SEA)\"}, {\"Player\": \"Rhamondre Stevenson\", \"Position\": \"RB\", \"Team\": \"Team12\", \"ProTeam\": \"NE\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 6, \"Stint (wks)\": [11, 12, 13, 15, 16], \"Total points\": 24.9, \"Player-info\": \"Rhamondre Stevenson, RB (NE)\"}, {\"Player\": \"Darrel Williams\", \"Position\": \"RB\", \"Team\": \"Team2\", \"ProTeam\": \"KC\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 11, \"Stint (wks)\": [17, 18, 19, 20, 21], \"Total points\": 24.2, \"Player-info\": \"Darrel Williams, RB (KC)\"}, {\"Player\": \"Kadarius Toney\", \"Position\": \"WR\", \"Team\": \"Team7\", \"ProTeam\": \"NYG\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 27, \"Stint (wks)\": [6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18], \"Total points\": 23.8, \"Player-info\": \"Kadarius Toney, WR (NYG)\"}, {\"Player\": \"Jared Cook\", \"Position\": \"TE\", \"Team\": \"Team9\", \"ProTeam\": \"LAC\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [3, 4, 5], \"Total points\": 23.1, \"Player-info\": \"Jared Cook, TE (LAC)\"}, {\"Player\": \"Rondale Moore\", \"Position\": \"WR\", \"Team\": \"Team8\", \"ProTeam\": \"ARI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 28, \"Stint (wks)\": [3, 4, 5, 6], \"Total points\": 22.9, \"Player-info\": \"Rondale Moore, WR (ARI)\"}, {\"Player\": \"Darnell Mooney\", \"Position\": \"WR\", \"Team\": \"Team7\", \"ProTeam\": \"CHI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [5, 6, 7], \"Total points\": 22.9, \"Player-info\": \"Darnell Mooney, WR (CHI)\"}, {\"Player\": \"Hunter Henry\", \"Position\": \"TE\", \"Team\": \"Team6\", \"ProTeam\": \"NE\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [6, 7, 8], \"Total points\": 22.6, \"Player-info\": \"Hunter Henry, TE (NE)\"}, {\"Player\": \"Boston Scott\", \"Position\": \"RB\", \"Team\": \"Team1\", \"ProTeam\": \"PHI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [17, 18, 19], \"Total points\": 22.6, \"Player-info\": \"Boston Scott, RB (PHI)\"}, {\"Player\": \"Phillip Lindsay\", \"Position\": \"RB\", \"Team\": \"Team3\", \"ProTeam\": \"MIA\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 0, \"Stint (wks)\": [2, 3, 4, 5, 6, 7, 8, 9, 10, 11], \"Total points\": 21.7, \"Player-info\": \"Phillip Lindsay, RB (MIA)\"}, {\"Player\": \"DeVante Parker\", \"Position\": \"WR\", \"Team\": \"Team12\", \"ProTeam\": \"MIA\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [15, 16, 17, 18], \"Total points\": 21.4, \"Player-info\": \"DeVante Parker, WR (MIA)\"}, {\"Player\": \"Christian Kirk\", \"Position\": \"WR\", \"Team\": \"Team11\", \"ProTeam\": \"ARI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 7, \"Stint (wks)\": [16, 17, 18, 19], \"Total points\": 19.2, \"Player-info\": \"Christian Kirk, WR (ARI)\"}, {\"Player\": \"J.D. McKissic\", \"Position\": \"RB\", \"Team\": \"Team9\", \"ProTeam\": \"WSH\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 9, \"Stint (wks)\": [3, 4], \"Total points\": 19.2, \"Player-info\": \"J.D. McKissic, RB (WSH)\"}, {\"Player\": \"Dan Arnold\", \"Position\": \"TE\", \"Team\": \"Team4\", \"ProTeam\": \"JAX\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [9, 10], \"Total points\": 19.2, \"Player-info\": \"Dan Arnold, TE (JAX)\"}, {\"Player\": \"Mecole Hardman\", \"Position\": \"WR\", \"Team\": \"Team8\", \"ProTeam\": \"KC\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [7, 8, 9, 10], \"Total points\": 19.1, \"Player-info\": \"Mecole Hardman, WR (KC)\"}, {\"Player\": \"Latavius Murray\", \"Position\": \"RB\", \"Team\": \"Team9\", \"ProTeam\": \"BAL\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 11, \"Stint (wks)\": [3, 4, 5], \"Total points\": 18.7, \"Player-info\": \"Latavius Murray, RB (BAL)\"}, {\"Player\": \"Ronald Jones II\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"TB\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [16, 17, 18, 19, 20], \"Total points\": 18.3, \"Player-info\": \"Ronald Jones II, RB (TB)\"}, {\"Player\": \"Tevin Coleman\", \"Position\": \"RB\", \"Team\": \"Team2\", \"ProTeam\": \"NYJ\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [12, 13, 14], \"Total points\": 17.2, \"Player-info\": \"Tevin Coleman, RB (NYJ)\"}, {\"Player\": \"Damien Williams\", \"Position\": \"RB\", \"Team\": \"Team7\", \"ProTeam\": \"CHI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 13, \"Stint (wks)\": [5, 6, 7], \"Total points\": 16.7, \"Player-info\": \"Damien Williams, RB (CHI)\"}, {\"Player\": \"Jarvis Landry\", \"Position\": \"WR\", \"Team\": \"Team6\", \"ProTeam\": \"CLE\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [6, 7, 8, 9], \"Total points\": 16.3, \"Player-info\": \"Jarvis Landry, WR (CLE)\"}, {\"Player\": \"Samaje Perine\", \"Position\": \"RB\", \"Team\": \"Team8\", \"ProTeam\": \"CIN\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [5, 6], \"Total points\": 16.3, \"Player-info\": \"Samaje Perine, RB (CIN)\"}, {\"Player\": \"Tyler Conklin\", \"Position\": \"TE\", \"Team\": \"Team10\", \"ProTeam\": \"MIN\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [4, 5, 6], \"Total points\": 15.9, \"Player-info\": \"Tyler Conklin, TE (MIN)\"}, {\"Player\": \"Tre'Quan Smith\", \"Position\": \"WR\", \"Team\": \"Team2\", \"ProTeam\": \"NO\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [12, 13, 14, 15], \"Total points\": 15.1, \"Player-info\": \"Tre'Quan Smith, WR (NO)\"}, {\"Player\": \"Tim Patrick\", \"Position\": \"WR\", \"Team\": \"Team2\", \"ProTeam\": \"DEN\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [6, 7], \"Total points\": 14.3, \"Player-info\": \"Tim Patrick, WR (DEN)\"}, {\"Player\": \"Robby Anderson\", \"Position\": \"WR\", \"Team\": \"Team4\", \"ProTeam\": \"CAR\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [5, 6], \"Total points\": 12.6, \"Player-info\": \"Robby Anderson, WR (CAR)\"}, {\"Player\": \"Tyler Boyd\", \"Position\": \"WR\", \"Team\": \"Team2\", \"ProTeam\": \"CIN\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 3, \"Stint (wks)\": [17, 18, 19, 20, 21, 22], \"Total points\": 11.6, \"Player-info\": \"Tyler Boyd, WR (CIN)\"}, {\"Player\": \"Cole Kmet\", \"Position\": \"TE\", \"Team\": \"Team3\", \"ProTeam\": \"CHI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [16, 17, 18], \"Total points\": 10.9, \"Player-info\": \"Cole Kmet, TE (CHI)\"}, {\"Player\": \"David Njoku\", \"Position\": \"TE\", \"Team\": \"Team11\", \"ProTeam\": \"CLE\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 49, \"Stint (wks)\": [17, 18], \"Total points\": 10.8, \"Player-info\": \"David Njoku, TE (CLE)\"}, {\"Player\": \"Ricky Seals-Jones\", \"Position\": \"TE\", \"Team\": \"Team2\", \"ProTeam\": \"WSH\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [7, 8], \"Total points\": 10.3, \"Player-info\": \"Ricky Seals-Jones, TE (WSH)\"}, {\"Player\": \"Tyler Higbee\", \"Position\": \"TE\", \"Team\": \"Team4\", \"ProTeam\": \"LAR\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 7, \"Stint (wks)\": [17, 18, 19, 20, 21, 22], \"Total points\": 9.9, \"Player-info\": \"Tyler Higbee, TE (LAR)\"}, {\"Player\": \"Rashod Bateman\", \"Position\": \"WR\", \"Team\": \"Team7\", \"ProTeam\": \"BAL\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [11, 12], \"Total points\": 9.5, \"Player-info\": \"Rashod Bateman, WR (BAL)\"}, {\"Player\": \"Myles Gaskin\", \"Position\": \"RB\", \"Team\": \"Team7\", \"ProTeam\": \"MIA\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [3, 4], \"Total points\": 9.2, \"Player-info\": \"Myles Gaskin, RB (MIA)\"}, {\"Player\": \"Kenneth Gainwell\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"PHI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [8, 9], \"Total points\": 9.0, \"Player-info\": \"Kenneth Gainwell, RB (PHI)\"}, {\"Player\": \"Courtland Sutton\", \"Position\": \"WR\", \"Team\": \"Team6\", \"ProTeam\": \"DEN\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [12, 13, 14, 15], \"Total points\": 8.8, \"Player-info\": \"Courtland Sutton, WR (DEN)\"}, {\"Player\": \"DeVante Parker\", \"Position\": \"WR\", \"Team\": \"Team12\", \"ProTeam\": \"MIA\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 6, \"Stint (wks)\": [9, 10, 11, 12, 13], \"Total points\": 8.7, \"Player-info\": \"DeVante Parker, WR (MIA)\"}, {\"Player\": \"Tyler Higbee\", \"Position\": \"TE\", \"Team\": \"Team3\", \"ProTeam\": \"LAR\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [12, 13, 14], \"Total points\": 8.1, \"Player-info\": \"Tyler Higbee, TE (LAR)\"}, {\"Player\": \"Jarvis Landry\", \"Position\": \"WR\", \"Team\": \"Team4\", \"ProTeam\": \"CLE\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [15, 16], \"Total points\": 7.5, \"Player-info\": \"Jarvis Landry, WR (CLE)\"}, {\"Player\": \"Jeff Wilson Jr.\", \"Position\": \"RB\", \"Team\": \"Team8\", \"ProTeam\": \"SF\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 5, \"Stint (wks)\": [11, 12], \"Total points\": 7.5, \"Player-info\": \"Jeff Wilson Jr., RB (SF)\"}, {\"Player\": \"Alex Collins\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"SEA\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [11, 12, 13, 14], \"Total points\": 7.0, \"Player-info\": \"Alex Collins, RB (SEA)\"}, {\"Player\": \"Royce Freeman\", \"Position\": \"RB\", \"Team\": \"Team3\", \"ProTeam\": \"HOU\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [15, 16, 17, 18], \"Total points\": 6.7, \"Player-info\": \"Royce Freeman, RB (HOU)\"}, {\"Player\": \"Ty Johnson\", \"Position\": \"RB\", \"Team\": \"Team7\", \"ProTeam\": \"NYJ\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [12, 13], \"Total points\": 6.7, \"Player-info\": \"Ty Johnson, RB (NYJ)\"}, {\"Player\": \"Jeremy McNichols\", \"Position\": \"RB\", \"Team\": \"Team7\", \"ProTeam\": \"TEN\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [9, 10], \"Total points\": 6.3, \"Player-info\": \"Jeremy McNichols, RB (TEN)\"}, {\"Player\": \"Hunter Henry\", \"Position\": \"TE\", \"Team\": \"Team1\", \"ProTeam\": \"NE\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [11, 12], \"Total points\": 6.1, \"Player-info\": \"Hunter Henry, TE (NE)\"}, {\"Player\": \"Latavius Murray\", \"Position\": \"RB\", \"Team\": \"Team2\", \"ProTeam\": \"BAL\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [9, 10, 11, 12], \"Total points\": 5.7, \"Player-info\": \"Latavius Murray, RB (BAL)\"}, {\"Player\": \"Nyheim Hines\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"IND\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 8, \"Stint (wks)\": [4, 5, 6], \"Total points\": 4.6, \"Player-info\": \"Nyheim Hines, RB (IND)\"}, {\"Player\": \"Christian Kirk\", \"Position\": \"WR\", \"Team\": \"Team4\", \"ProTeam\": \"ARI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [11, 13], \"Total points\": 4.4, \"Player-info\": \"Christian Kirk, WR (ARI)\"}, {\"Player\": \"David Njoku\", \"Position\": \"TE\", \"Team\": \"Team4\", \"ProTeam\": \"CLE\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [15, 16], \"Total points\": 4.4, \"Player-info\": \"David Njoku, TE (CLE)\"}, {\"Player\": \"Kenneth Gainwell\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"PHI\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [5, 6], \"Total points\": 3.5, \"Player-info\": \"Kenneth Gainwell, RB (PHI)\"}, {\"Player\": \"Dan Arnold\", \"Position\": \"TE\", \"Team\": \"Team10\", \"ProTeam\": \"JAX\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [11, 12], \"Total points\": 1.4, \"Player-info\": \"Dan Arnold, TE (JAX)\"}, {\"Player\": \"T.Y. Hilton\", \"Position\": \"WR\", \"Team\": \"Team5\", \"ProTeam\": \"IND\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [1, 2, 3, 4, 5], \"Total points\": 0.0, \"Player-info\": \"T.Y. Hilton, WR (IND)\"}, {\"Player\": \"Derrick Henry\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"TEN\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 1, \"Stint (wks)\": [9, 10, 11, 12, 14, 15, 16, 17, 18, 20], \"Total points\": 0.0, \"Player-info\": \"Derrick Henry, RB (TEN)\"}, {\"Player\": \"Jeff Wilson Jr.\", \"Position\": \"RB\", \"Team\": \"Team1\", \"ProTeam\": \"SF\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 0, \"Stint (wks)\": [2, 3, 4, 5], \"Total points\": 0.0, \"Player-info\": \"Jeff Wilson Jr., RB (SF)\"}, {\"Player\": \"J.D. McKissic\", \"Position\": \"RB\", \"Team\": \"Team10\", \"ProTeam\": \"WSH\", \"Action\": \"WAIVER\", \"Bid Amount ($)\": 2, \"Stint (wks)\": [13, 14, 15], \"Total points\": 0.0, \"Player-info\": \"J.D. McKissic, RB (WSH)\"}]}}, {\"mode\": \"vega-lite\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 156,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "chart"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## The Journeymen"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Who are the players that are borderline fantasy football relevant that get added frequently? Let's exclude kickers and D/STs. By \"added\", we include added by draft, waiver, or trade."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 157,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.options.mode.chained_assignment = None  # default='warn'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_acq_final1['Position'] = df_acq_final1['Player'].map(position_dict)\n",
    "\n",
    "df_acq_final2 = df_acq_final1[df_acq_final1['Position'].isin(['QB','RB','WR','TE'])]\n",
    "\n",
    "all_player_ls = list(set(df_acq_final2['Player'].tolist()))\n",
    "\n",
    "df_player_adds = pd.DataFrame(data=[], index = all_player_ls, columns = ['Times added'])\n",
    "for i in all_player_ls:\n",
    "    df_temp = df_acq_final2[df_acq_final2['Player'] == i]\n",
    "    # count number of adds of particular player\n",
    "    n_adds = df_temp['Action'].str.contains('ADDED').sum()\n",
    "    df_player_adds.loc[i, 'Times added'] = n_adds\n",
    "\n",
    "df_player_adds = df_player_adds.sort_values(by = 'Times added', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "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>Times added</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Jeff Wilson Jr.</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jarvis Landry</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>J.D. McKissic</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jared Cook</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tyler Conklin</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dallas Goedert</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Phillip Lindsay</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Travis Kelce</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Patrick Mahomes</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jerry Jeudy</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>220 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Times added\n",
       "Jeff Wilson Jr.           5\n",
       "Jarvis Landry             5\n",
       "J.D. McKissic             5\n",
       "Jared Cook                4\n",
       "Tyler Conklin             4\n",
       "...                     ...\n",
       "Dallas Goedert            1\n",
       "Phillip Lindsay           1\n",
       "Travis Kelce              1\n",
       "Patrick Mahomes           1\n",
       "Jerry Jeudy               1\n",
       "\n",
       "[220 rows x 1 columns]"
      ]
     },
     "execution_count": 159,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Dataframe of total player adds on the season\n",
    "\n",
    "df_player_adds"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Jarvis Landry, J.D. McKissic, and Jeff Wilson Jr. are much loved (and transiently so) in our league as they've each been added 5 times this season!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "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>Times added</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Jeff Wilson Jr.</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jarvis Landry</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>J.D. McKissic</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jared Cook</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tyler Conklin</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nyheim Hines</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jamison Crowder</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Latavius Murray</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Logan Thomas</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mark Ingram II</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Derek Carr</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Myles Gaskin</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Courtland Sutton</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Christian Kirk</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Devin Singletary</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ryan Tannehill</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Carter</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rob Gronkowski</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Daniel Jones</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tyler Higbee</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Michael Pittman Jr.</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tyler Boyd</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Brandon Aiyuk</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alexander Mattison</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ronald Jones II</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Times added\n",
       "Jeff Wilson Jr.               5\n",
       "Jarvis Landry                 5\n",
       "J.D. McKissic                 5\n",
       "Jared Cook                    4\n",
       "Tyler Conklin                 4\n",
       "Nyheim Hines                  4\n",
       "Jamison Crowder               4\n",
       "Latavius Murray               4\n",
       "Logan Thomas                  4\n",
       "Mark Ingram II                4\n",
       "Derek Carr                    4\n",
       "Myles Gaskin                  3\n",
       "Courtland Sutton              3\n",
       "Christian Kirk                3\n",
       "Devin Singletary              3\n",
       "Ryan Tannehill                3\n",
       "Michael Carter                3\n",
       "Rob Gronkowski                3\n",
       "Daniel Jones                  3\n",
       "Tyler Higbee                  3\n",
       "Michael Pittman Jr.           3\n",
       "Tyler Boyd                    3\n",
       "Brandon Aiyuk                 3\n",
       "Alexander Mattison            3\n",
       "Ronald Jones II               3"
      ]
     },
     "execution_count": 160,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_player_adds.head(25)"
   ]
  }
 ],
 "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}