octys.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import cluj_tools as ct\n",
    "\n",
    "from sqlalchemy import create_engine\n",
    "from sqlalchemy_utils import database_exists, create_database\n",
    "\n",
    "from secrets import *"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Get Rosters"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Matchup end date is 2020-03-01\n",
      "Matchup period is 18\n"
     ]
    }
   ],
   "source": [
    "matchup_end_date, matchupPeriod = ct.matchup_end_date()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "rosters = ct.get_rosters(matchupPeriod)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Get Boxscore data to calculate octys"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "True\n"
     ]
    }
   ],
   "source": [
    "dbname = 'cluj'\n",
    "engine = create_engine('postgres://%s:%s@localhost/%s'%(AUTH['db_user'],AUTH['db_pass'],dbname))\n",
    "\n",
    "if not database_exists(engine.url):\n",
    "    create_database(engine.url)\n",
    "print(database_exists(engine.url))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "sql = \"\"\"\n",
    "    SELECT * FROM boxscores b\n",
    "    LEFT JOIN player_name_comparison c ON b.name = c.boxscore_name\n",
    "    WHERE b.season_year = '2019-2020' AND b.season_type = 'regular'\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "boxscores = pd.read_sql(sql, engine)\n",
    "boxscores['ft_pct'] = boxscores.ftm / boxscores.fta\n",
    "boxscores['fg_pct'] = boxscores.fgm / boxscores.fga"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "boxscores.loc[boxscores.espn_name.isnull(),'espn_name'] = boxscores.loc[boxscores.espn_name.isnull(),'name']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(463, 21)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ft_pct_threshold = 0.75\n",
    "fg_pct_threshold = 0.4\n",
    "octys = boxscores.loc[(boxscores.assists > 0) & (boxscores.threes > 0) & (boxscores.steals > 0) & (boxscores.rebounds > 0) & (boxscores['blocks'] > 0) & (boxscores.ft_pct > ft_pct_threshold) & (boxscores.fg_pct > fg_pct_threshold)]\n",
    "octys.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "octy_counts = pd.DataFrame(octys.espn_name.value_counts())\n",
    "octy_counts.reset_index(inplace=True)\n",
    "octy_counts.rename(columns={'espn_name':'octy_count', 'index':'espn_name'}, inplace=True)"
   ]
  },
  {
   "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>espn_name</th>\n",
       "      <th>octy_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>James Harden</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Joel Embiid</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kawhi Leonard</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Nikola Jokic</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       espn_name  octy_count\n",
       "0  Anthony Davis          14\n",
       "1   James Harden          12\n",
       "2    Joel Embiid          11\n",
       "3  Kawhi Leonard          10\n",
       "4   Nikola Jokic           9"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "octy_counts.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "octys_games = pd.DataFrame(boxscores.groupby('espn_name')['assists'].count())\n",
    "octys_games.reset_index(inplace=True)\n",
    "octys_games.rename(columns={'assists':'game_count'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(189, 4)"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged = octy_counts.merge(octys_games, on='espn_name')\n",
    "merged['octy_pct'] = merged.octy_count / merged.game_count\n",
    "merged.sort_values('octy_pct', ascending=False, inplace=True)\n",
    "merged.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1a2e6746d8>"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD8CAYAAAB5Pm/hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvOIA7rQAAD3tJREFUeJzt3X+sX3ddx/Hnm9WJ7MI2GNwsXcMFacBJUdh1mZKQ72UkDma2JW5xZGJLRhoVgchMqGKyRGMoasQZiVoZoSSEO6gkq2xAoOxK+GPVFgdlq7gy6+g2GT+24h1R0vj2j3t2uZS73e/3e77f79ne3+cjae73nPM557zfOe3rnu/5nu9pZCaSpLqe0XUBkqTxMuglqTiDXpKKM+glqTiDXpKKM+glqTiDXpKKM+glqTiDXpKK29R1AQDnnXdezs3NrU4/9thjnHXWWd0V1KFp7h2mu397t/dBHT58+NuZ+fyNxj0lgn5ubo5Dhw6tTi8tLdHr9borqEPT3DtMd//23uu6jE606T0i/rOfcV66kaTiDHpJKs6gl6TiDHpJKs6gl6TiDHpJKs6gl6TiDHpJKs6gl6TinhLfjG1jbtdtrdY/vvvyEVUiSU9NntFLUnEbBn1EfDAiHo6Ir66Z99yI+GxE3Nv8PLeZHxHxVxFxLCK+EhGvGmfxkqSN9XNG/yHgstPm7QIOZOZW4EAzDfB6YGvzZyfwN6MpU5I0rA2DPjO/AHz3tNlXAnub13uBq9bM/3CuuBM4JyLOH1WxkqTBDXuNfjYzHwJofr6gmb8Z+MaacSeaeZKkjoz6rptYZ16uOzBiJyuXd5idnWVpaWl12fLy8o9MP5kbtp0atMYf0e9+JmWQ3iua5v7tfanrMjoxid6HDfpvRsT5mflQc2nm4Wb+CWDLmnEXAA+ut4HM3APsAZifn8+1D94f5EH8O9reXnldf/uZlGn+Dxhguvu3917XZXRiEr0Pe+lmP7C9eb0duHXN/N9o7r65BDj5+CUeSVI3Njyjj4iPAj3gvIg4AdwI7AY+FhHXA/cD1zTDbwfeABwDvg+8eQw1S5IGsGHQZ+Ybn2DRpeuMTeCtbYuSJI2O34yVpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOJaBX1E/G5E3B0RX42Ij0bEMyPiRRFxMCLujYhbIuLMURUrSRrc0EEfEZuBtwPzmfly4AzgWuC9wPsycyvwCHD9KAqVJA2n7aWbTcBPRcQm4FnAQ8BrgX3N8r3AVS33IUlqYeigz8wHgD8H7mcl4E8Ch4FHM/NUM+wEsLltkZKk4UVmDrdixLnAPwC/BjwKfLyZvjEzX9KM2QLcnpnb1ll/J7ATYHZ29qLFxcXVZcvLy8zMzPRVx5EHTg5V/+O2bT671fqjNkjvFU1z//Zu74NaWFg4nJnzG43bNNTWV7wO+I/M/BZARHwC+CXgnIjY1JzVXwA8uN7KmbkH2AMwPz+fvV5vddnS0hJrp5/Mjl23Dd8BcPy6/vYzKYP0XtE092/vva7L6MQkem9zjf5+4JKIeFZEBHApcA9wB3B1M2Y7cGu7EiVJbbS5Rn+QlQ9dvwQcaba1B3gX8M6IOAY8D7h5BHVKkobU5tINmXkjcONps+8DLm6zXUnS6PjNWEkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOIMekkqzqCXpOJaBX1EnBMR+yLi3yLiaET8YkQ8NyI+GxH3Nj/PHVWxkqTBtT2jvwn4dGa+DPg54CiwCziQmVuBA820JKkjQwd9RDwHeA1wM0Bm/iAzHwWuBPY2w/YCV7UtUpI0vMjM4VaM+HlgD3APK2fzh4F3AA9k5jlrxj2SmT92+SYidgI7AWZnZy9aXFxcXba8vMzMzExfdRx54ORQ9T9u2+azW60/aoP0XtE092/v9j6ohYWFw5k5v9G4NkE/D9wJvDozD0bETcD3gLf1E/Rrzc/P56FDh1anl5aW6PV6fdUxt+u2Iar/oeO7L2+1/qgN0ntF09y/vfe6LqMTbXqPiL6Cvs01+hPAicw82EzvA14FfDMizm+KOB94uMU+JEktDR30mflfwDci4qXNrEtZuYyzH9jezNsO3NqqQklSK5tarv824CMRcSZwH/BmVn55fCwirgfuB65puQ9JUgutgj4z7wLWuz50aZvtSpJGx2/GSlJxBr0kFWfQS1JxBr0kFWfQS1JxBr0kFWfQS1JxBr0kFWfQS1JxBr0kFWfQS1JxBr0kFWfQS1JxBr0kFWfQS1JxBr0kFWfQS1JxBr0kFWfQS1JxBr0kFWfQS1JxBr0kFWfQS1JxBr0kFWfQS1JxBr0kFWfQS1JxBr0kFbep6wK6NrfrtqHXPb778hFWIknj4Rm9JBVn0EtSca2DPiLOiIh/jYhPNtMvioiDEXFvRNwSEWe2L1OSNKxRnNG/Azi6Zvq9wPsycyvwCHD9CPYhSRpSq6CPiAuAy4EPNNMBvBbY1wzZC1zVZh+SpHYiM4dfOWIf8B7g2cDvATuAOzPzJc3yLcCnMvPl66y7E9gJMDs7e9Hi4uLqsuXlZWZmZvqq4cgDJ4euv61tm88e+TYH6b2iae7f3u19UAsLC4czc36jcUPfXhkRvwI8nJmHI6L3+Ox1hq77myQz9wB7AObn57PX660uW1paYu30k9nR4vbIto5f1xv5NgfpvaJp7t/ee12X0YlJ9N7mPvpXA1dExBuAZwLPAf4SOCciNmXmKeAC4MH2ZUqShjX0NfrM/P3MvCAz54Brgc9n5nXAHcDVzbDtwK2tq5QkDW0c99G/C3hnRBwDngfcPIZ9SJL6NJJHIGTmErDUvL4PuHgU25Uktec3YyWpOINekooz6CWpOINekooz6CWpOINekooz6CWpOINekooz6CWpOINekooz6CWpOINekooz6CWpOINekooz6CWpOINekooz6CWpOINekooz6CWpOINekooz6CWpOINekooz6CWpOINekooz6CWpOINekooz6CWpOINekooz6CWpOINekooz6CWpuKGDPiK2RMQdEXE0Iu6OiHc0858bEZ+NiHubn+eOrlxJ0qDanNGfAm7IzJ8BLgHeGhEXAruAA5m5FTjQTEuSOjJ00GfmQ5n5peb1fwNHgc3AlcDeZthe4Kq2RUqShjeSa/QRMQe8EjgIzGbmQ7DyywB4wSj2IUkaTmRmuw1EzAD/BPxJZn4iIh7NzHPWLH8kM3/sOn1E7AR2AszOzl60uLi4umx5eZmZmZm+9n/kgZOt6m9j2+azR77NQXqvaJr7t3d7H9TCwsLhzJzfaFyroI+InwA+CXwmM/+imfc1oJeZD0XE+cBSZr70ybYzPz+fhw4dWp1eWlqi1+v1VcPcrtuGrL6947svH/k2B+m9omnu3957XZfRiTa9R0RfQd/mrpsAbgaOPh7yjf3A9ub1duDWYfchSWpvU4t1Xw28CTgSEXc18/4A2A18LCKuB+4HrmlXoiSpjaGDPjO/CMQTLL502O1KkkbLb8ZKUnEGvSQVZ9BLUnEGvSQVZ9BLUnEGvSQVZ9BLUnEGvSQVZ9BLUnFtHoEw9do8UG0cD0STpPV4Ri9JxXlG35Enejdww7ZT7NjgnYLvBiQNwjN6SSrOoJek4gx6SSrOoJek4gx6SSrOoJek4gx6SSrOoJek4gx6SSrOoJek4gx6SSrOZ908DfnUTEmD8Ixekooz6CWpOINekooz6CWpOINekorzrpsp0+aOHfCuHenpyDN6SSpuLGf0EXEZcBNwBvCBzNw9jv1o8tq+I9hIP/9n7qB8F6JpN/Iz+og4A3g/8HrgQuCNEXHhqPcjSerPOM7oLwaOZeZ9ABGxCFwJ3DOGfUljNe53MGud/m7GdyJPD23/jnzosrNGVMkTG8c1+s3AN9ZMn2jmSZI6EJk52g1GXAP8cma+pZl+E3BxZr7ttHE7gZ3N5EuBr61ZfB7w7ZEW9vQxzb3DdPdv79OpTe8vzMznbzRoHJduTgBb1kxfADx4+qDM3APsWW8DEXEoM+fHUNtT3jT3DtPdv73b+7iM49LNvwBbI+JFEXEmcC2wfwz7kST1YeRn9Jl5KiJ+B/gMK7dXfjAz7x71fiRJ/RnLffSZeTtwe4tNrHtJZ0pMc+8w3f3b+3Qae+8j/zBWkvTU4iMQJKm4ToM+Ii6LiK9FxLGI2LXO8p+MiFua5QcjYm7yVY5HH72/JiK+FBGnIuLqLmoclz56f2dE3BMRX4mIAxHxwi7qHIc+ev/NiDgSEXdFxBcrfat8o97XjLs6IjIiytyF08dx3xER32qO+10R8ZaRFpCZnfxh5YParwMvBs4EvgxceNqY3wb+tnl9LXBLV/V20Psc8Argw8DVXdc84d4XgGc1r39ryo77c9a8vgL4dNd1T6r3ZtyzgS8AdwLzXdc9weO+A/jrcdXQ5Rn96qMSMvMHwOOPSljrSmBv83ofcGlExARrHJcNe8/M45n5FeD/uihwjPrp/Y7M/H4zeScr38WooJ/ev7dm8iygyodo/fx7B/hj4E+B/5lkcWPWb+9j02XQ9/OohNUxmXkKOAk8byLVjdc0PyZi0N6vBz411oomp6/eI+KtEfF1VgLv7ROqbdw27D0iXglsycxPTrKwCej37/yvNpcr90XElnWWD63LoF/vzPz0s5d+xjwdVe2rH333HhG/DswDfzbWiianr94z8/2Z+dPAu4A/HHtVk/GkvUfEM4D3ATdMrKLJ6ee4/yMwl5mvAD7HD69kjESXQd/PoxJWx0TEJuBs4LsTqW68+npMRFF99R4RrwPeDVyRmf87odrGbdDjvghcNdaKJmej3p8NvBxYiojjwCXA/iIfyG543DPzO2v+nv89cNEoC+gy6Pt5VMJ+YHvz+mrg89l8cvE0N82Pidiw9+Yt/N+xEvIPd1DjuPTT+9Y1k5cD906wvnF60t4z82RmnpeZc5k5x8pnM1dk5qFuyh2pfo77+WsmrwCOjrSCjj+NfgPw76x8Iv3uZt4fsXKAAZ4JfBw4Bvwz8OKuP0GfYO+/wMqZwGPAd4C7u655gr1/DvgmcFfzZ3/XNU+w95uAu5u+7wB+tuuaJ9X7aWOXKHLXTZ/H/T3Ncf9yc9xfNsr9+81YSSrOb8ZKUnEGvSQVZ9BLUnEGvSQVZ9BLUnEGvSQVZ9BLUnEGvSQV9//5O/spQc1iBgAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "merged.octy_pct.hist(bins=20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>espn_name</th>\n",
       "      <th>octy_count</th>\n",
       "      <th>game_count</th>\n",
       "      <th>octy_pct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>P.J. Washington</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Anthony Davis</td>\n",
       "      <td>14</td>\n",
       "      <td>48</td>\n",
       "      <td>0.291667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Joel Embiid</td>\n",
       "      <td>11</td>\n",
       "      <td>42</td>\n",
       "      <td>0.261905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kawhi Leonard</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>0.227273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>James Harden</td>\n",
       "      <td>12</td>\n",
       "      <td>54</td>\n",
       "      <td>0.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>Juan Toscano-Anderson</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Kyrie Irving</td>\n",
       "      <td>4</td>\n",
       "      <td>20</td>\n",
       "      <td>0.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>John Collins</td>\n",
       "      <td>6</td>\n",
       "      <td>33</td>\n",
       "      <td>0.181818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Brandon Ingram</td>\n",
       "      <td>8</td>\n",
       "      <td>49</td>\n",
       "      <td>0.163265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Nikola Jokic</td>\n",
       "      <td>9</td>\n",
       "      <td>57</td>\n",
       "      <td>0.157895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Jayson Tatum</td>\n",
       "      <td>8</td>\n",
       "      <td>52</td>\n",
       "      <td>0.153846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Pascal Siakam</td>\n",
       "      <td>7</td>\n",
       "      <td>46</td>\n",
       "      <td>0.152174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Josh Richardson</td>\n",
       "      <td>6</td>\n",
       "      <td>44</td>\n",
       "      <td>0.136364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Nikola Vucevic</td>\n",
       "      <td>6</td>\n",
       "      <td>46</td>\n",
       "      <td>0.130435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Kemba Walker</td>\n",
       "      <td>6</td>\n",
       "      <td>46</td>\n",
       "      <td>0.130435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Damian Lillard</td>\n",
       "      <td>7</td>\n",
       "      <td>54</td>\n",
       "      <td>0.129630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>LaMarcus Aldridge</td>\n",
       "      <td>6</td>\n",
       "      <td>52</td>\n",
       "      <td>0.115385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Karl-Anthony Towns</td>\n",
       "      <td>4</td>\n",
       "      <td>35</td>\n",
       "      <td>0.114286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Kyle Lowry</td>\n",
       "      <td>5</td>\n",
       "      <td>45</td>\n",
       "      <td>0.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Jamal Murray</td>\n",
       "      <td>5</td>\n",
       "      <td>47</td>\n",
       "      <td>0.106383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Myles Turner</td>\n",
       "      <td>5</td>\n",
       "      <td>47</td>\n",
       "      <td>0.106383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Kevin Love</td>\n",
       "      <td>5</td>\n",
       "      <td>48</td>\n",
       "      <td>0.104167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Bradley Beal</td>\n",
       "      <td>5</td>\n",
       "      <td>49</td>\n",
       "      <td>0.102041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>Josh Jackson</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>0.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>Kadeem Allen</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>0.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>LeBron James</td>\n",
       "      <td>5</td>\n",
       "      <td>53</td>\n",
       "      <td>0.094340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Jonathan Isaac</td>\n",
       "      <td>3</td>\n",
       "      <td>32</td>\n",
       "      <td>0.093750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>Justise Winslow</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>0.090909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Robert Covington</td>\n",
       "      <td>5</td>\n",
       "      <td>55</td>\n",
       "      <td>0.090909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Kristaps Porzingis</td>\n",
       "      <td>4</td>\n",
       "      <td>44</td>\n",
       "      <td>0.090909</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 espn_name  octy_count  game_count  octy_pct\n",
       "153        P.J. Washington           1           2  0.500000\n",
       "0            Anthony Davis          14          48  0.291667\n",
       "2              Joel Embiid          11          42  0.261905\n",
       "3            Kawhi Leonard          10          44  0.227273\n",
       "1             James Harden          12          54  0.222222\n",
       "167  Juan Toscano-Anderson           1           5  0.200000\n",
       "30            Kyrie Irving           4          20  0.200000\n",
       "9             John Collins           6          33  0.181818\n",
       "6           Brandon Ingram           8          49  0.163265\n",
       "4             Nikola Jokic           9          57  0.157895\n",
       "5             Jayson Tatum           8          52  0.153846\n",
       "8            Pascal Siakam           7          46  0.152174\n",
       "10         Josh Richardson           6          44  0.136364\n",
       "11          Nikola Vucevic           6          46  0.130435\n",
       "13            Kemba Walker           6          46  0.130435\n",
       "7           Damian Lillard           7          54  0.129630\n",
       "12       LaMarcus Aldridge           6          52  0.115385\n",
       "28      Karl-Anthony Towns           4          35  0.114286\n",
       "19              Kyle Lowry           5          45  0.111111\n",
       "20            Jamal Murray           5          47  0.106383\n",
       "17            Myles Turner           5          47  0.106383\n",
       "15              Kevin Love           5          48  0.104167\n",
       "14            Bradley Beal           5          49  0.102041\n",
       "154           Josh Jackson           1          10  0.100000\n",
       "136           Kadeem Allen           1          10  0.100000\n",
       "21            LeBron James           5          53  0.094340\n",
       "50          Jonathan Isaac           3          32  0.093750\n",
       "148        Justise Winslow           1          11  0.090909\n",
       "22        Robert Covington           5          55  0.090909\n",
       "24      Kristaps Porzingis           4          44  0.090909"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged.head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(189, 6)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rosters_merge = merged.merge(rosters, left_on='espn_name', right_on='fullName', how='left')\n",
    "rosters_merge.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "teamId\n",
       "9.0     0.045649\n",
       "1.0     0.051686\n",
       "2.0     0.051975\n",
       "12.0    0.055137\n",
       "3.0     0.057443\n",
       "11.0    0.057836\n",
       "5.0     0.060552\n",
       "6.0     0.065918\n",
       "8.0     0.066121\n",
       "10.0    0.066642\n",
       "7.0     0.067442\n",
       "4.0     0.091369\n",
       "Name: octy_pct, dtype: float64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rosters_merge.groupby('teamId')['octy_pct'].mean().sort_values()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "teamId\n",
       "2.0     19\n",
       "1.0     23\n",
       "8.0     24\n",
       "9.0     24\n",
       "12.0    24\n",
       "11.0    27\n",
       "3.0     29\n",
       "6.0     29\n",
       "5.0     33\n",
       "7.0     37\n",
       "10.0    41\n",
       "4.0     55\n",
       "Name: octy_count, dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rosters_merge.groupby('teamId')['octy_count'].sum().sort_values()"
   ]
  },
  {
   "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>espn_name</th>\n",
       "      <th>octy_count</th>\n",
       "      <th>game_count</th>\n",
       "      <th>octy_pct</th>\n",
       "      <th>fullName</th>\n",
       "      <th>teamId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Joel Embiid</td>\n",
       "      <td>11</td>\n",
       "      <td>42</td>\n",
       "      <td>0.261905</td>\n",
       "      <td>Joel Embiid</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kawhi Leonard</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>0.227273</td>\n",
       "      <td>Kawhi Leonard</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Pascal Siakam</td>\n",
       "      <td>7</td>\n",
       "      <td>46</td>\n",
       "      <td>0.152174</td>\n",
       "      <td>Pascal Siakam</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Kristaps Porzingis</td>\n",
       "      <td>4</td>\n",
       "      <td>44</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>Kristaps Porzingis</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Zach LaVine</td>\n",
       "      <td>5</td>\n",
       "      <td>58</td>\n",
       "      <td>0.086207</td>\n",
       "      <td>Zach LaVine</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Goran Dragic</td>\n",
       "      <td>3</td>\n",
       "      <td>46</td>\n",
       "      <td>0.065217</td>\n",
       "      <td>Goran Dragic</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Andrew Wiggins</td>\n",
       "      <td>3</td>\n",
       "      <td>47</td>\n",
       "      <td>0.063830</td>\n",
       "      <td>Andrew Wiggins</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>3</td>\n",
       "      <td>49</td>\n",
       "      <td>0.061224</td>\n",
       "      <td>Lonzo Ball</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Jonas Valanciunas</td>\n",
       "      <td>3</td>\n",
       "      <td>54</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>Jonas Valanciunas</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Dennis Schroder</td>\n",
       "      <td>3</td>\n",
       "      <td>56</td>\n",
       "      <td>0.053571</td>\n",
       "      <td>Dennis Schroder</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>Norman Powell</td>\n",
       "      <td>1</td>\n",
       "      <td>38</td>\n",
       "      <td>0.026316</td>\n",
       "      <td>Norman Powell</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>Patrick Beverley</td>\n",
       "      <td>1</td>\n",
       "      <td>41</td>\n",
       "      <td>0.024390</td>\n",
       "      <td>Patrick Beverley</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>JJ Redick</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>0.019231</td>\n",
       "      <td>JJ Redick</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              espn_name  octy_count  game_count  octy_pct            fullName  \\\n",
       "2           Joel Embiid          11          42  0.261905         Joel Embiid   \n",
       "3         Kawhi Leonard          10          44  0.227273       Kawhi Leonard   \n",
       "11        Pascal Siakam           7          46  0.152174       Pascal Siakam   \n",
       "29   Kristaps Porzingis           4          44  0.090909  Kristaps Porzingis   \n",
       "33          Zach LaVine           5          58  0.086207         Zach LaVine   \n",
       "44         Goran Dragic           3          46  0.065217        Goran Dragic   \n",
       "45       Andrew Wiggins           3          47  0.063830      Andrew Wiggins   \n",
       "50           Lonzo Ball           3          49  0.061224          Lonzo Ball   \n",
       "61    Jonas Valanciunas           3          54  0.055556   Jonas Valanciunas   \n",
       "66      Dennis Schroder           3          56  0.053571     Dennis Schroder   \n",
       "131       Norman Powell           1          38  0.026316       Norman Powell   \n",
       "141    Patrick Beverley           1          41  0.024390    Patrick Beverley   \n",
       "162           JJ Redick           1          52  0.019231           JJ Redick   \n",
       "\n",
       "     teamId  \n",
       "2       4.0  \n",
       "3       4.0  \n",
       "11      4.0  \n",
       "29      4.0  \n",
       "33      4.0  \n",
       "44      4.0  \n",
       "45      4.0  \n",
       "50      4.0  \n",
       "61      4.0  \n",
       "66      4.0  \n",
       "131     4.0  \n",
       "141     4.0  \n",
       "162     4.0  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rosters_merge.loc[rosters_merge.teamId == 4]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>espn_name</th>\n",
       "      <th>octy_count</th>\n",
       "      <th>game_count</th>\n",
       "      <th>octy_pct</th>\n",
       "      <th>fullName</th>\n",
       "      <th>teamId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Nikola Jokic</td>\n",
       "      <td>9</td>\n",
       "      <td>57</td>\n",
       "      <td>0.157895</td>\n",
       "      <td>Nikola Jokic</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Josh Richardson</td>\n",
       "      <td>6</td>\n",
       "      <td>44</td>\n",
       "      <td>0.136364</td>\n",
       "      <td>Josh Richardson</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Myles Turner</td>\n",
       "      <td>5</td>\n",
       "      <td>47</td>\n",
       "      <td>0.106383</td>\n",
       "      <td>Myles Turner</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Mikal Bridges</td>\n",
       "      <td>5</td>\n",
       "      <td>58</td>\n",
       "      <td>0.086207</td>\n",
       "      <td>Mikal Bridges</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Miles Bridges</td>\n",
       "      <td>4</td>\n",
       "      <td>56</td>\n",
       "      <td>0.071429</td>\n",
       "      <td>Miles Bridges</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Maxi Kleber</td>\n",
       "      <td>3</td>\n",
       "      <td>57</td>\n",
       "      <td>0.052632</td>\n",
       "      <td>Maxi Kleber</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>PJ Washington</td>\n",
       "      <td>2</td>\n",
       "      <td>47</td>\n",
       "      <td>0.042553</td>\n",
       "      <td>PJ Washington</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Derrick Rose</td>\n",
       "      <td>2</td>\n",
       "      <td>47</td>\n",
       "      <td>0.042553</td>\n",
       "      <td>Derrick Rose</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Giannis Antetokounmpo</td>\n",
       "      <td>2</td>\n",
       "      <td>51</td>\n",
       "      <td>0.039216</td>\n",
       "      <td>Giannis Antetokounmpo</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>Elfrid Payton</td>\n",
       "      <td>1</td>\n",
       "      <td>36</td>\n",
       "      <td>0.027778</td>\n",
       "      <td>Elfrid Payton</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>Seth Curry</td>\n",
       "      <td>1</td>\n",
       "      <td>54</td>\n",
       "      <td>0.018519</td>\n",
       "      <td>Seth Curry</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>Julius Randle</td>\n",
       "      <td>1</td>\n",
       "      <td>55</td>\n",
       "      <td>0.018182</td>\n",
       "      <td>Julius Randle</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 espn_name  octy_count  game_count  octy_pct  \\\n",
       "9             Nikola Jokic           9          57  0.157895   \n",
       "12         Josh Richardson           6          44  0.136364   \n",
       "20            Myles Turner           5          47  0.106383   \n",
       "32           Mikal Bridges           5          58  0.086207   \n",
       "40           Miles Bridges           4          56  0.071429   \n",
       "68             Maxi Kleber           3          57  0.052632   \n",
       "82           PJ Washington           2          47  0.042553   \n",
       "84            Derrick Rose           2          47  0.042553   \n",
       "91   Giannis Antetokounmpo           2          51  0.039216   \n",
       "127          Elfrid Payton           1          36  0.027778   \n",
       "171             Seth Curry           1          54  0.018519   \n",
       "175          Julius Randle           1          55  0.018182   \n",
       "\n",
       "                  fullName  teamId  \n",
       "9             Nikola Jokic    10.0  \n",
       "12         Josh Richardson    10.0  \n",
       "20            Myles Turner    10.0  \n",
       "32           Mikal Bridges    10.0  \n",
       "40           Miles Bridges    10.0  \n",
       "68             Maxi Kleber    10.0  \n",
       "82           PJ Washington    10.0  \n",
       "84            Derrick Rose    10.0  \n",
       "91   Giannis Antetokounmpo    10.0  \n",
       "127          Elfrid Payton    10.0  \n",
       "171             Seth Curry    10.0  \n",
       "175          Julius Randle    10.0  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rosters_merge.loc[rosters_merge.teamId == 10]"
   ]
  },
  {
   "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>espn_name</th>\n",
       "      <th>octy_count</th>\n",
       "      <th>game_count</th>\n",
       "      <th>octy_pct</th>\n",
       "      <th>fullName</th>\n",
       "      <th>teamId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>P.J. Washington</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Josh Jackson</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0.125000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Kadeem Allen</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Jonathan Isaac</td>\n",
       "      <td>3</td>\n",
       "      <td>32</td>\n",
       "      <td>0.093750</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Justise Winslow</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Lauri Markkanen</td>\n",
       "      <td>4</td>\n",
       "      <td>46</td>\n",
       "      <td>0.086957</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>PJ Dozier</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>0.066667</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Jabari Parker</td>\n",
       "      <td>2</td>\n",
       "      <td>33</td>\n",
       "      <td>0.060606</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Josh Okogie</td>\n",
       "      <td>3</td>\n",
       "      <td>51</td>\n",
       "      <td>0.058824</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Maxi Kleber</td>\n",
       "      <td>3</td>\n",
       "      <td>54</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Damion Lee</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Derrick Jones Jr</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>0.048780</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Cameron Johnson</td>\n",
       "      <td>2</td>\n",
       "      <td>42</td>\n",
       "      <td>0.047619</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Marvin Williams</td>\n",
       "      <td>2</td>\n",
       "      <td>43</td>\n",
       "      <td>0.046512</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Gary Harris</td>\n",
       "      <td>2</td>\n",
       "      <td>46</td>\n",
       "      <td>0.043478</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>PJ Washington</td>\n",
       "      <td>2</td>\n",
       "      <td>47</td>\n",
       "      <td>0.042553</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Matisse Thybulle</td>\n",
       "      <td>2</td>\n",
       "      <td>48</td>\n",
       "      <td>0.041667</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Cam Reddish</td>\n",
       "      <td>2</td>\n",
       "      <td>49</td>\n",
       "      <td>0.040816</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Jeff Teague</td>\n",
       "      <td>2</td>\n",
       "      <td>49</td>\n",
       "      <td>0.040816</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>Kentavious Caldwell-Pope</td>\n",
       "      <td>2</td>\n",
       "      <td>53</td>\n",
       "      <td>0.037736</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    espn_name  octy_count  game_count  octy_pct fullName  \\\n",
       "0             P.J. Washington           1           1  1.000000      NaN   \n",
       "14               Josh Jackson           1           8  0.125000      NaN   \n",
       "20               Kadeem Allen           1          10  0.100000      NaN   \n",
       "24             Jonathan Isaac           3          32  0.093750      NaN   \n",
       "26            Justise Winslow           1          11  0.090909      NaN   \n",
       "33            Lauri Markkanen           4          46  0.086957      NaN   \n",
       "41                  PJ Dozier           1          15  0.066667      NaN   \n",
       "49              Jabari Parker           2          33  0.060606      NaN   \n",
       "52                Josh Okogie           3          51  0.058824      NaN   \n",
       "63                Maxi Kleber           3          54  0.055556      NaN   \n",
       "69                 Damion Lee           2          40  0.050000      NaN   \n",
       "70           Derrick Jones Jr           2          41  0.048780      NaN   \n",
       "72            Cameron Johnson           2          42  0.047619      NaN   \n",
       "74            Marvin Williams           2          43  0.046512      NaN   \n",
       "80                Gary Harris           2          46  0.043478      NaN   \n",
       "82              PJ Washington           2          47  0.042553      NaN   \n",
       "85           Matisse Thybulle           2          48  0.041667      NaN   \n",
       "88                Cam Reddish           2          49  0.040816      NaN   \n",
       "87                Jeff Teague           2          49  0.040816      NaN   \n",
       "101  Kentavious Caldwell-Pope           2          53  0.037736      NaN   \n",
       "\n",
       "     teamId  \n",
       "0       NaN  \n",
       "14      NaN  \n",
       "20      NaN  \n",
       "24      NaN  \n",
       "26      NaN  \n",
       "33      NaN  \n",
       "41      NaN  \n",
       "49      NaN  \n",
       "52      NaN  \n",
       "63      NaN  \n",
       "69      NaN  \n",
       "70      NaN  \n",
       "72      NaN  \n",
       "74      NaN  \n",
       "80      NaN  \n",
       "82      NaN  \n",
       "85      NaN  \n",
       "88      NaN  \n",
       "87      NaN  \n",
       "101     NaN  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# should only be players on waiver wire\n",
    "rosters_merge.loc[rosters_merge.fullName.isnull()].sort_values('octy_pct', ascending=False).head(20)"
   ]
  },
  {
   "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
}