3_height_weight_data_scrape_luther.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "# Project Luther\n",
    "\n",
    "Kenny Leung - kenleung11@gmail.com\n",
    "\n",
    "Part 3/8 - Data scraping NBA drafted player's birthday, height and weight\n",
    "\n",
    "This notebook documents the process of scraping NBA drafted player's birthday, height and weight from https://www.basketball-reference.com/."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# import packages\n",
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "import pandas as pd\n",
    "import time\n",
    "import random\n",
    "import pickle\n",
    "from datetime import datetime"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data Scraping\n",
    "\n",
    "In order to scrape data located in each rookie player's extension page, I needed a list of url extensions for each rookie drafted since 2003. First I tried code for just scraping the url extensions for players drafted in 2003."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "url = 'https://www.basketball-reference.com/draft/NBA_2003.html'\n",
    "\n",
    "response = requests.get(url)\n",
    "page = response.text\n",
    "soup = BeautifulSoup(page, \"lxml\")\n",
    "\n",
    "url_list = [] # create empty list\n",
    "for x in soup.find_all(class_='left')[1::3]:\n",
    "    try: # try/except needed in case rookie player has no extension page\n",
    "        url = x.find('a')['href']\n",
    "        url_list.append(url) # append to empty list\n",
    "    except:\n",
    "        pass"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Once I was confident the code will work, I scraped the website created a url extension list for all drafted players since 2003."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2003\n",
      "2004\n",
      "2005\n",
      "2006\n",
      "2007\n",
      "2008\n",
      "2009\n",
      "2010\n",
      "2011\n",
      "2012\n",
      "2013\n",
      "2014\n",
      "2015\n",
      "2016\n"
     ]
    }
   ],
   "source": [
    "url_template = \"https://www.basketball-reference.com/draft/NBA_{year}.html\"\n",
    "url_list = []\n",
    "\n",
    "for year in range(2003, 2017):\n",
    "    print(year)\n",
    "    url = url_template.format(year=year)  # get the url\n",
    "\n",
    "    response = requests.get(url)\n",
    "    page = response.text\n",
    "\n",
    "    soup = BeautifulSoup(page, 'html5lib')\n",
    "    \n",
    "    for x in soup.find_all(class_='left')[1::3]:\n",
    "        try:\n",
    "            url = x.find('a')['href']\n",
    "            url_list.append(url)\n",
    "        except:\n",
    "            pass\n",
    "    \n",
    "    time.sleep(.5+2*random.random())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# create pickle object\n",
    "with open('draft_url_list.pkl', 'wb') as fp:\n",
    "    pickle.dump(url_list, fp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "with open(\"draft_url_list.pkl\", 'rb') as picklefile: \n",
    "    url_list = pickle.load(picklefile)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Scraping Height and Weight info from Player's extension page\n",
    "\n",
    "Now that I have a list of player's extensions, I wanted to try to scrape the birthday, height and weight of all the drafted players. I started by trying to get the data I needed on Lebron's page."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "player_url = 'https://www.basketball-reference.com/players/j/jamesle01.html'\n",
    "\n",
    "response2 = requests.get(player_url)\n",
    "page2 = response2.text\n",
    "soup2 = BeautifulSoup(page2, \"lxml\")\n",
    "\n",
    "# get player data\n",
    "Player = soup2.find_all('h1')[0].getText()\n",
    "Height_ft = int(soup2.find_all(itemprop=\"height\")[0].getText().split('-')[0]) \n",
    "Height_in = int(soup2.find_all(itemprop=\"height\")[0].getText().split('-')[1])\n",
    "Weight = int(soup2.find_all(itemprop=\"weight\")[0].getText()[:3])\n",
    "BirthMonth = [x.find_all('a') for x in soup2.find_all(itemprop=\"birthDate\")][0][0].getText().split()[0][:3]\n",
    "BirthDay = [x.find_all('a') for x in soup2.find_all(itemprop=\"birthDate\")][0][0].getText().split()[1]\n",
    "Birthyear = [x.find_all('a') for x in soup2.find_all(itemprop=\"birthDate\")][0][1].getText()\n",
    "\n",
    "date = BirthMonth + ' ' + BirthDay + ' ' + Birthyear\n",
    "Birthday = datetime.strptime(date, '%b %d %Y') # convert to datetime object using datetime module\n",
    "\n",
    "column_headers = ['Player', 'Birthday', 'Height_ft', 'Height_in', 'Weight']\n",
    "player_data = [Player, Birthday, Height_ft, Height_in, Weight]\n",
    "\n",
    "dic = dict(zip(column_headers,player_data))\n",
    "\n",
    "df = pd.DataFrame(dic,columns=column_headers, index=[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\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>Birthday</th>\n",
       "      <th>Height_ft</th>\n",
       "      <th>Height_in</th>\n",
       "      <th>Weight</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LeBron James</td>\n",
       "      <td>1984-12-30</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>250</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Player   Birthday  Height_ft  Height_in  Weight\n",
       "0  LeBron James 1984-12-30          6          8     250"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/players/j/jamesle01.html\n",
      "/players/m/milicda01.html\n",
      "/players/a/anthoca01.html\n",
      "/players/b/boshch01.html\n",
      "/players/w/wadedw01.html\n",
      "/players/k/kamanch01.html\n",
      "/players/h/hinriki01.html\n",
      "/players/f/fordtj01.html\n",
      "/players/s/sweetmi01.html\n",
      "/players/h/hayesja01.html\n",
      "/players/p/pietrmi01.html\n",
      "/players/c/collini01.html\n",
      "/players/b/banksma01.html\n",
      "/players/r/ridnolu01.html\n",
      "/players/g/gainere01.html\n",
      "/players/b/belltr01.html\n",
      "/players/c/cabarza01.html\n",
      "/players/w/westda01.html\n",
      "/players/p/pavloal01.html\n",
      "/players/j/jonesda02.html\n",
      "/players/d/diawbo01.html\n",
      "/players/p/planizo01.html\n",
      "/players/o/outlatr01.html\n",
      "/players/c/cookbr01.html\n",
      "/players/d/delfica01.html\n",
      "/players/e/ebind01.html\n",
      "/players/p/perkike01.html\n",
      "/players/b/barbole01.html\n",
      "/players/h/howarjo01.html\n",
      "/players/l/lampema01.html\n",
      "/players/k/kaponja01.html\n",
      "/players/w/waltolu01.html\n",
      "/players/b/beaslje01.html\n",
      "/players/s/schorso01.html\n",
      "/players/s/szewcsz01.html\n",
      "/players/a/austima01.html\n",
      "/players/h/hansetr01.html\n",
      "/players/b/blakest01.html\n",
      "/players/v/vranesl01.html\n",
      "/players/z/zimmede01.html\n",
      "/players/g/greenwi01.html\n",
      "/players/p/pachuza01.html\n",
      "/players/b/boganke01.html\n",
      "/players/b/bonnema01.html\n",
      "/players/b/becirsa01.html\n",
      "/players/w/willima01.html\n",
      "/players/l/langja01.html\n",
      "/players/j/jonesja02.html\n",
      "/players/m/morlepa01.html\n",
      "/players/k/korveky01.html\n",
      "/players/s/sinanne01.html\n",
      "/players/h/huntebr01.html\n",
      "/players/y/yuyanxu01.html\n",
      "/players/g/glynian01.html\n",
      "/players/h/howardw01.html\n",
      "/players/o/okafoem01.html\n",
      "/players/g/gordobe01.html\n",
      "/players/l/livinsh01.html\n",
      "/players/h/harride01.html\n",
      "/players/c/childjo01.html\n",
      "/players/d/denglu01.html\n",
      "/players/a/araujra01.html\n",
      "/players/i/iguodan01.html\n",
      "/players/j/jackslu02.html\n",
      "/players/b/biedran01.html\n",
      "/players/s/swiftro01.html\n",
      "/players/t/telfase01.html\n",
      "/players/h/humphkr01.html\n",
      "/players/j/jeffeal01.html\n",
      "/players/s/snydeki01.html\n",
      "/players/s/smithjo03.html\n",
      "/players/s/smithjr01.html\n",
      "/players/w/wrighdo01.html\n",
      "/players/n/nelsoja01.html\n",
      "/players/p/podkopa01.html\n",
      "/players/k/khryavi01.html\n",
      "/players/m/moniase01.html\n",
      "/players/w/westde01.html\n",
      "/players/a/allento01.html\n",
      "/players/m/martike02.html\n",
      "/players/v/vujacsa01.html\n",
      "/players/u/udrihbe01.html\n",
      "/players/h/harrida01.html\n",
      "/players/v/varejan01.html\n",
      "/players/v/vromaja01.html\n",
      "/players/r/ramospe01.html\n",
      "/players/c/chalmli01.html\n",
      "/players/s/smithdo04.html\n",
      "/players/e/emmetan01.html\n",
      "/players/b/burksan01.html\n",
      "/players/i/iveyro01.html\n",
      "/players/d/duhonch01.html\n",
      "/players/m/miralal01.html\n",
      "/players/r/reedju01.html\n",
      "/players/s/sanikvi01.html\n",
      "/players/a/arizatr01.html\n",
      "/players/r/robinbe01.html\n",
      "/players/s/seungha01.html\n",
      "/players/s/sowpa01.html\n",
      "/players/l/lishcse01.html\n",
      "/players/s/spanova01.html\n",
      "/players/f/freijma01.html\n",
      "/players/f/florelu01.html\n",
      "/players/k/karause01.html\n",
      "/players/b/bogutan01.html\n",
      "/players/w/willima02.html\n",
      "/players/w/willide01.html\n",
      "/players/p/paulch01.html\n",
      "/players/f/feltora01.html\n",
      "/players/w/webstma02.html\n",
      "/players/v/villach01.html\n",
      "/players/f/fryech01.html\n",
      "/players/d/dioguik01.html\n",
      "/players/b/bynuman01.html\n",
      "/players/v/vazqufr01.html\n",
      "/players/k/korolya01.html\n",
      "/players/m/mayse01.html\n",
      "/players/m/mccanra01.html\n",
      "/players/w/wrighan01.html\n",
      "/players/g/grahajo01.html\n",
      "/players/g/grangda01.html\n",
      "/players/g/greenge01.html\n",
      "/players/w/warriha01.html\n",
      "/players/h/hodgeju01.html\n",
      "/players/r/robinna01.html\n",
      "/players/j/jackja01.html\n",
      "/players/g/garcifr01.html\n",
      "/players/h/headlu01.html\n",
      "/players/p/petrojo01.html\n",
      "/players/m/maxieja01.html\n",
      "/players/k/kleizli01.html\n",
      "/players/m/mahinia01.html\n",
      "/players/s/simiewa01.html\n",
      "/players/l/leeda02.html\n",
      "/players/s/stoudsa01.html\n",
      "/players/e/ewingda01.html\n",
      "/players/b/bassbr01.html\n",
      "/players/m/milescj01.html\n",
      "/players/i/ilyaser01.html\n",
      "/players/t/turiaro01.html\n",
      "/players/d/dienetr01.html\n",
      "/players/w/wafervo01.html\n",
      "/players/e/ellismo01.html\n",
      "/players/u/ukicro01.html\n",
      "/players/t/taftch01.html\n",
      "/players/i/ilicmi01.html\n",
      "/players/a/andrima01.html\n",
      "/players/w/willilo02.html\n",
      "/players/l/lorbeer01.html\n",
      "/players/w/wrighbr02.html\n",
      "/players/g/gelabmi01.html\n",
      "/players/b/blatcan01.html\n",
      "/players/g/gomesry01.html\n",
      "/players/w/whalero01.html\n",
      "/players/h/herveax01.html\n",
      "/players/g/greenor01.html\n",
      "/players/t/thompdi01.html\n",
      "/players/r/roberla01.html\n",
      "/players/j/johnsam01.html\n",
      "/players/g/gortama01.html\n",
      "/players/s/slokaur01.html\n",
      "/players/a/akyolce01.html\n",
      "/players/a/ackeral01.html\n",
      "/players/b/bargnan01.html\n",
      "/players/a/aldrila01.html\n",
      "/players/m/morriad01.html\n",
      "/players/t/thomaty01.html\n",
      "/players/w/willish02.html\n",
      "/players/r/roybr01.html\n",
      "/players/f/foyera01.html\n",
      "/players/g/gayru01.html\n",
      "/players/o/obryapa01.html\n",
      "/players/s/senesa01.html\n",
      "/players/r/redicjj01.html\n",
      "/players/a/armsthi01.html\n",
      "/players/s/sefolth01.html\n",
      "/players/b/brewero02.html\n",
      "/players/s/simmoce01.html\n",
      "/players/c/carnero01.html\n",
      "/players/w/willish03.html\n",
      "/players/p/pecheol01.html\n",
      "/players/d/doubyqu01.html\n",
      "/players/b/balkmre01.html\n",
      "/players/r/rondora01.html\n",
      "/players/w/willima03.html\n",
      "/players/b/boonejo01.html\n",
      "/players/l/lowryky01.html\n",
      "/players/b/brownsh01.html\n",
      "/players/f/farmajo01.html\n",
      "/players/r/rodrise01.html\n",
      "/players/a/agerma01.html\n",
      "/players/c/collima01.html\n",
      "/players/f/freeljo01.html\n",
      "/players/w/whiteja02.html\n",
      "/players/n/novakst01.html\n",
      "/players/j/jonesso01.html\n",
      "/players/d/davispa01.html\n",
      "/players/t/tuckepj01.html\n",
      "/players/s/smithcr01.html\n",
      "/players/j/jonesbo02.html\n",
      "/players/p/perovko01.html\n",
      "/players/n/noelda01.html\n",
      "/players/a/augusja01.html\n",
      "/players/g/gibsoda01.html\n",
      "/players/v/vincima01.html\n",
      "/players/e/eliyali01.html\n",
      "/players/j/johnsal01.html\n",
      "/players/b/brownde03.html\n",
      "/players/m/millspa01.html\n",
      "/players/v/veremvl01.html\n",
      "/players/p/powele01.html\n",
      "/players/h/holliry01.html\n",
      "/players/s/sambch01.html\n",
      "/players/d/diazgu01.html\n",
      "/players/h/halpeyo01.html\n",
      "/players/a/adamsha01.html\n",
      "/players/u/ugboaej01.html\n",
      "/players/b/bavcied01.html\n",
      "/players/m/markoda01.html\n",
      "/players/b/blalowi01.html\n",
      "/players/o/odengr01.html\n",
      "/players/d/duranke01.html\n",
      "/players/h/horfoal01.html\n",
      "/players/c/conlemi01.html\n",
      "/players/g/greenje02.html\n",
      "/players/j/jianlyi01.html\n",
      "/players/b/breweco01.html\n",
      "/players/w/wrighbr03.html\n",
      "/players/n/noahjo01.html\n",
      "/players/h/hawessp01.html\n",
      "/players/l/lawac01.html\n",
      "/players/y/youngth01.html\n",
      "/players/w/wrighju01.html\n",
      "/players/t/thornal01.html\n",
      "/players/s/stuckro01.html\n",
      "/players/y/youngni01.html\n",
      "/players/w/willise01.html\n",
      "/players/b/belinma01.html\n",
      "/players/c/crittja01.html\n",
      "/players/s/smithja02.html\n",
      "/players/c/cookda02.html\n",
      "/players/d/dudleja01.html\n",
      "/players/c/chandwi01.html\n",
      "/players/f/fernaru01.html\n",
      "/players/a/almonmo01.html\n",
      "/players/b/brookaa01.html\n",
      "/players/a/afflaar01.html\n",
      "/players/s/splitti01.html\n",
      "/players/t/tuckeal02.html\n",
      "/players/k/koponpe01.html\n",
      "/players/l/landrca01.html\n",
      "/players/p/pruitga01.html\n",
      "/players/w/willima04.html\n",
      "/players/f/fazekni01.html\n",
      "/players/d/davisgl01.html\n",
      "/players/d/davidje01.html\n",
      "/players/m/mcrobjo01.html\n",
      "/players/f/fesenky01.html\n",
      "/players/b/baracst01.html\n",
      "/players/y/yuesu01.html\n",
      "/players/r/richach01.html\n",
      "/players/b/byarsde01.html\n",
      "/players/l/lasmest01.html\n",
      "/players/m/mcguido01.html\n",
      "/players/g/gasolma01.html\n",
      "/players/g/grayaa01.html\n",
      "/players/s/seibure01.html\n",
      "/players/c/curryja01.html\n",
      "/players/g/greenta01.html\n",
      "/players/n/nichode01.html\n",
      "/players/n/newlebr01.html\n",
      "/players/s/sessira01.html\n",
      "/players/p/printgi01.html\n",
      "/players/s/strawdj01.html\n",
      "/players/r/rakovmi01.html\n",
      "/players/r/rosede01.html\n",
      "/players/b/beaslmi01.html\n",
      "/players/m/mayooj01.html\n",
      "/players/w/westbru01.html\n",
      "/players/l/loveke01.html\n",
      "/players/g/gallida01.html\n",
      "/players/g/gordoer01.html\n",
      "/players/a/alexajo01.html\n",
      "/players/a/augusdj01.html\n",
      "/players/l/lopezbr01.html\n",
      "/players/b/bayleje01.html\n",
      "/players/t/thompja02.html\n",
      "/players/r/rushbr01.html\n",
      "/players/r/randoan01.html\n",
      "/players/l/lopezro01.html\n",
      "/players/s/speigma01.html\n",
      "/players/h/hibbero01.html\n",
      "/players/m/mcgeeja01.html\n",
      "/players/h/hicksjj01.html\n",
      "/players/a/ajincal01.html\n",
      "/players/a/anderry01.html\n",
      "/players/l/leeco01.html\n",
      "/players/k/koufoko01.html\n",
      "/players/i/ibakase01.html\n",
      "/players/b/batumni01.html\n",
      "/players/h/hillge01.html\n",
      "/players/a/arthuda01.html\n",
      "/players/g/greendo01.html\n",
      "/players/w/whitedj01.html\n",
      "/players/g/giddejr01.html\n",
      "/players/p/pekovni01.html\n",
      "/players/s/sharpwa01.html\n",
      "/players/d/dorsejo01.html\n",
      "/players/c/chalmma01.html\n",
      "/players/j/jordade01.html\n",
      "/players/a/asikom01.html\n",
      "/players/m/mbahalu01.html\n",
      "/players/w/weaveky01.html\n",
      "/players/w/weemsso01.html\n",
      "/players/d/douglch01.html\n",
      "/players/j/jawaina01.html\n",
      "/players/s/singlse01.html\n",
      "/players/e/ewingpa02.html\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/players/t/tomican01.html\n",
      "/players/d/dragigo01.html\n",
      "/players/w/walkebi01.html\n",
      "/players/h/hairsma01.html\n",
      "/players/h/hardide01.html\n",
      "/players/j/jacksda01.html\n",
      "/players/d/dragita01.html\n",
      "/players/l/leunema01.html\n",
      "/players/t/taylomi01.html\n",
      "/players/k/kaunsa01.html\n",
      "/players/c/crawfjo01.html\n",
      "/players/e/erdense01.html\n",
      "/players/g/griffbl01.html\n",
      "/players/t/thabeha01.html\n",
      "/players/h/hardeja01.html\n",
      "/players/e/evansty01.html\n",
      "/players/r/rubiori01.html\n",
      "/players/f/flynnjo01.html\n",
      "/players/c/curryst01.html\n",
      "/players/h/hilljo01.html\n",
      "/players/d/derozde01.html\n",
      "/players/j/jennibr01.html\n",
      "/players/w/willite01.html\n",
      "/players/h/hendege02.html\n",
      "/players/h/hansbty01.html\n",
      "/players/c/clarkea01.html\n",
      "/players/d/dayeau01.html\n",
      "/players/j/johnsja01.html\n",
      "/players/h/holidjr01.html\n",
      "/players/l/lawsoty01.html\n",
      "/players/t/teaguje01.html\n",
      "/players/m/maynoer01.html\n",
      "/players/c/collida01.html\n",
      "/players/c/clavevi01.html\n",
      "/players/c/casspom01.html\n",
      "/players/m/mulleby01.html\n",
      "/players/b/beaubro01.html\n",
      "/players/g/gibsota01.html\n",
      "/players/c/carrode01.html\n",
      "/players/e/ellinwa01.html\n",
      "/players/d/douglto01.html\n",
      "/players/e/eyengch01.html\n",
      "/players/p/pendeje02.html\n",
      "/players/t/tayloje02.html\n",
      "/players/c/cunnida01.html\n",
      "/players/l/llullse01.html\n",
      "/players/s/summeda01.html\n",
      "/players/y/youngsa01.html\n",
      "/players/b/blairde01.html\n",
      "/players/b/brockjo01.html\n",
      "/players/j/jerebjo01.html\n",
      "/players/b/brownde04.html\n",
      "/players/m/meeksjo01.html\n",
      "/players/b/beverpa01.html\n",
      "/players/t/thornma01.html\n",
      "/players/b/budinch01.html\n",
      "/players/c/calatni01.html\n",
      "/players/g/greenda02.html\n",
      "/players/n/norelhe01.html\n",
      "/players/g/griffta01.html\n",
      "/players/g/gladyse01.html\n",
      "/players/p/priceaj01.html\n",
      "/players/d/decolna01.html\n",
      "/players/m/millspa02.html\n",
      "/players/p/preldem01.html\n",
      "/players/h/hudsole01.html\n",
      "/players/e/elonuch01.html\n",
      "/players/w/walljo01.html\n",
      "/players/t/turneev01.html\n",
      "/players/f/favorde01.html\n",
      "/players/j/johnswe01.html\n",
      "/players/c/couside01.html\n",
      "/players/u/udohek01.html\n",
      "/players/m/monrogr01.html\n",
      "/players/a/aminual01.html\n",
      "/players/h/haywago01.html\n",
      "/players/g/georgpa01.html\n",
      "/players/a/aldrico01.html\n",
      "/players/h/henryxa01.html\n",
      "/players/d/davised01.html\n",
      "/players/p/pattepa01.html\n",
      "/players/s/sandela01.html\n",
      "/players/b/babbilu01.html\n",
      "/players/s/serapke01.html\n",
      "/players/b/bledser01.html\n",
      "/players/b/bradlav01.html\n",
      "/players/a/anderja01.html\n",
      "/players/b/brackcr01.html\n",
      "/players/w/williel01.html\n",
      "/players/b/booketr01.html\n",
      "/players/j/jamesda01.html\n",
      "/players/j/jonesdo02.html\n",
      "/players/p/pondequ01.html\n",
      "/players/c/crawfjo02.html\n",
      "/players/v/vasqugr01.html\n",
      "/players/o/ortonda01.html\n",
      "/players/h/haywala01.html\n",
      "/players/p/pleisti01.html\n",
      "/players/p/pittmde01.html\n",
      "/players/w/whiteha01.html\n",
      "/players/j/johnsar02.html\n",
      "/players/b/bjeline01.html\n",
      "/players/h/hobsoda01.html\n",
      "/players/r/rautian01.html\n",
      "/players/f/fieldla01.html\n",
      "/players/s/stephla01.html\n",
      "/players/v/varnaja01.html\n",
      "/players/e/ebankde01.html\n",
      "/players/j/jordaje01.html\n",
      "/players/p/prestpa01.html\n",
      "/players/l/lawalga01.html\n",
      "/players/w/willila01.html\n",
      "/players/r/richary01.html\n",
      "/players/a/alabiso01.html\n",
      "/players/h/haranlu01.html\n",
      "/players/s/sypa01.html\n",
      "/players/w/warrewi01.html\n",
      "/players/e/evansje01.html\n",
      "/players/n/ndiayha01.html\n",
      "/players/r/reidry01.html\n",
      "/players/c/caracde01.html\n",
      "/players/c/collidw01.html\n",
      "/players/i/irvinky01.html\n",
      "/players/w/willide02.html\n",
      "/players/k/kanteen01.html\n",
      "/players/t/thomptr01.html\n",
      "/players/v/valanjo01.html\n",
      "/players/v/veselja01.html\n",
      "/players/b/biyombi01.html\n",
      "/players/k/knighbr03.html\n",
      "/players/w/walkeke02.html\n",
      "/players/f/fredeji01.html\n",
      "/players/t/thompkl01.html\n",
      "/players/b/burksal01.html\n",
      "/players/m/morrima02.html\n",
      "/players/m/morrima03.html\n",
      "/players/l/leonaka01.html\n",
      "/players/v/vucevni01.html\n",
      "/players/s/shumpim01.html\n",
      "/players/s/singlch01.html\n",
      "/players/h/harrito02.html\n",
      "/players/m/motiedo01.html\n",
      "/players/s/smithno01.html\n",
      "/players/f/farieke01.html\n",
      "/players/m/mirotni01.html\n",
      "/players/j/jacksre01.html\n",
      "/players/b/brookma01.html\n",
      "/players/h/hamiljo02.html\n",
      "/players/j/johnsja02.html\n",
      "/players/c/coleno01.html\n",
      "/players/j/josepco01.html\n",
      "/players/b/butleji01.html\n",
      "/players/b/bogdabo02.html\n",
      "/players/h/harpeju01.html\n",
      "/players/s/singlky01.html\n",
      "/players/m/macksh01.html\n",
      "/players/h/honeyty01.html\n",
      "/players/w/willijo03.html\n",
      "/players/t/thomptr02.html\n",
      "/players/p/parsoch01.html\n",
      "/players/t/tylerje01.html\n",
      "/players/l/leuerjo01.html\n",
      "/players/m/morrida01.html\n",
      "/players/b/bertada01.html\n",
      "/players/l/leema01.html\n",
      "/players/j/jenkich01.html\n",
      "/players/h/harrejo01.html\n",
      "/players/g/goudean01.html\n",
      "/players/l/leslitr01.html\n",
      "/players/b/bensoke02.html\n",
      "/players/s/selbyjo01.html\n",
      "/players/a/allenla01.html\n",
      "/players/d/diebljo01.html\n",
      "/players/m/macklve01.html\n",
      "/players/l/liggide01.html\n",
      "/players/m/macvami01.html\n",
      "/players/m/mooreet01.html\n",
      "/players/m/maduach01.html\n",
      "/players/m/majokat01.html\n",
      "/players/h/hangaad01.html\n",
      "/players/t/thomais02.html\n",
      "/players/d/davisan02.html\n",
      "/players/k/kiddgmi01.html\n",
      "/players/b/bealbr01.html\n",
      "/players/w/waitedi01.html\n",
      "/players/r/robinth01.html\n",
      "/players/l/lillada01.html\n",
      "/players/b/barneha02.html\n",
      "/players/r/rosste01.html\n",
      "/players/d/drumman01.html\n",
      "/players/r/riverau01.html\n",
      "/players/l/leoname01.html\n",
      "/players/l/lambje01.html\n",
      "/players/m/marshke01.html\n",
      "/players/h/hensojo01.html\n",
      "/players/h/harklma01.html\n",
      "/players/w/whitero03.html\n",
      "/players/z/zellety01.html\n",
      "/players/j/joneste01.html\n",
      "/players/n/nichoan01.html\n",
      "/players/f/fournev01.html\n",
      "/players/s/sullija01.html\n",
      "/players/m/melofa01.html\n",
      "/players/j/jenkijo01.html\n",
      "/players/c/cunnija01.html\n",
      "/players/w/wroteto01.html\n",
      "/players/p/plumlmi01.html\n",
      "/players/m/moultar01.html\n",
      "/players/j/jonespe01.html\n",
      "/players/t/teaguma01.html\n",
      "/players/e/ezelife01.html\n",
      "/players/t/tayloje03.html\n",
      "/players/s/satorto01.html\n",
      "/players/j/jamesbe01.html\n",
      "/players/c/crowdja01.html\n",
      "/players/g/greendr01.html\n",
      "/players/j/johnsor01.html\n",
      "/players/a/acyqu01.html\n",
      "/players/m/millequ01.html\n",
      "/players/m/middlkh01.html\n",
      "/players/b/bartowi01.html\n",
      "/players/t/tayloty01.html\n",
      "/players/l/lambdo01.html\n",
      "/players/s/scottmi01.html\n",
      "/players/e/engliki01.html\n",
      "/players/h/hamilju01.html\n",
      "/players/m/milleda01.html\n",
      "/players/m/murphke01.html\n",
      "/players/p/papanko01.html\n",
      "/players/o/oquinky01.html\n",
      "/players/t/turkyiz01.html\n",
      "/players/j/josepkr01.html\n",
      "/players/k/kuzmiog01.html\n",
      "/players/a/aldemfu01.html\n",
      "/players/s/shengto01.html\n",
      "/players/j/johnsda03.html\n",
      "/players/z/zubcito01.html\n",
      "/players/k/karamil01.html\n",
      "/players/h/hummero01.html\n",
      "/players/d/denmoma01.html\n",
      "/players/s/sacrero01.html\n",
      "/players/b/bennean01.html\n",
      "/players/o/oladivi01.html\n",
      "/players/p/porteot01.html\n",
      "/players/z/zelleco01.html\n",
      "/players/l/lenal01.html\n",
      "/players/n/noelne01.html\n",
      "/players/m/mclembe01.html\n",
      "/players/c/caldwke01.html\n",
      "/players/b/burketr01.html\n",
      "/players/m/mccolcj01.html\n",
      "/players/c/cartemi01.html\n",
      "/players/a/adamsst01.html\n",
      "/players/o/olynyke01.html\n",
      "/players/m/muhamsh01.html\n",
      "/players/a/antetgi01.html\n",
      "/players/n/noguelu01.html\n",
      "/players/s/schrode01.html\n",
      "/players/l/larkish01.html\n",
      "/players/k/karasse01.html\n",
      "/players/s/snellto01.html\n",
      "/players/d/dienggo01.html\n",
      "/players/p/plumlma01.html\n",
      "/players/h/hillso01.html\n",
      "/players/h/hardati02.html\n",
      "/players/b/bullore01.html\n",
      "/players/r/roberan03.html\n",
      "/players/g/goberru01.html\n",
      "/players/j/jeancli01.html\n",
      "/players/g/goodwar01.html\n",
      "/players/n/nedovne01.html\n",
      "/players/c/crabbal01.html\n",
      "/players/a/abrinal01.html\n",
      "/players/f/felixca01.html\n",
      "/players/c/canaais01.html\n",
      "/players/r/ricegl02.html\n",
      "/players/m/mccalra01.html\n",
      "/players/m/mitchto02.html\n",
      "/players/w/woltena01.html\n",
      "/players/w/witheje01.html\n",
      "/players/j/jerregr01.html\n",
      "/players/f/frankja01.html\n",
      "/players/j/jackspi01.html\n",
      "/players/l/ledori01.html\n",
      "/players/m/muscami01.html\n",
      "/players/t/todorma01.html\n",
      "/players/g/greener01.html\n",
      "/players/n/netora01.html\n",
      "/players/k/kellyry01.html\n",
      "/players/m/murpher01.html\n",
      "/players/e/ennisja01.html\n",
      "/players/b/brownlo01.html\n",
      "/players/i/iversco01.html\n",
      "/players/k/kazemar01.html\n",
      "/players/l/lauvejo01.html\n",
      "/players/s/sivape01.html\n",
      "/players/o/oriakal01.html\n",
      "/players/t/thomade01.html\n",
      "/players/d/dubljbo01.html\n",
      "/players/t/timmaja01.html\n",
      "/players/w/wiggian01.html\n",
      "/players/p/parkeja01.html\n",
      "/players/e/embiijo01.html\n",
      "/players/g/gordoaa01.html\n",
      "/players/e/exumda01.html\n",
      "/players/s/smartma01.html\n",
      "/players/r/randlju01.html\n",
      "/players/s/stausni01.html\n",
      "/players/v/vonleno01.html\n",
      "/players/p/paytoel01.html\n",
      "/players/m/mcderdo01.html\n",
      "/players/s/saricda01.html\n",
      "/players/l/lavinza01.html\n",
      "/players/w/warretj01.html\n",
      "/players/p/paynead01.html\n",
      "/players/n/nurkiju01.html\n",
      "/players/y/youngja01.html\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/players/e/ennisty01.html\n",
      "/players/h/harriga01.html\n",
      "/players/c/cabocbr01.html\n",
      "/players/m/mcgarmi01.html\n",
      "/players/a/adamsjo01.html\n",
      "/players/h/hoodro01.html\n",
      "/players/n/napiesh01.html\n",
      "/players/c/capelca01.html\n",
      "/players/h/hairspj02.html\n",
      "/players/b/bogdabo01.html\n",
      "/players/w/wilcocj01.html\n",
      "/players/h/huestjo01.html\n",
      "/players/a/anderky01.html\n",
      "/players/i/inglida01.html\n",
      "/players/m/mcdankj01.html\n",
      "/players/h/harrijo01.html\n",
      "/players/e/earlycl01.html\n",
      "/players/s/stokeja01.html\n",
      "/players/o/obryajo01.html\n",
      "/players/d/daniede01.html\n",
      "/players/d/dinwisp01.html\n",
      "/players/g/grantje01.html\n",
      "/players/r/robingl02.html\n",
      "/players/j/jokicni01.html\n",
      "/players/j/johnsni01.html\n",
      "/players/t/tavarwa01.html\n",
      "/players/b/brownma02.html\n",
      "/players/p/poweldw01.html\n",
      "/players/c/clarkjo01.html\n",
      "/players/s/smithru01.html\n",
      "/players/p/pattela01.html\n",
      "/players/b/bairsca01.html\n",
      "/players/b/brownal01.html\n",
      "/players/a/antetth01.html\n",
      "/players/m/micicva01.html\n",
      "/players/g/gential01.html\n",
      "/players/d/dangune01.html\n",
      "/players/c/chrisse01.html\n",
      "/players/m/marblde01.html\n",
      "/players/l/labeylo01.html\n",
      "/players/m/mcraejo01.html\n",
      "/players/t/thamexa01.html\n",
      "/players/j/jeffeco01.html\n",
      "/players/t/townska01.html\n",
      "/players/r/russeda01.html\n",
      "/players/o/okafoja01.html\n",
      "/players/p/porzikr01.html\n",
      "/players/h/hezonma01.html\n",
      "/players/c/caulewi01.html\n",
      "/players/m/mudiaem01.html\n",
      "/players/j/johnsst04.html\n",
      "/players/k/kaminfr01.html\n",
      "/players/w/winslju01.html\n",
      "/players/t/turnemy01.html\n",
      "/players/l/lylestr01.html\n",
      "/players/b/bookede01.html\n",
      "/players/p/payneca01.html\n",
      "/players/o/oubreke01.html\n",
      "/players/r/roziete01.html\n",
      "/players/v/vaughra01.html\n",
      "/players/d/dekkesa01.html\n",
      "/players/g/grantje02.html\n",
      "/players/w/wrighde01.html\n",
      "/players/a/anderju01.html\n",
      "/players/p/portibo01.html\n",
      "/players/h/holliro01.html\n",
      "/players/j/jonesty01.html\n",
      "/players/m/martija01.html\n",
      "/players/m/milutni01.html\n",
      "/players/n/nancela02.html\n",
      "/players/h/hunterj01.html\n",
      "/players/m/mcculch01.html\n",
      "/players/l/looneke01.html\n",
      "/players/o/osmande01.html\n",
      "/players/h/harremo01.html\n",
      "/players/m/mickejo01.html\n",
      "/players/b/brownan02.html\n",
      "/players/h/hernawi01.html\n",
      "/players/c/chrisra01.html\n",
      "/players/h/holmeri01.html\n",
      "/players/h/hillida01.html\n",
      "/players/v/vauleju01.html\n",
      "/players/r/richajo01.html\n",
      "/players/c/connapa01.html\n",
      "/players/h/hanlaol01.html\n",
      "/players/y/youngjo01.html\n",
      "/players/h/harrian01.html\n",
      "/players/t/thornma02.html\n",
      "/players/p/powelno01.html\n",
      "/players/g/gudaiar01.html\n",
      "/players/j/johnsda04.html\n",
      "/players/w/whiteaa01.html\n",
      "/players/e/eriksma01.html\n",
      "/players/h/harvety01.html\n",
      "/players/s/singhsa01.html\n",
      "/players/p/pointsi01.html\n",
      "/players/d/diezda01.html\n",
      "/players/l/lalanca01.html\n",
      "/players/d/dawsobr01.html\n",
      "/players/r/radicni01.html\n",
      "/players/t/tokotjp01.html\n",
      "/players/a/agravdi01.html\n",
      "/players/m/mitrolu01.html\n",
      "/players/s/simmobe01.html\n",
      "/players/i/ingrabr01.html\n",
      "/players/b/brownja02.html\n",
      "/players/b/bendedr01.html\n",
      "/players/d/dunnkr01.html\n",
      "/players/h/hieldbu01.html\n",
      "/players/m/murraja01.html\n",
      "/players/c/chrisma01.html\n",
      "/players/p/poeltja01.html\n",
      "/players/m/makerth01.html\n",
      "/players/s/sabondo01.html\n",
      "/players/p/princta02.html\n",
      "/players/p/papagge01.html\n",
      "/players/v/valende01.html\n",
      "/players/h/hernaju01.html\n",
      "/players/y/yabusgu01.html\n",
      "/players/b/baldwwa01.html\n",
      "/players/e/ellenhe01.html\n",
      "/players/b/beaslma01.html\n",
      "/players/l/leverca01.html\n",
      "/players/b/bembrde01.html\n",
      "/players/r/richama01.html\n",
      "/players/z/zizican01.html\n",
      "/players/l/luwawti01.html\n",
      "/players/j/johnsbr02.html\n",
      "/players/k/korkmfu01.html\n",
      "/players/s/siakapa01.html\n",
      "/players/l/labissk01.html\n",
      "/players/m/murrade01.html\n",
      "/players/j/jonesda03.html\n",
      "/players/d/davisde01.html\n",
      "/players/z/zubaciv01.html\n",
      "/players/d/diallch01.html\n",
      "/players/u/ulisty01.html\n",
      "/players/z/zagorra01.html\n",
      "/players/b/brogdma01.html\n",
      "/players/o/onuakch01.html\n",
      "/players/m/mccawpa01.html\n",
      "/players/m/michida01.html\n",
      "/players/s/stonedi01.html\n",
      "/players/z/zimmest01.html\n",
      "/players/w/whiteis01.html\n",
      "/players/q/qizh01.html\n",
      "/players/c/cordiis01.html\n",
      "/players/j/jacksde01.html\n",
      "/players/h/hammoaj01.html\n",
      "/players/l/laymaja01.html\n",
      "/players/z/zipsepa01.html\n",
      "/players/g/gbinimi01.html\n",
      "/players/n/niangge01.html\n",
      "/players/b/bentibe01.html\n",
      "/players/b/bolomjo01.html\n",
      "/players/c/cornepe01.html\n",
      "/players/f/feldeka01.html\n",
      "/players/p/paigema01.html\n",
      "/players/h/hamilda02.html\n",
      "/players/s/sheliwa01.html\n",
      "/players/n/naderab01.html\n",
      "/players/c/cousiis01.html\n",
      "/players/w/wallaty01.html\n"
     ]
    }
   ],
   "source": [
    "# loop through url_list to get all drafted players info\n",
    "url_template2 = \"https://www.basketball-reference.com{player}\"\n",
    "player_df = pd.DataFrame()\n",
    "\n",
    "for player in url_list:\n",
    "    print(player)\n",
    "    url = url_template2.format(player=player)\n",
    "    \n",
    "    response = requests.get(url)\n",
    "    page = response.text\n",
    "\n",
    "    soup = BeautifulSoup(page, 'html5lib')\n",
    "    \n",
    "    Player = soup.find_all('h1')[0].getText()\n",
    "    BirthMonth = [x.find_all('a') for x in soup.find_all(itemprop=\"birthDate\")][0][0].getText().split()[0][:3]\n",
    "    BirthDay = [x.find_all('a') for x in soup.find_all(itemprop=\"birthDate\")][0][0].getText().split()[1]\n",
    "    Birthyear = [x.find_all('a') for x in soup.find_all(itemprop=\"birthDate\")][0][1].getText()\n",
    "    date = BirthMonth + ' ' + BirthDay + ' ' + Birthyear\n",
    "    Birthday = datetime.strptime(date, '%b %d %Y')\n",
    "    Height_ft = int(soup.find_all(itemprop=\"height\")[0].getText().split('-')[0])\n",
    "    Height_in = int(soup.find_all(itemprop=\"height\")[0].getText().split('-')[1])\n",
    "    Weight = int(soup.find_all(itemprop=\"weight\")[0].getText()[:3])\n",
    "    \n",
    "    column_headers = ['Player', 'Birthday', 'Height_ft', 'Height_in', 'Weight']\n",
    "    player_data = [Player, Birthday, Height_ft, Height_in, Weight]\n",
    "    \n",
    "    dic = dict(zip(column_headers,player_data))\n",
    "    df = pd.DataFrame(dic,columns=column_headers, index=[0])\n",
    "    \n",
    "    player_df = player_df.append(df, ignore_index=True)\n",
    "    \n",
    "    time.sleep(.5+2*random.random())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# save to csv file\n",
    "player_df.to_csv('player_raw.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\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>Birthday</th>\n",
       "      <th>Height_ft</th>\n",
       "      <th>Height_in</th>\n",
       "      <th>Weight</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LeBron James</td>\n",
       "      <td>1984-12-30</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Darko Milicic</td>\n",
       "      <td>1985-06-20</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Carmelo Anthony</td>\n",
       "      <td>1984-05-29</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Chris Bosh</td>\n",
       "      <td>1984-03-24</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Dwyane Wade</td>\n",
       "      <td>1982-01-17</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Chris Kaman</td>\n",
       "      <td>1982-04-28</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Kirk Hinrich</td>\n",
       "      <td>1981-01-02</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>T.J. Ford</td>\n",
       "      <td>1983-03-24</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Mike Sweetney</td>\n",
       "      <td>1982-10-25</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Jarvis Hayes</td>\n",
       "      <td>1981-08-09</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Mickael Pietrus</td>\n",
       "      <td>1982-02-07</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Nick Collison</td>\n",
       "      <td>1980-10-26</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Marcus Banks</td>\n",
       "      <td>1981-11-19</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Luke Ridnour</td>\n",
       "      <td>1981-02-13</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Reece Gaines</td>\n",
       "      <td>1981-01-07</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Troy Bell</td>\n",
       "      <td>1980-11-10</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Zarko Cabarkapa</td>\n",
       "      <td>1981-05-21</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>David West</td>\n",
       "      <td>1980-08-29</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Sasha Pavlovic</td>\n",
       "      <td>1983-11-15</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Dahntay Jones</td>\n",
       "      <td>1980-12-27</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Boris Diaw</td>\n",
       "      <td>1982-04-16</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Zoran Planinic</td>\n",
       "      <td>1982-09-12</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>195</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Travis Outlaw</td>\n",
       "      <td>1984-09-18</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Brian Cook</td>\n",
       "      <td>1980-12-04</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Carlos Delfino</td>\n",
       "      <td>1982-08-29</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Ndudi Ebi</td>\n",
       "      <td>1984-06-18</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Kendrick Perkins</td>\n",
       "      <td>1984-11-10</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Leandro Barbosa</td>\n",
       "      <td>1982-11-28</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Josh Howard</td>\n",
       "      <td>1980-04-28</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Maciej Lampe</td>\n",
       "      <td>1985-02-05</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>768</th>\n",
       "      <td>Deyonta Davis</td>\n",
       "      <td>1996-12-02</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>769</th>\n",
       "      <td>Ivica Zubac</td>\n",
       "      <td>1997-03-18</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>770</th>\n",
       "      <td>Cheick Diallo</td>\n",
       "      <td>1996-09-13</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771</th>\n",
       "      <td>Tyler Ulis</td>\n",
       "      <td>1996-01-05</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772</th>\n",
       "      <td>Rade Zagorac</td>\n",
       "      <td>1995-08-12</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>773</th>\n",
       "      <td>Malcolm Brogdon</td>\n",
       "      <td>1992-12-11</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>774</th>\n",
       "      <td>Chinanu Onuaku</td>\n",
       "      <td>1996-11-01</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>245</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775</th>\n",
       "      <td>Patrick McCaw</td>\n",
       "      <td>1995-10-25</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>776</th>\n",
       "      <td>David Michineau</td>\n",
       "      <td>1994-06-06</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>777</th>\n",
       "      <td>Diamond Stone</td>\n",
       "      <td>1997-02-10</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778</th>\n",
       "      <td>Stephen Zimmerman</td>\n",
       "      <td>1996-09-09</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779</th>\n",
       "      <td>Isaiah Whitehead</td>\n",
       "      <td>1995-03-08</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>780</th>\n",
       "      <td>Zhou Qi</td>\n",
       "      <td>1996-01-16</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>781</th>\n",
       "      <td>Isaia Cordinier</td>\n",
       "      <td>1996-11-28</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>782</th>\n",
       "      <td>Demetrius Jackson</td>\n",
       "      <td>1994-09-07</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>783</th>\n",
       "      <td>A.J. Hammons</td>\n",
       "      <td>1992-08-27</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>784</th>\n",
       "      <td>Jake Layman</td>\n",
       "      <td>1994-03-07</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>785</th>\n",
       "      <td>Paul Zipser</td>\n",
       "      <td>1994-02-18</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>786</th>\n",
       "      <td>Michael Gbinije</td>\n",
       "      <td>1992-06-05</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>787</th>\n",
       "      <td>Georges Niang</td>\n",
       "      <td>1993-06-17</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>788</th>\n",
       "      <td>Ben Bentil</td>\n",
       "      <td>1995-03-29</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>789</th>\n",
       "      <td>Joel Bolomboy</td>\n",
       "      <td>1994-01-28</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>235</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>790</th>\n",
       "      <td>Petr Cornelie</td>\n",
       "      <td>1995-07-26</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>791</th>\n",
       "      <td>Kay Felder</td>\n",
       "      <td>1995-03-29</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>792</th>\n",
       "      <td>Marcus Paige</td>\n",
       "      <td>1993-09-11</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>793</th>\n",
       "      <td>Daniel Hamilton</td>\n",
       "      <td>1995-08-08</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>195</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>Wang Zhelin</td>\n",
       "      <td>1994-01-20</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>795</th>\n",
       "      <td>Abdel Nader</td>\n",
       "      <td>1993-09-25</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>796</th>\n",
       "      <td>Isaiah Cousins</td>\n",
       "      <td>1994-03-13</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>797</th>\n",
       "      <td>Tyrone Wallace</td>\n",
       "      <td>1994-06-10</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>205</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>798 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Player   Birthday  Height_ft  Height_in  Weight\n",
       "0         LeBron James 1984-12-30          6          8     250\n",
       "1        Darko Milicic 1985-06-20          7          0     250\n",
       "2      Carmelo Anthony 1984-05-29          6          8     240\n",
       "3           Chris Bosh 1984-03-24          6         11     235\n",
       "4          Dwyane Wade 1982-01-17          6          4     220\n",
       "5          Chris Kaman 1982-04-28          7          0     265\n",
       "6         Kirk Hinrich 1981-01-02          6          4     190\n",
       "7            T.J. Ford 1983-03-24          6          0     165\n",
       "8        Mike Sweetney 1982-10-25          6          8     275\n",
       "9         Jarvis Hayes 1981-08-09          6          7     220\n",
       "10     Mickael Pietrus 1982-02-07          6          6     215\n",
       "11       Nick Collison 1980-10-26          6         10     255\n",
       "12        Marcus Banks 1981-11-19          6          2     200\n",
       "13        Luke Ridnour 1981-02-13          6          2     175\n",
       "14        Reece Gaines 1981-01-07          6          6     205\n",
       "15           Troy Bell 1980-11-10          6          1     180\n",
       "16     Zarko Cabarkapa 1981-05-21          6         11     235\n",
       "17          David West 1980-08-29          6          9     250\n",
       "18      Sasha Pavlovic 1983-11-15          6          8     220\n",
       "19       Dahntay Jones 1980-12-27          6          6     225\n",
       "20          Boris Diaw 1982-04-16          6          8     250\n",
       "21      Zoran Planinic 1982-09-12          6          7     195\n",
       "22       Travis Outlaw 1984-09-18          6          9     210\n",
       "23          Brian Cook 1980-12-04          6          9     234\n",
       "24      Carlos Delfino 1982-08-29          6          6     230\n",
       "25           Ndudi Ebi 1984-06-18          6          9     200\n",
       "26    Kendrick Perkins 1984-11-10          6         10     270\n",
       "27     Leandro Barbosa 1982-11-28          6          3     194\n",
       "28         Josh Howard 1980-04-28          6          7     210\n",
       "29        Maciej Lampe 1985-02-05          6         11     275\n",
       "..                 ...        ...        ...        ...     ...\n",
       "768      Deyonta Davis 1996-12-02          6         11     237\n",
       "769        Ivica Zubac 1997-03-18          7          1     265\n",
       "770      Cheick Diallo 1996-09-13          6          9     220\n",
       "771         Tyler Ulis 1996-01-05          5         10     150\n",
       "772       Rade Zagorac 1995-08-12          6          9     202\n",
       "773    Malcolm Brogdon 1992-12-11          6          5     215\n",
       "774     Chinanu Onuaku 1996-11-01          6         10     245\n",
       "775      Patrick McCaw 1995-10-25          6          7     185\n",
       "776    David Michineau 1994-06-06          6          4     180\n",
       "777      Diamond Stone 1997-02-10          6         11     255\n",
       "778  Stephen Zimmerman 1996-09-09          7          0     240\n",
       "779   Isaiah Whitehead 1995-03-08          6          4     213\n",
       "780            Zhou Qi 1996-01-16          7          1     210\n",
       "781    Isaia Cordinier 1996-11-28          6          4     180\n",
       "782  Demetrius Jackson 1994-09-07          6          1     201\n",
       "783       A.J. Hammons 1992-08-27          7          0     260\n",
       "784        Jake Layman 1994-03-07          6          9     210\n",
       "785        Paul Zipser 1994-02-18          6          8     215\n",
       "786    Michael Gbinije 1992-06-05          6          7     200\n",
       "787      Georges Niang 1993-06-17          6          8     230\n",
       "788         Ben Bentil 1995-03-29          6          9     235\n",
       "789      Joel Bolomboy 1994-01-28          6          9     235\n",
       "790      Petr Cornelie 1995-07-26          6         11     220\n",
       "791         Kay Felder 1995-03-29          5          9     176\n",
       "792       Marcus Paige 1993-09-11          6          1     175\n",
       "793    Daniel Hamilton 1995-08-08          6          7     195\n",
       "794        Wang Zhelin 1994-01-20          7          0     220\n",
       "795        Abdel Nader 1993-09-25          6          6     230\n",
       "796     Isaiah Cousins 1994-03-13          6          5     191\n",
       "797     Tyrone Wallace 1994-06-10          6          5     205\n",
       "\n",
       "[798 rows x 5 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "player_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}