1. Statistical Learning/Project-1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "laliga=pd.read_csv('Laliga.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": false
   },
   "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>Unnamed: 0</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>Unnamed: 10</th>\n",
       "      <th>Unnamed: 11</th>\n",
       "      <th>Unnamed: 12</th>\n",
       "      <th>Unnamed: 13</th>\n",
       "      <th>Unnamed: 14</th>\n",
       "      <th>Unnamed: 15</th>\n",
       "      <th>Unnamed: 16</th>\n",
       "      <th>Unnamed: 17</th>\n",
       "      <th>Unnamed: 18</th>\n",
       "      <th>Unnamed: 19</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Pos</td>\n",
       "      <td>Team</td>\n",
       "      <td>Seasons</td>\n",
       "      <td>Points</td>\n",
       "      <td>GamesPlayed</td>\n",
       "      <td>GamesWon</td>\n",
       "      <td>GamesDrawn</td>\n",
       "      <td>GamesLost</td>\n",
       "      <td>GoalsFor</td>\n",
       "      <td>GoalsAgainst</td>\n",
       "      <td>Champion</td>\n",
       "      <td>Runner-up</td>\n",
       "      <td>Third</td>\n",
       "      <td>Fourth</td>\n",
       "      <td>Fifth</td>\n",
       "      <td>Sixth</td>\n",
       "      <td>T</td>\n",
       "      <td>Debut</td>\n",
       "      <td>Since/LastApp</td>\n",
       "      <td>BestPosition</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>86</td>\n",
       "      <td>4385</td>\n",
       "      <td>2762</td>\n",
       "      <td>1647</td>\n",
       "      <td>552</td>\n",
       "      <td>563</td>\n",
       "      <td>5947</td>\n",
       "      <td>3140</td>\n",
       "      <td>33</td>\n",
       "      <td>23</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>79</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>86</td>\n",
       "      <td>4262</td>\n",
       "      <td>2762</td>\n",
       "      <td>1581</td>\n",
       "      <td>573</td>\n",
       "      <td>608</td>\n",
       "      <td>5900</td>\n",
       "      <td>3114</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>83</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Atletico Madrid</td>\n",
       "      <td>80</td>\n",
       "      <td>3442</td>\n",
       "      <td>2614</td>\n",
       "      <td>1241</td>\n",
       "      <td>598</td>\n",
       "      <td>775</td>\n",
       "      <td>4534</td>\n",
       "      <td>3309</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>56</td>\n",
       "      <td>1929</td>\n",
       "      <td>2002-03</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>82</td>\n",
       "      <td>3386</td>\n",
       "      <td>2664</td>\n",
       "      <td>1187</td>\n",
       "      <td>616</td>\n",
       "      <td>861</td>\n",
       "      <td>4398</td>\n",
       "      <td>3469</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>50</td>\n",
       "      <td>1931-32</td>\n",
       "      <td>1987-88</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Unnamed: 0       Unnamed: 1 Unnamed: 2 Unnamed: 3   Unnamed: 4 Unnamed: 5  \\\n",
       "0        Pos             Team    Seasons     Points  GamesPlayed   GamesWon   \n",
       "1          1      Real Madrid         86       4385         2762       1647   \n",
       "2          2        Barcelona         86       4262         2762       1581   \n",
       "3          3  Atletico Madrid         80       3442         2614       1241   \n",
       "4          4         Valencia         82       3386         2664       1187   \n",
       "\n",
       "   Unnamed: 6 Unnamed: 7 Unnamed: 8    Unnamed: 9 Unnamed: 10 Unnamed: 11  \\\n",
       "0  GamesDrawn  GamesLost   GoalsFor  GoalsAgainst    Champion   Runner-up   \n",
       "1         552        563       5947          3140          33          23   \n",
       "2         573        608       5900          3114          25          25   \n",
       "3         598        775       4534          3309          10           8   \n",
       "4         616        861       4398          3469           6           6   \n",
       "\n",
       "  Unnamed: 12 Unnamed: 13 Unnamed: 14 Unnamed: 15 Unnamed: 16 Unnamed: 17  \\\n",
       "0       Third      Fourth       Fifth       Sixth           T       Debut   \n",
       "1           8           8           3           4          79        1929   \n",
       "2          12          12           4           6          83        1929   \n",
       "3          16           9           7           6          56        1929   \n",
       "4          10          11          10           7          50     1931-32   \n",
       "\n",
       "     Unnamed: 18   Unnamed: 19  \n",
       "0  Since/LastApp  BestPosition  \n",
       "1           1929             1  \n",
       "2           1929             1  \n",
       "3        2002-03             1  \n",
       "4        1987-88             1  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "laliga.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "laliga.rename(columns=laliga.iloc[0], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "laliga.drop(0,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>Pos</th>\n",
       "      <th>Team</th>\n",
       "      <th>Seasons</th>\n",
       "      <th>Points</th>\n",
       "      <th>GamesPlayed</th>\n",
       "      <th>GamesWon</th>\n",
       "      <th>GamesDrawn</th>\n",
       "      <th>GamesLost</th>\n",
       "      <th>GoalsFor</th>\n",
       "      <th>GoalsAgainst</th>\n",
       "      <th>Champion</th>\n",
       "      <th>Runner-up</th>\n",
       "      <th>Third</th>\n",
       "      <th>Fourth</th>\n",
       "      <th>Fifth</th>\n",
       "      <th>Sixth</th>\n",
       "      <th>T</th>\n",
       "      <th>Debut</th>\n",
       "      <th>Since/LastApp</th>\n",
       "      <th>BestPosition</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>86</td>\n",
       "      <td>4385</td>\n",
       "      <td>2762</td>\n",
       "      <td>1647</td>\n",
       "      <td>552</td>\n",
       "      <td>563</td>\n",
       "      <td>5947</td>\n",
       "      <td>3140</td>\n",
       "      <td>33</td>\n",
       "      <td>23</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>79</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>86</td>\n",
       "      <td>4262</td>\n",
       "      <td>2762</td>\n",
       "      <td>1581</td>\n",
       "      <td>573</td>\n",
       "      <td>608</td>\n",
       "      <td>5900</td>\n",
       "      <td>3114</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>83</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Atletico Madrid</td>\n",
       "      <td>80</td>\n",
       "      <td>3442</td>\n",
       "      <td>2614</td>\n",
       "      <td>1241</td>\n",
       "      <td>598</td>\n",
       "      <td>775</td>\n",
       "      <td>4534</td>\n",
       "      <td>3309</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>56</td>\n",
       "      <td>1929</td>\n",
       "      <td>2002-03</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>82</td>\n",
       "      <td>3386</td>\n",
       "      <td>2664</td>\n",
       "      <td>1187</td>\n",
       "      <td>616</td>\n",
       "      <td>861</td>\n",
       "      <td>4398</td>\n",
       "      <td>3469</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>50</td>\n",
       "      <td>1931-32</td>\n",
       "      <td>1987-88</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Athletic Bilbao</td>\n",
       "      <td>86</td>\n",
       "      <td>3368</td>\n",
       "      <td>2762</td>\n",
       "      <td>1209</td>\n",
       "      <td>633</td>\n",
       "      <td>920</td>\n",
       "      <td>4631</td>\n",
       "      <td>3700</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>49</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Sevilla</td>\n",
       "      <td>73</td>\n",
       "      <td>2819</td>\n",
       "      <td>2408</td>\n",
       "      <td>990</td>\n",
       "      <td>531</td>\n",
       "      <td>887</td>\n",
       "      <td>3680</td>\n",
       "      <td>3373</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>32</td>\n",
       "      <td>1934-35</td>\n",
       "      <td>2001-02</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>Espanyol</td>\n",
       "      <td>82</td>\n",
       "      <td>2792</td>\n",
       "      <td>2626</td>\n",
       "      <td>948</td>\n",
       "      <td>608</td>\n",
       "      <td>1070</td>\n",
       "      <td>3609</td>\n",
       "      <td>3889</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>16</td>\n",
       "      <td>1929</td>\n",
       "      <td>1994-95</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>Real Sociedad</td>\n",
       "      <td>70</td>\n",
       "      <td>2573</td>\n",
       "      <td>2302</td>\n",
       "      <td>864</td>\n",
       "      <td>577</td>\n",
       "      <td>861</td>\n",
       "      <td>3228</td>\n",
       "      <td>3230</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>19</td>\n",
       "      <td>1929</td>\n",
       "      <td>2010-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>Zaragoza</td>\n",
       "      <td>58</td>\n",
       "      <td>2109</td>\n",
       "      <td>1986</td>\n",
       "      <td>698</td>\n",
       "      <td>522</td>\n",
       "      <td>766</td>\n",
       "      <td>2683</td>\n",
       "      <td>2847</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>18</td>\n",
       "      <td>1939-40</td>\n",
       "      <td>2012-13</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>Real Betis</td>\n",
       "      <td>51</td>\n",
       "      <td>1884</td>\n",
       "      <td>1728</td>\n",
       "      <td>606</td>\n",
       "      <td>440</td>\n",
       "      <td>682</td>\n",
       "      <td>2159</td>\n",
       "      <td>2492</td>\n",
       "      <td>1</td>\n",
       "      <td>-</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>14</td>\n",
       "      <td>1932-33</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>Deportivo La Coruna</td>\n",
       "      <td>45</td>\n",
       "      <td>1814</td>\n",
       "      <td>1530</td>\n",
       "      <td>563</td>\n",
       "      <td>392</td>\n",
       "      <td>575</td>\n",
       "      <td>2052</td>\n",
       "      <td>2188</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>1941-42</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>Celta Vigo</td>\n",
       "      <td>51</td>\n",
       "      <td>1789</td>\n",
       "      <td>1698</td>\n",
       "      <td>586</td>\n",
       "      <td>389</td>\n",
       "      <td>723</td>\n",
       "      <td>2278</td>\n",
       "      <td>2624</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>11</td>\n",
       "      <td>1939-40</td>\n",
       "      <td>2012-13</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>Valladolid</td>\n",
       "      <td>42</td>\n",
       "      <td>1471</td>\n",
       "      <td>1466</td>\n",
       "      <td>463</td>\n",
       "      <td>384</td>\n",
       "      <td>619</td>\n",
       "      <td>1767</td>\n",
       "      <td>2180</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1948-49</td>\n",
       "      <td>2013-14</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>Racing Santander</td>\n",
       "      <td>44</td>\n",
       "      <td>1416</td>\n",
       "      <td>1428</td>\n",
       "      <td>453</td>\n",
       "      <td>336</td>\n",
       "      <td>639</td>\n",
       "      <td>1843</td>\n",
       "      <td>2368</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1929</td>\n",
       "      <td>2011-12</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>Sporting Gijon</td>\n",
       "      <td>43</td>\n",
       "      <td>1389</td>\n",
       "      <td>1458</td>\n",
       "      <td>471</td>\n",
       "      <td>358</td>\n",
       "      <td>629</td>\n",
       "      <td>1753</td>\n",
       "      <td>2152</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>1944-45</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>Osasuna</td>\n",
       "      <td>37</td>\n",
       "      <td>1351</td>\n",
       "      <td>1318</td>\n",
       "      <td>426</td>\n",
       "      <td>327</td>\n",
       "      <td>565</td>\n",
       "      <td>1500</td>\n",
       "      <td>1834</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>1935-36</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>Malaga</td>\n",
       "      <td>36</td>\n",
       "      <td>1314</td>\n",
       "      <td>1255</td>\n",
       "      <td>390</td>\n",
       "      <td>330</td>\n",
       "      <td>535</td>\n",
       "      <td>1421</td>\n",
       "      <td>1763</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1949-50</td>\n",
       "      <td>2008-09</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>Oviedo</td>\n",
       "      <td>38</td>\n",
       "      <td>1174</td>\n",
       "      <td>1192</td>\n",
       "      <td>408</td>\n",
       "      <td>292</td>\n",
       "      <td>492</td>\n",
       "      <td>1642</td>\n",
       "      <td>1951</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>1933-34</td>\n",
       "      <td>2000-01</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>Mallorca</td>\n",
       "      <td>27</td>\n",
       "      <td>1148</td>\n",
       "      <td>988</td>\n",
       "      <td>333</td>\n",
       "      <td>256</td>\n",
       "      <td>399</td>\n",
       "      <td>1182</td>\n",
       "      <td>1371</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2</td>\n",
       "      <td>-</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1960-61</td>\n",
       "      <td>2012-13</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>Las Palmas</td>\n",
       "      <td>33</td>\n",
       "      <td>1020</td>\n",
       "      <td>1096</td>\n",
       "      <td>367</td>\n",
       "      <td>242</td>\n",
       "      <td>487</td>\n",
       "      <td>1347</td>\n",
       "      <td>1746</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1951-52</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>17</td>\n",
       "      <td>970</td>\n",
       "      <td>646</td>\n",
       "      <td>266</td>\n",
       "      <td>172</td>\n",
       "      <td>208</td>\n",
       "      <td>892</td>\n",
       "      <td>789</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>1998-99</td>\n",
       "      <td>2013-14</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>Granada</td>\n",
       "      <td>23</td>\n",
       "      <td>667</td>\n",
       "      <td>742</td>\n",
       "      <td>218</td>\n",
       "      <td>175</td>\n",
       "      <td>349</td>\n",
       "      <td>819</td>\n",
       "      <td>1157</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1941-42</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>Rayo Vallecano</td>\n",
       "      <td>17</td>\n",
       "      <td>662</td>\n",
       "      <td>652</td>\n",
       "      <td>189</td>\n",
       "      <td>148</td>\n",
       "      <td>305</td>\n",
       "      <td>760</td>\n",
       "      <td>1088</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1977-78</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>Elche</td>\n",
       "      <td>21</td>\n",
       "      <td>606</td>\n",
       "      <td>678</td>\n",
       "      <td>203</td>\n",
       "      <td>180</td>\n",
       "      <td>295</td>\n",
       "      <td>750</td>\n",
       "      <td>1022</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1959-60</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>Getafe</td>\n",
       "      <td>12</td>\n",
       "      <td>553</td>\n",
       "      <td>456</td>\n",
       "      <td>147</td>\n",
       "      <td>112</td>\n",
       "      <td>197</td>\n",
       "      <td>520</td>\n",
       "      <td>633</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2004-05</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>Hercules</td>\n",
       "      <td>20</td>\n",
       "      <td>538</td>\n",
       "      <td>628</td>\n",
       "      <td>184</td>\n",
       "      <td>149</td>\n",
       "      <td>295</td>\n",
       "      <td>716</td>\n",
       "      <td>1050</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>1935-36</td>\n",
       "      <td>2010-11</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>Tenerife</td>\n",
       "      <td>13</td>\n",
       "      <td>510</td>\n",
       "      <td>494</td>\n",
       "      <td>155</td>\n",
       "      <td>128</td>\n",
       "      <td>211</td>\n",
       "      <td>619</td>\n",
       "      <td>744</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2</td>\n",
       "      <td>-</td>\n",
       "      <td>2</td>\n",
       "      <td>1961-62</td>\n",
       "      <td>2009-10</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>Murcia</td>\n",
       "      <td>18</td>\n",
       "      <td>445</td>\n",
       "      <td>586</td>\n",
       "      <td>145</td>\n",
       "      <td>143</td>\n",
       "      <td>298</td>\n",
       "      <td>607</td>\n",
       "      <td>992</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1940-41</td>\n",
       "      <td>2007-08</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>Alaves</td>\n",
       "      <td>12</td>\n",
       "      <td>421</td>\n",
       "      <td>380</td>\n",
       "      <td>125</td>\n",
       "      <td>81</td>\n",
       "      <td>174</td>\n",
       "      <td>458</td>\n",
       "      <td>623</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1930-31</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>30</td>\n",
       "      <td>Levante</td>\n",
       "      <td>11</td>\n",
       "      <td>416</td>\n",
       "      <td>402</td>\n",
       "      <td>113</td>\n",
       "      <td>95</td>\n",
       "      <td>194</td>\n",
       "      <td>430</td>\n",
       "      <td>632</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1963-64</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>32</td>\n",
       "      <td>Sabadell</td>\n",
       "      <td>14</td>\n",
       "      <td>353</td>\n",
       "      <td>426</td>\n",
       "      <td>129</td>\n",
       "      <td>95</td>\n",
       "      <td>202</td>\n",
       "      <td>492</td>\n",
       "      <td>720</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>-</td>\n",
       "      <td>2</td>\n",
       "      <td>1943-44</td>\n",
       "      <td>1987-88</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>33</td>\n",
       "      <td>Cadiz</td>\n",
       "      <td>12</td>\n",
       "      <td>343</td>\n",
       "      <td>448</td>\n",
       "      <td>104</td>\n",
       "      <td>127</td>\n",
       "      <td>217</td>\n",
       "      <td>393</td>\n",
       "      <td>662</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1977-78</td>\n",
       "      <td>2005-06</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>34</td>\n",
       "      <td>Logrones</td>\n",
       "      <td>9</td>\n",
       "      <td>293</td>\n",
       "      <td>346</td>\n",
       "      <td>96</td>\n",
       "      <td>92</td>\n",
       "      <td>158</td>\n",
       "      <td>291</td>\n",
       "      <td>489</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1987-88</td>\n",
       "      <td>1996-97</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>35</td>\n",
       "      <td>Castellon</td>\n",
       "      <td>11</td>\n",
       "      <td>285</td>\n",
       "      <td>334</td>\n",
       "      <td>103</td>\n",
       "      <td>79</td>\n",
       "      <td>152</td>\n",
       "      <td>419</td>\n",
       "      <td>588</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>-</td>\n",
       "      <td>3</td>\n",
       "      <td>1941-42</td>\n",
       "      <td>1990-91</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>36</td>\n",
       "      <td>Albacete</td>\n",
       "      <td>7</td>\n",
       "      <td>277</td>\n",
       "      <td>270</td>\n",
       "      <td>76</td>\n",
       "      <td>76</td>\n",
       "      <td>118</td>\n",
       "      <td>320</td>\n",
       "      <td>410</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1991-92</td>\n",
       "      <td>2004-05</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>37</td>\n",
       "      <td>Almeria</td>\n",
       "      <td>6</td>\n",
       "      <td>242</td>\n",
       "      <td>228</td>\n",
       "      <td>62</td>\n",
       "      <td>56</td>\n",
       "      <td>110</td>\n",
       "      <td>244</td>\n",
       "      <td>366</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2007-08</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>38</td>\n",
       "      <td>Cordoba</td>\n",
       "      <td>9</td>\n",
       "      <td>230</td>\n",
       "      <td>282</td>\n",
       "      <td>82</td>\n",
       "      <td>63</td>\n",
       "      <td>137</td>\n",
       "      <td>285</td>\n",
       "      <td>430</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>1962-63</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>39</td>\n",
       "      <td>Compostela</td>\n",
       "      <td>4</td>\n",
       "      <td>190</td>\n",
       "      <td>160</td>\n",
       "      <td>52</td>\n",
       "      <td>45</td>\n",
       "      <td>63</td>\n",
       "      <td>199</td>\n",
       "      <td>241</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1994-95</td>\n",
       "      <td>1997-98</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>40</td>\n",
       "      <td>Recreativo</td>\n",
       "      <td>5</td>\n",
       "      <td>188</td>\n",
       "      <td>186</td>\n",
       "      <td>50</td>\n",
       "      <td>46</td>\n",
       "      <td>90</td>\n",
       "      <td>202</td>\n",
       "      <td>296</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1978-79</td>\n",
       "      <td>2008-09</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>41</td>\n",
       "      <td>Burgos CF</td>\n",
       "      <td>6</td>\n",
       "      <td>168</td>\n",
       "      <td>204</td>\n",
       "      <td>59</td>\n",
       "      <td>50</td>\n",
       "      <td>95</td>\n",
       "      <td>216</td>\n",
       "      <td>310</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1971-72</td>\n",
       "      <td>1979-80</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>42</td>\n",
       "      <td>Pontevedra</td>\n",
       "      <td>6</td>\n",
       "      <td>150</td>\n",
       "      <td>180</td>\n",
       "      <td>53</td>\n",
       "      <td>44</td>\n",
       "      <td>83</td>\n",
       "      <td>165</td>\n",
       "      <td>221</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1963-64</td>\n",
       "      <td>1969-70</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>43</td>\n",
       "      <td>Numancia</td>\n",
       "      <td>4</td>\n",
       "      <td>148</td>\n",
       "      <td>152</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>78</td>\n",
       "      <td>155</td>\n",
       "      <td>253</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1999-00</td>\n",
       "      <td>2008-09</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>44</td>\n",
       "      <td>Eibar</td>\n",
       "      <td>3</td>\n",
       "      <td>132</td>\n",
       "      <td>114</td>\n",
       "      <td>35</td>\n",
       "      <td>27</td>\n",
       "      <td>52</td>\n",
       "      <td>139</td>\n",
       "      <td>167</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>45</td>\n",
       "      <td>Arenas</td>\n",
       "      <td>7</td>\n",
       "      <td>107</td>\n",
       "      <td>130</td>\n",
       "      <td>43</td>\n",
       "      <td>21</td>\n",
       "      <td>66</td>\n",
       "      <td>227</td>\n",
       "      <td>308</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>-</td>\n",
       "      <td>3</td>\n",
       "      <td>-</td>\n",
       "      <td>4</td>\n",
       "      <td>1929</td>\n",
       "      <td>1934-35</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>46</td>\n",
       "      <td>Real Burgos</td>\n",
       "      <td>3</td>\n",
       "      <td>96</td>\n",
       "      <td>114</td>\n",
       "      <td>26</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>101</td>\n",
       "      <td>139</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1990-91</td>\n",
       "      <td>1992-93</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>47</td>\n",
       "      <td>Gimnastic</td>\n",
       "      <td>4</td>\n",
       "      <td>91</td>\n",
       "      <td>116</td>\n",
       "      <td>34</td>\n",
       "      <td>16</td>\n",
       "      <td>66</td>\n",
       "      <td>181</td>\n",
       "      <td>295</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1947-48</td>\n",
       "      <td>2006-07</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>48</td>\n",
       "      <td>Extremadura</td>\n",
       "      <td>2</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>20</td>\n",
       "      <td>23</td>\n",
       "      <td>37</td>\n",
       "      <td>62</td>\n",
       "      <td>117</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1996-97</td>\n",
       "      <td>1998-99</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>49</td>\n",
       "      <td>Merida</td>\n",
       "      <td>2</td>\n",
       "      <td>81</td>\n",
       "      <td>80</td>\n",
       "      <td>19</td>\n",
       "      <td>24</td>\n",
       "      <td>37</td>\n",
       "      <td>70</td>\n",
       "      <td>115</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1995-96</td>\n",
       "      <td>1997-98</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>50</td>\n",
       "      <td>Alcoyano</td>\n",
       "      <td>4</td>\n",
       "      <td>76</td>\n",
       "      <td>108</td>\n",
       "      <td>30</td>\n",
       "      <td>16</td>\n",
       "      <td>62</td>\n",
       "      <td>145</td>\n",
       "      <td>252</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1945-46</td>\n",
       "      <td>1950-51</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>51</td>\n",
       "      <td>Jaen</td>\n",
       "      <td>3</td>\n",
       "      <td>71</td>\n",
       "      <td>90</td>\n",
       "      <td>29</td>\n",
       "      <td>13</td>\n",
       "      <td>48</td>\n",
       "      <td>121</td>\n",
       "      <td>183</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1953-54</td>\n",
       "      <td>1957-58</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>52</td>\n",
       "      <td>Real Union</td>\n",
       "      <td>4</td>\n",
       "      <td>56</td>\n",
       "      <td>72</td>\n",
       "      <td>21</td>\n",
       "      <td>14</td>\n",
       "      <td>37</td>\n",
       "      <td>153</td>\n",
       "      <td>184</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1929</td>\n",
       "      <td>1931-32</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>53</td>\n",
       "      <td>AD Almeria</td>\n",
       "      <td>2</td>\n",
       "      <td>52</td>\n",
       "      <td>68</td>\n",
       "      <td>17</td>\n",
       "      <td>18</td>\n",
       "      <td>33</td>\n",
       "      <td>71</td>\n",
       "      <td>116</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1979-80</td>\n",
       "      <td>1980-81</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>54</td>\n",
       "      <td>Europa</td>\n",
       "      <td>3</td>\n",
       "      <td>42</td>\n",
       "      <td>54</td>\n",
       "      <td>18</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>97</td>\n",
       "      <td>131</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1929</td>\n",
       "      <td>1930-31</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>55</td>\n",
       "      <td>Lleida</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>68</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>41</td>\n",
       "      <td>70</td>\n",
       "      <td>182</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1950-51</td>\n",
       "      <td>1993-94</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>56</td>\n",
       "      <td>Leganes</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>38</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>19</td>\n",
       "      <td>36</td>\n",
       "      <td>55</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>57</td>\n",
       "      <td>Xerez</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>38</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "      <td>38</td>\n",
       "      <td>66</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2009-10</td>\n",
       "      <td>2009-10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>58</td>\n",
       "      <td>Condal</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>30</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>37</td>\n",
       "      <td>57</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1956-57</td>\n",
       "      <td>1956-57</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>59</td>\n",
       "      <td>Atletico Tetuan</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>30</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>18</td>\n",
       "      <td>51</td>\n",
       "      <td>85</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1951-52</td>\n",
       "      <td>1951-52</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>60</td>\n",
       "      <td>Cultural Leonesa</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>30</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "      <td>34</td>\n",
       "      <td>65</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1955-56</td>\n",
       "      <td>1955-56</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>61</td>\n",
       "      <td>Girona</td>\n",
       "      <td>1</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>2017-18</td>\n",
       "      <td>2017-18</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Pos                 Team Seasons Points GamesPlayed GamesWon GamesDrawn  \\\n",
       "1    1          Real Madrid      86   4385        2762     1647        552   \n",
       "2    2            Barcelona      86   4262        2762     1581        573   \n",
       "3    3      Atletico Madrid      80   3442        2614     1241        598   \n",
       "4    4             Valencia      82   3386        2664     1187        616   \n",
       "5    5      Athletic Bilbao      86   3368        2762     1209        633   \n",
       "6    6              Sevilla      73   2819        2408      990        531   \n",
       "7    7             Espanyol      82   2792        2626      948        608   \n",
       "8    8        Real Sociedad      70   2573        2302      864        577   \n",
       "9    9             Zaragoza      58   2109        1986      698        522   \n",
       "10  10           Real Betis      51   1884        1728      606        440   \n",
       "11  11  Deportivo La Coruna      45   1814        1530      563        392   \n",
       "12  12           Celta Vigo      51   1789        1698      586        389   \n",
       "13  13           Valladolid      42   1471        1466      463        384   \n",
       "14  14     Racing Santander      44   1416        1428      453        336   \n",
       "15  15       Sporting Gijon      43   1389        1458      471        358   \n",
       "16  16              Osasuna      37   1351        1318      426        327   \n",
       "17  17               Malaga      36   1314        1255      390        330   \n",
       "18  18               Oviedo      38   1174        1192      408        292   \n",
       "19  19             Mallorca      27   1148         988      333        256   \n",
       "20  20           Las Palmas      33   1020        1096      367        242   \n",
       "21  21           Villarreal      17    970         646      266        172   \n",
       "22  22              Granada      23    667         742      218        175   \n",
       "23  23       Rayo Vallecano      17    662         652      189        148   \n",
       "24  24                Elche      21    606         678      203        180   \n",
       "25  25               Getafe      12    553         456      147        112   \n",
       "26  26             Hercules      20    538         628      184        149   \n",
       "27  27             Tenerife      13    510         494      155        128   \n",
       "28  28               Murcia      18    445         586      145        143   \n",
       "29  29               Alaves      12    421         380      125         81   \n",
       "30  30              Levante      11    416         402      113         95   \n",
       "..  ..                  ...     ...    ...         ...      ...        ...   \n",
       "32  32             Sabadell      14    353         426      129         95   \n",
       "33  33                Cadiz      12    343         448      104        127   \n",
       "34  34             Logrones       9    293         346       96         92   \n",
       "35  35            Castellon      11    285         334      103         79   \n",
       "36  36             Albacete       7    277         270       76         76   \n",
       "37  37              Almeria       6    242         228       62         56   \n",
       "38  38              Cordoba       9    230         282       82         63   \n",
       "39  39           Compostela       4    190         160       52         45   \n",
       "40  40           Recreativo       5    188         186       50         46   \n",
       "41  41            Burgos CF       6    168         204       59         50   \n",
       "42  42           Pontevedra       6    150         180       53         44   \n",
       "43  43             Numancia       4    148         152       37         37   \n",
       "44  44                Eibar       3    132         114       35         27   \n",
       "45  45               Arenas       7    107         130       43         21   \n",
       "46  46          Real Burgos       3     96         114       26         44   \n",
       "47  47            Gimnastic       4     91         116       34         16   \n",
       "48  48          Extremadura       2     83          80       20         23   \n",
       "49  49               Merida       2     81          80       19         24   \n",
       "50  50             Alcoyano       4     76         108       30         16   \n",
       "51  51                 Jaen       3     71          90       29         13   \n",
       "52  52           Real Union       4     56          72       21         14   \n",
       "53  53           AD Almeria       2     52          68       17         18   \n",
       "54  54               Europa       3     42          54       18          6   \n",
       "55  55               Lleida       2     40          68       13         14   \n",
       "56  56              Leganes       1     35          38        8         11   \n",
       "57  57                Xerez       1     34          38        8         10   \n",
       "58  58               Condal       1     22          30        7          8   \n",
       "59  59      Atletico Tetuan       1     19          30        7          5   \n",
       "60  60     Cultural Leonesa       1     14          30        5          4   \n",
       "61  61               Girona       1      -           -        -          -   \n",
       "\n",
       "   GamesLost GoalsFor GoalsAgainst Champion Runner-up Third Fourth Fifth  \\\n",
       "1        563     5947         3140       33        23     8      8     3   \n",
       "2        608     5900         3114       25        25    12     12     4   \n",
       "3        775     4534         3309       10         8    16      9     7   \n",
       "4        861     4398         3469        6         6    10     11    10   \n",
       "5        920     4631         3700        8         7    10      5     8   \n",
       "6        887     3680         3373        1         4     4      5    12   \n",
       "7       1070     3609         3889        -         -     4      5     2   \n",
       "8        861     3228         3230        2         3     2      5     4   \n",
       "9        766     2683         2847        -         1     4      5     4   \n",
       "10       682     2159         2492        1         -     2      3     4   \n",
       "11       575     2052         2188        1         5     4      1     -   \n",
       "12       723     2278         2624        -         -     -      2     4   \n",
       "13       619     1767         2180        -         -     -      1     1   \n",
       "14       639     1843         2368        -         1     1      2     -   \n",
       "15       629     1753         2152        -         1     1      2     2   \n",
       "16       565     1500         1834        -         -     -      2     2   \n",
       "17       535     1421         1763        -         -     -      1     -   \n",
       "18       492     1642         1951        -         -     3      2     2   \n",
       "19       399     1182         1371        -         -     2      -     2   \n",
       "20       487     1347         1746        -         1     1      1     1   \n",
       "21       208      892          789        -         1     1      2     3   \n",
       "22       349      819         1157        -         -     -      -     -   \n",
       "23       305      760         1088        -         -     -      -     -   \n",
       "24       295      750         1022        -         -     -      -     1   \n",
       "25       197      520          633        -         -     -      -     -   \n",
       "26       295      716         1050        -         -     -      -     1   \n",
       "27       211      619          744        -         -     -      -     2   \n",
       "28       298      607          992        -         -     -      -     -   \n",
       "29       174      458          623        -         -     -      -     -   \n",
       "30       194      430          632        -         -     -      -     -   \n",
       "..       ...      ...          ...      ...       ...   ...    ...   ...   \n",
       "32       202      492          720        -         -     -      1     1   \n",
       "33       217      393          662        -         -     -      -     -   \n",
       "34       158      291          489        -         -     -      -     -   \n",
       "35       152      419          588        -         -     -      1     2   \n",
       "36       118      320          410        -         -     -      -     -   \n",
       "37       110      244          366        -         -     -      -     -   \n",
       "38       137      285          430        -         -     -      -     1   \n",
       "39        63      199          241        -         -     -      -     -   \n",
       "40        90      202          296        -         -     -      -     -   \n",
       "41        95      216          310        -         -     -      -     -   \n",
       "42        83      165          221        -         -     -      -     -   \n",
       "43        78      155          253        -         -     -      -     -   \n",
       "44        52      139          167        -         -     -      -     -   \n",
       "45        66      227          308        -         -     1      -     3   \n",
       "46        44      101          139        -         -     -      -     -   \n",
       "47        66      181          295        -         -     -      -     -   \n",
       "48        37       62          117        -         -     -      -     -   \n",
       "49        37       70          115        -         -     -      -     -   \n",
       "50        62      145          252        -         -     -      -     -   \n",
       "51        48      121          183        -         -     -      -     -   \n",
       "52        37      153          184        -         -     -      -     -   \n",
       "53        33       71          116        -         -     -      -     -   \n",
       "54        30       97          131        -         -     -      -     -   \n",
       "55        41       70          182        -         -     -      -     -   \n",
       "56        19       36           55        -         -     -      -     -   \n",
       "57        20       38           66        -         -     -      -     -   \n",
       "58        15       37           57        -         -     -      -     -   \n",
       "59        18       51           85        -         -     -      -     -   \n",
       "60        21       34           65        -         -     -      -     -   \n",
       "61         -        -            -        -         -     -      -     -   \n",
       "\n",
       "   Sixth   T    Debut Since/LastApp BestPosition  \n",
       "1      4  79     1929          1929            1  \n",
       "2      6  83     1929          1929            1  \n",
       "3      6  56     1929       2002-03            1  \n",
       "4      7  50  1931-32       1987-88            1  \n",
       "5     10  49     1929          1929            1  \n",
       "6      6  32  1934-35       2001-02            1  \n",
       "7      5  16     1929       1994-95            3  \n",
       "8      3  19     1929       2010-11            1  \n",
       "9      4  18  1939-40       2012-13            2  \n",
       "10     4  14  1932-33       2015-16            1  \n",
       "11     1  12  1941-42       2014-15            1  \n",
       "12     5  11  1939-40       2012-13            4  \n",
       "13     1   3  1948-49       2013-14            4  \n",
       "14     1   5     1929       2011-12            2  \n",
       "15     1   7  1944-45       2015-16            2  \n",
       "16     2   6  1935-36       2016-17            4  \n",
       "17     1   2  1949-50       2008-09            4  \n",
       "18     4  11  1933-34       2000-01            3  \n",
       "19     1   5  1960-61       2012-13            3  \n",
       "20     1   5  1951-52       2015-16            2  \n",
       "21     2   9  1998-99       2013-14            2  \n",
       "22     2   2  1941-42       2016-17            6  \n",
       "23     -   -  1977-78       2015-16            8  \n",
       "24     1   2  1959-60       2014-15            5  \n",
       "25     1   1  2004-05       2015-16            6  \n",
       "26     4   5  1935-36       2010-11            5  \n",
       "27     -   2  1961-62       2009-10            5  \n",
       "28     -   -  1940-41       2007-08           11  \n",
       "29     1   1  1930-31       2016-17            6  \n",
       "30     1   1  1963-64       2015-16            6  \n",
       "..   ...  ..      ...           ...          ...  \n",
       "32     -   2  1943-44       1987-88            4  \n",
       "33     -   -  1977-78       2005-06           12  \n",
       "34     -   -  1987-88       1996-97            7  \n",
       "35     -   3  1941-42       1990-91            4  \n",
       "36     -   -  1991-92       2004-05            7  \n",
       "37     -   -  2007-08       2014-15            8  \n",
       "38     -   1  1962-63       2014-15            5  \n",
       "39     -   -  1994-95       1997-98           10  \n",
       "40     -   -  1978-79       2008-09            8  \n",
       "41     -   -  1971-72       1979-80           12  \n",
       "42     -   -  1963-64       1969-70            7  \n",
       "43     -   -  1999-00       2008-09           17  \n",
       "44     -   -  2014-15       2014-15           10  \n",
       "45     -   4     1929       1934-35            3  \n",
       "46     -   -  1990-91       1992-93            9  \n",
       "47     -   -  1947-48       2006-07            7  \n",
       "48     -   -  1996-97       1998-99           17  \n",
       "49     -   -  1995-96       1997-98           19  \n",
       "50     -   -  1945-46       1950-51           10  \n",
       "51     -   -  1953-54       1957-58           14  \n",
       "52     1   1     1929       1931-32            6  \n",
       "53     -   -  1979-80       1980-81           10  \n",
       "54     -   -     1929       1930-31            8  \n",
       "55     -   -  1950-51       1993-94           16  \n",
       "56     -   -  2016-17       2016-17           17  \n",
       "57     -   -  2009-10       2009-10           20  \n",
       "58     -   -  1956-57       1956-57           16  \n",
       "59     -   -  1951-52       1951-52           16  \n",
       "60     -   -  1955-56       1955-56           15  \n",
       "61     -   -  2017-18       2017-18            9  \n",
       "\n",
       "[61 rows x 20 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "laliga"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Pos</th>\n",
       "      <th>Team</th>\n",
       "      <th>Seasons</th>\n",
       "      <th>Points</th>\n",
       "      <th>GamesPlayed</th>\n",
       "      <th>GamesWon</th>\n",
       "      <th>GamesDrawn</th>\n",
       "      <th>GamesLost</th>\n",
       "      <th>GoalsFor</th>\n",
       "      <th>GoalsAgainst</th>\n",
       "      <th>Champion</th>\n",
       "      <th>Runner-up</th>\n",
       "      <th>Third</th>\n",
       "      <th>Fourth</th>\n",
       "      <th>Fifth</th>\n",
       "      <th>Sixth</th>\n",
       "      <th>T</th>\n",
       "      <th>Debut</th>\n",
       "      <th>Since/LastApp</th>\n",
       "      <th>BestPosition</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>57</td>\n",
       "      <td>Xerez</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>38</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "      <td>38</td>\n",
       "      <td>66</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>2009-10</td>\n",
       "      <td>2009-10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>58</td>\n",
       "      <td>Condal</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>30</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>37</td>\n",
       "      <td>57</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1956-57</td>\n",
       "      <td>1956-57</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>59</td>\n",
       "      <td>Atletico Tetuan</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>30</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>18</td>\n",
       "      <td>51</td>\n",
       "      <td>85</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1951-52</td>\n",
       "      <td>1951-52</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>60</td>\n",
       "      <td>Cultural Leonesa</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>30</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "      <td>34</td>\n",
       "      <td>65</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1955-56</td>\n",
       "      <td>1955-56</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>61</td>\n",
       "      <td>Girona</td>\n",
       "      <td>1</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>2017-18</td>\n",
       "      <td>2017-18</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Pos              Team Seasons Points GamesPlayed GamesWon GamesDrawn  \\\n",
       "57  57             Xerez       1     34          38        8         10   \n",
       "58  58            Condal       1     22          30        7          8   \n",
       "59  59   Atletico Tetuan       1     19          30        7          5   \n",
       "60  60  Cultural Leonesa       1     14          30        5          4   \n",
       "61  61            Girona       1      -           -        -          -   \n",
       "\n",
       "   GamesLost GoalsFor GoalsAgainst Champion Runner-up Third Fourth Fifth  \\\n",
       "57        20       38           66        -         -     -      -     -   \n",
       "58        15       37           57        -         -     -      -     -   \n",
       "59        18       51           85        -         -     -      -     -   \n",
       "60        21       34           65        -         -     -      -     -   \n",
       "61         -        -            -        -         -     -      -     -   \n",
       "\n",
       "   Sixth  T    Debut Since/LastApp BestPosition  \n",
       "57     -  -  2009-10       2009-10           20  \n",
       "58     -  -  1956-57       1956-57           16  \n",
       "59     -  -  1951-52       1951-52           16  \n",
       "60     -  -  1955-56       1955-56           15  \n",
       "61     -  -  2017-18       2017-18            9  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "laliga.tail()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h1>1) Read the data set and replace dashes with 0 to make sure you can perform arithmetic operations on the data. (2.5 points)\n",
    "    </h1>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Pos</th>\n",
       "      <th>Team</th>\n",
       "      <th>Seasons</th>\n",
       "      <th>Points</th>\n",
       "      <th>GamesPlayed</th>\n",
       "      <th>GamesWon</th>\n",
       "      <th>GamesDrawn</th>\n",
       "      <th>GamesLost</th>\n",
       "      <th>GoalsFor</th>\n",
       "      <th>GoalsAgainst</th>\n",
       "      <th>Champion</th>\n",
       "      <th>Runner-up</th>\n",
       "      <th>Third</th>\n",
       "      <th>Fourth</th>\n",
       "      <th>Fifth</th>\n",
       "      <th>Sixth</th>\n",
       "      <th>T</th>\n",
       "      <th>Debut</th>\n",
       "      <th>Since/LastApp</th>\n",
       "      <th>BestPosition</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>33</td>\n",
       "      <td>61</td>\n",
       "      <td>53</td>\n",
       "      <td>59</td>\n",
       "      <td>57</td>\n",
       "      <td>56</td>\n",
       "      <td>60</td>\n",
       "      <td>61</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>21</td>\n",
       "      <td>45</td>\n",
       "      <td>37</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>20</td>\n",
       "      <td>Getafe</td>\n",
       "      <td>1</td>\n",
       "      <td>293</td>\n",
       "      <td>2762</td>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "      <td>37</td>\n",
       "      <td>70</td>\n",
       "      <td>253</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>1929</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>48</td>\n",
       "      <td>43</td>\n",
       "      <td>39</td>\n",
       "      <td>36</td>\n",
       "      <td>33</td>\n",
       "      <td>28</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Pos    Team Seasons Points GamesPlayed GamesWon GamesDrawn GamesLost  \\\n",
       "count   61      61      61     61          61       61         61        61   \n",
       "unique  61      61      33     61          53       59         57        56   \n",
       "top     20  Getafe       1    293        2762        8         16        37   \n",
       "freq     1       1       6      1           3        2          2         3   \n",
       "\n",
       "       GoalsFor GoalsAgainst Champion Runner-up Third Fourth Fifth Sixth   T  \\\n",
       "count        61           61       61        61    61     61    61    61  61   \n",
       "unique       60           61        8        10     9      9     9     9  21   \n",
       "top          70          253        -         -     -      -     -     -   -   \n",
       "freq          2            1       52        48    43     39    36    33  28   \n",
       "\n",
       "       Debut Since/LastApp BestPosition  \n",
       "count     61            61           61  \n",
       "unique    45            37           18  \n",
       "top     1929       2015-16            1  \n",
       "freq      10             6            9  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "laliga.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "laliga.replace(to_replace= '-', value= 0, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>Pos</th>\n",
       "      <th>Team</th>\n",
       "      <th>Seasons</th>\n",
       "      <th>Points</th>\n",
       "      <th>GamesPlayed</th>\n",
       "      <th>GamesWon</th>\n",
       "      <th>GamesDrawn</th>\n",
       "      <th>GamesLost</th>\n",
       "      <th>GoalsFor</th>\n",
       "      <th>GoalsAgainst</th>\n",
       "      <th>Champion</th>\n",
       "      <th>Runner-up</th>\n",
       "      <th>Third</th>\n",
       "      <th>Fourth</th>\n",
       "      <th>Fifth</th>\n",
       "      <th>Sixth</th>\n",
       "      <th>T</th>\n",
       "      <th>Debut</th>\n",
       "      <th>Since/LastApp</th>\n",
       "      <th>BestPosition</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>86</td>\n",
       "      <td>4385</td>\n",
       "      <td>2762</td>\n",
       "      <td>1647</td>\n",
       "      <td>552</td>\n",
       "      <td>563</td>\n",
       "      <td>5947</td>\n",
       "      <td>3140</td>\n",
       "      <td>33</td>\n",
       "      <td>23</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>79</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>86</td>\n",
       "      <td>4262</td>\n",
       "      <td>2762</td>\n",
       "      <td>1581</td>\n",
       "      <td>573</td>\n",
       "      <td>608</td>\n",
       "      <td>5900</td>\n",
       "      <td>3114</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>83</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Atletico Madrid</td>\n",
       "      <td>80</td>\n",
       "      <td>3442</td>\n",
       "      <td>2614</td>\n",
       "      <td>1241</td>\n",
       "      <td>598</td>\n",
       "      <td>775</td>\n",
       "      <td>4534</td>\n",
       "      <td>3309</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>56</td>\n",
       "      <td>1929</td>\n",
       "      <td>2002-03</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>82</td>\n",
       "      <td>3386</td>\n",
       "      <td>2664</td>\n",
       "      <td>1187</td>\n",
       "      <td>616</td>\n",
       "      <td>861</td>\n",
       "      <td>4398</td>\n",
       "      <td>3469</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>50</td>\n",
       "      <td>1931-32</td>\n",
       "      <td>1987-88</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Athletic Bilbao</td>\n",
       "      <td>86</td>\n",
       "      <td>3368</td>\n",
       "      <td>2762</td>\n",
       "      <td>1209</td>\n",
       "      <td>633</td>\n",
       "      <td>920</td>\n",
       "      <td>4631</td>\n",
       "      <td>3700</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>49</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Sevilla</td>\n",
       "      <td>73</td>\n",
       "      <td>2819</td>\n",
       "      <td>2408</td>\n",
       "      <td>990</td>\n",
       "      <td>531</td>\n",
       "      <td>887</td>\n",
       "      <td>3680</td>\n",
       "      <td>3373</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>32</td>\n",
       "      <td>1934-35</td>\n",
       "      <td>2001-02</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>Espanyol</td>\n",
       "      <td>82</td>\n",
       "      <td>2792</td>\n",
       "      <td>2626</td>\n",
       "      <td>948</td>\n",
       "      <td>608</td>\n",
       "      <td>1070</td>\n",
       "      <td>3609</td>\n",
       "      <td>3889</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>16</td>\n",
       "      <td>1929</td>\n",
       "      <td>1994-95</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>Real Sociedad</td>\n",
       "      <td>70</td>\n",
       "      <td>2573</td>\n",
       "      <td>2302</td>\n",
       "      <td>864</td>\n",
       "      <td>577</td>\n",
       "      <td>861</td>\n",
       "      <td>3228</td>\n",
       "      <td>3230</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>19</td>\n",
       "      <td>1929</td>\n",
       "      <td>2010-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>Zaragoza</td>\n",
       "      <td>58</td>\n",
       "      <td>2109</td>\n",
       "      <td>1986</td>\n",
       "      <td>698</td>\n",
       "      <td>522</td>\n",
       "      <td>766</td>\n",
       "      <td>2683</td>\n",
       "      <td>2847</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>18</td>\n",
       "      <td>1939-40</td>\n",
       "      <td>2012-13</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>Real Betis</td>\n",
       "      <td>51</td>\n",
       "      <td>1884</td>\n",
       "      <td>1728</td>\n",
       "      <td>606</td>\n",
       "      <td>440</td>\n",
       "      <td>682</td>\n",
       "      <td>2159</td>\n",
       "      <td>2492</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>14</td>\n",
       "      <td>1932-33</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>Deportivo La Coruna</td>\n",
       "      <td>45</td>\n",
       "      <td>1814</td>\n",
       "      <td>1530</td>\n",
       "      <td>563</td>\n",
       "      <td>392</td>\n",
       "      <td>575</td>\n",
       "      <td>2052</td>\n",
       "      <td>2188</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>1941-42</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>Celta Vigo</td>\n",
       "      <td>51</td>\n",
       "      <td>1789</td>\n",
       "      <td>1698</td>\n",
       "      <td>586</td>\n",
       "      <td>389</td>\n",
       "      <td>723</td>\n",
       "      <td>2278</td>\n",
       "      <td>2624</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>11</td>\n",
       "      <td>1939-40</td>\n",
       "      <td>2012-13</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>Valladolid</td>\n",
       "      <td>42</td>\n",
       "      <td>1471</td>\n",
       "      <td>1466</td>\n",
       "      <td>463</td>\n",
       "      <td>384</td>\n",
       "      <td>619</td>\n",
       "      <td>1767</td>\n",
       "      <td>2180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1948-49</td>\n",
       "      <td>2013-14</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>Racing Santander</td>\n",
       "      <td>44</td>\n",
       "      <td>1416</td>\n",
       "      <td>1428</td>\n",
       "      <td>453</td>\n",
       "      <td>336</td>\n",
       "      <td>639</td>\n",
       "      <td>1843</td>\n",
       "      <td>2368</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1929</td>\n",
       "      <td>2011-12</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>Sporting Gijon</td>\n",
       "      <td>43</td>\n",
       "      <td>1389</td>\n",
       "      <td>1458</td>\n",
       "      <td>471</td>\n",
       "      <td>358</td>\n",
       "      <td>629</td>\n",
       "      <td>1753</td>\n",
       "      <td>2152</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>1944-45</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>Osasuna</td>\n",
       "      <td>37</td>\n",
       "      <td>1351</td>\n",
       "      <td>1318</td>\n",
       "      <td>426</td>\n",
       "      <td>327</td>\n",
       "      <td>565</td>\n",
       "      <td>1500</td>\n",
       "      <td>1834</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>1935-36</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>Malaga</td>\n",
       "      <td>36</td>\n",
       "      <td>1314</td>\n",
       "      <td>1255</td>\n",
       "      <td>390</td>\n",
       "      <td>330</td>\n",
       "      <td>535</td>\n",
       "      <td>1421</td>\n",
       "      <td>1763</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1949-50</td>\n",
       "      <td>2008-09</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>Oviedo</td>\n",
       "      <td>38</td>\n",
       "      <td>1174</td>\n",
       "      <td>1192</td>\n",
       "      <td>408</td>\n",
       "      <td>292</td>\n",
       "      <td>492</td>\n",
       "      <td>1642</td>\n",
       "      <td>1951</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>1933-34</td>\n",
       "      <td>2000-01</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>Mallorca</td>\n",
       "      <td>27</td>\n",
       "      <td>1148</td>\n",
       "      <td>988</td>\n",
       "      <td>333</td>\n",
       "      <td>256</td>\n",
       "      <td>399</td>\n",
       "      <td>1182</td>\n",
       "      <td>1371</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1960-61</td>\n",
       "      <td>2012-13</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>Las Palmas</td>\n",
       "      <td>33</td>\n",
       "      <td>1020</td>\n",
       "      <td>1096</td>\n",
       "      <td>367</td>\n",
       "      <td>242</td>\n",
       "      <td>487</td>\n",
       "      <td>1347</td>\n",
       "      <td>1746</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1951-52</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>17</td>\n",
       "      <td>970</td>\n",
       "      <td>646</td>\n",
       "      <td>266</td>\n",
       "      <td>172</td>\n",
       "      <td>208</td>\n",
       "      <td>892</td>\n",
       "      <td>789</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>1998-99</td>\n",
       "      <td>2013-14</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>Granada</td>\n",
       "      <td>23</td>\n",
       "      <td>667</td>\n",
       "      <td>742</td>\n",
       "      <td>218</td>\n",
       "      <td>175</td>\n",
       "      <td>349</td>\n",
       "      <td>819</td>\n",
       "      <td>1157</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1941-42</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>Rayo Vallecano</td>\n",
       "      <td>17</td>\n",
       "      <td>662</td>\n",
       "      <td>652</td>\n",
       "      <td>189</td>\n",
       "      <td>148</td>\n",
       "      <td>305</td>\n",
       "      <td>760</td>\n",
       "      <td>1088</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1977-78</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>Elche</td>\n",
       "      <td>21</td>\n",
       "      <td>606</td>\n",
       "      <td>678</td>\n",
       "      <td>203</td>\n",
       "      <td>180</td>\n",
       "      <td>295</td>\n",
       "      <td>750</td>\n",
       "      <td>1022</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1959-60</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>Getafe</td>\n",
       "      <td>12</td>\n",
       "      <td>553</td>\n",
       "      <td>456</td>\n",
       "      <td>147</td>\n",
       "      <td>112</td>\n",
       "      <td>197</td>\n",
       "      <td>520</td>\n",
       "      <td>633</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2004-05</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>Hercules</td>\n",
       "      <td>20</td>\n",
       "      <td>538</td>\n",
       "      <td>628</td>\n",
       "      <td>184</td>\n",
       "      <td>149</td>\n",
       "      <td>295</td>\n",
       "      <td>716</td>\n",
       "      <td>1050</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>1935-36</td>\n",
       "      <td>2010-11</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>Tenerife</td>\n",
       "      <td>13</td>\n",
       "      <td>510</td>\n",
       "      <td>494</td>\n",
       "      <td>155</td>\n",
       "      <td>128</td>\n",
       "      <td>211</td>\n",
       "      <td>619</td>\n",
       "      <td>744</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1961-62</td>\n",
       "      <td>2009-10</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>Murcia</td>\n",
       "      <td>18</td>\n",
       "      <td>445</td>\n",
       "      <td>586</td>\n",
       "      <td>145</td>\n",
       "      <td>143</td>\n",
       "      <td>298</td>\n",
       "      <td>607</td>\n",
       "      <td>992</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1940-41</td>\n",
       "      <td>2007-08</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>Alaves</td>\n",
       "      <td>12</td>\n",
       "      <td>421</td>\n",
       "      <td>380</td>\n",
       "      <td>125</td>\n",
       "      <td>81</td>\n",
       "      <td>174</td>\n",
       "      <td>458</td>\n",
       "      <td>623</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1930-31</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>30</td>\n",
       "      <td>Levante</td>\n",
       "      <td>11</td>\n",
       "      <td>416</td>\n",
       "      <td>402</td>\n",
       "      <td>113</td>\n",
       "      <td>95</td>\n",
       "      <td>194</td>\n",
       "      <td>430</td>\n",
       "      <td>632</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1963-64</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>32</td>\n",
       "      <td>Sabadell</td>\n",
       "      <td>14</td>\n",
       "      <td>353</td>\n",
       "      <td>426</td>\n",
       "      <td>129</td>\n",
       "      <td>95</td>\n",
       "      <td>202</td>\n",
       "      <td>492</td>\n",
       "      <td>720</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1943-44</td>\n",
       "      <td>1987-88</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>33</td>\n",
       "      <td>Cadiz</td>\n",
       "      <td>12</td>\n",
       "      <td>343</td>\n",
       "      <td>448</td>\n",
       "      <td>104</td>\n",
       "      <td>127</td>\n",
       "      <td>217</td>\n",
       "      <td>393</td>\n",
       "      <td>662</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1977-78</td>\n",
       "      <td>2005-06</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>34</td>\n",
       "      <td>Logrones</td>\n",
       "      <td>9</td>\n",
       "      <td>293</td>\n",
       "      <td>346</td>\n",
       "      <td>96</td>\n",
       "      <td>92</td>\n",
       "      <td>158</td>\n",
       "      <td>291</td>\n",
       "      <td>489</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1987-88</td>\n",
       "      <td>1996-97</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>35</td>\n",
       "      <td>Castellon</td>\n",
       "      <td>11</td>\n",
       "      <td>285</td>\n",
       "      <td>334</td>\n",
       "      <td>103</td>\n",
       "      <td>79</td>\n",
       "      <td>152</td>\n",
       "      <td>419</td>\n",
       "      <td>588</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1941-42</td>\n",
       "      <td>1990-91</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>36</td>\n",
       "      <td>Albacete</td>\n",
       "      <td>7</td>\n",
       "      <td>277</td>\n",
       "      <td>270</td>\n",
       "      <td>76</td>\n",
       "      <td>76</td>\n",
       "      <td>118</td>\n",
       "      <td>320</td>\n",
       "      <td>410</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1991-92</td>\n",
       "      <td>2004-05</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>37</td>\n",
       "      <td>Almeria</td>\n",
       "      <td>6</td>\n",
       "      <td>242</td>\n",
       "      <td>228</td>\n",
       "      <td>62</td>\n",
       "      <td>56</td>\n",
       "      <td>110</td>\n",
       "      <td>244</td>\n",
       "      <td>366</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2007-08</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>38</td>\n",
       "      <td>Cordoba</td>\n",
       "      <td>9</td>\n",
       "      <td>230</td>\n",
       "      <td>282</td>\n",
       "      <td>82</td>\n",
       "      <td>63</td>\n",
       "      <td>137</td>\n",
       "      <td>285</td>\n",
       "      <td>430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1962-63</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>39</td>\n",
       "      <td>Compostela</td>\n",
       "      <td>4</td>\n",
       "      <td>190</td>\n",
       "      <td>160</td>\n",
       "      <td>52</td>\n",
       "      <td>45</td>\n",
       "      <td>63</td>\n",
       "      <td>199</td>\n",
       "      <td>241</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1994-95</td>\n",
       "      <td>1997-98</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>40</td>\n",
       "      <td>Recreativo</td>\n",
       "      <td>5</td>\n",
       "      <td>188</td>\n",
       "      <td>186</td>\n",
       "      <td>50</td>\n",
       "      <td>46</td>\n",
       "      <td>90</td>\n",
       "      <td>202</td>\n",
       "      <td>296</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1978-79</td>\n",
       "      <td>2008-09</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>41</td>\n",
       "      <td>Burgos CF</td>\n",
       "      <td>6</td>\n",
       "      <td>168</td>\n",
       "      <td>204</td>\n",
       "      <td>59</td>\n",
       "      <td>50</td>\n",
       "      <td>95</td>\n",
       "      <td>216</td>\n",
       "      <td>310</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1971-72</td>\n",
       "      <td>1979-80</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>42</td>\n",
       "      <td>Pontevedra</td>\n",
       "      <td>6</td>\n",
       "      <td>150</td>\n",
       "      <td>180</td>\n",
       "      <td>53</td>\n",
       "      <td>44</td>\n",
       "      <td>83</td>\n",
       "      <td>165</td>\n",
       "      <td>221</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1963-64</td>\n",
       "      <td>1969-70</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>43</td>\n",
       "      <td>Numancia</td>\n",
       "      <td>4</td>\n",
       "      <td>148</td>\n",
       "      <td>152</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>78</td>\n",
       "      <td>155</td>\n",
       "      <td>253</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1999-00</td>\n",
       "      <td>2008-09</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>44</td>\n",
       "      <td>Eibar</td>\n",
       "      <td>3</td>\n",
       "      <td>132</td>\n",
       "      <td>114</td>\n",
       "      <td>35</td>\n",
       "      <td>27</td>\n",
       "      <td>52</td>\n",
       "      <td>139</td>\n",
       "      <td>167</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>45</td>\n",
       "      <td>Arenas</td>\n",
       "      <td>7</td>\n",
       "      <td>107</td>\n",
       "      <td>130</td>\n",
       "      <td>43</td>\n",
       "      <td>21</td>\n",
       "      <td>66</td>\n",
       "      <td>227</td>\n",
       "      <td>308</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1929</td>\n",
       "      <td>1934-35</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>46</td>\n",
       "      <td>Real Burgos</td>\n",
       "      <td>3</td>\n",
       "      <td>96</td>\n",
       "      <td>114</td>\n",
       "      <td>26</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>101</td>\n",
       "      <td>139</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1990-91</td>\n",
       "      <td>1992-93</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>47</td>\n",
       "      <td>Gimnastic</td>\n",
       "      <td>4</td>\n",
       "      <td>91</td>\n",
       "      <td>116</td>\n",
       "      <td>34</td>\n",
       "      <td>16</td>\n",
       "      <td>66</td>\n",
       "      <td>181</td>\n",
       "      <td>295</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1947-48</td>\n",
       "      <td>2006-07</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>48</td>\n",
       "      <td>Extremadura</td>\n",
       "      <td>2</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>20</td>\n",
       "      <td>23</td>\n",
       "      <td>37</td>\n",
       "      <td>62</td>\n",
       "      <td>117</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1996-97</td>\n",
       "      <td>1998-99</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>49</td>\n",
       "      <td>Merida</td>\n",
       "      <td>2</td>\n",
       "      <td>81</td>\n",
       "      <td>80</td>\n",
       "      <td>19</td>\n",
       "      <td>24</td>\n",
       "      <td>37</td>\n",
       "      <td>70</td>\n",
       "      <td>115</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1995-96</td>\n",
       "      <td>1997-98</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>50</td>\n",
       "      <td>Alcoyano</td>\n",
       "      <td>4</td>\n",
       "      <td>76</td>\n",
       "      <td>108</td>\n",
       "      <td>30</td>\n",
       "      <td>16</td>\n",
       "      <td>62</td>\n",
       "      <td>145</td>\n",
       "      <td>252</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1945-46</td>\n",
       "      <td>1950-51</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>51</td>\n",
       "      <td>Jaen</td>\n",
       "      <td>3</td>\n",
       "      <td>71</td>\n",
       "      <td>90</td>\n",
       "      <td>29</td>\n",
       "      <td>13</td>\n",
       "      <td>48</td>\n",
       "      <td>121</td>\n",
       "      <td>183</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1953-54</td>\n",
       "      <td>1957-58</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>52</td>\n",
       "      <td>Real Union</td>\n",
       "      <td>4</td>\n",
       "      <td>56</td>\n",
       "      <td>72</td>\n",
       "      <td>21</td>\n",
       "      <td>14</td>\n",
       "      <td>37</td>\n",
       "      <td>153</td>\n",
       "      <td>184</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1929</td>\n",
       "      <td>1931-32</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>53</td>\n",
       "      <td>AD Almeria</td>\n",
       "      <td>2</td>\n",
       "      <td>52</td>\n",
       "      <td>68</td>\n",
       "      <td>17</td>\n",
       "      <td>18</td>\n",
       "      <td>33</td>\n",
       "      <td>71</td>\n",
       "      <td>116</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1979-80</td>\n",
       "      <td>1980-81</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>54</td>\n",
       "      <td>Europa</td>\n",
       "      <td>3</td>\n",
       "      <td>42</td>\n",
       "      <td>54</td>\n",
       "      <td>18</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>97</td>\n",
       "      <td>131</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1929</td>\n",
       "      <td>1930-31</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>55</td>\n",
       "      <td>Lleida</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>68</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>41</td>\n",
       "      <td>70</td>\n",
       "      <td>182</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1950-51</td>\n",
       "      <td>1993-94</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>56</td>\n",
       "      <td>Leganes</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>38</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>19</td>\n",
       "      <td>36</td>\n",
       "      <td>55</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>57</td>\n",
       "      <td>Xerez</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>38</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "      <td>38</td>\n",
       "      <td>66</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2009-10</td>\n",
       "      <td>2009-10</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>58</td>\n",
       "      <td>Condal</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>30</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>37</td>\n",
       "      <td>57</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1956-57</td>\n",
       "      <td>1956-57</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>59</td>\n",
       "      <td>Atletico Tetuan</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>30</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>18</td>\n",
       "      <td>51</td>\n",
       "      <td>85</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1951-52</td>\n",
       "      <td>1951-52</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>60</td>\n",
       "      <td>Cultural Leonesa</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>30</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "      <td>34</td>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1955-56</td>\n",
       "      <td>1955-56</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>61</td>\n",
       "      <td>Girona</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-18</td>\n",
       "      <td>2017-18</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Pos                 Team Seasons Points GamesPlayed GamesWon GamesDrawn  \\\n",
       "1    1          Real Madrid      86   4385        2762     1647        552   \n",
       "2    2            Barcelona      86   4262        2762     1581        573   \n",
       "3    3      Atletico Madrid      80   3442        2614     1241        598   \n",
       "4    4             Valencia      82   3386        2664     1187        616   \n",
       "5    5      Athletic Bilbao      86   3368        2762     1209        633   \n",
       "6    6              Sevilla      73   2819        2408      990        531   \n",
       "7    7             Espanyol      82   2792        2626      948        608   \n",
       "8    8        Real Sociedad      70   2573        2302      864        577   \n",
       "9    9             Zaragoza      58   2109        1986      698        522   \n",
       "10  10           Real Betis      51   1884        1728      606        440   \n",
       "11  11  Deportivo La Coruna      45   1814        1530      563        392   \n",
       "12  12           Celta Vigo      51   1789        1698      586        389   \n",
       "13  13           Valladolid      42   1471        1466      463        384   \n",
       "14  14     Racing Santander      44   1416        1428      453        336   \n",
       "15  15       Sporting Gijon      43   1389        1458      471        358   \n",
       "16  16              Osasuna      37   1351        1318      426        327   \n",
       "17  17               Malaga      36   1314        1255      390        330   \n",
       "18  18               Oviedo      38   1174        1192      408        292   \n",
       "19  19             Mallorca      27   1148         988      333        256   \n",
       "20  20           Las Palmas      33   1020        1096      367        242   \n",
       "21  21           Villarreal      17    970         646      266        172   \n",
       "22  22              Granada      23    667         742      218        175   \n",
       "23  23       Rayo Vallecano      17    662         652      189        148   \n",
       "24  24                Elche      21    606         678      203        180   \n",
       "25  25               Getafe      12    553         456      147        112   \n",
       "26  26             Hercules      20    538         628      184        149   \n",
       "27  27             Tenerife      13    510         494      155        128   \n",
       "28  28               Murcia      18    445         586      145        143   \n",
       "29  29               Alaves      12    421         380      125         81   \n",
       "30  30              Levante      11    416         402      113         95   \n",
       "..  ..                  ...     ...    ...         ...      ...        ...   \n",
       "32  32             Sabadell      14    353         426      129         95   \n",
       "33  33                Cadiz      12    343         448      104        127   \n",
       "34  34             Logrones       9    293         346       96         92   \n",
       "35  35            Castellon      11    285         334      103         79   \n",
       "36  36             Albacete       7    277         270       76         76   \n",
       "37  37              Almeria       6    242         228       62         56   \n",
       "38  38              Cordoba       9    230         282       82         63   \n",
       "39  39           Compostela       4    190         160       52         45   \n",
       "40  40           Recreativo       5    188         186       50         46   \n",
       "41  41            Burgos CF       6    168         204       59         50   \n",
       "42  42           Pontevedra       6    150         180       53         44   \n",
       "43  43             Numancia       4    148         152       37         37   \n",
       "44  44                Eibar       3    132         114       35         27   \n",
       "45  45               Arenas       7    107         130       43         21   \n",
       "46  46          Real Burgos       3     96         114       26         44   \n",
       "47  47            Gimnastic       4     91         116       34         16   \n",
       "48  48          Extremadura       2     83          80       20         23   \n",
       "49  49               Merida       2     81          80       19         24   \n",
       "50  50             Alcoyano       4     76         108       30         16   \n",
       "51  51                 Jaen       3     71          90       29         13   \n",
       "52  52           Real Union       4     56          72       21         14   \n",
       "53  53           AD Almeria       2     52          68       17         18   \n",
       "54  54               Europa       3     42          54       18          6   \n",
       "55  55               Lleida       2     40          68       13         14   \n",
       "56  56              Leganes       1     35          38        8         11   \n",
       "57  57                Xerez       1     34          38        8         10   \n",
       "58  58               Condal       1     22          30        7          8   \n",
       "59  59      Atletico Tetuan       1     19          30        7          5   \n",
       "60  60     Cultural Leonesa       1     14          30        5          4   \n",
       "61  61               Girona       1      0           0        0          0   \n",
       "\n",
       "   GamesLost GoalsFor GoalsAgainst Champion Runner-up Third Fourth Fifth  \\\n",
       "1        563     5947         3140       33        23     8      8     3   \n",
       "2        608     5900         3114       25        25    12     12     4   \n",
       "3        775     4534         3309       10         8    16      9     7   \n",
       "4        861     4398         3469        6         6    10     11    10   \n",
       "5        920     4631         3700        8         7    10      5     8   \n",
       "6        887     3680         3373        1         4     4      5    12   \n",
       "7       1070     3609         3889        0         0     4      5     2   \n",
       "8        861     3228         3230        2         3     2      5     4   \n",
       "9        766     2683         2847        0         1     4      5     4   \n",
       "10       682     2159         2492        1         0     2      3     4   \n",
       "11       575     2052         2188        1         5     4      1     0   \n",
       "12       723     2278         2624        0         0     0      2     4   \n",
       "13       619     1767         2180        0         0     0      1     1   \n",
       "14       639     1843         2368        0         1     1      2     0   \n",
       "15       629     1753         2152        0         1     1      2     2   \n",
       "16       565     1500         1834        0         0     0      2     2   \n",
       "17       535     1421         1763        0         0     0      1     0   \n",
       "18       492     1642         1951        0         0     3      2     2   \n",
       "19       399     1182         1371        0         0     2      0     2   \n",
       "20       487     1347         1746        0         1     1      1     1   \n",
       "21       208      892          789        0         1     1      2     3   \n",
       "22       349      819         1157        0         0     0      0     0   \n",
       "23       305      760         1088        0         0     0      0     0   \n",
       "24       295      750         1022        0         0     0      0     1   \n",
       "25       197      520          633        0         0     0      0     0   \n",
       "26       295      716         1050        0         0     0      0     1   \n",
       "27       211      619          744        0         0     0      0     2   \n",
       "28       298      607          992        0         0     0      0     0   \n",
       "29       174      458          623        0         0     0      0     0   \n",
       "30       194      430          632        0         0     0      0     0   \n",
       "..       ...      ...          ...      ...       ...   ...    ...   ...   \n",
       "32       202      492          720        0         0     0      1     1   \n",
       "33       217      393          662        0         0     0      0     0   \n",
       "34       158      291          489        0         0     0      0     0   \n",
       "35       152      419          588        0         0     0      1     2   \n",
       "36       118      320          410        0         0     0      0     0   \n",
       "37       110      244          366        0         0     0      0     0   \n",
       "38       137      285          430        0         0     0      0     1   \n",
       "39        63      199          241        0         0     0      0     0   \n",
       "40        90      202          296        0         0     0      0     0   \n",
       "41        95      216          310        0         0     0      0     0   \n",
       "42        83      165          221        0         0     0      0     0   \n",
       "43        78      155          253        0         0     0      0     0   \n",
       "44        52      139          167        0         0     0      0     0   \n",
       "45        66      227          308        0         0     1      0     3   \n",
       "46        44      101          139        0         0     0      0     0   \n",
       "47        66      181          295        0         0     0      0     0   \n",
       "48        37       62          117        0         0     0      0     0   \n",
       "49        37       70          115        0         0     0      0     0   \n",
       "50        62      145          252        0         0     0      0     0   \n",
       "51        48      121          183        0         0     0      0     0   \n",
       "52        37      153          184        0         0     0      0     0   \n",
       "53        33       71          116        0         0     0      0     0   \n",
       "54        30       97          131        0         0     0      0     0   \n",
       "55        41       70          182        0         0     0      0     0   \n",
       "56        19       36           55        0         0     0      0     0   \n",
       "57        20       38           66        0         0     0      0     0   \n",
       "58        15       37           57        0         0     0      0     0   \n",
       "59        18       51           85        0         0     0      0     0   \n",
       "60        21       34           65        0         0     0      0     0   \n",
       "61         0        0            0        0         0     0      0     0   \n",
       "\n",
       "   Sixth   T    Debut Since/LastApp BestPosition  \n",
       "1      4  79     1929          1929            1  \n",
       "2      6  83     1929          1929            1  \n",
       "3      6  56     1929       2002-03            1  \n",
       "4      7  50  1931-32       1987-88            1  \n",
       "5     10  49     1929          1929            1  \n",
       "6      6  32  1934-35       2001-02            1  \n",
       "7      5  16     1929       1994-95            3  \n",
       "8      3  19     1929       2010-11            1  \n",
       "9      4  18  1939-40       2012-13            2  \n",
       "10     4  14  1932-33       2015-16            1  \n",
       "11     1  12  1941-42       2014-15            1  \n",
       "12     5  11  1939-40       2012-13            4  \n",
       "13     1   3  1948-49       2013-14            4  \n",
       "14     1   5     1929       2011-12            2  \n",
       "15     1   7  1944-45       2015-16            2  \n",
       "16     2   6  1935-36       2016-17            4  \n",
       "17     1   2  1949-50       2008-09            4  \n",
       "18     4  11  1933-34       2000-01            3  \n",
       "19     1   5  1960-61       2012-13            3  \n",
       "20     1   5  1951-52       2015-16            2  \n",
       "21     2   9  1998-99       2013-14            2  \n",
       "22     2   2  1941-42       2016-17            6  \n",
       "23     0   0  1977-78       2015-16            8  \n",
       "24     1   2  1959-60       2014-15            5  \n",
       "25     1   1  2004-05       2015-16            6  \n",
       "26     4   5  1935-36       2010-11            5  \n",
       "27     0   2  1961-62       2009-10            5  \n",
       "28     0   0  1940-41       2007-08           11  \n",
       "29     1   1  1930-31       2016-17            6  \n",
       "30     1   1  1963-64       2015-16            6  \n",
       "..   ...  ..      ...           ...          ...  \n",
       "32     0   2  1943-44       1987-88            4  \n",
       "33     0   0  1977-78       2005-06           12  \n",
       "34     0   0  1987-88       1996-97            7  \n",
       "35     0   3  1941-42       1990-91            4  \n",
       "36     0   0  1991-92       2004-05            7  \n",
       "37     0   0  2007-08       2014-15            8  \n",
       "38     0   1  1962-63       2014-15            5  \n",
       "39     0   0  1994-95       1997-98           10  \n",
       "40     0   0  1978-79       2008-09            8  \n",
       "41     0   0  1971-72       1979-80           12  \n",
       "42     0   0  1963-64       1969-70            7  \n",
       "43     0   0  1999-00       2008-09           17  \n",
       "44     0   0  2014-15       2014-15           10  \n",
       "45     0   4     1929       1934-35            3  \n",
       "46     0   0  1990-91       1992-93            9  \n",
       "47     0   0  1947-48       2006-07            7  \n",
       "48     0   0  1996-97       1998-99           17  \n",
       "49     0   0  1995-96       1997-98           19  \n",
       "50     0   0  1945-46       1950-51           10  \n",
       "51     0   0  1953-54       1957-58           14  \n",
       "52     1   1     1929       1931-32            6  \n",
       "53     0   0  1979-80       1980-81           10  \n",
       "54     0   0     1929       1930-31            8  \n",
       "55     0   0  1950-51       1993-94           16  \n",
       "56     0   0  2016-17       2016-17           17  \n",
       "57     0   0  2009-10       2009-10           20  \n",
       "58     0   0  1956-57       1956-57           16  \n",
       "59     0   0  1951-52       1951-52           16  \n",
       "60     0   0  1955-56       1955-56           15  \n",
       "61     0   0  2017-18       2017-18            9  \n",
       "\n",
       "[61 rows x 20 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "laliga"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": true
   },
   "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>Pos</th>\n",
       "      <th>Team</th>\n",
       "      <th>Seasons</th>\n",
       "      <th>Points</th>\n",
       "      <th>GamesPlayed</th>\n",
       "      <th>GamesWon</th>\n",
       "      <th>GamesDrawn</th>\n",
       "      <th>GamesLost</th>\n",
       "      <th>GoalsFor</th>\n",
       "      <th>GoalsAgainst</th>\n",
       "      <th>Champion</th>\n",
       "      <th>Runner-up</th>\n",
       "      <th>Third</th>\n",
       "      <th>Fourth</th>\n",
       "      <th>Fifth</th>\n",
       "      <th>Sixth</th>\n",
       "      <th>T</th>\n",
       "      <th>Debut</th>\n",
       "      <th>Since/LastApp</th>\n",
       "      <th>BestPosition</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>33</td>\n",
       "      <td>61</td>\n",
       "      <td>53</td>\n",
       "      <td>59</td>\n",
       "      <td>57</td>\n",
       "      <td>56</td>\n",
       "      <td>60</td>\n",
       "      <td>61</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>21</td>\n",
       "      <td>45</td>\n",
       "      <td>37</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>20</td>\n",
       "      <td>Getafe</td>\n",
       "      <td>1</td>\n",
       "      <td>293</td>\n",
       "      <td>2762</td>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "      <td>37</td>\n",
       "      <td>70</td>\n",
       "      <td>253</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1929</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>48</td>\n",
       "      <td>43</td>\n",
       "      <td>39</td>\n",
       "      <td>36</td>\n",
       "      <td>33</td>\n",
       "      <td>28</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Pos    Team Seasons Points GamesPlayed GamesWon GamesDrawn GamesLost  \\\n",
       "count   61      61      61     61          61       61         61        61   \n",
       "unique  61      61      33     61          53       59         57        56   \n",
       "top     20  Getafe       1    293        2762        8         16        37   \n",
       "freq     1       1       6      1           3        2          2         3   \n",
       "\n",
       "       GoalsFor GoalsAgainst  Champion  Runner-up  Third  Fourth  Fifth  \\\n",
       "count        61           61        61         61     61      61     61   \n",
       "unique       60           61         8         10      9       9      9   \n",
       "top          70          253         0          0      0       0      0   \n",
       "freq          2            1        52         48     43      39     36   \n",
       "\n",
       "        Sixth   T Debut Since/LastApp BestPosition  \n",
       "count      61  61    61            61           61  \n",
       "unique      9  21    45            37           18  \n",
       "top         0   0  1929       2015-16            1  \n",
       "freq       33  28    10             6            9  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "laliga.describe()\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h> The dashes are replaced with zeros </h1>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "\n",
    "<h1>\n",
    "2) Print all the teams which have started playing between 1930-1980. (5 points)\n",
    "</h1>\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "debut_laliga=laliga[['Team','Debut']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "debut_btw_1930_and_1989=debut_laliga[debut_laliga['Debut']>=str(1930)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The teams which have started playing between 1930-1980 are\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\Python\\lib\\site-packages\\ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    },
    {
     "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>Team</th>\n",
       "      <th>Debut</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Valencia</td>\n",
       "      <td>1931-32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Sevilla</td>\n",
       "      <td>1934-35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Zaragoza</td>\n",
       "      <td>1939-40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Real Betis</td>\n",
       "      <td>1932-33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Deportivo La Coruna</td>\n",
       "      <td>1941-42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Celta Vigo</td>\n",
       "      <td>1939-40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Valladolid</td>\n",
       "      <td>1948-49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Sporting Gijon</td>\n",
       "      <td>1944-45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Osasuna</td>\n",
       "      <td>1935-36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Malaga</td>\n",
       "      <td>1949-50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Oviedo</td>\n",
       "      <td>1933-34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Mallorca</td>\n",
       "      <td>1960-61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Las Palmas</td>\n",
       "      <td>1951-52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Granada</td>\n",
       "      <td>1941-42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Rayo Vallecano</td>\n",
       "      <td>1977-78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Elche</td>\n",
       "      <td>1959-60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Hercules</td>\n",
       "      <td>1935-36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Tenerife</td>\n",
       "      <td>1961-62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Murcia</td>\n",
       "      <td>1940-41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Alaves</td>\n",
       "      <td>1930-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Levante</td>\n",
       "      <td>1963-64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Salamanca</td>\n",
       "      <td>1974-75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Sabadell</td>\n",
       "      <td>1943-44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Cadiz</td>\n",
       "      <td>1977-78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Castellon</td>\n",
       "      <td>1941-42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Cordoba</td>\n",
       "      <td>1962-63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Recreativo</td>\n",
       "      <td>1978-79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Burgos CF</td>\n",
       "      <td>1971-72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Pontevedra</td>\n",
       "      <td>1963-64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Gimnastic</td>\n",
       "      <td>1947-48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Alcoyano</td>\n",
       "      <td>1945-46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Jaen</td>\n",
       "      <td>1953-54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>AD Almeria</td>\n",
       "      <td>1979-80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Lleida</td>\n",
       "      <td>1950-51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Condal</td>\n",
       "      <td>1956-57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Atletico Tetuan</td>\n",
       "      <td>1951-52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Cultural Leonesa</td>\n",
       "      <td>1955-56</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Team    Debut\n",
       "4              Valencia  1931-32\n",
       "6               Sevilla  1934-35\n",
       "9              Zaragoza  1939-40\n",
       "10           Real Betis  1932-33\n",
       "11  Deportivo La Coruna  1941-42\n",
       "12           Celta Vigo  1939-40\n",
       "13           Valladolid  1948-49\n",
       "15       Sporting Gijon  1944-45\n",
       "16              Osasuna  1935-36\n",
       "17               Malaga  1949-50\n",
       "18               Oviedo  1933-34\n",
       "19             Mallorca  1960-61\n",
       "20           Las Palmas  1951-52\n",
       "22              Granada  1941-42\n",
       "23       Rayo Vallecano  1977-78\n",
       "24                Elche  1959-60\n",
       "26             Hercules  1935-36\n",
       "27             Tenerife  1961-62\n",
       "28               Murcia  1940-41\n",
       "29               Alaves  1930-31\n",
       "30              Levante  1963-64\n",
       "31            Salamanca  1974-75\n",
       "32             Sabadell  1943-44\n",
       "33                Cadiz  1977-78\n",
       "35            Castellon  1941-42\n",
       "38              Cordoba  1962-63\n",
       "40           Recreativo  1978-79\n",
       "41            Burgos CF  1971-72\n",
       "42           Pontevedra  1963-64\n",
       "47            Gimnastic  1947-48\n",
       "50             Alcoyano  1945-46\n",
       "51                 Jaen  1953-54\n",
       "53           AD Almeria  1979-80\n",
       "55               Lleida  1950-51\n",
       "58               Condal  1956-57\n",
       "59      Atletico Tetuan  1951-52\n",
       "60     Cultural Leonesa  1955-56"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "teams_debut=debut_btw_1930_and_1989[debut_laliga['Debut']<=str(1980)]\n",
    "print('The teams which have started playing between 1930-1980 are')\n",
    "teams_debut"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h1>3) Print the list of teams which came Top 5 in terms of points (2.5 points)</h1>\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('O')"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.dtype(laliga['Points'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "int64\n"
     ]
    }
   ],
   "source": [
    "laliga['Points'] = laliga['Points'].apply(pd.to_numeric) \n",
    "print(laliga['Points'].dtypes) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>Pos</th>\n",
       "      <th>Team</th>\n",
       "      <th>Seasons</th>\n",
       "      <th>Points</th>\n",
       "      <th>GamesPlayed</th>\n",
       "      <th>GamesWon</th>\n",
       "      <th>GamesDrawn</th>\n",
       "      <th>GamesLost</th>\n",
       "      <th>GoalsFor</th>\n",
       "      <th>GoalsAgainst</th>\n",
       "      <th>Champion</th>\n",
       "      <th>Runner-up</th>\n",
       "      <th>Third</th>\n",
       "      <th>Fourth</th>\n",
       "      <th>Fifth</th>\n",
       "      <th>Sixth</th>\n",
       "      <th>T</th>\n",
       "      <th>Debut</th>\n",
       "      <th>Since/LastApp</th>\n",
       "      <th>BestPosition</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>86</td>\n",
       "      <td>4385</td>\n",
       "      <td>2762</td>\n",
       "      <td>1647</td>\n",
       "      <td>552</td>\n",
       "      <td>563</td>\n",
       "      <td>5947</td>\n",
       "      <td>3140</td>\n",
       "      <td>33</td>\n",
       "      <td>23</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>79</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>86</td>\n",
       "      <td>4262</td>\n",
       "      <td>2762</td>\n",
       "      <td>1581</td>\n",
       "      <td>573</td>\n",
       "      <td>608</td>\n",
       "      <td>5900</td>\n",
       "      <td>3114</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>83</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Atletico Madrid</td>\n",
       "      <td>80</td>\n",
       "      <td>3442</td>\n",
       "      <td>2614</td>\n",
       "      <td>1241</td>\n",
       "      <td>598</td>\n",
       "      <td>775</td>\n",
       "      <td>4534</td>\n",
       "      <td>3309</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>56</td>\n",
       "      <td>1929</td>\n",
       "      <td>2002-03</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>82</td>\n",
       "      <td>3386</td>\n",
       "      <td>2664</td>\n",
       "      <td>1187</td>\n",
       "      <td>616</td>\n",
       "      <td>861</td>\n",
       "      <td>4398</td>\n",
       "      <td>3469</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>50</td>\n",
       "      <td>1931-32</td>\n",
       "      <td>1987-88</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Athletic Bilbao</td>\n",
       "      <td>86</td>\n",
       "      <td>3368</td>\n",
       "      <td>2762</td>\n",
       "      <td>1209</td>\n",
       "      <td>633</td>\n",
       "      <td>920</td>\n",
       "      <td>4631</td>\n",
       "      <td>3700</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>49</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Pos             Team Seasons  Points GamesPlayed GamesWon GamesDrawn  \\\n",
       "1   1      Real Madrid      86    4385        2762     1647        552   \n",
       "2   2        Barcelona      86    4262        2762     1581        573   \n",
       "3   3  Atletico Madrid      80    3442        2614     1241        598   \n",
       "4   4         Valencia      82    3386        2664     1187        616   \n",
       "5   5  Athletic Bilbao      86    3368        2762     1209        633   \n",
       "\n",
       "  GamesLost GoalsFor GoalsAgainst Champion Runner-up Third Fourth Fifth Sixth  \\\n",
       "1       563     5947         3140       33        23     8      8     3     4   \n",
       "2       608     5900         3114       25        25    12     12     4     6   \n",
       "3       775     4534         3309       10         8    16      9     7     6   \n",
       "4       861     4398         3469        6         6    10     11    10     7   \n",
       "5       920     4631         3700        8         7    10      5     8    10   \n",
       "\n",
       "    T    Debut Since/LastApp BestPosition  \n",
       "1  79     1929          1929            1  \n",
       "2  83     1929          1929            1  \n",
       "3  56     1929       2002-03            1  \n",
       "4  50  1931-32       1987-88            1  \n",
       "5  49     1929          1929            1  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x=laliga.nlargest(5, ['Points']) \n",
    "x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "l1=[]\n",
    "l1.append(x['Team'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The list of teams which came Top 5 in terms of points are : \n",
      " [1        Real Madrid\n",
      "2          Barcelona\n",
      "3    Atletico Madrid\n",
      "4           Valencia\n",
      "5    Athletic Bilbao\n",
      "Name: Team, dtype: object]\n"
     ]
    }
   ],
   "source": [
    "print('The list of teams which came Top 5 in terms of points are :','\\n',l1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h1>\n",
    "4) Write a function with name “Goal_diff_count” which should return all the teams with their Goal Differences. Using the same function, find the team which has maximum and minimum goal difference. (5 points)\n",
    "</h1>\n",
    "<h2>\n",
    "Goal_diff_count = GoalsFor - GoalsAgainst\n",
    "    </h2>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('O')"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.dtype(laliga['GoalsFor'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('O')"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.dtype(laliga['GoalsAgainst'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "GoalsFor        int64\n",
      "GoalsAgainst    int64\n",
      "dtype: object\n"
     ]
    }
   ],
   "source": [
    "laliga[['GoalsFor','GoalsAgainst']] = laliga[['GoalsFor','GoalsAgainst']].apply(pd.to_numeric) \n",
    "print(laliga[['GoalsFor','GoalsAgainst']].dtypes)\n",
    "# to convert dtypes from object to int"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "def Goal_diff_count():\n",
    "    difference = abs(laliga['GoalsFor'] - laliga['GoalsAgainst']) ## abs is for getting absolute values as here we get some negative values as difference\n",
    "    laliga['Goal Difference']=difference\n",
    "    x=laliga[['Team','Goal Difference']]\n",
    "    print('The teams and their respecti e goal differences are:','\\n',x)\n",
    "    max_goal=laliga['Goal Difference'].max()\n",
    "    maximum_goal=laliga[laliga[\"Goal Difference\"]==max_goal]\n",
    "    print('The team which has maximum goal difference is: ' , '\\n',maximum_goal[['Team','Goal Difference']])\n",
    "    min_goal=laliga['Goal Difference'].min()\n",
    "    minimum_goal=laliga[laliga[\"Goal Difference\"]==min_goal]\n",
    "    print('The team which has minimum goal difference is: ' , '\\n',minimum_goal[['Team','Goal Difference']])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The teams and their respecti e goal differences are: \n",
      "                    Team  Goal Difference\n",
      "1           Real Madrid             2807\n",
      "2             Barcelona             2786\n",
      "3       Atletico Madrid             1225\n",
      "4              Valencia              929\n",
      "5       Athletic Bilbao              931\n",
      "6               Sevilla              307\n",
      "7              Espanyol              280\n",
      "8         Real Sociedad                2\n",
      "9              Zaragoza              164\n",
      "10           Real Betis              333\n",
      "11  Deportivo La Coruna              136\n",
      "12           Celta Vigo              346\n",
      "13           Valladolid              413\n",
      "14     Racing Santander              525\n",
      "15       Sporting Gijon              399\n",
      "16              Osasuna              334\n",
      "17               Malaga              342\n",
      "18               Oviedo              309\n",
      "19             Mallorca              189\n",
      "20           Las Palmas              399\n",
      "21           Villarreal              103\n",
      "22              Granada              338\n",
      "23       Rayo Vallecano              328\n",
      "24                Elche              272\n",
      "25               Getafe              113\n",
      "26             Hercules              334\n",
      "27             Tenerife              125\n",
      "28               Murcia              385\n",
      "29               Alaves              165\n",
      "30              Levante              202\n",
      "..                  ...              ...\n",
      "32             Sabadell              228\n",
      "33                Cadiz              269\n",
      "34             Logrones              198\n",
      "35            Castellon              169\n",
      "36             Albacete               90\n",
      "37              Almeria              122\n",
      "38              Cordoba              145\n",
      "39           Compostela               42\n",
      "40           Recreativo               94\n",
      "41            Burgos CF               94\n",
      "42           Pontevedra               56\n",
      "43             Numancia               98\n",
      "44                Eibar               28\n",
      "45               Arenas               81\n",
      "46          Real Burgos               38\n",
      "47            Gimnastic              114\n",
      "48          Extremadura               55\n",
      "49               Merida               45\n",
      "50             Alcoyano              107\n",
      "51                 Jaen               62\n",
      "52           Real Union               31\n",
      "53           AD Almeria               45\n",
      "54               Europa               34\n",
      "55               Lleida              112\n",
      "56              Leganes               19\n",
      "57                Xerez               28\n",
      "58               Condal               20\n",
      "59      Atletico Tetuan               34\n",
      "60     Cultural Leonesa               31\n",
      "61               Girona                0\n",
      "\n",
      "[61 rows x 2 columns]\n",
      "The team which has maximum goal difference is:  \n",
      "           Team  Goal Difference\n",
      "1  Real Madrid             2807\n",
      "The team which has minimum goal difference is:  \n",
      "       Team  Goal Difference\n",
      "61  Girona                0\n"
     ]
    }
   ],
   "source": [
    "Goal_diff_count()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h1> 5) Create a new column with name “Winning Percent” and append it to the data set (5 points)\n",
    "Percentage of Winning = (GamesWon / GamesPlayed)*100\n",
    "\n",
    "If there are any numerical error, replace it with 0%\n",
    "\n",
    "Print the top 5 teams which has the highest Winning percentage </h1>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('O')"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "laliga['GamesPlayed'].dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('O')"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "laliga['GamesWon'].dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "GamesWon       int64\n",
      "GamesPlayed    int64\n",
      "dtype: object\n"
     ]
    }
   ],
   "source": [
    "laliga[['GamesWon','GamesPlayed']] = laliga[['GamesWon','GamesPlayed']].apply(pd.to_numeric) \n",
    "print(laliga[['GamesWon','GamesPlayed']].dtypes)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "laliga['Winning Percent']=(laliga['GamesWon']/laliga['GamesPlayed'])*100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "scrolled": false
   },
   "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>Pos</th>\n",
       "      <th>Team</th>\n",
       "      <th>Seasons</th>\n",
       "      <th>Points</th>\n",
       "      <th>GamesPlayed</th>\n",
       "      <th>GamesWon</th>\n",
       "      <th>GamesDrawn</th>\n",
       "      <th>GamesLost</th>\n",
       "      <th>GoalsFor</th>\n",
       "      <th>GoalsAgainst</th>\n",
       "      <th>...</th>\n",
       "      <th>Third</th>\n",
       "      <th>Fourth</th>\n",
       "      <th>Fifth</th>\n",
       "      <th>Sixth</th>\n",
       "      <th>T</th>\n",
       "      <th>Debut</th>\n",
       "      <th>Since/LastApp</th>\n",
       "      <th>BestPosition</th>\n",
       "      <th>Goal Difference</th>\n",
       "      <th>Winning Percent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>86</td>\n",
       "      <td>4385</td>\n",
       "      <td>2762</td>\n",
       "      <td>1647</td>\n",
       "      <td>552</td>\n",
       "      <td>563</td>\n",
       "      <td>5947</td>\n",
       "      <td>3140</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>79</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "      <td>2807</td>\n",
       "      <td>59.630702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>86</td>\n",
       "      <td>4262</td>\n",
       "      <td>2762</td>\n",
       "      <td>1581</td>\n",
       "      <td>573</td>\n",
       "      <td>608</td>\n",
       "      <td>5900</td>\n",
       "      <td>3114</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>83</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "      <td>2786</td>\n",
       "      <td>57.241130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Atletico Madrid</td>\n",
       "      <td>80</td>\n",
       "      <td>3442</td>\n",
       "      <td>2614</td>\n",
       "      <td>1241</td>\n",
       "      <td>598</td>\n",
       "      <td>775</td>\n",
       "      <td>4534</td>\n",
       "      <td>3309</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>56</td>\n",
       "      <td>1929</td>\n",
       "      <td>2002-03</td>\n",
       "      <td>1</td>\n",
       "      <td>1225</td>\n",
       "      <td>47.475134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>82</td>\n",
       "      <td>3386</td>\n",
       "      <td>2664</td>\n",
       "      <td>1187</td>\n",
       "      <td>616</td>\n",
       "      <td>861</td>\n",
       "      <td>4398</td>\n",
       "      <td>3469</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>50</td>\n",
       "      <td>1931-32</td>\n",
       "      <td>1987-88</td>\n",
       "      <td>1</td>\n",
       "      <td>929</td>\n",
       "      <td>44.557057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Athletic Bilbao</td>\n",
       "      <td>86</td>\n",
       "      <td>3368</td>\n",
       "      <td>2762</td>\n",
       "      <td>1209</td>\n",
       "      <td>633</td>\n",
       "      <td>920</td>\n",
       "      <td>4631</td>\n",
       "      <td>3700</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>49</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "      <td>931</td>\n",
       "      <td>43.772629</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Sevilla</td>\n",
       "      <td>73</td>\n",
       "      <td>2819</td>\n",
       "      <td>2408</td>\n",
       "      <td>990</td>\n",
       "      <td>531</td>\n",
       "      <td>887</td>\n",
       "      <td>3680</td>\n",
       "      <td>3373</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>32</td>\n",
       "      <td>1934-35</td>\n",
       "      <td>2001-02</td>\n",
       "      <td>1</td>\n",
       "      <td>307</td>\n",
       "      <td>41.112957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>Espanyol</td>\n",
       "      <td>82</td>\n",
       "      <td>2792</td>\n",
       "      <td>2626</td>\n",
       "      <td>948</td>\n",
       "      <td>608</td>\n",
       "      <td>1070</td>\n",
       "      <td>3609</td>\n",
       "      <td>3889</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>16</td>\n",
       "      <td>1929</td>\n",
       "      <td>1994-95</td>\n",
       "      <td>3</td>\n",
       "      <td>280</td>\n",
       "      <td>36.100533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>Real Sociedad</td>\n",
       "      <td>70</td>\n",
       "      <td>2573</td>\n",
       "      <td>2302</td>\n",
       "      <td>864</td>\n",
       "      <td>577</td>\n",
       "      <td>861</td>\n",
       "      <td>3228</td>\n",
       "      <td>3230</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>19</td>\n",
       "      <td>1929</td>\n",
       "      <td>2010-11</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>37.532580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>Zaragoza</td>\n",
       "      <td>58</td>\n",
       "      <td>2109</td>\n",
       "      <td>1986</td>\n",
       "      <td>698</td>\n",
       "      <td>522</td>\n",
       "      <td>766</td>\n",
       "      <td>2683</td>\n",
       "      <td>2847</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>18</td>\n",
       "      <td>1939-40</td>\n",
       "      <td>2012-13</td>\n",
       "      <td>2</td>\n",
       "      <td>164</td>\n",
       "      <td>35.146022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>Real Betis</td>\n",
       "      <td>51</td>\n",
       "      <td>1884</td>\n",
       "      <td>1728</td>\n",
       "      <td>606</td>\n",
       "      <td>440</td>\n",
       "      <td>682</td>\n",
       "      <td>2159</td>\n",
       "      <td>2492</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>14</td>\n",
       "      <td>1932-33</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>1</td>\n",
       "      <td>333</td>\n",
       "      <td>35.069444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>Deportivo La Coruna</td>\n",
       "      <td>45</td>\n",
       "      <td>1814</td>\n",
       "      <td>1530</td>\n",
       "      <td>563</td>\n",
       "      <td>392</td>\n",
       "      <td>575</td>\n",
       "      <td>2052</td>\n",
       "      <td>2188</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>1941-42</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>1</td>\n",
       "      <td>136</td>\n",
       "      <td>36.797386</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>Celta Vigo</td>\n",
       "      <td>51</td>\n",
       "      <td>1789</td>\n",
       "      <td>1698</td>\n",
       "      <td>586</td>\n",
       "      <td>389</td>\n",
       "      <td>723</td>\n",
       "      <td>2278</td>\n",
       "      <td>2624</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>11</td>\n",
       "      <td>1939-40</td>\n",
       "      <td>2012-13</td>\n",
       "      <td>4</td>\n",
       "      <td>346</td>\n",
       "      <td>34.511190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>Valladolid</td>\n",
       "      <td>42</td>\n",
       "      <td>1471</td>\n",
       "      <td>1466</td>\n",
       "      <td>463</td>\n",
       "      <td>384</td>\n",
       "      <td>619</td>\n",
       "      <td>1767</td>\n",
       "      <td>2180</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1948-49</td>\n",
       "      <td>2013-14</td>\n",
       "      <td>4</td>\n",
       "      <td>413</td>\n",
       "      <td>31.582538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>Racing Santander</td>\n",
       "      <td>44</td>\n",
       "      <td>1416</td>\n",
       "      <td>1428</td>\n",
       "      <td>453</td>\n",
       "      <td>336</td>\n",
       "      <td>639</td>\n",
       "      <td>1843</td>\n",
       "      <td>2368</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1929</td>\n",
       "      <td>2011-12</td>\n",
       "      <td>2</td>\n",
       "      <td>525</td>\n",
       "      <td>31.722689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>Sporting Gijon</td>\n",
       "      <td>43</td>\n",
       "      <td>1389</td>\n",
       "      <td>1458</td>\n",
       "      <td>471</td>\n",
       "      <td>358</td>\n",
       "      <td>629</td>\n",
       "      <td>1753</td>\n",
       "      <td>2152</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>1944-45</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>2</td>\n",
       "      <td>399</td>\n",
       "      <td>32.304527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>Osasuna</td>\n",
       "      <td>37</td>\n",
       "      <td>1351</td>\n",
       "      <td>1318</td>\n",
       "      <td>426</td>\n",
       "      <td>327</td>\n",
       "      <td>565</td>\n",
       "      <td>1500</td>\n",
       "      <td>1834</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>1935-36</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>4</td>\n",
       "      <td>334</td>\n",
       "      <td>32.321700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>Malaga</td>\n",
       "      <td>36</td>\n",
       "      <td>1314</td>\n",
       "      <td>1255</td>\n",
       "      <td>390</td>\n",
       "      <td>330</td>\n",
       "      <td>535</td>\n",
       "      <td>1421</td>\n",
       "      <td>1763</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1949-50</td>\n",
       "      <td>2008-09</td>\n",
       "      <td>4</td>\n",
       "      <td>342</td>\n",
       "      <td>31.075697</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>Oviedo</td>\n",
       "      <td>38</td>\n",
       "      <td>1174</td>\n",
       "      <td>1192</td>\n",
       "      <td>408</td>\n",
       "      <td>292</td>\n",
       "      <td>492</td>\n",
       "      <td>1642</td>\n",
       "      <td>1951</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>1933-34</td>\n",
       "      <td>2000-01</td>\n",
       "      <td>3</td>\n",
       "      <td>309</td>\n",
       "      <td>34.228188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>Mallorca</td>\n",
       "      <td>27</td>\n",
       "      <td>1148</td>\n",
       "      <td>988</td>\n",
       "      <td>333</td>\n",
       "      <td>256</td>\n",
       "      <td>399</td>\n",
       "      <td>1182</td>\n",
       "      <td>1371</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1960-61</td>\n",
       "      <td>2012-13</td>\n",
       "      <td>3</td>\n",
       "      <td>189</td>\n",
       "      <td>33.704453</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>Las Palmas</td>\n",
       "      <td>33</td>\n",
       "      <td>1020</td>\n",
       "      <td>1096</td>\n",
       "      <td>367</td>\n",
       "      <td>242</td>\n",
       "      <td>487</td>\n",
       "      <td>1347</td>\n",
       "      <td>1746</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1951-52</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>2</td>\n",
       "      <td>399</td>\n",
       "      <td>33.485401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>17</td>\n",
       "      <td>970</td>\n",
       "      <td>646</td>\n",
       "      <td>266</td>\n",
       "      <td>172</td>\n",
       "      <td>208</td>\n",
       "      <td>892</td>\n",
       "      <td>789</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>1998-99</td>\n",
       "      <td>2013-14</td>\n",
       "      <td>2</td>\n",
       "      <td>103</td>\n",
       "      <td>41.176471</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>Granada</td>\n",
       "      <td>23</td>\n",
       "      <td>667</td>\n",
       "      <td>742</td>\n",
       "      <td>218</td>\n",
       "      <td>175</td>\n",
       "      <td>349</td>\n",
       "      <td>819</td>\n",
       "      <td>1157</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1941-42</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>6</td>\n",
       "      <td>338</td>\n",
       "      <td>29.380054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>Rayo Vallecano</td>\n",
       "      <td>17</td>\n",
       "      <td>662</td>\n",
       "      <td>652</td>\n",
       "      <td>189</td>\n",
       "      <td>148</td>\n",
       "      <td>305</td>\n",
       "      <td>760</td>\n",
       "      <td>1088</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1977-78</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>8</td>\n",
       "      <td>328</td>\n",
       "      <td>28.987730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>Elche</td>\n",
       "      <td>21</td>\n",
       "      <td>606</td>\n",
       "      <td>678</td>\n",
       "      <td>203</td>\n",
       "      <td>180</td>\n",
       "      <td>295</td>\n",
       "      <td>750</td>\n",
       "      <td>1022</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1959-60</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>5</td>\n",
       "      <td>272</td>\n",
       "      <td>29.941003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>Getafe</td>\n",
       "      <td>12</td>\n",
       "      <td>553</td>\n",
       "      <td>456</td>\n",
       "      <td>147</td>\n",
       "      <td>112</td>\n",
       "      <td>197</td>\n",
       "      <td>520</td>\n",
       "      <td>633</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2004-05</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>6</td>\n",
       "      <td>113</td>\n",
       "      <td>32.236842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>Hercules</td>\n",
       "      <td>20</td>\n",
       "      <td>538</td>\n",
       "      <td>628</td>\n",
       "      <td>184</td>\n",
       "      <td>149</td>\n",
       "      <td>295</td>\n",
       "      <td>716</td>\n",
       "      <td>1050</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>1935-36</td>\n",
       "      <td>2010-11</td>\n",
       "      <td>5</td>\n",
       "      <td>334</td>\n",
       "      <td>29.299363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>Tenerife</td>\n",
       "      <td>13</td>\n",
       "      <td>510</td>\n",
       "      <td>494</td>\n",
       "      <td>155</td>\n",
       "      <td>128</td>\n",
       "      <td>211</td>\n",
       "      <td>619</td>\n",
       "      <td>744</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1961-62</td>\n",
       "      <td>2009-10</td>\n",
       "      <td>5</td>\n",
       "      <td>125</td>\n",
       "      <td>31.376518</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>Murcia</td>\n",
       "      <td>18</td>\n",
       "      <td>445</td>\n",
       "      <td>586</td>\n",
       "      <td>145</td>\n",
       "      <td>143</td>\n",
       "      <td>298</td>\n",
       "      <td>607</td>\n",
       "      <td>992</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1940-41</td>\n",
       "      <td>2007-08</td>\n",
       "      <td>11</td>\n",
       "      <td>385</td>\n",
       "      <td>24.744027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>Alaves</td>\n",
       "      <td>12</td>\n",
       "      <td>421</td>\n",
       "      <td>380</td>\n",
       "      <td>125</td>\n",
       "      <td>81</td>\n",
       "      <td>174</td>\n",
       "      <td>458</td>\n",
       "      <td>623</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1930-31</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>6</td>\n",
       "      <td>165</td>\n",
       "      <td>32.894737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>30</td>\n",
       "      <td>Levante</td>\n",
       "      <td>11</td>\n",
       "      <td>416</td>\n",
       "      <td>402</td>\n",
       "      <td>113</td>\n",
       "      <td>95</td>\n",
       "      <td>194</td>\n",
       "      <td>430</td>\n",
       "      <td>632</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1963-64</td>\n",
       "      <td>2015-16</td>\n",
       "      <td>6</td>\n",
       "      <td>202</td>\n",
       "      <td>28.109453</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>32</th>\n",
       "      <td>32</td>\n",
       "      <td>Sabadell</td>\n",
       "      <td>14</td>\n",
       "      <td>353</td>\n",
       "      <td>426</td>\n",
       "      <td>129</td>\n",
       "      <td>95</td>\n",
       "      <td>202</td>\n",
       "      <td>492</td>\n",
       "      <td>720</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1943-44</td>\n",
       "      <td>1987-88</td>\n",
       "      <td>4</td>\n",
       "      <td>228</td>\n",
       "      <td>30.281690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>33</td>\n",
       "      <td>Cadiz</td>\n",
       "      <td>12</td>\n",
       "      <td>343</td>\n",
       "      <td>448</td>\n",
       "      <td>104</td>\n",
       "      <td>127</td>\n",
       "      <td>217</td>\n",
       "      <td>393</td>\n",
       "      <td>662</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1977-78</td>\n",
       "      <td>2005-06</td>\n",
       "      <td>12</td>\n",
       "      <td>269</td>\n",
       "      <td>23.214286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>34</td>\n",
       "      <td>Logrones</td>\n",
       "      <td>9</td>\n",
       "      <td>293</td>\n",
       "      <td>346</td>\n",
       "      <td>96</td>\n",
       "      <td>92</td>\n",
       "      <td>158</td>\n",
       "      <td>291</td>\n",
       "      <td>489</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1987-88</td>\n",
       "      <td>1996-97</td>\n",
       "      <td>7</td>\n",
       "      <td>198</td>\n",
       "      <td>27.745665</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>35</td>\n",
       "      <td>Castellon</td>\n",
       "      <td>11</td>\n",
       "      <td>285</td>\n",
       "      <td>334</td>\n",
       "      <td>103</td>\n",
       "      <td>79</td>\n",
       "      <td>152</td>\n",
       "      <td>419</td>\n",
       "      <td>588</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1941-42</td>\n",
       "      <td>1990-91</td>\n",
       "      <td>4</td>\n",
       "      <td>169</td>\n",
       "      <td>30.838323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>36</td>\n",
       "      <td>Albacete</td>\n",
       "      <td>7</td>\n",
       "      <td>277</td>\n",
       "      <td>270</td>\n",
       "      <td>76</td>\n",
       "      <td>76</td>\n",
       "      <td>118</td>\n",
       "      <td>320</td>\n",
       "      <td>410</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1991-92</td>\n",
       "      <td>2004-05</td>\n",
       "      <td>7</td>\n",
       "      <td>90</td>\n",
       "      <td>28.148148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>37</td>\n",
       "      <td>Almeria</td>\n",
       "      <td>6</td>\n",
       "      <td>242</td>\n",
       "      <td>228</td>\n",
       "      <td>62</td>\n",
       "      <td>56</td>\n",
       "      <td>110</td>\n",
       "      <td>244</td>\n",
       "      <td>366</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2007-08</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>8</td>\n",
       "      <td>122</td>\n",
       "      <td>27.192982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>38</td>\n",
       "      <td>Cordoba</td>\n",
       "      <td>9</td>\n",
       "      <td>230</td>\n",
       "      <td>282</td>\n",
       "      <td>82</td>\n",
       "      <td>63</td>\n",
       "      <td>137</td>\n",
       "      <td>285</td>\n",
       "      <td>430</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1962-63</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>5</td>\n",
       "      <td>145</td>\n",
       "      <td>29.078014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>39</td>\n",
       "      <td>Compostela</td>\n",
       "      <td>4</td>\n",
       "      <td>190</td>\n",
       "      <td>160</td>\n",
       "      <td>52</td>\n",
       "      <td>45</td>\n",
       "      <td>63</td>\n",
       "      <td>199</td>\n",
       "      <td>241</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1994-95</td>\n",
       "      <td>1997-98</td>\n",
       "      <td>10</td>\n",
       "      <td>42</td>\n",
       "      <td>32.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>40</td>\n",
       "      <td>Recreativo</td>\n",
       "      <td>5</td>\n",
       "      <td>188</td>\n",
       "      <td>186</td>\n",
       "      <td>50</td>\n",
       "      <td>46</td>\n",
       "      <td>90</td>\n",
       "      <td>202</td>\n",
       "      <td>296</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1978-79</td>\n",
       "      <td>2008-09</td>\n",
       "      <td>8</td>\n",
       "      <td>94</td>\n",
       "      <td>26.881720</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>41</td>\n",
       "      <td>Burgos CF</td>\n",
       "      <td>6</td>\n",
       "      <td>168</td>\n",
       "      <td>204</td>\n",
       "      <td>59</td>\n",
       "      <td>50</td>\n",
       "      <td>95</td>\n",
       "      <td>216</td>\n",
       "      <td>310</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1971-72</td>\n",
       "      <td>1979-80</td>\n",
       "      <td>12</td>\n",
       "      <td>94</td>\n",
       "      <td>28.921569</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>42</td>\n",
       "      <td>Pontevedra</td>\n",
       "      <td>6</td>\n",
       "      <td>150</td>\n",
       "      <td>180</td>\n",
       "      <td>53</td>\n",
       "      <td>44</td>\n",
       "      <td>83</td>\n",
       "      <td>165</td>\n",
       "      <td>221</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1963-64</td>\n",
       "      <td>1969-70</td>\n",
       "      <td>7</td>\n",
       "      <td>56</td>\n",
       "      <td>29.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>43</td>\n",
       "      <td>Numancia</td>\n",
       "      <td>4</td>\n",
       "      <td>148</td>\n",
       "      <td>152</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>78</td>\n",
       "      <td>155</td>\n",
       "      <td>253</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1999-00</td>\n",
       "      <td>2008-09</td>\n",
       "      <td>17</td>\n",
       "      <td>98</td>\n",
       "      <td>24.342105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>44</td>\n",
       "      <td>Eibar</td>\n",
       "      <td>3</td>\n",
       "      <td>132</td>\n",
       "      <td>114</td>\n",
       "      <td>35</td>\n",
       "      <td>27</td>\n",
       "      <td>52</td>\n",
       "      <td>139</td>\n",
       "      <td>167</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>2014-15</td>\n",
       "      <td>10</td>\n",
       "      <td>28</td>\n",
       "      <td>30.701754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>45</td>\n",
       "      <td>Arenas</td>\n",
       "      <td>7</td>\n",
       "      <td>107</td>\n",
       "      <td>130</td>\n",
       "      <td>43</td>\n",
       "      <td>21</td>\n",
       "      <td>66</td>\n",
       "      <td>227</td>\n",
       "      <td>308</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1929</td>\n",
       "      <td>1934-35</td>\n",
       "      <td>3</td>\n",
       "      <td>81</td>\n",
       "      <td>33.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>46</td>\n",
       "      <td>Real Burgos</td>\n",
       "      <td>3</td>\n",
       "      <td>96</td>\n",
       "      <td>114</td>\n",
       "      <td>26</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>101</td>\n",
       "      <td>139</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1990-91</td>\n",
       "      <td>1992-93</td>\n",
       "      <td>9</td>\n",
       "      <td>38</td>\n",
       "      <td>22.807018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>47</td>\n",
       "      <td>Gimnastic</td>\n",
       "      <td>4</td>\n",
       "      <td>91</td>\n",
       "      <td>116</td>\n",
       "      <td>34</td>\n",
       "      <td>16</td>\n",
       "      <td>66</td>\n",
       "      <td>181</td>\n",
       "      <td>295</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1947-48</td>\n",
       "      <td>2006-07</td>\n",
       "      <td>7</td>\n",
       "      <td>114</td>\n",
       "      <td>29.310345</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>48</td>\n",
       "      <td>Extremadura</td>\n",
       "      <td>2</td>\n",
       "      <td>83</td>\n",
       "      <td>80</td>\n",
       "      <td>20</td>\n",
       "      <td>23</td>\n",
       "      <td>37</td>\n",
       "      <td>62</td>\n",
       "      <td>117</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1996-97</td>\n",
       "      <td>1998-99</td>\n",
       "      <td>17</td>\n",
       "      <td>55</td>\n",
       "      <td>25.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>49</td>\n",
       "      <td>Merida</td>\n",
       "      <td>2</td>\n",
       "      <td>81</td>\n",
       "      <td>80</td>\n",
       "      <td>19</td>\n",
       "      <td>24</td>\n",
       "      <td>37</td>\n",
       "      <td>70</td>\n",
       "      <td>115</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1995-96</td>\n",
       "      <td>1997-98</td>\n",
       "      <td>19</td>\n",
       "      <td>45</td>\n",
       "      <td>23.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>50</td>\n",
       "      <td>Alcoyano</td>\n",
       "      <td>4</td>\n",
       "      <td>76</td>\n",
       "      <td>108</td>\n",
       "      <td>30</td>\n",
       "      <td>16</td>\n",
       "      <td>62</td>\n",
       "      <td>145</td>\n",
       "      <td>252</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1945-46</td>\n",
       "      <td>1950-51</td>\n",
       "      <td>10</td>\n",
       "      <td>107</td>\n",
       "      <td>27.777778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>51</td>\n",
       "      <td>Jaen</td>\n",
       "      <td>3</td>\n",
       "      <td>71</td>\n",
       "      <td>90</td>\n",
       "      <td>29</td>\n",
       "      <td>13</td>\n",
       "      <td>48</td>\n",
       "      <td>121</td>\n",
       "      <td>183</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1953-54</td>\n",
       "      <td>1957-58</td>\n",
       "      <td>14</td>\n",
       "      <td>62</td>\n",
       "      <td>32.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>52</td>\n",
       "      <td>Real Union</td>\n",
       "      <td>4</td>\n",
       "      <td>56</td>\n",
       "      <td>72</td>\n",
       "      <td>21</td>\n",
       "      <td>14</td>\n",
       "      <td>37</td>\n",
       "      <td>153</td>\n",
       "      <td>184</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1929</td>\n",
       "      <td>1931-32</td>\n",
       "      <td>6</td>\n",
       "      <td>31</td>\n",
       "      <td>29.166667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>53</td>\n",
       "      <td>AD Almeria</td>\n",
       "      <td>2</td>\n",
       "      <td>52</td>\n",
       "      <td>68</td>\n",
       "      <td>17</td>\n",
       "      <td>18</td>\n",
       "      <td>33</td>\n",
       "      <td>71</td>\n",
       "      <td>116</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1979-80</td>\n",
       "      <td>1980-81</td>\n",
       "      <td>10</td>\n",
       "      <td>45</td>\n",
       "      <td>25.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>54</td>\n",
       "      <td>Europa</td>\n",
       "      <td>3</td>\n",
       "      <td>42</td>\n",
       "      <td>54</td>\n",
       "      <td>18</td>\n",
       "      <td>6</td>\n",
       "      <td>30</td>\n",
       "      <td>97</td>\n",
       "      <td>131</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1929</td>\n",
       "      <td>1930-31</td>\n",
       "      <td>8</td>\n",
       "      <td>34</td>\n",
       "      <td>33.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>55</td>\n",
       "      <td>Lleida</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>68</td>\n",
       "      <td>13</td>\n",
       "      <td>14</td>\n",
       "      <td>41</td>\n",
       "      <td>70</td>\n",
       "      <td>182</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1950-51</td>\n",
       "      <td>1993-94</td>\n",
       "      <td>16</td>\n",
       "      <td>112</td>\n",
       "      <td>19.117647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>56</td>\n",
       "      <td>Leganes</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>38</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>19</td>\n",
       "      <td>36</td>\n",
       "      <td>55</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>2016-17</td>\n",
       "      <td>17</td>\n",
       "      <td>19</td>\n",
       "      <td>21.052632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>57</td>\n",
       "      <td>Xerez</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>38</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>20</td>\n",
       "      <td>38</td>\n",
       "      <td>66</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2009-10</td>\n",
       "      <td>2009-10</td>\n",
       "      <td>20</td>\n",
       "      <td>28</td>\n",
       "      <td>21.052632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>58</td>\n",
       "      <td>Condal</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>30</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>37</td>\n",
       "      <td>57</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1956-57</td>\n",
       "      <td>1956-57</td>\n",
       "      <td>16</td>\n",
       "      <td>20</td>\n",
       "      <td>23.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>59</td>\n",
       "      <td>Atletico Tetuan</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>30</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>18</td>\n",
       "      <td>51</td>\n",
       "      <td>85</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1951-52</td>\n",
       "      <td>1951-52</td>\n",
       "      <td>16</td>\n",
       "      <td>34</td>\n",
       "      <td>23.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>60</td>\n",
       "      <td>Cultural Leonesa</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>30</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "      <td>34</td>\n",
       "      <td>65</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1955-56</td>\n",
       "      <td>1955-56</td>\n",
       "      <td>15</td>\n",
       "      <td>31</td>\n",
       "      <td>16.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>61</td>\n",
       "      <td>Girona</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-18</td>\n",
       "      <td>2017-18</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Pos                 Team Seasons  Points  GamesPlayed  GamesWon GamesDrawn  \\\n",
       "1    1          Real Madrid      86    4385         2762      1647        552   \n",
       "2    2            Barcelona      86    4262         2762      1581        573   \n",
       "3    3      Atletico Madrid      80    3442         2614      1241        598   \n",
       "4    4             Valencia      82    3386         2664      1187        616   \n",
       "5    5      Athletic Bilbao      86    3368         2762      1209        633   \n",
       "6    6              Sevilla      73    2819         2408       990        531   \n",
       "7    7             Espanyol      82    2792         2626       948        608   \n",
       "8    8        Real Sociedad      70    2573         2302       864        577   \n",
       "9    9             Zaragoza      58    2109         1986       698        522   \n",
       "10  10           Real Betis      51    1884         1728       606        440   \n",
       "11  11  Deportivo La Coruna      45    1814         1530       563        392   \n",
       "12  12           Celta Vigo      51    1789         1698       586        389   \n",
       "13  13           Valladolid      42    1471         1466       463        384   \n",
       "14  14     Racing Santander      44    1416         1428       453        336   \n",
       "15  15       Sporting Gijon      43    1389         1458       471        358   \n",
       "16  16              Osasuna      37    1351         1318       426        327   \n",
       "17  17               Malaga      36    1314         1255       390        330   \n",
       "18  18               Oviedo      38    1174         1192       408        292   \n",
       "19  19             Mallorca      27    1148          988       333        256   \n",
       "20  20           Las Palmas      33    1020         1096       367        242   \n",
       "21  21           Villarreal      17     970          646       266        172   \n",
       "22  22              Granada      23     667          742       218        175   \n",
       "23  23       Rayo Vallecano      17     662          652       189        148   \n",
       "24  24                Elche      21     606          678       203        180   \n",
       "25  25               Getafe      12     553          456       147        112   \n",
       "26  26             Hercules      20     538          628       184        149   \n",
       "27  27             Tenerife      13     510          494       155        128   \n",
       "28  28               Murcia      18     445          586       145        143   \n",
       "29  29               Alaves      12     421          380       125         81   \n",
       "30  30              Levante      11     416          402       113         95   \n",
       "..  ..                  ...     ...     ...          ...       ...        ...   \n",
       "32  32             Sabadell      14     353          426       129         95   \n",
       "33  33                Cadiz      12     343          448       104        127   \n",
       "34  34             Logrones       9     293          346        96         92   \n",
       "35  35            Castellon      11     285          334       103         79   \n",
       "36  36             Albacete       7     277          270        76         76   \n",
       "37  37              Almeria       6     242          228        62         56   \n",
       "38  38              Cordoba       9     230          282        82         63   \n",
       "39  39           Compostela       4     190          160        52         45   \n",
       "40  40           Recreativo       5     188          186        50         46   \n",
       "41  41            Burgos CF       6     168          204        59         50   \n",
       "42  42           Pontevedra       6     150          180        53         44   \n",
       "43  43             Numancia       4     148          152        37         37   \n",
       "44  44                Eibar       3     132          114        35         27   \n",
       "45  45               Arenas       7     107          130        43         21   \n",
       "46  46          Real Burgos       3      96          114        26         44   \n",
       "47  47            Gimnastic       4      91          116        34         16   \n",
       "48  48          Extremadura       2      83           80        20         23   \n",
       "49  49               Merida       2      81           80        19         24   \n",
       "50  50             Alcoyano       4      76          108        30         16   \n",
       "51  51                 Jaen       3      71           90        29         13   \n",
       "52  52           Real Union       4      56           72        21         14   \n",
       "53  53           AD Almeria       2      52           68        17         18   \n",
       "54  54               Europa       3      42           54        18          6   \n",
       "55  55               Lleida       2      40           68        13         14   \n",
       "56  56              Leganes       1      35           38         8         11   \n",
       "57  57                Xerez       1      34           38         8         10   \n",
       "58  58               Condal       1      22           30         7          8   \n",
       "59  59      Atletico Tetuan       1      19           30         7          5   \n",
       "60  60     Cultural Leonesa       1      14           30         5          4   \n",
       "61  61               Girona       1       0            0         0          0   \n",
       "\n",
       "   GamesLost  GoalsFor  GoalsAgainst       ...       Third Fourth Fifth Sixth  \\\n",
       "1        563      5947          3140       ...           8      8     3     4   \n",
       "2        608      5900          3114       ...          12     12     4     6   \n",
       "3        775      4534          3309       ...          16      9     7     6   \n",
       "4        861      4398          3469       ...          10     11    10     7   \n",
       "5        920      4631          3700       ...          10      5     8    10   \n",
       "6        887      3680          3373       ...           4      5    12     6   \n",
       "7       1070      3609          3889       ...           4      5     2     5   \n",
       "8        861      3228          3230       ...           2      5     4     3   \n",
       "9        766      2683          2847       ...           4      5     4     4   \n",
       "10       682      2159          2492       ...           2      3     4     4   \n",
       "11       575      2052          2188       ...           4      1     0     1   \n",
       "12       723      2278          2624       ...           0      2     4     5   \n",
       "13       619      1767          2180       ...           0      1     1     1   \n",
       "14       639      1843          2368       ...           1      2     0     1   \n",
       "15       629      1753          2152       ...           1      2     2     1   \n",
       "16       565      1500          1834       ...           0      2     2     2   \n",
       "17       535      1421          1763       ...           0      1     0     1   \n",
       "18       492      1642          1951       ...           3      2     2     4   \n",
       "19       399      1182          1371       ...           2      0     2     1   \n",
       "20       487      1347          1746       ...           1      1     1     1   \n",
       "21       208       892           789       ...           1      2     3     2   \n",
       "22       349       819          1157       ...           0      0     0     2   \n",
       "23       305       760          1088       ...           0      0     0     0   \n",
       "24       295       750          1022       ...           0      0     1     1   \n",
       "25       197       520           633       ...           0      0     0     1   \n",
       "26       295       716          1050       ...           0      0     1     4   \n",
       "27       211       619           744       ...           0      0     2     0   \n",
       "28       298       607           992       ...           0      0     0     0   \n",
       "29       174       458           623       ...           0      0     0     1   \n",
       "30       194       430           632       ...           0      0     0     1   \n",
       "..       ...       ...           ...       ...         ...    ...   ...   ...   \n",
       "32       202       492           720       ...           0      1     1     0   \n",
       "33       217       393           662       ...           0      0     0     0   \n",
       "34       158       291           489       ...           0      0     0     0   \n",
       "35       152       419           588       ...           0      1     2     0   \n",
       "36       118       320           410       ...           0      0     0     0   \n",
       "37       110       244           366       ...           0      0     0     0   \n",
       "38       137       285           430       ...           0      0     1     0   \n",
       "39        63       199           241       ...           0      0     0     0   \n",
       "40        90       202           296       ...           0      0     0     0   \n",
       "41        95       216           310       ...           0      0     0     0   \n",
       "42        83       165           221       ...           0      0     0     0   \n",
       "43        78       155           253       ...           0      0     0     0   \n",
       "44        52       139           167       ...           0      0     0     0   \n",
       "45        66       227           308       ...           1      0     3     0   \n",
       "46        44       101           139       ...           0      0     0     0   \n",
       "47        66       181           295       ...           0      0     0     0   \n",
       "48        37        62           117       ...           0      0     0     0   \n",
       "49        37        70           115       ...           0      0     0     0   \n",
       "50        62       145           252       ...           0      0     0     0   \n",
       "51        48       121           183       ...           0      0     0     0   \n",
       "52        37       153           184       ...           0      0     0     1   \n",
       "53        33        71           116       ...           0      0     0     0   \n",
       "54        30        97           131       ...           0      0     0     0   \n",
       "55        41        70           182       ...           0      0     0     0   \n",
       "56        19        36            55       ...           0      0     0     0   \n",
       "57        20        38            66       ...           0      0     0     0   \n",
       "58        15        37            57       ...           0      0     0     0   \n",
       "59        18        51            85       ...           0      0     0     0   \n",
       "60        21        34            65       ...           0      0     0     0   \n",
       "61         0         0             0       ...           0      0     0     0   \n",
       "\n",
       "     T    Debut Since/LastApp BestPosition Goal Difference Winning Percent  \n",
       "1   79     1929          1929            1            2807       59.630702  \n",
       "2   83     1929          1929            1            2786       57.241130  \n",
       "3   56     1929       2002-03            1            1225       47.475134  \n",
       "4   50  1931-32       1987-88            1             929       44.557057  \n",
       "5   49     1929          1929            1             931       43.772629  \n",
       "6   32  1934-35       2001-02            1             307       41.112957  \n",
       "7   16     1929       1994-95            3             280       36.100533  \n",
       "8   19     1929       2010-11            1               2       37.532580  \n",
       "9   18  1939-40       2012-13            2             164       35.146022  \n",
       "10  14  1932-33       2015-16            1             333       35.069444  \n",
       "11  12  1941-42       2014-15            1             136       36.797386  \n",
       "12  11  1939-40       2012-13            4             346       34.511190  \n",
       "13   3  1948-49       2013-14            4             413       31.582538  \n",
       "14   5     1929       2011-12            2             525       31.722689  \n",
       "15   7  1944-45       2015-16            2             399       32.304527  \n",
       "16   6  1935-36       2016-17            4             334       32.321700  \n",
       "17   2  1949-50       2008-09            4             342       31.075697  \n",
       "18  11  1933-34       2000-01            3             309       34.228188  \n",
       "19   5  1960-61       2012-13            3             189       33.704453  \n",
       "20   5  1951-52       2015-16            2             399       33.485401  \n",
       "21   9  1998-99       2013-14            2             103       41.176471  \n",
       "22   2  1941-42       2016-17            6             338       29.380054  \n",
       "23   0  1977-78       2015-16            8             328       28.987730  \n",
       "24   2  1959-60       2014-15            5             272       29.941003  \n",
       "25   1  2004-05       2015-16            6             113       32.236842  \n",
       "26   5  1935-36       2010-11            5             334       29.299363  \n",
       "27   2  1961-62       2009-10            5             125       31.376518  \n",
       "28   0  1940-41       2007-08           11             385       24.744027  \n",
       "29   1  1930-31       2016-17            6             165       32.894737  \n",
       "30   1  1963-64       2015-16            6             202       28.109453  \n",
       "..  ..      ...           ...          ...             ...             ...  \n",
       "32   2  1943-44       1987-88            4             228       30.281690  \n",
       "33   0  1977-78       2005-06           12             269       23.214286  \n",
       "34   0  1987-88       1996-97            7             198       27.745665  \n",
       "35   3  1941-42       1990-91            4             169       30.838323  \n",
       "36   0  1991-92       2004-05            7              90       28.148148  \n",
       "37   0  2007-08       2014-15            8             122       27.192982  \n",
       "38   1  1962-63       2014-15            5             145       29.078014  \n",
       "39   0  1994-95       1997-98           10              42       32.500000  \n",
       "40   0  1978-79       2008-09            8              94       26.881720  \n",
       "41   0  1971-72       1979-80           12              94       28.921569  \n",
       "42   0  1963-64       1969-70            7              56       29.444444  \n",
       "43   0  1999-00       2008-09           17              98       24.342105  \n",
       "44   0  2014-15       2014-15           10              28       30.701754  \n",
       "45   4     1929       1934-35            3              81       33.076923  \n",
       "46   0  1990-91       1992-93            9              38       22.807018  \n",
       "47   0  1947-48       2006-07            7             114       29.310345  \n",
       "48   0  1996-97       1998-99           17              55       25.000000  \n",
       "49   0  1995-96       1997-98           19              45       23.750000  \n",
       "50   0  1945-46       1950-51           10             107       27.777778  \n",
       "51   0  1953-54       1957-58           14              62       32.222222  \n",
       "52   1     1929       1931-32            6              31       29.166667  \n",
       "53   0  1979-80       1980-81           10              45       25.000000  \n",
       "54   0     1929       1930-31            8              34       33.333333  \n",
       "55   0  1950-51       1993-94           16             112       19.117647  \n",
       "56   0  2016-17       2016-17           17              19       21.052632  \n",
       "57   0  2009-10       2009-10           20              28       21.052632  \n",
       "58   0  1956-57       1956-57           16              20       23.333333  \n",
       "59   0  1951-52       1951-52           16              34       23.333333  \n",
       "60   0  1955-56       1955-56           15              31       16.666667  \n",
       "61   0  2017-18       2017-18            9               0             NaN  \n",
       "\n",
       "[61 rows x 22 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "laliga"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "# fill na values\n",
    "laliga.fillna(value=0, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "win=laliga.sort_values('Winning Percent',ascending=False)[:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The top 5 teams which has the highest Winning percentage \n",
      "\n"
     ]
    },
    {
     "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>Pos</th>\n",
       "      <th>Team</th>\n",
       "      <th>Seasons</th>\n",
       "      <th>Points</th>\n",
       "      <th>GamesPlayed</th>\n",
       "      <th>GamesWon</th>\n",
       "      <th>GamesDrawn</th>\n",
       "      <th>GamesLost</th>\n",
       "      <th>GoalsFor</th>\n",
       "      <th>GoalsAgainst</th>\n",
       "      <th>...</th>\n",
       "      <th>Third</th>\n",
       "      <th>Fourth</th>\n",
       "      <th>Fifth</th>\n",
       "      <th>Sixth</th>\n",
       "      <th>T</th>\n",
       "      <th>Debut</th>\n",
       "      <th>Since/LastApp</th>\n",
       "      <th>BestPosition</th>\n",
       "      <th>Goal Difference</th>\n",
       "      <th>Winning Percent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>86</td>\n",
       "      <td>4385</td>\n",
       "      <td>2762</td>\n",
       "      <td>1647</td>\n",
       "      <td>552</td>\n",
       "      <td>563</td>\n",
       "      <td>5947</td>\n",
       "      <td>3140</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>79</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "      <td>2807</td>\n",
       "      <td>59.630702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>86</td>\n",
       "      <td>4262</td>\n",
       "      <td>2762</td>\n",
       "      <td>1581</td>\n",
       "      <td>573</td>\n",
       "      <td>608</td>\n",
       "      <td>5900</td>\n",
       "      <td>3114</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>83</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "      <td>2786</td>\n",
       "      <td>57.241130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Atletico Madrid</td>\n",
       "      <td>80</td>\n",
       "      <td>3442</td>\n",
       "      <td>2614</td>\n",
       "      <td>1241</td>\n",
       "      <td>598</td>\n",
       "      <td>775</td>\n",
       "      <td>4534</td>\n",
       "      <td>3309</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>56</td>\n",
       "      <td>1929</td>\n",
       "      <td>2002-03</td>\n",
       "      <td>1</td>\n",
       "      <td>1225</td>\n",
       "      <td>47.475134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>82</td>\n",
       "      <td>3386</td>\n",
       "      <td>2664</td>\n",
       "      <td>1187</td>\n",
       "      <td>616</td>\n",
       "      <td>861</td>\n",
       "      <td>4398</td>\n",
       "      <td>3469</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>50</td>\n",
       "      <td>1931-32</td>\n",
       "      <td>1987-88</td>\n",
       "      <td>1</td>\n",
       "      <td>929</td>\n",
       "      <td>44.557057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Athletic Bilbao</td>\n",
       "      <td>86</td>\n",
       "      <td>3368</td>\n",
       "      <td>2762</td>\n",
       "      <td>1209</td>\n",
       "      <td>633</td>\n",
       "      <td>920</td>\n",
       "      <td>4631</td>\n",
       "      <td>3700</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>49</td>\n",
       "      <td>1929</td>\n",
       "      <td>1929</td>\n",
       "      <td>1</td>\n",
       "      <td>931</td>\n",
       "      <td>43.772629</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Pos             Team Seasons  Points  GamesPlayed  GamesWon GamesDrawn  \\\n",
       "1   1      Real Madrid      86    4385         2762      1647        552   \n",
       "2   2        Barcelona      86    4262         2762      1581        573   \n",
       "3   3  Atletico Madrid      80    3442         2614      1241        598   \n",
       "4   4         Valencia      82    3386         2664      1187        616   \n",
       "5   5  Athletic Bilbao      86    3368         2762      1209        633   \n",
       "\n",
       "  GamesLost  GoalsFor  GoalsAgainst       ...       Third Fourth Fifth Sixth  \\\n",
       "1       563      5947          3140       ...           8      8     3     4   \n",
       "2       608      5900          3114       ...          12     12     4     6   \n",
       "3       775      4534          3309       ...          16      9     7     6   \n",
       "4       861      4398          3469       ...          10     11    10     7   \n",
       "5       920      4631          3700       ...          10      5     8    10   \n",
       "\n",
       "    T    Debut Since/LastApp BestPosition Goal Difference Winning Percent  \n",
       "1  79     1929          1929            1            2807       59.630702  \n",
       "2  83     1929          1929            1            2786       57.241130  \n",
       "3  56     1929       2002-03            1            1225       47.475134  \n",
       "4  50  1931-32       1987-88            1             929       44.557057  \n",
       "5  49     1929          1929            1             931       43.772629  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print('The top 5 teams which has the highest Winning percentage','\\n')\n",
    "win"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h1>\n",
    "    6) Group teams based on their “Best position” and print the sum of their points for all positions (5 points)\n",
    "Eg: Best Position                Points\n",
    "\n",
    "        1                              25000\n",
    "\n",
    "        2                              7000    \n",
    " </h1>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "laliga['BestPosition'] = laliga['BestPosition'].apply(pd.to_numeric) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('int64')"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "laliga['BestPosition'].dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>Points</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BestPosition</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>27933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1884</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>445</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Points\n",
       "BestPosition        \n",
       "1              27933\n",
       "2               6904\n",
       "3               5221\n",
       "4               6563\n",
       "5               1884\n",
       "6               2113\n",
       "7               1186\n",
       "8               1134\n",
       "9                 96\n",
       "10               450\n",
       "11               445\n",
       "12               511\n",
       "14                71\n",
       "15                14\n",
       "16                81\n",
       "17               266\n",
       "19                81\n",
       "20                34"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grp=laliga[['BestPosition','Points']]\n",
    "q=grp.groupby('BestPosition')\n",
    "q.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}