02.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from sklearn.tree import DecisionTreeClassifier\n",
    "from sklearn.metrics import accuracy_score\n",
    "from sklearn import tree\n",
    "from subprocess import call"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# load CSV files\n",
    "league = 'spanish'\n",
    "\n",
    "df = None\n",
    "files = os.listdir(f'fulldata/{league}')\n",
    "files.sort()\n",
    "for file in files:\n",
    "    year = int(file.strip('.csv'))\n",
    "    df_year = pd.read_csv(f'fulldata/{league}/' + file)\n",
    "    df_year['Year'] = year\n",
    "    df_year['Match'] = df_year.index + 1\n",
    "\n",
    "    if df is None:\n",
    "        df = df_year\n",
    "    else:\n",
    "        df = df.append(df_year, ignore_index=True, sort=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Alaves prediction accuracy is  41.17647058823529\n",
      "Ath Bilbao prediction accuracy is  27.77777777777778\n",
      "Ath Madrid prediction accuracy is  55.55555555555556\n",
      "Barcelona prediction accuracy is  61.111111111111114\n",
      "Betis prediction accuracy is  33.33333333333333\n",
      "Celta prediction accuracy is  33.33333333333333\n",
      "Eibar prediction accuracy is  25.0\n",
      "Espanol prediction accuracy is  38.88888888888889\n",
      "Getafe prediction accuracy is  38.23529411764706\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/vachara/anaconda3/lib/python3.6/site-packages/numpy/lib/function_base.py:1128: RuntimeWarning: Mean of empty slice.\n",
      "  avg = a.mean(axis)\n",
      "/home/vachara/anaconda3/lib/python3.6/site-packages/numpy/core/_methods.py:80: RuntimeWarning: invalid value encountered in double_scalars\n",
      "  ret = ret.dtype.type(ret / rcount)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Girona prediction accuracy is  nan\n",
      "La Coruna prediction accuracy is  36.11111111111111\n",
      "Las Palmas prediction accuracy is  41.66666666666667\n",
      "Leganes prediction accuracy is  34.375\n",
      "Levante prediction accuracy is  31.25\n",
      "Malaga prediction accuracy is  38.88888888888889\n",
      "Real Madrid prediction accuracy is  61.111111111111114\n",
      "Sevilla prediction accuracy is  50.0\n",
      "Sociedad prediction accuracy is  22.22222222222222\n",
      "Valencia prediction accuracy is  55.55555555555556\n",
      "Villarreal prediction accuracy is  33.33333333333333\n",
      "Overall accuracy is  40.029761904761905\n"
     ]
    }
   ],
   "source": [
    "# remove unused columns\n",
    "df_league = None\n",
    "df.reset_index(inplace=True)\n",
    "df = df[['Year', 'Date', 'HomeTeam', 'AwayTeam', 'FTHG', 'FTAG', 'FTR', 'HTHG', 'HTAG', 'HTR', 'HS', 'AS', 'HST', 'AST', 'HF', 'AF', 'HC', 'AC', 'HY', 'AY', 'HR', 'AR']]\n",
    "\n",
    "predict_year = 2017\n",
    "\n",
    "teams = np.unique(df.loc[df['Year'] == predict_year, 'HomeTeam'].values)\n",
    "teams.sort()\n",
    "for team in teams:\n",
    "\n",
    "    df_team = df[(df['HomeTeam'] == team) | (df['AwayTeam'] == team)]\n",
    "    X = pd.DataFrame(\n",
    "        data={\n",
    "            'Year': df_team['Year'],\n",
    "            'Date': df_team['Date'],\n",
    "            'HomeMatch': df_team['HomeTeam'] == team\n",
    "        }\n",
    "    )\n",
    "    X['Opponent'] = np.where(X['HomeMatch'], df_team['AwayTeam'], df_team['HomeTeam'])\n",
    "    X['FTR'] = df_team['FTR']\n",
    "    X['Won'] = np.where(X['HomeMatch'], df_team['FTR'] == 'H', df_team['FTR'] == 'A')\n",
    "    X['Draw'] = df_team['FTR'] == 'D'\n",
    "    X['Lost'] = np.where(X['HomeMatch'], df_team['FTR'] == 'A', df_team['FTR'] == 'H')\n",
    "    X['Result'] = np.where(X['Won'], 'Win', (np.where(X['Lost'], 'Lose', 'Draw')))\n",
    "\n",
    "    # find number of times won against this opponent in last 5 meetings\n",
    "    for key, groupByOpponent in X.groupby('Opponent'):\n",
    "        # keep index as new a column, will be restored and assigned back to X later\n",
    "        idx = groupByOpponent.index\n",
    "\n",
    "        # make match day an index because rolling need an index date\n",
    "        xx = groupByOpponent.set_index('Date')\n",
    "        xx['idx'] = idx\n",
    "        # shift to exclude self\n",
    "        xx['Last5AgainstThisOpponentWon'] = xx['Won'].rolling(6).apply(lambda x: np.nansum(x.shift()), raw=False)\n",
    "        xx['Last5AgainstThisOpponentDraw'] = xx['Draw'].rolling(6).apply(lambda x: np.nansum(x.shift()), raw=False)\n",
    "\n",
    "        xx['LastThisOpponentWon'] = xx['Won'].rolling(2).apply(lambda x: np.nansum(x.shift()), raw=False)\n",
    "        xx['LastThisOpponentDraw'] = xx['Draw'].rolling(2).apply(lambda x: np.nansum(x.shift()), raw=False)\n",
    "\n",
    "        # restore index\n",
    "        xx = xx.set_index('idx')\n",
    "\n",
    "        # assign back to the big dataframe\n",
    "        X.loc[xx.index, 'Last5AgainstThisOpponentWon'] = xx['Last5AgainstThisOpponentWon']\n",
    "        X.loc[xx.index, 'Last5AgainstThisOpponentDraw'] = xx['Last5AgainstThisOpponentDraw']\n",
    "        \n",
    "        X.loc[xx.index, 'LastThisOpponentWon'] = xx['LastThisOpponentWon']\n",
    "        X.loc[xx.index, 'LastThisOpponentDraw'] = xx['LastThisOpponentDraw']\n",
    "\n",
    "    # find recent forms\n",
    "    idx = X.index\n",
    "    xx = X.set_index('Date')\n",
    "    xx['idx'] = idx\n",
    "    xx['Last5Won'] = xx['Won'].rolling(6).apply(lambda x: np.nansum(x.shift()), raw=False)\n",
    "    xx['Last5Draw'] = xx['Draw'].rolling(6).apply(lambda x: np.nansum(x.shift()), raw=False)\n",
    "    xx['LastWon'] = xx['Won'].rolling(2).apply(lambda x: np.nansum(x.shift()), raw=False)\n",
    "    xx['LastDraw'] = xx['Draw'].rolling(2).apply(lambda x: np.nansum(x.shift()), raw=False)\n",
    "    \n",
    "    # restore index\n",
    "    xx = xx.set_index('idx')\n",
    "    \n",
    "    # assign back to the big dataframe\n",
    "    X.loc[xx.index, 'Last5Won'] = xx['Last5Won']\n",
    "    X.loc[xx.index, 'Last5Draw'] = xx['Last5Draw']\n",
    "    X.loc[xx.index, 'LastWon'] = xx['LastWon']\n",
    "    X.loc[xx.index, 'LastDraw'] = xx['LastDraw']\n",
    "\n",
    "    X.loc[np.isnan(X['Last5AgainstThisOpponentWon']), 'Last5AgainstThisOpponentWon'] = 0\n",
    "    X.loc[np.isnan(X['Last5AgainstThisOpponentDraw']), 'Last5AgainstThisOpponentDraw'] = 0\n",
    "    X.loc[np.isnan(X['LastThisOpponentWon']), 'LastThisOpponentWon'] = 0\n",
    "    X.loc[np.isnan(X['LastThisOpponentDraw']), 'LastThisOpponentDraw'] = 0\n",
    "    X.loc[np.isnan(X['Last5Won']), 'Last5Won'] = 0\n",
    "    X.loc[np.isnan(X['Last5Draw']), 'Last5Draw'] = 0\n",
    "    X.loc[np.isnan(X['LastWon']), 'LastWon'] = 0\n",
    "    X.loc[np.isnan(X['LastDraw']), 'LastDraw'] = 0\n",
    "\n",
    "    # X = X.loc[X['Year'] >= 2011]\n",
    "    Y = X[['Opponent', 'Result']]\n",
    "    del X['Result']\n",
    "    del X['Lost']\n",
    "    del X['Draw']\n",
    "    del X['Won']\n",
    "    del X['FTR']\n",
    "    del X['Date']\n",
    "\n",
    "    X_train = X[(X['Year'] < predict_year)]\n",
    "    Y_train = Y[(X['Year'] < predict_year)]\n",
    "    X_test = X[(X['Year'] >= predict_year)]\n",
    "    Y_test = Y[(X['Year'] >= predict_year)]\n",
    "\n",
    "    # construct decision tree\n",
    "    X_train_opponents = X_train.groupby('Opponent')\n",
    "    Y_train_opponents = Y_train.groupby('Opponent')\n",
    "    X_test_opponents = X_test.groupby('Opponent')\n",
    "    Y_test_opponents = Y_test.groupby('Opponent')\n",
    "    x_test_teams = X_test_opponents.groups.keys()\n",
    "    X['Predict'] = ''\n",
    "    os.makedirs(f'decision_tree/{league}/{predict_year}/{team}/', exist_ok=True)\n",
    "    for key, X_train_opponent in X_train_opponents:\n",
    "        if key not in x_test_teams:\n",
    "            continue\n",
    "        X_test_opponent = X_test_opponents.get_group(key)\n",
    "        Y_train_opponent = Y_train_opponents.get_group(key)\n",
    "        Y_test_opponent = Y_test_opponents.get_group(key)\n",
    "\n",
    "        del Y_train_opponent['Opponent']\n",
    "        del Y_test_opponent['Opponent']\n",
    "        del X_train_opponent['Opponent']\n",
    "        del X_test_opponent['Opponent']\n",
    "        del X_train_opponent['Year']\n",
    "        del X_test_opponent['Year']\n",
    "\n",
    "        clf_entropy = DecisionTreeClassifier(\n",
    "            criterion=\"gini\",\n",
    "            # criterion=\"entropy\",\n",
    "            random_state=100,\n",
    "            # max_depth=3,\n",
    "            min_samples_leaf=5\n",
    "            # min_samples_leaf=3\n",
    "        )\n",
    "        clf_entropy.fit(X_train_opponent, Y_train_opponent)\n",
    "\n",
    "        Y_pred = clf_entropy.predict(X_test_opponent)\n",
    "        X.loc[X_test_opponent.index, 'Predict'] = Y_pred\n",
    "        tree.export_graphviz(clf_entropy, out_file=f'decision_tree/{league}/{predict_year}/{team}/{key}.dot',\n",
    "                             feature_names=X_test_opponent.columns.values,\n",
    "                             class_names=clf_entropy.classes_)\n",
    "        call(['dot', '-Tpng', f'decision_tree/{league}/{predict_year}/{team}/{key}.dot', '-o', f'decision_tree/{league}/{predict_year}/{team}/{key}.png'])\n",
    "\n",
    "    X['Actual'] = Y['Result']\n",
    "    x = X[X['Predict'] != '']\n",
    "    x.to_csv(f'./decision_tree/{league}/{predict_year}/{team}/x.csv')\n",
    "    print(f\"{team} prediction accuracy is \", accuracy_score(x['Actual'], x['Predict'])*100)\n",
    "\n",
    "    if df_league is None:\n",
    "        df_league = x\n",
    "    else:\n",
    "        df_league = df_league.append(x, ignore_index=True, sort=False)\n",
    "print(\"Overall accuracy is \", accuracy_score(df_league['Actual'], df_league['Predict'])*100)\n"
   ]
  },
  {
   "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>Year</th>\n",
       "      <th>HomeMatch</th>\n",
       "      <th>Opponent</th>\n",
       "      <th>Last5AgainstThisOpponentWon</th>\n",
       "      <th>Last5AgainstThisOpponentDraw</th>\n",
       "      <th>LastThisOpponentWon</th>\n",
       "      <th>LastThisOpponentDraw</th>\n",
       "      <th>Last5Won</th>\n",
       "      <th>Last5Draw</th>\n",
       "      <th>LastWon</th>\n",
       "      <th>LastDraw</th>\n",
       "      <th>Predict</th>\n",
       "      <th>Actual</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Leganes</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Celta</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>La Coruna</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Sociedad</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Betis</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Espanol</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Getafe</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Eibar</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Las Palmas</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Ath Madrid</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Malaga</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Ath Bilbao</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Sevilla</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Leganes</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Celta</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>La Coruna</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Sociedad</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Betis</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Espanol</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Getafe</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Eibar</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Las Palmas</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>642</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Eibar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>643</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Las Palmas</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>644</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Ath Madrid</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>645</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Malaga</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>646</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Ath Bilbao</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>647</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Sevilla</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>648</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Leganes</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>649</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>650</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Celta</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>651</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>La Coruna</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>653</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>654</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Levante</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>655</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Sociedad</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>656</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Betis</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>657</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Alaves</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>658</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Espanol</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>659</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Getafe</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>660</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Eibar</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>661</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Las Palmas</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>662</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Ath Madrid</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>663</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Malaga</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>664</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Ath Bilbao</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>665</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Sevilla</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>666</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Leganes</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Draw</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Celta</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>669</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Lose</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>670</th>\n",
       "      <td>2017</td>\n",
       "      <td>False</td>\n",
       "      <td>La Coruna</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Win</td>\n",
       "      <td>Win</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>671</th>\n",
       "      <td>2017</td>\n",
       "      <td>True</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Lose</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>672 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Year  HomeMatch     Opponent  Last5AgainstThisOpponentWon  \\\n",
       "0    2017      False      Leganes                          0.0   \n",
       "1    2017       True    Barcelona                          0.0   \n",
       "2    2017      False        Celta                          0.0   \n",
       "3    2017       True   Villarreal                          0.0   \n",
       "4    2017      False    La Coruna                          0.0   \n",
       "5    2017       True  Real Madrid                          0.0   \n",
       "6    2017       True     Sociedad                          0.0   \n",
       "7    2017      False        Betis                          0.0   \n",
       "8    2017       True     Valencia                          0.0   \n",
       "9    2017       True      Espanol                          0.0   \n",
       "10   2017      False       Getafe                          0.0   \n",
       "11   2017       True        Eibar                          0.0   \n",
       "12   2017       True   Las Palmas                          0.0   \n",
       "13   2017      False   Ath Madrid                          0.0   \n",
       "14   2017       True       Malaga                          0.0   \n",
       "15   2017      False   Ath Bilbao                          0.0   \n",
       "16   2017       True      Sevilla                          0.0   \n",
       "17   2017       True      Leganes                          0.0   \n",
       "18   2017      False    Barcelona                          1.0   \n",
       "19   2017       True        Celta                          2.0   \n",
       "20   2017      False   Villarreal                          2.0   \n",
       "21   2017       True    La Coruna                          3.0   \n",
       "22   2017      False  Real Madrid                          0.0   \n",
       "23   2017      False     Sociedad                          2.0   \n",
       "24   2017       True        Betis                          3.0   \n",
       "25   2017      False     Valencia                          1.0   \n",
       "26   2017      False      Espanol                          1.0   \n",
       "27   2017       True       Getafe                          0.0   \n",
       "28   2017      False        Eibar                          0.0   \n",
       "29   2017      False   Las Palmas                          0.0   \n",
       "..    ...        ...          ...                          ...   \n",
       "642  2017       True        Eibar                          2.0   \n",
       "643  2017       True   Las Palmas                          0.0   \n",
       "644  2017      False   Ath Madrid                          3.0   \n",
       "645  2017       True       Malaga                          4.0   \n",
       "646  2017      False   Ath Bilbao                          2.0   \n",
       "647  2017       True      Sevilla                          1.0   \n",
       "648  2017      False      Leganes                          0.0   \n",
       "649  2017       True    Barcelona                          0.0   \n",
       "650  2017      False        Celta                          3.0   \n",
       "651  2017      False     Valencia                          3.0   \n",
       "652  2017       True    La Coruna                          1.0   \n",
       "653  2017      False  Real Madrid                          1.0   \n",
       "654  2017       True      Levante                          3.0   \n",
       "655  2017       True     Sociedad                          3.0   \n",
       "656  2017      False        Betis                          3.0   \n",
       "657  2017       True       Alaves                          2.0   \n",
       "658  2017      False      Espanol                          2.0   \n",
       "659  2017       True       Getafe                          2.0   \n",
       "660  2017      False        Eibar                          2.0   \n",
       "661  2017      False   Las Palmas                          2.0   \n",
       "662  2017       True   Ath Madrid                          3.0   \n",
       "663  2017      False       Malaga                          4.0   \n",
       "664  2017       True   Ath Bilbao                          2.0   \n",
       "665  2017      False      Sevilla                          1.0   \n",
       "666  2017       True      Leganes                          0.0   \n",
       "667  2017       True        Celta                          3.0   \n",
       "668  2017       True     Valencia                          4.0   \n",
       "669  2017      False    Barcelona                          0.0   \n",
       "670  2017      False    La Coruna                          1.0   \n",
       "671  2017       True  Real Madrid                          2.0   \n",
       "\n",
       "     Last5AgainstThisOpponentDraw  LastThisOpponentWon  LastThisOpponentDraw  \\\n",
       "0                             0.0                  0.0                   1.0   \n",
       "1                             0.0                  0.0                   0.0   \n",
       "2                             0.0                  1.0                   0.0   \n",
       "3                             0.0                  1.0                   0.0   \n",
       "4                             0.0                  1.0                   0.0   \n",
       "5                             0.0                  0.0                   0.0   \n",
       "6                             0.0                  1.0                   0.0   \n",
       "7                             0.0                  1.0                   0.0   \n",
       "8                             0.0                  1.0                   0.0   \n",
       "9                             0.0                  0.0                   0.0   \n",
       "10                            0.0                  0.0                   1.0   \n",
       "11                            0.0                  0.0                   1.0   \n",
       "12                            0.0                  0.0                   1.0   \n",
       "13                            0.0                  0.0                   1.0   \n",
       "14                            0.0                  1.0                   0.0   \n",
       "15                            0.0                  1.0                   0.0   \n",
       "16                            0.0                  0.0                   1.0   \n",
       "17                            0.0                  0.0                   0.0   \n",
       "18                            1.0                  0.0                   0.0   \n",
       "19                            0.0                  0.0                   0.0   \n",
       "20                            1.0                  0.0                   0.0   \n",
       "21                            1.0                  0.0                   0.0   \n",
       "22                            0.0                  0.0                   0.0   \n",
       "23                            0.0                  0.0                   0.0   \n",
       "24                            0.0                  0.0                   0.0   \n",
       "25                            0.0                  0.0                   0.0   \n",
       "26                            2.0                  1.0                   0.0   \n",
       "27                            0.0                  0.0                   0.0   \n",
       "28                            0.0                  0.0                   0.0   \n",
       "29                            0.0                  1.0                   0.0   \n",
       "..                            ...                  ...                   ...   \n",
       "642                           1.0                  0.0                   0.0   \n",
       "643                           0.0                  0.0                   0.0   \n",
       "644                           1.0                  1.0                   0.0   \n",
       "645                           1.0                  0.0                   1.0   \n",
       "646                           1.0                  1.0                   0.0   \n",
       "647                           2.0                  0.0                   1.0   \n",
       "648                           0.0                  1.0                   0.0   \n",
       "649                           2.0                  0.0                   0.0   \n",
       "650                           1.0                  1.0                   0.0   \n",
       "651                           1.0                  1.0                   0.0   \n",
       "652                           3.0                  0.0                   1.0   \n",
       "653                           2.0                  0.0                   0.0   \n",
       "654                           0.0                  0.0                   0.0   \n",
       "655                           1.0                  0.0                   0.0   \n",
       "656                           2.0                  1.0                   0.0   \n",
       "657                           1.0                  1.0                   0.0   \n",
       "658                           3.0                  0.0                   1.0   \n",
       "659                           1.0                  0.0                   0.0   \n",
       "660                           1.0                  1.0                   0.0   \n",
       "661                           1.0                  1.0                   0.0   \n",
       "662                           2.0                  0.0                   1.0   \n",
       "663                           1.0                  1.0                   0.0   \n",
       "664                           2.0                  0.0                   1.0   \n",
       "665                           2.0                  0.0                   0.0   \n",
       "666                           0.0                  0.0                   0.0   \n",
       "667                           1.0                  1.0                   0.0   \n",
       "668                           0.0                  1.0                   0.0   \n",
       "669                           2.0                  0.0                   0.0   \n",
       "670                           3.0                  0.0                   1.0   \n",
       "671                           1.0                  1.0                   0.0   \n",
       "\n",
       "     Last5Won  Last5Draw  LastWon  LastDraw Predict Actual  \n",
       "0         3.0        2.0      0.0       1.0    Draw   Lose  \n",
       "1         3.0        1.0      0.0       0.0    Lose   Lose  \n",
       "2         2.0        1.0      0.0       0.0    Lose   Lose  \n",
       "3         1.0        1.0      0.0       0.0     Win   Lose  \n",
       "4         0.0        1.0      0.0       0.0     Win   Lose  \n",
       "5         0.0        0.0      0.0       0.0    Lose   Lose  \n",
       "6         1.0        0.0      1.0       0.0    Lose   Lose  \n",
       "7         1.0        0.0      0.0       0.0     Win   Lose  \n",
       "8         1.0        0.0      0.0       0.0    Lose   Lose  \n",
       "9         1.0        0.0      0.0       0.0    Draw    Win  \n",
       "10        2.0        0.0      1.0       0.0    Draw   Lose  \n",
       "11        1.0        0.0      0.0       0.0    Draw   Lose  \n",
       "12        2.0        0.0      1.0       0.0    Draw    Win  \n",
       "13        3.0        0.0      1.0       0.0    Draw   Lose  \n",
       "14        2.0        0.0      0.0       0.0    Draw    Win  \n",
       "15        3.0        0.0      1.0       0.0    Draw   Lose  \n",
       "16        3.0        0.0      0.0       0.0    Lose    Win  \n",
       "17        3.0        0.0      1.0       0.0    Draw   Draw  \n",
       "18        2.0        1.0      0.0       1.0    Lose   Lose  \n",
       "19        2.0        1.0      0.0       0.0    Lose    Win  \n",
       "20        2.0        1.0      1.0       0.0     Win    Win  \n",
       "21        3.0        1.0      1.0       0.0     Win    Win  \n",
       "22        3.0        1.0      1.0       0.0    Lose   Lose  \n",
       "23        4.0        0.0      1.0       0.0    Lose   Lose  \n",
       "24        3.0        0.0      0.0       0.0     Win   Lose  \n",
       "25        2.0        0.0      0.0       0.0    Lose   Lose  \n",
       "26        1.0        0.0      0.0       0.0    Draw   Draw  \n",
       "27        1.0        1.0      0.0       1.0    Draw    Win  \n",
       "28        1.0        1.0      1.0       0.0    Draw    Win  \n",
       "29        2.0        1.0      0.0       0.0    Draw    Win  \n",
       "..        ...        ...      ...       ...     ...    ...  \n",
       "642       2.0        1.0      0.0       0.0    Draw    Win  \n",
       "643       3.0        1.0      1.0       0.0    Lose    Win  \n",
       "644       3.0        1.0      1.0       0.0     Win   Draw  \n",
       "645       3.0        1.0      0.0       1.0    Draw    Win  \n",
       "646       4.0        1.0      1.0       0.0    Draw   Draw  \n",
       "647       3.0        2.0      0.0       1.0    Lose   Lose  \n",
       "648       2.0        2.0      0.0       0.0    Draw   Lose  \n",
       "649       1.0        2.0      0.0       0.0    Lose   Lose  \n",
       "650       1.0        1.0      0.0       0.0    Draw    Win  \n",
       "651       1.0        1.0      1.0       0.0     Win    Win  \n",
       "652       2.0        0.0      1.0       0.0    Lose   Draw  \n",
       "653       2.0        1.0      0.0       1.0    Lose    Win  \n",
       "654       3.0        1.0      1.0       0.0    Lose    Win  \n",
       "655       4.0        1.0      1.0       0.0     Win    Win  \n",
       "656       4.0        1.0      1.0       0.0     Win   Lose  \n",
       "657       3.0        1.0      0.0       0.0    Lose   Lose  \n",
       "658       3.0        0.0      0.0       0.0     Win   Draw  \n",
       "659       2.0        1.0      0.0       1.0    Lose    Win  \n",
       "660       2.0        1.0      1.0       0.0    Draw   Lose  \n",
       "661       1.0        1.0      0.0       0.0    Lose    Win  \n",
       "662       2.0        1.0      1.0       0.0     Win    Win  \n",
       "663       3.0        0.0      1.0       0.0    Draw   Lose  \n",
       "664       2.0        0.0      0.0       0.0     Win   Lose  \n",
       "665       2.0        0.0      0.0       0.0    Lose   Draw  \n",
       "666       2.0        1.0      0.0       1.0    Draw    Win  \n",
       "667       2.0        1.0      1.0       0.0    Lose    Win  \n",
       "668       2.0        1.0      1.0       0.0     Win    Win  \n",
       "669       3.0        1.0      1.0       0.0    Lose   Lose  \n",
       "670       3.0        1.0      0.0       0.0     Win    Win  \n",
       "671       4.0        0.0      1.0       0.0    Lose   Draw  \n",
       "\n",
       "[672 rows x 13 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_league"
   ]
  }
 ],
 "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}