merge_bases.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "political-rebel",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "preliminary-weight",
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = pd.read_csv('baseU18.csv')\n",
    "df2 = pd.read_csv('baseEuroleague.csv')\n",
    "df3 = pd.read_csv('baseEurocup.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "crude-forge",
   "metadata": {},
   "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>season</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>games</th>\n",
       "      <th>index</th>\n",
       "      <th>average</th>\n",
       "      <th>per_40min</th>\n",
       "      <th>minutes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-19 KAUNAS</td>\n",
       "      <td>4</td>\n",
       "      <td>ABAD, MAURO</td>\n",
       "      <td>U18 TORRONS VICENS L'HOSPITALET</td>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>18.50</td>\n",
       "      <td>29.37</td>\n",
       "      <td>100:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2012-13</td>\n",
       "      <td>11</td>\n",
       "      <td>ABALDE, ALBERTO</td>\n",
       "      <td>IJT CLUB JOVENTUT BADALONA</td>\n",
       "      <td>9</td>\n",
       "      <td>115</td>\n",
       "      <td>12.78</td>\n",
       "      <td>19.82</td>\n",
       "      <td>232:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2002-03</td>\n",
       "      <td>47</td>\n",
       "      <td>ABBAD, ROMAIN</td>\n",
       "      <td>U18 ELAN BEARNAIS PAU ORTHEZ</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3.00</td>\n",
       "      <td>4.86</td>\n",
       "      <td>74:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2009-10</td>\n",
       "      <td>286</td>\n",
       "      <td>ABIA, LARRY</td>\n",
       "      <td>IJT POWER ELECTRONICS</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1.33</td>\n",
       "      <td>3.73</td>\n",
       "      <td>42:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-16 KAUNAS</td>\n",
       "      <td>67</td>\n",
       "      <td>ABRAHA, FEKREMARIAM</td>\n",
       "      <td>U18 PORSCHE BASKETBALL ACADEMY LUDWIGSBURG</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0.67</td>\n",
       "      <td>1.95</td>\n",
       "      <td>40:56</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3955</th>\n",
       "      <td>2020-21 VALENCIA</td>\n",
       "      <td>89</td>\n",
       "      <td>ZULEMIE, NATHAN</td>\n",
       "      <td>U18 Nanterre 92</td>\n",
       "      <td>4</td>\n",
       "      <td>-5</td>\n",
       "      <td>-1.25</td>\n",
       "      <td>-3.02</td>\n",
       "      <td>66:07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3956</th>\n",
       "      <td>2008-09</td>\n",
       "      <td>222</td>\n",
       "      <td>ZUYKOV, DANYLO</td>\n",
       "      <td>BC KYIV</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.64</td>\n",
       "      <td>121:01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3957</th>\n",
       "      <td>2011-12</td>\n",
       "      <td>343</td>\n",
       "      <td>ZVEREV, NIKITA</td>\n",
       "      <td>IJT BC KHIMKI MOSCOW REGION</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3958</th>\n",
       "      <td>2011-12</td>\n",
       "      <td>39</td>\n",
       "      <td>ZVIGURS, IVARS</td>\n",
       "      <td>IJT VEF RIGA</td>\n",
       "      <td>4</td>\n",
       "      <td>69</td>\n",
       "      <td>17.25</td>\n",
       "      <td>20.97</td>\n",
       "      <td>131:38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3959</th>\n",
       "      <td>2015-16  BELGRADE</td>\n",
       "      <td>10</td>\n",
       "      <td>ZYLKA, FERDINAND</td>\n",
       "      <td>U18 ALBA BERLIN</td>\n",
       "      <td>4</td>\n",
       "      <td>85</td>\n",
       "      <td>21.25</td>\n",
       "      <td>30.48</td>\n",
       "      <td>111:33</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3960 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 season  rank               player  \\\n",
       "0        2018-19 KAUNAS     4          ABAD, MAURO   \n",
       "1               2012-13    11      ABALDE, ALBERTO   \n",
       "2               2002-03    47        ABBAD, ROMAIN   \n",
       "3               2009-10   286          ABIA, LARRY   \n",
       "4        2015-16 KAUNAS    67  ABRAHA, FEKREMARIAM   \n",
       "...                 ...   ...                  ...   \n",
       "3955   2020-21 VALENCIA    89      ZULEMIE, NATHAN   \n",
       "3956            2008-09   222       ZUYKOV, DANYLO   \n",
       "3957            2011-12   343       ZVEREV, NIKITA   \n",
       "3958            2011-12    39       ZVIGURS, IVARS   \n",
       "3959  2015-16  BELGRADE    10     ZYLKA, FERDINAND   \n",
       "\n",
       "                                            team  games  index  average  \\\n",
       "0                U18 TORRONS VICENS L'HOSPITALET      4     74    18.50   \n",
       "1                     IJT CLUB JOVENTUT BADALONA      9    115    12.78   \n",
       "2                   U18 ELAN BEARNAIS PAU ORTHEZ      3      9     3.00   \n",
       "3                          IJT POWER ELECTRONICS      3      4     1.33   \n",
       "4     U18 PORSCHE BASKETBALL ACADEMY LUDWIGSBURG      3      2     0.67   \n",
       "...                                          ...    ...    ...      ...   \n",
       "3955                             U18 Nanterre 92      4     -5    -1.25   \n",
       "3956                                     BC KYIV      4      8     2.00   \n",
       "3957                 IJT BC KHIMKI MOSCOW REGION      3      0     0.00   \n",
       "3958                                IJT VEF RIGA      4     69    17.25   \n",
       "3959                             U18 ALBA BERLIN      4     85    21.25   \n",
       "\n",
       "      per_40min minutes  \n",
       "0         29.37  100:46  \n",
       "1         19.82  232:08  \n",
       "2          4.86   74:00  \n",
       "3          3.73   42:54  \n",
       "4          1.95   40:56  \n",
       "...         ...     ...  \n",
       "3955      -3.02   66:07  \n",
       "3956       2.64  121:01  \n",
       "3957       0.00   10:11  \n",
       "3958      20.97  131:38  \n",
       "3959      30.48  111:33  \n",
       "\n",
       "[3960 rows x 9 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = df1.drop('Unnamed: 0', axis=1)\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "duplicate-screening",
   "metadata": {},
   "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>season</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>games</th>\n",
       "      <th>index</th>\n",
       "      <th>average</th>\n",
       "      <th>per_40min</th>\n",
       "      <th>minutes</th>\n",
       "      <th>index1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-19 KAUNAS</td>\n",
       "      <td>4</td>\n",
       "      <td>ABAD, MAURO</td>\n",
       "      <td>U18 TORRONS VICENS L'HOSPITALET</td>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>18.50</td>\n",
       "      <td>29.37</td>\n",
       "      <td>100:46</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2012-13</td>\n",
       "      <td>11</td>\n",
       "      <td>ABALDE, ALBERTO</td>\n",
       "      <td>IJT CLUB JOVENTUT BADALONA</td>\n",
       "      <td>9</td>\n",
       "      <td>115</td>\n",
       "      <td>12.78</td>\n",
       "      <td>19.82</td>\n",
       "      <td>232:08</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2002-03</td>\n",
       "      <td>47</td>\n",
       "      <td>ABBAD, ROMAIN</td>\n",
       "      <td>U18 ELAN BEARNAIS PAU ORTHEZ</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3.00</td>\n",
       "      <td>4.86</td>\n",
       "      <td>74:00</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2009-10</td>\n",
       "      <td>286</td>\n",
       "      <td>ABIA, LARRY</td>\n",
       "      <td>IJT POWER ELECTRONICS</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1.33</td>\n",
       "      <td>3.73</td>\n",
       "      <td>42:54</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-16 KAUNAS</td>\n",
       "      <td>67</td>\n",
       "      <td>ABRAHA, FEKREMARIAM</td>\n",
       "      <td>U18 PORSCHE BASKETBALL ACADEMY LUDWIGSBURG</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0.67</td>\n",
       "      <td>1.95</td>\n",
       "      <td>40:56</td>\n",
       "      <td>4</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3955</th>\n",
       "      <td>2020-21 VALENCIA</td>\n",
       "      <td>89</td>\n",
       "      <td>ZULEMIE, NATHAN</td>\n",
       "      <td>U18 Nanterre 92</td>\n",
       "      <td>4</td>\n",
       "      <td>-5</td>\n",
       "      <td>-1.25</td>\n",
       "      <td>-3.02</td>\n",
       "      <td>66:07</td>\n",
       "      <td>3955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3956</th>\n",
       "      <td>2008-09</td>\n",
       "      <td>222</td>\n",
       "      <td>ZUYKOV, DANYLO</td>\n",
       "      <td>BC KYIV</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.64</td>\n",
       "      <td>121:01</td>\n",
       "      <td>3956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3957</th>\n",
       "      <td>2011-12</td>\n",
       "      <td>343</td>\n",
       "      <td>ZVEREV, NIKITA</td>\n",
       "      <td>IJT BC KHIMKI MOSCOW REGION</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10:11</td>\n",
       "      <td>3957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3958</th>\n",
       "      <td>2011-12</td>\n",
       "      <td>39</td>\n",
       "      <td>ZVIGURS, IVARS</td>\n",
       "      <td>IJT VEF RIGA</td>\n",
       "      <td>4</td>\n",
       "      <td>69</td>\n",
       "      <td>17.25</td>\n",
       "      <td>20.97</td>\n",
       "      <td>131:38</td>\n",
       "      <td>3958</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3959</th>\n",
       "      <td>2015-16  BELGRADE</td>\n",
       "      <td>10</td>\n",
       "      <td>ZYLKA, FERDINAND</td>\n",
       "      <td>U18 ALBA BERLIN</td>\n",
       "      <td>4</td>\n",
       "      <td>85</td>\n",
       "      <td>21.25</td>\n",
       "      <td>30.48</td>\n",
       "      <td>111:33</td>\n",
       "      <td>3959</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3960 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 season  rank               player  \\\n",
       "0        2018-19 KAUNAS     4          ABAD, MAURO   \n",
       "1               2012-13    11      ABALDE, ALBERTO   \n",
       "2               2002-03    47        ABBAD, ROMAIN   \n",
       "3               2009-10   286          ABIA, LARRY   \n",
       "4        2015-16 KAUNAS    67  ABRAHA, FEKREMARIAM   \n",
       "...                 ...   ...                  ...   \n",
       "3955   2020-21 VALENCIA    89      ZULEMIE, NATHAN   \n",
       "3956            2008-09   222       ZUYKOV, DANYLO   \n",
       "3957            2011-12   343       ZVEREV, NIKITA   \n",
       "3958            2011-12    39       ZVIGURS, IVARS   \n",
       "3959  2015-16  BELGRADE    10     ZYLKA, FERDINAND   \n",
       "\n",
       "                                            team  games  index  average  \\\n",
       "0                U18 TORRONS VICENS L'HOSPITALET      4     74    18.50   \n",
       "1                     IJT CLUB JOVENTUT BADALONA      9    115    12.78   \n",
       "2                   U18 ELAN BEARNAIS PAU ORTHEZ      3      9     3.00   \n",
       "3                          IJT POWER ELECTRONICS      3      4     1.33   \n",
       "4     U18 PORSCHE BASKETBALL ACADEMY LUDWIGSBURG      3      2     0.67   \n",
       "...                                          ...    ...    ...      ...   \n",
       "3955                             U18 Nanterre 92      4     -5    -1.25   \n",
       "3956                                     BC KYIV      4      8     2.00   \n",
       "3957                 IJT BC KHIMKI MOSCOW REGION      3      0     0.00   \n",
       "3958                                IJT VEF RIGA      4     69    17.25   \n",
       "3959                             U18 ALBA BERLIN      4     85    21.25   \n",
       "\n",
       "      per_40min minutes  index1  \n",
       "0         29.37  100:46       0  \n",
       "1         19.82  232:08       1  \n",
       "2          4.86   74:00       2  \n",
       "3          3.73   42:54       3  \n",
       "4          1.95   40:56       4  \n",
       "...         ...     ...     ...  \n",
       "3955      -3.02   66:07    3955  \n",
       "3956       2.64  121:01    3956  \n",
       "3957       0.00   10:11    3957  \n",
       "3958      20.97  131:38    3958  \n",
       "3959      30.48  111:33    3959  \n",
       "\n",
       "[3960 rows x 10 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1['index1'] = df1.index\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "suspected-processor",
   "metadata": {},
   "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>season</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>games</th>\n",
       "      <th>index</th>\n",
       "      <th>average</th>\n",
       "      <th>per_40min</th>\n",
       "      <th>minutes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-21</td>\n",
       "      <td>76</td>\n",
       "      <td>ABALDE, ALBERTO</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>29</td>\n",
       "      <td>245</td>\n",
       "      <td>8.45</td>\n",
       "      <td>16.53</td>\n",
       "      <td>592:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-17</td>\n",
       "      <td>153</td>\n",
       "      <td>ABASS, AWUDU</td>\n",
       "      <td>EA7 Emporio Armani Milan</td>\n",
       "      <td>23</td>\n",
       "      <td>85</td>\n",
       "      <td>3.70</td>\n",
       "      <td>9.23</td>\n",
       "      <td>368:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2000-01</td>\n",
       "      <td>55</td>\n",
       "      <td>ABBIO, ALESSANDRO</td>\n",
       "      <td>Kinder Virtus Bologna</td>\n",
       "      <td>19</td>\n",
       "      <td>149</td>\n",
       "      <td>7.84</td>\n",
       "      <td>12.71</td>\n",
       "      <td>468:53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2006-07</td>\n",
       "      <td>250</td>\n",
       "      <td>ABDUL-RAUF, MAHMOUD</td>\n",
       "      <td>Aris TT Bank</td>\n",
       "      <td>17</td>\n",
       "      <td>22</td>\n",
       "      <td>1.29</td>\n",
       "      <td>4.57</td>\n",
       "      <td>192:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2001-02</td>\n",
       "      <td>310</td>\n",
       "      <td>ABI, MUSTAFA</td>\n",
       "      <td>Ulker</td>\n",
       "      <td>11</td>\n",
       "      <td>19</td>\n",
       "      <td>1.73</td>\n",
       "      <td>6.90</td>\n",
       "      <td>110:10</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2667</th>\n",
       "      <td>2002-03</td>\n",
       "      <td>139</td>\n",
       "      <td>ZUKAUSKAS, MINDAUGAS</td>\n",
       "      <td>Montepaschi Siena</td>\n",
       "      <td>22</td>\n",
       "      <td>107</td>\n",
       "      <td>4.86</td>\n",
       "      <td>8.20</td>\n",
       "      <td>522:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2668</th>\n",
       "      <td>2008-09</td>\n",
       "      <td>157</td>\n",
       "      <td>ZUPAN, MIHA</td>\n",
       "      <td>Union Olimpija</td>\n",
       "      <td>10</td>\n",
       "      <td>70</td>\n",
       "      <td>7.00</td>\n",
       "      <td>12.79</td>\n",
       "      <td>218:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2669</th>\n",
       "      <td>2004-05</td>\n",
       "      <td>229</td>\n",
       "      <td>ZUZA, JURICA</td>\n",
       "      <td>Cibona VIP</td>\n",
       "      <td>6</td>\n",
       "      <td>32</td>\n",
       "      <td>5.33</td>\n",
       "      <td>16.84</td>\n",
       "      <td>76:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2670</th>\n",
       "      <td>2008-09</td>\n",
       "      <td>318</td>\n",
       "      <td>ZWIENER, PHILLIP</td>\n",
       "      <td>Alba Berlin</td>\n",
       "      <td>3</td>\n",
       "      <td>-2</td>\n",
       "      <td>-0.67</td>\n",
       "      <td>-7.03</td>\n",
       "      <td>11:23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2671</th>\n",
       "      <td>2015-16</td>\n",
       "      <td>324</td>\n",
       "      <td>ZYWERT, KAMIL</td>\n",
       "      <td>Stelmet Zielona Gora</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1:36</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2672 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       season  rank                player                      team  games  \\\n",
       "0     2020-21    76       ABALDE, ALBERTO               Real Madrid     29   \n",
       "1     2016-17   153          ABASS, AWUDU  EA7 Emporio Armani Milan     23   \n",
       "2     2000-01    55     ABBIO, ALESSANDRO     Kinder Virtus Bologna     19   \n",
       "3     2006-07   250   ABDUL-RAUF, MAHMOUD              Aris TT Bank     17   \n",
       "4     2001-02   310          ABI, MUSTAFA                     Ulker     11   \n",
       "...       ...   ...                   ...                       ...    ...   \n",
       "2667  2002-03   139  ZUKAUSKAS, MINDAUGAS         Montepaschi Siena     22   \n",
       "2668  2008-09   157           ZUPAN, MIHA            Union Olimpija     10   \n",
       "2669  2004-05   229          ZUZA, JURICA                Cibona VIP      6   \n",
       "2670  2008-09   318      ZWIENER, PHILLIP               Alba Berlin      3   \n",
       "2671  2015-16   324         ZYWERT, KAMIL      Stelmet Zielona Gora      1   \n",
       "\n",
       "      index  average  per_40min minutes  \n",
       "0       245     8.45      16.53  592:51  \n",
       "1        85     3.70       9.23  368:32  \n",
       "2       149     7.84      12.71  468:53  \n",
       "3        22     1.29       4.57  192:45  \n",
       "4        19     1.73       6.90  110:10  \n",
       "...     ...      ...        ...     ...  \n",
       "2667    107     4.86       8.20  522:00  \n",
       "2668     70     7.00      12.79  218:51  \n",
       "2669     32     5.33      16.84   76:00  \n",
       "2670     -2    -0.67      -7.03   11:23  \n",
       "2671      0     0.00       0.00    1:36  \n",
       "\n",
       "[2672 rows x 9 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = df2.drop('Unnamed: 0', axis=1)\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "public-identification",
   "metadata": {},
   "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>season</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>games</th>\n",
       "      <th>index</th>\n",
       "      <th>average</th>\n",
       "      <th>per_40min</th>\n",
       "      <th>minutes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2007-08</td>\n",
       "      <td>282</td>\n",
       "      <td>AARTS, MARCEL</td>\n",
       "      <td>EiffelTowers Den Bosch</td>\n",
       "      <td>10</td>\n",
       "      <td>75</td>\n",
       "      <td>7.50</td>\n",
       "      <td>16.81</td>\n",
       "      <td>178:31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-19</td>\n",
       "      <td>95</td>\n",
       "      <td>ABALDE, ALBERTO</td>\n",
       "      <td>Valencia Basket</td>\n",
       "      <td>23</td>\n",
       "      <td>127</td>\n",
       "      <td>5.52</td>\n",
       "      <td>13.88</td>\n",
       "      <td>365:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2019-20</td>\n",
       "      <td>22</td>\n",
       "      <td>ABASS, AWUDU</td>\n",
       "      <td>Germani Brescia Leonessa</td>\n",
       "      <td>15</td>\n",
       "      <td>194</td>\n",
       "      <td>12.93</td>\n",
       "      <td>19.49</td>\n",
       "      <td>398:07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2002-03</td>\n",
       "      <td>118</td>\n",
       "      <td>ABBIO, ALESSANDRO</td>\n",
       "      <td>Pamesa Valencia</td>\n",
       "      <td>9</td>\n",
       "      <td>88</td>\n",
       "      <td>9.78</td>\n",
       "      <td>16.68</td>\n",
       "      <td>211:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2013-14</td>\n",
       "      <td>342</td>\n",
       "      <td>ABBOTT, TY</td>\n",
       "      <td>Kalev Cramo Tallinn</td>\n",
       "      <td>9</td>\n",
       "      <td>66</td>\n",
       "      <td>7.33</td>\n",
       "      <td>9.66</td>\n",
       "      <td>273: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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3831</th>\n",
       "      <td>2003-04</td>\n",
       "      <td>219</td>\n",
       "      <td>ZUZA, JURICA</td>\n",
       "      <td>Ionikos NF Egnatia Bank</td>\n",
       "      <td>6</td>\n",
       "      <td>60</td>\n",
       "      <td>10.00</td>\n",
       "      <td>18.50</td>\n",
       "      <td>129:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3832</th>\n",
       "      <td>2009-10</td>\n",
       "      <td>265</td>\n",
       "      <td>ZVARYKIN, VICTOR</td>\n",
       "      <td>Unics</td>\n",
       "      <td>7</td>\n",
       "      <td>23</td>\n",
       "      <td>3.29</td>\n",
       "      <td>9.93</td>\n",
       "      <td>92:39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3833</th>\n",
       "      <td>2016-17</td>\n",
       "      <td>230</td>\n",
       "      <td>ZVEREV, NIKITA</td>\n",
       "      <td>Nizhny Novgorod</td>\n",
       "      <td>9</td>\n",
       "      <td>13</td>\n",
       "      <td>1.44</td>\n",
       "      <td>8.49</td>\n",
       "      <td>61:14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3834</th>\n",
       "      <td>2012-13</td>\n",
       "      <td>361</td>\n",
       "      <td>ZVIGURS, IVARS</td>\n",
       "      <td>VEF Riga</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2.00</td>\n",
       "      <td>70.59</td>\n",
       "      <td>1:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3835</th>\n",
       "      <td>2014-15</td>\n",
       "      <td>411</td>\n",
       "      <td>ZWIENER, PHILLIP</td>\n",
       "      <td>EWE Baskets Oldenburg</td>\n",
       "      <td>10</td>\n",
       "      <td>28</td>\n",
       "      <td>2.80</td>\n",
       "      <td>7.51</td>\n",
       "      <td>149:06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3836 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       season  rank             player                      team  games  \\\n",
       "0     2007-08   282      AARTS, MARCEL    EiffelTowers Den Bosch     10   \n",
       "1     2018-19    95    ABALDE, ALBERTO           Valencia Basket     23   \n",
       "2     2019-20    22       ABASS, AWUDU  Germani Brescia Leonessa     15   \n",
       "3     2002-03   118  ABBIO, ALESSANDRO           Pamesa Valencia      9   \n",
       "4     2013-14   342         ABBOTT, TY       Kalev Cramo Tallinn      9   \n",
       "...       ...   ...                ...                       ...    ...   \n",
       "3831  2003-04   219       ZUZA, JURICA   Ionikos NF Egnatia Bank      6   \n",
       "3832  2009-10   265   ZVARYKIN, VICTOR                     Unics      7   \n",
       "3833  2016-17   230     ZVEREV, NIKITA           Nizhny Novgorod      9   \n",
       "3834  2012-13   361     ZVIGURS, IVARS                  VEF Riga      1   \n",
       "3835  2014-15   411   ZWIENER, PHILLIP     EWE Baskets Oldenburg     10   \n",
       "\n",
       "      index  average  per_40min minutes  \n",
       "0        75     7.50      16.81  178:31  \n",
       "1       127     5.52      13.88  365:52  \n",
       "2       194    12.93      19.49  398:07  \n",
       "3        88     9.78      16.68  211:00  \n",
       "4        66     7.33       9.66  273:17  \n",
       "...     ...      ...        ...     ...  \n",
       "3831     60    10.00      18.50  129:45  \n",
       "3832     23     3.29       9.93   92:39  \n",
       "3833     13     1.44       8.49   61:14  \n",
       "3834      2     2.00      70.59    1:08  \n",
       "3835     28     2.80       7.51  149:06  \n",
       "\n",
       "[3836 rows x 9 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3 = df3.drop('Unnamed: 0', axis=1)\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "executed-rendering",
   "metadata": {},
   "outputs": [],
   "source": [
    "new_merged_df = df1.merge(df2[['season', 'player', 'team', 'games','index', 'average', 'per_40min', 'minutes']],'left',on=['player'],suffixes=('', '_euroleague'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "charged-japanese",
   "metadata": {},
   "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>season</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>games</th>\n",
       "      <th>index</th>\n",
       "      <th>average</th>\n",
       "      <th>per_40min</th>\n",
       "      <th>minutes</th>\n",
       "      <th>index1</th>\n",
       "      <th>season_euroleague</th>\n",
       "      <th>team_euroleague</th>\n",
       "      <th>games_euroleague</th>\n",
       "      <th>index_euroleague</th>\n",
       "      <th>average_euroleague</th>\n",
       "      <th>per_40min_euroleague</th>\n",
       "      <th>minutes_euroleague</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-19 KAUNAS</td>\n",
       "      <td>4</td>\n",
       "      <td>ABAD, MAURO</td>\n",
       "      <td>U18 TORRONS VICENS L'HOSPITALET</td>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>18.50</td>\n",
       "      <td>29.37</td>\n",
       "      <td>100:46</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2012-13</td>\n",
       "      <td>11</td>\n",
       "      <td>ABALDE, ALBERTO</td>\n",
       "      <td>IJT CLUB JOVENTUT BADALONA</td>\n",
       "      <td>9</td>\n",
       "      <td>115</td>\n",
       "      <td>12.78</td>\n",
       "      <td>19.82</td>\n",
       "      <td>232:08</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-21</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>29.0</td>\n",
       "      <td>245.0</td>\n",
       "      <td>8.45</td>\n",
       "      <td>16.53</td>\n",
       "      <td>592:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2002-03</td>\n",
       "      <td>47</td>\n",
       "      <td>ABBAD, ROMAIN</td>\n",
       "      <td>U18 ELAN BEARNAIS PAU ORTHEZ</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3.00</td>\n",
       "      <td>4.86</td>\n",
       "      <td>74:00</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2009-10</td>\n",
       "      <td>286</td>\n",
       "      <td>ABIA, LARRY</td>\n",
       "      <td>IJT POWER ELECTRONICS</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1.33</td>\n",
       "      <td>3.73</td>\n",
       "      <td>42:54</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-16 KAUNAS</td>\n",
       "      <td>67</td>\n",
       "      <td>ABRAHA, FEKREMARIAM</td>\n",
       "      <td>U18 PORSCHE BASKETBALL ACADEMY LUDWIGSBURG</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0.67</td>\n",
       "      <td>1.95</td>\n",
       "      <td>40:56</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3959</th>\n",
       "      <td>2020-21 VALENCIA</td>\n",
       "      <td>89</td>\n",
       "      <td>ZULEMIE, NATHAN</td>\n",
       "      <td>U18 Nanterre 92</td>\n",
       "      <td>4</td>\n",
       "      <td>-5</td>\n",
       "      <td>-1.25</td>\n",
       "      <td>-3.02</td>\n",
       "      <td>66:07</td>\n",
       "      <td>3955</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3960</th>\n",
       "      <td>2008-09</td>\n",
       "      <td>222</td>\n",
       "      <td>ZUYKOV, DANYLO</td>\n",
       "      <td>BC KYIV</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.64</td>\n",
       "      <td>121:01</td>\n",
       "      <td>3956</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3961</th>\n",
       "      <td>2011-12</td>\n",
       "      <td>343</td>\n",
       "      <td>ZVEREV, NIKITA</td>\n",
       "      <td>IJT BC KHIMKI MOSCOW REGION</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10:11</td>\n",
       "      <td>3957</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3962</th>\n",
       "      <td>2011-12</td>\n",
       "      <td>39</td>\n",
       "      <td>ZVIGURS, IVARS</td>\n",
       "      <td>IJT VEF RIGA</td>\n",
       "      <td>4</td>\n",
       "      <td>69</td>\n",
       "      <td>17.25</td>\n",
       "      <td>20.97</td>\n",
       "      <td>131:38</td>\n",
       "      <td>3958</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3963</th>\n",
       "      <td>2015-16  BELGRADE</td>\n",
       "      <td>10</td>\n",
       "      <td>ZYLKA, FERDINAND</td>\n",
       "      <td>U18 ALBA BERLIN</td>\n",
       "      <td>4</td>\n",
       "      <td>85</td>\n",
       "      <td>21.25</td>\n",
       "      <td>30.48</td>\n",
       "      <td>111:33</td>\n",
       "      <td>3959</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3964 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 season  rank               player  \\\n",
       "0        2018-19 KAUNAS     4          ABAD, MAURO   \n",
       "1               2012-13    11      ABALDE, ALBERTO   \n",
       "2               2002-03    47        ABBAD, ROMAIN   \n",
       "3               2009-10   286          ABIA, LARRY   \n",
       "4        2015-16 KAUNAS    67  ABRAHA, FEKREMARIAM   \n",
       "...                 ...   ...                  ...   \n",
       "3959   2020-21 VALENCIA    89      ZULEMIE, NATHAN   \n",
       "3960            2008-09   222       ZUYKOV, DANYLO   \n",
       "3961            2011-12   343       ZVEREV, NIKITA   \n",
       "3962            2011-12    39       ZVIGURS, IVARS   \n",
       "3963  2015-16  BELGRADE    10     ZYLKA, FERDINAND   \n",
       "\n",
       "                                            team  games  index  average  \\\n",
       "0                U18 TORRONS VICENS L'HOSPITALET      4     74    18.50   \n",
       "1                     IJT CLUB JOVENTUT BADALONA      9    115    12.78   \n",
       "2                   U18 ELAN BEARNAIS PAU ORTHEZ      3      9     3.00   \n",
       "3                          IJT POWER ELECTRONICS      3      4     1.33   \n",
       "4     U18 PORSCHE BASKETBALL ACADEMY LUDWIGSBURG      3      2     0.67   \n",
       "...                                          ...    ...    ...      ...   \n",
       "3959                             U18 Nanterre 92      4     -5    -1.25   \n",
       "3960                                     BC KYIV      4      8     2.00   \n",
       "3961                 IJT BC KHIMKI MOSCOW REGION      3      0     0.00   \n",
       "3962                                IJT VEF RIGA      4     69    17.25   \n",
       "3963                             U18 ALBA BERLIN      4     85    21.25   \n",
       "\n",
       "      per_40min minutes  index1 season_euroleague team_euroleague  \\\n",
       "0         29.37  100:46       0               NaN             NaN   \n",
       "1         19.82  232:08       1           2020-21     Real Madrid   \n",
       "2          4.86   74:00       2               NaN             NaN   \n",
       "3          3.73   42:54       3               NaN             NaN   \n",
       "4          1.95   40:56       4               NaN             NaN   \n",
       "...         ...     ...     ...               ...             ...   \n",
       "3959      -3.02   66:07    3955               NaN             NaN   \n",
       "3960       2.64  121:01    3956               NaN             NaN   \n",
       "3961       0.00   10:11    3957               NaN             NaN   \n",
       "3962      20.97  131:38    3958               NaN             NaN   \n",
       "3963      30.48  111:33    3959               NaN             NaN   \n",
       "\n",
       "      games_euroleague  index_euroleague  average_euroleague  \\\n",
       "0                  NaN               NaN                 NaN   \n",
       "1                 29.0             245.0                8.45   \n",
       "2                  NaN               NaN                 NaN   \n",
       "3                  NaN               NaN                 NaN   \n",
       "4                  NaN               NaN                 NaN   \n",
       "...                ...               ...                 ...   \n",
       "3959               NaN               NaN                 NaN   \n",
       "3960               NaN               NaN                 NaN   \n",
       "3961               NaN               NaN                 NaN   \n",
       "3962               NaN               NaN                 NaN   \n",
       "3963               NaN               NaN                 NaN   \n",
       "\n",
       "      per_40min_euroleague minutes_euroleague  \n",
       "0                      NaN                NaN  \n",
       "1                    16.53             592:51  \n",
       "2                      NaN                NaN  \n",
       "3                      NaN                NaN  \n",
       "4                      NaN                NaN  \n",
       "...                    ...                ...  \n",
       "3959                   NaN                NaN  \n",
       "3960                   NaN                NaN  \n",
       "3961                   NaN                NaN  \n",
       "3962                   NaN                NaN  \n",
       "3963                   NaN                NaN  \n",
       "\n",
       "[3964 rows x 17 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_merged_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "complimentary-blackjack",
   "metadata": {},
   "outputs": [],
   "source": [
    "df1['equal'] = df1['player'].isin(df2['player'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "equivalent-updating",
   "metadata": {},
   "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>season</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>games</th>\n",
       "      <th>index</th>\n",
       "      <th>average</th>\n",
       "      <th>per_40min</th>\n",
       "      <th>minutes</th>\n",
       "      <th>index1</th>\n",
       "      <th>equal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-19 KAUNAS</td>\n",
       "      <td>4</td>\n",
       "      <td>ABAD, MAURO</td>\n",
       "      <td>U18 TORRONS VICENS L'HOSPITALET</td>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>18.50</td>\n",
       "      <td>29.37</td>\n",
       "      <td>100:46</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2012-13</td>\n",
       "      <td>11</td>\n",
       "      <td>ABALDE, ALBERTO</td>\n",
       "      <td>IJT CLUB JOVENTUT BADALONA</td>\n",
       "      <td>9</td>\n",
       "      <td>115</td>\n",
       "      <td>12.78</td>\n",
       "      <td>19.82</td>\n",
       "      <td>232:08</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2002-03</td>\n",
       "      <td>47</td>\n",
       "      <td>ABBAD, ROMAIN</td>\n",
       "      <td>U18 ELAN BEARNAIS PAU ORTHEZ</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3.00</td>\n",
       "      <td>4.86</td>\n",
       "      <td>74:00</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2009-10</td>\n",
       "      <td>286</td>\n",
       "      <td>ABIA, LARRY</td>\n",
       "      <td>IJT POWER ELECTRONICS</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1.33</td>\n",
       "      <td>3.73</td>\n",
       "      <td>42:54</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-16 KAUNAS</td>\n",
       "      <td>67</td>\n",
       "      <td>ABRAHA, FEKREMARIAM</td>\n",
       "      <td>U18 PORSCHE BASKETBALL ACADEMY LUDWIGSBURG</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0.67</td>\n",
       "      <td>1.95</td>\n",
       "      <td>40:56</td>\n",
       "      <td>4</td>\n",
       "      <td>False</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3955</th>\n",
       "      <td>2020-21 VALENCIA</td>\n",
       "      <td>89</td>\n",
       "      <td>ZULEMIE, NATHAN</td>\n",
       "      <td>U18 Nanterre 92</td>\n",
       "      <td>4</td>\n",
       "      <td>-5</td>\n",
       "      <td>-1.25</td>\n",
       "      <td>-3.02</td>\n",
       "      <td>66:07</td>\n",
       "      <td>3955</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3956</th>\n",
       "      <td>2008-09</td>\n",
       "      <td>222</td>\n",
       "      <td>ZUYKOV, DANYLO</td>\n",
       "      <td>BC KYIV</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.64</td>\n",
       "      <td>121:01</td>\n",
       "      <td>3956</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3957</th>\n",
       "      <td>2011-12</td>\n",
       "      <td>343</td>\n",
       "      <td>ZVEREV, NIKITA</td>\n",
       "      <td>IJT BC KHIMKI MOSCOW REGION</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10:11</td>\n",
       "      <td>3957</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3958</th>\n",
       "      <td>2011-12</td>\n",
       "      <td>39</td>\n",
       "      <td>ZVIGURS, IVARS</td>\n",
       "      <td>IJT VEF RIGA</td>\n",
       "      <td>4</td>\n",
       "      <td>69</td>\n",
       "      <td>17.25</td>\n",
       "      <td>20.97</td>\n",
       "      <td>131:38</td>\n",
       "      <td>3958</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3959</th>\n",
       "      <td>2015-16  BELGRADE</td>\n",
       "      <td>10</td>\n",
       "      <td>ZYLKA, FERDINAND</td>\n",
       "      <td>U18 ALBA BERLIN</td>\n",
       "      <td>4</td>\n",
       "      <td>85</td>\n",
       "      <td>21.25</td>\n",
       "      <td>30.48</td>\n",
       "      <td>111:33</td>\n",
       "      <td>3959</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3960 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 season  rank               player  \\\n",
       "0        2018-19 KAUNAS     4          ABAD, MAURO   \n",
       "1               2012-13    11      ABALDE, ALBERTO   \n",
       "2               2002-03    47        ABBAD, ROMAIN   \n",
       "3               2009-10   286          ABIA, LARRY   \n",
       "4        2015-16 KAUNAS    67  ABRAHA, FEKREMARIAM   \n",
       "...                 ...   ...                  ...   \n",
       "3955   2020-21 VALENCIA    89      ZULEMIE, NATHAN   \n",
       "3956            2008-09   222       ZUYKOV, DANYLO   \n",
       "3957            2011-12   343       ZVEREV, NIKITA   \n",
       "3958            2011-12    39       ZVIGURS, IVARS   \n",
       "3959  2015-16  BELGRADE    10     ZYLKA, FERDINAND   \n",
       "\n",
       "                                            team  games  index  average  \\\n",
       "0                U18 TORRONS VICENS L'HOSPITALET      4     74    18.50   \n",
       "1                     IJT CLUB JOVENTUT BADALONA      9    115    12.78   \n",
       "2                   U18 ELAN BEARNAIS PAU ORTHEZ      3      9     3.00   \n",
       "3                          IJT POWER ELECTRONICS      3      4     1.33   \n",
       "4     U18 PORSCHE BASKETBALL ACADEMY LUDWIGSBURG      3      2     0.67   \n",
       "...                                          ...    ...    ...      ...   \n",
       "3955                             U18 Nanterre 92      4     -5    -1.25   \n",
       "3956                                     BC KYIV      4      8     2.00   \n",
       "3957                 IJT BC KHIMKI MOSCOW REGION      3      0     0.00   \n",
       "3958                                IJT VEF RIGA      4     69    17.25   \n",
       "3959                             U18 ALBA BERLIN      4     85    21.25   \n",
       "\n",
       "      per_40min minutes  index1  equal  \n",
       "0         29.37  100:46       0  False  \n",
       "1         19.82  232:08       1   True  \n",
       "2          4.86   74:00       2  False  \n",
       "3          3.73   42:54       3  False  \n",
       "4          1.95   40:56       4  False  \n",
       "...         ...     ...     ...    ...  \n",
       "3955      -3.02   66:07    3955  False  \n",
       "3956       2.64  121:01    3956  False  \n",
       "3957       0.00   10:11    3957  False  \n",
       "3958      20.97  131:38    3958  False  \n",
       "3959      30.48  111:33    3959  False  \n",
       "\n",
       "[3960 rows x 11 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "loose-error",
   "metadata": {},
   "outputs": [],
   "source": [
    "new_merged_df['equal'] = new_merged_df['player'].isin(df1['player'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "nominated-brooklyn",
   "metadata": {},
   "outputs": [],
   "source": [
    "new_merged_df.to_csv('whatwrong.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "weekly-consolidation",
   "metadata": {},
   "outputs": [],
   "source": [
    "testes= pd.read_csv('whatwrong.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "peripheral-adapter",
   "metadata": {},
   "outputs": [],
   "source": [
    "org = new_merged_df.sort_values(by=['minutes_euroleague'], ascending=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "upper-peninsula",
   "metadata": {},
   "outputs": [],
   "source": [
    "out_dup = org.drop_duplicates(subset=['season', 'player', 'team'], keep = 'last')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "medieval-experience",
   "metadata": {},
   "outputs": [],
   "source": [
    "aa = out_dup.sort_values(by=['player'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "presidential-specialist",
   "metadata": {},
   "outputs": [],
   "source": [
    "aa.to_csv('abc.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "velvet-plasma",
   "metadata": {},
   "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>season</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>games</th>\n",
       "      <th>index</th>\n",
       "      <th>average</th>\n",
       "      <th>per_40min</th>\n",
       "      <th>minutes</th>\n",
       "      <th>index1</th>\n",
       "      <th>season_euroleague</th>\n",
       "      <th>team_euroleague</th>\n",
       "      <th>games_euroleague</th>\n",
       "      <th>index_euroleague</th>\n",
       "      <th>average_euroleague</th>\n",
       "      <th>per_40min_euroleague</th>\n",
       "      <th>minutes_euroleague</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-19 KAUNAS</td>\n",
       "      <td>4</td>\n",
       "      <td>ABAD, MAURO</td>\n",
       "      <td>U18 TORRONS VICENS L'HOSPITALET</td>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>18.50</td>\n",
       "      <td>29.37</td>\n",
       "      <td>100:46</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2012-13</td>\n",
       "      <td>11</td>\n",
       "      <td>ABALDE, ALBERTO</td>\n",
       "      <td>IJT CLUB JOVENTUT BADALONA</td>\n",
       "      <td>9</td>\n",
       "      <td>115</td>\n",
       "      <td>12.78</td>\n",
       "      <td>19.82</td>\n",
       "      <td>232:08</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-21</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>29.0</td>\n",
       "      <td>245.0</td>\n",
       "      <td>8.45</td>\n",
       "      <td>16.53</td>\n",
       "      <td>592:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2002-03</td>\n",
       "      <td>47</td>\n",
       "      <td>ABBAD, ROMAIN</td>\n",
       "      <td>U18 ELAN BEARNAIS PAU ORTHEZ</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3.00</td>\n",
       "      <td>4.86</td>\n",
       "      <td>74:00</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2009-10</td>\n",
       "      <td>286</td>\n",
       "      <td>ABIA, LARRY</td>\n",
       "      <td>IJT POWER ELECTRONICS</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1.33</td>\n",
       "      <td>3.73</td>\n",
       "      <td>42:54</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-16 KAUNAS</td>\n",
       "      <td>67</td>\n",
       "      <td>ABRAHA, FEKREMARIAM</td>\n",
       "      <td>U18 PORSCHE BASKETBALL ACADEMY LUDWIGSBURG</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0.67</td>\n",
       "      <td>1.95</td>\n",
       "      <td>40:56</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3959</th>\n",
       "      <td>2020-21 VALENCIA</td>\n",
       "      <td>89</td>\n",
       "      <td>ZULEMIE, NATHAN</td>\n",
       "      <td>U18 Nanterre 92</td>\n",
       "      <td>4</td>\n",
       "      <td>-5</td>\n",
       "      <td>-1.25</td>\n",
       "      <td>-3.02</td>\n",
       "      <td>66:07</td>\n",
       "      <td>3955</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3960</th>\n",
       "      <td>2008-09</td>\n",
       "      <td>222</td>\n",
       "      <td>ZUYKOV, DANYLO</td>\n",
       "      <td>BC KYIV</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.64</td>\n",
       "      <td>121:01</td>\n",
       "      <td>3956</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3961</th>\n",
       "      <td>2011-12</td>\n",
       "      <td>343</td>\n",
       "      <td>ZVEREV, NIKITA</td>\n",
       "      <td>IJT BC KHIMKI MOSCOW REGION</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10:11</td>\n",
       "      <td>3957</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3962</th>\n",
       "      <td>2011-12</td>\n",
       "      <td>39</td>\n",
       "      <td>ZVIGURS, IVARS</td>\n",
       "      <td>IJT VEF RIGA</td>\n",
       "      <td>4</td>\n",
       "      <td>69</td>\n",
       "      <td>17.25</td>\n",
       "      <td>20.97</td>\n",
       "      <td>131:38</td>\n",
       "      <td>3958</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3963</th>\n",
       "      <td>2015-16  BELGRADE</td>\n",
       "      <td>10</td>\n",
       "      <td>ZYLKA, FERDINAND</td>\n",
       "      <td>U18 ALBA BERLIN</td>\n",
       "      <td>4</td>\n",
       "      <td>85</td>\n",
       "      <td>21.25</td>\n",
       "      <td>30.48</td>\n",
       "      <td>111:33</td>\n",
       "      <td>3959</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3960 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 season  rank               player  \\\n",
       "0        2018-19 KAUNAS     4          ABAD, MAURO   \n",
       "1               2012-13    11      ABALDE, ALBERTO   \n",
       "2               2002-03    47        ABBAD, ROMAIN   \n",
       "3               2009-10   286          ABIA, LARRY   \n",
       "4        2015-16 KAUNAS    67  ABRAHA, FEKREMARIAM   \n",
       "...                 ...   ...                  ...   \n",
       "3959   2020-21 VALENCIA    89      ZULEMIE, NATHAN   \n",
       "3960            2008-09   222       ZUYKOV, DANYLO   \n",
       "3961            2011-12   343       ZVEREV, NIKITA   \n",
       "3962            2011-12    39       ZVIGURS, IVARS   \n",
       "3963  2015-16  BELGRADE    10     ZYLKA, FERDINAND   \n",
       "\n",
       "                                            team  games  index  average  \\\n",
       "0                U18 TORRONS VICENS L'HOSPITALET      4     74    18.50   \n",
       "1                     IJT CLUB JOVENTUT BADALONA      9    115    12.78   \n",
       "2                   U18 ELAN BEARNAIS PAU ORTHEZ      3      9     3.00   \n",
       "3                          IJT POWER ELECTRONICS      3      4     1.33   \n",
       "4     U18 PORSCHE BASKETBALL ACADEMY LUDWIGSBURG      3      2     0.67   \n",
       "...                                          ...    ...    ...      ...   \n",
       "3959                             U18 Nanterre 92      4     -5    -1.25   \n",
       "3960                                     BC KYIV      4      8     2.00   \n",
       "3961                 IJT BC KHIMKI MOSCOW REGION      3      0     0.00   \n",
       "3962                                IJT VEF RIGA      4     69    17.25   \n",
       "3963                             U18 ALBA BERLIN      4     85    21.25   \n",
       "\n",
       "      per_40min minutes  index1 season_euroleague team_euroleague  \\\n",
       "0         29.37  100:46       0               NaN             NaN   \n",
       "1         19.82  232:08       1           2020-21     Real Madrid   \n",
       "2          4.86   74:00       2               NaN             NaN   \n",
       "3          3.73   42:54       3               NaN             NaN   \n",
       "4          1.95   40:56       4               NaN             NaN   \n",
       "...         ...     ...     ...               ...             ...   \n",
       "3959      -3.02   66:07    3955               NaN             NaN   \n",
       "3960       2.64  121:01    3956               NaN             NaN   \n",
       "3961       0.00   10:11    3957               NaN             NaN   \n",
       "3962      20.97  131:38    3958               NaN             NaN   \n",
       "3963      30.48  111:33    3959               NaN             NaN   \n",
       "\n",
       "      games_euroleague  index_euroleague  average_euroleague  \\\n",
       "0                  NaN               NaN                 NaN   \n",
       "1                 29.0             245.0                8.45   \n",
       "2                  NaN               NaN                 NaN   \n",
       "3                  NaN               NaN                 NaN   \n",
       "4                  NaN               NaN                 NaN   \n",
       "...                ...               ...                 ...   \n",
       "3959               NaN               NaN                 NaN   \n",
       "3960               NaN               NaN                 NaN   \n",
       "3961               NaN               NaN                 NaN   \n",
       "3962               NaN               NaN                 NaN   \n",
       "3963               NaN               NaN                 NaN   \n",
       "\n",
       "      per_40min_euroleague minutes_euroleague  \n",
       "0                      NaN                NaN  \n",
       "1                    16.53             592:51  \n",
       "2                      NaN                NaN  \n",
       "3                      NaN                NaN  \n",
       "4                      NaN                NaN  \n",
       "...                    ...                ...  \n",
       "3959                   NaN                NaN  \n",
       "3960                   NaN                NaN  \n",
       "3961                   NaN                NaN  \n",
       "3962                   NaN                NaN  \n",
       "3963                   NaN                NaN  \n",
       "\n",
       "[3960 rows x 17 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "spanish-hungarian",
   "metadata": {},
   "outputs": [],
   "source": [
    "plus_eurocup = aa.merge(df3[['season', 'player', 'team', 'games','index', 'average', 'per_40min', 'minutes']],'left',on=['player'],suffixes=('', '_eurocup'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "structured-washer",
   "metadata": {},
   "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>season</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>games</th>\n",
       "      <th>index</th>\n",
       "      <th>average</th>\n",
       "      <th>per_40min</th>\n",
       "      <th>minutes</th>\n",
       "      <th>index1</th>\n",
       "      <th>...</th>\n",
       "      <th>average_euroleague</th>\n",
       "      <th>per_40min_euroleague</th>\n",
       "      <th>minutes_euroleague</th>\n",
       "      <th>season_eurocup</th>\n",
       "      <th>team_eurocup</th>\n",
       "      <th>games_eurocup</th>\n",
       "      <th>index_eurocup</th>\n",
       "      <th>average_eurocup</th>\n",
       "      <th>per_40min_eurocup</th>\n",
       "      <th>minutes_eurocup</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-19 KAUNAS</td>\n",
       "      <td>4</td>\n",
       "      <td>ABAD, MAURO</td>\n",
       "      <td>U18 TORRONS VICENS L'HOSPITALET</td>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>18.50</td>\n",
       "      <td>29.37</td>\n",
       "      <td>100:46</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2012-13</td>\n",
       "      <td>11</td>\n",
       "      <td>ABALDE, ALBERTO</td>\n",
       "      <td>IJT CLUB JOVENTUT BADALONA</td>\n",
       "      <td>9</td>\n",
       "      <td>115</td>\n",
       "      <td>12.78</td>\n",
       "      <td>19.82</td>\n",
       "      <td>232:08</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>8.45</td>\n",
       "      <td>16.53</td>\n",
       "      <td>592:51</td>\n",
       "      <td>2018-19</td>\n",
       "      <td>Valencia Basket</td>\n",
       "      <td>23.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>5.52</td>\n",
       "      <td>13.88</td>\n",
       "      <td>365:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2002-03</td>\n",
       "      <td>47</td>\n",
       "      <td>ABBAD, ROMAIN</td>\n",
       "      <td>U18 ELAN BEARNAIS PAU ORTHEZ</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3.00</td>\n",
       "      <td>4.86</td>\n",
       "      <td>74:00</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2009-10</td>\n",
       "      <td>286</td>\n",
       "      <td>ABIA, LARRY</td>\n",
       "      <td>IJT POWER ELECTRONICS</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1.33</td>\n",
       "      <td>3.73</td>\n",
       "      <td>42:54</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-12</td>\n",
       "      <td>Valencia Basket</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.50</td>\n",
       "      <td>5.18</td>\n",
       "      <td>46:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-16 KAUNAS</td>\n",
       "      <td>67</td>\n",
       "      <td>ABRAHA, FEKREMARIAM</td>\n",
       "      <td>U18 PORSCHE BASKETBALL ACADEMY LUDWIGSBURG</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0.67</td>\n",
       "      <td>1.95</td>\n",
       "      <td>40:56</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3955</th>\n",
       "      <td>2020-21 VALENCIA</td>\n",
       "      <td>89</td>\n",
       "      <td>ZULEMIE, NATHAN</td>\n",
       "      <td>U18 Nanterre 92</td>\n",
       "      <td>4</td>\n",
       "      <td>-5</td>\n",
       "      <td>-1.25</td>\n",
       "      <td>-3.02</td>\n",
       "      <td>66:07</td>\n",
       "      <td>3955</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3956</th>\n",
       "      <td>2008-09</td>\n",
       "      <td>222</td>\n",
       "      <td>ZUYKOV, DANYLO</td>\n",
       "      <td>BC KYIV</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.64</td>\n",
       "      <td>121:01</td>\n",
       "      <td>3956</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3957</th>\n",
       "      <td>2011-12</td>\n",
       "      <td>343</td>\n",
       "      <td>ZVEREV, NIKITA</td>\n",
       "      <td>IJT BC KHIMKI MOSCOW REGION</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10:11</td>\n",
       "      <td>3957</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>Nizhny Novgorod</td>\n",
       "      <td>9.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.44</td>\n",
       "      <td>8.49</td>\n",
       "      <td>61:14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3958</th>\n",
       "      <td>2011-12</td>\n",
       "      <td>39</td>\n",
       "      <td>ZVIGURS, IVARS</td>\n",
       "      <td>IJT VEF RIGA</td>\n",
       "      <td>4</td>\n",
       "      <td>69</td>\n",
       "      <td>17.25</td>\n",
       "      <td>20.97</td>\n",
       "      <td>131:38</td>\n",
       "      <td>3958</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-13</td>\n",
       "      <td>VEF Riga</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>70.59</td>\n",
       "      <td>1:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3959</th>\n",
       "      <td>2015-16  BELGRADE</td>\n",
       "      <td>10</td>\n",
       "      <td>ZYLKA, FERDINAND</td>\n",
       "      <td>U18 ALBA BERLIN</td>\n",
       "      <td>4</td>\n",
       "      <td>85</td>\n",
       "      <td>21.25</td>\n",
       "      <td>30.48</td>\n",
       "      <td>111:33</td>\n",
       "      <td>3959</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3960 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 season  rank               player  \\\n",
       "0        2018-19 KAUNAS     4          ABAD, MAURO   \n",
       "1               2012-13    11      ABALDE, ALBERTO   \n",
       "2               2002-03    47        ABBAD, ROMAIN   \n",
       "3               2009-10   286          ABIA, LARRY   \n",
       "4        2015-16 KAUNAS    67  ABRAHA, FEKREMARIAM   \n",
       "...                 ...   ...                  ...   \n",
       "3955   2020-21 VALENCIA    89      ZULEMIE, NATHAN   \n",
       "3956            2008-09   222       ZUYKOV, DANYLO   \n",
       "3957            2011-12   343       ZVEREV, NIKITA   \n",
       "3958            2011-12    39       ZVIGURS, IVARS   \n",
       "3959  2015-16  BELGRADE    10     ZYLKA, FERDINAND   \n",
       "\n",
       "                                            team  games  index  average  \\\n",
       "0                U18 TORRONS VICENS L'HOSPITALET      4     74    18.50   \n",
       "1                     IJT CLUB JOVENTUT BADALONA      9    115    12.78   \n",
       "2                   U18 ELAN BEARNAIS PAU ORTHEZ      3      9     3.00   \n",
       "3                          IJT POWER ELECTRONICS      3      4     1.33   \n",
       "4     U18 PORSCHE BASKETBALL ACADEMY LUDWIGSBURG      3      2     0.67   \n",
       "...                                          ...    ...    ...      ...   \n",
       "3955                             U18 Nanterre 92      4     -5    -1.25   \n",
       "3956                                     BC KYIV      4      8     2.00   \n",
       "3957                 IJT BC KHIMKI MOSCOW REGION      3      0     0.00   \n",
       "3958                                IJT VEF RIGA      4     69    17.25   \n",
       "3959                             U18 ALBA BERLIN      4     85    21.25   \n",
       "\n",
       "      per_40min minutes  index1  ... average_euroleague per_40min_euroleague  \\\n",
       "0         29.37  100:46       0  ...                NaN                  NaN   \n",
       "1         19.82  232:08       1  ...               8.45                16.53   \n",
       "2          4.86   74:00       2  ...                NaN                  NaN   \n",
       "3          3.73   42:54       3  ...                NaN                  NaN   \n",
       "4          1.95   40:56       4  ...                NaN                  NaN   \n",
       "...         ...     ...     ...  ...                ...                  ...   \n",
       "3955      -3.02   66:07    3955  ...                NaN                  NaN   \n",
       "3956       2.64  121:01    3956  ...                NaN                  NaN   \n",
       "3957       0.00   10:11    3957  ...                NaN                  NaN   \n",
       "3958      20.97  131:38    3958  ...                NaN                  NaN   \n",
       "3959      30.48  111:33    3959  ...                NaN                  NaN   \n",
       "\n",
       "      minutes_euroleague  season_eurocup     team_eurocup  games_eurocup  \\\n",
       "0                    NaN             NaN              NaN            NaN   \n",
       "1                 592:51         2018-19  Valencia Basket           23.0   \n",
       "2                    NaN             NaN              NaN            NaN   \n",
       "3                    NaN         2011-12  Valencia Basket            4.0   \n",
       "4                    NaN             NaN              NaN            NaN   \n",
       "...                  ...             ...              ...            ...   \n",
       "3955                 NaN             NaN              NaN            NaN   \n",
       "3956                 NaN             NaN              NaN            NaN   \n",
       "3957                 NaN         2016-17  Nizhny Novgorod            9.0   \n",
       "3958                 NaN         2012-13         VEF Riga            1.0   \n",
       "3959                 NaN             NaN              NaN            NaN   \n",
       "\n",
       "     index_eurocup average_eurocup per_40min_eurocup  minutes_eurocup  \n",
       "0              NaN             NaN               NaN              NaN  \n",
       "1            127.0            5.52             13.88           365:52  \n",
       "2              NaN             NaN               NaN              NaN  \n",
       "3              6.0            1.50              5.18            46:19  \n",
       "4              NaN             NaN               NaN              NaN  \n",
       "...            ...             ...               ...              ...  \n",
       "3955           NaN             NaN               NaN              NaN  \n",
       "3956           NaN             NaN               NaN              NaN  \n",
       "3957          13.0            1.44              8.49            61:14  \n",
       "3958           2.0            2.00             70.59             1:08  \n",
       "3959           NaN             NaN               NaN              NaN  \n",
       "\n",
       "[3960 rows x 24 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "plus_eurocup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "acceptable-tattoo",
   "metadata": {},
   "outputs": [],
   "source": [
    "def f(row):\n",
    "    if pd.isna(row['games_euroleague']) == False:\n",
    "        val = 2\n",
    "    elif pd.isna(row['games_eurocup']) == False:\n",
    "        val = 1\n",
    "    else:\n",
    "        val = 0\n",
    "    return val"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "center-gauge",
   "metadata": {},
   "outputs": [],
   "source": [
    "base_mod = plus_eurocup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "reflected-alloy",
   "metadata": {},
   "outputs": [],
   "source": [
    "base_mod['max_level'] = base_mod.apply(f, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "becoming-netscape",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       4.0\n",
       "1       9.0\n",
       "2       3.0\n",
       "3       3.0\n",
       "4       3.0\n",
       "       ... \n",
       "3955    4.0\n",
       "3956    4.0\n",
       "3957    3.0\n",
       "3958    4.0\n",
       "3959    4.0\n",
       "Name: games, Length: 3960, dtype: float64"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "xd['games'].astype('float64')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "id": "utility-receipt",
   "metadata": {},
   "outputs": [],
   "source": [
    "base_mod['games_eurocup'] = base_mod['games_eurocup'].astype('float64')\n",
    "base_mod['games_euroleague'] = base_mod['games_euroleague'].astype('float64')\n",
    "base_mod['games'] = base_mod['games'].astype('float64')\n",
    "base_mod['team_eurocup'] = base_mod['team_eurocup'].fillna('')\n",
    "base_mod['team_euroleague'] = base_mod['team_euroleague'].fillna('')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "loaded-locator",
   "metadata": {},
   "outputs": [],
   "source": [
    "base_mod.to_csv('base_28052021.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "id": "foreign-concrete",
   "metadata": {},
   "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>season</th>\n",
       "      <th>rank</th>\n",
       "      <th>player</th>\n",
       "      <th>team</th>\n",
       "      <th>games</th>\n",
       "      <th>index</th>\n",
       "      <th>average</th>\n",
       "      <th>per_40min</th>\n",
       "      <th>minutes</th>\n",
       "      <th>index1</th>\n",
       "      <th>...</th>\n",
       "      <th>average_euroleague</th>\n",
       "      <th>per_40min_euroleague</th>\n",
       "      <th>minutes_euroleague</th>\n",
       "      <th>season_eurocup</th>\n",
       "      <th>team_eurocup</th>\n",
       "      <th>games_eurocup</th>\n",
       "      <th>index_eurocup</th>\n",
       "      <th>average_eurocup</th>\n",
       "      <th>per_40min_eurocup</th>\n",
       "      <th>minutes_eurocup</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-19 KAUNAS</td>\n",
       "      <td>4</td>\n",
       "      <td>ABAD, MAURO</td>\n",
       "      <td>U18 TORRONS VICENS L'HOSPITALET</td>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>18.50</td>\n",
       "      <td>29.37</td>\n",
       "      <td>100:46</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2012-13</td>\n",
       "      <td>11</td>\n",
       "      <td>ABALDE, ALBERTO</td>\n",
       "      <td>IJT CLUB JOVENTUT BADALONA</td>\n",
       "      <td>9</td>\n",
       "      <td>115</td>\n",
       "      <td>12.78</td>\n",
       "      <td>19.82</td>\n",
       "      <td>232:08</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>8.45</td>\n",
       "      <td>16.53</td>\n",
       "      <td>592:51</td>\n",
       "      <td>2018-19</td>\n",
       "      <td>Valencia Basket</td>\n",
       "      <td>23.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>5.52</td>\n",
       "      <td>13.88</td>\n",
       "      <td>365:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2002-03</td>\n",
       "      <td>47</td>\n",
       "      <td>ABBAD, ROMAIN</td>\n",
       "      <td>U18 ELAN BEARNAIS PAU ORTHEZ</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>3.00</td>\n",
       "      <td>4.86</td>\n",
       "      <td>74:00</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2009-10</td>\n",
       "      <td>286</td>\n",
       "      <td>ABIA, LARRY</td>\n",
       "      <td>IJT POWER ELECTRONICS</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1.33</td>\n",
       "      <td>3.73</td>\n",
       "      <td>42:54</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-12</td>\n",
       "      <td>Valencia Basket</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.50</td>\n",
       "      <td>5.18</td>\n",
       "      <td>46:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2015-16 KAUNAS</td>\n",
       "      <td>67</td>\n",
       "      <td>ABRAHA, FEKREMARIAM</td>\n",
       "      <td>U18 PORSCHE BASKETBALL ACADEMY LUDWIGSBURG</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0.67</td>\n",
       "      <td>1.95</td>\n",
       "      <td>40:56</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3955</th>\n",
       "      <td>2020-21 VALENCIA</td>\n",
       "      <td>89</td>\n",
       "      <td>ZULEMIE, NATHAN</td>\n",
       "      <td>U18 Nanterre 92</td>\n",
       "      <td>4</td>\n",
       "      <td>-5</td>\n",
       "      <td>-1.25</td>\n",
       "      <td>-3.02</td>\n",
       "      <td>66:07</td>\n",
       "      <td>3955</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3956</th>\n",
       "      <td>2008-09</td>\n",
       "      <td>222</td>\n",
       "      <td>ZUYKOV, DANYLO</td>\n",
       "      <td>BC KYIV</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.64</td>\n",
       "      <td>121:01</td>\n",
       "      <td>3956</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3957</th>\n",
       "      <td>2011-12</td>\n",
       "      <td>343</td>\n",
       "      <td>ZVEREV, NIKITA</td>\n",
       "      <td>IJT BC KHIMKI MOSCOW REGION</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10:11</td>\n",
       "      <td>3957</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>Nizhny Novgorod</td>\n",
       "      <td>9.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.44</td>\n",
       "      <td>8.49</td>\n",
       "      <td>61:14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3958</th>\n",
       "      <td>2011-12</td>\n",
       "      <td>39</td>\n",
       "      <td>ZVIGURS, IVARS</td>\n",
       "      <td>IJT VEF RIGA</td>\n",
       "      <td>4</td>\n",
       "      <td>69</td>\n",
       "      <td>17.25</td>\n",
       "      <td>20.97</td>\n",
       "      <td>131:38</td>\n",
       "      <td>3958</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2012-13</td>\n",
       "      <td>VEF Riga</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>70.59</td>\n",
       "      <td>1:08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3959</th>\n",
       "      <td>2015-16  BELGRADE</td>\n",
       "      <td>10</td>\n",
       "      <td>ZYLKA, FERDINAND</td>\n",
       "      <td>U18 ALBA BERLIN</td>\n",
       "      <td>4</td>\n",
       "      <td>85</td>\n",
       "      <td>21.25</td>\n",
       "      <td>30.48</td>\n",
       "      <td>111:33</td>\n",
       "      <td>3959</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3960 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 season  rank               player  \\\n",
       "0        2018-19 KAUNAS     4          ABAD, MAURO   \n",
       "1               2012-13    11      ABALDE, ALBERTO   \n",
       "2               2002-03    47        ABBAD, ROMAIN   \n",
       "3               2009-10   286          ABIA, LARRY   \n",
       "4        2015-16 KAUNAS    67  ABRAHA, FEKREMARIAM   \n",
       "...                 ...   ...                  ...   \n",
       "3955   2020-21 VALENCIA    89      ZULEMIE, NATHAN   \n",
       "3956            2008-09   222       ZUYKOV, DANYLO   \n",
       "3957            2011-12   343       ZVEREV, NIKITA   \n",
       "3958            2011-12    39       ZVIGURS, IVARS   \n",
       "3959  2015-16  BELGRADE    10     ZYLKA, FERDINAND   \n",
       "\n",
       "                                            team  games  index  average  \\\n",
       "0                U18 TORRONS VICENS L'HOSPITALET      4     74    18.50   \n",
       "1                     IJT CLUB JOVENTUT BADALONA      9    115    12.78   \n",
       "2                   U18 ELAN BEARNAIS PAU ORTHEZ      3      9     3.00   \n",
       "3                          IJT POWER ELECTRONICS      3      4     1.33   \n",
       "4     U18 PORSCHE BASKETBALL ACADEMY LUDWIGSBURG      3      2     0.67   \n",
       "...                                          ...    ...    ...      ...   \n",
       "3955                             U18 Nanterre 92      4     -5    -1.25   \n",
       "3956                                     BC KYIV      4      8     2.00   \n",
       "3957                 IJT BC KHIMKI MOSCOW REGION      3      0     0.00   \n",
       "3958                                IJT VEF RIGA      4     69    17.25   \n",
       "3959                             U18 ALBA BERLIN      4     85    21.25   \n",
       "\n",
       "      per_40min minutes  index1  ... average_euroleague per_40min_euroleague  \\\n",
       "0         29.37  100:46       0  ...                NaN                  NaN   \n",
       "1         19.82  232:08       1  ...               8.45                16.53   \n",
       "2          4.86   74:00       2  ...                NaN                  NaN   \n",
       "3          3.73   42:54       3  ...                NaN                  NaN   \n",
       "4          1.95   40:56       4  ...                NaN                  NaN   \n",
       "...         ...     ...     ...  ...                ...                  ...   \n",
       "3955      -3.02   66:07    3955  ...                NaN                  NaN   \n",
       "3956       2.64  121:01    3956  ...                NaN                  NaN   \n",
       "3957       0.00   10:11    3957  ...                NaN                  NaN   \n",
       "3958      20.97  131:38    3958  ...                NaN                  NaN   \n",
       "3959      30.48  111:33    3959  ...                NaN                  NaN   \n",
       "\n",
       "      minutes_euroleague  season_eurocup     team_eurocup  games_eurocup  \\\n",
       "0                    NaN             NaN              NaN            NaN   \n",
       "1                 592:51         2018-19  Valencia Basket           23.0   \n",
       "2                    NaN             NaN              NaN            NaN   \n",
       "3                    NaN         2011-12  Valencia Basket            4.0   \n",
       "4                    NaN             NaN              NaN            NaN   \n",
       "...                  ...             ...              ...            ...   \n",
       "3955                 NaN             NaN              NaN            NaN   \n",
       "3956                 NaN             NaN              NaN            NaN   \n",
       "3957                 NaN         2016-17  Nizhny Novgorod            9.0   \n",
       "3958                 NaN         2012-13         VEF Riga            1.0   \n",
       "3959                 NaN             NaN              NaN            NaN   \n",
       "\n",
       "     index_eurocup average_eurocup per_40min_eurocup  minutes_eurocup  \n",
       "0              NaN             NaN               NaN              NaN  \n",
       "1            127.0            5.52             13.88           365:52  \n",
       "2              NaN             NaN               NaN              NaN  \n",
       "3              6.0            1.50              5.18            46:19  \n",
       "4              NaN             NaN               NaN              NaN  \n",
       "...            ...             ...               ...              ...  \n",
       "3955           NaN             NaN               NaN              NaN  \n",
       "3956           NaN             NaN               NaN              NaN  \n",
       "3957          13.0            1.44              8.49            61:14  \n",
       "3958           2.0            2.00             70.59             1:08  \n",
       "3959           NaN             NaN               NaN              NaN  \n",
       "\n",
       "[3960 rows x 24 columns]"
      ]
     },
     "execution_count": 125,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "plus_eurocup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "institutional-conversation",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}