clean_fixtures.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "mount_file_id": "1efR5lYsgPJYWX0QGkuKLKONZFrBg2ELF",
      "authorship_tag": "ABX9TyMUaC4iTtfhyu1/c5lkgqZ0",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/saheedniyi02/fpl-ai/blob/master/clean_fixtures.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "seasons=[\"2020-21\",\"2021-22\",\"2022-23\"]\n",
        "unused_columns=[\"xP\",\"opponent_team\",\"expected_assists\",\"expected_goal_involvements\",\"expected_goals\",\n",
        "                \"expected_goals_conceded\",\"element_type_ex\",\"team_h_score\",\"team_a_score\",\"element\" , \"round\" ,\"fixture\",\"starts\" ]\n",
        "#stats that you want to use their values for the last few games to predict a\n",
        "\n",
        "no_last_stats=3 #number of last gameweek stats to use for prediction\n",
        "\n",
        "history_stats=[\"assists\",\"bonus\",\"bps\",\"clean_sheets\",\"creativity\",\"goals_conceded\",\"goals_scored\",\"ict_index\",\"influence\",\"minutes\",\n",
        "               \"own_goals\",\"penalties_missed\",\"penalties_saved\",\"red_cards\",\"saves\",\"selected\",\"threat\",\"total_points\",\"transfers_in\",\"transfers_out\",\"value\",\"match_result\",\"team Goal scored\",\"team Goal conceded\"]\n",
        "\n",
        "last_features=[f\"last {no_last_stats} {stat}\" for stat in history_stats]\n",
        "\n",
        "mean_features=[\"assists\",\"bonus\",\"bps\",\"clean_sheets\",\"creativity\",\"goals_conceded\",\n",
        "     \"goals_scored\",\"ict_index\",\"influence\",\"minutes\"\n",
        "     ,\"own_goals\",\"penalties_missed\",\"penalties_saved\",\n",
        "     \"red_cards\",\"saves\",\"selected\",\"threat\",\"total_points\"\n",
        "     ,\"transfers_in\",\"transfers_out\",\"value\",\"match_result\",\"team Goal scored\",\"team Goal conceded\"]\n",
        "\n",
        "std_features=[\"bps\",\"creativity\",\"ict_index\",\"influence\",\"minutes\",\"selected\",\"threat\",\"total_points\",\"transfers_in\",\"transfers_out\",\"value\"]\n",
        "\n",
        "\n",
        "\n",
        "dropped_columns = [\n",
        "    \"season\",\n",
        "    \"opponent\",\n",
        "    \"match_result\",\n",
        "    \"position\",\n",
        "    \"assists\",\n",
        "    \"penalties_missed\",\n",
        "    \"bonus\",\n",
        "    \"bps\",\n",
        "    \"clean_sheets\",\n",
        "    \"creativity\",\n",
        "    \"goals_conceded\",\n",
        "    \"goals_scored\",\n",
        "    \"ict_index\",\n",
        "    \"influence\",\n",
        "    \"own_goals\",\n",
        "    \"penalties_saved\",\n",
        "    \"red_cards\",\n",
        "    \"saves\",\n",
        "    \"selected\",\n",
        "    \"threat\",\n",
        "    \"transfers_balance\",\n",
        "    \"transfers_in\",\n",
        "    \"transfers_out\",\n",
        "    \"yellow_cards\"\n",
        "]  # \"value\",\n",
        "\n",
        "\n",
        "\n",
        "leak_columns = [\n",
        "    \"name\",\n",
        "    \"team\",\n",
        "]  # columns that shouldnt be used in training fir fear of data leakage\n",
        "\n",
        "\n",
        "\n",
        "short_term_stats=3\n",
        "\n",
        "team_features=[\"team Goal scored\",\"team Goal conceded\"]"
      ],
      "metadata": {
        "id": "aHk-ncULU1fS"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#from config import *\n",
        "import numpy as np\n",
        "import pandas as pd\n",
        "from scipy import stats\n",
        "\n",
        "\n",
        "def split_test(data, gameweek):\n",
        "    # print(data[\"GW\"].value_counts())\n",
        "    data_gw = data[data[\"GW\"] == gameweek]\n",
        "    data_other_gw = data[~(data[\"GW\"] == gameweek)]\n",
        "    return data_gw, data_other_gw\n",
        "\n",
        "\n",
        "def check_win(df):\n",
        "    list_win = []\n",
        "    for index in df.index:\n",
        "        result = (df[\"team_a_score\"] - df[\"team_h_score\"]).loc[index]\n",
        "        is_home = df[\"was_home\"].loc[index]\n",
        "        if result == 0:\n",
        "            list_win.append(1)\n",
        "        elif result > 0 and is_home == True:\n",
        "            list_win.append(0)\n",
        "        elif result < 0 and is_home == True:\n",
        "            list_win.append(3)\n",
        "        elif result > 0 and is_home == False:\n",
        "            list_win.append(3)\n",
        "        elif result < 0 and is_home == False:\n",
        "            list_win.append(0)\n",
        "        else:\n",
        "            list_win.append(-1)\n",
        "    return list_win\n",
        "\n",
        "\n",
        "def get_2020_21_season_pos(club):\n",
        "    \"\"\"get the position of the club in the 2020-21 season\"\"\"\n",
        "    if club == \"Man City\":\n",
        "        return 1\n",
        "    elif club == \"Man Utd\":\n",
        "        return 2\n",
        "    elif club == \"Liverpool\":\n",
        "        return 3\n",
        "    elif club == \"Chelsea\":\n",
        "        return 4\n",
        "    elif club == \"Leicester\":\n",
        "        return 5\n",
        "    elif club == \"West Ham\":\n",
        "        return 6\n",
        "    elif club == \"Spurs\":\n",
        "        return 7\n",
        "    elif club == \"Arsenal\":\n",
        "        return 8\n",
        "    elif club == \"Leeds\":\n",
        "        return 9\n",
        "    elif club == \"Everton\":\n",
        "        return 10\n",
        "    elif club == \"Aston Villa\":\n",
        "        return 11\n",
        "    elif club == \"Newcastle\":\n",
        "        return 12\n",
        "    elif club == \"Wolves\":\n",
        "        return 13\n",
        "    elif club == \"Crystal Palace\":\n",
        "        return 14\n",
        "    elif club == \"Southampton\":\n",
        "        return 15\n",
        "    elif club == \"Brighton\":\n",
        "        return 16\n",
        "    elif club == \"Burnley\":\n",
        "        return 17\n",
        "    else:\n",
        "        return 20\n",
        "\n",
        "\n",
        "def get_2019_20_season_pos(club):\n",
        "    \"\"\"get the position of the club in the 2019-20 season\"\"\"\n",
        "    if club == \"Liverpool\":\n",
        "        return 1\n",
        "    elif club == \"Man City\":\n",
        "        return 2\n",
        "    elif club == \"Man Utd\":\n",
        "        return 3\n",
        "    elif club == \"Chelsea\":\n",
        "        return 4\n",
        "    elif club == \"Leicester\":\n",
        "        return 5\n",
        "    elif club == \"Spurs\":\n",
        "        return 6\n",
        "    elif club == \"Wolves\":\n",
        "        return 7\n",
        "    elif club == \"Arsenal\":\n",
        "        return 8\n",
        "    elif club == \"Sheffield Utd\":\n",
        "        return 9\n",
        "    elif club == \"Burnley\":\n",
        "        return 10\n",
        "    elif club == \"Southampton\":\n",
        "        return 11\n",
        "    elif club == \"Everton\":\n",
        "        return 12\n",
        "    elif club == \"Newcastle\":\n",
        "        return 13\n",
        "    elif club == \"Crystal Palace\":\n",
        "        return 14\n",
        "    elif club == \"Brighton\":\n",
        "        return 15\n",
        "    elif club == \"West Ham\":\n",
        "        return 16\n",
        "    elif club == \"Aston Villa\":\n",
        "        return 17\n",
        "    else:\n",
        "        return 20\n",
        "\n",
        "\n",
        "def get_2021_22_season_pos(club):\n",
        "    if club == \"Man City\":\n",
        "        return 1\n",
        "    elif club == \"Liverpool\":\n",
        "        return 2\n",
        "    elif club == \"Chelsea\":\n",
        "        return 3\n",
        "    elif club == \"Spurs\":\n",
        "        return 4\n",
        "    elif club == \"Arsenal\":\n",
        "        return 5\n",
        "    elif club == \"Man Utd\":\n",
        "        return 6\n",
        "    elif club == \"West Ham\":\n",
        "        return 7\n",
        "    elif club == \"Leicester\":\n",
        "        return 8\n",
        "    elif club == \"Brighton\":\n",
        "        return 9\n",
        "    elif club == \"Wolves\":\n",
        "        return 10\n",
        "    elif club == \"Newcastle\":\n",
        "        return 11\n",
        "    elif club == \"Crystal Palace\":\n",
        "        return 12\n",
        "    elif club == \"Brentford\":\n",
        "        return 13\n",
        "    elif club == \"Aston Villa\":\n",
        "        return 14\n",
        "    elif club == \"Southampton\":\n",
        "        return 15\n",
        "    elif club == \"Everton\":\n",
        "        return 16\n",
        "    elif club == \"Leeds\":\n",
        "        return 17\n",
        "    else:\n",
        "        return 20\n",
        "\n",
        "\n",
        "def get_2022_23_season_pos(club):\n",
        "    if club == \"Man City\":\n",
        "        return 1\n",
        "    elif club == \"Arsenal\":\n",
        "        return 2\n",
        "    elif club == \"Man Utd\":\n",
        "        return 3\n",
        "    elif club == \"Newcastle\":\n",
        "        return 4\n",
        "    elif club == \"Liverpool\":\n",
        "        return 5\n",
        "    elif club == \"Brighton\":\n",
        "        return 6\n",
        "    elif club == \"Aston Villa\":\n",
        "        return 7\n",
        "    elif club == \"Spurs\":\n",
        "        return 8\n",
        "    elif club == \"Brentford\":\n",
        "        return 9\n",
        "    elif club == \"Fulham\":\n",
        "        return 10\n",
        "    elif club == \"Crystal Palace\":\n",
        "        return 11\n",
        "    elif club == \"Chelsea\":\n",
        "        return 12\n",
        "    elif club == \"Wolves\":\n",
        "        return 13\n",
        "    elif club == \"West Ham\":\n",
        "        return 14\n",
        "    elif club == \"Bournemouth\":\n",
        "        return 15\n",
        "    elif club == \"Nott'm Forest\":\n",
        "        return 16\n",
        "    elif club == \"Everton\":\n",
        "        return 17\n",
        "    else:\n",
        "        return 20\n",
        "\n",
        "\n",
        "def get_last_season_pos(year):\n",
        "    \"\"\"get the function to get the last season position of a team at any year\"\"\"\n",
        "    if year == \"2020-21\":\n",
        "        return get_2019_20_season_pos\n",
        "    elif year == \"2021-22\":\n",
        "        return get_2020_21_season_pos\n",
        "    elif year == \"2022-23\":\n",
        "        return get_2021_22_season_pos\n",
        "    elif year == \"2023-24\":\n",
        "        return get_2022_23_season_pos\n",
        "\n",
        "\n",
        "def remove_neg(val):\n",
        "    if val > 0:\n",
        "        return val\n",
        "    else:\n",
        "        return -val\n",
        "\n",
        "\n",
        "def deque_and_queue(stats, value):\n",
        "    # if -1 in stats:\n",
        "    #  return stats\n",
        "    # deque\n",
        "    stats = stats[1:]\n",
        "    stats.append(value)\n",
        "    return stats\n",
        "\n",
        "\n",
        "def get_last_stats(data, stat, name, no_last_stats=3):\n",
        "    name_df = data[data[\"name\"] == name]\n",
        "    seasons = [\"2020-21\", \"2021-22\", \"2022-23\"]\n",
        "    name_df_dict = {}\n",
        "    for season in seasons:\n",
        "        name_df_season = name_df[name_df[\"season\"] == season]\n",
        "        list_stats = []\n",
        "        stats_x = []\n",
        "        for value in name_df_season[stat]:\n",
        "            if len(stats_x) < no_last_stats:\n",
        "                list_stats.append(np.array(stats_x))\n",
        "                stats_x.append(value)\n",
        "            else:\n",
        "                list_stats.append(np.array(stats_x))\n",
        "                stats_x = deque_and_queue(stats_x, value)\n",
        "        name_df_season[f\"last {no_last_stats} {stat}\"] = list_stats\n",
        "        name_df_dict[season] = name_df_season\n",
        "    return pd.concat(name_df_dict.values())\n",
        "\n",
        "\n",
        "def get_all_players_last_stats(data, stat, no_last_stats=3):\n",
        "    players_df = []\n",
        "    for player in data[\"name\"].unique():\n",
        "        data_player = get_last_stats(data, stat, player, no_last_stats)\n",
        "        players_df.append(data_player)\n",
        "    # print(pd.concat(players_df))\n",
        "    return pd.concat(players_df)\n",
        "\n",
        "\n",
        "def get_last_stats_test(data, stat, name, no_last_stats=3):\n",
        "    name_df = data[data[\"name\"] == name]\n",
        "    list_stats = []\n",
        "    stats_x = []\n",
        "    for value in name_df[stat]:\n",
        "        if len(stats_x) < no_last_stats:\n",
        "            list_stats.append(np.array(stats_x))\n",
        "            stats_x.append(value)\n",
        "        else:\n",
        "            list_stats.append(np.array(stats_x))\n",
        "            stats_x = deque_and_queue(stats_x, value)\n",
        "    name_df[f\"last {no_last_stats} {stat}\"] = list_stats\n",
        "    return name_df\n",
        "\n",
        "\n",
        "def get_players_last_stats_test(data, stat, no_last_stats=short_term_stats):\n",
        "    players_df = []\n",
        "    for player in data[\"name\"].unique():\n",
        "        data_player = get_last_stats_test(data, stat, player, no_last_stats)\n",
        "        players_df.append(data_player)\n",
        "    # print(pd.concat(players_df))\n",
        "    return pd.concat(players_df)\n",
        "\n",
        "def get_all_stats_test(data, stat, name):\n",
        "    name_df = data[data[\"name\"] == name]\n",
        "    list_stats = []\n",
        "    stats_x = []\n",
        "    for value in name_df[stat]:\n",
        "        list_stats.append(np.array(stats_x))\n",
        "        stats_x.append(value)\n",
        "    name_df[f\"all {stat}\"] = list_stats\n",
        "    return name_df\n",
        "\n",
        "\n",
        "def get_players_all_stats_test(data, stat):\n",
        "    players_df = []\n",
        "    for player in data[\"name\"].unique():\n",
        "        data_player = get_all_stats_test(data, stat, player)\n",
        "        players_df.append(data_player)\n",
        "    # print(pd.concat(players_df))\n",
        "    return pd.concat(players_df)\n",
        "\n",
        "def convert_minutes(val):\n",
        "    \"\"\"CONVERTS MINUTES TO A CATEGORICAL OUTPUT\"\"\"\n",
        "    if val > 10:\n",
        "        return 1\n",
        "    else:\n",
        "        return 0\n",
        "\n",
        "\n",
        "def find_mode(vals):\n",
        "    \"\"\"find the mode of vals\"\"\"\n",
        "    try:\n",
        "        if -1 in vals:\n",
        "            return -1\n",
        "        return stats.mode(vals)[0][0]\n",
        "    except IndexError:\n",
        "        return np.nan\n",
        "\n",
        "\n",
        "def find_mean(vals):\n",
        "    \"\"\"find the mean of vals\"\"\"\n",
        "    try:\n",
        "        if -1 in vals:\n",
        "            return -1\n",
        "        return np.mean(vals)\n",
        "    except:\n",
        "        return np.nan\n",
        "\n",
        "\n",
        "def find_max(vals):\n",
        "    \"\"\"find the maximum of vals\"\"\"\n",
        "    try:\n",
        "        if -1 in vals:\n",
        "            return -1\n",
        "        return np.max(vals)\n",
        "    except:\n",
        "        return np.nan\n",
        "\n",
        "\n",
        "def find_std(vals):\n",
        "    \"\"\"find the standard deviation of vals\"\"\"\n",
        "    try:\n",
        "        if -1 in vals:\n",
        "            return -1\n",
        "        return np.std(vals)\n",
        "    except:\n",
        "        return np.nan\n",
        "\n",
        "\n",
        "def find_value_count(vals, to_count):\n",
        "    \"\"\"find the number of times to_count appears in vals\"\"\"\n",
        "    try:\n",
        "        if -1 in vals:\n",
        "            return -1\n",
        "        values, count = np.unique(vals, return_counts=True)\n",
        "        index = np.where(values == to_count)[0][0]\n",
        "        return count[index]\n",
        "\n",
        "    except:\n",
        "        return -2\n",
        "\n",
        "\n",
        "def get_opp_team(data):\n",
        "    \"\"\"get the opponent team for each player\"\"\"\n",
        "    opp_teams = []\n",
        "    home_teams = data[\"home_team\"]\n",
        "    away_teams = data[\"away_team\"]\n",
        "    my_teams = data[\"team\"]\n",
        "    for id in data.index:\n",
        "        my_team = my_teams.iloc[id]\n",
        "        home_team = home_teams.iloc[id]\n",
        "        away_team = away_teams.iloc[id]\n",
        "        if my_team == home_team:\n",
        "            opp_teams.append(away_team)\n",
        "        else:\n",
        "            opp_teams.append(home_team)\n",
        "    return opp_teams\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "def create_features(data, mean_features, std_features):\n",
        "    for mean_feature in mean_features:\n",
        "        print(mean_feature)\n",
        "        data[f\"mean {mean_feature} {no_last_stats}\"] = [\n",
        "            find_mean(values) for values in data[f\"last {no_last_stats} {mean_feature}\"]\n",
        "        ]\n",
        "        data[f\"mean {mean_feature} all\"] = [\n",
        "            find_mean(values) for values in data[f\"all {mean_feature}\"]\n",
        "        ]\n",
        "        #data[f\"mean {mean_feature} all\"]= data[f\"mean {mean_feature} all\"]/data[\"GW\"]\n",
        "    for std_feature in std_features:\n",
        "        print(std_feature)\n",
        "        data[f\"std {std_feature} {no_last_stats}\"] = [\n",
        "            find_std(values) for values in data[f\"last {no_last_stats} {std_feature}\"]\n",
        "        ]\n",
        "    return data\n"
      ],
      "metadata": {
        "id": "oAqlrgBaUtaD"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "\n",
        "\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "#from config import unused_columns, history_stats, no_last_stats\n",
        "import warnings\n",
        "\n",
        "warnings.filterwarnings(\"ignore\")\n",
        "\n",
        "\n",
        "def calculate_ratio_team_value(name, df=None):\n",
        "    \"\"\"Calculate the ratio of player value to team value\"\"\"\n",
        "    team = df[df[\"name\"] == name][\"team\"].iloc[0]\n",
        "    total_value = df[df[\"team\"] == team][\"value\"].sum()\n",
        "    value = df[df[\"name\"] == name][\"value\"].iloc[0]\n",
        "    return value * 100 / total_value\n",
        "\n",
        "\n",
        "def calculate_position_rank(name, df=None):\n",
        "    \"\"\"Calculate the number of players with a higher  value\"\"\"\n",
        "    value = df[df[\"name\"] == name][\"value\"].iloc[0]\n",
        "    position = df[df[\"name\"] == name][\"position\"].iloc[0]\n",
        "    team = df[df[\"name\"] == name][\"team\"].iloc[0]\n",
        "    return df[\n",
        "        (df[\"value\"] > value) & (df[\"position\"] == position) & (df[\"team\"] == team)\n",
        "    ][\"value\"].shape[0]\n",
        "\n",
        "\n",
        "gameweek = 10\n",
        "old_gameweek_results = []\n",
        "for i in range(1, gameweek):\n",
        "    result = pd.read_csv(f\"/content/drive/MyDrive/Fplpredict /datasets/2023-24/results/GW{i}.csv\", index_col=0)\n",
        "    result.columns = [\n",
        "        \"element\",\n",
        "        \"fixture\",\n",
        "        \"opponent_team\",\n",
        "        \"total_points\",\n",
        "        \"was_home\",\n",
        "        \"kickoff_time\",\n",
        "        \"team_h_score\",\n",
        "        \"team_a_score\",\n",
        "        \"round\",\n",
        "        \"minutes\",\n",
        "        \"goals_scored\",\n",
        "        \"assists\",\n",
        "        \"clean_sheets\",\n",
        "        \"goals_conceded\",\n",
        "        \"own_goals\",\n",
        "        \"penalties_saved\",\n",
        "        \"penalties_missed\",\n",
        "        \"yellow_cards\",\n",
        "        \"red_cards\",\n",
        "        \"saves\",\n",
        "        \"bonus\",\n",
        "        \"bps\",\n",
        "        \"influence\",\n",
        "        \"creativity\",\n",
        "        \"threat\",\n",
        "        \"ict_index\",\n",
        "        \"starts\",\n",
        "        \"expected_goals\",\n",
        "        \"expected_assists\",\n",
        "        \"expected_goal_involvements\",\n",
        "        \"expected_goals_conceded\",\n",
        "        \"value\",\n",
        "        \"transfers_balance\",\n",
        "        \"selected\",\n",
        "        \"transfers_in\",\n",
        "        \"transfers_out\",\n",
        "        \"id\",\n",
        "        \"name\",\n",
        "        \"cost\",\n",
        "        \"position\",\n",
        "        \"home_team\",\n",
        "        \"away_team\",\n",
        "        \"team\",\n",
        "    ]\n",
        "    year = \"2023-24\"\n",
        "    previous_year = \"2022-23\"\n",
        "    result[\"xP\"] = 0\n",
        "    result[\"GW\"] = i\n",
        "    result[\"match_result\"] = check_win(result)\n",
        "    result[\"opponent\"] = get_opp_team(result)\n",
        "    print(result.shape)\n",
        "    result[\"last_season_position\"] = result[\"team\"].apply(get_last_season_pos(year))\n",
        "    result[\"opponent_last_season_position\"] = result[\"opponent\"].apply(\n",
        "        get_last_season_pos(year)\n",
        "    )\n",
        "    result[\"percent_value\"] = result[\"name\"].apply(\n",
        "        calculate_ratio_team_value, args=(result,)\n",
        "    )\n",
        "    result[\"position rank\"] = result[\"name\"].apply(\n",
        "        calculate_position_rank, args=(result,)\n",
        "    )\n",
        "\n",
        "    player_prev_stats = pd.read_csv(\n",
        "        f\"https://raw.githubusercontent.com/vaastav/Fantasy-Premier-League/master/data/{previous_year}/cleaned_players.csv\"\n",
        "    )\n",
        "    player_prev_stats[\"name\"] = (\n",
        "        player_prev_stats[\"first_name\"] + \" \" + player_prev_stats[\"second_name\"]\n",
        "    )\n",
        "    player_prev_stats.drop([\"first_name\", \"second_name\"], axis=1, inplace=True)\n",
        "    player_prev_stats.columns = player_prev_stats.columns + \"_ex\"\n",
        "    result = pd.merge(\n",
        "        result, player_prev_stats, left_on=\"name\", right_on=\"name_ex\", how=\"left\"\n",
        "    )\n",
        "    result_home=result[result[\"was_home\"]==True]\n",
        "    result_away=result[result[\"was_home\"]==False]\n",
        "    result_home[\"team Goal scored\"]=result_home[\"team_h_score\"]\n",
        "    result_home[\"team Goal conceded\"]=result_home[\"team_a_score\"]\n",
        "    result_away[\"team Goal conceded\"]=result_away[\"team_h_score\"]\n",
        "    result_away[\"team Goal scored\"]=result_away[\"team_a_score\"]\n",
        "    result=pd.concat([result_home,result_away])\n",
        "    result.drop(unused_columns, axis=1, inplace=True)\n",
        "    old_gameweek_results.append(result)\n",
        "    print(i)\n",
        "\n",
        "# print(old_gameweek_results[0][\"opponent\"].value_counts())\n",
        "current_fixture = pd.read_csv(\n",
        "    f\"/content/drive/MyDrive/Fplpredict /datasets/2023-24/fixtures/GW{gameweek}.csv\", index_col=0\n",
        ")\n",
        "current_fixture.columns = [\n",
        "    \"id\",\n",
        "    \"name\",\n",
        "    \"value\",\n",
        "    \"position\",\n",
        "    \"home_team\",\n",
        "    \"away_team\",\n",
        "    \"kickoff_time\",\n",
        "    \"was_home\",\n",
        "    \"team\",\n",
        "]\n",
        "\n",
        "\n",
        "current_fixture[\"opponent\"] = get_opp_team(current_fixture)\n",
        "# print(current_fixture[\"opponent\"].value_counts())\n",
        "current_fixture[\"last_season_position\"] = current_fixture[\"team\"].apply(\n",
        "    get_last_season_pos(year)\n",
        ")\n",
        "current_fixture[\"opponent_last_season_position\"] = current_fixture[\"opponent\"].apply(\n",
        "    get_last_season_pos(year)\n",
        ")\n",
        "current_fixture[\"percent_value\"] = current_fixture[\"name\"].apply(\n",
        "    calculate_ratio_team_value, args=(current_fixture,)\n",
        ")\n",
        "current_fixture[\"position rank\"] = current_fixture[\"name\"].apply(\n",
        "    calculate_position_rank, args=(current_fixture,)\n",
        ")\n",
        "\n",
        "\n",
        "# check_win not posible because it's only fixtures we have for now\n",
        "# merge last season data\n",
        "player_prev_stats = pd.read_csv(\n",
        "    f\"https://raw.githubusercontent.com/vaastav/Fantasy-Premier-League/master/data/{previous_year}/cleaned_players.csv\"\n",
        ")\n",
        "\n",
        "player_prev_stats[\"name\"] = (\n",
        "    player_prev_stats[\"first_name\"] + \" \" + player_prev_stats[\"second_name\"]\n",
        ")\n",
        "\n",
        "player_prev_stats.drop([\"first_name\", \"second_name\"], axis=1, inplace=True)\n",
        "player_prev_stats.columns = player_prev_stats.columns + \"_ex\"\n",
        "current_fixture = pd.merge(\n",
        "    current_fixture, player_prev_stats, left_on=\"name\", right_on=\"name_ex\", how=\"left\"\n",
        ")\n",
        "\n",
        "current_fixture[\"GW\"] = gameweek\n",
        "old_gameweek_results.append(current_fixture)\n",
        "data = pd.concat(old_gameweek_results)\n",
        "\n",
        "data = data.sort_values([\"name\", \"kickoff_time\"], ascending=True)\n",
        "\n",
        "\n",
        "data[\"season\"] = year\n",
        "data.drop([\"name_ex\", \"id\", \"home_team\", \"away_team\"], axis=1, inplace=True)\n",
        "\n",
        "for stat in history_stats:\n",
        "    print(stat)\n",
        "    data = get_players_last_stats_test(data, stat)\n",
        "    data = get_players_all_stats_test(data, stat)\n",
        "\n",
        "data = create_features(data, mean_features, std_features)\n",
        "data.drop(\n",
        "    [f\"last {no_last_stats} {stat}\" for stat in history_stats], axis=1, inplace=True\n",
        ")\n",
        "data.drop([f\"all {stat}\" for stat in history_stats],axis=1,inplace=True)\n",
        "data[\"ratio_goal_scored 3\"]=((data[\"mean goals_scored 3\"]/data[\"mean team Goal scored 3\"]).replace(np.inf, 0))*100\n",
        "data[\"ratio_goal_scored all\"]=((data[\"mean goals_scored all\"]/data[\"mean team Goal scored all\"]).replace(np.inf, 0))*100"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "kNny1GQPSlSE",
        "outputId": "25f80706-6de0-4769-cf60-aa3c3042aec5"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "(613, 47)\n",
            "1\n",
            "(585, 47)\n",
            "2\n",
            "(405, 47)\n",
            "3\n",
            "(584, 47)\n",
            "4\n",
            "(585, 47)\n",
            "5\n",
            "(585, 47)\n",
            "6\n",
            "(658, 47)\n",
            "7\n",
            "(658, 47)\n",
            "8\n",
            "(658, 47)\n",
            "9\n",
            "assists\n",
            "bonus\n",
            "bps\n",
            "clean_sheets\n",
            "creativity\n",
            "goals_conceded\n",
            "goals_scored\n",
            "ict_index\n",
            "influence\n",
            "minutes\n",
            "own_goals\n",
            "penalties_missed\n",
            "penalties_saved\n",
            "red_cards\n",
            "saves\n",
            "selected\n",
            "threat\n",
            "total_points\n",
            "transfers_in\n",
            "transfers_out\n",
            "value\n",
            "match_result\n",
            "team Goal scored\n",
            "team Goal conceded\n",
            "assists\n",
            "bonus\n",
            "bps\n",
            "clean_sheets\n",
            "creativity\n",
            "goals_conceded\n",
            "goals_scored\n",
            "ict_index\n",
            "influence\n",
            "minutes\n",
            "own_goals\n",
            "penalties_missed\n",
            "penalties_saved\n",
            "red_cards\n",
            "saves\n",
            "selected\n",
            "threat\n",
            "total_points\n",
            "transfers_in\n",
            "transfers_out\n",
            "value\n",
            "match_result\n",
            "team Goal scored\n",
            "team Goal conceded\n",
            "bps\n",
            "creativity\n",
            "ict_index\n",
            "influence\n",
            "minutes\n",
            "selected\n",
            "threat\n",
            "total_points\n",
            "transfers_in\n",
            "transfers_out\n",
            "value\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#add opponent stats for gameweeks\n",
        "list_data_gw=[]\n",
        "for GW in range(1,gameweek + 1):\n",
        "\n",
        "    data_gw=data[data[\"GW\"]==GW].sort_values(by=\"mean team Goal scored all\", ascending=False)\n",
        "    data_opponent=data_gw.drop_duplicates(subset=\"team\")[['team','mean team Goal scored 3','mean team Goal conceded 3','mean team Goal scored all','mean team Goal conceded all',\"mean match_result all\"]]\n",
        "    print(data_opponent.reset_index().drop(\"index\",axis=1))\n",
        "    #print(data_gw.shape)\n",
        "    data_opponent.columns=['opponent','opp mean team Goal scored 3','opp mean team Goal conceded 3','opp mean team Goal scored all','opp mean team Goal conceded all',\"opp mean match_result all\"]\n",
        "    #print(data_opponent.shape)\n",
        "    data_gw=pd.merge(data_gw,data_opponent,on=\"opponent\",how=\"left\")\n",
        "    list_data_gw.append(data_gw)"
      ],
      "metadata": {
        "id": "wNUKfvGvmBPE",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "3f28c402-e43c-427e-e346-e7c35975f850"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "              team  mean team Goal scored 3  mean team Goal conceded 3  \\\n",
            "0            Spurs                      2.0                        2.0   \n",
            "1         Brighton                      NaN                        NaN   \n",
            "2         West Ham                      NaN                        NaN   \n",
            "3        Brentford                      NaN                        NaN   \n",
            "4          Arsenal                      NaN                        NaN   \n",
            "5          Man Utd                      NaN                        NaN   \n",
            "6          Everton                      NaN                        NaN   \n",
            "7          Chelsea                      NaN                        NaN   \n",
            "8    Sheffield Utd                      NaN                        NaN   \n",
            "9      Bournemouth                      NaN                        NaN   \n",
            "10           Luton                      NaN                        NaN   \n",
            "11       Liverpool                      NaN                        NaN   \n",
            "12          Fulham                      NaN                        NaN   \n",
            "13   Nott'm Forest                      NaN                        NaN   \n",
            "14       Newcastle                      NaN                        NaN   \n",
            "15     Aston Villa                      NaN                        NaN   \n",
            "16         Burnley                      NaN                        NaN   \n",
            "17        Man City                      NaN                        NaN   \n",
            "18          Wolves                      NaN                        NaN   \n",
            "19  Crystal Palace                      NaN                        NaN   \n",
            "\n",
            "    mean team Goal scored all  mean team Goal conceded all  \\\n",
            "0                         2.0                          2.0   \n",
            "1                         NaN                          NaN   \n",
            "2                         NaN                          NaN   \n",
            "3                         NaN                          NaN   \n",
            "4                         NaN                          NaN   \n",
            "5                         NaN                          NaN   \n",
            "6                         NaN                          NaN   \n",
            "7                         NaN                          NaN   \n",
            "8                         NaN                          NaN   \n",
            "9                         NaN                          NaN   \n",
            "10                        NaN                          NaN   \n",
            "11                        NaN                          NaN   \n",
            "12                        NaN                          NaN   \n",
            "13                        NaN                          NaN   \n",
            "14                        NaN                          NaN   \n",
            "15                        NaN                          NaN   \n",
            "16                        NaN                          NaN   \n",
            "17                        NaN                          NaN   \n",
            "18                        NaN                          NaN   \n",
            "19                        NaN                          NaN   \n",
            "\n",
            "    mean match_result all  \n",
            "0                     1.0  \n",
            "1                     NaN  \n",
            "2                     NaN  \n",
            "3                     NaN  \n",
            "4                     NaN  \n",
            "5                     NaN  \n",
            "6                     NaN  \n",
            "7                     NaN  \n",
            "8                     NaN  \n",
            "9                     NaN  \n",
            "10                    NaN  \n",
            "11                    NaN  \n",
            "12                    NaN  \n",
            "13                    NaN  \n",
            "14                    NaN  \n",
            "15                    NaN  \n",
            "16                    NaN  \n",
            "17                    NaN  \n",
            "18                    NaN  \n",
            "19                    NaN  \n",
            "              team  mean team Goal scored 3  mean team Goal conceded 3  \\\n",
            "0        Newcastle                      5.0                        1.0   \n",
            "1         Brighton                      4.0                        1.0   \n",
            "2          Chelsea                      4.0                        1.0   \n",
            "3         Man City                      3.0                        0.0   \n",
            "4          Arsenal                      2.0                        1.0   \n",
            "5        Brentford                      2.0                        2.0   \n",
            "6            Spurs                      2.0                        2.0   \n",
            "7      Aston Villa                      1.0                        5.0   \n",
            "8      Bournemouth                      1.0                        1.0   \n",
            "9    Nott'm Forest                      1.0                        2.0   \n",
            "10         Man Utd                      1.0                        0.0   \n",
            "11  Crystal Palace                      1.0                        0.0   \n",
            "12          Fulham                      1.0                        0.0   \n",
            "13        West Ham                      1.0                        1.0   \n",
            "14       Liverpool                      1.0                        1.0   \n",
            "15          Wolves                      0.0                        1.0   \n",
            "16         Everton                      0.0                        1.0   \n",
            "17   Sheffield Utd                      0.0                        1.0   \n",
            "\n",
            "    mean team Goal scored all  mean team Goal conceded all  \\\n",
            "0                         5.0                          1.0   \n",
            "1                         4.0                          1.0   \n",
            "2                         4.0                          1.0   \n",
            "3                         3.0                          0.0   \n",
            "4                         2.0                          1.0   \n",
            "5                         2.0                          2.0   \n",
            "6                         2.0                          2.0   \n",
            "7                         1.0                          5.0   \n",
            "8                         1.0                          1.0   \n",
            "9                         1.0                          2.0   \n",
            "10                        1.0                          0.0   \n",
            "11                        1.0                          0.0   \n",
            "12                        1.0                          0.0   \n",
            "13                        1.0                          1.0   \n",
            "14                        1.0                          1.0   \n",
            "15                        0.0                          1.0   \n",
            "16                        0.0                          1.0   \n",
            "17                        0.0                          1.0   \n",
            "\n",
            "    mean match_result all  \n",
            "0                     3.0  \n",
            "1                     3.0  \n",
            "2                     3.0  \n",
            "3                     3.0  \n",
            "4                     3.0  \n",
            "5                     1.0  \n",
            "6                     1.0  \n",
            "7                     0.0  \n",
            "8                     1.0  \n",
            "9                     0.0  \n",
            "10                    3.0  \n",
            "11                    3.0  \n",
            "12                    3.0  \n",
            "13                    1.0  \n",
            "14                    1.0  \n",
            "15                    0.0  \n",
            "16                    0.0  \n",
            "17                    0.0  \n",
            "             team  mean team Goal scored 3  mean team Goal conceded 3  \\\n",
            "0        Brighton                      4.0                        1.0   \n",
            "1     Aston Villa                      4.0                        0.0   \n",
            "2       Brentford                      3.0                        0.0   \n",
            "3       Newcastle                      2.5                        1.0   \n",
            "4         Chelsea                      2.5                        2.0   \n",
            "5   Nott'm Forest                      2.0                        1.0   \n",
            "6           Spurs                      2.0                        1.0   \n",
            "7        Man City                      2.0                        0.0   \n",
            "8          Wolves                      2.0                        0.0   \n",
            "9         Man Utd                      2.0                        1.0   \n",
            "10        Arsenal                      1.5                        0.5   \n",
            "11    Bournemouth                      1.0                        2.0   \n",
            "12  Sheffield Utd                      1.0                        2.0   \n",
            "13        Burnley                      0.0                        3.0   \n",
            "\n",
            "    mean team Goal scored all  mean team Goal conceded all  \\\n",
            "0                         4.0                          1.0   \n",
            "1                         4.0                          0.0   \n",
            "2                         3.0                          0.0   \n",
            "3                         2.5                          1.0   \n",
            "4                         2.5                          2.0   \n",
            "5                         2.0                          1.0   \n",
            "6                         2.0                          1.0   \n",
            "7                         2.0                          0.0   \n",
            "8                         2.0                          0.0   \n",
            "9                         2.0                          1.0   \n",
            "10                        1.5                          0.5   \n",
            "11                        1.0                          2.0   \n",
            "12                        1.0                          2.0   \n",
            "13                        0.0                          3.0   \n",
            "\n",
            "    mean match_result all  \n",
            "0                     3.0  \n",
            "1                     3.0  \n",
            "2                     3.0  \n",
            "3                     1.5  \n",
            "4                     1.5  \n",
            "5                     3.0  \n",
            "6                     2.0  \n",
            "7                     3.0  \n",
            "8                     3.0  \n",
            "9                     2.0  \n",
            "10                    3.0  \n",
            "11                    0.5  \n",
            "12                    0.0  \n",
            "13                    0.0  \n",
            "              team  mean team Goal scored 3  mean team Goal conceded 3  \\\n",
            "0         Brighton                 4.000000                   1.000000   \n",
            "1      Aston Villa                 3.500000                   0.500000   \n",
            "2        Liverpool                 3.000000                   1.000000   \n",
            "3         West Ham                 3.000000                   1.000000   \n",
            "4          Chelsea                 2.666667                   1.333333   \n",
            "5        Newcastle                 2.500000                   1.000000   \n",
            "6    Sheffield Utd                 2.500000                   2.500000   \n",
            "7            Spurs                 3.000000                   0.666667   \n",
            "8         Man City                 2.000000                   0.333333   \n",
            "9        Brentford                 2.000000                   1.000000   \n",
            "10   Nott'm Forest                 2.000000                   2.000000   \n",
            "11         Man Utd                 2.000000                   0.666667   \n",
            "12          Wolves                 2.000000                   0.333333   \n",
            "13         Arsenal                 1.666667                   1.000000   \n",
            "14  Crystal Palace                 1.666667                   1.000000   \n",
            "15           Luton                 1.666667                   1.000000   \n",
            "16     Bournemouth                 0.666667                   2.000000   \n",
            "17          Fulham                 0.500000                   1.500000   \n",
            "18         Everton                 0.000000                   2.500000   \n",
            "\n",
            "    mean team Goal scored all  mean team Goal conceded all  \\\n",
            "0                    4.000000                     1.000000   \n",
            "1                    3.500000                     0.500000   \n",
            "2                    3.000000                     1.000000   \n",
            "3                    3.000000                     1.000000   \n",
            "4                    2.666667                     1.333333   \n",
            "5                    2.500000                     1.000000   \n",
            "6                    2.500000                     2.500000   \n",
            "7                    2.428571                     0.857143   \n",
            "8                    2.000000                     0.333333   \n",
            "9                    2.000000                     1.000000   \n",
            "10                   2.000000                     2.000000   \n",
            "11                   2.000000                     0.666667   \n",
            "12                   2.000000                     0.333333   \n",
            "13                   1.666667                     1.000000   \n",
            "14                   1.666667                     1.000000   \n",
            "15                   1.666667                     1.000000   \n",
            "16                   0.666667                     2.000000   \n",
            "17                   0.500000                     1.500000   \n",
            "18                   0.000000                     2.500000   \n",
            "\n",
            "    mean match_result all  \n",
            "0                3.000000  \n",
            "1                3.000000  \n",
            "2                3.000000  \n",
            "3                3.000000  \n",
            "4                2.000000  \n",
            "5                1.500000  \n",
            "6                1.500000  \n",
            "7                2.428571  \n",
            "8                3.000000  \n",
            "9                1.666667  \n",
            "10               1.500000  \n",
            "11               2.333333  \n",
            "12               3.000000  \n",
            "13               2.333333  \n",
            "14               2.333333  \n",
            "15               2.333333  \n",
            "16               0.333333  \n",
            "17               1.500000  \n",
            "18               0.000000  \n",
            "              team  mean team Goal scored 3  mean team Goal conceded 3  \\\n",
            "0         Brighton                 3.666667                   1.000000   \n",
            "1            Spurs                 3.500000                   1.000000   \n",
            "2        Liverpool                 3.000000                   0.500000   \n",
            "3         Man City                 3.000000                   0.333333   \n",
            "4    Sheffield Utd                 3.000000                   0.333333   \n",
            "5         West Ham                 2.500000                   1.000000   \n",
            "6      Aston Villa                 2.333333                   1.333333   \n",
            "7   Crystal Palace                 2.000000                   1.000000   \n",
            "8        Brentford                 2.000000                   1.000000   \n",
            "9          Arsenal                 2.000000                   1.000000   \n",
            "10          Wolves                 1.666667                   1.333333   \n",
            "11           Luton                 2.000000                   1.000000   \n",
            "12       Newcastle                 2.000000                   1.666667   \n",
            "13         Chelsea                 1.333333                   1.333333   \n",
            "14         Man Utd                 1.666667                   1.000000   \n",
            "15   Nott'm Forest                 1.666667                   1.333333   \n",
            "16     Bournemouth                 1.000000                   2.333333   \n",
            "17         Everton                 1.000000                   3.000000   \n",
            "18          Fulham                 0.666667                   2.666667   \n",
            "\n",
            "    mean team Goal scored all  mean team Goal conceded all  \\\n",
            "0                    3.666667                     1.000000   \n",
            "1                    3.500000                     1.000000   \n",
            "2                    3.000000                     0.500000   \n",
            "3                    3.000000                     0.333333   \n",
            "4                    3.000000                     0.333333   \n",
            "5                    2.500000                     1.000000   \n",
            "6                    2.333333                     1.333333   \n",
            "7                    2.000000                     1.000000   \n",
            "8                    2.000000                     1.250000   \n",
            "9                    2.000000                     1.000000   \n",
            "10                   2.000000                     1.000000   \n",
            "11                   2.000000                     1.000000   \n",
            "12                   2.000000                     1.666667   \n",
            "13                   2.000000                     1.250000   \n",
            "14                   1.750000                     1.250000   \n",
            "15                   1.666667                     1.333333   \n",
            "16                   1.000000                     2.000000   \n",
            "17                   1.000000                     3.000000   \n",
            "18                   0.666667                     2.666667   \n",
            "\n",
            "    mean match_result all  \n",
            "0                    3.00  \n",
            "1                    3.00  \n",
            "2                    3.00  \n",
            "3                    3.00  \n",
            "4                    3.00  \n",
            "5                    3.00  \n",
            "6                    2.00  \n",
            "7                    2.50  \n",
            "8                    1.50  \n",
            "9                    2.50  \n",
            "10                   2.25  \n",
            "11                   2.50  \n",
            "12                   1.00  \n",
            "13                   1.50  \n",
            "14                   1.75  \n",
            "15                   2.00  \n",
            "16                   0.50  \n",
            "17                   0.50  \n",
            "18                   1.00  \n",
            "              team  mean team Goal scored 3  mean team Goal conceded 3  \\\n",
            "0         Brighton                 3.333333                   1.000000   \n",
            "1         Man City                 3.000000                   0.666667   \n",
            "2            Spurs                 3.000000                   1.000000   \n",
            "3        Liverpool                 3.000000                   0.666667   \n",
            "4      Aston Villa                 2.000000                   1.666667   \n",
            "5    Sheffield Utd                 2.333333                   1.000000   \n",
            "6         West Ham                 2.000000                   1.666667   \n",
            "7          Arsenal                 2.000000                   1.000000   \n",
            "8           Wolves                 1.666667                   2.333333   \n",
            "9   Crystal Palace                 2.000000                   2.000000   \n",
            "10       Newcastle                 0.666667                   1.333333   \n",
            "11       Brentford                 1.000000                   1.333333   \n",
            "12         Chelsea                 1.000000                   0.333333   \n",
            "13           Luton                 1.666667                   1.333333   \n",
            "14         Man Utd                 1.333333                   2.000000   \n",
            "15   Nott'm Forest                 1.333333                   1.333333   \n",
            "16     Bournemouth                 0.666667                   1.333333   \n",
            "17          Fulham                 0.666667                   2.666667   \n",
            "18         Everton                 0.666667                   2.333333   \n",
            "\n",
            "    mean team Goal scored all  mean team Goal conceded all  \\\n",
            "0                    3.500000                     1.000000   \n",
            "1                    3.000000                     0.500000   \n",
            "2                    3.000000                     1.000000   \n",
            "3                    3.000000                     0.666667   \n",
            "4                    2.500000                     1.250000   \n",
            "5                    2.500000                     0.750000   \n",
            "6                    2.000000                     1.666667   \n",
            "7                    1.800000                     0.800000   \n",
            "8                    1.800000                     1.400000   \n",
            "9                    1.800000                     1.400000   \n",
            "10                   1.750000                     1.250000   \n",
            "11                   1.600000                     1.200000   \n",
            "12                   1.600000                     1.000000   \n",
            "13                   1.600000                     1.000000   \n",
            "14                   1.600000                     1.600000   \n",
            "15                   1.500000                     1.250000   \n",
            "16                   0.800000                     1.600000   \n",
            "17                   0.750000                     2.000000   \n",
            "18                   0.666667                     2.333333   \n",
            "\n",
            "    mean match_result all  \n",
            "0                3.000000  \n",
            "1                3.000000  \n",
            "2                3.000000  \n",
            "3                3.000000  \n",
            "4                2.250000  \n",
            "5                2.250000  \n",
            "6                2.000000  \n",
            "7                2.600000  \n",
            "8                1.800000  \n",
            "9                2.000000  \n",
            "10               1.500000  \n",
            "11               1.200000  \n",
            "12               1.400000  \n",
            "13               2.000000  \n",
            "14               1.400000  \n",
            "15               1.750000  \n",
            "16               0.600000  \n",
            "17               1.500000  \n",
            "18               0.333333  \n",
            "              team  mean team Goal scored 3  mean team Goal conceded 3  \\\n",
            "0         Brighton                 3.000000                   1.000000   \n",
            "1        Newcastle                 3.333333                   1.000000   \n",
            "2        Liverpool                 3.000000                   0.666667   \n",
            "3         Man City                 3.333333                   0.666667   \n",
            "4            Spurs                 3.000000                   1.666667   \n",
            "5      Aston Villa                 1.333333                   1.333333   \n",
            "6    Sheffield Utd                 2.000000                   3.666667   \n",
            "7          Burnley                 2.000000                   5.000000   \n",
            "8          Arsenal                 2.000000                   1.000000   \n",
            "9         West Ham                 1.333333                   2.333333   \n",
            "10          Wolves                 1.333333                   2.333333   \n",
            "11       Brentford                 1.000000                   2.000000   \n",
            "12  Crystal Palace                 1.333333                   1.333333   \n",
            "13           Luton                 1.333333                   1.000000   \n",
            "14         Man Utd                 1.000000                   2.000000   \n",
            "15         Chelsea                 0.000000                   0.666667   \n",
            "16         Everton                 1.666667                   1.333333   \n",
            "17   Nott'm Forest                 0.666667                   1.000000   \n",
            "18     Bournemouth                 1.000000                   1.666667   \n",
            "19          Fulham                 0.666667                   1.666667   \n",
            "\n",
            "    mean team Goal scored all  mean team Goal conceded all  \\\n",
            "0                    3.400000                     1.000000   \n",
            "1                    3.000000                     1.000000   \n",
            "2                    3.000000                     0.750000   \n",
            "3                    2.800000                     0.400000   \n",
            "4                    2.750000                     1.250000   \n",
            "5                    2.200000                     1.000000   \n",
            "6                    2.000000                     2.200000   \n",
            "7                    2.000000                     5.000000   \n",
            "8                    1.833333                     1.000000   \n",
            "9                    1.750000                     2.000000   \n",
            "10                   1.666667                     1.333333   \n",
            "11                   1.500000                     1.500000   \n",
            "12                   1.500000                     1.166667   \n",
            "13                   1.500000                     1.000000   \n",
            "14                   1.500000                     1.333333   \n",
            "15                   1.333333                     1.000000   \n",
            "16                   1.250000                     2.000000   \n",
            "17                   1.200000                     1.400000   \n",
            "18                   0.833333                     1.833333   \n",
            "19                   0.600000                     1.600000   \n",
            "\n",
            "    mean match_result all  \n",
            "0                3.000000  \n",
            "1                1.800000  \n",
            "2                3.000000  \n",
            "3                3.000000  \n",
            "4                2.500000  \n",
            "5                2.400000  \n",
            "6                1.800000  \n",
            "7                0.000000  \n",
            "8                2.333333  \n",
            "9                1.500000  \n",
            "10               1.666667  \n",
            "11               1.000000  \n",
            "12               1.833333  \n",
            "13               1.833333  \n",
            "14               1.666667  \n",
            "15               1.166667  \n",
            "16               1.000000  \n",
            "17               1.400000  \n",
            "18               0.500000  \n",
            "19               1.400000  \n",
            "              team  mean team Goal scored 3  mean team Goal conceded 3  \\\n",
            "0         Brighton                 2.333333                   2.666667   \n",
            "1        Newcastle                 3.666667                   0.000000   \n",
            "2      Aston Villa                 3.333333                   0.666667   \n",
            "3            Spurs                 2.000000                   1.333333   \n",
            "4        Liverpool                 2.333333                   1.333333   \n",
            "5         Man City                 2.000000                   1.000000   \n",
            "6          Arsenal                 2.333333                   0.666667   \n",
            "7          Burnley                 2.000000                   3.000000   \n",
            "8         West Ham                 1.333333                   2.000000   \n",
            "9           Wolves                 1.333333                   1.666667   \n",
            "10   Sheffield Utd                 0.333333                   4.000000   \n",
            "11           Luton                 1.000000                   1.000000   \n",
            "12       Brentford                 0.666667                   1.666667   \n",
            "13         Chelsea                 0.666667                   0.333333   \n",
            "14  Crystal Palace                 0.666667                   1.000000   \n",
            "15         Man Utd                 0.666667                   1.333333   \n",
            "16         Everton                 1.333333                   1.333333   \n",
            "17   Nott'm Forest                 0.666667                   1.333333   \n",
            "18     Bournemouth                 0.333333                   2.333333   \n",
            "19          Fulham                 0.333333                   0.666667   \n",
            "\n",
            "    mean team Goal scored all  mean team Goal conceded all  \\\n",
            "0                    3.000000                     1.833333   \n",
            "1                    2.833333                     0.833333   \n",
            "2                    2.833333                     1.000000   \n",
            "3                    2.600000                     1.200000   \n",
            "4                    2.600000                     1.000000   \n",
            "5                    2.500000                     0.666667   \n",
            "6                    2.166667                     0.833333   \n",
            "7                    2.000000                     3.000000   \n",
            "8                    1.800000                     1.600000   \n",
            "9                    1.714286                     1.285714   \n",
            "10                   1.666667                     2.166667   \n",
            "11                   1.571429                     1.000000   \n",
            "12                   1.428571                     1.428571   \n",
            "13                   1.428571                     0.857143   \n",
            "14                   1.428571                     1.000000   \n",
            "15                   1.285714                     1.285714   \n",
            "16                   1.200000                     2.000000   \n",
            "17                   1.166667                     1.333333   \n",
            "18                   0.714286                     2.142857   \n",
            "19                   0.500000                     1.666667   \n",
            "\n",
            "    mean match_result all  \n",
            "0                2.500000  \n",
            "1                2.000000  \n",
            "2                2.500000  \n",
            "3                2.600000  \n",
            "4                2.400000  \n",
            "5                2.500000  \n",
            "6                2.333333  \n",
            "7                1.500000  \n",
            "8                1.800000  \n",
            "9                1.857143  \n",
            "10               1.500000  \n",
            "11               2.000000  \n",
            "12               1.000000  \n",
            "13               1.428571  \n",
            "14               2.000000  \n",
            "15               1.428571  \n",
            "16               0.800000  \n",
            "17               1.333333  \n",
            "18               0.428571  \n",
            "19               1.166667  \n",
            "              team  mean team Goal scored 3  mean team Goal conceded 3  \\\n",
            "0         Brighton                 2.000000                   3.000000   \n",
            "1        Newcastle                 4.000000                   0.666667   \n",
            "2      Aston Villa                 2.666667                   0.666667   \n",
            "3        Liverpool                 2.000000                   1.666667   \n",
            "4            Spurs                 1.666667                   1.000000   \n",
            "5         Man City                 1.000000                   1.000000   \n",
            "6          Arsenal                 2.333333                   0.666667   \n",
            "7         West Ham                 1.666667                   1.666667   \n",
            "8          Chelsea                 2.000000                   0.666667   \n",
            "9          Burnley                 1.666667                   3.333333   \n",
            "10          Wolves                 1.333333                   1.000000   \n",
            "11   Sheffield Utd                 0.333333                   4.333333   \n",
            "12         Everton                 2.333333                   1.000000   \n",
            "13           Luton                 1.333333                   1.333333   \n",
            "14       Brentford                 1.000000                   2.000000   \n",
            "15         Man Utd                 1.000000                   0.666667   \n",
            "16  Crystal Palace                 0.333333                   0.000000   \n",
            "17   Nott'm Forest                 0.333333                   1.000000   \n",
            "18          Fulham                 1.000000                   1.000000   \n",
            "19     Bournemouth                 0.333333                   3.333333   \n",
            "\n",
            "    mean team Goal scored all  mean team Goal conceded all  \\\n",
            "0                    2.857143                     1.857143   \n",
            "1                    2.714286                     1.000000   \n",
            "2                    2.571429                     1.000000   \n",
            "3                    2.500000                     1.166667   \n",
            "4                    2.333333                     1.000000   \n",
            "5                    2.142857                     0.714286   \n",
            "6                    2.000000                     0.750000   \n",
            "7                    1.833333                     1.666667   \n",
            "8                    1.750000                     0.875000   \n",
            "9                    1.666667                     3.333333   \n",
            "10                   1.625000                     1.250000   \n",
            "11                   1.571429                     2.285714   \n",
            "12                   1.500000                     1.666667   \n",
            "13                   1.500000                     1.125000   \n",
            "14                   1.375000                     1.500000   \n",
            "15                   1.375000                     1.250000   \n",
            "16                   1.250000                     0.875000   \n",
            "17                   1.000000                     1.250000   \n",
            "18                   0.857143                     1.571429   \n",
            "19                   0.625000                     2.250000   \n",
            "\n",
            "    mean match_result all  \n",
            "0                2.285714  \n",
            "1                1.857143  \n",
            "2                2.285714  \n",
            "3                2.166667  \n",
            "4                2.666667  \n",
            "5                2.142857  \n",
            "6                2.500000  \n",
            "7                1.666667  \n",
            "8                1.625000  \n",
            "9                1.000000  \n",
            "10               1.750000  \n",
            "11               1.285714  \n",
            "12               1.166667  \n",
            "13               1.750000  \n",
            "14               0.875000  \n",
            "15               1.625000  \n",
            "16               1.875000  \n",
            "17               1.125000  \n",
            "18               1.428571  \n",
            "19               0.375000  \n",
            "              team  mean team Goal scored 3  mean team Goal conceded 3  \\\n",
            "0        Newcastle                 2.666667                   0.666667   \n",
            "1      Aston Villa                 3.666667                   1.000000   \n",
            "2         Brighton                 1.333333                   3.333333   \n",
            "3        Liverpool                 1.666667                   1.333333   \n",
            "4            Spurs                 1.666667                   0.333333   \n",
            "5         Man City                 1.000000                   1.333333   \n",
            "6    Sheffield Utd                 2.000000                   2.000000   \n",
            "7          Arsenal                 2.333333                   0.666667   \n",
            "8          Chelsea                 2.666667                   1.000000   \n",
            "9         West Ham                 1.666667                   2.000000   \n",
            "10          Wolves                 1.666667                   1.000000   \n",
            "11       Brentford                 1.666667                   1.000000   \n",
            "12         Man Utd                 1.333333                   1.000000   \n",
            "13           Luton                 1.000000                   1.333333   \n",
            "14         Everton                 1.333333                   1.333333   \n",
            "15         Burnley                 1.000000                   2.666667   \n",
            "16   Nott'm Forest                 1.000000                   1.000000   \n",
            "17  Crystal Palace                 0.333333                   1.333333   \n",
            "18          Fulham                 1.000000                   1.666667   \n",
            "19     Bournemouth                 0.333333                   3.000000   \n",
            "\n",
            "    mean team Goal scored all  mean team Goal conceded all  \\\n",
            "0                    2.875000                     0.875000   \n",
            "1                    2.750000                     1.000000   \n",
            "2                    2.625000                     1.875000   \n",
            "3                    2.428571                     1.000000   \n",
            "4                    2.285714                     0.857143   \n",
            "5                    2.125000                     0.750000   \n",
            "6                    2.000000                     2.000000   \n",
            "7                    2.000000                     0.888889   \n",
            "8                    1.777778                     1.000000   \n",
            "9                    1.714286                     2.000000   \n",
            "10                   1.666667                     1.222222   \n",
            "11                   1.555556                     1.333333   \n",
            "12                   1.444444                     1.222222   \n",
            "13                   1.333333                     1.111111   \n",
            "14                   1.285714                     1.714286   \n",
            "15                   1.250000                     3.250000   \n",
            "16                   1.125000                     1.250000   \n",
            "17                   1.111111                     1.222222   \n",
            "18                   0.750000                     1.625000   \n",
            "19                   0.666667                     2.222222   \n",
            "\n",
            "    mean match_result all  \n",
            "0                2.000000  \n",
            "1                2.375000  \n",
            "2                2.000000  \n",
            "3                2.285714  \n",
            "4                2.714286  \n",
            "5                2.250000  \n",
            "6                1.000000  \n",
            "7                2.333333  \n",
            "8                1.555556  \n",
            "9                1.428571  \n",
            "10               1.888889  \n",
            "11               1.111111  \n",
            "12               1.777778  \n",
            "13               1.555556  \n",
            "14               1.000000  \n",
            "15               0.750000  \n",
            "16               1.250000  \n",
            "17               1.666667  \n",
            "18               1.250000  \n",
            "19               0.333333  \n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data=pd.concat(list_data_gw)\n",
        "data=data.drop_duplicates([\"GW\",\"team\",\"opponent\",\"name\",\"kickoff_time\"])"
      ],
      "metadata": {
        "id": "UXi__NAemMsX"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "data.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "DopkZkF5ZVDn",
        "outputId": "b1ff7a2c-dff1-4ecd-f4d7-4a5fbe0282ef"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(6061, 122)"
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "5398+509"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "qq_vixo0Wj_Y",
        "outputId": "4f38b970-4495-4685-be9a-10100ece50bf"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "5907"
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "UFlr1eTmVcge",
        "outputId": "11fe6e8a-0226-4274-e2ff-a690385709a4"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(6061, 122)"
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# save cleaned files\n",
        "for i in range(1, gameweek + 1):\n",
        "    data_gw = data[data[\"GW\"] == i]\n",
        "    data_gw.to_csv(f\"/content/drive/MyDrive/Fplpredict /cleaned_dataset/2023-24/GW{i}.csv\")\n",
        "    print(i)"
      ],
      "metadata": {
        "id": "xHuXp5hBq0Cd",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "968a8d72-8d79-424f-c44a-930bd5b120e6"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "1\n",
            "2\n",
            "3\n",
            "4\n",
            "5\n",
            "6\n",
            "7\n",
            "8\n",
            "9\n",
            "10\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# DEBUGGING ERRORS"
      ],
      "metadata": {
        "id": "mggaCFoTv1Km"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "list(data.columns)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "viXqu5WolOgm",
        "outputId": "f8318a01-5e62-4ee4-caa9-3f11baa80dc4"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['total_points',\n",
              " 'was_home',\n",
              " 'kickoff_time',\n",
              " 'minutes',\n",
              " 'goals_scored',\n",
              " 'assists',\n",
              " 'clean_sheets',\n",
              " 'goals_conceded',\n",
              " 'own_goals',\n",
              " 'penalties_saved',\n",
              " 'penalties_missed',\n",
              " 'yellow_cards',\n",
              " 'red_cards',\n",
              " 'saves',\n",
              " 'bonus',\n",
              " 'bps',\n",
              " 'influence',\n",
              " 'creativity',\n",
              " 'threat',\n",
              " 'ict_index',\n",
              " 'value',\n",
              " 'transfers_balance',\n",
              " 'selected',\n",
              " 'transfers_in',\n",
              " 'transfers_out',\n",
              " 'name',\n",
              " 'cost',\n",
              " 'position',\n",
              " 'team',\n",
              " 'GW',\n",
              " 'match_result',\n",
              " 'opponent',\n",
              " 'last_season_position',\n",
              " 'opponent_last_season_position',\n",
              " 'percent_value',\n",
              " 'position rank',\n",
              " 'goals_scored_ex',\n",
              " 'assists_ex',\n",
              " 'total_points_ex',\n",
              " 'minutes_ex',\n",
              " 'goals_conceded_ex',\n",
              " 'creativity_ex',\n",
              " 'influence_ex',\n",
              " 'threat_ex',\n",
              " 'bonus_ex',\n",
              " 'bps_ex',\n",
              " 'ict_index_ex',\n",
              " 'clean_sheets_ex',\n",
              " 'red_cards_ex',\n",
              " 'yellow_cards_ex',\n",
              " 'selected_by_percent_ex',\n",
              " 'now_cost_ex',\n",
              " 'team Goal scored',\n",
              " 'team Goal conceded',\n",
              " 'element_type_ex',\n",
              " 'season',\n",
              " 'mean assists 3',\n",
              " 'mean assists all',\n",
              " 'mean bonus 3',\n",
              " 'mean bonus all',\n",
              " 'mean bps 3',\n",
              " 'mean bps all',\n",
              " 'mean clean_sheets 3',\n",
              " 'mean clean_sheets all',\n",
              " 'mean creativity 3',\n",
              " 'mean creativity all',\n",
              " 'mean goals_conceded 3',\n",
              " 'mean goals_conceded all',\n",
              " 'mean goals_scored 3',\n",
              " 'mean goals_scored all',\n",
              " 'mean ict_index 3',\n",
              " 'mean ict_index all',\n",
              " 'mean influence 3',\n",
              " 'mean influence all',\n",
              " 'mean minutes 3',\n",
              " 'mean minutes all',\n",
              " 'mean own_goals 3',\n",
              " 'mean own_goals all',\n",
              " 'mean penalties_missed 3',\n",
              " 'mean penalties_missed all',\n",
              " 'mean penalties_saved 3',\n",
              " 'mean penalties_saved all',\n",
              " 'mean red_cards 3',\n",
              " 'mean red_cards all',\n",
              " 'mean saves 3',\n",
              " 'mean saves all',\n",
              " 'mean selected 3',\n",
              " 'mean selected all',\n",
              " 'mean threat 3',\n",
              " 'mean threat all',\n",
              " 'mean total_points 3',\n",
              " 'mean total_points all',\n",
              " 'mean transfers_in 3',\n",
              " 'mean transfers_in all',\n",
              " 'mean transfers_out 3',\n",
              " 'mean transfers_out all',\n",
              " 'mean value 3',\n",
              " 'mean value all',\n",
              " 'mean match_result 3',\n",
              " 'mean match_result all',\n",
              " 'mean team Goal scored 3',\n",
              " 'mean team Goal scored all',\n",
              " 'mean team Goal conceded 3',\n",
              " 'mean team Goal conceded all',\n",
              " 'std bps 3',\n",
              " 'std creativity 3',\n",
              " 'std ict_index 3',\n",
              " 'std influence 3',\n",
              " 'std minutes 3',\n",
              " 'std selected 3',\n",
              " 'std threat 3',\n",
              " 'std total_points 3',\n",
              " 'std transfers_in 3',\n",
              " 'std transfers_out 3',\n",
              " 'std value 3',\n",
              " 'ratio_goal_scored 3',\n",
              " 'ratio_goal_scored all',\n",
              " 'opp mean team Goal scored 3',\n",
              " 'opp mean team Goal conceded 3',\n",
              " 'opp mean team Goal scored all',\n",
              " 'opp mean team Goal conceded all',\n",
              " 'opp mean match_result all']"
            ]
          },
          "metadata": {},
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "for GW in range(1,gameweek + 1):\n",
        "  print(f\"GW{GW}\")\n",
        "  print(data[data[\"GW\"]==GW][\"team\"].shape)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "7uyA6jQDzTD5",
        "outputId": "fb7de6f7-773c-40b1-ab15-142fed9f8e51"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "GW1\n",
            "(613,)\n",
            "GW2\n",
            "(585,)\n",
            "GW3\n",
            "(405,)\n",
            "GW4\n",
            "(584,)\n",
            "GW5\n",
            "(585,)\n",
            "GW6\n",
            "(585,)\n",
            "GW7\n",
            "(658,)\n",
            "GW8\n",
            "(658,)\n",
            "GW9\n",
            "(658,)\n",
            "GW10\n",
            "(730,)\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "for GW in range(1,gameweek + 1):\n",
        "  print(f\"GW{GW}\")\n",
        "  print(len(data[data[\"GW\"]==GW][\"team\"].unique()))\n",
        "  print(data[data[\"GW\"]==GW].drop_duplicates(subset=\"team\")[[\"team\",\"opponent\",\"last_season_position\",\"mean team Goal scored all\",\"opp mean team Goal scored all\"]].reset_index().drop(\"index\",axis=1))#.sort_values(\"last_season_position\"))\n",
        "  print(\"\\n\\n\")\n",
        "  #.sort_values(by=\"mean team Goal scored all\", ascending=False)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "6fIgmPpekUFY",
        "outputId": "387f446b-2378-467a-ebf3-311d6b82890d"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "GW1\n",
            "20\n",
            "              team        opponent  last_season_position  \\\n",
            "0            Spurs       Brentford                     8   \n",
            "1         Brighton           Luton                     6   \n",
            "2         West Ham     Bournemouth                    14   \n",
            "3        Brentford           Spurs                     9   \n",
            "4          Arsenal   Nott'm Forest                     2   \n",
            "5          Man Utd          Wolves                     3   \n",
            "6          Everton          Fulham                    17   \n",
            "7          Chelsea       Liverpool                    12   \n",
            "8    Sheffield Utd  Crystal Palace                    20   \n",
            "9      Bournemouth        West Ham                    15   \n",
            "10           Luton        Brighton                    20   \n",
            "11       Liverpool         Chelsea                     5   \n",
            "12          Fulham         Everton                    10   \n",
            "13   Nott'm Forest         Arsenal                    16   \n",
            "14       Newcastle     Aston Villa                     4   \n",
            "15     Aston Villa       Newcastle                     7   \n",
            "16         Burnley        Man City                    20   \n",
            "17        Man City         Burnley                     1   \n",
            "18          Wolves         Man Utd                    13   \n",
            "19  Crystal Palace   Sheffield Utd                    11   \n",
            "\n",
            "    mean team Goal scored all  opp mean team Goal scored all  \n",
            "0                         2.0                            NaN  \n",
            "1                         NaN                            NaN  \n",
            "2                         NaN                            NaN  \n",
            "3                         NaN                            2.0  \n",
            "4                         NaN                            NaN  \n",
            "5                         NaN                            NaN  \n",
            "6                         NaN                            NaN  \n",
            "7                         NaN                            NaN  \n",
            "8                         NaN                            NaN  \n",
            "9                         NaN                            NaN  \n",
            "10                        NaN                            NaN  \n",
            "11                        NaN                            NaN  \n",
            "12                        NaN                            NaN  \n",
            "13                        NaN                            NaN  \n",
            "14                        NaN                            NaN  \n",
            "15                        NaN                            NaN  \n",
            "16                        NaN                            NaN  \n",
            "17                        NaN                            NaN  \n",
            "18                        NaN                            NaN  \n",
            "19                        NaN                            NaN  \n",
            "\n",
            "\n",
            "\n",
            "GW2\n",
            "18\n",
            "              team        opponent  last_season_position  \\\n",
            "0        Newcastle       Liverpool                     4   \n",
            "1         Brighton        West Ham                     6   \n",
            "2          Chelsea           Luton                    12   \n",
            "3         Man City   Sheffield Utd                     1   \n",
            "4          Arsenal          Fulham                     2   \n",
            "5        Brentford  Crystal Palace                     9   \n",
            "6            Spurs     Bournemouth                     8   \n",
            "7      Aston Villa         Burnley                     7   \n",
            "8      Bournemouth           Spurs                    15   \n",
            "9    Nott'm Forest         Man Utd                    16   \n",
            "10         Man Utd   Nott'm Forest                     3   \n",
            "11  Crystal Palace       Brentford                    11   \n",
            "12          Fulham         Arsenal                    10   \n",
            "13        West Ham        Brighton                    14   \n",
            "14       Liverpool       Newcastle                     5   \n",
            "15          Wolves         Everton                    13   \n",
            "16         Everton          Wolves                    17   \n",
            "17   Sheffield Utd        Man City                    20   \n",
            "\n",
            "    mean team Goal scored all  opp mean team Goal scored all  \n",
            "0                         5.0                            1.0  \n",
            "1                         4.0                            1.0  \n",
            "2                         4.0                            NaN  \n",
            "3                         3.0                            0.0  \n",
            "4                         2.0                            1.0  \n",
            "5                         2.0                            1.0  \n",
            "6                         2.0                            1.0  \n",
            "7                         1.0                            NaN  \n",
            "8                         1.0                            2.0  \n",
            "9                         1.0                            1.0  \n",
            "10                        1.0                            1.0  \n",
            "11                        1.0                            2.0  \n",
            "12                        1.0                            2.0  \n",
            "13                        1.0                            4.0  \n",
            "14                        1.0                            5.0  \n",
            "15                        0.0                            0.0  \n",
            "16                        0.0                            0.0  \n",
            "17                        0.0                            3.0  \n",
            "\n",
            "\n",
            "\n",
            "GW3\n",
            "14\n",
            "             team        opponent  last_season_position  \\\n",
            "0        Brighton        West Ham                     6   \n",
            "1     Aston Villa         Burnley                     7   \n",
            "2       Brentford  Crystal Palace                     9   \n",
            "3       Newcastle       Liverpool                     4   \n",
            "4         Chelsea           Luton                    12   \n",
            "5   Nott'm Forest         Man Utd                    16   \n",
            "6           Spurs     Bournemouth                     8   \n",
            "7        Man City   Sheffield Utd                     1   \n",
            "8          Wolves   Sheffield Utd                    13   \n",
            "9         Man Utd     Bournemouth                     3   \n",
            "10        Arsenal          Fulham                     2   \n",
            "11    Bournemouth           Spurs                    15   \n",
            "12  Sheffield Utd        Man City                    20   \n",
            "13        Burnley     Aston Villa                    20   \n",
            "\n",
            "    mean team Goal scored all  opp mean team Goal scored all  \n",
            "0                         4.0                            NaN  \n",
            "1                         4.0                            0.0  \n",
            "2                         3.0                            NaN  \n",
            "3                         2.5                            NaN  \n",
            "4                         2.5                            NaN  \n",
            "5                         2.0                            2.0  \n",
            "6                         2.0                            1.0  \n",
            "7                         2.0                            1.0  \n",
            "8                         2.0                            1.0  \n",
            "9                         2.0                            1.0  \n",
            "10                        1.5                            NaN  \n",
            "11                        1.0                            2.0  \n",
            "12                        1.0                            2.0  \n",
            "13                        0.0                            4.0  \n",
            "\n",
            "\n",
            "\n",
            "GW4\n",
            "19\n",
            "              team        opponent  last_season_position  \\\n",
            "0         Brighton       Newcastle                     6   \n",
            "1      Aston Villa       Liverpool                     7   \n",
            "2        Liverpool     Aston Villa                     5   \n",
            "3         West Ham           Luton                    14   \n",
            "4          Chelsea   Nott'm Forest                    12   \n",
            "5        Newcastle        Brighton                     4   \n",
            "6    Sheffield Utd         Everton                    20   \n",
            "7            Spurs         Burnley                     8   \n",
            "8         Man City          Fulham                     1   \n",
            "9        Brentford     Bournemouth                     9   \n",
            "10   Nott'm Forest         Chelsea                    16   \n",
            "11         Man Utd         Arsenal                     3   \n",
            "12          Wolves  Crystal Palace                    13   \n",
            "13         Arsenal         Man Utd                     2   \n",
            "14  Crystal Palace         Arsenal                    11   \n",
            "15           Luton         Arsenal                    20   \n",
            "16     Bournemouth       Brentford                    15   \n",
            "17          Fulham        Man City                    10   \n",
            "18         Everton   Sheffield Utd                    17   \n",
            "\n",
            "    mean team Goal scored all  opp mean team Goal scored all  \n",
            "0                    4.000000                       2.500000  \n",
            "1                    3.500000                       3.000000  \n",
            "2                    3.000000                       3.500000  \n",
            "3                    3.000000                       1.666667  \n",
            "4                    2.666667                       2.000000  \n",
            "5                    2.500000                       4.000000  \n",
            "6                    2.500000                       0.000000  \n",
            "7                    2.428571                            NaN  \n",
            "8                    2.000000                       0.500000  \n",
            "9                    2.000000                       0.666667  \n",
            "10                   2.000000                       2.666667  \n",
            "11                   2.000000                       1.666667  \n",
            "12                   2.000000                       1.666667  \n",
            "13                   1.666667                       2.000000  \n",
            "14                   1.666667                       1.666667  \n",
            "15                   1.666667                       1.666667  \n",
            "16                   0.666667                       2.000000  \n",
            "17                   0.500000                       2.000000  \n",
            "18                   0.000000                       2.500000  \n",
            "\n",
            "\n",
            "\n",
            "GW5\n",
            "19\n",
            "              team        opponent  last_season_position  \\\n",
            "0         Brighton         Man Utd                     6   \n",
            "1            Spurs   Sheffield Utd                     8   \n",
            "2        Liverpool          Wolves                     5   \n",
            "3         Man City        West Ham                     1   \n",
            "4    Sheffield Utd           Spurs                    20   \n",
            "5         West Ham        Man City                    14   \n",
            "6      Aston Villa  Crystal Palace                     7   \n",
            "7   Crystal Palace     Aston Villa                    11   \n",
            "8        Brentford       Newcastle                     9   \n",
            "9          Arsenal         Everton                     2   \n",
            "10          Wolves       Liverpool                    13   \n",
            "11           Luton          Fulham                    20   \n",
            "12       Newcastle       Brentford                     4   \n",
            "13         Chelsea     Bournemouth                    12   \n",
            "14         Man Utd        Brighton                     3   \n",
            "15   Nott'm Forest         Burnley                    16   \n",
            "16     Bournemouth         Chelsea                    15   \n",
            "17         Everton         Arsenal                    17   \n",
            "18          Fulham           Luton                    10   \n",
            "\n",
            "    mean team Goal scored all  opp mean team Goal scored all  \n",
            "0                    3.666667                       1.750000  \n",
            "1                    3.500000                       3.000000  \n",
            "2                    3.000000                       2.000000  \n",
            "3                    3.000000                       2.500000  \n",
            "4                    3.000000                       3.500000  \n",
            "5                    2.500000                       3.000000  \n",
            "6                    2.333333                       2.000000  \n",
            "7                    2.000000                       2.333333  \n",
            "8                    2.000000                       2.000000  \n",
            "9                    2.000000                       1.000000  \n",
            "10                   2.000000                       3.000000  \n",
            "11                   2.000000                       0.666667  \n",
            "12                   2.000000                       2.000000  \n",
            "13                   2.000000                       1.000000  \n",
            "14                   1.750000                       3.666667  \n",
            "15                   1.666667                            NaN  \n",
            "16                   1.000000                       2.000000  \n",
            "17                   1.000000                       2.000000  \n",
            "18                   0.666667                       2.000000  \n",
            "\n",
            "\n",
            "\n",
            "GW6\n",
            "19\n",
            "              team        opponent  last_season_position  \\\n",
            "0         Brighton     Bournemouth                     6   \n",
            "1         Man City   Nott'm Forest                     1   \n",
            "2            Spurs         Arsenal                     8   \n",
            "3        Liverpool        West Ham                     5   \n",
            "4      Aston Villa         Chelsea                     7   \n",
            "5    Sheffield Utd       Newcastle                    20   \n",
            "6         West Ham       Liverpool                    14   \n",
            "7          Arsenal           Spurs                     2   \n",
            "8           Wolves           Luton                    13   \n",
            "9   Crystal Palace          Fulham                    11   \n",
            "10       Newcastle   Sheffield Utd                     4   \n",
            "11       Brentford         Everton                     9   \n",
            "12         Chelsea     Aston Villa                    12   \n",
            "13           Luton          Wolves                    20   \n",
            "14         Man Utd         Burnley                     3   \n",
            "15   Nott'm Forest        Man City                    16   \n",
            "16     Bournemouth        Brighton                    15   \n",
            "17          Fulham  Crystal Palace                    10   \n",
            "18         Everton       Brentford                    17   \n",
            "\n",
            "    mean team Goal scored all  opp mean team Goal scored all  \n",
            "0                    3.500000                       0.800000  \n",
            "1                    3.000000                       1.500000  \n",
            "2                    3.000000                       1.800000  \n",
            "3                    3.000000                       2.000000  \n",
            "4                    2.500000                       1.600000  \n",
            "5                    2.500000                       1.750000  \n",
            "6                    2.000000                       3.000000  \n",
            "7                    1.800000                       3.000000  \n",
            "8                    1.800000                       1.600000  \n",
            "9                    1.800000                       0.750000  \n",
            "10                   1.750000                       2.500000  \n",
            "11                   1.600000                       0.666667  \n",
            "12                   1.600000                       2.500000  \n",
            "13                   1.600000                       1.800000  \n",
            "14                   1.600000                            NaN  \n",
            "15                   1.500000                       3.000000  \n",
            "16                   0.800000                       3.500000  \n",
            "17                   0.750000                       1.800000  \n",
            "18                   0.666667                       1.600000  \n",
            "\n",
            "\n",
            "\n",
            "GW7\n",
            "20\n",
            "              team        opponent  last_season_position  \\\n",
            "0         Brighton     Aston Villa                     6   \n",
            "1        Newcastle         Burnley                     4   \n",
            "2        Liverpool           Spurs                     5   \n",
            "3         Man City          Wolves                     1   \n",
            "4            Spurs       Liverpool                     8   \n",
            "5      Aston Villa        Brighton                     7   \n",
            "6    Sheffield Utd        West Ham                    20   \n",
            "7          Burnley       Newcastle                    20   \n",
            "8          Arsenal     Bournemouth                     2   \n",
            "9         West Ham   Sheffield Utd                    14   \n",
            "10          Wolves        Man City                    13   \n",
            "11       Brentford   Nott'm Forest                     9   \n",
            "12  Crystal Palace         Man Utd                    11   \n",
            "13           Luton         Everton                    20   \n",
            "14         Man Utd  Crystal Palace                     3   \n",
            "15         Chelsea          Fulham                    12   \n",
            "16         Everton           Luton                    17   \n",
            "17   Nott'm Forest       Brentford                    16   \n",
            "18     Bournemouth         Arsenal                    15   \n",
            "19          Fulham         Chelsea                    10   \n",
            "\n",
            "    mean team Goal scored all  opp mean team Goal scored all  \n",
            "0                    3.400000                       2.200000  \n",
            "1                    3.000000                       2.000000  \n",
            "2                    3.000000                       2.750000  \n",
            "3                    2.800000                       1.666667  \n",
            "4                    2.750000                       3.000000  \n",
            "5                    2.200000                       3.400000  \n",
            "6                    2.000000                       1.750000  \n",
            "7                    2.000000                       3.000000  \n",
            "8                    1.833333                       0.833333  \n",
            "9                    1.750000                       2.000000  \n",
            "10                   1.666667                       2.800000  \n",
            "11                   1.500000                       1.200000  \n",
            "12                   1.500000                       1.500000  \n",
            "13                   1.500000                       1.250000  \n",
            "14                   1.500000                       1.500000  \n",
            "15                   1.333333                       0.600000  \n",
            "16                   1.250000                       1.500000  \n",
            "17                   1.200000                       1.500000  \n",
            "18                   0.833333                       1.833333  \n",
            "19                   0.600000                       1.333333  \n",
            "\n",
            "\n",
            "\n",
            "GW8\n",
            "20\n",
            "              team        opponent  last_season_position  \\\n",
            "0         Brighton       Liverpool                     6   \n",
            "1        Newcastle        West Ham                     4   \n",
            "2      Aston Villa          Wolves                     7   \n",
            "3            Spurs           Luton                     8   \n",
            "4        Liverpool        Brighton                     5   \n",
            "5         Man City         Arsenal                     1   \n",
            "6          Arsenal        Man City                     2   \n",
            "7          Burnley         Chelsea                    20   \n",
            "8         West Ham       Newcastle                    14   \n",
            "9           Wolves     Aston Villa                    13   \n",
            "10   Sheffield Utd          Fulham                    20   \n",
            "11           Luton           Spurs                    20   \n",
            "12       Brentford         Man Utd                     9   \n",
            "13         Chelsea         Burnley                    12   \n",
            "14  Crystal Palace   Nott'm Forest                    11   \n",
            "15         Man Utd       Brentford                     3   \n",
            "16         Everton     Bournemouth                    17   \n",
            "17   Nott'm Forest  Crystal Palace                    16   \n",
            "18     Bournemouth         Everton                    15   \n",
            "19          Fulham   Sheffield Utd                    10   \n",
            "\n",
            "    mean team Goal scored all  opp mean team Goal scored all  \n",
            "0                    3.000000                       2.600000  \n",
            "1                    2.833333                       1.800000  \n",
            "2                    2.833333                       1.714286  \n",
            "3                    2.600000                       1.571429  \n",
            "4                    2.600000                       3.000000  \n",
            "5                    2.500000                       2.166667  \n",
            "6                    2.166667                       2.500000  \n",
            "7                    2.000000                       1.428571  \n",
            "8                    1.800000                       2.833333  \n",
            "9                    1.714286                       2.833333  \n",
            "10                   1.666667                       0.500000  \n",
            "11                   1.571429                       2.600000  \n",
            "12                   1.428571                       1.285714  \n",
            "13                   1.428571                       2.000000  \n",
            "14                   1.428571                       1.166667  \n",
            "15                   1.285714                       1.428571  \n",
            "16                   1.200000                       0.714286  \n",
            "17                   1.166667                       1.428571  \n",
            "18                   0.714286                       1.200000  \n",
            "19                   0.500000                       1.666667  \n",
            "\n",
            "\n",
            "\n",
            "GW9\n",
            "20\n",
            "              team        opponent  last_season_position  \\\n",
            "0         Brighton        Man City                     6   \n",
            "1        Newcastle  Crystal Palace                     4   \n",
            "2      Aston Villa        West Ham                     7   \n",
            "3        Liverpool         Everton                     5   \n",
            "4            Spurs          Fulham                     8   \n",
            "5         Man City        Brighton                     1   \n",
            "6          Arsenal         Chelsea                     2   \n",
            "7         West Ham     Aston Villa                    14   \n",
            "8          Chelsea         Arsenal                    12   \n",
            "9          Burnley       Brentford                    20   \n",
            "10          Wolves     Bournemouth                    13   \n",
            "11   Sheffield Utd         Man Utd                    20   \n",
            "12         Everton       Liverpool                    17   \n",
            "13           Luton   Nott'm Forest                    20   \n",
            "14       Brentford         Burnley                     9   \n",
            "15         Man Utd   Sheffield Utd                     3   \n",
            "16  Crystal Palace       Newcastle                    11   \n",
            "17   Nott'm Forest           Luton                    16   \n",
            "18          Fulham           Spurs                    10   \n",
            "19     Bournemouth          Wolves                    15   \n",
            "\n",
            "    mean team Goal scored all  opp mean team Goal scored all  \n",
            "0                    2.857143                       2.142857  \n",
            "1                    2.714286                       1.250000  \n",
            "2                    2.571429                       1.833333  \n",
            "3                    2.500000                       1.500000  \n",
            "4                    2.333333                       0.857143  \n",
            "5                    2.142857                       2.857143  \n",
            "6                    2.000000                       1.750000  \n",
            "7                    1.833333                       2.571429  \n",
            "8                    1.750000                       2.000000  \n",
            "9                    1.666667                       1.375000  \n",
            "10                   1.625000                       0.625000  \n",
            "11                   1.571429                       1.375000  \n",
            "12                   1.500000                       2.500000  \n",
            "13                   1.500000                       1.000000  \n",
            "14                   1.375000                       1.666667  \n",
            "15                   1.375000                       1.571429  \n",
            "16                   1.250000                       2.714286  \n",
            "17                   1.000000                       1.500000  \n",
            "18                   0.857143                       2.333333  \n",
            "19                   0.625000                       1.625000  \n",
            "\n",
            "\n",
            "\n",
            "GW10\n",
            "20\n",
            "              team        opponent  last_season_position  \\\n",
            "0        Newcastle          Wolves                     4   \n",
            "1      Aston Villa           Luton                     7   \n",
            "2         Brighton          Fulham                     6   \n",
            "3        Liverpool   Nott'm Forest                     5   \n",
            "4            Spurs  Crystal Palace                     8   \n",
            "5         Man City         Man Utd                     1   \n",
            "6    Sheffield Utd         Arsenal                    20   \n",
            "7          Arsenal   Sheffield Utd                     2   \n",
            "8          Chelsea       Brentford                    12   \n",
            "9         West Ham         Everton                    14   \n",
            "10          Wolves       Newcastle                    13   \n",
            "11       Brentford         Chelsea                     9   \n",
            "12         Man Utd        Man City                     3   \n",
            "13           Luton     Aston Villa                    20   \n",
            "14         Everton        West Ham                    17   \n",
            "15         Burnley     Bournemouth                    20   \n",
            "16   Nott'm Forest       Liverpool                    16   \n",
            "17  Crystal Palace           Spurs                    11   \n",
            "18          Fulham        Brighton                    10   \n",
            "19     Bournemouth         Burnley                    15   \n",
            "\n",
            "    mean team Goal scored all  opp mean team Goal scored all  \n",
            "0                    2.875000                       1.666667  \n",
            "1                    2.750000                       1.333333  \n",
            "2                    2.625000                       0.750000  \n",
            "3                    2.428571                       1.125000  \n",
            "4                    2.285714                       1.111111  \n",
            "5                    2.125000                       1.444444  \n",
            "6                    2.000000                       2.000000  \n",
            "7                    2.000000                       2.000000  \n",
            "8                    1.777778                       1.555556  \n",
            "9                    1.714286                       1.285714  \n",
            "10                   1.666667                       2.875000  \n",
            "11                   1.555556                       1.777778  \n",
            "12                   1.444444                       2.125000  \n",
            "13                   1.333333                       2.750000  \n",
            "14                   1.285714                       1.714286  \n",
            "15                   1.250000                       0.666667  \n",
            "16                   1.125000                       2.428571  \n",
            "17                   1.111111                       2.285714  \n",
            "18                   0.750000                       2.625000  \n",
            "19                   0.666667                       1.250000  \n",
            "\n",
            "\n",
            "\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data[pd.isna(data[\"opp mean team Goal scored all\"])][\"GW\"].value_counts()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "BSdHYAgDBcAo",
        "outputId": "bb6a7221-11c9-464f-f84d-88e5631bb677"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "1    582\n",
              "3    174\n",
              "2     72\n",
              "5     44\n",
              "4     34\n",
              "6     34\n",
              "Name: GW, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data[pd.isna(data[\"opp mean team Goal scored all\"])]. shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "dXh5AkYSBoFO",
        "outputId": "1fb6b968-f321-4d0b-ee07-ada1a3ecf63b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(940, 122)"
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data[pd.isna(data[\"opp mean team Goal scored all\"])][\"GW\"].value_counts()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "en6WKp1JuKHt",
        "outputId": "78f97708-cf15-4ecc-c4b0-efbe25f81d65"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "1    582\n",
              "3    174\n",
              "2     72\n",
              "5     44\n",
              "4     34\n",
              "6     34\n",
              "Name: GW, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_gw[pd.isna(data_gw[\"opp mean team Goal scored all\"])][\"opponent\"].value_counts()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "nYjirOR2uQGC",
        "outputId": "1669bc74-915e-488e-ab78-febe0a7d941d"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Series([], Name: opponent, dtype: int64)"
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_gw[data_gw[\"opponent\"]==\"Crystal Palace\"][[\"name\",\"team\"]]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "Rraam1o0uQzJ",
        "outputId": "7d7a96de-0ff1-4014-a637-52866e746a07"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                              name   team\n",
              "107               Micky van de Ven  Spurs\n",
              "108                  Dane Scarlett  Spurs\n",
              "109                    Alejo Véliz  Spurs\n",
              "110                Pape Matar Sarr  Spurs\n",
              "111                    Hugo Lloris  Spurs\n",
              "113         Tanguy Ndombélé Alvaro  Spurs\n",
              "116                  Manor Solomon  Spurs\n",
              "117                Japhet Tanganga  Spurs\n",
              "118                 James Maddison  Spurs\n",
              "126               Davinson Sánchez  Spurs\n",
              "128               Dejan Kulusevski  Spurs\n",
              "130                 Destiny Udogie  Spurs\n",
              "132                Cristian Romero  Spurs\n",
              "133              Guglielmo Vicario  Spurs\n",
              "134                      Joe Rodon  Spurs\n",
              "135                    Pedro Porro  Spurs\n",
              "138               Giovani Lo Celso  Spurs\n",
              "140         Richarlison de Andrade  Spurs\n",
              "142                 Ryan Sessegnon  Spurs\n",
              "145                   Ivan Perišić  Spurs\n",
              "147                   Oliver Skipp  Spurs\n",
              "149                    Djed Spence  Spurs\n",
              "150                  Son Heung-min  Spurs\n",
              "155                 Alfie Whiteman  Spurs\n",
              "157  Emerson Leite de Souza Junior  Spurs\n",
              "158                 Fraser Forster  Spurs\n",
              "159                     Harry Kane  Spurs\n",
              "160          Bryan Gil Salvatierra  Spurs\n",
              "161                     Ben Davies  Spurs\n",
              "162              Rodrigo Bentancur  Spurs\n",
              "163                  Yves Bissouma  Spurs\n",
              "164                      Eric Dier  Spurs\n",
              "165          Pierre-Emile Højbjerg  Spurs\n",
              "166                 Brandon Austin  Spurs\n",
              "231                Brennan Johnson  Spurs\n",
              "670                Ashley Phillips  Spurs\n",
              "693                   Jamie Donley  Spurs"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a7e9a256-e8af-49a3-bce9-6eb75077ffae\" class=\"colab-df-container\">\n",
              "    <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>name</th>\n",
              "      <th>team</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>107</th>\n",
              "      <td>Micky van de Ven</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>108</th>\n",
              "      <td>Dane Scarlett</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>109</th>\n",
              "      <td>Alejo Véliz</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>110</th>\n",
              "      <td>Pape Matar Sarr</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>111</th>\n",
              "      <td>Hugo Lloris</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>113</th>\n",
              "      <td>Tanguy Ndombélé Alvaro</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>116</th>\n",
              "      <td>Manor Solomon</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>117</th>\n",
              "      <td>Japhet Tanganga</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>118</th>\n",
              "      <td>James Maddison</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>126</th>\n",
              "      <td>Davinson Sánchez</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128</th>\n",
              "      <td>Dejan Kulusevski</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>130</th>\n",
              "      <td>Destiny Udogie</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>132</th>\n",
              "      <td>Cristian Romero</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>133</th>\n",
              "      <td>Guglielmo Vicario</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>134</th>\n",
              "      <td>Joe Rodon</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>135</th>\n",
              "      <td>Pedro Porro</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>138</th>\n",
              "      <td>Giovani Lo Celso</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>140</th>\n",
              "      <td>Richarlison de Andrade</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>142</th>\n",
              "      <td>Ryan Sessegnon</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>145</th>\n",
              "      <td>Ivan Perišić</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>147</th>\n",
              "      <td>Oliver Skipp</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>149</th>\n",
              "      <td>Djed Spence</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>150</th>\n",
              "      <td>Son Heung-min</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>155</th>\n",
              "      <td>Alfie Whiteman</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>157</th>\n",
              "      <td>Emerson Leite de Souza Junior</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>158</th>\n",
              "      <td>Fraser Forster</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>159</th>\n",
              "      <td>Harry Kane</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>160</th>\n",
              "      <td>Bryan Gil Salvatierra</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>161</th>\n",
              "      <td>Ben Davies</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>162</th>\n",
              "      <td>Rodrigo Bentancur</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>163</th>\n",
              "      <td>Yves Bissouma</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>164</th>\n",
              "      <td>Eric Dier</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>165</th>\n",
              "      <td>Pierre-Emile Højbjerg</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>166</th>\n",
              "      <td>Brandon Austin</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>231</th>\n",
              "      <td>Brennan Johnson</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>670</th>\n",
              "      <td>Ashley Phillips</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>693</th>\n",
              "      <td>Jamie Donley</td>\n",
              "      <td>Spurs</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a7e9a256-e8af-49a3-bce9-6eb75077ffae')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-a7e9a256-e8af-49a3-bce9-6eb75077ffae button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-a7e9a256-e8af-49a3-bce9-6eb75077ffae');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-7b36b688-9e19-4928-a634-f425117eeb93\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-7b36b688-9e19-4928-a634-f425117eeb93')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-7b36b688-9e19-4928-a634-f425117eeb93 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "KC04bBUuvhap"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}