7. Pandas NBA & Solving.ipynb

{"cells":[{"cell_type":"markdown","metadata":{"id":"qFy52LdC9vPn"},"source":["Introduction\n","\n","pada notebook akan dilakukan proses ....\n","\n","Objective pada notebook ini adalah mencari ...."]},{"cell_type":"code","execution_count":null,"metadata":{"id":"1PHXEdXU9vPr"},"outputs":[],"source":["import pandas as pd\n","import numpy as np"]},{"cell_type":"code","execution_count":null,"metadata":{"scrolled":true,"id":"JBvz72tW9vPs"},"outputs":[],"source":["df = pd.read_csv('nbaallelo.csv')"]},{"cell_type":"code","execution_count":null,"metadata":{"scrolled":true,"id":"MKfxpSBu9vPs","outputId":"73a67cc2-8426-4a28-940b-9d92f005432c"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>...</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>...</td>\n","      <td>40.294830</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0000</td>\n","      <td>1306.7233</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>...</td>\n","      <td>41.705170</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0000</td>\n","      <td>1293.2767</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>...</td>\n","      <td>42.012257</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>1306.7233</td>\n","      <td>1297.0712</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.631101</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>...</td>\n","      <td>40.692783</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>1300.0000</td>\n","      <td>1309.6521</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.368899</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>3</td>\n","      <td>194611020DTF</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>DTF</td>\n","      <td>Falcons</td>\n","      <td>...</td>\n","      <td>38.864048</td>\n","      <td>WSC</td>\n","      <td>Capitols</td>\n","      <td>50</td>\n","      <td>1300.0000</td>\n","      <td>1320.3811</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>5 rows × 23 columns</p>\n","</div>"],"text/plain":["   gameorder       game_id lg_id  _iscopy  year_id  date_game  seasongame  \\\n","0          1  194611010TRH   NBA        0     1947  11/1/1946           1   \n","1          1  194611010TRH   NBA        1     1947  11/1/1946           1   \n","2          2  194611020CHS   NBA        0     1947  11/2/1946           1   \n","3          2  194611020CHS   NBA        1     1947  11/2/1946           2   \n","4          3  194611020DTF   NBA        0     1947  11/2/1946           1   \n","\n","   is_playoffs team_id  fran_id  ...  win_equiv  opp_id  opp_fran  opp_pts  \\\n","0            0     TRH  Huskies  ...  40.294830     NYK    Knicks       68   \n","1            0     NYK   Knicks  ...  41.705170     TRH   Huskies       66   \n","2            0     CHS    Stags  ...  42.012257     NYK    Knicks       47   \n","3            0     NYK   Knicks  ...  40.692783     CHS     Stags       63   \n","4            0     DTF  Falcons  ...  38.864048     WSC  Capitols       50   \n","\n","   opp_elo_i  opp_elo_n  game_location  game_result  forecast notes  \n","0  1300.0000  1306.7233              H            L  0.640065   NaN  \n","1  1300.0000  1293.2767              A            W  0.359935   NaN  \n","2  1306.7233  1297.0712              H            W  0.631101   NaN  \n","3  1300.0000  1309.6521              A            L  0.368899   NaN  \n","4  1300.0000  1320.3811              H            L  0.640065   NaN  \n","\n","[5 rows x 23 columns]"]},"execution_count":3,"metadata":{},"output_type":"execute_result"}],"source":["df.head()"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"Rb4Z2kHs9vPu"},"outputs":[],"source":["pd.set_option(\"display.max.columns\", None)"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"IeOgG5Ps9vPv","outputId":"27cd29ff-b87f-419f-833e-020b95957405"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0000</td>\n","      <td>1293.2767</td>\n","      <td>40.294830</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0000</td>\n","      <td>1306.7233</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0000</td>\n","      <td>1306.7233</td>\n","      <td>41.705170</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0000</td>\n","      <td>1293.2767</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>1300.0000</td>\n","      <td>1309.6521</td>\n","      <td>42.012257</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>1306.7233</td>\n","      <td>1297.0712</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.631101</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>1306.7233</td>\n","      <td>1297.0712</td>\n","      <td>40.692783</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>1300.0000</td>\n","      <td>1309.6521</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.368899</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>3</td>\n","      <td>194611020DTF</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>DTF</td>\n","      <td>Falcons</td>\n","      <td>33</td>\n","      <td>1300.0000</td>\n","      <td>1279.6189</td>\n","      <td>38.864048</td>\n","      <td>WSC</td>\n","      <td>Capitols</td>\n","      <td>50</td>\n","      <td>1300.0000</td>\n","      <td>1320.3811</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   gameorder       game_id lg_id  _iscopy  year_id  date_game  seasongame  \\\n","0          1  194611010TRH   NBA        0     1947  11/1/1946           1   \n","1          1  194611010TRH   NBA        1     1947  11/1/1946           1   \n","2          2  194611020CHS   NBA        0     1947  11/2/1946           1   \n","3          2  194611020CHS   NBA        1     1947  11/2/1946           2   \n","4          3  194611020DTF   NBA        0     1947  11/2/1946           1   \n","\n","   is_playoffs team_id  fran_id  pts      elo_i      elo_n  win_equiv opp_id  \\\n","0            0     TRH  Huskies   66  1300.0000  1293.2767  40.294830    NYK   \n","1            0     NYK   Knicks   68  1300.0000  1306.7233  41.705170    TRH   \n","2            0     CHS    Stags   63  1300.0000  1309.6521  42.012257    NYK   \n","3            0     NYK   Knicks   47  1306.7233  1297.0712  40.692783    CHS   \n","4            0     DTF  Falcons   33  1300.0000  1279.6189  38.864048    WSC   \n","\n","   opp_fran  opp_pts  opp_elo_i  opp_elo_n game_location game_result  \\\n","0    Knicks       68  1300.0000  1306.7233             H           L   \n","1   Huskies       66  1300.0000  1293.2767             A           W   \n","2    Knicks       47  1306.7233  1297.0712             H           W   \n","3     Stags       63  1300.0000  1309.6521             A           L   \n","4  Capitols       50  1300.0000  1320.3811             H           L   \n","\n","   forecast notes  \n","0  0.640065   NaN  \n","1  0.359935   NaN  \n","2  0.631101   NaN  \n","3  0.368899   NaN  \n","4  0.640065   NaN  "]},"execution_count":5,"metadata":{},"output_type":"execute_result"}],"source":["df.head()"]},{"cell_type":"code","execution_count":null,"metadata":{"scrolled":true,"id":"RAUiwqX39vPw","outputId":"e8d9dec0-e989-474b-971c-f66672054f16"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>126311</th>\n","      <td>63156</td>\n","      <td>201506140GSW</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/14/2015</td>\n","      <td>101</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>91</td>\n","      <td>1704.3949</td>\n","      <td>1700.7391</td>\n","      <td>60.010067</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>104</td>\n","      <td>1809.9791</td>\n","      <td>1813.6349</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.234435</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126312</th>\n","      <td>63157</td>\n","      <td>201506170CLE</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/16/2015</td>\n","      <td>102</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>97</td>\n","      <td>1700.7391</td>\n","      <td>1692.0859</td>\n","      <td>59.290245</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>105</td>\n","      <td>1813.6349</td>\n","      <td>1822.2881</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.481450</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126313</th>\n","      <td>63157</td>\n","      <td>201506170CLE</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/16/2015</td>\n","      <td>103</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>105</td>\n","      <td>1813.6349</td>\n","      <td>1822.2881</td>\n","      <td>68.519516</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>97</td>\n","      <td>1700.7391</td>\n","      <td>1692.0859</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.518550</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["        gameorder       game_id lg_id  _iscopy  year_id  date_game  \\\n","126311      63156  201506140GSW   NBA        1     2015  6/14/2015   \n","126312      63157  201506170CLE   NBA        0     2015  6/16/2015   \n","126313      63157  201506170CLE   NBA        1     2015  6/16/2015   \n","\n","        seasongame  is_playoffs team_id    fran_id  pts      elo_i      elo_n  \\\n","126311         101            1     CLE  Cavaliers   91  1704.3949  1700.7391   \n","126312         102            1     CLE  Cavaliers   97  1700.7391  1692.0859   \n","126313         103            1     GSW   Warriors  105  1813.6349  1822.2881   \n","\n","        win_equiv opp_id   opp_fran  opp_pts  opp_elo_i  opp_elo_n  \\\n","126311  60.010067    GSW   Warriors      104  1809.9791  1813.6349   \n","126312  59.290245    GSW   Warriors      105  1813.6349  1822.2881   \n","126313  68.519516    CLE  Cavaliers       97  1700.7391  1692.0859   \n","\n","       game_location game_result  forecast notes  \n","126311             A           L  0.234435   NaN  \n","126312             H           L  0.481450   NaN  \n","126313             A           W  0.518550   NaN  "]},"execution_count":6,"metadata":{},"output_type":"execute_result"}],"source":["df.tail(3)"]},{"cell_type":"code","execution_count":null,"metadata":{"scrolled":true,"id":"RS-q0tFl9vPx","outputId":"04933146-753a-40ce-8953-a218baf82a54"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>61675</th>\n","      <td>30838</td>\n","      <td>198904150ATL</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1989</td>\n","      <td>4/15/1989</td>\n","      <td>77</td>\n","      <td>0</td>\n","      <td>MIL</td>\n","      <td>Bucks</td>\n","      <td>100</td>\n","      <td>1595.2563</td>\n","      <td>1583.4548</td>\n","      <td>50.847076</td>\n","      <td>ATL</td>\n","      <td>Hawks</td>\n","      <td>125</td>\n","      <td>1612.9885</td>\n","      <td>1624.7900</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.336770</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>92990</th>\n","      <td>46496</td>\n","      <td>200211120IND</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2003</td>\n","      <td>11/12/2002</td>\n","      <td>7</td>\n","      <td>0</td>\n","      <td>IND</td>\n","      <td>Pacers</td>\n","      <td>95</td>\n","      <td>1538.2109</td>\n","      <td>1544.4546</td>\n","      <td>45.382847</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>75</td>\n","      <td>1421.9254</td>\n","      <td>1415.6818</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.776440</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>16115</th>\n","      <td>8058</td>\n","      <td>196801100CIN</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1968</td>\n","      <td>1/10/1968</td>\n","      <td>40</td>\n","      <td>0</td>\n","      <td>BAL</td>\n","      <td>Wizards</td>\n","      <td>117</td>\n","      <td>1384.8905</td>\n","      <td>1377.4176</td>\n","      <td>32.921989</td>\n","      <td>CIN</td>\n","      <td>Kings</td>\n","      <td>133</td>\n","      <td>1434.1438</td>\n","      <td>1441.6167</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.297513</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>24098</th>\n","      <td>12050</td>\n","      <td>197110190NYK</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1972</td>\n","      <td>10/19/1971</td>\n","      <td>4</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>93</td>\n","      <td>1482.0095</td>\n","      <td>1487.7288</td>\n","      <td>44.255699</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>84</td>\n","      <td>1454.1217</td>\n","      <td>1448.4025</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.676160</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>81673</th>\n","      <td>40837</td>\n","      <td>199712090WAS</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1998</td>\n","      <td>12/9/1997</td>\n","      <td>20</td>\n","      <td>0</td>\n","      <td>WAS</td>\n","      <td>Wizards</td>\n","      <td>120</td>\n","      <td>1524.4211</td>\n","      <td>1534.1227</td>\n","      <td>45.140732</td>\n","      <td>NJN</td>\n","      <td>Nets</td>\n","      <td>99</td>\n","      <td>1490.9111</td>\n","      <td>1481.2096</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.683206</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["       gameorder       game_id lg_id  _iscopy  year_id   date_game  \\\n","61675      30838  198904150ATL   NBA        1     1989   4/15/1989   \n","92990      46496  200211120IND   NBA        0     2003  11/12/2002   \n","16115       8058  196801100CIN   NBA        1     1968   1/10/1968   \n","24098      12050  197110190NYK   NBA        0     1972  10/19/1971   \n","81673      40837  199712090WAS   NBA        0     1998   12/9/1997   \n","\n","       seasongame  is_playoffs team_id  fran_id  pts      elo_i      elo_n  \\\n","61675          77            0     MIL    Bucks  100  1595.2563  1583.4548   \n","92990           7            0     IND   Pacers   95  1538.2109  1544.4546   \n","16115          40            0     BAL  Wizards  117  1384.8905  1377.4176   \n","24098           4            0     NYK   Knicks   93  1482.0095  1487.7288   \n","81673          20            0     WAS  Wizards  120  1524.4211  1534.1227   \n","\n","       win_equiv opp_id   opp_fran  opp_pts  opp_elo_i  opp_elo_n  \\\n","61675  50.847076    ATL      Hawks      125  1612.9885  1624.7900   \n","92990  45.382847    CLE  Cavaliers       75  1421.9254  1415.6818   \n","16115  32.921989    CIN      Kings      133  1434.1438  1441.6167   \n","24098  44.255699    GSW   Warriors       84  1454.1217  1448.4025   \n","81673  45.140732    NJN       Nets       99  1490.9111  1481.2096   \n","\n","      game_location game_result  forecast notes  \n","61675             A           L  0.336770   NaN  \n","92990             H           W  0.776440   NaN  \n","16115             A           L  0.297513   NaN  \n","24098             H           W  0.676160   NaN  \n","81673             H           W  0.683206   NaN  "]},"execution_count":7,"metadata":{},"output_type":"execute_result"}],"source":["df.sample(5)"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"6sBKbQet9vPx","outputId":"b56275a1-66bc-4ad8-eab0-e872be741e15"},"outputs":[{"data":{"text/plain":["(126314, 23)"]},"execution_count":8,"metadata":{},"output_type":"execute_result"}],"source":["df.shape"]},{"cell_type":"markdown","metadata":{"id":"MgNuuWvP9vPy"},"source":["## **Data Overview**"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"U1mOUFoH9vPy","outputId":"812bafc3-e71d-4ac6-9aee-4715bc3d1b22"},"outputs":[{"name":"stdout","output_type":"stream","text":["<class 'pandas.core.frame.DataFrame'>\n","RangeIndex: 126314 entries, 0 to 126313\n","Data columns (total 23 columns):\n"," #   Column         Non-Null Count   Dtype  \n","---  ------         --------------   -----  \n"," 0   gameorder      126314 non-null  int64  \n"," 1   game_id        126314 non-null  object \n"," 2   lg_id          126314 non-null  object \n"," 3   _iscopy        126314 non-null  int64  \n"," 4   year_id        126314 non-null  int64  \n"," 5   date_game      126314 non-null  object \n"," 6   seasongame     126314 non-null  int64  \n"," 7   is_playoffs    126314 non-null  int64  \n"," 8   team_id        126314 non-null  object \n"," 9   fran_id        126314 non-null  object \n"," 10  pts            126314 non-null  int64  \n"," 11  elo_i          126314 non-null  float64\n"," 12  elo_n          126314 non-null  float64\n"," 13  win_equiv      126314 non-null  float64\n"," 14  opp_id         126314 non-null  object \n"," 15  opp_fran       126314 non-null  object \n"," 16  opp_pts        126314 non-null  int64  \n"," 17  opp_elo_i      126314 non-null  float64\n"," 18  opp_elo_n      126314 non-null  float64\n"," 19  game_location  126314 non-null  object \n"," 20  game_result    126314 non-null  object \n"," 21  forecast       126314 non-null  float64\n"," 22  notes          5424 non-null    object \n","dtypes: float64(6), int64(7), object(10)\n","memory usage: 22.2+ MB\n"]}],"source":["df.info()"]},{"cell_type":"code","execution_count":null,"metadata":{"scrolled":true,"id":"lyOJTO1E9vPy","outputId":"a2909cb2-248c-4e1a-9325-650746e79183"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>count</th>\n","      <th>mean</th>\n","      <th>std</th>\n","      <th>min</th>\n","      <th>25%</th>\n","      <th>50%</th>\n","      <th>75%</th>\n","      <th>max</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>gameorder</th>\n","      <td>126314.0</td>\n","      <td>31579.000000</td>\n","      <td>18231.927643</td>\n","      <td>1.000000</td>\n","      <td>15790.000000</td>\n","      <td>31579.000000</td>\n","      <td>47368.000000</td>\n","      <td>63157.000000</td>\n","    </tr>\n","    <tr>\n","      <th>_iscopy</th>\n","      <td>126314.0</td>\n","      <td>0.500000</td>\n","      <td>0.500002</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.500000</td>\n","      <td>1.000000</td>\n","      <td>1.000000</td>\n","    </tr>\n","    <tr>\n","      <th>year_id</th>\n","      <td>126314.0</td>\n","      <td>1988.200374</td>\n","      <td>17.582309</td>\n","      <td>1947.000000</td>\n","      <td>1975.000000</td>\n","      <td>1990.000000</td>\n","      <td>2003.000000</td>\n","      <td>2015.000000</td>\n","    </tr>\n","    <tr>\n","      <th>seasongame</th>\n","      <td>126314.0</td>\n","      <td>43.533733</td>\n","      <td>25.375178</td>\n","      <td>1.000000</td>\n","      <td>22.000000</td>\n","      <td>43.000000</td>\n","      <td>65.000000</td>\n","      <td>108.000000</td>\n","    </tr>\n","    <tr>\n","      <th>is_playoffs</th>\n","      <td>126314.0</td>\n","      <td>0.063857</td>\n","      <td>0.244499</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>1.000000</td>\n","    </tr>\n","    <tr>\n","      <th>pts</th>\n","      <td>126314.0</td>\n","      <td>102.729982</td>\n","      <td>14.814845</td>\n","      <td>0.000000</td>\n","      <td>93.000000</td>\n","      <td>103.000000</td>\n","      <td>112.000000</td>\n","      <td>186.000000</td>\n","    </tr>\n","    <tr>\n","      <th>elo_i</th>\n","      <td>126314.0</td>\n","      <td>1495.236055</td>\n","      <td>112.139945</td>\n","      <td>1091.644500</td>\n","      <td>1417.237975</td>\n","      <td>1500.945550</td>\n","      <td>1576.060000</td>\n","      <td>1853.104500</td>\n","    </tr>\n","    <tr>\n","      <th>elo_n</th>\n","      <td>126314.0</td>\n","      <td>1495.236055</td>\n","      <td>112.461687</td>\n","      <td>1085.774400</td>\n","      <td>1416.994900</td>\n","      <td>1500.954400</td>\n","      <td>1576.291625</td>\n","      <td>1853.104500</td>\n","    </tr>\n","    <tr>\n","      <th>win_equiv</th>\n","      <td>126314.0</td>\n","      <td>41.707889</td>\n","      <td>10.627332</td>\n","      <td>10.152501</td>\n","      <td>34.103035</td>\n","      <td>42.113357</td>\n","      <td>49.635328</td>\n","      <td>71.112038</td>\n","    </tr>\n","    <tr>\n","      <th>opp_pts</th>\n","      <td>126314.0</td>\n","      <td>102.729982</td>\n","      <td>14.814845</td>\n","      <td>0.000000</td>\n","      <td>93.000000</td>\n","      <td>103.000000</td>\n","      <td>112.000000</td>\n","      <td>186.000000</td>\n","    </tr>\n","    <tr>\n","      <th>opp_elo_i</th>\n","      <td>126314.0</td>\n","      <td>1495.236055</td>\n","      <td>112.139945</td>\n","      <td>1091.644500</td>\n","      <td>1417.237975</td>\n","      <td>1500.945550</td>\n","      <td>1576.060000</td>\n","      <td>1853.104500</td>\n","    </tr>\n","    <tr>\n","      <th>opp_elo_n</th>\n","      <td>126314.0</td>\n","      <td>1495.236055</td>\n","      <td>112.461687</td>\n","      <td>1085.774400</td>\n","      <td>1416.994900</td>\n","      <td>1500.954400</td>\n","      <td>1576.291625</td>\n","      <td>1853.104500</td>\n","    </tr>\n","    <tr>\n","      <th>forecast</th>\n","      <td>126314.0</td>\n","      <td>0.500000</td>\n","      <td>0.215252</td>\n","      <td>0.020447</td>\n","      <td>0.327989</td>\n","      <td>0.500000</td>\n","      <td>0.672011</td>\n","      <td>0.979553</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                count          mean           std          min           25%  \\\n","gameorder    126314.0  31579.000000  18231.927643     1.000000  15790.000000   \n","_iscopy      126314.0      0.500000      0.500002     0.000000      0.000000   \n","year_id      126314.0   1988.200374     17.582309  1947.000000   1975.000000   \n","seasongame   126314.0     43.533733     25.375178     1.000000     22.000000   \n","is_playoffs  126314.0      0.063857      0.244499     0.000000      0.000000   \n","pts          126314.0    102.729982     14.814845     0.000000     93.000000   \n","elo_i        126314.0   1495.236055    112.139945  1091.644500   1417.237975   \n","elo_n        126314.0   1495.236055    112.461687  1085.774400   1416.994900   \n","win_equiv    126314.0     41.707889     10.627332    10.152501     34.103035   \n","opp_pts      126314.0    102.729982     14.814845     0.000000     93.000000   \n","opp_elo_i    126314.0   1495.236055    112.139945  1091.644500   1417.237975   \n","opp_elo_n    126314.0   1495.236055    112.461687  1085.774400   1416.994900   \n","forecast     126314.0      0.500000      0.215252     0.020447      0.327989   \n","\n","                      50%           75%           max  \n","gameorder    31579.000000  47368.000000  63157.000000  \n","_iscopy          0.500000      1.000000      1.000000  \n","year_id       1990.000000   2003.000000   2015.000000  \n","seasongame      43.000000     65.000000    108.000000  \n","is_playoffs      0.000000      0.000000      1.000000  \n","pts            103.000000    112.000000    186.000000  \n","elo_i         1500.945550   1576.060000   1853.104500  \n","elo_n         1500.954400   1576.291625   1853.104500  \n","win_equiv       42.113357     49.635328     71.112038  \n","opp_pts        103.000000    112.000000    186.000000  \n","opp_elo_i     1500.945550   1576.060000   1853.104500  \n","opp_elo_n     1500.954400   1576.291625   1853.104500  \n","forecast         0.500000      0.672011      0.979553  "]},"execution_count":10,"metadata":{},"output_type":"execute_result"}],"source":["df.describe().T"]},{"cell_type":"markdown","metadata":{"id":"aUKyDoVT9vPy"},"source":["Berdasarkan overview yang dilakukan didapatkan temuan:\n","- missing value ditemukan pada ...\n","- pts anomali ....."]},{"cell_type":"markdown","metadata":{"id":"ELOBhNmh9vPz"},"source":["## **Data Exploration**"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"_bVx8Rju9vPz","outputId":"da2eb869-5802-4555-b7fa-a9602e24d0b3"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0</td>\n","      <td>1293.2767</td>\n","      <td>40.294830</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0000</td>\n","      <td>1306.7233</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0</td>\n","      <td>1306.7233</td>\n","      <td>41.705170</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0000</td>\n","      <td>1293.2767</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>1300.0</td>\n","      <td>1309.6521</td>\n","      <td>42.012257</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>1306.7233</td>\n","      <td>1297.0712</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.631101</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   gameorder       game_id lg_id  _iscopy  year_id  date_game  seasongame  \\\n","0          1  194611010TRH   NBA        0     1947  11/1/1946           1   \n","1          1  194611010TRH   NBA        1     1947  11/1/1946           1   \n","2          2  194611020CHS   NBA        0     1947  11/2/1946           1   \n","\n","   is_playoffs team_id  fran_id  pts   elo_i      elo_n  win_equiv opp_id  \\\n","0            0     TRH  Huskies   66  1300.0  1293.2767  40.294830    NYK   \n","1            0     NYK   Knicks   68  1300.0  1306.7233  41.705170    TRH   \n","2            0     CHS    Stags   63  1300.0  1309.6521  42.012257    NYK   \n","\n","  opp_fran  opp_pts  opp_elo_i  opp_elo_n game_location game_result  forecast  \\\n","0   Knicks       68  1300.0000  1306.7233             H           L  0.640065   \n","1  Huskies       66  1300.0000  1293.2767             A           W  0.359935   \n","2   Knicks       47  1306.7233  1297.0712             H           W  0.631101   \n","\n","  notes  \n","0   NaN  \n","1   NaN  \n","2   NaN  "]},"execution_count":11,"metadata":{},"output_type":"execute_result"}],"source":["df.head(3)"]},{"cell_type":"code","execution_count":null,"metadata":{"scrolled":true,"id":"QRWAFnxN9vPz","outputId":"d2a027be-66f9-4157-c115-ea8bb230e612"},"outputs":[{"data":{"text/plain":["array(['TRH', 'NYK', 'CHS', 'DTF', 'WSC', 'BOS', 'PRO', 'PIT', 'STB',\n","       'CLR', 'PHW', 'BLB', 'INJ', 'FTW', 'MNL', 'ROC', 'TRI', 'DNN',\n","       'INO', 'SHE', 'WAT', 'AND', 'SYR', 'MLH', 'STL', 'DET', 'CIN',\n","       'LAL', 'CHP', 'CHZ', 'SFW', 'BAL', 'PHI', 'CHI', 'SEA', 'OAK',\n","       'ANA', 'SDR', 'KEN', 'INA', 'DNR', 'DLC', 'HSM', 'NOB', 'MNM',\n","       'NJA', 'PTP', 'ATL', 'MIL', 'PHO', 'NYA', 'MMF', 'MNP', 'LAS',\n","       'CAR', 'WSA', 'BUF', 'CLE', 'UTS', 'FLO', 'PTC', 'POR', 'VIR',\n","       'TEX', 'MMP', 'HOU', 'GSW', 'KCO', 'MMT', 'SDA', 'CAP', 'SAA',\n","       'NOJ', 'DNA', 'SSL', 'MMS', 'WSB', 'KCK', 'SDS', 'IND', 'NYN',\n","       'DEN', 'SAS', 'NJN', 'SDC', 'UTA', 'DAL', 'LAC', 'SAC', 'CHH',\n","       'MIA', 'MIN', 'ORL', 'VAN', 'TOR', 'WAS', 'MEM', 'NOH', 'CHA',\n","       'NOK', 'OKC', 'BRK', 'NOP', 'CHO'], dtype=object)"]},"execution_count":12,"metadata":{},"output_type":"execute_result"}],"source":["df['team_id'].unique()"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"bLM-p1fZ9vPz","outputId":"3bae5120-e67b-49cc-cbbe-f3eda87bffdd"},"outputs":[{"data":{"text/plain":["BOS    5997\n","NYK    5769\n","LAL    5078\n","Name: team_id, dtype: int64"]},"execution_count":13,"metadata":{},"output_type":"execute_result"}],"source":["df['team_id'].value_counts().head(3)"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"w8LyNg6s9vP0","outputId":"899b82e8-69a4-46a2-da52-f259f068bd32"},"outputs":[{"data":{"text/plain":["Lakers     6024\n","Celtics    5997\n","Knicks     5769\n","Name: fran_id, dtype: int64"]},"execution_count":14,"metadata":{},"output_type":"execute_result"}],"source":["df['fran_id'].value_counts().head(3)"]},{"cell_type":"markdown","metadata":{"id":"oflM9bER9vP0"},"source":["Hmm there is inconsistency ....."]},{"cell_type":"code","execution_count":null,"metadata":{"id":"rSh3luMS9vP0","outputId":"b37d2fc9-76b0-4e42-d24f-2913b3c87653"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0</td>\n","      <td>1293.2767</td>\n","      <td>40.29483</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0</td>\n","      <td>1306.7233</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0</td>\n","      <td>1306.7233</td>\n","      <td>41.70517</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0</td>\n","      <td>1293.2767</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   gameorder       game_id lg_id  _iscopy  year_id  date_game  seasongame  \\\n","0          1  194611010TRH   NBA        0     1947  11/1/1946           1   \n","1          1  194611010TRH   NBA        1     1947  11/1/1946           1   \n","\n","   is_playoffs team_id  fran_id  pts   elo_i      elo_n  win_equiv opp_id  \\\n","0            0     TRH  Huskies   66  1300.0  1293.2767   40.29483    NYK   \n","1            0     NYK   Knicks   68  1300.0  1306.7233   41.70517    TRH   \n","\n","  opp_fran  opp_pts  opp_elo_i  opp_elo_n game_location game_result  forecast  \\\n","0   Knicks       68     1300.0  1306.7233             H           L  0.640065   \n","1  Huskies       66     1300.0  1293.2767             A           W  0.359935   \n","\n","  notes  \n","0   NaN  \n","1   NaN  "]},"execution_count":15,"metadata":{},"output_type":"execute_result"}],"source":["df.head(2)"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"kUTfP30Q9vP0","outputId":"a96089fd-de99-4421-eb3d-c4813a71e198"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>1136</th>\n","      <td>569</td>\n","      <td>194811040BLB</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1949</td>\n","      <td>11/4/1948</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>84</td>\n","      <td>1527.0000</td>\n","      <td>1542.2545</td>\n","      <td>51.218754</td>\n","      <td>BLB</td>\n","      <td>Baltimore</td>\n","      <td>72</td>\n","      <td>1507.2052</td>\n","      <td>1491.9507</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.386583</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1152</th>\n","      <td>577</td>\n","      <td>194811060WSC</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1949</td>\n","      <td>11/6/1948</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>62</td>\n","      <td>1542.2545</td>\n","      <td>1536.2078</td>\n","      <td>50.621624</td>\n","      <td>WSC</td>\n","      <td>Capitols</td>\n","      <td>67</td>\n","      <td>1481.8721</td>\n","      <td>1487.9188</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.443232</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1159</th>\n","      <td>580</td>\n","      <td>194811090BOS</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1949</td>\n","      <td>11/9/1948</td>\n","      <td>3</td>\n","      <td>0</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>55</td>\n","      <td>1536.2078</td>\n","      <td>1513.4880</td>\n","      <td>48.341133</td>\n","      <td>BOS</td>\n","      <td>Celtics</td>\n","      <td>77</td>\n","      <td>1359.3345</td>\n","      <td>1382.0542</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.608859</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1170</th>\n","      <td>586</td>\n","      <td>194811110NYK</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1949</td>\n","      <td>11/11/1948</td>\n","      <td>4</td>\n","      <td>0</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>77</td>\n","      <td>1513.4880</td>\n","      <td>1524.9596</td>\n","      <td>49.499451</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1460.4232</td>\n","      <td>1448.9517</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.432863</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1183</th>\n","      <td>592</td>\n","      <td>194811130PRO</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1949</td>\n","      <td>11/13/1948</td>\n","      <td>5</td>\n","      <td>0</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>90</td>\n","      <td>1524.9596</td>\n","      <td>1533.2726</td>\n","      <td>50.330185</td>\n","      <td>PRO</td>\n","      <td>Steamrollers</td>\n","      <td>67</td>\n","      <td>1245.9456</td>\n","      <td>1237.6326</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.737010</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>126016</th>\n","      <td>63009</td>\n","      <td>201504080DEN</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>4/8/2015</td>\n","      <td>78</td>\n","      <td>0</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>101</td>\n","      <td>1313.7802</td>\n","      <td>1307.5118</td>\n","      <td>21.921890</td>\n","      <td>DEN</td>\n","      <td>Nuggets</td>\n","      <td>119</td>\n","      <td>1415.0565</td>\n","      <td>1421.3248</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.238914</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126052</th>\n","      <td>63027</td>\n","      <td>201504100LAL</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>4/10/2015</td>\n","      <td>79</td>\n","      <td>0</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>106</td>\n","      <td>1307.5118</td>\n","      <td>1312.9532</td>\n","      <td>22.371969</td>\n","      <td>MIN</td>\n","      <td>Timberwolves</td>\n","      <td>98</td>\n","      <td>1283.9249</td>\n","      <td>1278.4835</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.670716</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126086</th>\n","      <td>63044</td>\n","      <td>201504120LAL</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>4/12/2015</td>\n","      <td>80</td>\n","      <td>0</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>106</td>\n","      <td>1312.9532</td>\n","      <td>1305.9197</td>\n","      <td>21.791288</td>\n","      <td>DAL</td>\n","      <td>Mavericks</td>\n","      <td>120</td>\n","      <td>1556.2162</td>\n","      <td>1563.2498</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.304769</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126115</th>\n","      <td>63058</td>\n","      <td>201504130SAC</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>4/13/2015</td>\n","      <td>81</td>\n","      <td>0</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>92</td>\n","      <td>1305.9197</td>\n","      <td>1301.3918</td>\n","      <td>21.422607</td>\n","      <td>SAC</td>\n","      <td>Kings</td>\n","      <td>102</td>\n","      <td>1395.6000</td>\n","      <td>1400.1278</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.251263</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126137</th>\n","      <td>63069</td>\n","      <td>201504150LAL</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>4/15/2015</td>\n","      <td>82</td>\n","      <td>0</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>99</td>\n","      <td>1301.3918</td>\n","      <td>1283.2395</td>\n","      <td>19.985550</td>\n","      <td>SAC</td>\n","      <td>Kings</td>\n","      <td>122</td>\n","      <td>1400.1278</td>\n","      <td>1418.2802</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.501819</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>6024 rows × 23 columns</p>\n","</div>"],"text/plain":["        gameorder       game_id lg_id  _iscopy  year_id   date_game  \\\n","1136          569  194811040BLB   NBA        1     1949   11/4/1948   \n","1152          577  194811060WSC   NBA        1     1949   11/6/1948   \n","1159          580  194811090BOS   NBA        1     1949   11/9/1948   \n","1170          586  194811110NYK   NBA        1     1949  11/11/1948   \n","1183          592  194811130PRO   NBA        1     1949  11/13/1948   \n","...           ...           ...   ...      ...      ...         ...   \n","126016      63009  201504080DEN   NBA        1     2015    4/8/2015   \n","126052      63027  201504100LAL   NBA        0     2015   4/10/2015   \n","126086      63044  201504120LAL   NBA        0     2015   4/12/2015   \n","126115      63058  201504130SAC   NBA        1     2015   4/13/2015   \n","126137      63069  201504150LAL   NBA        0     2015   4/15/2015   \n","\n","        seasongame  is_playoffs team_id fran_id  pts      elo_i      elo_n  \\\n","1136             1            0     MNL  Lakers   84  1527.0000  1542.2545   \n","1152             2            0     MNL  Lakers   62  1542.2545  1536.2078   \n","1159             3            0     MNL  Lakers   55  1536.2078  1513.4880   \n","1170             4            0     MNL  Lakers   77  1513.4880  1524.9596   \n","1183             5            0     MNL  Lakers   90  1524.9596  1533.2726   \n","...            ...          ...     ...     ...  ...        ...        ...   \n","126016          78            0     LAL  Lakers  101  1313.7802  1307.5118   \n","126052          79            0     LAL  Lakers  106  1307.5118  1312.9532   \n","126086          80            0     LAL  Lakers  106  1312.9532  1305.9197   \n","126115          81            0     LAL  Lakers   92  1305.9197  1301.3918   \n","126137          82            0     LAL  Lakers   99  1301.3918  1283.2395   \n","\n","        win_equiv opp_id      opp_fran  opp_pts  opp_elo_i  opp_elo_n  \\\n","1136    51.218754    BLB     Baltimore       72  1507.2052  1491.9507   \n","1152    50.621624    WSC      Capitols       67  1481.8721  1487.9188   \n","1159    48.341133    BOS       Celtics       77  1359.3345  1382.0542   \n","1170    49.499451    NYK        Knicks       68  1460.4232  1448.9517   \n","1183    50.330185    PRO  Steamrollers       67  1245.9456  1237.6326   \n","...           ...    ...           ...      ...        ...        ...   \n","126016  21.921890    DEN       Nuggets      119  1415.0565  1421.3248   \n","126052  22.371969    MIN  Timberwolves       98  1283.9249  1278.4835   \n","126086  21.791288    DAL     Mavericks      120  1556.2162  1563.2498   \n","126115  21.422607    SAC         Kings      102  1395.6000  1400.1278   \n","126137  19.985550    SAC         Kings      122  1400.1278  1418.2802   \n","\n","       game_location game_result  forecast notes  \n","1136               A           W  0.386583   NaN  \n","1152               A           L  0.443232   NaN  \n","1159               A           L  0.608859   NaN  \n","1170               A           W  0.432863   NaN  \n","1183               A           W  0.737010   NaN  \n","...              ...         ...       ...   ...  \n","126016             A           L  0.238914   NaN  \n","126052             H           W  0.670716   NaN  \n","126086             H           L  0.304769   NaN  \n","126115             A           L  0.251263   NaN  \n","126137             H           L  0.501819   NaN  \n","\n","[6024 rows x 23 columns]"]},"execution_count":16,"metadata":{},"output_type":"execute_result"}],"source":["df.loc[df['fran_id']=='Lakers', :]"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"t9pmqZOU9vP0","outputId":"7c5dd0e8-918a-471f-e042-cfe5bc0f40d7"},"outputs":[{"data":{"text/plain":["LAL    5078\n","MNL     946\n","Name: team_id, dtype: int64"]},"execution_count":17,"metadata":{},"output_type":"execute_result"}],"source":["df.loc[df['fran_id']=='Lakers', 'team_id'].value_counts()"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"zLgjQ16s9vP1","outputId":"6a57cff0-61a6-4043-8b17-06d43d5fe2a4"},"outputs":[{"data":{"text/plain":["6024"]},"execution_count":18,"metadata":{},"output_type":"execute_result"}],"source":["5078 + 946"]},{"cell_type":"markdown","metadata":{"id":"x-wqTNCY9vP1"},"source":["It look likes Lakers had 2 team id .... "]},{"cell_type":"code","execution_count":null,"metadata":{"id":"aQcenhoW9vP1","outputId":"022299ea-3858-44f3-ab24-e75cf07d1437"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>year_id</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>opp_pts</th>\n","      <th>opp_fran</th>\n","      <th>opp_id</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>1136</th>\n","      <td>1949</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>84</td>\n","      <td>72</td>\n","      <td>Baltimore</td>\n","      <td>BLB</td>\n","    </tr>\n","    <tr>\n","      <th>1152</th>\n","      <td>1949</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>62</td>\n","      <td>67</td>\n","      <td>Capitols</td>\n","      <td>WSC</td>\n","    </tr>\n","    <tr>\n","      <th>1159</th>\n","      <td>1949</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>55</td>\n","      <td>77</td>\n","      <td>Celtics</td>\n","      <td>BOS</td>\n","    </tr>\n","    <tr>\n","      <th>1170</th>\n","      <td>1949</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>77</td>\n","      <td>68</td>\n","      <td>Knicks</td>\n","      <td>NYK</td>\n","    </tr>\n","    <tr>\n","      <th>1183</th>\n","      <td>1949</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>90</td>\n","      <td>67</td>\n","      <td>Steamrollers</td>\n","      <td>PRO</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>126016</th>\n","      <td>2015</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>101</td>\n","      <td>119</td>\n","      <td>Nuggets</td>\n","      <td>DEN</td>\n","    </tr>\n","    <tr>\n","      <th>126052</th>\n","      <td>2015</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>106</td>\n","      <td>98</td>\n","      <td>Timberwolves</td>\n","      <td>MIN</td>\n","    </tr>\n","    <tr>\n","      <th>126086</th>\n","      <td>2015</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>106</td>\n","      <td>120</td>\n","      <td>Mavericks</td>\n","      <td>DAL</td>\n","    </tr>\n","    <tr>\n","      <th>126115</th>\n","      <td>2015</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>92</td>\n","      <td>102</td>\n","      <td>Kings</td>\n","      <td>SAC</td>\n","    </tr>\n","    <tr>\n","      <th>126137</th>\n","      <td>2015</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>99</td>\n","      <td>122</td>\n","      <td>Kings</td>\n","      <td>SAC</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>6024 rows × 7 columns</p>\n","</div>"],"text/plain":["        year_id team_id fran_id  pts  opp_pts      opp_fran opp_id\n","1136       1949     MNL  Lakers   84       72     Baltimore    BLB\n","1152       1949     MNL  Lakers   62       67      Capitols    WSC\n","1159       1949     MNL  Lakers   55       77       Celtics    BOS\n","1170       1949     MNL  Lakers   77       68        Knicks    NYK\n","1183       1949     MNL  Lakers   90       67  Steamrollers    PRO\n","...         ...     ...     ...  ...      ...           ...    ...\n","126016     2015     LAL  Lakers  101      119       Nuggets    DEN\n","126052     2015     LAL  Lakers  106       98  Timberwolves    MIN\n","126086     2015     LAL  Lakers  106      120     Mavericks    DAL\n","126115     2015     LAL  Lakers   92      102         Kings    SAC\n","126137     2015     LAL  Lakers   99      122         Kings    SAC\n","\n","[6024 rows x 7 columns]"]},"execution_count":19,"metadata":{},"output_type":"execute_result"}],"source":["# .loc with multiple columns\n","df.loc[df['fran_id']=='Lakers', \n","       ['year_id', 'team_id', 'fran_id', 'pts', 'opp_pts', 'opp_fran', 'opp_id']]"]},{"cell_type":"code","execution_count":null,"metadata":{"scrolled":true,"id":"1VfER7QC9vP1","outputId":"de04ecce-2d27-46a1-bddb-2dfa1266c2af"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>9701</th>\n","      <td>4851</td>\n","      <td>196003190LAL</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1960</td>\n","      <td>3/19/1960</td>\n","      <td>80</td>\n","      <td>1</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>89</td>\n","      <td>1471.0741</td>\n","      <td>1464.6069</td>\n","      <td>36.052319</td>\n","      <td>STL</td>\n","      <td>Hawks</td>\n","      <td>93</td>\n","      <td>1564.9653</td>\n","      <td>1571.4325</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.508790</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>9702</th>\n","      <td>4852</td>\n","      <td>196003200LAL</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1960</td>\n","      <td>3/20/1960</td>\n","      <td>81</td>\n","      <td>1</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>103</td>\n","      <td>1464.6069</td>\n","      <td>1469.5608</td>\n","      <td>36.565147</td>\n","      <td>STL</td>\n","      <td>Hawks</td>\n","      <td>101</td>\n","      <td>1571.4325</td>\n","      <td>1566.4786</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.490178</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>9709</th>\n","      <td>4855</td>\n","      <td>196003220STL</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1960</td>\n","      <td>3/22/1960</td>\n","      <td>82</td>\n","      <td>1</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>117</td>\n","      <td>1469.5608</td>\n","      <td>1484.6693</td>\n","      <td>38.137211</td>\n","      <td>STL</td>\n","      <td>Hawks</td>\n","      <td>110</td>\n","      <td>1566.4786</td>\n","      <td>1551.3701</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.243506</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>9711</th>\n","      <td>4856</td>\n","      <td>196003240LAL</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1960</td>\n","      <td>3/24/1960</td>\n","      <td>83</td>\n","      <td>1</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>96</td>\n","      <td>1484.6693</td>\n","      <td>1465.5942</td>\n","      <td>36.154404</td>\n","      <td>STL</td>\n","      <td>Hawks</td>\n","      <td>117</td>\n","      <td>1551.3701</td>\n","      <td>1570.4452</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.547775</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>9715</th>\n","      <td>4858</td>\n","      <td>196003260STL</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1960</td>\n","      <td>3/26/1960</td>\n","      <td>84</td>\n","      <td>1</td>\n","      <td>MNL</td>\n","      <td>Lakers</td>\n","      <td>86</td>\n","      <td>1465.5942</td>\n","      <td>1461.1439</td>\n","      <td>35.694744</td>\n","      <td>STL</td>\n","      <td>Hawks</td>\n","      <td>97</td>\n","      <td>1570.4452</td>\n","      <td>1574.8955</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.235193</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["      gameorder       game_id lg_id  _iscopy  year_id  date_game  seasongame  \\\n","9701       4851  196003190LAL   NBA        0     1960  3/19/1960          80   \n","9702       4852  196003200LAL   NBA        0     1960  3/20/1960          81   \n","9709       4855  196003220STL   NBA        1     1960  3/22/1960          82   \n","9711       4856  196003240LAL   NBA        0     1960  3/24/1960          83   \n","9715       4858  196003260STL   NBA        1     1960  3/26/1960          84   \n","\n","      is_playoffs team_id fran_id  pts      elo_i      elo_n  win_equiv  \\\n","9701            1     MNL  Lakers   89  1471.0741  1464.6069  36.052319   \n","9702            1     MNL  Lakers  103  1464.6069  1469.5608  36.565147   \n","9709            1     MNL  Lakers  117  1469.5608  1484.6693  38.137211   \n","9711            1     MNL  Lakers   96  1484.6693  1465.5942  36.154404   \n","9715            1     MNL  Lakers   86  1465.5942  1461.1439  35.694744   \n","\n","     opp_id opp_fran  opp_pts  opp_elo_i  opp_elo_n game_location game_result  \\\n","9701    STL    Hawks       93  1564.9653  1571.4325             H           L   \n","9702    STL    Hawks      101  1571.4325  1566.4786             H           W   \n","9709    STL    Hawks      110  1566.4786  1551.3701             A           W   \n","9711    STL    Hawks      117  1551.3701  1570.4452             H           L   \n","9715    STL    Hawks       97  1570.4452  1574.8955             A           L   \n","\n","      forecast notes  \n","9701  0.508790   NaN  \n","9702  0.490178   NaN  \n","9709  0.243506   NaN  \n","9711  0.547775   NaN  \n","9715  0.235193   NaN  "]},"execution_count":20,"metadata":{},"output_type":"execute_result"}],"source":["df.loc[(df['fran_id']=='Lakers')&(df['team_id']=='MNL'), :].tail()"]},{"cell_type":"code","execution_count":null,"metadata":{"scrolled":true,"id":"xZieVn5v9vP2","outputId":"506ab33d-ab18-4470-8b7f-1195c53435c5"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>9730</th>\n","      <td>4866</td>\n","      <td>196010190CIN</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1961</td>\n","      <td>10/19/1960</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>123</td>\n","      <td>1472.1079</td>\n","      <td>1456.2350</td>\n","      <td>35.369419</td>\n","      <td>CIN</td>\n","      <td>Kings</td>\n","      <td>140</td>\n","      <td>1349.7457</td>\n","      <td>1365.6187</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.532137</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>9739</th>\n","      <td>4870</td>\n","      <td>196010220STL</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1961</td>\n","      <td>10/22/1960</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>96</td>\n","      <td>1456.2350</td>\n","      <td>1450.4137</td>\n","      <td>34.771576</td>\n","      <td>STL</td>\n","      <td>Hawks</td>\n","      <td>112</td>\n","      <td>1556.3074</td>\n","      <td>1562.1287</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.240177</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>9744</th>\n","      <td>4873</td>\n","      <td>196010240LAL</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1961</td>\n","      <td>10/24/1960</td>\n","      <td>3</td>\n","      <td>0</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>101</td>\n","      <td>1450.4137</td>\n","      <td>1435.3485</td>\n","      <td>33.237518</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>111</td>\n","      <td>1435.7505</td>\n","      <td>1450.8157</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.659273</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>9747</th>\n","      <td>4874</td>\n","      <td>196010250LAL</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1961</td>\n","      <td>10/25/1960</td>\n","      <td>4</td>\n","      <td>0</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>120</td>\n","      <td>1435.3485</td>\n","      <td>1438.7944</td>\n","      <td>33.586594</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>118</td>\n","      <td>1450.8157</td>\n","      <td>1447.3698</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.619308</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>9756</th>\n","      <td>4879</td>\n","      <td>196010280GSW</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1961</td>\n","      <td>10/28/1960</td>\n","      <td>5</td>\n","      <td>0</td>\n","      <td>LAL</td>\n","      <td>Lakers</td>\n","      <td>120</td>\n","      <td>1438.7944</td>\n","      <td>1437.4066</td>\n","      <td>33.445869</td>\n","      <td>PHW</td>\n","      <td>Warriors</td>\n","      <td>122</td>\n","      <td>1608.6340</td>\n","      <td>1610.0219</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.174607</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["      gameorder       game_id lg_id  _iscopy  year_id   date_game  seasongame  \\\n","9730       4866  196010190CIN   NBA        1     1961  10/19/1960           1   \n","9739       4870  196010220STL   NBA        1     1961  10/22/1960           2   \n","9744       4873  196010240LAL   NBA        0     1961  10/24/1960           3   \n","9747       4874  196010250LAL   NBA        0     1961  10/25/1960           4   \n","9756       4879  196010280GSW   NBA        1     1961  10/28/1960           5   \n","\n","      is_playoffs team_id fran_id  pts      elo_i      elo_n  win_equiv  \\\n","9730            0     LAL  Lakers  123  1472.1079  1456.2350  35.369419   \n","9739            0     LAL  Lakers   96  1456.2350  1450.4137  34.771576   \n","9744            0     LAL  Lakers  101  1450.4137  1435.3485  33.237518   \n","9747            0     LAL  Lakers  120  1435.3485  1438.7944  33.586594   \n","9756            0     LAL  Lakers  120  1438.7944  1437.4066  33.445869   \n","\n","     opp_id  opp_fran  opp_pts  opp_elo_i  opp_elo_n game_location  \\\n","9730    CIN     Kings      140  1349.7457  1365.6187             A   \n","9739    STL     Hawks      112  1556.3074  1562.1287             A   \n","9744    NYK    Knicks      111  1435.7505  1450.8157             H   \n","9747    NYK    Knicks      118  1450.8157  1447.3698             H   \n","9756    PHW  Warriors      122  1608.6340  1610.0219             A   \n","\n","     game_result  forecast notes  \n","9730           L  0.532137   NaN  \n","9739           L  0.240177   NaN  \n","9744           L  0.659273   NaN  \n","9747           W  0.619308   NaN  \n","9756           L  0.174607   NaN  "]},"execution_count":21,"metadata":{},"output_type":"execute_result"}],"source":["df.loc[(df['fran_id']=='Lakers')&(df['team_id']=='LAL'), :].head()"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"GdQ6yJZn9vP2","outputId":"ea91596b-ec82-417f-b8e4-272f055ba212"},"outputs":[{"data":{"text/plain":["108.15576998818432"]},"execution_count":22,"metadata":{},"output_type":"execute_result"}],"source":["df.loc[(df['fran_id']=='Lakers')&(df['team_id']=='LAL'), 'pts'].mean()"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"wE8dT2bR9vP9","outputId":"3d619c6a-a95a-4f50-d155-0434342b831e"},"outputs":[{"data":{"text/plain":["year_id    1961\n","pts          68\n","dtype: int64"]},"execution_count":23,"metadata":{},"output_type":"execute_result"}],"source":["df.loc[(df['fran_id']=='Lakers')&(df['team_id']=='LAL'), ['year_id', 'pts']].min()"]},{"cell_type":"markdown","metadata":{"id":"qF8_4DDs9vP9"},"source":["## **Query**"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"Nz7N8ZCT9vP9","outputId":"99445e62-34a8-47c7-bffd-67c53e3709c6"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0</td>\n","      <td>1293.2767</td>\n","      <td>40.29483</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0</td>\n","      <td>1306.7233</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0</td>\n","      <td>1306.7233</td>\n","      <td>41.70517</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0</td>\n","      <td>1293.2767</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   gameorder       game_id lg_id  _iscopy  year_id  date_game  seasongame  \\\n","0          1  194611010TRH   NBA        0     1947  11/1/1946           1   \n","1          1  194611010TRH   NBA        1     1947  11/1/1946           1   \n","\n","   is_playoffs team_id  fran_id  pts   elo_i      elo_n  win_equiv opp_id  \\\n","0            0     TRH  Huskies   66  1300.0  1293.2767   40.29483    NYK   \n","1            0     NYK   Knicks   68  1300.0  1306.7233   41.70517    TRH   \n","\n","  opp_fran  opp_pts  opp_elo_i  opp_elo_n game_location game_result  forecast  \\\n","0   Knicks       68     1300.0  1306.7233             H           L  0.640065   \n","1  Huskies       66     1300.0  1293.2767             A           W  0.359935   \n","\n","  notes  \n","0   NaN  \n","1   NaN  "]},"execution_count":24,"metadata":{},"output_type":"execute_result"}],"source":["df.head(2)"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"YJxFCDMp9vP9","outputId":"1e549bdc-5259-48bf-85ce-5aa47d85f05b"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>113668</th>\n","      <td>56835</td>\n","      <td>201010270GSW</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2011</td>\n","      <td>10/27/2010</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>132</td>\n","      <td>1432.7798</td>\n","      <td>1438.4199</td>\n","      <td>34.231400</td>\n","      <td>HOU</td>\n","      <td>Rockets</td>\n","      <td>128</td>\n","      <td>1502.5969</td>\n","      <td>1496.9568</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.543328</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>113700</th>\n","      <td>56851</td>\n","      <td>201010290GSW</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2011</td>\n","      <td>10/29/2010</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>109</td>\n","      <td>1438.4199</td>\n","      <td>1445.4368</td>\n","      <td>34.949425</td>\n","      <td>LAC</td>\n","      <td>Clippers</td>\n","      <td>91</td>\n","      <td>1359.6786</td>\n","      <td>1352.6617</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.736706</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>113767</th>\n","      <td>56884</td>\n","      <td>201011030GSW</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2011</td>\n","      <td>11/3/2010</td>\n","      <td>4</td>\n","      <td>0</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>115</td>\n","      <td>1441.2949</td>\n","      <td>1446.8822</td>\n","      <td>35.097824</td>\n","      <td>MEM</td>\n","      <td>Grizzlies</td>\n","      <td>109</td>\n","      <td>1459.8025</td>\n","      <td>1454.2152</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.615173</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>113944</th>\n","      <td>56973</td>\n","      <td>201011150GSW</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2011</td>\n","      <td>11/15/2010</td>\n","      <td>11</td>\n","      <td>0</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>101</td>\n","      <td>1452.7739</td>\n","      <td>1456.0579</td>\n","      <td>36.043385</td>\n","      <td>DET</td>\n","      <td>Pistons</td>\n","      <td>97</td>\n","      <td>1398.6144</td>\n","      <td>1395.3304</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.708356</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>113998</th>\n","      <td>57000</td>\n","      <td>201011190GSW</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2011</td>\n","      <td>11/19/2010</td>\n","      <td>12</td>\n","      <td>0</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>119</td>\n","      <td>1456.0579</td>\n","      <td>1443.5485</td>\n","      <td>34.755802</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>125</td>\n","      <td>1401.4916</td>\n","      <td>1414.0010</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.708840</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>126237</th>\n","      <td>63119</td>\n","      <td>201505030GSW</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>5/3/2015</td>\n","      <td>87</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>101</td>\n","      <td>1785.5422</td>\n","      <td>1789.2944</td>\n","      <td>66.508675</td>\n","      <td>MEM</td>\n","      <td>Grizzlies</td>\n","      <td>86</td>\n","      <td>1610.1501</td>\n","      <td>1606.3979</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.829952</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126284</th>\n","      <td>63143</td>\n","      <td>201505190GSW</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>5/19/2015</td>\n","      <td>93</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>110</td>\n","      <td>1787.3469</td>\n","      <td>1789.7388</td>\n","      <td>66.537224</td>\n","      <td>HOU</td>\n","      <td>Rockets</td>\n","      <td>106</td>\n","      <td>1669.5398</td>\n","      <td>1667.1479</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.777957</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126301</th>\n","      <td>63151</td>\n","      <td>201505270GSW</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>5/27/2015</td>\n","      <td>97</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>104</td>\n","      <td>1797.8933</td>\n","      <td>1802.2509</td>\n","      <td>67.324539</td>\n","      <td>HOU</td>\n","      <td>Rockets</td>\n","      <td>90</td>\n","      <td>1658.9934</td>\n","      <td>1654.6359</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.798222</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126303</th>\n","      <td>63152</td>\n","      <td>201506040GSW</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/4/2015</td>\n","      <td>98</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>108</td>\n","      <td>1802.2509</td>\n","      <td>1806.2035</td>\n","      <td>67.566650</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>100</td>\n","      <td>1712.1232</td>\n","      <td>1708.1705</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.749221</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126310</th>\n","      <td>63156</td>\n","      <td>201506140GSW</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/14/2015</td>\n","      <td>102</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>104</td>\n","      <td>1809.9791</td>\n","      <td>1813.6349</td>\n","      <td>68.013329</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>91</td>\n","      <td>1704.3949</td>\n","      <td>1700.7391</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.765565</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>144 rows × 23 columns</p>\n","</div>"],"text/plain":["        gameorder       game_id lg_id  _iscopy  year_id   date_game  \\\n","113668      56835  201010270GSW   NBA        0     2011  10/27/2010   \n","113700      56851  201010290GSW   NBA        0     2011  10/29/2010   \n","113767      56884  201011030GSW   NBA        0     2011   11/3/2010   \n","113944      56973  201011150GSW   NBA        0     2011  11/15/2010   \n","113998      57000  201011190GSW   NBA        0     2011  11/19/2010   \n","...           ...           ...   ...      ...      ...         ...   \n","126237      63119  201505030GSW   NBA        0     2015    5/3/2015   \n","126284      63143  201505190GSW   NBA        0     2015   5/19/2015   \n","126301      63151  201505270GSW   NBA        0     2015   5/27/2015   \n","126303      63152  201506040GSW   NBA        0     2015    6/4/2015   \n","126310      63156  201506140GSW   NBA        0     2015   6/14/2015   \n","\n","        seasongame  is_playoffs team_id   fran_id  pts      elo_i      elo_n  \\\n","113668           1            0     GSW  Warriors  132  1432.7798  1438.4199   \n","113700           2            0     GSW  Warriors  109  1438.4199  1445.4368   \n","113767           4            0     GSW  Warriors  115  1441.2949  1446.8822   \n","113944          11            0     GSW  Warriors  101  1452.7739  1456.0579   \n","113998          12            0     GSW  Warriors  119  1456.0579  1443.5485   \n","...            ...          ...     ...       ...  ...        ...        ...   \n","126237          87            1     GSW  Warriors  101  1785.5422  1789.2944   \n","126284          93            1     GSW  Warriors  110  1787.3469  1789.7388   \n","126301          97            1     GSW  Warriors  104  1797.8933  1802.2509   \n","126303          98            1     GSW  Warriors  108  1802.2509  1806.2035   \n","126310         102            1     GSW  Warriors  104  1809.9791  1813.6349   \n","\n","        win_equiv opp_id   opp_fran  opp_pts  opp_elo_i  opp_elo_n  \\\n","113668  34.231400    HOU    Rockets      128  1502.5969  1496.9568   \n","113700  34.949425    LAC   Clippers       91  1359.6786  1352.6617   \n","113767  35.097824    MEM  Grizzlies      109  1459.8025  1454.2152   \n","113944  36.043385    DET    Pistons       97  1398.6144  1395.3304   \n","113998  34.755802    NYK     Knicks      125  1401.4916  1414.0010   \n","...           ...    ...        ...      ...        ...        ...   \n","126237  66.508675    MEM  Grizzlies       86  1610.1501  1606.3979   \n","126284  66.537224    HOU    Rockets      106  1669.5398  1667.1479   \n","126301  67.324539    HOU    Rockets       90  1658.9934  1654.6359   \n","126303  67.566650    CLE  Cavaliers      100  1712.1232  1708.1705   \n","126310  68.013329    CLE  Cavaliers       91  1704.3949  1700.7391   \n","\n","       game_location game_result  forecast notes  \n","113668             H           W  0.543328   NaN  \n","113700             H           W  0.736706   NaN  \n","113767             H           W  0.615173   NaN  \n","113944             H           W  0.708356   NaN  \n","113998             H           L  0.708840   NaN  \n","...              ...         ...       ...   ...  \n","126237             H           W  0.829952   NaN  \n","126284             H           W  0.777957   NaN  \n","126301             H           W  0.798222   NaN  \n","126303             H           W  0.749221   NaN  \n","126310             H           W  0.765565   NaN  \n","\n","[144 rows x 23 columns]"]},"execution_count":25,"metadata":{},"output_type":"execute_result"}],"source":["df[\n","    (df['year_id'] > 2010) &\n","    (df['game_location'] == 'H') &\n","    (df['fran_id'] == 'Warriors') &\n","    (df['pts'] > 100)\n","]"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"7VaMIN6l9vP-","outputId":"86650bd8-74f7-43a1-d3f1-5ba921469e65"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>year_id</th>\n","      <th>seasongame</th>\n","      <th>team_id</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>113668</th>\n","      <td>2011</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","    </tr>\n","    <tr>\n","      <th>113700</th>\n","      <td>2011</td>\n","      <td>2</td>\n","      <td>GSW</td>\n","    </tr>\n","    <tr>\n","      <th>113767</th>\n","      <td>2011</td>\n","      <td>4</td>\n","      <td>GSW</td>\n","    </tr>\n","    <tr>\n","      <th>113944</th>\n","      <td>2011</td>\n","      <td>11</td>\n","      <td>GSW</td>\n","    </tr>\n","    <tr>\n","      <th>113998</th>\n","      <td>2011</td>\n","      <td>12</td>\n","      <td>GSW</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>126237</th>\n","      <td>2015</td>\n","      <td>87</td>\n","      <td>GSW</td>\n","    </tr>\n","    <tr>\n","      <th>126284</th>\n","      <td>2015</td>\n","      <td>93</td>\n","      <td>GSW</td>\n","    </tr>\n","    <tr>\n","      <th>126301</th>\n","      <td>2015</td>\n","      <td>97</td>\n","      <td>GSW</td>\n","    </tr>\n","    <tr>\n","      <th>126303</th>\n","      <td>2015</td>\n","      <td>98</td>\n","      <td>GSW</td>\n","    </tr>\n","    <tr>\n","      <th>126310</th>\n","      <td>2015</td>\n","      <td>102</td>\n","      <td>GSW</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>144 rows × 3 columns</p>\n","</div>"],"text/plain":["        year_id  seasongame team_id\n","113668     2011           1     GSW\n","113700     2011           2     GSW\n","113767     2011           4     GSW\n","113944     2011          11     GSW\n","113998     2011          12     GSW\n","...         ...         ...     ...\n","126237     2015          87     GSW\n","126284     2015          93     GSW\n","126301     2015          97     GSW\n","126303     2015          98     GSW\n","126310     2015         102     GSW\n","\n","[144 rows x 3 columns]"]},"execution_count":26,"metadata":{},"output_type":"execute_result"}],"source":["df[\n","    (df['year_id'] > 2010) &\n","    (df['game_location'] == 'H') &\n","    (df['fran_id'] == 'Warriors') &\n","    (df['pts'] > 100)\n","][['year_id','seasongame','team_id']]"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"CY_NNn0h9vP-","outputId":"fb8c0db0-a01b-4547-aaea-ee53d919f846"},"outputs":[{"data":{"text/plain":["(5169, 23)"]},"execution_count":27,"metadata":{},"output_type":"execute_result"}],"source":["# year [2005 - 2012]\n","# seasongame ganjil\n","# pts > 80\n","# game_result W\n","\n","df[\n","    (df['year_id'] >= 2005) &\n","    (df['year_id'] <= 2012) &\n","    (df['pts'] > 80) &\n","    (df['seasongame'] % 2 != 0) &\n","    (df['game_result'] == 'W')\n","].shape"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"On7juqLs9vP-","outputId":"33f1505b-79f9-4c45-fbb6-211f3992b9bd"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0</td>\n","      <td>1293.2767</td>\n","      <td>40.29483</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0</td>\n","      <td>1306.7233</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0</td>\n","      <td>1306.7233</td>\n","      <td>41.70517</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0</td>\n","      <td>1293.2767</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   gameorder       game_id lg_id  _iscopy  year_id  date_game  seasongame  \\\n","0          1  194611010TRH   NBA        0     1947  11/1/1946           1   \n","1          1  194611010TRH   NBA        1     1947  11/1/1946           1   \n","\n","   is_playoffs team_id  fran_id  pts   elo_i      elo_n  win_equiv opp_id  \\\n","0            0     TRH  Huskies   66  1300.0  1293.2767   40.29483    NYK   \n","1            0     NYK   Knicks   68  1300.0  1306.7233   41.70517    TRH   \n","\n","  opp_fran  opp_pts  opp_elo_i  opp_elo_n game_location game_result  forecast  \\\n","0   Knicks       68     1300.0  1306.7233             H           L  0.640065   \n","1  Huskies       66     1300.0  1293.2767             A           W  0.359935   \n","\n","  notes  \n","0   NaN  \n","1   NaN  "]},"execution_count":28,"metadata":{},"output_type":"execute_result"}],"source":["df.head(2)"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"a7-Iky_B9vP_","outputId":"04cc139b-47f7-433a-d352-5d0084f51f61"},"outputs":[{"data":{"text/plain":["(5169, 23)"]},"execution_count":29,"metadata":{},"output_type":"execute_result"}],"source":["df.query(\"year_id >= 2005 & \\\n","            year_id <= 2012 & \\\n","            pts > 80 & \\\n","            seasongame % 2 != 0 & \\\n","            game_result == 'W'\").shape"]},{"cell_type":"markdown","metadata":{"id":"yftjLT9L9vP_"},"source":["## **Grouping and Aggregating**"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"bfvL11Um9vP_","outputId":"8bf561ac-b479-40bd-ac3f-e6d917e4101d"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>pts</th>\n","    </tr>\n","    <tr>\n","      <th>fran_id</th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>Condors</th>\n","      <td>115.446512</td>\n","    </tr>\n","    <tr>\n","      <th>Squires</th>\n","      <td>114.051314</td>\n","    </tr>\n","    <tr>\n","      <th>Floridians</th>\n","      <td>112.654545</td>\n","    </tr>\n","    <tr>\n","      <th>Stars</th>\n","      <td>112.354497</td>\n","    </tr>\n","    <tr>\n","      <th>Colonels</th>\n","      <td>111.625296</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                   pts\n","fran_id               \n","Condors     115.446512\n","Squires     114.051314\n","Floridians  112.654545\n","Stars       112.354497\n","Colonels    111.625296"]},"execution_count":30,"metadata":{},"output_type":"execute_result"}],"source":["df.groupby(by='fran_id')[['pts']].mean().sort_values(by='pts', ascending=False).head()"]},{"cell_type":"code","execution_count":null,"metadata":{"scrolled":true,"id":"9e7xVqBD9vQA","outputId":"7291e69c-f1a7-4c1b-877e-899bc0e1f8f2"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0</td>\n","      <td>1293.2767</td>\n","      <td>40.29483</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0</td>\n","      <td>1306.7233</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0</td>\n","      <td>1306.7233</td>\n","      <td>41.70517</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0</td>\n","      <td>1293.2767</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   gameorder       game_id lg_id  _iscopy  year_id  date_game  seasongame  \\\n","0          1  194611010TRH   NBA        0     1947  11/1/1946           1   \n","1          1  194611010TRH   NBA        1     1947  11/1/1946           1   \n","\n","   is_playoffs team_id  fran_id  pts   elo_i      elo_n  win_equiv opp_id  \\\n","0            0     TRH  Huskies   66  1300.0  1293.2767   40.29483    NYK   \n","1            0     NYK   Knicks   68  1300.0  1306.7233   41.70517    TRH   \n","\n","  opp_fran  opp_pts  opp_elo_i  opp_elo_n game_location game_result  forecast  \\\n","0   Knicks       68     1300.0  1306.7233             H           L  0.640065   \n","1  Huskies       66     1300.0  1293.2767             A           W  0.359935   \n","\n","  notes  \n","0   NaN  \n","1   NaN  "]},"execution_count":31,"metadata":{},"output_type":"execute_result"}],"source":["df.head(2)"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"D6PmTRFg9vQA","outputId":"6cd8ee8e-ecce-4051-b35e-fc52c2786eb6"},"outputs":[{"data":{"text/plain":["H    63138\n","A    63138\n","N       38\n","Name: game_location, dtype: int64"]},"execution_count":32,"metadata":{},"output_type":"execute_result"}],"source":["df.game_location.value_counts()"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"AgFh7bcM9vQA","outputId":"7a289a3e-010d-466d-f80f-f94ce4acd914"},"outputs":[{"data":{"text/plain":["game_location\n","A    100.856616\n","H    104.602395\n","N    104.315789\n","Name: pts, dtype: float64"]},"execution_count":33,"metadata":{},"output_type":"execute_result"}],"source":["df.groupby(by='game_location')['pts'].mean()"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"BmsgE_RH9vQA","outputId":"8daf9085-adc9-4a33-aa60-ad82d8b150d8"},"outputs":[{"data":{"text/plain":["<pandas.core.groupby.generic.DataFrameGroupBy object at 0x0000021399D04820>"]},"execution_count":34,"metadata":{},"output_type":"execute_result"}],"source":["# elaborasi cara kerja\n","grup = df.groupby(by='game_location')\n","grup"]},{"cell_type":"code","execution_count":null,"metadata":{"scrolled":true,"id":"QX0vGD-w9vQA","outputId":"a9f20cf9-a712-4a27-b33b-1f26336a3d1f"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0000</td>\n","      <td>1306.7233</td>\n","      <td>41.705170</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0000</td>\n","      <td>1293.2767</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>1306.7233</td>\n","      <td>1297.0712</td>\n","      <td>40.692783</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>1300.0000</td>\n","      <td>1309.6521</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.368899</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>3</td>\n","      <td>194611020DTF</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>WSC</td>\n","      <td>Capitols</td>\n","      <td>50</td>\n","      <td>1300.0000</td>\n","      <td>1320.3811</td>\n","      <td>43.135952</td>\n","      <td>DTF</td>\n","      <td>Falcons</td>\n","      <td>33</td>\n","      <td>1300.0000</td>\n","      <td>1279.6189</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>4</td>\n","      <td>194611020PRO</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>BOS</td>\n","      <td>Celtics</td>\n","      <td>53</td>\n","      <td>1300.0000</td>\n","      <td>1294.8458</td>\n","      <td>40.459381</td>\n","      <td>PRO</td>\n","      <td>Steamrollers</td>\n","      <td>59</td>\n","      <td>1300.0000</td>\n","      <td>1305.1542</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>5</td>\n","      <td>194611020STB</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>PIT</td>\n","      <td>Ironmen</td>\n","      <td>51</td>\n","      <td>1300.0000</td>\n","      <td>1295.3092</td>\n","      <td>40.507980</td>\n","      <td>STB</td>\n","      <td>Bombers</td>\n","      <td>56</td>\n","      <td>1300.0000</td>\n","      <td>1304.6908</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>126304</th>\n","      <td>63153</td>\n","      <td>201506070GSW</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/7/2015</td>\n","      <td>98</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>95</td>\n","      <td>1708.1705</td>\n","      <td>1716.8708</td>\n","      <td>61.312763</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>93</td>\n","      <td>1806.2035</td>\n","      <td>1797.5032</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.242326</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126306</th>\n","      <td>63154</td>\n","      <td>201506090CLE</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/9/2015</td>\n","      <td>100</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>91</td>\n","      <td>1797.5032</td>\n","      <td>1790.9591</td>\n","      <td>66.615417</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>96</td>\n","      <td>1716.8708</td>\n","      <td>1723.4149</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.472157</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126308</th>\n","      <td>63155</td>\n","      <td>201506110CLE</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/11/2015</td>\n","      <td>101</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>103</td>\n","      <td>1790.9591</td>\n","      <td>1809.9791</td>\n","      <td>67.794983</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>82</td>\n","      <td>1723.4149</td>\n","      <td>1704.3949</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.453428</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126311</th>\n","      <td>63156</td>\n","      <td>201506140GSW</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/14/2015</td>\n","      <td>101</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>91</td>\n","      <td>1704.3949</td>\n","      <td>1700.7391</td>\n","      <td>60.010067</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>104</td>\n","      <td>1809.9791</td>\n","      <td>1813.6349</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.234435</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126313</th>\n","      <td>63157</td>\n","      <td>201506170CLE</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/16/2015</td>\n","      <td>103</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>105</td>\n","      <td>1813.6349</td>\n","      <td>1822.2881</td>\n","      <td>68.519516</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>97</td>\n","      <td>1700.7391</td>\n","      <td>1692.0859</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.518550</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>63138 rows × 23 columns</p>\n","</div>"],"text/plain":["        gameorder       game_id lg_id  _iscopy  year_id  date_game  \\\n","1               1  194611010TRH   NBA        1     1947  11/1/1946   \n","3               2  194611020CHS   NBA        1     1947  11/2/1946   \n","5               3  194611020DTF   NBA        1     1947  11/2/1946   \n","6               4  194611020PRO   NBA        1     1947  11/2/1946   \n","8               5  194611020STB   NBA        1     1947  11/2/1946   \n","...           ...           ...   ...      ...      ...        ...   \n","126304      63153  201506070GSW   NBA        1     2015   6/7/2015   \n","126306      63154  201506090CLE   NBA        1     2015   6/9/2015   \n","126308      63155  201506110CLE   NBA        1     2015  6/11/2015   \n","126311      63156  201506140GSW   NBA        1     2015  6/14/2015   \n","126313      63157  201506170CLE   NBA        1     2015  6/16/2015   \n","\n","        seasongame  is_playoffs team_id    fran_id  pts      elo_i      elo_n  \\\n","1                1            0     NYK     Knicks   68  1300.0000  1306.7233   \n","3                2            0     NYK     Knicks   47  1306.7233  1297.0712   \n","5                1            0     WSC   Capitols   50  1300.0000  1320.3811   \n","6                1            0     BOS    Celtics   53  1300.0000  1294.8458   \n","8                1            0     PIT    Ironmen   51  1300.0000  1295.3092   \n","...            ...          ...     ...        ...  ...        ...        ...   \n","126304          98            1     CLE  Cavaliers   95  1708.1705  1716.8708   \n","126306         100            1     GSW   Warriors   91  1797.5032  1790.9591   \n","126308         101            1     GSW   Warriors  103  1790.9591  1809.9791   \n","126311         101            1     CLE  Cavaliers   91  1704.3949  1700.7391   \n","126313         103            1     GSW   Warriors  105  1813.6349  1822.2881   \n","\n","        win_equiv opp_id      opp_fran  opp_pts  opp_elo_i  opp_elo_n  \\\n","1       41.705170    TRH       Huskies       66  1300.0000  1293.2767   \n","3       40.692783    CHS         Stags       63  1300.0000  1309.6521   \n","5       43.135952    DTF       Falcons       33  1300.0000  1279.6189   \n","6       40.459381    PRO  Steamrollers       59  1300.0000  1305.1542   \n","8       40.507980    STB       Bombers       56  1300.0000  1304.6908   \n","...           ...    ...           ...      ...        ...        ...   \n","126304  61.312763    GSW      Warriors       93  1806.2035  1797.5032   \n","126306  66.615417    CLE     Cavaliers       96  1716.8708  1723.4149   \n","126308  67.794983    CLE     Cavaliers       82  1723.4149  1704.3949   \n","126311  60.010067    GSW      Warriors      104  1809.9791  1813.6349   \n","126313  68.519516    CLE     Cavaliers       97  1700.7391  1692.0859   \n","\n","       game_location game_result  forecast notes  \n","1                  A           W  0.359935   NaN  \n","3                  A           L  0.368899   NaN  \n","5                  A           W  0.359935   NaN  \n","6                  A           L  0.359935   NaN  \n","8                  A           L  0.359935   NaN  \n","...              ...         ...       ...   ...  \n","126304             A           W  0.242326   NaN  \n","126306             A           L  0.472157   NaN  \n","126308             A           W  0.453428   NaN  \n","126311             A           L  0.234435   NaN  \n","126313             A           W  0.518550   NaN  \n","\n","[63138 rows x 23 columns]"]},"execution_count":35,"metadata":{},"output_type":"execute_result"}],"source":["grup.get_group('A')"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"ogqywg6Q9vQA","outputId":"f2c7130a-edff-4cb6-dfd6-9b2993df210e"},"outputs":[{"data":{"text/plain":["104.60239475434761"]},"execution_count":36,"metadata":{},"output_type":"execute_result"}],"source":["grup.get_group('H')['pts'].mean()"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"Z_-vh2Dv9vQB","outputId":"9f35362b-b4ca-4e0b-e47b-32b8380faec4"},"outputs":[{"data":{"text/plain":["104.3157894736842"]},"execution_count":37,"metadata":{},"output_type":"execute_result"}],"source":["grup.get_group('N')['pts'].mean()"]},{"cell_type":"code","execution_count":null,"metadata":{"scrolled":true,"id":"Ew0eVVtI9vQB","outputId":"458f832d-742a-4076-a9d1-3d1bf42bc36c"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th></th>\n","      <th>pts</th>\n","    </tr>\n","    <tr>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th rowspan=\"2\" valign=\"top\">A</th>\n","      <th>L</th>\n","      <td>98.600000</td>\n","    </tr>\n","    <tr>\n","      <th>W</th>\n","      <td>111.250000</td>\n","    </tr>\n","    <tr>\n","      <th rowspan=\"2\" valign=\"top\">H</th>\n","      <th>L</th>\n","      <td>94.750000</td>\n","    </tr>\n","    <tr>\n","      <th>W</th>\n","      <td>104.444444</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                                  pts\n","game_location game_result            \n","A             L             98.600000\n","              W            111.250000\n","H             L             94.750000\n","              W            104.444444"]},"execution_count":38,"metadata":{},"output_type":"execute_result"}],"source":["df[(df['year_id'] >= 2002)&\n","   (df['year_id'] <= 2015)&\n","   (df['fran_id'] == 'Celtics')&\n","   (df['opp_fran'] == 'Warriors')\n","].groupby(by=['game_location', 'game_result'])[['pts']].mean()"]},{"cell_type":"markdown","metadata":{"id":"padRs1l19vQB"},"source":["Head-2-head Celtics avg point vs Warriors between 2002 - 2015"]},{"cell_type":"markdown","metadata":{"id":"wBnNUUC69vQB"},"source":["## **Columns Manipulation**\n","\n","- rename column\n","- drop column\n","- create new column"]},{"cell_type":"code","execution_count":1,"metadata":{"id":"xcwTdR5V9vQC","colab":{"base_uri":"https://localhost:8080/","height":165},"executionInfo":{"status":"error","timestamp":1653355511989,"user_tz":-480,"elapsed":41,"user":{"displayName":"Hillidatul Ilmi","userId":"07932027707791477475"}},"outputId":"64fee95a-60b8-4c56-8f39-5dd9bff1a421"},"outputs":[{"output_type":"error","ename":"NameError","evalue":"ignored","traceback":["\u001b[0;31m---------------------------------------------------------------------------\u001b[0m","\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)","\u001b[0;32m<ipython-input-1-93b1e5c49b5b>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mnba\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcopy\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m","\u001b[0;31mNameError\u001b[0m: name 'df' is not defined"]}],"source":["nba = df.copy()"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"RgBtu_GH9vQC","outputId":"63be902f-0864-44bb-a1a8-ca97f80f38cd"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>game_location</th>\n","      <th>game_result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0000</td>\n","      <td>1293.2767</td>\n","      <td>40.294830</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0000</td>\n","      <td>1306.7233</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0000</td>\n","      <td>1306.7233</td>\n","      <td>41.705170</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0000</td>\n","      <td>1293.2767</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>1300.0000</td>\n","      <td>1309.6521</td>\n","      <td>42.012257</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>1306.7233</td>\n","      <td>1297.0712</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.631101</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>1306.7233</td>\n","      <td>1297.0712</td>\n","      <td>40.692783</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>1300.0000</td>\n","      <td>1309.6521</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.368899</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>3</td>\n","      <td>194611020DTF</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>DTF</td>\n","      <td>Falcons</td>\n","      <td>33</td>\n","      <td>1300.0000</td>\n","      <td>1279.6189</td>\n","      <td>38.864048</td>\n","      <td>WSC</td>\n","      <td>Capitols</td>\n","      <td>50</td>\n","      <td>1300.0000</td>\n","      <td>1320.3811</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   gameorder       game_id lg_id  _iscopy  year_id  date_game  seasongame  \\\n","0          1  194611010TRH   NBA        0     1947  11/1/1946           1   \n","1          1  194611010TRH   NBA        1     1947  11/1/1946           1   \n","2          2  194611020CHS   NBA        0     1947  11/2/1946           1   \n","3          2  194611020CHS   NBA        1     1947  11/2/1946           2   \n","4          3  194611020DTF   NBA        0     1947  11/2/1946           1   \n","\n","   is_playoffs team_id  fran_id  pts      elo_i      elo_n  win_equiv opp_id  \\\n","0            0     TRH  Huskies   66  1300.0000  1293.2767  40.294830    NYK   \n","1            0     NYK   Knicks   68  1300.0000  1306.7233  41.705170    TRH   \n","2            0     CHS    Stags   63  1300.0000  1309.6521  42.012257    NYK   \n","3            0     NYK   Knicks   47  1306.7233  1297.0712  40.692783    CHS   \n","4            0     DTF  Falcons   33  1300.0000  1279.6189  38.864048    WSC   \n","\n","   opp_fran  opp_pts  opp_elo_i  opp_elo_n game_location game_result  \\\n","0    Knicks       68  1300.0000  1306.7233             H           L   \n","1   Huskies       66  1300.0000  1293.2767             A           W   \n","2    Knicks       47  1306.7233  1297.0712             H           W   \n","3     Stags       63  1300.0000  1309.6521             A           L   \n","4  Capitols       50  1300.0000  1320.3811             H           L   \n","\n","   forecast notes  \n","0  0.640065   NaN  \n","1  0.359935   NaN  \n","2  0.631101   NaN  \n","3  0.368899   NaN  \n","4  0.640065   NaN  "]},"execution_count":40,"metadata":{},"output_type":"execute_result"}],"source":["nba.head()"]},{"cell_type":"code","execution_count":null,"metadata":{"scrolled":true,"id":"0plzaV7s9vQC"},"outputs":[],"source":["# rename\n","nba.rename(columns={'game_location': 'loc', 'game_result':'result'}, inplace=True)"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"IRtCnaiS9vQC","outputId":"991ec9c5-3925-40b8-e1bb-c3ae0147c0d1"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>elo_i</th>\n","      <th>elo_n</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>opp_elo_i</th>\n","      <th>opp_elo_n</th>\n","      <th>loc</th>\n","      <th>result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0000</td>\n","      <td>1293.2767</td>\n","      <td>40.294830</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0000</td>\n","      <td>1306.7233</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>1300.0000</td>\n","      <td>1306.7233</td>\n","      <td>41.705170</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>1300.0000</td>\n","      <td>1293.2767</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>1300.0000</td>\n","      <td>1309.6521</td>\n","      <td>42.012257</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>1306.7233</td>\n","      <td>1297.0712</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.631101</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>1306.7233</td>\n","      <td>1297.0712</td>\n","      <td>40.692783</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>1300.0000</td>\n","      <td>1309.6521</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.368899</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>3</td>\n","      <td>194611020DTF</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>DTF</td>\n","      <td>Falcons</td>\n","      <td>33</td>\n","      <td>1300.0000</td>\n","      <td>1279.6189</td>\n","      <td>38.864048</td>\n","      <td>WSC</td>\n","      <td>Capitols</td>\n","      <td>50</td>\n","      <td>1300.0000</td>\n","      <td>1320.3811</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>126309</th>\n","      <td>63155</td>\n","      <td>201506110CLE</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/11/2015</td>\n","      <td>100</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>82</td>\n","      <td>1723.4149</td>\n","      <td>1704.3949</td>\n","      <td>60.309792</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>103</td>\n","      <td>1790.9591</td>\n","      <td>1809.9791</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.546572</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126310</th>\n","      <td>63156</td>\n","      <td>201506140GSW</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/14/2015</td>\n","      <td>102</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>104</td>\n","      <td>1809.9791</td>\n","      <td>1813.6349</td>\n","      <td>68.013329</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>91</td>\n","      <td>1704.3949</td>\n","      <td>1700.7391</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.765565</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126311</th>\n","      <td>63156</td>\n","      <td>201506140GSW</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/14/2015</td>\n","      <td>101</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>91</td>\n","      <td>1704.3949</td>\n","      <td>1700.7391</td>\n","      <td>60.010067</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>104</td>\n","      <td>1809.9791</td>\n","      <td>1813.6349</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.234435</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126312</th>\n","      <td>63157</td>\n","      <td>201506170CLE</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/16/2015</td>\n","      <td>102</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>97</td>\n","      <td>1700.7391</td>\n","      <td>1692.0859</td>\n","      <td>59.290245</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>105</td>\n","      <td>1813.6349</td>\n","      <td>1822.2881</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.481450</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126313</th>\n","      <td>63157</td>\n","      <td>201506170CLE</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/16/2015</td>\n","      <td>103</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>105</td>\n","      <td>1813.6349</td>\n","      <td>1822.2881</td>\n","      <td>68.519516</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>97</td>\n","      <td>1700.7391</td>\n","      <td>1692.0859</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.518550</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>126314 rows × 23 columns</p>\n","</div>"],"text/plain":["        gameorder       game_id lg_id  _iscopy  year_id  date_game  \\\n","0               1  194611010TRH   NBA        0     1947  11/1/1946   \n","1               1  194611010TRH   NBA        1     1947  11/1/1946   \n","2               2  194611020CHS   NBA        0     1947  11/2/1946   \n","3               2  194611020CHS   NBA        1     1947  11/2/1946   \n","4               3  194611020DTF   NBA        0     1947  11/2/1946   \n","...           ...           ...   ...      ...      ...        ...   \n","126309      63155  201506110CLE   NBA        0     2015  6/11/2015   \n","126310      63156  201506140GSW   NBA        0     2015  6/14/2015   \n","126311      63156  201506140GSW   NBA        1     2015  6/14/2015   \n","126312      63157  201506170CLE   NBA        0     2015  6/16/2015   \n","126313      63157  201506170CLE   NBA        1     2015  6/16/2015   \n","\n","        seasongame  is_playoffs team_id    fran_id  pts      elo_i      elo_n  \\\n","0                1            0     TRH    Huskies   66  1300.0000  1293.2767   \n","1                1            0     NYK     Knicks   68  1300.0000  1306.7233   \n","2                1            0     CHS      Stags   63  1300.0000  1309.6521   \n","3                2            0     NYK     Knicks   47  1306.7233  1297.0712   \n","4                1            0     DTF    Falcons   33  1300.0000  1279.6189   \n","...            ...          ...     ...        ...  ...        ...        ...   \n","126309         100            1     CLE  Cavaliers   82  1723.4149  1704.3949   \n","126310         102            1     GSW   Warriors  104  1809.9791  1813.6349   \n","126311         101            1     CLE  Cavaliers   91  1704.3949  1700.7391   \n","126312         102            1     CLE  Cavaliers   97  1700.7391  1692.0859   \n","126313         103            1     GSW   Warriors  105  1813.6349  1822.2881   \n","\n","        win_equiv opp_id   opp_fran  opp_pts  opp_elo_i  opp_elo_n loc result  \\\n","0       40.294830    NYK     Knicks       68  1300.0000  1306.7233   H      L   \n","1       41.705170    TRH    Huskies       66  1300.0000  1293.2767   A      W   \n","2       42.012257    NYK     Knicks       47  1306.7233  1297.0712   H      W   \n","3       40.692783    CHS      Stags       63  1300.0000  1309.6521   A      L   \n","4       38.864048    WSC   Capitols       50  1300.0000  1320.3811   H      L   \n","...           ...    ...        ...      ...        ...        ...  ..    ...   \n","126309  60.309792    GSW   Warriors      103  1790.9591  1809.9791   H      L   \n","126310  68.013329    CLE  Cavaliers       91  1704.3949  1700.7391   H      W   \n","126311  60.010067    GSW   Warriors      104  1809.9791  1813.6349   A      L   \n","126312  59.290245    GSW   Warriors      105  1813.6349  1822.2881   H      L   \n","126313  68.519516    CLE  Cavaliers       97  1700.7391  1692.0859   A      W   \n","\n","        forecast notes  \n","0       0.640065   NaN  \n","1       0.359935   NaN  \n","2       0.631101   NaN  \n","3       0.368899   NaN  \n","4       0.640065   NaN  \n","...          ...   ...  \n","126309  0.546572   NaN  \n","126310  0.765565   NaN  \n","126311  0.234435   NaN  \n","126312  0.481450   NaN  \n","126313  0.518550   NaN  \n","\n","[126314 rows x 23 columns]"]},"execution_count":42,"metadata":{},"output_type":"execute_result"}],"source":["nba"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"PD24PwsD9vQD"},"outputs":[],"source":["# drop column\n","nba.drop(labels=['elo_i', 'elo_n', 'opp_elo_i', 'opp_elo_n'], axis=1, inplace=True)"]},{"cell_type":"code","execution_count":null,"metadata":{"scrolled":true,"id":"wU9QYf1O9vQD","outputId":"6ddfbfe5-1c5f-43b8-aecc-6be90e2775a6"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>loc</th>\n","      <th>result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>40.294830</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>41.705170</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>42.012257</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.631101</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>40.692783</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.368899</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>3</td>\n","      <td>194611020DTF</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>DTF</td>\n","      <td>Falcons</td>\n","      <td>33</td>\n","      <td>38.864048</td>\n","      <td>WSC</td>\n","      <td>Capitols</td>\n","      <td>50</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>126309</th>\n","      <td>63155</td>\n","      <td>201506110CLE</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/11/2015</td>\n","      <td>100</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>82</td>\n","      <td>60.309792</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>103</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.546572</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126310</th>\n","      <td>63156</td>\n","      <td>201506140GSW</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/14/2015</td>\n","      <td>102</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>104</td>\n","      <td>68.013329</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>91</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.765565</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126311</th>\n","      <td>63156</td>\n","      <td>201506140GSW</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/14/2015</td>\n","      <td>101</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>91</td>\n","      <td>60.010067</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>104</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.234435</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126312</th>\n","      <td>63157</td>\n","      <td>201506170CLE</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/16/2015</td>\n","      <td>102</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>97</td>\n","      <td>59.290245</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>105</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.481450</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>126313</th>\n","      <td>63157</td>\n","      <td>201506170CLE</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/16/2015</td>\n","      <td>103</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>105</td>\n","      <td>68.519516</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>97</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.518550</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>126314 rows × 19 columns</p>\n","</div>"],"text/plain":["        gameorder       game_id lg_id  _iscopy  year_id  date_game  \\\n","0               1  194611010TRH   NBA        0     1947  11/1/1946   \n","1               1  194611010TRH   NBA        1     1947  11/1/1946   \n","2               2  194611020CHS   NBA        0     1947  11/2/1946   \n","3               2  194611020CHS   NBA        1     1947  11/2/1946   \n","4               3  194611020DTF   NBA        0     1947  11/2/1946   \n","...           ...           ...   ...      ...      ...        ...   \n","126309      63155  201506110CLE   NBA        0     2015  6/11/2015   \n","126310      63156  201506140GSW   NBA        0     2015  6/14/2015   \n","126311      63156  201506140GSW   NBA        1     2015  6/14/2015   \n","126312      63157  201506170CLE   NBA        0     2015  6/16/2015   \n","126313      63157  201506170CLE   NBA        1     2015  6/16/2015   \n","\n","        seasongame  is_playoffs team_id    fran_id  pts  win_equiv opp_id  \\\n","0                1            0     TRH    Huskies   66  40.294830    NYK   \n","1                1            0     NYK     Knicks   68  41.705170    TRH   \n","2                1            0     CHS      Stags   63  42.012257    NYK   \n","3                2            0     NYK     Knicks   47  40.692783    CHS   \n","4                1            0     DTF    Falcons   33  38.864048    WSC   \n","...            ...          ...     ...        ...  ...        ...    ...   \n","126309         100            1     CLE  Cavaliers   82  60.309792    GSW   \n","126310         102            1     GSW   Warriors  104  68.013329    CLE   \n","126311         101            1     CLE  Cavaliers   91  60.010067    GSW   \n","126312         102            1     CLE  Cavaliers   97  59.290245    GSW   \n","126313         103            1     GSW   Warriors  105  68.519516    CLE   \n","\n","         opp_fran  opp_pts loc result  forecast notes  \n","0          Knicks       68   H      L  0.640065   NaN  \n","1         Huskies       66   A      W  0.359935   NaN  \n","2          Knicks       47   H      W  0.631101   NaN  \n","3           Stags       63   A      L  0.368899   NaN  \n","4        Capitols       50   H      L  0.640065   NaN  \n","...           ...      ...  ..    ...       ...   ...  \n","126309   Warriors      103   H      L  0.546572   NaN  \n","126310  Cavaliers       91   H      W  0.765565   NaN  \n","126311   Warriors      104   A      L  0.234435   NaN  \n","126312   Warriors      105   H      L  0.481450   NaN  \n","126313  Cavaliers       97   A      W  0.518550   NaN  \n","\n","[126314 rows x 19 columns]"]},"execution_count":44,"metadata":{},"output_type":"execute_result"}],"source":["nba"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"TJjdq9TE9vQD","outputId":"4f97b748-f8ec-43e2-cf01-cbcdd84db8fb"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>loc</th>\n","      <th>result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>40.294830</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>41.705170</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>42.012257</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.631101</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>40.692783</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.368899</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>3</td>\n","      <td>194611020DTF</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>DTF</td>\n","      <td>Falcons</td>\n","      <td>33</td>\n","      <td>38.864048</td>\n","      <td>WSC</td>\n","      <td>Capitols</td>\n","      <td>50</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   gameorder       game_id lg_id  _iscopy  year_id  date_game  seasongame  \\\n","0          1  194611010TRH   NBA        0     1947  11/1/1946           1   \n","1          1  194611010TRH   NBA        1     1947  11/1/1946           1   \n","2          2  194611020CHS   NBA        0     1947  11/2/1946           1   \n","3          2  194611020CHS   NBA        1     1947  11/2/1946           2   \n","4          3  194611020DTF   NBA        0     1947  11/2/1946           1   \n","\n","   is_playoffs team_id  fran_id  pts  win_equiv opp_id  opp_fran  opp_pts loc  \\\n","0            0     TRH  Huskies   66  40.294830    NYK    Knicks       68   H   \n","1            0     NYK   Knicks   68  41.705170    TRH   Huskies       66   A   \n","2            0     CHS    Stags   63  42.012257    NYK    Knicks       47   H   \n","3            0     NYK   Knicks   47  40.692783    CHS     Stags       63   A   \n","4            0     DTF  Falcons   33  38.864048    WSC  Capitols       50   H   \n","\n","  result  forecast notes  \n","0      L  0.640065   NaN  \n","1      W  0.359935   NaN  \n","2      W  0.631101   NaN  \n","3      L  0.368899   NaN  \n","4      L  0.640065   NaN  "]},"execution_count":45,"metadata":{},"output_type":"execute_result"}],"source":["# create new column\n","nba.head()"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"sPzSP24c9vQE"},"outputs":[],"source":["nba['selisih'] = nba['pts'] - nba['opp_pts']"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"YwGzr0qq9vQE","outputId":"cde4b10c-1f24-46a5-942e-222baf70a22d"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>loc</th>\n","      <th>result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","      <th>selisih</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>40.294830</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","      <td>-2</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>41.705170</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","      <td>2</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>42.012257</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.631101</td>\n","      <td>NaN</td>\n","      <td>16</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>40.692783</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.368899</td>\n","      <td>NaN</td>\n","      <td>-16</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>3</td>\n","      <td>194611020DTF</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>DTF</td>\n","      <td>Falcons</td>\n","      <td>33</td>\n","      <td>38.864048</td>\n","      <td>WSC</td>\n","      <td>Capitols</td>\n","      <td>50</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","      <td>-17</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>126309</th>\n","      <td>63155</td>\n","      <td>201506110CLE</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/11/2015</td>\n","      <td>100</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>82</td>\n","      <td>60.309792</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>103</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.546572</td>\n","      <td>NaN</td>\n","      <td>-21</td>\n","    </tr>\n","    <tr>\n","      <th>126310</th>\n","      <td>63156</td>\n","      <td>201506140GSW</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/14/2015</td>\n","      <td>102</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>104</td>\n","      <td>68.013329</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>91</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.765565</td>\n","      <td>NaN</td>\n","      <td>13</td>\n","    </tr>\n","    <tr>\n","      <th>126311</th>\n","      <td>63156</td>\n","      <td>201506140GSW</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/14/2015</td>\n","      <td>101</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>91</td>\n","      <td>60.010067</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>104</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.234435</td>\n","      <td>NaN</td>\n","      <td>-13</td>\n","    </tr>\n","    <tr>\n","      <th>126312</th>\n","      <td>63157</td>\n","      <td>201506170CLE</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/16/2015</td>\n","      <td>102</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>97</td>\n","      <td>59.290245</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>105</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.481450</td>\n","      <td>NaN</td>\n","      <td>-8</td>\n","    </tr>\n","    <tr>\n","      <th>126313</th>\n","      <td>63157</td>\n","      <td>201506170CLE</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/16/2015</td>\n","      <td>103</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>105</td>\n","      <td>68.519516</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>97</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.518550</td>\n","      <td>NaN</td>\n","      <td>8</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>126314 rows × 20 columns</p>\n","</div>"],"text/plain":["        gameorder       game_id lg_id  _iscopy  year_id  date_game  \\\n","0               1  194611010TRH   NBA        0     1947  11/1/1946   \n","1               1  194611010TRH   NBA        1     1947  11/1/1946   \n","2               2  194611020CHS   NBA        0     1947  11/2/1946   \n","3               2  194611020CHS   NBA        1     1947  11/2/1946   \n","4               3  194611020DTF   NBA        0     1947  11/2/1946   \n","...           ...           ...   ...      ...      ...        ...   \n","126309      63155  201506110CLE   NBA        0     2015  6/11/2015   \n","126310      63156  201506140GSW   NBA        0     2015  6/14/2015   \n","126311      63156  201506140GSW   NBA        1     2015  6/14/2015   \n","126312      63157  201506170CLE   NBA        0     2015  6/16/2015   \n","126313      63157  201506170CLE   NBA        1     2015  6/16/2015   \n","\n","        seasongame  is_playoffs team_id    fran_id  pts  win_equiv opp_id  \\\n","0                1            0     TRH    Huskies   66  40.294830    NYK   \n","1                1            0     NYK     Knicks   68  41.705170    TRH   \n","2                1            0     CHS      Stags   63  42.012257    NYK   \n","3                2            0     NYK     Knicks   47  40.692783    CHS   \n","4                1            0     DTF    Falcons   33  38.864048    WSC   \n","...            ...          ...     ...        ...  ...        ...    ...   \n","126309         100            1     CLE  Cavaliers   82  60.309792    GSW   \n","126310         102            1     GSW   Warriors  104  68.013329    CLE   \n","126311         101            1     CLE  Cavaliers   91  60.010067    GSW   \n","126312         102            1     CLE  Cavaliers   97  59.290245    GSW   \n","126313         103            1     GSW   Warriors  105  68.519516    CLE   \n","\n","         opp_fran  opp_pts loc result  forecast notes  selisih  \n","0          Knicks       68   H      L  0.640065   NaN       -2  \n","1         Huskies       66   A      W  0.359935   NaN        2  \n","2          Knicks       47   H      W  0.631101   NaN       16  \n","3           Stags       63   A      L  0.368899   NaN      -16  \n","4        Capitols       50   H      L  0.640065   NaN      -17  \n","...           ...      ...  ..    ...       ...   ...      ...  \n","126309   Warriors      103   H      L  0.546572   NaN      -21  \n","126310  Cavaliers       91   H      W  0.765565   NaN       13  \n","126311   Warriors      104   A      L  0.234435   NaN      -13  \n","126312   Warriors      105   H      L  0.481450   NaN       -8  \n","126313  Cavaliers       97   A      W  0.518550   NaN        8  \n","\n","[126314 rows x 20 columns]"]},"execution_count":47,"metadata":{},"output_type":"execute_result"}],"source":["nba"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"3zS15hmS9vQE","outputId":"ac84fb67-bb39-491c-e958-964e779e7bff"},"outputs":[{"data":{"text/plain":["Index(['gameorder', 'game_id', 'lg_id', '_iscopy', 'year_id', 'date_game',\n","       'seasongame', 'is_playoffs', 'team_id', 'fran_id', 'pts', 'win_equiv',\n","       'opp_id', 'opp_fran', 'opp_pts', 'loc', 'result', 'forecast', 'notes',\n","       'selisih'],\n","      dtype='object')"]},"execution_count":48,"metadata":{},"output_type":"execute_result"}],"source":["nba.columns"]},{"cell_type":"markdown","metadata":{"id":"A9CPUsf19vQE"},"source":["## latihan"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"vP9DRCgV9vQE","outputId":"aac27d4a-aea4-43b8-9283-15fbf96d0917"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>loc</th>\n","      <th>result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","      <th>selisih</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>40.294830</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","      <td>-2</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>41.705170</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","      <td>2</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>42.012257</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.631101</td>\n","      <td>NaN</td>\n","      <td>16</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>40.692783</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.368899</td>\n","      <td>NaN</td>\n","      <td>-16</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>3</td>\n","      <td>194611020DTF</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>DTF</td>\n","      <td>Falcons</td>\n","      <td>33</td>\n","      <td>38.864048</td>\n","      <td>WSC</td>\n","      <td>Capitols</td>\n","      <td>50</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","      <td>-17</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   gameorder       game_id lg_id  _iscopy  year_id  date_game  seasongame  \\\n","0          1  194611010TRH   NBA        0     1947  11/1/1946           1   \n","1          1  194611010TRH   NBA        1     1947  11/1/1946           1   \n","2          2  194611020CHS   NBA        0     1947  11/2/1946           1   \n","3          2  194611020CHS   NBA        1     1947  11/2/1946           2   \n","4          3  194611020DTF   NBA        0     1947  11/2/1946           1   \n","\n","   is_playoffs team_id  fran_id  pts  win_equiv opp_id  opp_fran  opp_pts loc  \\\n","0            0     TRH  Huskies   66  40.294830    NYK    Knicks       68   H   \n","1            0     NYK   Knicks   68  41.705170    TRH   Huskies       66   A   \n","2            0     CHS    Stags   63  42.012257    NYK    Knicks       47   H   \n","3            0     NYK   Knicks   47  40.692783    CHS     Stags       63   A   \n","4            0     DTF  Falcons   33  38.864048    WSC  Capitols       50   H   \n","\n","  result  forecast notes  selisih  \n","0      L  0.640065   NaN       -2  \n","1      W  0.359935   NaN        2  \n","2      W  0.631101   NaN       16  \n","3      L  0.368899   NaN      -16  \n","4      L  0.640065   NaN      -17  "]},"execution_count":51,"metadata":{},"output_type":"execute_result"}],"source":["nba.head()"]},{"cell_type":"code","execution_count":null,"metadata":{"collapsed":true,"id":"pc5reB2n9vQF","outputId":"07b9f292-abfc-4956-cd54-866396c8ae91"},"outputs":[{"data":{"text/plain":["[-2,\n"," 2,\n"," 16,\n"," -16,\n"," -17,\n"," 17,\n"," -6,\n"," 6,\n"," -5,\n"," 5,\n"," -11,\n"," 11,\n"," -15,\n"," 15,\n"," -2,\n"," 2,\n"," 4,\n"," -4,\n"," -6,\n"," 6,\n"," 8,\n"," -8,\n"," -5,\n"," 5,\n"," 2,\n"," -2,\n"," -8,\n"," 8,\n"," -23,\n"," 23,\n"," 10,\n"," -10,\n"," 1,\n"," -1,\n"," 24,\n"," -24,\n"," 10,\n"," -10,\n"," 13,\n"," -13,\n"," -10,\n"," 10,\n"," -2,\n"," 2,\n"," 3,\n"," -3,\n"," -2,\n"," 2,\n"," -17,\n"," 17,\n"," -4,\n"," 4,\n"," 8,\n"," -8,\n"," 2,\n"," -2,\n"," 11,\n"," -11,\n"," 9,\n"," -9,\n"," -2,\n"," 2,\n"," 4,\n"," -4,\n"," -6,\n"," 6,\n"," -3,\n"," 3,\n"," 2,\n"," -2,\n"," 1,\n"," -1,\n"," 3,\n"," -3,\n"," 3,\n"," -3,\n"," -12,\n"," 12,\n"," -2,\n"," 2,\n"," 8,\n"," -8,\n"," -1,\n"," 1,\n"," -8,\n"," 8,\n"," -6,\n"," 6,\n"," -6,\n"," 6,\n"," 24,\n"," -24,\n"," -13,\n"," 13,\n"," -2,\n"," 2,\n"," 12,\n"," -12,\n"," 16,\n"," -16,\n"," 20,\n"," -20,\n"," 12,\n"," -12,\n"," -10,\n"," 10,\n"," -7,\n"," 7,\n"," -2,\n"," 2,\n"," 8,\n"," -8,\n"," -4,\n"," 4,\n"," 3,\n"," -3,\n"," -13,\n"," 13,\n"," -2,\n"," 2,\n"," -15,\n"," 15,\n"," 4,\n"," -4,\n"," -14,\n"," 14,\n"," 3,\n"," -3,\n"," 9,\n"," -9,\n"," -10,\n"," 10,\n"," -2,\n"," 2,\n"," -2,\n"," 2,\n"," -8,\n"," 8,\n"," -13,\n"," 13,\n"," 11,\n"," -11,\n"," 18,\n"," -18,\n"," -4,\n"," 4,\n"," -4,\n"," 4,\n"," -11,\n"," 11,\n"," -11,\n"," 11,\n"," -25,\n"," 25,\n"," 8,\n"," -8,\n"," -9,\n"," 9,\n"," -10,\n"," 10,\n"," -11,\n"," 11,\n"," -6,\n"," 6,\n"," -18,\n"," 18,\n"," -8,\n"," 8,\n"," 1,\n"," -1,\n"," 12,\n"," -12,\n"," -9,\n"," 9,\n"," -15,\n"," 15,\n"," -15,\n"," 15,\n"," -7,\n"," 7,\n"," 15,\n"," -15,\n"," 20,\n"," -20,\n"," 10,\n"," -10,\n"," 12,\n"," -12,\n"," 15,\n"," -15,\n"," -20,\n"," 20,\n"," 9,\n"," -9,\n"," -18,\n"," 18,\n"," -4,\n"," 4,\n"," -11,\n"," 11,\n"," 16,\n"," -16,\n"," -8,\n"," 8,\n"," 3,\n"," -3,\n"," 21,\n"," -21,\n"," -2,\n"," 2,\n"," 14,\n"," -14,\n"," 4,\n"," -4,\n"," -4,\n"," 4,\n"," 2,\n"," -2,\n"," 12,\n"," -12,\n"," 3,\n"," -3,\n"," 4,\n"," -4,\n"," -12,\n"," 12,\n"," -10,\n"," 10,\n"," 7,\n"," -7,\n"," -12,\n"," 12,\n"," -4,\n"," 4,\n"," -3,\n"," 3,\n"," -8,\n"," 8,\n"," -12,\n"," 12,\n"," 21,\n"," -21,\n"," 8,\n"," -8,\n"," -4,\n"," 4,\n"," -7,\n"," 7,\n"," 10,\n"," -10,\n"," 2,\n"," -2,\n"," -9,\n"," 9,\n"," 10,\n"," -10,\n"," 13,\n"," -13,\n"," 5,\n"," -5,\n"," 13,\n"," -13,\n"," -12,\n"," 12,\n"," 9,\n"," -9,\n"," 5,\n"," -5,\n"," -12,\n"," 12,\n"," -4,\n"," 4,\n"," -14,\n"," 14,\n"," -2,\n"," 2,\n"," 11,\n"," -11,\n"," 14,\n"," -14,\n"," -15,\n"," 15,\n"," -3,\n"," 3,\n"," 13,\n"," -13,\n"," -4,\n"," 4,\n"," 8,\n"," -8,\n"," 19,\n"," -19,\n"," 23,\n"," -23,\n"," 3,\n"," -3,\n"," -4,\n"," 4,\n"," 2,\n"," -2,\n"," 1,\n"," -1,\n"," -15,\n"," 15,\n"," 3,\n"," -3,\n"," -13,\n"," 13,\n"," 3,\n"," -3,\n"," -4,\n"," 4,\n"," -30,\n"," 30,\n"," -9,\n"," 9,\n"," -2,\n"," 2,\n"," 12,\n"," -12,\n"," -9,\n"," 9,\n"," -6,\n"," 6,\n"," 4,\n"," -4,\n"," -10,\n"," 10,\n"," -13,\n"," 13,\n"," -15,\n"," 15,\n"," -7,\n"," 7,\n"," 16,\n"," -16,\n"," -27,\n"," 27,\n"," -5,\n"," 5,\n"," -16,\n"," 16,\n"," 1,\n"," -1,\n"," 14,\n"," -14,\n"," 10,\n"," -10,\n"," -2,\n"," 2,\n"," 5,\n"," -5,\n"," 21,\n"," -21,\n"," 5,\n"," -5,\n"," 3,\n"," -3,\n"," 6,\n"," -6,\n"," -6,\n"," 6,\n"," 13,\n"," -13,\n"," -6,\n"," 6,\n"," 5,\n"," -5,\n"," -23,\n"," 23,\n"," -8,\n"," 8,\n"," -6,\n"," 6,\n"," 10,\n"," -10,\n"," 10,\n"," -10,\n"," -4,\n"," 4,\n"," -12,\n"," 12,\n"," -15,\n"," 15,\n"," 7,\n"," -7,\n"," 11,\n"," -11,\n"," 9,\n"," -9,\n"," -8,\n"," 8,\n"," 16,\n"," -16,\n"," -22,\n"," 22,\n"," 15,\n"," -15,\n"," -26,\n"," 26,\n"," -2,\n"," 2,\n"," -6,\n"," 6,\n"," -5,\n"," 5,\n"," -7,\n"," 7,\n"," 21,\n"," -21,\n"," -25,\n"," 25,\n"," -3,\n"," 3,\n"," 1,\n"," -1,\n"," 24,\n"," -24,\n"," 18,\n"," -18,\n"," -8,\n"," 8,\n"," 6,\n"," -6,\n"," 23,\n"," -23,\n"," 9,\n"," -9,\n"," 3,\n"," -3,\n"," -18,\n"," 18,\n"," 5,\n"," -5,\n"," 6,\n"," -6,\n"," 9,\n"," -9,\n"," 16,\n"," -16,\n"," 20,\n"," -20,\n"," -4,\n"," 4,\n"," 19,\n"," -19,\n"," 10,\n"," -10,\n"," 2,\n"," -2,\n"," 13,\n"," -13,\n"," -11,\n"," 11,\n"," 6,\n"," -6,\n"," -10,\n"," 10,\n"," 10,\n"," -10,\n"," 7,\n"," -7,\n"," -4,\n"," 4,\n"," 8,\n"," -8,\n"," 16,\n"," -16,\n"," -4,\n"," 4,\n"," -11,\n"," 11,\n"," -8,\n"," 8,\n"," -6,\n"," 6,\n"," 7,\n"," -7,\n"," 10,\n"," -10,\n"," 2,\n"," -2,\n"," 12,\n"," -12,\n"," -8,\n"," 8,\n"," 28,\n"," -28,\n"," 5,\n"," -5,\n"," 6,\n"," -6,\n"," -8,\n"," 8,\n"," -32,\n"," 32,\n"," -12,\n"," 12,\n"," 14,\n"," -14,\n"," 8,\n"," -8,\n"," -9,\n"," 9,\n"," 5,\n"," -5,\n"," -2,\n"," 2,\n"," -24,\n"," 24,\n"," 20,\n"," -20,\n"," -23,\n"," 23,\n"," 4,\n"," -4,\n"," 24,\n"," -24,\n"," 10,\n"," -10,\n"," 21,\n"," -21,\n"," -8,\n"," 8,\n"," -7,\n"," 7,\n"," 8,\n"," -8,\n"," -15,\n"," 15,\n"," 6,\n"," -6,\n"," -23,\n"," 23,\n"," -12,\n"," 12,\n"," -3,\n"," 3,\n"," -10,\n"," 10,\n"," -3,\n"," 3,\n"," -1,\n"," 1,\n"," 6,\n"," -6,\n"," -3,\n"," 3,\n"," -32,\n"," 32,\n"," 9,\n"," -9,\n"," -1,\n"," 1,\n"," -2,\n"," 2,\n"," 16,\n"," -16,\n"," 2,\n"," -2,\n"," -26,\n"," 26,\n"," 3,\n"," -3,\n"," -1,\n"," 1,\n"," 29,\n"," -29,\n"," 17,\n"," -17,\n"," 6,\n"," -6,\n"," -3,\n"," 3,\n"," -8,\n"," 8,\n"," -12,\n"," 12,\n"," 8,\n"," -8,\n"," -17,\n"," 17,\n"," -4,\n"," 4,\n"," 24,\n"," -24,\n"," 7,\n"," -7,\n"," -3,\n"," 3,\n"," -4,\n"," 4,\n"," 15,\n"," -15,\n"," 12,\n"," -12,\n"," -6,\n"," 6,\n"," 9,\n"," -9,\n"," -9,\n"," 9,\n"," 6,\n"," -6,\n"," -8,\n"," 8,\n"," 25,\n"," -25,\n"," 1,\n"," -1,\n"," -2,\n"," 2,\n"," -3,\n"," 3,\n"," -2,\n"," 2,\n"," -16,\n"," 16,\n"," -9,\n"," 9,\n"," 20,\n"," -20,\n"," -21,\n"," 21,\n"," -5,\n"," 5,\n"," 6,\n"," -6,\n"," -20,\n"," 20,\n"," 11,\n"," -11,\n"," 14,\n"," -14,\n"," 8,\n"," -8,\n"," -4,\n"," 4,\n"," 7,\n"," -7,\n"," -13,\n"," 13,\n"," -28,\n"," 28,\n"," -7,\n"," 7,\n"," 10,\n"," -10,\n"," 3,\n"," -3,\n"," -4,\n"," 4,\n"," 4,\n"," -4,\n"," 10,\n"," -10,\n"," -5,\n"," 5,\n"," -4,\n"," 4,\n"," -7,\n"," 7,\n"," 26,\n"," -26,\n"," -5,\n"," 5,\n"," -16,\n"," 16,\n"," 16,\n"," -16,\n"," 12,\n"," -12,\n"," -22,\n"," 22,\n"," 16,\n"," -16,\n"," 12,\n"," -12,\n"," 22,\n"," -22,\n"," -7,\n"," 7,\n"," 12,\n"," -12,\n"," -12,\n"," 12,\n"," 5,\n"," -5,\n"," 19,\n"," -19,\n"," 13,\n"," -13,\n"," 11,\n"," -11,\n"," -3,\n"," 3,\n"," -1,\n"," 1,\n"," -3,\n"," 3,\n"," 8,\n"," -8,\n"," 11,\n"," -11,\n"," 10,\n"," -10,\n"," -15,\n"," 15,\n"," -15,\n"," 15,\n"," 5,\n"," -5,\n"," -4,\n"," 4,\n"," 4,\n"," -4,\n"," 6,\n"," -6,\n"," 2,\n"," -2,\n"," -15,\n"," 15,\n"," 18,\n"," -18,\n"," -18,\n"," 18,\n"," -7,\n"," 7,\n"," -12,\n"," 12,\n"," 4,\n"," -4,\n"," 10,\n"," -10,\n"," 6,\n"," -6,\n"," -16,\n"," 16,\n"," -3,\n"," 3,\n"," -3,\n"," 3,\n"," 5,\n"," -5,\n"," -8,\n"," 8,\n"," 16,\n"," -16,\n"," -2,\n"," 2,\n"," 19,\n"," -19,\n"," -22,\n"," 22,\n"," -15,\n"," 15,\n"," 9,\n"," -9,\n"," 4,\n"," -4,\n"," -4,\n"," 4,\n"," -7,\n"," 7,\n"," 8,\n"," -8,\n"," -8,\n"," 8,\n"," -20,\n"," 20,\n"," 8,\n"," -8,\n"," -15,\n"," 15,\n"," 14,\n"," -14,\n"," 4,\n"," -4,\n"," 8,\n"," -8,\n"," -29,\n"," 29,\n"," 15,\n"," -15,\n"," -4,\n"," 4,\n"," -4,\n"," 4,\n"," 2,\n"," -2,\n"," -5,\n"," 5,\n"," 2,\n"," -2,\n"," 10,\n"," -10,\n"," 14,\n"," -14,\n"," -16,\n"," 16,\n"," -3,\n"," 3,\n"," 1,\n"," -1,\n"," -2,\n"," 2,\n"," -7,\n"," 7,\n"," 6,\n"," -6,\n"," 28,\n"," -28,\n"," 8,\n"," -8,\n"," -12,\n"," 12,\n"," 6,\n"," -6,\n"," 3,\n"," -3,\n"," -10,\n"," 10,\n"," -8,\n"," 8,\n"," -8,\n"," 8,\n"," -17,\n"," 17,\n"," -14,\n"," 14,\n"," 17,\n"," -17,\n"," -28,\n"," 28,\n"," 11,\n"," -11,\n"," 9,\n"," -9,\n"," -2,\n"," 2,\n"," -4,\n"," 4,\n"," -6,\n"," 6,\n"," 12,\n"," -12,\n"," -12,\n"," 12,\n"," 10,\n"," -10,\n"," -9,\n"," 9,\n"," 9,\n"," -9,\n"," -3,\n"," 3,\n"," 35,\n"," -35,\n"," 14,\n"," -14,\n"," -18,\n"," 18,\n"," -5,\n"," 5,\n"," 3,\n"," -3,\n"," 3,\n"," -3,\n"," -17,\n"," 17,\n"," 13,\n"," -13,\n"," 7,\n"," -7,\n"," -28,\n"," 28,\n"," 13,\n"," -13,\n"," -15,\n"," 15,\n"," -8,\n"," 8,\n"," -20,\n"," 20,\n"," 4,\n"," -4,\n"," 14,\n"," -14,\n"," -9,\n"," 9,\n"," 2,\n"," -2,\n"," -16,\n"," 16,\n"," 24,\n"," -24,\n"," -9,\n"," 9,\n"," 6,\n"," -6,\n"," -23,\n"," 23,\n"," -7,\n"," 7,\n"," -3,\n"," 3,\n"," -6,\n"," 6,\n"," -7,\n"," 7,\n"," 16,\n"," -16,\n"," -14,\n"," 14,\n"," -9,\n"," 9,\n"," 18,\n"," -18,\n"," -9,\n"," 9,\n"," -4,\n"," 4,\n"," 33,\n"," -33,\n"," -2,\n"," 2,\n"," -6,\n"," 6,\n"," -2,\n"," 2,\n"," -24,\n"," 24,\n"," 10,\n"," -10,\n"," -2,\n"," 2,\n"," -6,\n"," 6,\n"," 6,\n"," -6,\n"," 6,\n"," -6,\n"," -7,\n"," 7,\n"," -16,\n"," 16,\n"," 39,\n"," -39,\n"," 5,\n"," -5,\n"," -26,\n"," 26,\n"," -12,\n"," 12,\n"," -6,\n"," 6,\n"," -11,\n"," 11,\n"," 22,\n"," -22,\n"," 13,\n"," -13,\n"," 6,\n"," -6,\n"," -12,\n"," 12,\n"," 19,\n"," -19,\n"," -2,\n"," 2,\n"," -23,\n"," 23,\n"," -10,\n"," 10,\n"," 9,\n"," -9,\n"," 6,\n"," -6,\n"," 6,\n"," -6,\n"," 31,\n"," -31,\n"," -14,\n"," 14,\n"," 6,\n"," -6,\n"," 6,\n"," -6,\n"," -4,\n"," 4,\n"," -3,\n"," 3,\n"," -8,\n"," 8,\n"," 8,\n"," -8,\n"," -9,\n"," 9,\n"," 19,\n"," -19,\n"," ...]"]},"execution_count":56,"metadata":{},"output_type":"execute_result"}],"source":["# siapkan list kosong\n","# definisikan argumen dari for loop\n","# simpan hasil ke dalam list kosong\n","# jika sudah selesai convert list menjadi kolom\n","\n","# kolom pts -> nba.iloc[:, 10]\n","# kolom opp_pts -> nba.iloc[:, 14]\n","\n","hasil = []\n","\n","for idx in range(0,len(nba)):\n","    selisih = nba.iloc[idx, 10] - nba.iloc[idx, 14]\n","    hasil.append(selisih)\n","\n","hasil"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"nkEPw6x-9vQF"},"outputs":[],"source":["nba['selisih_loop'] = hasil"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"hhnTJQl_9vQF","outputId":"5b438918-a827-4013-a724-7dcbf3a6bb9d"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>gameorder</th>\n","      <th>game_id</th>\n","      <th>lg_id</th>\n","      <th>_iscopy</th>\n","      <th>year_id</th>\n","      <th>date_game</th>\n","      <th>seasongame</th>\n","      <th>is_playoffs</th>\n","      <th>team_id</th>\n","      <th>fran_id</th>\n","      <th>pts</th>\n","      <th>win_equiv</th>\n","      <th>opp_id</th>\n","      <th>opp_fran</th>\n","      <th>opp_pts</th>\n","      <th>loc</th>\n","      <th>result</th>\n","      <th>forecast</th>\n","      <th>notes</th>\n","      <th>selisih</th>\n","      <th>selisih_loop</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>40.294830</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","      <td>-2</td>\n","      <td>-2</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>194611010TRH</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/1/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>68</td>\n","      <td>41.705170</td>\n","      <td>TRH</td>\n","      <td>Huskies</td>\n","      <td>66</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.359935</td>\n","      <td>NaN</td>\n","      <td>2</td>\n","      <td>2</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>42.012257</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.631101</td>\n","      <td>NaN</td>\n","      <td>16</td>\n","      <td>16</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2</td>\n","      <td>194611020CHS</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>NYK</td>\n","      <td>Knicks</td>\n","      <td>47</td>\n","      <td>40.692783</td>\n","      <td>CHS</td>\n","      <td>Stags</td>\n","      <td>63</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.368899</td>\n","      <td>NaN</td>\n","      <td>-16</td>\n","      <td>-16</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>3</td>\n","      <td>194611020DTF</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>1947</td>\n","      <td>11/2/1946</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>DTF</td>\n","      <td>Falcons</td>\n","      <td>33</td>\n","      <td>38.864048</td>\n","      <td>WSC</td>\n","      <td>Capitols</td>\n","      <td>50</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.640065</td>\n","      <td>NaN</td>\n","      <td>-17</td>\n","      <td>-17</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>126309</th>\n","      <td>63155</td>\n","      <td>201506110CLE</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/11/2015</td>\n","      <td>100</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>82</td>\n","      <td>60.309792</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>103</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.546572</td>\n","      <td>NaN</td>\n","      <td>-21</td>\n","      <td>-21</td>\n","    </tr>\n","    <tr>\n","      <th>126310</th>\n","      <td>63156</td>\n","      <td>201506140GSW</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/14/2015</td>\n","      <td>102</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>104</td>\n","      <td>68.013329</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>91</td>\n","      <td>H</td>\n","      <td>W</td>\n","      <td>0.765565</td>\n","      <td>NaN</td>\n","      <td>13</td>\n","      <td>13</td>\n","    </tr>\n","    <tr>\n","      <th>126311</th>\n","      <td>63156</td>\n","      <td>201506140GSW</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/14/2015</td>\n","      <td>101</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>91</td>\n","      <td>60.010067</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>104</td>\n","      <td>A</td>\n","      <td>L</td>\n","      <td>0.234435</td>\n","      <td>NaN</td>\n","      <td>-13</td>\n","      <td>-13</td>\n","    </tr>\n","    <tr>\n","      <th>126312</th>\n","      <td>63157</td>\n","      <td>201506170CLE</td>\n","      <td>NBA</td>\n","      <td>0</td>\n","      <td>2015</td>\n","      <td>6/16/2015</td>\n","      <td>102</td>\n","      <td>1</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>97</td>\n","      <td>59.290245</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>105</td>\n","      <td>H</td>\n","      <td>L</td>\n","      <td>0.481450</td>\n","      <td>NaN</td>\n","      <td>-8</td>\n","      <td>-8</td>\n","    </tr>\n","    <tr>\n","      <th>126313</th>\n","      <td>63157</td>\n","      <td>201506170CLE</td>\n","      <td>NBA</td>\n","      <td>1</td>\n","      <td>2015</td>\n","      <td>6/16/2015</td>\n","      <td>103</td>\n","      <td>1</td>\n","      <td>GSW</td>\n","      <td>Warriors</td>\n","      <td>105</td>\n","      <td>68.519516</td>\n","      <td>CLE</td>\n","      <td>Cavaliers</td>\n","      <td>97</td>\n","      <td>A</td>\n","      <td>W</td>\n","      <td>0.518550</td>\n","      <td>NaN</td>\n","      <td>8</td>\n","      <td>8</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>126314 rows × 21 columns</p>\n","</div>"],"text/plain":["        gameorder       game_id lg_id  _iscopy  year_id  date_game  \\\n","0               1  194611010TRH   NBA        0     1947  11/1/1946   \n","1               1  194611010TRH   NBA        1     1947  11/1/1946   \n","2               2  194611020CHS   NBA        0     1947  11/2/1946   \n","3               2  194611020CHS   NBA        1     1947  11/2/1946   \n","4               3  194611020DTF   NBA        0     1947  11/2/1946   \n","...           ...           ...   ...      ...      ...        ...   \n","126309      63155  201506110CLE   NBA        0     2015  6/11/2015   \n","126310      63156  201506140GSW   NBA        0     2015  6/14/2015   \n","126311      63156  201506140GSW   NBA        1     2015  6/14/2015   \n","126312      63157  201506170CLE   NBA        0     2015  6/16/2015   \n","126313      63157  201506170CLE   NBA        1     2015  6/16/2015   \n","\n","        seasongame  is_playoffs team_id    fran_id  pts  win_equiv opp_id  \\\n","0                1            0     TRH    Huskies   66  40.294830    NYK   \n","1                1            0     NYK     Knicks   68  41.705170    TRH   \n","2                1            0     CHS      Stags   63  42.012257    NYK   \n","3                2            0     NYK     Knicks   47  40.692783    CHS   \n","4                1            0     DTF    Falcons   33  38.864048    WSC   \n","...            ...          ...     ...        ...  ...        ...    ...   \n","126309         100            1     CLE  Cavaliers   82  60.309792    GSW   \n","126310         102            1     GSW   Warriors  104  68.013329    CLE   \n","126311         101            1     CLE  Cavaliers   91  60.010067    GSW   \n","126312         102            1     CLE  Cavaliers   97  59.290245    GSW   \n","126313         103            1     GSW   Warriors  105  68.519516    CLE   \n","\n","         opp_fran  opp_pts loc result  forecast notes  selisih  selisih_loop  \n","0          Knicks       68   H      L  0.640065   NaN       -2            -2  \n","1         Huskies       66   A      W  0.359935   NaN        2             2  \n","2          Knicks       47   H      W  0.631101   NaN       16            16  \n","3           Stags       63   A      L  0.368899   NaN      -16           -16  \n","4        Capitols       50   H      L  0.640065   NaN      -17           -17  \n","...           ...      ...  ..    ...       ...   ...      ...           ...  \n","126309   Warriors      103   H      L  0.546572   NaN      -21           -21  \n","126310  Cavaliers       91   H      W  0.765565   NaN       13            13  \n","126311   Warriors      104   A      L  0.234435   NaN      -13           -13  \n","126312   Warriors      105   H      L  0.481450   NaN       -8            -8  \n","126313  Cavaliers       97   A      W  0.518550   NaN        8             8  \n","\n","[126314 rows x 21 columns]"]},"execution_count":58,"metadata":{},"output_type":"execute_result"}],"source":["nba"]},{"cell_type":"markdown","metadata":{"id":"_hAWjWtZ9vQF"},"source":["## **Visualization**"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"UStPYP_09vQF","outputId":"9182eb33-f187-4691-fc49-c32e0df830e6"},"outputs":[{"data":{"text/plain":["<AxesSubplot:>"]},"execution_count":62,"metadata":{},"output_type":"execute_result"},{"data":{"image/png":"iVBORw0KGgoAAAANSUhEUgAAAX0AAAEYCAYAAACwQCa4AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8rg+JYAAAACXBIWXMAAAsTAAALEwEAmpwYAAAYDklEQVR4nO3df7RdZX3n8ffHRJQ6QILErEwSTSxRi1WQ3gYUl1PJNASwhrqQgVpJMRpXV1phdKYDs3SyBOloxxZlKrSpSRssU0wtlhSxkBV/tSo/EqBEfq3cIqwk8iMlCVJRFPjMH/u55nC5J/dcuDn7Js/ntdZdZ+9n73Pud5/kfs4+z3723rJNRETU4UVtFxAREf2T0I+IqEhCPyKiIgn9iIiKJPQjIiqS0I+IqMjktgvYmyOOOMJz5sxpu4yIiP3Kpk2b/s32tJGWTejQnzNnDhs3bmy7jIiI/YqkB7otS/dORERFEvoRERVJ6EdEVCShHxFRkYR+RERFegp9SVMkfUnSPZLulvRmSYdLWi9pS3mcWtaVpEslDUq6Q9KxHa+zpKy/RdKSfbVRERExsl739D8L/KPt1wFHA3cD5wMbbM8DNpR5gJOBeeVnGXA5gKTDgRXAccB8YMXQB0VERPTHqKEv6TDgbcAqANs/tb0bWAysKautAU4r04uBK9y4EZgiaQZwErDe9k7bu4D1wKJx3JaIiBhFLydnzQV2AH8p6WhgE3AuMN32g2Wdh4DpZXomsLXj+dtKW7f2fWrO+V/Z17+iJ/d/8tS2S4iI6Cn0JwPHAr9v+yZJn2VPVw4Ati1pXG7BJWkZTbcQr3zlK8fjJaPIB2BE9NKnvw3YZvumMv8lmg+Bh0u3DeXxkbJ8OzC74/mzSlu39mexvdL2gO2BadNGvHREREQ8T6OGvu2HgK2SXluaFgB3AeuAoRE4S4BryvQ64Owyiud44LHSDXQ9sFDS1HIAd2Fpi4iIPun1gmu/D1wp6SDgPuAcmg+MtZKWAg8AZ5R1rwNOAQaBJ8q62N4p6SLglrLehbZ3jstWRERET3oKfdu3AwMjLFowwroGlnd5ndXA6jHUFxER4yhn5EZEVCShHxFRkYR+RERFJvSdsyL2lYlwzkLOV4g2ZE8/IqIiCf2IiIok9CMiKpI+/YjK5fjGHjW8F9nTj4ioSEI/IqIiCf2IiIok9CMiKpLQj4ioSEI/IqIiCf2IiIok9CMiKpLQj4ioSEI/IqIiCf2IiIok9CMiKpLQj4ioSEI/IqIiCf2IiIok9CMiKpLQj4ioSEI/IqIiPYW+pPslbZZ0u6SNpe1wSeslbSmPU0u7JF0qaVDSHZKO7XidJWX9LZKW7JtNioiIbsayp/9228fYHijz5wMbbM8DNpR5gJOBeeVnGXA5NB8SwArgOGA+sGLogyIiIvrjhXTvLAbWlOk1wGkd7Ve4cSMwRdIM4CRgve2dtncB64FFL+D3R0TEGPUa+gZukLRJ0rLSNt32g2X6IWB6mZ4JbO147rbS1q39WSQtk7RR0sYdO3b0WF5ERPRico/rvdX2dkmvANZLuqdzoW1L8ngUZHslsBJgYGBgXF4zIiIaPe3p295eHh8BvkzTJ/9w6bahPD5SVt8OzO54+qzS1q09IiL6ZNTQl/QySYcMTQMLge8B64ChEThLgGvK9Drg7DKK53jgsdINdD2wUNLUcgB3YWmLiIg+6aV7ZzrwZUlD6/8/2/8o6RZgraSlwAPAGWX964BTgEHgCeAcANs7JV0E3FLWu9D2znHbkoiIGNWooW/7PuDoEdofBRaM0G5geZfXWg2sHnuZERExHnJGbkRERRL6EREVSehHRFQkoR8RUZGEfkRERRL6EREVSehHRFQkoR8RUZGEfkRERRL6EREVSehHRFQkoR8RUZGEfkRERRL6EREVSehHRFQkoR8RUZGEfkRERRL6EREVSehHRFQkoR8RUZGEfkRERRL6EREVSehHRFQkoR8RUZGEfkRERXoOfUmTJN0m6doyP1fSTZIGJX1R0kGl/SVlfrAsn9PxGheU9nslnTTuWxMREXs1lj39c4G7O+Y/BVxi+0hgF7C0tC8FdpX2S8p6SDoKOBN4PbAIuEzSpBdWfkREjEVPoS9pFnAq8PkyL+BE4EtllTXAaWV6cZmnLF9Q1l8MXGX7SdvfBwaB+eOwDRER0aNe9/Q/A/wB8EyZfzmw2/ZTZX4bMLNMzwS2ApTlj5X1f94+wnMiIqIPRg19Se8AHrG9qQ/1IGmZpI2SNu7YsaMfvzIiohq97OmfALxT0v3AVTTdOp8FpkiaXNaZBWwv09uB2QBl+WHAo53tIzzn52yvtD1ge2DatGlj3qCIiOhu1NC3fYHtWbbn0ByI/Zrt9wBfB04vqy0BrinT68o8ZfnXbLu0n1lG98wF5gE3j9uWRETEqCaPvkpX/wO4StIngNuAVaV9FfAFSYPATpoPCmzfKWktcBfwFLDc9tMv4PdHRMQYjSn0bX8D+EaZvo8RRt/Y/gnw7i7Pvxi4eKxFRkTE+MgZuRERFUnoR0RUJKEfEVGRhH5EREUS+hERFUnoR0RUJKEfEVGRhH5EREUS+hERFUnoR0RUJKEfEVGRhH5EREUS+hERFUnoR0RUJKEfEVGRhH5EREUS+hERFUnoR0RUJKEfEVGRhH5EREUS+hERFUnoR0RUJKEfEVGRhH5EREUS+hERFUnoR0RUZNTQl/RSSTdL+hdJd0r6eGmfK+kmSYOSvijpoNL+kjI/WJbP6XitC0r7vZJO2mdbFRERI+plT/9J4ETbRwPHAIskHQ98CrjE9pHALmBpWX8psKu0X1LWQ9JRwJnA64FFwGWSJo3jtkRExChGDX03/r3Mvrj8GDgR+FJpXwOcVqYXl3nK8gWSVNqvsv2k7e8Dg8D88diIiIjoTU99+pImSbodeARYD/wrsNv2U2WVbcDMMj0T2ApQlj8GvLyzfYTndP6uZZI2Stq4Y8eOMW9QRER011Po237a9jHALJq989ftq4Jsr7Q9YHtg2rRp++rXRERUaUyjd2zvBr4OvBmYImlyWTQL2F6mtwOzAcryw4BHO9tHeE5ERPRBL6N3pkmaUqYPBn4duJsm/E8vqy0BrinT68o8ZfnXbLu0n1lG98wF5gE3j9N2REREDyaPvgozgDVlpM2LgLW2r5V0F3CVpE8AtwGryvqrgC9IGgR20ozYwfadktYCdwFPActtPz2+mxMREXszaujbvgN40wjt9zHC6BvbPwHe3eW1LgYuHnuZERExHnJGbkRERRL6EREVSehHRFQkoR8RUZGEfkRERRL6EREVSehHRFQkoR8RUZGEfkRERRL6EREVSehHRFQkoR8RUZGEfkRERRL6EREVSehHRFQkoR8RUZGEfkRERRL6EREVSehHRFQkoR8RUZGEfkRERRL6EREVSehHRFQkoR8RUZGEfkRERUYNfUmzJX1d0l2S7pR0bmk/XNJ6SVvK49TSLkmXShqUdIekYztea0lZf4ukJftusyIiYiS97Ok/BXzE9lHA8cBySUcB5wMbbM8DNpR5gJOBeeVnGXA5NB8SwArgOGA+sGLogyIiIvpj1NC3/aDtW8v048DdwExgMbCmrLYGOK1MLwaucONGYIqkGcBJwHrbO23vAtYDi8ZzYyIiYu/G1KcvaQ7wJuAmYLrtB8uih4DpZXomsLXjadtKW7f24b9jmaSNkjbu2LFjLOVFRMQoeg59Sf8B+DvgPNs/7Fxm24DHoyDbK20P2B6YNm3aeLxkREQUPYW+pBfTBP6Vtq8uzQ+XbhvK4yOlfTswu+Pps0pbt/aIiOiTXkbvCFgF3G37TzoWrQOGRuAsAa7paD+7jOI5HnisdANdDyyUNLUcwF1Y2iIiok8m97DOCcB7gc2Sbi9t/xP4JLBW0lLgAeCMsuw64BRgEHgCOAfA9k5JFwG3lPUutL1zPDYiIiJ6M2ro2/5nQF0WLxhhfQPLu7zWamD1WAqMiIjxkzNyIyIqktCPiKhIQj8ioiIJ/YiIiiT0IyIqktCPiKhIQj8ioiIJ/YiIiiT0IyIqktCPiKhIQj8ioiIJ/YiIiiT0IyIqktCPiKhIQj8ioiIJ/YiIiiT0IyIqktCPiKhIQj8ioiIJ/YiIiiT0IyIqktCPiKhIQj8ioiIJ/YiIiiT0IyIqMmroS1ot6RFJ3+toO1zSeklbyuPU0i5Jl0oalHSHpGM7nrOkrL9F0pJ9szkREbE3vezp/xWwaFjb+cAG2/OADWUe4GRgXvlZBlwOzYcEsAI4DpgPrBj6oIiIiP4ZNfRtfwvYOax5MbCmTK8BTutov8KNG4EpkmYAJwHrbe+0vQtYz3M/SCIiYh97vn36020/WKYfAqaX6ZnA1o71tpW2bu0REdFHL/hArm0DHodaAJC0TNJGSRt37NgxXi8bERE8/9B/uHTbUB4fKe3bgdkd680qbd3an8P2StsDtgemTZv2PMuLiIiRPN/QXwcMjcBZAlzT0X52GcVzPPBY6Qa6HlgoaWo5gLuwtEVERB9NHm0FSX8D/BpwhKRtNKNwPgmslbQUeAA4o6x+HXAKMAg8AZwDYHunpIuAW8p6F9oefnA4IiL2sVFD3/ZZXRYtGGFdA8u7vM5qYPWYqouIiHGVM3IjIiqS0I+IqEhCPyKiIgn9iIiKJPQjIiqS0I+IqEhCPyKiIgn9iIiKJPQjIiqS0I+IqEhCPyKiIgn9iIiKJPQjIiqS0I+IqEhCPyKiIgn9iIiKJPQjIiqS0I+IqEhCPyKiIgn9iIiKJPQjIiqS0I+IqEhCPyKiIgn9iIiKJPQjIiqS0I+IqEjfQ1/SIkn3ShqUdH6/f39ERM36GvqSJgGfA04GjgLOknRUP2uIiKhZv/f05wODtu+z/VPgKmBxn2uIiKiWbPfvl0mnA4tsv7/Mvxc4zvbvdayzDFhWZl8L3Nu3Ars7Avi3touYIPJe7JH3Yo+8F3tMhPfiVbanjbRgcr8rGY3tlcDKtuvoJGmj7YG265gI8l7skfdij7wXe0z096Lf3Tvbgdkd87NKW0RE9EG/Q/8WYJ6kuZIOAs4E1vW5hoiIavW1e8f2U5J+D7gemASstn1nP2t4niZUd1PL8l7skfdij7wXe0zo96KvB3IjIqJdOSM3IqIiCf2IiIok9CMiKpLQj4gXRNJUSW9su47oTUK/C0l/JOlQSS+WtEHSDkm/3XZd/Sbp3PI+SNIqSbdKWth2XW2R9G5Jh5Tpj0q6WtKxbdfVb5K+Uf5fHA7cCvyFpD9pu6627E9/Jwn97hba/iHwDuB+4Ejgv7daUTveV96HhcBU4L3AJ9stqVUfs/24pLcC/xlYBVzeck1tOKz8v3gXcIXt42jej1rtN38nCf3uXlweTwX+1vZjbRbTIpXHU4AvlPMqtJf1D3RPl8dTgZW2vwIc1GI9bZksaQZwBnBt28VMAPvN30lCv7t1ku4BfgXYIGka8JOWa2rDJkk30Pxnvr50bTzTck1t2i7pz4H/Alwn6SXU+Xf0cZqTLAdt3yLp1cCWlmtq037zd5KTs0Yg6UXA8cA9wGO2n5b0MuAQ2w+1W11/lffiGOA+27slvRyYafuOditrh6RfABYBm21vKXu7b7B9Q8ul9U25L8aHbF/Sdi0Txf70d1LjHsqobD8DfM72TttPl7Yf1Rb4xWLgX23vLvNPA69ur5zWnWX7attbAGw/CJzYck19Vf4mzmq7jomkZMbDwFGS3ga8HpjSalFdZE+/C0mfBr4LXO2K3yRJt9s+Zljbbbbf1FJJrZJ0HXCl7SvL/OeAl9pe2m5l/SXpEprjXl8EfjTUbvvW1opqkaRP0XT53cWe4z62/c72qhpZQr8LSY8DL6P5B/wxzUEZ2z601cL6TNIdtt84rG2z7Te0VVObJB1Mc2XY1TTdPLttn9tuVf0n6esjNNt2Vd96hki6F3ij7SfbrmU0Cf3YK0mrgd009zYGWA4cbvt32qqpDWU8+pBDgL8Hvg38LwDbO1soKyYISV8F3m3739uuZTQJ/S4kCXgPMNf2RZJmAzNs39xyaX1VDmB/jD1jsNcDn7D9o+7POvBI+j5gyjc+nj0cz7arOs4h6TBgBfC20vRN4MJahzZL+jvgaGAD8PO9fdsfaq2oLhL6XUi6nGbI1Ym2f0nSVOAG27/acmkRrSsh9z1gTWl6L3C07Xe1V1V7JC0Zqd32mpHa25TQ70LSrbaP7TxoKelfbB/ddm39IOkzts+T9A80e7bPMhEPUPWDpOU0B3J3l/mpNCN6Lmu1sD7rcoD/OW01KXcDfE2Zvdf2z9qsp5sJd2P0CeRnZTyyAcrJWRPyZIt95Avl8dOtVjHxfMD20PENbO+S9AGgqtAHfizprbb/GUDSCTQDHqok6ddovvXcT9P1N1vSEtvfarGsESX0u7sU+DLwCkkXA6cDH223pP6xvalMHmP7s53LJJ1L04dbo0mSNDSMt+wY1HgZht8F1pS+fQE7gd9ptaJ2/THN9bruBZD0GuBvaM7on1DSvdNFOb1+LrCA5j/1BuDh2kZpDHVzDWureZz+/wFeBfx5afogsNX2R9qrqj2SDgUoFxurVpehzc9pmwgS+l1I+gpw2lC/XDnd/lrbE+6Te1+QdBbwW8BbgX/qWHQI8IztBa0U1rJyuv0HaXYGoBnN9PmhM7cPdJJ+2/ZfS/rwSMttV3l55TK0+Rngr0vTe4BJtt/XXlUjS/dOd38PrJV0OjCb5oSc/9ZqRf31HeBB4Aiar65DHgcm3PVE+qWcbn85dV5OGZoTFqH58I89fpfmHJahIZr/xJ5zWyaU7OnvRRmpsQiYA3zQ9nfarSjaImmt7TMkbWbk0UwT7mv8vpILrj2XpHNHOvY1vG0iSOgPM+xrq4CzafZsb4N6vr6Wy1CM9J+j1stRzLD9oKRXjbTc9gP9rqlNkm62Pb/tOiaK/enYV7p3nmv419aru7Qf0GxXtb2jKVfTrC7c9+Lbkv6Uyi+41nHsa66kdR2LDqUZ0TThZE8/RlVuDTjP9l9KOoLmvgLfb7uuNkh6F/Ap4BU033pq/eaTC64B5ZvfXOB/A+d3LHocuMP2U60UthcJ/S7KyVh/QHNd7JcOtVf4n3oFMAC81vZrJP1HmttHntByaa2QNAj8hu27266lLenTf65yjaof236mjNF/HfDViXhWbm6i0t2VNHfOmktza7j7gVvaLKglvwm8k/IV3vYPqKyra5iHaw58yE1UuvgW8FJJM4EbaK5F9FetVtRF+vS7e7ntVeUI/DeBb0qqMfR/atuShs5AfdloTzjAbZT0RZohvZ1XU7y66zMOTOnTfzbZfkLSUuAy238k6fa2ixpJQr+7oa9lD0o6FfgBcPhe1j9QrS03Ap9SrjHzPuAvWq6pTYcCTwALO9rMngP+tTimPF7Y0WYqu3VkB0l6M81JWUN3UZvUYj1dJfS7+0S5rshHgP9L88d+XqsV9ZGkI4Hptj8t6deBHwKvBb4KXNdqcS2QNNv2VtvnjLDsHW3U1Cbbb2+7hgnmPOAC4Mu275T0amCkg92ty4HcMZB0nu3PtF1HP0i6FrjA9uZh7W8A/tD2b7RTWTsk3QMssn3/sPZzgI/a/sVWCmtR+QY8fKDDhd2fERNB9vTH5sPAZ9ouok+mDw98ANubJc1poZ62fRi4QdKptrcASLqAZoz2f2q1shZI+jPgF4C3A5+nuQptVXeVg/3zvhMJ/bHR6KscMKbsZdnB/SpiorB9naQnga9KOg14PzAfeJvtXa0W14632H5juZLkxyX9MU3XX232u/tOJPTHpqa+sI2SPmD7WQdtJb0f2NTlOQc02xtKd843aC5Id6Ltn7RbVWuGtvuJcu7Go8CMFutpy52SzgOOBDYDqybiCVmd0qc/zCjXnDnYdhUflJKm09xE5qfsCfkBmhuG/Kbth9qqrQ0d/y8EvIRmdNfTVHZGbgm479CMXvpTmtE6l9G8N5+3/bH2quu/Mnz3ZzRX1TwZeMD2ue1WtXcJ/dgrSW8HfrnM3mn7a23WE+2S9GngLcAv0VyI8NvAd4Hv2H60zdraIGmz7TeU6cnAzcMvvDbRJPQjYszKTcAHaD4A3lx+dts+qtXC+mz41TVHutrmRFNFV0VEjLuDac5dOaz8/ICmT7s2R0saulWkgIPL/ITt9suefkT0TNJKmrH5jwM3ATcCN1Y6gmm/lAuuRcRYvJLmQPZDwHZgG7C7zYJibLKnHxFjIkk0e/tvKT+/THPDkO/aXtFmbTG6hH5EPC+SZgEn0AT/O2iuTDul1aJiVAn9iOiZpA+xZw//ZzRj9od+Ntt+psXyogcZvRMRYzEH+Fvgvw7dNzj2L9nTj4ioSEbvRERUJKEfEVGRhH5EREUS+hERFUnoR0RU5P8D1hqo5bg6uWgAAAAASUVORK5CYII=\n","text/plain":["<Figure size 432x288 with 1 Axes>"]},"metadata":{"needs_background":"light"},"output_type":"display_data"}],"source":["nba['fran_id'].value_counts().head(5).plot(kind='bar')"]},{"cell_type":"code","source":[""],"metadata":{"id":"EptxaL-renFP"},"execution_count":null,"outputs":[]}],"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"},"language_info":{"codemirror_mode":{"name":"ipython","version":3},"file_extension":".py","mimetype":"text/x-python","name":"python","nbconvert_exporter":"python","pygments_lexer":"ipython3","version":"3.8.5"},"colab":{"name":"w1d4PM_Pandas NBA & Solving.ipynb","provenance":[{"file_id":"1JF0Ia0K3S6MPlJC7FdmNdU9if8-Df5UN","timestamp":1653272505424}],"collapsed_sections":["qF8_4DDs9vP9","yftjLT9L9vP_","wBnNUUC69vQB","A9CPUsf19vQE","_hAWjWtZ9vQF"]}},"nbformat":4,"nbformat_minor":0}