data_preprocessing/spain league DataPrep.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import zipfile # it is used for reading the zip file without extrating\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "with zipfile.ZipFile(\"matches.zip\") as Z:\n",
    "    with Z.open(\"matches_Spain.json\") as f:\n",
    "        matches_df = pd.read_json(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>status</th>\n",
       "      <th>roundId</th>\n",
       "      <th>gameweek</th>\n",
       "      <th>teamsData</th>\n",
       "      <th>seasonId</th>\n",
       "      <th>dateutc</th>\n",
       "      <th>winner</th>\n",
       "      <th>venue</th>\n",
       "      <th>wyId</th>\n",
       "      <th>label</th>\n",
       "      <th>date</th>\n",
       "      <th>referees</th>\n",
       "      <th>duration</th>\n",
       "      <th>competitionId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Played</td>\n",
       "      <td>4406122</td>\n",
       "      <td>38</td>\n",
       "      <td>{'676': {'scoreET': 0, 'coachId': 92894, 'side...</td>\n",
       "      <td>181144</td>\n",
       "      <td>2018-05-20 18:45:00</td>\n",
       "      <td>676</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>2565922</td>\n",
       "      <td>Barcelona - Real Sociedad, 1 - 0</td>\n",
       "      <td>May 20, 2018 at 8:45:00 PM GMT+2</td>\n",
       "      <td>[{'refereeId': 398931, 'role': 'referee'}, {'r...</td>\n",
       "      <td>Regular</td>\n",
       "      <td>795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Played</td>\n",
       "      <td>4406122</td>\n",
       "      <td>38</td>\n",
       "      <td>{'679': {'scoreET': 0, 'coachId': 3427, 'side'...</td>\n",
       "      <td>181144</td>\n",
       "      <td>2018-05-20 16:30:00</td>\n",
       "      <td>0</td>\n",
       "      <td>Estadio Wanda Metropolitano</td>\n",
       "      <td>2565925</td>\n",
       "      <td>Atl\\u00e9tico Madrid - Eibar, 2 - 2</td>\n",
       "      <td>May 20, 2018 at 6:30:00 PM GMT+2</td>\n",
       "      <td>[{'refereeId': 395056, 'role': 'referee'}, {'r...</td>\n",
       "      <td>Regular</td>\n",
       "      <td>795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Played</td>\n",
       "      <td>4406122</td>\n",
       "      <td>38</td>\n",
       "      <td>{'691': {'scoreET': 0, 'coachId': 444778, 'sid...</td>\n",
       "      <td>181144</td>\n",
       "      <td>2018-05-20 14:15:00</td>\n",
       "      <td>691</td>\n",
       "      <td>San Mam\\u00e9s Barria</td>\n",
       "      <td>2565919</td>\n",
       "      <td>Athletic Club - Espanyol, 0 - 1</td>\n",
       "      <td>May 20, 2018 at 4:15:00 PM GMT+2</td>\n",
       "      <td>[{'refereeId': 384957, 'role': 'referee'}, {'r...</td>\n",
       "      <td>Regular</td>\n",
       "      <td>795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Played</td>\n",
       "      <td>4406122</td>\n",
       "      <td>38</td>\n",
       "      <td>{'674': {'scoreET': 0, 'coachId': 210074, 'sid...</td>\n",
       "      <td>181144</td>\n",
       "      <td>2018-05-20 10:00:00</td>\n",
       "      <td>674</td>\n",
       "      <td>Estadio de Mestalla</td>\n",
       "      <td>2565924</td>\n",
       "      <td>Valencia - Deportivo La Coru\\u00f1a, 2 - 1</td>\n",
       "      <td>May 20, 2018 at 12:00:00 PM GMT+2</td>\n",
       "      <td>[{'refereeId': 398913, 'role': 'referee'}, {'r...</td>\n",
       "      <td>Regular</td>\n",
       "      <td>795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Played</td>\n",
       "      <td>4406122</td>\n",
       "      <td>38</td>\n",
       "      <td>{'675': {'scoreET': 0, 'coachId': 275283, 'sid...</td>\n",
       "      <td>181144</td>\n",
       "      <td>2018-05-19 18:45:00</td>\n",
       "      <td>0</td>\n",
       "      <td>Estadio de la Cer\\u00e1mica</td>\n",
       "      <td>2565927</td>\n",
       "      <td>Villarreal - Real Madrid, 2 - 2</td>\n",
       "      <td>May 19, 2018 at 8:45:00 PM GMT+2</td>\n",
       "      <td>[{'refereeId': 395085, 'role': 'referee'}, {'r...</td>\n",
       "      <td>Regular</td>\n",
       "      <td>795</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>375</th>\n",
       "      <td>Played</td>\n",
       "      <td>4406122</td>\n",
       "      <td>1</td>\n",
       "      <td>{'691': {'scoreET': 0, 'coachId': 169425, 'sid...</td>\n",
       "      <td>181144</td>\n",
       "      <td>2017-08-19 20:15:00</td>\n",
       "      <td>0</td>\n",
       "      <td>Estadio Ram\\u00f3n S\\u00e1nchez Pizju\\u00e1n</td>\n",
       "      <td>2565552</td>\n",
       "      <td>Sevilla - Espanyol, 1 - 1</td>\n",
       "      <td>August 19, 2017 at 10:15:00 PM GMT+2</td>\n",
       "      <td>[{'refereeId': 378950, 'role': 'referee'}, {'r...</td>\n",
       "      <td>Regular</td>\n",
       "      <td>795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>Played</td>\n",
       "      <td>4406122</td>\n",
       "      <td>1</td>\n",
       "      <td>{'756': {'scoreET': 0, 'coachId': 167044, 'sid...</td>\n",
       "      <td>181144</td>\n",
       "      <td>2017-08-19 18:15:00</td>\n",
       "      <td>0</td>\n",
       "      <td>Estadi Municipal de Montilivi</td>\n",
       "      <td>2565551</td>\n",
       "      <td>Girona - Atl\\u00e9tico Madrid, 2 - 2</td>\n",
       "      <td>August 19, 2017 at 8:15:00 PM GMT+2</td>\n",
       "      <td>[{'refereeId': 378994, 'role': 'referee'}, {'r...</td>\n",
       "      <td>Regular</td>\n",
       "      <td>795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>Played</td>\n",
       "      <td>4406122</td>\n",
       "      <td>1</td>\n",
       "      <td>{'692': {'scoreET': 0, 'coachId': 3880, 'side'...</td>\n",
       "      <td>181144</td>\n",
       "      <td>2017-08-19 16:15:00</td>\n",
       "      <td>687</td>\n",
       "      <td>Estadio de Bala\\u00eddos</td>\n",
       "      <td>2565549</td>\n",
       "      <td>Celta de Vigo - Real Sociedad, 2 - 3</td>\n",
       "      <td>August 19, 2017 at 6:15:00 PM GMT+2</td>\n",
       "      <td>[{'refereeId': 384946, 'role': 'referee'}, {'r...</td>\n",
       "      <td>Regular</td>\n",
       "      <td>795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>Played</td>\n",
       "      <td>4406122</td>\n",
       "      <td>1</td>\n",
       "      <td>{'674': {'scoreET': 0, 'coachId': 210074, 'sid...</td>\n",
       "      <td>181144</td>\n",
       "      <td>2017-08-18 20:15:00</td>\n",
       "      <td>674</td>\n",
       "      <td>Estadio de Mestalla</td>\n",
       "      <td>2565556</td>\n",
       "      <td>Valencia - Las Palmas, 1 - 0</td>\n",
       "      <td>August 18, 2017 at 10:15:00 PM GMT+2</td>\n",
       "      <td>[{'refereeId': 381927, 'role': 'referee'}, {'r...</td>\n",
       "      <td>Regular</td>\n",
       "      <td>795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <td>Played</td>\n",
       "      <td>4406122</td>\n",
       "      <td>1</td>\n",
       "      <td>{'696': {'scoreET': 0, 'coachId': 117648, 'sid...</td>\n",
       "      <td>181144</td>\n",
       "      <td>2017-08-18 18:15:00</td>\n",
       "      <td>712</td>\n",
       "      <td>Estadio Municipal de Butarque</td>\n",
       "      <td>2565557</td>\n",
       "      <td>Legan\\u00e9s - Deportivo Alav\\u00e9s, 1 - 0</td>\n",
       "      <td>August 18, 2017 at 8:15:00 PM GMT+2</td>\n",
       "      <td>[{'refereeId': 398931, 'role': 'referee'}, {'r...</td>\n",
       "      <td>Regular</td>\n",
       "      <td>795</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>380 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     status  roundId  gameweek  \\\n",
       "0    Played  4406122        38   \n",
       "1    Played  4406122        38   \n",
       "2    Played  4406122        38   \n",
       "3    Played  4406122        38   \n",
       "4    Played  4406122        38   \n",
       "..      ...      ...       ...   \n",
       "375  Played  4406122         1   \n",
       "376  Played  4406122         1   \n",
       "377  Played  4406122         1   \n",
       "378  Played  4406122         1   \n",
       "379  Played  4406122         1   \n",
       "\n",
       "                                             teamsData  seasonId  \\\n",
       "0    {'676': {'scoreET': 0, 'coachId': 92894, 'side...    181144   \n",
       "1    {'679': {'scoreET': 0, 'coachId': 3427, 'side'...    181144   \n",
       "2    {'691': {'scoreET': 0, 'coachId': 444778, 'sid...    181144   \n",
       "3    {'674': {'scoreET': 0, 'coachId': 210074, 'sid...    181144   \n",
       "4    {'675': {'scoreET': 0, 'coachId': 275283, 'sid...    181144   \n",
       "..                                                 ...       ...   \n",
       "375  {'691': {'scoreET': 0, 'coachId': 169425, 'sid...    181144   \n",
       "376  {'756': {'scoreET': 0, 'coachId': 167044, 'sid...    181144   \n",
       "377  {'692': {'scoreET': 0, 'coachId': 3880, 'side'...    181144   \n",
       "378  {'674': {'scoreET': 0, 'coachId': 210074, 'sid...    181144   \n",
       "379  {'696': {'scoreET': 0, 'coachId': 117648, 'sid...    181144   \n",
       "\n",
       "                 dateutc  winner  \\\n",
       "0    2018-05-20 18:45:00     676   \n",
       "1    2018-05-20 16:30:00       0   \n",
       "2    2018-05-20 14:15:00     691   \n",
       "3    2018-05-20 10:00:00     674   \n",
       "4    2018-05-19 18:45:00       0   \n",
       "..                   ...     ...   \n",
       "375  2017-08-19 20:15:00       0   \n",
       "376  2017-08-19 18:15:00       0   \n",
       "377  2017-08-19 16:15:00     687   \n",
       "378  2017-08-18 20:15:00     674   \n",
       "379  2017-08-18 18:15:00     712   \n",
       "\n",
       "                                            venue     wyId  \\\n",
       "0                                        Camp Nou  2565922   \n",
       "1                     Estadio Wanda Metropolitano  2565925   \n",
       "2                           San Mam\\u00e9s Barria  2565919   \n",
       "3                             Estadio de Mestalla  2565924   \n",
       "4                     Estadio de la Cer\\u00e1mica  2565927   \n",
       "..                                            ...      ...   \n",
       "375  Estadio Ram\\u00f3n S\\u00e1nchez Pizju\\u00e1n  2565552   \n",
       "376                 Estadi Municipal de Montilivi  2565551   \n",
       "377                      Estadio de Bala\\u00eddos  2565549   \n",
       "378                           Estadio de Mestalla  2565556   \n",
       "379                 Estadio Municipal de Butarque  2565557   \n",
       "\n",
       "                                           label  \\\n",
       "0               Barcelona - Real Sociedad, 1 - 0   \n",
       "1            Atl\\u00e9tico Madrid - Eibar, 2 - 2   \n",
       "2                Athletic Club - Espanyol, 0 - 1   \n",
       "3     Valencia - Deportivo La Coru\\u00f1a, 2 - 1   \n",
       "4                Villarreal - Real Madrid, 2 - 2   \n",
       "..                                           ...   \n",
       "375                    Sevilla - Espanyol, 1 - 1   \n",
       "376         Girona - Atl\\u00e9tico Madrid, 2 - 2   \n",
       "377         Celta de Vigo - Real Sociedad, 2 - 3   \n",
       "378                 Valencia - Las Palmas, 1 - 0   \n",
       "379  Legan\\u00e9s - Deportivo Alav\\u00e9s, 1 - 0   \n",
       "\n",
       "                                     date  \\\n",
       "0        May 20, 2018 at 8:45:00 PM GMT+2   \n",
       "1        May 20, 2018 at 6:30:00 PM GMT+2   \n",
       "2        May 20, 2018 at 4:15:00 PM GMT+2   \n",
       "3       May 20, 2018 at 12:00:00 PM GMT+2   \n",
       "4        May 19, 2018 at 8:45:00 PM GMT+2   \n",
       "..                                    ...   \n",
       "375  August 19, 2017 at 10:15:00 PM GMT+2   \n",
       "376   August 19, 2017 at 8:15:00 PM GMT+2   \n",
       "377   August 19, 2017 at 6:15:00 PM GMT+2   \n",
       "378  August 18, 2017 at 10:15:00 PM GMT+2   \n",
       "379   August 18, 2017 at 8:15:00 PM GMT+2   \n",
       "\n",
       "                                              referees duration  competitionId  \n",
       "0    [{'refereeId': 398931, 'role': 'referee'}, {'r...  Regular            795  \n",
       "1    [{'refereeId': 395056, 'role': 'referee'}, {'r...  Regular            795  \n",
       "2    [{'refereeId': 384957, 'role': 'referee'}, {'r...  Regular            795  \n",
       "3    [{'refereeId': 398913, 'role': 'referee'}, {'r...  Regular            795  \n",
       "4    [{'refereeId': 395085, 'role': 'referee'}, {'r...  Regular            795  \n",
       "..                                                 ...      ...            ...  \n",
       "375  [{'refereeId': 378950, 'role': 'referee'}, {'r...  Regular            795  \n",
       "376  [{'refereeId': 378994, 'role': 'referee'}, {'r...  Regular            795  \n",
       "377  [{'refereeId': 384946, 'role': 'referee'}, {'r...  Regular            795  \n",
       "378  [{'refereeId': 381927, 'role': 'referee'}, {'r...  Regular            795  \n",
       "379  [{'refereeId': 398931, 'role': 'referee'}, {'r...  Regular            795  \n",
       "\n",
       "[380 rows x 14 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "#weekly points\n",
    "\n",
    "point_data = list()\n",
    "for i in range(len(matches_df)):\n",
    "    gameweek = matches_df.iloc[i].gameweek# iloc is used for the locating data in a data frame\n",
    "    label = matches_df.iloc[i].label\n",
    "    match_id = matches_df.iloc[i].wyId\n",
    "    \n",
    "    score = label.split(\",\")[1]\n",
    "    b = score.split(\"-\")\n",
    "    c = [int(i) for i in b]\n",
    "    diff = c[0] - c[1]\n",
    "    \n",
    "    [[home_team, away_team], [home_score, away_score]] = [[o.strip() for o in s.split('-')] for s in label.split(',')]# here we have converted the label column into a nested list, od home team/away team . HOme score and Away score \n",
    "    home_score = int(home_score)\n",
    "    away_score = int(away_score)\n",
    "    if home_score > away_score:# we have identified the winner /looser and Draw\n",
    "        home_point = 3\n",
    "        away_point = 0\n",
    "    if away_score > home_score:\n",
    "        away_point = 3\n",
    "        home_point = 0\n",
    "    if away_score == home_score:\n",
    "        home_point = 1\n",
    "        away_point = 1\n",
    "    point_data.append([gameweek, home_team, home_point,label,match_id,diff]) #here we have summarize the team with week and point all together\n",
    "    point_data.append([gameweek, away_team, away_point,label,match_id,-diff])\n",
    "point_df = pd.DataFrame(point_data, columns=['gameweek', 'team', 'point','label','matchId','tempgd'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "weeks = np.sort(point_df.gameweek.unique())\n",
    "teams = point_df.team.unique()\n",
    "points_cp = pd.DataFrame([])\n",
    "\n",
    "for team in teams:\n",
    "    t1 = point_df[point_df.team == team]\n",
    "    cumP = {}\n",
    "    cumgd ={}\n",
    "    t1 = t1.sort_values(by=['gameweek'])\n",
    "    for week in weeks:\n",
    "        if week == 1:\n",
    "            cumP[week] = int(t1[t1.gameweek == 1]['point'])\n",
    "            cumgd[week] = int(t1[t1.gameweek == 1]['tempgd'])\n",
    "        else:\n",
    "            cumP[week] = int(t1[t1.gameweek == week]['point']) + cumP.get(week -1) \n",
    "            cumgd[week] = int(t1[t1.gameweek == week]['tempgd']) + cumgd.get(week -1)\n",
    "    \n",
    "    t1['cummPoints'] = t1.apply(lambda x : cumP.get(x.gameweek),axis =1)\n",
    "    t1['gd'] = t1.apply(lambda x : cumgd.get(x.gameweek),axis =1)\n",
    "#     print(t1)\n",
    "    points_cp = points_cp.append(t1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "weekly_points = pd.DataFrame()\n",
    "for week in weeks:\n",
    "    t1 = points_cp[points_cp.gameweek == week]\n",
    "    t2 =t1.sort_values(by=['cummPoints','gd'],ascending=False)\n",
    "    t2['rank'] = [i for i in range(1,t2.shape[0]+1)]\n",
    "    weekly_points = weekly_points.append(t2)"
   ]
  },
  {
   "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>gameweek</th>\n",
       "      <th>team</th>\n",
       "      <th>point</th>\n",
       "      <th>label</th>\n",
       "      <th>matchId</th>\n",
       "      <th>tempgd</th>\n",
       "      <th>cummPoints</th>\n",
       "      <th>gd</th>\n",
       "      <th>rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>745</th>\n",
       "      <td>1</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>3</td>\n",
       "      <td>Deportivo La Coru\\u00f1a - Real Madrid, 0 - 3</td>\n",
       "      <td>2565555</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>746</th>\n",
       "      <td>1</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>3</td>\n",
       "      <td>Barcelona - Real Betis, 2 - 0</td>\n",
       "      <td>2565554</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>755</th>\n",
       "      <td>1</td>\n",
       "      <td>Real Sociedad</td>\n",
       "      <td>3</td>\n",
       "      <td>Celta de Vigo - Real Sociedad, 2 - 3</td>\n",
       "      <td>2565549</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>741</th>\n",
       "      <td>1</td>\n",
       "      <td>Eibar</td>\n",
       "      <td>3</td>\n",
       "      <td>M\\u00e1laga - Eibar, 0 - 1</td>\n",
       "      <td>2565553</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>756</th>\n",
       "      <td>1</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>3</td>\n",
       "      <td>Valencia - Las Palmas, 1 - 0</td>\n",
       "      <td>2565556</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>38</td>\n",
       "      <td>Athletic Club</td>\n",
       "      <td>0</td>\n",
       "      <td>Athletic Club - Espanyol, 0 - 1</td>\n",
       "      <td>2565919</td>\n",
       "      <td>-1</td>\n",
       "      <td>43</td>\n",
       "      <td>-8</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>38</td>\n",
       "      <td>Legan\\u00e9s</td>\n",
       "      <td>3</td>\n",
       "      <td>Legan\\u00e9s - Real Betis, 3 - 2</td>\n",
       "      <td>2565926</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>-17</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>38</td>\n",
       "      <td>Deportivo La Coru\\u00f1a</td>\n",
       "      <td>0</td>\n",
       "      <td>Valencia - Deportivo La Coru\\u00f1a, 2 - 1</td>\n",
       "      <td>2565924</td>\n",
       "      <td>-1</td>\n",
       "      <td>29</td>\n",
       "      <td>-38</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>38</td>\n",
       "      <td>Las Palmas</td>\n",
       "      <td>0</td>\n",
       "      <td>Las Palmas - Girona, 1 - 2</td>\n",
       "      <td>2565923</td>\n",
       "      <td>-1</td>\n",
       "      <td>22</td>\n",
       "      <td>-50</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>38</td>\n",
       "      <td>M\\u00e1laga</td>\n",
       "      <td>0</td>\n",
       "      <td>M\\u00e1laga - Getafe, 0 - 1</td>\n",
       "      <td>2565921</td>\n",
       "      <td>-1</td>\n",
       "      <td>20</td>\n",
       "      <td>-37</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>760 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     gameweek                      team  point  \\\n",
       "745         1               Real Madrid      3   \n",
       "746         1                 Barcelona      3   \n",
       "755         1             Real Sociedad      3   \n",
       "741         1                     Eibar      3   \n",
       "756         1                  Valencia      3   \n",
       "..        ...                       ...    ...   \n",
       "4          38             Athletic Club      0   \n",
       "16         38              Legan\\u00e9s      3   \n",
       "7          38  Deportivo La Coru\\u00f1a      0   \n",
       "14         38                Las Palmas      0   \n",
       "12         38               M\\u00e1laga      0   \n",
       "\n",
       "                                             label  matchId  tempgd  \\\n",
       "745  Deportivo La Coru\\u00f1a - Real Madrid, 0 - 3  2565555       3   \n",
       "746                  Barcelona - Real Betis, 2 - 0  2565554       2   \n",
       "755           Celta de Vigo - Real Sociedad, 2 - 3  2565549       1   \n",
       "741                     M\\u00e1laga - Eibar, 0 - 1  2565553       1   \n",
       "756                   Valencia - Las Palmas, 1 - 0  2565556       1   \n",
       "..                                             ...      ...     ...   \n",
       "4                  Athletic Club - Espanyol, 0 - 1  2565919      -1   \n",
       "16                Legan\\u00e9s - Real Betis, 3 - 2  2565926       1   \n",
       "7       Valencia - Deportivo La Coru\\u00f1a, 2 - 1  2565924      -1   \n",
       "14                      Las Palmas - Girona, 1 - 2  2565923      -1   \n",
       "12                     M\\u00e1laga - Getafe, 0 - 1  2565921      -1   \n",
       "\n",
       "     cummPoints  gd  rank  \n",
       "745           3   3     1  \n",
       "746           3   2     2  \n",
       "755           3   1     3  \n",
       "741           3   1     4  \n",
       "756           3   1     5  \n",
       "..          ...  ..   ...  \n",
       "4            43  -8    16  \n",
       "16           43 -17    17  \n",
       "7            29 -38    18  \n",
       "14           22 -50    19  \n",
       "12           20 -37    20  \n",
       "\n",
       "[760 rows x 9 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weekly_points"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# for cur_index, item in enumerate(team):\n",
    "#     if item == 'Atl\\\\u00e9tico Madrid':\n",
    "#         team[cur_index]='Atletico Madrid'\n",
    "#     if item == 'Deportivo La Coru\\\\u00f1a':\n",
    "#         team[cur_index]='Deportivo La Coruna'\n",
    "#     if item == 'Deportivo Alav\\\\u00e9s':\n",
    "#         team[cur_index]='Deportivo Alaves'\n",
    "#     if item == 'M\\\\u00e1laga':\n",
    "#         team[cur_index]='Malaga'\n",
    "#     if item == 'Legan\\\\u00e9s':\n",
    "#         team[cur_index]='Leganes'\n",
    "\n",
    "# for cur_index, item in enumerate(home_team):\n",
    "#     if item == 'Atl\\\\u00e9tico Madrid':\n",
    "#         home_team[cur_index]='Atletico Madrid'\n",
    "#     if item == 'Deportivo La Coru\\\\u00f1a':\n",
    "#         home_team[cur_index]='Deportivo La Coruna'\n",
    "#     if item == 'Deportivo Alav\\\\u00e9s':\n",
    "#         home_team[cur_index]='Deportivo Alaves'\n",
    "#     if item == 'M\\\\u00e1laga':\n",
    "#         home_team[cur_index]='Malaga'\n",
    "#     if item == 'Legan\\\\u00e9s':\n",
    "#         home_team[cur_index]='Leganes'\n",
    "    \n",
    "# for cur_index, item in enumerate(away_team):\n",
    "#     if item == 'Atl\\\\u00e9tico Madrid':\n",
    "#         away_team[cur_index]='Atletico Madrid'\n",
    "#     if item == 'Deportivo La Coru\\\\u00f1a':\n",
    "#         away_team[cur_index]='Deportivo La Coruna'\n",
    "#     if item == 'Deportivo Alav\\\\u00e9s':\n",
    "#         away_team[cur_index]='Deportivo Alaves'\n",
    "#     if item == 'M\\\\u00e1laga':\n",
    "#         away_team[cur_index]='Malaga'\n",
    "#     if item == 'Legan\\\\u00e9s':\n",
    "#         away_team[cur_index]='Leganes'"
   ]
  },
  {
   "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>gameweek</th>\n",
       "      <th>team</th>\n",
       "      <th>point</th>\n",
       "      <th>label</th>\n",
       "      <th>matchId</th>\n",
       "      <th>tempgd</th>\n",
       "      <th>cummPoints</th>\n",
       "      <th>gd</th>\n",
       "      <th>rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>745</th>\n",
       "      <td>1</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>3</td>\n",
       "      <td>Deportivo La Coru\\u00f1a - Real Madrid, 0 - 3</td>\n",
       "      <td>2565555</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>746</th>\n",
       "      <td>1</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>3</td>\n",
       "      <td>Barcelona - Real Betis, 2 - 0</td>\n",
       "      <td>2565554</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>755</th>\n",
       "      <td>1</td>\n",
       "      <td>Real Sociedad</td>\n",
       "      <td>3</td>\n",
       "      <td>Celta de Vigo - Real Sociedad, 2 - 3</td>\n",
       "      <td>2565549</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>741</th>\n",
       "      <td>1</td>\n",
       "      <td>Eibar</td>\n",
       "      <td>3</td>\n",
       "      <td>M\\u00e1laga - Eibar, 0 - 1</td>\n",
       "      <td>2565553</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>756</th>\n",
       "      <td>1</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>3</td>\n",
       "      <td>Valencia - Las Palmas, 1 - 0</td>\n",
       "      <td>2565556</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>38</td>\n",
       "      <td>Athletic Club</td>\n",
       "      <td>0</td>\n",
       "      <td>Athletic Club - Espanyol, 0 - 1</td>\n",
       "      <td>2565919</td>\n",
       "      <td>-1</td>\n",
       "      <td>43</td>\n",
       "      <td>-8</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>38</td>\n",
       "      <td>Legan\\u00e9s</td>\n",
       "      <td>3</td>\n",
       "      <td>Legan\\u00e9s - Real Betis, 3 - 2</td>\n",
       "      <td>2565926</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>-17</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>38</td>\n",
       "      <td>Deportivo La Coru\\u00f1a</td>\n",
       "      <td>0</td>\n",
       "      <td>Valencia - Deportivo La Coru\\u00f1a, 2 - 1</td>\n",
       "      <td>2565924</td>\n",
       "      <td>-1</td>\n",
       "      <td>29</td>\n",
       "      <td>-38</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>38</td>\n",
       "      <td>Las Palmas</td>\n",
       "      <td>0</td>\n",
       "      <td>Las Palmas - Girona, 1 - 2</td>\n",
       "      <td>2565923</td>\n",
       "      <td>-1</td>\n",
       "      <td>22</td>\n",
       "      <td>-50</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>38</td>\n",
       "      <td>M\\u00e1laga</td>\n",
       "      <td>0</td>\n",
       "      <td>M\\u00e1laga - Getafe, 0 - 1</td>\n",
       "      <td>2565921</td>\n",
       "      <td>-1</td>\n",
       "      <td>20</td>\n",
       "      <td>-37</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>760 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     gameweek                      team  point  \\\n",
       "745         1               Real Madrid      3   \n",
       "746         1                 Barcelona      3   \n",
       "755         1             Real Sociedad      3   \n",
       "741         1                     Eibar      3   \n",
       "756         1                  Valencia      3   \n",
       "..        ...                       ...    ...   \n",
       "4          38             Athletic Club      0   \n",
       "16         38              Legan\\u00e9s      3   \n",
       "7          38  Deportivo La Coru\\u00f1a      0   \n",
       "14         38                Las Palmas      0   \n",
       "12         38               M\\u00e1laga      0   \n",
       "\n",
       "                                             label  matchId  tempgd  \\\n",
       "745  Deportivo La Coru\\u00f1a - Real Madrid, 0 - 3  2565555       3   \n",
       "746                  Barcelona - Real Betis, 2 - 0  2565554       2   \n",
       "755           Celta de Vigo - Real Sociedad, 2 - 3  2565549       1   \n",
       "741                     M\\u00e1laga - Eibar, 0 - 1  2565553       1   \n",
       "756                   Valencia - Las Palmas, 1 - 0  2565556       1   \n",
       "..                                             ...      ...     ...   \n",
       "4                  Athletic Club - Espanyol, 0 - 1  2565919      -1   \n",
       "16                Legan\\u00e9s - Real Betis, 3 - 2  2565926       1   \n",
       "7       Valencia - Deportivo La Coru\\u00f1a, 2 - 1  2565924      -1   \n",
       "14                      Las Palmas - Girona, 1 - 2  2565923      -1   \n",
       "12                     M\\u00e1laga - Getafe, 0 - 1  2565921      -1   \n",
       "\n",
       "     cummPoints  gd  rank  \n",
       "745           3   3     1  \n",
       "746           3   2     2  \n",
       "755           3   1     3  \n",
       "741           3   1     4  \n",
       "756           3   1     5  \n",
       "..          ...  ..   ...  \n",
       "4            43  -8    16  \n",
       "16           43 -17    17  \n",
       "7            29 -38    18  \n",
       "14           22 -50    19  \n",
       "12           20 -37    20  \n",
       "\n",
       "[760 rows x 9 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weekly_points."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(760, 9)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weekly_points.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [],
   "source": [
    "updated_df = pd.DataFrame(columns = weekly_points.columns)\n",
    "for index,row in weekly_points.iterrows():\n",
    "#     print(row.team.split(\",\")[0].split(\"-\"))\n",
    "#     print(correct_team_name(row.team))\n",
    "    row.team = correct_team_name(row.team)\n",
    "    row.label = correct_labels(row.label)\n",
    "    updated_df = updated_df.append(row)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "updated_df = updated_df.sort_values(by=[\"team\",'gameweek'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "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>gameweek</th>\n",
       "      <th>team</th>\n",
       "      <th>point</th>\n",
       "      <th>label</th>\n",
       "      <th>matchId</th>\n",
       "      <th>tempgd</th>\n",
       "      <th>cummPoints</th>\n",
       "      <th>gd</th>\n",
       "      <th>rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>748</th>\n",
       "      <td>1</td>\n",
       "      <td>Athletic Club</td>\n",
       "      <td>1</td>\n",
       "      <td>Athletic Club-Getafe, 0 - 0</td>\n",
       "      <td>2565550</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>727</th>\n",
       "      <td>2</td>\n",
       "      <td>Athletic Club</td>\n",
       "      <td>3</td>\n",
       "      <td>Eibar-Athletic Club, 0 - 1</td>\n",
       "      <td>2565567</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>706</th>\n",
       "      <td>3</td>\n",
       "      <td>Athletic Club</td>\n",
       "      <td>3</td>\n",
       "      <td>Athletic Club-Girona, 2 - 0</td>\n",
       "      <td>2565574</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>685</th>\n",
       "      <td>4</td>\n",
       "      <td>Athletic Club</td>\n",
       "      <td>0</td>\n",
       "      <td>Las Palmas-Athletic Club, 1 - 0</td>\n",
       "      <td>2565578</td>\n",
       "      <td>-1</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>672</th>\n",
       "      <td>5</td>\n",
       "      <td>Athletic Club</td>\n",
       "      <td>0</td>\n",
       "      <td>Athletic Club-Atletico Madrid, 1 - 2</td>\n",
       "      <td>2565589</td>\n",
       "      <td>-1</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>34</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>0</td>\n",
       "      <td>Barcelona-Villarreal, 5 - 1</td>\n",
       "      <td>2565884</td>\n",
       "      <td>-4</td>\n",
       "      <td>51</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>35</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>3</td>\n",
       "      <td>Villarreal-Celta de Vigo, 4 - 1</td>\n",
       "      <td>2565888</td>\n",
       "      <td>3</td>\n",
       "      <td>54</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>36</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>3</td>\n",
       "      <td>Villarreal-Valencia, 1 - 0</td>\n",
       "      <td>2565901</td>\n",
       "      <td>1</td>\n",
       "      <td>57</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>37</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>3</td>\n",
       "      <td>Deportivo La Coruna-Villarreal, 2 - 4</td>\n",
       "      <td>2565911</td>\n",
       "      <td>2</td>\n",
       "      <td>60</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>38</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>1</td>\n",
       "      <td>Villarreal-Real Madrid, 2 - 2</td>\n",
       "      <td>2565927</td>\n",
       "      <td>0</td>\n",
       "      <td>61</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>760 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    gameweek           team point                                  label  \\\n",
       "748        1  Athletic Club     1            Athletic Club-Getafe, 0 - 0   \n",
       "727        2  Athletic Club     3             Eibar-Athletic Club, 0 - 1   \n",
       "706        3  Athletic Club     3            Athletic Club-Girona, 2 - 0   \n",
       "685        4  Athletic Club     0        Las Palmas-Athletic Club, 1 - 0   \n",
       "672        5  Athletic Club     0   Athletic Club-Atletico Madrid, 1 - 2   \n",
       "..       ...            ...   ...                                    ...   \n",
       "43        34     Villarreal     0            Barcelona-Villarreal, 5 - 1   \n",
       "74        35     Villarreal     3        Villarreal-Celta de Vigo, 4 - 1   \n",
       "54        36     Villarreal     3             Villarreal-Valencia, 1 - 0   \n",
       "31        37     Villarreal     3  Deportivo La Coruna-Villarreal, 2 - 4   \n",
       "8         38     Villarreal     1          Villarreal-Real Madrid, 2 - 2   \n",
       "\n",
       "     matchId tempgd cummPoints gd rank  \n",
       "748  2565550      0          1  0    9  \n",
       "727  2565567      1          4  1    6  \n",
       "706  2565574      2          7  3    4  \n",
       "685  2565578     -1          7  2    6  \n",
       "672  2565589     -1          7  1    9  \n",
       "..       ...    ...        ... ..  ...  \n",
       "43   2565884     -4         51  1    6  \n",
       "74   2565888      3         54  4    6  \n",
       "54   2565901      1         57  5    6  \n",
       "31   2565911      2         60  7    5  \n",
       "8    2565927      0         61  7    5  \n",
       "\n",
       "[760 rows x 9 columns]"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "updated_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [],
   "source": [
    "updated_df.to_csv(\"spainLeague.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "# set(updated_df.label.tolist())\n",
    "# .split(\",\").split(\"-\").unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'x' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-51-fa1812046d81>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mset\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mcorrect_team_name\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0my\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mfor\u001b[0m \u001b[0my\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mx\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0msplit\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\",\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0msplit\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"-\"\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mfor\u001b[0m \u001b[0mx\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mupdated_df\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mlabel\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m: name 'x' is not defined"
     ]
    }
   ],
   "source": [
    "set([correct_team_name(y) for y in x.split(\",\")[0].split(\"-\") for x in updated_df.label])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "sequence item 0: expected str instance, list found",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-61-d21c68ceb5bd>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[1;34m\",\"\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mjoin\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mteam_test\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mx\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mfor\u001b[0m \u001b[0mx\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mupdated_df\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mlabel\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mTypeError\u001b[0m: sequence item 0: expected str instance, list found"
     ]
    }
   ],
   "source": [
    "\",\".join([team_test(x) for x in updated_df.label])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "list2d = ([team_test(x) for x in updated_df.label])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{' Athletic Club',\n",
       " ' Atl\\\\u00e9tico Madrid',\n",
       " ' Barcelona',\n",
       " ' Celta de Vigo',\n",
       " ' Deportivo Alav\\\\u00e9s',\n",
       " ' Deportivo La Coru\\\\u00f1a',\n",
       " ' Eibar',\n",
       " ' Espanyol',\n",
       " ' Getafe',\n",
       " ' Girona',\n",
       " ' Las Palmas',\n",
       " ' Legan\\\\u00e9s',\n",
       " ' Levante',\n",
       " ' M\\\\u00e1laga',\n",
       " ' Real Betis',\n",
       " ' Real Madrid',\n",
       " ' Real Sociedad',\n",
       " ' Sevilla',\n",
       " ' Valencia',\n",
       " ' Villarreal',\n",
       " 'Athletic Club ',\n",
       " 'Atl\\\\u00e9tico Madrid ',\n",
       " 'Barcelona ',\n",
       " 'Celta de Vigo ',\n",
       " 'Deportivo Alav\\\\u00e9s ',\n",
       " 'Deportivo La Coru\\\\u00f1a ',\n",
       " 'Eibar ',\n",
       " 'Espanyol ',\n",
       " 'Getafe ',\n",
       " 'Girona ',\n",
       " 'Las Palmas ',\n",
       " 'Legan\\\\u00e9s ',\n",
       " 'Levante ',\n",
       " 'M\\\\u00e1laga ',\n",
       " 'Real Betis ',\n",
       " 'Real Madrid ',\n",
       " 'Real Sociedad ',\n",
       " 'Sevilla ',\n",
       " 'Valencia ',\n",
       " 'Villarreal '}"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import itertools\n",
    "# list2d = [[1,2,3], [4,5,6], [7], [8,9]]\n",
    "merged = list(itertools.chain(*list2d))\n",
    "set(merged)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "def team_test(x):\n",
    "    t = x.split(\",\")\n",
    "    return [correct_team_name(x) for x in t[0].split(\"-\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "def correct_team_name(name):\n",
    "    team=name.strip()\n",
    "    if (team == 'Atl\\\\u00e9tico Madrid') :\n",
    "        team='Atletico Madrid'\n",
    "    if team == 'Deportivo La Coru\\\\u00f1a':\n",
    "        team='Deportivo La Coruna'\n",
    "    if team == 'Deportivo Alav\\\\u00e9s':\n",
    "        team='Deportivo Alaves'\n",
    "    if team == 'M\\\\u00e1laga':\n",
    "        team='Malaga'\n",
    "    if team == 'Legan\\\\u00e9s':\n",
    "        team='Leganes'\n",
    "        \n",
    "    return team"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "def correct_labels(label):\n",
    "    temp = label.split(\",\")\n",
    "    temp[0] = \"-\".join([correct_team_name(x) for x in temp[0].split(\"-\")])\n",
    "    return \",\".join(temp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "s =\"M\\u00e1laga - Getafe, 0 - 1\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Málaga - Getafe, 0 - 1'"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Málaga - Getafe', ' 0 - 1']"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a = s.split(\",\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "a = s.split(\",\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "a[0] = \"-\".join([correct_team_name(x) for x in a[0].split(\"-\")])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Málaga - Getafe, 0 - 1'"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\",\".join(a)"
   ]
  },
  {
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}