weekly_fixtures.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "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/PeteJoh/FPL-Optimization-Tools/blob/main/weekly_fixtures.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "6EXafEw696R0",
        "outputId": "2d691a8a-a4ae-46cf-c492-0318325a66c9"
      },
      "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",
            "12\n",
            "13\n",
            "15\n",
            "16\n",
            "17\n",
            "18\n",
            "20\n",
            "21\n",
            "22\n",
            "23\n",
            "24\n",
            "25\n",
            "73\n",
            "186\n",
            "578\n",
            "597\n",
            "633\n",
            "638\n",
            "639\n",
            "657\n",
            "658\n",
            "659\n",
            "662\n",
            "665\n",
            "28\n",
            "29\n",
            "30\n",
            "31\n",
            "32\n",
            "33\n",
            "34\n",
            "35\n",
            "36\n",
            "37\n",
            "38\n",
            "39\n",
            "40\n",
            "41\n",
            "42\n",
            "43\n",
            "44\n",
            "45\n",
            "46\n",
            "47\n",
            "48\n",
            "49\n",
            "50\n",
            "51\n",
            "52\n",
            "53\n",
            "54\n",
            "55\n",
            "56\n",
            "57\n",
            "58\n",
            "233\n",
            "569\n",
            "598\n",
            "640\n",
            "641\n",
            "656\n",
            "59\n",
            "60\n",
            "61\n",
            "62\n",
            "63\n",
            "64\n",
            "65\n",
            "66\n",
            "67\n",
            "68\n",
            "69\n",
            "70\n",
            "71\n",
            "72\n",
            "74\n",
            "75\n",
            "76\n",
            "77\n",
            "78\n",
            "79\n",
            "80\n",
            "81\n",
            "83\n",
            "84\n",
            "85\n",
            "152\n",
            "580\n",
            "592\n",
            "599\n",
            "617\n",
            "86\n",
            "87\n",
            "88\n",
            "89\n",
            "90\n",
            "91\n",
            "92\n",
            "93\n",
            "94\n",
            "95\n",
            "96\n",
            "97\n",
            "98\n",
            "99\n",
            "100\n",
            "101\n",
            "102\n",
            "103\n",
            "104\n",
            "105\n",
            "106\n",
            "107\n",
            "108\n",
            "109\n",
            "110\n",
            "111\n",
            "112\n",
            "314\n",
            "338\n",
            "602\n",
            "634\n",
            "649\n",
            "661\n",
            "113\n",
            "114\n",
            "115\n",
            "116\n",
            "118\n",
            "119\n",
            "120\n",
            "121\n",
            "122\n",
            "123\n",
            "124\n",
            "125\n",
            "126\n",
            "127\n",
            "128\n",
            "129\n",
            "130\n",
            "131\n",
            "132\n",
            "133\n",
            "134\n",
            "135\n",
            "136\n",
            "137\n",
            "138\n",
            "139\n",
            "140\n",
            "141\n",
            "142\n",
            "143\n",
            "144\n",
            "145\n",
            "146\n",
            "147\n",
            "148\n",
            "149\n",
            "595\n",
            "600\n",
            "601\n",
            "615\n",
            "618\n",
            "628\n",
            "629\n",
            "663\n",
            "150\n",
            "151\n",
            "153\n",
            "154\n",
            "155\n",
            "157\n",
            "158\n",
            "160\n",
            "161\n",
            "162\n",
            "163\n",
            "164\n",
            "165\n",
            "166\n",
            "167\n",
            "168\n",
            "169\n",
            "170\n",
            "171\n",
            "172\n",
            "173\n",
            "174\n",
            "175\n",
            "176\n",
            "177\n",
            "178\n",
            "179\n",
            "180\n",
            "181\n",
            "182\n",
            "183\n",
            "184\n",
            "185\n",
            "187\n",
            "189\n",
            "386\n",
            "560\n",
            "575\n",
            "581\n",
            "621\n",
            "11\n",
            "159\n",
            "190\n",
            "193\n",
            "194\n",
            "195\n",
            "196\n",
            "197\n",
            "199\n",
            "200\n",
            "201\n",
            "202\n",
            "203\n",
            "205\n",
            "206\n",
            "207\n",
            "208\n",
            "209\n",
            "210\n",
            "211\n",
            "212\n",
            "213\n",
            "214\n",
            "215\n",
            "216\n",
            "445\n",
            "585\n",
            "644\n",
            "645\n",
            "646\n",
            "647\n",
            "650\n",
            "666\n",
            "156\n",
            "217\n",
            "218\n",
            "219\n",
            "220\n",
            "221\n",
            "222\n",
            "223\n",
            "224\n",
            "225\n",
            "226\n",
            "227\n",
            "228\n",
            "229\n",
            "230\n",
            "231\n",
            "232\n",
            "234\n",
            "235\n",
            "236\n",
            "237\n",
            "238\n",
            "577\n",
            "582\n",
            "603\n",
            "614\n",
            "624\n",
            "627\n",
            "651\n",
            "10\n",
            "19\n",
            "191\n",
            "239\n",
            "240\n",
            "241\n",
            "242\n",
            "243\n",
            "244\n",
            "245\n",
            "246\n",
            "247\n",
            "248\n",
            "249\n",
            "250\n",
            "251\n",
            "252\n",
            "253\n",
            "254\n",
            "255\n",
            "256\n",
            "257\n",
            "258\n",
            "259\n",
            "579\n",
            "586\n",
            "604\n",
            "605\n",
            "622\n",
            "260\n",
            "261\n",
            "262\n",
            "263\n",
            "264\n",
            "265\n",
            "266\n",
            "267\n",
            "268\n",
            "269\n",
            "270\n",
            "271\n",
            "272\n",
            "273\n",
            "274\n",
            "275\n",
            "276\n",
            "277\n",
            "278\n",
            "279\n",
            "280\n",
            "281\n",
            "282\n",
            "283\n",
            "284\n",
            "359\n",
            "568\n",
            "583\n",
            "611\n",
            "619\n",
            "630\n",
            "631\n",
            "632\n",
            "117\n",
            "192\n",
            "198\n",
            "285\n",
            "286\n",
            "287\n",
            "288\n",
            "289\n",
            "290\n",
            "291\n",
            "292\n",
            "293\n",
            "294\n",
            "295\n",
            "296\n",
            "297\n",
            "298\n",
            "299\n",
            "300\n",
            "301\n",
            "302\n",
            "303\n",
            "304\n",
            "305\n",
            "306\n",
            "307\n",
            "308\n",
            "309\n",
            "501\n",
            "570\n",
            "606\n",
            "616\n",
            "635\n",
            "310\n",
            "311\n",
            "312\n",
            "313\n",
            "315\n",
            "316\n",
            "317\n",
            "318\n",
            "319\n",
            "320\n",
            "321\n",
            "322\n",
            "323\n",
            "324\n",
            "325\n",
            "326\n",
            "327\n",
            "328\n",
            "329\n",
            "330\n",
            "331\n",
            "332\n",
            "333\n",
            "334\n",
            "335\n",
            "336\n",
            "337\n",
            "339\n",
            "636\n",
            "660\n",
            "340\n",
            "341\n",
            "342\n",
            "343\n",
            "344\n",
            "345\n",
            "346\n",
            "347\n",
            "348\n",
            "349\n",
            "350\n",
            "351\n",
            "352\n",
            "353\n",
            "354\n",
            "355\n",
            "356\n",
            "357\n",
            "358\n",
            "360\n",
            "361\n",
            "362\n",
            "363\n",
            "571\n",
            "607\n",
            "625\n",
            "626\n",
            "364\n",
            "365\n",
            "366\n",
            "367\n",
            "368\n",
            "369\n",
            "370\n",
            "371\n",
            "372\n",
            "373\n",
            "374\n",
            "375\n",
            "376\n",
            "377\n",
            "378\n",
            "379\n",
            "380\n",
            "381\n",
            "382\n",
            "383\n",
            "384\n",
            "385\n",
            "387\n",
            "389\n",
            "572\n",
            "593\n",
            "594\n",
            "613\n",
            "648\n",
            "652\n",
            "667\n",
            "390\n",
            "391\n",
            "392\n",
            "393\n",
            "394\n",
            "395\n",
            "396\n",
            "398\n",
            "399\n",
            "400\n",
            "401\n",
            "402\n",
            "403\n",
            "404\n",
            "405\n",
            "406\n",
            "407\n",
            "408\n",
            "409\n",
            "410\n",
            "411\n",
            "412\n",
            "413\n",
            "414\n",
            "415\n",
            "416\n",
            "417\n",
            "418\n",
            "419\n",
            "420\n",
            "421\n",
            "574\n",
            "590\n",
            "26\n",
            "422\n",
            "423\n",
            "424\n",
            "425\n",
            "426\n",
            "427\n",
            "428\n",
            "429\n",
            "430\n",
            "431\n",
            "432\n",
            "433\n",
            "434\n",
            "435\n",
            "436\n",
            "437\n",
            "438\n",
            "439\n",
            "440\n",
            "441\n",
            "442\n",
            "443\n",
            "444\n",
            "446\n",
            "447\n",
            "448\n",
            "449\n",
            "531\n",
            "573\n",
            "596\n",
            "620\n",
            "653\n",
            "14\n",
            "27\n",
            "188\n",
            "397\n",
            "450\n",
            "451\n",
            "452\n",
            "453\n",
            "454\n",
            "455\n",
            "456\n",
            "457\n",
            "458\n",
            "459\n",
            "460\n",
            "461\n",
            "462\n",
            "463\n",
            "464\n",
            "465\n",
            "466\n",
            "467\n",
            "468\n",
            "469\n",
            "470\n",
            "471\n",
            "472\n",
            "473\n",
            "474\n",
            "475\n",
            "476\n",
            "477\n",
            "515\n",
            "518\n",
            "584\n",
            "608\n",
            "623\n",
            "82\n",
            "478\n",
            "479\n",
            "480\n",
            "481\n",
            "482\n",
            "483\n",
            "484\n",
            "485\n",
            "486\n",
            "487\n",
            "488\n",
            "489\n",
            "490\n",
            "491\n",
            "492\n",
            "493\n",
            "494\n",
            "495\n",
            "496\n",
            "497\n",
            "498\n",
            "499\n",
            "500\n",
            "502\n",
            "503\n",
            "504\n",
            "505\n",
            "506\n",
            "507\n",
            "508\n",
            "509\n",
            "510\n",
            "609\n",
            "610\n",
            "612\n",
            "388\n",
            "511\n",
            "512\n",
            "513\n",
            "514\n",
            "516\n",
            "517\n",
            "519\n",
            "520\n",
            "521\n",
            "522\n",
            "523\n",
            "524\n",
            "525\n",
            "526\n",
            "527\n",
            "528\n",
            "529\n",
            "530\n",
            "532\n",
            "576\n",
            "587\n",
            "588\n",
            "589\n",
            "591\n",
            "643\n",
            "654\n",
            "204\n",
            "533\n",
            "534\n",
            "535\n",
            "536\n",
            "537\n",
            "538\n",
            "539\n",
            "540\n",
            "541\n",
            "542\n",
            "543\n",
            "544\n",
            "545\n",
            "546\n",
            "547\n",
            "548\n",
            "549\n",
            "550\n",
            "551\n",
            "552\n",
            "553\n",
            "554\n",
            "555\n",
            "556\n",
            "557\n",
            "558\n",
            "559\n",
            "561\n",
            "562\n",
            "563\n",
            "564\n",
            "565\n",
            "566\n",
            "567\n",
            "637\n",
            "642\n",
            "655\n",
            "664\n"
          ]
        }
      ],
      "source": [
        "import requests\n",
        "import pandas as pd\n",
        "\n",
        "def get_player_fixture_info(id):\n",
        "    player_info = requests.get(\n",
        "        f\"https://fantasy.premierleague.com/api/element-summary/{id}/\"\n",
        "    ).json()\n",
        "    fixture = player_info[\"fixtures\"][0]\n",
        "    home_team = get_team_name(fixture[\"team_h\"])\n",
        "    away_team = get_team_name(fixture[\"team_a\"])\n",
        "    kickoff_time = fixture[\"kickoff_time\"]\n",
        "    is_home = fixture[\"is_home\"]\n",
        "    return home_team, away_team, kickoff_time, is_home\n",
        "\n",
        "\n",
        "def get_gameweek_result(id, gameweek):\n",
        "    \"returns a dictionary of the statistics from the gameweek\"\n",
        "    gameweek_results = requests.get(\n",
        "    f\"https://fantasy.premierleague.com/api/element-summary/{id}/\").json()\n",
        "    return gameweek_results[\"history\"][gameweek-1]\n",
        "\n",
        "def get_team_name(id):\n",
        "    general_information = requests.get(\n",
        "        \"https://fantasy.premierleague.com/api/bootstrap-static/\"\n",
        "    ).json()\n",
        "    teams = general_information[\"teams\"]\n",
        "    for team in teams:\n",
        "        if team[\"id\"] == id:\n",
        "            return team[\"name\"]\n",
        "\n",
        "\n",
        "def get_player_position(element_type):\n",
        "    general_information = requests.get(\n",
        "        \"https://fantasy.premierleague.com/api/bootstrap-static/\"\n",
        "    ).json()\n",
        "    positions = general_information[\"element_types\"]\n",
        "    for position in positions:\n",
        "        if position[\"id\"] == element_type:\n",
        "            return position[\"singular_name_short\"]\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "general_info = requests.get(\n",
        "    f\"https://fantasy.premierleague.com/api/bootstrap-static/\"\n",
        ").json()\n",
        "player_infos = general_info[\"elements\"]\n",
        "gameweek = 10\n",
        "\n",
        "# WEEKLY fixtures fixtures\n",
        "my_teams = []\n",
        "home_teams = []\n",
        "away_teams = []\n",
        "kickoff_times = []\n",
        "is_homes = []\n",
        "positions = []\n",
        "costs = []\n",
        "names = []\n",
        "ids = []\n",
        "general_info = requests.get(\n",
        "    f\"https://fantasy.premierleague.com/api/bootstrap-static/\"\n",
        ").json()\n",
        "player_infos = general_info[\"elements\"]\n",
        "\n",
        "#print(player_infos[0])\n",
        "\n",
        "\n",
        "# week 1\n",
        "for player_info in player_infos:\n",
        "    id = player_info[\"id\"]\n",
        "    print(id)\n",
        "    name = player_info[\"first_name\"] + \" \" + player_info[\"second_name\"]\n",
        "    team_id = player_info[\"team\"]\n",
        "    cost = player_info[\"now_cost\"]\n",
        "    element_type = player_info[\"element_type\"]\n",
        "    my_team = get_team_name(team_id)\n",
        "    position = get_player_position(element_type)\n",
        "    home_team, away_team, kickoff_time, is_home = get_player_fixture_info(id)\n",
        "    ids.append(id)\n",
        "    names.append(name)\n",
        "    costs.append(cost)\n",
        "    positions.append(position)\n",
        "    my_teams.append(my_team)\n",
        "    home_teams.append(home_team)\n",
        "    away_teams.append(away_team)\n",
        "    kickoff_times.append(kickoff_time)\n",
        "    is_homes.append(is_home)\n",
        "\n",
        "\n",
        "df = pd.DataFrame()\n",
        "df[\"id\"] = ids\n",
        "df[\"name\"] = names\n",
        "df[\"cost\"] = costs\n",
        "df[\"position\"] = positions\n",
        "df[\"home_team\"] = home_teams\n",
        "df[\"away_team\"] = away_teams\n",
        "df[\"kickoff_time\"] = kickoff_times\n",
        "df[\"is_home\"] = is_homes\n",
        "df[\"team_x\"] = my_teams\n",
        "#"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df"
      ],
      "metadata": {
        "id": "Wm8Y6zlTec8e",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "outputId": "b2eba581-7c78-40a4-c983-58b3cb2293d7"
      },
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      id                          name  cost position home_team  away_team  \\\n",
              "0      1         Fábio Ferreira Vieira    54      MID   Arsenal  Liverpool   \n",
              "1      2     Gabriel Fernando de Jesus    68      FWD   Arsenal  Liverpool   \n",
              "2      3  Gabriel dos Santos Magalhães    63      DEF   Arsenal  Liverpool   \n",
              "3      4                   Kai Havertz    83      FWD   Arsenal  Liverpool   \n",
              "4      5                     Karl Hein    40      GKP   Arsenal  Liverpool   \n",
              "..   ...                           ...   ...      ...       ...        ...   \n",
              "662  567            Toti António Gomes    43      DEF  Brighton     Wolves   \n",
              "663  637              Bastien Meupiyou    40      DEF  Brighton     Wolves   \n",
              "664  642  André Trindade da Costa Neto    50      MID  Brighton     Wolves   \n",
              "665  655   Carlos Roberto Forbs Borges    55      MID  Brighton     Wolves   \n",
              "666  664                    Alfie Pond    40      DEF  Brighton     Wolves   \n",
              "\n",
              "             kickoff_time  is_home   team_x  \n",
              "0    2024-10-27T16:30:00Z     True  Arsenal  \n",
              "1    2024-10-27T16:30:00Z     True  Arsenal  \n",
              "2    2024-10-27T16:30:00Z     True  Arsenal  \n",
              "3    2024-10-27T16:30:00Z     True  Arsenal  \n",
              "4    2024-10-27T16:30:00Z     True  Arsenal  \n",
              "..                    ...      ...      ...  \n",
              "662  2024-10-26T14:00:00Z    False   Wolves  \n",
              "663  2024-10-26T14:00:00Z    False   Wolves  \n",
              "664  2024-10-26T14:00:00Z    False   Wolves  \n",
              "665  2024-10-26T14:00:00Z    False   Wolves  \n",
              "666  2024-10-26T14:00:00Z    False   Wolves  \n",
              "\n",
              "[667 rows x 9 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-763e8a74-0587-433e-8d13-28eeb48329d9\" 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>id</th>\n",
              "      <th>name</th>\n",
              "      <th>cost</th>\n",
              "      <th>position</th>\n",
              "      <th>home_team</th>\n",
              "      <th>away_team</th>\n",
              "      <th>kickoff_time</th>\n",
              "      <th>is_home</th>\n",
              "      <th>team_x</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Fábio Ferreira Vieira</td>\n",
              "      <td>54</td>\n",
              "      <td>MID</td>\n",
              "      <td>Arsenal</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>2024-10-27T16:30:00Z</td>\n",
              "      <td>True</td>\n",
              "      <td>Arsenal</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>Gabriel Fernando de Jesus</td>\n",
              "      <td>68</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Arsenal</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>2024-10-27T16:30:00Z</td>\n",
              "      <td>True</td>\n",
              "      <td>Arsenal</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>Gabriel dos Santos Magalhães</td>\n",
              "      <td>63</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Arsenal</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>2024-10-27T16:30:00Z</td>\n",
              "      <td>True</td>\n",
              "      <td>Arsenal</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>Kai Havertz</td>\n",
              "      <td>83</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Arsenal</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>2024-10-27T16:30:00Z</td>\n",
              "      <td>True</td>\n",
              "      <td>Arsenal</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>Karl Hein</td>\n",
              "      <td>40</td>\n",
              "      <td>GKP</td>\n",
              "      <td>Arsenal</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>2024-10-27T16:30:00Z</td>\n",
              "      <td>True</td>\n",
              "      <td>Arsenal</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>662</th>\n",
              "      <td>567</td>\n",
              "      <td>Toti António Gomes</td>\n",
              "      <td>43</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>663</th>\n",
              "      <td>637</td>\n",
              "      <td>Bastien Meupiyou</td>\n",
              "      <td>40</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>664</th>\n",
              "      <td>642</td>\n",
              "      <td>André Trindade da Costa Neto</td>\n",
              "      <td>50</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>665</th>\n",
              "      <td>655</td>\n",
              "      <td>Carlos Roberto Forbs Borges</td>\n",
              "      <td>55</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>666</th>\n",
              "      <td>664</td>\n",
              "      <td>Alfie Pond</td>\n",
              "      <td>40</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>667 rows × 9 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-763e8a74-0587-433e-8d13-28eeb48329d9')\"\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-763e8a74-0587-433e-8d13-28eeb48329d9 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-763e8a74-0587-433e-8d13-28eeb48329d9');\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-cda66b97-41d0-4f73-8bb6-7f3c2f92d794\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-cda66b97-41d0-4f73-8bb6-7f3c2f92d794')\"\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-cda66b97-41d0-4f73-8bb6-7f3c2f92d794 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_12472e06-5cf3-45ef-9c03-09ad437b0a4b\">\n",
              "    <style>\n",
              "      .colab-df-generate {\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-generate: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",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate: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",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('df')\"\n",
              "            title=\"Generate code using this dataframe.\"\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",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_12472e06-5cf3-45ef-9c03-09ad437b0a4b button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('df');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "df",
              "summary": "{\n  \"name\": \"df\",\n  \"rows\": 667,\n  \"fields\": [\n    {\n      \"column\": \"id\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 192,\n        \"min\": 1,\n        \"max\": 667,\n        \"num_unique_values\": 667,\n        \"samples\": [\n          565,\n          139,\n          538\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"name\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 667,\n        \"samples\": [\n          \"Pablo Sarabia\",\n          \"Odeluga Offiah\",\n          \"Tawanda Chirewa\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"cost\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 10,\n        \"min\": 39,\n        \"max\": 154,\n        \"num_unique_values\": 48,\n        \"samples\": [\n          56,\n          71,\n          51\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"position\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 4,\n        \"samples\": [\n          \"FWD\",\n          \"GKP\",\n          \"MID\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"home_team\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 10,\n        \"samples\": [\n          \"Man City\",\n          \"Aston Villa\",\n          \"Crystal Palace\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"away_team\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 10,\n        \"samples\": [\n          \"Southampton\",\n          \"Bournemouth\",\n          \"Spurs\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"kickoff_time\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \"2024-10-26T14:00:00Z\",\n          \"2024-10-25T19:00:00Z\",\n          \"2024-10-27T14:00:00Z\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"is_home\",\n      \"properties\": {\n        \"dtype\": \"boolean\",\n        \"num_unique_values\": 2,\n        \"samples\": [\n          false,\n          true\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"team_x\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 20,\n        \"samples\": [\n          \"Arsenal\",\n          \"Spurs\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df[df[\"team_x\"]==\"Wolves\"]"
      ],
      "metadata": {
        "id": "YJtzGvjIShjB",
        "outputId": "34ff5a55-13a9-4887-ce49-01c0d0e99bd5",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      id                              name  cost position home_team away_team  \\\n",
              "628  204                     Sam Johnstone    44      GKP  Brighton    Wolves   \n",
              "629  533                   Rayan Aït-Nouri    44      DEF  Brighton    Wolves   \n",
              "630  534                   Boubacar Traoré    48      MID  Brighton    Wolves   \n",
              "631  535            Jean-Ricner Bellegarde    50      MID  Brighton    Wolves   \n",
              "632  536                    Daniel Bentley    40      GKP  Brighton    Wolves   \n",
              "633  537    Francisco Jorge Tomás Oliveira    45      MID  Brighton    Wolves   \n",
              "634  538                   Tawanda Chirewa    45      MID  Brighton    Wolves   \n",
              "635  539                      Leon Chiwome    45      FWD  Brighton    Wolves   \n",
              "636  540                       Luke Cundle    45      MID  Brighton    Wolves   \n",
              "637  541  Matheus Santos Carneiro Da Cunha    65      FWD  Brighton    Wolves   \n",
              "638  542                      Craig Dawson    44      DEF  Brighton    Wolves   \n",
              "639  543                      Matt Doherty    44      DEF  Brighton    Wolves   \n",
              "640  544                       Tommy Doyle    48      MID  Brighton    Wolves   \n",
              "641  545                       Fábio Silva    50      FWD  Brighton    Wolves   \n",
              "642  546                     Nathan Fraser    45      FWD  Brighton    Wolves   \n",
              "643  547                     Enso González    45      MID  Brighton    Wolves   \n",
              "644  548   Gonçalo Manuel Ganchinho Guedes    53      MID  Brighton    Wolves   \n",
              "645  549                  Hugo Bueno López    45      DEF  Brighton    Wolves   \n",
              "646  550                    Hwang Hee-chan    61      MID  Brighton    Wolves   \n",
              "647  551                         Joe Hodge    45      MID  Brighton    Wolves   \n",
              "648  552                    Ki-Jana Hoever    40      DEF  Brighton    Wolves   \n",
              "649  553        João Victor Gomes da Silva    49      MID  Brighton    Wolves   \n",
              "650  554               José Malheiro de Sá    43      GKP  Brighton    Wolves   \n",
              "651  555                    Saša Kalajdžić    49      FWD  Brighton    Wolves   \n",
              "652  556                          Tom King    40      GKP  Brighton    Wolves   \n",
              "653  557                      Mario Lemina    50      MID  Brighton    Wolves   \n",
              "654  558                   Yerson Mosquera    40      DEF  Brighton    Wolves   \n",
              "655  559              Nélson Cabral Semedo    45      DEF  Brighton    Wolves   \n",
              "656  561             Pedro Cardoso de Lima    40      DEF  Brighton    Wolves   \n",
              "657  562            Daniel Castelo Podence    55      MID  Brighton    Wolves   \n",
              "658  563             Rodrigo Martins Gomes    52      MID  Brighton    Wolves   \n",
              "659  564                    Santiago Bueno    43      DEF  Brighton    Wolves   \n",
              "660  565                     Pablo Sarabia    51      MID  Brighton    Wolves   \n",
              "661  566              Jørgen Strand Larsen    55      FWD  Brighton    Wolves   \n",
              "662  567                Toti António Gomes    43      DEF  Brighton    Wolves   \n",
              "663  637                  Bastien Meupiyou    40      DEF  Brighton    Wolves   \n",
              "664  642      André Trindade da Costa Neto    50      MID  Brighton    Wolves   \n",
              "665  655       Carlos Roberto Forbs Borges    55      MID  Brighton    Wolves   \n",
              "666  664                        Alfie Pond    40      DEF  Brighton    Wolves   \n",
              "\n",
              "             kickoff_time  is_home  team_x  \n",
              "628  2024-10-26T14:00:00Z    False  Wolves  \n",
              "629  2024-10-26T14:00:00Z    False  Wolves  \n",
              "630  2024-10-26T14:00:00Z    False  Wolves  \n",
              "631  2024-10-26T14:00:00Z    False  Wolves  \n",
              "632  2024-10-26T14:00:00Z    False  Wolves  \n",
              "633  2024-10-26T14:00:00Z    False  Wolves  \n",
              "634  2024-10-26T14:00:00Z    False  Wolves  \n",
              "635  2024-10-26T14:00:00Z    False  Wolves  \n",
              "636  2024-10-26T14:00:00Z    False  Wolves  \n",
              "637  2024-10-26T14:00:00Z    False  Wolves  \n",
              "638  2024-10-26T14:00:00Z    False  Wolves  \n",
              "639  2024-10-26T14:00:00Z    False  Wolves  \n",
              "640  2024-10-26T14:00:00Z    False  Wolves  \n",
              "641  2024-10-26T14:00:00Z    False  Wolves  \n",
              "642  2024-10-26T14:00:00Z    False  Wolves  \n",
              "643  2024-10-26T14:00:00Z    False  Wolves  \n",
              "644  2024-10-26T14:00:00Z    False  Wolves  \n",
              "645  2024-10-26T14:00:00Z    False  Wolves  \n",
              "646  2024-10-26T14:00:00Z    False  Wolves  \n",
              "647  2024-10-26T14:00:00Z    False  Wolves  \n",
              "648  2024-10-26T14:00:00Z    False  Wolves  \n",
              "649  2024-10-26T14:00:00Z    False  Wolves  \n",
              "650  2024-10-26T14:00:00Z    False  Wolves  \n",
              "651  2024-10-26T14:00:00Z    False  Wolves  \n",
              "652  2024-10-26T14:00:00Z    False  Wolves  \n",
              "653  2024-10-26T14:00:00Z    False  Wolves  \n",
              "654  2024-10-26T14:00:00Z    False  Wolves  \n",
              "655  2024-10-26T14:00:00Z    False  Wolves  \n",
              "656  2024-10-26T14:00:00Z    False  Wolves  \n",
              "657  2024-10-26T14:00:00Z    False  Wolves  \n",
              "658  2024-10-26T14:00:00Z    False  Wolves  \n",
              "659  2024-10-26T14:00:00Z    False  Wolves  \n",
              "660  2024-10-26T14:00:00Z    False  Wolves  \n",
              "661  2024-10-26T14:00:00Z    False  Wolves  \n",
              "662  2024-10-26T14:00:00Z    False  Wolves  \n",
              "663  2024-10-26T14:00:00Z    False  Wolves  \n",
              "664  2024-10-26T14:00:00Z    False  Wolves  \n",
              "665  2024-10-26T14:00:00Z    False  Wolves  \n",
              "666  2024-10-26T14:00:00Z    False  Wolves  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-3438b343-3edf-4d2a-b9e3-0f1cadbab99d\" 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>id</th>\n",
              "      <th>name</th>\n",
              "      <th>cost</th>\n",
              "      <th>position</th>\n",
              "      <th>home_team</th>\n",
              "      <th>away_team</th>\n",
              "      <th>kickoff_time</th>\n",
              "      <th>is_home</th>\n",
              "      <th>team_x</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>628</th>\n",
              "      <td>204</td>\n",
              "      <td>Sam Johnstone</td>\n",
              "      <td>44</td>\n",
              "      <td>GKP</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>629</th>\n",
              "      <td>533</td>\n",
              "      <td>Rayan Aït-Nouri</td>\n",
              "      <td>44</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>630</th>\n",
              "      <td>534</td>\n",
              "      <td>Boubacar Traoré</td>\n",
              "      <td>48</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>631</th>\n",
              "      <td>535</td>\n",
              "      <td>Jean-Ricner Bellegarde</td>\n",
              "      <td>50</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>632</th>\n",
              "      <td>536</td>\n",
              "      <td>Daniel Bentley</td>\n",
              "      <td>40</td>\n",
              "      <td>GKP</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>633</th>\n",
              "      <td>537</td>\n",
              "      <td>Francisco Jorge Tomás Oliveira</td>\n",
              "      <td>45</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>634</th>\n",
              "      <td>538</td>\n",
              "      <td>Tawanda Chirewa</td>\n",
              "      <td>45</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>635</th>\n",
              "      <td>539</td>\n",
              "      <td>Leon Chiwome</td>\n",
              "      <td>45</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>636</th>\n",
              "      <td>540</td>\n",
              "      <td>Luke Cundle</td>\n",
              "      <td>45</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>637</th>\n",
              "      <td>541</td>\n",
              "      <td>Matheus Santos Carneiro Da Cunha</td>\n",
              "      <td>65</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>638</th>\n",
              "      <td>542</td>\n",
              "      <td>Craig Dawson</td>\n",
              "      <td>44</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>639</th>\n",
              "      <td>543</td>\n",
              "      <td>Matt Doherty</td>\n",
              "      <td>44</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>640</th>\n",
              "      <td>544</td>\n",
              "      <td>Tommy Doyle</td>\n",
              "      <td>48</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>641</th>\n",
              "      <td>545</td>\n",
              "      <td>Fábio Silva</td>\n",
              "      <td>50</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>642</th>\n",
              "      <td>546</td>\n",
              "      <td>Nathan Fraser</td>\n",
              "      <td>45</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>643</th>\n",
              "      <td>547</td>\n",
              "      <td>Enso González</td>\n",
              "      <td>45</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>644</th>\n",
              "      <td>548</td>\n",
              "      <td>Gonçalo Manuel Ganchinho Guedes</td>\n",
              "      <td>53</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>645</th>\n",
              "      <td>549</td>\n",
              "      <td>Hugo Bueno López</td>\n",
              "      <td>45</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>646</th>\n",
              "      <td>550</td>\n",
              "      <td>Hwang Hee-chan</td>\n",
              "      <td>61</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>647</th>\n",
              "      <td>551</td>\n",
              "      <td>Joe Hodge</td>\n",
              "      <td>45</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>648</th>\n",
              "      <td>552</td>\n",
              "      <td>Ki-Jana Hoever</td>\n",
              "      <td>40</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>649</th>\n",
              "      <td>553</td>\n",
              "      <td>João Victor Gomes da Silva</td>\n",
              "      <td>49</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>650</th>\n",
              "      <td>554</td>\n",
              "      <td>José Malheiro de Sá</td>\n",
              "      <td>43</td>\n",
              "      <td>GKP</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>651</th>\n",
              "      <td>555</td>\n",
              "      <td>Saša Kalajdžić</td>\n",
              "      <td>49</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>652</th>\n",
              "      <td>556</td>\n",
              "      <td>Tom King</td>\n",
              "      <td>40</td>\n",
              "      <td>GKP</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>653</th>\n",
              "      <td>557</td>\n",
              "      <td>Mario Lemina</td>\n",
              "      <td>50</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>654</th>\n",
              "      <td>558</td>\n",
              "      <td>Yerson Mosquera</td>\n",
              "      <td>40</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>655</th>\n",
              "      <td>559</td>\n",
              "      <td>Nélson Cabral Semedo</td>\n",
              "      <td>45</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>656</th>\n",
              "      <td>561</td>\n",
              "      <td>Pedro Cardoso de Lima</td>\n",
              "      <td>40</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>657</th>\n",
              "      <td>562</td>\n",
              "      <td>Daniel Castelo Podence</td>\n",
              "      <td>55</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>658</th>\n",
              "      <td>563</td>\n",
              "      <td>Rodrigo Martins Gomes</td>\n",
              "      <td>52</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>659</th>\n",
              "      <td>564</td>\n",
              "      <td>Santiago Bueno</td>\n",
              "      <td>43</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>660</th>\n",
              "      <td>565</td>\n",
              "      <td>Pablo Sarabia</td>\n",
              "      <td>51</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>661</th>\n",
              "      <td>566</td>\n",
              "      <td>Jørgen Strand Larsen</td>\n",
              "      <td>55</td>\n",
              "      <td>FWD</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>662</th>\n",
              "      <td>567</td>\n",
              "      <td>Toti António Gomes</td>\n",
              "      <td>43</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>663</th>\n",
              "      <td>637</td>\n",
              "      <td>Bastien Meupiyou</td>\n",
              "      <td>40</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>664</th>\n",
              "      <td>642</td>\n",
              "      <td>André Trindade da Costa Neto</td>\n",
              "      <td>50</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>665</th>\n",
              "      <td>655</td>\n",
              "      <td>Carlos Roberto Forbs Borges</td>\n",
              "      <td>55</td>\n",
              "      <td>MID</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>666</th>\n",
              "      <td>664</td>\n",
              "      <td>Alfie Pond</td>\n",
              "      <td>40</td>\n",
              "      <td>DEF</td>\n",
              "      <td>Brighton</td>\n",
              "      <td>Wolves</td>\n",
              "      <td>2024-10-26T14:00:00Z</td>\n",
              "      <td>False</td>\n",
              "      <td>Wolves</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-3438b343-3edf-4d2a-b9e3-0f1cadbab99d')\"\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-3438b343-3edf-4d2a-b9e3-0f1cadbab99d 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-3438b343-3edf-4d2a-b9e3-0f1cadbab99d');\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-d9d1b16f-8578-49d3-8a5d-78c700fddae7\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-d9d1b16f-8578-49d3-8a5d-78c700fddae7')\"\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-d9d1b16f-8578-49d3-8a5d-78c700fddae7 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "repr_error": "0"
            }
          },
          "metadata": {},
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# save to folder\n",
        "df.to_csv(f\"/content/drive/MyDrive/Fplpredict /datasets/2023-24/fixtures/GW{gameweek}.csv\")"
      ],
      "metadata": {
        "id": "B78Pv07fey9p",
        "outputId": "299303f1-1571-412b-d6d3-a8ca1a41595d",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 304
        }
      },
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "error",
          "ename": "OSError",
          "evalue": "Cannot save file into a non-existent directory: '/content/drive/MyDrive/Fplpredict /datasets/2023-24/fixtures'",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mOSError\u001b[0m                                   Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-5-119eb5b22e46>\u001b[0m in \u001b[0;36m<cell line: 2>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0;31m# save to folder\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 2\u001b[0;31m \u001b[0mdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34mf\"/content/drive/MyDrive/Fplpredict /datasets/2023-24/fixtures/GW{gameweek}.csv\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/util/_decorators.py\u001b[0m in \u001b[0;36mwrapper\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m    331\u001b[0m                     \u001b[0mstacklevel\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mfind_stack_level\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    332\u001b[0m                 )\n\u001b[0;32m--> 333\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    334\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    335\u001b[0m         \u001b[0;31m# error: \"Callable[[VarArg(Any), KwArg(Any)], Any]\" has no\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36mto_csv\u001b[0;34m(self, path_or_buf, sep, na_rep, float_format, columns, header, index, index_label, mode, encoding, compression, quoting, quotechar, lineterminator, chunksize, date_format, doublequote, escapechar, decimal, errors, storage_options)\u001b[0m\n\u001b[1;32m   3965\u001b[0m         )\n\u001b[1;32m   3966\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3967\u001b[0;31m         return DataFrameRenderer(formatter).to_csv(\n\u001b[0m\u001b[1;32m   3968\u001b[0m             \u001b[0mpath_or_buf\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3969\u001b[0m             \u001b[0mlineterminator\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mlineterminator\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/formats/format.py\u001b[0m in \u001b[0;36mto_csv\u001b[0;34m(self, path_or_buf, encoding, sep, columns, index_label, mode, compression, quoting, quotechar, lineterminator, chunksize, date_format, doublequote, escapechar, errors, storage_options)\u001b[0m\n\u001b[1;32m   1012\u001b[0m             \u001b[0mformatter\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mfmt\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1013\u001b[0m         )\n\u001b[0;32m-> 1014\u001b[0;31m         \u001b[0mcsv_formatter\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msave\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1015\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1016\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mcreated_buffer\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/formats/csvs.py\u001b[0m in \u001b[0;36msave\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    249\u001b[0m         \"\"\"\n\u001b[1;32m    250\u001b[0m         \u001b[0;31m# apply compression and byte/text conversion\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 251\u001b[0;31m         with get_handle(\n\u001b[0m\u001b[1;32m    252\u001b[0m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    253\u001b[0m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmode\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/common.py\u001b[0m in \u001b[0;36mget_handle\u001b[0;34m(path_or_buf, mode, encoding, compression, memory_map, is_text, errors, storage_options)\u001b[0m\n\u001b[1;32m    747\u001b[0m     \u001b[0;31m# Only for write methods\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    748\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0;34m\"r\"\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mmode\u001b[0m \u001b[0;32mand\u001b[0m \u001b[0mis_path\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 749\u001b[0;31m         \u001b[0mcheck_parent_directory\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mhandle\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    750\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    751\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mcompression\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.10/dist-packages/pandas/io/common.py\u001b[0m in \u001b[0;36mcheck_parent_directory\u001b[0;34m(path)\u001b[0m\n\u001b[1;32m    614\u001b[0m     \u001b[0mparent\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mPath\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mpath\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mparent\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    615\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mparent\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mis_dir\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 616\u001b[0;31m         \u001b[0;32mraise\u001b[0m \u001b[0mOSError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34mrf\"Cannot save file into a non-existent directory: '{parent}'\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    617\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    618\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;31mOSError\u001b[0m: Cannot save file into a non-existent directory: '/content/drive/MyDrive/Fplpredict /datasets/2023-24/fixtures'"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "S-nKBQucSkVe"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}