Web_Scrapping_para_Basquete.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Web Scrapping para Basquete.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "authorship_tag": "ABX9TyNP0Bk0kRaLHOoqRLMXeD6l"
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "source": [
        "---\n",
        "<img alt=\"Colaboratory logo\" width=\"15%\" src=\"https://i.postimg.cc/8CdBQXmP/JPLavor.png\">\n",
        "\n",
        "#### **Data Science**\n",
        "*by [jplavorr](https://linktr.ee/jplavorr)*  \n",
        "\n",
        "---"
      ],
      "metadata": {
        "id": "dnUmFcTTMjMN"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "#Web Scraping para Esportes\n",
        "\n",
        "Quando comecei a procurar DataSets relacionados as ligas esportivas e as estatisticas de seus jogadores, acabei me deparando com um problema. Por mais que eu encontrasse tais DataSets no Kaggle, eles não continham as informações completas ou não apresentavam colunas nos quais eu gostaria de analisar. Foi aí que percebi que às vezes, nem todos os dados estão disponíveis para nós de forma prática. Para continuar um determinado projeto de análise de dados, devemos fazer um pouco mais para obter os dados apropriados e atualizados de que precisamos.\n",
        "\n",
        "Logo, isso nos tras no tópico desse artigo, **Web Scraping**, que será usado para criar DataSets que iremos usar futuramente na série de artigos sobre Data Science aplicada nos esportes. Esse artigo servirá como base sobre como iremos extrair as informações estatísticas dos jogos e temporadas para realizar as analises que irão ocorrer. \n",
        "\n",
        "Para reunir as informações de todas as estatísticas de variados esportes, iremos usar o site [Sports Reference](https://www.sports-reference.com/). Este site é essencialmente uma enciclopédia para todas as coisas sobre estatísticas de esportes. Aí veio a minha próxima pergunta: Por que não pegar os dados diretamente da Referência do Basquete? Depois de mais pesquisas, descobri uma ótima biblioteca Python que resolveu esta parte do meu projeto: BeautifulSoup. Esta biblioteca é um raspador da web que nos permite pesquisar o HTML de uma página da web e extrair as informações de que precisamos. A partir daí, armazenaremos os dados que coletamos em um DataFrame usando pandas.\n"
      ],
      "metadata": {
        "id": "_UZMdxZFMkmY"
      }
    },
    {
      "cell_type": "code",
      "execution_count": 28,
      "metadata": {
        "id": "5TOtTf0teowW"
      },
      "outputs": [],
      "source": [
        "#Bibliotecas \n",
        "from urllib.request import urlopen\n",
        "from bs4 import BeautifulSoup\n",
        "import pandas as pd\n",
        "import requests"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Temporada iremos Analisar\n",
        "year = 2018"
      ],
      "metadata": {
        "id": "EKdnGsTwzNTm"
      },
      "execution_count": 29,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# URL da pagina que iremos fazer o scarping\n",
        "url_nba = \"https://www.basketball-reference.com/leagues/NBA_{}_per_game.html\".format(year)"
      ],
      "metadata": {
        "id": "-hK3JgVYrF7e"
      },
      "execution_count": 30,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "page = requests.get(url_nba)\n",
        "page"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "NiDga1afzSWa",
        "outputId": "5281a69e-6375-4fda-93ec-e1dba8a34332"
      },
      "execution_count": 31,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<Response [200]>"
            ]
          },
          "metadata": {},
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "page.content"
      ],
      "metadata": {
        "id": "3YqYHovLzjX5"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "html_nba = urlopen(url_nba)\n",
        "soup_nba = BeautifulSoup(html_nba)"
      ],
      "metadata": {
        "id": "8Ob0R29prHH_"
      },
      "execution_count": 32,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "#Players"
      ],
      "metadata": {
        "id": "UTJS8tmDrY0m"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# avoid the first header row\n",
        "rows = soup_nba.findAll('tr')[1:]\n",
        "players_stats_2018 = [[td.getText() for td in rows[i].findAll('td')] for i in range(len(rows))]"
      ],
      "metadata": {
        "id": "hNBmGRnl0Qye"
      },
      "execution_count": 33,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "headers_2018 = [th.getText() for th in soup_nba.findAll('tr', limit=2)[0].findAll('th')]"
      ],
      "metadata": {
        "id": "efXk_csPrKPd"
      },
      "execution_count": 34,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "headers_2018"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Bq_uPJ5LgvK4",
        "outputId": "a2a8f98e-320c-47ae-f25e-5b8f2278d570"
      },
      "execution_count": 35,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['Rk',\n",
              " 'Player',\n",
              " 'Pos',\n",
              " 'Age',\n",
              " 'Tm',\n",
              " 'G',\n",
              " 'GS',\n",
              " 'MP',\n",
              " 'FG',\n",
              " 'FGA',\n",
              " 'FG%',\n",
              " '3P',\n",
              " '3PA',\n",
              " '3P%',\n",
              " '2P',\n",
              " '2PA',\n",
              " '2P%',\n",
              " 'eFG%',\n",
              " 'FT',\n",
              " 'FTA',\n",
              " 'FT%',\n",
              " 'ORB',\n",
              " 'DRB',\n",
              " 'TRB',\n",
              " 'AST',\n",
              " 'STL',\n",
              " 'BLK',\n",
              " 'TOV',\n",
              " 'PF',\n",
              " 'PTS']"
            ]
          },
          "metadata": {},
          "execution_count": 35
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "headers_2018_final = headers_2018[1:]"
      ],
      "metadata": {
        "id": "NtqoNyT9rJyb"
      },
      "execution_count": 36,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "stats_2018 = pd.DataFrame(players_stats_2018, columns = headers_2018_final)"
      ],
      "metadata": {
        "id": "Jgo0CrN6rMFp"
      },
      "execution_count": 37,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "stats_2018.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 235
        },
        "id": "EC0rofow2Rof",
        "outputId": "ca9f3736-bda6-4a4c-9664-3f51b6f28da0"
      },
      "execution_count": 38,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "          Player Pos Age   Tm   G  GS    MP   FG  FGA   FG%  ...   FT%  ORB  \\\n",
              "0   Álex Abrines  SG  24  OKC  75   8  15.1  1.5  3.9  .395  ...  .848  0.3   \n",
              "1     Quincy Acy  PF  27  BRK  70   8  19.4  1.9  5.2  .356  ...  .817  0.6   \n",
              "2   Steven Adams   C  24  OKC  76  76  32.7  5.9  9.4  .629  ...  .559  5.1   \n",
              "3    Bam Adebayo   C  20  MIA  69  19  19.8  2.5  4.9  .512  ...  .721  1.7   \n",
              "4  Arron Afflalo  SG  32  ORL  53   3  12.9  1.2  3.1  .401  ...  .846  0.1   \n",
              "\n",
              "   DRB  TRB  AST  STL  BLK  TOV   PF   PTS  \n",
              "0  1.2  1.5  0.4  0.5  0.1  0.3  1.7   4.7  \n",
              "1  3.1  3.7  0.8  0.5  0.4  0.9  2.1   5.9  \n",
              "2  4.0  9.0  1.2  1.2  1.0  1.7  2.8  13.9  \n",
              "3  3.8  5.5  1.5  0.5  0.6  1.0  2.0   6.9  \n",
              "4  1.2  1.2  0.6  0.1  0.2  0.4  1.1   3.4  \n",
              "\n",
              "[5 rows x 29 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-632991e3-e73a-4284-b33a-96b1bb937dfd\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player</th>\n",
              "      <th>Pos</th>\n",
              "      <th>Age</th>\n",
              "      <th>Tm</th>\n",
              "      <th>G</th>\n",
              "      <th>GS</th>\n",
              "      <th>MP</th>\n",
              "      <th>FG</th>\n",
              "      <th>FGA</th>\n",
              "      <th>FG%</th>\n",
              "      <th>...</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>Álex Abrines</td>\n",
              "      <td>SG</td>\n",
              "      <td>24</td>\n",
              "      <td>OKC</td>\n",
              "      <td>75</td>\n",
              "      <td>8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>1.5</td>\n",
              "      <td>3.9</td>\n",
              "      <td>.395</td>\n",
              "      <td>...</td>\n",
              "      <td>.848</td>\n",
              "      <td>0.3</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1.5</td>\n",
              "      <td>0.4</td>\n",
              "      <td>0.5</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.3</td>\n",
              "      <td>1.7</td>\n",
              "      <td>4.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Quincy Acy</td>\n",
              "      <td>PF</td>\n",
              "      <td>27</td>\n",
              "      <td>BRK</td>\n",
              "      <td>70</td>\n",
              "      <td>8</td>\n",
              "      <td>19.4</td>\n",
              "      <td>1.9</td>\n",
              "      <td>5.2</td>\n",
              "      <td>.356</td>\n",
              "      <td>...</td>\n",
              "      <td>.817</td>\n",
              "      <td>0.6</td>\n",
              "      <td>3.1</td>\n",
              "      <td>3.7</td>\n",
              "      <td>0.8</td>\n",
              "      <td>0.5</td>\n",
              "      <td>0.4</td>\n",
              "      <td>0.9</td>\n",
              "      <td>2.1</td>\n",
              "      <td>5.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Steven Adams</td>\n",
              "      <td>C</td>\n",
              "      <td>24</td>\n",
              "      <td>OKC</td>\n",
              "      <td>76</td>\n",
              "      <td>76</td>\n",
              "      <td>32.7</td>\n",
              "      <td>5.9</td>\n",
              "      <td>9.4</td>\n",
              "      <td>.629</td>\n",
              "      <td>...</td>\n",
              "      <td>.559</td>\n",
              "      <td>5.1</td>\n",
              "      <td>4.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.7</td>\n",
              "      <td>2.8</td>\n",
              "      <td>13.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Bam Adebayo</td>\n",
              "      <td>C</td>\n",
              "      <td>20</td>\n",
              "      <td>MIA</td>\n",
              "      <td>69</td>\n",
              "      <td>19</td>\n",
              "      <td>19.8</td>\n",
              "      <td>2.5</td>\n",
              "      <td>4.9</td>\n",
              "      <td>.512</td>\n",
              "      <td>...</td>\n",
              "      <td>.721</td>\n",
              "      <td>1.7</td>\n",
              "      <td>3.8</td>\n",
              "      <td>5.5</td>\n",
              "      <td>1.5</td>\n",
              "      <td>0.5</td>\n",
              "      <td>0.6</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>6.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Arron Afflalo</td>\n",
              "      <td>SG</td>\n",
              "      <td>32</td>\n",
              "      <td>ORL</td>\n",
              "      <td>53</td>\n",
              "      <td>3</td>\n",
              "      <td>12.9</td>\n",
              "      <td>1.2</td>\n",
              "      <td>3.1</td>\n",
              "      <td>.401</td>\n",
              "      <td>...</td>\n",
              "      <td>.846</td>\n",
              "      <td>0.1</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1.2</td>\n",
              "      <td>0.6</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.2</td>\n",
              "      <td>0.4</td>\n",
              "      <td>1.1</td>\n",
              "      <td>3.4</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 29 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-632991e3-e73a-4284-b33a-96b1bb937dfd')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-632991e3-e73a-4284-b33a-96b1bb937dfd button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-632991e3-e73a-4284-b33a-96b1bb937dfd');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 38
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "stats_2018.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "rXZ_s1Va2Myh",
        "outputId": "6e6f94df-73c4-4205-8d53-d2414792a83b"
      },
      "execution_count": 39,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(690, 29)"
            ]
          },
          "metadata": {},
          "execution_count": 39
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "#Players (outro)"
      ],
      "metadata": {
        "id": "AEO0Waz6yjXN"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "table_Basket = soup_nba.find(lambda tag: tag.name=='table' and tag.has_attr('id') and tag['id']==\"per_game_stats\") "
      ],
      "metadata": {
        "id": "hHfmA3iz0eBz"
      },
      "execution_count": 40,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "columns_Basket = table_Basket.findAll(lambda tag: tag.name=='tr',limit=1)"
      ],
      "metadata": {
        "id": "npAqo6YU0pET"
      },
      "execution_count": 42,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "headers_Basket = [th.getText() for th in columns_Basket[0].findAll('th')]\n",
        "headers_Basket_final = headers_Basket[1:]"
      ],
      "metadata": {
        "id": "UxeCgU8X0rfj"
      },
      "execution_count": 43,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#Criando uma lista com todas as estatisticas presentes\n",
        "rows_Basket = table_Basket.tbody.findAll('tr')[0:]\n",
        "player_stats_Basket = [[td.getText() for td in rows[i].findAll('td')] for i in range(len(rows))]"
      ],
      "metadata": {
        "id": "eUyuqF_r0thw"
      },
      "execution_count": 44,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "nba_stats_Basket_2018 = pd.DataFrame(player_stats_Basket, columns = headers_Basket_final)"
      ],
      "metadata": {
        "id": "rajzOa8t0z_z"
      },
      "execution_count": 45,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "nba_stats_Basket_2018.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 235
        },
        "id": "sj-5RqQN2HS4",
        "outputId": "5eb733d0-905b-4d1f-80cf-30b1380b02b7"
      },
      "execution_count": 46,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "          Player Pos Age   Tm   G  GS    MP   FG  FGA   FG%  ...   FT%  ORB  \\\n",
              "0   Álex Abrines  SG  24  OKC  75   8  15.1  1.5  3.9  .395  ...  .848  0.3   \n",
              "1     Quincy Acy  PF  27  BRK  70   8  19.4  1.9  5.2  .356  ...  .817  0.6   \n",
              "2   Steven Adams   C  24  OKC  76  76  32.7  5.9  9.4  .629  ...  .559  5.1   \n",
              "3    Bam Adebayo   C  20  MIA  69  19  19.8  2.5  4.9  .512  ...  .721  1.7   \n",
              "4  Arron Afflalo  SG  32  ORL  53   3  12.9  1.2  3.1  .401  ...  .846  0.1   \n",
              "\n",
              "   DRB  TRB  AST  STL  BLK  TOV   PF   PTS  \n",
              "0  1.2  1.5  0.4  0.5  0.1  0.3  1.7   4.7  \n",
              "1  3.1  3.7  0.8  0.5  0.4  0.9  2.1   5.9  \n",
              "2  4.0  9.0  1.2  1.2  1.0  1.7  2.8  13.9  \n",
              "3  3.8  5.5  1.5  0.5  0.6  1.0  2.0   6.9  \n",
              "4  1.2  1.2  0.6  0.1  0.2  0.4  1.1   3.4  \n",
              "\n",
              "[5 rows x 29 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-9f8271a4-2b3d-4039-95b7-0bb5bff4a04d\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player</th>\n",
              "      <th>Pos</th>\n",
              "      <th>Age</th>\n",
              "      <th>Tm</th>\n",
              "      <th>G</th>\n",
              "      <th>GS</th>\n",
              "      <th>MP</th>\n",
              "      <th>FG</th>\n",
              "      <th>FGA</th>\n",
              "      <th>FG%</th>\n",
              "      <th>...</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>Álex Abrines</td>\n",
              "      <td>SG</td>\n",
              "      <td>24</td>\n",
              "      <td>OKC</td>\n",
              "      <td>75</td>\n",
              "      <td>8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>1.5</td>\n",
              "      <td>3.9</td>\n",
              "      <td>.395</td>\n",
              "      <td>...</td>\n",
              "      <td>.848</td>\n",
              "      <td>0.3</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1.5</td>\n",
              "      <td>0.4</td>\n",
              "      <td>0.5</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.3</td>\n",
              "      <td>1.7</td>\n",
              "      <td>4.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Quincy Acy</td>\n",
              "      <td>PF</td>\n",
              "      <td>27</td>\n",
              "      <td>BRK</td>\n",
              "      <td>70</td>\n",
              "      <td>8</td>\n",
              "      <td>19.4</td>\n",
              "      <td>1.9</td>\n",
              "      <td>5.2</td>\n",
              "      <td>.356</td>\n",
              "      <td>...</td>\n",
              "      <td>.817</td>\n",
              "      <td>0.6</td>\n",
              "      <td>3.1</td>\n",
              "      <td>3.7</td>\n",
              "      <td>0.8</td>\n",
              "      <td>0.5</td>\n",
              "      <td>0.4</td>\n",
              "      <td>0.9</td>\n",
              "      <td>2.1</td>\n",
              "      <td>5.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Steven Adams</td>\n",
              "      <td>C</td>\n",
              "      <td>24</td>\n",
              "      <td>OKC</td>\n",
              "      <td>76</td>\n",
              "      <td>76</td>\n",
              "      <td>32.7</td>\n",
              "      <td>5.9</td>\n",
              "      <td>9.4</td>\n",
              "      <td>.629</td>\n",
              "      <td>...</td>\n",
              "      <td>.559</td>\n",
              "      <td>5.1</td>\n",
              "      <td>4.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.7</td>\n",
              "      <td>2.8</td>\n",
              "      <td>13.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Bam Adebayo</td>\n",
              "      <td>C</td>\n",
              "      <td>20</td>\n",
              "      <td>MIA</td>\n",
              "      <td>69</td>\n",
              "      <td>19</td>\n",
              "      <td>19.8</td>\n",
              "      <td>2.5</td>\n",
              "      <td>4.9</td>\n",
              "      <td>.512</td>\n",
              "      <td>...</td>\n",
              "      <td>.721</td>\n",
              "      <td>1.7</td>\n",
              "      <td>3.8</td>\n",
              "      <td>5.5</td>\n",
              "      <td>1.5</td>\n",
              "      <td>0.5</td>\n",
              "      <td>0.6</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>6.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Arron Afflalo</td>\n",
              "      <td>SG</td>\n",
              "      <td>32</td>\n",
              "      <td>ORL</td>\n",
              "      <td>53</td>\n",
              "      <td>3</td>\n",
              "      <td>12.9</td>\n",
              "      <td>1.2</td>\n",
              "      <td>3.1</td>\n",
              "      <td>.401</td>\n",
              "      <td>...</td>\n",
              "      <td>.846</td>\n",
              "      <td>0.1</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1.2</td>\n",
              "      <td>0.6</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.2</td>\n",
              "      <td>0.4</td>\n",
              "      <td>1.1</td>\n",
              "      <td>3.4</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 29 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-9f8271a4-2b3d-4039-95b7-0bb5bff4a04d')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-9f8271a4-2b3d-4039-95b7-0bb5bff4a04d button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-9f8271a4-2b3d-4039-95b7-0bb5bff4a04d');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 46
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "nba_stats_Basket_2018.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "-RmYEKNq2IAc",
        "outputId": "d74ea6ad-3888-4c42-a215-115948ba315a"
      },
      "execution_count": 47,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(690, 29)"
            ]
          },
          "metadata": {},
          "execution_count": 47
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Time"
      ],
      "metadata": {
        "id": "zGJJnxJour3a"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# URL da pagina que iremos fazer o scarping\n",
        "url_time = \"https://www.basketball-reference.com/leagues/NBA_{}.html\".format(year)"
      ],
      "metadata": {
        "id": "YE-G3ra0uzOZ"
      },
      "execution_count": 48,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "page = requests.get(url_time)\n",
        "page"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "RfMh1r4ou4E1",
        "outputId": "363954af-c4cb-4340-b3d0-44636731bf60"
      },
      "execution_count": 49,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<Response [200]>"
            ]
          },
          "metadata": {},
          "execution_count": 49
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "html_time = urlopen(url_time)\n",
        "soup_time = BeautifulSoup(html_time)"
      ],
      "metadata": {
        "id": "rHNOWgTBvL8r"
      },
      "execution_count": 50,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "table_time = soup_time.find(lambda tag: tag.name=='table' and tag.has_attr('id') and tag['id']==\"per_game-team\") "
      ],
      "metadata": {
        "id": "C589stWput52"
      },
      "execution_count": 51,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "columns_time = table_time.findAll(lambda tag: tag.name=='tr',limit=2)"
      ],
      "metadata": {
        "id": "y9LGXKmYu_ev"
      },
      "execution_count": 52,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "columns_time"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "TTHkdd8PwKyQ",
        "outputId": "7e433e6d-04dd-44b9-f487-89c2e377cce0"
      },
      "execution_count": 53,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[<tr> <th aria-label=\"Rk\" class=\"ranker poptip sort_default_asc show_partial_when_sorting center\" data-stat=\"ranker\" data-tip=\"Rank\" scope=\"col\">Rk</th> <th aria-label=\"team\" class=\" poptip center\" data-stat=\"team\" scope=\"col\">Team</th> <th aria-label=\"Games\" class=\" poptip center\" data-stat=\"g\" data-tip=\"Games\" scope=\"col\">G</th> <th aria-label=\"Minutes Played\" class=\" poptip center\" data-stat=\"mp\" data-tip=\"Minutes Played\" scope=\"col\">MP</th> <th aria-label=\"Field Goals\" class=\" poptip center\" data-stat=\"fg\" data-tip=\"Field Goals\" scope=\"col\">FG</th> <th aria-label=\"FGA\" class=\" poptip center\" data-stat=\"fga\" data-tip=\"Field Goal Attempts\" scope=\"col\">FGA</th> <th aria-label=\"Field Goal Percentage\" class=\" poptip center\" data-stat=\"fg_pct\" data-tip=\"Field Goal Percentage\" scope=\"col\">FG%</th> <th aria-label=\"3-Point Field Goals\" class=\" poptip center\" data-stat=\"fg3\" data-tip=\"3-Point Field Goals\" scope=\"col\">3P</th> <th aria-label=\"3-Point Field Goal Attempts\" class=\" poptip center\" data-stat=\"fg3a\" data-tip=\"3-Point Field Goal Attempts\" scope=\"col\">3PA</th> <th aria-label=\"3-Point Field Goal Percentage\" class=\" poptip center\" data-stat=\"fg3_pct\" data-tip=\"3-Point Field Goal Percentage\" scope=\"col\">3P%</th> <th aria-label=\"2-Point Field Goals\" class=\" poptip center\" data-stat=\"fg2\" data-tip=\"2-Point Field Goals\" scope=\"col\">2P</th> <th aria-label=\"2-point Field Goal Attempts\" class=\" poptip center\" data-stat=\"fg2a\" data-tip=\"2-point Field Goal Attempts\" scope=\"col\">2PA</th> <th aria-label=\"2-Point Field Goal Percentage\" class=\" poptip center\" data-stat=\"fg2_pct\" data-tip=\"2-Point Field Goal Percentage\" scope=\"col\">2P%</th> <th aria-label=\"Free Throws\" class=\" poptip center\" data-stat=\"ft\" data-tip=\"Free Throws\" scope=\"col\">FT</th> <th aria-label=\"Free Throw Attempts\" class=\" poptip center\" data-stat=\"fta\" data-tip=\"Free Throw Attempts\" scope=\"col\">FTA</th> <th aria-label=\"Free Throw Percentage\" class=\" poptip center\" data-stat=\"ft_pct\" data-tip=\"Free Throw Percentage\" scope=\"col\">FT%</th> <th aria-label=\"Offensive Rebounds\" class=\" poptip center\" data-stat=\"orb\" data-tip=\"Offensive Rebounds\" scope=\"col\">ORB</th> <th aria-label=\"Defensive Rebounds\" class=\" poptip center\" data-stat=\"drb\" data-tip=\"Defensive Rebounds\" scope=\"col\">DRB</th> <th aria-label=\"Total Rebounds\" class=\" poptip center\" data-stat=\"trb\" data-tip=\"Total Rebounds\" scope=\"col\">TRB</th> <th aria-label=\"Assists\" class=\" poptip center\" data-stat=\"ast\" data-tip=\"Assists\" scope=\"col\">AST</th> <th aria-label=\"Steals\" class=\" poptip center\" data-stat=\"stl\" data-tip=\"Steals\" scope=\"col\">STL</th> <th aria-label=\"Blocks\" class=\" poptip center\" data-stat=\"blk\" data-tip=\"Blocks\" scope=\"col\">BLK</th> <th aria-label=\"Turnovers\" class=\" poptip center\" data-stat=\"tov\" data-tip=\"Turnovers\" scope=\"col\">TOV</th> <th aria-label=\"Personal Fouls\" class=\" poptip center\" data-stat=\"pf\" data-tip=\"Personal Fouls\" scope=\"col\">PF</th> <th aria-label=\"Points\" class=\" poptip center\" data-stat=\"pts\" data-tip=\"Points\" scope=\"col\">PTS</th> </tr>,\n",
              " <tr><th class=\"right \" data-stat=\"ranker\" scope=\"row\">1</th><td class=\"left \" data-stat=\"team\"><a href=\"/teams/GSW/2018.html\">Golden State Warriors</a>*</td><td class=\"right \" data-stat=\"g\">82</td><td class=\"right \" data-stat=\"mp\">240.6</td><td class=\"right \" data-stat=\"fg\">42.8</td><td class=\"right \" data-stat=\"fga\">85.1</td><td class=\"right \" data-stat=\"fg_pct\">.503</td><td class=\"right \" data-stat=\"fg3\">11.3</td><td class=\"right \" data-stat=\"fg3a\">28.9</td><td class=\"right \" data-stat=\"fg3_pct\">.391</td><td class=\"right \" data-stat=\"fg2\">31.5</td><td class=\"right \" data-stat=\"fg2a\">56.2</td><td class=\"right \" data-stat=\"fg2_pct\">.560</td><td class=\"right \" data-stat=\"ft\">16.6</td><td class=\"right \" data-stat=\"fta\">20.3</td><td class=\"right \" data-stat=\"ft_pct\">.815</td><td class=\"right \" data-stat=\"orb\">8.4</td><td class=\"right \" data-stat=\"drb\">35.1</td><td class=\"right \" data-stat=\"trb\">43.5</td><td class=\"right \" data-stat=\"ast\">29.3</td><td class=\"right \" data-stat=\"stl\">8.0</td><td class=\"right \" data-stat=\"blk\">7.5</td><td class=\"right \" data-stat=\"tov\">15.5</td><td class=\"right \" data-stat=\"pf\">19.6</td><td class=\"right \" data-stat=\"pts\">113.5</td></tr>]"
            ]
          },
          "metadata": {},
          "execution_count": 53
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "headers_time = [th.getText() for th in columns_time[0].findAll('th')]\n",
        "headers_time_final = headers_time[1:]"
      ],
      "metadata": {
        "id": "ffYz-o-WvuUF"
      },
      "execution_count": 54,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "headers_time_final"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "RIZPi46xwNuw",
        "outputId": "aed7ce01-e01a-4847-d42d-48debf78bf21"
      },
      "execution_count": 55,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['Team',\n",
              " 'G',\n",
              " 'MP',\n",
              " 'FG',\n",
              " 'FGA',\n",
              " 'FG%',\n",
              " '3P',\n",
              " '3PA',\n",
              " '3P%',\n",
              " '2P',\n",
              " '2PA',\n",
              " '2P%',\n",
              " 'FT',\n",
              " 'FTA',\n",
              " 'FT%',\n",
              " 'ORB',\n",
              " 'DRB',\n",
              " 'TRB',\n",
              " 'AST',\n",
              " 'STL',\n",
              " 'BLK',\n",
              " 'TOV',\n",
              " 'PF',\n",
              " 'PTS']"
            ]
          },
          "metadata": {},
          "execution_count": 55
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Criando uma lista com todas as estatisticas presentes\n",
        "rows_time = table_time.tbody.findAll('tr')[0:]\n",
        "time_stats_Basket = [[td.getText() for td in rows_time[i].findAll('td')] for i in range(len(rows_time))]"
      ],
      "metadata": {
        "id": "phE0btLpwTBG"
      },
      "execution_count": 56,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "nba_stats_2018 = pd.DataFrame(time_stats_Basket, columns = headers_time_final)"
      ],
      "metadata": {
        "id": "lgCrZxKExQPK"
      },
      "execution_count": 57,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "nba_stats_2018"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "bjCdzEZkxZB2",
        "outputId": "93ae7a9f-9b14-4d1e-8b97-1b71f521b2f6"
      },
      "execution_count": 58,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                       Team   G     MP    FG   FGA   FG%    3P   3PA   3P%  \\\n",
              "0    Golden State Warriors*  82  240.6  42.8  85.1  .503  11.3  28.9  .391   \n",
              "1          Houston Rockets*  82  240.9  38.7  84.2  .460  15.3  42.3  .362   \n",
              "2     New Orleans Pelicans*  82  243.4  42.7  88.3  .483  10.2  28.2  .362   \n",
              "3          Toronto Raptors*  82  241.8  41.3  87.4  .472  11.8  33.0  .358   \n",
              "4      Cleveland Cavaliers*  82  240.6  40.4  84.8  .476  12.0  32.1  .372   \n",
              "5            Denver Nuggets  82  242.4  40.7  86.6  .470  11.5  30.9  .371   \n",
              "6       Philadelphia 76ers*  82  241.2  40.8  86.6  .472  11.0  29.8  .369   \n",
              "7   Minnesota Timberwolves*  82  241.5  41.0  86.1  .476   8.0  22.5  .357   \n",
              "8      Los Angeles Clippers  82  240.3  40.3  85.4  .471   9.5  26.8  .354   \n",
              "9         Charlotte Hornets  82  241.2  39.0  86.7  .450  10.0  27.2  .369   \n",
              "10       Los Angeles Lakers  82  242.7  40.7  88.4  .461  10.0  29.1  .345   \n",
              "11   Oklahoma City Thunder*  82  241.8  39.9  88.1  .453  10.7  30.4  .354   \n",
              "12      Washington Wizards*  82  242.1  39.9  85.6  .467   9.9  26.5  .375   \n",
              "13            Brooklyn Nets  82  242.1  38.2  86.8  .441  12.7  35.7  .356   \n",
              "14         Milwaukee Bucks*  82  241.8  39.7  83.0  .478   8.8  24.7  .355   \n",
              "15          Indiana Pacers*  82  240.9  40.8  86.4  .472   9.0  24.5  .369   \n",
              "16  Portland Trail Blazers*  82  240.9  39.3  87.0  .452  10.3  28.1  .366   \n",
              "17          New York Knicks  82  241.8  40.7  87.7  .464   8.2  23.3  .352   \n",
              "18               Utah Jazz*  82  240.9  38.3  82.9  .462  10.8  29.6  .366   \n",
              "19          Boston Celtics*  82  241.5  38.3  85.1  .450  11.5  30.4  .377   \n",
              "20             Phoenix Suns  82  240.3  38.5  87.1  .442   9.3  27.9  .334   \n",
              "21          Detroit Pistons  82  241.5  39.1  86.9  .450  10.8  28.9  .373   \n",
              "22              Miami Heat*  82  243.0  38.8  85.3  .455  11.0  30.6  .360   \n",
              "23            Orlando Magic  82  240.6  38.8  85.9  .452  10.3  29.3  .351   \n",
              "24            Atlanta Hawks  82  240.3  38.2  85.5  .446  11.2  31.0  .360   \n",
              "25            Chicago Bulls  82  242.1  38.7  88.8  .435  11.0  31.1  .355   \n",
              "26       San Antonio Spurs*  82  240.6  39.0  85.4  .457   8.5  24.1  .352   \n",
              "27         Dallas Mavericks  82  241.5  38.1  85.9  .444  11.8  32.8  .360   \n",
              "28        Memphis Grizzlies  82  240.3  36.7  82.8  .444   9.2  26.2  .352   \n",
              "29         Sacramento Kings  82  240.9  38.8  86.1  .450   9.0  24.0  .375   \n",
              "\n",
              "      2P  ...   FT%   ORB   DRB   TRB   AST  STL  BLK   TOV    PF    PTS  \n",
              "0   31.5  ...  .815   8.4  35.1  43.5  29.3  8.0  7.5  15.5  19.6  113.5  \n",
              "1   23.4  ...  .781   9.0  34.5  43.5  21.5  8.5  4.8  13.8  19.5  112.4  \n",
              "2   32.5  ...  .772   8.7  35.7  44.3  26.8  8.0  5.9  14.9  19.1  111.7  \n",
              "3   29.5  ...  .794   9.8  34.2  44.0  24.3  7.6  6.1  13.4  21.7  111.7  \n",
              "4   28.4  ...  .779   8.5  33.7  42.1  23.4  7.1  3.8  13.7  18.6  110.9  \n",
              "5   29.2  ...  .767  11.0  33.5  44.5  25.1  7.6  4.9  15.0  18.7  110.0  \n",
              "6   29.9  ...  .752  10.9  36.5  47.4  27.1  8.3  5.1  16.5  22.1  109.8  \n",
              "7   33.0  ...  .804  10.3  31.6  42.0  22.7  8.4  4.2  12.5  18.2  109.5  \n",
              "8   30.8  ...  .743  10.1  33.7  43.9  22.3  7.7  4.5  14.7  20.0  109.0  \n",
              "9   28.9  ...  .747  10.1  35.4  45.5  21.6  6.8  4.5  12.7  17.2  108.2  \n",
              "10  30.7  ...  .714  10.7  35.7  46.4  23.8  7.7  4.7  15.8  21.2  108.1  \n",
              "11  29.1  ...  .716  12.5  32.6  45.1  21.3  9.1  5.0  14.0  20.2  107.9  \n",
              "12  30.0  ...  .772  10.0  33.1  43.1  25.2  7.9  4.3  14.6  21.3  106.6  \n",
              "13  25.5  ...  .772   9.7  34.8  44.4  23.7  6.2  4.8  15.2  20.6  106.6  \n",
              "14  31.0  ...  .783   8.4  31.5  39.8  23.2  8.8  5.4  13.8  21.4  106.5  \n",
              "15  31.8  ...  .779   9.6  32.7  42.3  22.2  8.8  4.1  13.3  18.8  105.6  \n",
              "16  29.0  ...  .800  10.2  35.3  45.5  19.5  7.0  5.2  13.5  19.5  105.6  \n",
              "17  32.5  ...  .787  10.5  33.6  44.0  23.3  6.7  5.1  14.7  20.5  104.5  \n",
              "18  27.5  ...  .779   9.0  34.2  43.3  22.4  8.6  5.1  14.7  19.6  104.1  \n",
              "19  26.9  ...  .771   9.4  35.1  44.5  22.5  7.4  4.5  14.0  19.7  104.0  \n",
              "20  29.1  ...  .741  10.3  33.9  44.1  21.3  6.9  4.5  15.7  22.0  103.9  \n",
              "21  28.3  ...  .745  10.1  33.6  43.7  22.8  7.7  3.9  13.5  18.4  103.8  \n",
              "22  27.8  ...  .755   9.3  34.2  43.5  22.7  7.6  5.3  14.4  20.1  103.4  \n",
              "23  28.5  ...  .757   8.8  32.8  41.6  23.4  7.6  4.9  14.5  19.3  103.4  \n",
              "24  27.0  ...  .785   9.1  32.8  41.9  23.7  7.8  4.2  15.6  19.6  103.4  \n",
              "25  27.6  ...  .759   9.6  35.0  44.7  23.5  7.6  3.5  14.0  19.2  102.9  \n",
              "26  30.6  ...  .772  10.4  33.9  44.2  22.8  7.7  5.6  13.1  17.2  102.7  \n",
              "27  26.4  ...  .763   8.1  33.1  41.3  22.7  7.0  3.8  12.3  19.2  102.3  \n",
              "28  27.5  ...  .786   9.5  31.0  40.5  21.5  7.5  4.8  15.0  23.2   99.3  \n",
              "29  29.8  ...  .735   9.5  31.4  40.9  21.6  7.8  4.1  13.7  20.0   98.8  \n",
              "\n",
              "[30 rows x 24 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-f2f499f7-bdc1-442d-bffc-6d9f6343ef24\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>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>...</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>Golden State Warriors*</td>\n",
              "      <td>82</td>\n",
              "      <td>240.6</td>\n",
              "      <td>42.8</td>\n",
              "      <td>85.1</td>\n",
              "      <td>.503</td>\n",
              "      <td>11.3</td>\n",
              "      <td>28.9</td>\n",
              "      <td>.391</td>\n",
              "      <td>31.5</td>\n",
              "      <td>...</td>\n",
              "      <td>.815</td>\n",
              "      <td>8.4</td>\n",
              "      <td>35.1</td>\n",
              "      <td>43.5</td>\n",
              "      <td>29.3</td>\n",
              "      <td>8.0</td>\n",
              "      <td>7.5</td>\n",
              "      <td>15.5</td>\n",
              "      <td>19.6</td>\n",
              "      <td>113.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Houston Rockets*</td>\n",
              "      <td>82</td>\n",
              "      <td>240.9</td>\n",
              "      <td>38.7</td>\n",
              "      <td>84.2</td>\n",
              "      <td>.460</td>\n",
              "      <td>15.3</td>\n",
              "      <td>42.3</td>\n",
              "      <td>.362</td>\n",
              "      <td>23.4</td>\n",
              "      <td>...</td>\n",
              "      <td>.781</td>\n",
              "      <td>9.0</td>\n",
              "      <td>34.5</td>\n",
              "      <td>43.5</td>\n",
              "      <td>21.5</td>\n",
              "      <td>8.5</td>\n",
              "      <td>4.8</td>\n",
              "      <td>13.8</td>\n",
              "      <td>19.5</td>\n",
              "      <td>112.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>New Orleans Pelicans*</td>\n",
              "      <td>82</td>\n",
              "      <td>243.4</td>\n",
              "      <td>42.7</td>\n",
              "      <td>88.3</td>\n",
              "      <td>.483</td>\n",
              "      <td>10.2</td>\n",
              "      <td>28.2</td>\n",
              "      <td>.362</td>\n",
              "      <td>32.5</td>\n",
              "      <td>...</td>\n",
              "      <td>.772</td>\n",
              "      <td>8.7</td>\n",
              "      <td>35.7</td>\n",
              "      <td>44.3</td>\n",
              "      <td>26.8</td>\n",
              "      <td>8.0</td>\n",
              "      <td>5.9</td>\n",
              "      <td>14.9</td>\n",
              "      <td>19.1</td>\n",
              "      <td>111.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Toronto Raptors*</td>\n",
              "      <td>82</td>\n",
              "      <td>241.8</td>\n",
              "      <td>41.3</td>\n",
              "      <td>87.4</td>\n",
              "      <td>.472</td>\n",
              "      <td>11.8</td>\n",
              "      <td>33.0</td>\n",
              "      <td>.358</td>\n",
              "      <td>29.5</td>\n",
              "      <td>...</td>\n",
              "      <td>.794</td>\n",
              "      <td>9.8</td>\n",
              "      <td>34.2</td>\n",
              "      <td>44.0</td>\n",
              "      <td>24.3</td>\n",
              "      <td>7.6</td>\n",
              "      <td>6.1</td>\n",
              "      <td>13.4</td>\n",
              "      <td>21.7</td>\n",
              "      <td>111.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Cleveland Cavaliers*</td>\n",
              "      <td>82</td>\n",
              "      <td>240.6</td>\n",
              "      <td>40.4</td>\n",
              "      <td>84.8</td>\n",
              "      <td>.476</td>\n",
              "      <td>12.0</td>\n",
              "      <td>32.1</td>\n",
              "      <td>.372</td>\n",
              "      <td>28.4</td>\n",
              "      <td>...</td>\n",
              "      <td>.779</td>\n",
              "      <td>8.5</td>\n",
              "      <td>33.7</td>\n",
              "      <td>42.1</td>\n",
              "      <td>23.4</td>\n",
              "      <td>7.1</td>\n",
              "      <td>3.8</td>\n",
              "      <td>13.7</td>\n",
              "      <td>18.6</td>\n",
              "      <td>110.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Denver Nuggets</td>\n",
              "      <td>82</td>\n",
              "      <td>242.4</td>\n",
              "      <td>40.7</td>\n",
              "      <td>86.6</td>\n",
              "      <td>.470</td>\n",
              "      <td>11.5</td>\n",
              "      <td>30.9</td>\n",
              "      <td>.371</td>\n",
              "      <td>29.2</td>\n",
              "      <td>...</td>\n",
              "      <td>.767</td>\n",
              "      <td>11.0</td>\n",
              "      <td>33.5</td>\n",
              "      <td>44.5</td>\n",
              "      <td>25.1</td>\n",
              "      <td>7.6</td>\n",
              "      <td>4.9</td>\n",
              "      <td>15.0</td>\n",
              "      <td>18.7</td>\n",
              "      <td>110.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Philadelphia 76ers*</td>\n",
              "      <td>82</td>\n",
              "      <td>241.2</td>\n",
              "      <td>40.8</td>\n",
              "      <td>86.6</td>\n",
              "      <td>.472</td>\n",
              "      <td>11.0</td>\n",
              "      <td>29.8</td>\n",
              "      <td>.369</td>\n",
              "      <td>29.9</td>\n",
              "      <td>...</td>\n",
              "      <td>.752</td>\n",
              "      <td>10.9</td>\n",
              "      <td>36.5</td>\n",
              "      <td>47.4</td>\n",
              "      <td>27.1</td>\n",
              "      <td>8.3</td>\n",
              "      <td>5.1</td>\n",
              "      <td>16.5</td>\n",
              "      <td>22.1</td>\n",
              "      <td>109.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Minnesota Timberwolves*</td>\n",
              "      <td>82</td>\n",
              "      <td>241.5</td>\n",
              "      <td>41.0</td>\n",
              "      <td>86.1</td>\n",
              "      <td>.476</td>\n",
              "      <td>8.0</td>\n",
              "      <td>22.5</td>\n",
              "      <td>.357</td>\n",
              "      <td>33.0</td>\n",
              "      <td>...</td>\n",
              "      <td>.804</td>\n",
              "      <td>10.3</td>\n",
              "      <td>31.6</td>\n",
              "      <td>42.0</td>\n",
              "      <td>22.7</td>\n",
              "      <td>8.4</td>\n",
              "      <td>4.2</td>\n",
              "      <td>12.5</td>\n",
              "      <td>18.2</td>\n",
              "      <td>109.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Los Angeles Clippers</td>\n",
              "      <td>82</td>\n",
              "      <td>240.3</td>\n",
              "      <td>40.3</td>\n",
              "      <td>85.4</td>\n",
              "      <td>.471</td>\n",
              "      <td>9.5</td>\n",
              "      <td>26.8</td>\n",
              "      <td>.354</td>\n",
              "      <td>30.8</td>\n",
              "      <td>...</td>\n",
              "      <td>.743</td>\n",
              "      <td>10.1</td>\n",
              "      <td>33.7</td>\n",
              "      <td>43.9</td>\n",
              "      <td>22.3</td>\n",
              "      <td>7.7</td>\n",
              "      <td>4.5</td>\n",
              "      <td>14.7</td>\n",
              "      <td>20.0</td>\n",
              "      <td>109.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Charlotte Hornets</td>\n",
              "      <td>82</td>\n",
              "      <td>241.2</td>\n",
              "      <td>39.0</td>\n",
              "      <td>86.7</td>\n",
              "      <td>.450</td>\n",
              "      <td>10.0</td>\n",
              "      <td>27.2</td>\n",
              "      <td>.369</td>\n",
              "      <td>28.9</td>\n",
              "      <td>...</td>\n",
              "      <td>.747</td>\n",
              "      <td>10.1</td>\n",
              "      <td>35.4</td>\n",
              "      <td>45.5</td>\n",
              "      <td>21.6</td>\n",
              "      <td>6.8</td>\n",
              "      <td>4.5</td>\n",
              "      <td>12.7</td>\n",
              "      <td>17.2</td>\n",
              "      <td>108.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Los Angeles Lakers</td>\n",
              "      <td>82</td>\n",
              "      <td>242.7</td>\n",
              "      <td>40.7</td>\n",
              "      <td>88.4</td>\n",
              "      <td>.461</td>\n",
              "      <td>10.0</td>\n",
              "      <td>29.1</td>\n",
              "      <td>.345</td>\n",
              "      <td>30.7</td>\n",
              "      <td>...</td>\n",
              "      <td>.714</td>\n",
              "      <td>10.7</td>\n",
              "      <td>35.7</td>\n",
              "      <td>46.4</td>\n",
              "      <td>23.8</td>\n",
              "      <td>7.7</td>\n",
              "      <td>4.7</td>\n",
              "      <td>15.8</td>\n",
              "      <td>21.2</td>\n",
              "      <td>108.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Oklahoma City Thunder*</td>\n",
              "      <td>82</td>\n",
              "      <td>241.8</td>\n",
              "      <td>39.9</td>\n",
              "      <td>88.1</td>\n",
              "      <td>.453</td>\n",
              "      <td>10.7</td>\n",
              "      <td>30.4</td>\n",
              "      <td>.354</td>\n",
              "      <td>29.1</td>\n",
              "      <td>...</td>\n",
              "      <td>.716</td>\n",
              "      <td>12.5</td>\n",
              "      <td>32.6</td>\n",
              "      <td>45.1</td>\n",
              "      <td>21.3</td>\n",
              "      <td>9.1</td>\n",
              "      <td>5.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>20.2</td>\n",
              "      <td>107.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Washington Wizards*</td>\n",
              "      <td>82</td>\n",
              "      <td>242.1</td>\n",
              "      <td>39.9</td>\n",
              "      <td>85.6</td>\n",
              "      <td>.467</td>\n",
              "      <td>9.9</td>\n",
              "      <td>26.5</td>\n",
              "      <td>.375</td>\n",
              "      <td>30.0</td>\n",
              "      <td>...</td>\n",
              "      <td>.772</td>\n",
              "      <td>10.0</td>\n",
              "      <td>33.1</td>\n",
              "      <td>43.1</td>\n",
              "      <td>25.2</td>\n",
              "      <td>7.9</td>\n",
              "      <td>4.3</td>\n",
              "      <td>14.6</td>\n",
              "      <td>21.3</td>\n",
              "      <td>106.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Brooklyn Nets</td>\n",
              "      <td>82</td>\n",
              "      <td>242.1</td>\n",
              "      <td>38.2</td>\n",
              "      <td>86.8</td>\n",
              "      <td>.441</td>\n",
              "      <td>12.7</td>\n",
              "      <td>35.7</td>\n",
              "      <td>.356</td>\n",
              "      <td>25.5</td>\n",
              "      <td>...</td>\n",
              "      <td>.772</td>\n",
              "      <td>9.7</td>\n",
              "      <td>34.8</td>\n",
              "      <td>44.4</td>\n",
              "      <td>23.7</td>\n",
              "      <td>6.2</td>\n",
              "      <td>4.8</td>\n",
              "      <td>15.2</td>\n",
              "      <td>20.6</td>\n",
              "      <td>106.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Milwaukee Bucks*</td>\n",
              "      <td>82</td>\n",
              "      <td>241.8</td>\n",
              "      <td>39.7</td>\n",
              "      <td>83.0</td>\n",
              "      <td>.478</td>\n",
              "      <td>8.8</td>\n",
              "      <td>24.7</td>\n",
              "      <td>.355</td>\n",
              "      <td>31.0</td>\n",
              "      <td>...</td>\n",
              "      <td>.783</td>\n",
              "      <td>8.4</td>\n",
              "      <td>31.5</td>\n",
              "      <td>39.8</td>\n",
              "      <td>23.2</td>\n",
              "      <td>8.8</td>\n",
              "      <td>5.4</td>\n",
              "      <td>13.8</td>\n",
              "      <td>21.4</td>\n",
              "      <td>106.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Indiana Pacers*</td>\n",
              "      <td>82</td>\n",
              "      <td>240.9</td>\n",
              "      <td>40.8</td>\n",
              "      <td>86.4</td>\n",
              "      <td>.472</td>\n",
              "      <td>9.0</td>\n",
              "      <td>24.5</td>\n",
              "      <td>.369</td>\n",
              "      <td>31.8</td>\n",
              "      <td>...</td>\n",
              "      <td>.779</td>\n",
              "      <td>9.6</td>\n",
              "      <td>32.7</td>\n",
              "      <td>42.3</td>\n",
              "      <td>22.2</td>\n",
              "      <td>8.8</td>\n",
              "      <td>4.1</td>\n",
              "      <td>13.3</td>\n",
              "      <td>18.8</td>\n",
              "      <td>105.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Portland Trail Blazers*</td>\n",
              "      <td>82</td>\n",
              "      <td>240.9</td>\n",
              "      <td>39.3</td>\n",
              "      <td>87.0</td>\n",
              "      <td>.452</td>\n",
              "      <td>10.3</td>\n",
              "      <td>28.1</td>\n",
              "      <td>.366</td>\n",
              "      <td>29.0</td>\n",
              "      <td>...</td>\n",
              "      <td>.800</td>\n",
              "      <td>10.2</td>\n",
              "      <td>35.3</td>\n",
              "      <td>45.5</td>\n",
              "      <td>19.5</td>\n",
              "      <td>7.0</td>\n",
              "      <td>5.2</td>\n",
              "      <td>13.5</td>\n",
              "      <td>19.5</td>\n",
              "      <td>105.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>New York Knicks</td>\n",
              "      <td>82</td>\n",
              "      <td>241.8</td>\n",
              "      <td>40.7</td>\n",
              "      <td>87.7</td>\n",
              "      <td>.464</td>\n",
              "      <td>8.2</td>\n",
              "      <td>23.3</td>\n",
              "      <td>.352</td>\n",
              "      <td>32.5</td>\n",
              "      <td>...</td>\n",
              "      <td>.787</td>\n",
              "      <td>10.5</td>\n",
              "      <td>33.6</td>\n",
              "      <td>44.0</td>\n",
              "      <td>23.3</td>\n",
              "      <td>6.7</td>\n",
              "      <td>5.1</td>\n",
              "      <td>14.7</td>\n",
              "      <td>20.5</td>\n",
              "      <td>104.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Utah Jazz*</td>\n",
              "      <td>82</td>\n",
              "      <td>240.9</td>\n",
              "      <td>38.3</td>\n",
              "      <td>82.9</td>\n",
              "      <td>.462</td>\n",
              "      <td>10.8</td>\n",
              "      <td>29.6</td>\n",
              "      <td>.366</td>\n",
              "      <td>27.5</td>\n",
              "      <td>...</td>\n",
              "      <td>.779</td>\n",
              "      <td>9.0</td>\n",
              "      <td>34.2</td>\n",
              "      <td>43.3</td>\n",
              "      <td>22.4</td>\n",
              "      <td>8.6</td>\n",
              "      <td>5.1</td>\n",
              "      <td>14.7</td>\n",
              "      <td>19.6</td>\n",
              "      <td>104.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Boston Celtics*</td>\n",
              "      <td>82</td>\n",
              "      <td>241.5</td>\n",
              "      <td>38.3</td>\n",
              "      <td>85.1</td>\n",
              "      <td>.450</td>\n",
              "      <td>11.5</td>\n",
              "      <td>30.4</td>\n",
              "      <td>.377</td>\n",
              "      <td>26.9</td>\n",
              "      <td>...</td>\n",
              "      <td>.771</td>\n",
              "      <td>9.4</td>\n",
              "      <td>35.1</td>\n",
              "      <td>44.5</td>\n",
              "      <td>22.5</td>\n",
              "      <td>7.4</td>\n",
              "      <td>4.5</td>\n",
              "      <td>14.0</td>\n",
              "      <td>19.7</td>\n",
              "      <td>104.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Phoenix Suns</td>\n",
              "      <td>82</td>\n",
              "      <td>240.3</td>\n",
              "      <td>38.5</td>\n",
              "      <td>87.1</td>\n",
              "      <td>.442</td>\n",
              "      <td>9.3</td>\n",
              "      <td>27.9</td>\n",
              "      <td>.334</td>\n",
              "      <td>29.1</td>\n",
              "      <td>...</td>\n",
              "      <td>.741</td>\n",
              "      <td>10.3</td>\n",
              "      <td>33.9</td>\n",
              "      <td>44.1</td>\n",
              "      <td>21.3</td>\n",
              "      <td>6.9</td>\n",
              "      <td>4.5</td>\n",
              "      <td>15.7</td>\n",
              "      <td>22.0</td>\n",
              "      <td>103.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Detroit Pistons</td>\n",
              "      <td>82</td>\n",
              "      <td>241.5</td>\n",
              "      <td>39.1</td>\n",
              "      <td>86.9</td>\n",
              "      <td>.450</td>\n",
              "      <td>10.8</td>\n",
              "      <td>28.9</td>\n",
              "      <td>.373</td>\n",
              "      <td>28.3</td>\n",
              "      <td>...</td>\n",
              "      <td>.745</td>\n",
              "      <td>10.1</td>\n",
              "      <td>33.6</td>\n",
              "      <td>43.7</td>\n",
              "      <td>22.8</td>\n",
              "      <td>7.7</td>\n",
              "      <td>3.9</td>\n",
              "      <td>13.5</td>\n",
              "      <td>18.4</td>\n",
              "      <td>103.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Miami Heat*</td>\n",
              "      <td>82</td>\n",
              "      <td>243.0</td>\n",
              "      <td>38.8</td>\n",
              "      <td>85.3</td>\n",
              "      <td>.455</td>\n",
              "      <td>11.0</td>\n",
              "      <td>30.6</td>\n",
              "      <td>.360</td>\n",
              "      <td>27.8</td>\n",
              "      <td>...</td>\n",
              "      <td>.755</td>\n",
              "      <td>9.3</td>\n",
              "      <td>34.2</td>\n",
              "      <td>43.5</td>\n",
              "      <td>22.7</td>\n",
              "      <td>7.6</td>\n",
              "      <td>5.3</td>\n",
              "      <td>14.4</td>\n",
              "      <td>20.1</td>\n",
              "      <td>103.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Orlando Magic</td>\n",
              "      <td>82</td>\n",
              "      <td>240.6</td>\n",
              "      <td>38.8</td>\n",
              "      <td>85.9</td>\n",
              "      <td>.452</td>\n",
              "      <td>10.3</td>\n",
              "      <td>29.3</td>\n",
              "      <td>.351</td>\n",
              "      <td>28.5</td>\n",
              "      <td>...</td>\n",
              "      <td>.757</td>\n",
              "      <td>8.8</td>\n",
              "      <td>32.8</td>\n",
              "      <td>41.6</td>\n",
              "      <td>23.4</td>\n",
              "      <td>7.6</td>\n",
              "      <td>4.9</td>\n",
              "      <td>14.5</td>\n",
              "      <td>19.3</td>\n",
              "      <td>103.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Atlanta Hawks</td>\n",
              "      <td>82</td>\n",
              "      <td>240.3</td>\n",
              "      <td>38.2</td>\n",
              "      <td>85.5</td>\n",
              "      <td>.446</td>\n",
              "      <td>11.2</td>\n",
              "      <td>31.0</td>\n",
              "      <td>.360</td>\n",
              "      <td>27.0</td>\n",
              "      <td>...</td>\n",
              "      <td>.785</td>\n",
              "      <td>9.1</td>\n",
              "      <td>32.8</td>\n",
              "      <td>41.9</td>\n",
              "      <td>23.7</td>\n",
              "      <td>7.8</td>\n",
              "      <td>4.2</td>\n",
              "      <td>15.6</td>\n",
              "      <td>19.6</td>\n",
              "      <td>103.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Chicago Bulls</td>\n",
              "      <td>82</td>\n",
              "      <td>242.1</td>\n",
              "      <td>38.7</td>\n",
              "      <td>88.8</td>\n",
              "      <td>.435</td>\n",
              "      <td>11.0</td>\n",
              "      <td>31.1</td>\n",
              "      <td>.355</td>\n",
              "      <td>27.6</td>\n",
              "      <td>...</td>\n",
              "      <td>.759</td>\n",
              "      <td>9.6</td>\n",
              "      <td>35.0</td>\n",
              "      <td>44.7</td>\n",
              "      <td>23.5</td>\n",
              "      <td>7.6</td>\n",
              "      <td>3.5</td>\n",
              "      <td>14.0</td>\n",
              "      <td>19.2</td>\n",
              "      <td>102.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>San Antonio Spurs*</td>\n",
              "      <td>82</td>\n",
              "      <td>240.6</td>\n",
              "      <td>39.0</td>\n",
              "      <td>85.4</td>\n",
              "      <td>.457</td>\n",
              "      <td>8.5</td>\n",
              "      <td>24.1</td>\n",
              "      <td>.352</td>\n",
              "      <td>30.6</td>\n",
              "      <td>...</td>\n",
              "      <td>.772</td>\n",
              "      <td>10.4</td>\n",
              "      <td>33.9</td>\n",
              "      <td>44.2</td>\n",
              "      <td>22.8</td>\n",
              "      <td>7.7</td>\n",
              "      <td>5.6</td>\n",
              "      <td>13.1</td>\n",
              "      <td>17.2</td>\n",
              "      <td>102.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>Dallas Mavericks</td>\n",
              "      <td>82</td>\n",
              "      <td>241.5</td>\n",
              "      <td>38.1</td>\n",
              "      <td>85.9</td>\n",
              "      <td>.444</td>\n",
              "      <td>11.8</td>\n",
              "      <td>32.8</td>\n",
              "      <td>.360</td>\n",
              "      <td>26.4</td>\n",
              "      <td>...</td>\n",
              "      <td>.763</td>\n",
              "      <td>8.1</td>\n",
              "      <td>33.1</td>\n",
              "      <td>41.3</td>\n",
              "      <td>22.7</td>\n",
              "      <td>7.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>12.3</td>\n",
              "      <td>19.2</td>\n",
              "      <td>102.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Memphis Grizzlies</td>\n",
              "      <td>82</td>\n",
              "      <td>240.3</td>\n",
              "      <td>36.7</td>\n",
              "      <td>82.8</td>\n",
              "      <td>.444</td>\n",
              "      <td>9.2</td>\n",
              "      <td>26.2</td>\n",
              "      <td>.352</td>\n",
              "      <td>27.5</td>\n",
              "      <td>...</td>\n",
              "      <td>.786</td>\n",
              "      <td>9.5</td>\n",
              "      <td>31.0</td>\n",
              "      <td>40.5</td>\n",
              "      <td>21.5</td>\n",
              "      <td>7.5</td>\n",
              "      <td>4.8</td>\n",
              "      <td>15.0</td>\n",
              "      <td>23.2</td>\n",
              "      <td>99.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Sacramento Kings</td>\n",
              "      <td>82</td>\n",
              "      <td>240.9</td>\n",
              "      <td>38.8</td>\n",
              "      <td>86.1</td>\n",
              "      <td>.450</td>\n",
              "      <td>9.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>.375</td>\n",
              "      <td>29.8</td>\n",
              "      <td>...</td>\n",
              "      <td>.735</td>\n",
              "      <td>9.5</td>\n",
              "      <td>31.4</td>\n",
              "      <td>40.9</td>\n",
              "      <td>21.6</td>\n",
              "      <td>7.8</td>\n",
              "      <td>4.1</td>\n",
              "      <td>13.7</td>\n",
              "      <td>20.0</td>\n",
              "      <td>98.8</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>30 rows × 24 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f2f499f7-bdc1-442d-bffc-6d9f6343ef24')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-f2f499f7-bdc1-442d-bffc-6d9f6343ef24 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-f2f499f7-bdc1-442d-bffc-6d9f6343ef24');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 58
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "#Processo ETL"
      ],
      "metadata": {
        "id": "p02CKUkdM4mt"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "from datetime import date\n",
        "\n",
        "start = date(2018, 1, 1) \n",
        "end = date(2020, 1, 1)\n",
        "\n",
        "year_range = [year for year in range(start.year, end.year +1)]"
      ],
      "metadata": {
        "id": "tMCegAnD2KqJ"
      },
      "execution_count": 59,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "year_range"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "7fOlOhrf13ng",
        "outputId": "6b8fd190-c6c6-4edf-a078-a450c565b5af"
      },
      "execution_count": 60,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[2018, 2019, 2020]"
            ]
          },
          "metadata": {},
          "execution_count": 60
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "names = ['Season_{}'.format(i) for i in year_range]"
      ],
      "metadata": {
        "id": "h-CtRNb_M6OT"
      },
      "execution_count": 61,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "names"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "KN2XKXae2C5u",
        "outputId": "b271d935-f3b1-4d69-d11d-ec03dcd8d513"
      },
      "execution_count": 62,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['Season_2018', 'Season_2019', 'Season_2020']"
            ]
          },
          "metadata": {},
          "execution_count": 62
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "for i in range(len(year_range)):\n",
        "    url = \"https://www.basketball-reference.com/leagues/NBA_{}_per_game.html\".format(year_range[i])\n",
        "    # this is the HTML from the given URL\n",
        "    html = urlopen(url)\n",
        "    soup = BeautifulSoup(html)\n",
        "    headers = [th.getText() for th in soup.findAll('tr', limit=2)[0].findAll('th')]\n",
        "    headers = headers[1:]\n",
        "    # avoid the first header row\n",
        "    rows = soup.findAll('tr')[1:]\n",
        "    player_stats = [[td.getText() for td in rows[j].findAll('td')]\n",
        "                for j in range(len(rows))]\n",
        "    locals()[names[i]] = pd.DataFrame(player_stats, columns = headers)\n"
      ],
      "metadata": {
        "id": "1i1DVuw_M976"
      },
      "execution_count": 63,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "Season_2019.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 235
        },
        "id": "KB569rG02Rlx",
        "outputId": "42d53b35-3ee5-4482-c27b-9925a2434d25"
      },
      "execution_count": 64,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         Player Pos Age   Tm   G  GS    MP   FG   FGA   FG%  ...   FT%  ORB  \\\n",
              "0  Álex Abrines  SG  25  OKC  31   2  19.0  1.8   5.1  .357  ...  .923  0.2   \n",
              "1    Quincy Acy  PF  28  PHO  10   0  12.3  0.4   1.8  .222  ...  .700  0.3   \n",
              "2  Jaylen Adams  PG  22  ATL  34   1  12.6  1.1   3.2  .345  ...  .778  0.3   \n",
              "3  Steven Adams   C  25  OKC  80  80  33.4  6.0  10.1  .595  ...  .500  4.9   \n",
              "4   Bam Adebayo   C  21  MIA  82  28  23.3  3.4   5.9  .576  ...  .735  2.0   \n",
              "\n",
              "   DRB  TRB  AST  STL  BLK  TOV   PF   PTS  \n",
              "0  1.4  1.5  0.6  0.5  0.2  0.5  1.7   5.3  \n",
              "1  2.2  2.5  0.8  0.1  0.4  0.4  2.4   1.7  \n",
              "2  1.4  1.8  1.9  0.4  0.1  0.8  1.3   3.2  \n",
              "3  4.6  9.5  1.6  1.5  1.0  1.7  2.6  13.9  \n",
              "4  5.3  7.3  2.2  0.9  0.8  1.5  2.5   8.9  \n",
              "\n",
              "[5 rows x 29 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b22dd43a-f6a7-4815-840d-f1ed575234d0\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player</th>\n",
              "      <th>Pos</th>\n",
              "      <th>Age</th>\n",
              "      <th>Tm</th>\n",
              "      <th>G</th>\n",
              "      <th>GS</th>\n",
              "      <th>MP</th>\n",
              "      <th>FG</th>\n",
              "      <th>FGA</th>\n",
              "      <th>FG%</th>\n",
              "      <th>...</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>Álex Abrines</td>\n",
              "      <td>SG</td>\n",
              "      <td>25</td>\n",
              "      <td>OKC</td>\n",
              "      <td>31</td>\n",
              "      <td>2</td>\n",
              "      <td>19.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>5.1</td>\n",
              "      <td>.357</td>\n",
              "      <td>...</td>\n",
              "      <td>.923</td>\n",
              "      <td>0.2</td>\n",
              "      <td>1.4</td>\n",
              "      <td>1.5</td>\n",
              "      <td>0.6</td>\n",
              "      <td>0.5</td>\n",
              "      <td>0.2</td>\n",
              "      <td>0.5</td>\n",
              "      <td>1.7</td>\n",
              "      <td>5.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Quincy Acy</td>\n",
              "      <td>PF</td>\n",
              "      <td>28</td>\n",
              "      <td>PHO</td>\n",
              "      <td>10</td>\n",
              "      <td>0</td>\n",
              "      <td>12.3</td>\n",
              "      <td>0.4</td>\n",
              "      <td>1.8</td>\n",
              "      <td>.222</td>\n",
              "      <td>...</td>\n",
              "      <td>.700</td>\n",
              "      <td>0.3</td>\n",
              "      <td>2.2</td>\n",
              "      <td>2.5</td>\n",
              "      <td>0.8</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.4</td>\n",
              "      <td>0.4</td>\n",
              "      <td>2.4</td>\n",
              "      <td>1.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Jaylen Adams</td>\n",
              "      <td>PG</td>\n",
              "      <td>22</td>\n",
              "      <td>ATL</td>\n",
              "      <td>34</td>\n",
              "      <td>1</td>\n",
              "      <td>12.6</td>\n",
              "      <td>1.1</td>\n",
              "      <td>3.2</td>\n",
              "      <td>.345</td>\n",
              "      <td>...</td>\n",
              "      <td>.778</td>\n",
              "      <td>0.3</td>\n",
              "      <td>1.4</td>\n",
              "      <td>1.8</td>\n",
              "      <td>1.9</td>\n",
              "      <td>0.4</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.8</td>\n",
              "      <td>1.3</td>\n",
              "      <td>3.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Steven Adams</td>\n",
              "      <td>C</td>\n",
              "      <td>25</td>\n",
              "      <td>OKC</td>\n",
              "      <td>80</td>\n",
              "      <td>80</td>\n",
              "      <td>33.4</td>\n",
              "      <td>6.0</td>\n",
              "      <td>10.1</td>\n",
              "      <td>.595</td>\n",
              "      <td>...</td>\n",
              "      <td>.500</td>\n",
              "      <td>4.9</td>\n",
              "      <td>4.6</td>\n",
              "      <td>9.5</td>\n",
              "      <td>1.6</td>\n",
              "      <td>1.5</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.7</td>\n",
              "      <td>2.6</td>\n",
              "      <td>13.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Bam Adebayo</td>\n",
              "      <td>C</td>\n",
              "      <td>21</td>\n",
              "      <td>MIA</td>\n",
              "      <td>82</td>\n",
              "      <td>28</td>\n",
              "      <td>23.3</td>\n",
              "      <td>3.4</td>\n",
              "      <td>5.9</td>\n",
              "      <td>.576</td>\n",
              "      <td>...</td>\n",
              "      <td>.735</td>\n",
              "      <td>2.0</td>\n",
              "      <td>5.3</td>\n",
              "      <td>7.3</td>\n",
              "      <td>2.2</td>\n",
              "      <td>0.9</td>\n",
              "      <td>0.8</td>\n",
              "      <td>1.5</td>\n",
              "      <td>2.5</td>\n",
              "      <td>8.9</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 29 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b22dd43a-f6a7-4815-840d-f1ed575234d0')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-b22dd43a-f6a7-4815-840d-f1ed575234d0 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-b22dd43a-f6a7-4815-840d-f1ed575234d0');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 64
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "Season_2020.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 235
        },
        "id": "R4qsDbDg2Tfo",
        "outputId": "21137d85-0eac-4b0b-c5a1-919ecf8fbee2"
      },
      "execution_count": 66,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                     Player Pos Age   Tm   G  GS    MP   FG   FGA   FG%  ...  \\\n",
              "0              Steven Adams   C  26  OKC  63  63  26.7  4.5   7.6  .592  ...   \n",
              "1               Bam Adebayo  PF  22  MIA  72  72  33.6  6.1  11.0  .557  ...   \n",
              "2         LaMarcus Aldridge   C  34  SAS  53  53  33.1  7.4  15.0  .493  ...   \n",
              "3            Kyle Alexander   C  23  MIA   2   0   6.5  0.5   1.0  .500  ...   \n",
              "4  Nickeil Alexander-Walker  SG  21  NOP  47   1  12.6  2.1   5.7  .368  ...   \n",
              "\n",
              "    FT%  ORB  DRB   TRB  AST  STL  BLK  TOV   PF   PTS  \n",
              "0  .582  3.3  6.0   9.3  2.3  0.8  1.1  1.5  1.9  10.9  \n",
              "1  .691  2.4  7.8  10.2  5.1  1.1  1.3  2.8  2.5  15.9  \n",
              "2  .827  1.9  5.5   7.4  2.4  0.7  1.6  1.4  2.4  18.9  \n",
              "3        1.0  0.5   1.5  0.0  0.0  0.0  0.5  0.5   1.0  \n",
              "4  .676  0.2  1.6   1.8  1.9  0.4  0.2  1.1  1.2   5.7  \n",
              "\n",
              "[5 rows x 29 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-754531de-3248-430f-9f2b-f2d4d3eae533\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player</th>\n",
              "      <th>Pos</th>\n",
              "      <th>Age</th>\n",
              "      <th>Tm</th>\n",
              "      <th>G</th>\n",
              "      <th>GS</th>\n",
              "      <th>MP</th>\n",
              "      <th>FG</th>\n",
              "      <th>FGA</th>\n",
              "      <th>FG%</th>\n",
              "      <th>...</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>Steven Adams</td>\n",
              "      <td>C</td>\n",
              "      <td>26</td>\n",
              "      <td>OKC</td>\n",
              "      <td>63</td>\n",
              "      <td>63</td>\n",
              "      <td>26.7</td>\n",
              "      <td>4.5</td>\n",
              "      <td>7.6</td>\n",
              "      <td>.592</td>\n",
              "      <td>...</td>\n",
              "      <td>.582</td>\n",
              "      <td>3.3</td>\n",
              "      <td>6.0</td>\n",
              "      <td>9.3</td>\n",
              "      <td>2.3</td>\n",
              "      <td>0.8</td>\n",
              "      <td>1.1</td>\n",
              "      <td>1.5</td>\n",
              "      <td>1.9</td>\n",
              "      <td>10.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Bam Adebayo</td>\n",
              "      <td>PF</td>\n",
              "      <td>22</td>\n",
              "      <td>MIA</td>\n",
              "      <td>72</td>\n",
              "      <td>72</td>\n",
              "      <td>33.6</td>\n",
              "      <td>6.1</td>\n",
              "      <td>11.0</td>\n",
              "      <td>.557</td>\n",
              "      <td>...</td>\n",
              "      <td>.691</td>\n",
              "      <td>2.4</td>\n",
              "      <td>7.8</td>\n",
              "      <td>10.2</td>\n",
              "      <td>5.1</td>\n",
              "      <td>1.1</td>\n",
              "      <td>1.3</td>\n",
              "      <td>2.8</td>\n",
              "      <td>2.5</td>\n",
              "      <td>15.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>LaMarcus Aldridge</td>\n",
              "      <td>C</td>\n",
              "      <td>34</td>\n",
              "      <td>SAS</td>\n",
              "      <td>53</td>\n",
              "      <td>53</td>\n",
              "      <td>33.1</td>\n",
              "      <td>7.4</td>\n",
              "      <td>15.0</td>\n",
              "      <td>.493</td>\n",
              "      <td>...</td>\n",
              "      <td>.827</td>\n",
              "      <td>1.9</td>\n",
              "      <td>5.5</td>\n",
              "      <td>7.4</td>\n",
              "      <td>2.4</td>\n",
              "      <td>0.7</td>\n",
              "      <td>1.6</td>\n",
              "      <td>1.4</td>\n",
              "      <td>2.4</td>\n",
              "      <td>18.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Kyle Alexander</td>\n",
              "      <td>C</td>\n",
              "      <td>23</td>\n",
              "      <td>MIA</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>6.5</td>\n",
              "      <td>0.5</td>\n",
              "      <td>1.0</td>\n",
              "      <td>.500</td>\n",
              "      <td>...</td>\n",
              "      <td></td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.5</td>\n",
              "      <td>1.5</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.5</td>\n",
              "      <td>0.5</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Nickeil Alexander-Walker</td>\n",
              "      <td>SG</td>\n",
              "      <td>21</td>\n",
              "      <td>NOP</td>\n",
              "      <td>47</td>\n",
              "      <td>1</td>\n",
              "      <td>12.6</td>\n",
              "      <td>2.1</td>\n",
              "      <td>5.7</td>\n",
              "      <td>.368</td>\n",
              "      <td>...</td>\n",
              "      <td>.676</td>\n",
              "      <td>0.2</td>\n",
              "      <td>1.6</td>\n",
              "      <td>1.8</td>\n",
              "      <td>1.9</td>\n",
              "      <td>0.4</td>\n",
              "      <td>0.2</td>\n",
              "      <td>1.1</td>\n",
              "      <td>1.2</td>\n",
              "      <td>5.7</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 29 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-754531de-3248-430f-9f2b-f2d4d3eae533')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-754531de-3248-430f-9f2b-f2d4d3eae533 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-754531de-3248-430f-9f2b-f2d4d3eae533');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 66
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        ""
      ],
      "metadata": {
        "id": "J29c5Zug2WP_"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}