web_scraping/NBA_Regular_Season_Stats.ipynb

{
 "metadata": {
  "name": "",
  "signature": "sha256:ddb5d3a6663e16c727f46050ba7da19c26a6bd88fcbf172e96c5a9b60c83c825"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "<a id=\"top\"></a>"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "# This is sort of the Part 2 of my NBA web scraping example that I did [earlier](http://nbviewer.ipython.org/github/pybokeh/ipython_notebooks/blob/master/web_scraping/NBA_Player_Stats.ipynb)."
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "In this part, I will be scraping the regular season player stats for <strong>ALL</strong> players.  This data is quite big compared to the tables in my part 1 of this series.  [Here's](http://espn.go.com/nba/player/stats/_/id/1966/lebron-james) an example of regular season stats data for LeBron James."
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "#### Quick Links"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "- [source code for scraping regular seaons avgs](#season_avgs)\n",
      "- [source code for scraping regular season totals](#season_totals)\n",
      "- [source code for scraping regular season misc totals](#season_misc)\n",
      "- [query the NBA sqlite database using db.py](#db_py)\n",
      "- [sqlite table definitions](#sqlite_tables)"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Let's get the urls for all the NBA teams"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import urllib.request as request\n",
      "from bs4 import BeautifulSoup\n",
      "import re\n",
      "\n",
      "base_url = 'http://espn.go.com'\n",
      "\n",
      "teams_url = 'http://espn.go.com/nba/teams'\n",
      "html_teams = request.urlopen(teams_url)\n",
      "\n",
      "soup_teams = BeautifulSoup(html_teams)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 30
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "urls = soup_teams.find_all(href=re.compile('/nba/teams/stats'))\n",
      "urls"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 31,
       "text": [
        "[<a href=\"/nba/teams/stats?team=bos\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=bkn\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=nyk\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=phi\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=tor\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=gsw\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=lac\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=lal\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=pho\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=sac\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=chi\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=cle\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=det\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=ind\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=mil\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=dal\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=hou\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=mem\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=nor\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=sas\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=atl\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=cha\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=mia\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=orl\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=was\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=den\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=min\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=okc\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=por\">Stats</a>,\n",
        " <a href=\"/nba/teams/stats?team=uth\">Stats</a>]"
       ]
      }
     ],
     "prompt_number": 31
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### But I want the full URLs and without the markup junk"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "team_urls = [base_url+url['href'] for url in urls]\n",
      "team_urls"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 32,
       "text": [
        "['http://espn.go.com/nba/teams/stats?team=bos',\n",
        " 'http://espn.go.com/nba/teams/stats?team=bkn',\n",
        " 'http://espn.go.com/nba/teams/stats?team=nyk',\n",
        " 'http://espn.go.com/nba/teams/stats?team=phi',\n",
        " 'http://espn.go.com/nba/teams/stats?team=tor',\n",
        " 'http://espn.go.com/nba/teams/stats?team=gsw',\n",
        " 'http://espn.go.com/nba/teams/stats?team=lac',\n",
        " 'http://espn.go.com/nba/teams/stats?team=lal',\n",
        " 'http://espn.go.com/nba/teams/stats?team=pho',\n",
        " 'http://espn.go.com/nba/teams/stats?team=sac',\n",
        " 'http://espn.go.com/nba/teams/stats?team=chi',\n",
        " 'http://espn.go.com/nba/teams/stats?team=cle',\n",
        " 'http://espn.go.com/nba/teams/stats?team=det',\n",
        " 'http://espn.go.com/nba/teams/stats?team=ind',\n",
        " 'http://espn.go.com/nba/teams/stats?team=mil',\n",
        " 'http://espn.go.com/nba/teams/stats?team=dal',\n",
        " 'http://espn.go.com/nba/teams/stats?team=hou',\n",
        " 'http://espn.go.com/nba/teams/stats?team=mem',\n",
        " 'http://espn.go.com/nba/teams/stats?team=nor',\n",
        " 'http://espn.go.com/nba/teams/stats?team=sas',\n",
        " 'http://espn.go.com/nba/teams/stats?team=atl',\n",
        " 'http://espn.go.com/nba/teams/stats?team=cha',\n",
        " 'http://espn.go.com/nba/teams/stats?team=mia',\n",
        " 'http://espn.go.com/nba/teams/stats?team=orl',\n",
        " 'http://espn.go.com/nba/teams/stats?team=was',\n",
        " 'http://espn.go.com/nba/teams/stats?team=den',\n",
        " 'http://espn.go.com/nba/teams/stats?team=min',\n",
        " 'http://espn.go.com/nba/teams/stats?team=okc',\n",
        " 'http://espn.go.com/nba/teams/stats?team=por',\n",
        " 'http://espn.go.com/nba/teams/stats?team=uth']"
       ]
      }
     ],
     "prompt_number": 32
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Now, let's get the urls for all players for a particular team"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import urllib.request as request\n",
      "from bs4 import BeautifulSoup\n",
      "import re\n",
      "\n",
      "team_url = 'http://espn.go.com/nba/team/stats/_/name/cle/cleveland-cavaliers'\n",
      "html_team = request.urlopen(team_url)\n",
      "\n",
      "soup_team = BeautifulSoup(html_team)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 33
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "html_rows = soup_team.find_all('tr', class_=re.compile('player'))"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 34
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Now let's look at the URLs"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "for row in html_rows:\n",
      "    print(row.a['href'])"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "http://espn.go.com/nba/player/_/id/1966/lebron-james\n",
        "http://espn.go.com/nba/player/_/id/6442/kyrie-irving\n",
        "http://espn.go.com/nba/player/_/id/3449/kevin-love\n",
        "http://espn.go.com/nba/player/_/id/6628/dion-waiters\n",
        "http://espn.go.com/nba/player/_/id/2419/anderson-varejao\n",
        "http://espn.go.com/nba/player/_/id/6474/tristan-thompson\n",
        "http://espn.go.com/nba/player/_/id/510/shawn-marion\n",
        "http://espn.go.com/nba/player/_/id/2489716/matthew-dellavedova\n",
        "http://espn.go.com/nba/player/_/id/2009/james-jones\n",
        "http://espn.go.com/nba/player/_/id/558/mike-miller\n",
        "http://espn.go.com/nba/player/_/id/2528794/joe-harris\n",
        "http://espn.go.com/nba/player/_/id/1000/brendan-haywood\n",
        "http://espn.go.com/nba/player/_/id/2489897/will-cherry\n",
        "http://espn.go.com/nba/player/_/id/4010/a.j.-price\n",
        "http://espn.go.com/nba/player/_/id/3041/lou-amundson\n",
        "http://espn.go.com/nba/player/_/id/2528355/alex-kirk\n",
        "http://espn.go.com/nba/player/_/id/1966/lebron-james\n",
        "http://espn.go.com/nba/player/_/id/6442/kyrie-irving\n",
        "http://espn.go.com/nba/player/_/id/3449/kevin-love\n",
        "http://espn.go.com/nba/player/_/id/6628/dion-waiters\n",
        "http://espn.go.com/nba/player/_/id/2419/anderson-varejao\n",
        "http://espn.go.com/nba/player/_/id/6474/tristan-thompson\n",
        "http://espn.go.com/nba/player/_/id/510/shawn-marion\n",
        "http://espn.go.com/nba/player/_/id/2489716/matthew-dellavedova\n",
        "http://espn.go.com/nba/player/_/id/2009/james-jones\n",
        "http://espn.go.com/nba/player/_/id/558/mike-miller\n",
        "http://espn.go.com/nba/player/_/id/2528794/joe-harris\n",
        "http://espn.go.com/nba/player/_/id/1000/brendan-haywood\n",
        "http://espn.go.com/nba/player/_/id/2489897/will-cherry\n",
        "http://espn.go.com/nba/player/_/id/4010/a.j.-price\n",
        "http://espn.go.com/nba/player/_/id/3041/lou-amundson\n",
        "http://espn.go.com/nba/player/_/id/2528355/alex-kirk\n"
       ]
      }
     ],
     "prompt_number": 35
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### The problem with the URLs above is that they are the URLs to the shortened version of each players stats page.  To get the complete stats page, we need to slightly modify the URLs by replacing the underscore character with 'stats/_'"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "for row in html_rows:\n",
      "    print(row.a['href'].replace('_','stats/_'))"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "http://espn.go.com/nba/player/stats/_/id/1966/lebron-james\n",
        "http://espn.go.com/nba/player/stats/_/id/6442/kyrie-irving\n",
        "http://espn.go.com/nba/player/stats/_/id/3449/kevin-love\n",
        "http://espn.go.com/nba/player/stats/_/id/6628/dion-waiters\n",
        "http://espn.go.com/nba/player/stats/_/id/2419/anderson-varejao\n",
        "http://espn.go.com/nba/player/stats/_/id/6474/tristan-thompson\n",
        "http://espn.go.com/nba/player/stats/_/id/510/shawn-marion\n",
        "http://espn.go.com/nba/player/stats/_/id/2489716/matthew-dellavedova\n",
        "http://espn.go.com/nba/player/stats/_/id/2009/james-jones\n",
        "http://espn.go.com/nba/player/stats/_/id/558/mike-miller\n",
        "http://espn.go.com/nba/player/stats/_/id/2528794/joe-harris\n",
        "http://espn.go.com/nba/player/stats/_/id/1000/brendan-haywood\n",
        "http://espn.go.com/nba/player/stats/_/id/2489897/will-cherry\n",
        "http://espn.go.com/nba/player/stats/_/id/4010/a.j.-price\n",
        "http://espn.go.com/nba/player/stats/_/id/3041/lou-amundson\n",
        "http://espn.go.com/nba/player/stats/_/id/2528355/alex-kirk\n",
        "http://espn.go.com/nba/player/stats/_/id/1966/lebron-james\n",
        "http://espn.go.com/nba/player/stats/_/id/6442/kyrie-irving\n",
        "http://espn.go.com/nba/player/stats/_/id/3449/kevin-love\n",
        "http://espn.go.com/nba/player/stats/_/id/6628/dion-waiters\n",
        "http://espn.go.com/nba/player/stats/_/id/2419/anderson-varejao\n",
        "http://espn.go.com/nba/player/stats/_/id/6474/tristan-thompson\n",
        "http://espn.go.com/nba/player/stats/_/id/510/shawn-marion\n",
        "http://espn.go.com/nba/player/stats/_/id/2489716/matthew-dellavedova\n",
        "http://espn.go.com/nba/player/stats/_/id/2009/james-jones\n",
        "http://espn.go.com/nba/player/stats/_/id/558/mike-miller\n",
        "http://espn.go.com/nba/player/stats/_/id/2528794/joe-harris\n",
        "http://espn.go.com/nba/player/stats/_/id/1000/brendan-haywood\n",
        "http://espn.go.com/nba/player/stats/_/id/2489897/will-cherry\n",
        "http://espn.go.com/nba/player/stats/_/id/4010/a.j.-price\n",
        "http://espn.go.com/nba/player/stats/_/id/3041/lou-amundson\n",
        "http://espn.go.com/nba/player/stats/_/id/2528355/alex-kirk\n"
       ]
      }
     ],
     "prompt_number": 36
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Now let's make a list containing the URLs of each player"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "player_urls = [row.a['href'].replace('_','stats/_') for row in html_rows]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 37
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "player_urls"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 38,
       "text": [
        "['http://espn.go.com/nba/player/stats/_/id/1966/lebron-james',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/6442/kyrie-irving',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/3449/kevin-love',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/6628/dion-waiters',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/2419/anderson-varejao',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/6474/tristan-thompson',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/510/shawn-marion',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/2489716/matthew-dellavedova',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/2009/james-jones',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/558/mike-miller',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/2528794/joe-harris',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/1000/brendan-haywood',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/2489897/will-cherry',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/4010/a.j.-price',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/3041/lou-amundson',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/2528355/alex-kirk',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/1966/lebron-james',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/6442/kyrie-irving',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/3449/kevin-love',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/6628/dion-waiters',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/2419/anderson-varejao',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/6474/tristan-thompson',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/510/shawn-marion',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/2489716/matthew-dellavedova',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/2009/james-jones',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/558/mike-miller',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/2528794/joe-harris',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/1000/brendan-haywood',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/2489897/will-cherry',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/4010/a.j.-price',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/3041/lou-amundson',\n",
        " 'http://espn.go.com/nba/player/stats/_/id/2528355/alex-kirk']"
       ]
      }
     ],
     "prompt_number": 38
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### I can grab the player's ID which is embedded in the URL also"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "player_id = player_urls[0].split('/')[8]\n",
      "player_id"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 39,
       "text": [
        "'1966'"
       ]
      }
     ],
     "prompt_number": 39
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### So let's snag all the stats for LeBron James"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "player_url = 'http://espn.go.com/nba/player/stats/_/id/1966/lebron-james'\n",
      "html_player = request.urlopen(player_url)\n",
      "\n",
      "soup_player = BeautifulSoup(html_player)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 4
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Need to get player's name so that we can include it in the tables we will be creating"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "soup_name = soup_player.find('meta', property='og:title')\n",
      "player_name = soup_name['content']\n",
      "player_name"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 15,
       "text": [
        "'LeBron James'"
       ]
      }
     ],
     "prompt_number": 15
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "regular_season_stats = soup_player.find_all('tr', class_=re.compile('row'))"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 16
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "len(regular_season_stats)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 17,
       "text": [
        "36"
       ]
      }
     ],
     "prompt_number": 17
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Here's what the raw soup data looks like"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "regular_season_stats"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 18,
       "text": [
        "[<tr class=\"oddrow\"><td>'03-'04</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td>79</td><td>79</td><td style=\"text-align:right;\">39.5</td><td style=\"text-align:right;\">7.9-18.9</td><td style=\"text-align:right;\">.417</td><td style=\"text-align:right;\">0.8-2.7</td><td style=\"text-align:right;\">.290</td><td style=\"text-align:right;\">4.4-5.8</td><td style=\"text-align:right;\">.754</td><td style=\"text-align:right;\">1.3</td><td style=\"text-align:right;\">4.2</td><td style=\"text-align:right;\">5.5</td><td style=\"text-align:right;\">5.9</td><td style=\"text-align:right;\">0.7</td><td style=\"text-align:right;\">1.6</td><td style=\"text-align:right;\">1.9</td><td style=\"text-align:right;\">3.5</td><td style=\"text-align:right;\">20.9</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'04-'05</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td>80</td><td>80</td><td style=\"text-align:right;\">42.4</td><td style=\"text-align:right;\">9.9-21.1</td><td style=\"text-align:right;\">.472</td><td style=\"text-align:right;\">1.4-3.9</td><td style=\"text-align:right;\">.351</td><td style=\"text-align:right;\">6.0-8.0</td><td style=\"text-align:right;\">.750</td><td style=\"text-align:right;\">1.4</td><td style=\"text-align:right;\">6.0</td><td style=\"text-align:right;\">7.4</td><td style=\"text-align:right;\">7.2</td><td style=\"text-align:right;\">0.7</td><td style=\"text-align:right;\">2.2</td><td style=\"text-align:right;\">1.8</td><td style=\"text-align:right;\">3.3</td><td style=\"text-align:right;\">27.2</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'05-'06</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td>79</td><td>79</td><td style=\"text-align:right;\">42.5</td><td style=\"text-align:right;\">11.1-23.1</td><td style=\"text-align:right;\">.480</td><td style=\"text-align:right;\">1.6-4.8</td><td style=\"text-align:right;\">.335</td><td style=\"text-align:right;\">7.6-10.3</td><td style=\"text-align:right;\">.738</td><td style=\"text-align:right;\">1.0</td><td style=\"text-align:right;\">6.1</td><td style=\"text-align:right;\">7.0</td><td style=\"text-align:right;\">6.6</td><td style=\"text-align:right;\">0.8</td><td style=\"text-align:right;\">1.6</td><td style=\"text-align:right;\">2.3</td><td style=\"text-align:right;\">3.3</td><td style=\"text-align:right;\">31.4</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'06-'07</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td>78</td><td>78</td><td style=\"text-align:right;\">40.9</td><td style=\"text-align:right;\">9.9-20.8</td><td style=\"text-align:right;\">.476</td><td style=\"text-align:right;\">1.3-4.0</td><td style=\"text-align:right;\">.319</td><td style=\"text-align:right;\">6.3-9.0</td><td style=\"text-align:right;\">.698</td><td style=\"text-align:right;\">1.1</td><td style=\"text-align:right;\">5.7</td><td style=\"text-align:right;\">6.7</td><td style=\"text-align:right;\">6.0</td><td style=\"text-align:right;\">0.7</td><td style=\"text-align:right;\">1.6</td><td style=\"text-align:right;\">2.2</td><td style=\"text-align:right;\">3.2</td><td style=\"text-align:right;\">27.3</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'07-'08</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td>75</td><td>74</td><td style=\"text-align:right;\">40.4</td><td style=\"text-align:right;\">10.6-21.9</td><td style=\"text-align:right;\">.484</td><td style=\"text-align:right;\">1.5-4.8</td><td style=\"text-align:right;\">.315</td><td style=\"text-align:right;\">7.3-10.3</td><td style=\"text-align:right;\">.712</td><td style=\"text-align:right;\">1.8</td><td style=\"text-align:right;\">6.1</td><td style=\"text-align:right;\">7.9</td><td style=\"text-align:right;\">7.2</td><td style=\"text-align:right;\">1.1</td><td style=\"text-align:right;\">1.8</td><td style=\"text-align:right;\">2.2</td><td style=\"text-align:right;\">3.4</td><td style=\"text-align:right;\">30.0</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'08-'09</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td>81</td><td>81</td><td style=\"text-align:right;\">37.7</td><td style=\"text-align:right;\">9.7-19.9</td><td style=\"text-align:right;\">.489</td><td style=\"text-align:right;\">1.6-4.7</td><td style=\"text-align:right;\">.344</td><td style=\"text-align:right;\">7.3-9.4</td><td style=\"text-align:right;\">.780</td><td style=\"text-align:right;\">1.3</td><td style=\"text-align:right;\">6.3</td><td style=\"text-align:right;\">7.6</td><td style=\"text-align:right;\">7.2</td><td style=\"text-align:right;\">1.1</td><td style=\"text-align:right;\">1.7</td><td style=\"text-align:right;\">1.7</td><td style=\"text-align:right;\">3.0</td><td style=\"text-align:right;\">28.4</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'09-'10</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td>76</td><td>76</td><td style=\"text-align:right;\">39.0</td><td style=\"text-align:right;\">10.1-20.1</td><td style=\"text-align:right;\">.503</td><td style=\"text-align:right;\">1.7-5.1</td><td style=\"text-align:right;\">.333</td><td style=\"text-align:right;\">7.8-10.2</td><td style=\"text-align:right;\">.767</td><td style=\"text-align:right;\">0.9</td><td style=\"text-align:right;\">6.4</td><td style=\"text-align:right;\">7.3</td><td style=\"text-align:right;\">8.6</td><td style=\"text-align:right;\">1.0</td><td style=\"text-align:right;\">1.6</td><td style=\"text-align:right;\">1.6</td><td style=\"text-align:right;\">3.4</td><td style=\"text-align:right;\">29.7</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'10-'11</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-14\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\">MIA</a></li></ul></td><td>79</td><td>79</td><td style=\"text-align:right;\">38.8</td><td style=\"text-align:right;\">9.6-18.8</td><td style=\"text-align:right;\">.510</td><td style=\"text-align:right;\">1.2-3.5</td><td style=\"text-align:right;\">.330</td><td style=\"text-align:right;\">6.4-8.4</td><td style=\"text-align:right;\">.759</td><td style=\"text-align:right;\">1.0</td><td style=\"text-align:right;\">6.5</td><td style=\"text-align:right;\">7.5</td><td style=\"text-align:right;\">7.0</td><td style=\"text-align:right;\">0.6</td><td style=\"text-align:right;\">1.6</td><td style=\"text-align:right;\">2.1</td><td style=\"text-align:right;\">3.6</td><td style=\"text-align:right;\">26.7</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'11-'12</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-14\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\">MIA</a></li></ul></td><td>62</td><td>62</td><td style=\"text-align:right;\">37.5</td><td style=\"text-align:right;\">10.0-18.9</td><td style=\"text-align:right;\">.531</td><td style=\"text-align:right;\">0.9-2.4</td><td style=\"text-align:right;\">.362</td><td style=\"text-align:right;\">6.2-8.1</td><td style=\"text-align:right;\">.771</td><td style=\"text-align:right;\">1.5</td><td style=\"text-align:right;\">6.4</td><td style=\"text-align:right;\">7.9</td><td style=\"text-align:right;\">6.2</td><td style=\"text-align:right;\">0.8</td><td style=\"text-align:right;\">1.9</td><td style=\"text-align:right;\">1.5</td><td style=\"text-align:right;\">3.4</td><td style=\"text-align:right;\">27.1</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'12-'13</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-14\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\">MIA</a></li></ul></td><td>76</td><td>76</td><td style=\"text-align:right;\">37.9</td><td style=\"text-align:right;\">10.1-17.8</td><td style=\"text-align:right;\">.565</td><td style=\"text-align:right;\">1.4-3.3</td><td style=\"text-align:right;\">.406</td><td style=\"text-align:right;\">5.3-7.0</td><td style=\"text-align:right;\">.753</td><td style=\"text-align:right;\">1.3</td><td style=\"text-align:right;\">6.8</td><td style=\"text-align:right;\">8.0</td><td style=\"text-align:right;\">7.3</td><td style=\"text-align:right;\">0.9</td><td style=\"text-align:right;\">1.7</td><td style=\"text-align:right;\">1.4</td><td style=\"text-align:right;\">3.0</td><td style=\"text-align:right;\">26.8</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'13-'14</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-14\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\">MIA</a></li></ul></td><td>77</td><td>77</td><td style=\"text-align:right;\">37.7</td><td style=\"text-align:right;\">10.0-17.6</td><td style=\"text-align:right;\">.567</td><td style=\"text-align:right;\">1.5-4.0</td><td style=\"text-align:right;\">.379</td><td style=\"text-align:right;\">5.7-7.6</td><td style=\"text-align:right;\">.750</td><td style=\"text-align:right;\">1.1</td><td style=\"text-align:right;\">5.9</td><td style=\"text-align:right;\">6.9</td><td style=\"text-align:right;\">6.4</td><td style=\"text-align:right;\">0.3</td><td style=\"text-align:right;\">1.6</td><td style=\"text-align:right;\">1.6</td><td style=\"text-align:right;\">3.5</td><td style=\"text-align:right;\">27.1</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'14-'15</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td>29</td><td>29</td><td style=\"text-align:right;\">37.5</td><td style=\"text-align:right;\">8.8-18.1</td><td style=\"text-align:right;\">.488</td><td style=\"text-align:right;\">1.7-4.5</td><td style=\"text-align:right;\">.369</td><td style=\"text-align:right;\">5.9-7.9</td><td style=\"text-align:right;\">.743</td><td style=\"text-align:right;\">0.7</td><td style=\"text-align:right;\">4.6</td><td style=\"text-align:right;\">5.3</td><td style=\"text-align:right;\">7.6</td><td style=\"text-align:right;\">0.8</td><td style=\"text-align:right;\">1.3</td><td style=\"text-align:right;\">1.7</td><td style=\"text-align:right;\">3.8</td><td style=\"text-align:right;\">25.2</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'03-'04</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">622-1492</td><td style=\"text-align:right;\">.417</td><td style=\"text-align:right;\">63-217</td><td style=\"text-align:right;\">.290</td><td style=\"text-align:right;\">347-460</td><td style=\"text-align:right;\">.754</td><td style=\"text-align:right;\">99</td><td style=\"text-align:right;\">333</td><td style=\"text-align:right;\">432</td><td style=\"text-align:right;\">465</td><td style=\"text-align:right;\">58</td><td style=\"text-align:right;\">130</td><td style=\"text-align:right;\">149</td><td style=\"text-align:right;\">273</td><td style=\"text-align:right;\">1654</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'04-'05</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">795-1684</td><td style=\"text-align:right;\">.472</td><td style=\"text-align:right;\">108-308</td><td style=\"text-align:right;\">.351</td><td style=\"text-align:right;\">477-636</td><td style=\"text-align:right;\">.750</td><td style=\"text-align:right;\">111</td><td style=\"text-align:right;\">477</td><td style=\"text-align:right;\">588</td><td style=\"text-align:right;\">577</td><td style=\"text-align:right;\">52</td><td style=\"text-align:right;\">177</td><td style=\"text-align:right;\">146</td><td style=\"text-align:right;\">262</td><td style=\"text-align:right;\">2175</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'05-'06</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">875-1823</td><td style=\"text-align:right;\">.480</td><td style=\"text-align:right;\">127-379</td><td style=\"text-align:right;\">.335</td><td style=\"text-align:right;\">601-814</td><td style=\"text-align:right;\">.738</td><td style=\"text-align:right;\">75</td><td style=\"text-align:right;\">481</td><td style=\"text-align:right;\">556</td><td style=\"text-align:right;\">521</td><td style=\"text-align:right;\">66</td><td style=\"text-align:right;\">123</td><td style=\"text-align:right;\">181</td><td style=\"text-align:right;\">260</td><td style=\"text-align:right;\">2478</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'06-'07</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">772-1621</td><td style=\"text-align:right;\">.476</td><td style=\"text-align:right;\">99-310</td><td style=\"text-align:right;\">.319</td><td style=\"text-align:right;\">489-701</td><td style=\"text-align:right;\">.698</td><td style=\"text-align:right;\">83</td><td style=\"text-align:right;\">443</td><td style=\"text-align:right;\">526</td><td style=\"text-align:right;\">470</td><td style=\"text-align:right;\">55</td><td style=\"text-align:right;\">125</td><td style=\"text-align:right;\">171</td><td style=\"text-align:right;\">250</td><td style=\"text-align:right;\">2132</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'07-'08</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">794-1642</td><td style=\"text-align:right;\">.484</td><td style=\"text-align:right;\">113-359</td><td style=\"text-align:right;\">.315</td><td style=\"text-align:right;\">549-771</td><td style=\"text-align:right;\">.712</td><td style=\"text-align:right;\">133</td><td style=\"text-align:right;\">459</td><td style=\"text-align:right;\">592</td><td style=\"text-align:right;\">539</td><td style=\"text-align:right;\">81</td><td style=\"text-align:right;\">138</td><td style=\"text-align:right;\">165</td><td style=\"text-align:right;\">255</td><td style=\"text-align:right;\">2250</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'08-'09</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">789-1613</td><td style=\"text-align:right;\">.489</td><td style=\"text-align:right;\">132-384</td><td style=\"text-align:right;\">.344</td><td style=\"text-align:right;\">594-762</td><td style=\"text-align:right;\">.780</td><td style=\"text-align:right;\">106</td><td style=\"text-align:right;\">507</td><td style=\"text-align:right;\">613</td><td style=\"text-align:right;\">587</td><td style=\"text-align:right;\">93</td><td style=\"text-align:right;\">137</td><td style=\"text-align:right;\">139</td><td style=\"text-align:right;\">241</td><td style=\"text-align:right;\">2304</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'09-'10</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">768-1528</td><td style=\"text-align:right;\">.503</td><td style=\"text-align:right;\">129-387</td><td style=\"text-align:right;\">.333</td><td style=\"text-align:right;\">593-773</td><td style=\"text-align:right;\">.767</td><td style=\"text-align:right;\">71</td><td style=\"text-align:right;\">483</td><td style=\"text-align:right;\">554</td><td style=\"text-align:right;\">651</td><td style=\"text-align:right;\">77</td><td style=\"text-align:right;\">125</td><td style=\"text-align:right;\">119</td><td style=\"text-align:right;\">261</td><td style=\"text-align:right;\">2258</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'10-'11</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-14\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\">MIA</a></li></ul></td><td style=\"text-align:right;\">758-1485</td><td style=\"text-align:right;\">.510</td><td style=\"text-align:right;\">92-279</td><td style=\"text-align:right;\">.330</td><td style=\"text-align:right;\">503-663</td><td style=\"text-align:right;\">.759</td><td style=\"text-align:right;\">80</td><td style=\"text-align:right;\">510</td><td style=\"text-align:right;\">590</td><td style=\"text-align:right;\">554</td><td style=\"text-align:right;\">50</td><td style=\"text-align:right;\">124</td><td style=\"text-align:right;\">163</td><td style=\"text-align:right;\">284</td><td style=\"text-align:right;\">2111</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'11-'12</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-14\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\">MIA</a></li></ul></td><td style=\"text-align:right;\">621-1169</td><td style=\"text-align:right;\">.531</td><td style=\"text-align:right;\">54-149</td><td style=\"text-align:right;\">.362</td><td style=\"text-align:right;\">387-502</td><td style=\"text-align:right;\">.771</td><td style=\"text-align:right;\">94</td><td style=\"text-align:right;\">398</td><td style=\"text-align:right;\">492</td><td style=\"text-align:right;\">387</td><td style=\"text-align:right;\">50</td><td style=\"text-align:right;\">115</td><td style=\"text-align:right;\">96</td><td style=\"text-align:right;\">213</td><td style=\"text-align:right;\">1683</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'12-'13</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-14\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\">MIA</a></li></ul></td><td style=\"text-align:right;\">765-1354</td><td style=\"text-align:right;\">.565</td><td style=\"text-align:right;\">103-254</td><td style=\"text-align:right;\">.406</td><td style=\"text-align:right;\">403-535</td><td style=\"text-align:right;\">.753</td><td style=\"text-align:right;\">97</td><td style=\"text-align:right;\">513</td><td style=\"text-align:right;\">610</td><td style=\"text-align:right;\">551</td><td style=\"text-align:right;\">67</td><td style=\"text-align:right;\">129</td><td style=\"text-align:right;\">110</td><td style=\"text-align:right;\">226</td><td style=\"text-align:right;\">2036</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'13-'14</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-14\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\">MIA</a></li></ul></td><td style=\"text-align:right;\">767-1353</td><td style=\"text-align:right;\">.567</td><td style=\"text-align:right;\">116-306</td><td style=\"text-align:right;\">.379</td><td style=\"text-align:right;\">439-585</td><td style=\"text-align:right;\">.750</td><td style=\"text-align:right;\">81</td><td style=\"text-align:right;\">452</td><td style=\"text-align:right;\">533</td><td style=\"text-align:right;\">489</td><td style=\"text-align:right;\">26</td><td style=\"text-align:right;\">121</td><td style=\"text-align:right;\">126</td><td style=\"text-align:right;\">270</td><td style=\"text-align:right;\">2089</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'14-'15</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">256-525</td><td style=\"text-align:right;\">.488</td><td style=\"text-align:right;\">48-130</td><td style=\"text-align:right;\">.369</td><td style=\"text-align:right;\">171-230</td><td style=\"text-align:right;\">.743</td><td style=\"text-align:right;\">19</td><td style=\"text-align:right;\">134</td><td style=\"text-align:right;\">153</td><td style=\"text-align:right;\">221</td><td style=\"text-align:right;\">23</td><td style=\"text-align:right;\">39</td><td style=\"text-align:right;\">50</td><td style=\"text-align:right;\">111</td><td style=\"text-align:right;\">731</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'03-'04</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">12</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">2</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">1.70</td><td style=\"text-align:right;\">0.48</td><td style=\"text-align:right;\">34.32</td><td style=\"text-align:right;\">1.109</td><td style=\"text-align:right;\">.438</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'04-'05</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">25</td><td style=\"text-align:right;\">4</td><td style=\"text-align:right;\">1</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">4</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">2.20</td><td style=\"text-align:right;\">0.68</td><td style=\"text-align:right;\">47.09</td><td style=\"text-align:right;\">1.292</td><td style=\"text-align:right;\">.504</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'05-'06</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">21</td><td style=\"text-align:right;\">5</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">2.00</td><td style=\"text-align:right;\">0.47</td><td style=\"text-align:right;\">50.09</td><td style=\"text-align:right;\">1.359</td><td style=\"text-align:right;\">.515</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'06-'07</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">16</td><td style=\"text-align:right;\">1</td><td style=\"text-align:right;\">1</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">2</td><td style=\"text-align:right;\">2</td><td style=\"text-align:right;\">1.88</td><td style=\"text-align:right;\">0.50</td><td style=\"text-align:right;\">44.08</td><td style=\"text-align:right;\">1.315</td><td style=\"text-align:right;\">.507</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'07-'08</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">31</td><td style=\"text-align:right;\">7</td><td style=\"text-align:right;\">1</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">2</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">2.11</td><td style=\"text-align:right;\">0.54</td><td style=\"text-align:right;\">50.68</td><td style=\"text-align:right;\">1.370</td><td style=\"text-align:right;\">.518</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'08-'09</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">29</td><td style=\"text-align:right;\">7</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">10</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">2.44</td><td style=\"text-align:right;\">0.57</td><td style=\"text-align:right;\">49.97</td><td style=\"text-align:right;\">1.428</td><td style=\"text-align:right;\">.530</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'09-'10</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">31</td><td style=\"text-align:right;\">4</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">4</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">2.49</td><td style=\"text-align:right;\">0.48</td><td style=\"text-align:right;\">52.66</td><td style=\"text-align:right;\">1.478</td><td style=\"text-align:right;\">.545</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'10-'11</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-14\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\">MIA</a></li></ul></td><td style=\"text-align:right;\">31</td><td style=\"text-align:right;\">4</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">7</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">1.95</td><td style=\"text-align:right;\">0.44</td><td style=\"text-align:right;\">46.73</td><td style=\"text-align:right;\">1.422</td><td style=\"text-align:right;\">.541</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'11-'12</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-14\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\">MIA</a></li></ul></td><td style=\"text-align:right;\">23</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">3</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">1.82</td><td style=\"text-align:right;\">0.54</td><td style=\"text-align:right;\">47.86</td><td style=\"text-align:right;\">1.440</td><td style=\"text-align:right;\">.554</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'12-'13</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-14\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\">MIA</a></li></ul></td><td style=\"text-align:right;\">36</td><td style=\"text-align:right;\">4</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">6</td><td style=\"text-align:right;\">1</td><td style=\"text-align:right;\">2.44</td><td style=\"text-align:right;\">0.57</td><td style=\"text-align:right;\">50.30</td><td style=\"text-align:right;\">1.504</td><td style=\"text-align:right;\">.603</td></tr>,\n",
        " <tr class=\"oddrow\"><td>'13-'14</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-14\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/mia/miami-heat\">MIA</a></li></ul></td><td style=\"text-align:right;\">12</td><td style=\"text-align:right;\">1</td><td style=\"text-align:right;\">1</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">5</td><td style=\"text-align:right;\">1</td><td style=\"text-align:right;\">1.81</td><td style=\"text-align:right;\">0.45</td><td style=\"text-align:right;\">47.07</td><td style=\"text-align:right;\">1.544</td><td style=\"text-align:right;\">.610</td></tr>,\n",
        " <tr class=\"evenrow\"><td>'14-'15</td><td><ul class=\"game-schedule\"><li class=\"team-logo-small logo-nba-small nba-small-5\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\"></a></li><li class=\"team-name\"><a href=\"http://espn.go.com/nba/team/_/name/cle/cleveland-cavaliers\">CLE</a></li></ul></td><td style=\"text-align:right;\">11</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">2</td><td style=\"text-align:right;\">0</td><td style=\"text-align:right;\">1.99</td><td style=\"text-align:right;\">0.35</td><td style=\"text-align:right;\">43.01</td><td style=\"text-align:right;\">1.392</td><td style=\"text-align:right;\">.533</td></tr>]"
       ]
      }
     ],
     "prompt_number": 18
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### But let's just get the data that we want and print them out to make sure it is what we want"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "for stat in regular_season_stats:\n",
      "    print(stat.get_text())"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "'03-'04CLE797939.57.9-18.9.4170.8-2.7.2904.4-5.8.7541.34.25.55.90.71.61.93.520.9\n",
        "'04-'05CLE808042.49.9-21.1.4721.4-3.9.3516.0-8.0.7501.46.07.47.20.72.21.83.327.2\n",
        "'05-'06CLE797942.511.1-23.1.4801.6-4.8.3357.6-10.3.7381.06.17.06.60.81.62.33.331.4\n",
        "'06-'07CLE787840.99.9-20.8.4761.3-4.0.3196.3-9.0.6981.15.76.76.00.71.62.23.227.3\n",
        "'07-'08CLE757440.410.6-21.9.4841.5-4.8.3157.3-10.3.7121.86.17.97.21.11.82.23.430.0\n",
        "'08-'09CLE818137.79.7-19.9.4891.6-4.7.3447.3-9.4.7801.36.37.67.21.11.71.73.028.4\n",
        "'09-'10CLE767639.010.1-20.1.5031.7-5.1.3337.8-10.2.7670.96.47.38.61.01.61.63.429.7\n",
        "'10-'11MIA797938.89.6-18.8.5101.2-3.5.3306.4-8.4.7591.06.57.57.00.61.62.13.626.7\n",
        "'11-'12MIA626237.510.0-18.9.5310.9-2.4.3626.2-8.1.7711.56.47.96.20.81.91.53.427.1\n",
        "'12-'13MIA767637.910.1-17.8.5651.4-3.3.4065.3-7.0.7531.36.88.07.30.91.71.43.026.8\n",
        "'13-'14MIA777737.710.0-17.6.5671.5-4.0.3795.7-7.6.7501.15.96.96.40.31.61.63.527.1\n",
        "'14-'15CLE292937.58.8-18.1.4881.7-4.5.3695.9-7.9.7430.74.65.37.60.81.31.73.825.2\n",
        "'03-'04CLE622-1492.41763-217.290347-460.75499333432465581301492731654\n",
        "'04-'05CLE795-1684.472108-308.351477-636.750111477588577521771462622175\n",
        "'05-'06CLE875-1823.480127-379.335601-814.73875481556521661231812602478\n",
        "'06-'07CLE772-1621.47699-310.319489-701.69883443526470551251712502132\n",
        "'07-'08CLE794-1642.484113-359.315549-771.712133459592539811381652552250\n",
        "'08-'09CLE789-1613.489132-384.344594-762.780106507613587931371392412304\n",
        "'09-'10CLE768-1528.503129-387.333593-773.76771483554651771251192612258\n",
        "'10-'11MIA758-1485.51092-279.330503-663.75980510590554501241632842111\n",
        "'11-'12MIA621-1169.53154-149.362387-502.7719439849238750115962131683\n",
        "'12-'13MIA765-1354.565103-254.406403-535.75397513610551671291102262036\n",
        "'13-'14MIA767-1353.567116-306.379439-585.75081452533489261211262702089\n",
        "'14-'15CLE256-525.48848-130.369171-230.74319134153221233950111731\n",
        "'03-'04CLE12000201.700.4834.321.109.438\n",
        "'04-'05CLE25410402.200.6847.091.292.504\n",
        "'05-'06CLE21500002.000.4750.091.359.515\n",
        "'06-'07CLE16110221.880.5044.081.315.507\n",
        "'07-'08CLE31710202.110.5450.681.370.518\n",
        "'08-'09CLE297001002.440.5749.971.428.530\n",
        "'09-'10CLE31400402.490.4852.661.478.545\n",
        "'10-'11MIA31400701.950.4446.731.422.541\n",
        "'11-'12MIA23000301.820.5447.861.440.554\n",
        "'12-'13MIA36400612.440.5750.301.504.603\n",
        "'13-'14MIA12110511.810.4547.071.544.610\n",
        "'14-'15CLE11000201.990.3543.011.392.533\n"
       ]
      }
     ],
     "prompt_number": 19
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "#### The regular season stats above actually contains 3 sections of data: regular season averages, regular season totals, and regular season misc totals.  We can isolate them with simple Python slicing.  You can check out LeBron's [page](http://espn.go.com/nba/player/stats/_/id/1966/lebron-james) to see what I'm talking about."
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Since LeBron has participated in 12 seasons and there are 3 sets of stats, we will break up this data into 3 partitions."
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "size = int(len(regular_season_stats)/3)  # LeBron's has participated in 12 seasons\n",
      "size"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 20,
       "text": [
        "12"
       ]
      }
     ],
     "prompt_number": 20
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### I'm going to use Python's slice() method to create named slices or named partitions, just for sake of readability."
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "season_avgs_slice = slice(0,size)\n",
      "season_totals_slice = slice(size,size*2)\n",
      "season_misc_totals_slice = slice(size*2,size*3)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 21
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "regular_season_avgs = regular_season_stats[season_avgs_slice]\n",
      "regular_season_totals = regular_season_stats[season_totals_slice]\n",
      "regular_season_misc_totals = regular_season_stats[season_misc_totals_slice]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 22
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Now that we have partitions setup, let's inspect each one"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "for stat in regular_season_avgs:\n",
      "    print(stat.get_text())"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "'03-'04CLE797939.57.9-18.9.4170.8-2.7.2904.4-5.8.7541.34.25.55.90.71.61.93.520.9\n",
        "'04-'05CLE808042.49.9-21.1.4721.4-3.9.3516.0-8.0.7501.46.07.47.20.72.21.83.327.2\n",
        "'05-'06CLE797942.511.1-23.1.4801.6-4.8.3357.6-10.3.7381.06.17.06.60.81.62.33.331.4\n",
        "'06-'07CLE787840.99.9-20.8.4761.3-4.0.3196.3-9.0.6981.15.76.76.00.71.62.23.227.3\n",
        "'07-'08CLE757440.410.6-21.9.4841.5-4.8.3157.3-10.3.7121.86.17.97.21.11.82.23.430.0\n",
        "'08-'09CLE818137.79.7-19.9.4891.6-4.7.3447.3-9.4.7801.36.37.67.21.11.71.73.028.4\n",
        "'09-'10CLE767639.010.1-20.1.5031.7-5.1.3337.8-10.2.7670.96.47.38.61.01.61.63.429.7\n",
        "'10-'11MIA797938.89.6-18.8.5101.2-3.5.3306.4-8.4.7591.06.57.57.00.61.62.13.626.7\n",
        "'11-'12MIA626237.510.0-18.9.5310.9-2.4.3626.2-8.1.7711.56.47.96.20.81.91.53.427.1\n",
        "'12-'13MIA767637.910.1-17.8.5651.4-3.3.4065.3-7.0.7531.36.88.07.30.91.71.43.026.8\n",
        "'13-'14MIA777737.710.0-17.6.5671.5-4.0.3795.7-7.6.7501.15.96.96.40.31.61.63.527.1\n",
        "'14-'15CLE292937.58.8-18.1.4881.7-4.5.3695.9-7.9.7430.74.65.37.60.81.31.73.825.2\n"
       ]
      }
     ],
     "prompt_number": 23
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "for stat in regular_season_totals:\n",
      "    print(stat.get_text())"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "'03-'04CLE622-1492.41763-217.290347-460.75499333432465581301492731654\n",
        "'04-'05CLE795-1684.472108-308.351477-636.750111477588577521771462622175\n",
        "'05-'06CLE875-1823.480127-379.335601-814.73875481556521661231812602478\n",
        "'06-'07CLE772-1621.47699-310.319489-701.69883443526470551251712502132\n",
        "'07-'08CLE794-1642.484113-359.315549-771.712133459592539811381652552250\n",
        "'08-'09CLE789-1613.489132-384.344594-762.780106507613587931371392412304\n",
        "'09-'10CLE768-1528.503129-387.333593-773.76771483554651771251192612258\n",
        "'10-'11MIA758-1485.51092-279.330503-663.75980510590554501241632842111\n",
        "'11-'12MIA621-1169.53154-149.362387-502.7719439849238750115962131683\n",
        "'12-'13MIA765-1354.565103-254.406403-535.75397513610551671291102262036\n",
        "'13-'14MIA767-1353.567116-306.379439-585.75081452533489261211262702089\n",
        "'14-'15CLE256-525.48848-130.369171-230.74319134153221233950111731\n"
       ]
      }
     ],
     "prompt_number": 24
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "for stat in regular_season_misc_totals:\n",
      "    print(stat.get_text())"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "'03-'04CLE12000201.700.4834.321.109.438\n",
        "'04-'05CLE25410402.200.6847.091.292.504\n",
        "'05-'06CLE21500002.000.4750.091.359.515\n",
        "'06-'07CLE16110221.880.5044.081.315.507\n",
        "'07-'08CLE31710202.110.5450.681.370.518\n",
        "'08-'09CLE297001002.440.5749.971.428.530\n",
        "'09-'10CLE31400402.490.4852.661.478.545\n",
        "'10-'11MIA31400701.950.4446.731.422.541\n",
        "'11-'12MIA23000301.820.5447.861.440.554\n",
        "'12-'13MIA36400612.440.5750.301.504.603\n",
        "'13-'14MIA12110511.810.4547.071.544.610\n",
        "'14-'15CLE11000201.990.3543.011.392.533\n"
       ]
      }
     ],
     "prompt_number": 25
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Looks good.  So we'll create 3 lists for each set of stats:"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "- one for regular season average (\"avgs\")\n",
      "- one for regular season totals (\"totals\")\n",
      "- one for regular season misc totals (\"misc_totals\")"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "avgs = []\n",
      "for row in regular_season_avgs:\n",
      "    for data in row:\n",
      "        avgs.append(data.get_text())"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 44
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "avgs"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 45,
       "text": [
        "[\"'03-'04\",\n",
        " 'CLE',\n",
        " '79',\n",
        " '79',\n",
        " '39.5',\n",
        " '7.9-18.9',\n",
        " '.417',\n",
        " '0.8-2.7',\n",
        " '.290',\n",
        " '4.4-5.8',\n",
        " '.754',\n",
        " '1.3',\n",
        " '4.2',\n",
        " '5.5',\n",
        " '5.9',\n",
        " '0.7',\n",
        " '1.6',\n",
        " '1.9',\n",
        " '3.5',\n",
        " '20.9',\n",
        " \"'04-'05\",\n",
        " 'CLE',\n",
        " '80',\n",
        " '80',\n",
        " '42.4',\n",
        " '9.9-21.1',\n",
        " '.472',\n",
        " '1.4-3.9',\n",
        " '.351',\n",
        " '6.0-8.0',\n",
        " '.750',\n",
        " '1.4',\n",
        " '6.0',\n",
        " '7.4',\n",
        " '7.2',\n",
        " '0.7',\n",
        " '2.2',\n",
        " '1.8',\n",
        " '3.3',\n",
        " '27.2',\n",
        " \"'05-'06\",\n",
        " 'CLE',\n",
        " '79',\n",
        " '79',\n",
        " '42.5',\n",
        " '11.1-23.1',\n",
        " '.480',\n",
        " '1.6-4.8',\n",
        " '.335',\n",
        " '7.6-10.3',\n",
        " '.738',\n",
        " '1.0',\n",
        " '6.1',\n",
        " '7.0',\n",
        " '6.6',\n",
        " '0.8',\n",
        " '1.6',\n",
        " '2.3',\n",
        " '3.3',\n",
        " '31.4',\n",
        " \"'06-'07\",\n",
        " 'CLE',\n",
        " '78',\n",
        " '78',\n",
        " '40.9',\n",
        " '9.9-20.8',\n",
        " '.476',\n",
        " '1.3-4.0',\n",
        " '.319',\n",
        " '6.3-9.0',\n",
        " '.698',\n",
        " '1.1',\n",
        " '5.7',\n",
        " '6.7',\n",
        " '6.0',\n",
        " '0.7',\n",
        " '1.6',\n",
        " '2.2',\n",
        " '3.2',\n",
        " '27.3',\n",
        " \"'07-'08\",\n",
        " 'CLE',\n",
        " '75',\n",
        " '74',\n",
        " '40.4',\n",
        " '10.6-21.9',\n",
        " '.484',\n",
        " '1.5-4.8',\n",
        " '.315',\n",
        " '7.3-10.3',\n",
        " '.712',\n",
        " '1.8',\n",
        " '6.1',\n",
        " '7.9',\n",
        " '7.2',\n",
        " '1.1',\n",
        " '1.8',\n",
        " '2.2',\n",
        " '3.4',\n",
        " '30.0',\n",
        " \"'08-'09\",\n",
        " 'CLE',\n",
        " '81',\n",
        " '81',\n",
        " '37.7',\n",
        " '9.7-19.9',\n",
        " '.489',\n",
        " '1.6-4.7',\n",
        " '.344',\n",
        " '7.3-9.4',\n",
        " '.780',\n",
        " '1.3',\n",
        " '6.3',\n",
        " '7.6',\n",
        " '7.2',\n",
        " '1.1',\n",
        " '1.7',\n",
        " '1.7',\n",
        " '3.0',\n",
        " '28.4',\n",
        " \"'09-'10\",\n",
        " 'CLE',\n",
        " '76',\n",
        " '76',\n",
        " '39.0',\n",
        " '10.1-20.1',\n",
        " '.503',\n",
        " '1.7-5.1',\n",
        " '.333',\n",
        " '7.8-10.2',\n",
        " '.767',\n",
        " '0.9',\n",
        " '6.4',\n",
        " '7.3',\n",
        " '8.6',\n",
        " '1.0',\n",
        " '1.6',\n",
        " '1.6',\n",
        " '3.4',\n",
        " '29.7',\n",
        " \"'10-'11\",\n",
        " 'MIA',\n",
        " '79',\n",
        " '79',\n",
        " '38.8',\n",
        " '9.6-18.8',\n",
        " '.510',\n",
        " '1.2-3.5',\n",
        " '.330',\n",
        " '6.4-8.4',\n",
        " '.759',\n",
        " '1.0',\n",
        " '6.5',\n",
        " '7.5',\n",
        " '7.0',\n",
        " '0.6',\n",
        " '1.6',\n",
        " '2.1',\n",
        " '3.6',\n",
        " '26.7',\n",
        " \"'11-'12\",\n",
        " 'MIA',\n",
        " '62',\n",
        " '62',\n",
        " '37.5',\n",
        " '10.0-18.9',\n",
        " '.531',\n",
        " '0.9-2.4',\n",
        " '.362',\n",
        " '6.2-8.1',\n",
        " '.771',\n",
        " '1.5',\n",
        " '6.4',\n",
        " '7.9',\n",
        " '6.2',\n",
        " '0.8',\n",
        " '1.9',\n",
        " '1.5',\n",
        " '3.4',\n",
        " '27.1',\n",
        " \"'12-'13\",\n",
        " 'MIA',\n",
        " '76',\n",
        " '76',\n",
        " '37.9',\n",
        " '10.1-17.8',\n",
        " '.565',\n",
        " '1.4-3.3',\n",
        " '.406',\n",
        " '5.3-7.0',\n",
        " '.753',\n",
        " '1.3',\n",
        " '6.8',\n",
        " '8.0',\n",
        " '7.3',\n",
        " '0.9',\n",
        " '1.7',\n",
        " '1.4',\n",
        " '3.0',\n",
        " '26.8',\n",
        " \"'13-'14\",\n",
        " 'MIA',\n",
        " '77',\n",
        " '77',\n",
        " '37.7',\n",
        " '10.0-17.6',\n",
        " '.567',\n",
        " '1.5-4.0',\n",
        " '.379',\n",
        " '5.7-7.6',\n",
        " '.750',\n",
        " '1.1',\n",
        " '5.9',\n",
        " '6.9',\n",
        " '6.4',\n",
        " '0.3',\n",
        " '1.6',\n",
        " '1.6',\n",
        " '3.5',\n",
        " '27.1',\n",
        " \"'14-'15\",\n",
        " 'CLE',\n",
        " '29',\n",
        " '29',\n",
        " '37.5',\n",
        " '8.8-18.1',\n",
        " '.488',\n",
        " '1.7-4.5',\n",
        " '.369',\n",
        " '5.9-7.9',\n",
        " '.743',\n",
        " '0.7',\n",
        " '4.6',\n",
        " '5.3',\n",
        " '7.6',\n",
        " '0.8',\n",
        " '1.3',\n",
        " '1.7',\n",
        " '3.8',\n",
        " '25.2']"
       ]
      }
     ],
     "prompt_number": 45
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### So that we can merge this table with other tables associated with a player, I want to include the player's ID also in the list."
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "index = 0 # insert the player ID before the player's season\n",
      "increment = 0\n",
      "for row in range(len(regular_season_avgs)):\n",
      "    avgs.insert(index + increment, player_id)\n",
      "    index = index + 20  # There are 20 columns in the season avgs section\n",
      "    increment = increment + 1"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 46
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Also want to insert player's name as the 2nd element in the list"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "index = 1 # insert the player's name after the player's ID\n",
      "increment = 0\n",
      "for row in range(len(regular_season_avgs)):\n",
      "    avgs.insert(index + increment, player_name)\n",
      "    index = index + 21  # There are 21 columns in the season avgs section since I've just added player ID\n",
      "    increment = increment + 1"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 47
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Let's see if the player ID and player's name was added:"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "avgs"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 48,
       "text": [
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'03-'04\",\n",
        " 'CLE',\n",
        " '79',\n",
        " '79',\n",
        " '39.5',\n",
        " '7.9-18.9',\n",
        " '.417',\n",
        " '0.8-2.7',\n",
        " '.290',\n",
        " '4.4-5.8',\n",
        " '.754',\n",
        " '1.3',\n",
        " '4.2',\n",
        " '5.5',\n",
        " '5.9',\n",
        " '0.7',\n",
        " '1.6',\n",
        " '1.9',\n",
        " '3.5',\n",
        " '20.9',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'04-'05\",\n",
        " 'CLE',\n",
        " '80',\n",
        " '80',\n",
        " '42.4',\n",
        " '9.9-21.1',\n",
        " '.472',\n",
        " '1.4-3.9',\n",
        " '.351',\n",
        " '6.0-8.0',\n",
        " '.750',\n",
        " '1.4',\n",
        " '6.0',\n",
        " '7.4',\n",
        " '7.2',\n",
        " '0.7',\n",
        " '2.2',\n",
        " '1.8',\n",
        " '3.3',\n",
        " '27.2',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'05-'06\",\n",
        " 'CLE',\n",
        " '79',\n",
        " '79',\n",
        " '42.5',\n",
        " '11.1-23.1',\n",
        " '.480',\n",
        " '1.6-4.8',\n",
        " '.335',\n",
        " '7.6-10.3',\n",
        " '.738',\n",
        " '1.0',\n",
        " '6.1',\n",
        " '7.0',\n",
        " '6.6',\n",
        " '0.8',\n",
        " '1.6',\n",
        " '2.3',\n",
        " '3.3',\n",
        " '31.4',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'06-'07\",\n",
        " 'CLE',\n",
        " '78',\n",
        " '78',\n",
        " '40.9',\n",
        " '9.9-20.8',\n",
        " '.476',\n",
        " '1.3-4.0',\n",
        " '.319',\n",
        " '6.3-9.0',\n",
        " '.698',\n",
        " '1.1',\n",
        " '5.7',\n",
        " '6.7',\n",
        " '6.0',\n",
        " '0.7',\n",
        " '1.6',\n",
        " '2.2',\n",
        " '3.2',\n",
        " '27.3',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'07-'08\",\n",
        " 'CLE',\n",
        " '75',\n",
        " '74',\n",
        " '40.4',\n",
        " '10.6-21.9',\n",
        " '.484',\n",
        " '1.5-4.8',\n",
        " '.315',\n",
        " '7.3-10.3',\n",
        " '.712',\n",
        " '1.8',\n",
        " '6.1',\n",
        " '7.9',\n",
        " '7.2',\n",
        " '1.1',\n",
        " '1.8',\n",
        " '2.2',\n",
        " '3.4',\n",
        " '30.0',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'08-'09\",\n",
        " 'CLE',\n",
        " '81',\n",
        " '81',\n",
        " '37.7',\n",
        " '9.7-19.9',\n",
        " '.489',\n",
        " '1.6-4.7',\n",
        " '.344',\n",
        " '7.3-9.4',\n",
        " '.780',\n",
        " '1.3',\n",
        " '6.3',\n",
        " '7.6',\n",
        " '7.2',\n",
        " '1.1',\n",
        " '1.7',\n",
        " '1.7',\n",
        " '3.0',\n",
        " '28.4',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'09-'10\",\n",
        " 'CLE',\n",
        " '76',\n",
        " '76',\n",
        " '39.0',\n",
        " '10.1-20.1',\n",
        " '.503',\n",
        " '1.7-5.1',\n",
        " '.333',\n",
        " '7.8-10.2',\n",
        " '.767',\n",
        " '0.9',\n",
        " '6.4',\n",
        " '7.3',\n",
        " '8.6',\n",
        " '1.0',\n",
        " '1.6',\n",
        " '1.6',\n",
        " '3.4',\n",
        " '29.7',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'10-'11\",\n",
        " 'MIA',\n",
        " '79',\n",
        " '79',\n",
        " '38.8',\n",
        " '9.6-18.8',\n",
        " '.510',\n",
        " '1.2-3.5',\n",
        " '.330',\n",
        " '6.4-8.4',\n",
        " '.759',\n",
        " '1.0',\n",
        " '6.5',\n",
        " '7.5',\n",
        " '7.0',\n",
        " '0.6',\n",
        " '1.6',\n",
        " '2.1',\n",
        " '3.6',\n",
        " '26.7',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'11-'12\",\n",
        " 'MIA',\n",
        " '62',\n",
        " '62',\n",
        " '37.5',\n",
        " '10.0-18.9',\n",
        " '.531',\n",
        " '0.9-2.4',\n",
        " '.362',\n",
        " '6.2-8.1',\n",
        " '.771',\n",
        " '1.5',\n",
        " '6.4',\n",
        " '7.9',\n",
        " '6.2',\n",
        " '0.8',\n",
        " '1.9',\n",
        " '1.5',\n",
        " '3.4',\n",
        " '27.1',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'12-'13\",\n",
        " 'MIA',\n",
        " '76',\n",
        " '76',\n",
        " '37.9',\n",
        " '10.1-17.8',\n",
        " '.565',\n",
        " '1.4-3.3',\n",
        " '.406',\n",
        " '5.3-7.0',\n",
        " '.753',\n",
        " '1.3',\n",
        " '6.8',\n",
        " '8.0',\n",
        " '7.3',\n",
        " '0.9',\n",
        " '1.7',\n",
        " '1.4',\n",
        " '3.0',\n",
        " '26.8',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'13-'14\",\n",
        " 'MIA',\n",
        " '77',\n",
        " '77',\n",
        " '37.7',\n",
        " '10.0-17.6',\n",
        " '.567',\n",
        " '1.5-4.0',\n",
        " '.379',\n",
        " '5.7-7.6',\n",
        " '.750',\n",
        " '1.1',\n",
        " '5.9',\n",
        " '6.9',\n",
        " '6.4',\n",
        " '0.3',\n",
        " '1.6',\n",
        " '1.6',\n",
        " '3.5',\n",
        " '27.1',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'14-'15\",\n",
        " 'CLE',\n",
        " '29',\n",
        " '29',\n",
        " '37.5',\n",
        " '8.8-18.1',\n",
        " '.488',\n",
        " '1.7-4.5',\n",
        " '.369',\n",
        " '5.9-7.9',\n",
        " '.743',\n",
        " '0.7',\n",
        " '4.6',\n",
        " '5.3',\n",
        " '7.6',\n",
        " '0.8',\n",
        " '1.3',\n",
        " '1.7',\n",
        " '3.8',\n",
        " '25.2']"
       ]
      }
     ],
     "prompt_number": 48
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### OK, so far so good"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Now, we'll do the same for the season totals and season misc totals"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "totals = []\n",
      "for row in regular_season_totals:\n",
      "    for data in row:\n",
      "        totals.append(data.get_text())"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 55
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "totals"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 50,
       "text": [
        "[\"'03-'04\",\n",
        " 'CLE',\n",
        " '622-1492',\n",
        " '.417',\n",
        " '63-217',\n",
        " '.290',\n",
        " '347-460',\n",
        " '.754',\n",
        " '99',\n",
        " '333',\n",
        " '432',\n",
        " '465',\n",
        " '58',\n",
        " '130',\n",
        " '149',\n",
        " '273',\n",
        " '1654',\n",
        " \"'04-'05\",\n",
        " 'CLE',\n",
        " '795-1684',\n",
        " '.472',\n",
        " '108-308',\n",
        " '.351',\n",
        " '477-636',\n",
        " '.750',\n",
        " '111',\n",
        " '477',\n",
        " '588',\n",
        " '577',\n",
        " '52',\n",
        " '177',\n",
        " '146',\n",
        " '262',\n",
        " '2175',\n",
        " \"'05-'06\",\n",
        " 'CLE',\n",
        " '875-1823',\n",
        " '.480',\n",
        " '127-379',\n",
        " '.335',\n",
        " '601-814',\n",
        " '.738',\n",
        " '75',\n",
        " '481',\n",
        " '556',\n",
        " '521',\n",
        " '66',\n",
        " '123',\n",
        " '181',\n",
        " '260',\n",
        " '2478',\n",
        " \"'06-'07\",\n",
        " 'CLE',\n",
        " '772-1621',\n",
        " '.476',\n",
        " '99-310',\n",
        " '.319',\n",
        " '489-701',\n",
        " '.698',\n",
        " '83',\n",
        " '443',\n",
        " '526',\n",
        " '470',\n",
        " '55',\n",
        " '125',\n",
        " '171',\n",
        " '250',\n",
        " '2132',\n",
        " \"'07-'08\",\n",
        " 'CLE',\n",
        " '794-1642',\n",
        " '.484',\n",
        " '113-359',\n",
        " '.315',\n",
        " '549-771',\n",
        " '.712',\n",
        " '133',\n",
        " '459',\n",
        " '592',\n",
        " '539',\n",
        " '81',\n",
        " '138',\n",
        " '165',\n",
        " '255',\n",
        " '2250',\n",
        " \"'08-'09\",\n",
        " 'CLE',\n",
        " '789-1613',\n",
        " '.489',\n",
        " '132-384',\n",
        " '.344',\n",
        " '594-762',\n",
        " '.780',\n",
        " '106',\n",
        " '507',\n",
        " '613',\n",
        " '587',\n",
        " '93',\n",
        " '137',\n",
        " '139',\n",
        " '241',\n",
        " '2304',\n",
        " \"'09-'10\",\n",
        " 'CLE',\n",
        " '768-1528',\n",
        " '.503',\n",
        " '129-387',\n",
        " '.333',\n",
        " '593-773',\n",
        " '.767',\n",
        " '71',\n",
        " '483',\n",
        " '554',\n",
        " '651',\n",
        " '77',\n",
        " '125',\n",
        " '119',\n",
        " '261',\n",
        " '2258',\n",
        " \"'10-'11\",\n",
        " 'MIA',\n",
        " '758-1485',\n",
        " '.510',\n",
        " '92-279',\n",
        " '.330',\n",
        " '503-663',\n",
        " '.759',\n",
        " '80',\n",
        " '510',\n",
        " '590',\n",
        " '554',\n",
        " '50',\n",
        " '124',\n",
        " '163',\n",
        " '284',\n",
        " '2111',\n",
        " \"'11-'12\",\n",
        " 'MIA',\n",
        " '621-1169',\n",
        " '.531',\n",
        " '54-149',\n",
        " '.362',\n",
        " '387-502',\n",
        " '.771',\n",
        " '94',\n",
        " '398',\n",
        " '492',\n",
        " '387',\n",
        " '50',\n",
        " '115',\n",
        " '96',\n",
        " '213',\n",
        " '1683',\n",
        " \"'12-'13\",\n",
        " 'MIA',\n",
        " '765-1354',\n",
        " '.565',\n",
        " '103-254',\n",
        " '.406',\n",
        " '403-535',\n",
        " '.753',\n",
        " '97',\n",
        " '513',\n",
        " '610',\n",
        " '551',\n",
        " '67',\n",
        " '129',\n",
        " '110',\n",
        " '226',\n",
        " '2036',\n",
        " \"'13-'14\",\n",
        " 'MIA',\n",
        " '767-1353',\n",
        " '.567',\n",
        " '116-306',\n",
        " '.379',\n",
        " '439-585',\n",
        " '.750',\n",
        " '81',\n",
        " '452',\n",
        " '533',\n",
        " '489',\n",
        " '26',\n",
        " '121',\n",
        " '126',\n",
        " '270',\n",
        " '2089',\n",
        " \"'14-'15\",\n",
        " 'CLE',\n",
        " '256-525',\n",
        " '.488',\n",
        " '48-130',\n",
        " '.369',\n",
        " '171-230',\n",
        " '.743',\n",
        " '19',\n",
        " '134',\n",
        " '153',\n",
        " '221',\n",
        " '23',\n",
        " '39',\n",
        " '50',\n",
        " '111',\n",
        " '731']"
       ]
      }
     ],
     "prompt_number": 50
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Again, I'm just inserting the player's ID into the list and then player's name"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "index = 0 # insert the player ID before the player's season\n",
      "increment = 0\n",
      "for row in range(len(regular_season_totals)):\n",
      "    totals.insert(index + increment, player_id)\n",
      "    index = index + 17 # There are 17 columns in the reg season totals section\n",
      "    increment = increment + 1"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 56
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "index = 1 # insert the player's name after the player's ID\n",
      "increment = 0\n",
      "for row in range(len(regular_season_totals)):\n",
      "    totals.insert(index + increment, player_name)\n",
      "    index = index + 18 # There are now 18 columns in the reg season totals after inserting player's ID\n",
      "    increment = increment + 1"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 57
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "totals"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 58,
       "text": [
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'03-'04\",\n",
        " 'CLE',\n",
        " '622-1492',\n",
        " '.417',\n",
        " '63-217',\n",
        " '.290',\n",
        " '347-460',\n",
        " '.754',\n",
        " '99',\n",
        " '333',\n",
        " '432',\n",
        " '465',\n",
        " '58',\n",
        " '130',\n",
        " '149',\n",
        " '273',\n",
        " '1654',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'04-'05\",\n",
        " 'CLE',\n",
        " '795-1684',\n",
        " '.472',\n",
        " '108-308',\n",
        " '.351',\n",
        " '477-636',\n",
        " '.750',\n",
        " '111',\n",
        " '477',\n",
        " '588',\n",
        " '577',\n",
        " '52',\n",
        " '177',\n",
        " '146',\n",
        " '262',\n",
        " '2175',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'05-'06\",\n",
        " 'CLE',\n",
        " '875-1823',\n",
        " '.480',\n",
        " '127-379',\n",
        " '.335',\n",
        " '601-814',\n",
        " '.738',\n",
        " '75',\n",
        " '481',\n",
        " '556',\n",
        " '521',\n",
        " '66',\n",
        " '123',\n",
        " '181',\n",
        " '260',\n",
        " '2478',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'06-'07\",\n",
        " 'CLE',\n",
        " '772-1621',\n",
        " '.476',\n",
        " '99-310',\n",
        " '.319',\n",
        " '489-701',\n",
        " '.698',\n",
        " '83',\n",
        " '443',\n",
        " '526',\n",
        " '470',\n",
        " '55',\n",
        " '125',\n",
        " '171',\n",
        " '250',\n",
        " '2132',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'07-'08\",\n",
        " 'CLE',\n",
        " '794-1642',\n",
        " '.484',\n",
        " '113-359',\n",
        " '.315',\n",
        " '549-771',\n",
        " '.712',\n",
        " '133',\n",
        " '459',\n",
        " '592',\n",
        " '539',\n",
        " '81',\n",
        " '138',\n",
        " '165',\n",
        " '255',\n",
        " '2250',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'08-'09\",\n",
        " 'CLE',\n",
        " '789-1613',\n",
        " '.489',\n",
        " '132-384',\n",
        " '.344',\n",
        " '594-762',\n",
        " '.780',\n",
        " '106',\n",
        " '507',\n",
        " '613',\n",
        " '587',\n",
        " '93',\n",
        " '137',\n",
        " '139',\n",
        " '241',\n",
        " '2304',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'09-'10\",\n",
        " 'CLE',\n",
        " '768-1528',\n",
        " '.503',\n",
        " '129-387',\n",
        " '.333',\n",
        " '593-773',\n",
        " '.767',\n",
        " '71',\n",
        " '483',\n",
        " '554',\n",
        " '651',\n",
        " '77',\n",
        " '125',\n",
        " '119',\n",
        " '261',\n",
        " '2258',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'10-'11\",\n",
        " 'MIA',\n",
        " '758-1485',\n",
        " '.510',\n",
        " '92-279',\n",
        " '.330',\n",
        " '503-663',\n",
        " '.759',\n",
        " '80',\n",
        " '510',\n",
        " '590',\n",
        " '554',\n",
        " '50',\n",
        " '124',\n",
        " '163',\n",
        " '284',\n",
        " '2111',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'11-'12\",\n",
        " 'MIA',\n",
        " '621-1169',\n",
        " '.531',\n",
        " '54-149',\n",
        " '.362',\n",
        " '387-502',\n",
        " '.771',\n",
        " '94',\n",
        " '398',\n",
        " '492',\n",
        " '387',\n",
        " '50',\n",
        " '115',\n",
        " '96',\n",
        " '213',\n",
        " '1683',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'12-'13\",\n",
        " 'MIA',\n",
        " '765-1354',\n",
        " '.565',\n",
        " '103-254',\n",
        " '.406',\n",
        " '403-535',\n",
        " '.753',\n",
        " '97',\n",
        " '513',\n",
        " '610',\n",
        " '551',\n",
        " '67',\n",
        " '129',\n",
        " '110',\n",
        " '226',\n",
        " '2036',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'13-'14\",\n",
        " 'MIA',\n",
        " '767-1353',\n",
        " '.567',\n",
        " '116-306',\n",
        " '.379',\n",
        " '439-585',\n",
        " '.750',\n",
        " '81',\n",
        " '452',\n",
        " '533',\n",
        " '489',\n",
        " '26',\n",
        " '121',\n",
        " '126',\n",
        " '270',\n",
        " '2089',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'14-'15\",\n",
        " 'CLE',\n",
        " '256-525',\n",
        " '.488',\n",
        " '48-130',\n",
        " '.369',\n",
        " '171-230',\n",
        " '.743',\n",
        " '19',\n",
        " '134',\n",
        " '153',\n",
        " '221',\n",
        " '23',\n",
        " '39',\n",
        " '50',\n",
        " '111',\n",
        " '731']"
       ]
      }
     ],
     "prompt_number": 58
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "misc_totals = []\n",
      "for row in regular_season_misc_totals:\n",
      "    for data in row:\n",
      "        misc_totals.append(data.get_text())"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 59
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "misc_totals"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 60,
       "text": [
        "[\"'03-'04\",\n",
        " 'CLE',\n",
        " '12',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '2',\n",
        " '0',\n",
        " '1.70',\n",
        " '0.48',\n",
        " '34.32',\n",
        " '1.109',\n",
        " '.438',\n",
        " \"'04-'05\",\n",
        " 'CLE',\n",
        " '25',\n",
        " '4',\n",
        " '1',\n",
        " '0',\n",
        " '4',\n",
        " '0',\n",
        " '2.20',\n",
        " '0.68',\n",
        " '47.09',\n",
        " '1.292',\n",
        " '.504',\n",
        " \"'05-'06\",\n",
        " 'CLE',\n",
        " '21',\n",
        " '5',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '2.00',\n",
        " '0.47',\n",
        " '50.09',\n",
        " '1.359',\n",
        " '.515',\n",
        " \"'06-'07\",\n",
        " 'CLE',\n",
        " '16',\n",
        " '1',\n",
        " '1',\n",
        " '0',\n",
        " '2',\n",
        " '2',\n",
        " '1.88',\n",
        " '0.50',\n",
        " '44.08',\n",
        " '1.315',\n",
        " '.507',\n",
        " \"'07-'08\",\n",
        " 'CLE',\n",
        " '31',\n",
        " '7',\n",
        " '1',\n",
        " '0',\n",
        " '2',\n",
        " '0',\n",
        " '2.11',\n",
        " '0.54',\n",
        " '50.68',\n",
        " '1.370',\n",
        " '.518',\n",
        " \"'08-'09\",\n",
        " 'CLE',\n",
        " '29',\n",
        " '7',\n",
        " '0',\n",
        " '0',\n",
        " '10',\n",
        " '0',\n",
        " '2.44',\n",
        " '0.57',\n",
        " '49.97',\n",
        " '1.428',\n",
        " '.530',\n",
        " \"'09-'10\",\n",
        " 'CLE',\n",
        " '31',\n",
        " '4',\n",
        " '0',\n",
        " '0',\n",
        " '4',\n",
        " '0',\n",
        " '2.49',\n",
        " '0.48',\n",
        " '52.66',\n",
        " '1.478',\n",
        " '.545',\n",
        " \"'10-'11\",\n",
        " 'MIA',\n",
        " '31',\n",
        " '4',\n",
        " '0',\n",
        " '0',\n",
        " '7',\n",
        " '0',\n",
        " '1.95',\n",
        " '0.44',\n",
        " '46.73',\n",
        " '1.422',\n",
        " '.541',\n",
        " \"'11-'12\",\n",
        " 'MIA',\n",
        " '23',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '3',\n",
        " '0',\n",
        " '1.82',\n",
        " '0.54',\n",
        " '47.86',\n",
        " '1.440',\n",
        " '.554',\n",
        " \"'12-'13\",\n",
        " 'MIA',\n",
        " '36',\n",
        " '4',\n",
        " '0',\n",
        " '0',\n",
        " '6',\n",
        " '1',\n",
        " '2.44',\n",
        " '0.57',\n",
        " '50.30',\n",
        " '1.504',\n",
        " '.603',\n",
        " \"'13-'14\",\n",
        " 'MIA',\n",
        " '12',\n",
        " '1',\n",
        " '1',\n",
        " '0',\n",
        " '5',\n",
        " '1',\n",
        " '1.81',\n",
        " '0.45',\n",
        " '47.07',\n",
        " '1.544',\n",
        " '.610',\n",
        " \"'14-'15\",\n",
        " 'CLE',\n",
        " '11',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '2',\n",
        " '0',\n",
        " '1.99',\n",
        " '0.35',\n",
        " '43.01',\n",
        " '1.392',\n",
        " '.533']"
       ]
      }
     ],
     "prompt_number": 60
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Again, I am inserting the player's ID into this list."
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "index = 0 # insert the player ID before the player's season\n",
      "increment = 0\n",
      "for row in range(len(regular_season_misc_totals)):\n",
      "    misc_totals.insert(index + increment, player_id)\n",
      "    index = index + 13 # There are 13 columns in the reg season misc totals section\n",
      "    increment = increment + 1"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 61
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "index = 1 # insert the player's name after the player's ID\n",
      "increment = 0\n",
      "for row in range(len(regular_season_misc_totals)):\n",
      "    misc_totals.insert(index + increment, player_name)\n",
      "    index = index + 14 # There are now 14 columns in the reg season misc totals after inserting player ID\n",
      "    increment = increment + 1"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 63
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "misc_totals"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 64,
       "text": [
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'03-'04\",\n",
        " 'CLE',\n",
        " '12',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '2',\n",
        " '0',\n",
        " '1.70',\n",
        " '0.48',\n",
        " '34.32',\n",
        " '1.109',\n",
        " '.438',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'04-'05\",\n",
        " 'CLE',\n",
        " '25',\n",
        " '4',\n",
        " '1',\n",
        " '0',\n",
        " '4',\n",
        " '0',\n",
        " '2.20',\n",
        " '0.68',\n",
        " '47.09',\n",
        " '1.292',\n",
        " '.504',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'05-'06\",\n",
        " 'CLE',\n",
        " '21',\n",
        " '5',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '2.00',\n",
        " '0.47',\n",
        " '50.09',\n",
        " '1.359',\n",
        " '.515',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'06-'07\",\n",
        " 'CLE',\n",
        " '16',\n",
        " '1',\n",
        " '1',\n",
        " '0',\n",
        " '2',\n",
        " '2',\n",
        " '1.88',\n",
        " '0.50',\n",
        " '44.08',\n",
        " '1.315',\n",
        " '.507',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'07-'08\",\n",
        " 'CLE',\n",
        " '31',\n",
        " '7',\n",
        " '1',\n",
        " '0',\n",
        " '2',\n",
        " '0',\n",
        " '2.11',\n",
        " '0.54',\n",
        " '50.68',\n",
        " '1.370',\n",
        " '.518',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'08-'09\",\n",
        " 'CLE',\n",
        " '29',\n",
        " '7',\n",
        " '0',\n",
        " '0',\n",
        " '10',\n",
        " '0',\n",
        " '2.44',\n",
        " '0.57',\n",
        " '49.97',\n",
        " '1.428',\n",
        " '.530',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'09-'10\",\n",
        " 'CLE',\n",
        " '31',\n",
        " '4',\n",
        " '0',\n",
        " '0',\n",
        " '4',\n",
        " '0',\n",
        " '2.49',\n",
        " '0.48',\n",
        " '52.66',\n",
        " '1.478',\n",
        " '.545',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'10-'11\",\n",
        " 'MIA',\n",
        " '31',\n",
        " '4',\n",
        " '0',\n",
        " '0',\n",
        " '7',\n",
        " '0',\n",
        " '1.95',\n",
        " '0.44',\n",
        " '46.73',\n",
        " '1.422',\n",
        " '.541',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'11-'12\",\n",
        " 'MIA',\n",
        " '23',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '3',\n",
        " '0',\n",
        " '1.82',\n",
        " '0.54',\n",
        " '47.86',\n",
        " '1.440',\n",
        " '.554',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'12-'13\",\n",
        " 'MIA',\n",
        " '36',\n",
        " '4',\n",
        " '0',\n",
        " '0',\n",
        " '6',\n",
        " '1',\n",
        " '2.44',\n",
        " '0.57',\n",
        " '50.30',\n",
        " '1.504',\n",
        " '.603',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'13-'14\",\n",
        " 'MIA',\n",
        " '12',\n",
        " '1',\n",
        " '1',\n",
        " '0',\n",
        " '5',\n",
        " '1',\n",
        " '1.81',\n",
        " '0.45',\n",
        " '47.07',\n",
        " '1.544',\n",
        " '.610',\n",
        " '1966',\n",
        " 'LeBron James',\n",
        " \"'14-'15\",\n",
        " 'CLE',\n",
        " '11',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '2',\n",
        " '0',\n",
        " '1.99',\n",
        " '0.35',\n",
        " '43.01',\n",
        " '1.392',\n",
        " '.533']"
       ]
      }
     ],
     "prompt_number": 64
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### As in my earlier example, I need to group each season's data in its own list.  Found this generator solution on [SO](http://stackoverflow.com/questions/312443/how-do-you-split-a-list-into-evenly-sized-chunks-in-python)."
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# http://stackoverflow.com/questions/312443/how-do-you-split-a-list-into-evenly-sized-chunks-in-python\n",
      "def chunks(l, n):\n",
      "    \"\"\" Yield successive n-sized chunks from l.\n",
      "    \"\"\"\n",
      "    for i in range(0, len(l), n):\n",
      "        yield l[i:i+n]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 66
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "from pprint import pprint\n",
      "\n",
      "for row in chunks(avgs,22):\n",
      "    pprint(row)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'03-'04\",\n",
        " 'CLE',\n",
        " '79',\n",
        " '79',\n",
        " '39.5',\n",
        " '7.9-18.9',\n",
        " '.417',\n",
        " '0.8-2.7',\n",
        " '.290',\n",
        " '4.4-5.8',\n",
        " '.754',\n",
        " '1.3',\n",
        " '4.2',\n",
        " '5.5',\n",
        " '5.9',\n",
        " '0.7',\n",
        " '1.6',\n",
        " '1.9',\n",
        " '3.5',\n",
        " '20.9']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'04-'05\",\n",
        " 'CLE',\n",
        " '80',\n",
        " '80',\n",
        " '42.4',\n",
        " '9.9-21.1',\n",
        " '.472',\n",
        " '1.4-3.9',\n",
        " '.351',\n",
        " '6.0-8.0',\n",
        " '.750',\n",
        " '1.4',\n",
        " '6.0',\n",
        " '7.4',\n",
        " '7.2',\n",
        " '0.7',\n",
        " '2.2',\n",
        " '1.8',\n",
        " '3.3',\n",
        " '27.2']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'05-'06\",\n",
        " 'CLE',\n",
        " '79',\n",
        " '79',\n",
        " '42.5',\n",
        " '11.1-23.1',\n",
        " '.480',\n",
        " '1.6-4.8',\n",
        " '.335',\n",
        " '7.6-10.3',\n",
        " '.738',\n",
        " '1.0',\n",
        " '6.1',\n",
        " '7.0',\n",
        " '6.6',\n",
        " '0.8',\n",
        " '1.6',\n",
        " '2.3',\n",
        " '3.3',\n",
        " '31.4']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'06-'07\",\n",
        " 'CLE',\n",
        " '78',\n",
        " '78',\n",
        " '40.9',\n",
        " '9.9-20.8',\n",
        " '.476',\n",
        " '1.3-4.0',\n",
        " '.319',\n",
        " '6.3-9.0',\n",
        " '.698',\n",
        " '1.1',\n",
        " '5.7',\n",
        " '6.7',\n",
        " '6.0',\n",
        " '0.7',\n",
        " '1.6',\n",
        " '2.2',\n",
        " '3.2',\n",
        " '27.3']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'07-'08\",\n",
        " 'CLE',\n",
        " '75',\n",
        " '74',\n",
        " '40.4',\n",
        " '10.6-21.9',\n",
        " '.484',\n",
        " '1.5-4.8',\n",
        " '.315',\n",
        " '7.3-10.3',\n",
        " '.712',\n",
        " '1.8',\n",
        " '6.1',\n",
        " '7.9',\n",
        " '7.2',\n",
        " '1.1',\n",
        " '1.8',\n",
        " '2.2',\n",
        " '3.4',\n",
        " '30.0']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'08-'09\",\n",
        " 'CLE',\n",
        " '81',\n",
        " '81',\n",
        " '37.7',\n",
        " '9.7-19.9',\n",
        " '.489',\n",
        " '1.6-4.7',\n",
        " '.344',\n",
        " '7.3-9.4',\n",
        " '.780',\n",
        " '1.3',\n",
        " '6.3',\n",
        " '7.6',\n",
        " '7.2',\n",
        " '1.1',\n",
        " '1.7',\n",
        " '1.7',\n",
        " '3.0',\n",
        " '28.4']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'09-'10\",\n",
        " 'CLE',\n",
        " '76',\n",
        " '76',\n",
        " '39.0',\n",
        " '10.1-20.1',\n",
        " '.503',\n",
        " '1.7-5.1',\n",
        " '.333',\n",
        " '7.8-10.2',\n",
        " '.767',\n",
        " '0.9',\n",
        " '6.4',\n",
        " '7.3',\n",
        " '8.6',\n",
        " '1.0',\n",
        " '1.6',\n",
        " '1.6',\n",
        " '3.4',\n",
        " '29.7']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'10-'11\",\n",
        " 'MIA',\n",
        " '79',\n",
        " '79',\n",
        " '38.8',\n",
        " '9.6-18.8',\n",
        " '.510',\n",
        " '1.2-3.5',\n",
        " '.330',\n",
        " '6.4-8.4',\n",
        " '.759',\n",
        " '1.0',\n",
        " '6.5',\n",
        " '7.5',\n",
        " '7.0',\n",
        " '0.6',\n",
        " '1.6',\n",
        " '2.1',\n",
        " '3.6',\n",
        " '26.7']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'11-'12\",\n",
        " 'MIA',\n",
        " '62',\n",
        " '62',\n",
        " '37.5',\n",
        " '10.0-18.9',\n",
        " '.531',\n",
        " '0.9-2.4',\n",
        " '.362',\n",
        " '6.2-8.1',\n",
        " '.771',\n",
        " '1.5',\n",
        " '6.4',\n",
        " '7.9',\n",
        " '6.2',\n",
        " '0.8',\n",
        " '1.9',\n",
        " '1.5',\n",
        " '3.4',\n",
        " '27.1']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'12-'13\",\n",
        " 'MIA',\n",
        " '76',\n",
        " '76',\n",
        " '37.9',\n",
        " '10.1-17.8',\n",
        " '.565',\n",
        " '1.4-3.3',\n",
        " '.406',\n",
        " '5.3-7.0',\n",
        " '.753',\n",
        " '1.3',\n",
        " '6.8',\n",
        " '8.0',\n",
        " '7.3',\n",
        " '0.9',\n",
        " '1.7',\n",
        " '1.4',\n",
        " '3.0',\n",
        " '26.8']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'13-'14\",\n",
        " 'MIA',\n",
        " '77',\n",
        " '77',\n",
        " '37.7',\n",
        " '10.0-17.6',\n",
        " '.567',\n",
        " '1.5-4.0',\n",
        " '.379',\n",
        " '5.7-7.6',\n",
        " '.750',\n",
        " '1.1',\n",
        " '5.9',\n",
        " '6.9',\n",
        " '6.4',\n",
        " '0.3',\n",
        " '1.6',\n",
        " '1.6',\n",
        " '3.5',\n",
        " '27.1']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'14-'15\",\n",
        " 'CLE',\n",
        " '29',\n",
        " '29',\n",
        " '37.5',\n",
        " '8.8-18.1',\n",
        " '.488',\n",
        " '1.7-4.5',\n",
        " '.369',\n",
        " '5.9-7.9',\n",
        " '.743',\n",
        " '0.7',\n",
        " '4.6',\n",
        " '5.3',\n",
        " '7.6',\n",
        " '0.8',\n",
        " '1.3',\n",
        " '1.7',\n",
        " '3.8',\n",
        " '25.2']\n"
       ]
      }
     ],
     "prompt_number": 67
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "for row in chunks(totals,19):\n",
      "    pprint(row)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'03-'04\",\n",
        " 'CLE',\n",
        " '622-1492',\n",
        " '.417',\n",
        " '63-217',\n",
        " '.290',\n",
        " '347-460',\n",
        " '.754',\n",
        " '99',\n",
        " '333',\n",
        " '432',\n",
        " '465',\n",
        " '58',\n",
        " '130',\n",
        " '149',\n",
        " '273',\n",
        " '1654']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'04-'05\",\n",
        " 'CLE',\n",
        " '795-1684',\n",
        " '.472',\n",
        " '108-308',\n",
        " '.351',\n",
        " '477-636',\n",
        " '.750',\n",
        " '111',\n",
        " '477',\n",
        " '588',\n",
        " '577',\n",
        " '52',\n",
        " '177',\n",
        " '146',\n",
        " '262',\n",
        " '2175']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'05-'06\",\n",
        " 'CLE',\n",
        " '875-1823',\n",
        " '.480',\n",
        " '127-379',\n",
        " '.335',\n",
        " '601-814',\n",
        " '.738',\n",
        " '75',\n",
        " '481',\n",
        " '556',\n",
        " '521',\n",
        " '66',\n",
        " '123',\n",
        " '181',\n",
        " '260',\n",
        " '2478']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'06-'07\",\n",
        " 'CLE',\n",
        " '772-1621',\n",
        " '.476',\n",
        " '99-310',\n",
        " '.319',\n",
        " '489-701',\n",
        " '.698',\n",
        " '83',\n",
        " '443',\n",
        " '526',\n",
        " '470',\n",
        " '55',\n",
        " '125',\n",
        " '171',\n",
        " '250',\n",
        " '2132']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'07-'08\",\n",
        " 'CLE',\n",
        " '794-1642',\n",
        " '.484',\n",
        " '113-359',\n",
        " '.315',\n",
        " '549-771',\n",
        " '.712',\n",
        " '133',\n",
        " '459',\n",
        " '592',\n",
        " '539',\n",
        " '81',\n",
        " '138',\n",
        " '165',\n",
        " '255',\n",
        " '2250']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'08-'09\",\n",
        " 'CLE',\n",
        " '789-1613',\n",
        " '.489',\n",
        " '132-384',\n",
        " '.344',\n",
        " '594-762',\n",
        " '.780',\n",
        " '106',\n",
        " '507',\n",
        " '613',\n",
        " '587',\n",
        " '93',\n",
        " '137',\n",
        " '139',\n",
        " '241',\n",
        " '2304']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'09-'10\",\n",
        " 'CLE',\n",
        " '768-1528',\n",
        " '.503',\n",
        " '129-387',\n",
        " '.333',\n",
        " '593-773',\n",
        " '.767',\n",
        " '71',\n",
        " '483',\n",
        " '554',\n",
        " '651',\n",
        " '77',\n",
        " '125',\n",
        " '119',\n",
        " '261',\n",
        " '2258']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'10-'11\",\n",
        " 'MIA',\n",
        " '758-1485',\n",
        " '.510',\n",
        " '92-279',\n",
        " '.330',\n",
        " '503-663',\n",
        " '.759',\n",
        " '80',\n",
        " '510',\n",
        " '590',\n",
        " '554',\n",
        " '50',\n",
        " '124',\n",
        " '163',\n",
        " '284',\n",
        " '2111']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'11-'12\",\n",
        " 'MIA',\n",
        " '621-1169',\n",
        " '.531',\n",
        " '54-149',\n",
        " '.362',\n",
        " '387-502',\n",
        " '.771',\n",
        " '94',\n",
        " '398',\n",
        " '492',\n",
        " '387',\n",
        " '50',\n",
        " '115',\n",
        " '96',\n",
        " '213',\n",
        " '1683']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'12-'13\",\n",
        " 'MIA',\n",
        " '765-1354',\n",
        " '.565',\n",
        " '103-254',\n",
        " '.406',\n",
        " '403-535',\n",
        " '.753',\n",
        " '97',\n",
        " '513',\n",
        " '610',\n",
        " '551',\n",
        " '67',\n",
        " '129',\n",
        " '110',\n",
        " '226',\n",
        " '2036']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'13-'14\",\n",
        " 'MIA',\n",
        " '767-1353',\n",
        " '.567',\n",
        " '116-306',\n",
        " '.379',\n",
        " '439-585',\n",
        " '.750',\n",
        " '81',\n",
        " '452',\n",
        " '533',\n",
        " '489',\n",
        " '26',\n",
        " '121',\n",
        " '126',\n",
        " '270',\n",
        " '2089']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'14-'15\",\n",
        " 'CLE',\n",
        " '256-525',\n",
        " '.488',\n",
        " '48-130',\n",
        " '.369',\n",
        " '171-230',\n",
        " '.743',\n",
        " '19',\n",
        " '134',\n",
        " '153',\n",
        " '221',\n",
        " '23',\n",
        " '39',\n",
        " '50',\n",
        " '111',\n",
        " '731']\n"
       ]
      }
     ],
     "prompt_number": 68
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "for row in chunks(misc_totals,15):\n",
      "    pprint(row)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'03-'04\",\n",
        " 'CLE',\n",
        " '12',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '2',\n",
        " '0',\n",
        " '1.70',\n",
        " '0.48',\n",
        " '34.32',\n",
        " '1.109',\n",
        " '.438']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'04-'05\",\n",
        " 'CLE',\n",
        " '25',\n",
        " '4',\n",
        " '1',\n",
        " '0',\n",
        " '4',\n",
        " '0',\n",
        " '2.20',\n",
        " '0.68',\n",
        " '47.09',\n",
        " '1.292',\n",
        " '.504']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'05-'06\",\n",
        " 'CLE',\n",
        " '21',\n",
        " '5',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '2.00',\n",
        " '0.47',\n",
        " '50.09',\n",
        " '1.359',\n",
        " '.515']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'06-'07\",\n",
        " 'CLE',\n",
        " '16',\n",
        " '1',\n",
        " '1',\n",
        " '0',\n",
        " '2',\n",
        " '2',\n",
        " '1.88',\n",
        " '0.50',\n",
        " '44.08',\n",
        " '1.315',\n",
        " '.507']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'07-'08\",\n",
        " 'CLE',\n",
        " '31',\n",
        " '7',\n",
        " '1',\n",
        " '0',\n",
        " '2',\n",
        " '0',\n",
        " '2.11',\n",
        " '0.54',\n",
        " '50.68',\n",
        " '1.370',\n",
        " '.518']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'08-'09\",\n",
        " 'CLE',\n",
        " '29',\n",
        " '7',\n",
        " '0',\n",
        " '0',\n",
        " '10',\n",
        " '0',\n",
        " '2.44',\n",
        " '0.57',\n",
        " '49.97',\n",
        " '1.428',\n",
        " '.530']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'09-'10\",\n",
        " 'CLE',\n",
        " '31',\n",
        " '4',\n",
        " '0',\n",
        " '0',\n",
        " '4',\n",
        " '0',\n",
        " '2.49',\n",
        " '0.48',\n",
        " '52.66',\n",
        " '1.478',\n",
        " '.545']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'10-'11\",\n",
        " 'MIA',\n",
        " '31',\n",
        " '4',\n",
        " '0',\n",
        " '0',\n",
        " '7',\n",
        " '0',\n",
        " '1.95',\n",
        " '0.44',\n",
        " '46.73',\n",
        " '1.422',\n",
        " '.541']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'11-'12\",\n",
        " 'MIA',\n",
        " '23',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '3',\n",
        " '0',\n",
        " '1.82',\n",
        " '0.54',\n",
        " '47.86',\n",
        " '1.440',\n",
        " '.554']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'12-'13\",\n",
        " 'MIA',\n",
        " '36',\n",
        " '4',\n",
        " '0',\n",
        " '0',\n",
        " '6',\n",
        " '1',\n",
        " '2.44',\n",
        " '0.57',\n",
        " '50.30',\n",
        " '1.504',\n",
        " '.603']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'13-'14\",\n",
        " 'MIA',\n",
        " '12',\n",
        " '1',\n",
        " '1',\n",
        " '0',\n",
        " '5',\n",
        " '1',\n",
        " '1.81',\n",
        " '0.45',\n",
        " '47.07',\n",
        " '1.544',\n",
        " '.610']\n",
        "['1966',\n",
        " 'LeBron James',\n",
        " \"'14-'15\",\n",
        " 'CLE',\n",
        " '11',\n",
        " '0',\n",
        " '0',\n",
        " '0',\n",
        " '2',\n",
        " '0',\n",
        " '1.99',\n",
        " '0.35',\n",
        " '43.01',\n",
        " '1.392',\n",
        " '.533']\n"
       ]
      }
     ],
     "prompt_number": 69
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Below are sqlite-related code to insert the data into our sqlite database"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import sqlite3\n",
      "\n",
      "conn = sqlite3.connect('/home/pybokeh/databases/nba')\n",
      "c = conn.cursor()\n",
      "\n",
      "for data in chunks(avgs,22):\n",
      "    try:\n",
      "        c.execute('INSERT INTO regular_season_avgs VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', data)\n",
      "    except:\n",
      "        pass\n",
      "    conn.commit()\n",
      "conn.close()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 70
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import sqlite3\n",
      "\n",
      "conn = sqlite3.connect('/home/pybokeh/databases/nba')\n",
      "c = conn.cursor()\n",
      "\n",
      "for data in chunks(totals,19):\n",
      "    try:\n",
      "        c.execute('INSERT INTO regular_season_totals VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', data)\n",
      "    except:\n",
      "        pass\n",
      "    conn.commit()\n",
      "conn.close()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 71
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import sqlite3\n",
      "\n",
      "conn = sqlite3.connect('/home/pybokeh/databases/nba')\n",
      "c = conn.cursor()\n",
      "\n",
      "for data in chunks(misc_totals,15):\n",
      "    try:\n",
      "        c.execute('INSERT INTO regular_season_misc_totals VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', data)\n",
      "    except:\n",
      "        pass\n",
      "    conn.commit()\n",
      "conn.close()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 72
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### This concludes the step-by-step explanations."
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "## Below is all the code above combined into 3 cells: one for each of the 3 tables we are populating into our sqlite database.  The difference in the all-in-one versions below compared to the step-by-step version above is I am using 2 for loops: one to loop through all the NBA teams' URLs and the other to loop, to loop through each of the player's URL."
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "<a id=\"season_avgs\"></a>"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "## Populating the regular season averages table:"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "[[back to top]](#top)"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import urllib.request as request\n",
      "from bs4 import BeautifulSoup\n",
      "import sqlite3\n",
      "import re\n",
      "from datetime import datetime\n",
      "\n",
      "startTime = datetime.now()\n",
      "\n",
      "# http://stackoverflow.com/questions/312443/how-do-you-split-a-list-into-evenly-sized-chunks-in-python\n",
      "def chunks(l, n):\n",
      "    \"\"\" Yield successive n-sized chunks from l.\n",
      "    \"\"\"\n",
      "    for i in range(0, len(l), n):\n",
      "        yield l[i:i+n]\n",
      "\n",
      "base_url = 'http://espn.go.com'\n",
      "\n",
      "teams_url = 'http://espn.go.com/nba/teams'\n",
      "html_teams = request.urlopen(teams_url)\n",
      "\n",
      "soup_teams = BeautifulSoup(html_teams)\n",
      "urls = soup_teams.find_all(href=re.compile('/nba/teams/stats'))\n",
      "\n",
      "team_urls = [base_url+url['href'] for url in urls]\n",
      "\n",
      "for team in team_urls:\n",
      "    html_team = request.urlopen(team)\n",
      "    soup_team = BeautifulSoup(html_team)\n",
      "    html_rows = soup_team.find_all('tr', class_=re.compile('player'))\n",
      "    \n",
      "    player_urls = [row.a['href'].replace('_','stats/_') for row in html_rows]\n",
      "    \n",
      "    for player in player_urls:\n",
      "        player_id   = player.split('/')[8]\n",
      "        html_player = request.urlopen(player)\n",
      "        soup_player = BeautifulSoup(html_player)\n",
      "        \n",
      "        soup_name = soup_player.find('meta', property='og:title')\n",
      "        player_name = soup_name['content']\n",
      "        \n",
      "        regular_season_stats = soup_player.find_all('tr', class_=re.compile('row'))\n",
      "        \n",
      "        size = int(len(regular_season_stats)/3)\n",
      "        \n",
      "        season_avgs_slice        = slice(0,size)\n",
      "        #season_totals_slice      = slice(size,size*2)\n",
      "        #season_misc_totals_slice = slice(size*2,size*3)\n",
      "        \n",
      "        regular_season_avgs = regular_season_stats[season_avgs_slice]\n",
      "        #regular_season_totals = regular_season_stats[season_totals_slice]\n",
      "        #regular_season_misc_totals = regular_season_stats[season_misc_totals_slice]\n",
      "        \n",
      "        avgs = []\n",
      "        for row in regular_season_avgs:\n",
      "            for data in row:\n",
      "                avgs.append(data.get_text())\n",
      "                \n",
      "        index = 0 # insert the player ID before the player's season\n",
      "        increment = 0\n",
      "        for row in range(len(regular_season_avgs)):\n",
      "            avgs.insert(index + increment, player_id)\n",
      "            index = index + 20  # There are 20 columns in the season avgs section\n",
      "            increment = increment + 1\n",
      "            \n",
      "        index = 1 # insert the player's name after the player's ID\n",
      "        increment = 0\n",
      "        for row in range(len(regular_season_avgs)):\n",
      "            avgs.insert(index + increment, player_name)\n",
      "            index = index + 21  # There are 21 columns in the season avgs section since I've just added player ID\n",
      "            increment = increment + 1\n",
      "\n",
      "        conn = sqlite3.connect('/home/pybokeh/databases/nba')\n",
      "        c = conn.cursor()\n",
      "\n",
      "        for data in chunks(avgs,22):\n",
      "            try:\n",
      "                c.execute('INSERT INTO regular_season_avgs VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', data)\n",
      "            except:\n",
      "                pass\n",
      "            conn.commit()\n",
      "        conn.close()\n",
      "        \n",
      "print(datetime.now() - startTime)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "0:15:28.872399\n"
       ]
      }
     ],
     "prompt_number": 27
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "<a id=\"season_totals\"></a>"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "## Populating the regular season totals table:"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "[[back to top]](#top)"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import urllib.request as request\n",
      "from bs4 import BeautifulSoup\n",
      "import sqlite3\n",
      "import re\n",
      "from datetime import datetime\n",
      "\n",
      "startTime = datetime.now()\n",
      "\n",
      "# http://stackoverflow.com/questions/312443/how-do-you-split-a-list-into-evenly-sized-chunks-in-python\n",
      "def chunks(l, n):\n",
      "    \"\"\" Yield successive n-sized chunks from l.\n",
      "    \"\"\"\n",
      "    for i in range(0, len(l), n):\n",
      "        yield l[i:i+n]\n",
      "\n",
      "base_url = 'http://espn.go.com'\n",
      "\n",
      "teams_url = 'http://espn.go.com/nba/teams'\n",
      "html_teams = request.urlopen(teams_url)\n",
      "\n",
      "soup_teams = BeautifulSoup(html_teams)\n",
      "urls = soup_teams.find_all(href=re.compile('/nba/teams/stats'))\n",
      "\n",
      "team_urls = [base_url+url['href'] for url in urls]\n",
      "\n",
      "for team in team_urls:\n",
      "    html_team = request.urlopen(team)\n",
      "    soup_team = BeautifulSoup(html_team)\n",
      "    html_rows = soup_team.find_all('tr', class_=re.compile('player'))\n",
      "    \n",
      "    player_urls = [row.a['href'].replace('_','stats/_') for row in html_rows]\n",
      "    \n",
      "    for player in player_urls:\n",
      "        player_id   = player.split('/')[8]\n",
      "        html_player = request.urlopen(player)\n",
      "        soup_player = BeautifulSoup(html_player)\n",
      "        \n",
      "        soup_name = soup_player.find('meta', property='og:title')\n",
      "        player_name = soup_name['content']\n",
      "        \n",
      "        regular_season_stats = soup_player.find_all('tr', class_=re.compile('row'))\n",
      "        \n",
      "        size = int(len(regular_season_stats)/3)\n",
      "        \n",
      "        #season_avgs_slice        = slice(0,size)\n",
      "        season_totals_slice      = slice(size,size*2)\n",
      "        #season_misc_totals_slice = slice(size*2,size*3)\n",
      "        \n",
      "        #regular_season_avgs = regular_season_stats[season_avgs_slice]\n",
      "        regular_season_totals = regular_season_stats[season_totals_slice]\n",
      "        #regular_season_misc_totals = regular_season_stats[season_misc_totals_slice]\n",
      "        \n",
      "        totals = []\n",
      "        for row in regular_season_totals:\n",
      "            for data in row:\n",
      "                totals.append(data.get_text())\n",
      "                \n",
      "        index = 0 # insert the player ID before the player's season\n",
      "        increment = 0\n",
      "        for row in range(len(regular_season_totals)):\n",
      "            totals.insert(index + increment, player_id)\n",
      "            index = index + 17  # There are 17 columns in the season totals section\n",
      "            increment = increment + 1\n",
      "            \n",
      "        index = 1 # insert the player's name after the player's ID\n",
      "        increment = 0\n",
      "        for row in range(len(regular_season_totals)):\n",
      "            totals.insert(index + increment, player_name)\n",
      "            index = index + 18 # There are now 18 columns in the reg season totals after inserting player's ID\n",
      "            increment = increment + 1\n",
      "\n",
      "        conn = sqlite3.connect('/home/pybokeh/databases/nba')\n",
      "        c = conn.cursor()\n",
      "\n",
      "        for data in chunks(totals,19):\n",
      "            try:\n",
      "                c.execute('INSERT INTO regular_season_totals VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', data)\n",
      "            except:\n",
      "                pass\n",
      "            conn.commit()\n",
      "        conn.close()\n",
      "        \n",
      "print(datetime.now() - startTime)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": []
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "<a id=\"season_misc\"></a>"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "## Populating regular season misc totals table:"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "[[back to top]](#top)"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import urllib.request as request\n",
      "from bs4 import BeautifulSoup\n",
      "import sqlite3\n",
      "import re\n",
      "from datetime import datetime\n",
      "\n",
      "startTime = datetime.now()\n",
      "\n",
      "# http://stackoverflow.com/questions/312443/how-do-you-split-a-list-into-evenly-sized-chunks-in-python\n",
      "def chunks(l, n):\n",
      "    \"\"\" Yield successive n-sized chunks from l.\n",
      "    \"\"\"\n",
      "    for i in range(0, len(l), n):\n",
      "        yield l[i:i+n]\n",
      "\n",
      "base_url = 'http://espn.go.com'\n",
      "\n",
      "teams_url = 'http://espn.go.com/nba/teams'\n",
      "html_teams = request.urlopen(teams_url)\n",
      "\n",
      "soup_teams = BeautifulSoup(html_teams)\n",
      "urls = soup_teams.find_all(href=re.compile('/nba/teams/stats'))\n",
      "\n",
      "team_urls = [base_url+url['href'] for url in urls]\n",
      "\n",
      "for team in team_urls:\n",
      "    html_team = request.urlopen(team)\n",
      "    soup_team = BeautifulSoup(html_team)\n",
      "    html_rows = soup_team.find_all('tr', class_=re.compile('player'))\n",
      "    \n",
      "    player_urls = [row.a['href'].replace('_','stats/_') for row in html_rows]\n",
      "    \n",
      "    for player in player_urls:\n",
      "        player_id   = player.split('/')[8]\n",
      "        html_player = request.urlopen(player)\n",
      "        soup_player = BeautifulSoup(html_player)\n",
      "        \n",
      "        soup_name = soup_player.find('meta', property='og:title')\n",
      "        player_name = soup_name['content']\n",
      "        \n",
      "        regular_season_stats = soup_player.find_all('tr', class_=re.compile('row'))\n",
      "        \n",
      "        size = int(len(regular_season_stats)/3)\n",
      "        \n",
      "        #season_avgs_slice        = slice(0,size)\n",
      "        #season_totals_slice      = slice(size,size*2)\n",
      "        season_misc_totals_slice = slice(size*2,size*3)\n",
      "        \n",
      "        #regular_season_avgs = regular_season_stats[season_avgs_slice]\n",
      "        #regular_season_totals = regular_season_stats[season_totals_slice]\n",
      "        regular_season_misc_totals = regular_season_stats[season_misc_totals_slice]\n",
      "        \n",
      "        misc_totals = []\n",
      "        for row in regular_season_misc_totals:\n",
      "            for data in row:\n",
      "                misc_totals.append(data.get_text())\n",
      "                \n",
      "        index = 0 # insert the player ID before the player's season\n",
      "        increment = 0\n",
      "        for row in range(len(regular_season_misc_totals)):\n",
      "            misc_totals.insert(index + increment, player_id)\n",
      "            index = index + 13  # There are 13 columns in the season misc totals section\n",
      "            increment = increment + 1\n",
      "            \n",
      "        index = 1 # insert the player's name after the player's ID\n",
      "        increment = 0\n",
      "        for row in range(len(regular_season_misc_totals)):\n",
      "            misc_totals.insert(index + increment, player_name)\n",
      "            index = index + 14 # There are now 14 columns in the reg season misc totals after inserting player ID\n",
      "            increment = increment + 1\n",
      "\n",
      "        conn = sqlite3.connect('/home/pybokeh/databases/nba')\n",
      "        c = conn.cursor()\n",
      "\n",
      "        for data in chunks(misc_totals,15):\n",
      "            try:\n",
      "                c.execute('INSERT INTO regular_season_misc_totals VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)', data)\n",
      "            except:\n",
      "                pass\n",
      "            conn.commit()\n",
      "        conn.close()\n",
      "        \n",
      "print(datetime.now() - startTime)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": []
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "<a id=\"db_py\"></a>"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "## Now let's take a look at our sqlite database using Yhat's [db.py](http://blog.yhathq.com/posts/introducing-db-py.html)"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "[[back to top]](#top)"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "from db import DB\n",
      "import pandas as pd\n",
      "\n",
      "db = DB(filename=\"/home/pybokeh/databases/nba\", dbtype=\"sqlite\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stderr",
       "text": [
        "Indexing schema. This will take a second...finished!\n",
        "Refreshing schema. Please wait...done!\n"
       ]
      }
     ],
     "prompt_number": 55
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.tables"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<table>\n",
        "    <tr>\n",
        "        <th>Table</th>\n",
        "        <th>Columns</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>player_game_stats</td>\n",
        "        <td>id, name_pos, team_name, GP, GS, MIN, PPG, OFFR, DEFR, RPG, APG, SPG, BPG, TPG, <br>FPG, A2TO, PER</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>player_shooting_stats</td>\n",
        "        <td>id, name_pos, team_name, FGM, FGA, FG_Perc, 3PM, 3PA, 3P_Perc, FTM, FTA, FT_Perc<br>, 2PM, 2PA, 2P_Perc, PPS, AFG_Perc</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>regular_season_avgs</td>\n",
        "        <td>id, player_name, season, team, GP, GS, MIN, FGM-A, FG_Perc, 3PM-A, 3P_Perc, FTM-<br>A, FT_Perc, OR, DR, REB, AST, BLK, STL, PF, TO, PTS</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>regular_season_misc_totals</td>\n",
        "        <td>id, player_name, season, team, DBLDBL, TRIDBL, DQ, EJECT, TECH, FLAG, AST2TO, ST<br>L2TO, RAT, SCEFF, SHEFF</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>regular_season_totals</td>\n",
        "        <td>id, player_name, season, team, FGM-A, FG_Perc, 3PM-A, 3P_Perc, FTM-A, FT_Perc, O<br>R, DR, REB, AST, BLK, STL, PF, TO, PTS</td>\n",
        "    </tr>\n",
        "</table>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 56,
       "text": [
        "+----------------------------+----------------------------------------------------------------------------------+\n",
        "| Table                      | Columns                                                                          |\n",
        "+----------------------------+----------------------------------------------------------------------------------+\n",
        "| player_game_stats          | id, name_pos, team_name, GP, GS, MIN, PPG, OFFR, DEFR, RPG, APG, SPG, BPG, TPG,  |\n",
        "|                            | FPG, A2TO, PER                                                                   |\n",
        "| player_shooting_stats      | id, name_pos, team_name, FGM, FGA, FG_Perc, 3PM, 3PA, 3P_Perc, FTM, FTA, FT_Perc |\n",
        "|                            | , 2PM, 2PA, 2P_Perc, PPS, AFG_Perc                                               |\n",
        "| regular_season_avgs        | id, player_name, season, team, GP, GS, MIN, FGM-A, FG_Perc, 3PM-A, 3P_Perc, FTM- |\n",
        "|                            | A, FT_Perc, OR, DR, REB, AST, BLK, STL, PF, TO, PTS                              |\n",
        "| regular_season_misc_totals | id, player_name, season, team, DBLDBL, TRIDBL, DQ, EJECT, TECH, FLAG, AST2TO, ST |\n",
        "|                            | L2TO, RAT, SCEFF, SHEFF                                                          |\n",
        "| regular_season_totals      | id, player_name, season, team, FGM-A, FG_Perc, 3PM-A, 3P_Perc, FTM-A, FT_Perc, O |\n",
        "|                            | R, DR, REB, AST, BLK, STL, PF, TO, PTS                                           |\n",
        "+----------------------------+----------------------------------------------------------------------------------+"
       ]
      }
     ],
     "prompt_number": 56
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### let's configure IPython notebook display options so that we can make sure we can view our results."
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "pd.set_option(\"display.max_columns\",50)\n",
      "pd.set_option(\"display.max_rows\",999)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 57
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### I'll be querying or filtering based on player's name.  But what if I don't know what the player name columns are spelled as?"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "db.py has a useful find_column() method, although I hope in future versions, we can chain find_column() and find_table() together."
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.find_column(\"*name*\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<table>\n",
        "    <tr>\n",
        "        <th>Table</th>\n",
        "        <th>Column Name</th>\n",
        "        <th>Type</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>player_game_stats</td>\n",
        "        <td>name_pos</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>player_game_stats</td>\n",
        "        <td>team_name</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>player_shooting_stats</td>\n",
        "        <td>name_pos</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>player_shooting_stats</td>\n",
        "        <td>team_name</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>regular_season_avgs</td>\n",
        "        <td>player_name</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>regular_season_misc_totals</td>\n",
        "        <td>player_name</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "        <td>regular_season_totals</td>\n",
        "        <td>player_name</td>\n",
        "        <td>TEXT</td>\n",
        "    </tr>\n",
        "</table>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 77,
       "text": [
        "+----------------------------+-------------+------+\n",
        "| Table                      | Column Name | Type |\n",
        "+----------------------------+-------------+------+\n",
        "| player_game_stats          |   name_pos  | TEXT |\n",
        "| player_game_stats          |  team_name  | TEXT |\n",
        "| player_shooting_stats      |   name_pos  | TEXT |\n",
        "| player_shooting_stats      |  team_name  | TEXT |\n",
        "| regular_season_avgs        | player_name | TEXT |\n",
        "| regular_season_misc_totals | player_name | TEXT |\n",
        "| regular_season_totals      | player_name | TEXT |\n",
        "+----------------------------+-------------+------+"
       ]
      }
     ],
     "prompt_number": 77
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Below is the SQL needed to get LeBron's regular season averages stats:"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "sql = \"\"\"\n",
      "select *\n",
      "\n",
      "from regular_season_avgs\n",
      "\n",
      "where\n",
      "player_name like '%LeBron%'\n",
      "\"\"\""
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 74
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### So below are LeBron's regular season averages stats:"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.query(sql)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>id</th>\n",
        "      <th>player_name</th>\n",
        "      <th>season</th>\n",
        "      <th>team</th>\n",
        "      <th>GP</th>\n",
        "      <th>GS</th>\n",
        "      <th>MIN</th>\n",
        "      <th>FGM-A</th>\n",
        "      <th>FG_Perc</th>\n",
        "      <th>3PM-A</th>\n",
        "      <th>3P_Perc</th>\n",
        "      <th>FTM-A</th>\n",
        "      <th>FT_Perc</th>\n",
        "      <th>OR</th>\n",
        "      <th>DR</th>\n",
        "      <th>REB</th>\n",
        "      <th>AST</th>\n",
        "      <th>BLK</th>\n",
        "      <th>STL</th>\n",
        "      <th>PF</th>\n",
        "      <th>TO</th>\n",
        "      <th>PTS</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '03-'04</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 79</td>\n",
        "      <td> 79</td>\n",
        "      <td> 39.5</td>\n",
        "      <td>  7.9-18.9</td>\n",
        "      <td> 0.417</td>\n",
        "      <td> 0.8-2.7</td>\n",
        "      <td> 0.290</td>\n",
        "      <td>  4.4-5.8</td>\n",
        "      <td> 0.754</td>\n",
        "      <td> 1.3</td>\n",
        "      <td> 4.2</td>\n",
        "      <td> 5.5</td>\n",
        "      <td> 5.9</td>\n",
        "      <td> 0.7</td>\n",
        "      <td> 1.6</td>\n",
        "      <td> 1.9</td>\n",
        "      <td> 3.5</td>\n",
        "      <td> 20.9</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '04-'05</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 80</td>\n",
        "      <td> 80</td>\n",
        "      <td> 42.4</td>\n",
        "      <td>  9.9-21.1</td>\n",
        "      <td> 0.472</td>\n",
        "      <td> 1.4-3.9</td>\n",
        "      <td> 0.351</td>\n",
        "      <td>  6.0-8.0</td>\n",
        "      <td> 0.750</td>\n",
        "      <td> 1.4</td>\n",
        "      <td> 6.0</td>\n",
        "      <td> 7.4</td>\n",
        "      <td> 7.2</td>\n",
        "      <td> 0.7</td>\n",
        "      <td> 2.2</td>\n",
        "      <td> 1.8</td>\n",
        "      <td> 3.3</td>\n",
        "      <td> 27.2</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '05-'06</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 79</td>\n",
        "      <td> 79</td>\n",
        "      <td> 42.5</td>\n",
        "      <td> 11.1-23.1</td>\n",
        "      <td> 0.480</td>\n",
        "      <td> 1.6-4.8</td>\n",
        "      <td> 0.335</td>\n",
        "      <td> 7.6-10.3</td>\n",
        "      <td> 0.738</td>\n",
        "      <td> 1.0</td>\n",
        "      <td> 6.1</td>\n",
        "      <td> 7.0</td>\n",
        "      <td> 6.6</td>\n",
        "      <td> 0.8</td>\n",
        "      <td> 1.6</td>\n",
        "      <td> 2.3</td>\n",
        "      <td> 3.3</td>\n",
        "      <td> 31.4</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '06-'07</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 78</td>\n",
        "      <td> 78</td>\n",
        "      <td> 40.9</td>\n",
        "      <td>  9.9-20.8</td>\n",
        "      <td> 0.476</td>\n",
        "      <td> 1.3-4.0</td>\n",
        "      <td> 0.319</td>\n",
        "      <td>  6.3-9.0</td>\n",
        "      <td> 0.698</td>\n",
        "      <td> 1.1</td>\n",
        "      <td> 5.7</td>\n",
        "      <td> 6.7</td>\n",
        "      <td> 6.0</td>\n",
        "      <td> 0.7</td>\n",
        "      <td> 1.6</td>\n",
        "      <td> 2.2</td>\n",
        "      <td> 3.2</td>\n",
        "      <td> 27.3</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '07-'08</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 75</td>\n",
        "      <td> 74</td>\n",
        "      <td> 40.4</td>\n",
        "      <td> 10.6-21.9</td>\n",
        "      <td> 0.484</td>\n",
        "      <td> 1.5-4.8</td>\n",
        "      <td> 0.315</td>\n",
        "      <td> 7.3-10.3</td>\n",
        "      <td> 0.712</td>\n",
        "      <td> 1.8</td>\n",
        "      <td> 6.1</td>\n",
        "      <td> 7.9</td>\n",
        "      <td> 7.2</td>\n",
        "      <td> 1.1</td>\n",
        "      <td> 1.8</td>\n",
        "      <td> 2.2</td>\n",
        "      <td> 3.4</td>\n",
        "      <td> 30.0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '08-'09</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 81</td>\n",
        "      <td> 81</td>\n",
        "      <td> 37.7</td>\n",
        "      <td>  9.7-19.9</td>\n",
        "      <td> 0.489</td>\n",
        "      <td> 1.6-4.7</td>\n",
        "      <td> 0.344</td>\n",
        "      <td>  7.3-9.4</td>\n",
        "      <td> 0.780</td>\n",
        "      <td> 1.3</td>\n",
        "      <td> 6.3</td>\n",
        "      <td> 7.6</td>\n",
        "      <td> 7.2</td>\n",
        "      <td> 1.1</td>\n",
        "      <td> 1.7</td>\n",
        "      <td> 1.7</td>\n",
        "      <td> 3.0</td>\n",
        "      <td> 28.4</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '09-'10</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 76</td>\n",
        "      <td> 76</td>\n",
        "      <td> 39.0</td>\n",
        "      <td> 10.1-20.1</td>\n",
        "      <td> 0.503</td>\n",
        "      <td> 1.7-5.1</td>\n",
        "      <td> 0.333</td>\n",
        "      <td> 7.8-10.2</td>\n",
        "      <td> 0.767</td>\n",
        "      <td> 0.9</td>\n",
        "      <td> 6.4</td>\n",
        "      <td> 7.3</td>\n",
        "      <td> 8.6</td>\n",
        "      <td> 1.0</td>\n",
        "      <td> 1.6</td>\n",
        "      <td> 1.6</td>\n",
        "      <td> 3.4</td>\n",
        "      <td> 29.7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '10-'11</td>\n",
        "      <td> MIA</td>\n",
        "      <td> 79</td>\n",
        "      <td> 79</td>\n",
        "      <td> 38.8</td>\n",
        "      <td>  9.6-18.8</td>\n",
        "      <td> 0.510</td>\n",
        "      <td> 1.2-3.5</td>\n",
        "      <td> 0.330</td>\n",
        "      <td>  6.4-8.4</td>\n",
        "      <td> 0.759</td>\n",
        "      <td> 1.0</td>\n",
        "      <td> 6.5</td>\n",
        "      <td> 7.5</td>\n",
        "      <td> 7.0</td>\n",
        "      <td> 0.6</td>\n",
        "      <td> 1.6</td>\n",
        "      <td> 2.1</td>\n",
        "      <td> 3.6</td>\n",
        "      <td> 26.7</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '11-'12</td>\n",
        "      <td> MIA</td>\n",
        "      <td> 62</td>\n",
        "      <td> 62</td>\n",
        "      <td> 37.5</td>\n",
        "      <td> 10.0-18.9</td>\n",
        "      <td> 0.531</td>\n",
        "      <td> 0.9-2.4</td>\n",
        "      <td> 0.362</td>\n",
        "      <td>  6.2-8.1</td>\n",
        "      <td> 0.771</td>\n",
        "      <td> 1.5</td>\n",
        "      <td> 6.4</td>\n",
        "      <td> 7.9</td>\n",
        "      <td> 6.2</td>\n",
        "      <td> 0.8</td>\n",
        "      <td> 1.9</td>\n",
        "      <td> 1.5</td>\n",
        "      <td> 3.4</td>\n",
        "      <td> 27.1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '12-'13</td>\n",
        "      <td> MIA</td>\n",
        "      <td> 76</td>\n",
        "      <td> 76</td>\n",
        "      <td> 37.9</td>\n",
        "      <td> 10.1-17.8</td>\n",
        "      <td> 0.565</td>\n",
        "      <td> 1.4-3.3</td>\n",
        "      <td> 0.406</td>\n",
        "      <td>  5.3-7.0</td>\n",
        "      <td> 0.753</td>\n",
        "      <td> 1.3</td>\n",
        "      <td> 6.8</td>\n",
        "      <td> 8.0</td>\n",
        "      <td> 7.3</td>\n",
        "      <td> 0.9</td>\n",
        "      <td> 1.7</td>\n",
        "      <td> 1.4</td>\n",
        "      <td> 3.0</td>\n",
        "      <td> 26.8</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10</th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '13-'14</td>\n",
        "      <td> MIA</td>\n",
        "      <td> 77</td>\n",
        "      <td> 77</td>\n",
        "      <td> 37.7</td>\n",
        "      <td> 10.0-17.6</td>\n",
        "      <td> 0.567</td>\n",
        "      <td> 1.5-4.0</td>\n",
        "      <td> 0.379</td>\n",
        "      <td>  5.7-7.6</td>\n",
        "      <td> 0.750</td>\n",
        "      <td> 1.1</td>\n",
        "      <td> 5.9</td>\n",
        "      <td> 6.9</td>\n",
        "      <td> 6.4</td>\n",
        "      <td> 0.3</td>\n",
        "      <td> 1.6</td>\n",
        "      <td> 1.6</td>\n",
        "      <td> 3.5</td>\n",
        "      <td> 27.1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11</th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '14-'15</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 29</td>\n",
        "      <td> 29</td>\n",
        "      <td> 37.5</td>\n",
        "      <td>  8.8-18.1</td>\n",
        "      <td> 0.488</td>\n",
        "      <td> 1.7-4.5</td>\n",
        "      <td> 0.369</td>\n",
        "      <td>  5.9-7.9</td>\n",
        "      <td> 0.743</td>\n",
        "      <td> 0.7</td>\n",
        "      <td> 4.6</td>\n",
        "      <td> 5.3</td>\n",
        "      <td> 7.6</td>\n",
        "      <td> 0.8</td>\n",
        "      <td> 1.3</td>\n",
        "      <td> 1.7</td>\n",
        "      <td> 3.8</td>\n",
        "      <td> 25.2</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 75,
       "text": [
        "      id   player_name   season team  GP  GS   MIN      FGM-A  FG_Perc  \\\n",
        "0   1966  LeBron James  '03-'04  CLE  79  79  39.5   7.9-18.9    0.417   \n",
        "1   1966  LeBron James  '04-'05  CLE  80  80  42.4   9.9-21.1    0.472   \n",
        "2   1966  LeBron James  '05-'06  CLE  79  79  42.5  11.1-23.1    0.480   \n",
        "3   1966  LeBron James  '06-'07  CLE  78  78  40.9   9.9-20.8    0.476   \n",
        "4   1966  LeBron James  '07-'08  CLE  75  74  40.4  10.6-21.9    0.484   \n",
        "5   1966  LeBron James  '08-'09  CLE  81  81  37.7   9.7-19.9    0.489   \n",
        "6   1966  LeBron James  '09-'10  CLE  76  76  39.0  10.1-20.1    0.503   \n",
        "7   1966  LeBron James  '10-'11  MIA  79  79  38.8   9.6-18.8    0.510   \n",
        "8   1966  LeBron James  '11-'12  MIA  62  62  37.5  10.0-18.9    0.531   \n",
        "9   1966  LeBron James  '12-'13  MIA  76  76  37.9  10.1-17.8    0.565   \n",
        "10  1966  LeBron James  '13-'14  MIA  77  77  37.7  10.0-17.6    0.567   \n",
        "11  1966  LeBron James  '14-'15  CLE  29  29  37.5   8.8-18.1    0.488   \n",
        "\n",
        "      3PM-A  3P_Perc     FTM-A  FT_Perc   OR   DR  REB  AST  BLK  STL   PF  \\\n",
        "0   0.8-2.7    0.290   4.4-5.8    0.754  1.3  4.2  5.5  5.9  0.7  1.6  1.9   \n",
        "1   1.4-3.9    0.351   6.0-8.0    0.750  1.4  6.0  7.4  7.2  0.7  2.2  1.8   \n",
        "2   1.6-4.8    0.335  7.6-10.3    0.738  1.0  6.1  7.0  6.6  0.8  1.6  2.3   \n",
        "3   1.3-4.0    0.319   6.3-9.0    0.698  1.1  5.7  6.7  6.0  0.7  1.6  2.2   \n",
        "4   1.5-4.8    0.315  7.3-10.3    0.712  1.8  6.1  7.9  7.2  1.1  1.8  2.2   \n",
        "5   1.6-4.7    0.344   7.3-9.4    0.780  1.3  6.3  7.6  7.2  1.1  1.7  1.7   \n",
        "6   1.7-5.1    0.333  7.8-10.2    0.767  0.9  6.4  7.3  8.6  1.0  1.6  1.6   \n",
        "7   1.2-3.5    0.330   6.4-8.4    0.759  1.0  6.5  7.5  7.0  0.6  1.6  2.1   \n",
        "8   0.9-2.4    0.362   6.2-8.1    0.771  1.5  6.4  7.9  6.2  0.8  1.9  1.5   \n",
        "9   1.4-3.3    0.406   5.3-7.0    0.753  1.3  6.8  8.0  7.3  0.9  1.7  1.4   \n",
        "10  1.5-4.0    0.379   5.7-7.6    0.750  1.1  5.9  6.9  6.4  0.3  1.6  1.6   \n",
        "11  1.7-4.5    0.369   5.9-7.9    0.743  0.7  4.6  5.3  7.6  0.8  1.3  1.7   \n",
        "\n",
        "     TO   PTS  \n",
        "0   3.5  20.9  \n",
        "1   3.3  27.2  \n",
        "2   3.3  31.4  \n",
        "3   3.2  27.3  \n",
        "4   3.4  30.0  \n",
        "5   3.0  28.4  \n",
        "6   3.4  29.7  \n",
        "7   3.6  26.7  \n",
        "8   3.4  27.1  \n",
        "9   3.0  26.8  \n",
        "10  3.5  27.1  \n",
        "11  3.8  25.2  "
       ]
      }
     ],
     "prompt_number": 75
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Now let's get LeBron's regular season totals.  Below is the SQL to get that:"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "sql = \"\"\"\n",
      "select *\n",
      "\n",
      "from regular_season_totals\n",
      "\n",
      "where\n",
      "player_name like '%LeBron%'\n",
      "\"\"\""
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 70
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.query(sql)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>id</th>\n",
        "      <th>player_name</th>\n",
        "      <th>season</th>\n",
        "      <th>team</th>\n",
        "      <th>FGM-A</th>\n",
        "      <th>FG_Perc</th>\n",
        "      <th>3PM-A</th>\n",
        "      <th>3P_Perc</th>\n",
        "      <th>FTM-A</th>\n",
        "      <th>FT_Perc</th>\n",
        "      <th>OR</th>\n",
        "      <th>DR</th>\n",
        "      <th>REB</th>\n",
        "      <th>AST</th>\n",
        "      <th>BLK</th>\n",
        "      <th>STL</th>\n",
        "      <th>PF</th>\n",
        "      <th>TO</th>\n",
        "      <th>PTS</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '03-'04</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 622-1492</td>\n",
        "      <td> 0.417</td>\n",
        "      <td>  63-217</td>\n",
        "      <td> 0.290</td>\n",
        "      <td> 347-460</td>\n",
        "      <td> 0.754</td>\n",
        "      <td>  99</td>\n",
        "      <td> 333</td>\n",
        "      <td> 432</td>\n",
        "      <td> 465</td>\n",
        "      <td> 58</td>\n",
        "      <td> 130</td>\n",
        "      <td> 149</td>\n",
        "      <td> 273</td>\n",
        "      <td> 1654</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '04-'05</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 795-1684</td>\n",
        "      <td> 0.472</td>\n",
        "      <td> 108-308</td>\n",
        "      <td> 0.351</td>\n",
        "      <td> 477-636</td>\n",
        "      <td> 0.750</td>\n",
        "      <td> 111</td>\n",
        "      <td> 477</td>\n",
        "      <td> 588</td>\n",
        "      <td> 577</td>\n",
        "      <td> 52</td>\n",
        "      <td> 177</td>\n",
        "      <td> 146</td>\n",
        "      <td> 262</td>\n",
        "      <td> 2175</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '05-'06</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 875-1823</td>\n",
        "      <td> 0.480</td>\n",
        "      <td> 127-379</td>\n",
        "      <td> 0.335</td>\n",
        "      <td> 601-814</td>\n",
        "      <td> 0.738</td>\n",
        "      <td>  75</td>\n",
        "      <td> 481</td>\n",
        "      <td> 556</td>\n",
        "      <td> 521</td>\n",
        "      <td> 66</td>\n",
        "      <td> 123</td>\n",
        "      <td> 181</td>\n",
        "      <td> 260</td>\n",
        "      <td> 2478</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '06-'07</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 772-1621</td>\n",
        "      <td> 0.476</td>\n",
        "      <td>  99-310</td>\n",
        "      <td> 0.319</td>\n",
        "      <td> 489-701</td>\n",
        "      <td> 0.698</td>\n",
        "      <td>  83</td>\n",
        "      <td> 443</td>\n",
        "      <td> 526</td>\n",
        "      <td> 470</td>\n",
        "      <td> 55</td>\n",
        "      <td> 125</td>\n",
        "      <td> 171</td>\n",
        "      <td> 250</td>\n",
        "      <td> 2132</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '07-'08</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 794-1642</td>\n",
        "      <td> 0.484</td>\n",
        "      <td> 113-359</td>\n",
        "      <td> 0.315</td>\n",
        "      <td> 549-771</td>\n",
        "      <td> 0.712</td>\n",
        "      <td> 133</td>\n",
        "      <td> 459</td>\n",
        "      <td> 592</td>\n",
        "      <td> 539</td>\n",
        "      <td> 81</td>\n",
        "      <td> 138</td>\n",
        "      <td> 165</td>\n",
        "      <td> 255</td>\n",
        "      <td> 2250</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '08-'09</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 789-1613</td>\n",
        "      <td> 0.489</td>\n",
        "      <td> 132-384</td>\n",
        "      <td> 0.344</td>\n",
        "      <td> 594-762</td>\n",
        "      <td> 0.780</td>\n",
        "      <td> 106</td>\n",
        "      <td> 507</td>\n",
        "      <td> 613</td>\n",
        "      <td> 587</td>\n",
        "      <td> 93</td>\n",
        "      <td> 137</td>\n",
        "      <td> 139</td>\n",
        "      <td> 241</td>\n",
        "      <td> 2304</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '09-'10</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 768-1528</td>\n",
        "      <td> 0.503</td>\n",
        "      <td> 129-387</td>\n",
        "      <td> 0.333</td>\n",
        "      <td> 593-773</td>\n",
        "      <td> 0.767</td>\n",
        "      <td>  71</td>\n",
        "      <td> 483</td>\n",
        "      <td> 554</td>\n",
        "      <td> 651</td>\n",
        "      <td> 77</td>\n",
        "      <td> 125</td>\n",
        "      <td> 119</td>\n",
        "      <td> 261</td>\n",
        "      <td> 2258</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '10-'11</td>\n",
        "      <td> MIA</td>\n",
        "      <td> 758-1485</td>\n",
        "      <td> 0.510</td>\n",
        "      <td>  92-279</td>\n",
        "      <td> 0.330</td>\n",
        "      <td> 503-663</td>\n",
        "      <td> 0.759</td>\n",
        "      <td>  80</td>\n",
        "      <td> 510</td>\n",
        "      <td> 590</td>\n",
        "      <td> 554</td>\n",
        "      <td> 50</td>\n",
        "      <td> 124</td>\n",
        "      <td> 163</td>\n",
        "      <td> 284</td>\n",
        "      <td> 2111</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '11-'12</td>\n",
        "      <td> MIA</td>\n",
        "      <td> 621-1169</td>\n",
        "      <td> 0.531</td>\n",
        "      <td>  54-149</td>\n",
        "      <td> 0.362</td>\n",
        "      <td> 387-502</td>\n",
        "      <td> 0.771</td>\n",
        "      <td>  94</td>\n",
        "      <td> 398</td>\n",
        "      <td> 492</td>\n",
        "      <td> 387</td>\n",
        "      <td> 50</td>\n",
        "      <td> 115</td>\n",
        "      <td>  96</td>\n",
        "      <td> 213</td>\n",
        "      <td> 1683</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '12-'13</td>\n",
        "      <td> MIA</td>\n",
        "      <td> 765-1354</td>\n",
        "      <td> 0.565</td>\n",
        "      <td> 103-254</td>\n",
        "      <td> 0.406</td>\n",
        "      <td> 403-535</td>\n",
        "      <td> 0.753</td>\n",
        "      <td>  97</td>\n",
        "      <td> 513</td>\n",
        "      <td> 610</td>\n",
        "      <td> 551</td>\n",
        "      <td> 67</td>\n",
        "      <td> 129</td>\n",
        "      <td> 110</td>\n",
        "      <td> 226</td>\n",
        "      <td> 2036</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10</th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '13-'14</td>\n",
        "      <td> MIA</td>\n",
        "      <td> 767-1353</td>\n",
        "      <td> 0.567</td>\n",
        "      <td> 116-306</td>\n",
        "      <td> 0.379</td>\n",
        "      <td> 439-585</td>\n",
        "      <td> 0.750</td>\n",
        "      <td>  81</td>\n",
        "      <td> 452</td>\n",
        "      <td> 533</td>\n",
        "      <td> 489</td>\n",
        "      <td> 26</td>\n",
        "      <td> 121</td>\n",
        "      <td> 126</td>\n",
        "      <td> 270</td>\n",
        "      <td> 2089</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11</th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '14-'15</td>\n",
        "      <td> CLE</td>\n",
        "      <td>  256-525</td>\n",
        "      <td> 0.488</td>\n",
        "      <td>  48-130</td>\n",
        "      <td> 0.369</td>\n",
        "      <td> 171-230</td>\n",
        "      <td> 0.743</td>\n",
        "      <td>  19</td>\n",
        "      <td> 134</td>\n",
        "      <td> 153</td>\n",
        "      <td> 221</td>\n",
        "      <td> 23</td>\n",
        "      <td>  39</td>\n",
        "      <td>  50</td>\n",
        "      <td> 111</td>\n",
        "      <td>  731</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 71,
       "text": [
        "      id   player_name   season team     FGM-A  FG_Perc    3PM-A  3P_Perc  \\\n",
        "0   1966  LeBron James  '03-'04  CLE  622-1492    0.417   63-217    0.290   \n",
        "1   1966  LeBron James  '04-'05  CLE  795-1684    0.472  108-308    0.351   \n",
        "2   1966  LeBron James  '05-'06  CLE  875-1823    0.480  127-379    0.335   \n",
        "3   1966  LeBron James  '06-'07  CLE  772-1621    0.476   99-310    0.319   \n",
        "4   1966  LeBron James  '07-'08  CLE  794-1642    0.484  113-359    0.315   \n",
        "5   1966  LeBron James  '08-'09  CLE  789-1613    0.489  132-384    0.344   \n",
        "6   1966  LeBron James  '09-'10  CLE  768-1528    0.503  129-387    0.333   \n",
        "7   1966  LeBron James  '10-'11  MIA  758-1485    0.510   92-279    0.330   \n",
        "8   1966  LeBron James  '11-'12  MIA  621-1169    0.531   54-149    0.362   \n",
        "9   1966  LeBron James  '12-'13  MIA  765-1354    0.565  103-254    0.406   \n",
        "10  1966  LeBron James  '13-'14  MIA  767-1353    0.567  116-306    0.379   \n",
        "11  1966  LeBron James  '14-'15  CLE   256-525    0.488   48-130    0.369   \n",
        "\n",
        "      FTM-A  FT_Perc   OR   DR  REB  AST  BLK  STL   PF   TO   PTS  \n",
        "0   347-460    0.754   99  333  432  465   58  130  149  273  1654  \n",
        "1   477-636    0.750  111  477  588  577   52  177  146  262  2175  \n",
        "2   601-814    0.738   75  481  556  521   66  123  181  260  2478  \n",
        "3   489-701    0.698   83  443  526  470   55  125  171  250  2132  \n",
        "4   549-771    0.712  133  459  592  539   81  138  165  255  2250  \n",
        "5   594-762    0.780  106  507  613  587   93  137  139  241  2304  \n",
        "6   593-773    0.767   71  483  554  651   77  125  119  261  2258  \n",
        "7   503-663    0.759   80  510  590  554   50  124  163  284  2111  \n",
        "8   387-502    0.771   94  398  492  387   50  115   96  213  1683  \n",
        "9   403-535    0.753   97  513  610  551   67  129  110  226  2036  \n",
        "10  439-585    0.750   81  452  533  489   26  121  126  270  2089  \n",
        "11  171-230    0.743   19  134  153  221   23   39   50  111   731  "
       ]
      }
     ],
     "prompt_number": 71
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### Below is the SQL to get LeBron's regular season misc totals:"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "sql = \"\"\"\n",
      "select *\n",
      "\n",
      "from regular_season_misc_totals\n",
      "\n",
      "where\n",
      "player_name like '%LeBron%'\n",
      "\"\"\""
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 72
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "db.query(sql)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>id</th>\n",
        "      <th>player_name</th>\n",
        "      <th>season</th>\n",
        "      <th>team</th>\n",
        "      <th>DBLDBL</th>\n",
        "      <th>TRIDBL</th>\n",
        "      <th>DQ</th>\n",
        "      <th>EJECT</th>\n",
        "      <th>TECH</th>\n",
        "      <th>FLAG</th>\n",
        "      <th>AST2TO</th>\n",
        "      <th>STL2TO</th>\n",
        "      <th>RAT</th>\n",
        "      <th>SCEFF</th>\n",
        "      <th>SHEFF</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '03-'04</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 12</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  2</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1.70</td>\n",
        "      <td> 0.48</td>\n",
        "      <td> 34.32</td>\n",
        "      <td> 1.109</td>\n",
        "      <td> 0.438</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '04-'05</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 25</td>\n",
        "      <td> 4</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td>  4</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2.20</td>\n",
        "      <td> 0.68</td>\n",
        "      <td> 47.09</td>\n",
        "      <td> 1.292</td>\n",
        "      <td> 0.504</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '05-'06</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 21</td>\n",
        "      <td> 5</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2.00</td>\n",
        "      <td> 0.47</td>\n",
        "      <td> 50.09</td>\n",
        "      <td> 1.359</td>\n",
        "      <td> 0.515</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '06-'07</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 16</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td>  2</td>\n",
        "      <td> 2</td>\n",
        "      <td> 1.88</td>\n",
        "      <td> 0.50</td>\n",
        "      <td> 44.08</td>\n",
        "      <td> 1.315</td>\n",
        "      <td> 0.507</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '07-'08</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 31</td>\n",
        "      <td> 7</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td>  2</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2.11</td>\n",
        "      <td> 0.54</td>\n",
        "      <td> 50.68</td>\n",
        "      <td> 1.370</td>\n",
        "      <td> 0.518</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '08-'09</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 29</td>\n",
        "      <td> 7</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 10</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2.44</td>\n",
        "      <td> 0.57</td>\n",
        "      <td> 49.97</td>\n",
        "      <td> 1.428</td>\n",
        "      <td> 0.530</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '09-'10</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 31</td>\n",
        "      <td> 4</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  4</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2.49</td>\n",
        "      <td> 0.48</td>\n",
        "      <td> 52.66</td>\n",
        "      <td> 1.478</td>\n",
        "      <td> 0.545</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '10-'11</td>\n",
        "      <td> MIA</td>\n",
        "      <td> 31</td>\n",
        "      <td> 4</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  7</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1.95</td>\n",
        "      <td> 0.44</td>\n",
        "      <td> 46.73</td>\n",
        "      <td> 1.422</td>\n",
        "      <td> 0.541</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '11-'12</td>\n",
        "      <td> MIA</td>\n",
        "      <td> 23</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  3</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1.82</td>\n",
        "      <td> 0.54</td>\n",
        "      <td> 47.86</td>\n",
        "      <td> 1.440</td>\n",
        "      <td> 0.554</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9 </th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '12-'13</td>\n",
        "      <td> MIA</td>\n",
        "      <td> 36</td>\n",
        "      <td> 4</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  6</td>\n",
        "      <td> 1</td>\n",
        "      <td> 2.44</td>\n",
        "      <td> 0.57</td>\n",
        "      <td> 50.30</td>\n",
        "      <td> 1.504</td>\n",
        "      <td> 0.603</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10</th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '13-'14</td>\n",
        "      <td> MIA</td>\n",
        "      <td> 12</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td>  5</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1.81</td>\n",
        "      <td> 0.45</td>\n",
        "      <td> 47.07</td>\n",
        "      <td> 1.544</td>\n",
        "      <td> 0.610</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11</th>\n",
        "      <td> 1966</td>\n",
        "      <td> LeBron James</td>\n",
        "      <td> '14-'15</td>\n",
        "      <td> CLE</td>\n",
        "      <td> 11</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>  2</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1.99</td>\n",
        "      <td> 0.35</td>\n",
        "      <td> 43.01</td>\n",
        "      <td> 1.392</td>\n",
        "      <td> 0.533</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 73,
       "text": [
        "      id   player_name   season team  DBLDBL  TRIDBL  DQ  EJECT  TECH  FLAG  \\\n",
        "0   1966  LeBron James  '03-'04  CLE      12       0   0      0     2     0   \n",
        "1   1966  LeBron James  '04-'05  CLE      25       4   1      0     4     0   \n",
        "2   1966  LeBron James  '05-'06  CLE      21       5   0      0     0     0   \n",
        "3   1966  LeBron James  '06-'07  CLE      16       1   1      0     2     2   \n",
        "4   1966  LeBron James  '07-'08  CLE      31       7   1      0     2     0   \n",
        "5   1966  LeBron James  '08-'09  CLE      29       7   0      0    10     0   \n",
        "6   1966  LeBron James  '09-'10  CLE      31       4   0      0     4     0   \n",
        "7   1966  LeBron James  '10-'11  MIA      31       4   0      0     7     0   \n",
        "8   1966  LeBron James  '11-'12  MIA      23       0   0      0     3     0   \n",
        "9   1966  LeBron James  '12-'13  MIA      36       4   0      0     6     1   \n",
        "10  1966  LeBron James  '13-'14  MIA      12       1   1      0     5     1   \n",
        "11  1966  LeBron James  '14-'15  CLE      11       0   0      0     2     0   \n",
        "\n",
        "    AST2TO  STL2TO    RAT  SCEFF  SHEFF  \n",
        "0     1.70    0.48  34.32  1.109  0.438  \n",
        "1     2.20    0.68  47.09  1.292  0.504  \n",
        "2     2.00    0.47  50.09  1.359  0.515  \n",
        "3     1.88    0.50  44.08  1.315  0.507  \n",
        "4     2.11    0.54  50.68  1.370  0.518  \n",
        "5     2.44    0.57  49.97  1.428  0.530  \n",
        "6     2.49    0.48  52.66  1.478  0.545  \n",
        "7     1.95    0.44  46.73  1.422  0.541  \n",
        "8     1.82    0.54  47.86  1.440  0.554  \n",
        "9     2.44    0.57  50.30  1.504  0.603  \n",
        "10    1.81    0.45  47.07  1.544  0.610  \n",
        "11    1.99    0.35  43.01  1.392  0.533  "
       ]
      }
     ],
     "prompt_number": 73
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "## Sweet!  Checking my results and comparing them to LeBron's [site](http://espn.go.com/nba/player/stats/_/id/1966/lebron-james), it looks like my scraping worked!"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "<a id=\"sqlite_tables\"></a>"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "# Below are the sqlite table definitions for the tables I created in this example"
     ]
    },
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "[[back to top]](#top)"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "CREATE TABLE \"player_game_stats\" (\n",
      "    \"id\" INTEGER PRIMARY KEY NOT NULL,\n",
      "    \"name_pos\" TEXT NOT NULL,\n",
      "    \"team_name\" TEXT NOT NULL,\n",
      "    \"GP\" INTEGER NOT NULL,\n",
      "    \"GS\" INTEGER NOT NULL,\n",
      "    \"MIN\" REAL NOT NULL,\n",
      "    \"PPG\" REAL NOT NULL,\n",
      "    \"OFFR\" REAL NOT NULL,\n",
      "    \"DEFR\" REAL NOT NULL,\n",
      "    \"RPG\" REAL NOT NULL,\n",
      "    \"APG\" REAL NOT NULL,\n",
      "    \"SPG\" REAL NOT NULL,\n",
      "    \"BPG\" REAL NOT NULL,\n",
      "    \"TPG\" REAL NOT NULL,\n",
      "    \"FPG\" REAL NOT NULL,\n",
      "    \"A2TO\" REAL NOT NULL,\n",
      "    \"PER\" REAL NOT NULL\n",
      ");\n",
      "\n",
      "CREATE TABLE \"player_shooting_stats\" (\n",
      "    \"id\" INTEGER PRIMARY KEY NOT NULL,\n",
      "    \"name_pos\" TEXT NOT NULL,\n",
      "    \"team_name\" TEXT NOT NULL,\n",
      "    \"FGM\" REAL NOT NULL,\n",
      "    \"FGA\" REAL NOT NULL,\n",
      "    \"FG_Perc\" REAL NOT NULL,\n",
      "    \"3PM\" REAL NOT NULL,\n",
      "    \"3PA\" REAL NOT NULL,\n",
      "    \"3P_Perc\" REAL NOT NULL,\n",
      "    \"FTM\" REAL NOT NULL,\n",
      "    \"FTA\" REAL NOT NULL,\n",
      "    \"FT_Perc\" REAL NOT NULL,\n",
      "    \"2PM\" REAL NOT NULL,\n",
      "    \"2PA\" REAL NOT NULL,\n",
      "    \"2P_Perc\" REAL NOT NULL,\n",
      "    \"PPS\" REAL NOT NULL,\n",
      "    \"AFG_Perc\" REAL NOT NULL\n",
      ");\n",
      "\n",
      "CREATE TABLE \"regular_season_avgs\" (\n",
      "    \"id\" INTEGER NOT NULL,\n",
      "    \"season\" TEXT NOT NULL,\n",
      "    \"team\" TEXT NOT NULL,\n",
      "    \"GP\" INTEGER NOT NULL,\n",
      "    \"GS\" INTEGER NOT NULL,\n",
      "    \"MIN\" REAL NOT NULL,\n",
      "    \"FGM-A\" TEXT NOT NULL,\n",
      "    \"FG_Perc\" REAL NOT NULL,\n",
      "    \"3PM-A\" TEXT NOT NULL,\n",
      "    \"3P_Perc\" REAL NOT NULL,\n",
      "    \"FTM-A\" TEXT NOT NULL,\n",
      "    \"FT_Perc\" REAL NOT NULL,\n",
      "    \"OR\" REAL NOT NULL,\n",
      "    \"DR\" REAL NOT NULL,\n",
      "    \"REB\" REAL NOT NULL,\n",
      "    \"AST\" REAL NOT NULL,\n",
      "    \"BLK\" REAL NOT NULL,\n",
      "    \"STL\" REAL NOT NULL,\n",
      "    \"PF\" REAL NOT NULL,\n",
      "    \"TO\" REAL NOT NULL,\n",
      "    \"PTS\" REAL NOT NULL,\n",
      "    unique (\"id\", \"season\",\"team\")\n",
      ");\n",
      "\n",
      "CREATE TABLE \"regular_season_totals\" (\n",
      "    \"id\" INTEGER NOT NULL,\n",
      "    \"season\" TEXT NOT NULL,\n",
      "    \"team\" TEXT NOT NULL,\n",
      "    \"FGM-A\" TEXT NOT NULL,\n",
      "    \"FG_Perc\" REAL NOT NULL,\n",
      "    \"3PM-A\" TEXT NOT NULL,\n",
      "    \"3P_Perc\" REAL NOT NULL,\n",
      "    \"FTM-A\" TEXT NOT NULL,\n",
      "    \"FT_Perc\" REAL NOT NULL,\n",
      "    \"OR\" INTEGER NOT NULL,\n",
      "    \"DR\" INTEGER NOT NULL,\n",
      "    \"REB\" INTEGER NOT NULL,\n",
      "    \"AST\" INTEGER NOT NULL,\n",
      "    \"BLK\" INTEGER NOT NULL,\n",
      "    \"STL\" INTEGER NOT NULL,\n",
      "    \"PF\" INTEGER NOT NULL,\n",
      "    \"TO\" INTEGER NOT NULL,\n",
      "    \"PTS\" INTEGER NOT NULL,\n",
      "    unique (\"id\",\"season\",\"team\")\n",
      ");\n",
      "\n",
      "CREATE TABLE \"regular_season_misc_totals\" (\n",
      "    \"id\" INTEGER NOT NULL,\n",
      "    \"season\" TEXT NOT NULL,\n",
      "    \"team\" TEXT NOT NULL,\n",
      "    \"DBLDBL\" INTEGER NOT NULL,\n",
      "    \"TRIDBL\" INTEGER NOT NULL,\n",
      "    \"DQ\" INTEGER NOT NULL,\n",
      "    \"EJECT\" INTEGER NOT NULL,\n",
      "    \"TECH\" INTEGER NOT NULL,\n",
      "    \"FLAG\" INTEGER NOT NULL,\n",
      "    \"AST2TO\" REAL NOT NULL,\n",
      "    \"STL2TO\" REAL NOT NULL,\n",
      "    \"RAT\" REAL NOT NULL,\n",
      "    \"SCEFF\" REAL NOT NULL,\n",
      "    \"SHEFF\" REAL NOT NULL,\n",
      "    unique(\"id\",\"season\",\"team\")\n",
      ");"
     ],
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}