Player rater.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import cluj_tools as ct"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# I could easily use the boxscores from in the db instead of pulling from ESPN\n",
    "# but nice that ESPN has them as totals, still could calculate totals for players from boxscores without too much trouble"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_stats_df = ct.player_rater()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# how to properly account for fga and fta in their ranks? Did what I did make sense? doesn't appear to match up well with website\n",
    "# do I need to remove anyone when I calculate the ranks?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "cat_ranks = [#'ast_total_rank','blocks_total_rank','steals_total_rank','reb_total_rank','pts_total_rank','threes_total_rank',\n",
    "                'ast_avg_rank','blocks_avg_rank','steals_avg_rank','reb_avg_rank','pts_avg_rank','threes_avg_rank',\n",
    "                'fg_rank_adj','ft_rank_adj']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>playerName</th>\n",
       "      <th>ast_avg_rank</th>\n",
       "      <th>blocks_avg_rank</th>\n",
       "      <th>steals_avg_rank</th>\n",
       "      <th>reb_avg_rank</th>\n",
       "      <th>pts_avg_rank</th>\n",
       "      <th>threes_avg_rank</th>\n",
       "      <th>fg_rank_adj</th>\n",
       "      <th>ft_rank_adj</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>Giannis Antetokounmpo</td>\n",
       "      <td>2.114142</td>\n",
       "      <td>1.491697</td>\n",
       "      <td>1.093173</td>\n",
       "      <td>3.781604</td>\n",
       "      <td>3.210067</td>\n",
       "      <td>0.620927</td>\n",
       "      <td>2.616141</td>\n",
       "      <td>-4.520041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>Nikola Jokic</td>\n",
       "      <td>2.652002</td>\n",
       "      <td>0.555266</td>\n",
       "      <td>1.256676</td>\n",
       "      <td>2.532811</td>\n",
       "      <td>1.774487</td>\n",
       "      <td>0.307703</td>\n",
       "      <td>1.402153</td>\n",
       "      <td>0.784305</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>Julius Randle</td>\n",
       "      <td>0.696092</td>\n",
       "      <td>-0.251988</td>\n",
       "      <td>0.464881</td>\n",
       "      <td>2.199563</td>\n",
       "      <td>1.516090</td>\n",
       "      <td>0.095750</td>\n",
       "      <td>0.091825</td>\n",
       "      <td>-0.504932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>Myles Turner</td>\n",
       "      <td>-0.428919</td>\n",
       "      <td>3.620714</td>\n",
       "      <td>0.160522</td>\n",
       "      <td>0.911165</td>\n",
       "      <td>0.410179</td>\n",
       "      <td>0.504721</td>\n",
       "      <td>0.007827</td>\n",
       "      <td>0.062559</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>Taurean Prince</td>\n",
       "      <td>0.027505</td>\n",
       "      <td>-0.069344</td>\n",
       "      <td>0.749390</td>\n",
       "      <td>0.988358</td>\n",
       "      <td>0.521296</td>\n",
       "      <td>1.655958</td>\n",
       "      <td>-0.700261</td>\n",
       "      <td>-0.036933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Derrick Rose</td>\n",
       "      <td>2.105809</td>\n",
       "      <td>-0.294536</td>\n",
       "      <td>0.396987</td>\n",
       "      <td>-0.493765</td>\n",
       "      <td>1.448743</td>\n",
       "      <td>-0.048620</td>\n",
       "      <td>0.731297</td>\n",
       "      <td>0.524871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>Elfrid Payton</td>\n",
       "      <td>2.626366</td>\n",
       "      <td>0.044809</td>\n",
       "      <td>2.314193</td>\n",
       "      <td>0.371257</td>\n",
       "      <td>0.043493</td>\n",
       "      <td>-0.673210</td>\n",
       "      <td>-0.028878</td>\n",
       "      <td>0.646085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>401</th>\n",
       "      <td>Miles Bridges</td>\n",
       "      <td>-0.152706</td>\n",
       "      <td>0.763972</td>\n",
       "      <td>-0.038482</td>\n",
       "      <td>0.692780</td>\n",
       "      <td>0.570108</td>\n",
       "      <td>0.619105</td>\n",
       "      <td>-0.055365</td>\n",
       "      <td>0.079777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>Justin Holiday</td>\n",
       "      <td>-0.284610</td>\n",
       "      <td>0.511328</td>\n",
       "      <td>0.982903</td>\n",
       "      <td>-0.167016</td>\n",
       "      <td>-0.096512</td>\n",
       "      <td>1.015474</td>\n",
       "      <td>-0.015166</td>\n",
       "      <td>-0.074662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>Josh Richardson</td>\n",
       "      <td>0.725125</td>\n",
       "      <td>0.450491</td>\n",
       "      <td>0.767628</td>\n",
       "      <td>-0.206926</td>\n",
       "      <td>0.859851</td>\n",
       "      <td>0.670112</td>\n",
       "      <td>-0.096213</td>\n",
       "      <td>0.224706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Jeff Teague</td>\n",
       "      <td>2.059146</td>\n",
       "      <td>-0.206327</td>\n",
       "      <td>0.461720</td>\n",
       "      <td>-0.498307</td>\n",
       "      <td>0.404935</td>\n",
       "      <td>-0.173200</td>\n",
       "      <td>-0.075366</td>\n",
       "      <td>1.049334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>Nerlens Noel</td>\n",
       "      <td>-0.454499</td>\n",
       "      <td>2.591745</td>\n",
       "      <td>1.172847</td>\n",
       "      <td>0.592943</td>\n",
       "      <td>-0.133277</td>\n",
       "      <td>-1.081404</td>\n",
       "      <td>-0.764076</td>\n",
       "      <td>0.043121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>Matisse Thybulle</td>\n",
       "      <td>-0.421814</td>\n",
       "      <td>1.035656</td>\n",
       "      <td>2.073940</td>\n",
       "      <td>-0.880577</td>\n",
       "      <td>-0.640503</td>\n",
       "      <td>0.028884</td>\n",
       "      <td>0.165709</td>\n",
       "      <td>0.341269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Mike Conley</td>\n",
       "      <td>1.159093</td>\n",
       "      <td>-0.682087</td>\n",
       "      <td>0.189549</td>\n",
       "      <td>-0.244114</td>\n",
       "      <td>0.649268</td>\n",
       "      <td>0.908928</td>\n",
       "      <td>-0.161898</td>\n",
       "      <td>0.076836</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                playerName  ast_avg_rank  blocks_avg_rank  steals_avg_rank  \\\n",
       "223  Giannis Antetokounmpo      2.114142         1.491697         1.093173   \n",
       "267           Nikola Jokic      2.652002         0.555266         1.256676   \n",
       "254          Julius Randle      0.696092        -0.251988         0.464881   \n",
       "276           Myles Turner     -0.428919         3.620714         0.160522   \n",
       "192         Taurean Prince      0.027505        -0.069344         0.749390   \n",
       "46            Derrick Rose      2.105809        -0.294536         0.396987   \n",
       "173          Elfrid Payton      2.626366         0.044809         2.314193   \n",
       "401          Miles Bridges     -0.152706         0.763972        -0.038482   \n",
       "123         Justin Holiday     -0.284610         0.511328         0.982903   \n",
       "171        Josh Richardson      0.725125         0.450491         0.767628   \n",
       "62             Jeff Teague      2.059146        -0.206327         0.461720   \n",
       "210           Nerlens Noel     -0.454499         2.591745         1.172847   \n",
       "328       Matisse Thybulle     -0.421814         1.035656         2.073940   \n",
       "25             Mike Conley      1.159093        -0.682087         0.189549   \n",
       "\n",
       "     reb_avg_rank  pts_avg_rank  threes_avg_rank  fg_rank_adj  ft_rank_adj  \n",
       "223      3.781604      3.210067         0.620927     2.616141    -4.520041  \n",
       "267      2.532811      1.774487         0.307703     1.402153     0.784305  \n",
       "254      2.199563      1.516090         0.095750     0.091825    -0.504932  \n",
       "276      0.911165      0.410179         0.504721     0.007827     0.062559  \n",
       "192      0.988358      0.521296         1.655958    -0.700261    -0.036933  \n",
       "46      -0.493765      1.448743        -0.048620     0.731297     0.524871  \n",
       "173      0.371257      0.043493        -0.673210    -0.028878     0.646085  \n",
       "401      0.692780      0.570108         0.619105    -0.055365     0.079777  \n",
       "123     -0.167016     -0.096512         1.015474    -0.015166    -0.074662  \n",
       "171     -0.206926      0.859851         0.670112    -0.096213     0.224706  \n",
       "62      -0.498307      0.404935        -0.173200    -0.075366     1.049334  \n",
       "210      0.592943     -0.133277        -1.081404    -0.764076     0.043121  \n",
       "328     -0.880577     -0.640503         0.028884     0.165709     0.341269  \n",
       "25      -0.244114      0.649268         0.908928    -0.161898     0.076836  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "team = final_stats_df.loc[final_stats_df.onTeamId==10][['playerName']+cat_ranks]\n",
    "team"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ast_avg_rank       12.422731\n",
       "blocks_avg_rank     9.561398\n",
       "steals_avg_rank    12.045927\n",
       "reb_avg_rank        9.579775\n",
       "pts_avg_rank       10.538226\n",
       "threes_avg_rank     4.451128\n",
       "fg_rank_adj         3.117729\n",
       "ft_rank_adj        -1.303705\n",
       "dtype: float64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "team[cat_ranks].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(14, 18)\n",
      "(13, 18)\n",
      "(13, 18)\n",
      "(14, 18)\n",
      "(14, 18)\n",
      "(11, 18)\n",
      "(14, 18)\n",
      "(14, 18)\n",
      "(14, 18)\n",
      "(14, 18)\n",
      "(14, 18)\n",
      "(14, 18)\n"
     ]
    }
   ],
   "source": [
    "team_stats_list = []\n",
    "for team_id in range(1, 13):\n",
    "    team_stats = final_stats_df.loc[(final_stats_df.onTeamId==team_id) & (final_stats_df.injuryStatus!= 'OUT')]\n",
    "    team_stats = final_stats_df.loc[(final_stats_df.onTeamId==team_id)]\n",
    "    print(team_stats.shape)\n",
    "    team_stats_list.append(team_stats[cat_ranks].sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "team_rater = pd.concat(team_stats_list, axis=1).transpose()\n",
    "team_ranks = team_rater.rank(ascending=False)\n",
    "team_rater['teamId'] = list(range(1,13))\n",
    "team_ranks['teamId'] = list(range(1,13))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ast_avg_rank</th>\n",
       "      <th>blocks_avg_rank</th>\n",
       "      <th>steals_avg_rank</th>\n",
       "      <th>reb_avg_rank</th>\n",
       "      <th>pts_avg_rank</th>\n",
       "      <th>threes_avg_rank</th>\n",
       "      <th>fg_rank_adj</th>\n",
       "      <th>ft_rank_adj</th>\n",
       "      <th>teamId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>8.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>9.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>11.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    ast_avg_rank  blocks_avg_rank  steals_avg_rank  reb_avg_rank  \\\n",
       "0            4.0              5.0              3.0          10.0   \n",
       "1           12.0              3.0             11.0           4.0   \n",
       "2            2.0              8.0              7.0           8.0   \n",
       "3            7.0              2.0             12.0           1.0   \n",
       "4            1.0              9.0              4.0           9.0   \n",
       "5            6.0             10.0              9.0          12.0   \n",
       "6            8.0              7.0              6.0           7.0   \n",
       "7            9.0              1.0              1.0           5.0   \n",
       "8           11.0              6.0              8.0           2.0   \n",
       "9            5.0              4.0              2.0           6.0   \n",
       "10          10.0             12.0             10.0          11.0   \n",
       "11           3.0             11.0              5.0           3.0   \n",
       "\n",
       "    pts_avg_rank  threes_avg_rank  fg_rank_adj  ft_rank_adj  teamId  \n",
       "0           10.0             11.0          1.0          4.0       1  \n",
       "1            5.0              7.0         11.0         11.0       2  \n",
       "2            8.0              9.0          8.0          8.0       3  \n",
       "3            2.0              5.0         10.0          3.0       4  \n",
       "4            3.0              1.0          5.0          6.0       5  \n",
       "5           12.0              4.0          6.0          9.0       6  \n",
       "6            6.0              3.0          9.0          2.0       7  \n",
       "7            7.0              8.0         12.0         10.0       8  \n",
       "8            9.0             10.0          3.0          5.0       9  \n",
       "9           11.0             12.0          2.0         12.0      10  \n",
       "10           4.0              6.0          7.0          7.0      11  \n",
       "11           1.0              2.0          4.0          1.0      12  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# write something to figure out which team is my worst matchup\n",
    "# rebs, asts, and blocks are the two cats I'm trying to be good at, that I'm just mediocre\n",
    "# steals and fg% I'm good\n",
    "team_ranks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ast_avg_rank</th>\n",
       "      <th>blocks_avg_rank</th>\n",
       "      <th>steals_avg_rank</th>\n",
       "      <th>reb_avg_rank</th>\n",
       "      <th>pts_avg_rank</th>\n",
       "      <th>threes_avg_rank</th>\n",
       "      <th>fg_rank_adj</th>\n",
       "      <th>ft_rank_adj</th>\n",
       "      <th>teamId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12.689961</td>\n",
       "      <td>8.756164</td>\n",
       "      <td>11.931934</td>\n",
       "      <td>7.875827</td>\n",
       "      <td>11.742054</td>\n",
       "      <td>5.008333</td>\n",
       "      <td>4.262045</td>\n",
       "      <td>6.029185</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4.781144</td>\n",
       "      <td>9.647064</td>\n",
       "      <td>6.503909</td>\n",
       "      <td>13.724102</td>\n",
       "      <td>14.201196</td>\n",
       "      <td>8.312101</td>\n",
       "      <td>1.018912</td>\n",
       "      <td>-0.837052</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14.145451</td>\n",
       "      <td>4.790364</td>\n",
       "      <td>9.025349</td>\n",
       "      <td>9.046886</td>\n",
       "      <td>12.611023</td>\n",
       "      <td>6.501060</td>\n",
       "      <td>1.624442</td>\n",
       "      <td>2.814049</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9.702601</td>\n",
       "      <td>11.944844</td>\n",
       "      <td>5.857848</td>\n",
       "      <td>18.223478</td>\n",
       "      <td>18.874046</td>\n",
       "      <td>11.095110</td>\n",
       "      <td>1.132359</td>\n",
       "      <td>7.505519</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>17.260794</td>\n",
       "      <td>4.640478</td>\n",
       "      <td>10.491929</td>\n",
       "      <td>8.941658</td>\n",
       "      <td>15.947355</td>\n",
       "      <td>13.923817</td>\n",
       "      <td>2.284808</td>\n",
       "      <td>4.442630</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>11.099192</td>\n",
       "      <td>2.350755</td>\n",
       "      <td>8.648835</td>\n",
       "      <td>7.009068</td>\n",
       "      <td>9.235414</td>\n",
       "      <td>11.168371</td>\n",
       "      <td>1.688675</td>\n",
       "      <td>1.110971</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>9.217345</td>\n",
       "      <td>6.123650</td>\n",
       "      <td>9.066628</td>\n",
       "      <td>9.345756</td>\n",
       "      <td>13.975470</td>\n",
       "      <td>12.247638</td>\n",
       "      <td>1.222845</td>\n",
       "      <td>9.840196</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7.968571</td>\n",
       "      <td>14.120435</td>\n",
       "      <td>14.591802</td>\n",
       "      <td>12.909079</td>\n",
       "      <td>12.703641</td>\n",
       "      <td>7.500565</td>\n",
       "      <td>0.219232</td>\n",
       "      <td>-0.237533</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>7.200725</td>\n",
       "      <td>6.299795</td>\n",
       "      <td>8.807542</td>\n",
       "      <td>13.994622</td>\n",
       "      <td>12.553296</td>\n",
       "      <td>5.464442</td>\n",
       "      <td>2.887062</td>\n",
       "      <td>5.465954</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>12.422731</td>\n",
       "      <td>9.561398</td>\n",
       "      <td>12.045927</td>\n",
       "      <td>9.579775</td>\n",
       "      <td>10.538226</td>\n",
       "      <td>4.451128</td>\n",
       "      <td>3.117729</td>\n",
       "      <td>-1.303705</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>7.348915</td>\n",
       "      <td>0.501473</td>\n",
       "      <td>8.434635</td>\n",
       "      <td>7.295396</td>\n",
       "      <td>15.308901</td>\n",
       "      <td>10.789971</td>\n",
       "      <td>1.652927</td>\n",
       "      <td>3.669777</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>13.285562</td>\n",
       "      <td>0.997040</td>\n",
       "      <td>9.845777</td>\n",
       "      <td>13.915550</td>\n",
       "      <td>21.501685</td>\n",
       "      <td>13.578631</td>\n",
       "      <td>2.560933</td>\n",
       "      <td>13.295791</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    ast_avg_rank  blocks_avg_rank  steals_avg_rank  reb_avg_rank  \\\n",
       "0      12.689961         8.756164        11.931934      7.875827   \n",
       "1       4.781144         9.647064         6.503909     13.724102   \n",
       "2      14.145451         4.790364         9.025349      9.046886   \n",
       "3       9.702601        11.944844         5.857848     18.223478   \n",
       "4      17.260794         4.640478        10.491929      8.941658   \n",
       "5      11.099192         2.350755         8.648835      7.009068   \n",
       "6       9.217345         6.123650         9.066628      9.345756   \n",
       "7       7.968571        14.120435        14.591802     12.909079   \n",
       "8       7.200725         6.299795         8.807542     13.994622   \n",
       "9      12.422731         9.561398        12.045927      9.579775   \n",
       "10      7.348915         0.501473         8.434635      7.295396   \n",
       "11     13.285562         0.997040         9.845777     13.915550   \n",
       "\n",
       "    pts_avg_rank  threes_avg_rank  fg_rank_adj  ft_rank_adj  teamId  \n",
       "0      11.742054         5.008333     4.262045     6.029185       1  \n",
       "1      14.201196         8.312101     1.018912    -0.837052       2  \n",
       "2      12.611023         6.501060     1.624442     2.814049       3  \n",
       "3      18.874046        11.095110     1.132359     7.505519       4  \n",
       "4      15.947355        13.923817     2.284808     4.442630       5  \n",
       "5       9.235414        11.168371     1.688675     1.110971       6  \n",
       "6      13.975470        12.247638     1.222845     9.840196       7  \n",
       "7      12.703641         7.500565     0.219232    -0.237533       8  \n",
       "8      12.553296         5.464442     2.887062     5.465954       9  \n",
       "9      10.538226         4.451128     3.117729    -1.303705      10  \n",
       "10     15.308901        10.789971     1.652927     3.669777      11  \n",
       "11     21.501685        13.578631     2.560933    13.295791      12  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "team_rater"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>playerName</th>\n",
       "      <th>ast_avg_rank</th>\n",
       "      <th>blocks_avg_rank</th>\n",
       "      <th>steals_avg_rank</th>\n",
       "      <th>reb_avg_rank</th>\n",
       "      <th>pts_avg_rank</th>\n",
       "      <th>threes_avg_rank</th>\n",
       "      <th>fg_rank_adj</th>\n",
       "      <th>ft_rank_adj</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>P.J. Tucker</td>\n",
       "      <td>-0.205588</td>\n",
       "      <td>0.047444</td>\n",
       "      <td>1.310203</td>\n",
       "      <td>1.279218</td>\n",
       "      <td>-0.260684</td>\n",
       "      <td>0.553525</td>\n",
       "      <td>-0.010209</td>\n",
       "      <td>-0.256980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408</th>\n",
       "      <td>Markelle Fultz</td>\n",
       "      <td>1.550074</td>\n",
       "      <td>-0.579519</td>\n",
       "      <td>1.589241</td>\n",
       "      <td>-0.111692</td>\n",
       "      <td>0.398628</td>\n",
       "      <td>-0.561338</td>\n",
       "      <td>0.133652</td>\n",
       "      <td>-0.002328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>PJ Washington</td>\n",
       "      <td>0.018159</td>\n",
       "      <td>0.932157</td>\n",
       "      <td>0.622942</td>\n",
       "      <td>0.648505</td>\n",
       "      <td>0.442516</td>\n",
       "      <td>0.382531</td>\n",
       "      <td>0.127871</td>\n",
       "      <td>-0.256816</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>Mikal Bridges</td>\n",
       "      <td>-0.222350</td>\n",
       "      <td>0.291638</td>\n",
       "      <td>1.986739</td>\n",
       "      <td>0.054281</td>\n",
       "      <td>-0.203840</td>\n",
       "      <td>-0.357173</td>\n",
       "      <td>0.023001</td>\n",
       "      <td>0.074089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>Maxi Kleber</td>\n",
       "      <td>-0.522876</td>\n",
       "      <td>1.525284</td>\n",
       "      <td>-0.829090</td>\n",
       "      <td>0.625114</td>\n",
       "      <td>-0.003464</td>\n",
       "      <td>0.750266</td>\n",
       "      <td>0.030765</td>\n",
       "      <td>-0.094586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>Josh Okogie</td>\n",
       "      <td>-0.252210</td>\n",
       "      <td>0.015456</td>\n",
       "      <td>1.237121</td>\n",
       "      <td>0.219426</td>\n",
       "      <td>-0.074904</td>\n",
       "      <td>-0.365489</td>\n",
       "      <td>-0.038167</td>\n",
       "      <td>0.327579</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         playerName  ast_avg_rank  blocks_avg_rank  steals_avg_rank  \\\n",
       "21      P.J. Tucker     -0.205588         0.047444         1.310203   \n",
       "408  Markelle Fultz      1.550074        -0.579519         1.589241   \n",
       "442   PJ Washington      0.018159         0.932157         0.622942   \n",
       "306   Mikal Bridges     -0.222350         0.291638         1.986739   \n",
       "184     Maxi Kleber     -0.522876         1.525284        -0.829090   \n",
       "380     Josh Okogie     -0.252210         0.015456         1.237121   \n",
       "\n",
       "     reb_avg_rank  pts_avg_rank  threes_avg_rank  fg_rank_adj  ft_rank_adj  \n",
       "21       1.279218     -0.260684         0.553525    -0.010209    -0.256980  \n",
       "408     -0.111692      0.398628        -0.561338     0.133652    -0.002328  \n",
       "442      0.648505      0.442516         0.382531     0.127871    -0.256816  \n",
       "306      0.054281     -0.203840        -0.357173     0.023001     0.074089  \n",
       "184      0.625114     -0.003464         0.750266     0.030765    -0.094586  \n",
       "380      0.219426     -0.074904        -0.365489    -0.038167     0.327579  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players = ['Mikal Bridges', 'Josh Okogie', 'Maxi Kleber', 'P.J. Tucker', 'PJ Washington', 'Markelle Fultz']\n",
    "final_stats_df.loc[final_stats_df.playerName.isin(players)][['playerName']+cat_ranks]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ast_avg_rank</th>\n",
       "      <th>blocks_avg_rank</th>\n",
       "      <th>steals_avg_rank</th>\n",
       "      <th>reb_avg_rank</th>\n",
       "      <th>pts_avg_rank</th>\n",
       "      <th>threes_avg_rank</th>\n",
       "      <th>fg_rank_adj</th>\n",
       "      <th>ft_rank_adj</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>272.000000</td>\n",
       "      <td>272.000000</td>\n",
       "      <td>272.000000</td>\n",
       "      <td>272.000000</td>\n",
       "      <td>272.000000</td>\n",
       "      <td>272.000000</td>\n",
       "      <td>269.000000</td>\n",
       "      <td>250.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>-0.437485</td>\n",
       "      <td>-0.300202</td>\n",
       "      <td>-0.434710</td>\n",
       "      <td>-0.475777</td>\n",
       "      <td>-0.589162</td>\n",
       "      <td>-0.378533</td>\n",
       "      <td>0.104407</td>\n",
       "      <td>0.105377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.530719</td>\n",
       "      <td>0.676711</td>\n",
       "      <td>0.782135</td>\n",
       "      <td>0.584971</td>\n",
       "      <td>0.451093</td>\n",
       "      <td>0.664269</td>\n",
       "      <td>1.175749</td>\n",
       "      <td>0.817152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>-1.093995</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>-1.526686</td>\n",
       "      <td>-1.480047</td>\n",
       "      <td>-1.398958</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>-6.180512</td>\n",
       "      <td>-1.620200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>-0.786331</td>\n",
       "      <td>-0.749695</td>\n",
       "      <td>-0.989279</td>\n",
       "      <td>-0.908780</td>\n",
       "      <td>-0.922250</td>\n",
       "      <td>-0.995520</td>\n",
       "      <td>-0.193062</td>\n",
       "      <td>-0.227201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>-0.570457</td>\n",
       "      <td>-0.496289</td>\n",
       "      <td>-0.559353</td>\n",
       "      <td>-0.548806</td>\n",
       "      <td>-0.620719</td>\n",
       "      <td>-0.490909</td>\n",
       "      <td>0.030554</td>\n",
       "      <td>0.013953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>-0.228728</td>\n",
       "      <td>-0.086906</td>\n",
       "      <td>0.007174</td>\n",
       "      <td>-0.133383</td>\n",
       "      <td>-0.274222</td>\n",
       "      <td>0.028884</td>\n",
       "      <td>0.328608</td>\n",
       "      <td>0.337846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.869713</td>\n",
       "      <td>2.819423</td>\n",
       "      <td>2.158390</td>\n",
       "      <td>1.279218</td>\n",
       "      <td>0.654124</td>\n",
       "      <td>1.923422</td>\n",
       "      <td>5.000009</td>\n",
       "      <td>4.655257</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       ast_avg_rank  blocks_avg_rank  steals_avg_rank  reb_avg_rank  \\\n",
       "count    272.000000       272.000000       272.000000    272.000000   \n",
       "mean      -0.437485        -0.300202        -0.434710     -0.475777   \n",
       "std        0.530719         0.676711         0.782135      0.584971   \n",
       "min       -1.093995        -0.982567        -1.526686     -1.480047   \n",
       "25%       -0.786331        -0.749695        -0.989279     -0.908780   \n",
       "50%       -0.570457        -0.496289        -0.559353     -0.548806   \n",
       "75%       -0.228728        -0.086906         0.007174     -0.133383   \n",
       "max        1.869713         2.819423         2.158390      1.279218   \n",
       "\n",
       "       pts_avg_rank  threes_avg_rank  fg_rank_adj  ft_rank_adj  \n",
       "count    272.000000       272.000000   269.000000   250.000000  \n",
       "mean      -0.589162        -0.378533     0.104407     0.105377  \n",
       "std        0.451093         0.664269     1.175749     0.817152  \n",
       "min       -1.398958        -1.107839    -6.180512    -1.620200  \n",
       "25%       -0.922250        -0.995520    -0.193062    -0.227201  \n",
       "50%       -0.620719        -0.490909     0.030554     0.013953  \n",
       "75%       -0.274222         0.028884     0.328608     0.337846  \n",
       "max        0.654124         1.923422     5.000009     4.655257  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show the distribution of cat ranks for all waiver wire players, what are the most readily available cats?\n",
    "# blocks, steals, asts, then rebs\n",
    "available_players = final_stats_df.loc[(final_stats_df.onTeamId == 0) & (final_stats_df.injuryStatus != 'OUT')]\n",
    "available_players[cat_ranks].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>playerName</th>\n",
       "      <th>ast_avg_rank</th>\n",
       "      <th>blocks_avg_rank</th>\n",
       "      <th>steals_avg_rank</th>\n",
       "      <th>reb_avg_rank</th>\n",
       "      <th>pts_avg_rank</th>\n",
       "      <th>threes_avg_rank</th>\n",
       "      <th>fg_rank_adj</th>\n",
       "      <th>ft_rank_adj</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>Dion Waiters</td>\n",
       "      <td>-0.544029</td>\n",
       "      <td>0.569912</td>\n",
       "      <td>-1.526686</td>\n",
       "      <td>-0.046532</td>\n",
       "      <td>0.035957</td>\n",
       "      <td>1.923422</td>\n",
       "      <td>0.639951</td>\n",
       "      <td>4.655257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>Ben McLemore</td>\n",
       "      <td>-0.586334</td>\n",
       "      <td>-0.445170</td>\n",
       "      <td>0.008024</td>\n",
       "      <td>-0.630464</td>\n",
       "      <td>0.194626</td>\n",
       "      <td>1.755829</td>\n",
       "      <td>-0.056300</td>\n",
       "      <td>-0.024445</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Patty Mills</td>\n",
       "      <td>-0.015215</td>\n",
       "      <td>-0.758651</td>\n",
       "      <td>0.473088</td>\n",
       "      <td>-0.840980</td>\n",
       "      <td>0.380889</td>\n",
       "      <td>1.602808</td>\n",
       "      <td>-0.122551</td>\n",
       "      <td>0.051064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343</th>\n",
       "      <td>Landry Shamet</td>\n",
       "      <td>-0.041202</td>\n",
       "      <td>-0.516823</td>\n",
       "      <td>-0.490258</td>\n",
       "      <td>-0.675790</td>\n",
       "      <td>0.156021</td>\n",
       "      <td>1.555341</td>\n",
       "      <td>0.016879</td>\n",
       "      <td>-0.441423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>Bryn Forbes</td>\n",
       "      <td>-0.057520</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>-0.224508</td>\n",
       "      <td>-0.690612</td>\n",
       "      <td>0.301062</td>\n",
       "      <td>1.493508</td>\n",
       "      <td>-0.325163</td>\n",
       "      <td>-0.049785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>Tyler Herro</td>\n",
       "      <td>-0.006018</td>\n",
       "      <td>-0.628196</td>\n",
       "      <td>-0.002086</td>\n",
       "      <td>0.100785</td>\n",
       "      <td>0.616385</td>\n",
       "      <td>1.338587</td>\n",
       "      <td>-0.299533</td>\n",
       "      <td>0.030050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>Seth Curry</td>\n",
       "      <td>-0.072629</td>\n",
       "      <td>-0.602368</td>\n",
       "      <td>-0.144782</td>\n",
       "      <td>-0.610364</td>\n",
       "      <td>0.342393</td>\n",
       "      <td>1.258401</td>\n",
       "      <td>0.107986</td>\n",
       "      <td>-0.074636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Garrett Temple</td>\n",
       "      <td>0.257009</td>\n",
       "      <td>0.080544</td>\n",
       "      <td>0.418493</td>\n",
       "      <td>-0.171186</td>\n",
       "      <td>0.165189</td>\n",
       "      <td>1.190318</td>\n",
       "      <td>-0.395406</td>\n",
       "      <td>-0.018141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>Langston Galloway</td>\n",
       "      <td>-0.274045</td>\n",
       "      <td>-0.559163</td>\n",
       "      <td>0.232100</td>\n",
       "      <td>-0.634155</td>\n",
       "      <td>0.158018</td>\n",
       "      <td>1.144939</td>\n",
       "      <td>-0.079029</td>\n",
       "      <td>-0.001930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Isaiah Thomas</td>\n",
       "      <td>0.913382</td>\n",
       "      <td>-0.633259</td>\n",
       "      <td>-0.740728</td>\n",
       "      <td>-0.815418</td>\n",
       "      <td>0.476681</td>\n",
       "      <td>1.108771</td>\n",
       "      <td>-0.196766</td>\n",
       "      <td>0.004975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Danny Green</td>\n",
       "      <td>-0.346041</td>\n",
       "      <td>0.135218</td>\n",
       "      <td>1.520411</td>\n",
       "      <td>-0.096054</td>\n",
       "      <td>-0.042963</td>\n",
       "      <td>1.097404</td>\n",
       "      <td>-0.066582</td>\n",
       "      <td>0.038389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>Furkan Korkmaz</td>\n",
       "      <td>-0.565181</td>\n",
       "      <td>-0.400387</td>\n",
       "      <td>-0.364027</td>\n",
       "      <td>-0.607909</td>\n",
       "      <td>0.034972</td>\n",
       "      <td>1.056307</td>\n",
       "      <td>-0.069736</td>\n",
       "      <td>0.073563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>Coby White</td>\n",
       "      <td>0.171965</td>\n",
       "      <td>-0.806814</td>\n",
       "      <td>0.161583</td>\n",
       "      <td>-0.144887</td>\n",
       "      <td>0.318299</td>\n",
       "      <td>0.951131</td>\n",
       "      <td>-0.800573</td>\n",
       "      <td>-0.006172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>Tony Snell</td>\n",
       "      <td>-0.120096</td>\n",
       "      <td>-0.448902</td>\n",
       "      <td>-0.418284</td>\n",
       "      <td>-0.795870</td>\n",
       "      <td>-0.159422</td>\n",
       "      <td>0.928790</td>\n",
       "      <td>0.000058</td>\n",
       "      <td>-1.183516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>Jae Crowder</td>\n",
       "      <td>0.433689</td>\n",
       "      <td>-0.258076</td>\n",
       "      <td>0.999127</td>\n",
       "      <td>0.926520</td>\n",
       "      <td>0.128202</td>\n",
       "      <td>0.862481</td>\n",
       "      <td>-0.318624</td>\n",
       "      <td>0.079777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>303</th>\n",
       "      <td>Cameron Johnson</td>\n",
       "      <td>-0.544029</td>\n",
       "      <td>-0.225733</td>\n",
       "      <td>-0.377979</td>\n",
       "      <td>-0.307171</td>\n",
       "      <td>-0.215153</td>\n",
       "      <td>0.824590</td>\n",
       "      <td>0.053633</td>\n",
       "      <td>-0.083928</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Kyle Korver</td>\n",
       "      <td>-0.448382</td>\n",
       "      <td>-0.425699</td>\n",
       "      <td>-0.475238</td>\n",
       "      <td>-0.681132</td>\n",
       "      <td>-0.399642</td>\n",
       "      <td>0.794936</td>\n",
       "      <td>0.058118</td>\n",
       "      <td>-0.362211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>Maxi Kleber</td>\n",
       "      <td>-0.522876</td>\n",
       "      <td>1.525284</td>\n",
       "      <td>-0.829090</td>\n",
       "      <td>0.625114</td>\n",
       "      <td>-0.003464</td>\n",
       "      <td>0.750266</td>\n",
       "      <td>0.030765</td>\n",
       "      <td>-0.094586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Wesley Matthews</td>\n",
       "      <td>-0.319552</td>\n",
       "      <td>-0.554843</td>\n",
       "      <td>-0.095429</td>\n",
       "      <td>-0.514619</td>\n",
       "      <td>-0.244333</td>\n",
       "      <td>0.724837</td>\n",
       "      <td>-0.012891</td>\n",
       "      <td>-0.046848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>Dorian Finney-Smith</td>\n",
       "      <td>-0.263857</td>\n",
       "      <td>0.247700</td>\n",
       "      <td>0.115954</td>\n",
       "      <td>0.710796</td>\n",
       "      <td>0.060130</td>\n",
       "      <td>0.715207</td>\n",
       "      <td>0.062200</td>\n",
       "      <td>-0.012478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Patrick Beverley</td>\n",
       "      <td>1.092121</td>\n",
       "      <td>0.472882</td>\n",
       "      <td>1.435770</td>\n",
       "      <td>0.777739</td>\n",
       "      <td>-0.099847</td>\n",
       "      <td>0.710918</td>\n",
       "      <td>0.001539</td>\n",
       "      <td>0.346859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>George Hill</td>\n",
       "      <td>0.555904</td>\n",
       "      <td>-0.770865</td>\n",
       "      <td>0.232100</td>\n",
       "      <td>-0.298286</td>\n",
       "      <td>0.096522</td>\n",
       "      <td>0.623080</td>\n",
       "      <td>-0.036735</td>\n",
       "      <td>-0.054868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>Aaron Holiday</td>\n",
       "      <td>0.791604</td>\n",
       "      <td>-0.459793</td>\n",
       "      <td>0.200693</td>\n",
       "      <td>-0.626321</td>\n",
       "      <td>0.116488</td>\n",
       "      <td>0.608845</td>\n",
       "      <td>-0.175084</td>\n",
       "      <td>-0.230526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>351</th>\n",
       "      <td>Terence Davis</td>\n",
       "      <td>-0.108206</td>\n",
       "      <td>-0.499248</td>\n",
       "      <td>-0.157819</td>\n",
       "      <td>-0.085874</td>\n",
       "      <td>-0.142924</td>\n",
       "      <td>0.586522</td>\n",
       "      <td>0.050722</td>\n",
       "      <td>-0.470941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>P.J. Tucker</td>\n",
       "      <td>-0.205588</td>\n",
       "      <td>0.047444</td>\n",
       "      <td>1.310203</td>\n",
       "      <td>1.279218</td>\n",
       "      <td>-0.260684</td>\n",
       "      <td>0.553525</td>\n",
       "      <td>-0.010209</td>\n",
       "      <td>-0.256980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>Gary Trent Jr.</td>\n",
       "      <td>-0.585276</td>\n",
       "      <td>-0.400387</td>\n",
       "      <td>-0.075687</td>\n",
       "      <td>-0.893609</td>\n",
       "      <td>-0.384268</td>\n",
       "      <td>0.540409</td>\n",
       "      <td>0.056988</td>\n",
       "      <td>-0.711488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>Reggie Bullock</td>\n",
       "      <td>-0.225627</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>1.146206</td>\n",
       "      <td>-0.533516</td>\n",
       "      <td>0.057535</td>\n",
       "      <td>0.507504</td>\n",
       "      <td>0.167138</td>\n",
       "      <td>-0.635657</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331</th>\n",
       "      <td>Malik Beasley</td>\n",
       "      <td>-0.450132</td>\n",
       "      <td>-0.641779</td>\n",
       "      <td>0.301808</td>\n",
       "      <td>-0.745808</td>\n",
       "      <td>-0.180280</td>\n",
       "      <td>0.500208</td>\n",
       "      <td>-0.017280</td>\n",
       "      <td>-0.398336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>Kentavious Caldwell-Pope</td>\n",
       "      <td>-0.134250</td>\n",
       "      <td>-0.480294</td>\n",
       "      <td>0.180371</td>\n",
       "      <td>-0.652135</td>\n",
       "      <td>0.054044</td>\n",
       "      <td>0.496946</td>\n",
       "      <td>0.068196</td>\n",
       "      <td>0.021925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>Austin Rivers</td>\n",
       "      <td>-0.223215</td>\n",
       "      <td>-0.545932</td>\n",
       "      <td>0.135917</td>\n",
       "      <td>-0.510796</td>\n",
       "      <td>-0.053725</td>\n",
       "      <td>0.478837</td>\n",
       "      <td>-0.070859</td>\n",
       "      <td>0.001070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>Cristiano Felicio</td>\n",
       "      <td>-0.797859</td>\n",
       "      <td>-0.803434</td>\n",
       "      <td>-0.596559</td>\n",
       "      <td>0.234156</td>\n",
       "      <td>-0.843126</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>-1.753810</td>\n",
       "      <td>-0.227201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>Moses Brown</td>\n",
       "      <td>-1.093995</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>-1.123631</td>\n",
       "      <td>-0.763290</td>\n",
       "      <td>-1.142724</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>0.030043</td>\n",
       "      <td>1.456177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>Khem Birch</td>\n",
       "      <td>-0.573756</td>\n",
       "      <td>0.276200</td>\n",
       "      <td>-0.480921</td>\n",
       "      <td>0.379648</td>\n",
       "      <td>-0.796460</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>-0.242918</td>\n",
       "      <td>0.090118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>437</th>\n",
       "      <td>Daniel Gafford</td>\n",
       "      <td>-0.860676</td>\n",
       "      <td>1.981257</td>\n",
       "      <td>-0.867141</td>\n",
       "      <td>-0.555963</td>\n",
       "      <td>-0.681501</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>-1.647214</td>\n",
       "      <td>0.678057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305</th>\n",
       "      <td>Kevin Hervey</td>\n",
       "      <td>-0.984002</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>-1.526686</td>\n",
       "      <td>-1.323664</td>\n",
       "      <td>-1.398958</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>4.931581</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>Zach Norvell Jr.</td>\n",
       "      <td>-1.093995</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>-1.526686</td>\n",
       "      <td>-1.284568</td>\n",
       "      <td>-1.398958</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>5.000009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>Caleb Martin</td>\n",
       "      <td>-0.727351</td>\n",
       "      <td>-0.206327</td>\n",
       "      <td>-1.123631</td>\n",
       "      <td>-0.893609</td>\n",
       "      <td>-1.168347</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>1.884032</td>\n",
       "      <td>0.842008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>Caleb Swanigan</td>\n",
       "      <td>-0.654022</td>\n",
       "      <td>-0.206327</td>\n",
       "      <td>-1.365464</td>\n",
       "      <td>0.031659</td>\n",
       "      <td>-1.040230</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>-0.867393</td>\n",
       "      <td>2.084808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>Quinndary Weatherspoon</td>\n",
       "      <td>-1.093995</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>-1.526686</td>\n",
       "      <td>-1.480047</td>\n",
       "      <td>-1.398958</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>5.000009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402</th>\n",
       "      <td>Isaiah Roby</td>\n",
       "      <td>-1.093995</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>-1.526686</td>\n",
       "      <td>-1.480047</td>\n",
       "      <td>-1.398958</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>5.000009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>Amile Jefferson</td>\n",
       "      <td>-0.964591</td>\n",
       "      <td>-0.571616</td>\n",
       "      <td>-1.384431</td>\n",
       "      <td>-0.951103</td>\n",
       "      <td>-1.263305</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>0.962178</td>\n",
       "      <td>1.991107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>Isaiah Hartenstein</td>\n",
       "      <td>-0.644022</td>\n",
       "      <td>0.287643</td>\n",
       "      <td>-0.537369</td>\n",
       "      <td>0.119329</td>\n",
       "      <td>-0.651218</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>-1.813475</td>\n",
       "      <td>0.252492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>Justin Anderson</td>\n",
       "      <td>-1.093995</td>\n",
       "      <td>-0.206327</td>\n",
       "      <td>-1.526686</td>\n",
       "      <td>-1.219408</td>\n",
       "      <td>-1.245218</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>3.082931</td>\n",
       "      <td>1.497078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>Chris Silva</td>\n",
       "      <td>-0.842582</td>\n",
       "      <td>0.148525</td>\n",
       "      <td>-0.904829</td>\n",
       "      <td>-0.363023</td>\n",
       "      <td>-0.920165</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>-1.916131</td>\n",
       "      <td>0.135206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>Harry Giles III</td>\n",
       "      <td>-0.438266</td>\n",
       "      <td>-0.176472</td>\n",
       "      <td>-0.317520</td>\n",
       "      <td>-0.201913</td>\n",
       "      <td>-0.582949</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>-0.567586</td>\n",
       "      <td>-0.476678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>Henry Ellenson</td>\n",
       "      <td>-0.984002</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>-1.526686</td>\n",
       "      <td>-1.010897</td>\n",
       "      <td>-1.337462</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>3.332938</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Evan Turner</td>\n",
       "      <td>0.005938</td>\n",
       "      <td>-0.002054</td>\n",
       "      <td>-0.381161</td>\n",
       "      <td>-0.698130</td>\n",
       "      <td>-0.897277</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>0.641162</td>\n",
       "      <td>-0.596919</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>Antonius Cleveland</td>\n",
       "      <td>-1.093995</td>\n",
       "      <td>-0.594447</td>\n",
       "      <td>-1.123631</td>\n",
       "      <td>-1.284568</td>\n",
       "      <td>-1.270841</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>1.251389</td>\n",
       "      <td>1.497078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>Jordan Bone</td>\n",
       "      <td>-0.605136</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>-1.257982</td>\n",
       "      <td>-1.436607</td>\n",
       "      <td>-1.296464</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>2.861272</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>Johnathan Williams</td>\n",
       "      <td>-0.764015</td>\n",
       "      <td>0.414664</td>\n",
       "      <td>-1.284853</td>\n",
       "      <td>0.201075</td>\n",
       "      <td>-0.860865</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>-1.978527</td>\n",
       "      <td>0.842008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>Tony Bradley</td>\n",
       "      <td>-0.949267</td>\n",
       "      <td>-0.063336</td>\n",
       "      <td>-0.890283</td>\n",
       "      <td>0.155806</td>\n",
       "      <td>-0.731399</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>-1.234920</td>\n",
       "      <td>0.481937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>464</th>\n",
       "      <td>Talen Horton-Tucker</td>\n",
       "      <td>-0.544029</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>-0.317520</td>\n",
       "      <td>-1.480047</td>\n",
       "      <td>-1.398958</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>5.000009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Ed Davis</td>\n",
       "      <td>-0.918006</td>\n",
       "      <td>-0.144228</td>\n",
       "      <td>-0.559353</td>\n",
       "      <td>0.005595</td>\n",
       "      <td>-1.196020</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>0.351524</td>\n",
       "      <td>1.559830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>Norvel Pelle</td>\n",
       "      <td>-0.837344</td>\n",
       "      <td>2.588135</td>\n",
       "      <td>-1.365464</td>\n",
       "      <td>-0.072596</td>\n",
       "      <td>-0.988983</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>-1.405209</td>\n",
       "      <td>1.292572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>Devon Hall</td>\n",
       "      <td>-0.764015</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>-1.526686</td>\n",
       "      <td>-1.401856</td>\n",
       "      <td>-1.245218</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>2.726079</td>\n",
       "      <td>-0.049260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>Nigel Williams-Goss</td>\n",
       "      <td>-0.750266</td>\n",
       "      <td>-0.691477</td>\n",
       "      <td>-1.224395</td>\n",
       "      <td>-1.235698</td>\n",
       "      <td>-1.322088</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>3.332938</td>\n",
       "      <td>-1.598366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>Anzejs Pasecniks</td>\n",
       "      <td>-0.601920</td>\n",
       "      <td>0.243075</td>\n",
       "      <td>-0.508441</td>\n",
       "      <td>0.454169</td>\n",
       "      <td>-0.274222</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>-0.601489</td>\n",
       "      <td>0.259664</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>Jonah Bolden</td>\n",
       "      <td>-1.093995</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>-0.922103</td>\n",
       "      <td>-1.382308</td>\n",
       "      <td>-1.245218</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>-2.436882</td>\n",
       "      <td>4.592522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>Zhaire Smith</td>\n",
       "      <td>-0.910673</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>-0.317520</td>\n",
       "      <td>-1.349728</td>\n",
       "      <td>-1.193971</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>1.884032</td>\n",
       "      <td>1.456177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Udonis Haslem</td>\n",
       "      <td>-1.093995</td>\n",
       "      <td>-0.982567</td>\n",
       "      <td>-1.526686</td>\n",
       "      <td>-0.893609</td>\n",
       "      <td>-1.014606</td>\n",
       "      <td>-1.107839</td>\n",
       "      <td>-6.180512</td>\n",
       "      <td>-0.049260</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>272 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   playerName  ast_avg_rank  blocks_avg_rank  steals_avg_rank  \\\n",
       "121              Dion Waiters     -0.544029         0.569912        -1.526686   \n",
       "158              Ben McLemore     -0.586334        -0.445170         0.008024   \n",
       "60                Patty Mills     -0.015215        -0.758651         0.473088   \n",
       "343             Landry Shamet     -0.041202        -0.516823        -0.490258   \n",
       "215               Bryn Forbes     -0.057520        -0.982567        -0.224508   \n",
       "461               Tyler Herro     -0.006018        -0.628196        -0.002086   \n",
       "124                Seth Curry     -0.072629        -0.602368        -0.144782   \n",
       "63             Garrett Temple      0.257009         0.080544         0.418493   \n",
       "148         Langston Galloway     -0.274045        -0.559163         0.232100   \n",
       "95              Isaiah Thomas      0.913382        -0.633259        -0.740728   \n",
       "55                Danny Green     -0.346041         0.135218         1.520411   \n",
       "355            Furkan Korkmaz     -0.565181        -0.400387        -0.364027   \n",
       "458                Coby White      0.171965        -0.806814         0.161583   \n",
       "140                Tony Snell     -0.120096        -0.448902        -0.418284   \n",
       "104               Jae Crowder      0.433689        -0.258076         0.999127   \n",
       "303           Cameron Johnson     -0.544029        -0.225733        -0.377979   \n",
       "4                 Kyle Korver     -0.448382        -0.425699        -0.475238   \n",
       "184               Maxi Kleber     -0.522876         1.525284        -0.829090   \n",
       "64            Wesley Matthews     -0.319552        -0.554843        -0.095429   \n",
       "157       Dorian Finney-Smith     -0.263857         0.247700         0.115954   \n",
       "49           Patrick Beverley      1.092121         0.472882         1.435770   \n",
       "38                George Hill      0.555904        -0.770865         0.232100   \n",
       "352             Aaron Holiday      0.791604        -0.459793         0.200693   \n",
       "351             Terence Davis     -0.108206        -0.499248        -0.157819   \n",
       "21                P.J. Tucker     -0.205588         0.047444         1.310203   \n",
       "425            Gary Trent Jr.     -0.585276        -0.400387        -0.075687   \n",
       "144            Reggie Bullock     -0.225627        -0.982567         1.146206   \n",
       "331             Malik Beasley     -0.450132        -0.641779         0.301808   \n",
       "169  Kentavious Caldwell-Pope     -0.134250        -0.480294         0.180371   \n",
       "117             Austin Rivers     -0.223215        -0.545932         0.135917   \n",
       "..                        ...           ...              ...              ...   \n",
       "269         Cristiano Felicio     -0.797859        -0.803434        -0.596559   \n",
       "468               Moses Brown     -1.093995        -0.982567        -1.123631   \n",
       "160                Khem Birch     -0.573756         0.276200        -0.480921   \n",
       "437            Daniel Gafford     -0.860676         1.981257        -0.867141   \n",
       "305              Kevin Hervey     -0.984002        -0.982567        -1.526686   \n",
       "410          Zach Norvell Jr.     -1.093995        -0.982567        -1.526686   \n",
       "301              Caleb Martin     -0.727351        -0.206327        -1.123631   \n",
       "323            Caleb Swanigan     -0.654022        -0.206327        -1.365464   \n",
       "324    Quinndary Weatherspoon     -1.093995        -0.982567        -1.526686   \n",
       "402               Isaiah Roby     -1.093995        -0.982567        -1.526686   \n",
       "188           Amile Jefferson     -0.964591        -0.571616        -1.384431   \n",
       "416        Isaiah Hartenstein     -0.644022         0.287643        -0.537369   \n",
       "191           Justin Anderson     -1.093995        -0.206327        -1.526686   \n",
       "354               Chris Silva     -0.842582         0.148525        -0.904829   \n",
       "376           Harry Giles III     -0.438266        -0.176472        -0.317520   \n",
       "320            Henry Ellenson     -0.984002        -0.982567        -1.526686   \n",
       "66                Evan Turner      0.005938        -0.002054        -0.381161   \n",
       "246        Antonius Cleveland     -1.093995        -0.594447        -1.123631   \n",
       "390               Jordan Bone     -0.605136        -0.982567        -1.257982   \n",
       "255        Johnathan Williams     -0.764015         0.414664        -1.284853   \n",
       "383              Tony Bradley     -0.949267        -0.063336        -0.890283   \n",
       "464       Talen Horton-Tucker     -0.544029        -0.982567        -0.317520   \n",
       "72                   Ed Davis     -0.918006        -0.144228        -0.559353   \n",
       "183              Norvel Pelle     -0.837344         2.588135        -1.365464   \n",
       "235                Devon Hall     -0.764015        -0.982567        -1.526686   \n",
       "252       Nigel Williams-Goss     -0.750266        -0.691477        -1.224395   \n",
       "318          Anzejs Pasecniks     -0.601920         0.243075        -0.508441   \n",
       "311              Jonah Bolden     -1.093995        -0.982567        -0.922103   \n",
       "431              Zhaire Smith     -0.910673        -0.982567        -0.317520   \n",
       "5               Udonis Haslem     -1.093995        -0.982567        -1.526686   \n",
       "\n",
       "     reb_avg_rank  pts_avg_rank  threes_avg_rank  fg_rank_adj  ft_rank_adj  \n",
       "121     -0.046532      0.035957         1.923422     0.639951     4.655257  \n",
       "158     -0.630464      0.194626         1.755829    -0.056300    -0.024445  \n",
       "60      -0.840980      0.380889         1.602808    -0.122551     0.051064  \n",
       "343     -0.675790      0.156021         1.555341     0.016879    -0.441423  \n",
       "215     -0.690612      0.301062         1.493508    -0.325163    -0.049785  \n",
       "461      0.100785      0.616385         1.338587    -0.299533     0.030050  \n",
       "124     -0.610364      0.342393         1.258401     0.107986    -0.074636  \n",
       "63      -0.171186      0.165189         1.190318    -0.395406    -0.018141  \n",
       "148     -0.634155      0.158018         1.144939    -0.079029    -0.001930  \n",
       "95      -0.815418      0.476681         1.108771    -0.196766     0.004975  \n",
       "55      -0.096054     -0.042963         1.097404    -0.066582     0.038389  \n",
       "355     -0.607909      0.034972         1.056307    -0.069736     0.073563  \n",
       "458     -0.144887      0.318299         0.951131    -0.800573    -0.006172  \n",
       "140     -0.795870     -0.159422         0.928790     0.000058    -1.183516  \n",
       "104      0.926520      0.128202         0.862481    -0.318624     0.079777  \n",
       "303     -0.307171     -0.215153         0.824590     0.053633    -0.083928  \n",
       "4       -0.681132     -0.399642         0.794936     0.058118    -0.362211  \n",
       "184      0.625114     -0.003464         0.750266     0.030765    -0.094586  \n",
       "64      -0.514619     -0.244333         0.724837    -0.012891    -0.046848  \n",
       "157      0.710796      0.060130         0.715207     0.062200    -0.012478  \n",
       "49       0.777739     -0.099847         0.710918     0.001539     0.346859  \n",
       "38      -0.298286      0.096522         0.623080    -0.036735    -0.054868  \n",
       "352     -0.626321      0.116488         0.608845    -0.175084    -0.230526  \n",
       "351     -0.085874     -0.142924         0.586522     0.050722    -0.470941  \n",
       "21       1.279218     -0.260684         0.553525    -0.010209    -0.256980  \n",
       "425     -0.893609     -0.384268         0.540409     0.056988    -0.711488  \n",
       "144     -0.533516      0.057535         0.507504     0.167138    -0.635657  \n",
       "331     -0.745808     -0.180280         0.500208    -0.017280    -0.398336  \n",
       "169     -0.652135      0.054044         0.496946     0.068196     0.021925  \n",
       "117     -0.510796     -0.053725         0.478837    -0.070859     0.001070  \n",
       "..            ...           ...              ...          ...          ...  \n",
       "269      0.234156     -0.843126        -1.107839    -1.753810    -0.227201  \n",
       "468     -0.763290     -1.142724        -1.107839     0.030043     1.456177  \n",
       "160      0.379648     -0.796460        -1.107839    -0.242918     0.090118  \n",
       "437     -0.555963     -0.681501        -1.107839    -1.647214     0.678057  \n",
       "305     -1.323664     -1.398958        -1.107839     4.931581          NaN  \n",
       "410     -1.284568     -1.398958        -1.107839     5.000009          NaN  \n",
       "301     -0.893609     -1.168347        -1.107839     1.884032     0.842008  \n",
       "323      0.031659     -1.040230        -1.107839    -0.867393     2.084808  \n",
       "324     -1.480047     -1.398958        -1.107839     5.000009          NaN  \n",
       "402     -1.480047     -1.398958        -1.107839     5.000009          NaN  \n",
       "188     -0.951103     -1.263305        -1.107839     0.962178     1.991107  \n",
       "416      0.119329     -0.651218        -1.107839    -1.813475     0.252492  \n",
       "191     -1.219408     -1.245218        -1.107839     3.082931     1.497078  \n",
       "354     -0.363023     -0.920165        -1.107839    -1.916131     0.135206  \n",
       "376     -0.201913     -0.582949        -1.107839    -0.567586    -0.476678  \n",
       "320     -1.010897     -1.337462        -1.107839     3.332938          NaN  \n",
       "66      -0.698130     -0.897277        -1.107839     0.641162    -0.596919  \n",
       "246     -1.284568     -1.270841        -1.107839     1.251389     1.497078  \n",
       "390     -1.436607     -1.296464        -1.107839     2.861272          NaN  \n",
       "255      0.201075     -0.860865        -1.107839    -1.978527     0.842008  \n",
       "383      0.155806     -0.731399        -1.107839    -1.234920     0.481937  \n",
       "464     -1.480047     -1.398958        -1.107839     5.000009          NaN  \n",
       "72       0.005595     -1.196020        -1.107839     0.351524     1.559830  \n",
       "183     -0.072596     -0.988983        -1.107839    -1.405209     1.292572  \n",
       "235     -1.401856     -1.245218        -1.107839     2.726079    -0.049260  \n",
       "252     -1.235698     -1.322088        -1.107839     3.332938    -1.598366  \n",
       "318      0.454169     -0.274222        -1.107839    -0.601489     0.259664  \n",
       "311     -1.382308     -1.245218        -1.107839    -2.436882     4.592522  \n",
       "431     -1.349728     -1.193971        -1.107839     1.884032     1.456177  \n",
       "5       -0.893609     -1.014606        -1.107839    -6.180512    -0.049260  \n",
       "\n",
       "[272 rows x 9 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "available_players.sort_values('threes_avg_rank', ascending=False)[['playerName']+cat_ranks]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}