FIFA17_FIFA23_Players_Combine_Dataset.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "4uF9gXM8exLR",
        "outputId": "a2d4abc6-d8a3-46e2-b262-23f34e7ae3ac"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Mounted at /content/drive\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import os\n",
        "import pandas as pd"
      ],
      "metadata": {
        "id": "tzuSuRJpe1Sw"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# define basedir of fifa dataset\n",
        "basedir = \"path-dataset-folder\""
      ],
      "metadata": {
        "id": "G6_DHUdkfVNJ"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "pd.set_option('display.max_columns', None)"
      ],
      "metadata": {
        "id": "tHHySiaWnkQY"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# check filename on directory\n",
        "data_raw = []\n",
        "for file in os.listdir(basedir):\n",
        "    filename = os.path.join(basedir, file)\n",
        "    data = pd.read_csv(filename)\n",
        "    data[\"FIFA Version\"] = [file.split(\"_\")[0]] * len(data)\n",
        "    data_raw.append(data)"
      ],
      "metadata": {
        "id": "SHEwNa4ufl0U"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Column anomaly based on FIFA17\n",
        "required_column = list(data_raw[0].columns)\n",
        "for data in data_raw:\n",
        "    current_column = list(data.columns)\n",
        "    print(f\"Missing Columns: {sorted(set(required_column) - set(current_column))}\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "BYH74zb8nQKn",
        "outputId": "7479b0a7-88e6-4ebd-bf6c-8a87b53822ac"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: ['Acceleration', 'Aggression', 'Agility', 'Balance', 'BallControl', 'Best Position', 'Composure', 'Crossing', 'Curve', 'Dribbling', 'FKAccuracy', 'Finishing', 'GKDiving', 'GKHandling', 'GKKicking', 'GKPositioning', 'GKReflexes', 'HeadingAccuracy', 'Interceptions', 'Jersey Number', 'Jumping', 'LongPassing', 'LongShots', 'Marking', 'Penalties', 'Positioning', 'Reactions', 'ShortPassing', 'ShotPower', 'SlidingTackle', 'SprintSpeed', 'Stamina', 'StandingTackle', 'Strength', 'Vision', 'Volleys']\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Column anomaly based on FIFA18\n",
        "required_column = list(data_raw[1].columns)\n",
        "for data in data_raw:\n",
        "    current_column = list(data.columns)\n",
        "    print(f\"Missing Columns: {sorted(set(required_column) - set(current_column))}\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "-kJzk3IMo8zM",
        "outputId": "322f6c13-844f-4ed5-be8f-c6adc3f5d1ac"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Missing Columns: ['Release Clause']\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: ['Acceleration', 'Aggression', 'Agility', 'Balance', 'BallControl', 'Best Position', 'Composure', 'Crossing', 'Curve', 'Dribbling', 'FKAccuracy', 'Finishing', 'GKDiving', 'GKHandling', 'GKKicking', 'GKPositioning', 'GKReflexes', 'HeadingAccuracy', 'Interceptions', 'Jersey Number', 'Jumping', 'LongPassing', 'LongShots', 'Marking', 'Penalties', 'Positioning', 'Reactions', 'ShortPassing', 'ShotPower', 'SlidingTackle', 'SprintSpeed', 'Stamina', 'StandingTackle', 'Strength', 'Vision', 'Volleys']\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Column anomaly based on FIFA19\n",
        "required_column = list(data_raw[2].columns)\n",
        "for data in data_raw:\n",
        "    current_column = list(data.columns)\n",
        "    print(f\"Missing Columns: {sorted(set(required_column) - set(current_column))}\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "uEu_Mgevo_ux",
        "outputId": "77e8f16f-9086-44d3-fe9c-87af374fed27"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Missing Columns: ['Release Clause']\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: ['Acceleration', 'Aggression', 'Agility', 'Balance', 'BallControl', 'Best Position', 'Composure', 'Crossing', 'Curve', 'Dribbling', 'FKAccuracy', 'Finishing', 'GKDiving', 'GKHandling', 'GKKicking', 'GKPositioning', 'GKReflexes', 'HeadingAccuracy', 'Interceptions', 'Jersey Number', 'Jumping', 'LongPassing', 'LongShots', 'Marking', 'Penalties', 'Positioning', 'Reactions', 'ShortPassing', 'ShotPower', 'SlidingTackle', 'SprintSpeed', 'Stamina', 'StandingTackle', 'Strength', 'Vision', 'Volleys']\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Column anomaly based on FIFA20\n",
        "required_column = list(data_raw[3].columns)\n",
        "for data in data_raw:\n",
        "    current_column = list(data.columns)\n",
        "    print(f\"Missing Columns: {sorted(set(required_column) - set(current_column))}\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "JsuDViWmpF9F",
        "outputId": "6e23d6b5-397c-4cc2-86a1-317726207252"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Missing Columns: ['DefensiveAwareness', 'Release Clause']\n",
            "Missing Columns: ['DefensiveAwareness']\n",
            "Missing Columns: ['DefensiveAwareness']\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: ['Acceleration', 'Aggression', 'Agility', 'Balance', 'BallControl', 'Best Position', 'Composure', 'Crossing', 'Curve', 'DefensiveAwareness', 'Dribbling', 'FKAccuracy', 'Finishing', 'GKDiving', 'GKHandling', 'GKKicking', 'GKPositioning', 'GKReflexes', 'HeadingAccuracy', 'Interceptions', 'Jersey Number', 'Jumping', 'LongPassing', 'LongShots', 'Marking', 'Penalties', 'Positioning', 'Reactions', 'ShortPassing', 'ShotPower', 'SlidingTackle', 'SprintSpeed', 'Stamina', 'StandingTackle', 'Strength', 'Vision', 'Volleys']\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Column anomaly based on FIFA21\n",
        "required_column = list(data_raw[4].columns)\n",
        "for data in data_raw:\n",
        "    current_column = list(data.columns)\n",
        "    print(f\"Missing Columns: {sorted(set(required_column) - set(current_column))}\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "hyENWu6xpKAL",
        "outputId": "0809b319-20f5-4b5e-b42b-342ff941b976"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Missing Columns: ['DefensiveAwareness', 'Release Clause']\n",
            "Missing Columns: ['DefensiveAwareness']\n",
            "Missing Columns: ['DefensiveAwareness']\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: ['Acceleration', 'Aggression', 'Agility', 'Balance', 'BallControl', 'Best Position', 'Composure', 'Crossing', 'Curve', 'DefensiveAwareness', 'Dribbling', 'FKAccuracy', 'Finishing', 'GKDiving', 'GKHandling', 'GKKicking', 'GKPositioning', 'GKReflexes', 'HeadingAccuracy', 'Interceptions', 'Jersey Number', 'Jumping', 'LongPassing', 'LongShots', 'Marking', 'Penalties', 'Positioning', 'Reactions', 'ShortPassing', 'ShotPower', 'SlidingTackle', 'SprintSpeed', 'Stamina', 'StandingTackle', 'Strength', 'Vision', 'Volleys']\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Column anomaly based on FIFA22\n",
        "required_column = list(data_raw[5].columns)\n",
        "for data in data_raw:\n",
        "    current_column = list(data.columns)\n",
        "    print(f\"Missing Columns: {sorted(set(required_column) - set(current_column))}\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "HpMvquZjnNAJ",
        "outputId": "c5eaaaf7-d9d8-4590-bd26-1c8360685211"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Missing Columns: ['DefensiveAwareness', 'Release Clause']\n",
            "Missing Columns: ['DefensiveAwareness']\n",
            "Missing Columns: ['DefensiveAwareness']\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: []\n",
            "Missing Columns: ['Acceleration', 'Aggression', 'Agility', 'Balance', 'BallControl', 'Best Position', 'Composure', 'Crossing', 'Curve', 'DefensiveAwareness', 'Dribbling', 'FKAccuracy', 'Finishing', 'GKDiving', 'GKHandling', 'GKKicking', 'GKPositioning', 'GKReflexes', 'HeadingAccuracy', 'Interceptions', 'Jersey Number', 'Jumping', 'LongPassing', 'LongShots', 'Marking', 'Penalties', 'Positioning', 'Reactions', 'ShortPassing', 'ShotPower', 'SlidingTackle', 'SprintSpeed', 'Stamina', 'StandingTackle', 'Strength', 'Vision', 'Volleys']\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Column anomaly based on FIFA23\n",
        "required_column = list(data_raw[-1].columns)\n",
        "for data in data_raw:\n",
        "    current_column = list(data.columns)\n",
        "    print(f\"Missing Columns: {sorted(set(required_column) - set(current_column))}\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "D-HykRPofqkl",
        "outputId": "58fc4d5a-2de8-4134-bde7-3ab96a66f7f2"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Missing Columns: ['Kit Number', 'Release Clause']\n",
            "Missing Columns: ['Kit Number']\n",
            "Missing Columns: ['Kit Number']\n",
            "Missing Columns: ['Kit Number']\n",
            "Missing Columns: ['Kit Number']\n",
            "Missing Columns: ['Kit Number']\n",
            "Missing Columns: []\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "\"Kit Number\" in data_raw[0].columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "E5RKkBsGh-c9",
        "outputId": "bea16f16-2dc8-4395-db6b-c43c2a4f2c23"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "False"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "\"Kit Number\" in data_raw[-1].columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "WjZyB5zMgSGy",
        "outputId": "81f2ba65-b5ff-45a3-a6da-616f3ae18299"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "True"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "For FIFA17 - FIFA22 \"Jersey Number\" column is equal to FIFA23 \"Kit Number\" column."
      ],
      "metadata": {
        "id": "Rlp5cX5ykYfB"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "“Release Clause” atau “Buy-Out Clause” adalah klausul dalam kontrak yang menetapkan biaya transfer minimum seorang pemain, yang telah disepakati di kontrak sang pemain dan klub yang bersangkutan. Jika satu tim melayangkan tawaran yang sama dengan release clause sang pemain, maka klub pemilik pemain tersebut harus menerima tawaran tersebut dan mempersilakan pemainnya untuk berbicara dengan klub penawar. Release clause ini berbagai macam bentuk klausulnya, bergantung kepada kesepakatan yang terjadi antara pemain dan klub saat pembicaraan kontrak."
      ],
      "metadata": {
        "id": "hPbdvdTClDSL"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "\"Value\" in data_raw[1].columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "wZqOsyeGnXN1",
        "outputId": "82a79022-96a4-45a9-85bb-ff30de803b07"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "True"
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_raw[0].columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ApAGbkR3n0ix",
        "outputId": "6be246a2-32bc-4ae0-be4c-027c223c2772"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['ID', 'Name', 'Age', 'Photo', 'Nationality', 'Flag', 'Overall',\n",
              "       'Potential', 'Club', 'Club Logo', 'Value', 'Wage', 'Special',\n",
              "       'Preferred Foot', 'International Reputation', 'Weak Foot',\n",
              "       'Skill Moves', 'Work Rate', 'Body Type', 'Real Face', 'Position',\n",
              "       'Jersey Number', 'Joined', 'Loaned From', 'Contract Valid Until',\n",
              "       'Height', 'Weight', 'Crossing', 'Finishing', 'HeadingAccuracy',\n",
              "       'ShortPassing', 'Volleys', 'Dribbling', 'Curve', 'FKAccuracy',\n",
              "       'LongPassing', 'BallControl', 'Acceleration', 'SprintSpeed', 'Agility',\n",
              "       'Reactions', 'Balance', 'ShotPower', 'Jumping', 'Stamina', 'Strength',\n",
              "       'LongShots', 'Aggression', 'Interceptions', 'Positioning', 'Vision',\n",
              "       'Penalties', 'Composure', 'Marking', 'StandingTackle', 'SlidingTackle',\n",
              "       'GKDiving', 'GKHandling', 'GKKicking', 'GKPositioning', 'GKReflexes',\n",
              "       'Best Position', 'Best Overall Rating', 'FIFA Version'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_raw[-1].head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 478
        },
        "id": "YYGIiBqL3e3m",
        "outputId": "7011e4ef-6203-40ab-be49-e29caec83994"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       ID             Name  Age  \\\n",
              "0  209658      L. Goretzka   27   \n",
              "1  212198  Bruno Fernandes   27   \n",
              "2  224334         M. Acuña   30   \n",
              "3  192985     K. De Bruyne   31   \n",
              "4  224232       N. Barella   25   \n",
              "\n",
              "                                              Photo Nationality  \\\n",
              "0  https://cdn.sofifa.net/players/209/658/23_60.png     Germany   \n",
              "1  https://cdn.sofifa.net/players/212/198/23_60.png    Portugal   \n",
              "2  https://cdn.sofifa.net/players/224/334/23_60.png   Argentina   \n",
              "3  https://cdn.sofifa.net/players/192/985/23_60.png     Belgium   \n",
              "4  https://cdn.sofifa.net/players/224/232/23_60.png       Italy   \n",
              "\n",
              "                                  Flag  Overall  Potential               Club  \\\n",
              "0  https://cdn.sofifa.net/flags/de.png       87         88  FC Bayern München   \n",
              "1  https://cdn.sofifa.net/flags/pt.png       86         87  Manchester United   \n",
              "2  https://cdn.sofifa.net/flags/ar.png       85         85         Sevilla FC   \n",
              "3  https://cdn.sofifa.net/flags/be.png       91         91    Manchester City   \n",
              "4  https://cdn.sofifa.net/flags/it.png       86         89              Inter   \n",
              "\n",
              "                                 Club Logo    Value   Wage  Special  \\\n",
              "0   https://cdn.sofifa.net/teams/21/30.png     €91M  €115K     2312   \n",
              "1   https://cdn.sofifa.net/teams/11/30.png   €78.5M  €190K     2305   \n",
              "2  https://cdn.sofifa.net/teams/481/30.png   €46.5M   €46K     2303   \n",
              "3   https://cdn.sofifa.net/teams/10/30.png  €107.5M  €350K     2303   \n",
              "4   https://cdn.sofifa.net/teams/44/30.png   €89.5M  €110K     2296   \n",
              "\n",
              "  Preferred Foot  International Reputation  Weak Foot  Skill Moves  \\\n",
              "0          Right                       4.0        4.0          3.0   \n",
              "1          Right                       3.0        3.0          4.0   \n",
              "2           Left                       2.0        3.0          3.0   \n",
              "3          Right                       4.0        5.0          4.0   \n",
              "4          Right                       3.0        3.0          3.0   \n",
              "\n",
              "      Work Rate         Body Type Real Face                     Position  \\\n",
              "0  High/ Medium            Unique       Yes  <span class=\"pos pos28\">SUB   \n",
              "1    High/ High            Unique       Yes  <span class=\"pos pos15\">LCM   \n",
              "2    High/ High  Stocky (170-185)        No    <span class=\"pos pos7\">LB   \n",
              "3    High/ High            Unique       Yes  <span class=\"pos pos13\">RCM   \n",
              "4    High/ High     Normal (170-)       Yes  <span class=\"pos pos13\">RCM   \n",
              "\n",
              "         Joined Loaned From Contract Valid Until Height Weight Release Clause  \\\n",
              "0   Jul 1, 2018         NaN                 2026  189cm   82kg          €157M   \n",
              "1  Jan 30, 2020         NaN                 2026  179cm   69kg          €155M   \n",
              "2  Sep 14, 2020         NaN                 2024  172cm   69kg         €97.7M   \n",
              "3  Aug 30, 2015         NaN                 2025  181cm   70kg        €198.9M   \n",
              "4   Sep 1, 2020         NaN                 2026  172cm   68kg        €154.4M   \n",
              "\n",
              "   Kit Number Best Overall Rating FIFA Version  \n",
              "0         8.0                 NaN       FIFA23  \n",
              "1         8.0                 NaN       FIFA23  \n",
              "2        19.0                 NaN       FIFA23  \n",
              "3        17.0                 NaN       FIFA23  \n",
              "4        23.0                 NaN       FIFA23  "
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-5ff60cce-921e-4615-a0a9-fd3340db8060\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>ID</th>\n",
              "      <th>Name</th>\n",
              "      <th>Age</th>\n",
              "      <th>Photo</th>\n",
              "      <th>Nationality</th>\n",
              "      <th>Flag</th>\n",
              "      <th>Overall</th>\n",
              "      <th>Potential</th>\n",
              "      <th>Club</th>\n",
              "      <th>Club Logo</th>\n",
              "      <th>Value</th>\n",
              "      <th>Wage</th>\n",
              "      <th>Special</th>\n",
              "      <th>Preferred Foot</th>\n",
              "      <th>International Reputation</th>\n",
              "      <th>Weak Foot</th>\n",
              "      <th>Skill Moves</th>\n",
              "      <th>Work Rate</th>\n",
              "      <th>Body Type</th>\n",
              "      <th>Real Face</th>\n",
              "      <th>Position</th>\n",
              "      <th>Joined</th>\n",
              "      <th>Loaned From</th>\n",
              "      <th>Contract Valid Until</th>\n",
              "      <th>Height</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Release Clause</th>\n",
              "      <th>Kit Number</th>\n",
              "      <th>Best Overall Rating</th>\n",
              "      <th>FIFA Version</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>209658</td>\n",
              "      <td>L. Goretzka</td>\n",
              "      <td>27</td>\n",
              "      <td>https://cdn.sofifa.net/players/209/658/23_60.png</td>\n",
              "      <td>Germany</td>\n",
              "      <td>https://cdn.sofifa.net/flags/de.png</td>\n",
              "      <td>87</td>\n",
              "      <td>88</td>\n",
              "      <td>FC Bayern München</td>\n",
              "      <td>https://cdn.sofifa.net/teams/21/30.png</td>\n",
              "      <td>€91M</td>\n",
              "      <td>€115K</td>\n",
              "      <td>2312</td>\n",
              "      <td>Right</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>High/ Medium</td>\n",
              "      <td>Unique</td>\n",
              "      <td>Yes</td>\n",
              "      <td>&lt;span class=\"pos pos28\"&gt;SUB</td>\n",
              "      <td>Jul 1, 2018</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2026</td>\n",
              "      <td>189cm</td>\n",
              "      <td>82kg</td>\n",
              "      <td>€157M</td>\n",
              "      <td>8.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>FIFA23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>212198</td>\n",
              "      <td>Bruno Fernandes</td>\n",
              "      <td>27</td>\n",
              "      <td>https://cdn.sofifa.net/players/212/198/23_60.png</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>https://cdn.sofifa.net/flags/pt.png</td>\n",
              "      <td>86</td>\n",
              "      <td>87</td>\n",
              "      <td>Manchester United</td>\n",
              "      <td>https://cdn.sofifa.net/teams/11/30.png</td>\n",
              "      <td>€78.5M</td>\n",
              "      <td>€190K</td>\n",
              "      <td>2305</td>\n",
              "      <td>Right</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>High/ High</td>\n",
              "      <td>Unique</td>\n",
              "      <td>Yes</td>\n",
              "      <td>&lt;span class=\"pos pos15\"&gt;LCM</td>\n",
              "      <td>Jan 30, 2020</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2026</td>\n",
              "      <td>179cm</td>\n",
              "      <td>69kg</td>\n",
              "      <td>€155M</td>\n",
              "      <td>8.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>FIFA23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>224334</td>\n",
              "      <td>M. Acuña</td>\n",
              "      <td>30</td>\n",
              "      <td>https://cdn.sofifa.net/players/224/334/23_60.png</td>\n",
              "      <td>Argentina</td>\n",
              "      <td>https://cdn.sofifa.net/flags/ar.png</td>\n",
              "      <td>85</td>\n",
              "      <td>85</td>\n",
              "      <td>Sevilla FC</td>\n",
              "      <td>https://cdn.sofifa.net/teams/481/30.png</td>\n",
              "      <td>€46.5M</td>\n",
              "      <td>€46K</td>\n",
              "      <td>2303</td>\n",
              "      <td>Left</td>\n",
              "      <td>2.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>High/ High</td>\n",
              "      <td>Stocky (170-185)</td>\n",
              "      <td>No</td>\n",
              "      <td>&lt;span class=\"pos pos7\"&gt;LB</td>\n",
              "      <td>Sep 14, 2020</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2024</td>\n",
              "      <td>172cm</td>\n",
              "      <td>69kg</td>\n",
              "      <td>€97.7M</td>\n",
              "      <td>19.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>FIFA23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>192985</td>\n",
              "      <td>K. De Bruyne</td>\n",
              "      <td>31</td>\n",
              "      <td>https://cdn.sofifa.net/players/192/985/23_60.png</td>\n",
              "      <td>Belgium</td>\n",
              "      <td>https://cdn.sofifa.net/flags/be.png</td>\n",
              "      <td>91</td>\n",
              "      <td>91</td>\n",
              "      <td>Manchester City</td>\n",
              "      <td>https://cdn.sofifa.net/teams/10/30.png</td>\n",
              "      <td>€107.5M</td>\n",
              "      <td>€350K</td>\n",
              "      <td>2303</td>\n",
              "      <td>Right</td>\n",
              "      <td>4.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>High/ High</td>\n",
              "      <td>Unique</td>\n",
              "      <td>Yes</td>\n",
              "      <td>&lt;span class=\"pos pos13\"&gt;RCM</td>\n",
              "      <td>Aug 30, 2015</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2025</td>\n",
              "      <td>181cm</td>\n",
              "      <td>70kg</td>\n",
              "      <td>€198.9M</td>\n",
              "      <td>17.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>FIFA23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>224232</td>\n",
              "      <td>N. Barella</td>\n",
              "      <td>25</td>\n",
              "      <td>https://cdn.sofifa.net/players/224/232/23_60.png</td>\n",
              "      <td>Italy</td>\n",
              "      <td>https://cdn.sofifa.net/flags/it.png</td>\n",
              "      <td>86</td>\n",
              "      <td>89</td>\n",
              "      <td>Inter</td>\n",
              "      <td>https://cdn.sofifa.net/teams/44/30.png</td>\n",
              "      <td>€89.5M</td>\n",
              "      <td>€110K</td>\n",
              "      <td>2296</td>\n",
              "      <td>Right</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>High/ High</td>\n",
              "      <td>Normal (170-)</td>\n",
              "      <td>Yes</td>\n",
              "      <td>&lt;span class=\"pos pos13\"&gt;RCM</td>\n",
              "      <td>Sep 1, 2020</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2026</td>\n",
              "      <td>172cm</td>\n",
              "      <td>68kg</td>\n",
              "      <td>€154.4M</td>\n",
              "      <td>23.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>FIFA23</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5ff60cce-921e-4615-a0a9-fd3340db8060')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-ae0b70c7-8a7e-4b0f-a955-f7034bb19db1\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ae0b70c7-8a7e-4b0f-a955-f7034bb19db1')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-ae0b70c7-8a7e-4b0f-a955-f7034bb19db1 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-5ff60cce-921e-4615-a0a9-fd3340db8060 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-5ff60cce-921e-4615-a0a9-fd3340db8060');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat = pd.concat(data_raw).reset_index(drop = True)"
      ],
      "metadata": {
        "id": "rVOimJploL5h"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat['Release Clause'].dtypes"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "uf7OxjF-x196",
        "outputId": "bdb8c527-bcc3-4722-b7c6-c780befb6b37"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "dtype('O')"
            ]
          },
          "metadata": {},
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "def convert_currency(val):\n",
        "    if isinstance(val, str):\n",
        "        new_val = val.replace(',', '').replace('€', '')\n",
        "        if new_val[-1] == 'B':\n",
        "            return float(new_val[:-1]) * 1000000000\n",
        "        elif new_val[-1] == 'M':\n",
        "            return float(new_val[:-1]) * 1000000\n",
        "        elif new_val[-1] == 'K':\n",
        "            return float(new_val[:-1]) * 1000\n",
        "        else:\n",
        "            return float(new_val)\n",
        "    else:\n",
        "        return val\n",
        "\n",
        "cols = ['Value', 'Wage', 'Release Clause']\n",
        "data_concat[cols] = data_concat[cols].applymap(convert_currency)"
      ],
      "metadata": {
        "id": "i2nCUo7_vzCU"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat[\"Jersey Number\"] = data_concat.apply(lambda x: x['Kit Number'] if pd.isnull(x['Jersey Number']) else x['Jersey Number'], axis = 1)\n",
        "data_concat.drop(\"Kit Number\", axis=1, inplace=True)"
      ],
      "metadata": {
        "id": "tGPsGTyNp27L"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "\"Kit Number\" in data_concat.columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "wny_74i-riim",
        "outputId": "af39c942-95d0-4270-8d57-65e9ffb4d89f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "False"
            ]
          },
          "metadata": {},
          "execution_count": 22
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 870
        },
        "id": "aIS2JVfrtXqX",
        "outputId": "178d8e18-bdb3-4125-e297-05740b1bd392"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "            ID             Name  Age  \\\n",
              "0       176580        L. Suárez   29   \n",
              "1       178518    R. Nainggolan   28   \n",
              "2       181872         A. Vidal   29   \n",
              "3       197445         D. Alaba   24   \n",
              "4       195864         P. Pogba   23   \n",
              "...        ...              ...  ...   \n",
              "122007  269526    Deng Xiongtao   19   \n",
              "122008  267946   22 Lim Jun Sub   17   \n",
              "122009  270567         A. Demir   25   \n",
              "122010  256624     21 S. Czajor   18   \n",
              "122011  256376  21 F. Jakobsson   20   \n",
              "\n",
              "                                                   Photo     Nationality  \\\n",
              "0       https://cdn.sofifa.com/players/176/580/17_60.png         Uruguay   \n",
              "1       https://cdn.sofifa.com/players/178/518/17_60.png         Belgium   \n",
              "2       https://cdn.sofifa.com/players/181/872/17_60.png           Chile   \n",
              "3       https://cdn.sofifa.com/players/197/445/17_60.png         Austria   \n",
              "4       https://cdn.sofifa.com/players/195/864/17_60.png          France   \n",
              "...                                                  ...             ...   \n",
              "122007  https://cdn.sofifa.net/players/269/526/23_60.png        China PR   \n",
              "122008  https://cdn.sofifa.net/players/267/946/22_60.png  Korea Republic   \n",
              "122009  https://cdn.sofifa.net/players/270/567/23_60.png          Turkey   \n",
              "122010  https://cdn.sofifa.net/players/256/624/21_60.png          Poland   \n",
              "122011  https://cdn.sofifa.net/players/256/376/21_60.png          Sweden   \n",
              "\n",
              "                                       Flag  Overall  Potential  \\\n",
              "0       https://cdn.sofifa.com/flags/uy.png       92         92   \n",
              "1       https://cdn.sofifa.com/flags/be.png       86         86   \n",
              "2       https://cdn.sofifa.com/flags/cl.png       87         87   \n",
              "3       https://cdn.sofifa.com/flags/at.png       86         89   \n",
              "4       https://cdn.sofifa.com/flags/fr.png       88         94   \n",
              "...                                     ...      ...        ...   \n",
              "122007  https://cdn.sofifa.net/flags/cn.png       48         61   \n",
              "122008  https://cdn.sofifa.net/flags/kr.png       48         64   \n",
              "122009  https://cdn.sofifa.net/flags/tr.png       51         56   \n",
              "122010  https://cdn.sofifa.net/flags/pl.png       50         65   \n",
              "122011  https://cdn.sofifa.net/flags/se.png       50         61   \n",
              "\n",
              "                     Club                                      Club Logo  \\\n",
              "0            FC Barcelona  https://cdn.sofifa.com/teams/241/light_30.png   \n",
              "1                    Roma   https://cdn.sofifa.com/teams/52/light_30.png   \n",
              "2       FC Bayern München   https://cdn.sofifa.com/teams/21/light_30.png   \n",
              "3       FC Bayern München   https://cdn.sofifa.com/teams/21/light_30.png   \n",
              "4       Manchester United   https://cdn.sofifa.com/teams/11/light_30.png   \n",
              "...                   ...                                            ...   \n",
              "122007      Meizhou Hakka     https://cdn.sofifa.net/teams/114628/30.png   \n",
              "122008     Jeju United FC       https://cdn.sofifa.net/teams/1478/30.png   \n",
              "122009       Ümraniyespor     https://cdn.sofifa.net/teams/113796/30.png   \n",
              "122010     Fleetwood Town     https://cdn.sofifa.net/teams/112260/30.png   \n",
              "122011     IFK Norrköping        https://cdn.sofifa.net/teams/702/30.png   \n",
              "\n",
              "             Value      Wage  Special Preferred Foot  \\\n",
              "0       83000000.0  525000.0     2291          Right   \n",
              "1       37500000.0  130000.0     2290          Right   \n",
              "2       41500000.0  180000.0     2285          Right   \n",
              "3       41500000.0  140000.0     2279           Left   \n",
              "4       71500000.0  225000.0     2271          Right   \n",
              "...            ...       ...      ...            ...   \n",
              "122007    100000.0     500.0      762          Right   \n",
              "122008    100000.0     500.0      761          Right   \n",
              "122009     70000.0    2000.0      759          Right   \n",
              "122010     90000.0     500.0      758          Right   \n",
              "122011     90000.0     500.0      749           Left   \n",
              "\n",
              "        International Reputation  Weak Foot  Skill Moves       Work Rate  \\\n",
              "0                            5.0        4.0          4.0    High/ Medium   \n",
              "1                            3.0        3.0          3.0      High/ High   \n",
              "2                            4.0        4.0          3.0      High/ High   \n",
              "3                            4.0        4.0          3.0    High/ Medium   \n",
              "4                            4.0        4.0          5.0    High/ Medium   \n",
              "...                          ...        ...          ...             ...   \n",
              "122007                       1.0        3.0          1.0  Medium/ Medium   \n",
              "122008                       1.0        2.0          1.0  Medium/ Medium   \n",
              "122009                       1.0        2.0          1.0  Medium/ Medium   \n",
              "122010                       1.0        2.0          1.0  Medium/ Medium   \n",
              "122011                       1.0        2.0          1.0  Medium/ Medium   \n",
              "\n",
              "               Body Type Real Face                     Position  \\\n",
              "0       Normal (170-185)       Yes   <span class=\"pos pos25\">ST   \n",
              "1       Stocky (170-185)        No   <span class=\"pos pos22\">LF   \n",
              "2       Normal (170-185)       Yes  <span class=\"pos pos11\">LDM   \n",
              "3         Lean (170-185)       Yes    <span class=\"pos pos7\">LB   \n",
              "4            Lean (185+)       Yes  <span class=\"pos pos11\">LDM   \n",
              "...                  ...       ...                          ...   \n",
              "122007     Normal (185+)        No  <span class=\"pos pos29\">RES   \n",
              "122008       Lean (185+)        No  <span class=\"pos pos29\">RES   \n",
              "122009       Lean (185+)        No  <span class=\"pos pos29\">RES   \n",
              "122010     Normal (185+)        No  <span class=\"pos pos29\">RES   \n",
              "122011     Normal (185+)        No  <span class=\"pos pos29\">RES   \n",
              "\n",
              "        Jersey Number        Joined Loaned From Contract Valid Until Height  \\\n",
              "0                 9.0  Jul 11, 2014         NaN                 2021    6'0   \n",
              "1                 4.0   Jan 7, 2014         NaN                 2021    5'9   \n",
              "2                23.0  Jul 28, 2015         NaN                 2019   5'11   \n",
              "3                27.0  Feb 10, 2010         NaN                 2021   5'11   \n",
              "4                 6.0   Aug 9, 2016         NaN                 2021    6'3   \n",
              "...               ...           ...         ...                  ...    ...   \n",
              "122007           35.0  Apr 11, 2022         NaN                 2027  190cm   \n",
              "122008           21.0   Jan 1, 2022         NaN                 2026  195cm   \n",
              "122009           12.0   Jun 6, 2021         NaN                 2023  190cm   \n",
              "122010           40.0   Jan 1, 2020         NaN                 2021  187cm   \n",
              "122011           30.0   Jan 8, 2020         NaN                 2021  186cm   \n",
              "\n",
              "        Weight  Crossing  Finishing  HeadingAccuracy  ShortPassing  Volleys  \\\n",
              "0       190lbs      77.0       94.0             77.0          83.0     88.0   \n",
              "1       143lbs      73.0       76.0             59.0          84.0     75.0   \n",
              "2       165lbs      76.0       77.0             81.0          84.0     78.0   \n",
              "3       168lbs      82.0       63.0             75.0          83.0     68.0   \n",
              "4       185lbs      78.0       71.0             73.0          85.0     84.0   \n",
              "...        ...       ...        ...              ...           ...      ...   \n",
              "122007    78kg       NaN        NaN              NaN           NaN      NaN   \n",
              "122008    84kg       NaN        NaN              NaN           NaN      NaN   \n",
              "122009    82kg       NaN        NaN              NaN           NaN      NaN   \n",
              "122010    79kg       NaN        NaN              NaN           NaN      NaN   \n",
              "122011    78kg       NaN        NaN              NaN           NaN      NaN   \n",
              "\n",
              "        Dribbling  Curve  FKAccuracy  LongPassing  BallControl  Acceleration  \\\n",
              "0            86.0   86.0        84.0         64.0         91.0          88.0   \n",
              "1            80.0   73.0        68.0         81.0         85.0          81.0   \n",
              "2            76.0   76.0        68.0         82.0         83.0          77.0   \n",
              "3            79.0   78.0        83.0         80.0         83.0          86.0   \n",
              "4            89.0   84.0        82.0         88.0         90.0          75.0   \n",
              "...           ...    ...         ...          ...          ...           ...   \n",
              "122007        NaN    NaN         NaN          NaN          NaN           NaN   \n",
              "122008        NaN    NaN         NaN          NaN          NaN           NaN   \n",
              "122009        NaN    NaN         NaN          NaN          NaN           NaN   \n",
              "122010        NaN    NaN         NaN          NaN          NaN           NaN   \n",
              "122011        NaN    NaN         NaN          NaN          NaN           NaN   \n",
              "\n",
              "        SprintSpeed  Agility  Reactions  Balance  ShotPower  Jumping  Stamina  \\\n",
              "0              77.0     86.0       93.0     60.0       87.0     69.0     89.0   \n",
              "1              78.0     81.0       87.0     84.0       84.0     76.0     94.0   \n",
              "2              74.0     75.0       89.0     77.0       84.0     82.0     93.0   \n",
              "3              86.0     82.0       84.0     77.0       83.0     82.0     87.0   \n",
              "4              79.0     79.0       86.0     61.0       90.0     85.0     91.0   \n",
              "...             ...      ...        ...      ...        ...      ...      ...   \n",
              "122007          NaN      NaN        NaN      NaN        NaN      NaN      NaN   \n",
              "122008          NaN      NaN        NaN      NaN        NaN      NaN      NaN   \n",
              "122009          NaN      NaN        NaN      NaN        NaN      NaN      NaN   \n",
              "122010          NaN      NaN        NaN      NaN        NaN      NaN      NaN   \n",
              "122011          NaN      NaN        NaN      NaN        NaN      NaN      NaN   \n",
              "\n",
              "        Strength  LongShots  Aggression  Interceptions  Positioning  Vision  \\\n",
              "0           80.0       86.0        78.0           41.0         92.0    84.0   \n",
              "1           78.0       86.0        88.0           86.0         88.0    76.0   \n",
              "2           79.0       85.0        91.0           89.0         80.0    80.0   \n",
              "3           69.0       83.0        69.0           85.0         77.0    78.0   \n",
              "4           91.0       87.0        72.0           70.0         84.0    87.0   \n",
              "...          ...        ...         ...            ...          ...     ...   \n",
              "122007       NaN        NaN         NaN            NaN          NaN     NaN   \n",
              "122008       NaN        NaN         NaN            NaN          NaN     NaN   \n",
              "122009       NaN        NaN         NaN            NaN          NaN     NaN   \n",
              "122010       NaN        NaN         NaN            NaN          NaN     NaN   \n",
              "122011       NaN        NaN         NaN            NaN          NaN     NaN   \n",
              "\n",
              "        Penalties  Composure  Marking  StandingTackle  SlidingTackle  \\\n",
              "0            85.0       83.0     30.0            45.0           38.0   \n",
              "1            63.0       85.0     78.0            85.0           88.0   \n",
              "2            84.0       86.0     76.0            89.0           84.0   \n",
              "3            80.0       79.0     81.0            83.0           83.0   \n",
              "4            76.0       83.0     68.0            73.0           73.0   \n",
              "...           ...        ...      ...             ...            ...   \n",
              "122007        NaN        NaN      NaN             NaN            NaN   \n",
              "122008        NaN        NaN      NaN             NaN            NaN   \n",
              "122009        NaN        NaN      NaN             NaN            NaN   \n",
              "122010        NaN        NaN      NaN             NaN            NaN   \n",
              "122011        NaN        NaN      NaN             NaN            NaN   \n",
              "\n",
              "        GKDiving  GKHandling  GKKicking  GKPositioning  GKReflexes  \\\n",
              "0           27.0        25.0       31.0           33.0        37.0   \n",
              "1           11.0        11.0       14.0            8.0        11.0   \n",
              "2            4.0         2.0        4.0            2.0         4.0   \n",
              "3            5.0         7.0       14.0           15.0         9.0   \n",
              "4            5.0         6.0        2.0            4.0         3.0   \n",
              "...          ...         ...        ...            ...         ...   \n",
              "122007       NaN         NaN        NaN            NaN         NaN   \n",
              "122008       NaN         NaN        NaN            NaN         NaN   \n",
              "122009       NaN         NaN        NaN            NaN         NaN   \n",
              "122010       NaN         NaN        NaN            NaN         NaN   \n",
              "122011       NaN         NaN        NaN            NaN         NaN   \n",
              "\n",
              "       Best Position Best Overall Rating FIFA Version  Release Clause  \\\n",
              "0                 ST                88.0       FIFA17             NaN   \n",
              "1                CDM                84.0       FIFA17             NaN   \n",
              "2                CDM                85.0       FIFA17             NaN   \n",
              "3                 LB                84.0       FIFA17             NaN   \n",
              "4                CAM                85.0       FIFA17             NaN   \n",
              "...              ...                 ...          ...             ...   \n",
              "122007           NaN                 NaN       FIFA23        218000.0   \n",
              "122008           NaN                 NaN       FIFA23        188000.0   \n",
              "122009           NaN                 NaN       FIFA23        142000.0   \n",
              "122010           NaN                 NaN       FIFA23        214000.0   \n",
              "122011           NaN                 NaN       FIFA23        131000.0   \n",
              "\n",
              "        DefensiveAwareness  \n",
              "0                      NaN  \n",
              "1                      NaN  \n",
              "2                      NaN  \n",
              "3                      NaN  \n",
              "4                      NaN  \n",
              "...                    ...  \n",
              "122007                 NaN  \n",
              "122008                 NaN  \n",
              "122009                 NaN  \n",
              "122010                 NaN  \n",
              "122011                 NaN  \n",
              "\n",
              "[122012 rows x 66 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-b99ea99e-d42a-494a-8c71-26f963af8fbe\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>ID</th>\n",
              "      <th>Name</th>\n",
              "      <th>Age</th>\n",
              "      <th>Photo</th>\n",
              "      <th>Nationality</th>\n",
              "      <th>Flag</th>\n",
              "      <th>Overall</th>\n",
              "      <th>Potential</th>\n",
              "      <th>Club</th>\n",
              "      <th>Club Logo</th>\n",
              "      <th>Value</th>\n",
              "      <th>Wage</th>\n",
              "      <th>Special</th>\n",
              "      <th>Preferred Foot</th>\n",
              "      <th>International Reputation</th>\n",
              "      <th>Weak Foot</th>\n",
              "      <th>Skill Moves</th>\n",
              "      <th>Work Rate</th>\n",
              "      <th>Body Type</th>\n",
              "      <th>Real Face</th>\n",
              "      <th>Position</th>\n",
              "      <th>Jersey Number</th>\n",
              "      <th>Joined</th>\n",
              "      <th>Loaned From</th>\n",
              "      <th>Contract Valid Until</th>\n",
              "      <th>Height</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Crossing</th>\n",
              "      <th>Finishing</th>\n",
              "      <th>HeadingAccuracy</th>\n",
              "      <th>ShortPassing</th>\n",
              "      <th>Volleys</th>\n",
              "      <th>Dribbling</th>\n",
              "      <th>Curve</th>\n",
              "      <th>FKAccuracy</th>\n",
              "      <th>LongPassing</th>\n",
              "      <th>BallControl</th>\n",
              "      <th>Acceleration</th>\n",
              "      <th>SprintSpeed</th>\n",
              "      <th>Agility</th>\n",
              "      <th>Reactions</th>\n",
              "      <th>Balance</th>\n",
              "      <th>ShotPower</th>\n",
              "      <th>Jumping</th>\n",
              "      <th>Stamina</th>\n",
              "      <th>Strength</th>\n",
              "      <th>LongShots</th>\n",
              "      <th>Aggression</th>\n",
              "      <th>Interceptions</th>\n",
              "      <th>Positioning</th>\n",
              "      <th>Vision</th>\n",
              "      <th>Penalties</th>\n",
              "      <th>Composure</th>\n",
              "      <th>Marking</th>\n",
              "      <th>StandingTackle</th>\n",
              "      <th>SlidingTackle</th>\n",
              "      <th>GKDiving</th>\n",
              "      <th>GKHandling</th>\n",
              "      <th>GKKicking</th>\n",
              "      <th>GKPositioning</th>\n",
              "      <th>GKReflexes</th>\n",
              "      <th>Best Position</th>\n",
              "      <th>Best Overall Rating</th>\n",
              "      <th>FIFA Version</th>\n",
              "      <th>Release Clause</th>\n",
              "      <th>DefensiveAwareness</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>176580</td>\n",
              "      <td>L. Suárez</td>\n",
              "      <td>29</td>\n",
              "      <td>https://cdn.sofifa.com/players/176/580/17_60.png</td>\n",
              "      <td>Uruguay</td>\n",
              "      <td>https://cdn.sofifa.com/flags/uy.png</td>\n",
              "      <td>92</td>\n",
              "      <td>92</td>\n",
              "      <td>FC Barcelona</td>\n",
              "      <td>https://cdn.sofifa.com/teams/241/light_30.png</td>\n",
              "      <td>83000000.0</td>\n",
              "      <td>525000.0</td>\n",
              "      <td>2291</td>\n",
              "      <td>Right</td>\n",
              "      <td>5.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>High/ Medium</td>\n",
              "      <td>Normal (170-185)</td>\n",
              "      <td>Yes</td>\n",
              "      <td>&lt;span class=\"pos pos25\"&gt;ST</td>\n",
              "      <td>9.0</td>\n",
              "      <td>Jul 11, 2014</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021</td>\n",
              "      <td>6'0</td>\n",
              "      <td>190lbs</td>\n",
              "      <td>77.0</td>\n",
              "      <td>94.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>64.0</td>\n",
              "      <td>91.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>93.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>87.0</td>\n",
              "      <td>69.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>41.0</td>\n",
              "      <td>92.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>45.0</td>\n",
              "      <td>38.0</td>\n",
              "      <td>27.0</td>\n",
              "      <td>25.0</td>\n",
              "      <td>31.0</td>\n",
              "      <td>33.0</td>\n",
              "      <td>37.0</td>\n",
              "      <td>ST</td>\n",
              "      <td>88.0</td>\n",
              "      <td>FIFA17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>178518</td>\n",
              "      <td>R. Nainggolan</td>\n",
              "      <td>28</td>\n",
              "      <td>https://cdn.sofifa.com/players/178/518/17_60.png</td>\n",
              "      <td>Belgium</td>\n",
              "      <td>https://cdn.sofifa.com/flags/be.png</td>\n",
              "      <td>86</td>\n",
              "      <td>86</td>\n",
              "      <td>Roma</td>\n",
              "      <td>https://cdn.sofifa.com/teams/52/light_30.png</td>\n",
              "      <td>37500000.0</td>\n",
              "      <td>130000.0</td>\n",
              "      <td>2290</td>\n",
              "      <td>Right</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>High/ High</td>\n",
              "      <td>Stocky (170-185)</td>\n",
              "      <td>No</td>\n",
              "      <td>&lt;span class=\"pos pos22\"&gt;LF</td>\n",
              "      <td>4.0</td>\n",
              "      <td>Jan 7, 2014</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021</td>\n",
              "      <td>5'9</td>\n",
              "      <td>143lbs</td>\n",
              "      <td>73.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>59.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>73.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>87.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>94.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>63.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>CDM</td>\n",
              "      <td>84.0</td>\n",
              "      <td>FIFA17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>181872</td>\n",
              "      <td>A. Vidal</td>\n",
              "      <td>29</td>\n",
              "      <td>https://cdn.sofifa.com/players/181/872/17_60.png</td>\n",
              "      <td>Chile</td>\n",
              "      <td>https://cdn.sofifa.com/flags/cl.png</td>\n",
              "      <td>87</td>\n",
              "      <td>87</td>\n",
              "      <td>FC Bayern München</td>\n",
              "      <td>https://cdn.sofifa.com/teams/21/light_30.png</td>\n",
              "      <td>41500000.0</td>\n",
              "      <td>180000.0</td>\n",
              "      <td>2285</td>\n",
              "      <td>Right</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>High/ High</td>\n",
              "      <td>Normal (170-185)</td>\n",
              "      <td>Yes</td>\n",
              "      <td>&lt;span class=\"pos pos11\"&gt;LDM</td>\n",
              "      <td>23.0</td>\n",
              "      <td>Jul 28, 2015</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2019</td>\n",
              "      <td>5'11</td>\n",
              "      <td>165lbs</td>\n",
              "      <td>76.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>74.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>93.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>91.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>CDM</td>\n",
              "      <td>85.0</td>\n",
              "      <td>FIFA17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>197445</td>\n",
              "      <td>D. Alaba</td>\n",
              "      <td>24</td>\n",
              "      <td>https://cdn.sofifa.com/players/197/445/17_60.png</td>\n",
              "      <td>Austria</td>\n",
              "      <td>https://cdn.sofifa.com/flags/at.png</td>\n",
              "      <td>86</td>\n",
              "      <td>89</td>\n",
              "      <td>FC Bayern München</td>\n",
              "      <td>https://cdn.sofifa.com/teams/21/light_30.png</td>\n",
              "      <td>41500000.0</td>\n",
              "      <td>140000.0</td>\n",
              "      <td>2279</td>\n",
              "      <td>Left</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>High/ Medium</td>\n",
              "      <td>Lean (170-185)</td>\n",
              "      <td>Yes</td>\n",
              "      <td>&lt;span class=\"pos pos7\"&gt;LB</td>\n",
              "      <td>27.0</td>\n",
              "      <td>Feb 10, 2010</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021</td>\n",
              "      <td>5'11</td>\n",
              "      <td>168lbs</td>\n",
              "      <td>82.0</td>\n",
              "      <td>63.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>87.0</td>\n",
              "      <td>69.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>69.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>LB</td>\n",
              "      <td>84.0</td>\n",
              "      <td>FIFA17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>195864</td>\n",
              "      <td>P. Pogba</td>\n",
              "      <td>23</td>\n",
              "      <td>https://cdn.sofifa.com/players/195/864/17_60.png</td>\n",
              "      <td>France</td>\n",
              "      <td>https://cdn.sofifa.com/flags/fr.png</td>\n",
              "      <td>88</td>\n",
              "      <td>94</td>\n",
              "      <td>Manchester United</td>\n",
              "      <td>https://cdn.sofifa.com/teams/11/light_30.png</td>\n",
              "      <td>71500000.0</td>\n",
              "      <td>225000.0</td>\n",
              "      <td>2271</td>\n",
              "      <td>Right</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>High/ Medium</td>\n",
              "      <td>Lean (185+)</td>\n",
              "      <td>Yes</td>\n",
              "      <td>&lt;span class=\"pos pos11\"&gt;LDM</td>\n",
              "      <td>6.0</td>\n",
              "      <td>Aug 9, 2016</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021</td>\n",
              "      <td>6'3</td>\n",
              "      <td>185lbs</td>\n",
              "      <td>78.0</td>\n",
              "      <td>71.0</td>\n",
              "      <td>73.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>90.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>61.0</td>\n",
              "      <td>90.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>91.0</td>\n",
              "      <td>91.0</td>\n",
              "      <td>87.0</td>\n",
              "      <td>72.0</td>\n",
              "      <td>70.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>87.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>73.0</td>\n",
              "      <td>73.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>CAM</td>\n",
              "      <td>85.0</td>\n",
              "      <td>FIFA17</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",
              "      <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",
              "      <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",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122007</th>\n",
              "      <td>269526</td>\n",
              "      <td>Deng Xiongtao</td>\n",
              "      <td>19</td>\n",
              "      <td>https://cdn.sofifa.net/players/269/526/23_60.png</td>\n",
              "      <td>China PR</td>\n",
              "      <td>https://cdn.sofifa.net/flags/cn.png</td>\n",
              "      <td>48</td>\n",
              "      <td>61</td>\n",
              "      <td>Meizhou Hakka</td>\n",
              "      <td>https://cdn.sofifa.net/teams/114628/30.png</td>\n",
              "      <td>100000.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>762</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Normal (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>&lt;span class=\"pos pos29\"&gt;RES</td>\n",
              "      <td>35.0</td>\n",
              "      <td>Apr 11, 2022</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2027</td>\n",
              "      <td>190cm</td>\n",
              "      <td>78kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>218000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122008</th>\n",
              "      <td>267946</td>\n",
              "      <td>22 Lim Jun Sub</td>\n",
              "      <td>17</td>\n",
              "      <td>https://cdn.sofifa.net/players/267/946/22_60.png</td>\n",
              "      <td>Korea Republic</td>\n",
              "      <td>https://cdn.sofifa.net/flags/kr.png</td>\n",
              "      <td>48</td>\n",
              "      <td>64</td>\n",
              "      <td>Jeju United FC</td>\n",
              "      <td>https://cdn.sofifa.net/teams/1478/30.png</td>\n",
              "      <td>100000.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>761</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Lean (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>&lt;span class=\"pos pos29\"&gt;RES</td>\n",
              "      <td>21.0</td>\n",
              "      <td>Jan 1, 2022</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2026</td>\n",
              "      <td>195cm</td>\n",
              "      <td>84kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>188000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122009</th>\n",
              "      <td>270567</td>\n",
              "      <td>A. Demir</td>\n",
              "      <td>25</td>\n",
              "      <td>https://cdn.sofifa.net/players/270/567/23_60.png</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>https://cdn.sofifa.net/flags/tr.png</td>\n",
              "      <td>51</td>\n",
              "      <td>56</td>\n",
              "      <td>Ümraniyespor</td>\n",
              "      <td>https://cdn.sofifa.net/teams/113796/30.png</td>\n",
              "      <td>70000.0</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>759</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Lean (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>&lt;span class=\"pos pos29\"&gt;RES</td>\n",
              "      <td>12.0</td>\n",
              "      <td>Jun 6, 2021</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023</td>\n",
              "      <td>190cm</td>\n",
              "      <td>82kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>142000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122010</th>\n",
              "      <td>256624</td>\n",
              "      <td>21 S. Czajor</td>\n",
              "      <td>18</td>\n",
              "      <td>https://cdn.sofifa.net/players/256/624/21_60.png</td>\n",
              "      <td>Poland</td>\n",
              "      <td>https://cdn.sofifa.net/flags/pl.png</td>\n",
              "      <td>50</td>\n",
              "      <td>65</td>\n",
              "      <td>Fleetwood Town</td>\n",
              "      <td>https://cdn.sofifa.net/teams/112260/30.png</td>\n",
              "      <td>90000.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>758</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Normal (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>&lt;span class=\"pos pos29\"&gt;RES</td>\n",
              "      <td>40.0</td>\n",
              "      <td>Jan 1, 2020</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021</td>\n",
              "      <td>187cm</td>\n",
              "      <td>79kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>214000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122011</th>\n",
              "      <td>256376</td>\n",
              "      <td>21 F. Jakobsson</td>\n",
              "      <td>20</td>\n",
              "      <td>https://cdn.sofifa.net/players/256/376/21_60.png</td>\n",
              "      <td>Sweden</td>\n",
              "      <td>https://cdn.sofifa.net/flags/se.png</td>\n",
              "      <td>50</td>\n",
              "      <td>61</td>\n",
              "      <td>IFK Norrköping</td>\n",
              "      <td>https://cdn.sofifa.net/teams/702/30.png</td>\n",
              "      <td>90000.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>749</td>\n",
              "      <td>Left</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Normal (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>&lt;span class=\"pos pos29\"&gt;RES</td>\n",
              "      <td>30.0</td>\n",
              "      <td>Jan 8, 2020</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021</td>\n",
              "      <td>186cm</td>\n",
              "      <td>78kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>131000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>122012 rows × 66 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b99ea99e-d42a-494a-8c71-26f963af8fbe')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-c6e62dd9-6993-41e4-abae-7d89656cbfcb\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-c6e62dd9-6993-41e4-abae-7d89656cbfcb')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-c6e62dd9-6993-41e4-abae-7d89656cbfcb button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-b99ea99e-d42a-494a-8c71-26f963af8fbe 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-b99ea99e-d42a-494a-8c71-26f963af8fbe');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Dalam data FIFA player, “Position” mengacu pada posisi utama pemain di lapangan, sedangkan “Best Position” mengacu pada posisi di mana pemain memiliki peringkat keseluruhan tertinggi. Sebagai contoh, seorang pemain mungkin memiliki “Position” sebagai gelandang tengah (CM), tetapi memiliki peringkat keseluruhan tertinggi ketika bermain sebagai gelandang bertahan (CDM), sehingga “Best Position” mereka adalah CDM."
      ],
      "metadata": {
        "id": "uq29LfErtM7g"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat['Position'].dtypes"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "SVINaffTq1n2",
        "outputId": "1a93cde4-819c-46d9-9643-8417e63bd456"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "dtype('O')"
            ]
          },
          "metadata": {},
          "execution_count": 24
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# change all value in column 'Position' to string\n",
        "data_concat['Position'] = data_concat['Position'].astype(str)"
      ],
      "metadata": {
        "id": "8ZaykUdkro6L"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "Berikut adalah penjelasan singkatan posisi dalam data FIFA player:\n",
        "\n",
        "CB: Centre Back (Bek Tengah)\n",
        "\n",
        "ST: Striker (Penyerang)\n",
        "\n",
        "CAM: Central Attacking Midfielder (Gelandang Serang Tengah)\n",
        "\n",
        "GK: Goalkeeper (Penjaga Gawang)\n",
        "\n",
        "RM: Right Midfielder (Gelandang Kanan)\n",
        "\n",
        "CDM: Central Defensive Midfielder (Gelandang Bertahan Tengah)\n",
        "\n",
        "CM: Central Midfielder (Gelandang Tengah)\n",
        "\n",
        "RB: Right Back (Bek Kanan)\n",
        "\n",
        "LB: Left Back (Bek Kiri)\n",
        "\n",
        "LM: Left Midfielder (Gelandang Kiri)\n",
        "\n",
        "RW: Right Winger (Sayap Kanan)\n",
        "\n",
        "RWB: Right Wing Back (Bek Sayap Kanan)\n",
        "\n",
        "LWB: Left Wing Back (Bek Sayap Kiri)\n",
        "\n",
        "LW: Left Winger (Sayap Kiri)\n",
        "\n",
        "CF: Centre Forward (Penyerang Tengah)\n",
        "\n",
        "LF: Left Forward (Penyerang Kiri)\n",
        "\n",
        "SW: Sweeper (Sweeper)"
      ],
      "metadata": {
        "id": "QAJtfwFutmYl"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat['Best Position'].value_counts()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "qvBcjFyXsQJy",
        "outputId": "0a454fba-7b90-4941-e9af-fd18a7dd7e3f"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "CB     20687\n",
              "ST     15332\n",
              "CAM    12517\n",
              "GK     10890\n",
              "RM      8359\n",
              "CDM     7824\n",
              "CM      6018\n",
              "RB      5116\n",
              "LB      4840\n",
              "LM      4711\n",
              "RW      2656\n",
              "RWB     1861\n",
              "LWB     1779\n",
              "LW      1279\n",
              "CF       480\n",
              "LF         2\n",
              "SW         1\n",
              "Name: Best Position, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Define function to get characters after '>'\n",
        "def get_char_after_gt(x):\n",
        "    if '>' in x:\n",
        "        return x.split('>')[1]\n",
        "    else:\n",
        "        return x"
      ],
      "metadata": {
        "id": "th2oUQy6qWiW"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat['Position'] = data_concat['Position'].apply(get_char_after_gt)"
      ],
      "metadata": {
        "id": "DpfP6jKlqezm"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat['Position'].value_counts()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "pT8rquteuG4b",
        "outputId": "fa3a1911-8baa-4842-e993-73d4a1663bc4"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "SUB    52317\n",
              "RES    23487\n",
              "RCB     4127\n",
              "LCB     4070\n",
              "GK      3938\n",
              "RB      3368\n",
              "LB      3357\n",
              "ST      3026\n",
              "RM      2731\n",
              "LM      2682\n",
              "RCM     2590\n",
              "LCM     2581\n",
              "CAM     2032\n",
              "RDM     1508\n",
              "LDM     1495\n",
              "LS      1402\n",
              "RS      1385\n",
              "CDM     1032\n",
              "LW      1024\n",
              "RW       998\n",
              "CB       740\n",
              "RWB      465\n",
              "LWB      450\n",
              "CM       433\n",
              "nan      152\n",
              "RAM      146\n",
              "LAM      146\n",
              "LF       130\n",
              "RF       120\n",
              "CF        80\n",
              "Name: Position, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "SUB: Substitute (Pemain Cadangan)\n",
        "\n",
        "RES: Reserve (Pemain Cadangan)\n",
        "\n",
        "RCB: Right Centre Back (Bek Tengah Kanan)\n",
        "\n",
        "LCB: Left Centre Back (Bek Tengah Kiri)\n",
        "\n",
        "GK: Goalkeeper (Penjaga Gawang)\n",
        "\n",
        "RB: Right Back (Bek Kanan)\n",
        "\n",
        "LB: Left Back (Bek Kiri)\n",
        "\n",
        "ST: Striker (Penyerang)\n",
        "\n",
        "RM: Right Midfielder (Gelandang Kanan)\n",
        "\n",
        "LM: Left Midfielder (Gelandang Kiri)\n",
        "\n",
        "RCM: Right Central Midfielder (Gelandang Tengah Kanan)\n",
        "\n",
        "LCM: Left Central Midfielder (Gelandang Tengah Kiri)\n",
        "\n",
        "CAM: Central Attacking Midfielder (Gelandang Serang Tengah)\n",
        "\n",
        "RDM: Right Defensive Midfielder (Gelandang Bertahan Kanan)\n",
        "\n",
        "LDM: Left Defensive Midfielder (Gelandang Bertahan Kiri)\n",
        "\n",
        "LS: Left Striker (Penyerang Kiri)\n",
        "\n",
        "RS: Right Striker (Penyerang Kanan)\n",
        "\n",
        "CDM: Central Defensive Midfielder (Gelandang Bertahan Tengah)\n",
        "\n",
        "LW: Left Winger (Sayap Kiri)\n",
        "\n",
        "RW: Right Winger (Sayap Kanan)\n",
        "\n",
        "CB: Centre Back (Bek Tengah)\n",
        "\n",
        "RWB: Right Wing Back (Bek Sayap Kanan)\n",
        "\n",
        "LWB: Left Wing Back (Bek Sayap Kiri)\n",
        "\n",
        "CM: Central Midfielder (Gelandang Tengah)\n",
        "\n",
        "RAM: Right Attacking Midfielder (Gelandang Serang Kanan)\n",
        "\n",
        "LAM: Left Attacking Midfielder (Gelandang Serang Kiri)\n",
        "\n",
        "LF: Left Forward (Penyerang Kiri)\n",
        "\n",
        "RF: Right Forward (Penyerang Kanan)\n",
        "\n",
        "CF: Centre Forward (Penyerang Tengah)"
      ],
      "metadata": {
        "id": "aNJ035gbwRzF"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "wMKMQVBBHUbc",
        "outputId": "47f280ba-15b6-4815-be4d-052cca12a496"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 122012 entries, 0 to 122011\n",
            "Data columns (total 66 columns):\n",
            " #   Column                    Non-Null Count   Dtype  \n",
            "---  ------                    --------------   -----  \n",
            " 0   ID                        122012 non-null  int64  \n",
            " 1   Name                      122012 non-null  object \n",
            " 2   Age                       122012 non-null  int64  \n",
            " 3   Photo                     122012 non-null  object \n",
            " 4   Nationality               122012 non-null  object \n",
            " 5   Flag                      122012 non-null  object \n",
            " 6   Overall                   122012 non-null  int64  \n",
            " 7   Potential                 122012 non-null  int64  \n",
            " 8   Club                      120091 non-null  object \n",
            " 9   Club Logo                 122012 non-null  object \n",
            " 10  Value                     122012 non-null  float64\n",
            " 11  Wage                      122012 non-null  float64\n",
            " 12  Special                   122012 non-null  int64  \n",
            " 13  Preferred Foot            122012 non-null  object \n",
            " 14  International Reputation  122012 non-null  float64\n",
            " 15  Weak Foot                 122012 non-null  float64\n",
            " 16  Skill Moves               122012 non-null  float64\n",
            " 17  Work Rate                 122012 non-null  object \n",
            " 18  Body Type                 121893 non-null  object \n",
            " 19  Real Face                 121893 non-null  object \n",
            " 20  Position                  122012 non-null  object \n",
            " 21  Jersey Number             121860 non-null  float64\n",
            " 22  Joined                    110453 non-null  object \n",
            " 23  Loaned From               8537 non-null    object \n",
            " 24  Contract Valid Until      119115 non-null  object \n",
            " 25  Height                    122012 non-null  object \n",
            " 26  Weight                    122012 non-null  object \n",
            " 27  Crossing                  104352 non-null  float64\n",
            " 28  Finishing                 104352 non-null  float64\n",
            " 29  HeadingAccuracy           104352 non-null  float64\n",
            " 30  ShortPassing              104352 non-null  float64\n",
            " 31  Volleys                   104237 non-null  float64\n",
            " 32  Dribbling                 104352 non-null  float64\n",
            " 33  Curve                     104237 non-null  float64\n",
            " 34  FKAccuracy                104352 non-null  float64\n",
            " 35  LongPassing               104352 non-null  float64\n",
            " 36  BallControl               104352 non-null  float64\n",
            " 37  Acceleration              104352 non-null  float64\n",
            " 38  SprintSpeed               104352 non-null  float64\n",
            " 39  Agility                   104237 non-null  float64\n",
            " 40  Reactions                 104352 non-null  float64\n",
            " 41  Balance                   104237 non-null  float64\n",
            " 42  ShotPower                 104352 non-null  float64\n",
            " 43  Jumping                   104237 non-null  float64\n",
            " 44  Stamina                   104352 non-null  float64\n",
            " 45  Strength                  104352 non-null  float64\n",
            " 46  LongShots                 104352 non-null  float64\n",
            " 47  Aggression                104352 non-null  float64\n",
            " 48  Interceptions             104337 non-null  float64\n",
            " 49  Positioning               104337 non-null  float64\n",
            " 50  Vision                    104237 non-null  float64\n",
            " 51  Penalties                 104352 non-null  float64\n",
            " 52  Composure                 103394 non-null  float64\n",
            " 53  Marking                   56950 non-null   float64\n",
            " 54  StandingTackle            104352 non-null  float64\n",
            " 55  SlidingTackle             104237 non-null  float64\n",
            " 56  GKDiving                  104352 non-null  float64\n",
            " 57  GKHandling                104352 non-null  float64\n",
            " 58  GKKicking                 104352 non-null  float64\n",
            " 59  GKPositioning             104352 non-null  float64\n",
            " 60  GKReflexes                104352 non-null  float64\n",
            " 61  Best Position             104352 non-null  object \n",
            " 62  Best Overall Rating       104373 non-null  object \n",
            " 63  FIFA Version              122012 non-null  object \n",
            " 64  Release Clause            94017 non-null   float64\n",
            " 65  DefensiveAwareness        47402 non-null   float64\n",
            "dtypes: float64(42), int64(5), object(19)\n",
            "memory usage: 61.4+ MB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat.columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "_6uS96UOOJQ8",
        "outputId": "e0bda277-9066-468e-c0ed-c1a11625c8c4"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['ID', 'Name', 'Age', 'Photo', 'Nationality', 'Flag', 'Overall',\n",
              "       'Potential', 'Club', 'Club Logo', 'Value', 'Wage', 'Special',\n",
              "       'Preferred Foot', 'International Reputation', 'Weak Foot',\n",
              "       'Skill Moves', 'Work Rate', 'Body Type', 'Real Face', 'Position',\n",
              "       'Jersey Number', 'Joined', 'Loaned From', 'Contract Valid Until',\n",
              "       'Height', 'Weight', 'Crossing', 'Finishing', 'HeadingAccuracy',\n",
              "       'ShortPassing', 'Volleys', 'Dribbling', 'Curve', 'FKAccuracy',\n",
              "       'LongPassing', 'BallControl', 'Acceleration', 'SprintSpeed', 'Agility',\n",
              "       'Reactions', 'Balance', 'ShotPower', 'Jumping', 'Stamina', 'Strength',\n",
              "       'LongShots', 'Aggression', 'Interceptions', 'Positioning', 'Vision',\n",
              "       'Penalties', 'Composure', 'Marking', 'StandingTackle', 'SlidingTackle',\n",
              "       'GKDiving', 'GKHandling', 'GKKicking', 'GKPositioning', 'GKReflexes',\n",
              "       'Best Position', 'Best Overall Rating', 'FIFA Version',\n",
              "       'Release Clause', 'DefensiveAwareness'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {},
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat[data_concat[\"Name\"] == 'Cristiano Ronaldo']"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 280
        },
        "id": "3kAW4UdNR1MT",
        "outputId": "24f6a3f5-5b32-4297-9ed9-d71c2ae6fef2"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "             ID               Name   Age Nationality  Overall  Potential  \\\n",
              "70570   20801.0  Cristiano Ronaldo  36.0    Portugal     91.0       91.0   \n",
              "104452  20801.0  Cristiano Ronaldo  37.0    Portugal     90.0       90.0   \n",
              "\n",
              "                     Club       Value      Wage  Special Preferred Foot  \\\n",
              "70570   Manchester United  45000000.0  270000.0   2208.0          Right   \n",
              "104452  Manchester United  41000000.0  220000.0   2159.0          Right   \n",
              "\n",
              "        International Reputation  Weak Foot  Skill Moves  Work Rate Body Type  \\\n",
              "70570                        5.0        4.0          5.0  High/ Low    Unique   \n",
              "104452                       5.0        4.0          5.0  High/ Low    Unique   \n",
              "\n",
              "       Real Face Position  Jersey Number        Joined Loaned From  \\\n",
              "70570        Yes       ST            7.0  Aug 27, 2021         NaN   \n",
              "104452       Yes       ST            7.0  Aug 27, 2021         NaN   \n",
              "\n",
              "       Contract Valid Until Height Weight  Crossing  Finishing  \\\n",
              "70570                  2023  187cm   83kg      87.0       95.0   \n",
              "104452                 2023  187cm   83kg       NaN        NaN   \n",
              "\n",
              "        HeadingAccuracy  ShortPassing  Volleys  Dribbling  Curve  FKAccuracy  \\\n",
              "70570              90.0          80.0     86.0       88.0   81.0        84.0   \n",
              "104452              NaN           NaN      NaN        NaN    NaN         NaN   \n",
              "\n",
              "        LongPassing  BallControl  Acceleration  SprintSpeed  Agility  \\\n",
              "70570          77.0         88.0          85.0         88.0     86.0   \n",
              "104452          NaN          NaN           NaN          NaN      NaN   \n",
              "\n",
              "        Reactions  Balance  ShotPower  Jumping  Stamina  Strength  LongShots  \\\n",
              "70570        94.0     74.0       94.0     95.0     77.0      77.0       93.0   \n",
              "104452        NaN      NaN        NaN      NaN      NaN       NaN        NaN   \n",
              "\n",
              "        Aggression  Interceptions  Positioning  Vision  Penalties  Composure  \\\n",
              "70570         63.0           29.0         95.0    76.0       88.0       95.0   \n",
              "104452         NaN            NaN          NaN     NaN        NaN        NaN   \n",
              "\n",
              "        Marking  StandingTackle  SlidingTackle  GKDiving  GKHandling  \\\n",
              "70570       NaN            32.0           24.0       7.0        11.0   \n",
              "104452      NaN             NaN            NaN       NaN         NaN   \n",
              "\n",
              "        GKKicking  GKPositioning  GKReflexes Best Position  \\\n",
              "70570        15.0           14.0        11.0            ST   \n",
              "104452        NaN            NaN         NaN           NaN   \n",
              "\n",
              "       Best Overall Rating FIFA Version  Release Clause  DefensiveAwareness  \n",
              "70570                 91.0       FIFA22      83300000.0                24.0  \n",
              "104452                 NaN       FIFA23      77900000.0                 NaN  "
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-69bf7c0a-c0ef-4fe0-a899-f7e70b0c3c7e\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>ID</th>\n",
              "      <th>Name</th>\n",
              "      <th>Age</th>\n",
              "      <th>Nationality</th>\n",
              "      <th>Overall</th>\n",
              "      <th>Potential</th>\n",
              "      <th>Club</th>\n",
              "      <th>Value</th>\n",
              "      <th>Wage</th>\n",
              "      <th>Special</th>\n",
              "      <th>Preferred Foot</th>\n",
              "      <th>International Reputation</th>\n",
              "      <th>Weak Foot</th>\n",
              "      <th>Skill Moves</th>\n",
              "      <th>Work Rate</th>\n",
              "      <th>Body Type</th>\n",
              "      <th>Real Face</th>\n",
              "      <th>Position</th>\n",
              "      <th>Jersey Number</th>\n",
              "      <th>Joined</th>\n",
              "      <th>Loaned From</th>\n",
              "      <th>Contract Valid Until</th>\n",
              "      <th>Height</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Crossing</th>\n",
              "      <th>Finishing</th>\n",
              "      <th>HeadingAccuracy</th>\n",
              "      <th>ShortPassing</th>\n",
              "      <th>Volleys</th>\n",
              "      <th>Dribbling</th>\n",
              "      <th>Curve</th>\n",
              "      <th>FKAccuracy</th>\n",
              "      <th>LongPassing</th>\n",
              "      <th>BallControl</th>\n",
              "      <th>Acceleration</th>\n",
              "      <th>SprintSpeed</th>\n",
              "      <th>Agility</th>\n",
              "      <th>Reactions</th>\n",
              "      <th>Balance</th>\n",
              "      <th>ShotPower</th>\n",
              "      <th>Jumping</th>\n",
              "      <th>Stamina</th>\n",
              "      <th>Strength</th>\n",
              "      <th>LongShots</th>\n",
              "      <th>Aggression</th>\n",
              "      <th>Interceptions</th>\n",
              "      <th>Positioning</th>\n",
              "      <th>Vision</th>\n",
              "      <th>Penalties</th>\n",
              "      <th>Composure</th>\n",
              "      <th>Marking</th>\n",
              "      <th>StandingTackle</th>\n",
              "      <th>SlidingTackle</th>\n",
              "      <th>GKDiving</th>\n",
              "      <th>GKHandling</th>\n",
              "      <th>GKKicking</th>\n",
              "      <th>GKPositioning</th>\n",
              "      <th>GKReflexes</th>\n",
              "      <th>Best Position</th>\n",
              "      <th>Best Overall Rating</th>\n",
              "      <th>FIFA Version</th>\n",
              "      <th>Release Clause</th>\n",
              "      <th>DefensiveAwareness</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>70570</th>\n",
              "      <td>20801.0</td>\n",
              "      <td>Cristiano Ronaldo</td>\n",
              "      <td>36.0</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>91.0</td>\n",
              "      <td>91.0</td>\n",
              "      <td>Manchester United</td>\n",
              "      <td>45000000.0</td>\n",
              "      <td>270000.0</td>\n",
              "      <td>2208.0</td>\n",
              "      <td>Right</td>\n",
              "      <td>5.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>High/ Low</td>\n",
              "      <td>Unique</td>\n",
              "      <td>Yes</td>\n",
              "      <td>ST</td>\n",
              "      <td>7.0</td>\n",
              "      <td>Aug 27, 2021</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023</td>\n",
              "      <td>187cm</td>\n",
              "      <td>83kg</td>\n",
              "      <td>87.0</td>\n",
              "      <td>95.0</td>\n",
              "      <td>90.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>94.0</td>\n",
              "      <td>74.0</td>\n",
              "      <td>94.0</td>\n",
              "      <td>95.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>93.0</td>\n",
              "      <td>63.0</td>\n",
              "      <td>29.0</td>\n",
              "      <td>95.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>95.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>32.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>ST</td>\n",
              "      <td>91.0</td>\n",
              "      <td>FIFA22</td>\n",
              "      <td>83300000.0</td>\n",
              "      <td>24.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>104452</th>\n",
              "      <td>20801.0</td>\n",
              "      <td>Cristiano Ronaldo</td>\n",
              "      <td>37.0</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>90.0</td>\n",
              "      <td>90.0</td>\n",
              "      <td>Manchester United</td>\n",
              "      <td>41000000.0</td>\n",
              "      <td>220000.0</td>\n",
              "      <td>2159.0</td>\n",
              "      <td>Right</td>\n",
              "      <td>5.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>High/ Low</td>\n",
              "      <td>Unique</td>\n",
              "      <td>Yes</td>\n",
              "      <td>ST</td>\n",
              "      <td>7.0</td>\n",
              "      <td>Aug 27, 2021</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023</td>\n",
              "      <td>187cm</td>\n",
              "      <td>83kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>77900000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-69bf7c0a-c0ef-4fe0-a899-f7e70b0c3c7e')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-2ee28937-b110-4ecc-aa16-e0fd45b4e4d9\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-2ee28937-b110-4ecc-aa16-e0fd45b4e4d9')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-2ee28937-b110-4ecc-aa16-e0fd45b4e4d9 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-69bf7c0a-c0ef-4fe0-a899-f7e70b0c3c7e 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-69bf7c0a-c0ef-4fe0-a899-f7e70b0c3c7e');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 56
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat.tail()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 392
        },
        "id": "TRDJ11pNtlm_",
        "outputId": "a0967d5c-b9a4-4c92-f551-494f63cdd50b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "            ID             Name  Age  \\\n",
              "122007  269526    Deng Xiongtao   19   \n",
              "122008  267946   22 Lim Jun Sub   17   \n",
              "122009  270567         A. Demir   25   \n",
              "122010  256624     21 S. Czajor   18   \n",
              "122011  256376  21 F. Jakobsson   20   \n",
              "\n",
              "                                                   Photo     Nationality  \\\n",
              "122007  https://cdn.sofifa.net/players/269/526/23_60.png        China PR   \n",
              "122008  https://cdn.sofifa.net/players/267/946/22_60.png  Korea Republic   \n",
              "122009  https://cdn.sofifa.net/players/270/567/23_60.png          Turkey   \n",
              "122010  https://cdn.sofifa.net/players/256/624/21_60.png          Poland   \n",
              "122011  https://cdn.sofifa.net/players/256/376/21_60.png          Sweden   \n",
              "\n",
              "                                       Flag  Overall  Potential  \\\n",
              "122007  https://cdn.sofifa.net/flags/cn.png       48         61   \n",
              "122008  https://cdn.sofifa.net/flags/kr.png       48         64   \n",
              "122009  https://cdn.sofifa.net/flags/tr.png       51         56   \n",
              "122010  https://cdn.sofifa.net/flags/pl.png       50         65   \n",
              "122011  https://cdn.sofifa.net/flags/se.png       50         61   \n",
              "\n",
              "                  Club                                   Club Logo     Value  \\\n",
              "122007   Meizhou Hakka  https://cdn.sofifa.net/teams/114628/30.png  100000.0   \n",
              "122008  Jeju United FC    https://cdn.sofifa.net/teams/1478/30.png  100000.0   \n",
              "122009    Ümraniyespor  https://cdn.sofifa.net/teams/113796/30.png   70000.0   \n",
              "122010  Fleetwood Town  https://cdn.sofifa.net/teams/112260/30.png   90000.0   \n",
              "122011  IFK Norrköping     https://cdn.sofifa.net/teams/702/30.png   90000.0   \n",
              "\n",
              "          Wage  Special Preferred Foot  International Reputation  Weak Foot  \\\n",
              "122007   500.0      762          Right                       1.0        3.0   \n",
              "122008   500.0      761          Right                       1.0        2.0   \n",
              "122009  2000.0      759          Right                       1.0        2.0   \n",
              "122010   500.0      758          Right                       1.0        2.0   \n",
              "122011   500.0      749           Left                       1.0        2.0   \n",
              "\n",
              "        Skill Moves       Work Rate      Body Type Real Face Position  \\\n",
              "122007          1.0  Medium/ Medium  Normal (185+)        No      RES   \n",
              "122008          1.0  Medium/ Medium    Lean (185+)        No      RES   \n",
              "122009          1.0  Medium/ Medium    Lean (185+)        No      RES   \n",
              "122010          1.0  Medium/ Medium  Normal (185+)        No      RES   \n",
              "122011          1.0  Medium/ Medium  Normal (185+)        No      RES   \n",
              "\n",
              "        Jersey Number        Joined Loaned From Contract Valid Until Height  \\\n",
              "122007           35.0  Apr 11, 2022         NaN                 2027  190cm   \n",
              "122008           21.0   Jan 1, 2022         NaN                 2026  195cm   \n",
              "122009           12.0   Jun 6, 2021         NaN                 2023  190cm   \n",
              "122010           40.0   Jan 1, 2020         NaN                 2021  187cm   \n",
              "122011           30.0   Jan 8, 2020         NaN                 2021  186cm   \n",
              "\n",
              "       Weight  Crossing  Finishing  HeadingAccuracy  ShortPassing  Volleys  \\\n",
              "122007   78kg       NaN        NaN              NaN           NaN      NaN   \n",
              "122008   84kg       NaN        NaN              NaN           NaN      NaN   \n",
              "122009   82kg       NaN        NaN              NaN           NaN      NaN   \n",
              "122010   79kg       NaN        NaN              NaN           NaN      NaN   \n",
              "122011   78kg       NaN        NaN              NaN           NaN      NaN   \n",
              "\n",
              "        Dribbling  Curve  FKAccuracy  LongPassing  BallControl  Acceleration  \\\n",
              "122007        NaN    NaN         NaN          NaN          NaN           NaN   \n",
              "122008        NaN    NaN         NaN          NaN          NaN           NaN   \n",
              "122009        NaN    NaN         NaN          NaN          NaN           NaN   \n",
              "122010        NaN    NaN         NaN          NaN          NaN           NaN   \n",
              "122011        NaN    NaN         NaN          NaN          NaN           NaN   \n",
              "\n",
              "        SprintSpeed  Agility  Reactions  Balance  ShotPower  Jumping  Stamina  \\\n",
              "122007          NaN      NaN        NaN      NaN        NaN      NaN      NaN   \n",
              "122008          NaN      NaN        NaN      NaN        NaN      NaN      NaN   \n",
              "122009          NaN      NaN        NaN      NaN        NaN      NaN      NaN   \n",
              "122010          NaN      NaN        NaN      NaN        NaN      NaN      NaN   \n",
              "122011          NaN      NaN        NaN      NaN        NaN      NaN      NaN   \n",
              "\n",
              "        Strength  LongShots  Aggression  Interceptions  Positioning  Vision  \\\n",
              "122007       NaN        NaN         NaN            NaN          NaN     NaN   \n",
              "122008       NaN        NaN         NaN            NaN          NaN     NaN   \n",
              "122009       NaN        NaN         NaN            NaN          NaN     NaN   \n",
              "122010       NaN        NaN         NaN            NaN          NaN     NaN   \n",
              "122011       NaN        NaN         NaN            NaN          NaN     NaN   \n",
              "\n",
              "        Penalties  Composure  Marking  StandingTackle  SlidingTackle  \\\n",
              "122007        NaN        NaN      NaN             NaN            NaN   \n",
              "122008        NaN        NaN      NaN             NaN            NaN   \n",
              "122009        NaN        NaN      NaN             NaN            NaN   \n",
              "122010        NaN        NaN      NaN             NaN            NaN   \n",
              "122011        NaN        NaN      NaN             NaN            NaN   \n",
              "\n",
              "        GKDiving  GKHandling  GKKicking  GKPositioning  GKReflexes  \\\n",
              "122007       NaN         NaN        NaN            NaN         NaN   \n",
              "122008       NaN         NaN        NaN            NaN         NaN   \n",
              "122009       NaN         NaN        NaN            NaN         NaN   \n",
              "122010       NaN         NaN        NaN            NaN         NaN   \n",
              "122011       NaN         NaN        NaN            NaN         NaN   \n",
              "\n",
              "       Best Position Best Overall Rating FIFA Version  Release Clause  \\\n",
              "122007           NaN                 NaN       FIFA23        218000.0   \n",
              "122008           NaN                 NaN       FIFA23        188000.0   \n",
              "122009           NaN                 NaN       FIFA23        142000.0   \n",
              "122010           NaN                 NaN       FIFA23        214000.0   \n",
              "122011           NaN                 NaN       FIFA23        131000.0   \n",
              "\n",
              "        DefensiveAwareness  \n",
              "122007                 NaN  \n",
              "122008                 NaN  \n",
              "122009                 NaN  \n",
              "122010                 NaN  \n",
              "122011                 NaN  "
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-f9349f36-695b-4444-bc4f-87bc59defce8\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>ID</th>\n",
              "      <th>Name</th>\n",
              "      <th>Age</th>\n",
              "      <th>Photo</th>\n",
              "      <th>Nationality</th>\n",
              "      <th>Flag</th>\n",
              "      <th>Overall</th>\n",
              "      <th>Potential</th>\n",
              "      <th>Club</th>\n",
              "      <th>Club Logo</th>\n",
              "      <th>Value</th>\n",
              "      <th>Wage</th>\n",
              "      <th>Special</th>\n",
              "      <th>Preferred Foot</th>\n",
              "      <th>International Reputation</th>\n",
              "      <th>Weak Foot</th>\n",
              "      <th>Skill Moves</th>\n",
              "      <th>Work Rate</th>\n",
              "      <th>Body Type</th>\n",
              "      <th>Real Face</th>\n",
              "      <th>Position</th>\n",
              "      <th>Jersey Number</th>\n",
              "      <th>Joined</th>\n",
              "      <th>Loaned From</th>\n",
              "      <th>Contract Valid Until</th>\n",
              "      <th>Height</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Crossing</th>\n",
              "      <th>Finishing</th>\n",
              "      <th>HeadingAccuracy</th>\n",
              "      <th>ShortPassing</th>\n",
              "      <th>Volleys</th>\n",
              "      <th>Dribbling</th>\n",
              "      <th>Curve</th>\n",
              "      <th>FKAccuracy</th>\n",
              "      <th>LongPassing</th>\n",
              "      <th>BallControl</th>\n",
              "      <th>Acceleration</th>\n",
              "      <th>SprintSpeed</th>\n",
              "      <th>Agility</th>\n",
              "      <th>Reactions</th>\n",
              "      <th>Balance</th>\n",
              "      <th>ShotPower</th>\n",
              "      <th>Jumping</th>\n",
              "      <th>Stamina</th>\n",
              "      <th>Strength</th>\n",
              "      <th>LongShots</th>\n",
              "      <th>Aggression</th>\n",
              "      <th>Interceptions</th>\n",
              "      <th>Positioning</th>\n",
              "      <th>Vision</th>\n",
              "      <th>Penalties</th>\n",
              "      <th>Composure</th>\n",
              "      <th>Marking</th>\n",
              "      <th>StandingTackle</th>\n",
              "      <th>SlidingTackle</th>\n",
              "      <th>GKDiving</th>\n",
              "      <th>GKHandling</th>\n",
              "      <th>GKKicking</th>\n",
              "      <th>GKPositioning</th>\n",
              "      <th>GKReflexes</th>\n",
              "      <th>Best Position</th>\n",
              "      <th>Best Overall Rating</th>\n",
              "      <th>FIFA Version</th>\n",
              "      <th>Release Clause</th>\n",
              "      <th>DefensiveAwareness</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>122007</th>\n",
              "      <td>269526</td>\n",
              "      <td>Deng Xiongtao</td>\n",
              "      <td>19</td>\n",
              "      <td>https://cdn.sofifa.net/players/269/526/23_60.png</td>\n",
              "      <td>China PR</td>\n",
              "      <td>https://cdn.sofifa.net/flags/cn.png</td>\n",
              "      <td>48</td>\n",
              "      <td>61</td>\n",
              "      <td>Meizhou Hakka</td>\n",
              "      <td>https://cdn.sofifa.net/teams/114628/30.png</td>\n",
              "      <td>100000.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>762</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Normal (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>RES</td>\n",
              "      <td>35.0</td>\n",
              "      <td>Apr 11, 2022</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2027</td>\n",
              "      <td>190cm</td>\n",
              "      <td>78kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>218000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122008</th>\n",
              "      <td>267946</td>\n",
              "      <td>22 Lim Jun Sub</td>\n",
              "      <td>17</td>\n",
              "      <td>https://cdn.sofifa.net/players/267/946/22_60.png</td>\n",
              "      <td>Korea Republic</td>\n",
              "      <td>https://cdn.sofifa.net/flags/kr.png</td>\n",
              "      <td>48</td>\n",
              "      <td>64</td>\n",
              "      <td>Jeju United FC</td>\n",
              "      <td>https://cdn.sofifa.net/teams/1478/30.png</td>\n",
              "      <td>100000.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>761</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Lean (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>RES</td>\n",
              "      <td>21.0</td>\n",
              "      <td>Jan 1, 2022</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2026</td>\n",
              "      <td>195cm</td>\n",
              "      <td>84kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>188000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122009</th>\n",
              "      <td>270567</td>\n",
              "      <td>A. Demir</td>\n",
              "      <td>25</td>\n",
              "      <td>https://cdn.sofifa.net/players/270/567/23_60.png</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>https://cdn.sofifa.net/flags/tr.png</td>\n",
              "      <td>51</td>\n",
              "      <td>56</td>\n",
              "      <td>Ümraniyespor</td>\n",
              "      <td>https://cdn.sofifa.net/teams/113796/30.png</td>\n",
              "      <td>70000.0</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>759</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Lean (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>RES</td>\n",
              "      <td>12.0</td>\n",
              "      <td>Jun 6, 2021</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023</td>\n",
              "      <td>190cm</td>\n",
              "      <td>82kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>142000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122010</th>\n",
              "      <td>256624</td>\n",
              "      <td>21 S. Czajor</td>\n",
              "      <td>18</td>\n",
              "      <td>https://cdn.sofifa.net/players/256/624/21_60.png</td>\n",
              "      <td>Poland</td>\n",
              "      <td>https://cdn.sofifa.net/flags/pl.png</td>\n",
              "      <td>50</td>\n",
              "      <td>65</td>\n",
              "      <td>Fleetwood Town</td>\n",
              "      <td>https://cdn.sofifa.net/teams/112260/30.png</td>\n",
              "      <td>90000.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>758</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Normal (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>RES</td>\n",
              "      <td>40.0</td>\n",
              "      <td>Jan 1, 2020</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021</td>\n",
              "      <td>187cm</td>\n",
              "      <td>79kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>214000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122011</th>\n",
              "      <td>256376</td>\n",
              "      <td>21 F. Jakobsson</td>\n",
              "      <td>20</td>\n",
              "      <td>https://cdn.sofifa.net/players/256/376/21_60.png</td>\n",
              "      <td>Sweden</td>\n",
              "      <td>https://cdn.sofifa.net/flags/se.png</td>\n",
              "      <td>50</td>\n",
              "      <td>61</td>\n",
              "      <td>IFK Norrköping</td>\n",
              "      <td>https://cdn.sofifa.net/teams/702/30.png</td>\n",
              "      <td>90000.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>749</td>\n",
              "      <td>Left</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Normal (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>RES</td>\n",
              "      <td>30.0</td>\n",
              "      <td>Jan 8, 2020</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021</td>\n",
              "      <td>186cm</td>\n",
              "      <td>78kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>131000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f9349f36-695b-4444-bc4f-87bc59defce8')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-e92da28f-697c-43f1-a812-b9feed243c4a\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-e92da28f-697c-43f1-a812-b9feed243c4a')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-e92da28f-697c-43f1-a812-b9feed243c4a button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-f9349f36-695b-4444-bc4f-87bc59defce8 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-f9349f36-695b-4444-bc4f-87bc59defce8');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 33
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat = data_concat.drop(['Photo', 'Flag', 'Club Logo'], axis=1)"
      ],
      "metadata": {
        "id": "qfCAKgyeSQIO"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 765
        },
        "id": "JtLFVJde2igV",
        "outputId": "828d9d8d-7570-45f9-abdb-9e8fe0e7fc74"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "            ID             Name  Age     Nationality  Overall  Potential  \\\n",
              "0       176580        L. Suárez   29         Uruguay       92         92   \n",
              "1       178518    R. Nainggolan   28         Belgium       86         86   \n",
              "2       181872         A. Vidal   29           Chile       87         87   \n",
              "3       197445         D. Alaba   24         Austria       86         89   \n",
              "4       195864         P. Pogba   23          France       88         94   \n",
              "...        ...              ...  ...             ...      ...        ...   \n",
              "122007  269526    Deng Xiongtao   19        China PR       48         61   \n",
              "122008  267946   22 Lim Jun Sub   17  Korea Republic       48         64   \n",
              "122009  270567         A. Demir   25          Turkey       51         56   \n",
              "122010  256624     21 S. Czajor   18          Poland       50         65   \n",
              "122011  256376  21 F. Jakobsson   20          Sweden       50         61   \n",
              "\n",
              "                     Club       Value      Wage  Special Preferred Foot  \\\n",
              "0            FC Barcelona  83000000.0  525000.0     2291          Right   \n",
              "1                    Roma  37500000.0  130000.0     2290          Right   \n",
              "2       FC Bayern München  41500000.0  180000.0     2285          Right   \n",
              "3       FC Bayern München  41500000.0  140000.0     2279           Left   \n",
              "4       Manchester United  71500000.0  225000.0     2271          Right   \n",
              "...                   ...         ...       ...      ...            ...   \n",
              "122007      Meizhou Hakka    100000.0     500.0      762          Right   \n",
              "122008     Jeju United FC    100000.0     500.0      761          Right   \n",
              "122009       Ümraniyespor     70000.0    2000.0      759          Right   \n",
              "122010     Fleetwood Town     90000.0     500.0      758          Right   \n",
              "122011     IFK Norrköping     90000.0     500.0      749           Left   \n",
              "\n",
              "        International Reputation  Weak Foot  Skill Moves       Work Rate  \\\n",
              "0                            5.0        4.0          4.0    High/ Medium   \n",
              "1                            3.0        3.0          3.0      High/ High   \n",
              "2                            4.0        4.0          3.0      High/ High   \n",
              "3                            4.0        4.0          3.0    High/ Medium   \n",
              "4                            4.0        4.0          5.0    High/ Medium   \n",
              "...                          ...        ...          ...             ...   \n",
              "122007                       1.0        3.0          1.0  Medium/ Medium   \n",
              "122008                       1.0        2.0          1.0  Medium/ Medium   \n",
              "122009                       1.0        2.0          1.0  Medium/ Medium   \n",
              "122010                       1.0        2.0          1.0  Medium/ Medium   \n",
              "122011                       1.0        2.0          1.0  Medium/ Medium   \n",
              "\n",
              "               Body Type Real Face Position  Jersey Number        Joined  \\\n",
              "0       Normal (170-185)       Yes       ST            9.0  Jul 11, 2014   \n",
              "1       Stocky (170-185)        No       LF            4.0   Jan 7, 2014   \n",
              "2       Normal (170-185)       Yes      LDM           23.0  Jul 28, 2015   \n",
              "3         Lean (170-185)       Yes       LB           27.0  Feb 10, 2010   \n",
              "4            Lean (185+)       Yes      LDM            6.0   Aug 9, 2016   \n",
              "...                  ...       ...      ...            ...           ...   \n",
              "122007     Normal (185+)        No      RES           35.0  Apr 11, 2022   \n",
              "122008       Lean (185+)        No      RES           21.0   Jan 1, 2022   \n",
              "122009       Lean (185+)        No      RES           12.0   Jun 6, 2021   \n",
              "122010     Normal (185+)        No      RES           40.0   Jan 1, 2020   \n",
              "122011     Normal (185+)        No      RES           30.0   Jan 8, 2020   \n",
              "\n",
              "       Loaned From Contract Valid Until Height  Weight  Crossing  Finishing  \\\n",
              "0              NaN                 2021    6'0  190lbs      77.0       94.0   \n",
              "1              NaN                 2021    5'9  143lbs      73.0       76.0   \n",
              "2              NaN                 2019   5'11  165lbs      76.0       77.0   \n",
              "3              NaN                 2021   5'11  168lbs      82.0       63.0   \n",
              "4              NaN                 2021    6'3  185lbs      78.0       71.0   \n",
              "...            ...                  ...    ...     ...       ...        ...   \n",
              "122007         NaN                 2027  190cm    78kg       NaN        NaN   \n",
              "122008         NaN                 2026  195cm    84kg       NaN        NaN   \n",
              "122009         NaN                 2023  190cm    82kg       NaN        NaN   \n",
              "122010         NaN                 2021  187cm    79kg       NaN        NaN   \n",
              "122011         NaN                 2021  186cm    78kg       NaN        NaN   \n",
              "\n",
              "        HeadingAccuracy  ShortPassing  Volleys  Dribbling  Curve  FKAccuracy  \\\n",
              "0                  77.0          83.0     88.0       86.0   86.0        84.0   \n",
              "1                  59.0          84.0     75.0       80.0   73.0        68.0   \n",
              "2                  81.0          84.0     78.0       76.0   76.0        68.0   \n",
              "3                  75.0          83.0     68.0       79.0   78.0        83.0   \n",
              "4                  73.0          85.0     84.0       89.0   84.0        82.0   \n",
              "...                 ...           ...      ...        ...    ...         ...   \n",
              "122007              NaN           NaN      NaN        NaN    NaN         NaN   \n",
              "122008              NaN           NaN      NaN        NaN    NaN         NaN   \n",
              "122009              NaN           NaN      NaN        NaN    NaN         NaN   \n",
              "122010              NaN           NaN      NaN        NaN    NaN         NaN   \n",
              "122011              NaN           NaN      NaN        NaN    NaN         NaN   \n",
              "\n",
              "        LongPassing  BallControl  Acceleration  SprintSpeed  Agility  \\\n",
              "0              64.0         91.0          88.0         77.0     86.0   \n",
              "1              81.0         85.0          81.0         78.0     81.0   \n",
              "2              82.0         83.0          77.0         74.0     75.0   \n",
              "3              80.0         83.0          86.0         86.0     82.0   \n",
              "4              88.0         90.0          75.0         79.0     79.0   \n",
              "...             ...          ...           ...          ...      ...   \n",
              "122007          NaN          NaN           NaN          NaN      NaN   \n",
              "122008          NaN          NaN           NaN          NaN      NaN   \n",
              "122009          NaN          NaN           NaN          NaN      NaN   \n",
              "122010          NaN          NaN           NaN          NaN      NaN   \n",
              "122011          NaN          NaN           NaN          NaN      NaN   \n",
              "\n",
              "        Reactions  Balance  ShotPower  Jumping  Stamina  Strength  LongShots  \\\n",
              "0            93.0     60.0       87.0     69.0     89.0      80.0       86.0   \n",
              "1            87.0     84.0       84.0     76.0     94.0      78.0       86.0   \n",
              "2            89.0     77.0       84.0     82.0     93.0      79.0       85.0   \n",
              "3            84.0     77.0       83.0     82.0     87.0      69.0       83.0   \n",
              "4            86.0     61.0       90.0     85.0     91.0      91.0       87.0   \n",
              "...           ...      ...        ...      ...      ...       ...        ...   \n",
              "122007        NaN      NaN        NaN      NaN      NaN       NaN        NaN   \n",
              "122008        NaN      NaN        NaN      NaN      NaN       NaN        NaN   \n",
              "122009        NaN      NaN        NaN      NaN      NaN       NaN        NaN   \n",
              "122010        NaN      NaN        NaN      NaN      NaN       NaN        NaN   \n",
              "122011        NaN      NaN        NaN      NaN      NaN       NaN        NaN   \n",
              "\n",
              "        Aggression  Interceptions  Positioning  Vision  Penalties  Composure  \\\n",
              "0             78.0           41.0         92.0    84.0       85.0       83.0   \n",
              "1             88.0           86.0         88.0    76.0       63.0       85.0   \n",
              "2             91.0           89.0         80.0    80.0       84.0       86.0   \n",
              "3             69.0           85.0         77.0    78.0       80.0       79.0   \n",
              "4             72.0           70.0         84.0    87.0       76.0       83.0   \n",
              "...            ...            ...          ...     ...        ...        ...   \n",
              "122007         NaN            NaN          NaN     NaN        NaN        NaN   \n",
              "122008         NaN            NaN          NaN     NaN        NaN        NaN   \n",
              "122009         NaN            NaN          NaN     NaN        NaN        NaN   \n",
              "122010         NaN            NaN          NaN     NaN        NaN        NaN   \n",
              "122011         NaN            NaN          NaN     NaN        NaN        NaN   \n",
              "\n",
              "        Marking  StandingTackle  SlidingTackle  GKDiving  GKHandling  \\\n",
              "0          30.0            45.0           38.0      27.0        25.0   \n",
              "1          78.0            85.0           88.0      11.0        11.0   \n",
              "2          76.0            89.0           84.0       4.0         2.0   \n",
              "3          81.0            83.0           83.0       5.0         7.0   \n",
              "4          68.0            73.0           73.0       5.0         6.0   \n",
              "...         ...             ...            ...       ...         ...   \n",
              "122007      NaN             NaN            NaN       NaN         NaN   \n",
              "122008      NaN             NaN            NaN       NaN         NaN   \n",
              "122009      NaN             NaN            NaN       NaN         NaN   \n",
              "122010      NaN             NaN            NaN       NaN         NaN   \n",
              "122011      NaN             NaN            NaN       NaN         NaN   \n",
              "\n",
              "        GKKicking  GKPositioning  GKReflexes Best Position  \\\n",
              "0            31.0           33.0        37.0            ST   \n",
              "1            14.0            8.0        11.0           CDM   \n",
              "2             4.0            2.0         4.0           CDM   \n",
              "3            14.0           15.0         9.0            LB   \n",
              "4             2.0            4.0         3.0           CAM   \n",
              "...           ...            ...         ...           ...   \n",
              "122007        NaN            NaN         NaN           NaN   \n",
              "122008        NaN            NaN         NaN           NaN   \n",
              "122009        NaN            NaN         NaN           NaN   \n",
              "122010        NaN            NaN         NaN           NaN   \n",
              "122011        NaN            NaN         NaN           NaN   \n",
              "\n",
              "       Best Overall Rating FIFA Version  Release Clause  DefensiveAwareness  \n",
              "0                     88.0       FIFA17             NaN                 NaN  \n",
              "1                     84.0       FIFA17             NaN                 NaN  \n",
              "2                     85.0       FIFA17             NaN                 NaN  \n",
              "3                     84.0       FIFA17             NaN                 NaN  \n",
              "4                     85.0       FIFA17             NaN                 NaN  \n",
              "...                    ...          ...             ...                 ...  \n",
              "122007                 NaN       FIFA23        218000.0                 NaN  \n",
              "122008                 NaN       FIFA23        188000.0                 NaN  \n",
              "122009                 NaN       FIFA23        142000.0                 NaN  \n",
              "122010                 NaN       FIFA23        214000.0                 NaN  \n",
              "122011                 NaN       FIFA23        131000.0                 NaN  \n",
              "\n",
              "[122012 rows x 63 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-81f09b61-efed-4a90-a1e8-3481abf90423\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>ID</th>\n",
              "      <th>Name</th>\n",
              "      <th>Age</th>\n",
              "      <th>Nationality</th>\n",
              "      <th>Overall</th>\n",
              "      <th>Potential</th>\n",
              "      <th>Club</th>\n",
              "      <th>Value</th>\n",
              "      <th>Wage</th>\n",
              "      <th>Special</th>\n",
              "      <th>Preferred Foot</th>\n",
              "      <th>International Reputation</th>\n",
              "      <th>Weak Foot</th>\n",
              "      <th>Skill Moves</th>\n",
              "      <th>Work Rate</th>\n",
              "      <th>Body Type</th>\n",
              "      <th>Real Face</th>\n",
              "      <th>Position</th>\n",
              "      <th>Jersey Number</th>\n",
              "      <th>Joined</th>\n",
              "      <th>Loaned From</th>\n",
              "      <th>Contract Valid Until</th>\n",
              "      <th>Height</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Crossing</th>\n",
              "      <th>Finishing</th>\n",
              "      <th>HeadingAccuracy</th>\n",
              "      <th>ShortPassing</th>\n",
              "      <th>Volleys</th>\n",
              "      <th>Dribbling</th>\n",
              "      <th>Curve</th>\n",
              "      <th>FKAccuracy</th>\n",
              "      <th>LongPassing</th>\n",
              "      <th>BallControl</th>\n",
              "      <th>Acceleration</th>\n",
              "      <th>SprintSpeed</th>\n",
              "      <th>Agility</th>\n",
              "      <th>Reactions</th>\n",
              "      <th>Balance</th>\n",
              "      <th>ShotPower</th>\n",
              "      <th>Jumping</th>\n",
              "      <th>Stamina</th>\n",
              "      <th>Strength</th>\n",
              "      <th>LongShots</th>\n",
              "      <th>Aggression</th>\n",
              "      <th>Interceptions</th>\n",
              "      <th>Positioning</th>\n",
              "      <th>Vision</th>\n",
              "      <th>Penalties</th>\n",
              "      <th>Composure</th>\n",
              "      <th>Marking</th>\n",
              "      <th>StandingTackle</th>\n",
              "      <th>SlidingTackle</th>\n",
              "      <th>GKDiving</th>\n",
              "      <th>GKHandling</th>\n",
              "      <th>GKKicking</th>\n",
              "      <th>GKPositioning</th>\n",
              "      <th>GKReflexes</th>\n",
              "      <th>Best Position</th>\n",
              "      <th>Best Overall Rating</th>\n",
              "      <th>FIFA Version</th>\n",
              "      <th>Release Clause</th>\n",
              "      <th>DefensiveAwareness</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>176580</td>\n",
              "      <td>L. Suárez</td>\n",
              "      <td>29</td>\n",
              "      <td>Uruguay</td>\n",
              "      <td>92</td>\n",
              "      <td>92</td>\n",
              "      <td>FC Barcelona</td>\n",
              "      <td>83000000.0</td>\n",
              "      <td>525000.0</td>\n",
              "      <td>2291</td>\n",
              "      <td>Right</td>\n",
              "      <td>5.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>High/ Medium</td>\n",
              "      <td>Normal (170-185)</td>\n",
              "      <td>Yes</td>\n",
              "      <td>ST</td>\n",
              "      <td>9.0</td>\n",
              "      <td>Jul 11, 2014</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021</td>\n",
              "      <td>6'0</td>\n",
              "      <td>190lbs</td>\n",
              "      <td>77.0</td>\n",
              "      <td>94.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>64.0</td>\n",
              "      <td>91.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>93.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>87.0</td>\n",
              "      <td>69.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>41.0</td>\n",
              "      <td>92.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>45.0</td>\n",
              "      <td>38.0</td>\n",
              "      <td>27.0</td>\n",
              "      <td>25.0</td>\n",
              "      <td>31.0</td>\n",
              "      <td>33.0</td>\n",
              "      <td>37.0</td>\n",
              "      <td>ST</td>\n",
              "      <td>88.0</td>\n",
              "      <td>FIFA17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>178518</td>\n",
              "      <td>R. Nainggolan</td>\n",
              "      <td>28</td>\n",
              "      <td>Belgium</td>\n",
              "      <td>86</td>\n",
              "      <td>86</td>\n",
              "      <td>Roma</td>\n",
              "      <td>37500000.0</td>\n",
              "      <td>130000.0</td>\n",
              "      <td>2290</td>\n",
              "      <td>Right</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>High/ High</td>\n",
              "      <td>Stocky (170-185)</td>\n",
              "      <td>No</td>\n",
              "      <td>LF</td>\n",
              "      <td>4.0</td>\n",
              "      <td>Jan 7, 2014</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021</td>\n",
              "      <td>5'9</td>\n",
              "      <td>143lbs</td>\n",
              "      <td>73.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>59.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>73.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>87.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>94.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>63.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>CDM</td>\n",
              "      <td>84.0</td>\n",
              "      <td>FIFA17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>181872</td>\n",
              "      <td>A. Vidal</td>\n",
              "      <td>29</td>\n",
              "      <td>Chile</td>\n",
              "      <td>87</td>\n",
              "      <td>87</td>\n",
              "      <td>FC Bayern München</td>\n",
              "      <td>41500000.0</td>\n",
              "      <td>180000.0</td>\n",
              "      <td>2285</td>\n",
              "      <td>Right</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>High/ High</td>\n",
              "      <td>Normal (170-185)</td>\n",
              "      <td>Yes</td>\n",
              "      <td>LDM</td>\n",
              "      <td>23.0</td>\n",
              "      <td>Jul 28, 2015</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2019</td>\n",
              "      <td>5'11</td>\n",
              "      <td>165lbs</td>\n",
              "      <td>76.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>74.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>93.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>91.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>CDM</td>\n",
              "      <td>85.0</td>\n",
              "      <td>FIFA17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>197445</td>\n",
              "      <td>D. Alaba</td>\n",
              "      <td>24</td>\n",
              "      <td>Austria</td>\n",
              "      <td>86</td>\n",
              "      <td>89</td>\n",
              "      <td>FC Bayern München</td>\n",
              "      <td>41500000.0</td>\n",
              "      <td>140000.0</td>\n",
              "      <td>2279</td>\n",
              "      <td>Left</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>High/ Medium</td>\n",
              "      <td>Lean (170-185)</td>\n",
              "      <td>Yes</td>\n",
              "      <td>LB</td>\n",
              "      <td>27.0</td>\n",
              "      <td>Feb 10, 2010</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021</td>\n",
              "      <td>5'11</td>\n",
              "      <td>168lbs</td>\n",
              "      <td>82.0</td>\n",
              "      <td>63.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>87.0</td>\n",
              "      <td>69.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>69.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>LB</td>\n",
              "      <td>84.0</td>\n",
              "      <td>FIFA17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>195864</td>\n",
              "      <td>P. Pogba</td>\n",
              "      <td>23</td>\n",
              "      <td>France</td>\n",
              "      <td>88</td>\n",
              "      <td>94</td>\n",
              "      <td>Manchester United</td>\n",
              "      <td>71500000.0</td>\n",
              "      <td>225000.0</td>\n",
              "      <td>2271</td>\n",
              "      <td>Right</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>High/ Medium</td>\n",
              "      <td>Lean (185+)</td>\n",
              "      <td>Yes</td>\n",
              "      <td>LDM</td>\n",
              "      <td>6.0</td>\n",
              "      <td>Aug 9, 2016</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021</td>\n",
              "      <td>6'3</td>\n",
              "      <td>185lbs</td>\n",
              "      <td>78.0</td>\n",
              "      <td>71.0</td>\n",
              "      <td>73.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>90.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>61.0</td>\n",
              "      <td>90.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>91.0</td>\n",
              "      <td>91.0</td>\n",
              "      <td>87.0</td>\n",
              "      <td>72.0</td>\n",
              "      <td>70.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>87.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>73.0</td>\n",
              "      <td>73.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>CAM</td>\n",
              "      <td>85.0</td>\n",
              "      <td>FIFA17</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",
              "      <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",
              "      <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>122007</th>\n",
              "      <td>269526</td>\n",
              "      <td>Deng Xiongtao</td>\n",
              "      <td>19</td>\n",
              "      <td>China PR</td>\n",
              "      <td>48</td>\n",
              "      <td>61</td>\n",
              "      <td>Meizhou Hakka</td>\n",
              "      <td>100000.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>762</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Normal (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>RES</td>\n",
              "      <td>35.0</td>\n",
              "      <td>Apr 11, 2022</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2027</td>\n",
              "      <td>190cm</td>\n",
              "      <td>78kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>218000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122008</th>\n",
              "      <td>267946</td>\n",
              "      <td>22 Lim Jun Sub</td>\n",
              "      <td>17</td>\n",
              "      <td>Korea Republic</td>\n",
              "      <td>48</td>\n",
              "      <td>64</td>\n",
              "      <td>Jeju United FC</td>\n",
              "      <td>100000.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>761</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Lean (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>RES</td>\n",
              "      <td>21.0</td>\n",
              "      <td>Jan 1, 2022</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2026</td>\n",
              "      <td>195cm</td>\n",
              "      <td>84kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>188000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122009</th>\n",
              "      <td>270567</td>\n",
              "      <td>A. Demir</td>\n",
              "      <td>25</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>51</td>\n",
              "      <td>56</td>\n",
              "      <td>Ümraniyespor</td>\n",
              "      <td>70000.0</td>\n",
              "      <td>2000.0</td>\n",
              "      <td>759</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Lean (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>RES</td>\n",
              "      <td>12.0</td>\n",
              "      <td>Jun 6, 2021</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023</td>\n",
              "      <td>190cm</td>\n",
              "      <td>82kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>142000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122010</th>\n",
              "      <td>256624</td>\n",
              "      <td>21 S. Czajor</td>\n",
              "      <td>18</td>\n",
              "      <td>Poland</td>\n",
              "      <td>50</td>\n",
              "      <td>65</td>\n",
              "      <td>Fleetwood Town</td>\n",
              "      <td>90000.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>758</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Normal (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>RES</td>\n",
              "      <td>40.0</td>\n",
              "      <td>Jan 1, 2020</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021</td>\n",
              "      <td>187cm</td>\n",
              "      <td>79kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>214000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122011</th>\n",
              "      <td>256376</td>\n",
              "      <td>21 F. Jakobsson</td>\n",
              "      <td>20</td>\n",
              "      <td>Sweden</td>\n",
              "      <td>50</td>\n",
              "      <td>61</td>\n",
              "      <td>IFK Norrköping</td>\n",
              "      <td>90000.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>749</td>\n",
              "      <td>Left</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Normal (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>RES</td>\n",
              "      <td>30.0</td>\n",
              "      <td>Jan 8, 2020</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2021</td>\n",
              "      <td>186cm</td>\n",
              "      <td>78kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>131000.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>122012 rows × 63 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-81f09b61-efed-4a90-a1e8-3481abf90423')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-25b9ff05-df5d-414e-95a6-259c6f5046c5\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-25b9ff05-df5d-414e-95a6-259c6f5046c5')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-25b9ff05-df5d-414e-95a6-259c6f5046c5 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-81f09b61-efed-4a90-a1e8-3481abf90423 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-81f09b61-efed-4a90-a1e8-3481abf90423');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 35
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat[['ID', 'Age', 'Overall', 'Potential', 'Value', 'Wage', 'Special', 'International Reputation',\n",
        "       'Skill Moves', 'Jersey Number', 'Crossing', 'Finishing', 'HeadingAccuracy']] = data_concat[['ID', 'Age', 'Overall', 'Potential', 'Value', 'Wage', 'Special', 'International Reputation',\n",
        "       'Skill Moves', 'Jersey Number', 'Crossing', 'Finishing', 'HeadingAccuracy']].astype(\"float\")"
      ],
      "metadata": {
        "id": "2kvJC7gBmY0S"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat[['ShortPassing', 'Volleys', 'Dribbling', 'Curve', 'FKAccuracy',\n",
        "       'LongPassing', 'BallControl', 'Acceleration', 'SprintSpeed', 'Agility',\n",
        "       'Reactions', 'Balance', 'ShotPower', 'Jumping', 'Stamina', 'Strength',\n",
        "       'LongShots', 'Aggression', 'Interceptions', 'Positioning']] = data_concat[['ShortPassing', 'Volleys', 'Dribbling', 'Curve', 'FKAccuracy',\n",
        "       'LongPassing', 'BallControl', 'Acceleration', 'SprintSpeed', 'Agility',\n",
        "       'Reactions', 'Balance', 'ShotPower', 'Jumping', 'Stamina', 'Strength',\n",
        "       'LongShots', 'Aggression', 'Interceptions', 'Positioning']].astype(\"float\")"
      ],
      "metadata": {
        "id": "3xc43S_XppO6"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat[['Vision',\n",
        "       'Penalties', 'Composure', 'Marking', 'StandingTackle', 'SlidingTackle',\n",
        "       'GKDiving', 'GKHandling', 'GKKicking', 'GKPositioning', 'GKReflexes']] = data_concat[['Vision',\n",
        "       'Penalties', 'Composure', 'Marking', 'StandingTackle', 'SlidingTackle',\n",
        "       'GKDiving', 'GKHandling', 'GKKicking', 'GKPositioning', 'GKReflexes',\n",
        "       ]].astype(\"float\")"
      ],
      "metadata": {
        "id": "cYDKlwszpz4p"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat[\"Best Overall Rating\"].dtypes"
      ],
      "metadata": {
        "id": "6-PbYKUCzovO",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "879878a1-ea87-446e-d97d-d760f06740bf"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "dtype('O')"
            ]
          },
          "metadata": {},
          "execution_count": 39
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data_concat[data_concat[\"Contract Valid Until\"].isna()]"
      ],
      "metadata": {
        "id": "IEs0-e17q0Bo",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 852
        },
        "outputId": "9585dacf-2524-421a-fcf6-a97777a363a9"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              ID            Name   Age           Nationality  Overall  \\\n",
              "28      184826.0    Adrien Silva  27.0              Portugal     83.0   \n",
              "37      187961.0        Paulinho  27.0                Brazil     81.0   \n",
              "43      197965.0           Pizzi  26.0              Portugal     82.0   \n",
              "70      178322.0        M. Layún  28.0                Mexico     79.0   \n",
              "74      177413.0       A. Witsel  27.0               Belgium     82.0   \n",
              "...          ...             ...   ...                   ...      ...   \n",
              "121143  253949.0      20 R. Goss  25.0          South Africa     61.0   \n",
              "121187  257550.0  22 I. Al Kaabi  28.0  United Arab Emirates     59.0   \n",
              "121320  267767.0       S. Kittos  20.0                Cyprus     58.0   \n",
              "121356  252359.0  21 E. Ira Tape  22.0         Côte d'Ivoire     61.0   \n",
              "121970  168933.0    07 I. Paskov  33.0              Bulgaria     43.0   \n",
              "\n",
              "        Potential         Club       Value     Wage  Special Preferred Foot  \\\n",
              "28           83.0  Sporting CP  23000000.0  20000.0   2179.0          Right   \n",
              "37           81.0          NaN         0.0      0.0   2168.0          Right   \n",
              "43           82.0   SL Benfica  20500000.0  20000.0   2166.0          Right   \n",
              "70           79.0     FC Porto   8000000.0  20000.0   2145.0          Right   \n",
              "74           82.0          NaN         0.0      0.0   2143.0          Right   \n",
              "...           ...          ...         ...      ...      ...            ...   \n",
              "121143       65.0          NaN         0.0      0.0    918.0          Right   \n",
              "121187       62.0          NaN         0.0      0.0    910.0          Right   \n",
              "121320       68.0          NaN         0.0      0.0    891.0          Right   \n",
              "121356       70.0          NaN         0.0      0.0    886.0          Right   \n",
              "121970       42.0          NaN         0.0      0.0    800.0          Right   \n",
              "\n",
              "        International Reputation  Weak Foot  Skill Moves       Work Rate  \\\n",
              "28                           2.0        4.0          3.0    Medium/ High   \n",
              "37                           3.0        3.0          3.0      High/ High   \n",
              "43                           2.0        4.0          4.0    High/ Medium   \n",
              "70                           3.0        5.0          3.0      High/ High   \n",
              "74                           3.0        3.0          4.0  Medium/ Medium   \n",
              "...                          ...        ...          ...             ...   \n",
              "121143                       1.0        3.0          1.0  Medium/ Medium   \n",
              "121187                       1.0        3.0          1.0  Medium/ Medium   \n",
              "121320                       1.0        2.0          1.0  Medium/ Medium   \n",
              "121356                       1.0        3.0          1.0  Medium/ Medium   \n",
              "121970                       1.0        3.0          1.0        N/A/ N/A   \n",
              "\n",
              "               Body Type Real Face Position  Jersey Number Joined Loaned From  \\\n",
              "28      Normal (170-185)        No      SUB           23.0    NaN         NaN   \n",
              "37      Normal (170-185)       Yes      RCM           15.0    NaN         NaN   \n",
              "43        Lean (170-185)        No      SUB           16.0    NaN         NaN   \n",
              "70      Normal (170-185)       Yes      LCM            7.0    NaN         NaN   \n",
              "74         Normal (185+)        No      LCM            6.0    NaN         NaN   \n",
              "...                  ...       ...      ...            ...    ...         ...   \n",
              "121143  Normal (170-185)        No      SUB           16.0    NaN         NaN   \n",
              "121187  Normal (170-185)        No      nan            NaN    NaN         NaN   \n",
              "121320       Lean (185+)        No      nan            NaN    NaN         NaN   \n",
              "121356     Normal (185+)        No      SUB            1.0    NaN         NaN   \n",
              "121970               NaN       NaN      SUB           24.0    NaN         NaN   \n",
              "\n",
              "       Contract Valid Until Height  Weight  Crossing  Finishing  \\\n",
              "28                      NaN    5'9  152lbs      78.0       71.0   \n",
              "37                      NaN   5'11  165lbs      64.0       72.0   \n",
              "43                      NaN    5'8  146lbs      75.0       78.0   \n",
              "70                      NaN   5'10  152lbs      82.0       67.0   \n",
              "74                      NaN    6'1  161lbs      69.0       71.0   \n",
              "...                     ...    ...     ...       ...        ...   \n",
              "121143                  NaN  181cm    75kg       NaN        NaN   \n",
              "121187                  NaN  183cm    82kg       NaN        NaN   \n",
              "121320                  NaN  186cm    75kg       NaN        NaN   \n",
              "121356                  NaN  192cm    85kg       NaN        NaN   \n",
              "121970                  NaN  184cm    79kg       NaN        NaN   \n",
              "\n",
              "        HeadingAccuracy  ShortPassing  Volleys  Dribbling  Curve  FKAccuracy  \\\n",
              "28                 61.0          83.0     78.0       82.0   77.0        78.0   \n",
              "37                 80.0          81.0     75.0       77.0   66.0        72.0   \n",
              "43                 45.0          82.0     77.0       83.0   85.0        76.0   \n",
              "70                 64.0          78.0     66.0       77.0   68.0        74.0   \n",
              "74                 77.0          83.0     67.0       83.0   69.0        68.0   \n",
              "...                 ...           ...      ...        ...    ...         ...   \n",
              "121143              NaN           NaN      NaN        NaN    NaN         NaN   \n",
              "121187              NaN           NaN      NaN        NaN    NaN         NaN   \n",
              "121320              NaN           NaN      NaN        NaN    NaN         NaN   \n",
              "121356              NaN           NaN      NaN        NaN    NaN         NaN   \n",
              "121970              NaN           NaN      NaN        NaN    NaN         NaN   \n",
              "\n",
              "        LongPassing  BallControl  Acceleration  SprintSpeed  Agility  \\\n",
              "28             84.0         85.0          64.0         65.0     73.0   \n",
              "37             76.0         81.0          76.0         76.0     70.0   \n",
              "43             80.0         82.0          83.0         76.0     85.0   \n",
              "70             74.0         78.0          78.0         82.0     78.0   \n",
              "74             78.0         85.0          67.0         74.0     82.0   \n",
              "...             ...          ...           ...          ...      ...   \n",
              "121143          NaN          NaN           NaN          NaN      NaN   \n",
              "121187          NaN          NaN           NaN          NaN      NaN   \n",
              "121320          NaN          NaN           NaN          NaN      NaN   \n",
              "121356          NaN          NaN           NaN          NaN      NaN   \n",
              "121970          NaN          NaN           NaN          NaN      NaN   \n",
              "\n",
              "        Reactions  Balance  ShotPower  Jumping  Stamina  Strength  LongShots  \\\n",
              "28           77.0     67.0       83.0     56.0     89.0      62.0       81.0   \n",
              "37           81.0     64.0       79.0     88.0     92.0      69.0       76.0   \n",
              "43           83.0     86.0       74.0     67.0     86.0      61.0       78.0   \n",
              "70           77.0     77.0       80.0     75.0     79.0      67.0       76.0   \n",
              "74           81.0     60.0       78.0     72.0     85.0      79.0       74.0   \n",
              "...           ...      ...        ...      ...      ...       ...        ...   \n",
              "121143        NaN      NaN        NaN      NaN      NaN       NaN        NaN   \n",
              "121187        NaN      NaN        NaN      NaN      NaN       NaN        NaN   \n",
              "121320        NaN      NaN        NaN      NaN      NaN       NaN        NaN   \n",
              "121356        NaN      NaN        NaN      NaN      NaN       NaN        NaN   \n",
              "121970        NaN      NaN        NaN      NaN      NaN       NaN        NaN   \n",
              "\n",
              "        Aggression  Interceptions  Positioning  Vision  Penalties  Composure  \\\n",
              "28            79.0           84.0         75.0    85.0       85.0       82.0   \n",
              "37            69.0           78.0         75.0    75.0       71.0       79.0   \n",
              "43            68.0           70.0         85.0    84.0       76.0       78.0   \n",
              "70            72.0           79.0         74.0    71.0       75.0       78.0   \n",
              "74            78.0           80.0         75.0    78.0       81.0       86.0   \n",
              "...            ...            ...          ...     ...        ...        ...   \n",
              "121143         NaN            NaN          NaN     NaN        NaN        NaN   \n",
              "121187         NaN            NaN          NaN     NaN        NaN        NaN   \n",
              "121320         NaN            NaN          NaN     NaN        NaN        NaN   \n",
              "121356         NaN            NaN          NaN     NaN        NaN        NaN   \n",
              "121970         NaN            NaN          NaN     NaN        NaN        NaN   \n",
              "\n",
              "        Marking  StandingTackle  SlidingTackle  GKDiving  GKHandling  \\\n",
              "28         80.0            78.0           73.0      15.0         6.0   \n",
              "37         77.0            78.0           73.0      16.0        16.0   \n",
              "43         62.0            65.0           52.0      15.0        14.0   \n",
              "70         72.0            77.0           76.0       7.0        16.0   \n",
              "74         69.0            73.0           71.0       5.0         7.0   \n",
              "...         ...             ...            ...       ...         ...   \n",
              "121143      NaN             NaN            NaN       NaN         NaN   \n",
              "121187      NaN             NaN            NaN       NaN         NaN   \n",
              "121320      NaN             NaN            NaN       NaN         NaN   \n",
              "121356      NaN             NaN            NaN       NaN         NaN   \n",
              "121970      NaN             NaN            NaN       NaN         NaN   \n",
              "\n",
              "        GKKicking  GKPositioning  GKReflexes Best Position  \\\n",
              "28            8.0           10.0         7.0            CM   \n",
              "37           11.0            6.0         8.0            CM   \n",
              "43            9.0            9.0        15.0           CAM   \n",
              "70            6.0           12.0        11.0           RWB   \n",
              "74            7.0           10.0         7.0            CM   \n",
              "...           ...            ...         ...           ...   \n",
              "121143        NaN            NaN         NaN           NaN   \n",
              "121187        NaN            NaN         NaN           NaN   \n",
              "121320        NaN            NaN         NaN           NaN   \n",
              "121356        NaN            NaN         NaN           NaN   \n",
              "121970        NaN            NaN         NaN           NaN   \n",
              "\n",
              "                           Best Overall Rating FIFA Version  Release Clause  \\\n",
              "28                                        82.0       FIFA17             NaN   \n",
              "37                                        79.0       FIFA17             NaN   \n",
              "43                                        82.0       FIFA17             NaN   \n",
              "70                                        78.0       FIFA17             NaN   \n",
              "74                                        80.0       FIFA17             NaN   \n",
              "...                                        ...          ...             ...   \n",
              "121143                                     NaN       FIFA23             NaN   \n",
              "121187  <span class=\"bp3-tag p p-59\">59</span>       FIFA23             NaN   \n",
              "121320  <span class=\"bp3-tag p p-58\">58</span>       FIFA23             NaN   \n",
              "121356                                     NaN       FIFA23             NaN   \n",
              "121970                                     NaN       FIFA23             NaN   \n",
              "\n",
              "        DefensiveAwareness  \n",
              "28                     NaN  \n",
              "37                     NaN  \n",
              "43                     NaN  \n",
              "70                     NaN  \n",
              "74                     NaN  \n",
              "...                    ...  \n",
              "121143                 NaN  \n",
              "121187                 NaN  \n",
              "121320                 NaN  \n",
              "121356                 NaN  \n",
              "121970                 NaN  \n",
              "\n",
              "[2897 rows x 63 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-836a517d-7aea-4519-8265-2af1df801bb4\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>ID</th>\n",
              "      <th>Name</th>\n",
              "      <th>Age</th>\n",
              "      <th>Nationality</th>\n",
              "      <th>Overall</th>\n",
              "      <th>Potential</th>\n",
              "      <th>Club</th>\n",
              "      <th>Value</th>\n",
              "      <th>Wage</th>\n",
              "      <th>Special</th>\n",
              "      <th>Preferred Foot</th>\n",
              "      <th>International Reputation</th>\n",
              "      <th>Weak Foot</th>\n",
              "      <th>Skill Moves</th>\n",
              "      <th>Work Rate</th>\n",
              "      <th>Body Type</th>\n",
              "      <th>Real Face</th>\n",
              "      <th>Position</th>\n",
              "      <th>Jersey Number</th>\n",
              "      <th>Joined</th>\n",
              "      <th>Loaned From</th>\n",
              "      <th>Contract Valid Until</th>\n",
              "      <th>Height</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Crossing</th>\n",
              "      <th>Finishing</th>\n",
              "      <th>HeadingAccuracy</th>\n",
              "      <th>ShortPassing</th>\n",
              "      <th>Volleys</th>\n",
              "      <th>Dribbling</th>\n",
              "      <th>Curve</th>\n",
              "      <th>FKAccuracy</th>\n",
              "      <th>LongPassing</th>\n",
              "      <th>BallControl</th>\n",
              "      <th>Acceleration</th>\n",
              "      <th>SprintSpeed</th>\n",
              "      <th>Agility</th>\n",
              "      <th>Reactions</th>\n",
              "      <th>Balance</th>\n",
              "      <th>ShotPower</th>\n",
              "      <th>Jumping</th>\n",
              "      <th>Stamina</th>\n",
              "      <th>Strength</th>\n",
              "      <th>LongShots</th>\n",
              "      <th>Aggression</th>\n",
              "      <th>Interceptions</th>\n",
              "      <th>Positioning</th>\n",
              "      <th>Vision</th>\n",
              "      <th>Penalties</th>\n",
              "      <th>Composure</th>\n",
              "      <th>Marking</th>\n",
              "      <th>StandingTackle</th>\n",
              "      <th>SlidingTackle</th>\n",
              "      <th>GKDiving</th>\n",
              "      <th>GKHandling</th>\n",
              "      <th>GKKicking</th>\n",
              "      <th>GKPositioning</th>\n",
              "      <th>GKReflexes</th>\n",
              "      <th>Best Position</th>\n",
              "      <th>Best Overall Rating</th>\n",
              "      <th>FIFA Version</th>\n",
              "      <th>Release Clause</th>\n",
              "      <th>DefensiveAwareness</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>184826.0</td>\n",
              "      <td>Adrien Silva</td>\n",
              "      <td>27.0</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>83.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>Sporting CP</td>\n",
              "      <td>23000000.0</td>\n",
              "      <td>20000.0</td>\n",
              "      <td>2179.0</td>\n",
              "      <td>Right</td>\n",
              "      <td>2.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Medium/ High</td>\n",
              "      <td>Normal (170-185)</td>\n",
              "      <td>No</td>\n",
              "      <td>SUB</td>\n",
              "      <td>23.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5'9</td>\n",
              "      <td>152lbs</td>\n",
              "      <td>78.0</td>\n",
              "      <td>71.0</td>\n",
              "      <td>61.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>64.0</td>\n",
              "      <td>65.0</td>\n",
              "      <td>73.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>67.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>89.0</td>\n",
              "      <td>62.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>73.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>CM</td>\n",
              "      <td>82.0</td>\n",
              "      <td>FIFA17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>187961.0</td>\n",
              "      <td>Paulinho</td>\n",
              "      <td>27.0</td>\n",
              "      <td>Brazil</td>\n",
              "      <td>81.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2168.0</td>\n",
              "      <td>Right</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>High/ High</td>\n",
              "      <td>Normal (170-185)</td>\n",
              "      <td>Yes</td>\n",
              "      <td>RCM</td>\n",
              "      <td>15.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5'11</td>\n",
              "      <td>165lbs</td>\n",
              "      <td>64.0</td>\n",
              "      <td>72.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>66.0</td>\n",
              "      <td>72.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>70.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>64.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>92.0</td>\n",
              "      <td>69.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>69.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>71.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>73.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>CM</td>\n",
              "      <td>79.0</td>\n",
              "      <td>FIFA17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>197965.0</td>\n",
              "      <td>Pizzi</td>\n",
              "      <td>26.0</td>\n",
              "      <td>Portugal</td>\n",
              "      <td>82.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>SL Benfica</td>\n",
              "      <td>20500000.0</td>\n",
              "      <td>20000.0</td>\n",
              "      <td>2166.0</td>\n",
              "      <td>Right</td>\n",
              "      <td>2.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>High/ Medium</td>\n",
              "      <td>Lean (170-185)</td>\n",
              "      <td>No</td>\n",
              "      <td>SUB</td>\n",
              "      <td>16.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5'8</td>\n",
              "      <td>146lbs</td>\n",
              "      <td>75.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>45.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>74.0</td>\n",
              "      <td>67.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>61.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>70.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>62.0</td>\n",
              "      <td>65.0</td>\n",
              "      <td>52.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>15.0</td>\n",
              "      <td>CAM</td>\n",
              "      <td>82.0</td>\n",
              "      <td>FIFA17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>70</th>\n",
              "      <td>178322.0</td>\n",
              "      <td>M. Layún</td>\n",
              "      <td>28.0</td>\n",
              "      <td>Mexico</td>\n",
              "      <td>79.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>FC Porto</td>\n",
              "      <td>8000000.0</td>\n",
              "      <td>20000.0</td>\n",
              "      <td>2145.0</td>\n",
              "      <td>Right</td>\n",
              "      <td>3.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>High/ High</td>\n",
              "      <td>Normal (170-185)</td>\n",
              "      <td>Yes</td>\n",
              "      <td>LCM</td>\n",
              "      <td>7.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5'10</td>\n",
              "      <td>152lbs</td>\n",
              "      <td>82.0</td>\n",
              "      <td>67.0</td>\n",
              "      <td>64.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>66.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>74.0</td>\n",
              "      <td>74.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>67.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>72.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>74.0</td>\n",
              "      <td>71.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>72.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>76.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>RWB</td>\n",
              "      <td>78.0</td>\n",
              "      <td>FIFA17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>74</th>\n",
              "      <td>177413.0</td>\n",
              "      <td>A. Witsel</td>\n",
              "      <td>27.0</td>\n",
              "      <td>Belgium</td>\n",
              "      <td>82.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2143.0</td>\n",
              "      <td>Right</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Normal (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>LCM</td>\n",
              "      <td>6.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6'1</td>\n",
              "      <td>161lbs</td>\n",
              "      <td>69.0</td>\n",
              "      <td>71.0</td>\n",
              "      <td>77.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>67.0</td>\n",
              "      <td>83.0</td>\n",
              "      <td>69.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>67.0</td>\n",
              "      <td>74.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>72.0</td>\n",
              "      <td>85.0</td>\n",
              "      <td>79.0</td>\n",
              "      <td>74.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>80.0</td>\n",
              "      <td>75.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>86.0</td>\n",
              "      <td>69.0</td>\n",
              "      <td>73.0</td>\n",
              "      <td>71.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>CM</td>\n",
              "      <td>80.0</td>\n",
              "      <td>FIFA17</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",
              "      <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",
              "      <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>121143</th>\n",
              "      <td>253949.0</td>\n",
              "      <td>20 R. Goss</td>\n",
              "      <td>25.0</td>\n",
              "      <td>South Africa</td>\n",
              "      <td>61.0</td>\n",
              "      <td>65.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>918.0</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Normal (170-185)</td>\n",
              "      <td>No</td>\n",
              "      <td>SUB</td>\n",
              "      <td>16.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>181cm</td>\n",
              "      <td>75kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>121187</th>\n",
              "      <td>257550.0</td>\n",
              "      <td>22 I. Al Kaabi</td>\n",
              "      <td>28.0</td>\n",
              "      <td>United Arab Emirates</td>\n",
              "      <td>59.0</td>\n",
              "      <td>62.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>910.0</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Normal (170-185)</td>\n",
              "      <td>No</td>\n",
              "      <td>nan</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>183cm</td>\n",
              "      <td>82kg</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",
              "      <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",
              "      <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",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>&lt;span class=\"bp3-tag p p-59\"&gt;59&lt;/span&gt;</td>\n",
              "      <td>FIFA23</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>121320</th>\n",
              "      <td>267767.0</td>\n",
              "      <td>S. Kittos</td>\n",
              "      <td>20.0</td>\n",
              "      <td>Cyprus</td>\n",
              "      <td>58.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>891.0</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Lean (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>nan</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>186cm</td>\n",
              "      <td>75kg</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",
              "      <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",
              "      <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",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>&lt;span class=\"bp3-tag p p-58\"&gt;58&lt;/span&gt;</td>\n",
              "      <td>FIFA23</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>121356</th>\n",
              "      <td>252359.0</td>\n",
              "      <td>21 E. Ira Tape</td>\n",
              "      <td>22.0</td>\n",
              "      <td>Côte d'Ivoire</td>\n",
              "      <td>61.0</td>\n",
              "      <td>70.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>886.0</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Medium/ Medium</td>\n",
              "      <td>Normal (185+)</td>\n",
              "      <td>No</td>\n",
              "      <td>SUB</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>192cm</td>\n",
              "      <td>85kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>121970</th>\n",
              "      <td>168933.0</td>\n",
              "      <td>07 I. Paskov</td>\n",
              "      <td>33.0</td>\n",
              "      <td>Bulgaria</td>\n",
              "      <td>43.0</td>\n",
              "      <td>42.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>800.0</td>\n",
              "      <td>Right</td>\n",
              "      <td>1.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>N/A/ N/A</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>SUB</td>\n",
              "      <td>24.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>184cm</td>\n",
              "      <td>79kg</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",
              "      <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",
              "      <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",
              "      <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>FIFA23</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>2897 rows × 63 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-836a517d-7aea-4519-8265-2af1df801bb4')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-11ec0e41-9171-412b-b51a-e8dec3b35a04\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-11ec0e41-9171-412b-b51a-e8dec3b35a04')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart:hover {\n",
              "    background-color: #E2EBFA;\n",
              "    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: #174EA6;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-11ec0e41-9171-412b-b51a-e8dec3b35a04 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-836a517d-7aea-4519-8265-2af1df801bb4 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-836a517d-7aea-4519-8265-2af1df801bb4');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 49
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "Ln-ULJrX0YIl"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}