evaluate_draft.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from csh_fantasy_bot import bot\n",
    "from csh_fantasy_bot.yahoo_scraping import YahooPredictions, PredictionType\n",
    "\n",
    "league_id = \"411.l.85094\"\n",
    "manager: bot.ManagerBot = bot.ManagerBot(league_id=league_id)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>draft_pick</th>\n",
       "      <th>draft_round</th>\n",
       "      <th>team_key</th>\n",
       "      <th>player_key</th>\n",
       "      <th>fantasy_team_id</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>player_id</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>6743</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.6</td>\n",
       "      <td>411.p.6743</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6369</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.10</td>\n",
       "      <td>411.p.6369</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5980</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.5</td>\n",
       "      <td>411.p.5980</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5425</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.1</td>\n",
       "      <td>411.p.5425</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5699</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.2</td>\n",
       "      <td>411.p.5699</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8643</th>\n",
       "      <td>188</td>\n",
       "      <td>16</td>\n",
       "      <td>411.l.85094.t.2</td>\n",
       "      <td>411.p.8643</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7636</th>\n",
       "      <td>189</td>\n",
       "      <td>16</td>\n",
       "      <td>411.l.85094.t.1</td>\n",
       "      <td>411.p.7636</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4974</th>\n",
       "      <td>190</td>\n",
       "      <td>16</td>\n",
       "      <td>411.l.85094.t.5</td>\n",
       "      <td>411.p.4974</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6762</th>\n",
       "      <td>191</td>\n",
       "      <td>16</td>\n",
       "      <td>411.l.85094.t.10</td>\n",
       "      <td>411.p.6762</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3349</th>\n",
       "      <td>192</td>\n",
       "      <td>16</td>\n",
       "      <td>411.l.85094.t.6</td>\n",
       "      <td>411.p.3349</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>192 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           draft_pick  draft_round          team_key  player_key  \\\n",
       "player_id                                                          \n",
       "6743                1            1   411.l.85094.t.6  411.p.6743   \n",
       "6369                2            1  411.l.85094.t.10  411.p.6369   \n",
       "5980                3            1   411.l.85094.t.5  411.p.5980   \n",
       "5425                4            1   411.l.85094.t.1  411.p.5425   \n",
       "5699                5            1   411.l.85094.t.2  411.p.5699   \n",
       "...               ...          ...               ...         ...   \n",
       "8643              188           16   411.l.85094.t.2  411.p.8643   \n",
       "7636              189           16   411.l.85094.t.1  411.p.7636   \n",
       "4974              190           16   411.l.85094.t.5  411.p.4974   \n",
       "6762              191           16  411.l.85094.t.10  411.p.6762   \n",
       "3349              192           16   411.l.85094.t.6  411.p.3349   \n",
       "\n",
       "           fantasy_team_id  \n",
       "player_id                   \n",
       "6743                     6  \n",
       "6369                    10  \n",
       "5980                     5  \n",
       "5425                     1  \n",
       "5699                     2  \n",
       "...                    ...  \n",
       "8643                     2  \n",
       "7636                     1  \n",
       "4974                     5  \n",
       "6762                    10  \n",
       "3349                     6  \n",
       "\n",
       "[192 rows x 5 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "draft_results = manager.lg.draft_results(format='Pandas')\n",
    "\n",
    "draft_results\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Logging in\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "INFO:csh_fantasy_bot.yahoo_scraping:Setting username: craig_hamilton2000@yahoo.com\n",
      "/Users/craigh/dev/fantasy_bot/venv/lib/python3.8/site-packages/selenium/webdriver/remote/webelement.py:393: UserWarning: find_element_by_* commands are deprecated. Please use find_element() instead\n",
      "  warnings.warn(\"find_element_by_* commands are deprecated. Please use find_element() instead\")\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<csh_fantasy_bot.yahoo_scraping.YahooPredictions at 0x7faef91b7b20>"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_projections = YahooPredictions(league_id, predition_type=PredictionType.rest_season)\n",
    "y_projections"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "projected_draft = draft_results.merge(y_projections.all_players[['preseason_rank', 'current_rank','name'] + manager.lg.scoring_categories()], left_index=True, right_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>pick</th>\n",
       "      <th>round</th>\n",
       "      <th>team_key</th>\n",
       "      <th>player_key</th>\n",
       "      <th>fantasy_team_id</th>\n",
       "      <th>preseason_rank</th>\n",
       "      <th>current_rank</th>\n",
       "      <th>name</th>\n",
       "      <th>G</th>\n",
       "      <th>A</th>\n",
       "      <th>+/-</th>\n",
       "      <th>PPP</th>\n",
       "      <th>SOG</th>\n",
       "      <th>HIT</th>\n",
       "      <th>draft_value</th>\n",
       "      <th>draft_value_clipped</th>\n",
       "      <th>draft_value_clipped_30</th>\n",
       "      <th>draft_value_clipped_50</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>player_id</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",
       "      <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>6743</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.6</td>\n",
       "      <td>411.p.6743</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Connor McDavid</td>\n",
       "      <td>0.512195</td>\n",
       "      <td>0.951219</td>\n",
       "      <td>0.268293</td>\n",
       "      <td>0.634146</td>\n",
       "      <td>3.487805</td>\n",
       "      <td>0.951219</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6369</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.10</td>\n",
       "      <td>411.p.6369</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Leon Draisaitl</td>\n",
       "      <td>0.575000</td>\n",
       "      <td>0.825000</td>\n",
       "      <td>0.237500</td>\n",
       "      <td>0.512500</td>\n",
       "      <td>3.187500</td>\n",
       "      <td>0.700000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5980</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.5</td>\n",
       "      <td>411.p.5980</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Nathan MacKinnon</td>\n",
       "      <td>0.507246</td>\n",
       "      <td>0.782609</td>\n",
       "      <td>0.246377</td>\n",
       "      <td>0.521739</td>\n",
       "      <td>4.420290</td>\n",
       "      <td>0.753623</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5425</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.1</td>\n",
       "      <td>411.p.5425</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>17</td>\n",
       "      <td>Nikita Kucherov</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.843750</td>\n",
       "      <td>0.312500</td>\n",
       "      <td>0.578125</td>\n",
       "      <td>3.015625</td>\n",
       "      <td>0.531250</td>\n",
       "      <td>-13</td>\n",
       "      <td>-13</td>\n",
       "      <td>-13</td>\n",
       "      <td>-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7109</th>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.11</td>\n",
       "      <td>411.p.7109</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>Auston Matthews</td>\n",
       "      <td>0.739726</td>\n",
       "      <td>0.479452</td>\n",
       "      <td>0.315068</td>\n",
       "      <td>0.315068</td>\n",
       "      <td>4.205480</td>\n",
       "      <td>0.931507</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6391</th>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.12</td>\n",
       "      <td>411.p.6391</td>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>David Pastrnak</td>\n",
       "      <td>0.586667</td>\n",
       "      <td>0.613333</td>\n",
       "      <td>0.226667</td>\n",
       "      <td>0.453333</td>\n",
       "      <td>3.706667</td>\n",
       "      <td>0.720000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6752</th>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.9</td>\n",
       "      <td>411.p.6752</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>Mikko Rantanen</td>\n",
       "      <td>0.565789</td>\n",
       "      <td>0.684211</td>\n",
       "      <td>0.236842</td>\n",
       "      <td>0.486842</td>\n",
       "      <td>3.236842</td>\n",
       "      <td>0.552632</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6728</th>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.8</td>\n",
       "      <td>411.p.6728</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>Artemi Panarin</td>\n",
       "      <td>0.423077</td>\n",
       "      <td>0.948718</td>\n",
       "      <td>0.346154</td>\n",
       "      <td>0.384615</td>\n",
       "      <td>2.769231</td>\n",
       "      <td>0.294872</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4351</th>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.4</td>\n",
       "      <td>411.p.4351</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>6</td>\n",
       "      <td>Brad Marchand</td>\n",
       "      <td>0.532468</td>\n",
       "      <td>0.740260</td>\n",
       "      <td>0.324675</td>\n",
       "      <td>0.350649</td>\n",
       "      <td>2.948052</td>\n",
       "      <td>1.103896</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3637</th>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.7</td>\n",
       "      <td>411.p.3637</td>\n",
       "      <td>7</td>\n",
       "      <td>12</td>\n",
       "      <td>11</td>\n",
       "      <td>Alex Ovechkin</td>\n",
       "      <td>0.594937</td>\n",
       "      <td>0.417722</td>\n",
       "      <td>-0.126582</td>\n",
       "      <td>0.316456</td>\n",
       "      <td>4.025316</td>\n",
       "      <td>2.443038</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7519</th>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.3</td>\n",
       "      <td>411.p.7519</td>\n",
       "      <td>3</td>\n",
       "      <td>13</td>\n",
       "      <td>35</td>\n",
       "      <td>Cale Makar</td>\n",
       "      <td>0.191781</td>\n",
       "      <td>0.780822</td>\n",
       "      <td>0.205479</td>\n",
       "      <td>0.438356</td>\n",
       "      <td>2.315068</td>\n",
       "      <td>1.054795</td>\n",
       "      <td>-23</td>\n",
       "      <td>-23</td>\n",
       "      <td>-23</td>\n",
       "      <td>-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4240</th>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>411.l.85094.t.3</td>\n",
       "      <td>411.p.4240</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>16</td>\n",
       "      <td>Patrick Kane</td>\n",
       "      <td>0.444444</td>\n",
       "      <td>0.703704</td>\n",
       "      <td>0.049383</td>\n",
       "      <td>0.370370</td>\n",
       "      <td>3.604938</td>\n",
       "      <td>0.246914</td>\n",
       "      <td>-3</td>\n",
       "      <td>-3</td>\n",
       "      <td>-3</td>\n",
       "      <td>-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6746</th>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>411.l.85094.t.7</td>\n",
       "      <td>411.p.6746</td>\n",
       "      <td>7</td>\n",
       "      <td>14</td>\n",
       "      <td>13</td>\n",
       "      <td>Mitchell Marner</td>\n",
       "      <td>0.353659</td>\n",
       "      <td>0.853659</td>\n",
       "      <td>0.231707</td>\n",
       "      <td>0.329268</td>\n",
       "      <td>2.865854</td>\n",
       "      <td>0.402439</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5364</th>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>411.l.85094.t.4</td>\n",
       "      <td>411.p.5364</td>\n",
       "      <td>4</td>\n",
       "      <td>15</td>\n",
       "      <td>14</td>\n",
       "      <td>Jonathan Huberdeau</td>\n",
       "      <td>0.365854</td>\n",
       "      <td>0.743902</td>\n",
       "      <td>0.158537</td>\n",
       "      <td>0.439024</td>\n",
       "      <td>2.353658</td>\n",
       "      <td>0.878049</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6448</th>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>411.l.85094.t.8</td>\n",
       "      <td>411.p.6448</td>\n",
       "      <td>8</td>\n",
       "      <td>18</td>\n",
       "      <td>28</td>\n",
       "      <td>Brayden Point</td>\n",
       "      <td>0.412500</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.325000</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>2.325000</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>-12</td>\n",
       "      <td>-12</td>\n",
       "      <td>-12</td>\n",
       "      <td>-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6777</th>\n",
       "      <td>17</td>\n",
       "      <td>2</td>\n",
       "      <td>411.l.85094.t.9</td>\n",
       "      <td>411.p.6777</td>\n",
       "      <td>9</td>\n",
       "      <td>17</td>\n",
       "      <td>23</td>\n",
       "      <td>Sebastian Aho</td>\n",
       "      <td>0.437500</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.175000</td>\n",
       "      <td>0.325000</td>\n",
       "      <td>2.750000</td>\n",
       "      <td>0.762500</td>\n",
       "      <td>-6</td>\n",
       "      <td>-6</td>\n",
       "      <td>-6</td>\n",
       "      <td>-6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5367</th>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>411.l.85094.t.2</td>\n",
       "      <td>411.p.5367</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>30</td>\n",
       "      <td>Mika Zibanejad</td>\n",
       "      <td>0.466667</td>\n",
       "      <td>0.493333</td>\n",
       "      <td>0.066667</td>\n",
       "      <td>0.346667</td>\n",
       "      <td>3.173333</td>\n",
       "      <td>1.306667</td>\n",
       "      <td>-10</td>\n",
       "      <td>-10</td>\n",
       "      <td>-10</td>\n",
       "      <td>-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4503</th>\n",
       "      <td>21</td>\n",
       "      <td>2</td>\n",
       "      <td>411.l.85094.t.1</td>\n",
       "      <td>411.p.4503</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>79</td>\n",
       "      <td>John Carlson</td>\n",
       "      <td>0.189189</td>\n",
       "      <td>0.702703</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.337838</td>\n",
       "      <td>2.500000</td>\n",
       "      <td>0.918919</td>\n",
       "      <td>-58</td>\n",
       "      <td>-30</td>\n",
       "      <td>-30</td>\n",
       "      <td>-50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7174</th>\n",
       "      <td>22</td>\n",
       "      <td>2</td>\n",
       "      <td>411.l.85094.t.5</td>\n",
       "      <td>411.p.7174</td>\n",
       "      <td>5</td>\n",
       "      <td>22</td>\n",
       "      <td>58</td>\n",
       "      <td>Adam Fox</td>\n",
       "      <td>0.098765</td>\n",
       "      <td>0.691358</td>\n",
       "      <td>0.259259</td>\n",
       "      <td>0.345679</td>\n",
       "      <td>1.851852</td>\n",
       "      <td>0.444444</td>\n",
       "      <td>-36</td>\n",
       "      <td>-30</td>\n",
       "      <td>-30</td>\n",
       "      <td>-36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7902</th>\n",
       "      <td>23</td>\n",
       "      <td>2</td>\n",
       "      <td>411.l.85094.t.10</td>\n",
       "      <td>411.p.7902</td>\n",
       "      <td>10</td>\n",
       "      <td>23</td>\n",
       "      <td>21</td>\n",
       "      <td>Brady Tkachuk</td>\n",
       "      <td>0.312500</td>\n",
       "      <td>0.350000</td>\n",
       "      <td>-0.187500</td>\n",
       "      <td>0.175000</td>\n",
       "      <td>3.800000</td>\n",
       "      <td>4.225000</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5981</th>\n",
       "      <td>24</td>\n",
       "      <td>2</td>\n",
       "      <td>411.l.85094.t.6</td>\n",
       "      <td>411.p.5981</td>\n",
       "      <td>6</td>\n",
       "      <td>16</td>\n",
       "      <td>18</td>\n",
       "      <td>Aleksander Barkov</td>\n",
       "      <td>0.493506</td>\n",
       "      <td>0.649351</td>\n",
       "      <td>0.129870</td>\n",
       "      <td>0.363636</td>\n",
       "      <td>3.415584</td>\n",
       "      <td>0.545455</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           pick  round          team_key  player_key  fantasy_team_id  \\\n",
       "player_id                                                               \n",
       "6743          1      1   411.l.85094.t.6  411.p.6743                6   \n",
       "6369          2      1  411.l.85094.t.10  411.p.6369               10   \n",
       "5980          3      1   411.l.85094.t.5  411.p.5980                5   \n",
       "5425          4      1   411.l.85094.t.1  411.p.5425                1   \n",
       "7109          6      1  411.l.85094.t.11  411.p.7109               11   \n",
       "6391          7      1  411.l.85094.t.12  411.p.6391               12   \n",
       "6752          8      1   411.l.85094.t.9  411.p.6752                9   \n",
       "6728          9      1   411.l.85094.t.8  411.p.6728                8   \n",
       "4351         10      1   411.l.85094.t.4  411.p.4351                4   \n",
       "3637         11      1   411.l.85094.t.7  411.p.3637                7   \n",
       "7519         12      1   411.l.85094.t.3  411.p.7519                3   \n",
       "4240         13      2   411.l.85094.t.3  411.p.4240                3   \n",
       "6746         14      2   411.l.85094.t.7  411.p.6746                7   \n",
       "5364         15      2   411.l.85094.t.4  411.p.5364                4   \n",
       "6448         16      2   411.l.85094.t.8  411.p.6448                8   \n",
       "6777         17      2   411.l.85094.t.9  411.p.6777                9   \n",
       "5367         20      2   411.l.85094.t.2  411.p.5367                2   \n",
       "4503         21      2   411.l.85094.t.1  411.p.4503                1   \n",
       "7174         22      2   411.l.85094.t.5  411.p.7174                5   \n",
       "7902         23      2  411.l.85094.t.10  411.p.7902               10   \n",
       "5981         24      2   411.l.85094.t.6  411.p.5981                6   \n",
       "\n",
       "           preseason_rank  current_rank                name         G  \\\n",
       "player_id                                                               \n",
       "6743                    1             1      Connor McDavid  0.512195   \n",
       "6369                    2             2      Leon Draisaitl  0.575000   \n",
       "5980                    3             3    Nathan MacKinnon  0.507246   \n",
       "5425                    4            17     Nikita Kucherov  0.500000   \n",
       "7109                   10             5     Auston Matthews  0.739726   \n",
       "6391                    8             7      David Pastrnak  0.586667   \n",
       "6752                    7             8      Mikko Rantanen  0.565789   \n",
       "6728                    6             9      Artemi Panarin  0.423077   \n",
       "4351                   11             6       Brad Marchand  0.532468   \n",
       "3637                   12            11       Alex Ovechkin  0.594937   \n",
       "7519                   13            35          Cale Makar  0.191781   \n",
       "4240                    9            16        Patrick Kane  0.444444   \n",
       "6746                   14            13     Mitchell Marner  0.353659   \n",
       "5364                   15            14  Jonathan Huberdeau  0.365854   \n",
       "6448                   18            28       Brayden Point  0.412500   \n",
       "6777                   17            23       Sebastian Aho  0.437500   \n",
       "5367                   19            30      Mika Zibanejad  0.466667   \n",
       "4503                   21            79        John Carlson  0.189189   \n",
       "7174                   22            58            Adam Fox  0.098765   \n",
       "7902                   23            21       Brady Tkachuk  0.312500   \n",
       "5981                   16            18   Aleksander Barkov  0.493506   \n",
       "\n",
       "                  A       +/-       PPP       SOG       HIT  draft_value  \\\n",
       "player_id                                                                  \n",
       "6743       0.951219  0.268293  0.634146  3.487805  0.951219            0   \n",
       "6369       0.825000  0.237500  0.512500  3.187500  0.700000            0   \n",
       "5980       0.782609  0.246377  0.521739  4.420290  0.753623            0   \n",
       "5425       0.843750  0.312500  0.578125  3.015625  0.531250          -13   \n",
       "7109       0.479452  0.315068  0.315068  4.205480  0.931507            1   \n",
       "6391       0.613333  0.226667  0.453333  3.706667  0.720000            0   \n",
       "6752       0.684211  0.236842  0.486842  3.236842  0.552632            0   \n",
       "6728       0.948718  0.346154  0.384615  2.769231  0.294872            0   \n",
       "4351       0.740260  0.324675  0.350649  2.948052  1.103896            4   \n",
       "3637       0.417722 -0.126582  0.316456  4.025316  2.443038            0   \n",
       "7519       0.780822  0.205479  0.438356  2.315068  1.054795          -23   \n",
       "4240       0.703704  0.049383  0.370370  3.604938  0.246914           -3   \n",
       "6746       0.853659  0.231707  0.329268  2.865854  0.402439            1   \n",
       "5364       0.743902  0.158537  0.439024  2.353658  0.878049            1   \n",
       "6448       0.600000  0.325000  0.300000  2.325000  0.400000          -12   \n",
       "6777       0.600000  0.175000  0.325000  2.750000  0.762500           -6   \n",
       "5367       0.493333  0.066667  0.346667  3.173333  1.306667          -10   \n",
       "4503       0.702703  0.000000  0.337838  2.500000  0.918919          -58   \n",
       "7174       0.691358  0.259259  0.345679  1.851852  0.444444          -36   \n",
       "7902       0.350000 -0.187500  0.175000  3.800000  4.225000            2   \n",
       "5981       0.649351  0.129870  0.363636  3.415584  0.545455            6   \n",
       "\n",
       "           draft_value_clipped  draft_value_clipped_30  draft_value_clipped_50  \n",
       "player_id                                                                       \n",
       "6743                         0                       0                       0  \n",
       "6369                         0                       0                       0  \n",
       "5980                         0                       0                       0  \n",
       "5425                       -13                     -13                     -13  \n",
       "7109                         1                       1                       1  \n",
       "6391                         0                       0                       0  \n",
       "6752                         0                       0                       0  \n",
       "6728                         0                       0                       0  \n",
       "4351                         4                       4                       4  \n",
       "3637                         0                       0                       0  \n",
       "7519                       -23                     -23                     -23  \n",
       "4240                        -3                      -3                      -3  \n",
       "6746                         1                       1                       1  \n",
       "5364                         1                       1                       1  \n",
       "6448                       -12                     -12                     -12  \n",
       "6777                        -6                      -6                      -6  \n",
       "5367                       -10                     -10                     -10  \n",
       "4503                       -30                     -30                     -50  \n",
       "7174                       -30                     -30                     -36  \n",
       "7902                         2                       2                       2  \n",
       "5981                         6                       6                       6  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "projected_draft['draft_value'] = projected_draft['pick'] - projected_draft['current_rank']\n",
    "projected_draft['draft_value_clipped_30'] = projected_draft['draft_value'].clip(-30,30)\n",
    "projected_draft['draft_value_clipped_50'] = projected_draft['draft_value'].clip(-50,50)\n",
    "projected_draft[projected_draft.pick < 25]\n",
    "\n",
    "# projected_draft.current_rank.dtype\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>pick</th>\n",
       "      <th>round</th>\n",
       "      <th>team_key</th>\n",
       "      <th>player_key</th>\n",
       "      <th>fantasy_team_id</th>\n",
       "      <th>preseason_rank</th>\n",
       "      <th>current_rank</th>\n",
       "      <th>name</th>\n",
       "      <th>G</th>\n",
       "      <th>A</th>\n",
       "      <th>+/-</th>\n",
       "      <th>PPP</th>\n",
       "      <th>SOG</th>\n",
       "      <th>HIT</th>\n",
       "      <th>draft_value</th>\n",
       "      <th>draft_value_clipped</th>\n",
       "      <th>draft_value_clipped_30</th>\n",
       "      <th>draft_value_clipped_50</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>player_id</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",
       "      <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>6391</th>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>411.l.85094.t.12</td>\n",
       "      <td>411.p.6391</td>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>David Pastrnak</td>\n",
       "      <td>0.586667</td>\n",
       "      <td>0.613333</td>\n",
       "      <td>0.226667</td>\n",
       "      <td>0.453333</td>\n",
       "      <td>3.706667</td>\n",
       "      <td>0.720000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4682</th>\n",
       "      <td>31</td>\n",
       "      <td>3</td>\n",
       "      <td>411.l.85094.t.12</td>\n",
       "      <td>411.p.4682</td>\n",
       "      <td>12</td>\n",
       "      <td>29</td>\n",
       "      <td>33</td>\n",
       "      <td>Victor Hedman</td>\n",
       "      <td>0.173333</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>0.346667</td>\n",
       "      <td>0.413333</td>\n",
       "      <td>2.506667</td>\n",
       "      <td>0.973333</td>\n",
       "      <td>-2</td>\n",
       "      <td>-2</td>\n",
       "      <td>-2</td>\n",
       "      <td>-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7905</th>\n",
       "      <td>42</td>\n",
       "      <td>4</td>\n",
       "      <td>411.l.85094.t.12</td>\n",
       "      <td>411.p.7905</td>\n",
       "      <td>12</td>\n",
       "      <td>41</td>\n",
       "      <td>203</td>\n",
       "      <td>Quinn Hughes</td>\n",
       "      <td>0.116883</td>\n",
       "      <td>0.688312</td>\n",
       "      <td>-0.207792</td>\n",
       "      <td>0.376623</td>\n",
       "      <td>1.883117</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>-161</td>\n",
       "      <td>-30</td>\n",
       "      <td>-30</td>\n",
       "      <td>-50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5470</th>\n",
       "      <td>55</td>\n",
       "      <td>5</td>\n",
       "      <td>411.l.85094.t.12</td>\n",
       "      <td>411.p.5470</td>\n",
       "      <td>12</td>\n",
       "      <td>63</td>\n",
       "      <td>70</td>\n",
       "      <td>Johnny Gaudreau</td>\n",
       "      <td>0.345679</td>\n",
       "      <td>0.567901</td>\n",
       "      <td>0.037037</td>\n",
       "      <td>0.308642</td>\n",
       "      <td>2.395062</td>\n",
       "      <td>0.123457</td>\n",
       "      <td>-15</td>\n",
       "      <td>-15</td>\n",
       "      <td>-15</td>\n",
       "      <td>-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4962</th>\n",
       "      <td>66</td>\n",
       "      <td>6</td>\n",
       "      <td>411.l.85094.t.12</td>\n",
       "      <td>411.p.4962</td>\n",
       "      <td>12</td>\n",
       "      <td>101</td>\n",
       "      <td>25</td>\n",
       "      <td>Tyler Seguin</td>\n",
       "      <td>0.363636</td>\n",
       "      <td>0.467532</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>3.688312</td>\n",
       "      <td>1.376623</td>\n",
       "      <td>41</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4064</th>\n",
       "      <td>79</td>\n",
       "      <td>7</td>\n",
       "      <td>411.l.85094.t.12</td>\n",
       "      <td>411.p.4064</td>\n",
       "      <td>12</td>\n",
       "      <td>84</td>\n",
       "      <td>68</td>\n",
       "      <td>Kris Letang</td>\n",
       "      <td>0.169014</td>\n",
       "      <td>0.549296</td>\n",
       "      <td>0.211268</td>\n",
       "      <td>0.253521</td>\n",
       "      <td>2.563380</td>\n",
       "      <td>1.690141</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3641</th>\n",
       "      <td>90</td>\n",
       "      <td>8</td>\n",
       "      <td>411.l.85094.t.12</td>\n",
       "      <td>411.p.3641</td>\n",
       "      <td>12</td>\n",
       "      <td>104</td>\n",
       "      <td>67</td>\n",
       "      <td>Blake Wheeler</td>\n",
       "      <td>0.293333</td>\n",
       "      <td>0.626667</td>\n",
       "      <td>-0.040000</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>2.360000</td>\n",
       "      <td>1.253333</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4961</th>\n",
       "      <td>103</td>\n",
       "      <td>9</td>\n",
       "      <td>411.l.85094.t.12</td>\n",
       "      <td>411.p.4961</td>\n",
       "      <td>12</td>\n",
       "      <td>123</td>\n",
       "      <td>45</td>\n",
       "      <td>Taylor Hall</td>\n",
       "      <td>0.346667</td>\n",
       "      <td>0.520000</td>\n",
       "      <td>0.186667</td>\n",
       "      <td>0.266667</td>\n",
       "      <td>3.080000</td>\n",
       "      <td>0.653333</td>\n",
       "      <td>58</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7110</th>\n",
       "      <td>114</td>\n",
       "      <td>10</td>\n",
       "      <td>411.l.85094.t.12</td>\n",
       "      <td>411.p.7110</td>\n",
       "      <td>12</td>\n",
       "      <td>148</td>\n",
       "      <td>95</td>\n",
       "      <td>Patrik Laine</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>0.426667</td>\n",
       "      <td>-0.160000</td>\n",
       "      <td>0.320000</td>\n",
       "      <td>3.053333</td>\n",
       "      <td>0.920000</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4002</th>\n",
       "      <td>151</td>\n",
       "      <td>13</td>\n",
       "      <td>411.l.85094.t.12</td>\n",
       "      <td>411.p.4002</td>\n",
       "      <td>12</td>\n",
       "      <td>161</td>\n",
       "      <td>106</td>\n",
       "      <td>Claude Giroux</td>\n",
       "      <td>0.272727</td>\n",
       "      <td>0.519481</td>\n",
       "      <td>0.064935</td>\n",
       "      <td>0.259740</td>\n",
       "      <td>2.402597</td>\n",
       "      <td>0.584416</td>\n",
       "      <td>45</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3981</th>\n",
       "      <td>162</td>\n",
       "      <td>14</td>\n",
       "      <td>411.l.85094.t.12</td>\n",
       "      <td>411.p.3981</td>\n",
       "      <td>12</td>\n",
       "      <td>177</td>\n",
       "      <td>118</td>\n",
       "      <td>Jonathan Toews</td>\n",
       "      <td>0.301370</td>\n",
       "      <td>0.465753</td>\n",
       "      <td>0.027397</td>\n",
       "      <td>0.232877</td>\n",
       "      <td>2.835616</td>\n",
       "      <td>0.712329</td>\n",
       "      <td>44</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5987</th>\n",
       "      <td>186</td>\n",
       "      <td>16</td>\n",
       "      <td>411.l.85094.t.12</td>\n",
       "      <td>411.p.5987</td>\n",
       "      <td>12</td>\n",
       "      <td>339</td>\n",
       "      <td>179</td>\n",
       "      <td>Rasmus Ristolainen</td>\n",
       "      <td>0.077922</td>\n",
       "      <td>0.324675</td>\n",
       "      <td>-0.116883</td>\n",
       "      <td>0.155844</td>\n",
       "      <td>1.636364</td>\n",
       "      <td>3.623377</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           pick  round          team_key  player_key  fantasy_team_id  \\\n",
       "player_id                                                               \n",
       "6391          7      1  411.l.85094.t.12  411.p.6391               12   \n",
       "4682         31      3  411.l.85094.t.12  411.p.4682               12   \n",
       "7905         42      4  411.l.85094.t.12  411.p.7905               12   \n",
       "5470         55      5  411.l.85094.t.12  411.p.5470               12   \n",
       "4962         66      6  411.l.85094.t.12  411.p.4962               12   \n",
       "4064         79      7  411.l.85094.t.12  411.p.4064               12   \n",
       "3641         90      8  411.l.85094.t.12  411.p.3641               12   \n",
       "4961        103      9  411.l.85094.t.12  411.p.4961               12   \n",
       "7110        114     10  411.l.85094.t.12  411.p.7110               12   \n",
       "4002        151     13  411.l.85094.t.12  411.p.4002               12   \n",
       "3981        162     14  411.l.85094.t.12  411.p.3981               12   \n",
       "5987        186     16  411.l.85094.t.12  411.p.5987               12   \n",
       "\n",
       "           preseason_rank  current_rank                name         G  \\\n",
       "player_id                                                               \n",
       "6391                    8             7      David Pastrnak  0.586667   \n",
       "4682                   29            33       Victor Hedman  0.173333   \n",
       "7905                   41           203        Quinn Hughes  0.116883   \n",
       "5470                   63            70     Johnny Gaudreau  0.345679   \n",
       "4962                  101            25        Tyler Seguin  0.363636   \n",
       "4064                   84            68         Kris Letang  0.169014   \n",
       "3641                  104            67       Blake Wheeler  0.293333   \n",
       "4961                  123            45         Taylor Hall  0.346667   \n",
       "7110                  148            95        Patrik Laine  0.400000   \n",
       "4002                  161           106       Claude Giroux  0.272727   \n",
       "3981                  177           118      Jonathan Toews  0.301370   \n",
       "5987                  339           179  Rasmus Ristolainen  0.077922   \n",
       "\n",
       "                  A       +/-       PPP       SOG       HIT  draft_value  \\\n",
       "player_id                                                                  \n",
       "6391       0.613333  0.226667  0.453333  3.706667  0.720000            0   \n",
       "4682       0.600000  0.346667  0.413333  2.506667  0.973333           -2   \n",
       "7905       0.688312 -0.207792  0.376623  1.883117  0.285714         -161   \n",
       "5470       0.567901  0.037037  0.308642  2.395062  0.123457          -15   \n",
       "4962       0.467532  0.142857  0.285714  3.688312  1.376623           41   \n",
       "4064       0.549296  0.211268  0.253521  2.563380  1.690141           11   \n",
       "3641       0.626667 -0.040000  0.333333  2.360000  1.253333           23   \n",
       "4961       0.520000  0.186667  0.266667  3.080000  0.653333           58   \n",
       "7110       0.426667 -0.160000  0.320000  3.053333  0.920000           19   \n",
       "4002       0.519481  0.064935  0.259740  2.402597  0.584416           45   \n",
       "3981       0.465753  0.027397  0.232877  2.835616  0.712329           44   \n",
       "5987       0.324675 -0.116883  0.155844  1.636364  3.623377            7   \n",
       "\n",
       "           draft_value_clipped  draft_value_clipped_30  draft_value_clipped_50  \n",
       "player_id                                                                       \n",
       "6391                         0                       0                       0  \n",
       "4682                        -2                      -2                      -2  \n",
       "7905                       -30                     -30                     -50  \n",
       "5470                       -15                     -15                     -15  \n",
       "4962                        30                      30                      41  \n",
       "4064                        11                      11                      11  \n",
       "3641                        23                      23                      23  \n",
       "4961                        30                      30                      50  \n",
       "7110                        19                      19                      19  \n",
       "4002                        30                      30                      45  \n",
       "3981                        30                      30                      44  \n",
       "5987                         7                       7                       7  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "projected_draft[projected_draft.fantasy_team_id == 12]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>draft_value_clipped_50</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fantasy_team_id</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>-163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>-85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>-43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>173</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 draft_value_clipped_50\n",
       "fantasy_team_id                        \n",
       "1                                   -92\n",
       "2                                  -203\n",
       "3                                    76\n",
       "4                                     2\n",
       "5                                  -199\n",
       "6                                  -125\n",
       "7                                  -163\n",
       "8                                   178\n",
       "9                                  -128\n",
       "10                                  -85\n",
       "11                                  -43\n",
       "12                                  173"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "projected_draft.groupby(['fantasy_team_id']).agg({'draft_value_clipped_50': 'sum'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "scoreboard = manager.lg.scoreboard()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "ea9849012fc58500037a088c32978d576e64ddfe7880248a88430f3f0fb99280"
  },
  "kernelspec": {
   "display_name": "Python 3.8.8 64-bit ('venv': venv)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}