WebSrapingUsingPandasReadHTML.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "WebSrapingUsingPandasReadHTML.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "authorship_tag": "ABX9TyMP/1J2Wx5YSsDiiq9v8X6I",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/abidshafee/dataAnalysis/blob/master/WebSrapingUsingPandasReadHTML.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CzwHzCYhtexF",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import pandas as pd"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PQuGlmO_t_q1",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "# original website\n",
        "# https://www.basketball-reference.com/playoffs/NBA_2019.html\n",
        "# Formating website for accessing any year data\n",
        "\n",
        "year = '2019'\n",
        "site = f'https://www.basketball-reference.com/playoffs/NBA_{year}.html'\n",
        "teamState = f'https://www.basketball-reference.com/playoffs/NBA_{year}.html#team-stats-base::none'"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "U9tIhF2_uu-A",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "outputId": "a3c98fc5-e6a5-4d68-812c-63e093ecdae6"
      },
      "source": [
        "site"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            },
            "text/plain": [
              "'https://www.basketball-reference.com/playoffs/NBA_2019.html'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "qVabcrGnuzNI",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "dfRaw = pd.read_html(site, header=0)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DlQzeNsQv_AT",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 576
        },
        "outputId": "b35fc001-0274-4900-b7f7-19288270bfb1"
      },
      "source": [
        "dfRaw[16]"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Rk</th>\n",
              "      <th>Team</th>\n",
              "      <th>G</th>\n",
              "      <th>MP</th>\n",
              "      <th>FG</th>\n",
              "      <th>FGA</th>\n",
              "      <th>FG%</th>\n",
              "      <th>3P</th>\n",
              "      <th>3PA</th>\n",
              "      <th>3P%</th>\n",
              "      <th>2P</th>\n",
              "      <th>2PA</th>\n",
              "      <th>2P%</th>\n",
              "      <th>FT</th>\n",
              "      <th>FTA</th>\n",
              "      <th>FT%</th>\n",
              "      <th>ORB</th>\n",
              "      <th>DRB</th>\n",
              "      <th>TRB</th>\n",
              "      <th>AST</th>\n",
              "      <th>STL</th>\n",
              "      <th>BLK</th>\n",
              "      <th>TOV</th>\n",
              "      <th>PF</th>\n",
              "      <th>PTS</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1.0</td>\n",
              "      <td>Toronto Raptors</td>\n",
              "      <td>24</td>\n",
              "      <td>242.1</td>\n",
              "      <td>37.7</td>\n",
              "      <td>84.8</td>\n",
              "      <td>0.444</td>\n",
              "      <td>11.9</td>\n",
              "      <td>34.5</td>\n",
              "      <td>0.346</td>\n",
              "      <td>25.8</td>\n",
              "      <td>50.3</td>\n",
              "      <td>0.512</td>\n",
              "      <td>19.3</td>\n",
              "      <td>23.3</td>\n",
              "      <td>0.830</td>\n",
              "      <td>8.3</td>\n",
              "      <td>34.0</td>\n",
              "      <td>42.3</td>\n",
              "      <td>22.5</td>\n",
              "      <td>8.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>12.0</td>\n",
              "      <td>22.6</td>\n",
              "      <td>106.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2.0</td>\n",
              "      <td>Golden State Warriors</td>\n",
              "      <td>22</td>\n",
              "      <td>242.3</td>\n",
              "      <td>41.1</td>\n",
              "      <td>86.1</td>\n",
              "      <td>0.477</td>\n",
              "      <td>12.2</td>\n",
              "      <td>32.7</td>\n",
              "      <td>0.372</td>\n",
              "      <td>28.9</td>\n",
              "      <td>53.4</td>\n",
              "      <td>0.541</td>\n",
              "      <td>19.8</td>\n",
              "      <td>24.3</td>\n",
              "      <td>0.813</td>\n",
              "      <td>10.1</td>\n",
              "      <td>33.2</td>\n",
              "      <td>43.3</td>\n",
              "      <td>28.4</td>\n",
              "      <td>7.4</td>\n",
              "      <td>5.7</td>\n",
              "      <td>14.9</td>\n",
              "      <td>23.2</td>\n",
              "      <td>114.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3.0</td>\n",
              "      <td>Portland Trail Blazers</td>\n",
              "      <td>16</td>\n",
              "      <td>247.8</td>\n",
              "      <td>39.4</td>\n",
              "      <td>90.4</td>\n",
              "      <td>0.436</td>\n",
              "      <td>11.8</td>\n",
              "      <td>32.8</td>\n",
              "      <td>0.360</td>\n",
              "      <td>27.6</td>\n",
              "      <td>57.6</td>\n",
              "      <td>0.479</td>\n",
              "      <td>19.0</td>\n",
              "      <td>24.8</td>\n",
              "      <td>0.766</td>\n",
              "      <td>11.4</td>\n",
              "      <td>33.8</td>\n",
              "      <td>45.3</td>\n",
              "      <td>19.8</td>\n",
              "      <td>6.8</td>\n",
              "      <td>5.2</td>\n",
              "      <td>12.9</td>\n",
              "      <td>22.8</td>\n",
              "      <td>109.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4.0</td>\n",
              "      <td>Milwaukee Bucks</td>\n",
              "      <td>15</td>\n",
              "      <td>243.3</td>\n",
              "      <td>39.8</td>\n",
              "      <td>88.4</td>\n",
              "      <td>0.450</td>\n",
              "      <td>12.8</td>\n",
              "      <td>38.1</td>\n",
              "      <td>0.336</td>\n",
              "      <td>27.0</td>\n",
              "      <td>50.3</td>\n",
              "      <td>0.536</td>\n",
              "      <td>20.4</td>\n",
              "      <td>28.0</td>\n",
              "      <td>0.729</td>\n",
              "      <td>10.1</td>\n",
              "      <td>41.8</td>\n",
              "      <td>51.9</td>\n",
              "      <td>25.0</td>\n",
              "      <td>6.7</td>\n",
              "      <td>6.4</td>\n",
              "      <td>12.9</td>\n",
              "      <td>21.8</td>\n",
              "      <td>112.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5.0</td>\n",
              "      <td>Denver Nuggets</td>\n",
              "      <td>14</td>\n",
              "      <td>247.1</td>\n",
              "      <td>39.9</td>\n",
              "      <td>90.3</td>\n",
              "      <td>0.442</td>\n",
              "      <td>9.6</td>\n",
              "      <td>27.8</td>\n",
              "      <td>0.344</td>\n",
              "      <td>30.4</td>\n",
              "      <td>62.5</td>\n",
              "      <td>0.486</td>\n",
              "      <td>19.7</td>\n",
              "      <td>25.2</td>\n",
              "      <td>0.782</td>\n",
              "      <td>13.1</td>\n",
              "      <td>34.6</td>\n",
              "      <td>47.7</td>\n",
              "      <td>24.0</td>\n",
              "      <td>5.7</td>\n",
              "      <td>4.6</td>\n",
              "      <td>9.7</td>\n",
              "      <td>21.3</td>\n",
              "      <td>109.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>6.0</td>\n",
              "      <td>Philadelphia 76ers</td>\n",
              "      <td>12</td>\n",
              "      <td>240.0</td>\n",
              "      <td>39.4</td>\n",
              "      <td>85.8</td>\n",
              "      <td>0.459</td>\n",
              "      <td>9.4</td>\n",
              "      <td>28.4</td>\n",
              "      <td>0.331</td>\n",
              "      <td>30.0</td>\n",
              "      <td>57.4</td>\n",
              "      <td>0.522</td>\n",
              "      <td>20.4</td>\n",
              "      <td>25.8</td>\n",
              "      <td>0.790</td>\n",
              "      <td>11.4</td>\n",
              "      <td>37.1</td>\n",
              "      <td>48.5</td>\n",
              "      <td>24.4</td>\n",
              "      <td>6.3</td>\n",
              "      <td>5.5</td>\n",
              "      <td>16.4</td>\n",
              "      <td>22.4</td>\n",
              "      <td>108.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>7.0</td>\n",
              "      <td>Houston Rockets</td>\n",
              "      <td>11</td>\n",
              "      <td>242.3</td>\n",
              "      <td>37.2</td>\n",
              "      <td>83.8</td>\n",
              "      <td>0.444</td>\n",
              "      <td>15.6</td>\n",
              "      <td>42.7</td>\n",
              "      <td>0.366</td>\n",
              "      <td>21.5</td>\n",
              "      <td>41.1</td>\n",
              "      <td>0.524</td>\n",
              "      <td>18.5</td>\n",
              "      <td>24.3</td>\n",
              "      <td>0.764</td>\n",
              "      <td>9.6</td>\n",
              "      <td>33.3</td>\n",
              "      <td>42.9</td>\n",
              "      <td>18.3</td>\n",
              "      <td>8.5</td>\n",
              "      <td>5.1</td>\n",
              "      <td>15.8</td>\n",
              "      <td>21.6</td>\n",
              "      <td>108.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>8.0</td>\n",
              "      <td>Boston Celtics</td>\n",
              "      <td>9</td>\n",
              "      <td>240.0</td>\n",
              "      <td>35.7</td>\n",
              "      <td>84.1</td>\n",
              "      <td>0.424</td>\n",
              "      <td>11.3</td>\n",
              "      <td>33.0</td>\n",
              "      <td>0.343</td>\n",
              "      <td>24.3</td>\n",
              "      <td>51.1</td>\n",
              "      <td>0.476</td>\n",
              "      <td>19.4</td>\n",
              "      <td>24.2</td>\n",
              "      <td>0.803</td>\n",
              "      <td>7.4</td>\n",
              "      <td>40.6</td>\n",
              "      <td>48.0</td>\n",
              "      <td>21.4</td>\n",
              "      <td>5.7</td>\n",
              "      <td>3.9</td>\n",
              "      <td>14.8</td>\n",
              "      <td>20.8</td>\n",
              "      <td>102.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>9.0</td>\n",
              "      <td>San Antonio Spurs</td>\n",
              "      <td>7</td>\n",
              "      <td>240.0</td>\n",
              "      <td>39.4</td>\n",
              "      <td>85.1</td>\n",
              "      <td>0.463</td>\n",
              "      <td>6.7</td>\n",
              "      <td>19.9</td>\n",
              "      <td>0.338</td>\n",
              "      <td>32.7</td>\n",
              "      <td>65.3</td>\n",
              "      <td>0.501</td>\n",
              "      <td>17.7</td>\n",
              "      <td>23.0</td>\n",
              "      <td>0.770</td>\n",
              "      <td>10.7</td>\n",
              "      <td>34.4</td>\n",
              "      <td>45.1</td>\n",
              "      <td>21.1</td>\n",
              "      <td>4.6</td>\n",
              "      <td>4.0</td>\n",
              "      <td>8.4</td>\n",
              "      <td>19.4</td>\n",
              "      <td>103.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>10.0</td>\n",
              "      <td>Los Angeles Clippers</td>\n",
              "      <td>6</td>\n",
              "      <td>240.0</td>\n",
              "      <td>39.8</td>\n",
              "      <td>89.2</td>\n",
              "      <td>0.447</td>\n",
              "      <td>11.5</td>\n",
              "      <td>31.7</td>\n",
              "      <td>0.363</td>\n",
              "      <td>28.3</td>\n",
              "      <td>57.5</td>\n",
              "      <td>0.493</td>\n",
              "      <td>23.5</td>\n",
              "      <td>28.8</td>\n",
              "      <td>0.815</td>\n",
              "      <td>10.0</td>\n",
              "      <td>30.2</td>\n",
              "      <td>40.2</td>\n",
              "      <td>25.3</td>\n",
              "      <td>8.0</td>\n",
              "      <td>3.3</td>\n",
              "      <td>15.0</td>\n",
              "      <td>25.0</td>\n",
              "      <td>114.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>11.0</td>\n",
              "      <td>Brooklyn Nets</td>\n",
              "      <td>5</td>\n",
              "      <td>240.0</td>\n",
              "      <td>38.4</td>\n",
              "      <td>91.4</td>\n",
              "      <td>0.420</td>\n",
              "      <td>11.0</td>\n",
              "      <td>34.0</td>\n",
              "      <td>0.324</td>\n",
              "      <td>27.4</td>\n",
              "      <td>57.4</td>\n",
              "      <td>0.477</td>\n",
              "      <td>23.6</td>\n",
              "      <td>29.2</td>\n",
              "      <td>0.808</td>\n",
              "      <td>11.4</td>\n",
              "      <td>29.2</td>\n",
              "      <td>40.6</td>\n",
              "      <td>19.2</td>\n",
              "      <td>7.4</td>\n",
              "      <td>2.8</td>\n",
              "      <td>14.2</td>\n",
              "      <td>22.8</td>\n",
              "      <td>111.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>12.0</td>\n",
              "      <td>Oklahoma City Thunder</td>\n",
              "      <td>5</td>\n",
              "      <td>240.0</td>\n",
              "      <td>37.8</td>\n",
              "      <td>86.0</td>\n",
              "      <td>0.440</td>\n",
              "      <td>10.4</td>\n",
              "      <td>31.4</td>\n",
              "      <td>0.331</td>\n",
              "      <td>27.4</td>\n",
              "      <td>54.6</td>\n",
              "      <td>0.502</td>\n",
              "      <td>19.2</td>\n",
              "      <td>25.4</td>\n",
              "      <td>0.756</td>\n",
              "      <td>10.2</td>\n",
              "      <td>33.0</td>\n",
              "      <td>43.2</td>\n",
              "      <td>22.6</td>\n",
              "      <td>6.6</td>\n",
              "      <td>5.4</td>\n",
              "      <td>15.2</td>\n",
              "      <td>24.2</td>\n",
              "      <td>105.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>13.0</td>\n",
              "      <td>Utah Jazz</td>\n",
              "      <td>5</td>\n",
              "      <td>240.0</td>\n",
              "      <td>34.6</td>\n",
              "      <td>86.4</td>\n",
              "      <td>0.400</td>\n",
              "      <td>9.4</td>\n",
              "      <td>35.8</td>\n",
              "      <td>0.263</td>\n",
              "      <td>25.2</td>\n",
              "      <td>50.6</td>\n",
              "      <td>0.498</td>\n",
              "      <td>19.2</td>\n",
              "      <td>25.6</td>\n",
              "      <td>0.750</td>\n",
              "      <td>11.8</td>\n",
              "      <td>35.4</td>\n",
              "      <td>47.2</td>\n",
              "      <td>23.0</td>\n",
              "      <td>9.2</td>\n",
              "      <td>5.4</td>\n",
              "      <td>15.2</td>\n",
              "      <td>21.8</td>\n",
              "      <td>97.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>14.0</td>\n",
              "      <td>Orlando Magic</td>\n",
              "      <td>5</td>\n",
              "      <td>240.0</td>\n",
              "      <td>32.2</td>\n",
              "      <td>83.0</td>\n",
              "      <td>0.388</td>\n",
              "      <td>10.4</td>\n",
              "      <td>34.8</td>\n",
              "      <td>0.299</td>\n",
              "      <td>21.8</td>\n",
              "      <td>48.2</td>\n",
              "      <td>0.452</td>\n",
              "      <td>17.2</td>\n",
              "      <td>22.2</td>\n",
              "      <td>0.775</td>\n",
              "      <td>9.6</td>\n",
              "      <td>33.8</td>\n",
              "      <td>43.4</td>\n",
              "      <td>19.0</td>\n",
              "      <td>6.6</td>\n",
              "      <td>4.0</td>\n",
              "      <td>15.6</td>\n",
              "      <td>18.8</td>\n",
              "      <td>92.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>15.0</td>\n",
              "      <td>Detroit Pistons</td>\n",
              "      <td>4</td>\n",
              "      <td>240.0</td>\n",
              "      <td>37.5</td>\n",
              "      <td>96.8</td>\n",
              "      <td>0.388</td>\n",
              "      <td>11.0</td>\n",
              "      <td>33.3</td>\n",
              "      <td>0.331</td>\n",
              "      <td>26.5</td>\n",
              "      <td>63.5</td>\n",
              "      <td>0.417</td>\n",
              "      <td>12.0</td>\n",
              "      <td>16.5</td>\n",
              "      <td>0.727</td>\n",
              "      <td>10.8</td>\n",
              "      <td>31.5</td>\n",
              "      <td>42.3</td>\n",
              "      <td>23.0</td>\n",
              "      <td>7.3</td>\n",
              "      <td>4.0</td>\n",
              "      <td>10.5</td>\n",
              "      <td>24.3</td>\n",
              "      <td>98.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>16.0</td>\n",
              "      <td>Indiana Pacers</td>\n",
              "      <td>4</td>\n",
              "      <td>240.0</td>\n",
              "      <td>33.5</td>\n",
              "      <td>83.5</td>\n",
              "      <td>0.401</td>\n",
              "      <td>10.0</td>\n",
              "      <td>29.8</td>\n",
              "      <td>0.336</td>\n",
              "      <td>23.5</td>\n",
              "      <td>53.8</td>\n",
              "      <td>0.437</td>\n",
              "      <td>14.8</td>\n",
              "      <td>20.5</td>\n",
              "      <td>0.720</td>\n",
              "      <td>8.0</td>\n",
              "      <td>32.3</td>\n",
              "      <td>40.3</td>\n",
              "      <td>20.8</td>\n",
              "      <td>8.3</td>\n",
              "      <td>3.5</td>\n",
              "      <td>12.0</td>\n",
              "      <td>20.0</td>\n",
              "      <td>91.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>NaN</td>\n",
              "      <td>League Average</td>\n",
              "      <td>10</td>\n",
              "      <td>242.4</td>\n",
              "      <td>38.5</td>\n",
              "      <td>87.0</td>\n",
              "      <td>0.443</td>\n",
              "      <td>11.4</td>\n",
              "      <td>32.9</td>\n",
              "      <td>0.345</td>\n",
              "      <td>27.1</td>\n",
              "      <td>54.0</td>\n",
              "      <td>0.502</td>\n",
              "      <td>19.4</td>\n",
              "      <td>24.7</td>\n",
              "      <td>0.784</td>\n",
              "      <td>10.2</td>\n",
              "      <td>34.8</td>\n",
              "      <td>45.0</td>\n",
              "      <td>23.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>4.9</td>\n",
              "      <td>13.4</td>\n",
              "      <td>22.2</td>\n",
              "      <td>107.7</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      Rk                    Team   G     MP    FG  ...  STL  BLK   TOV    PF    PTS\n",
              "0    1.0         Toronto Raptors  24  242.1  37.7  ...  8.0  4.6  12.0  22.6  106.6\n",
              "1    2.0   Golden State Warriors  22  242.3  41.1  ...  7.4  5.7  14.9  23.2  114.1\n",
              "2    3.0  Portland Trail Blazers  16  247.8  39.4  ...  6.8  5.2  12.9  22.8  109.7\n",
              "3    4.0         Milwaukee Bucks  15  243.3  39.8  ...  6.7  6.4  12.9  21.8  112.8\n",
              "4    5.0          Denver Nuggets  14  247.1  39.9  ...  5.7  4.6   9.7  21.3  109.1\n",
              "5    6.0      Philadelphia 76ers  12  240.0  39.4  ...  6.3  5.5  16.4  22.4  108.7\n",
              "6    7.0         Houston Rockets  11  242.3  37.2  ...  8.5  5.1  15.8  21.6  108.5\n",
              "7    8.0          Boston Celtics   9  240.0  35.7  ...  5.7  3.9  14.8  20.8  102.1\n",
              "8    9.0       San Antonio Spurs   7  240.0  39.4  ...  4.6  4.0   8.4  19.4  103.3\n",
              "9   10.0    Los Angeles Clippers   6  240.0  39.8  ...  8.0  3.3  15.0  25.0  114.7\n",
              "10  11.0           Brooklyn Nets   5  240.0  38.4  ...  7.4  2.8  14.2  22.8  111.4\n",
              "11  12.0   Oklahoma City Thunder   5  240.0  37.8  ...  6.6  5.4  15.2  24.2  105.2\n",
              "12  13.0               Utah Jazz   5  240.0  34.6  ...  9.2  5.4  15.2  21.8   97.8\n",
              "13  14.0           Orlando Magic   5  240.0  32.2  ...  6.6  4.0  15.6  18.8   92.0\n",
              "14  15.0         Detroit Pistons   4  240.0  37.5  ...  7.3  4.0  10.5  24.3   98.0\n",
              "15  16.0          Indiana Pacers   4  240.0  33.5  ...  8.3  3.5  12.0  20.0   91.8\n",
              "16   NaN          League Average  10  242.4  38.5  ...  7.0  4.9  13.4  22.2  107.7\n",
              "\n",
              "[17 rows x 25 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Mkyyyj2WwgGE",
        "colab_type": "text"
      },
      "source": [
        "There total 17 tables in dfRaw dataframe"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "27oSKGrZwCFn",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "152360c6-06fb-4818-a382-f1264747d61e"
      },
      "source": [
        "len(dfRaw)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "17"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pCPGY7rawKOz",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "outputId": "b1d4bc78-d524-40db-eb70-580d703be162"
      },
      "source": [
        "teamState"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            },
            "text/plain": [
              "'https://www.basketball-reference.com/playoffs/NBA_2019.html'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 33
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "afd1q5UKy5w8",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "dfTeamState = pd.read_html(teamState, header=0)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "XaIEyEVezD7G",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 576
        },
        "outputId": "ae867077-b560-4571-d47d-64be5795f218"
      },
      "source": [
        "dfTeamState[16]"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Rk</th>\n",
              "      <th>Team</th>\n",
              "      <th>G</th>\n",
              "      <th>MP</th>\n",
              "      <th>FG</th>\n",
              "      <th>FGA</th>\n",
              "      <th>FG%</th>\n",
              "      <th>3P</th>\n",
              "      <th>3PA</th>\n",
              "      <th>3P%</th>\n",
              "      <th>2P</th>\n",
              "      <th>2PA</th>\n",
              "      <th>2P%</th>\n",
              "      <th>FT</th>\n",
              "      <th>FTA</th>\n",
              "      <th>FT%</th>\n",
              "      <th>ORB</th>\n",
              "      <th>DRB</th>\n",
              "      <th>TRB</th>\n",
              "      <th>AST</th>\n",
              "      <th>STL</th>\n",
              "      <th>BLK</th>\n",
              "      <th>TOV</th>\n",
              "      <th>PF</th>\n",
              "      <th>PTS</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1.0</td>\n",
              "      <td>Toronto Raptors</td>\n",
              "      <td>24</td>\n",
              "      <td>242.1</td>\n",
              "      <td>37.7</td>\n",
              "      <td>84.8</td>\n",
              "      <td>0.444</td>\n",
              "      <td>11.9</td>\n",
              "      <td>34.5</td>\n",
              "      <td>0.346</td>\n",
              "      <td>25.8</td>\n",
              "      <td>50.3</td>\n",
              "      <td>0.512</td>\n",
              "      <td>19.3</td>\n",
              "      <td>23.3</td>\n",
              "      <td>0.830</td>\n",
              "      <td>8.3</td>\n",
              "      <td>34.0</td>\n",
              "      <td>42.3</td>\n",
              "      <td>22.5</td>\n",
              "      <td>8.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>12.0</td>\n",
              "      <td>22.6</td>\n",
              "      <td>106.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2.0</td>\n",
              "      <td>Golden State Warriors</td>\n",
              "      <td>22</td>\n",
              "      <td>242.3</td>\n",
              "      <td>41.1</td>\n",
              "      <td>86.1</td>\n",
              "      <td>0.477</td>\n",
              "      <td>12.2</td>\n",
              "      <td>32.7</td>\n",
              "      <td>0.372</td>\n",
              "      <td>28.9</td>\n",
              "      <td>53.4</td>\n",
              "      <td>0.541</td>\n",
              "      <td>19.8</td>\n",
              "      <td>24.3</td>\n",
              "      <td>0.813</td>\n",
              "      <td>10.1</td>\n",
              "      <td>33.2</td>\n",
              "      <td>43.3</td>\n",
              "      <td>28.4</td>\n",
              "      <td>7.4</td>\n",
              "      <td>5.7</td>\n",
              "      <td>14.9</td>\n",
              "      <td>23.2</td>\n",
              "      <td>114.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3.0</td>\n",
              "      <td>Portland Trail Blazers</td>\n",
              "      <td>16</td>\n",
              "      <td>247.8</td>\n",
              "      <td>39.4</td>\n",
              "      <td>90.4</td>\n",
              "      <td>0.436</td>\n",
              "      <td>11.8</td>\n",
              "      <td>32.8</td>\n",
              "      <td>0.360</td>\n",
              "      <td>27.6</td>\n",
              "      <td>57.6</td>\n",
              "      <td>0.479</td>\n",
              "      <td>19.0</td>\n",
              "      <td>24.8</td>\n",
              "      <td>0.766</td>\n",
              "      <td>11.4</td>\n",
              "      <td>33.8</td>\n",
              "      <td>45.3</td>\n",
              "      <td>19.8</td>\n",
              "      <td>6.8</td>\n",
              "      <td>5.2</td>\n",
              "      <td>12.9</td>\n",
              "      <td>22.8</td>\n",
              "      <td>109.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4.0</td>\n",
              "      <td>Milwaukee Bucks</td>\n",
              "      <td>15</td>\n",
              "      <td>243.3</td>\n",
              "      <td>39.8</td>\n",
              "      <td>88.4</td>\n",
              "      <td>0.450</td>\n",
              "      <td>12.8</td>\n",
              "      <td>38.1</td>\n",
              "      <td>0.336</td>\n",
              "      <td>27.0</td>\n",
              "      <td>50.3</td>\n",
              "      <td>0.536</td>\n",
              "      <td>20.4</td>\n",
              "      <td>28.0</td>\n",
              "      <td>0.729</td>\n",
              "      <td>10.1</td>\n",
              "      <td>41.8</td>\n",
              "      <td>51.9</td>\n",
              "      <td>25.0</td>\n",
              "      <td>6.7</td>\n",
              "      <td>6.4</td>\n",
              "      <td>12.9</td>\n",
              "      <td>21.8</td>\n",
              "      <td>112.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5.0</td>\n",
              "      <td>Denver Nuggets</td>\n",
              "      <td>14</td>\n",
              "      <td>247.1</td>\n",
              "      <td>39.9</td>\n",
              "      <td>90.3</td>\n",
              "      <td>0.442</td>\n",
              "      <td>9.6</td>\n",
              "      <td>27.8</td>\n",
              "      <td>0.344</td>\n",
              "      <td>30.4</td>\n",
              "      <td>62.5</td>\n",
              "      <td>0.486</td>\n",
              "      <td>19.7</td>\n",
              "      <td>25.2</td>\n",
              "      <td>0.782</td>\n",
              "      <td>13.1</td>\n",
              "      <td>34.6</td>\n",
              "      <td>47.7</td>\n",
              "      <td>24.0</td>\n",
              "      <td>5.7</td>\n",
              "      <td>4.6</td>\n",
              "      <td>9.7</td>\n",
              "      <td>21.3</td>\n",
              "      <td>109.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>6.0</td>\n",
              "      <td>Philadelphia 76ers</td>\n",
              "      <td>12</td>\n",
              "      <td>240.0</td>\n",
              "      <td>39.4</td>\n",
              "      <td>85.8</td>\n",
              "      <td>0.459</td>\n",
              "      <td>9.4</td>\n",
              "      <td>28.4</td>\n",
              "      <td>0.331</td>\n",
              "      <td>30.0</td>\n",
              "      <td>57.4</td>\n",
              "      <td>0.522</td>\n",
              "      <td>20.4</td>\n",
              "      <td>25.8</td>\n",
              "      <td>0.790</td>\n",
              "      <td>11.4</td>\n",
              "      <td>37.1</td>\n",
              "      <td>48.5</td>\n",
              "      <td>24.4</td>\n",
              "      <td>6.3</td>\n",
              "      <td>5.5</td>\n",
              "      <td>16.4</td>\n",
              "      <td>22.4</td>\n",
              "      <td>108.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>7.0</td>\n",
              "      <td>Houston Rockets</td>\n",
              "      <td>11</td>\n",
              "      <td>242.3</td>\n",
              "      <td>37.2</td>\n",
              "      <td>83.8</td>\n",
              "      <td>0.444</td>\n",
              "      <td>15.6</td>\n",
              "      <td>42.7</td>\n",
              "      <td>0.366</td>\n",
              "      <td>21.5</td>\n",
              "      <td>41.1</td>\n",
              "      <td>0.524</td>\n",
              "      <td>18.5</td>\n",
              "      <td>24.3</td>\n",
              "      <td>0.764</td>\n",
              "      <td>9.6</td>\n",
              "      <td>33.3</td>\n",
              "      <td>42.9</td>\n",
              "      <td>18.3</td>\n",
              "      <td>8.5</td>\n",
              "      <td>5.1</td>\n",
              "      <td>15.8</td>\n",
              "      <td>21.6</td>\n",
              "      <td>108.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>8.0</td>\n",
              "      <td>Boston Celtics</td>\n",
              "      <td>9</td>\n",
              "      <td>240.0</td>\n",
              "      <td>35.7</td>\n",
              "      <td>84.1</td>\n",
              "      <td>0.424</td>\n",
              "      <td>11.3</td>\n",
              "      <td>33.0</td>\n",
              "      <td>0.343</td>\n",
              "      <td>24.3</td>\n",
              "      <td>51.1</td>\n",
              "      <td>0.476</td>\n",
              "      <td>19.4</td>\n",
              "      <td>24.2</td>\n",
              "      <td>0.803</td>\n",
              "      <td>7.4</td>\n",
              "      <td>40.6</td>\n",
              "      <td>48.0</td>\n",
              "      <td>21.4</td>\n",
              "      <td>5.7</td>\n",
              "      <td>3.9</td>\n",
              "      <td>14.8</td>\n",
              "      <td>20.8</td>\n",
              "      <td>102.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>9.0</td>\n",
              "      <td>San Antonio Spurs</td>\n",
              "      <td>7</td>\n",
              "      <td>240.0</td>\n",
              "      <td>39.4</td>\n",
              "      <td>85.1</td>\n",
              "      <td>0.463</td>\n",
              "      <td>6.7</td>\n",
              "      <td>19.9</td>\n",
              "      <td>0.338</td>\n",
              "      <td>32.7</td>\n",
              "      <td>65.3</td>\n",
              "      <td>0.501</td>\n",
              "      <td>17.7</td>\n",
              "      <td>23.0</td>\n",
              "      <td>0.770</td>\n",
              "      <td>10.7</td>\n",
              "      <td>34.4</td>\n",
              "      <td>45.1</td>\n",
              "      <td>21.1</td>\n",
              "      <td>4.6</td>\n",
              "      <td>4.0</td>\n",
              "      <td>8.4</td>\n",
              "      <td>19.4</td>\n",
              "      <td>103.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>10.0</td>\n",
              "      <td>Los Angeles Clippers</td>\n",
              "      <td>6</td>\n",
              "      <td>240.0</td>\n",
              "      <td>39.8</td>\n",
              "      <td>89.2</td>\n",
              "      <td>0.447</td>\n",
              "      <td>11.5</td>\n",
              "      <td>31.7</td>\n",
              "      <td>0.363</td>\n",
              "      <td>28.3</td>\n",
              "      <td>57.5</td>\n",
              "      <td>0.493</td>\n",
              "      <td>23.5</td>\n",
              "      <td>28.8</td>\n",
              "      <td>0.815</td>\n",
              "      <td>10.0</td>\n",
              "      <td>30.2</td>\n",
              "      <td>40.2</td>\n",
              "      <td>25.3</td>\n",
              "      <td>8.0</td>\n",
              "      <td>3.3</td>\n",
              "      <td>15.0</td>\n",
              "      <td>25.0</td>\n",
              "      <td>114.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>11.0</td>\n",
              "      <td>Brooklyn Nets</td>\n",
              "      <td>5</td>\n",
              "      <td>240.0</td>\n",
              "      <td>38.4</td>\n",
              "      <td>91.4</td>\n",
              "      <td>0.420</td>\n",
              "      <td>11.0</td>\n",
              "      <td>34.0</td>\n",
              "      <td>0.324</td>\n",
              "      <td>27.4</td>\n",
              "      <td>57.4</td>\n",
              "      <td>0.477</td>\n",
              "      <td>23.6</td>\n",
              "      <td>29.2</td>\n",
              "      <td>0.808</td>\n",
              "      <td>11.4</td>\n",
              "      <td>29.2</td>\n",
              "      <td>40.6</td>\n",
              "      <td>19.2</td>\n",
              "      <td>7.4</td>\n",
              "      <td>2.8</td>\n",
              "      <td>14.2</td>\n",
              "      <td>22.8</td>\n",
              "      <td>111.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>12.0</td>\n",
              "      <td>Oklahoma City Thunder</td>\n",
              "      <td>5</td>\n",
              "      <td>240.0</td>\n",
              "      <td>37.8</td>\n",
              "      <td>86.0</td>\n",
              "      <td>0.440</td>\n",
              "      <td>10.4</td>\n",
              "      <td>31.4</td>\n",
              "      <td>0.331</td>\n",
              "      <td>27.4</td>\n",
              "      <td>54.6</td>\n",
              "      <td>0.502</td>\n",
              "      <td>19.2</td>\n",
              "      <td>25.4</td>\n",
              "      <td>0.756</td>\n",
              "      <td>10.2</td>\n",
              "      <td>33.0</td>\n",
              "      <td>43.2</td>\n",
              "      <td>22.6</td>\n",
              "      <td>6.6</td>\n",
              "      <td>5.4</td>\n",
              "      <td>15.2</td>\n",
              "      <td>24.2</td>\n",
              "      <td>105.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>13.0</td>\n",
              "      <td>Utah Jazz</td>\n",
              "      <td>5</td>\n",
              "      <td>240.0</td>\n",
              "      <td>34.6</td>\n",
              "      <td>86.4</td>\n",
              "      <td>0.400</td>\n",
              "      <td>9.4</td>\n",
              "      <td>35.8</td>\n",
              "      <td>0.263</td>\n",
              "      <td>25.2</td>\n",
              "      <td>50.6</td>\n",
              "      <td>0.498</td>\n",
              "      <td>19.2</td>\n",
              "      <td>25.6</td>\n",
              "      <td>0.750</td>\n",
              "      <td>11.8</td>\n",
              "      <td>35.4</td>\n",
              "      <td>47.2</td>\n",
              "      <td>23.0</td>\n",
              "      <td>9.2</td>\n",
              "      <td>5.4</td>\n",
              "      <td>15.2</td>\n",
              "      <td>21.8</td>\n",
              "      <td>97.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>14.0</td>\n",
              "      <td>Orlando Magic</td>\n",
              "      <td>5</td>\n",
              "      <td>240.0</td>\n",
              "      <td>32.2</td>\n",
              "      <td>83.0</td>\n",
              "      <td>0.388</td>\n",
              "      <td>10.4</td>\n",
              "      <td>34.8</td>\n",
              "      <td>0.299</td>\n",
              "      <td>21.8</td>\n",
              "      <td>48.2</td>\n",
              "      <td>0.452</td>\n",
              "      <td>17.2</td>\n",
              "      <td>22.2</td>\n",
              "      <td>0.775</td>\n",
              "      <td>9.6</td>\n",
              "      <td>33.8</td>\n",
              "      <td>43.4</td>\n",
              "      <td>19.0</td>\n",
              "      <td>6.6</td>\n",
              "      <td>4.0</td>\n",
              "      <td>15.6</td>\n",
              "      <td>18.8</td>\n",
              "      <td>92.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>15.0</td>\n",
              "      <td>Detroit Pistons</td>\n",
              "      <td>4</td>\n",
              "      <td>240.0</td>\n",
              "      <td>37.5</td>\n",
              "      <td>96.8</td>\n",
              "      <td>0.388</td>\n",
              "      <td>11.0</td>\n",
              "      <td>33.3</td>\n",
              "      <td>0.331</td>\n",
              "      <td>26.5</td>\n",
              "      <td>63.5</td>\n",
              "      <td>0.417</td>\n",
              "      <td>12.0</td>\n",
              "      <td>16.5</td>\n",
              "      <td>0.727</td>\n",
              "      <td>10.8</td>\n",
              "      <td>31.5</td>\n",
              "      <td>42.3</td>\n",
              "      <td>23.0</td>\n",
              "      <td>7.3</td>\n",
              "      <td>4.0</td>\n",
              "      <td>10.5</td>\n",
              "      <td>24.3</td>\n",
              "      <td>98.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>16.0</td>\n",
              "      <td>Indiana Pacers</td>\n",
              "      <td>4</td>\n",
              "      <td>240.0</td>\n",
              "      <td>33.5</td>\n",
              "      <td>83.5</td>\n",
              "      <td>0.401</td>\n",
              "      <td>10.0</td>\n",
              "      <td>29.8</td>\n",
              "      <td>0.336</td>\n",
              "      <td>23.5</td>\n",
              "      <td>53.8</td>\n",
              "      <td>0.437</td>\n",
              "      <td>14.8</td>\n",
              "      <td>20.5</td>\n",
              "      <td>0.720</td>\n",
              "      <td>8.0</td>\n",
              "      <td>32.3</td>\n",
              "      <td>40.3</td>\n",
              "      <td>20.8</td>\n",
              "      <td>8.3</td>\n",
              "      <td>3.5</td>\n",
              "      <td>12.0</td>\n",
              "      <td>20.0</td>\n",
              "      <td>91.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>NaN</td>\n",
              "      <td>League Average</td>\n",
              "      <td>10</td>\n",
              "      <td>242.4</td>\n",
              "      <td>38.5</td>\n",
              "      <td>87.0</td>\n",
              "      <td>0.443</td>\n",
              "      <td>11.4</td>\n",
              "      <td>32.9</td>\n",
              "      <td>0.345</td>\n",
              "      <td>27.1</td>\n",
              "      <td>54.0</td>\n",
              "      <td>0.502</td>\n",
              "      <td>19.4</td>\n",
              "      <td>24.7</td>\n",
              "      <td>0.784</td>\n",
              "      <td>10.2</td>\n",
              "      <td>34.8</td>\n",
              "      <td>45.0</td>\n",
              "      <td>23.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>4.9</td>\n",
              "      <td>13.4</td>\n",
              "      <td>22.2</td>\n",
              "      <td>107.7</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      Rk                    Team   G     MP    FG  ...  STL  BLK   TOV    PF    PTS\n",
              "0    1.0         Toronto Raptors  24  242.1  37.7  ...  8.0  4.6  12.0  22.6  106.6\n",
              "1    2.0   Golden State Warriors  22  242.3  41.1  ...  7.4  5.7  14.9  23.2  114.1\n",
              "2    3.0  Portland Trail Blazers  16  247.8  39.4  ...  6.8  5.2  12.9  22.8  109.7\n",
              "3    4.0         Milwaukee Bucks  15  243.3  39.8  ...  6.7  6.4  12.9  21.8  112.8\n",
              "4    5.0          Denver Nuggets  14  247.1  39.9  ...  5.7  4.6   9.7  21.3  109.1\n",
              "5    6.0      Philadelphia 76ers  12  240.0  39.4  ...  6.3  5.5  16.4  22.4  108.7\n",
              "6    7.0         Houston Rockets  11  242.3  37.2  ...  8.5  5.1  15.8  21.6  108.5\n",
              "7    8.0          Boston Celtics   9  240.0  35.7  ...  5.7  3.9  14.8  20.8  102.1\n",
              "8    9.0       San Antonio Spurs   7  240.0  39.4  ...  4.6  4.0   8.4  19.4  103.3\n",
              "9   10.0    Los Angeles Clippers   6  240.0  39.8  ...  8.0  3.3  15.0  25.0  114.7\n",
              "10  11.0           Brooklyn Nets   5  240.0  38.4  ...  7.4  2.8  14.2  22.8  111.4\n",
              "11  12.0   Oklahoma City Thunder   5  240.0  37.8  ...  6.6  5.4  15.2  24.2  105.2\n",
              "12  13.0               Utah Jazz   5  240.0  34.6  ...  9.2  5.4  15.2  21.8   97.8\n",
              "13  14.0           Orlando Magic   5  240.0  32.2  ...  6.6  4.0  15.6  18.8   92.0\n",
              "14  15.0         Detroit Pistons   4  240.0  37.5  ...  7.3  4.0  10.5  24.3   98.0\n",
              "15  16.0          Indiana Pacers   4  240.0  33.5  ...  8.3  3.5  12.0  20.0   91.8\n",
              "16   NaN          League Average  10  242.4  38.5  ...  7.0  4.9  13.4  22.2  107.7\n",
              "\n",
              "[17 rows x 25 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 45
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1F9f9JbqwNqM",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "dfTeamState1 = dfTeamState[16]"
      ],
      "execution_count": 52,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "q9IB4b61wb3C",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "26cd3924-c27c-4f08-b09f-e4c6bedab479"
      },
      "source": [
        "type(dfTeamState1['G'])"
      ],
      "execution_count": 59,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "pandas.core.series.Series"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 59
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "sAShwL_jxx9g",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "4134459c-50f9-4d54-9ce5-290d3b45c4cc"
      },
      "source": [
        "type([dfTeamState1['G']])"
      ],
      "execution_count": 64,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "list"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 64
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DPgry_G7xJxH",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "866fed24-1816-450b-dbfa-4d65c5bca25a"
      },
      "source": [
        "type(dfTeamState1[['G']])"
      ],
      "execution_count": 62,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "pandas.core.frame.DataFrame"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 62
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "skG9FhOYzIGG",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 71
        },
        "outputId": "852422d8-f639-4aa5-f1b1-e1329784d9be"
      },
      "source": [
        "import seaborn as sns"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.6/dist-packages/statsmodels/tools/_testing.py:19: FutureWarning: pandas.util.testing is deprecated. Use the functions in the public API at pandas.testing instead.\n",
            "  import pandas.util.testing as tm\n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZBZBHqlg33ut",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 296
        },
        "outputId": "f1ff3ed6-8c3d-4a7a-8e18-d790271e9a56"
      },
      "source": [
        "sns.distplot(dfTeamState[16].PTS, \n",
        "             kde=False)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f1af0973860>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 46
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWoAAAEGCAYAAABM7t/CAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAM8ElEQVR4nO3df4xld13G8eeh0yoIWmGvpWk7TJXaCMRuy2SxIlVLxLYWK/6IBX+AIY4m1rTRaEpMDPqfib8JYBZbtmqXahC0QShFpLQkdnGmbNvdLoW2QmlTurOgwCLZutvHP86Z3cv07s6Z9Z57P5l5v5KbuffcMzOffnv3nTtnzr3jJAIA1PWsaQ8AADgxQg0AxRFqACiOUANAcYQaAIqb6eOLbtmyJXNzc318aQDYkJaWlg4kGYy6r5dQz83NaXFxsY8vDQAbku3PH+8+Dn0AQHGEGgCKI9QAUByhBoDiCDUAFEeoAaC4TqG2fbrt99r+tO19ti/uezAAQKPredR/Iem2JD9r+zRJz+lxJgDAkDVDbfs7JF0i6U2SlOQpSU/1OxYAYEWXZ9TnSlqW9G7bF0haknRtkq8P72R7QdKCJM3Ozo57TmAsdu56dNojYAN7wyv6aV+XY9Qzki6S9M4kF0r6uqTrV++UZHuS+STzg8HIl6sDAE5Cl1A/JumxJLva2+9VE24AwASsGeokX5T0Bdvnt5teLemBXqcCABzV9ayP35R0c3vGxyOSfqW/kQAAwzqFOsluSfM9zwIAGIFXJgJAcYQaAIoj1ABQHKEGgOIINQAUR6gBoDhCDQDFEWoAKI5QA0BxhBoAiiPUAFAcoQaA4gg1ABRHqAGgOEINAMURagAojlADQHGEGgCKI9QAUByhBoDiCDUAFEeoAaA4Qg0AxRFqACiOUANAcTNddrL9OUlfk3RE0uEk830OBQA4plOoWz+a5EBvkwAARuLQBwAU1zXUkXS77SXbC6N2sL1ge9H24vLy8vgmBIBNrmuofyjJRZIul/Qbti9ZvUOS7Unmk8wPBoOxDgkAm1mnUCd5vP24X9L7JW3rcygAwDFrhtr2t9l+3sp1Sa+RtKfvwQAAjS5nfZwh6f22V/bfmeS2XqcCABy1ZqiTPCLpggnMAgAYgdPzAKA4Qg0AxRFqACiOUANAcYQaAIoj1ABQHKEGgOIINQAUR6gBoDhCDQDFEWoAKI5QA0BxhBoAiiPUAFAcoQaA4gg1ABRHqAGgOEINAMURagAojlADQHGEGgCKI9QAUByhBoDiCDUAFEeoAaA4Qg0AxXUOte1TbH/K9gf6HAgA8M3W84z6Wkn7+hoEADBap1DbPlvST0j6637HAQCs1vUZ9Z9L+l1JTx9vB9sLthdtLy4vL49lOABAh1DbvlLS/iRLJ9ovyfYk80nmB4PB2AYEgM2uyzPqV0r6Sdufk3SLpEtt/12vUwEAjloz1EnekuTsJHOSrpb0b0l+sffJAACSOI8aAMqbWc/OSe6QdEcvkwAARuIZNQAUR6gBoDhCDQDFEWoAKI5QA0BxhBoAiiPUAFAcoQaA4gg1ABRHqAGgOEINAMURagAojlADQHGEGgCKI9QAUByhBoDiCDUAFEeoAaA4Qg0AxRFqACiOUANAcYQaAIoj1ABQHKEGgOIINQAUt2aobX+r7U/avtf2Xtt/MInBAACNmQ77HJJ0aZKDtk+V9AnbH0pyd8+zAQDUIdRJIulge/PU9pI+hwIAHNPlGbVsnyJpSdKLJb09ya4R+yxIWpCk2dnZcc6IE9i569FpjwCgZ51+mZjkSJKtks6WtM32y0bssz3JfJL5wWAw7jkBYNNa11kfSf5b0sckXdbPOACA1bqc9TGwfXp7/dmSfkzSp/seDADQ6HKM+kxJN7XHqZ8l6R+SfKDfsQAAK7qc9XGfpAsnMAsAYARemQgAxRFqACiOUANAcYQaAIoj1ABQHKEGgOIINQAUR6gBoDhCDQDFEWoAKI5QA0BxhBoAiiPUAFAcoQaA4gg1ABRHqAGgOEINAMURagAojlADQHGEGgCKI9QAUByhBoDiCDUAFEeoAaA4Qg0AxRFqAChuzVDbPsf2x2w/YHuv7WsnMRgAoDHTYZ/Dkn47yT22nydpyfZHkjzQ82wAAHV4Rp3kiST3tNe/JmmfpLP6HgwA0OjyjPoo23OSLpS0a8R9C5IWJGl2dvakB9q569GT/lwA2Ig6/zLR9nMl/aOk65J8dfX9SbYnmU8yPxgMxjkjAGxqnUJt+1Q1kb45yfv6HQkAMKzLWR+WdIOkfUn+tP+RAADDujyjfqWkX5J0qe3d7eWKnucCALTW/GVikk9I8gRmAQCMwCsTAaA4Qg0AxRFqACiOUANAcYQaAIoj1ABQHKEGgOIINQAUR6gBoDhCDQDFEWoAKI5QA0BxhBoAiiPUAFAcoQaA4gg1ABRHqAGgOEINAMURagAojlADQHGEGgCKI9QAUByhBoDiCDUAFEeoAaC4NUNt+0bb+23vmcRAAIBv1uUZ9Q5Jl/U8BwDgONYMdZI7JX15ArMAAEYY2zFq2wu2F20vLi8vj+vLAsCmN7ZQJ9meZD7J/GAwGNeXBYBNj7M+AKA4Qg0AxXU5Pe89kv5d0vm2H7P95v7HAgCsmFlrhySvn8QgAIDROPQBAMURagAojlADQHGEGgCKI9QAUByhBoDiCDUAFEeoAaA4Qg0AxRFqACiOUANAcYQaAIoj1ABQHKEGgOIINQAUR6gBoDhCDQDFEWoAKI5QA0BxhBoAiiPUAFAcoQaA4gg1ABRHqAGgOEINAMURagAorlOobV9m+0HbD9m+vu+hAADHrBlq26dIerukyyW9RNLrbb+k78EAAI0uz6i3SXooySNJnpJ0i6Sr+h0LALBipsM+Z0n6wtDtxyS9YvVOthckLbQ3D9p+8P8/XmlbJB2Y9hBFsBYN1uGYTbkWv/DMTetZhxcd744uoe4kyXZJ28f19aqzvZhkftpzVMBaNFiHY1iLxrjWocuhj8clnTN0++x2GwBgArqE+j8knWf7XNunSbpa0q39jgUAWLHmoY8kh21fI+nDkk6RdGOSvb1PVt+mOczTAWvRYB2OYS0aY1kHJxnH1wEA9IRXJgJAcYQaAIoj1B3Zvtb2Htt7bV/Xbnur7cdt724vV0x7znGzfaPt/bb3DG17vu2P2P5s+/E72+22/ZftWw3cZ/ui6U0+futcix+x/ZWhx8bvT2/y8TrOOvxc+2/jadvzq/Z/S/uYeND2j09+4v6sZy1sz9n+xtBj4q+6fh9C3YHtl0n6VTWv0rxA0pW2X9ze/WdJtraXD05tyP7skHTZqm3XS/pokvMkfbS9LTVvM3Bee1mQ9M4JzTgpO9R9LSTprqHHxh9OaMZJ2KFnrsMeST8t6c7hje3bTVwt6aXt57yjfVuKjWKHOq5F6+Ghx8Svd/0mhLqb75O0K8n/JDks6eNq/kdseEnulPTlVZuvknRTe/0mST81tP1v0rhb0um2z5zMpP1b51psWKPWIcm+JKNejXyVpFuSHEryn5IeUvOEZ0NY51qcNELdzR5Jr7L9AtvPkXSFjr0I6Jr2x/wbV37s3QTOSPJEe/2Lks5or496u4GzJjnYFBxvLSTpYtv32v6Q7ZdOYbYKNuNj4kTOtf0p2x+3/aqun0SoO0iyT9IfSbpd0m2Sdks6ouZH+++RtFXSE5L+ZFozTkua8zs5x1PPWIt7JL0oyQWS3ibpn6Y2GKp4QtJskgsl/Zaknba/vcsnEuqOktyQ5OVJLpH0X5I+k+TJJEeSPC3pXdpAP9Kt4cmVQxrtx/3t9s34dgMj1yLJV5McbK9/UNKptrdMb8yp2YyPiZHawz9faq8vSXpY0vd2+VxC3ZHt72o/zqo5Pr1z1fHX16k5RLIZ3Crpje31N0r656Htv9ye/fEDkr4ydFhgoxq5FrZfaNvt9W1q/q19aSoTTtetkq62/S22z1Xzi+ZPTnmmqbA9WPlFqu3vVrMWj3T65CRcOlwk3SXpAUn3Snp1u+1vJd0v6T41D8gzpz1nD//d71HzI9v/qjm++GZJL1BzhsNnJf2rpOe3+1rNH5l4uF2X+WnPP8W1uEbS3vbxcrekH5z2/D2vw+va64ckPSnpw0P7/177mHhQ0uXTnn9aayHpZ9rHxG41h8Ze2/X78BJyACiOQx8AUByhBoDiCDUAFEeoAaA4Qg0AxY3tj9sCFdg+oubUwBlJ+yRdJ+lf2rtfqOYVpcvt7W2SfkfSG9rtT0v6tSS7JjkzsBZCjY3mG0m2SpLtmyX9/NDtt0o6mOSP29sXS7pS0kVJDrWvHDxtOmMDx0eosZHdJen7T3D/mZIOJDkkSUkOTGQqYJ04Ro0NyfaMmvfHvv8Eu90u6Rzbn7H9Dts/PJnpgPUh1Nhonm17t6RFSY9KuuF4O6Z506SXq/kjB8uS/t72myYxJLAeHPrARnP0GHUXSY5IukPSHbbvV/PGSjv6GQ04OTyjxqZl+3zb5w1t2irp89OaBzgenlFjM3uupLfZPl3SYTV/JmphuiMBz8S75wFAcRz6AIDiCDUAFEeoAaA4Qg0AxRFqACiOUANAcYQaAIr7P8tOkeF86z+kAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gKCp3H-p4A8Y",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 296
        },
        "outputId": "55a50060-d6f6-4201-cccd-8dabb363347a"
      },
      "source": [
        "sns.distplot(dfTeamState[16].PTS, \n",
        "             kde=False,\n",
        "             hist_kws=dict(edgecolor=\"black\", linewidth=2))"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f1af08bce10>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 47
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWoAAAEGCAYAAABM7t/CAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAANkklEQVR4nO3deYycdR3H8c/HLvXAo2JXJMK6VZF4RApOqnhULVELouAVgXhGHU3EQDQajNGo/5l4G4+MgkWlolFBgsihiAuJtO7qAi0tylEFUum29UK02vL1j+dpOy7T7rN1nnm+3X2/ks3O8ezslx/Td5599plZR4QAAHk9pOkBAAD7R6gBIDlCDQDJEWoASI5QA0ByQ3U86OLFi2N0dLSOhwaAOWliYmJrRAz3uq+WUI+Ojmp8fLyOhwaAOcn2H/Z1H4c+ACA5Qg0AyRFqAEiOUANAcoQaAJIj1ACQXKVQ215k+we2N9reYPuEugcDABSqnkf9BUlXRMTrbS+U9IgaZwIAdJkx1LYfI2m5pLdJUkT8W9K/6x0L6L9Op9P0CAeVsbExSdLy5csbnuTg0m63+/6YVfaol0iakvRN28dKmpB0dkT8o3sj221JbUkaGRnp95xAX6y9c3vTIxw0Nm27XwsOXcSazcKyJYfV8rhVQj0k6XhJ74uINba/IOlcSR/t3igiOpI6ktRqtfizMUhrxWlnNj3CQWHj5FpJrFdV11yyurbHrvLLxLsl3R0Ra8rrP1ARbgDAAMwY6oj4k6S7bB9T3nSipFtqnQoAsEfVsz7eJ+nC8oyPOyS9vb6RAADdKoU6IiYltWqeBQDQA69MBIDkCDUAJEeoASA5Qg0AyRFqAEiOUANAcoQaAJIj1ACQHKEGgOQINQAkR6gBIDlCDQDJEWoASI5QA0ByhBoAkiPUAJAcoQaA5Ag1ACRHqAEgOUINAMkRagBIjlADQHKEGgCSI9QAkByhBoDkhqpsZHuTpL9L2iVpZ0S06hwKALBXpVCXXhoRW2ubBADQE4c+ACC5qqEOSVfZnrDd7rWB7bbtcdvjU1NT/ZsQAOa5qqF+YUQcL+kkSe+1vXz6BhHRiYhWRLSGh4f7OiQAzGeVQh0R95Sft0i6WNKyOocCAOw1Y6htH2r7UbsvS3q5pHV1DwYAKFQ56+NwSRfb3r396oi4otapAAB7zBjqiLhD0rEDmAUA0AOn5wFAcoQaAJIj1ACQHKEGgOQINQAkR6gBIDlCDQDJEWoASI5QA0ByhBoAkiPUAJAcoQaA5Ag1ACRHqAEgOUINAMkRagBIjlADQHKEGgCSI9QAkByhBoDkCDUAJEeoASA5Qg0AyRFqAEiOUANAcoQaAJKrHGrbC2z/1vZldQ4EAPhfs9mjPlvShroGAQD0VinUto+U9EpJ36h3HADAdFX3qD8v6UOSHtjXBrbbtsdtj09NTfVlOABAhVDbPkXSloiY2N92EdGJiFZEtIaHh/s2IADMd1X2qF8g6dW2N0m6SNIK29+pdSoAwB4zhjoiPhwRR0bEqKTTJV0TEW+qfTIAgCTOowaA9IZms3FEXCvp2lomAQD0xB41ACRHqAEgOUINAMkRagBIjlADQHKEGgCSI9QAkByhBoDkCDUAJEeoASA5Qg0AyRFqAEiOUANAcoQaAJIj1ACQHKEGgOQINQAkR6gBIDlCDQDJEWoASI5QA0ByhBoAkiPUAJAcoQaA5Ag1ACQ3Y6htP8z2Wts32l5v+xODGAwAUBiqsM0OSSsi4j7bh0i63vZPI+KGmmcDAKhCqCMiJN1XXj2k/Ig6h0I1nU6n6REOKmNjY7rrXwu1oulBgFmqskct2wskTUh6qqQvR8SaHtu0JbUlaWRkpJ8zYj/W3rm96REOGpu23a8Fhy5segxg1iqFOiJ2SVpqe5Gki20/KyLWTdumI6kjSa1Wiz3uAVpx2plNj3BQ2Di5tukRgAMyq7M+IuIvkn4haWU94wAApqty1sdwuSct2w+X9DJJG+seDABQqHLo4whJF5THqR8i6fsRcVm9YwEAdqty1sdNko4bwCwAgB54ZSIAJEeoASA5Qg0AyRFqAEiOUANAcoQaAJIj1ACQHKEGgOQINQAkR6gBIDlCDQDJEWoASI5QA0ByhBoAkiPUAJAcoQaA5Ag1ACRHqAEgOUINAMkRagBIjlADQHKEGgCSI9QAkByhBoDkCDUAJEeoASC5GUNt+yjbv7B9i+31ts8exGAAgMJQhW12SvpARPzG9qMkTdi+OiJuqXk2AIAqhDoiNkvaXF7+u+0Nkp4oqe+h7nQ6/X7IOW1sbEx3/WuhVjQ9CIBaVdmj3sP2qKTjJK3pcV9bUluSRkZGDnigtXduP+CvnW82bbtfCw5d2PQYAGpWOdS2Hynph5LOiYi/Tb8/IjqSOpLUarXi/xlqxWln/j9fPm9snFzb9AgABqDSWR+2D1ER6Qsj4kf1jgQA6FblrA9LOk/Shoj4bP0jAQC6VdmjfoGkN0taYXuy/Di55rkAAKUqZ31cL8kDmAUA0AOvTASA5Ag1ACRHqAEgOUINAMkRagBIjlADQHKEGgCSI9QAkByhBoDkCDUAJEeoASA5Qg0AyRFqAEiOUANAcoQaAJIj1ACQHKEGgOQINQAkR6gBIDlCDQDJEWoASI5QA0ByhBoAkiPUAJAcoQaA5GYMte3zbW+xvW4QAwEA/leVPepVklbWPAcAYB9mDHVEjEnaPoBZAAA99O0Yte227XHb41NTU/16WACY9/oW6ojoREQrIlrDw8P9elgAmPc46wMAkiPUAJBcldPzvivpV5KOsX237XfUPxYAYLehmTaIiDMGMQgAoDcOfQBAcoQaAJIj1ACQHKEGgOQINQAkR6gBIDlCDQDJEWoASI5QA0ByhBoAkiPUAJAcoQaA5Ag1ACRHqAEgOUINAMkRagBIjlADQHKEGgCSI9QAkByhBoDkCDUAJEeoASA5Qg0AyRFqAEiOUANAcoQaAJKrFGrbK23favs22+fWPRQAYK8ZQ217gaQvSzpJ0jMknWH7GXUPBgAoDFXYZpmk2yLiDkmyfZGkUyXdUtdQ11yyuq6HnpNYr9lhvWaH9WqeI2L/G9ivl7QyIt5ZXn+zpOdGxFnTtmtLapdXj5F0a//HTWWxpK1ND5EEa1FgHfZiLQqzWYcnRcRwrzuq7FFXEhEdSZ1+PV52tscjotX0HBmwFgXWYS/WotCvdajyy8R7JB3Vdf3I8jYAwABUCfWvJR1te4nthZJOl3RpvWMBAHab8dBHROy0fZakKyUtkHR+RKyvfbL85s1hngpYiwLrsBdrUejLOsz4y0QAQLN4ZSIAJEeoASA5Ql2R7bNtr7O93vY55W0ft32P7cny4+Sm5+w32+fb3mJ7Xddth9m+2vbvy8+PLW+37S+WbzVwk+3jm5u8/2a5Fi+x/deu58bHmpu8v/axDm8o/208YLs1bfsPl8+JW22/YvAT12c2a2F71PY/u54TX6v6fQh1BbafJeldKl6leaykU2w/tbz7cxGxtPy4vLEh67NK0sppt50r6ecRcbSkn5fXpeJtBo4uP9qSvjqgGQdllaqvhSRd1/Xc+OSAZhyEVXrwOqyT9FpJY903lm83cbqkZ5Zf85XybSnmilWquBal27ueE++p+k0IdTVPl7QmIu6PiJ2Sfqnif8ScFxFjkrZPu/lUSReUly+QdFrX7d+Kwg2SFtk+YjCT1m+WazFn9VqHiNgQEb1ejXyqpIsiYkdE3CnpNhU7PHPCLNfigBHqatZJepHtx9l+hKSTtfdFQGeVP+afv/vH3nng8IjYXF7+k6TDy8tPlHRX13Z3l7fNZftaC0k6wfaNtn9q+5kNzJbBfHxO7M8S27+1/UvbL6r6RYS6gojYIOlTkq6SdIWkSUm7VPxo/xRJSyVtlvSZpmZsShTnd3KOpx60Fr9R8d4Nx0r6kqRLGhsMWWyWNBIRx0l6v6TVth9d5QsJdUURcV5EPCcilkv6s6TfRcS9EbErIh6Q9HXNoR/pZnDv7kMa5ect5e3z8e0Geq5FRPwtIu4rL18u6RDbi5sbszHz8TnRU3n4Z1t5eULS7ZKeVuVrCXVFth9ffh5RcXx69bTjr69RcYhkPrhU0lvLy2+V9OOu299Snv3xPEl/7TosMFf1XAvbT7Dt8vIyFf/WtjUyYbMulXS67YfaXqLiF81rG56pEbaHd/8i1faTVazFHZW+OCL4qPAh6ToV78F9o6QTy9u+LelmSTepeEIe0fScNfx3f1fFj2z/UXF88R2SHqfiDIffS/qZpMPKba3ij0zcXq5Lq+n5G1yLsyStL58vN0h6ftPz17wOrykv75B0r6Qru7b/SPmcuFXSSU3P39RaSHpd+ZyYVHFo7FVVvw8vIQeA5Dj0AQDJEWoASI5QA0ByhBoAkiPUAJBc3/64LZCB7V0qTg0ckrRB0jmSflLe/QQVryidKq8vk/RBSWeWtz8g6d0RsWaQMwMzIdSYa/4ZEUslyfaFkt7Ydf3jku6LiE+X10+QdIqk4yNiR/nKwYXNjA3sG6HGXHadpGfv5/4jJG2NiB2SFBFbBzIVMEsco8acZHtIxftj37yfza6SdJTt39n+iu0XD2Y6YHYINeaah9uelDQu6Y+SztvXhlG8adJzVPyRgylJ37P9tkEMCcwGhz4w1+w5Rl1FROySdK2ka23frOKNlVbVMxpwYNijxrxl+xjbR3fdtFTSH5qaB9gX9qgxnz1S0pdsL5K0U8WfiWo3OxLwYLx7HgAkx6EPAEiOUANAcoQaAJIj1ACQHKEGgOQINQAkR6gBILn/Aio4v55wNqfnAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "rrpgsYj19SBk",
        "colab_type": "text"
      },
      "source": [
        "#### Building Dataset\n",
        "Code for extracting Raw Data"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "z9auw1rs42fU",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 52
        },
        "outputId": "ba7347ac-cb4d-4284-cca7-513718352882"
      },
      "source": [
        "'''\n",
        "records = []\n",
        "\n",
        "for content in soupObject:\n",
        "  date = content.find('class-name').text[:-1]+'2017'\n",
        "  centiment = content.contents[1][1:-2]\n",
        "  para = content.find('p', attrs={'class':'speach'}).text[1:-1]\n",
        "  url = content.find('a')['href']\n",
        "  records.append((date, centiment, para, url))\n",
        "'''"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            },
            "text/plain": [
              "\"\\nrecords = []\\n\\nfor content in soupObject:\\n  date = content.find('class-name').text[:-1]+'2017'\\n  centiment = content.contents[1][1:-2]\\n  para = content.find('p', attrs={'class':'speach'}).text[1:-1]\\n  url = content.find('a')['href']\\n  records.append((date, centiment, para, url))\\n\""
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 48
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "DurXwMBVCMwt",
        "colab_type": "text"
      },
      "source": [
        "Exporting records[] array to panadas dataframe\n",
        "### Dataframe"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9IAh33nPBO7t",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "outputId": "119b9758-e014-4a64-c2ee-1530b68af8bb"
      },
      "source": [
        "'''\n",
        "ndf = pd.DataFrame(records, columns=['date', 'centiment', 'para', 'url'])\n",
        "'''"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            },
            "text/plain": [
              "\"\\nndf = pd.DataFrame(records, columns=['date', 'centiment', 'para', 'url'])\\n\""
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 49
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "U80xljsiGDw2",
        "colab_type": "text"
      },
      "source": [
        "### Merging two dataframes "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "f3VulyXJDijL",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "outputId": "f4cb4152-fd81-451d-bb2f-92ca2200ee34"
      },
      "source": [
        "'''\n",
        "new_df = pd.merge(A_df, B_df,  how='left', left_on=['A_c1','c2'], right_on = ['B_c1','c2'])\n",
        "\n",
        "# or we can use this syntaxt\n",
        "\n",
        "new_df = A_df.merge(B_df, left_on=['A_c1','c2'], right_on = ['B_c1','c2'], how='left'\n",
        "'''"
      ],
      "execution_count": 65,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            },
            "text/plain": [
              "\"\\nnew_df = pd.merge(A_df, B_df,  how='left', left_on=['A_c1','c2'], right_on = ['B_c1','c2'])\\n\""
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 65
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "MyNKjvVLGbGW",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}