01.02_Scrape_Combine_Data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import pfr"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Scraped: http://www.pro-football-reference.com/draft/2000-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2001-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2002-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2003-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2004-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2005-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2006-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2007-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2008-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2009-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2010-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2011-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2012-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2013-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2014-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2015-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2016-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2017-combine.htm\n",
      "Scraped: http://www.pro-football-reference.com/draft/2018-combine.htm\n"
     ]
    }
   ],
   "source": [
    "url_template = \"http://www.pro-football-reference.com/draft/{}-combine.htm\"\n",
    "row_css_selector = \"#combine > tbody > tr\" \n",
    "col_css_selector = \"#combine > thead > tr > th.poptip\"\n",
    "dfs = []\n",
    "errors = []\n",
    "for i in range (2000, 2019):\n",
    "    url = url_template.format(i)\n",
    "    try:\n",
    "        df = pfr.get_combine_table(url, row_css_selector, col_css_selector, 0, 3)\n",
    "        df[\"Year\"] = i\n",
    "        dfs.append(df)\n",
    "        print('Scraped:', url)\n",
    "    except Exception as e:\n",
    "        errors.append([url, e])\n",
    "        print('ERROR:', url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "19"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(dfs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(errors)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "errors"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.concat(dfs, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Pos</th>\n",
       "      <th>School</th>\n",
       "      <th>College</th>\n",
       "      <th>Ht</th>\n",
       "      <th>Wt</th>\n",
       "      <th>40yd</th>\n",
       "      <th>Vertical</th>\n",
       "      <th>Bench</th>\n",
       "      <th>Broad Jump</th>\n",
       "      <th>3Cone</th>\n",
       "      <th>Shuttle</th>\n",
       "      <th>Drafted (tm/rnd/yr)</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>(John Abraham, AbraJo00)</td>\n",
       "      <td>OLB</td>\n",
       "      <td>South Carolina</td>\n",
       "      <td></td>\n",
       "      <td>6-4</td>\n",
       "      <td>252</td>\n",
       "      <td>4.55</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>New York Jets / 1st / 13th pick / 2000</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>(Shaun Alexander, AlexSh00)</td>\n",
       "      <td>RB</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>https://www.sports-reference.com/cfb/players/s...</td>\n",
       "      <td>6-0</td>\n",
       "      <td>218</td>\n",
       "      <td>4.58</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Seattle Seahawks / 1st / 19th pick / 2000</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>(Darnell Alford, AlfoDa20)</td>\n",
       "      <td>OT</td>\n",
       "      <td>Boston College</td>\n",
       "      <td></td>\n",
       "      <td>6-4</td>\n",
       "      <td>334</td>\n",
       "      <td>5.56</td>\n",
       "      <td>25.0</td>\n",
       "      <td>23</td>\n",
       "      <td>94</td>\n",
       "      <td>8.48</td>\n",
       "      <td>4.98</td>\n",
       "      <td>Kansas City Chiefs / 6th / 188th pick / 2000</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>(Kyle Allamon, None)</td>\n",
       "      <td>TE</td>\n",
       "      <td>Texas Tech</td>\n",
       "      <td></td>\n",
       "      <td>6-2</td>\n",
       "      <td>253</td>\n",
       "      <td>4.97</td>\n",
       "      <td>29.0</td>\n",
       "      <td></td>\n",
       "      <td>104</td>\n",
       "      <td>7.29</td>\n",
       "      <td>4.49</td>\n",
       "      <td></td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>(Rashard Anderson, AndeRa21)</td>\n",
       "      <td>CB</td>\n",
       "      <td>Jackson State</td>\n",
       "      <td></td>\n",
       "      <td>6-2</td>\n",
       "      <td>206</td>\n",
       "      <td>4.55</td>\n",
       "      <td>34.0</td>\n",
       "      <td></td>\n",
       "      <td>123</td>\n",
       "      <td>7.18</td>\n",
       "      <td>4.15</td>\n",
       "      <td>Carolina Panthers / 1st / 23rd pick / 2000</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Player  Pos          School  \\\n",
       "0      (John Abraham, AbraJo00)  OLB  South Carolina   \n",
       "1   (Shaun Alexander, AlexSh00)   RB         Alabama   \n",
       "2    (Darnell Alford, AlfoDa20)   OT  Boston College   \n",
       "3          (Kyle Allamon, None)   TE      Texas Tech   \n",
       "4  (Rashard Anderson, AndeRa21)   CB   Jackson State   \n",
       "\n",
       "                                             College   Ht   Wt  40yd Vertical  \\\n",
       "0                                                     6-4  252  4.55            \n",
       "1  https://www.sports-reference.com/cfb/players/s...  6-0  218  4.58            \n",
       "2                                                     6-4  334  5.56     25.0   \n",
       "3                                                     6-2  253  4.97     29.0   \n",
       "4                                                     6-2  206  4.55     34.0   \n",
       "\n",
       "  Bench Broad Jump 3Cone Shuttle  \\\n",
       "0                                  \n",
       "1                                  \n",
       "2    23         94  8.48    4.98   \n",
       "3              104  7.29    4.49   \n",
       "4              123  7.18    4.15   \n",
       "\n",
       "                            Drafted (tm/rnd/yr)  Year  \n",
       "0        New York Jets / 1st / 13th pick / 2000  2000  \n",
       "1     Seattle Seahawks / 1st / 19th pick / 2000  2000  \n",
       "2  Kansas City Chiefs / 6th / 188th pick / 2000  2000  \n",
       "3                                                2000  \n",
       "4    Carolina Panthers / 1st / 23rd pick / 2000  2000  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Pos</th>\n",
       "      <th>School</th>\n",
       "      <th>College</th>\n",
       "      <th>Ht</th>\n",
       "      <th>Wt</th>\n",
       "      <th>40yd</th>\n",
       "      <th>Vertical</th>\n",
       "      <th>Bench</th>\n",
       "      <th>Broad Jump</th>\n",
       "      <th>3Cone</th>\n",
       "      <th>Shuttle</th>\n",
       "      <th>Drafted (tm/rnd/yr)</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6213</th>\n",
       "      <td>(Chris Worley, WorlCh00)</td>\n",
       "      <td>ILB</td>\n",
       "      <td>Ohio St.</td>\n",
       "      <td>https://www.sports-reference.com/cfb/players/c...</td>\n",
       "      <td>6-2</td>\n",
       "      <td>238</td>\n",
       "      <td>4.86</td>\n",
       "      <td>29.5</td>\n",
       "      <td>15</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6214</th>\n",
       "      <td>(Isaiah Wynn, WynnIs00)</td>\n",
       "      <td>OG</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>https://www.sports-reference.com/cfb/players/i...</td>\n",
       "      <td>6-3</td>\n",
       "      <td>313</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>New England Patriots / 1st / 23rd pick / 2018</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6215</th>\n",
       "      <td>(Isaac Yiadom, YiadIs00)</td>\n",
       "      <td>CB</td>\n",
       "      <td>Boston College</td>\n",
       "      <td>https://www.sports-reference.com/cfb/players/i...</td>\n",
       "      <td>6-1</td>\n",
       "      <td>190</td>\n",
       "      <td>4.52</td>\n",
       "      <td></td>\n",
       "      <td>8</td>\n",
       "      <td>120</td>\n",
       "      <td></td>\n",
       "      <td>4.18</td>\n",
       "      <td>Denver Broncos / 3rd / 99th pick / 2018</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6216</th>\n",
       "      <td>(Kenny Young, None)</td>\n",
       "      <td>ILB</td>\n",
       "      <td>UCLA</td>\n",
       "      <td>https://www.sports-reference.com/cfb/players/k...</td>\n",
       "      <td>6-1</td>\n",
       "      <td>236</td>\n",
       "      <td>4.60</td>\n",
       "      <td>36.0</td>\n",
       "      <td>23</td>\n",
       "      <td>117</td>\n",
       "      <td>7.38</td>\n",
       "      <td>4.48</td>\n",
       "      <td></td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6217</th>\n",
       "      <td>(Trevon Young, YounTr00)</td>\n",
       "      <td>EDGE</td>\n",
       "      <td>Louisville</td>\n",
       "      <td>https://www.sports-reference.com/cfb/players/t...</td>\n",
       "      <td>6-4</td>\n",
       "      <td>258</td>\n",
       "      <td>4.78</td>\n",
       "      <td>33.0</td>\n",
       "      <td>25</td>\n",
       "      <td>114</td>\n",
       "      <td>6.99</td>\n",
       "      <td>4.40</td>\n",
       "      <td>Los Angeles Rams / 6th / 205th pick / 2018</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Player   Pos          School  \\\n",
       "6213  (Chris Worley, WorlCh00)   ILB        Ohio St.   \n",
       "6214   (Isaiah Wynn, WynnIs00)    OG         Georgia   \n",
       "6215  (Isaac Yiadom, YiadIs00)    CB  Boston College   \n",
       "6216       (Kenny Young, None)   ILB            UCLA   \n",
       "6217  (Trevon Young, YounTr00)  EDGE      Louisville   \n",
       "\n",
       "                                                College   Ht   Wt  40yd  \\\n",
       "6213  https://www.sports-reference.com/cfb/players/c...  6-2  238  4.86   \n",
       "6214  https://www.sports-reference.com/cfb/players/i...  6-3  313         \n",
       "6215  https://www.sports-reference.com/cfb/players/i...  6-1  190  4.52   \n",
       "6216  https://www.sports-reference.com/cfb/players/k...  6-1  236  4.60   \n",
       "6217  https://www.sports-reference.com/cfb/players/t...  6-4  258  4.78   \n",
       "\n",
       "     Vertical Bench Broad Jump 3Cone Shuttle  \\\n",
       "6213     29.5    15                            \n",
       "6214                                           \n",
       "6215              8        120          4.18   \n",
       "6216     36.0    23        117  7.38    4.48   \n",
       "6217     33.0    25        114  6.99    4.40   \n",
       "\n",
       "                                Drafted (tm/rnd/yr)  Year  \n",
       "6213                                                 2018  \n",
       "6214  New England Patriots / 1st / 23rd pick / 2018  2018  \n",
       "6215        Denver Broncos / 3rd / 99th pick / 2018  2018  \n",
       "6216                                                 2018  \n",
       "6217     Los Angeles Rams / 6th / 205th pick / 2018  2018  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 6218 entries, 0 to 6217\n",
      "Data columns (total 14 columns):\n",
      "Player                 6218 non-null object\n",
      "Pos                    6218 non-null object\n",
      "School                 6218 non-null object\n",
      "College                6218 non-null object\n",
      "Ht                     6218 non-null object\n",
      "Wt                     6218 non-null object\n",
      "40yd                   6218 non-null object\n",
      "Vertical               6218 non-null object\n",
      "Bench                  6218 non-null object\n",
      "Broad Jump             6218 non-null object\n",
      "3Cone                  6218 non-null object\n",
      "Shuttle                6218 non-null object\n",
      "Drafted (tm/rnd/yr)    6218 non-null object\n",
      "Year                   6218 non-null int64\n",
      "dtypes: int64(1), object(13)\n",
      "memory usage: 680.2+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[[\"Player\", \"Pfr_ID\"]] = df.Player.apply(pd.Series)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"Sref_Cfb_ID\"] = df.College.str.extract(\"/.*/.*/(.*)\\.\", expand=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 6218 entries, 0 to 6217\n",
      "Data columns (total 16 columns):\n",
      "Player                 6218 non-null object\n",
      "Pos                    6218 non-null object\n",
      "School                 6218 non-null object\n",
      "College                6218 non-null object\n",
      "Ht                     6218 non-null object\n",
      "Wt                     6218 non-null object\n",
      "40yd                   6218 non-null object\n",
      "Vertical               6218 non-null object\n",
      "Bench                  6218 non-null object\n",
      "Broad Jump             6218 non-null object\n",
      "3Cone                  6218 non-null object\n",
      "Shuttle                6218 non-null object\n",
      "Drafted (tm/rnd/yr)    6218 non-null object\n",
      "Year                   6218 non-null int64\n",
      "Pfr_ID                 4895 non-null object\n",
      "Sref_Cfb_ID            4841 non-null object\n",
      "dtypes: int64(1), object(15)\n",
      "memory usage: 777.3+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Player</th>\n",
       "      <th>Pos</th>\n",
       "      <th>School</th>\n",
       "      <th>College</th>\n",
       "      <th>Ht</th>\n",
       "      <th>Wt</th>\n",
       "      <th>40yd</th>\n",
       "      <th>Vertical</th>\n",
       "      <th>Bench</th>\n",
       "      <th>Broad Jump</th>\n",
       "      <th>3Cone</th>\n",
       "      <th>Shuttle</th>\n",
       "      <th>Drafted (tm/rnd/yr)</th>\n",
       "      <th>Year</th>\n",
       "      <th>Pfr_ID</th>\n",
       "      <th>Sref_Cfb_ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>John Abraham</td>\n",
       "      <td>OLB</td>\n",
       "      <td>South Carolina</td>\n",
       "      <td></td>\n",
       "      <td>6-4</td>\n",
       "      <td>252</td>\n",
       "      <td>4.55</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>New York Jets / 1st / 13th pick / 2000</td>\n",
       "      <td>2000</td>\n",
       "      <td>AbraJo00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Shaun Alexander</td>\n",
       "      <td>RB</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>https://www.sports-reference.com/cfb/players/s...</td>\n",
       "      <td>6-0</td>\n",
       "      <td>218</td>\n",
       "      <td>4.58</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Seattle Seahawks / 1st / 19th pick / 2000</td>\n",
       "      <td>2000</td>\n",
       "      <td>AlexSh00</td>\n",
       "      <td>shaun-alexander-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Darnell Alford</td>\n",
       "      <td>OT</td>\n",
       "      <td>Boston College</td>\n",
       "      <td></td>\n",
       "      <td>6-4</td>\n",
       "      <td>334</td>\n",
       "      <td>5.56</td>\n",
       "      <td>25.0</td>\n",
       "      <td>23</td>\n",
       "      <td>94</td>\n",
       "      <td>8.48</td>\n",
       "      <td>4.98</td>\n",
       "      <td>Kansas City Chiefs / 6th / 188th pick / 2000</td>\n",
       "      <td>2000</td>\n",
       "      <td>AlfoDa20</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kyle Allamon</td>\n",
       "      <td>TE</td>\n",
       "      <td>Texas Tech</td>\n",
       "      <td></td>\n",
       "      <td>6-2</td>\n",
       "      <td>253</td>\n",
       "      <td>4.97</td>\n",
       "      <td>29.0</td>\n",
       "      <td></td>\n",
       "      <td>104</td>\n",
       "      <td>7.29</td>\n",
       "      <td>4.49</td>\n",
       "      <td></td>\n",
       "      <td>2000</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Rashard Anderson</td>\n",
       "      <td>CB</td>\n",
       "      <td>Jackson State</td>\n",
       "      <td></td>\n",
       "      <td>6-2</td>\n",
       "      <td>206</td>\n",
       "      <td>4.55</td>\n",
       "      <td>34.0</td>\n",
       "      <td></td>\n",
       "      <td>123</td>\n",
       "      <td>7.18</td>\n",
       "      <td>4.15</td>\n",
       "      <td>Carolina Panthers / 1st / 23rd pick / 2000</td>\n",
       "      <td>2000</td>\n",
       "      <td>AndeRa21</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Player  Pos          School  \\\n",
       "0      John Abraham  OLB  South Carolina   \n",
       "1   Shaun Alexander   RB         Alabama   \n",
       "2    Darnell Alford   OT  Boston College   \n",
       "3      Kyle Allamon   TE      Texas Tech   \n",
       "4  Rashard Anderson   CB   Jackson State   \n",
       "\n",
       "                                             College   Ht   Wt  40yd Vertical  \\\n",
       "0                                                     6-4  252  4.55            \n",
       "1  https://www.sports-reference.com/cfb/players/s...  6-0  218  4.58            \n",
       "2                                                     6-4  334  5.56     25.0   \n",
       "3                                                     6-2  253  4.97     29.0   \n",
       "4                                                     6-2  206  4.55     34.0   \n",
       "\n",
       "  Bench Broad Jump 3Cone Shuttle  \\\n",
       "0                                  \n",
       "1                                  \n",
       "2    23         94  8.48    4.98   \n",
       "3              104  7.29    4.49   \n",
       "4              123  7.18    4.15   \n",
       "\n",
       "                            Drafted (tm/rnd/yr)  Year    Pfr_ID  \\\n",
       "0        New York Jets / 1st / 13th pick / 2000  2000  AbraJo00   \n",
       "1     Seattle Seahawks / 1st / 19th pick / 2000  2000  AlexSh00   \n",
       "2  Kansas City Chiefs / 6th / 188th pick / 2000  2000  AlfoDa20   \n",
       "3                                                2000      None   \n",
       "4    Carolina Panthers / 1st / 23rd pick / 2000  2000  AndeRa21   \n",
       "\n",
       "         Sref_Cfb_ID  \n",
       "0                NaN  \n",
       "1  shaun-alexander-1  \n",
       "2                NaN  \n",
       "3                NaN  \n",
       "4                NaN  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"raw_data/pfr_combine_data.csv\", index=False)"
   ]
  }
 ],
 "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.6.5"
  },
  "nav_menu": {},
  "toc": {
   "navigate_menu": true,
   "number_sections": false,
   "sideBar": false,
   "threshold": 6,
   "toc_cell": false,
   "toc_section_display": "block",
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}