Football_Salaries_Notebook.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "86Q5JSOeMJFj",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "3b70a8cb-32f2-452c-948c-0a07cb8b0ccd"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Requirement already satisfied: pandas in /usr/local/lib/python3.10/dist-packages (1.5.3)\n",
            "Requirement already satisfied: python-dateutil>=2.8.1 in /usr/local/lib/python3.10/dist-packages (from pandas) (2.8.2)\n",
            "Requirement already satisfied: pytz>=2020.1 in /usr/local/lib/python3.10/dist-packages (from pandas) (2023.3.post1)\n",
            "Requirement already satisfied: numpy>=1.21.0 in /usr/local/lib/python3.10/dist-packages (from pandas) (1.23.5)\n",
            "Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.10/dist-packages (from python-dateutil>=2.8.1->pandas) (1.16.0)\n"
          ]
        }
      ],
      "source": [
        "pip install pandas"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd\n",
        "print(pd.__version__)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "8XirQs5OXEXG",
        "outputId": "12f00f6d-4510-4b23-f9ad-efe9c5cb46ad"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "1.5.3\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from google.colab import files"
      ],
      "metadata": {
        "id": "cuQqKtQrYujt"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "uploaded = files.upload()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 74
        },
        "id": "oaAK-dbY6-y2",
        "outputId": "051b8c36-801b-48ed-80df-614b546a8dd1"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<IPython.core.display.HTML object>"
            ],
            "text/html": [
              "\n",
              "     <input type=\"file\" id=\"files-23a8afad-d5e1-4aa6-a049-f20120db762e\" name=\"files[]\" multiple disabled\n",
              "        style=\"border:none\" />\n",
              "     <output id=\"result-23a8afad-d5e1-4aa6-a049-f20120db762e\">\n",
              "      Upload widget is only available when the cell has been executed in the\n",
              "      current browser session. Please rerun this cell to enable.\n",
              "      </output>\n",
              "      <script>// Copyright 2017 Google LLC\n",
              "//\n",
              "// Licensed under the Apache License, Version 2.0 (the \"License\");\n",
              "// you may not use this file except in compliance with the License.\n",
              "// You may obtain a copy of the License at\n",
              "//\n",
              "//      http://www.apache.org/licenses/LICENSE-2.0\n",
              "//\n",
              "// Unless required by applicable law or agreed to in writing, software\n",
              "// distributed under the License is distributed on an \"AS IS\" BASIS,\n",
              "// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\n",
              "// See the License for the specific language governing permissions and\n",
              "// limitations under the License.\n",
              "\n",
              "/**\n",
              " * @fileoverview Helpers for google.colab Python module.\n",
              " */\n",
              "(function(scope) {\n",
              "function span(text, styleAttributes = {}) {\n",
              "  const element = document.createElement('span');\n",
              "  element.textContent = text;\n",
              "  for (const key of Object.keys(styleAttributes)) {\n",
              "    element.style[key] = styleAttributes[key];\n",
              "  }\n",
              "  return element;\n",
              "}\n",
              "\n",
              "// Max number of bytes which will be uploaded at a time.\n",
              "const MAX_PAYLOAD_SIZE = 100 * 1024;\n",
              "\n",
              "function _uploadFiles(inputId, outputId) {\n",
              "  const steps = uploadFilesStep(inputId, outputId);\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  // Cache steps on the outputElement to make it available for the next call\n",
              "  // to uploadFilesContinue from Python.\n",
              "  outputElement.steps = steps;\n",
              "\n",
              "  return _uploadFilesContinue(outputId);\n",
              "}\n",
              "\n",
              "// This is roughly an async generator (not supported in the browser yet),\n",
              "// where there are multiple asynchronous steps and the Python side is going\n",
              "// to poll for completion of each step.\n",
              "// This uses a Promise to block the python side on completion of each step,\n",
              "// then passes the result of the previous step as the input to the next step.\n",
              "function _uploadFilesContinue(outputId) {\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  const steps = outputElement.steps;\n",
              "\n",
              "  const next = steps.next(outputElement.lastPromiseValue);\n",
              "  return Promise.resolve(next.value.promise).then((value) => {\n",
              "    // Cache the last promise value to make it available to the next\n",
              "    // step of the generator.\n",
              "    outputElement.lastPromiseValue = value;\n",
              "    return next.value.response;\n",
              "  });\n",
              "}\n",
              "\n",
              "/**\n",
              " * Generator function which is called between each async step of the upload\n",
              " * process.\n",
              " * @param {string} inputId Element ID of the input file picker element.\n",
              " * @param {string} outputId Element ID of the output display.\n",
              " * @return {!Iterable<!Object>} Iterable of next steps.\n",
              " */\n",
              "function* uploadFilesStep(inputId, outputId) {\n",
              "  const inputElement = document.getElementById(inputId);\n",
              "  inputElement.disabled = false;\n",
              "\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  outputElement.innerHTML = '';\n",
              "\n",
              "  const pickedPromise = new Promise((resolve) => {\n",
              "    inputElement.addEventListener('change', (e) => {\n",
              "      resolve(e.target.files);\n",
              "    });\n",
              "  });\n",
              "\n",
              "  const cancel = document.createElement('button');\n",
              "  inputElement.parentElement.appendChild(cancel);\n",
              "  cancel.textContent = 'Cancel upload';\n",
              "  const cancelPromise = new Promise((resolve) => {\n",
              "    cancel.onclick = () => {\n",
              "      resolve(null);\n",
              "    };\n",
              "  });\n",
              "\n",
              "  // Wait for the user to pick the files.\n",
              "  const files = yield {\n",
              "    promise: Promise.race([pickedPromise, cancelPromise]),\n",
              "    response: {\n",
              "      action: 'starting',\n",
              "    }\n",
              "  };\n",
              "\n",
              "  cancel.remove();\n",
              "\n",
              "  // Disable the input element since further picks are not allowed.\n",
              "  inputElement.disabled = true;\n",
              "\n",
              "  if (!files) {\n",
              "    return {\n",
              "      response: {\n",
              "        action: 'complete',\n",
              "      }\n",
              "    };\n",
              "  }\n",
              "\n",
              "  for (const file of files) {\n",
              "    const li = document.createElement('li');\n",
              "    li.append(span(file.name, {fontWeight: 'bold'}));\n",
              "    li.append(span(\n",
              "        `(${file.type || 'n/a'}) - ${file.size} bytes, ` +\n",
              "        `last modified: ${\n",
              "            file.lastModifiedDate ? file.lastModifiedDate.toLocaleDateString() :\n",
              "                                    'n/a'} - `));\n",
              "    const percent = span('0% done');\n",
              "    li.appendChild(percent);\n",
              "\n",
              "    outputElement.appendChild(li);\n",
              "\n",
              "    const fileDataPromise = new Promise((resolve) => {\n",
              "      const reader = new FileReader();\n",
              "      reader.onload = (e) => {\n",
              "        resolve(e.target.result);\n",
              "      };\n",
              "      reader.readAsArrayBuffer(file);\n",
              "    });\n",
              "    // Wait for the data to be ready.\n",
              "    let fileData = yield {\n",
              "      promise: fileDataPromise,\n",
              "      response: {\n",
              "        action: 'continue',\n",
              "      }\n",
              "    };\n",
              "\n",
              "    // Use a chunked sending to avoid message size limits. See b/62115660.\n",
              "    let position = 0;\n",
              "    do {\n",
              "      const length = Math.min(fileData.byteLength - position, MAX_PAYLOAD_SIZE);\n",
              "      const chunk = new Uint8Array(fileData, position, length);\n",
              "      position += length;\n",
              "\n",
              "      const base64 = btoa(String.fromCharCode.apply(null, chunk));\n",
              "      yield {\n",
              "        response: {\n",
              "          action: 'append',\n",
              "          file: file.name,\n",
              "          data: base64,\n",
              "        },\n",
              "      };\n",
              "\n",
              "      let percentDone = fileData.byteLength === 0 ?\n",
              "          100 :\n",
              "          Math.round((position / fileData.byteLength) * 100);\n",
              "      percent.textContent = `${percentDone}% done`;\n",
              "\n",
              "    } while (position < fileData.byteLength);\n",
              "  }\n",
              "\n",
              "  // All done.\n",
              "  yield {\n",
              "    response: {\n",
              "      action: 'complete',\n",
              "    }\n",
              "  };\n",
              "}\n",
              "\n",
              "scope.google = scope.google || {};\n",
              "scope.google.colab = scope.google.colab || {};\n",
              "scope.google.colab._files = {\n",
              "  _uploadFiles,\n",
              "  _uploadFilesContinue,\n",
              "};\n",
              "})(self);\n",
              "</script> "
            ]
          },
          "metadata": {}
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Saving football_salaries_2023_OUTPUT.csv to football_salaries_2023_OUTPUT.csv\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#df is just a variable. We could name it something else\n",
        "df = pd.read_csv(\"football_salaries_2023_OUTPUT.csv\")"
      ],
      "metadata": {
        "id": "bKmxmKFiKZC6"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#top 5 rows\n",
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 342
        },
        "id": "viT9pV24Lh7D",
        "outputId": "60d5585d-92de-4bdd-a335-617ed6b5fbd7"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              name               club   status position position_detail  age  \\\n",
              "0  Kevin De Bruyne    Manchester City  Starter        F              AM   32   \n",
              "1   Erling Haaland    Manchester City  Starter        F              CF   23   \n",
              "2    Mohamed Salah          Liverpool  Starter        F              RW   31   \n",
              "3         Casemiro  Manchester United  Starter        M              DM   31   \n",
              "4   Raphaël Varane  Manchester United  Starter        D              CB   30   \n",
              "\n",
              "   country  active   loan        signed  ... bonus_net_usd  total_gross_eur  \\\n",
              "0  Belgium    True  False   Apr 7, 2021  ...           NaN     € 47,922,060   \n",
              "1   Norway    True  False   Jul 1, 2022  ...  $ 16,714,126     € 89,853,863   \n",
              "2    Egypt    True  False   Jul 1, 2022  ...   $ 1,758,734     € 41,931,803   \n",
              "3   Brazil    True  False  Aug 22, 2022  ...   $ 3,517,469     € 62,897,704   \n",
              "4   France    True  False  Aug 14, 2021  ...           NaN     € 40,733,751   \n",
              "\n",
              "  total_net_eur total_gross_gbp total_net_gbp total_gross_usd total_net_usd  \\\n",
              "0  € 26,357,133    £ 41,600,000  £ 22,880,000    $ 51,163,183  $ 28,139,750   \n",
              "1  € 49,442,664    £ 78,000,000  £ 42,920,000    $ 95,930,968  $ 52,786,630   \n",
              "2  € 23,062,491    £ 36,400,000  £ 20,020,000    $ 44,767,785  $ 24,622,282   \n",
              "3  € 34,593,737    £ 54,600,000  £ 30,030,000    $ 67,151,677  $ 36,933,423   \n",
              "4  € 22,394,347    £ 35,360,000  £ 19,440,000    $ 43,488,705  $ 23,908,949   \n",
              "\n",
              "     release_eur    release_gbp    release_usd  \n",
              "0            NaN            NaN            NaN  \n",
              "1  € 199,291,260  £ 173,000,000  $ 212,769,967  \n",
              "2            NaN            NaN            NaN  \n",
              "3            NaN            NaN            NaN  \n",
              "4            NaN            NaN            NaN  \n",
              "\n",
              "[5 rows x 39 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-85abf5c5-80db-40ea-9bfc-b9bd32fa48fb\" 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>club</th>\n",
              "      <th>status</th>\n",
              "      <th>position</th>\n",
              "      <th>position_detail</th>\n",
              "      <th>age</th>\n",
              "      <th>country</th>\n",
              "      <th>active</th>\n",
              "      <th>loan</th>\n",
              "      <th>signed</th>\n",
              "      <th>...</th>\n",
              "      <th>bonus_net_usd</th>\n",
              "      <th>total_gross_eur</th>\n",
              "      <th>total_net_eur</th>\n",
              "      <th>total_gross_gbp</th>\n",
              "      <th>total_net_gbp</th>\n",
              "      <th>total_gross_usd</th>\n",
              "      <th>total_net_usd</th>\n",
              "      <th>release_eur</th>\n",
              "      <th>release_gbp</th>\n",
              "      <th>release_usd</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Kevin De Bruyne</td>\n",
              "      <td>Manchester City</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>AM</td>\n",
              "      <td>32</td>\n",
              "      <td>Belgium</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Apr 7, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 47,922,060</td>\n",
              "      <td>€ 26,357,133</td>\n",
              "      <td>£ 41,600,000</td>\n",
              "      <td>£ 22,880,000</td>\n",
              "      <td>$ 51,163,183</td>\n",
              "      <td>$ 28,139,750</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Erling Haaland</td>\n",
              "      <td>Manchester City</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>CF</td>\n",
              "      <td>23</td>\n",
              "      <td>Norway</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>$ 16,714,126</td>\n",
              "      <td>€ 89,853,863</td>\n",
              "      <td>€ 49,442,664</td>\n",
              "      <td>£ 78,000,000</td>\n",
              "      <td>£ 42,920,000</td>\n",
              "      <td>$ 95,930,968</td>\n",
              "      <td>$ 52,786,630</td>\n",
              "      <td>€ 199,291,260</td>\n",
              "      <td>£ 173,000,000</td>\n",
              "      <td>$ 212,769,967</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Mohamed Salah</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>RW</td>\n",
              "      <td>31</td>\n",
              "      <td>Egypt</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>$ 1,758,734</td>\n",
              "      <td>€ 41,931,803</td>\n",
              "      <td>€ 23,062,491</td>\n",
              "      <td>£ 36,400,000</td>\n",
              "      <td>£ 20,020,000</td>\n",
              "      <td>$ 44,767,785</td>\n",
              "      <td>$ 24,622,282</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Casemiro</td>\n",
              "      <td>Manchester United</td>\n",
              "      <td>Starter</td>\n",
              "      <td>M</td>\n",
              "      <td>DM</td>\n",
              "      <td>31</td>\n",
              "      <td>Brazil</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 22, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>$ 3,517,469</td>\n",
              "      <td>€ 62,897,704</td>\n",
              "      <td>€ 34,593,737</td>\n",
              "      <td>£ 54,600,000</td>\n",
              "      <td>£ 30,030,000</td>\n",
              "      <td>$ 67,151,677</td>\n",
              "      <td>$ 36,933,423</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Raphaël Varane</td>\n",
              "      <td>Manchester United</td>\n",
              "      <td>Starter</td>\n",
              "      <td>D</td>\n",
              "      <td>CB</td>\n",
              "      <td>30</td>\n",
              "      <td>France</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 14, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 40,733,751</td>\n",
              "      <td>€ 22,394,347</td>\n",
              "      <td>£ 35,360,000</td>\n",
              "      <td>£ 19,440,000</td>\n",
              "      <td>$ 43,488,705</td>\n",
              "      <td>$ 23,908,949</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 39 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-85abf5c5-80db-40ea-9bfc-b9bd32fa48fb')\"\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-85abf5c5-80db-40ea-9bfc-b9bd32fa48fb 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-85abf5c5-80db-40ea-9bfc-b9bd32fa48fb');\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-e391f09e-6f5e-4c9c-a683-2d2ce10a44fa\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-e391f09e-6f5e-4c9c-a683-2d2ce10a44fa')\"\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-e391f09e-6f5e-4c9c-a683-2d2ce10a44fa 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": 33
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#shows you the size of the thing\n",
        "df.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "gQ69g-CSNV0H",
        "outputId": "76785a25-d718-4085-df21-9754823616b5"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(565, 39)"
            ]
          },
          "metadata": {},
          "execution_count": 34
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#data types\n",
        "df.info"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "M1B4fqngPZ7t",
        "outputId": "f6f65957-3b9a-49f4-c57e-9afb5223e661"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<bound method DataFrame.info of                   name               club   status position position_detail  \\\n",
              "0      Kevin De Bruyne    Manchester City  Starter        F              AM   \n",
              "1       Erling Haaland    Manchester City  Starter        F              CF   \n",
              "2        Mohamed Salah          Liverpool  Starter        F              RW   \n",
              "3             Casemiro  Manchester United  Starter        M              DM   \n",
              "4       Raphaël Varane  Manchester United  Starter        D              CB   \n",
              "..                 ...                ...      ...      ...             ...   \n",
              "560  Philippe Coutinho        Aston Villa  Reserve        F              LW   \n",
              "561       Adama Traoré             Fulham  Reserve        F              RW   \n",
              "562        Luke Harris             Fulham  Reserve        F              AM   \n",
              "563    Emmanuel Dennis  Nottingham Forest  Reserve        F              CF   \n",
              "564      Calvin Bassey             Fulham  Reserve        D              CB   \n",
              "\n",
              "     age  country  active   loan        signed  ... bonus_net_usd  \\\n",
              "0     32  Belgium    True  False   Apr 7, 2021  ...           NaN   \n",
              "1     23   Norway    True  False   Jul 1, 2022  ...  $ 16,714,126   \n",
              "2     31    Egypt    True  False   Jul 1, 2022  ...   $ 1,758,734   \n",
              "3     31   Brazil    True  False  Aug 22, 2022  ...   $ 3,517,469   \n",
              "4     30   France    True  False  Aug 14, 2021  ...           NaN   \n",
              "..   ...      ...     ...    ...           ...  ...           ...   \n",
              "560   31   Brazil   False  False   Jul 1, 2022  ...           NaN   \n",
              "561   27    Spain    True  False  Aug 12, 2023  ...           NaN   \n",
              "562   18    Wales    True  False   Jul 1, 2023  ...           NaN   \n",
              "563   25  Nigeria   False  False  Aug 13, 2022  ...           NaN   \n",
              "564   23  Nigeria    True  False  Jul 28, 2023  ...           NaN   \n",
              "\n",
              "     total_gross_eur total_net_eur total_gross_gbp total_net_gbp  \\\n",
              "0       € 47,922,060  € 26,357,133    £ 41,600,000  £ 22,880,000   \n",
              "1       € 89,853,863  € 49,442,664    £ 78,000,000  £ 42,920,000   \n",
              "2       € 41,931,803  € 23,062,491    £ 36,400,000  £ 20,020,000   \n",
              "3       € 62,897,704  € 34,593,737    £ 54,600,000  £ 30,030,000   \n",
              "4       € 40,733,751  € 22,394,347    £ 35,360,000  £ 19,440,000   \n",
              "..               ...           ...             ...           ...   \n",
              "560              NaN           NaN             NaN           NaN   \n",
              "561              NaN           NaN             NaN           NaN   \n",
              "562              NaN           NaN             NaN           NaN   \n",
              "563              NaN           NaN             NaN           NaN   \n",
              "564              NaN           NaN             NaN           NaN   \n",
              "\n",
              "    total_gross_usd total_net_usd    release_eur    release_gbp    release_usd  \n",
              "0      $ 51,163,183  $ 28,139,750            NaN            NaN            NaN  \n",
              "1      $ 95,930,968  $ 52,786,630  € 199,291,260  £ 173,000,000  $ 212,769,967  \n",
              "2      $ 44,767,785  $ 24,622,282            NaN            NaN            NaN  \n",
              "3      $ 67,151,677  $ 36,933,423            NaN            NaN            NaN  \n",
              "4      $ 43,488,705  $ 23,908,949            NaN            NaN            NaN  \n",
              "..              ...           ...            ...            ...            ...  \n",
              "560             NaN           NaN            NaN            NaN            NaN  \n",
              "561             NaN           NaN            NaN            NaN            NaN  \n",
              "562             NaN           NaN            NaN            NaN            NaN  \n",
              "563             NaN           NaN            NaN            NaN            NaN  \n",
              "564             NaN           NaN            NaN            NaN            NaN  \n",
              "\n",
              "[565 rows x 39 columns]>"
            ]
          },
          "metadata": {},
          "execution_count": 44
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.head(565)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 617
        },
        "id": "ntuedfxiOkDZ",
        "outputId": "f831808c-f8da-4348-c2bf-33f39b70d9bd"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                  name               club   status position position_detail  \\\n",
              "0      Kevin De Bruyne    Manchester City  Starter        F              AM   \n",
              "1       Erling Haaland    Manchester City  Starter        F              CF   \n",
              "2        Mohamed Salah          Liverpool  Starter        F              RW   \n",
              "3             Casemiro  Manchester United  Starter        M              DM   \n",
              "4       Raphaël Varane  Manchester United  Starter        D              CB   \n",
              "..                 ...                ...      ...      ...             ...   \n",
              "560  Philippe Coutinho        Aston Villa  Reserve        F              LW   \n",
              "561       Adama Traoré             Fulham  Reserve        F              RW   \n",
              "562        Luke Harris             Fulham  Reserve        F              AM   \n",
              "563    Emmanuel Dennis  Nottingham Forest  Reserve        F              CF   \n",
              "564      Calvin Bassey             Fulham  Reserve        D              CB   \n",
              "\n",
              "     age  country  active   loan        signed  ... bonus_net_usd  \\\n",
              "0     32  Belgium    True  False   Apr 7, 2021  ...           NaN   \n",
              "1     23   Norway    True  False   Jul 1, 2022  ...  $ 16,714,126   \n",
              "2     31    Egypt    True  False   Jul 1, 2022  ...   $ 1,758,734   \n",
              "3     31   Brazil    True  False  Aug 22, 2022  ...   $ 3,517,469   \n",
              "4     30   France    True  False  Aug 14, 2021  ...           NaN   \n",
              "..   ...      ...     ...    ...           ...  ...           ...   \n",
              "560   31   Brazil   False  False   Jul 1, 2022  ...           NaN   \n",
              "561   27    Spain    True  False  Aug 12, 2023  ...           NaN   \n",
              "562   18    Wales    True  False   Jul 1, 2023  ...           NaN   \n",
              "563   25  Nigeria   False  False  Aug 13, 2022  ...           NaN   \n",
              "564   23  Nigeria    True  False  Jul 28, 2023  ...           NaN   \n",
              "\n",
              "     total_gross_eur total_net_eur total_gross_gbp total_net_gbp  \\\n",
              "0       € 47,922,060  € 26,357,133    £ 41,600,000  £ 22,880,000   \n",
              "1       € 89,853,863  € 49,442,664    £ 78,000,000  £ 42,920,000   \n",
              "2       € 41,931,803  € 23,062,491    £ 36,400,000  £ 20,020,000   \n",
              "3       € 62,897,704  € 34,593,737    £ 54,600,000  £ 30,030,000   \n",
              "4       € 40,733,751  € 22,394,347    £ 35,360,000  £ 19,440,000   \n",
              "..               ...           ...             ...           ...   \n",
              "560              NaN           NaN             NaN           NaN   \n",
              "561              NaN           NaN             NaN           NaN   \n",
              "562              NaN           NaN             NaN           NaN   \n",
              "563              NaN           NaN             NaN           NaN   \n",
              "564              NaN           NaN             NaN           NaN   \n",
              "\n",
              "    total_gross_usd total_net_usd    release_eur    release_gbp    release_usd  \n",
              "0      $ 51,163,183  $ 28,139,750            NaN            NaN            NaN  \n",
              "1      $ 95,930,968  $ 52,786,630  € 199,291,260  £ 173,000,000  $ 212,769,967  \n",
              "2      $ 44,767,785  $ 24,622,282            NaN            NaN            NaN  \n",
              "3      $ 67,151,677  $ 36,933,423            NaN            NaN            NaN  \n",
              "4      $ 43,488,705  $ 23,908,949            NaN            NaN            NaN  \n",
              "..              ...           ...            ...            ...            ...  \n",
              "560             NaN           NaN            NaN            NaN            NaN  \n",
              "561             NaN           NaN            NaN            NaN            NaN  \n",
              "562             NaN           NaN            NaN            NaN            NaN  \n",
              "563             NaN           NaN            NaN            NaN            NaN  \n",
              "564             NaN           NaN            NaN            NaN            NaN  \n",
              "\n",
              "[565 rows x 39 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-6f2116a9-5773-49ce-90bc-5793866ca41c\" 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>club</th>\n",
              "      <th>status</th>\n",
              "      <th>position</th>\n",
              "      <th>position_detail</th>\n",
              "      <th>age</th>\n",
              "      <th>country</th>\n",
              "      <th>active</th>\n",
              "      <th>loan</th>\n",
              "      <th>signed</th>\n",
              "      <th>...</th>\n",
              "      <th>bonus_net_usd</th>\n",
              "      <th>total_gross_eur</th>\n",
              "      <th>total_net_eur</th>\n",
              "      <th>total_gross_gbp</th>\n",
              "      <th>total_net_gbp</th>\n",
              "      <th>total_gross_usd</th>\n",
              "      <th>total_net_usd</th>\n",
              "      <th>release_eur</th>\n",
              "      <th>release_gbp</th>\n",
              "      <th>release_usd</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Kevin De Bruyne</td>\n",
              "      <td>Manchester City</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>AM</td>\n",
              "      <td>32</td>\n",
              "      <td>Belgium</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Apr 7, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 47,922,060</td>\n",
              "      <td>€ 26,357,133</td>\n",
              "      <td>£ 41,600,000</td>\n",
              "      <td>£ 22,880,000</td>\n",
              "      <td>$ 51,163,183</td>\n",
              "      <td>$ 28,139,750</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Erling Haaland</td>\n",
              "      <td>Manchester City</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>CF</td>\n",
              "      <td>23</td>\n",
              "      <td>Norway</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>$ 16,714,126</td>\n",
              "      <td>€ 89,853,863</td>\n",
              "      <td>€ 49,442,664</td>\n",
              "      <td>£ 78,000,000</td>\n",
              "      <td>£ 42,920,000</td>\n",
              "      <td>$ 95,930,968</td>\n",
              "      <td>$ 52,786,630</td>\n",
              "      <td>€ 199,291,260</td>\n",
              "      <td>£ 173,000,000</td>\n",
              "      <td>$ 212,769,967</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Mohamed Salah</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>RW</td>\n",
              "      <td>31</td>\n",
              "      <td>Egypt</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>$ 1,758,734</td>\n",
              "      <td>€ 41,931,803</td>\n",
              "      <td>€ 23,062,491</td>\n",
              "      <td>£ 36,400,000</td>\n",
              "      <td>£ 20,020,000</td>\n",
              "      <td>$ 44,767,785</td>\n",
              "      <td>$ 24,622,282</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Casemiro</td>\n",
              "      <td>Manchester United</td>\n",
              "      <td>Starter</td>\n",
              "      <td>M</td>\n",
              "      <td>DM</td>\n",
              "      <td>31</td>\n",
              "      <td>Brazil</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 22, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>$ 3,517,469</td>\n",
              "      <td>€ 62,897,704</td>\n",
              "      <td>€ 34,593,737</td>\n",
              "      <td>£ 54,600,000</td>\n",
              "      <td>£ 30,030,000</td>\n",
              "      <td>$ 67,151,677</td>\n",
              "      <td>$ 36,933,423</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Raphaël Varane</td>\n",
              "      <td>Manchester United</td>\n",
              "      <td>Starter</td>\n",
              "      <td>D</td>\n",
              "      <td>CB</td>\n",
              "      <td>30</td>\n",
              "      <td>France</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 14, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 40,733,751</td>\n",
              "      <td>€ 22,394,347</td>\n",
              "      <td>£ 35,360,000</td>\n",
              "      <td>£ 19,440,000</td>\n",
              "      <td>$ 43,488,705</td>\n",
              "      <td>$ 23,908,949</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>560</th>\n",
              "      <td>Philippe Coutinho</td>\n",
              "      <td>Aston Villa</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>F</td>\n",
              "      <td>LW</td>\n",
              "      <td>31</td>\n",
              "      <td>Brazil</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>561</th>\n",
              "      <td>Adama Traoré</td>\n",
              "      <td>Fulham</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>F</td>\n",
              "      <td>RW</td>\n",
              "      <td>27</td>\n",
              "      <td>Spain</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 12, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>562</th>\n",
              "      <td>Luke Harris</td>\n",
              "      <td>Fulham</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>F</td>\n",
              "      <td>AM</td>\n",
              "      <td>18</td>\n",
              "      <td>Wales</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>563</th>\n",
              "      <td>Emmanuel Dennis</td>\n",
              "      <td>Nottingham Forest</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>F</td>\n",
              "      <td>CF</td>\n",
              "      <td>25</td>\n",
              "      <td>Nigeria</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 13, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>564</th>\n",
              "      <td>Calvin Bassey</td>\n",
              "      <td>Fulham</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>D</td>\n",
              "      <td>CB</td>\n",
              "      <td>23</td>\n",
              "      <td>Nigeria</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 28, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>565 rows × 39 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-6f2116a9-5773-49ce-90bc-5793866ca41c')\"\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-6f2116a9-5773-49ce-90bc-5793866ca41c 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-6f2116a9-5773-49ce-90bc-5793866ca41c');\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-408f2ae4-01bc-4c47-a492-d96dd9aecca0\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-408f2ae4-01bc-4c47-a492-d96dd9aecca0')\"\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-408f2ae4-01bc-4c47-a492-d96dd9aecca0 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": 37
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.head(3)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 245
        },
        "id": "4uKFjeLYN1Bu",
        "outputId": "857c82c1-3f61-4314-ac62-b16c719c72b4"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              name             club   status position position_detail  age  \\\n",
              "0  Kevin De Bruyne  Manchester City  Starter        F              AM   32   \n",
              "1   Erling Haaland  Manchester City  Starter        F              CF   23   \n",
              "2    Mohamed Salah        Liverpool  Starter        F              RW   31   \n",
              "\n",
              "   country  active   loan       signed  ... bonus_net_usd  total_gross_eur  \\\n",
              "0  Belgium    True  False  Apr 7, 2021  ...           NaN     € 47,922,060   \n",
              "1   Norway    True  False  Jul 1, 2022  ...  $ 16,714,126     € 89,853,863   \n",
              "2    Egypt    True  False  Jul 1, 2022  ...   $ 1,758,734     € 41,931,803   \n",
              "\n",
              "  total_net_eur total_gross_gbp total_net_gbp total_gross_usd total_net_usd  \\\n",
              "0  € 26,357,133    £ 41,600,000  £ 22,880,000    $ 51,163,183  $ 28,139,750   \n",
              "1  € 49,442,664    £ 78,000,000  £ 42,920,000    $ 95,930,968  $ 52,786,630   \n",
              "2  € 23,062,491    £ 36,400,000  £ 20,020,000    $ 44,767,785  $ 24,622,282   \n",
              "\n",
              "     release_eur    release_gbp    release_usd  \n",
              "0            NaN            NaN            NaN  \n",
              "1  € 199,291,260  £ 173,000,000  $ 212,769,967  \n",
              "2            NaN            NaN            NaN  \n",
              "\n",
              "[3 rows x 39 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b18865fd-a102-4c01-baa5-7968851f3efd\" 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>club</th>\n",
              "      <th>status</th>\n",
              "      <th>position</th>\n",
              "      <th>position_detail</th>\n",
              "      <th>age</th>\n",
              "      <th>country</th>\n",
              "      <th>active</th>\n",
              "      <th>loan</th>\n",
              "      <th>signed</th>\n",
              "      <th>...</th>\n",
              "      <th>bonus_net_usd</th>\n",
              "      <th>total_gross_eur</th>\n",
              "      <th>total_net_eur</th>\n",
              "      <th>total_gross_gbp</th>\n",
              "      <th>total_net_gbp</th>\n",
              "      <th>total_gross_usd</th>\n",
              "      <th>total_net_usd</th>\n",
              "      <th>release_eur</th>\n",
              "      <th>release_gbp</th>\n",
              "      <th>release_usd</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Kevin De Bruyne</td>\n",
              "      <td>Manchester City</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>AM</td>\n",
              "      <td>32</td>\n",
              "      <td>Belgium</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Apr 7, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 47,922,060</td>\n",
              "      <td>€ 26,357,133</td>\n",
              "      <td>£ 41,600,000</td>\n",
              "      <td>£ 22,880,000</td>\n",
              "      <td>$ 51,163,183</td>\n",
              "      <td>$ 28,139,750</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Erling Haaland</td>\n",
              "      <td>Manchester City</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>CF</td>\n",
              "      <td>23</td>\n",
              "      <td>Norway</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>$ 16,714,126</td>\n",
              "      <td>€ 89,853,863</td>\n",
              "      <td>€ 49,442,664</td>\n",
              "      <td>£ 78,000,000</td>\n",
              "      <td>£ 42,920,000</td>\n",
              "      <td>$ 95,930,968</td>\n",
              "      <td>$ 52,786,630</td>\n",
              "      <td>€ 199,291,260</td>\n",
              "      <td>£ 173,000,000</td>\n",
              "      <td>$ 212,769,967</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Mohamed Salah</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>RW</td>\n",
              "      <td>31</td>\n",
              "      <td>Egypt</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>$ 1,758,734</td>\n",
              "      <td>€ 41,931,803</td>\n",
              "      <td>€ 23,062,491</td>\n",
              "      <td>£ 36,400,000</td>\n",
              "      <td>£ 20,020,000</td>\n",
              "      <td>$ 44,767,785</td>\n",
              "      <td>$ 24,622,282</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>3 rows × 39 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-b18865fd-a102-4c01-baa5-7968851f3efd')\"\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-b18865fd-a102-4c01-baa5-7968851f3efd 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-b18865fd-a102-4c01-baa5-7968851f3efd');\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-20a65838-4a8b-49ee-b56b-8156e2c5233e\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-20a65838-4a8b-49ee-b56b-8156e2c5233e')\"\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-20a65838-4a8b-49ee-b56b-8156e2c5233e 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": 35
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.age.mean()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ssRSQUioO5Zl",
        "outputId": "a78d4ba4-ee35-473e-9fbe-1e46824f4dd2"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "25.819469026548674"
            ]
          },
          "metadata": {},
          "execution_count": 49
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.age.median()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "s8C40LJ5PODF",
        "outputId": "adde296c-d494-433e-f111-95f7a8031539"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "25.0"
            ]
          },
          "metadata": {},
          "execution_count": 50
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.age.value_counts()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "3B5RiScQQOlP",
        "outputId": "54f91e3a-d7c8-41fd-f7a2-bb250592005e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "26    54\n",
              "23    52\n",
              "24    50\n",
              "25    46\n",
              "27    40\n",
              "22    40\n",
              "28    36\n",
              "21    34\n",
              "30    34\n",
              "29    31\n",
              "20    28\n",
              "31    28\n",
              "32    19\n",
              "19    18\n",
              "18    14\n",
              "33    13\n",
              "34     8\n",
              "35     8\n",
              "38     4\n",
              "36     4\n",
              "37     2\n",
              "39     1\n",
              "17     1\n",
              "Name: age, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 55
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.age.min()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Lk2DIoXVQf31",
        "outputId": "458f132c-6f14-454b-a7ad-e710ce4731b7"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "17"
            ]
          },
          "metadata": {},
          "execution_count": 57
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.age.max()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "bVeGFScLQn8H",
        "outputId": "5d4f0612-6923-426a-95dc-597c47101920"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "39"
            ]
          },
          "metadata": {},
          "execution_count": 58
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "len(df)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "O695XtagQpNS",
        "outputId": "8c7c5628-549c-477b-afb1-65148948caf6"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "565"
            ]
          },
          "metadata": {},
          "execution_count": 61
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df[df.club == \"Liverpool\"]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "s2W2XrKeQ4dl",
        "outputId": "c945fd90-3837-4a92-db62-6cd1932c4389"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                       name       club   status position position_detail  age  \\\n",
              "2             Mohamed Salah  Liverpool  Starter        F              RW   31   \n",
              "20          Virgil van Dijk  Liverpool  Starter        D              CB   32   \n",
              "25                   Thiago  Liverpool  Reserve        M              CM   32   \n",
              "37   Trent Alexander-Arnold  Liverpool  Starter        D              RB   24   \n",
              "50         Ryan Gravenberch  Liverpool  Reserve        M              CM   21   \n",
              "51                  Alisson  Liverpool  Starter        K              GK   30   \n",
              "54      Alexis Mac Allister  Liverpool  Starter        M              CM   24   \n",
              "59             Darwin Núñez  Liverpool  Reserve        F              CF   24   \n",
              "60               Diogo Jota  Liverpool  Reserve        F              LW   26   \n",
              "67               Cody Gakpo  Liverpool  Starter        F              CF   24   \n",
              "71       Dominik Szoboszlai  Liverpool  Starter        F              AM   22   \n",
              "97         Andrew Robertson  Liverpool  Starter        D              LB   29   \n",
              "98               Joel Matip  Liverpool  Starter        D              CB   32   \n",
              "133               Joe Gomez  Liverpool  Starter        D              CB   26   \n",
              "169   Konstantinos Tsimikas  Liverpool  Reserve        D              LB   27   \n",
              "175         Ibrahima Konaté  Liverpool  Reserve        D              CB   24   \n",
              "194                  Adrián  Liverpool  Reserve        K              GK   36   \n",
              "210               Luis Díaz  Liverpool  Starter        F              LW   26   \n",
              "256             Wataru Endo  Liverpool  Reserve        M              DM   30   \n",
              "288          Harvey Elliott  Liverpool  Reserve        F              AM   20   \n",
              "294         Stefan Bajcetic  Liverpool  Reserve        M              DM   18   \n",
              "446            Curtis Jones  Liverpool  Reserve        M              CM   22   \n",
              "504       Caoimhín Kelleher  Liverpool  Reserve        K              GK   24   \n",
              "\n",
              "         country  active   loan        signed  ... bonus_net_usd  \\\n",
              "2          Egypt    True  False   Jul 1, 2022  ...   $ 1,758,734   \n",
              "20   Netherlands    True  False  Aug 13, 2021  ...           NaN   \n",
              "25         Spain    True  False  Sep 18, 2020  ...           NaN   \n",
              "37       England    True  False  Jul 30, 2021  ...           NaN   \n",
              "50   Netherlands    True  False   Sep 1, 2023  ...           NaN   \n",
              "51        Brazil    True  False   Aug 4, 2021  ...           NaN   \n",
              "54     Argentina    True  False   Jul 1, 2023  ...   $ 1,057,700   \n",
              "59       Uruguay    True  False   Jul 1, 2022  ...           NaN   \n",
              "60      Portugal    True  False   Aug 2, 2022  ...           NaN   \n",
              "67   Netherlands    True  False   Jan 1, 2023  ...           NaN   \n",
              "71       Hungary    True  False   Jul 2, 2023  ...   $ 1,057,700   \n",
              "97      Scotland    True  False  Aug 24, 2021  ...           NaN   \n",
              "98      Cameroon    True  False  Oct 18, 2019  ...           NaN   \n",
              "133      England    True  False   Jul 7, 2022  ...           NaN   \n",
              "169       Greece    True  False  Sep 25, 2023  ...           NaN   \n",
              "175       France    True  False   Jul 1, 2021  ...           NaN   \n",
              "194        Spain    True  False  Jun 30, 2023  ...           NaN   \n",
              "210     Colombia    True  False  Jan 30, 2022  ...           NaN   \n",
              "256        Japan    True  False  Aug 18, 2023  ...           NaN   \n",
              "288      England    True  False  Aug 11, 2022  ...           NaN   \n",
              "294        Spain    True  False  Jan 26, 2023  ...           NaN   \n",
              "446      England    True  False  Nov 17, 2022  ...           NaN   \n",
              "504      Ireland    True  False  Jun 24, 2021  ...           NaN   \n",
              "\n",
              "     total_gross_eur total_net_eur total_gross_gbp total_net_gbp  \\\n",
              "2       € 41,931,803  € 23,062,491    £ 36,400,000  £ 20,020,000   \n",
              "20      € 26,357,133  € 14,491,815    £ 22,880,000  £ 12,580,000   \n",
              "25      € 11,980,515   € 6,589,283    £ 10,400,000   £ 5,720,000   \n",
              "37      € 21,564,927  € 11,865,318    £ 18,720,000  £ 10,300,000   \n",
              "50       € 8,985,386   € 4,941,962     £ 7,800,000   £ 4,290,000   \n",
              "51      € 35,941,545  € 19,767,850    £ 31,200,000  £ 17,160,000   \n",
              "54      € 44,926,931  € 24,709,812    £ 39,000,000  £ 21,450,000   \n",
              "59      € 41,931,803  € 23,039,452    £ 36,400,000  £ 20,000,000   \n",
              "60      € 33,545,442  € 18,431,562    £ 29,120,000  £ 16,000,000   \n",
              "67      € 35,941,545  € 19,756,330    £ 31,200,000  £ 17,150,000   \n",
              "71      € 35,941,545  € 19,756,330    £ 31,200,000  £ 17,150,000   \n",
              "97      € 17,970,773   € 9,883,925    £ 15,600,000   £ 8,580,000   \n",
              "98       € 5,990,258   € 3,294,642     £ 5,200,000   £ 2,860,000   \n",
              "133     € 20,366,876  € 11,197,174    £ 17,680,000   £ 9,720,000   \n",
              "169     € 17,970,773   € 9,906,964    £ 15,600,000   £ 8,600,000   \n",
              "175     € 12,579,541   € 6,911,836    £ 10,920,000   £ 6,000,000   \n",
              "194      € 3,594,155   € 1,981,393     £ 3,120,000   £ 1,720,000   \n",
              "210     € 13,178,567   € 7,234,388    £ 11,440,000   £ 6,280,000   \n",
              "256     € 11,980,515   € 6,589,283    £ 10,400,000   £ 5,720,000   \n",
              "288      € 9,584,412   € 5,252,995     £ 8,320,000   £ 4,560,000   \n",
              "294      € 9,584,412   € 5,252,995     £ 8,320,000   £ 4,560,000   \n",
              "446      € 3,594,155   € 1,981,393     £ 3,120,000   £ 1,720,000   \n",
              "504      € 1,797,077   € 1,002,216     £ 1,560,000     £ 870,000   \n",
              "\n",
              "    total_gross_usd total_net_usd release_eur release_gbp release_usd  \n",
              "2      $ 44,767,785  $ 24,622,282         NaN         NaN         NaN  \n",
              "20     $ 28,139,750  $ 15,471,943         NaN         NaN         NaN  \n",
              "25     $ 12,790,796   $ 7,034,938         NaN         NaN         NaN  \n",
              "37     $ 23,023,432  $ 12,667,807         NaN         NaN         NaN  \n",
              "50      $ 9,593,097   $ 5,276,203         NaN         NaN         NaN  \n",
              "51     $ 38,372,387  $ 21,104,813         NaN         NaN         NaN  \n",
              "54     $ 47,965,484  $ 26,381,016         NaN         NaN         NaN  \n",
              "59     $ 44,767,785  $ 24,597,684         NaN         NaN         NaN  \n",
              "60     $ 35,814,228  $ 19,678,147         NaN         NaN         NaN  \n",
              "67     $ 38,372,387  $ 21,092,514         NaN         NaN         NaN  \n",
              "71     $ 38,372,387  $ 21,092,514         NaN         NaN         NaN  \n",
              "97     $ 19,186,194  $ 10,552,406         NaN         NaN         NaN  \n",
              "98      $ 6,395,398   $ 3,517,469         NaN         NaN         NaN  \n",
              "133    $ 21,744,353  $ 11,954,474         NaN         NaN         NaN  \n",
              "169    $ 19,186,194  $ 10,577,004         NaN         NaN         NaN  \n",
              "175    $ 13,430,335   $ 7,379,305         NaN         NaN         NaN  \n",
              "194     $ 3,837,239   $ 2,115,401         NaN         NaN         NaN  \n",
              "210    $ 14,069,875   $ 7,723,673         NaN         NaN         NaN  \n",
              "256    $ 12,790,796   $ 7,034,938         NaN         NaN         NaN  \n",
              "288    $ 10,232,637   $ 5,608,272         NaN         NaN         NaN  \n",
              "294    $ 10,232,637   $ 5,608,272         NaN         NaN         NaN  \n",
              "446     $ 3,837,239   $ 2,115,401         NaN         NaN         NaN  \n",
              "504     $ 1,918,619   $ 1,069,999         NaN         NaN         NaN  \n",
              "\n",
              "[23 rows x 39 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-0cab1c47-33bf-40e4-b1d8-98394a2f5478\" 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>club</th>\n",
              "      <th>status</th>\n",
              "      <th>position</th>\n",
              "      <th>position_detail</th>\n",
              "      <th>age</th>\n",
              "      <th>country</th>\n",
              "      <th>active</th>\n",
              "      <th>loan</th>\n",
              "      <th>signed</th>\n",
              "      <th>...</th>\n",
              "      <th>bonus_net_usd</th>\n",
              "      <th>total_gross_eur</th>\n",
              "      <th>total_net_eur</th>\n",
              "      <th>total_gross_gbp</th>\n",
              "      <th>total_net_gbp</th>\n",
              "      <th>total_gross_usd</th>\n",
              "      <th>total_net_usd</th>\n",
              "      <th>release_eur</th>\n",
              "      <th>release_gbp</th>\n",
              "      <th>release_usd</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Mohamed Salah</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>RW</td>\n",
              "      <td>31</td>\n",
              "      <td>Egypt</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>$ 1,758,734</td>\n",
              "      <td>€ 41,931,803</td>\n",
              "      <td>€ 23,062,491</td>\n",
              "      <td>£ 36,400,000</td>\n",
              "      <td>£ 20,020,000</td>\n",
              "      <td>$ 44,767,785</td>\n",
              "      <td>$ 24,622,282</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Virgil van Dijk</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>D</td>\n",
              "      <td>CB</td>\n",
              "      <td>32</td>\n",
              "      <td>Netherlands</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 13, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 26,357,133</td>\n",
              "      <td>€ 14,491,815</td>\n",
              "      <td>£ 22,880,000</td>\n",
              "      <td>£ 12,580,000</td>\n",
              "      <td>$ 28,139,750</td>\n",
              "      <td>$ 15,471,943</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Thiago</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>M</td>\n",
              "      <td>CM</td>\n",
              "      <td>32</td>\n",
              "      <td>Spain</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Sep 18, 2020</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 11,980,515</td>\n",
              "      <td>€ 6,589,283</td>\n",
              "      <td>£ 10,400,000</td>\n",
              "      <td>£ 5,720,000</td>\n",
              "      <td>$ 12,790,796</td>\n",
              "      <td>$ 7,034,938</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>Trent Alexander-Arnold</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>D</td>\n",
              "      <td>RB</td>\n",
              "      <td>24</td>\n",
              "      <td>England</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 30, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 21,564,927</td>\n",
              "      <td>€ 11,865,318</td>\n",
              "      <td>£ 18,720,000</td>\n",
              "      <td>£ 10,300,000</td>\n",
              "      <td>$ 23,023,432</td>\n",
              "      <td>$ 12,667,807</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50</th>\n",
              "      <td>Ryan Gravenberch</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>M</td>\n",
              "      <td>CM</td>\n",
              "      <td>21</td>\n",
              "      <td>Netherlands</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Sep 1, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 8,985,386</td>\n",
              "      <td>€ 4,941,962</td>\n",
              "      <td>£ 7,800,000</td>\n",
              "      <td>£ 4,290,000</td>\n",
              "      <td>$ 9,593,097</td>\n",
              "      <td>$ 5,276,203</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>51</th>\n",
              "      <td>Alisson</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>K</td>\n",
              "      <td>GK</td>\n",
              "      <td>30</td>\n",
              "      <td>Brazil</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 4, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 35,941,545</td>\n",
              "      <td>€ 19,767,850</td>\n",
              "      <td>£ 31,200,000</td>\n",
              "      <td>£ 17,160,000</td>\n",
              "      <td>$ 38,372,387</td>\n",
              "      <td>$ 21,104,813</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>54</th>\n",
              "      <td>Alexis Mac Allister</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>M</td>\n",
              "      <td>CM</td>\n",
              "      <td>24</td>\n",
              "      <td>Argentina</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>$ 1,057,700</td>\n",
              "      <td>€ 44,926,931</td>\n",
              "      <td>€ 24,709,812</td>\n",
              "      <td>£ 39,000,000</td>\n",
              "      <td>£ 21,450,000</td>\n",
              "      <td>$ 47,965,484</td>\n",
              "      <td>$ 26,381,016</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>59</th>\n",
              "      <td>Darwin Núñez</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>F</td>\n",
              "      <td>CF</td>\n",
              "      <td>24</td>\n",
              "      <td>Uruguay</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 41,931,803</td>\n",
              "      <td>€ 23,039,452</td>\n",
              "      <td>£ 36,400,000</td>\n",
              "      <td>£ 20,000,000</td>\n",
              "      <td>$ 44,767,785</td>\n",
              "      <td>$ 24,597,684</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60</th>\n",
              "      <td>Diogo Jota</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>F</td>\n",
              "      <td>LW</td>\n",
              "      <td>26</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 2, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 33,545,442</td>\n",
              "      <td>€ 18,431,562</td>\n",
              "      <td>£ 29,120,000</td>\n",
              "      <td>£ 16,000,000</td>\n",
              "      <td>$ 35,814,228</td>\n",
              "      <td>$ 19,678,147</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>67</th>\n",
              "      <td>Cody Gakpo</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>CF</td>\n",
              "      <td>24</td>\n",
              "      <td>Netherlands</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jan 1, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 35,941,545</td>\n",
              "      <td>€ 19,756,330</td>\n",
              "      <td>£ 31,200,000</td>\n",
              "      <td>£ 17,150,000</td>\n",
              "      <td>$ 38,372,387</td>\n",
              "      <td>$ 21,092,514</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71</th>\n",
              "      <td>Dominik Szoboszlai</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>AM</td>\n",
              "      <td>22</td>\n",
              "      <td>Hungary</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 2, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>$ 1,057,700</td>\n",
              "      <td>€ 35,941,545</td>\n",
              "      <td>€ 19,756,330</td>\n",
              "      <td>£ 31,200,000</td>\n",
              "      <td>£ 17,150,000</td>\n",
              "      <td>$ 38,372,387</td>\n",
              "      <td>$ 21,092,514</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>97</th>\n",
              "      <td>Andrew Robertson</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>D</td>\n",
              "      <td>LB</td>\n",
              "      <td>29</td>\n",
              "      <td>Scotland</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 24, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 17,970,773</td>\n",
              "      <td>€ 9,883,925</td>\n",
              "      <td>£ 15,600,000</td>\n",
              "      <td>£ 8,580,000</td>\n",
              "      <td>$ 19,186,194</td>\n",
              "      <td>$ 10,552,406</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>98</th>\n",
              "      <td>Joel Matip</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>D</td>\n",
              "      <td>CB</td>\n",
              "      <td>32</td>\n",
              "      <td>Cameroon</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Oct 18, 2019</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 5,990,258</td>\n",
              "      <td>€ 3,294,642</td>\n",
              "      <td>£ 5,200,000</td>\n",
              "      <td>£ 2,860,000</td>\n",
              "      <td>$ 6,395,398</td>\n",
              "      <td>$ 3,517,469</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>133</th>\n",
              "      <td>Joe Gomez</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>D</td>\n",
              "      <td>CB</td>\n",
              "      <td>26</td>\n",
              "      <td>England</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 7, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 20,366,876</td>\n",
              "      <td>€ 11,197,174</td>\n",
              "      <td>£ 17,680,000</td>\n",
              "      <td>£ 9,720,000</td>\n",
              "      <td>$ 21,744,353</td>\n",
              "      <td>$ 11,954,474</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>169</th>\n",
              "      <td>Konstantinos Tsimikas</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>D</td>\n",
              "      <td>LB</td>\n",
              "      <td>27</td>\n",
              "      <td>Greece</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Sep 25, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 17,970,773</td>\n",
              "      <td>€ 9,906,964</td>\n",
              "      <td>£ 15,600,000</td>\n",
              "      <td>£ 8,600,000</td>\n",
              "      <td>$ 19,186,194</td>\n",
              "      <td>$ 10,577,004</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>175</th>\n",
              "      <td>Ibrahima Konaté</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>D</td>\n",
              "      <td>CB</td>\n",
              "      <td>24</td>\n",
              "      <td>France</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 12,579,541</td>\n",
              "      <td>€ 6,911,836</td>\n",
              "      <td>£ 10,920,000</td>\n",
              "      <td>£ 6,000,000</td>\n",
              "      <td>$ 13,430,335</td>\n",
              "      <td>$ 7,379,305</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>194</th>\n",
              "      <td>Adrián</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>K</td>\n",
              "      <td>GK</td>\n",
              "      <td>36</td>\n",
              "      <td>Spain</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jun 30, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 3,594,155</td>\n",
              "      <td>€ 1,981,393</td>\n",
              "      <td>£ 3,120,000</td>\n",
              "      <td>£ 1,720,000</td>\n",
              "      <td>$ 3,837,239</td>\n",
              "      <td>$ 2,115,401</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>210</th>\n",
              "      <td>Luis Díaz</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>LW</td>\n",
              "      <td>26</td>\n",
              "      <td>Colombia</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jan 30, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 13,178,567</td>\n",
              "      <td>€ 7,234,388</td>\n",
              "      <td>£ 11,440,000</td>\n",
              "      <td>£ 6,280,000</td>\n",
              "      <td>$ 14,069,875</td>\n",
              "      <td>$ 7,723,673</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>256</th>\n",
              "      <td>Wataru Endo</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>M</td>\n",
              "      <td>DM</td>\n",
              "      <td>30</td>\n",
              "      <td>Japan</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 18, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 11,980,515</td>\n",
              "      <td>€ 6,589,283</td>\n",
              "      <td>£ 10,400,000</td>\n",
              "      <td>£ 5,720,000</td>\n",
              "      <td>$ 12,790,796</td>\n",
              "      <td>$ 7,034,938</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>288</th>\n",
              "      <td>Harvey Elliott</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>F</td>\n",
              "      <td>AM</td>\n",
              "      <td>20</td>\n",
              "      <td>England</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 11, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 9,584,412</td>\n",
              "      <td>€ 5,252,995</td>\n",
              "      <td>£ 8,320,000</td>\n",
              "      <td>£ 4,560,000</td>\n",
              "      <td>$ 10,232,637</td>\n",
              "      <td>$ 5,608,272</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>294</th>\n",
              "      <td>Stefan Bajcetic</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>M</td>\n",
              "      <td>DM</td>\n",
              "      <td>18</td>\n",
              "      <td>Spain</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jan 26, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 9,584,412</td>\n",
              "      <td>€ 5,252,995</td>\n",
              "      <td>£ 8,320,000</td>\n",
              "      <td>£ 4,560,000</td>\n",
              "      <td>$ 10,232,637</td>\n",
              "      <td>$ 5,608,272</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>446</th>\n",
              "      <td>Curtis Jones</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>M</td>\n",
              "      <td>CM</td>\n",
              "      <td>22</td>\n",
              "      <td>England</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Nov 17, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 3,594,155</td>\n",
              "      <td>€ 1,981,393</td>\n",
              "      <td>£ 3,120,000</td>\n",
              "      <td>£ 1,720,000</td>\n",
              "      <td>$ 3,837,239</td>\n",
              "      <td>$ 2,115,401</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>504</th>\n",
              "      <td>Caoimhín Kelleher</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>K</td>\n",
              "      <td>GK</td>\n",
              "      <td>24</td>\n",
              "      <td>Ireland</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jun 24, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 1,797,077</td>\n",
              "      <td>€ 1,002,216</td>\n",
              "      <td>£ 1,560,000</td>\n",
              "      <td>£ 870,000</td>\n",
              "      <td>$ 1,918,619</td>\n",
              "      <td>$ 1,069,999</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>23 rows × 39 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-0cab1c47-33bf-40e4-b1d8-98394a2f5478')\"\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-0cab1c47-33bf-40e4-b1d8-98394a2f5478 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-0cab1c47-33bf-40e4-b1d8-98394a2f5478');\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-620ed21b-8632-4a5c-8c46-7c83cde2b14d\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-620ed21b-8632-4a5c-8c46-7c83cde2b14d')\"\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-620ed21b-8632-4a5c-8c46-7c83cde2b14d 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": 68
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df[df.club == \"Liverpool\"].age.mean()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "guE5PVRIRciN",
        "outputId": "364d76fa-ba0b-4720-ba30-1d1df8e185ab"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "26.26086956521739"
            ]
          },
          "metadata": {},
          "execution_count": 71
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df[df.club == \"Liverpool\"].age.max()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "d7Pmo_oiRsP_",
        "outputId": "90779013-d11b-4ced-b4e8-e3f57b400f7e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "36"
            ]
          },
          "metadata": {},
          "execution_count": 72
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df[(df.club == \"Liverpool\") & (df.age == 36)]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 147
        },
        "id": "s8SVgP8iSDz5",
        "outputId": "63cc4aa0-fcbc-45b2-975e-2094e538746c"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       name       club   status position position_detail  age country  active  \\\n",
              "194  Adrián  Liverpool  Reserve        K              GK   36   Spain    True   \n",
              "\n",
              "      loan        signed  ... bonus_net_usd  total_gross_eur total_net_eur  \\\n",
              "194  False  Jun 30, 2023  ...           NaN      € 3,594,155   € 1,981,393   \n",
              "\n",
              "    total_gross_gbp total_net_gbp total_gross_usd total_net_usd release_eur  \\\n",
              "194     £ 3,120,000   £ 1,720,000     $ 3,837,239   $ 2,115,401         NaN   \n",
              "\n",
              "    release_gbp release_usd  \n",
              "194         NaN         NaN  \n",
              "\n",
              "[1 rows x 39 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-fb06f5e2-ce1c-4971-8f6a-c0ff37733e79\" 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>club</th>\n",
              "      <th>status</th>\n",
              "      <th>position</th>\n",
              "      <th>position_detail</th>\n",
              "      <th>age</th>\n",
              "      <th>country</th>\n",
              "      <th>active</th>\n",
              "      <th>loan</th>\n",
              "      <th>signed</th>\n",
              "      <th>...</th>\n",
              "      <th>bonus_net_usd</th>\n",
              "      <th>total_gross_eur</th>\n",
              "      <th>total_net_eur</th>\n",
              "      <th>total_gross_gbp</th>\n",
              "      <th>total_net_gbp</th>\n",
              "      <th>total_gross_usd</th>\n",
              "      <th>total_net_usd</th>\n",
              "      <th>release_eur</th>\n",
              "      <th>release_gbp</th>\n",
              "      <th>release_usd</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>194</th>\n",
              "      <td>Adrián</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>K</td>\n",
              "      <td>GK</td>\n",
              "      <td>36</td>\n",
              "      <td>Spain</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jun 30, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 3,594,155</td>\n",
              "      <td>€ 1,981,393</td>\n",
              "      <td>£ 3,120,000</td>\n",
              "      <td>£ 1,720,000</td>\n",
              "      <td>$ 3,837,239</td>\n",
              "      <td>$ 2,115,401</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1 rows × 39 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-fb06f5e2-ce1c-4971-8f6a-c0ff37733e79')\"\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-fb06f5e2-ce1c-4971-8f6a-c0ff37733e79 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-fb06f5e2-ce1c-4971-8f6a-c0ff37733e79');\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",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 74
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.sort_values(\"annual_gross_eur\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 617
        },
        "id": "fImi9kYNSSWN",
        "outputId": "e18eb78c-b6eb-4352-960f-b4a31de7676f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                  name               club   status position position_detail  \\\n",
              "438      Ethan Horvath  Nottingham Forest  Reserve        K              GK   \n",
              "418         Ben Osborn   Sheffield United  Reserve        M              CM   \n",
              "419        Harry Arter  Nottingham Forest  Reserve        M              CM   \n",
              "420     Oliver Norwood   Sheffield United  Starter        M              CM   \n",
              "421        Ben Johnson           West Ham  Reserve        D              RB   \n",
              "..                 ...                ...      ...      ...             ...   \n",
              "560  Philippe Coutinho        Aston Villa  Reserve        F              LW   \n",
              "561       Adama Traoré             Fulham  Reserve        F              RW   \n",
              "562        Luke Harris             Fulham  Reserve        F              AM   \n",
              "563    Emmanuel Dennis  Nottingham Forest  Reserve        F              CF   \n",
              "564      Calvin Bassey             Fulham  Reserve        D              CB   \n",
              "\n",
              "     age           country  active   loan        signed  ... bonus_net_usd  \\\n",
              "438   28     United States    True  False  Jul 13, 2021  ...           NaN   \n",
              "418   29           England    True  False  Jun 26, 2023  ...           NaN   \n",
              "419   33           Ireland    True  False  Sep 22, 2020  ...           NaN   \n",
              "420   32  Northern Ireland    True  False   Jan 4, 2019  ...           NaN   \n",
              "421   23           England    True  False   Jul 1, 2020  ...           NaN   \n",
              "..   ...               ...     ...    ...           ...  ...           ...   \n",
              "560   31            Brazil   False  False   Jul 1, 2022  ...           NaN   \n",
              "561   27             Spain    True  False  Aug 12, 2023  ...           NaN   \n",
              "562   18             Wales    True  False   Jul 1, 2023  ...           NaN   \n",
              "563   25           Nigeria   False  False  Aug 13, 2022  ...           NaN   \n",
              "564   23           Nigeria    True  False  Jul 28, 2023  ...           NaN   \n",
              "\n",
              "     total_gross_eur total_net_eur total_gross_gbp total_net_gbp  \\\n",
              "438      € 1,025,256     € 564,467       £ 890,000     £ 490,000   \n",
              "418      € 1,198,052     € 656,624     £ 1,040,000     £ 570,000   \n",
              "419      € 1,198,052     € 656,624     £ 1,040,000     £ 570,000   \n",
              "420      € 1,198,052     € 656,624     £ 1,040,000     £ 570,000   \n",
              "421      € 1,198,052     € 656,624     £ 1,040,000     £ 570,000   \n",
              "..               ...           ...             ...           ...   \n",
              "560              NaN           NaN             NaN           NaN   \n",
              "561              NaN           NaN             NaN           NaN   \n",
              "562              NaN           NaN             NaN           NaN   \n",
              "563              NaN           NaN             NaN           NaN   \n",
              "564              NaN           NaN             NaN           NaN   \n",
              "\n",
              "    total_gross_usd total_net_usd release_eur release_gbp release_usd  \n",
              "438     $ 1,094,597     $ 602,643         NaN         NaN         NaN  \n",
              "418     $ 1,279,080     $ 701,034         NaN         NaN         NaN  \n",
              "419     $ 1,279,080     $ 701,034         NaN         NaN         NaN  \n",
              "420     $ 1,279,080     $ 701,034         NaN         NaN         NaN  \n",
              "421     $ 1,279,080     $ 701,034         NaN         NaN         NaN  \n",
              "..              ...           ...         ...         ...         ...  \n",
              "560             NaN           NaN         NaN         NaN         NaN  \n",
              "561             NaN           NaN         NaN         NaN         NaN  \n",
              "562             NaN           NaN         NaN         NaN         NaN  \n",
              "563             NaN           NaN         NaN         NaN         NaN  \n",
              "564             NaN           NaN         NaN         NaN         NaN  \n",
              "\n",
              "[565 rows x 39 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-69de7481-d3b7-429d-81bc-eab58e8b79db\" 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>club</th>\n",
              "      <th>status</th>\n",
              "      <th>position</th>\n",
              "      <th>position_detail</th>\n",
              "      <th>age</th>\n",
              "      <th>country</th>\n",
              "      <th>active</th>\n",
              "      <th>loan</th>\n",
              "      <th>signed</th>\n",
              "      <th>...</th>\n",
              "      <th>bonus_net_usd</th>\n",
              "      <th>total_gross_eur</th>\n",
              "      <th>total_net_eur</th>\n",
              "      <th>total_gross_gbp</th>\n",
              "      <th>total_net_gbp</th>\n",
              "      <th>total_gross_usd</th>\n",
              "      <th>total_net_usd</th>\n",
              "      <th>release_eur</th>\n",
              "      <th>release_gbp</th>\n",
              "      <th>release_usd</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>438</th>\n",
              "      <td>Ethan Horvath</td>\n",
              "      <td>Nottingham Forest</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>K</td>\n",
              "      <td>GK</td>\n",
              "      <td>28</td>\n",
              "      <td>United States</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 13, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 1,025,256</td>\n",
              "      <td>€ 564,467</td>\n",
              "      <td>£ 890,000</td>\n",
              "      <td>£ 490,000</td>\n",
              "      <td>$ 1,094,597</td>\n",
              "      <td>$ 602,643</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>418</th>\n",
              "      <td>Ben Osborn</td>\n",
              "      <td>Sheffield United</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>M</td>\n",
              "      <td>CM</td>\n",
              "      <td>29</td>\n",
              "      <td>England</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jun 26, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 1,198,052</td>\n",
              "      <td>€ 656,624</td>\n",
              "      <td>£ 1,040,000</td>\n",
              "      <td>£ 570,000</td>\n",
              "      <td>$ 1,279,080</td>\n",
              "      <td>$ 701,034</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>419</th>\n",
              "      <td>Harry Arter</td>\n",
              "      <td>Nottingham Forest</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>M</td>\n",
              "      <td>CM</td>\n",
              "      <td>33</td>\n",
              "      <td>Ireland</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Sep 22, 2020</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 1,198,052</td>\n",
              "      <td>€ 656,624</td>\n",
              "      <td>£ 1,040,000</td>\n",
              "      <td>£ 570,000</td>\n",
              "      <td>$ 1,279,080</td>\n",
              "      <td>$ 701,034</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>420</th>\n",
              "      <td>Oliver Norwood</td>\n",
              "      <td>Sheffield United</td>\n",
              "      <td>Starter</td>\n",
              "      <td>M</td>\n",
              "      <td>CM</td>\n",
              "      <td>32</td>\n",
              "      <td>Northern Ireland</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jan 4, 2019</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 1,198,052</td>\n",
              "      <td>€ 656,624</td>\n",
              "      <td>£ 1,040,000</td>\n",
              "      <td>£ 570,000</td>\n",
              "      <td>$ 1,279,080</td>\n",
              "      <td>$ 701,034</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421</th>\n",
              "      <td>Ben Johnson</td>\n",
              "      <td>West Ham</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>D</td>\n",
              "      <td>RB</td>\n",
              "      <td>23</td>\n",
              "      <td>England</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2020</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 1,198,052</td>\n",
              "      <td>€ 656,624</td>\n",
              "      <td>£ 1,040,000</td>\n",
              "      <td>£ 570,000</td>\n",
              "      <td>$ 1,279,080</td>\n",
              "      <td>$ 701,034</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>560</th>\n",
              "      <td>Philippe Coutinho</td>\n",
              "      <td>Aston Villa</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>F</td>\n",
              "      <td>LW</td>\n",
              "      <td>31</td>\n",
              "      <td>Brazil</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>561</th>\n",
              "      <td>Adama Traoré</td>\n",
              "      <td>Fulham</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>F</td>\n",
              "      <td>RW</td>\n",
              "      <td>27</td>\n",
              "      <td>Spain</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 12, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>562</th>\n",
              "      <td>Luke Harris</td>\n",
              "      <td>Fulham</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>F</td>\n",
              "      <td>AM</td>\n",
              "      <td>18</td>\n",
              "      <td>Wales</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>563</th>\n",
              "      <td>Emmanuel Dennis</td>\n",
              "      <td>Nottingham Forest</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>F</td>\n",
              "      <td>CF</td>\n",
              "      <td>25</td>\n",
              "      <td>Nigeria</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 13, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>564</th>\n",
              "      <td>Calvin Bassey</td>\n",
              "      <td>Fulham</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>D</td>\n",
              "      <td>CB</td>\n",
              "      <td>23</td>\n",
              "      <td>Nigeria</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 28, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>565 rows × 39 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-69de7481-d3b7-429d-81bc-eab58e8b79db')\"\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-69de7481-d3b7-429d-81bc-eab58e8b79db 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-69de7481-d3b7-429d-81bc-eab58e8b79db');\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-70243e55-928d-4641-af92-76cac1629d18\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-70243e55-928d-4641-af92-76cac1629d18')\"\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-70243e55-928d-4641-af92-76cac1629d18 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": 75
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df[df.club == \"Liverpool\"].sort_values(\"annual_gross_eur\", ascending = False)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "kEDblfzDSbfg",
        "outputId": "c54d10c4-5cd8-499e-8fbc-05f08bac7827"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                       name       club   status position position_detail  age  \\\n",
              "446            Curtis Jones  Liverpool  Reserve        M              CM   22   \n",
              "50         Ryan Gravenberch  Liverpool  Reserve        M              CM   21   \n",
              "51                  Alisson  Liverpool  Starter        K              GK   30   \n",
              "54      Alexis Mac Allister  Liverpool  Starter        M              CM   24   \n",
              "59             Darwin Núñez  Liverpool  Reserve        F              CF   24   \n",
              "60               Diogo Jota  Liverpool  Reserve        F              LW   26   \n",
              "71       Dominik Szoboszlai  Liverpool  Starter        F              AM   22   \n",
              "67               Cody Gakpo  Liverpool  Starter        F              CF   24   \n",
              "504       Caoimhín Kelleher  Liverpool  Reserve        K              GK   24   \n",
              "98               Joel Matip  Liverpool  Starter        D              CB   32   \n",
              "97         Andrew Robertson  Liverpool  Starter        D              LB   29   \n",
              "133               Joe Gomez  Liverpool  Starter        D              CB   26   \n",
              "169   Konstantinos Tsimikas  Liverpool  Reserve        D              LB   27   \n",
              "175         Ibrahima Konaté  Liverpool  Reserve        D              CB   24   \n",
              "194                  Adrián  Liverpool  Reserve        K              GK   36   \n",
              "210               Luis Díaz  Liverpool  Starter        F              LW   26   \n",
              "2             Mohamed Salah  Liverpool  Starter        F              RW   31   \n",
              "256             Wataru Endo  Liverpool  Reserve        M              DM   30   \n",
              "288          Harvey Elliott  Liverpool  Reserve        F              AM   20   \n",
              "294         Stefan Bajcetic  Liverpool  Reserve        M              DM   18   \n",
              "20          Virgil van Dijk  Liverpool  Starter        D              CB   32   \n",
              "25                   Thiago  Liverpool  Reserve        M              CM   32   \n",
              "37   Trent Alexander-Arnold  Liverpool  Starter        D              RB   24   \n",
              "\n",
              "         country  active   loan        signed  ... bonus_net_usd  \\\n",
              "446      England    True  False  Nov 17, 2022  ...           NaN   \n",
              "50   Netherlands    True  False   Sep 1, 2023  ...           NaN   \n",
              "51        Brazil    True  False   Aug 4, 2021  ...           NaN   \n",
              "54     Argentina    True  False   Jul 1, 2023  ...   $ 1,057,700   \n",
              "59       Uruguay    True  False   Jul 1, 2022  ...           NaN   \n",
              "60      Portugal    True  False   Aug 2, 2022  ...           NaN   \n",
              "71       Hungary    True  False   Jul 2, 2023  ...   $ 1,057,700   \n",
              "67   Netherlands    True  False   Jan 1, 2023  ...           NaN   \n",
              "504      Ireland    True  False  Jun 24, 2021  ...           NaN   \n",
              "98      Cameroon    True  False  Oct 18, 2019  ...           NaN   \n",
              "97      Scotland    True  False  Aug 24, 2021  ...           NaN   \n",
              "133      England    True  False   Jul 7, 2022  ...           NaN   \n",
              "169       Greece    True  False  Sep 25, 2023  ...           NaN   \n",
              "175       France    True  False   Jul 1, 2021  ...           NaN   \n",
              "194        Spain    True  False  Jun 30, 2023  ...           NaN   \n",
              "210     Colombia    True  False  Jan 30, 2022  ...           NaN   \n",
              "2          Egypt    True  False   Jul 1, 2022  ...   $ 1,758,734   \n",
              "256        Japan    True  False  Aug 18, 2023  ...           NaN   \n",
              "288      England    True  False  Aug 11, 2022  ...           NaN   \n",
              "294        Spain    True  False  Jan 26, 2023  ...           NaN   \n",
              "20   Netherlands    True  False  Aug 13, 2021  ...           NaN   \n",
              "25         Spain    True  False  Sep 18, 2020  ...           NaN   \n",
              "37       England    True  False  Jul 30, 2021  ...           NaN   \n",
              "\n",
              "     total_gross_eur total_net_eur total_gross_gbp total_net_gbp  \\\n",
              "446      € 3,594,155   € 1,981,393     £ 3,120,000   £ 1,720,000   \n",
              "50       € 8,985,386   € 4,941,962     £ 7,800,000   £ 4,290,000   \n",
              "51      € 35,941,545  € 19,767,850    £ 31,200,000  £ 17,160,000   \n",
              "54      € 44,926,931  € 24,709,812    £ 39,000,000  £ 21,450,000   \n",
              "59      € 41,931,803  € 23,039,452    £ 36,400,000  £ 20,000,000   \n",
              "60      € 33,545,442  € 18,431,562    £ 29,120,000  £ 16,000,000   \n",
              "71      € 35,941,545  € 19,756,330    £ 31,200,000  £ 17,150,000   \n",
              "67      € 35,941,545  € 19,756,330    £ 31,200,000  £ 17,150,000   \n",
              "504      € 1,797,077   € 1,002,216     £ 1,560,000     £ 870,000   \n",
              "98       € 5,990,258   € 3,294,642     £ 5,200,000   £ 2,860,000   \n",
              "97      € 17,970,773   € 9,883,925    £ 15,600,000   £ 8,580,000   \n",
              "133     € 20,366,876  € 11,197,174    £ 17,680,000   £ 9,720,000   \n",
              "169     € 17,970,773   € 9,906,964    £ 15,600,000   £ 8,600,000   \n",
              "175     € 12,579,541   € 6,911,836    £ 10,920,000   £ 6,000,000   \n",
              "194      € 3,594,155   € 1,981,393     £ 3,120,000   £ 1,720,000   \n",
              "210     € 13,178,567   € 7,234,388    £ 11,440,000   £ 6,280,000   \n",
              "2       € 41,931,803  € 23,062,491    £ 36,400,000  £ 20,020,000   \n",
              "256     € 11,980,515   € 6,589,283    £ 10,400,000   £ 5,720,000   \n",
              "288      € 9,584,412   € 5,252,995     £ 8,320,000   £ 4,560,000   \n",
              "294      € 9,584,412   € 5,252,995     £ 8,320,000   £ 4,560,000   \n",
              "20      € 26,357,133  € 14,491,815    £ 22,880,000  £ 12,580,000   \n",
              "25      € 11,980,515   € 6,589,283    £ 10,400,000   £ 5,720,000   \n",
              "37      € 21,564,927  € 11,865,318    £ 18,720,000  £ 10,300,000   \n",
              "\n",
              "    total_gross_usd total_net_usd release_eur release_gbp release_usd  \n",
              "446     $ 3,837,239   $ 2,115,401         NaN         NaN         NaN  \n",
              "50      $ 9,593,097   $ 5,276,203         NaN         NaN         NaN  \n",
              "51     $ 38,372,387  $ 21,104,813         NaN         NaN         NaN  \n",
              "54     $ 47,965,484  $ 26,381,016         NaN         NaN         NaN  \n",
              "59     $ 44,767,785  $ 24,597,684         NaN         NaN         NaN  \n",
              "60     $ 35,814,228  $ 19,678,147         NaN         NaN         NaN  \n",
              "71     $ 38,372,387  $ 21,092,514         NaN         NaN         NaN  \n",
              "67     $ 38,372,387  $ 21,092,514         NaN         NaN         NaN  \n",
              "504     $ 1,918,619   $ 1,069,999         NaN         NaN         NaN  \n",
              "98      $ 6,395,398   $ 3,517,469         NaN         NaN         NaN  \n",
              "97     $ 19,186,194  $ 10,552,406         NaN         NaN         NaN  \n",
              "133    $ 21,744,353  $ 11,954,474         NaN         NaN         NaN  \n",
              "169    $ 19,186,194  $ 10,577,004         NaN         NaN         NaN  \n",
              "175    $ 13,430,335   $ 7,379,305         NaN         NaN         NaN  \n",
              "194     $ 3,837,239   $ 2,115,401         NaN         NaN         NaN  \n",
              "210    $ 14,069,875   $ 7,723,673         NaN         NaN         NaN  \n",
              "2      $ 44,767,785  $ 24,622,282         NaN         NaN         NaN  \n",
              "256    $ 12,790,796   $ 7,034,938         NaN         NaN         NaN  \n",
              "288    $ 10,232,637   $ 5,608,272         NaN         NaN         NaN  \n",
              "294    $ 10,232,637   $ 5,608,272         NaN         NaN         NaN  \n",
              "20     $ 28,139,750  $ 15,471,943         NaN         NaN         NaN  \n",
              "25     $ 12,790,796   $ 7,034,938         NaN         NaN         NaN  \n",
              "37     $ 23,023,432  $ 12,667,807         NaN         NaN         NaN  \n",
              "\n",
              "[23 rows x 39 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-592fc85d-18de-4254-bd18-4f3089f04033\" 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>club</th>\n",
              "      <th>status</th>\n",
              "      <th>position</th>\n",
              "      <th>position_detail</th>\n",
              "      <th>age</th>\n",
              "      <th>country</th>\n",
              "      <th>active</th>\n",
              "      <th>loan</th>\n",
              "      <th>signed</th>\n",
              "      <th>...</th>\n",
              "      <th>bonus_net_usd</th>\n",
              "      <th>total_gross_eur</th>\n",
              "      <th>total_net_eur</th>\n",
              "      <th>total_gross_gbp</th>\n",
              "      <th>total_net_gbp</th>\n",
              "      <th>total_gross_usd</th>\n",
              "      <th>total_net_usd</th>\n",
              "      <th>release_eur</th>\n",
              "      <th>release_gbp</th>\n",
              "      <th>release_usd</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>446</th>\n",
              "      <td>Curtis Jones</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>M</td>\n",
              "      <td>CM</td>\n",
              "      <td>22</td>\n",
              "      <td>England</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Nov 17, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 3,594,155</td>\n",
              "      <td>€ 1,981,393</td>\n",
              "      <td>£ 3,120,000</td>\n",
              "      <td>£ 1,720,000</td>\n",
              "      <td>$ 3,837,239</td>\n",
              "      <td>$ 2,115,401</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50</th>\n",
              "      <td>Ryan Gravenberch</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>M</td>\n",
              "      <td>CM</td>\n",
              "      <td>21</td>\n",
              "      <td>Netherlands</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Sep 1, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 8,985,386</td>\n",
              "      <td>€ 4,941,962</td>\n",
              "      <td>£ 7,800,000</td>\n",
              "      <td>£ 4,290,000</td>\n",
              "      <td>$ 9,593,097</td>\n",
              "      <td>$ 5,276,203</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>51</th>\n",
              "      <td>Alisson</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>K</td>\n",
              "      <td>GK</td>\n",
              "      <td>30</td>\n",
              "      <td>Brazil</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 4, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 35,941,545</td>\n",
              "      <td>€ 19,767,850</td>\n",
              "      <td>£ 31,200,000</td>\n",
              "      <td>£ 17,160,000</td>\n",
              "      <td>$ 38,372,387</td>\n",
              "      <td>$ 21,104,813</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>54</th>\n",
              "      <td>Alexis Mac Allister</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>M</td>\n",
              "      <td>CM</td>\n",
              "      <td>24</td>\n",
              "      <td>Argentina</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>$ 1,057,700</td>\n",
              "      <td>€ 44,926,931</td>\n",
              "      <td>€ 24,709,812</td>\n",
              "      <td>£ 39,000,000</td>\n",
              "      <td>£ 21,450,000</td>\n",
              "      <td>$ 47,965,484</td>\n",
              "      <td>$ 26,381,016</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>59</th>\n",
              "      <td>Darwin Núñez</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>F</td>\n",
              "      <td>CF</td>\n",
              "      <td>24</td>\n",
              "      <td>Uruguay</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 41,931,803</td>\n",
              "      <td>€ 23,039,452</td>\n",
              "      <td>£ 36,400,000</td>\n",
              "      <td>£ 20,000,000</td>\n",
              "      <td>$ 44,767,785</td>\n",
              "      <td>$ 24,597,684</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60</th>\n",
              "      <td>Diogo Jota</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>F</td>\n",
              "      <td>LW</td>\n",
              "      <td>26</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 2, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 33,545,442</td>\n",
              "      <td>€ 18,431,562</td>\n",
              "      <td>£ 29,120,000</td>\n",
              "      <td>£ 16,000,000</td>\n",
              "      <td>$ 35,814,228</td>\n",
              "      <td>$ 19,678,147</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71</th>\n",
              "      <td>Dominik Szoboszlai</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>AM</td>\n",
              "      <td>22</td>\n",
              "      <td>Hungary</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 2, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>$ 1,057,700</td>\n",
              "      <td>€ 35,941,545</td>\n",
              "      <td>€ 19,756,330</td>\n",
              "      <td>£ 31,200,000</td>\n",
              "      <td>£ 17,150,000</td>\n",
              "      <td>$ 38,372,387</td>\n",
              "      <td>$ 21,092,514</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>67</th>\n",
              "      <td>Cody Gakpo</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>CF</td>\n",
              "      <td>24</td>\n",
              "      <td>Netherlands</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jan 1, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 35,941,545</td>\n",
              "      <td>€ 19,756,330</td>\n",
              "      <td>£ 31,200,000</td>\n",
              "      <td>£ 17,150,000</td>\n",
              "      <td>$ 38,372,387</td>\n",
              "      <td>$ 21,092,514</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>504</th>\n",
              "      <td>Caoimhín Kelleher</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>K</td>\n",
              "      <td>GK</td>\n",
              "      <td>24</td>\n",
              "      <td>Ireland</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jun 24, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 1,797,077</td>\n",
              "      <td>€ 1,002,216</td>\n",
              "      <td>£ 1,560,000</td>\n",
              "      <td>£ 870,000</td>\n",
              "      <td>$ 1,918,619</td>\n",
              "      <td>$ 1,069,999</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>98</th>\n",
              "      <td>Joel Matip</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>D</td>\n",
              "      <td>CB</td>\n",
              "      <td>32</td>\n",
              "      <td>Cameroon</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Oct 18, 2019</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 5,990,258</td>\n",
              "      <td>€ 3,294,642</td>\n",
              "      <td>£ 5,200,000</td>\n",
              "      <td>£ 2,860,000</td>\n",
              "      <td>$ 6,395,398</td>\n",
              "      <td>$ 3,517,469</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>97</th>\n",
              "      <td>Andrew Robertson</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>D</td>\n",
              "      <td>LB</td>\n",
              "      <td>29</td>\n",
              "      <td>Scotland</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 24, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 17,970,773</td>\n",
              "      <td>€ 9,883,925</td>\n",
              "      <td>£ 15,600,000</td>\n",
              "      <td>£ 8,580,000</td>\n",
              "      <td>$ 19,186,194</td>\n",
              "      <td>$ 10,552,406</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>133</th>\n",
              "      <td>Joe Gomez</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>D</td>\n",
              "      <td>CB</td>\n",
              "      <td>26</td>\n",
              "      <td>England</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 7, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 20,366,876</td>\n",
              "      <td>€ 11,197,174</td>\n",
              "      <td>£ 17,680,000</td>\n",
              "      <td>£ 9,720,000</td>\n",
              "      <td>$ 21,744,353</td>\n",
              "      <td>$ 11,954,474</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>169</th>\n",
              "      <td>Konstantinos Tsimikas</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>D</td>\n",
              "      <td>LB</td>\n",
              "      <td>27</td>\n",
              "      <td>Greece</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Sep 25, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 17,970,773</td>\n",
              "      <td>€ 9,906,964</td>\n",
              "      <td>£ 15,600,000</td>\n",
              "      <td>£ 8,600,000</td>\n",
              "      <td>$ 19,186,194</td>\n",
              "      <td>$ 10,577,004</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>175</th>\n",
              "      <td>Ibrahima Konaté</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>D</td>\n",
              "      <td>CB</td>\n",
              "      <td>24</td>\n",
              "      <td>France</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 12,579,541</td>\n",
              "      <td>€ 6,911,836</td>\n",
              "      <td>£ 10,920,000</td>\n",
              "      <td>£ 6,000,000</td>\n",
              "      <td>$ 13,430,335</td>\n",
              "      <td>$ 7,379,305</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>194</th>\n",
              "      <td>Adrián</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>K</td>\n",
              "      <td>GK</td>\n",
              "      <td>36</td>\n",
              "      <td>Spain</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jun 30, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 3,594,155</td>\n",
              "      <td>€ 1,981,393</td>\n",
              "      <td>£ 3,120,000</td>\n",
              "      <td>£ 1,720,000</td>\n",
              "      <td>$ 3,837,239</td>\n",
              "      <td>$ 2,115,401</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>210</th>\n",
              "      <td>Luis Díaz</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>LW</td>\n",
              "      <td>26</td>\n",
              "      <td>Colombia</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jan 30, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 13,178,567</td>\n",
              "      <td>€ 7,234,388</td>\n",
              "      <td>£ 11,440,000</td>\n",
              "      <td>£ 6,280,000</td>\n",
              "      <td>$ 14,069,875</td>\n",
              "      <td>$ 7,723,673</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Mohamed Salah</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>F</td>\n",
              "      <td>RW</td>\n",
              "      <td>31</td>\n",
              "      <td>Egypt</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 1, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>$ 1,758,734</td>\n",
              "      <td>€ 41,931,803</td>\n",
              "      <td>€ 23,062,491</td>\n",
              "      <td>£ 36,400,000</td>\n",
              "      <td>£ 20,020,000</td>\n",
              "      <td>$ 44,767,785</td>\n",
              "      <td>$ 24,622,282</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>256</th>\n",
              "      <td>Wataru Endo</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>M</td>\n",
              "      <td>DM</td>\n",
              "      <td>30</td>\n",
              "      <td>Japan</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 18, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 11,980,515</td>\n",
              "      <td>€ 6,589,283</td>\n",
              "      <td>£ 10,400,000</td>\n",
              "      <td>£ 5,720,000</td>\n",
              "      <td>$ 12,790,796</td>\n",
              "      <td>$ 7,034,938</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>288</th>\n",
              "      <td>Harvey Elliott</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>F</td>\n",
              "      <td>AM</td>\n",
              "      <td>20</td>\n",
              "      <td>England</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 11, 2022</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 9,584,412</td>\n",
              "      <td>€ 5,252,995</td>\n",
              "      <td>£ 8,320,000</td>\n",
              "      <td>£ 4,560,000</td>\n",
              "      <td>$ 10,232,637</td>\n",
              "      <td>$ 5,608,272</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>294</th>\n",
              "      <td>Stefan Bajcetic</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>M</td>\n",
              "      <td>DM</td>\n",
              "      <td>18</td>\n",
              "      <td>Spain</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jan 26, 2023</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 9,584,412</td>\n",
              "      <td>€ 5,252,995</td>\n",
              "      <td>£ 8,320,000</td>\n",
              "      <td>£ 4,560,000</td>\n",
              "      <td>$ 10,232,637</td>\n",
              "      <td>$ 5,608,272</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Virgil van Dijk</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>D</td>\n",
              "      <td>CB</td>\n",
              "      <td>32</td>\n",
              "      <td>Netherlands</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Aug 13, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 26,357,133</td>\n",
              "      <td>€ 14,491,815</td>\n",
              "      <td>£ 22,880,000</td>\n",
              "      <td>£ 12,580,000</td>\n",
              "      <td>$ 28,139,750</td>\n",
              "      <td>$ 15,471,943</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Thiago</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Reserve</td>\n",
              "      <td>M</td>\n",
              "      <td>CM</td>\n",
              "      <td>32</td>\n",
              "      <td>Spain</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Sep 18, 2020</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 11,980,515</td>\n",
              "      <td>€ 6,589,283</td>\n",
              "      <td>£ 10,400,000</td>\n",
              "      <td>£ 5,720,000</td>\n",
              "      <td>$ 12,790,796</td>\n",
              "      <td>$ 7,034,938</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>Trent Alexander-Arnold</td>\n",
              "      <td>Liverpool</td>\n",
              "      <td>Starter</td>\n",
              "      <td>D</td>\n",
              "      <td>RB</td>\n",
              "      <td>24</td>\n",
              "      <td>England</td>\n",
              "      <td>True</td>\n",
              "      <td>False</td>\n",
              "      <td>Jul 30, 2021</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>€ 21,564,927</td>\n",
              "      <td>€ 11,865,318</td>\n",
              "      <td>£ 18,720,000</td>\n",
              "      <td>£ 10,300,000</td>\n",
              "      <td>$ 23,023,432</td>\n",
              "      <td>$ 12,667,807</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>23 rows × 39 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-592fc85d-18de-4254-bd18-4f3089f04033')\"\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-592fc85d-18de-4254-bd18-4f3089f04033 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-592fc85d-18de-4254-bd18-4f3089f04033');\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-68868226-234a-4876-bba7-5d9be6c250c1\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-68868226-234a-4876-bba7-5d9be6c250c1')\"\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-68868226-234a-4876-bba7-5d9be6c250c1 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": 80
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "MPzjXt1yTOtO",
        "outputId": "580f8f7b-324a-4f64-84b7-90fdd6d5734b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 565 entries, 0 to 564\n",
            "Data columns (total 39 columns):\n",
            " #   Column            Non-Null Count  Dtype \n",
            "---  ------            --------------  ----- \n",
            " 0   name              565 non-null    object\n",
            " 1   club              565 non-null    object\n",
            " 2   status            565 non-null    object\n",
            " 3   position          565 non-null    object\n",
            " 4   position_detail   565 non-null    object\n",
            " 5   age               565 non-null    int64 \n",
            " 6   country           565 non-null    object\n",
            " 7   active            565 non-null    bool  \n",
            " 8   loan              565 non-null    bool  \n",
            " 9   signed            565 non-null    object\n",
            " 10  expiration        565 non-null    object\n",
            " 11  years             565 non-null    int64 \n",
            " 12  weekly_gross_eur  546 non-null    object\n",
            " 13  annual_gross_eur  546 non-null    object\n",
            " 14  weekly_net_eur    546 non-null    object\n",
            " 15  annual_net_eur    546 non-null    object\n",
            " 16  weekly_gross_gbp  546 non-null    object\n",
            " 17  annual_gross_gbp  546 non-null    object\n",
            " 18  weekly_net_gbp    546 non-null    object\n",
            " 19  annual_net_gbp    546 non-null    object\n",
            " 20  weekly_gross_usd  546 non-null    object\n",
            " 21  annual_gross_usd  546 non-null    object\n",
            " 22  weekly_net_usd    546 non-null    object\n",
            " 23  annual_net_usd    546 non-null    object\n",
            " 24  bonus_gross_eur   24 non-null     object\n",
            " 25  bonus_net_eur     24 non-null     object\n",
            " 26  bonus_gross_gbp   24 non-null     object\n",
            " 27  bonus_net_gbp     24 non-null     object\n",
            " 28  bonus_gross_usd   24 non-null     object\n",
            " 29  bonus_net_usd     24 non-null     object\n",
            " 30  total_gross_eur   546 non-null    object\n",
            " 31  total_net_eur     546 non-null    object\n",
            " 32  total_gross_gbp   546 non-null    object\n",
            " 33  total_net_gbp     546 non-null    object\n",
            " 34  total_gross_usd   546 non-null    object\n",
            " 35  total_net_usd     546 non-null    object\n",
            " 36  release_eur       6 non-null      object\n",
            " 37  release_gbp       6 non-null      object\n",
            " 38  release_usd       6 non-null      object\n",
            "dtypes: bool(2), int64(2), object(35)\n",
            "memory usage: 164.5+ KB\n"
          ]
        }
      ]
    }
  ]
}