3. Feature Extraction.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/SKawsar/data_preprocessing_for_ML_with_Python/blob/main/Lecture_03.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "DBBfZPHIvqvx"
      },
      "source": [
        "# Lecture 3: Data Preproccessing with Pandas (Part 2)\n",
        "\n",
        "Instructor: Md Shahidullah Kawsar\n",
        "<br>Data Scientist, IDARE, Houston, TX, USA\n",
        "\n",
        "#### Objectives:\n",
        "- How to extract new information from a column?\n",
        "- How to create a column based on a condition or function?\n",
        "- Removing a string from a column\n",
        "- Checking the unique values for each column\n",
        "- performing calculation in dataframe columns\n",
        "- dataframe sorting\n",
        "\n",
        "#### References:\n",
        "[1] Data Source: https://stats.espncricinfo.com/ci/content/records/223646.html\n",
        "<br>[2] pandas split: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.str.split.html\n",
        "<br>[3] pandas concatenation: https://pandas.pydata.org/docs/reference/api/pandas.concat.html\n",
        "<br>[4] pandas replace: https://pandas.pydata.org/docs/reference/api/pandas.Series.str.replace.html\n",
        "<br>[5] pandas column rename: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.rename.html\n",
        "<br>[6] pandas sorting: https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.sort_values.html\n",
        "<br>[7] pandas counting unique values: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.value_counts.html\n",
        "<br>[8] pandas drop: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.drop.html\n",
        "<br>[9] pandas data type conversion: https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.astype.html\n",
        "<br>[10] **Self Study:** difference between .loc and .iloc: https://www.analyticsvidhya.com/blog/2020/02/loc-iloc-pandas/"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "oX0OFwtPvqv1"
      },
      "outputs": [],
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "\n",
        "# display 100 rows of the dataframe\n",
        "pd.options.display.max_rows = 100"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "LC8uom88vqv2"
      },
      "source": [
        "#### Reading an excel file"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "zUUAJoAxvqv3",
        "outputId": "72fd6edd-c1d1-459c-c5be-d63fd1501d54"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player</th>\n",
              "      <th>Span</th>\n",
              "      <th>Mat</th>\n",
              "      <th>Inns</th>\n",
              "      <th>NO</th>\n",
              "      <th>Runs</th>\n",
              "      <th>HS</th>\n",
              "      <th>Ave</th>\n",
              "      <th>BF</th>\n",
              "      <th>SR</th>\n",
              "      <th>100</th>\n",
              "      <th>50</th>\n",
              "      <th>0</th>\n",
              "      <th>4s</th>\n",
              "      <th>6s</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SR Tendulkar (INDIA)</td>\n",
              "      <td>1989-2012</td>\n",
              "      <td>463</td>\n",
              "      <td>452</td>\n",
              "      <td>41</td>\n",
              "      <td>18426</td>\n",
              "      <td>200*</td>\n",
              "      <td>44.83</td>\n",
              "      <td>21368</td>\n",
              "      <td>86.23</td>\n",
              "      <td>49</td>\n",
              "      <td>96</td>\n",
              "      <td>20</td>\n",
              "      <td>2016</td>\n",
              "      <td>195</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>KC Sangakkara (Asia/ICC/SL)</td>\n",
              "      <td>2000-2015</td>\n",
              "      <td>404</td>\n",
              "      <td>380</td>\n",
              "      <td>41</td>\n",
              "      <td>14234</td>\n",
              "      <td>169</td>\n",
              "      <td>41.98</td>\n",
              "      <td>18048</td>\n",
              "      <td>78.86</td>\n",
              "      <td>25</td>\n",
              "      <td>93</td>\n",
              "      <td>15</td>\n",
              "      <td>1385</td>\n",
              "      <td>88</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>RT Ponting (AUS/ICC)</td>\n",
              "      <td>1995-2012</td>\n",
              "      <td>375</td>\n",
              "      <td>365</td>\n",
              "      <td>39</td>\n",
              "      <td>13704</td>\n",
              "      <td>164</td>\n",
              "      <td>42.03</td>\n",
              "      <td>17046</td>\n",
              "      <td>80.39</td>\n",
              "      <td>30</td>\n",
              "      <td>82</td>\n",
              "      <td>20</td>\n",
              "      <td>1231</td>\n",
              "      <td>162</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ST Jayasuriya (Asia/SL)</td>\n",
              "      <td>1989-2011</td>\n",
              "      <td>445</td>\n",
              "      <td>433</td>\n",
              "      <td>18</td>\n",
              "      <td>13430</td>\n",
              "      <td>189</td>\n",
              "      <td>32.36</td>\n",
              "      <td>14725</td>\n",
              "      <td>91.20</td>\n",
              "      <td>28</td>\n",
              "      <td>68</td>\n",
              "      <td>34</td>\n",
              "      <td>1500</td>\n",
              "      <td>270</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>DPMD Jayawardene (Asia/SL)</td>\n",
              "      <td>1998-2015</td>\n",
              "      <td>448</td>\n",
              "      <td>418</td>\n",
              "      <td>39</td>\n",
              "      <td>12650</td>\n",
              "      <td>144</td>\n",
              "      <td>33.37</td>\n",
              "      <td>16020</td>\n",
              "      <td>78.96</td>\n",
              "      <td>19</td>\n",
              "      <td>77</td>\n",
              "      <td>28</td>\n",
              "      <td>1119</td>\n",
              "      <td>76</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                        Player       Span  Mat  Inns  NO   Runs    HS    Ave  \\\n",
              "0         SR Tendulkar (INDIA)  1989-2012  463   452  41  18426  200*  44.83   \n",
              "1  KC Sangakkara (Asia/ICC/SL)  2000-2015  404   380  41  14234   169  41.98   \n",
              "2         RT Ponting (AUS/ICC)  1995-2012  375   365  39  13704   164  42.03   \n",
              "3      ST Jayasuriya (Asia/SL)  1989-2011  445   433  18  13430   189  32.36   \n",
              "4   DPMD Jayawardene (Asia/SL)  1998-2015  448   418  39  12650   144  33.37   \n",
              "\n",
              "      BF     SR  100  50   0    4s   6s  \n",
              "0  21368  86.23   49  96  20  2016  195  \n",
              "1  18048  78.86   25  93  15  1385   88  \n",
              "2  17046  80.39   30  82  20  1231  162  \n",
              "3  14725  91.20   28  68  34  1500  270  \n",
              "4  16020  78.96   19  77  28  1119   76  "
            ]
          },
          "metadata": {},
          "output_type": "display_data"
        }
      ],
      "source": [
        "df = pd.read_excel(\"ODI_cricket.xlsx\", sheet_name=\"batsman\", engine=\"openpyxl\")\n",
        "\n",
        "display(df.head())"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "SKTmmC_vvqv3"
      },
      "source": [
        "#### Codes from Lecture 2"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "Yu_X-PUIvqv4",
        "outputId": "98b754f9-351c-4d1c-9722-77ac5a0b1477"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player_Name</th>\n",
              "      <th>Country</th>\n",
              "      <th>Span</th>\n",
              "      <th>Match</th>\n",
              "      <th>Innings</th>\n",
              "      <th>NotOut</th>\n",
              "      <th>Runs</th>\n",
              "      <th>Highest_score</th>\n",
              "      <th>Average</th>\n",
              "      <th>Balls_Faced</th>\n",
              "      <th>Strike_Rate</th>\n",
              "      <th>Centuries</th>\n",
              "      <th>Half_centuries</th>\n",
              "      <th>Ducks</th>\n",
              "      <th>Fours</th>\n",
              "      <th>Sixes</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SR Tendulkar</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>1989-2012</td>\n",
              "      <td>463</td>\n",
              "      <td>452</td>\n",
              "      <td>41</td>\n",
              "      <td>18426</td>\n",
              "      <td>200*</td>\n",
              "      <td>44.83</td>\n",
              "      <td>21368</td>\n",
              "      <td>86.23</td>\n",
              "      <td>49</td>\n",
              "      <td>96</td>\n",
              "      <td>20</td>\n",
              "      <td>2016</td>\n",
              "      <td>195</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>KC Sangakkara</td>\n",
              "      <td>Asia/ICC/SL</td>\n",
              "      <td>2000-2015</td>\n",
              "      <td>404</td>\n",
              "      <td>380</td>\n",
              "      <td>41</td>\n",
              "      <td>14234</td>\n",
              "      <td>169</td>\n",
              "      <td>41.98</td>\n",
              "      <td>18048</td>\n",
              "      <td>78.86</td>\n",
              "      <td>25</td>\n",
              "      <td>93</td>\n",
              "      <td>15</td>\n",
              "      <td>1385</td>\n",
              "      <td>88</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>RT Ponting</td>\n",
              "      <td>AUS/ICC</td>\n",
              "      <td>1995-2012</td>\n",
              "      <td>375</td>\n",
              "      <td>365</td>\n",
              "      <td>39</td>\n",
              "      <td>13704</td>\n",
              "      <td>164</td>\n",
              "      <td>42.03</td>\n",
              "      <td>17046</td>\n",
              "      <td>80.39</td>\n",
              "      <td>30</td>\n",
              "      <td>82</td>\n",
              "      <td>20</td>\n",
              "      <td>1231</td>\n",
              "      <td>162</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ST Jayasuriya</td>\n",
              "      <td>Asia/SL</td>\n",
              "      <td>1989-2011</td>\n",
              "      <td>445</td>\n",
              "      <td>433</td>\n",
              "      <td>18</td>\n",
              "      <td>13430</td>\n",
              "      <td>189</td>\n",
              "      <td>32.36</td>\n",
              "      <td>14725</td>\n",
              "      <td>91.20</td>\n",
              "      <td>28</td>\n",
              "      <td>68</td>\n",
              "      <td>34</td>\n",
              "      <td>1500</td>\n",
              "      <td>270</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>DPMD Jayawardene</td>\n",
              "      <td>Asia/SL</td>\n",
              "      <td>1998-2015</td>\n",
              "      <td>448</td>\n",
              "      <td>418</td>\n",
              "      <td>39</td>\n",
              "      <td>12650</td>\n",
              "      <td>144</td>\n",
              "      <td>33.37</td>\n",
              "      <td>16020</td>\n",
              "      <td>78.96</td>\n",
              "      <td>19</td>\n",
              "      <td>77</td>\n",
              "      <td>28</td>\n",
              "      <td>1119</td>\n",
              "      <td>76</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         Player_Name      Country       Span  Match  Innings  NotOut   Runs  \\\n",
              "0      SR Tendulkar         INDIA  1989-2012    463      452      41  18426   \n",
              "1     KC Sangakkara   Asia/ICC/SL  2000-2015    404      380      41  14234   \n",
              "2        RT Ponting       AUS/ICC  1995-2012    375      365      39  13704   \n",
              "3     ST Jayasuriya       Asia/SL  1989-2011    445      433      18  13430   \n",
              "4  DPMD Jayawardene       Asia/SL  1998-2015    448      418      39  12650   \n",
              "\n",
              "  Highest_score  Average  Balls_Faced  Strike_Rate  Centuries  Half_centuries  \\\n",
              "0          200*    44.83        21368        86.23         49              96   \n",
              "1           169    41.98        18048        78.86         25              93   \n",
              "2           164    42.03        17046        80.39         30              82   \n",
              "3           189    32.36        14725        91.20         28              68   \n",
              "4           144    33.37        16020        78.96         19              77   \n",
              "\n",
              "   Ducks Fours Sixes  \n",
              "0     20  2016   195  \n",
              "1     15  1385    88  \n",
              "2     20  1231   162  \n",
              "3     34  1500   270  \n",
              "4     28  1119    76  "
            ]
          },
          "metadata": {},
          "output_type": "display_data"
        }
      ],
      "source": [
        "# renaming the column names\n",
        "df = df.rename(columns={'Mat':'Match', \n",
        "                        'Inns':'Innings',\n",
        "                        'NO': 'NotOut',\n",
        "                        'HS': 'Highest_score',\n",
        "                        'Ave': 'Average',\n",
        "                        'BF': 'Balls_Faced',\n",
        "                        'SR': 'Strike_Rate',\n",
        "                        100: 'Centuries',\n",
        "                        50: 'Half_centuries',\n",
        "                        0: 'Ducks',\n",
        "                        \"4s\": \"Fours\",\n",
        "                        \"6s\": \"Sixes\"})\n",
        "\n",
        "# splitting the 'Player' column to get the information about 'Country'\n",
        "df[[\"Player_Name\", \"Country\"]] = df['Player'].str.split(\"(\", expand=True)\n",
        "\n",
        "# dropping the 'Player' columns\n",
        "df = df.drop('Player', axis=1)\n",
        "\n",
        "# remove the \")\" from the 'Country' column\n",
        "df['Country'] = df['Country'].str.replace(\")\", \"\")\n",
        "\n",
        "# rearrange the columns\n",
        "new_col_sequence = ['Player_Name', 'Country', 'Span', 'Match', 'Innings', 'NotOut', 'Runs', 'Highest_score',\n",
        "       'Average', 'Balls_Faced', 'Strike_Rate', 'Centuries', 'Half_centuries', 'Ducks', 'Fours', 'Sixes']\n",
        "df = df[new_col_sequence]\n",
        "\n",
        "display(df.head())"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "lmSrAMFQvqv5"
      },
      "source": [
        "#### How to create a column based on a condition or function?"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "m1rExGs8vqv5",
        "outputId": "20f5d3a4-191f-4fc0-d2a5-1624913e93e8"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "AUS               13\n",
              "PAK                9\n",
              "WI                 8\n",
              "SA                 8\n",
              "INDIA              8\n",
              "SL                 6\n",
              "ZIM                5\n",
              "NZ                 5\n",
              "AUS/ICC            3\n",
              "BAN                3\n",
              "Asia/INDIA         3\n",
              "ENG                3\n",
              "Asia/PAK           3\n",
              "Asia/SL            3\n",
              "ICC/WI             2\n",
              "Asia/ICC/INDIA     2\n",
              "Afr/SA             2\n",
              "ENG/IRE            1\n",
              "ICC/NZ             1\n",
              "Asia/ICC/PAK       1\n",
              "Asia/ICC/SL        1\n",
              "Afr/ICC/SA         1\n",
              "IRE                1\n",
              "Name: Country, dtype: int64"
            ]
          },
          "execution_count": 67,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df['Country'].value_counts()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "uJ8rMnlHvqv6"
      },
      "outputs": [],
      "source": [
        "def icc_check(x):\n",
        "    if \"ICC\" in x:\n",
        "        return \"Yes\"\n",
        "    else:\n",
        "        return \"No\""
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "-Bn79GEavqv6"
      },
      "outputs": [],
      "source": [
        "def asia_check(x):\n",
        "    if \"Asia\" in x:\n",
        "        return \"Yes\"\n",
        "    else:\n",
        "        return \"No\""
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "_sTEDrXXvqv7"
      },
      "outputs": [],
      "source": [
        "def africa_check(x):\n",
        "    if \"Afr\" in x:\n",
        "        return \"Yes\"\n",
        "    else:\n",
        "        return \"No\""
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "U7u5ETC4vqv7",
        "outputId": "c2a64a36-d60f-4ad6-f19a-510ce5786eb4"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player_Name</th>\n",
              "      <th>Country</th>\n",
              "      <th>Span</th>\n",
              "      <th>Match</th>\n",
              "      <th>Innings</th>\n",
              "      <th>NotOut</th>\n",
              "      <th>Runs</th>\n",
              "      <th>Highest_score</th>\n",
              "      <th>Average</th>\n",
              "      <th>Balls_Faced</th>\n",
              "      <th>Strike_Rate</th>\n",
              "      <th>Centuries</th>\n",
              "      <th>Half_centuries</th>\n",
              "      <th>Ducks</th>\n",
              "      <th>Fours</th>\n",
              "      <th>Sixes</th>\n",
              "      <th>played_for_ICC</th>\n",
              "      <th>played_for_Asia</th>\n",
              "      <th>played_for_Africa</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SR Tendulkar</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>1989-2012</td>\n",
              "      <td>463</td>\n",
              "      <td>452</td>\n",
              "      <td>41</td>\n",
              "      <td>18426</td>\n",
              "      <td>200*</td>\n",
              "      <td>44.83</td>\n",
              "      <td>21368</td>\n",
              "      <td>86.23</td>\n",
              "      <td>49</td>\n",
              "      <td>96</td>\n",
              "      <td>20</td>\n",
              "      <td>2016</td>\n",
              "      <td>195</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>KC Sangakkara</td>\n",
              "      <td>Asia/ICC/SL</td>\n",
              "      <td>2000-2015</td>\n",
              "      <td>404</td>\n",
              "      <td>380</td>\n",
              "      <td>41</td>\n",
              "      <td>14234</td>\n",
              "      <td>169</td>\n",
              "      <td>41.98</td>\n",
              "      <td>18048</td>\n",
              "      <td>78.86</td>\n",
              "      <td>25</td>\n",
              "      <td>93</td>\n",
              "      <td>15</td>\n",
              "      <td>1385</td>\n",
              "      <td>88</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>RT Ponting</td>\n",
              "      <td>AUS/ICC</td>\n",
              "      <td>1995-2012</td>\n",
              "      <td>375</td>\n",
              "      <td>365</td>\n",
              "      <td>39</td>\n",
              "      <td>13704</td>\n",
              "      <td>164</td>\n",
              "      <td>42.03</td>\n",
              "      <td>17046</td>\n",
              "      <td>80.39</td>\n",
              "      <td>30</td>\n",
              "      <td>82</td>\n",
              "      <td>20</td>\n",
              "      <td>1231</td>\n",
              "      <td>162</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ST Jayasuriya</td>\n",
              "      <td>Asia/SL</td>\n",
              "      <td>1989-2011</td>\n",
              "      <td>445</td>\n",
              "      <td>433</td>\n",
              "      <td>18</td>\n",
              "      <td>13430</td>\n",
              "      <td>189</td>\n",
              "      <td>32.36</td>\n",
              "      <td>14725</td>\n",
              "      <td>91.20</td>\n",
              "      <td>28</td>\n",
              "      <td>68</td>\n",
              "      <td>34</td>\n",
              "      <td>1500</td>\n",
              "      <td>270</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>DPMD Jayawardene</td>\n",
              "      <td>Asia/SL</td>\n",
              "      <td>1998-2015</td>\n",
              "      <td>448</td>\n",
              "      <td>418</td>\n",
              "      <td>39</td>\n",
              "      <td>12650</td>\n",
              "      <td>144</td>\n",
              "      <td>33.37</td>\n",
              "      <td>16020</td>\n",
              "      <td>78.96</td>\n",
              "      <td>19</td>\n",
              "      <td>77</td>\n",
              "      <td>28</td>\n",
              "      <td>1119</td>\n",
              "      <td>76</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>V Kohli</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>2008-2022</td>\n",
              "      <td>260</td>\n",
              "      <td>251</td>\n",
              "      <td>39</td>\n",
              "      <td>12311</td>\n",
              "      <td>183</td>\n",
              "      <td>58.07</td>\n",
              "      <td>13249</td>\n",
              "      <td>92.92</td>\n",
              "      <td>43</td>\n",
              "      <td>64</td>\n",
              "      <td>15</td>\n",
              "      <td>1153</td>\n",
              "      <td>125</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Inzamam-ul-Haq</td>\n",
              "      <td>Asia/PAK</td>\n",
              "      <td>1991-2007</td>\n",
              "      <td>378</td>\n",
              "      <td>350</td>\n",
              "      <td>53</td>\n",
              "      <td>11739</td>\n",
              "      <td>137*</td>\n",
              "      <td>39.52</td>\n",
              "      <td>15812</td>\n",
              "      <td>74.24</td>\n",
              "      <td>10</td>\n",
              "      <td>83</td>\n",
              "      <td>20</td>\n",
              "      <td>971</td>\n",
              "      <td>144</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>JH Kallis</td>\n",
              "      <td>Afr/ICC/SA</td>\n",
              "      <td>1996-2014</td>\n",
              "      <td>328</td>\n",
              "      <td>314</td>\n",
              "      <td>53</td>\n",
              "      <td>11579</td>\n",
              "      <td>139</td>\n",
              "      <td>44.36</td>\n",
              "      <td>15885</td>\n",
              "      <td>72.89</td>\n",
              "      <td>17</td>\n",
              "      <td>86</td>\n",
              "      <td>17</td>\n",
              "      <td>911</td>\n",
              "      <td>137</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>SC Ganguly</td>\n",
              "      <td>Asia/INDIA</td>\n",
              "      <td>1992-2007</td>\n",
              "      <td>311</td>\n",
              "      <td>300</td>\n",
              "      <td>23</td>\n",
              "      <td>11363</td>\n",
              "      <td>183</td>\n",
              "      <td>41.02</td>\n",
              "      <td>15416</td>\n",
              "      <td>73.70</td>\n",
              "      <td>22</td>\n",
              "      <td>72</td>\n",
              "      <td>16</td>\n",
              "      <td>1122</td>\n",
              "      <td>190</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>R Dravid</td>\n",
              "      <td>Asia/ICC/INDIA</td>\n",
              "      <td>1996-2011</td>\n",
              "      <td>344</td>\n",
              "      <td>318</td>\n",
              "      <td>40</td>\n",
              "      <td>10889</td>\n",
              "      <td>153</td>\n",
              "      <td>39.16</td>\n",
              "      <td>15285</td>\n",
              "      <td>71.23</td>\n",
              "      <td>12</td>\n",
              "      <td>83</td>\n",
              "      <td>13</td>\n",
              "      <td>950</td>\n",
              "      <td>42</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         Player_Name         Country       Span  Match  Innings  NotOut  \\\n",
              "0      SR Tendulkar            INDIA  1989-2012    463      452      41   \n",
              "1     KC Sangakkara      Asia/ICC/SL  2000-2015    404      380      41   \n",
              "2        RT Ponting          AUS/ICC  1995-2012    375      365      39   \n",
              "3     ST Jayasuriya          Asia/SL  1989-2011    445      433      18   \n",
              "4  DPMD Jayawardene          Asia/SL  1998-2015    448      418      39   \n",
              "5           V Kohli            INDIA  2008-2022    260      251      39   \n",
              "6    Inzamam-ul-Haq         Asia/PAK  1991-2007    378      350      53   \n",
              "7         JH Kallis       Afr/ICC/SA  1996-2014    328      314      53   \n",
              "8        SC Ganguly       Asia/INDIA  1992-2007    311      300      23   \n",
              "9          R Dravid   Asia/ICC/INDIA  1996-2011    344      318      40   \n",
              "\n",
              "    Runs Highest_score  Average  Balls_Faced  Strike_Rate  Centuries  \\\n",
              "0  18426          200*    44.83        21368        86.23         49   \n",
              "1  14234           169    41.98        18048        78.86         25   \n",
              "2  13704           164    42.03        17046        80.39         30   \n",
              "3  13430           189    32.36        14725        91.20         28   \n",
              "4  12650           144    33.37        16020        78.96         19   \n",
              "5  12311           183    58.07        13249        92.92         43   \n",
              "6  11739          137*    39.52        15812        74.24         10   \n",
              "7  11579           139    44.36        15885        72.89         17   \n",
              "8  11363           183    41.02        15416        73.70         22   \n",
              "9  10889           153    39.16        15285        71.23         12   \n",
              "\n",
              "   Half_centuries  Ducks Fours Sixes played_for_ICC played_for_Asia  \\\n",
              "0              96     20  2016   195             No              No   \n",
              "1              93     15  1385    88            Yes             Yes   \n",
              "2              82     20  1231   162            Yes              No   \n",
              "3              68     34  1500   270             No             Yes   \n",
              "4              77     28  1119    76             No             Yes   \n",
              "5              64     15  1153   125             No              No   \n",
              "6              83     20   971   144             No             Yes   \n",
              "7              86     17   911   137            Yes              No   \n",
              "8              72     16  1122   190             No             Yes   \n",
              "9              83     13   950    42            Yes             Yes   \n",
              "\n",
              "  played_for_Africa  \n",
              "0                No  \n",
              "1                No  \n",
              "2                No  \n",
              "3                No  \n",
              "4                No  \n",
              "5                No  \n",
              "6                No  \n",
              "7               Yes  \n",
              "8                No  \n",
              "9                No  "
            ]
          },
          "metadata": {},
          "output_type": "display_data"
        }
      ],
      "source": [
        "df['played_for_ICC'] = df['Country'].apply(icc_check)\n",
        "df['played_for_Asia'] = df['Country'].apply(asia_check)\n",
        "df['played_for_Africa'] = df['Country'].apply(africa_check)\n",
        "\n",
        "display(df.head(10))"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "m5qrJvgSvqv8",
        "outputId": "e86084f5-c169-4ab6-e660-2c743de36c0d"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "No     81\n",
            "Yes    11\n",
            "Name: played_for_ICC, dtype: int64\n",
            "No     79\n",
            "Yes    13\n",
            "Name: played_for_Asia, dtype: int64\n",
            "No     89\n",
            "Yes     3\n",
            "Name: played_for_Africa, dtype: int64\n"
          ]
        }
      ],
      "source": [
        "print(df['played_for_ICC'].value_counts())\n",
        "print(df['played_for_Asia'].value_counts())\n",
        "print(df['played_for_Africa'].value_counts())"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "_bQCa_iQvqv8"
      },
      "source": [
        "#### Removing \"ICC/\" from the 'Country'"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "pJ7dsLWTvqv9",
        "outputId": "8a7dd18d-70ae-4781-c1db-e15f0f256350"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player_Name</th>\n",
              "      <th>Country</th>\n",
              "      <th>Span</th>\n",
              "      <th>Match</th>\n",
              "      <th>Innings</th>\n",
              "      <th>NotOut</th>\n",
              "      <th>Runs</th>\n",
              "      <th>Highest_score</th>\n",
              "      <th>Average</th>\n",
              "      <th>Balls_Faced</th>\n",
              "      <th>Strike_Rate</th>\n",
              "      <th>Centuries</th>\n",
              "      <th>Half_centuries</th>\n",
              "      <th>Ducks</th>\n",
              "      <th>Fours</th>\n",
              "      <th>Sixes</th>\n",
              "      <th>played_for_ICC</th>\n",
              "      <th>played_for_Asia</th>\n",
              "      <th>played_for_Africa</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SR Tendulkar</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>1989-2012</td>\n",
              "      <td>463</td>\n",
              "      <td>452</td>\n",
              "      <td>41</td>\n",
              "      <td>18426</td>\n",
              "      <td>200*</td>\n",
              "      <td>44.83</td>\n",
              "      <td>21368</td>\n",
              "      <td>86.23</td>\n",
              "      <td>49</td>\n",
              "      <td>96</td>\n",
              "      <td>20</td>\n",
              "      <td>2016</td>\n",
              "      <td>195</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>KC Sangakkara</td>\n",
              "      <td>SL</td>\n",
              "      <td>2000-2015</td>\n",
              "      <td>404</td>\n",
              "      <td>380</td>\n",
              "      <td>41</td>\n",
              "      <td>14234</td>\n",
              "      <td>169</td>\n",
              "      <td>41.98</td>\n",
              "      <td>18048</td>\n",
              "      <td>78.86</td>\n",
              "      <td>25</td>\n",
              "      <td>93</td>\n",
              "      <td>15</td>\n",
              "      <td>1385</td>\n",
              "      <td>88</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>RT Ponting</td>\n",
              "      <td>AUS</td>\n",
              "      <td>1995-2012</td>\n",
              "      <td>375</td>\n",
              "      <td>365</td>\n",
              "      <td>39</td>\n",
              "      <td>13704</td>\n",
              "      <td>164</td>\n",
              "      <td>42.03</td>\n",
              "      <td>17046</td>\n",
              "      <td>80.39</td>\n",
              "      <td>30</td>\n",
              "      <td>82</td>\n",
              "      <td>20</td>\n",
              "      <td>1231</td>\n",
              "      <td>162</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ST Jayasuriya</td>\n",
              "      <td>SL</td>\n",
              "      <td>1989-2011</td>\n",
              "      <td>445</td>\n",
              "      <td>433</td>\n",
              "      <td>18</td>\n",
              "      <td>13430</td>\n",
              "      <td>189</td>\n",
              "      <td>32.36</td>\n",
              "      <td>14725</td>\n",
              "      <td>91.20</td>\n",
              "      <td>28</td>\n",
              "      <td>68</td>\n",
              "      <td>34</td>\n",
              "      <td>1500</td>\n",
              "      <td>270</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>DPMD Jayawardene</td>\n",
              "      <td>SL</td>\n",
              "      <td>1998-2015</td>\n",
              "      <td>448</td>\n",
              "      <td>418</td>\n",
              "      <td>39</td>\n",
              "      <td>12650</td>\n",
              "      <td>144</td>\n",
              "      <td>33.37</td>\n",
              "      <td>16020</td>\n",
              "      <td>78.96</td>\n",
              "      <td>19</td>\n",
              "      <td>77</td>\n",
              "      <td>28</td>\n",
              "      <td>1119</td>\n",
              "      <td>76</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         Player_Name Country       Span  Match  Innings  NotOut   Runs  \\\n",
              "0      SR Tendulkar    INDIA  1989-2012    463      452      41  18426   \n",
              "1     KC Sangakkara       SL  2000-2015    404      380      41  14234   \n",
              "2        RT Ponting      AUS  1995-2012    375      365      39  13704   \n",
              "3     ST Jayasuriya       SL  1989-2011    445      433      18  13430   \n",
              "4  DPMD Jayawardene       SL  1998-2015    448      418      39  12650   \n",
              "\n",
              "  Highest_score  Average  Balls_Faced  Strike_Rate  Centuries  Half_centuries  \\\n",
              "0          200*    44.83        21368        86.23         49              96   \n",
              "1           169    41.98        18048        78.86         25              93   \n",
              "2           164    42.03        17046        80.39         30              82   \n",
              "3           189    32.36        14725        91.20         28              68   \n",
              "4           144    33.37        16020        78.96         19              77   \n",
              "\n",
              "   Ducks Fours Sixes played_for_ICC played_for_Asia played_for_Africa  \n",
              "0     20  2016   195             No              No                No  \n",
              "1     15  1385    88            Yes             Yes                No  \n",
              "2     20  1231   162            Yes              No                No  \n",
              "3     34  1500   270             No             Yes                No  \n",
              "4     28  1119    76             No             Yes                No  "
            ]
          },
          "metadata": {},
          "output_type": "display_data"
        }
      ],
      "source": [
        "df['Country'] = df['Country'].str.replace(\"ICC/\", \"\")\n",
        "df['Country'] = df['Country'].str.replace(\"/ICC\", \"\")\n",
        "df['Country'] = df['Country'].str.replace(\"Asia/\", \"\")\n",
        "df['Country'] = df['Country'].str.replace(\"Afr/\", \"\")\n",
        "\n",
        "display(df.head())"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "SYDimjaZvqv9"
      },
      "source": [
        "#### Checking the unique values for each column"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "Wk2-fDSUvqv-",
        "outputId": "d61903f7-d805-4ce2-ed9a-9e2f5064e50c"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "AUS        16\n",
              "PAK        13\n",
              "INDIA      13\n",
              "SA         11\n",
              "SL         10\n",
              "WI         10\n",
              "NZ          6\n",
              "ZIM         5\n",
              "ENG         3\n",
              "BAN         3\n",
              "ENG/IRE     1\n",
              "IRE         1\n",
              "Name: Country, dtype: int64"
            ]
          },
          "execution_count": 74,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df['Country'].value_counts()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "99UOH_klvqv-"
      },
      "source": [
        "#### Find number of years played"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "fa7FoOpsvqv-"
      },
      "outputs": [],
      "source": [
        "# df['start_year'] = df['Span'].str[0:4]\n",
        "\n",
        "# df['end_year'] = df['Span'].str[5:]\n",
        "\n",
        "# display(df.head(10))"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "MGJNTRaEvqv_",
        "outputId": "ffe78fa8-0e34-4abd-d2ae-da0f09f31742"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player_Name</th>\n",
              "      <th>Country</th>\n",
              "      <th>Match</th>\n",
              "      <th>Innings</th>\n",
              "      <th>NotOut</th>\n",
              "      <th>Runs</th>\n",
              "      <th>Highest_score</th>\n",
              "      <th>Average</th>\n",
              "      <th>Balls_Faced</th>\n",
              "      <th>Strike_Rate</th>\n",
              "      <th>Centuries</th>\n",
              "      <th>Half_centuries</th>\n",
              "      <th>Ducks</th>\n",
              "      <th>Fours</th>\n",
              "      <th>Sixes</th>\n",
              "      <th>played_for_ICC</th>\n",
              "      <th>played_for_Asia</th>\n",
              "      <th>played_for_Africa</th>\n",
              "      <th>start_year</th>\n",
              "      <th>end_year</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SR Tendulkar</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>463</td>\n",
              "      <td>452</td>\n",
              "      <td>41</td>\n",
              "      <td>18426</td>\n",
              "      <td>200*</td>\n",
              "      <td>44.83</td>\n",
              "      <td>21368</td>\n",
              "      <td>86.23</td>\n",
              "      <td>49</td>\n",
              "      <td>96</td>\n",
              "      <td>20</td>\n",
              "      <td>2016</td>\n",
              "      <td>195</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>1989</td>\n",
              "      <td>2012</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>KC Sangakkara</td>\n",
              "      <td>SL</td>\n",
              "      <td>404</td>\n",
              "      <td>380</td>\n",
              "      <td>41</td>\n",
              "      <td>14234</td>\n",
              "      <td>169</td>\n",
              "      <td>41.98</td>\n",
              "      <td>18048</td>\n",
              "      <td>78.86</td>\n",
              "      <td>25</td>\n",
              "      <td>93</td>\n",
              "      <td>15</td>\n",
              "      <td>1385</td>\n",
              "      <td>88</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>2000</td>\n",
              "      <td>2015</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>RT Ponting</td>\n",
              "      <td>AUS</td>\n",
              "      <td>375</td>\n",
              "      <td>365</td>\n",
              "      <td>39</td>\n",
              "      <td>13704</td>\n",
              "      <td>164</td>\n",
              "      <td>42.03</td>\n",
              "      <td>17046</td>\n",
              "      <td>80.39</td>\n",
              "      <td>30</td>\n",
              "      <td>82</td>\n",
              "      <td>20</td>\n",
              "      <td>1231</td>\n",
              "      <td>162</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>1995</td>\n",
              "      <td>2012</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ST Jayasuriya</td>\n",
              "      <td>SL</td>\n",
              "      <td>445</td>\n",
              "      <td>433</td>\n",
              "      <td>18</td>\n",
              "      <td>13430</td>\n",
              "      <td>189</td>\n",
              "      <td>32.36</td>\n",
              "      <td>14725</td>\n",
              "      <td>91.20</td>\n",
              "      <td>28</td>\n",
              "      <td>68</td>\n",
              "      <td>34</td>\n",
              "      <td>1500</td>\n",
              "      <td>270</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>1989</td>\n",
              "      <td>2011</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>DPMD Jayawardene</td>\n",
              "      <td>SL</td>\n",
              "      <td>448</td>\n",
              "      <td>418</td>\n",
              "      <td>39</td>\n",
              "      <td>12650</td>\n",
              "      <td>144</td>\n",
              "      <td>33.37</td>\n",
              "      <td>16020</td>\n",
              "      <td>78.96</td>\n",
              "      <td>19</td>\n",
              "      <td>77</td>\n",
              "      <td>28</td>\n",
              "      <td>1119</td>\n",
              "      <td>76</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>1998</td>\n",
              "      <td>2015</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         Player_Name Country  Match  Innings  NotOut   Runs Highest_score  \\\n",
              "0      SR Tendulkar    INDIA    463      452      41  18426          200*   \n",
              "1     KC Sangakkara       SL    404      380      41  14234           169   \n",
              "2        RT Ponting      AUS    375      365      39  13704           164   \n",
              "3     ST Jayasuriya       SL    445      433      18  13430           189   \n",
              "4  DPMD Jayawardene       SL    448      418      39  12650           144   \n",
              "\n",
              "   Average  Balls_Faced  Strike_Rate  Centuries  Half_centuries  Ducks Fours  \\\n",
              "0    44.83        21368        86.23         49              96     20  2016   \n",
              "1    41.98        18048        78.86         25              93     15  1385   \n",
              "2    42.03        17046        80.39         30              82     20  1231   \n",
              "3    32.36        14725        91.20         28              68     34  1500   \n",
              "4    33.37        16020        78.96         19              77     28  1119   \n",
              "\n",
              "  Sixes played_for_ICC played_for_Asia played_for_Africa start_year end_year  \n",
              "0   195             No              No                No       1989     2012  \n",
              "1    88            Yes             Yes                No       2000     2015  \n",
              "2   162            Yes              No                No       1995     2012  \n",
              "3   270             No             Yes                No       1989     2011  \n",
              "4    76             No             Yes                No       1998     2015  "
            ]
          },
          "metadata": {},
          "output_type": "display_data"
        }
      ],
      "source": [
        "# splitting the 'Span' column based on the \"-\"\n",
        "df[['start_year', 'end_year']] = df['Span'].str.split(\"-\", expand=True)\n",
        "\n",
        "# removing the \"Span\" column\n",
        "df = df.drop(\"Span\", axis=1)\n",
        "\n",
        "display(df.head())"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "7GiAuPegvqv_",
        "outputId": "ba558a1d-6bb4-4aa3-a4b2-0c80c4f473e4"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 92 entries, 0 to 91\n",
            "Data columns (total 20 columns):\n",
            " #   Column             Non-Null Count  Dtype  \n",
            "---  ------             --------------  -----  \n",
            " 0   Player_Name        92 non-null     object \n",
            " 1   Country            92 non-null     object \n",
            " 2   Match              92 non-null     int64  \n",
            " 3   Innings            92 non-null     int64  \n",
            " 4   NotOut             92 non-null     int64  \n",
            " 5   Runs               92 non-null     int64  \n",
            " 6   Highest_score      92 non-null     object \n",
            " 7   Average            92 non-null     float64\n",
            " 8   Balls_Faced        92 non-null     int64  \n",
            " 9   Strike_Rate        92 non-null     float64\n",
            " 10  Centuries          92 non-null     int64  \n",
            " 11  Half_centuries     92 non-null     int64  \n",
            " 12  Ducks              92 non-null     int64  \n",
            " 13  Fours              92 non-null     object \n",
            " 14  Sixes              92 non-null     object \n",
            " 15  played_for_ICC     92 non-null     object \n",
            " 16  played_for_Asia    92 non-null     object \n",
            " 17  played_for_Africa  92 non-null     object \n",
            " 18  start_year         92 non-null     object \n",
            " 19  end_year           92 non-null     object \n",
            "dtypes: float64(2), int64(8), object(10)\n",
            "memory usage: 14.5+ KB\n"
          ]
        }
      ],
      "source": [
        "df.info()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "UXyAJpsrvqwA"
      },
      "source": [
        "**Data type conversion**"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "3lIybLHavqwA",
        "outputId": "68d3c8b0-dc26-42a4-9e9c-d84afad5a3a0"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 92 entries, 0 to 91\n",
            "Data columns (total 20 columns):\n",
            " #   Column             Non-Null Count  Dtype  \n",
            "---  ------             --------------  -----  \n",
            " 0   Player_Name        92 non-null     object \n",
            " 1   Country            92 non-null     object \n",
            " 2   Match              92 non-null     int64  \n",
            " 3   Innings            92 non-null     int64  \n",
            " 4   NotOut             92 non-null     int64  \n",
            " 5   Runs               92 non-null     int64  \n",
            " 6   Highest_score      92 non-null     object \n",
            " 7   Average            92 non-null     float64\n",
            " 8   Balls_Faced        92 non-null     int64  \n",
            " 9   Strike_Rate        92 non-null     float64\n",
            " 10  Centuries          92 non-null     int64  \n",
            " 11  Half_centuries     92 non-null     int64  \n",
            " 12  Ducks              92 non-null     int64  \n",
            " 13  Fours              92 non-null     object \n",
            " 14  Sixes              92 non-null     object \n",
            " 15  played_for_ICC     92 non-null     object \n",
            " 16  played_for_Asia    92 non-null     object \n",
            " 17  played_for_Africa  92 non-null     object \n",
            " 18  start_year         92 non-null     int32  \n",
            " 19  end_year           92 non-null     int32  \n",
            "dtypes: float64(2), int32(2), int64(8), object(8)\n",
            "memory usage: 13.8+ KB\n",
            "None\n"
          ]
        }
      ],
      "source": [
        "df['start_year'] = df['start_year'].astype('int') \n",
        "df['end_year'] = df['end_year'].astype('int')\n",
        "\n",
        "print(df.info())"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "DfzZ1T-PvqwA",
        "outputId": "bb8733c0-2db3-4922-92f3-5cc71a7bfb4c"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player_Name</th>\n",
              "      <th>Country</th>\n",
              "      <th>Match</th>\n",
              "      <th>Innings</th>\n",
              "      <th>NotOut</th>\n",
              "      <th>Runs</th>\n",
              "      <th>Highest_score</th>\n",
              "      <th>Average</th>\n",
              "      <th>Balls_Faced</th>\n",
              "      <th>Strike_Rate</th>\n",
              "      <th>Centuries</th>\n",
              "      <th>Half_centuries</th>\n",
              "      <th>Ducks</th>\n",
              "      <th>Fours</th>\n",
              "      <th>Sixes</th>\n",
              "      <th>played_for_ICC</th>\n",
              "      <th>played_for_Asia</th>\n",
              "      <th>played_for_Africa</th>\n",
              "      <th>years_played</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SR Tendulkar</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>463</td>\n",
              "      <td>452</td>\n",
              "      <td>41</td>\n",
              "      <td>18426</td>\n",
              "      <td>200*</td>\n",
              "      <td>44.83</td>\n",
              "      <td>21368</td>\n",
              "      <td>86.23</td>\n",
              "      <td>49</td>\n",
              "      <td>96</td>\n",
              "      <td>20</td>\n",
              "      <td>2016</td>\n",
              "      <td>195</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>KC Sangakkara</td>\n",
              "      <td>SL</td>\n",
              "      <td>404</td>\n",
              "      <td>380</td>\n",
              "      <td>41</td>\n",
              "      <td>14234</td>\n",
              "      <td>169</td>\n",
              "      <td>41.98</td>\n",
              "      <td>18048</td>\n",
              "      <td>78.86</td>\n",
              "      <td>25</td>\n",
              "      <td>93</td>\n",
              "      <td>15</td>\n",
              "      <td>1385</td>\n",
              "      <td>88</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>RT Ponting</td>\n",
              "      <td>AUS</td>\n",
              "      <td>375</td>\n",
              "      <td>365</td>\n",
              "      <td>39</td>\n",
              "      <td>13704</td>\n",
              "      <td>164</td>\n",
              "      <td>42.03</td>\n",
              "      <td>17046</td>\n",
              "      <td>80.39</td>\n",
              "      <td>30</td>\n",
              "      <td>82</td>\n",
              "      <td>20</td>\n",
              "      <td>1231</td>\n",
              "      <td>162</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ST Jayasuriya</td>\n",
              "      <td>SL</td>\n",
              "      <td>445</td>\n",
              "      <td>433</td>\n",
              "      <td>18</td>\n",
              "      <td>13430</td>\n",
              "      <td>189</td>\n",
              "      <td>32.36</td>\n",
              "      <td>14725</td>\n",
              "      <td>91.20</td>\n",
              "      <td>28</td>\n",
              "      <td>68</td>\n",
              "      <td>34</td>\n",
              "      <td>1500</td>\n",
              "      <td>270</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>DPMD Jayawardene</td>\n",
              "      <td>SL</td>\n",
              "      <td>448</td>\n",
              "      <td>418</td>\n",
              "      <td>39</td>\n",
              "      <td>12650</td>\n",
              "      <td>144</td>\n",
              "      <td>33.37</td>\n",
              "      <td>16020</td>\n",
              "      <td>78.96</td>\n",
              "      <td>19</td>\n",
              "      <td>77</td>\n",
              "      <td>28</td>\n",
              "      <td>1119</td>\n",
              "      <td>76</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>V Kohli</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>260</td>\n",
              "      <td>251</td>\n",
              "      <td>39</td>\n",
              "      <td>12311</td>\n",
              "      <td>183</td>\n",
              "      <td>58.07</td>\n",
              "      <td>13249</td>\n",
              "      <td>92.92</td>\n",
              "      <td>43</td>\n",
              "      <td>64</td>\n",
              "      <td>15</td>\n",
              "      <td>1153</td>\n",
              "      <td>125</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Inzamam-ul-Haq</td>\n",
              "      <td>PAK</td>\n",
              "      <td>378</td>\n",
              "      <td>350</td>\n",
              "      <td>53</td>\n",
              "      <td>11739</td>\n",
              "      <td>137*</td>\n",
              "      <td>39.52</td>\n",
              "      <td>15812</td>\n",
              "      <td>74.24</td>\n",
              "      <td>10</td>\n",
              "      <td>83</td>\n",
              "      <td>20</td>\n",
              "      <td>971</td>\n",
              "      <td>144</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>JH Kallis</td>\n",
              "      <td>SA</td>\n",
              "      <td>328</td>\n",
              "      <td>314</td>\n",
              "      <td>53</td>\n",
              "      <td>11579</td>\n",
              "      <td>139</td>\n",
              "      <td>44.36</td>\n",
              "      <td>15885</td>\n",
              "      <td>72.89</td>\n",
              "      <td>17</td>\n",
              "      <td>86</td>\n",
              "      <td>17</td>\n",
              "      <td>911</td>\n",
              "      <td>137</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>18</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>SC Ganguly</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>311</td>\n",
              "      <td>300</td>\n",
              "      <td>23</td>\n",
              "      <td>11363</td>\n",
              "      <td>183</td>\n",
              "      <td>41.02</td>\n",
              "      <td>15416</td>\n",
              "      <td>73.70</td>\n",
              "      <td>22</td>\n",
              "      <td>72</td>\n",
              "      <td>16</td>\n",
              "      <td>1122</td>\n",
              "      <td>190</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>R Dravid</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>344</td>\n",
              "      <td>318</td>\n",
              "      <td>40</td>\n",
              "      <td>10889</td>\n",
              "      <td>153</td>\n",
              "      <td>39.16</td>\n",
              "      <td>15285</td>\n",
              "      <td>71.23</td>\n",
              "      <td>12</td>\n",
              "      <td>83</td>\n",
              "      <td>13</td>\n",
              "      <td>950</td>\n",
              "      <td>42</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         Player_Name Country  Match  Innings  NotOut   Runs Highest_score  \\\n",
              "0      SR Tendulkar    INDIA    463      452      41  18426          200*   \n",
              "1     KC Sangakkara       SL    404      380      41  14234           169   \n",
              "2        RT Ponting      AUS    375      365      39  13704           164   \n",
              "3     ST Jayasuriya       SL    445      433      18  13430           189   \n",
              "4  DPMD Jayawardene       SL    448      418      39  12650           144   \n",
              "5           V Kohli    INDIA    260      251      39  12311           183   \n",
              "6    Inzamam-ul-Haq      PAK    378      350      53  11739          137*   \n",
              "7         JH Kallis       SA    328      314      53  11579           139   \n",
              "8        SC Ganguly    INDIA    311      300      23  11363           183   \n",
              "9          R Dravid    INDIA    344      318      40  10889           153   \n",
              "\n",
              "   Average  Balls_Faced  Strike_Rate  Centuries  Half_centuries  Ducks Fours  \\\n",
              "0    44.83        21368        86.23         49              96     20  2016   \n",
              "1    41.98        18048        78.86         25              93     15  1385   \n",
              "2    42.03        17046        80.39         30              82     20  1231   \n",
              "3    32.36        14725        91.20         28              68     34  1500   \n",
              "4    33.37        16020        78.96         19              77     28  1119   \n",
              "5    58.07        13249        92.92         43              64     15  1153   \n",
              "6    39.52        15812        74.24         10              83     20   971   \n",
              "7    44.36        15885        72.89         17              86     17   911   \n",
              "8    41.02        15416        73.70         22              72     16  1122   \n",
              "9    39.16        15285        71.23         12              83     13   950   \n",
              "\n",
              "  Sixes played_for_ICC played_for_Asia played_for_Africa  years_played  \n",
              "0   195             No              No                No            23  \n",
              "1    88            Yes             Yes                No            15  \n",
              "2   162            Yes              No                No            17  \n",
              "3   270             No             Yes                No            22  \n",
              "4    76             No             Yes                No            17  \n",
              "5   125             No              No                No            14  \n",
              "6   144             No             Yes                No            16  \n",
              "7   137            Yes              No               Yes            18  \n",
              "8   190             No             Yes                No            15  \n",
              "9    42            Yes             Yes                No            15  "
            ]
          },
          "metadata": {},
          "output_type": "display_data"
        }
      ],
      "source": [
        "df['years_played'] = df['end_year'] - df['start_year']\n",
        "\n",
        "df = df.drop(['start_year', \"end_year\"], axis=1)\n",
        "\n",
        "display(df.head(10))"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "jHN10FW9vqwB"
      },
      "source": [
        "#### Checking the average "
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "nn-qPMYCvqwB"
      },
      "outputs": [],
      "source": [
        "# df['avg'] = df['Runs']/(df['Innings'] - df['NotOut'])\n",
        "# df['avg'] = np.round(df['avg'], 2)\n",
        "\n",
        "# display(df.head(10))"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "HCQULwUTvqwB"
      },
      "source": [
        "#### Top 10 batsmen: Highest Batting average"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "oxDluUXevqwC",
        "outputId": "26226783-62ac-4c77-8fb4-1717f22d63a8"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player_Name</th>\n",
              "      <th>Country</th>\n",
              "      <th>Match</th>\n",
              "      <th>Innings</th>\n",
              "      <th>NotOut</th>\n",
              "      <th>Runs</th>\n",
              "      <th>Highest_score</th>\n",
              "      <th>Average</th>\n",
              "      <th>Balls_Faced</th>\n",
              "      <th>Strike_Rate</th>\n",
              "      <th>Centuries</th>\n",
              "      <th>Half_centuries</th>\n",
              "      <th>Ducks</th>\n",
              "      <th>Fours</th>\n",
              "      <th>Sixes</th>\n",
              "      <th>played_for_ICC</th>\n",
              "      <th>played_for_Asia</th>\n",
              "      <th>played_for_Africa</th>\n",
              "      <th>years_played</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>V Kohli</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>260</td>\n",
              "      <td>251</td>\n",
              "      <td>39</td>\n",
              "      <td>12311</td>\n",
              "      <td>183</td>\n",
              "      <td>58.07</td>\n",
              "      <td>13249</td>\n",
              "      <td>92.92</td>\n",
              "      <td>43</td>\n",
              "      <td>64</td>\n",
              "      <td>15</td>\n",
              "      <td>1153</td>\n",
              "      <td>125</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>MG Bevan</td>\n",
              "      <td>AUS</td>\n",
              "      <td>232</td>\n",
              "      <td>196</td>\n",
              "      <td>67</td>\n",
              "      <td>6912</td>\n",
              "      <td>108*</td>\n",
              "      <td>53.58</td>\n",
              "      <td>9320</td>\n",
              "      <td>74.16</td>\n",
              "      <td>6</td>\n",
              "      <td>46</td>\n",
              "      <td>5</td>\n",
              "      <td>450</td>\n",
              "      <td>21</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>AB de Villiers</td>\n",
              "      <td>SA</td>\n",
              "      <td>228</td>\n",
              "      <td>218</td>\n",
              "      <td>39</td>\n",
              "      <td>9577</td>\n",
              "      <td>176</td>\n",
              "      <td>53.50</td>\n",
              "      <td>9473</td>\n",
              "      <td>101.09</td>\n",
              "      <td>25</td>\n",
              "      <td>53</td>\n",
              "      <td>7</td>\n",
              "      <td>840</td>\n",
              "      <td>204</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60</th>\n",
              "      <td>JE Root</td>\n",
              "      <td>ENG</td>\n",
              "      <td>152</td>\n",
              "      <td>142</td>\n",
              "      <td>23</td>\n",
              "      <td>6109</td>\n",
              "      <td>133*</td>\n",
              "      <td>51.33</td>\n",
              "      <td>7034</td>\n",
              "      <td>86.84</td>\n",
              "      <td>16</td>\n",
              "      <td>35</td>\n",
              "      <td>5</td>\n",
              "      <td>491</td>\n",
              "      <td>44</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>MS Dhoni</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>350</td>\n",
              "      <td>297</td>\n",
              "      <td>84</td>\n",
              "      <td>10773</td>\n",
              "      <td>183*</td>\n",
              "      <td>50.57</td>\n",
              "      <td>12303</td>\n",
              "      <td>87.56</td>\n",
              "      <td>10</td>\n",
              "      <td>73</td>\n",
              "      <td>10</td>\n",
              "      <td>826</td>\n",
              "      <td>229</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>HM Amla</td>\n",
              "      <td>SA</td>\n",
              "      <td>181</td>\n",
              "      <td>178</td>\n",
              "      <td>14</td>\n",
              "      <td>8113</td>\n",
              "      <td>159</td>\n",
              "      <td>49.46</td>\n",
              "      <td>9178</td>\n",
              "      <td>88.39</td>\n",
              "      <td>27</td>\n",
              "      <td>39</td>\n",
              "      <td>4</td>\n",
              "      <td>822</td>\n",
              "      <td>53</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>RG Sharma</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>230</td>\n",
              "      <td>223</td>\n",
              "      <td>32</td>\n",
              "      <td>9283</td>\n",
              "      <td>264</td>\n",
              "      <td>48.60</td>\n",
              "      <td>10428</td>\n",
              "      <td>89.01</td>\n",
              "      <td>29</td>\n",
              "      <td>44</td>\n",
              "      <td>13</td>\n",
              "      <td>845</td>\n",
              "      <td>245</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>LRPL Taylor</td>\n",
              "      <td>NZ</td>\n",
              "      <td>233</td>\n",
              "      <td>217</td>\n",
              "      <td>39</td>\n",
              "      <td>8581</td>\n",
              "      <td>181*</td>\n",
              "      <td>48.20</td>\n",
              "      <td>10287</td>\n",
              "      <td>83.41</td>\n",
              "      <td>21</td>\n",
              "      <td>51</td>\n",
              "      <td>9</td>\n",
              "      <td>712</td>\n",
              "      <td>146</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>77</th>\n",
              "      <td>MEK Hussey</td>\n",
              "      <td>AUS</td>\n",
              "      <td>185</td>\n",
              "      <td>157</td>\n",
              "      <td>44</td>\n",
              "      <td>5442</td>\n",
              "      <td>109*</td>\n",
              "      <td>48.15</td>\n",
              "      <td>6243</td>\n",
              "      <td>87.16</td>\n",
              "      <td>3</td>\n",
              "      <td>39</td>\n",
              "      <td>3</td>\n",
              "      <td>383</td>\n",
              "      <td>80</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>58</th>\n",
              "      <td>KS Williamson</td>\n",
              "      <td>NZ</td>\n",
              "      <td>151</td>\n",
              "      <td>144</td>\n",
              "      <td>14</td>\n",
              "      <td>6173</td>\n",
              "      <td>148</td>\n",
              "      <td>47.48</td>\n",
              "      <td>7551</td>\n",
              "      <td>81.75</td>\n",
              "      <td>13</td>\n",
              "      <td>39</td>\n",
              "      <td>5</td>\n",
              "      <td>563</td>\n",
              "      <td>49</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>10</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        Player_Name Country  Match  Innings  NotOut   Runs Highest_score  \\\n",
              "5          V Kohli    INDIA    260      251      39  12311           183   \n",
              "45        MG Bevan      AUS    232      196      67   6912          108*   \n",
              "16  AB de Villiers       SA    228      218      39   9577           176   \n",
              "60         JE Root      ENG    152      142      23   6109          133*   \n",
              "10        MS Dhoni    INDIA    350      297      84  10773          183*   \n",
              "28         HM Amla       SA    181      178      14   8113           159   \n",
              "19       RG Sharma    INDIA    230      223      32   9283           264   \n",
              "24     LRPL Taylor       NZ    233      217      39   8581          181*   \n",
              "77      MEK Hussey      AUS    185      157      44   5442          109*   \n",
              "58   KS Williamson       NZ    151      144      14   6173           148   \n",
              "\n",
              "    Average  Balls_Faced  Strike_Rate  Centuries  Half_centuries  Ducks Fours  \\\n",
              "5     58.07        13249        92.92         43              64     15  1153   \n",
              "45    53.58         9320        74.16          6              46      5   450   \n",
              "16    53.50         9473       101.09         25              53      7   840   \n",
              "60    51.33         7034        86.84         16              35      5   491   \n",
              "10    50.57        12303        87.56         10              73     10   826   \n",
              "28    49.46         9178        88.39         27              39      4   822   \n",
              "19    48.60        10428        89.01         29              44     13   845   \n",
              "24    48.20        10287        83.41         21              51      9   712   \n",
              "77    48.15         6243        87.16          3              39      3   383   \n",
              "58    47.48         7551        81.75         13              39      5   563   \n",
              "\n",
              "   Sixes played_for_ICC played_for_Asia played_for_Africa  years_played  \n",
              "5    125             No              No                No            14  \n",
              "45    21             No              No                No            10  \n",
              "16   204             No              No               Yes            13  \n",
              "60    44             No              No                No             8  \n",
              "10   229             No             Yes                No            15  \n",
              "28    53             No              No                No            11  \n",
              "19   245             No              No                No            15  \n",
              "24   146             No              No                No            15  \n",
              "77    80             No              No                No             8  \n",
              "58    49             No              No                No            10  "
            ]
          },
          "execution_count": 81,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df.sort_values(by='Average', ascending = False).head(10)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "9XjIBMt5vqwC"
      },
      "source": [
        "#### Top 10 batsmen: Highest number of centuries"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "yL2-N9pbvqwC",
        "outputId": "97490b4d-59e3-4e7c-80c1-736ad13be517"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player_Name</th>\n",
              "      <th>Country</th>\n",
              "      <th>Match</th>\n",
              "      <th>Innings</th>\n",
              "      <th>NotOut</th>\n",
              "      <th>Runs</th>\n",
              "      <th>Highest_score</th>\n",
              "      <th>Average</th>\n",
              "      <th>Balls_Faced</th>\n",
              "      <th>Strike_Rate</th>\n",
              "      <th>Centuries</th>\n",
              "      <th>Half_centuries</th>\n",
              "      <th>Ducks</th>\n",
              "      <th>Fours</th>\n",
              "      <th>Sixes</th>\n",
              "      <th>played_for_ICC</th>\n",
              "      <th>played_for_Asia</th>\n",
              "      <th>played_for_Africa</th>\n",
              "      <th>years_played</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SR Tendulkar</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>463</td>\n",
              "      <td>452</td>\n",
              "      <td>41</td>\n",
              "      <td>18426</td>\n",
              "      <td>200*</td>\n",
              "      <td>44.83</td>\n",
              "      <td>21368</td>\n",
              "      <td>86.23</td>\n",
              "      <td>49</td>\n",
              "      <td>96</td>\n",
              "      <td>20</td>\n",
              "      <td>2016</td>\n",
              "      <td>195</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>V Kohli</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>260</td>\n",
              "      <td>251</td>\n",
              "      <td>39</td>\n",
              "      <td>12311</td>\n",
              "      <td>183</td>\n",
              "      <td>58.07</td>\n",
              "      <td>13249</td>\n",
              "      <td>92.92</td>\n",
              "      <td>43</td>\n",
              "      <td>64</td>\n",
              "      <td>15</td>\n",
              "      <td>1153</td>\n",
              "      <td>125</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>RT Ponting</td>\n",
              "      <td>AUS</td>\n",
              "      <td>375</td>\n",
              "      <td>365</td>\n",
              "      <td>39</td>\n",
              "      <td>13704</td>\n",
              "      <td>164</td>\n",
              "      <td>42.03</td>\n",
              "      <td>17046</td>\n",
              "      <td>80.39</td>\n",
              "      <td>30</td>\n",
              "      <td>82</td>\n",
              "      <td>20</td>\n",
              "      <td>1231</td>\n",
              "      <td>162</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>RG Sharma</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>230</td>\n",
              "      <td>223</td>\n",
              "      <td>32</td>\n",
              "      <td>9283</td>\n",
              "      <td>264</td>\n",
              "      <td>48.60</td>\n",
              "      <td>10428</td>\n",
              "      <td>89.01</td>\n",
              "      <td>29</td>\n",
              "      <td>44</td>\n",
              "      <td>13</td>\n",
              "      <td>845</td>\n",
              "      <td>245</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ST Jayasuriya</td>\n",
              "      <td>SL</td>\n",
              "      <td>445</td>\n",
              "      <td>433</td>\n",
              "      <td>18</td>\n",
              "      <td>13430</td>\n",
              "      <td>189</td>\n",
              "      <td>32.36</td>\n",
              "      <td>14725</td>\n",
              "      <td>91.20</td>\n",
              "      <td>28</td>\n",
              "      <td>68</td>\n",
              "      <td>34</td>\n",
              "      <td>1500</td>\n",
              "      <td>270</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>HM Amla</td>\n",
              "      <td>SA</td>\n",
              "      <td>181</td>\n",
              "      <td>178</td>\n",
              "      <td>14</td>\n",
              "      <td>8113</td>\n",
              "      <td>159</td>\n",
              "      <td>49.46</td>\n",
              "      <td>9178</td>\n",
              "      <td>88.39</td>\n",
              "      <td>27</td>\n",
              "      <td>39</td>\n",
              "      <td>4</td>\n",
              "      <td>822</td>\n",
              "      <td>53</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>11</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>KC Sangakkara</td>\n",
              "      <td>SL</td>\n",
              "      <td>404</td>\n",
              "      <td>380</td>\n",
              "      <td>41</td>\n",
              "      <td>14234</td>\n",
              "      <td>169</td>\n",
              "      <td>41.98</td>\n",
              "      <td>18048</td>\n",
              "      <td>78.86</td>\n",
              "      <td>25</td>\n",
              "      <td>93</td>\n",
              "      <td>15</td>\n",
              "      <td>1385</td>\n",
              "      <td>88</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>CH Gayle</td>\n",
              "      <td>WI</td>\n",
              "      <td>301</td>\n",
              "      <td>294</td>\n",
              "      <td>17</td>\n",
              "      <td>10480</td>\n",
              "      <td>215</td>\n",
              "      <td>37.83</td>\n",
              "      <td>12019</td>\n",
              "      <td>87.19</td>\n",
              "      <td>25</td>\n",
              "      <td>54</td>\n",
              "      <td>25</td>\n",
              "      <td>1128</td>\n",
              "      <td>331</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>AB de Villiers</td>\n",
              "      <td>SA</td>\n",
              "      <td>228</td>\n",
              "      <td>218</td>\n",
              "      <td>39</td>\n",
              "      <td>9577</td>\n",
              "      <td>176</td>\n",
              "      <td>53.50</td>\n",
              "      <td>9473</td>\n",
              "      <td>101.09</td>\n",
              "      <td>25</td>\n",
              "      <td>53</td>\n",
              "      <td>7</td>\n",
              "      <td>840</td>\n",
              "      <td>204</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>SC Ganguly</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>311</td>\n",
              "      <td>300</td>\n",
              "      <td>23</td>\n",
              "      <td>11363</td>\n",
              "      <td>183</td>\n",
              "      <td>41.02</td>\n",
              "      <td>15416</td>\n",
              "      <td>73.70</td>\n",
              "      <td>22</td>\n",
              "      <td>72</td>\n",
              "      <td>16</td>\n",
              "      <td>1122</td>\n",
              "      <td>190</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        Player_Name Country  Match  Innings  NotOut   Runs Highest_score  \\\n",
              "0     SR Tendulkar    INDIA    463      452      41  18426          200*   \n",
              "5          V Kohli    INDIA    260      251      39  12311           183   \n",
              "2       RT Ponting      AUS    375      365      39  13704           164   \n",
              "19       RG Sharma    INDIA    230      223      32   9283           264   \n",
              "3    ST Jayasuriya       SL    445      433      18  13430           189   \n",
              "28         HM Amla       SA    181      178      14   8113           159   \n",
              "1    KC Sangakkara       SL    404      380      41  14234           169   \n",
              "11        CH Gayle       WI    301      294      17  10480           215   \n",
              "16  AB de Villiers       SA    228      218      39   9577           176   \n",
              "8       SC Ganguly    INDIA    311      300      23  11363           183   \n",
              "\n",
              "    Average  Balls_Faced  Strike_Rate  Centuries  Half_centuries  Ducks Fours  \\\n",
              "0     44.83        21368        86.23         49              96     20  2016   \n",
              "5     58.07        13249        92.92         43              64     15  1153   \n",
              "2     42.03        17046        80.39         30              82     20  1231   \n",
              "19    48.60        10428        89.01         29              44     13   845   \n",
              "3     32.36        14725        91.20         28              68     34  1500   \n",
              "28    49.46         9178        88.39         27              39      4   822   \n",
              "1     41.98        18048        78.86         25              93     15  1385   \n",
              "11    37.83        12019        87.19         25              54     25  1128   \n",
              "16    53.50         9473       101.09         25              53      7   840   \n",
              "8     41.02        15416        73.70         22              72     16  1122   \n",
              "\n",
              "   Sixes played_for_ICC played_for_Asia played_for_Africa  years_played  \n",
              "0    195             No              No                No            23  \n",
              "5    125             No              No                No            14  \n",
              "2    162            Yes              No                No            17  \n",
              "19   245             No              No                No            15  \n",
              "3    270             No             Yes                No            22  \n",
              "28    53             No              No                No            11  \n",
              "1     88            Yes             Yes                No            15  \n",
              "11   331            Yes              No                No            20  \n",
              "16   204             No              No               Yes            13  \n",
              "8    190             No             Yes                No            15  "
            ]
          },
          "execution_count": 82,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df.sort_values(by=['Centuries', \"Half_centuries\"], ascending = False).head(10)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "PCZaEWVwvqwC"
      },
      "source": [
        "#### Top 10 batsmen: Highest number of half centuries"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "scrolled": false,
        "id": "Ye-5xBtAvqwD",
        "outputId": "e1603a7d-e246-4c2b-daf8-5d6733f1be16"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player_Name</th>\n",
              "      <th>Country</th>\n",
              "      <th>Match</th>\n",
              "      <th>Innings</th>\n",
              "      <th>NotOut</th>\n",
              "      <th>Runs</th>\n",
              "      <th>Highest_score</th>\n",
              "      <th>Average</th>\n",
              "      <th>Balls_Faced</th>\n",
              "      <th>Strike_Rate</th>\n",
              "      <th>Centuries</th>\n",
              "      <th>Half_centuries</th>\n",
              "      <th>Ducks</th>\n",
              "      <th>Fours</th>\n",
              "      <th>Sixes</th>\n",
              "      <th>played_for_ICC</th>\n",
              "      <th>played_for_Asia</th>\n",
              "      <th>played_for_Africa</th>\n",
              "      <th>years_played</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SR Tendulkar</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>463</td>\n",
              "      <td>452</td>\n",
              "      <td>41</td>\n",
              "      <td>18426</td>\n",
              "      <td>200*</td>\n",
              "      <td>44.83</td>\n",
              "      <td>21368</td>\n",
              "      <td>86.23</td>\n",
              "      <td>49</td>\n",
              "      <td>96</td>\n",
              "      <td>20</td>\n",
              "      <td>2016</td>\n",
              "      <td>195</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>KC Sangakkara</td>\n",
              "      <td>SL</td>\n",
              "      <td>404</td>\n",
              "      <td>380</td>\n",
              "      <td>41</td>\n",
              "      <td>14234</td>\n",
              "      <td>169</td>\n",
              "      <td>41.98</td>\n",
              "      <td>18048</td>\n",
              "      <td>78.86</td>\n",
              "      <td>25</td>\n",
              "      <td>93</td>\n",
              "      <td>15</td>\n",
              "      <td>1385</td>\n",
              "      <td>88</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>JH Kallis</td>\n",
              "      <td>SA</td>\n",
              "      <td>328</td>\n",
              "      <td>314</td>\n",
              "      <td>53</td>\n",
              "      <td>11579</td>\n",
              "      <td>139</td>\n",
              "      <td>44.36</td>\n",
              "      <td>15885</td>\n",
              "      <td>72.89</td>\n",
              "      <td>17</td>\n",
              "      <td>86</td>\n",
              "      <td>17</td>\n",
              "      <td>911</td>\n",
              "      <td>137</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>18</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Inzamam-ul-Haq</td>\n",
              "      <td>PAK</td>\n",
              "      <td>378</td>\n",
              "      <td>350</td>\n",
              "      <td>53</td>\n",
              "      <td>11739</td>\n",
              "      <td>137*</td>\n",
              "      <td>39.52</td>\n",
              "      <td>15812</td>\n",
              "      <td>74.24</td>\n",
              "      <td>10</td>\n",
              "      <td>83</td>\n",
              "      <td>20</td>\n",
              "      <td>971</td>\n",
              "      <td>144</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>R Dravid</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>344</td>\n",
              "      <td>318</td>\n",
              "      <td>40</td>\n",
              "      <td>10889</td>\n",
              "      <td>153</td>\n",
              "      <td>39.16</td>\n",
              "      <td>15285</td>\n",
              "      <td>71.23</td>\n",
              "      <td>12</td>\n",
              "      <td>83</td>\n",
              "      <td>13</td>\n",
              "      <td>950</td>\n",
              "      <td>42</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>RT Ponting</td>\n",
              "      <td>AUS</td>\n",
              "      <td>375</td>\n",
              "      <td>365</td>\n",
              "      <td>39</td>\n",
              "      <td>13704</td>\n",
              "      <td>164</td>\n",
              "      <td>42.03</td>\n",
              "      <td>17046</td>\n",
              "      <td>80.39</td>\n",
              "      <td>30</td>\n",
              "      <td>82</td>\n",
              "      <td>20</td>\n",
              "      <td>1231</td>\n",
              "      <td>162</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>DPMD Jayawardene</td>\n",
              "      <td>SL</td>\n",
              "      <td>448</td>\n",
              "      <td>418</td>\n",
              "      <td>39</td>\n",
              "      <td>12650</td>\n",
              "      <td>144</td>\n",
              "      <td>33.37</td>\n",
              "      <td>16020</td>\n",
              "      <td>78.96</td>\n",
              "      <td>19</td>\n",
              "      <td>77</td>\n",
              "      <td>28</td>\n",
              "      <td>1119</td>\n",
              "      <td>76</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>MS Dhoni</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>350</td>\n",
              "      <td>297</td>\n",
              "      <td>84</td>\n",
              "      <td>10773</td>\n",
              "      <td>183*</td>\n",
              "      <td>50.57</td>\n",
              "      <td>12303</td>\n",
              "      <td>87.56</td>\n",
              "      <td>10</td>\n",
              "      <td>73</td>\n",
              "      <td>10</td>\n",
              "      <td>826</td>\n",
              "      <td>229</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>SC Ganguly</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>311</td>\n",
              "      <td>300</td>\n",
              "      <td>23</td>\n",
              "      <td>11363</td>\n",
              "      <td>183</td>\n",
              "      <td>41.02</td>\n",
              "      <td>15416</td>\n",
              "      <td>73.70</td>\n",
              "      <td>22</td>\n",
              "      <td>72</td>\n",
              "      <td>16</td>\n",
              "      <td>1122</td>\n",
              "      <td>190</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ST Jayasuriya</td>\n",
              "      <td>SL</td>\n",
              "      <td>445</td>\n",
              "      <td>433</td>\n",
              "      <td>18</td>\n",
              "      <td>13430</td>\n",
              "      <td>189</td>\n",
              "      <td>32.36</td>\n",
              "      <td>14725</td>\n",
              "      <td>91.20</td>\n",
              "      <td>28</td>\n",
              "      <td>68</td>\n",
              "      <td>34</td>\n",
              "      <td>1500</td>\n",
              "      <td>270</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          Player_Name Country  Match  Innings  NotOut   Runs Highest_score  \\\n",
              "0       SR Tendulkar    INDIA    463      452      41  18426          200*   \n",
              "1      KC Sangakkara       SL    404      380      41  14234           169   \n",
              "7          JH Kallis       SA    328      314      53  11579           139   \n",
              "6     Inzamam-ul-Haq      PAK    378      350      53  11739          137*   \n",
              "9           R Dravid    INDIA    344      318      40  10889           153   \n",
              "2         RT Ponting      AUS    375      365      39  13704           164   \n",
              "4   DPMD Jayawardene       SL    448      418      39  12650           144   \n",
              "10          MS Dhoni    INDIA    350      297      84  10773          183*   \n",
              "8         SC Ganguly    INDIA    311      300      23  11363           183   \n",
              "3      ST Jayasuriya       SL    445      433      18  13430           189   \n",
              "\n",
              "    Average  Balls_Faced  Strike_Rate  Centuries  Half_centuries  Ducks Fours  \\\n",
              "0     44.83        21368        86.23         49              96     20  2016   \n",
              "1     41.98        18048        78.86         25              93     15  1385   \n",
              "7     44.36        15885        72.89         17              86     17   911   \n",
              "6     39.52        15812        74.24         10              83     20   971   \n",
              "9     39.16        15285        71.23         12              83     13   950   \n",
              "2     42.03        17046        80.39         30              82     20  1231   \n",
              "4     33.37        16020        78.96         19              77     28  1119   \n",
              "10    50.57        12303        87.56         10              73     10   826   \n",
              "8     41.02        15416        73.70         22              72     16  1122   \n",
              "3     32.36        14725        91.20         28              68     34  1500   \n",
              "\n",
              "   Sixes played_for_ICC played_for_Asia played_for_Africa  years_played  \n",
              "0    195             No              No                No            23  \n",
              "1     88            Yes             Yes                No            15  \n",
              "7    137            Yes              No               Yes            18  \n",
              "6    144             No             Yes                No            16  \n",
              "9     42            Yes             Yes                No            15  \n",
              "2    162            Yes              No                No            17  \n",
              "4     76             No             Yes                No            17  \n",
              "10   229             No             Yes                No            15  \n",
              "8    190             No             Yes                No            15  \n",
              "3    270             No             Yes                No            22  "
            ]
          },
          "execution_count": 83,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df.sort_values(by=\"Half_centuries\", ascending = False).head(10)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "fFubXTzsvqwD"
      },
      "source": [
        "#### Top 10 batsmen: Highest number of years played"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "I27GT2m7vqwD",
        "outputId": "7216e8f5-957b-47f9-cfaa-21afb9af4f5c"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player_Name</th>\n",
              "      <th>Country</th>\n",
              "      <th>Match</th>\n",
              "      <th>Innings</th>\n",
              "      <th>NotOut</th>\n",
              "      <th>Runs</th>\n",
              "      <th>Highest_score</th>\n",
              "      <th>Average</th>\n",
              "      <th>Balls_Faced</th>\n",
              "      <th>Strike_Rate</th>\n",
              "      <th>Centuries</th>\n",
              "      <th>Half_centuries</th>\n",
              "      <th>Ducks</th>\n",
              "      <th>Fours</th>\n",
              "      <th>Sixes</th>\n",
              "      <th>played_for_ICC</th>\n",
              "      <th>played_for_Asia</th>\n",
              "      <th>played_for_Africa</th>\n",
              "      <th>years_played</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SR Tendulkar</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>463</td>\n",
              "      <td>452</td>\n",
              "      <td>41</td>\n",
              "      <td>18426</td>\n",
              "      <td>200*</td>\n",
              "      <td>44.83</td>\n",
              "      <td>21368</td>\n",
              "      <td>86.23</td>\n",
              "      <td>49</td>\n",
              "      <td>96</td>\n",
              "      <td>20</td>\n",
              "      <td>2016</td>\n",
              "      <td>195</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ST Jayasuriya</td>\n",
              "      <td>SL</td>\n",
              "      <td>445</td>\n",
              "      <td>433</td>\n",
              "      <td>18</td>\n",
              "      <td>13430</td>\n",
              "      <td>189</td>\n",
              "      <td>32.36</td>\n",
              "      <td>14725</td>\n",
              "      <td>91.20</td>\n",
              "      <td>28</td>\n",
              "      <td>68</td>\n",
              "      <td>34</td>\n",
              "      <td>1500</td>\n",
              "      <td>270</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>Javed Miandad</td>\n",
              "      <td>PAK</td>\n",
              "      <td>233</td>\n",
              "      <td>218</td>\n",
              "      <td>41</td>\n",
              "      <td>7381</td>\n",
              "      <td>119*</td>\n",
              "      <td>41.70</td>\n",
              "      <td>11014</td>\n",
              "      <td>67.01</td>\n",
              "      <td>8</td>\n",
              "      <td>50</td>\n",
              "      <td>8</td>\n",
              "      <td>445+</td>\n",
              "      <td>44+</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>21</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>Shoaib Malik</td>\n",
              "      <td>PAK</td>\n",
              "      <td>287</td>\n",
              "      <td>258</td>\n",
              "      <td>40</td>\n",
              "      <td>7534</td>\n",
              "      <td>143</td>\n",
              "      <td>34.55</td>\n",
              "      <td>9199</td>\n",
              "      <td>81.90</td>\n",
              "      <td>9</td>\n",
              "      <td>44</td>\n",
              "      <td>15</td>\n",
              "      <td>603</td>\n",
              "      <td>113</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>CH Gayle</td>\n",
              "      <td>WI</td>\n",
              "      <td>301</td>\n",
              "      <td>294</td>\n",
              "      <td>17</td>\n",
              "      <td>10480</td>\n",
              "      <td>215</td>\n",
              "      <td>37.83</td>\n",
              "      <td>12019</td>\n",
              "      <td>87.19</td>\n",
              "      <td>25</td>\n",
              "      <td>54</td>\n",
              "      <td>25</td>\n",
              "      <td>1128</td>\n",
              "      <td>331</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>Shahid Afridi</td>\n",
              "      <td>PAK</td>\n",
              "      <td>398</td>\n",
              "      <td>369</td>\n",
              "      <td>27</td>\n",
              "      <td>8064</td>\n",
              "      <td>124</td>\n",
              "      <td>23.57</td>\n",
              "      <td>6892</td>\n",
              "      <td>117.00</td>\n",
              "      <td>6</td>\n",
              "      <td>39</td>\n",
              "      <td>30</td>\n",
              "      <td>730</td>\n",
              "      <td>351</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>PA de Silva</td>\n",
              "      <td>SL</td>\n",
              "      <td>308</td>\n",
              "      <td>296</td>\n",
              "      <td>30</td>\n",
              "      <td>9284</td>\n",
              "      <td>145</td>\n",
              "      <td>34.90</td>\n",
              "      <td>11443</td>\n",
              "      <td>81.13</td>\n",
              "      <td>11</td>\n",
              "      <td>64</td>\n",
              "      <td>17</td>\n",
              "      <td>712+</td>\n",
              "      <td>102+</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>73</th>\n",
              "      <td>MN Samuels</td>\n",
              "      <td>WI</td>\n",
              "      <td>207</td>\n",
              "      <td>196</td>\n",
              "      <td>26</td>\n",
              "      <td>5606</td>\n",
              "      <td>133*</td>\n",
              "      <td>32.97</td>\n",
              "      <td>7463</td>\n",
              "      <td>75.11</td>\n",
              "      <td>10</td>\n",
              "      <td>30</td>\n",
              "      <td>11</td>\n",
              "      <td>526</td>\n",
              "      <td>118</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>18</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>JH Kallis</td>\n",
              "      <td>SA</td>\n",
              "      <td>328</td>\n",
              "      <td>314</td>\n",
              "      <td>53</td>\n",
              "      <td>11579</td>\n",
              "      <td>139</td>\n",
              "      <td>44.36</td>\n",
              "      <td>15885</td>\n",
              "      <td>72.89</td>\n",
              "      <td>17</td>\n",
              "      <td>86</td>\n",
              "      <td>17</td>\n",
              "      <td>911</td>\n",
              "      <td>137</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>18</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>53</th>\n",
              "      <td>GW Flower</td>\n",
              "      <td>ZIM</td>\n",
              "      <td>221</td>\n",
              "      <td>214</td>\n",
              "      <td>18</td>\n",
              "      <td>6571</td>\n",
              "      <td>142*</td>\n",
              "      <td>33.52</td>\n",
              "      <td>9723</td>\n",
              "      <td>67.58</td>\n",
              "      <td>6</td>\n",
              "      <td>40</td>\n",
              "      <td>18</td>\n",
              "      <td>557+</td>\n",
              "      <td>37+</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>18</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       Player_Name Country  Match  Innings  NotOut   Runs Highest_score  \\\n",
              "0    SR Tendulkar    INDIA    463      452      41  18426          200*   \n",
              "3   ST Jayasuriya       SL    445      433      18  13430           189   \n",
              "38  Javed Miandad      PAK    233      218      41   7381          119*   \n",
              "36   Shoaib Malik      PAK    287      258      40   7534           143   \n",
              "11       CH Gayle       WI    301      294      17  10480           215   \n",
              "30  Shahid Afridi      PAK    398      369      27   8064           124   \n",
              "18    PA de Silva       SL    308      296      30   9284           145   \n",
              "73     MN Samuels       WI    207      196      26   5606          133*   \n",
              "7       JH Kallis       SA    328      314      53  11579           139   \n",
              "53      GW Flower      ZIM    221      214      18   6571          142*   \n",
              "\n",
              "    Average  Balls_Faced  Strike_Rate  Centuries  Half_centuries  Ducks Fours  \\\n",
              "0     44.83        21368        86.23         49              96     20  2016   \n",
              "3     32.36        14725        91.20         28              68     34  1500   \n",
              "38    41.70        11014        67.01          8              50      8  445+   \n",
              "36    34.55         9199        81.90          9              44     15   603   \n",
              "11    37.83        12019        87.19         25              54     25  1128   \n",
              "30    23.57         6892       117.00          6              39     30   730   \n",
              "18    34.90        11443        81.13         11              64     17  712+   \n",
              "73    32.97         7463        75.11         10              30     11   526   \n",
              "7     44.36        15885        72.89         17              86     17   911   \n",
              "53    33.52         9723        67.58          6              40     18  557+   \n",
              "\n",
              "   Sixes played_for_ICC played_for_Asia played_for_Africa  years_played  \n",
              "0    195             No              No                No            23  \n",
              "3    270             No             Yes                No            22  \n",
              "38   44+             No              No                No            21  \n",
              "36   113             No              No                No            20  \n",
              "11   331            Yes              No                No            20  \n",
              "30   351            Yes             Yes                No            19  \n",
              "18  102+             No              No                No            19  \n",
              "73   118             No              No                No            18  \n",
              "7    137            Yes              No               Yes            18  \n",
              "53   37+             No              No                No            18  "
            ]
          },
          "execution_count": 84,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df.sort_values(by=\"years_played\", ascending = False).head(10)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "KbVqXwqzvqwD"
      },
      "source": [
        "#### Top 10 batsmen: Highest number of matches played"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "88N5K7mnvqwE",
        "outputId": "25bcf98d-03f9-4aad-a834-7b57aa8935cb"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player_Name</th>\n",
              "      <th>Country</th>\n",
              "      <th>Match</th>\n",
              "      <th>Innings</th>\n",
              "      <th>NotOut</th>\n",
              "      <th>Runs</th>\n",
              "      <th>Highest_score</th>\n",
              "      <th>Average</th>\n",
              "      <th>Balls_Faced</th>\n",
              "      <th>Strike_Rate</th>\n",
              "      <th>Centuries</th>\n",
              "      <th>Half_centuries</th>\n",
              "      <th>Ducks</th>\n",
              "      <th>Fours</th>\n",
              "      <th>Sixes</th>\n",
              "      <th>played_for_ICC</th>\n",
              "      <th>played_for_Asia</th>\n",
              "      <th>played_for_Africa</th>\n",
              "      <th>years_played</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SR Tendulkar</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>463</td>\n",
              "      <td>452</td>\n",
              "      <td>41</td>\n",
              "      <td>18426</td>\n",
              "      <td>200*</td>\n",
              "      <td>44.83</td>\n",
              "      <td>21368</td>\n",
              "      <td>86.23</td>\n",
              "      <td>49</td>\n",
              "      <td>96</td>\n",
              "      <td>20</td>\n",
              "      <td>2016</td>\n",
              "      <td>195</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>DPMD Jayawardene</td>\n",
              "      <td>SL</td>\n",
              "      <td>448</td>\n",
              "      <td>418</td>\n",
              "      <td>39</td>\n",
              "      <td>12650</td>\n",
              "      <td>144</td>\n",
              "      <td>33.37</td>\n",
              "      <td>16020</td>\n",
              "      <td>78.96</td>\n",
              "      <td>19</td>\n",
              "      <td>77</td>\n",
              "      <td>28</td>\n",
              "      <td>1119</td>\n",
              "      <td>76</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ST Jayasuriya</td>\n",
              "      <td>SL</td>\n",
              "      <td>445</td>\n",
              "      <td>433</td>\n",
              "      <td>18</td>\n",
              "      <td>13430</td>\n",
              "      <td>189</td>\n",
              "      <td>32.36</td>\n",
              "      <td>14725</td>\n",
              "      <td>91.20</td>\n",
              "      <td>28</td>\n",
              "      <td>68</td>\n",
              "      <td>34</td>\n",
              "      <td>1500</td>\n",
              "      <td>270</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>KC Sangakkara</td>\n",
              "      <td>SL</td>\n",
              "      <td>404</td>\n",
              "      <td>380</td>\n",
              "      <td>41</td>\n",
              "      <td>14234</td>\n",
              "      <td>169</td>\n",
              "      <td>41.98</td>\n",
              "      <td>18048</td>\n",
              "      <td>78.86</td>\n",
              "      <td>25</td>\n",
              "      <td>93</td>\n",
              "      <td>15</td>\n",
              "      <td>1385</td>\n",
              "      <td>88</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>Shahid Afridi</td>\n",
              "      <td>PAK</td>\n",
              "      <td>398</td>\n",
              "      <td>369</td>\n",
              "      <td>27</td>\n",
              "      <td>8064</td>\n",
              "      <td>124</td>\n",
              "      <td>23.57</td>\n",
              "      <td>6892</td>\n",
              "      <td>117.00</td>\n",
              "      <td>6</td>\n",
              "      <td>39</td>\n",
              "      <td>30</td>\n",
              "      <td>730</td>\n",
              "      <td>351</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>19</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Inzamam-ul-Haq</td>\n",
              "      <td>PAK</td>\n",
              "      <td>378</td>\n",
              "      <td>350</td>\n",
              "      <td>53</td>\n",
              "      <td>11739</td>\n",
              "      <td>137*</td>\n",
              "      <td>39.52</td>\n",
              "      <td>15812</td>\n",
              "      <td>74.24</td>\n",
              "      <td>10</td>\n",
              "      <td>83</td>\n",
              "      <td>20</td>\n",
              "      <td>971</td>\n",
              "      <td>144</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>RT Ponting</td>\n",
              "      <td>AUS</td>\n",
              "      <td>375</td>\n",
              "      <td>365</td>\n",
              "      <td>39</td>\n",
              "      <td>13704</td>\n",
              "      <td>164</td>\n",
              "      <td>42.03</td>\n",
              "      <td>17046</td>\n",
              "      <td>80.39</td>\n",
              "      <td>30</td>\n",
              "      <td>82</td>\n",
              "      <td>20</td>\n",
              "      <td>1231</td>\n",
              "      <td>162</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>MS Dhoni</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>350</td>\n",
              "      <td>297</td>\n",
              "      <td>84</td>\n",
              "      <td>10773</td>\n",
              "      <td>183*</td>\n",
              "      <td>50.57</td>\n",
              "      <td>12303</td>\n",
              "      <td>87.56</td>\n",
              "      <td>10</td>\n",
              "      <td>73</td>\n",
              "      <td>10</td>\n",
              "      <td>826</td>\n",
              "      <td>229</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>R Dravid</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>344</td>\n",
              "      <td>318</td>\n",
              "      <td>40</td>\n",
              "      <td>10889</td>\n",
              "      <td>153</td>\n",
              "      <td>39.16</td>\n",
              "      <td>15285</td>\n",
              "      <td>71.23</td>\n",
              "      <td>12</td>\n",
              "      <td>83</td>\n",
              "      <td>13</td>\n",
              "      <td>950</td>\n",
              "      <td>42</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>M Azharuddin</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>334</td>\n",
              "      <td>308</td>\n",
              "      <td>54</td>\n",
              "      <td>9378</td>\n",
              "      <td>153*</td>\n",
              "      <td>36.92</td>\n",
              "      <td>12669</td>\n",
              "      <td>74.02</td>\n",
              "      <td>7</td>\n",
              "      <td>58</td>\n",
              "      <td>9</td>\n",
              "      <td>622+</td>\n",
              "      <td>77+</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "          Player_Name Country  Match  Innings  NotOut   Runs Highest_score  \\\n",
              "0       SR Tendulkar    INDIA    463      452      41  18426          200*   \n",
              "4   DPMD Jayawardene       SL    448      418      39  12650           144   \n",
              "3      ST Jayasuriya       SL    445      433      18  13430           189   \n",
              "1      KC Sangakkara       SL    404      380      41  14234           169   \n",
              "30     Shahid Afridi      PAK    398      369      27   8064           124   \n",
              "6     Inzamam-ul-Haq      PAK    378      350      53  11739          137*   \n",
              "2         RT Ponting      AUS    375      365      39  13704           164   \n",
              "10          MS Dhoni    INDIA    350      297      84  10773          183*   \n",
              "9           R Dravid    INDIA    344      318      40  10889           153   \n",
              "17      M Azharuddin    INDIA    334      308      54   9378          153*   \n",
              "\n",
              "    Average  Balls_Faced  Strike_Rate  Centuries  Half_centuries  Ducks Fours  \\\n",
              "0     44.83        21368        86.23         49              96     20  2016   \n",
              "4     33.37        16020        78.96         19              77     28  1119   \n",
              "3     32.36        14725        91.20         28              68     34  1500   \n",
              "1     41.98        18048        78.86         25              93     15  1385   \n",
              "30    23.57         6892       117.00          6              39     30   730   \n",
              "6     39.52        15812        74.24         10              83     20   971   \n",
              "2     42.03        17046        80.39         30              82     20  1231   \n",
              "10    50.57        12303        87.56         10              73     10   826   \n",
              "9     39.16        15285        71.23         12              83     13   950   \n",
              "17    36.92        12669        74.02          7              58      9  622+   \n",
              "\n",
              "   Sixes played_for_ICC played_for_Asia played_for_Africa  years_played  \n",
              "0    195             No              No                No            23  \n",
              "4     76             No             Yes                No            17  \n",
              "3    270             No             Yes                No            22  \n",
              "1     88            Yes             Yes                No            15  \n",
              "30   351            Yes             Yes                No            19  \n",
              "6    144             No             Yes                No            16  \n",
              "2    162            Yes              No                No            17  \n",
              "10   229             No             Yes                No            15  \n",
              "9     42            Yes             Yes                No            15  \n",
              "17   77+             No              No                No            15  "
            ]
          },
          "execution_count": 85,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df.sort_values(by=\"Match\", ascending = False).head(10)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "pn2fZXabvqwE",
        "outputId": "b8c3ecfc-b3ab-4ea4-cf64-8f099543c54e"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player_Name</th>\n",
              "      <th>Country</th>\n",
              "      <th>Match</th>\n",
              "      <th>Innings</th>\n",
              "      <th>NotOut</th>\n",
              "      <th>Runs</th>\n",
              "      <th>Highest_score</th>\n",
              "      <th>Average</th>\n",
              "      <th>Balls_Faced</th>\n",
              "      <th>Strike_Rate</th>\n",
              "      <th>Centuries</th>\n",
              "      <th>Half_centuries</th>\n",
              "      <th>Ducks</th>\n",
              "      <th>Fours</th>\n",
              "      <th>Sixes</th>\n",
              "      <th>played_for_ICC</th>\n",
              "      <th>played_for_Asia</th>\n",
              "      <th>played_for_Africa</th>\n",
              "      <th>years_played</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SR Tendulkar</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>463</td>\n",
              "      <td>452</td>\n",
              "      <td>41</td>\n",
              "      <td>18426</td>\n",
              "      <td>200*</td>\n",
              "      <td>44.83</td>\n",
              "      <td>21368</td>\n",
              "      <td>86.23</td>\n",
              "      <td>49</td>\n",
              "      <td>96</td>\n",
              "      <td>20</td>\n",
              "      <td>2016</td>\n",
              "      <td>195</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>KC Sangakkara</td>\n",
              "      <td>SL</td>\n",
              "      <td>404</td>\n",
              "      <td>380</td>\n",
              "      <td>41</td>\n",
              "      <td>14234</td>\n",
              "      <td>169</td>\n",
              "      <td>41.98</td>\n",
              "      <td>18048</td>\n",
              "      <td>78.86</td>\n",
              "      <td>25</td>\n",
              "      <td>93</td>\n",
              "      <td>15</td>\n",
              "      <td>1385</td>\n",
              "      <td>88</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>RT Ponting</td>\n",
              "      <td>AUS</td>\n",
              "      <td>375</td>\n",
              "      <td>365</td>\n",
              "      <td>39</td>\n",
              "      <td>13704</td>\n",
              "      <td>164</td>\n",
              "      <td>42.03</td>\n",
              "      <td>17046</td>\n",
              "      <td>80.39</td>\n",
              "      <td>30</td>\n",
              "      <td>82</td>\n",
              "      <td>20</td>\n",
              "      <td>1231</td>\n",
              "      <td>162</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ST Jayasuriya</td>\n",
              "      <td>SL</td>\n",
              "      <td>445</td>\n",
              "      <td>433</td>\n",
              "      <td>18</td>\n",
              "      <td>13430</td>\n",
              "      <td>189</td>\n",
              "      <td>32.36</td>\n",
              "      <td>14725</td>\n",
              "      <td>91.20</td>\n",
              "      <td>28</td>\n",
              "      <td>68</td>\n",
              "      <td>34</td>\n",
              "      <td>1500</td>\n",
              "      <td>270</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>DPMD Jayawardene</td>\n",
              "      <td>SL</td>\n",
              "      <td>448</td>\n",
              "      <td>418</td>\n",
              "      <td>39</td>\n",
              "      <td>12650</td>\n",
              "      <td>144</td>\n",
              "      <td>33.37</td>\n",
              "      <td>16020</td>\n",
              "      <td>78.96</td>\n",
              "      <td>19</td>\n",
              "      <td>77</td>\n",
              "      <td>28</td>\n",
              "      <td>1119</td>\n",
              "      <td>76</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>V Kohli</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>260</td>\n",
              "      <td>251</td>\n",
              "      <td>39</td>\n",
              "      <td>12311</td>\n",
              "      <td>183</td>\n",
              "      <td>58.07</td>\n",
              "      <td>13249</td>\n",
              "      <td>92.92</td>\n",
              "      <td>43</td>\n",
              "      <td>64</td>\n",
              "      <td>15</td>\n",
              "      <td>1153</td>\n",
              "      <td>125</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Inzamam-ul-Haq</td>\n",
              "      <td>PAK</td>\n",
              "      <td>378</td>\n",
              "      <td>350</td>\n",
              "      <td>53</td>\n",
              "      <td>11739</td>\n",
              "      <td>137*</td>\n",
              "      <td>39.52</td>\n",
              "      <td>15812</td>\n",
              "      <td>74.24</td>\n",
              "      <td>10</td>\n",
              "      <td>83</td>\n",
              "      <td>20</td>\n",
              "      <td>971</td>\n",
              "      <td>144</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>JH Kallis</td>\n",
              "      <td>SA</td>\n",
              "      <td>328</td>\n",
              "      <td>314</td>\n",
              "      <td>53</td>\n",
              "      <td>11579</td>\n",
              "      <td>139</td>\n",
              "      <td>44.36</td>\n",
              "      <td>15885</td>\n",
              "      <td>72.89</td>\n",
              "      <td>17</td>\n",
              "      <td>86</td>\n",
              "      <td>17</td>\n",
              "      <td>911</td>\n",
              "      <td>137</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>18</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>SC Ganguly</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>311</td>\n",
              "      <td>300</td>\n",
              "      <td>23</td>\n",
              "      <td>11363</td>\n",
              "      <td>183</td>\n",
              "      <td>41.02</td>\n",
              "      <td>15416</td>\n",
              "      <td>73.70</td>\n",
              "      <td>22</td>\n",
              "      <td>72</td>\n",
              "      <td>16</td>\n",
              "      <td>1122</td>\n",
              "      <td>190</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>R Dravid</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>344</td>\n",
              "      <td>318</td>\n",
              "      <td>40</td>\n",
              "      <td>10889</td>\n",
              "      <td>153</td>\n",
              "      <td>39.16</td>\n",
              "      <td>15285</td>\n",
              "      <td>71.23</td>\n",
              "      <td>12</td>\n",
              "      <td>83</td>\n",
              "      <td>13</td>\n",
              "      <td>950</td>\n",
              "      <td>42</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         Player_Name Country  Match  Innings  NotOut   Runs Highest_score  \\\n",
              "0      SR Tendulkar    INDIA    463      452      41  18426          200*   \n",
              "1     KC Sangakkara       SL    404      380      41  14234           169   \n",
              "2        RT Ponting      AUS    375      365      39  13704           164   \n",
              "3     ST Jayasuriya       SL    445      433      18  13430           189   \n",
              "4  DPMD Jayawardene       SL    448      418      39  12650           144   \n",
              "5           V Kohli    INDIA    260      251      39  12311           183   \n",
              "6    Inzamam-ul-Haq      PAK    378      350      53  11739          137*   \n",
              "7         JH Kallis       SA    328      314      53  11579           139   \n",
              "8        SC Ganguly    INDIA    311      300      23  11363           183   \n",
              "9          R Dravid    INDIA    344      318      40  10889           153   \n",
              "\n",
              "   Average  Balls_Faced  Strike_Rate  Centuries  Half_centuries  Ducks Fours  \\\n",
              "0    44.83        21368        86.23         49              96     20  2016   \n",
              "1    41.98        18048        78.86         25              93     15  1385   \n",
              "2    42.03        17046        80.39         30              82     20  1231   \n",
              "3    32.36        14725        91.20         28              68     34  1500   \n",
              "4    33.37        16020        78.96         19              77     28  1119   \n",
              "5    58.07        13249        92.92         43              64     15  1153   \n",
              "6    39.52        15812        74.24         10              83     20   971   \n",
              "7    44.36        15885        72.89         17              86     17   911   \n",
              "8    41.02        15416        73.70         22              72     16  1122   \n",
              "9    39.16        15285        71.23         12              83     13   950   \n",
              "\n",
              "  Sixes played_for_ICC played_for_Asia played_for_Africa  years_played  \n",
              "0   195             No              No                No            23  \n",
              "1    88            Yes             Yes                No            15  \n",
              "2   162            Yes              No                No            17  \n",
              "3   270             No             Yes                No            22  \n",
              "4    76             No             Yes                No            17  \n",
              "5   125             No              No                No            14  \n",
              "6   144             No             Yes                No            16  \n",
              "7   137            Yes              No               Yes            18  \n",
              "8   190             No             Yes                No            15  \n",
              "9    42            Yes             Yes                No            15  "
            ]
          },
          "metadata": {},
          "output_type": "display_data"
        }
      ],
      "source": [
        "display(df.head(10))"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "zoG9CGm7vqwE"
      },
      "source": [
        "#### Removing the * symbol from the Highest_Score column"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "u0NZtDQ2vqwE",
        "outputId": "73399a01-0fbb-4b77-9bd9-347e53b324f8"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player_Name</th>\n",
              "      <th>Country</th>\n",
              "      <th>Match</th>\n",
              "      <th>Innings</th>\n",
              "      <th>NotOut</th>\n",
              "      <th>Runs</th>\n",
              "      <th>Highest_score</th>\n",
              "      <th>Average</th>\n",
              "      <th>Balls_Faced</th>\n",
              "      <th>Strike_Rate</th>\n",
              "      <th>Centuries</th>\n",
              "      <th>Half_centuries</th>\n",
              "      <th>Ducks</th>\n",
              "      <th>Fours</th>\n",
              "      <th>Sixes</th>\n",
              "      <th>played_for_ICC</th>\n",
              "      <th>played_for_Asia</th>\n",
              "      <th>played_for_Africa</th>\n",
              "      <th>years_played</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SR Tendulkar</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>463</td>\n",
              "      <td>452</td>\n",
              "      <td>41</td>\n",
              "      <td>18426</td>\n",
              "      <td>200</td>\n",
              "      <td>44.83</td>\n",
              "      <td>21368</td>\n",
              "      <td>86.23</td>\n",
              "      <td>49</td>\n",
              "      <td>96</td>\n",
              "      <td>20</td>\n",
              "      <td>2016</td>\n",
              "      <td>195</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>KC Sangakkara</td>\n",
              "      <td>SL</td>\n",
              "      <td>404</td>\n",
              "      <td>380</td>\n",
              "      <td>41</td>\n",
              "      <td>14234</td>\n",
              "      <td>169</td>\n",
              "      <td>41.98</td>\n",
              "      <td>18048</td>\n",
              "      <td>78.86</td>\n",
              "      <td>25</td>\n",
              "      <td>93</td>\n",
              "      <td>15</td>\n",
              "      <td>1385</td>\n",
              "      <td>88</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>RT Ponting</td>\n",
              "      <td>AUS</td>\n",
              "      <td>375</td>\n",
              "      <td>365</td>\n",
              "      <td>39</td>\n",
              "      <td>13704</td>\n",
              "      <td>164</td>\n",
              "      <td>42.03</td>\n",
              "      <td>17046</td>\n",
              "      <td>80.39</td>\n",
              "      <td>30</td>\n",
              "      <td>82</td>\n",
              "      <td>20</td>\n",
              "      <td>1231</td>\n",
              "      <td>162</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ST Jayasuriya</td>\n",
              "      <td>SL</td>\n",
              "      <td>445</td>\n",
              "      <td>433</td>\n",
              "      <td>18</td>\n",
              "      <td>13430</td>\n",
              "      <td>189</td>\n",
              "      <td>32.36</td>\n",
              "      <td>14725</td>\n",
              "      <td>91.20</td>\n",
              "      <td>28</td>\n",
              "      <td>68</td>\n",
              "      <td>34</td>\n",
              "      <td>1500</td>\n",
              "      <td>270</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>DPMD Jayawardene</td>\n",
              "      <td>SL</td>\n",
              "      <td>448</td>\n",
              "      <td>418</td>\n",
              "      <td>39</td>\n",
              "      <td>12650</td>\n",
              "      <td>144</td>\n",
              "      <td>33.37</td>\n",
              "      <td>16020</td>\n",
              "      <td>78.96</td>\n",
              "      <td>19</td>\n",
              "      <td>77</td>\n",
              "      <td>28</td>\n",
              "      <td>1119</td>\n",
              "      <td>76</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>V Kohli</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>260</td>\n",
              "      <td>251</td>\n",
              "      <td>39</td>\n",
              "      <td>12311</td>\n",
              "      <td>183</td>\n",
              "      <td>58.07</td>\n",
              "      <td>13249</td>\n",
              "      <td>92.92</td>\n",
              "      <td>43</td>\n",
              "      <td>64</td>\n",
              "      <td>15</td>\n",
              "      <td>1153</td>\n",
              "      <td>125</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Inzamam-ul-Haq</td>\n",
              "      <td>PAK</td>\n",
              "      <td>378</td>\n",
              "      <td>350</td>\n",
              "      <td>53</td>\n",
              "      <td>11739</td>\n",
              "      <td>137</td>\n",
              "      <td>39.52</td>\n",
              "      <td>15812</td>\n",
              "      <td>74.24</td>\n",
              "      <td>10</td>\n",
              "      <td>83</td>\n",
              "      <td>20</td>\n",
              "      <td>971</td>\n",
              "      <td>144</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>JH Kallis</td>\n",
              "      <td>SA</td>\n",
              "      <td>328</td>\n",
              "      <td>314</td>\n",
              "      <td>53</td>\n",
              "      <td>11579</td>\n",
              "      <td>139</td>\n",
              "      <td>44.36</td>\n",
              "      <td>15885</td>\n",
              "      <td>72.89</td>\n",
              "      <td>17</td>\n",
              "      <td>86</td>\n",
              "      <td>17</td>\n",
              "      <td>911</td>\n",
              "      <td>137</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>18</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>SC Ganguly</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>311</td>\n",
              "      <td>300</td>\n",
              "      <td>23</td>\n",
              "      <td>11363</td>\n",
              "      <td>183</td>\n",
              "      <td>41.02</td>\n",
              "      <td>15416</td>\n",
              "      <td>73.70</td>\n",
              "      <td>22</td>\n",
              "      <td>72</td>\n",
              "      <td>16</td>\n",
              "      <td>1122</td>\n",
              "      <td>190</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>R Dravid</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>344</td>\n",
              "      <td>318</td>\n",
              "      <td>40</td>\n",
              "      <td>10889</td>\n",
              "      <td>153</td>\n",
              "      <td>39.16</td>\n",
              "      <td>15285</td>\n",
              "      <td>71.23</td>\n",
              "      <td>12</td>\n",
              "      <td>83</td>\n",
              "      <td>13</td>\n",
              "      <td>950</td>\n",
              "      <td>42</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "         Player_Name Country  Match  Innings  NotOut   Runs  Highest_score  \\\n",
              "0      SR Tendulkar    INDIA    463      452      41  18426            200   \n",
              "1     KC Sangakkara       SL    404      380      41  14234            169   \n",
              "2        RT Ponting      AUS    375      365      39  13704            164   \n",
              "3     ST Jayasuriya       SL    445      433      18  13430            189   \n",
              "4  DPMD Jayawardene       SL    448      418      39  12650            144   \n",
              "5           V Kohli    INDIA    260      251      39  12311            183   \n",
              "6    Inzamam-ul-Haq      PAK    378      350      53  11739            137   \n",
              "7         JH Kallis       SA    328      314      53  11579            139   \n",
              "8        SC Ganguly    INDIA    311      300      23  11363            183   \n",
              "9          R Dravid    INDIA    344      318      40  10889            153   \n",
              "\n",
              "   Average  Balls_Faced  Strike_Rate  Centuries  Half_centuries  Ducks Fours  \\\n",
              "0    44.83        21368        86.23         49              96     20  2016   \n",
              "1    41.98        18048        78.86         25              93     15  1385   \n",
              "2    42.03        17046        80.39         30              82     20  1231   \n",
              "3    32.36        14725        91.20         28              68     34  1500   \n",
              "4    33.37        16020        78.96         19              77     28  1119   \n",
              "5    58.07        13249        92.92         43              64     15  1153   \n",
              "6    39.52        15812        74.24         10              83     20   971   \n",
              "7    44.36        15885        72.89         17              86     17   911   \n",
              "8    41.02        15416        73.70         22              72     16  1122   \n",
              "9    39.16        15285        71.23         12              83     13   950   \n",
              "\n",
              "  Sixes played_for_ICC played_for_Asia played_for_Africa  years_played  \n",
              "0   195             No              No                No            23  \n",
              "1    88            Yes             Yes                No            15  \n",
              "2   162            Yes              No                No            17  \n",
              "3   270             No             Yes                No            22  \n",
              "4    76             No             Yes                No            17  \n",
              "5   125             No              No                No            14  \n",
              "6   144             No             Yes                No            16  \n",
              "7   137            Yes              No               Yes            18  \n",
              "8   190             No             Yes                No            15  \n",
              "9    42            Yes             Yes                No            15  "
            ]
          },
          "metadata": {},
          "output_type": "display_data"
        },
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 92 entries, 0 to 91\n",
            "Data columns (total 19 columns):\n",
            " #   Column             Non-Null Count  Dtype  \n",
            "---  ------             --------------  -----  \n",
            " 0   Player_Name        92 non-null     object \n",
            " 1   Country            92 non-null     object \n",
            " 2   Match              92 non-null     int64  \n",
            " 3   Innings            92 non-null     int64  \n",
            " 4   NotOut             92 non-null     int64  \n",
            " 5   Runs               92 non-null     int64  \n",
            " 6   Highest_score      92 non-null     int32  \n",
            " 7   Average            92 non-null     float64\n",
            " 8   Balls_Faced        92 non-null     int64  \n",
            " 9   Strike_Rate        92 non-null     float64\n",
            " 10  Centuries          92 non-null     int64  \n",
            " 11  Half_centuries     92 non-null     int64  \n",
            " 12  Ducks              92 non-null     int64  \n",
            " 13  Fours              92 non-null     object \n",
            " 14  Sixes              92 non-null     object \n",
            " 15  played_for_ICC     92 non-null     object \n",
            " 16  played_for_Asia    92 non-null     object \n",
            " 17  played_for_Africa  92 non-null     object \n",
            " 18  years_played       92 non-null     int32  \n",
            "dtypes: float64(2), int32(2), int64(8), object(7)\n",
            "memory usage: 13.1+ KB\n",
            "None\n"
          ]
        }
      ],
      "source": [
        "def star_remover(x):\n",
        "    x = str(x)\n",
        "    if \"*\" in x:\n",
        "        return x.replace(\"*\", \"\")\n",
        "    else:\n",
        "        return x\n",
        "\n",
        "df['Highest_score'] = df['Highest_score'].apply(star_remover)\n",
        "df['Highest_score'] = df['Highest_score'].astype('int')\n",
        "\n",
        "display(df.head(10))\n",
        "print(df.info())"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "8fqkYXRCvqwE",
        "outputId": "45cda183-8788-42ff-b3f4-0da6a6142ae5"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Player_Name</th>\n",
              "      <th>Country</th>\n",
              "      <th>Match</th>\n",
              "      <th>Innings</th>\n",
              "      <th>NotOut</th>\n",
              "      <th>Runs</th>\n",
              "      <th>Highest_score</th>\n",
              "      <th>Average</th>\n",
              "      <th>Balls_Faced</th>\n",
              "      <th>Strike_Rate</th>\n",
              "      <th>Centuries</th>\n",
              "      <th>Half_centuries</th>\n",
              "      <th>Ducks</th>\n",
              "      <th>Fours</th>\n",
              "      <th>Sixes</th>\n",
              "      <th>played_for_ICC</th>\n",
              "      <th>played_for_Asia</th>\n",
              "      <th>played_for_Africa</th>\n",
              "      <th>years_played</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>RG Sharma</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>230</td>\n",
              "      <td>223</td>\n",
              "      <td>32</td>\n",
              "      <td>9283</td>\n",
              "      <td>264</td>\n",
              "      <td>48.60</td>\n",
              "      <td>10428</td>\n",
              "      <td>89.01</td>\n",
              "      <td>29</td>\n",
              "      <td>44</td>\n",
              "      <td>13</td>\n",
              "      <td>845</td>\n",
              "      <td>245</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>MJ Guptill</td>\n",
              "      <td>NZ</td>\n",
              "      <td>186</td>\n",
              "      <td>183</td>\n",
              "      <td>19</td>\n",
              "      <td>6927</td>\n",
              "      <td>237</td>\n",
              "      <td>42.23</td>\n",
              "      <td>7896</td>\n",
              "      <td>87.72</td>\n",
              "      <td>16</td>\n",
              "      <td>37</td>\n",
              "      <td>15</td>\n",
              "      <td>702</td>\n",
              "      <td>181</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>12</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>V Sehwag</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>251</td>\n",
              "      <td>245</td>\n",
              "      <td>9</td>\n",
              "      <td>8273</td>\n",
              "      <td>219</td>\n",
              "      <td>35.05</td>\n",
              "      <td>7929</td>\n",
              "      <td>104.33</td>\n",
              "      <td>15</td>\n",
              "      <td>38</td>\n",
              "      <td>14</td>\n",
              "      <td>1132</td>\n",
              "      <td>136</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>CH Gayle</td>\n",
              "      <td>WI</td>\n",
              "      <td>301</td>\n",
              "      <td>294</td>\n",
              "      <td>17</td>\n",
              "      <td>10480</td>\n",
              "      <td>215</td>\n",
              "      <td>37.83</td>\n",
              "      <td>12019</td>\n",
              "      <td>87.19</td>\n",
              "      <td>25</td>\n",
              "      <td>54</td>\n",
              "      <td>25</td>\n",
              "      <td>1128</td>\n",
              "      <td>331</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>20</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SR Tendulkar</td>\n",
              "      <td>INDIA</td>\n",
              "      <td>463</td>\n",
              "      <td>452</td>\n",
              "      <td>41</td>\n",
              "      <td>18426</td>\n",
              "      <td>200</td>\n",
              "      <td>44.83</td>\n",
              "      <td>21368</td>\n",
              "      <td>86.23</td>\n",
              "      <td>49</td>\n",
              "      <td>96</td>\n",
              "      <td>20</td>\n",
              "      <td>2016</td>\n",
              "      <td>195</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Saeed Anwar</td>\n",
              "      <td>PAK</td>\n",
              "      <td>247</td>\n",
              "      <td>244</td>\n",
              "      <td>19</td>\n",
              "      <td>8824</td>\n",
              "      <td>194</td>\n",
              "      <td>39.21</td>\n",
              "      <td>10938</td>\n",
              "      <td>80.67</td>\n",
              "      <td>20</td>\n",
              "      <td>43</td>\n",
              "      <td>15</td>\n",
              "      <td>938</td>\n",
              "      <td>97</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>IVA Richards</td>\n",
              "      <td>WI</td>\n",
              "      <td>187</td>\n",
              "      <td>167</td>\n",
              "      <td>24</td>\n",
              "      <td>6721</td>\n",
              "      <td>189</td>\n",
              "      <td>47.00</td>\n",
              "      <td>7451</td>\n",
              "      <td>90.20</td>\n",
              "      <td>11</td>\n",
              "      <td>45</td>\n",
              "      <td>7</td>\n",
              "      <td>600+</td>\n",
              "      <td>126+</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ST Jayasuriya</td>\n",
              "      <td>SL</td>\n",
              "      <td>445</td>\n",
              "      <td>433</td>\n",
              "      <td>18</td>\n",
              "      <td>13430</td>\n",
              "      <td>189</td>\n",
              "      <td>32.36</td>\n",
              "      <td>14725</td>\n",
              "      <td>91.20</td>\n",
              "      <td>28</td>\n",
              "      <td>68</td>\n",
              "      <td>34</td>\n",
              "      <td>1500</td>\n",
              "      <td>270</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>G Kirsten</td>\n",
              "      <td>SA</td>\n",
              "      <td>185</td>\n",
              "      <td>185</td>\n",
              "      <td>19</td>\n",
              "      <td>6798</td>\n",
              "      <td>188</td>\n",
              "      <td>40.95</td>\n",
              "      <td>9436</td>\n",
              "      <td>72.04</td>\n",
              "      <td>13</td>\n",
              "      <td>45</td>\n",
              "      <td>11</td>\n",
              "      <td>659</td>\n",
              "      <td>20</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75</th>\n",
              "      <td>F du Plessis</td>\n",
              "      <td>SA</td>\n",
              "      <td>143</td>\n",
              "      <td>136</td>\n",
              "      <td>20</td>\n",
              "      <td>5507</td>\n",
              "      <td>185</td>\n",
              "      <td>47.47</td>\n",
              "      <td>6215</td>\n",
              "      <td>88.60</td>\n",
              "      <td>12</td>\n",
              "      <td>35</td>\n",
              "      <td>3</td>\n",
              "      <td>495</td>\n",
              "      <td>66</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       Player_Name Country  Match  Innings  NotOut   Runs  Highest_score  \\\n",
              "19      RG Sharma    INDIA    230      223      32   9283            264   \n",
              "44     MJ Guptill       NZ    186      183      19   6927            237   \n",
              "27       V Sehwag    INDIA    251      245       9   8273            219   \n",
              "11       CH Gayle       WI    301      294      17  10480            215   \n",
              "0    SR Tendulkar    INDIA    463      452      41  18426            200   \n",
              "20    Saeed Anwar      PAK    247      244      19   8824            194   \n",
              "49   IVA Richards       WI    187      167      24   6721            189   \n",
              "3   ST Jayasuriya       SL    445      433      18  13430            189   \n",
              "46      G Kirsten       SA    185      185      19   6798            188   \n",
              "75   F du Plessis       SA    143      136      20   5507            185   \n",
              "\n",
              "    Average  Balls_Faced  Strike_Rate  Centuries  Half_centuries  Ducks Fours  \\\n",
              "19    48.60        10428        89.01         29              44     13   845   \n",
              "44    42.23         7896        87.72         16              37     15   702   \n",
              "27    35.05         7929       104.33         15              38     14  1132   \n",
              "11    37.83        12019        87.19         25              54     25  1128   \n",
              "0     44.83        21368        86.23         49              96     20  2016   \n",
              "20    39.21        10938        80.67         20              43     15   938   \n",
              "49    47.00         7451        90.20         11              45      7  600+   \n",
              "3     32.36        14725        91.20         28              68     34  1500   \n",
              "46    40.95         9436        72.04         13              45     11   659   \n",
              "75    47.47         6215        88.60         12              35      3   495   \n",
              "\n",
              "   Sixes played_for_ICC played_for_Asia played_for_Africa  years_played  \n",
              "19   245             No              No                No            15  \n",
              "44   181             No              No                No            12  \n",
              "27   136            Yes             Yes                No            14  \n",
              "11   331            Yes              No                No            20  \n",
              "0    195             No              No                No            23  \n",
              "20    97             No              No                No            14  \n",
              "49  126+             No              No                No            16  \n",
              "3    270             No             Yes                No            22  \n",
              "46    20             No              No                No            10  \n",
              "75    66             No              No                No             8  "
            ]
          },
          "execution_count": 88,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df.sort_values(by=\"Highest_score\", ascending = False).head(10)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "RJ_D8ymsvqwF"
      },
      "outputs": [],
      "source": [
        ""
      ]
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.7.7"
    },
    "colab": {
      "name": "Lecture_03.ipynb",
      "provenance": [],
      "include_colab_link": true
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}