01.01_Scrape_First_4_Year_AV.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": [],
   "source": [
    "url_template = \"https://www.pro-football-reference.com/play-index/psl_finder.\"\\\n",
    "               \"cgi?request=1&match=combined&year_min=2000&year_max=2017&seas\"\\\n",
    "               \"on_start=1&season_end=4&pos%5B%5D=qb&pos%5B%5D=rb&pos%5B%5D=wr\"\\\n",
    "               \"&pos%5B%5D=te&pos%5B%5D=e&pos%5B%5D=t&pos%5B%5D=g&pos%5B%5D=c&\"\\\n",
    "               \"pos%5B%5D=ol&pos%5B%5D=dt&pos%5B%5D=de&pos%5B%5D=dl&pos%5B%5D=\"\\\n",
    "               \"ilb&pos%5B%5D=olb&pos%5B%5D=lb&pos%5B%5D=cb&pos%5B%5D=s&pos%5B\"\\\n",
    "               \"%5D=db&pos%5B%5D=k&pos%5B%5D=p&draft_year_min=1936&draft_year_\"\\\n",
    "               \"max=2017&draft_slot_min=1&draft_slot_max=500&draft_pick_in_\"\\\n",
    "               \"round=pick_overall&conference=any&draft_pos%5B%5D=qb&draft_pos\"\\\n",
    "               \"%5B%5D=rb&draft_pos%5B%5D=wr&draft_pos%5B%5D=te&draft_pos%5B%5\"\\\n",
    "               \"D=e&draft_pos%5B%5D=t&draft_pos%5B%5D=g&draft_pos%5B%5D=c&\"\\\n",
    "               \"draft_pos%5B%5D=ol&draft_pos%5B%5D=dt&draft_pos%5B%5D=de&draft\"\\\n",
    "               \"_pos%5B%5D=dl&draft_pos%5B%5D=ilb&draft_pos%5B%5D=olb&\"\\\n",
    "               \"draft_pos%5B%5D=lb&draft_pos%5B%5D=cb&draft_pos%5B%5D=s&\"\\\n",
    "               \"draft_pos%5B%5D=db&draft_pos%5B%5D=k&draft_pos%5B%5D=p&c5val=\"\\\n",
    "               \"1.0&order_by=av&offset={}\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Scraped: 0\n",
      "Scraped: 100\n",
      "Scraped: 200\n",
      "Scraped: 300\n",
      "Scraped: 400\n",
      "Scraped: 500\n",
      "Scraped: 600\n",
      "Scraped: 700\n",
      "Scraped: 800\n",
      "Scraped: 900\n",
      "Scraped: 1000\n",
      "Scraped: 1100\n",
      "Scraped: 1200\n",
      "Scraped: 1300\n",
      "Scraped: 1400\n",
      "Scraped: 1500\n",
      "Scraped: 1600\n",
      "Scraped: 1700\n",
      "Scraped: 1800\n",
      "Scraped: 1900\n",
      "Scraped: 2000\n",
      "Scraped: 2100\n",
      "Scraped: 2200\n",
      "Scraped: 2300\n",
      "Scraped: 2400\n",
      "Scraped: 2500\n",
      "Scraped: 2600\n",
      "Scraped: 2700\n",
      "Scraped: 2800\n",
      "Scraped: 2900\n",
      "Scraped: 3000\n",
      "Scraped: 3100\n",
      "Scraped: 3200\n",
      "Scraped: 3300\n",
      "Scraped: 3400\n",
      "Scraped: 3500\n",
      "Scraped: 3600\n",
      "Scraped: 3700\n",
      "Scraped: 3800\n",
      "Scraped: 3900\n",
      "Scraped: 4000\n",
      "Scraped: 4100\n",
      "Scraped: 4200\n",
      "Scraped: 4300\n",
      "Scraped: 4400\n",
      "Scraped: 4500\n",
      "Scraped: 4600\n",
      "Scraped: 4700\n",
      "Scraped: 4800\n",
      "Scraped: 4900\n",
      "Scraped: 5000\n",
      "Scraped: 5100\n",
      "Scraped: 5200\n",
      "Scraped: 5300\n",
      "Scraped: 5400\n",
      "Scraped: 5500\n",
      "Scraped: 5600\n",
      "Scraped: 5700\n",
      "Scraped: 5800\n",
      "Scraped: 5900\n",
      "Scraped: 6000\n",
      "Scraped: 6100\n",
      "Scraped: 6200\n",
      "Scraped: 6300\n",
      "Scraped: 6400\n",
      "Scraped: 6500\n",
      "Scraped: 6600\n",
      "Scraped: 6700\n",
      "Scraped: 6800\n",
      "Scraped: 6900\n",
      "Scraped: 7000\n",
      "Scraped: 7100\n",
      "Scraped: 7200\n",
      "Scraped: 7300\n",
      "Scraped: 7400\n",
      "Scraped: 7500\n",
      "Scraped: 7600\n",
      "Scraped: 7700\n",
      "Scraped: 7800\n",
      "Scraped: 7900\n",
      "Scraped: 8000\n"
     ]
    }
   ],
   "source": [
    "row_css_selector = \"#results > tbody > tr\" \n",
    "col_css_selector = \"#results > thead > tr:nth-child(2) > th\"\n",
    "dfs = []\n",
    "errors = []\n",
    "# i's represent page offset values\n",
    "for i in range (0, 8001, 100):\n",
    "    url = url_template.format(i)\n",
    "    try:\n",
    "        df = pfr.get_table(url, row_css_selector, col_css_selector, 1)\n",
    "        dfs.append(df)\n",
    "        print(\"Scraped:\", i)\n",
    "    except Exception as e:\n",
    "        errors.append([url, e])\n",
    "        print(\"ERROR:\", i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "81"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(dfs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(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": true
   },
   "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>Rk</th>\n",
       "      <th>Player</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Draft</th>\n",
       "      <th>Tm</th>\n",
       "      <th>Lg</th>\n",
       "      <th>G</th>\n",
       "      <th>GS</th>\n",
       "      <th>Yrs</th>\n",
       "      <th>PB</th>\n",
       "      <th>AP1</th>\n",
       "      <th>AV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>(Russell Wilson, WilsRu00)</td>\n",
       "      <td>2012</td>\n",
       "      <td>2015</td>\n",
       "      <td>3-75</td>\n",
       "      <td>SEA</td>\n",
       "      <td>NFL</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>(J.J. Watt, WattJ.00)</td>\n",
       "      <td>2011</td>\n",
       "      <td>2014</td>\n",
       "      <td>1-11</td>\n",
       "      <td>HTX</td>\n",
       "      <td>NFL</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>(Cam Newton, NewtCa00)</td>\n",
       "      <td>2011</td>\n",
       "      <td>2014</td>\n",
       "      <td>1-1</td>\n",
       "      <td>CAR</td>\n",
       "      <td>NFL</td>\n",
       "      <td>62</td>\n",
       "      <td>62</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>(Patrick Willis, WillPa98)</td>\n",
       "      <td>2007</td>\n",
       "      <td>2010</td>\n",
       "      <td>1-11</td>\n",
       "      <td>SFO</td>\n",
       "      <td>NFL</td>\n",
       "      <td>63</td>\n",
       "      <td>63</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>(LaDainian Tomlinson*, TomlLa00)</td>\n",
       "      <td>2001</td>\n",
       "      <td>2004</td>\n",
       "      <td>1-5</td>\n",
       "      <td>SDG</td>\n",
       "      <td>NFL</td>\n",
       "      <td>63</td>\n",
       "      <td>63</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>62</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Rk                            Player  From    To Draft   Tm   Lg   G  GS  \\\n",
       "0  1        (Russell Wilson, WilsRu00)  2012  2015  3-75  SEA  NFL  64  64   \n",
       "1  2             (J.J. Watt, WattJ.00)  2011  2014  1-11  HTX  NFL  64  64   \n",
       "2  3            (Cam Newton, NewtCa00)  2011  2014   1-1  CAR  NFL  62  62   \n",
       "3  4        (Patrick Willis, WillPa98)  2007  2010  1-11  SFO  NFL  63  63   \n",
       "4  5  (LaDainian Tomlinson*, TomlLa00)  2001  2004   1-5  SDG  NFL  63  63   \n",
       "\n",
       "  Yrs PB AP1  AV  \n",
       "0   4  3   0  70  \n",
       "1   4  3   3  67  \n",
       "2   4  2   0  63  \n",
       "3   4  4   3  63  \n",
       "4   4  2   1  62  "
      ]
     },
     "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>Rk</th>\n",
       "      <th>Player</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Draft</th>\n",
       "      <th>Tm</th>\n",
       "      <th>Lg</th>\n",
       "      <th>G</th>\n",
       "      <th>GS</th>\n",
       "      <th>Yrs</th>\n",
       "      <th>PB</th>\n",
       "      <th>AP1</th>\n",
       "      <th>AV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8052</th>\n",
       "      <td>8053</td>\n",
       "      <td>(Chris Young, YounCh03)</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014</td>\n",
       "      <td></td>\n",
       "      <td>NYJ</td>\n",
       "      <td>NFL</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8053</th>\n",
       "      <td>8054</td>\n",
       "      <td>(Michael Zimmer, ZimmMi00)</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014</td>\n",
       "      <td></td>\n",
       "      <td>SEA</td>\n",
       "      <td>NFL</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8054</th>\n",
       "      <td>8055</td>\n",
       "      <td>(Ty Zimmerman, ZimmTy00)</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014</td>\n",
       "      <td></td>\n",
       "      <td>NOR</td>\n",
       "      <td>NFL</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8055</th>\n",
       "      <td>8056</td>\n",
       "      <td>(Michael Zordich, ZordMi01)</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014</td>\n",
       "      <td></td>\n",
       "      <td>NOR</td>\n",
       "      <td>NFL</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8056</th>\n",
       "      <td>8057</td>\n",
       "      <td>(Jordan Zumwalt, ZumwJo00)</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014</td>\n",
       "      <td>6-192</td>\n",
       "      <td>PIT</td>\n",
       "      <td>NFL</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Rk                       Player  From    To  Draft   Tm   Lg  G GS  \\\n",
       "8052  8053      (Chris Young, YounCh03)  2014  2014         NYJ  NFL  0      \n",
       "8053  8054   (Michael Zimmer, ZimmMi00)  2014  2014         SEA  NFL  0      \n",
       "8054  8055     (Ty Zimmerman, ZimmTy00)  2014  2014         NOR  NFL  0      \n",
       "8055  8056  (Michael Zordich, ZordMi01)  2014  2014         NOR  NFL  0      \n",
       "8056  8057   (Jordan Zumwalt, ZumwJo00)  2014  2014  6-192  PIT  NFL  0      \n",
       "\n",
       "     Yrs PB AP1 AV  \n",
       "8052   1  0   0     \n",
       "8053   1  0   0     \n",
       "8054   1  0   0     \n",
       "8055   1  0   0     \n",
       "8056   1  0   0     "
      ]
     },
     "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: 8057 entries, 0 to 8056\n",
      "Data columns (total 13 columns):\n",
      "Rk        8057 non-null object\n",
      "Player    8057 non-null object\n",
      "From      8057 non-null object\n",
      "To        8057 non-null object\n",
      "Draft     8057 non-null object\n",
      "Tm        8057 non-null object\n",
      "Lg        8057 non-null object\n",
      "G         8057 non-null object\n",
      "GS        8057 non-null object\n",
      "Yrs       8057 non-null object\n",
      "PB        8057 non-null object\n",
      "AP1       8057 non-null object\n",
      "AV        8057 non-null object\n",
      "dtypes: object(13)\n",
      "memory usage: 818.4+ 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": [
    {
     "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>Rk</th>\n",
       "      <th>Player</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>Draft</th>\n",
       "      <th>Tm</th>\n",
       "      <th>Lg</th>\n",
       "      <th>G</th>\n",
       "      <th>GS</th>\n",
       "      <th>Yrs</th>\n",
       "      <th>PB</th>\n",
       "      <th>AP1</th>\n",
       "      <th>AV</th>\n",
       "      <th>Pfr_ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Russell Wilson</td>\n",
       "      <td>2012</td>\n",
       "      <td>2015</td>\n",
       "      <td>3-75</td>\n",
       "      <td>SEA</td>\n",
       "      <td>NFL</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>70</td>\n",
       "      <td>WilsRu00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>J.J. Watt</td>\n",
       "      <td>2011</td>\n",
       "      <td>2014</td>\n",
       "      <td>1-11</td>\n",
       "      <td>HTX</td>\n",
       "      <td>NFL</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>67</td>\n",
       "      <td>WattJ.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Cam Newton</td>\n",
       "      <td>2011</td>\n",
       "      <td>2014</td>\n",
       "      <td>1-1</td>\n",
       "      <td>CAR</td>\n",
       "      <td>NFL</td>\n",
       "      <td>62</td>\n",
       "      <td>62</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>63</td>\n",
       "      <td>NewtCa00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Patrick Willis</td>\n",
       "      <td>2007</td>\n",
       "      <td>2010</td>\n",
       "      <td>1-11</td>\n",
       "      <td>SFO</td>\n",
       "      <td>NFL</td>\n",
       "      <td>63</td>\n",
       "      <td>63</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>63</td>\n",
       "      <td>WillPa98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>LaDainian Tomlinson*</td>\n",
       "      <td>2001</td>\n",
       "      <td>2004</td>\n",
       "      <td>1-5</td>\n",
       "      <td>SDG</td>\n",
       "      <td>NFL</td>\n",
       "      <td>63</td>\n",
       "      <td>63</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>62</td>\n",
       "      <td>TomlLa00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Rk                Player  From    To Draft   Tm   Lg   G  GS Yrs PB AP1  AV  \\\n",
       "0  1        Russell Wilson  2012  2015  3-75  SEA  NFL  64  64   4  3   0  70   \n",
       "1  2             J.J. Watt  2011  2014  1-11  HTX  NFL  64  64   4  3   3  67   \n",
       "2  3            Cam Newton  2011  2014   1-1  CAR  NFL  62  62   4  2   0  63   \n",
       "3  4        Patrick Willis  2007  2010  1-11  SFO  NFL  63  63   4  4   3  63   \n",
       "4  5  LaDainian Tomlinson*  2001  2004   1-5  SDG  NFL  63  63   4  2   1  62   \n",
       "\n",
       "     Pfr_ID  \n",
       "0  WilsRu00  \n",
       "1  WattJ.00  \n",
       "2  NewtCa00  \n",
       "3  WillPa98  \n",
       "4  TomlLa00  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 8057 entries, 0 to 8056\n",
      "Data columns (total 14 columns):\n",
      "Rk        8057 non-null object\n",
      "Player    8057 non-null object\n",
      "From      8057 non-null object\n",
      "To        8057 non-null object\n",
      "Draft     8057 non-null object\n",
      "Tm        8057 non-null object\n",
      "Lg        8057 non-null object\n",
      "G         8057 non-null object\n",
      "GS        8057 non-null object\n",
      "Yrs       8057 non-null object\n",
      "PB        8057 non-null object\n",
      "AP1       8057 non-null object\n",
      "AV        8057 non-null object\n",
      "Pfr_ID    8057 non-null object\n",
      "dtypes: object(14)\n",
      "memory usage: 881.3+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"raw_data/first_4_season_AV_since_2000.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"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}