test.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "45\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "['/ci/engine/match/1298135.html',\n",
       " '/ci/engine/match/1298136.html',\n",
       " '/ci/engine/match/1298137.html',\n",
       " '/ci/engine/match/1298138.html',\n",
       " '/ci/engine/match/1298139.html',\n",
       " '/ci/engine/match/1298140.html',\n",
       " '/ci/engine/match/1298141.html',\n",
       " '/ci/engine/match/1298142.html',\n",
       " '/ci/engine/match/1298143.html',\n",
       " '/ci/engine/match/1298144.html',\n",
       " '/ci/engine/match/1298145.html',\n",
       " '/ci/engine/match/1298146.html',\n",
       " '/ci/engine/match/1298147.html',\n",
       " '/ci/engine/match/1298148.html',\n",
       " '/ci/engine/match/1298149.html',\n",
       " '/ci/engine/match/1298150.html',\n",
       " '/ci/engine/match/1298151.html',\n",
       " '/ci/engine/match/1298152.html',\n",
       " '/ci/engine/match/1298153.html',\n",
       " '/ci/engine/match/1298154.html',\n",
       " '/ci/engine/match/1298155.html',\n",
       " '/ci/engine/match/1298156.html',\n",
       " '/ci/engine/match/1298157.html',\n",
       " '/ci/engine/match/1298158.html',\n",
       " '/ci/engine/match/1298159.html',\n",
       " '/ci/engine/match/1298160.html',\n",
       " '/ci/engine/match/1298161.html',\n",
       " '/ci/engine/match/1298162.html',\n",
       " '/ci/engine/match/1298163.html',\n",
       " '/ci/engine/match/1298164.html',\n",
       " '/ci/engine/match/1298165.html',\n",
       " '/ci/engine/match/1298166.html',\n",
       " '/ci/engine/match/1298167.html',\n",
       " '/ci/engine/match/1298168.html',\n",
       " '/ci/engine/match/1298169.html',\n",
       " '/ci/engine/match/1298170.html',\n",
       " '/ci/engine/match/1298171.html',\n",
       " '/ci/engine/match/1298172.html',\n",
       " '/ci/engine/match/1298173.html',\n",
       " '/ci/engine/match/1298174.html',\n",
       " '/ci/engine/match/1298175.html',\n",
       " '/ci/engine/match/1298176.html',\n",
       " '/ci/engine/match/1298177.html',\n",
       " '/ci/engine/match/1298178.html',\n",
       " '/ci/engine/match/1298179.html']"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response = requests.get(\"https://stats.espncricinfo.com/ci/engine/records/team/match_results.html?id=2022%2F23;trophy=89;type=season\")\n",
    "soup = BeautifulSoup(response.content, 'html.parser')\n",
    "urls = []\n",
    "links = soup.find_all('a', class_='data-link', href=True)\n",
    "for link in links:\n",
    "    urls.append(link.get('href'))\n",
    "filtered_urls = []\n",
    "\n",
    "for url in urls:\n",
    "  if \"ci/engine/match\" in url:\n",
    "    filtered_urls.append(url)\n",
    "\n",
    "print(len(filtered_urls))\n",
    "filtered_urls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2\n"
     ]
    }
   ],
   "source": [
    "res = requests.get(\"https://stats.espncricinfo.com/ci/engine/match/1298135.html\")\n",
    "soup = BeautifulSoup(res.content, 'html.parser')\n",
    "div = soup.find_all('div', class_ = 'ds-flex ds-items-center ds-min-w-0 ds-mr-1')\n",
    "div = div[-2].text +' vs '+ div[-1].text\n",
    "span = soup.find_all('span', class_='ds-text-title-xs ds-font-bold ds-capitalize')\n",
    "tables = soup.find_all('table', class_='ci-scorecard-table')\n",
    "print(len(tables))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<table class=\"ds-w-full ds-table ds-table-md ds-table-auto ci-scorecard-table\"><thead class=\"ds-bg-fill-content-alternate ds-text-left\"><tr class=\"ds-text-right\"><th class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-left\">BATTING</th><th class=\"ds-min-w-max\"> </th><th class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max\">R</th><th class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max\">B</th><th class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max\">M</th><th class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max\">4s</th><th class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max\">6s</th><th class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max\">SR</th></tr></thead><tbody class=\"\"><tr class=\"\"><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max\"><a class=\"ds-inline-flex ds-items-start ds-leading-none\" href=\"/player/michael-van-lingen-833777\" title=\"Michael van Lingen\"><span class=\"ds-text-tight-s ds-font-medium ds-text-ui-typo ds-underline ds-decoration-ui-stroke hover:ds-text-ui-typo-primary hover:ds-decoration-ui-stroke-primary ds-block\"><span>Michael van Lingen<!-- --> </span></span></a></td><td class=\"ds-min-w-max !ds-pl-[100px]\"><span class=\"ds-flex ds-cursor-pointer ds-items-center\"><i class=\"icon-keyboard_arrow_down-outlined ds-text-icon-primary ds-inline-flex ds-items-center\" style=\"font-size:16px\"></i><span>c Pramod Madushan b Chameera</span></span></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\"><strong>3</strong></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">6</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">7</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">0</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">0</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">50.00</td></tr><tr class=\"ds-hidden\"><td class=\"\" colspan=\"9\"></td></tr><tr class=\"\"><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max\"><a class=\"ds-inline-flex ds-items-start ds-leading-none\" href=\"/player/divan-la-cock-1178065\" title=\"Divan la Cock\"><span class=\"ds-text-tight-s ds-font-medium ds-text-ui-typo ds-underline ds-decoration-ui-stroke hover:ds-text-ui-typo-primary hover:ds-decoration-ui-stroke-primary ds-block\"><span>Divan la Cock<!-- --> </span></span></a></td><td class=\"ds-min-w-max !ds-pl-[100px]\"><span class=\"ds-flex ds-cursor-pointer ds-items-center\"><i class=\"icon-keyboard_arrow_down-outlined ds-text-icon-primary ds-inline-flex ds-items-center\" style=\"font-size:16px\"></i><span>c Shanaka b Pramod Madushan</span></span></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\"><strong>9</strong></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">9</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">15</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">1</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">0</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">100.00</td></tr><tr class=\"ds-hidden\"><td class=\"\" colspan=\"9\"></td></tr><tr class=\"\"><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max\"><a class=\"ds-inline-flex ds-items-start ds-leading-none\" href=\"/player/jan-nicol-loftie-eaton-1071473\" title=\"Jan Nicol Loftie-Eaton\"><span class=\"ds-text-tight-s ds-font-medium ds-text-ui-typo ds-underline ds-decoration-ui-stroke hover:ds-text-ui-typo-primary hover:ds-decoration-ui-stroke-primary ds-block\"><span>Jan Nicol Loftie-Eaton<!-- --> </span></span></a></td><td class=\"ds-min-w-max !ds-pl-[100px]\"><span class=\"ds-flex ds-cursor-pointer ds-items-center\"><i class=\"icon-keyboard_arrow_down-outlined ds-text-icon-primary ds-inline-flex ds-items-center\" style=\"font-size:16px\"></i><span>c †Mendis b Karunaratne</span></span></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\"><strong>20</strong></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">12</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">18</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">1</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">2</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">166.66</td></tr><tr class=\"ds-hidden\"><td class=\"\" colspan=\"9\"></td></tr><tr class=\"\"><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max\"><a class=\"ds-inline-flex ds-items-start ds-leading-none\" href=\"/player/stephan-baard-437927\" title=\"Stephan Baard\"><span class=\"ds-text-tight-s ds-font-medium ds-text-ui-typo ds-underline ds-decoration-ui-stroke hover:ds-text-ui-typo-primary hover:ds-decoration-ui-stroke-primary ds-block\"><span>Stephan Baard<!-- --> </span></span></a></td><td class=\"ds-min-w-max !ds-pl-[100px]\"><span class=\"ds-flex ds-cursor-pointer ds-items-center\"><i class=\"icon-keyboard_arrow_down-outlined ds-text-icon-primary ds-inline-flex ds-items-center\" style=\"font-size:16px\"></i><span>c DM de Silva b Pramod Madushan</span></span></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\"><strong>26</strong></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">24</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">49</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">2</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">0</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">108.33</td></tr><tr class=\"ds-hidden\"><td class=\"\" colspan=\"9\"></td></tr><tr class=\"\"><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max\"><a class=\"ds-inline-flex ds-items-start ds-leading-none\" href=\"/player/gerhard-erasmus-519070\" title=\"Gerhard Erasmus\"><span class=\"ds-text-tight-s ds-font-medium ds-text-ui-typo ds-underline ds-decoration-ui-stroke hover:ds-text-ui-typo-primary hover:ds-decoration-ui-stroke-primary ds-block\"><span>Gerhard Erasmus<!-- --> <span>(c)</span></span></span></a></td><td class=\"ds-min-w-max !ds-pl-[100px]\"><span class=\"ds-flex ds-cursor-pointer ds-items-center\"><i class=\"icon-keyboard_arrow_down-outlined ds-text-icon-primary ds-inline-flex ds-items-center\" style=\"font-size:16px\"></i><span>c Gunathilaka b PWH de Silva</span></span></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\"><strong>20</strong></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">24</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">30</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">0</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">0</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">83.33</td></tr><tr class=\"ds-hidden\"><td class=\"\" colspan=\"9\"></td></tr><tr class=\"\"><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max\"><a class=\"ds-inline-flex ds-items-start ds-leading-none\" href=\"/player/jan-frylinck-482478\" title=\"Jan Frylinck\"><span class=\"ds-text-tight-s ds-font-medium ds-text-ui-typo ds-underline ds-decoration-ui-stroke hover:ds-text-ui-typo-primary hover:ds-decoration-ui-stroke-primary ds-block\"><span>Jan Frylinck<!-- --> </span></span></a></td><td class=\"ds-min-w-max !ds-pl-[100px]\"><span class=\"ds-flex ds-cursor-pointer ds-items-center\"><i class=\"icon-keyboard_arrow_down-outlined ds-text-icon-primary ds-inline-flex ds-items-center\" style=\"font-size:16px\"></i><span>run out (Gunathilaka/†Mendis)</span></span></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\"><strong>44</strong></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">28</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">44</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">4</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">0</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">157.14</td></tr><tr class=\"ds-hidden\"><td class=\"\" colspan=\"9\"></td></tr><tr class=\"\"><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max\"><a class=\"ds-inline-flex ds-items-start ds-leading-none\" href=\"/player/david-wiese-221140\" title=\"David Wiese\"><span class=\"ds-text-tight-s ds-font-medium ds-text-ui-typo ds-underline ds-decoration-ui-stroke hover:ds-text-ui-typo-primary hover:ds-decoration-ui-stroke-primary ds-block\"><span>David Wiese<!-- --> </span></span></a></td><td class=\"ds-min-w-max !ds-pl-[100px]\"><span class=\"ds-flex ds-cursor-pointer ds-items-center\"><i class=\"icon-keyboard_arrow_down-outlined ds-text-icon-primary ds-inline-flex ds-items-center\" style=\"font-size:16px\"></i><span>c †Mendis b Theekshana</span></span></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\"><strong>0</strong></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">1</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">4</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">0</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">0</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">0.00</td></tr><tr class=\"ds-hidden\"><td class=\"\" colspan=\"9\"></td></tr><tr class=\"\"><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-border-line-primary ci-scorecard-player-notout\"><a class=\"ds-inline-flex ds-items-start ds-leading-none\" href=\"/player/jj-smit-553821\" title=\"JJ Smit\"><span class=\"ds-text-tight-s ds-font-medium ds-text-ui-typo ds-underline ds-decoration-ui-stroke hover:ds-text-ui-typo-primary hover:ds-decoration-ui-stroke-primary ds-block\"><span>JJ Smit<!-- --> </span></span></a></td><td class=\"ds-min-w-max !ds-pl-[100px]\">not out </td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\"><strong>31</strong></td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">16</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">29</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">2</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">2</td><td class=\"ds-w-0 ds-whitespace-nowrap ds-min-w-max ds-text-right\">193.75</td></tr><tr class=\"ds-text-tight-s\"><td class=\"ds-min-w-max\" colspan=\"1\">Extras</td><td class=\"ds-min-w-max !ds-pl-[100px]\">(b 1, w 9)</td><td class=\"ds-min-w-max ds-text-right\" colspan=\"1\"><strong>10</strong></td><td class=\"ds-text-right\" colspan=\"7\"></td></tr><tr class=\"\"><td class=\"ds-font-bold ds-bg-fill-content-alternate ds-text-tight-m ds-min-w-max\" colspan=\"1\">TOTAL</td><td class=\"ds-font-bold ds-bg-fill-content-alternate ds-text-tight-m ds-min-w-max ds-flex ds-items-center !ds-pl-[100px]\"><span class=\"ds-font-regular ds-text-tight-xs\">20 Ov</span><span class=\"ds-font-regular ds-text-tight-xs\"> <!-- -->(RR: 8.15)</span><i class=\"icon-blank_placeholder ds-text-icon\" style=\"font-size:20px\"></i></td><td class=\"ds-font-bold ds-bg-fill-content-alternate ds-text-tight-m ds-min-w-max ds-text-right\" colspan=\"1\">163<!-- -->/7</td><td class=\"ds-font-bold ds-bg-fill-content-alternate ds-text-tight-m ds-text-right !ds-font-regular\" colspan=\"7\"><div></div></td></tr><tr class=\"!ds-border-b-0\"><td class=\"!ds-py-2\" colspan=\"9\"><div class=\"ds-text-tight-s ds-font-regular ds-leading-4\"><strong>Did not bat: </strong><a class=\"ds-inline-flex ds-items-start ds-leading-none\" href=\"/player/zane-green-596664\"><span class=\"ds-text-tight-s ds-font-medium ds-text-ui-typo ds-underline ds-decoration-ui-stroke hover:ds-text-ui-typo-primary hover:ds-decoration-ui-stroke-primary ds-block ds-mr-1\"><span>Zane Green<span> †</span>,<!-- --> </span></span></a><a class=\"ds-inline-flex ds-items-start ds-leading-none\" href=\"/player/bernard-scholtz-330223\"><span class=\"ds-text-tight-s ds-font-medium ds-text-ui-typo ds-underline ds-decoration-ui-stroke hover:ds-text-ui-typo-primary hover:ds-decoration-ui-stroke-primary ds-block ds-mr-1\"><span>Bernard Scholtz<!-- -->,<!-- --> </span></span></a><a class=\"ds-inline-flex ds-items-start ds-leading-none\" href=\"/player/ben-shikongo-1069820\"><span class=\"ds-text-tight-s ds-font-medium ds-text-ui-typo ds-underline ds-decoration-ui-stroke hover:ds-text-ui-typo-primary hover:ds-decoration-ui-stroke-primary ds-block ds-mr-1\"><span>Ben Shikongo<!-- --> </span></span></a></div></td></tr><tr class=\"\"><td class=\"\" colspan=\"9\"><div class=\"ds-text-tight-s ds-font-regular ds-leading-4\"><strong>Fall of wickets<!-- -->: </strong><span>1<!-- -->-<!-- -->6<!-- --> (<!-- -->Michael van Lingen<!-- -->, 1.2 ov<!-- -->)</span><span>, <!-- -->2<!-- -->-<!-- -->16<!-- --> (<!-- -->Divan la Cock<!-- -->, 2.6 ov<!-- -->)</span><span>, <!-- -->3<!-- -->-<!-- -->35<!-- --> (<!-- -->Jan Nicol Loftie-Eaton<!-- -->, 4.5 ov<!-- -->)</span><span>, <!-- -->4<!-- -->-<!-- -->76<!-- --> (<!-- -->Gerhard Erasmus<!-- -->, 11.5 ov<!-- -->)</span><span>, <!-- -->5<!-- -->-<!-- -->91<!-- --> (<!-- -->Stephan Baard<!-- -->, 13.6 ov<!-- -->)</span><span>, <!-- -->6<!-- -->-<!-- -->93<!-- --> (<!-- -->David Wiese<!-- -->, 14.2 ov<!-- -->)</span><span>, <!-- -->7<!-- -->-<!-- -->163<!-- --> (<!-- -->Jan Frylinck<!-- -->, 19.6 ov<!-- -->)</span></div></td></tr></tbody></table>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "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>BATTING</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>R</th>\n",
       "      <th>B</th>\n",
       "      <th>M</th>\n",
       "      <th>4s</th>\n",
       "      <th>6s</th>\n",
       "      <th>SR</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>match</th>\n",
       "      <th>team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Michael van Lingen</td>\n",
       "      <td>c Pramod Madushan b Chameera</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>50.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Divan la Cock</td>\n",
       "      <td>c Shanaka b Pramod Madushan</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jan Nicol Loftie-Eaton</td>\n",
       "      <td>c †Mendis b Karunaratne</td>\n",
       "      <td>20</td>\n",
       "      <td>12</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>166.66</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Stephan Baard</td>\n",
       "      <td>c DM de Silva b Pramod Madushan</td>\n",
       "      <td>26</td>\n",
       "      <td>24</td>\n",
       "      <td>49</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>108.33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Gerhard Erasmus (c)</td>\n",
       "      <td>c Gunathilaka b PWH de Silva</td>\n",
       "      <td>20</td>\n",
       "      <td>24</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>83.33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Jan Frylinck</td>\n",
       "      <td>run out (Gunathilaka/†Mendis)</td>\n",
       "      <td>44</td>\n",
       "      <td>28</td>\n",
       "      <td>44</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>157.14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>David Wiese</td>\n",
       "      <td>c †Mendis b Theekshana</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>JJ Smit</td>\n",
       "      <td>not out</td>\n",
       "      <td>31</td>\n",
       "      <td>16</td>\n",
       "      <td>29</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>193.75</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Extras</td>\n",
       "      <td>(b 1, w 9)</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>TOTAL</td>\n",
       "      <td>20 Ov (RR: 8.15)</td>\n",
       "      <td>163/7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Did not bat: Zane Green †, Bernard Scholtz, Be...</td>\n",
       "      <td>Did not bat: Zane Green †, Bernard Scholtz, Be...</td>\n",
       "      <td>Did not bat: Zane Green †, Bernard Scholtz, Be...</td>\n",
       "      <td>Did not bat: Zane Green †, Bernard Scholtz, Be...</td>\n",
       "      <td>Did not bat: Zane Green †, Bernard Scholtz, Be...</td>\n",
       "      <td>Did not bat: Zane Green †, Bernard Scholtz, Be...</td>\n",
       "      <td>Did not bat: Zane Green †, Bernard Scholtz, Be...</td>\n",
       "      <td>Did not bat: Zane Green †, Bernard Scholtz, Be...</td>\n",
       "      <td>Did not bat: Zane Green †, Bernard Scholtz, Be...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...</td>\n",
       "      <td>Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...</td>\n",
       "      <td>Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...</td>\n",
       "      <td>Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...</td>\n",
       "      <td>Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...</td>\n",
       "      <td>Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...</td>\n",
       "      <td>Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...</td>\n",
       "      <td>Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...</td>\n",
       "      <td>Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              BATTING  \\\n",
       "0                                  Michael van Lingen   \n",
       "1                                                 NaN   \n",
       "2                                       Divan la Cock   \n",
       "3                                                 NaN   \n",
       "4                              Jan Nicol Loftie-Eaton   \n",
       "5                                                 NaN   \n",
       "6                                       Stephan Baard   \n",
       "7                                                 NaN   \n",
       "8                                 Gerhard Erasmus (c)   \n",
       "9                                                 NaN   \n",
       "10                                       Jan Frylinck   \n",
       "11                                                NaN   \n",
       "12                                        David Wiese   \n",
       "13                                                NaN   \n",
       "14                                            JJ Smit   \n",
       "15                                             Extras   \n",
       "16                                              TOTAL   \n",
       "17  Did not bat: Zane Green †, Bernard Scholtz, Be...   \n",
       "18  Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...   \n",
       "\n",
       "                                           Unnamed: 1  \\\n",
       "0                        c Pramod Madushan b Chameera   \n",
       "1                                                 NaN   \n",
       "2                         c Shanaka b Pramod Madushan   \n",
       "3                                                 NaN   \n",
       "4                             c †Mendis b Karunaratne   \n",
       "5                                                 NaN   \n",
       "6                     c DM de Silva b Pramod Madushan   \n",
       "7                                                 NaN   \n",
       "8                        c Gunathilaka b PWH de Silva   \n",
       "9                                                 NaN   \n",
       "10                      run out (Gunathilaka/†Mendis)   \n",
       "11                                                NaN   \n",
       "12                             c †Mendis b Theekshana   \n",
       "13                                                NaN   \n",
       "14                                            not out   \n",
       "15                                         (b 1, w 9)   \n",
       "16                                   20 Ov (RR: 8.15)   \n",
       "17  Did not bat: Zane Green †, Bernard Scholtz, Be...   \n",
       "18  Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...   \n",
       "\n",
       "                                                    R  \\\n",
       "0                                                   3   \n",
       "1                                                 NaN   \n",
       "2                                                   9   \n",
       "3                                                 NaN   \n",
       "4                                                  20   \n",
       "5                                                 NaN   \n",
       "6                                                  26   \n",
       "7                                                 NaN   \n",
       "8                                                  20   \n",
       "9                                                 NaN   \n",
       "10                                                 44   \n",
       "11                                                NaN   \n",
       "12                                                  0   \n",
       "13                                                NaN   \n",
       "14                                                 31   \n",
       "15                                                 10   \n",
       "16                                              163/7   \n",
       "17  Did not bat: Zane Green †, Bernard Scholtz, Be...   \n",
       "18  Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...   \n",
       "\n",
       "                                                    B  \\\n",
       "0                                                   6   \n",
       "1                                                 NaN   \n",
       "2                                                   9   \n",
       "3                                                 NaN   \n",
       "4                                                  12   \n",
       "5                                                 NaN   \n",
       "6                                                  24   \n",
       "7                                                 NaN   \n",
       "8                                                  24   \n",
       "9                                                 NaN   \n",
       "10                                                 28   \n",
       "11                                                NaN   \n",
       "12                                                  1   \n",
       "13                                                NaN   \n",
       "14                                                 16   \n",
       "15                                                NaN   \n",
       "16                                                NaN   \n",
       "17  Did not bat: Zane Green †, Bernard Scholtz, Be...   \n",
       "18  Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...   \n",
       "\n",
       "                                                    M  \\\n",
       "0                                                   7   \n",
       "1                                                 NaN   \n",
       "2                                                  15   \n",
       "3                                                 NaN   \n",
       "4                                                  18   \n",
       "5                                                 NaN   \n",
       "6                                                  49   \n",
       "7                                                 NaN   \n",
       "8                                                  30   \n",
       "9                                                 NaN   \n",
       "10                                                 44   \n",
       "11                                                NaN   \n",
       "12                                                  4   \n",
       "13                                                NaN   \n",
       "14                                                 29   \n",
       "15                                                NaN   \n",
       "16                                                NaN   \n",
       "17  Did not bat: Zane Green †, Bernard Scholtz, Be...   \n",
       "18  Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...   \n",
       "\n",
       "                                                   4s  \\\n",
       "0                                                   0   \n",
       "1                                                 NaN   \n",
       "2                                                   1   \n",
       "3                                                 NaN   \n",
       "4                                                   1   \n",
       "5                                                 NaN   \n",
       "6                                                   2   \n",
       "7                                                 NaN   \n",
       "8                                                   0   \n",
       "9                                                 NaN   \n",
       "10                                                  4   \n",
       "11                                                NaN   \n",
       "12                                                  0   \n",
       "13                                                NaN   \n",
       "14                                                  2   \n",
       "15                                                NaN   \n",
       "16                                                NaN   \n",
       "17  Did not bat: Zane Green †, Bernard Scholtz, Be...   \n",
       "18  Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...   \n",
       "\n",
       "                                                   6s  \\\n",
       "0                                                   0   \n",
       "1                                                 NaN   \n",
       "2                                                   0   \n",
       "3                                                 NaN   \n",
       "4                                                   2   \n",
       "5                                                 NaN   \n",
       "6                                                   0   \n",
       "7                                                 NaN   \n",
       "8                                                   0   \n",
       "9                                                 NaN   \n",
       "10                                                  0   \n",
       "11                                                NaN   \n",
       "12                                                  0   \n",
       "13                                                NaN   \n",
       "14                                                  2   \n",
       "15                                                NaN   \n",
       "16                                                NaN   \n",
       "17  Did not bat: Zane Green †, Bernard Scholtz, Be...   \n",
       "18  Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...   \n",
       "\n",
       "                                                   SR  \\\n",
       "0                                               50.00   \n",
       "1                                                 NaN   \n",
       "2                                              100.00   \n",
       "3                                                 NaN   \n",
       "4                                              166.66   \n",
       "5                                                 NaN   \n",
       "6                                              108.33   \n",
       "7                                                 NaN   \n",
       "8                                               83.33   \n",
       "9                                                 NaN   \n",
       "10                                             157.14   \n",
       "11                                                NaN   \n",
       "12                                               0.00   \n",
       "13                                                NaN   \n",
       "14                                             193.75   \n",
       "15                                                NaN   \n",
       "16                                                NaN   \n",
       "17  Did not bat: Zane Green †, Bernard Scholtz, Be...   \n",
       "18  Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...   \n",
       "\n",
       "                                           Unnamed: 8  Unnamed: 9  \\\n",
       "0                                                 NaN         NaN   \n",
       "1                                                 NaN         NaN   \n",
       "2                                                 NaN         NaN   \n",
       "3                                                 NaN         NaN   \n",
       "4                                                 NaN         NaN   \n",
       "5                                                 NaN         NaN   \n",
       "6                                                 NaN         NaN   \n",
       "7                                                 NaN         NaN   \n",
       "8                                                 NaN         NaN   \n",
       "9                                                 NaN         NaN   \n",
       "10                                                NaN         NaN   \n",
       "11                                                NaN         NaN   \n",
       "12                                                NaN         NaN   \n",
       "13                                                NaN         NaN   \n",
       "14                                                NaN         NaN   \n",
       "15                                                NaN         NaN   \n",
       "16                                                NaN         NaN   \n",
       "17  Did not bat: Zane Green †, Bernard Scholtz, Be...         NaN   \n",
       "18  Fall of wickets: 1-6 (Michael van Lingen, 1.2 ...         NaN   \n",
       "\n",
       "                   match     team  \n",
       "0   Namibia vs Sri Lanka  Namibia  \n",
       "1   Namibia vs Sri Lanka  Namibia  \n",
       "2   Namibia vs Sri Lanka  Namibia  \n",
       "3   Namibia vs Sri Lanka  Namibia  \n",
       "4   Namibia vs Sri Lanka  Namibia  \n",
       "5   Namibia vs Sri Lanka  Namibia  \n",
       "6   Namibia vs Sri Lanka  Namibia  \n",
       "7   Namibia vs Sri Lanka  Namibia  \n",
       "8   Namibia vs Sri Lanka  Namibia  \n",
       "9   Namibia vs Sri Lanka  Namibia  \n",
       "10  Namibia vs Sri Lanka  Namibia  \n",
       "11  Namibia vs Sri Lanka  Namibia  \n",
       "12  Namibia vs Sri Lanka  Namibia  \n",
       "13  Namibia vs Sri Lanka  Namibia  \n",
       "14  Namibia vs Sri Lanka  Namibia  \n",
       "15  Namibia vs Sri Lanka  Namibia  \n",
       "16  Namibia vs Sri Lanka  Namibia  \n",
       "17  Namibia vs Sri Lanka  Namibia  \n",
       "18  Namibia vs Sri Lanka  Namibia  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_html(str(tables[0]))\n",
    "df = pd.DataFrame(df[0])\n",
    "df['match'] = df.apply(lambda row: div, axis=1)\n",
    "df['team'] = df.apply(lambda row: span[0].text, axis=1)\n",
    "df.dropna(inplace=True,axis=0, how='all')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "45"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(filtered_urls)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "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>BATTING</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>R</th>\n",
       "      <th>B</th>\n",
       "      <th>M</th>\n",
       "      <th>4s</th>\n",
       "      <th>6s</th>\n",
       "      <th>SR</th>\n",
       "      <th>Unnamed: 8</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>match</th>\n",
       "      <th>team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Michael van Lingen</td>\n",
       "      <td>c Pramod Madushan b Chameera</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>50.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Divan la Cock</td>\n",
       "      <td>c Shanaka b Pramod Madushan</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jan Nicol Loftie-Eaton</td>\n",
       "      <td>c †Mendis b Karunaratne</td>\n",
       "      <td>20</td>\n",
       "      <td>12</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>166.66</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Namibia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1563</th>\n",
       "      <td>Liam Livingstone</td>\n",
       "      <td>not out</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan vs England</td>\n",
       "      <td>England</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1564</th>\n",
       "      <td>Extras</td>\n",
       "      <td>(lb 1, w 8)</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan vs England</td>\n",
       "      <td>England</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1565</th>\n",
       "      <td>TOTAL</td>\n",
       "      <td>19 Ov (RR: 7.26)</td>\n",
       "      <td>138/5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan vs England</td>\n",
       "      <td>England</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1566</th>\n",
       "      <td>Did not bat: Sam Curran, Chris Woakes, Chris J...</td>\n",
       "      <td>Did not bat: Sam Curran, Chris Woakes, Chris J...</td>\n",
       "      <td>Did not bat: Sam Curran, Chris Woakes, Chris J...</td>\n",
       "      <td>Did not bat: Sam Curran, Chris Woakes, Chris J...</td>\n",
       "      <td>Did not bat: Sam Curran, Chris Woakes, Chris J...</td>\n",
       "      <td>Did not bat: Sam Curran, Chris Woakes, Chris J...</td>\n",
       "      <td>Did not bat: Sam Curran, Chris Woakes, Chris J...</td>\n",
       "      <td>Did not bat: Sam Curran, Chris Woakes, Chris J...</td>\n",
       "      <td>Did not bat: Sam Curran, Chris Woakes, Chris J...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan vs England</td>\n",
       "      <td>England</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1567</th>\n",
       "      <td>Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...</td>\n",
       "      <td>Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...</td>\n",
       "      <td>Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...</td>\n",
       "      <td>Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...</td>\n",
       "      <td>Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...</td>\n",
       "      <td>Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...</td>\n",
       "      <td>Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...</td>\n",
       "      <td>Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...</td>\n",
       "      <td>Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pakistan vs England</td>\n",
       "      <td>England</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1568 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                BATTING  \\\n",
       "0                                    Michael van Lingen   \n",
       "1                                                   NaN   \n",
       "2                                         Divan la Cock   \n",
       "3                                                   NaN   \n",
       "4                                Jan Nicol Loftie-Eaton   \n",
       "...                                                 ...   \n",
       "1563                                   Liam Livingstone   \n",
       "1564                                             Extras   \n",
       "1565                                              TOTAL   \n",
       "1566  Did not bat: Sam Curran, Chris Woakes, Chris J...   \n",
       "1567  Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...   \n",
       "\n",
       "                                             Unnamed: 1  \\\n",
       "0                          c Pramod Madushan b Chameera   \n",
       "1                                                   NaN   \n",
       "2                           c Shanaka b Pramod Madushan   \n",
       "3                                                   NaN   \n",
       "4                               c †Mendis b Karunaratne   \n",
       "...                                                 ...   \n",
       "1563                                            not out   \n",
       "1564                                        (lb 1, w 8)   \n",
       "1565                                   19 Ov (RR: 7.26)   \n",
       "1566  Did not bat: Sam Curran, Chris Woakes, Chris J...   \n",
       "1567  Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...   \n",
       "\n",
       "                                                      R  \\\n",
       "0                                                     3   \n",
       "1                                                   NaN   \n",
       "2                                                     9   \n",
       "3                                                   NaN   \n",
       "4                                                    20   \n",
       "...                                                 ...   \n",
       "1563                                                  1   \n",
       "1564                                                  9   \n",
       "1565                                              138/5   \n",
       "1566  Did not bat: Sam Curran, Chris Woakes, Chris J...   \n",
       "1567  Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...   \n",
       "\n",
       "                                                      B  \\\n",
       "0                                                     6   \n",
       "1                                                   NaN   \n",
       "2                                                     9   \n",
       "3                                                   NaN   \n",
       "4                                                    12   \n",
       "...                                                 ...   \n",
       "1563                                                  1   \n",
       "1564                                                NaN   \n",
       "1565                                                NaN   \n",
       "1566  Did not bat: Sam Curran, Chris Woakes, Chris J...   \n",
       "1567  Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...   \n",
       "\n",
       "                                                      M  \\\n",
       "0                                                     7   \n",
       "1                                                   NaN   \n",
       "2                                                    15   \n",
       "3                                                   NaN   \n",
       "4                                                    18   \n",
       "...                                                 ...   \n",
       "1563                                                  3   \n",
       "1564                                                NaN   \n",
       "1565                                                NaN   \n",
       "1566  Did not bat: Sam Curran, Chris Woakes, Chris J...   \n",
       "1567  Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...   \n",
       "\n",
       "                                                     4s  \\\n",
       "0                                                     0   \n",
       "1                                                   NaN   \n",
       "2                                                     1   \n",
       "3                                                   NaN   \n",
       "4                                                     1   \n",
       "...                                                 ...   \n",
       "1563                                                  0   \n",
       "1564                                                NaN   \n",
       "1565                                                NaN   \n",
       "1566  Did not bat: Sam Curran, Chris Woakes, Chris J...   \n",
       "1567  Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...   \n",
       "\n",
       "                                                     6s  \\\n",
       "0                                                     0   \n",
       "1                                                   NaN   \n",
       "2                                                     0   \n",
       "3                                                   NaN   \n",
       "4                                                     2   \n",
       "...                                                 ...   \n",
       "1563                                                  0   \n",
       "1564                                                NaN   \n",
       "1565                                                NaN   \n",
       "1566  Did not bat: Sam Curran, Chris Woakes, Chris J...   \n",
       "1567  Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...   \n",
       "\n",
       "                                                     SR  \\\n",
       "0                                                 50.00   \n",
       "1                                                   NaN   \n",
       "2                                                100.00   \n",
       "3                                                   NaN   \n",
       "4                                                166.66   \n",
       "...                                                 ...   \n",
       "1563                                             100.00   \n",
       "1564                                                NaN   \n",
       "1565                                                NaN   \n",
       "1566  Did not bat: Sam Curran, Chris Woakes, Chris J...   \n",
       "1567  Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...   \n",
       "\n",
       "                                             Unnamed: 8 Unnamed: 9  \\\n",
       "0                                                   NaN        NaN   \n",
       "1                                                   NaN        NaN   \n",
       "2                                                   NaN        NaN   \n",
       "3                                                   NaN        NaN   \n",
       "4                                                   NaN        NaN   \n",
       "...                                                 ...        ...   \n",
       "1563                                                NaN        NaN   \n",
       "1564                                                NaN        NaN   \n",
       "1565                                                NaN        NaN   \n",
       "1566  Did not bat: Sam Curran, Chris Woakes, Chris J...        NaN   \n",
       "1567  Fall of wickets: 1-7 (Alex Hales, 0.6 ov), 2-3...        NaN   \n",
       "\n",
       "                     match     team  \n",
       "0     Namibia vs Sri Lanka  Namibia  \n",
       "1     Namibia vs Sri Lanka  Namibia  \n",
       "2     Namibia vs Sri Lanka  Namibia  \n",
       "3     Namibia vs Sri Lanka  Namibia  \n",
       "4     Namibia vs Sri Lanka  Namibia  \n",
       "...                    ...      ...  \n",
       "1563   Pakistan vs England  England  \n",
       "1564   Pakistan vs England  England  \n",
       "1565   Pakistan vs England  England  \n",
       "1566   Pakistan vs England  England  \n",
       "1567   Pakistan vs England  England  \n",
       "\n",
       "[1568 rows x 12 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.DataFrame(columns=['BATTING', 'Unnamed: 1', 'R', 'B', 'M', '4s', '6s', 'SR', 'Unnamed: 8',\n",
    "       'Unnamed: 9', 'match', 'team'])\n",
    "for url in filtered_urls:\n",
    "    res = requests.get(\"https://stats.espncricinfo.com\"+ url)\n",
    "    soup = BeautifulSoup(res.content, 'html.parser')\n",
    "    div = soup.find_all('div', class_ = 'ds-flex ds-items-center ds-min-w-0 ds-mr-1')\n",
    "    div = div[-2].text +' vs '+ div[-1].text\n",
    "    span = soup.find_all('span', class_='ds-text-title-xs ds-font-bold ds-capitalize')\n",
    "    tables = soup.find_all('table', class_='ci-scorecard-table')\n",
    "    c = 0\n",
    "    for table in tables:\n",
    "        df = pd.read_html(str(table))\n",
    "        df = pd.DataFrame(df[0])\n",
    "        df['match'] = df.apply(lambda row: div, axis=1)\n",
    "        df['team'] = df.apply(lambda row: span[c].text, axis=1)\n",
    "        c = c+1\n",
    "        data = pd.concat([data,df], axis=0, ignore_index=True)\n",
    "data       "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "res = requests.get(\"https://stats.espncricinfo.com/ci/engine/match/1298135.html\")\n",
    "soup = BeautifulSoup(res.content, 'html.parser')\n",
    "tables =  soup.find_all('table', class_='ds-w-full ds-table ds-table-md ds-table-auto')\n",
    "len(tables)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "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>BOWLING</th>\n",
       "      <th>O</th>\n",
       "      <th>M</th>\n",
       "      <th>R</th>\n",
       "      <th>W</th>\n",
       "      <th>ECON</th>\n",
       "      <th>0s</th>\n",
       "      <th>4s</th>\n",
       "      <th>6s</th>\n",
       "      <th>WD</th>\n",
       "      <th>NB</th>\n",
       "      <th>match</th>\n",
       "      <th>team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Maheesh Theekshana</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>5.75</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Sri Lanka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>14.2 to D Wiese, Big appeal for caught behind,...</td>\n",
       "      <td>14.2 to D Wiese, Big appeal for caught behind,...</td>\n",
       "      <td>14.2 to D Wiese, Big appeal for caught behind,...</td>\n",
       "      <td>14.2 to D Wiese, Big appeal for caught behind,...</td>\n",
       "      <td>14.2 to D Wiese, Big appeal for caught behind,...</td>\n",
       "      <td>14.2 to D Wiese, Big appeal for caught behind,...</td>\n",
       "      <td>14.2 to D Wiese, Big appeal for caught behind,...</td>\n",
       "      <td>14.2 to D Wiese, Big appeal for caught behind,...</td>\n",
       "      <td>14.2 to D Wiese, Big appeal for caught behind,...</td>\n",
       "      <td>14.2 to D Wiese, Big appeal for caught behind,...</td>\n",
       "      <td>14.2 to D Wiese, Big appeal for caught behind,...</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Sri Lanka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Dushmantha Chameera</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>9.75</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Sri Lanka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.2 to M van Lingen, Massive top-edge and Cham...</td>\n",
       "      <td>1.2 to M van Lingen, Massive top-edge and Cham...</td>\n",
       "      <td>1.2 to M van Lingen, Massive top-edge and Cham...</td>\n",
       "      <td>1.2 to M van Lingen, Massive top-edge and Cham...</td>\n",
       "      <td>1.2 to M van Lingen, Massive top-edge and Cham...</td>\n",
       "      <td>1.2 to M van Lingen, Massive top-edge and Cham...</td>\n",
       "      <td>1.2 to M van Lingen, Massive top-edge and Cham...</td>\n",
       "      <td>1.2 to M van Lingen, Massive top-edge and Cham...</td>\n",
       "      <td>1.2 to M van Lingen, Massive top-edge and Cham...</td>\n",
       "      <td>1.2 to M van Lingen, Massive top-edge and Cham...</td>\n",
       "      <td>1.2 to M van Lingen, Massive top-edge and Cham...</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Sri Lanka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Pramod Madushan</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "      <td>2</td>\n",
       "      <td>9.25</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Namibia vs Sri Lanka</td>\n",
       "      <td>Sri Lanka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>808</th>\n",
       "      <td>Shadab Khan</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>5.00</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Pakistan vs England</td>\n",
       "      <td>Pakistan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809</th>\n",
       "      <td>12.3 to HC Brook, crashed hard, flat, straight...</td>\n",
       "      <td>12.3 to HC Brook, crashed hard, flat, straight...</td>\n",
       "      <td>12.3 to HC Brook, crashed hard, flat, straight...</td>\n",
       "      <td>12.3 to HC Brook, crashed hard, flat, straight...</td>\n",
       "      <td>12.3 to HC Brook, crashed hard, flat, straight...</td>\n",
       "      <td>12.3 to HC Brook, crashed hard, flat, straight...</td>\n",
       "      <td>12.3 to HC Brook, crashed hard, flat, straight...</td>\n",
       "      <td>12.3 to HC Brook, crashed hard, flat, straight...</td>\n",
       "      <td>12.3 to HC Brook, crashed hard, flat, straight...</td>\n",
       "      <td>12.3 to HC Brook, crashed hard, flat, straight...</td>\n",
       "      <td>12.3 to HC Brook, crashed hard, flat, straight...</td>\n",
       "      <td>Pakistan vs England</td>\n",
       "      <td>Pakistan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>810</th>\n",
       "      <td>Mohammad Wasim</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>9.50</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Pakistan vs England</td>\n",
       "      <td>Pakistan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>811</th>\n",
       "      <td>18.2 to MM Ali, full and straight, and Moeen i...</td>\n",
       "      <td>18.2 to MM Ali, full and straight, and Moeen i...</td>\n",
       "      <td>18.2 to MM Ali, full and straight, and Moeen i...</td>\n",
       "      <td>18.2 to MM Ali, full and straight, and Moeen i...</td>\n",
       "      <td>18.2 to MM Ali, full and straight, and Moeen i...</td>\n",
       "      <td>18.2 to MM Ali, full and straight, and Moeen i...</td>\n",
       "      <td>18.2 to MM Ali, full and straight, and Moeen i...</td>\n",
       "      <td>18.2 to MM Ali, full and straight, and Moeen i...</td>\n",
       "      <td>18.2 to MM Ali, full and straight, and Moeen i...</td>\n",
       "      <td>18.2 to MM Ali, full and straight, and Moeen i...</td>\n",
       "      <td>18.2 to MM Ali, full and straight, and Moeen i...</td>\n",
       "      <td>Pakistan vs England</td>\n",
       "      <td>Pakistan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>812</th>\n",
       "      <td>Iftikhar Ahmed</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>15.60</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Pakistan vs England</td>\n",
       "      <td>Pakistan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>813 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               BOWLING  \\\n",
       "0                                   Maheesh Theekshana   \n",
       "1    14.2 to D Wiese, Big appeal for caught behind,...   \n",
       "2                                  Dushmantha Chameera   \n",
       "3    1.2 to M van Lingen, Massive top-edge and Cham...   \n",
       "4                                      Pramod Madushan   \n",
       "..                                                 ...   \n",
       "808                                        Shadab Khan   \n",
       "809  12.3 to HC Brook, crashed hard, flat, straight...   \n",
       "810                                     Mohammad Wasim   \n",
       "811  18.2 to MM Ali, full and straight, and Moeen i...   \n",
       "812                                     Iftikhar Ahmed   \n",
       "\n",
       "                                                     O  \\\n",
       "0                                                    4   \n",
       "1    14.2 to D Wiese, Big appeal for caught behind,...   \n",
       "2                                                    4   \n",
       "3    1.2 to M van Lingen, Massive top-edge and Cham...   \n",
       "4                                                    4   \n",
       "..                                                 ...   \n",
       "808                                                  4   \n",
       "809  12.3 to HC Brook, crashed hard, flat, straight...   \n",
       "810                                                  4   \n",
       "811  18.2 to MM Ali, full and straight, and Moeen i...   \n",
       "812                                                0.5   \n",
       "\n",
       "                                                     M  \\\n",
       "0                                                    0   \n",
       "1    14.2 to D Wiese, Big appeal for caught behind,...   \n",
       "2                                                    0   \n",
       "3    1.2 to M van Lingen, Massive top-edge and Cham...   \n",
       "4                                                    0   \n",
       "..                                                 ...   \n",
       "808                                                  0   \n",
       "809  12.3 to HC Brook, crashed hard, flat, straight...   \n",
       "810                                                  0   \n",
       "811  18.2 to MM Ali, full and straight, and Moeen i...   \n",
       "812                                                  0   \n",
       "\n",
       "                                                     R  \\\n",
       "0                                                   23   \n",
       "1    14.2 to D Wiese, Big appeal for caught behind,...   \n",
       "2                                                   39   \n",
       "3    1.2 to M van Lingen, Massive top-edge and Cham...   \n",
       "4                                                   37   \n",
       "..                                                 ...   \n",
       "808                                                 20   \n",
       "809  12.3 to HC Brook, crashed hard, flat, straight...   \n",
       "810                                                 38   \n",
       "811  18.2 to MM Ali, full and straight, and Moeen i...   \n",
       "812                                                 13   \n",
       "\n",
       "                                                     W  \\\n",
       "0                                                    1   \n",
       "1    14.2 to D Wiese, Big appeal for caught behind,...   \n",
       "2                                                    1   \n",
       "3    1.2 to M van Lingen, Massive top-edge and Cham...   \n",
       "4                                                    2   \n",
       "..                                                 ...   \n",
       "808                                                  1   \n",
       "809  12.3 to HC Brook, crashed hard, flat, straight...   \n",
       "810                                                  1   \n",
       "811  18.2 to MM Ali, full and straight, and Moeen i...   \n",
       "812                                                  0   \n",
       "\n",
       "                                                  ECON  \\\n",
       "0                                                 5.75   \n",
       "1    14.2 to D Wiese, Big appeal for caught behind,...   \n",
       "2                                                 9.75   \n",
       "3    1.2 to M van Lingen, Massive top-edge and Cham...   \n",
       "4                                                 9.25   \n",
       "..                                                 ...   \n",
       "808                                               5.00   \n",
       "809  12.3 to HC Brook, crashed hard, flat, straight...   \n",
       "810                                               9.50   \n",
       "811  18.2 to MM Ali, full and straight, and Moeen i...   \n",
       "812                                              15.60   \n",
       "\n",
       "                                                    0s  \\\n",
       "0                                                    7   \n",
       "1    14.2 to D Wiese, Big appeal for caught behind,...   \n",
       "2                                                    6   \n",
       "3    1.2 to M van Lingen, Massive top-edge and Cham...   \n",
       "4                                                    6   \n",
       "..                                                 ...   \n",
       "808                                                 10   \n",
       "809  12.3 to HC Brook, crashed hard, flat, straight...   \n",
       "810                                                  5   \n",
       "811  18.2 to MM Ali, full and straight, and Moeen i...   \n",
       "812                                                  0   \n",
       "\n",
       "                                                    4s  \\\n",
       "0                                                    0   \n",
       "1    14.2 to D Wiese, Big appeal for caught behind,...   \n",
       "2                                                    3   \n",
       "3    1.2 to M van Lingen, Massive top-edge and Cham...   \n",
       "4                                                    3   \n",
       "..                                                 ...   \n",
       "808                                                  1   \n",
       "809  12.3 to HC Brook, crashed hard, flat, straight...   \n",
       "810                                                  5   \n",
       "811  18.2 to MM Ali, full and straight, and Moeen i...   \n",
       "812                                                  1   \n",
       "\n",
       "                                                    6s  \\\n",
       "0                                                    0   \n",
       "1    14.2 to D Wiese, Big appeal for caught behind,...   \n",
       "2                                                    1   \n",
       "3    1.2 to M van Lingen, Massive top-edge and Cham...   \n",
       "4                                                    1   \n",
       "..                                                 ...   \n",
       "808                                                  0   \n",
       "809  12.3 to HC Brook, crashed hard, flat, straight...   \n",
       "810                                                  0   \n",
       "811  18.2 to MM Ali, full and straight, and Moeen i...   \n",
       "812                                                  1   \n",
       "\n",
       "                                                    WD  \\\n",
       "0                                                    2   \n",
       "1    14.2 to D Wiese, Big appeal for caught behind,...   \n",
       "2                                                    2   \n",
       "3    1.2 to M van Lingen, Massive top-edge and Cham...   \n",
       "4                                                    0   \n",
       "..                                                 ...   \n",
       "808                                                  0   \n",
       "809  12.3 to HC Brook, crashed hard, flat, straight...   \n",
       "810                                                  2   \n",
       "811  18.2 to MM Ali, full and straight, and Moeen i...   \n",
       "812                                                  0   \n",
       "\n",
       "                                                    NB                 match  \\\n",
       "0                                                    0  Namibia vs Sri Lanka   \n",
       "1    14.2 to D Wiese, Big appeal for caught behind,...  Namibia vs Sri Lanka   \n",
       "2                                                    0  Namibia vs Sri Lanka   \n",
       "3    1.2 to M van Lingen, Massive top-edge and Cham...  Namibia vs Sri Lanka   \n",
       "4                                                    0  Namibia vs Sri Lanka   \n",
       "..                                                 ...                   ...   \n",
       "808                                                  0   Pakistan vs England   \n",
       "809  12.3 to HC Brook, crashed hard, flat, straight...   Pakistan vs England   \n",
       "810                                                  0   Pakistan vs England   \n",
       "811  18.2 to MM Ali, full and straight, and Moeen i...   Pakistan vs England   \n",
       "812                                                  0   Pakistan vs England   \n",
       "\n",
       "          team  \n",
       "0    Sri Lanka  \n",
       "1    Sri Lanka  \n",
       "2    Sri Lanka  \n",
       "3    Sri Lanka  \n",
       "4    Sri Lanka  \n",
       "..         ...  \n",
       "808   Pakistan  \n",
       "809   Pakistan  \n",
       "810   Pakistan  \n",
       "811   Pakistan  \n",
       "812   Pakistan  \n",
       "\n",
       "[813 rows x 13 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.DataFrame()\n",
    "for url in filtered_urls:\n",
    "    res = requests.get(\"https://stats.espncricinfo.com\"+ url)\n",
    "    soup = BeautifulSoup(res.content, 'html.parser')\n",
    "    tables =  soup.find_all('table', class_='ds-w-full ds-table ds-table-md ds-table-auto')\n",
    "    div = soup.find_all('div', class_ = 'ds-flex ds-items-center ds-min-w-0 ds-mr-1')\n",
    "    div = div[-2].text +' vs '+ div[-1].text\n",
    "    span = soup.find_all('span', class_='ds-text-title-xs ds-font-bold ds-capitalize')\n",
    "    c=1\n",
    "    for table in tables:\n",
    "        df = pd.read_html(str(table))\n",
    "        df = pd.DataFrame(df[0])\n",
    "        df['match'] = df.apply(lambda row: div, axis=1)\n",
    "        df['team'] = df.apply(lambda row: span[c].text, axis=1)\n",
    "        c = c-1\n",
    "        data = pd.concat([data,df], axis=0, ignore_index=True)\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['/player/jan-frylinck-482478',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/michael-van-lingen-833777',\n",
       " '/player/divan-la-cock-1178065',\n",
       " '/player/jan-nicol-loftie-eaton-1071473',\n",
       " '/player/stephan-baard-437927',\n",
       " '/player/gerhard-erasmus-519070',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/david-wiese-221140',\n",
       " '/player/jj-smit-553821',\n",
       " '/player/zane-green-596664',\n",
       " '/player/bernard-scholtz-330223',\n",
       " '/player/ben-shikongo-1069820',\n",
       " '/player/maheesh-theekshana-1138316',\n",
       " '/player/dushmantha-chameera-552152',\n",
       " '/player/pramod-madushan-826689',\n",
       " '/player/chamika-karunaratne-623695',\n",
       " '/player/wanindu-hasaranga-de-silva-784379',\n",
       " '/player/pathum-nissanka-1028655',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/dhananjaya-de-silva-465793',\n",
       " '/player/danushka-gunathilaka-345821',\n",
       " '/player/bhanuka-rajapaksa-342619',\n",
       " '/player/dasun-shanaka-437316',\n",
       " '/player/wanindu-hasaranga-de-silva-784379',\n",
       " '/player/chamika-karunaratne-623695',\n",
       " '/player/pramod-madushan-826689',\n",
       " '/player/dushmantha-chameera-552152',\n",
       " '/player/maheesh-theekshana-1138316',\n",
       " '/player/gerhard-erasmus-519070',\n",
       " '/player/david-wiese-221140',\n",
       " '/player/bernard-scholtz-330223',\n",
       " '/player/ben-shikongo-1069820',\n",
       " '/player/jj-smit-553821',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/joel-wilson-387601',\n",
       " '/player/rod-tucker-7986',\n",
       " '/player/paul-reiffel-7326',\n",
       " '/player/marais-erasmus-44971',\n",
       " '/player/andy-pycroft-55700',\n",
       " '/player/pathum-nissanka-1028655',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/dhananjaya-de-silva-465793',\n",
       " '/player/danushka-gunathilaka-345821',\n",
       " '/player/bhanuka-rajapaksa-342619',\n",
       " '/player/dasun-shanaka-437316',\n",
       " '/player/wanindu-hasaranga-de-silva-784379',\n",
       " '/player/chamika-karunaratne-623695',\n",
       " '/player/pramod-madushan-826689',\n",
       " '/player/dushmantha-chameera-552152',\n",
       " '/player/maheesh-theekshana-1138316',\n",
       " '/player/gerhard-erasmus-519070',\n",
       " '/player/david-wiese-221140',\n",
       " '/player/bernard-scholtz-330223',\n",
       " '/player/ben-shikongo-1069820',\n",
       " '/player/jj-smit-553821',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/junaid-siddique-1203754',\n",
       " '/player/junaid-siddique-1203754',\n",
       " '/player/chirag-suri-534734',\n",
       " '/player/muhammad-waseem-1241277',\n",
       " '/player/kashif-daud-229225',\n",
       " '/player/vriitya-aravind-1178586',\n",
       " '/player/zawar-farid-1196500',\n",
       " '/player/basil-hameed-1209110',\n",
       " '/player/chundangapoyil-rizwan-474760',\n",
       " '/player/aayan-afzal-khan-1241265',\n",
       " '/player/karthik-meiyappan-1058987',\n",
       " '/player/junaid-siddique-1203754',\n",
       " '/player/zahoor-khan-384525',\n",
       " '/player/fred-klaassen-1104703',\n",
       " '/player/tim-pringle-1193548',\n",
       " '/player/logan-van-beek-440522',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/paul-van-meekeren-348109',\n",
       " '/player/roelof-van-der-merwe-47850',\n",
       " '/player/vikramjit-singh-1153767',\n",
       " '/player/max-o-dowd-643197',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/colin-ackermann-379774',\n",
       " '/player/tom-cooper-219885',\n",
       " '/player/scott-edwards-1127317',\n",
       " '/player/roelof-van-der-merwe-47850',\n",
       " '/player/tim-pringle-1193548',\n",
       " '/player/logan-van-beek-440522',\n",
       " '/player/fred-klaassen-1104703',\n",
       " '/player/paul-van-meekeren-348109',\n",
       " '/player/junaid-siddique-1203754',\n",
       " '/player/basil-hameed-1209110',\n",
       " '/player/aayan-afzal-khan-1241265',\n",
       " '/player/karthik-meiyappan-1058987',\n",
       " '/player/zahoor-khan-384525',\n",
       " '/player/zawar-farid-1196500',\n",
       " '/player/kashif-daud-229225',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/paul-reiffel-7326',\n",
       " '/player/richard-kettleborough-15872',\n",
       " '/player/rod-tucker-7986',\n",
       " '/player/joel-wilson-387601',\n",
       " '/player/ranjan-madugalle-49623',\n",
       " '/player/vikramjit-singh-1153767',\n",
       " '/player/max-o-dowd-643197',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/colin-ackermann-379774',\n",
       " '/player/tom-cooper-219885',\n",
       " '/player/scott-edwards-1127317',\n",
       " '/player/roelof-van-der-merwe-47850',\n",
       " '/player/tim-pringle-1193548',\n",
       " '/player/logan-van-beek-440522',\n",
       " '/player/junaid-siddique-1203754',\n",
       " '/player/basil-hameed-1209110',\n",
       " '/player/aayan-afzal-khan-1241265',\n",
       " '/player/karthik-meiyappan-1058987',\n",
       " '/player/zahoor-khan-384525',\n",
       " '/player/zawar-farid-1196500',\n",
       " '/player/kashif-daud-229225',\n",
       " '/player/george-munsey-671805',\n",
       " '/player/george-munsey-671805',\n",
       " '/player/george-munsey-671805',\n",
       " '/player/george-munsey-671805',\n",
       " '/player/george-munsey-671805',\n",
       " '/player/michael-jones-1093091',\n",
       " '/player/matthew-cross-417268',\n",
       " '/player/richie-berrington-25490',\n",
       " '/player/calum-macleod-232435',\n",
       " '/player/michael-leask-414966',\n",
       " '/player/chris-greaves-873199',\n",
       " '/player/mark-watt-659081',\n",
       " '/player/josh-davey-407265',\n",
       " '/player/safyaan-sharif-414970',\n",
       " '/player/brad-wheal-807535',\n",
       " '/player/kyle-mayers-348056',\n",
       " '/player/akeal-hosein-530812',\n",
       " '/player/alzarri-joseph-670031',\n",
       " '/player/obed-mccoy-906783',\n",
       " '/player/jason-holder-391485',\n",
       " '/player/odean-smith-820691',\n",
       " '/player/kyle-mayers-348056',\n",
       " '/player/evin-lewis-431901',\n",
       " '/player/brandon-king-670035',\n",
       " '/player/nicholas-pooran-604302',\n",
       " '/player/shamarh-brooks-230555',\n",
       " '/player/rovman-powell-820351',\n",
       " '/player/jason-holder-391485',\n",
       " '/player/akeal-hosein-530812',\n",
       " '/player/alzarri-joseph-670031',\n",
       " '/player/odean-smith-820691',\n",
       " '/player/obed-mccoy-906783',\n",
       " '/player/mark-watt-659081',\n",
       " '/player/brad-wheal-807535',\n",
       " '/player/josh-davey-407265',\n",
       " '/player/safyaan-sharif-414970',\n",
       " '/player/michael-leask-414966',\n",
       " '/player/george-munsey-671805',\n",
       " '/player/aleem-dar-39157',\n",
       " '/player/paul-wilson-8241',\n",
       " '/player/chris-brown-36352',\n",
       " '/player/kumar-dharmasena-48469',\n",
       " '/player/chris-broad-9230',\n",
       " '/player/kyle-mayers-348056',\n",
       " '/player/evin-lewis-431901',\n",
       " '/player/brandon-king-670035',\n",
       " '/player/nicholas-pooran-604302',\n",
       " '/player/shamarh-brooks-230555',\n",
       " '/player/rovman-powell-820351',\n",
       " '/player/jason-holder-391485',\n",
       " '/player/akeal-hosein-530812',\n",
       " '/player/alzarri-joseph-670031',\n",
       " '/player/odean-smith-820691',\n",
       " '/player/obed-mccoy-906783',\n",
       " '/player/mark-watt-659081',\n",
       " '/player/brad-wheal-807535',\n",
       " '/player/josh-davey-407265',\n",
       " '/player/safyaan-sharif-414970',\n",
       " '/player/michael-leask-414966',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/regis-chakabva-293831',\n",
       " '/player/craig-ervine-55412',\n",
       " '/player/wessly-madhevere-938959',\n",
       " '/player/sean-williams-55870',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/milton-shumba-951781',\n",
       " '/player/ryan-burl-495964',\n",
       " '/player/luke-jongwe-541224',\n",
       " '/player/tendai-chatara-425639',\n",
       " '/player/richard-ngarava-806241',\n",
       " '/player/blessing-muzarabani-827051',\n",
       " '/player/josh-little-928067',\n",
       " '/player/mark-adair-526441',\n",
       " '/player/barry-mccarthy-348059',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/simi-singh-1005257',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/paul-stirling-303427',\n",
       " '/player/andy-balbirnie-303423',\n",
       " '/player/lorcan-tucker-928057',\n",
       " '/player/harry-tector-961407',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/george-dockrell-348034',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/mark-adair-526441',\n",
       " '/player/simi-singh-1005257',\n",
       " '/player/barry-mccarthy-348059',\n",
       " '/player/josh-little-928067',\n",
       " '/player/richard-ngarava-806241',\n",
       " '/player/tendai-chatara-425639',\n",
       " '/player/blessing-muzarabani-827051',\n",
       " '/player/luke-jongwe-541224',\n",
       " '/player/sean-williams-55870',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/chris-brown-36352',\n",
       " '/player/kumar-dharmasena-48469',\n",
       " '/player/aleem-dar-39157',\n",
       " '/player/paul-wilson-8241',\n",
       " '/player/chris-broad-9230',\n",
       " '/player/paul-stirling-303427',\n",
       " '/player/andy-balbirnie-303423',\n",
       " '/player/lorcan-tucker-928057',\n",
       " '/player/harry-tector-961407',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/george-dockrell-348034',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/mark-adair-526441',\n",
       " '/player/simi-singh-1005257',\n",
       " '/player/barry-mccarthy-348059',\n",
       " '/player/josh-little-928067',\n",
       " '/player/richard-ngarava-806241',\n",
       " '/player/tendai-chatara-425639',\n",
       " '/player/blessing-muzarabani-827051',\n",
       " '/player/luke-jongwe-541224',\n",
       " '/player/sean-williams-55870',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/michael-van-lingen-833777',\n",
       " '/player/divan-la-cock-1178065',\n",
       " '/player/stephan-baard-437927',\n",
       " '/player/jan-nicol-loftie-eaton-1071473',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/gerhard-erasmus-519070',\n",
       " '/player/david-wiese-221140',\n",
       " '/player/jj-smit-553821',\n",
       " '/player/zane-green-596664',\n",
       " '/player/bernard-scholtz-330223',\n",
       " '/player/ben-shikongo-1069820',\n",
       " '/player/fred-klaassen-1104703',\n",
       " '/player/tim-pringle-1193548',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/colin-ackermann-379774',\n",
       " '/player/paul-van-meekeren-348109',\n",
       " '/player/timm-van-der-gugten-333782',\n",
       " '/player/roelof-van-der-merwe-47850',\n",
       " '/player/max-o-dowd-643197',\n",
       " '/player/vikramjit-singh-1153767',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/tom-cooper-219885',\n",
       " '/player/colin-ackermann-379774',\n",
       " '/player/scott-edwards-1127317',\n",
       " '/player/tim-pringle-1193548',\n",
       " '/player/roelof-van-der-merwe-47850',\n",
       " '/player/timm-van-der-gugten-333782',\n",
       " '/player/fred-klaassen-1104703',\n",
       " '/player/paul-van-meekeren-348109',\n",
       " '/player/bernard-scholtz-330223',\n",
       " '/player/david-wiese-221140',\n",
       " '/player/gerhard-erasmus-519070',\n",
       " '/player/ben-shikongo-1069820',\n",
       " '/player/jj-smit-553821',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/jan-nicol-loftie-eaton-1071473',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/joel-wilson-387601',\n",
       " '/player/richard-kettleborough-15872',\n",
       " '/player/marais-erasmus-44971',\n",
       " '/player/rod-tucker-7986',\n",
       " '/player/ranjan-madugalle-49623',\n",
       " '/player/max-o-dowd-643197',\n",
       " '/player/vikramjit-singh-1153767',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/tom-cooper-219885',\n",
       " '/player/colin-ackermann-379774',\n",
       " '/player/scott-edwards-1127317',\n",
       " '/player/tim-pringle-1193548',\n",
       " '/player/bernard-scholtz-330223',\n",
       " '/player/david-wiese-221140',\n",
       " '/player/gerhard-erasmus-519070',\n",
       " '/player/ben-shikongo-1069820',\n",
       " '/player/jj-smit-553821',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/jan-nicol-loftie-eaton-1071473',\n",
       " '/player/pathum-nissanka-1028655',\n",
       " '/player/pathum-nissanka-1028655',\n",
       " '/player/pathum-nissanka-1028655',\n",
       " '/player/pathum-nissanka-1028655',\n",
       " '/player/pathum-nissanka-1028655',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/dhananjaya-de-silva-465793',\n",
       " '/player/bhanuka-rajapaksa-342619',\n",
       " '/player/charith-asalanka-784367',\n",
       " '/player/dasun-shanaka-437316',\n",
       " '/player/wanindu-hasaranga-de-silva-784379',\n",
       " '/player/chamika-karunaratne-623695',\n",
       " '/player/pramod-madushan-826689',\n",
       " '/player/dushmantha-chameera-552152',\n",
       " '/player/maheesh-theekshana-1138316',\n",
       " '/player/junaid-siddique-1203754',\n",
       " '/player/kashif-daud-229225',\n",
       " '/player/zahoor-khan-384525',\n",
       " '/player/aayan-afzal-khan-1241265',\n",
       " '/player/aryan-lakra-1058989',\n",
       " '/player/karthik-meiyappan-1058987',\n",
       " '/player/basil-hameed-1209110',\n",
       " '/player/muhammad-waseem-1241277',\n",
       " '/player/chirag-suri-534734',\n",
       " '/player/aryan-lakra-1058989',\n",
       " '/player/chundangapoyil-rizwan-474760',\n",
       " '/player/vriitya-aravind-1178586',\n",
       " '/player/basil-hameed-1209110',\n",
       " '/player/aayan-afzal-khan-1241265',\n",
       " '/player/kashif-daud-229225',\n",
       " '/player/karthik-meiyappan-1058987',\n",
       " '/player/junaid-siddique-1203754',\n",
       " '/player/zahoor-khan-384525',\n",
       " '/player/pramod-madushan-826689',\n",
       " '/player/maheesh-theekshana-1138316',\n",
       " '/player/dushmantha-chameera-552152',\n",
       " '/player/chamika-karunaratne-623695',\n",
       " '/player/wanindu-hasaranga-de-silva-784379',\n",
       " '/player/dasun-shanaka-437316',\n",
       " '/player/pathum-nissanka-1028655',\n",
       " '/player/marais-erasmus-44971',\n",
       " '/player/rod-tucker-7986',\n",
       " '/player/joel-wilson-387601',\n",
       " '/player/richard-kettleborough-15872',\n",
       " '/player/andy-pycroft-55700',\n",
       " '/player/muhammad-waseem-1241277',\n",
       " '/player/chirag-suri-534734',\n",
       " '/player/aryan-lakra-1058989',\n",
       " '/player/chundangapoyil-rizwan-474760',\n",
       " '/player/vriitya-aravind-1178586',\n",
       " '/player/basil-hameed-1209110',\n",
       " '/player/aayan-afzal-khan-1241265',\n",
       " '/player/kashif-daud-229225',\n",
       " '/player/karthik-meiyappan-1058987',\n",
       " '/player/junaid-siddique-1203754',\n",
       " '/player/zahoor-khan-384525',\n",
       " '/player/pramod-madushan-826689',\n",
       " '/player/maheesh-theekshana-1138316',\n",
       " '/player/dushmantha-chameera-552152',\n",
       " '/player/chamika-karunaratne-623695',\n",
       " '/player/wanindu-hasaranga-de-silva-784379',\n",
       " '/player/dasun-shanaka-437316',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/george-munsey-671805',\n",
       " '/player/michael-jones-1093091',\n",
       " '/player/matthew-cross-417268',\n",
       " '/player/richie-berrington-25490',\n",
       " '/player/michael-leask-414966',\n",
       " '/player/calum-macleod-232435',\n",
       " '/player/chris-greaves-873199',\n",
       " '/player/mark-watt-659081',\n",
       " '/player/josh-davey-407265',\n",
       " '/player/safyaan-sharif-414970',\n",
       " '/player/brad-wheal-807535',\n",
       " '/player/josh-little-928067',\n",
       " '/player/mark-adair-526441',\n",
       " '/player/barry-mccarthy-348059',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/simi-singh-1005257',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/george-dockrell-348034',\n",
       " '/player/paul-stirling-303427',\n",
       " '/player/andy-balbirnie-303423',\n",
       " '/player/lorcan-tucker-928057',\n",
       " '/player/harry-tector-961407',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/george-dockrell-348034',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/mark-adair-526441',\n",
       " '/player/simi-singh-1005257',\n",
       " '/player/barry-mccarthy-348059',\n",
       " '/player/josh-little-928067',\n",
       " '/player/mark-watt-659081',\n",
       " '/player/brad-wheal-807535',\n",
       " '/player/josh-davey-407265',\n",
       " '/player/safyaan-sharif-414970',\n",
       " '/player/chris-greaves-873199',\n",
       " '/player/michael-leask-414966',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/chris-brown-36352',\n",
       " '/player/kumar-dharmasena-48469',\n",
       " '/player/paul-wilson-8241',\n",
       " '/player/aleem-dar-39157',\n",
       " '/player/chris-broad-9230',\n",
       " '/player/paul-stirling-303427',\n",
       " '/player/andy-balbirnie-303423',\n",
       " '/player/lorcan-tucker-928057',\n",
       " '/player/harry-tector-961407',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/george-dockrell-348034',\n",
       " '/player/mark-watt-659081',\n",
       " '/player/brad-wheal-807535',\n",
       " '/player/josh-davey-407265',\n",
       " '/player/safyaan-sharif-414970',\n",
       " '/player/chris-greaves-873199',\n",
       " '/player/michael-leask-414966',\n",
       " '/player/alzarri-joseph-670031',\n",
       " '/player/alzarri-joseph-670031',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/kyle-mayers-348056',\n",
       " '/player/johnson-charles-333066',\n",
       " '/player/evin-lewis-431901',\n",
       " '/player/nicholas-pooran-604302',\n",
       " '/player/rovman-powell-820351',\n",
       " '/player/shamarh-brooks-230555',\n",
       " '/player/jason-holder-391485',\n",
       " '/player/akeal-hosein-530812',\n",
       " '/player/odean-smith-820691',\n",
       " '/player/alzarri-joseph-670031',\n",
       " '/player/obed-mccoy-906783',\n",
       " '/player/richard-ngarava-806241',\n",
       " '/player/tendai-chatara-425639',\n",
       " '/player/blessing-muzarabani-827051',\n",
       " '/player/ryan-burl-495964',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/sean-williams-55870',\n",
       " '/player/wessly-madhevere-938959',\n",
       " '/player/regis-chakabva-293831',\n",
       " '/player/tony-munyonga-1122853',\n",
       " '/player/sean-williams-55870',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/milton-shumba-951781',\n",
       " '/player/ryan-burl-495964',\n",
       " '/player/luke-jongwe-541224',\n",
       " '/player/richard-ngarava-806241',\n",
       " '/player/tendai-chatara-425639',\n",
       " '/player/blessing-muzarabani-827051',\n",
       " '/player/kyle-mayers-348056',\n",
       " '/player/akeal-hosein-530812',\n",
       " '/player/alzarri-joseph-670031',\n",
       " '/player/obed-mccoy-906783',\n",
       " '/player/jason-holder-391485',\n",
       " '/player/odean-smith-820691',\n",
       " '/player/alzarri-joseph-670031',\n",
       " '/player/aleem-dar-39157',\n",
       " '/player/paul-wilson-8241',\n",
       " '/player/kumar-dharmasena-48469',\n",
       " '/player/chris-brown-36352',\n",
       " '/player/chris-broad-9230',\n",
       " '/player/wessly-madhevere-938959',\n",
       " '/player/regis-chakabva-293831',\n",
       " '/player/tony-munyonga-1122853',\n",
       " '/player/sean-williams-55870',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/milton-shumba-951781',\n",
       " '/player/ryan-burl-495964',\n",
       " '/player/luke-jongwe-541224',\n",
       " '/player/richard-ngarava-806241',\n",
       " '/player/tendai-chatara-425639',\n",
       " '/player/blessing-muzarabani-827051',\n",
       " '/player/kyle-mayers-348056',\n",
       " '/player/akeal-hosein-530812',\n",
       " '/player/alzarri-joseph-670031',\n",
       " '/player/obed-mccoy-906783',\n",
       " '/player/jason-holder-391485',\n",
       " '/player/odean-smith-820691',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/pathum-nissanka-1028655',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/dhananjaya-de-silva-465793',\n",
       " '/player/charith-asalanka-784367',\n",
       " '/player/bhanuka-rajapaksa-342619',\n",
       " '/player/dasun-shanaka-437316',\n",
       " '/player/wanindu-hasaranga-de-silva-784379',\n",
       " '/player/chamika-karunaratne-623695',\n",
       " '/player/maheesh-theekshana-1138316',\n",
       " '/player/lahiru-kumara-784375',\n",
       " '/player/binura-fernando-629080',\n",
       " '/player/fred-klaassen-1104703',\n",
       " '/player/tim-pringle-1193548',\n",
       " '/player/roelof-van-der-merwe-47850',\n",
       " '/player/paul-van-meekeren-348109',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/timm-van-der-gugten-333782',\n",
       " '/player/max-o-dowd-643197',\n",
       " '/player/vikramjit-singh-1153767',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/colin-ackermann-379774',\n",
       " '/player/tom-cooper-219885',\n",
       " '/player/scott-edwards-1127317',\n",
       " '/player/tim-pringle-1193548',\n",
       " '/player/timm-van-der-gugten-333782',\n",
       " '/player/fred-klaassen-1104703',\n",
       " '/player/paul-van-meekeren-348109',\n",
       " '/player/roelof-van-der-merwe-47850',\n",
       " '/player/dhananjaya-de-silva-465793',\n",
       " '/player/lahiru-kumara-784375',\n",
       " '/player/binura-fernando-629080',\n",
       " '/player/maheesh-theekshana-1138316',\n",
       " '/player/wanindu-hasaranga-de-silva-784379',\n",
       " '/player/chamika-karunaratne-623695',\n",
       " '/player/dasun-shanaka-437316',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/joel-wilson-387601',\n",
       " '/player/marais-erasmus-44971',\n",
       " '/player/richard-kettleborough-15872',\n",
       " '/player/richard-illingworth-15383',\n",
       " '/player/andy-pycroft-55700',\n",
       " '/player/max-o-dowd-643197',\n",
       " '/player/vikramjit-singh-1153767',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/colin-ackermann-379774',\n",
       " '/player/tom-cooper-219885',\n",
       " '/player/scott-edwards-1127317',\n",
       " '/player/tim-pringle-1193548',\n",
       " '/player/timm-van-der-gugten-333782',\n",
       " '/player/fred-klaassen-1104703',\n",
       " '/player/paul-van-meekeren-348109',\n",
       " '/player/roelof-van-der-merwe-47850',\n",
       " '/player/dhananjaya-de-silva-465793',\n",
       " '/player/lahiru-kumara-784375',\n",
       " '/player/binura-fernando-629080',\n",
       " '/player/maheesh-theekshana-1138316',\n",
       " '/player/wanindu-hasaranga-de-silva-784379',\n",
       " '/player/chamika-karunaratne-623695',\n",
       " '/player/dasun-shanaka-437316',\n",
       " '/player/muhammad-waseem-1241277',\n",
       " '/player/muhammad-waseem-1241277',\n",
       " '/player/david-wiese-221140',\n",
       " '/player/david-wiese-221140',\n",
       " '/player/muhammad-waseem-1241277',\n",
       " '/player/vriitya-aravind-1178586',\n",
       " '/player/chundangapoyil-rizwan-474760',\n",
       " '/player/alishan-sharafu-1161038',\n",
       " '/player/basil-hameed-1209110',\n",
       " '/player/aayan-afzal-khan-1241265',\n",
       " '/player/fahad-nawaz-1126002',\n",
       " '/player/karthik-meiyappan-1058987',\n",
       " '/player/ahmed-raza-245490',\n",
       " '/player/junaid-siddique-1203754',\n",
       " '/player/zahoor-khan-384525',\n",
       " '/player/ruben-trumpelmann-698317',\n",
       " '/player/david-wiese-221140',\n",
       " '/player/bernard-scholtz-330223',\n",
       " '/player/jj-smit-553821',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/ben-shikongo-1069820',\n",
       " '/player/michael-van-lingen-833777',\n",
       " '/player/stephan-baard-437927',\n",
       " '/player/jan-nicol-loftie-eaton-1071473',\n",
       " '/player/gerhard-erasmus-519070',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/jj-smit-553821',\n",
       " '/player/david-wiese-221140',\n",
       " '/player/zane-green-596664',\n",
       " '/player/ruben-trumpelmann-698317',\n",
       " '/player/bernard-scholtz-330223',\n",
       " '/player/ben-shikongo-1069820',\n",
       " '/player/basil-hameed-1209110',\n",
       " '/player/junaid-siddique-1203754',\n",
       " '/player/zahoor-khan-384525',\n",
       " '/player/ahmed-raza-245490',\n",
       " '/player/karthik-meiyappan-1058987',\n",
       " '/player/aayan-afzal-khan-1241265',\n",
       " '/player/muhammad-waseem-1241277',\n",
       " '/player/muhammad-waseem-1241277',\n",
       " '/player/fahad-nawaz-1126002',\n",
       " '/player/fahad-nawaz-1126002',\n",
       " '/player/richard-illingworth-15383',\n",
       " '/player/richard-kettleborough-15872',\n",
       " '/player/joel-wilson-387601',\n",
       " '/player/marais-erasmus-44971',\n",
       " '/player/ranjan-madugalle-49623',\n",
       " '/player/michael-van-lingen-833777',\n",
       " '/player/stephan-baard-437927',\n",
       " '/player/jan-nicol-loftie-eaton-1071473',\n",
       " '/player/gerhard-erasmus-519070',\n",
       " '/player/jan-frylinck-482478',\n",
       " '/player/jj-smit-553821',\n",
       " '/player/david-wiese-221140',\n",
       " '/player/zane-green-596664',\n",
       " '/player/ruben-trumpelmann-698317',\n",
       " '/player/bernard-scholtz-330223',\n",
       " '/player/basil-hameed-1209110',\n",
       " '/player/junaid-siddique-1203754',\n",
       " '/player/zahoor-khan-384525',\n",
       " '/player/ahmed-raza-245490',\n",
       " '/player/karthik-meiyappan-1058987',\n",
       " '/player/aayan-afzal-khan-1241265',\n",
       " '/player/muhammad-waseem-1241277',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/kyle-mayers-348056',\n",
       " '/player/johnson-charles-333066',\n",
       " '/player/evin-lewis-431901',\n",
       " '/player/brandon-king-670035',\n",
       " '/player/nicholas-pooran-604302',\n",
       " '/player/rovman-powell-820351',\n",
       " '/player/odean-smith-820691',\n",
       " '/player/jason-holder-391485',\n",
       " '/player/akeal-hosein-530812',\n",
       " '/player/alzarri-joseph-670031',\n",
       " '/player/obed-mccoy-906783',\n",
       " '/player/josh-little-928067',\n",
       " '/player/mark-adair-526441',\n",
       " '/player/barry-mccarthy-348059',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/simi-singh-1005257',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/paul-stirling-303427',\n",
       " '/player/andy-balbirnie-303423',\n",
       " '/player/lorcan-tucker-928057',\n",
       " '/player/harry-tector-961407',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/george-dockrell-348034',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/mark-adair-526441',\n",
       " '/player/simi-singh-1005257',\n",
       " '/player/barry-mccarthy-348059',\n",
       " '/player/josh-little-928067',\n",
       " '/player/obed-mccoy-906783',\n",
       " '/player/akeal-hosein-530812',\n",
       " '/player/alzarri-joseph-670031',\n",
       " '/player/odean-smith-820691',\n",
       " '/player/jason-holder-391485',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/ahsan-raza-39146',\n",
       " '/player/chris-gaffaney-37097',\n",
       " '/player/michael-gough-13413',\n",
       " '/player/nitin-menon-30988',\n",
       " '/player/david-boon-4169',\n",
       " '/player/paul-stirling-303427',\n",
       " '/player/andy-balbirnie-303423',\n",
       " '/player/lorcan-tucker-928057',\n",
       " '/player/obed-mccoy-906783',\n",
       " '/player/akeal-hosein-530812',\n",
       " '/player/alzarri-joseph-670031',\n",
       " '/player/odean-smith-820691',\n",
       " '/player/jason-holder-391485',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/george-munsey-671805',\n",
       " '/player/michael-jones-1093091',\n",
       " '/player/matthew-cross-417268',\n",
       " '/player/richie-berrington-25490',\n",
       " '/player/calum-macleod-232435',\n",
       " '/player/michael-leask-414966',\n",
       " '/player/chris-greaves-873199',\n",
       " '/player/josh-davey-407265',\n",
       " '/player/mark-watt-659081',\n",
       " '/player/safyaan-sharif-414970',\n",
       " '/player/brad-wheal-807535',\n",
       " '/player/tendai-chatara-425639',\n",
       " '/player/richard-ngarava-806241',\n",
       " '/player/blessing-muzarabani-827051',\n",
       " '/player/sean-williams-55870',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/wessly-madhevere-938959',\n",
       " '/player/regis-chakabva-293831',\n",
       " '/player/craig-ervine-55412',\n",
       " '/player/wessly-madhevere-938959',\n",
       " '/player/sean-williams-55870',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/milton-shumba-951781',\n",
       " '/player/ryan-burl-495964',\n",
       " '/player/luke-jongwe-541224',\n",
       " '/player/richard-ngarava-806241',\n",
       " '/player/tendai-chatara-425639',\n",
       " '/player/blessing-muzarabani-827051',\n",
       " '/player/brad-wheal-807535',\n",
       " '/player/josh-davey-407265',\n",
       " '/player/safyaan-sharif-414970',\n",
       " '/player/mark-watt-659081',\n",
       " '/player/michael-leask-414966',\n",
       " '/player/calum-macleod-232435',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/michael-gough-13413',\n",
       " '/player/nitin-menon-30988',\n",
       " '/player/ahsan-raza-39146',\n",
       " '/player/chris-gaffaney-37097',\n",
       " '/player/david-boon-4169',\n",
       " '/player/regis-chakabva-293831',\n",
       " '/player/craig-ervine-55412',\n",
       " '/player/wessly-madhevere-938959',\n",
       " '/player/sean-williams-55870',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/milton-shumba-951781',\n",
       " '/player/ryan-burl-495964',\n",
       " '/player/brad-wheal-807535',\n",
       " '/player/josh-davey-407265',\n",
       " '/player/safyaan-sharif-414970',\n",
       " '/player/mark-watt-659081',\n",
       " '/player/michael-leask-414966',\n",
       " '/player/calum-macleod-232435',\n",
       " '/player/devon-conway-379140',\n",
       " '/player/devon-conway-379140',\n",
       " '/player/devon-conway-379140',\n",
       " '/player/devon-conway-379140',\n",
       " '/player/finn-allen-959759',\n",
       " '/player/devon-conway-379140',\n",
       " '/player/kane-williamson-277906',\n",
       " '/player/glenn-phillips-823509',\n",
       " '/player/james-neesham-355269',\n",
       " '/player/mark-chapman-438563',\n",
       " '/player/mitchell-santner-502714',\n",
       " '/player/ish-sodhi-559066',\n",
       " '/player/tim-southee-232364',\n",
       " '/player/lockie-ferguson-493773',\n",
       " '/player/trent-boult-277912',\n",
       " '/player/mitchell-starc-311592',\n",
       " '/player/josh-hazlewood-288284',\n",
       " '/player/pat-cummins-489889',\n",
       " '/player/marcus-stoinis-325012',\n",
       " '/player/adam-zampa-379504',\n",
       " '/player/david-warner-219889',\n",
       " '/player/aaron-finch-5334',\n",
       " '/player/mitchell-marsh-272450',\n",
       " '/player/glenn-maxwell-325026',\n",
       " '/player/marcus-stoinis-325012',\n",
       " '/player/tim-david-892749',\n",
       " '/player/matthew-wade-230193',\n",
       " '/player/pat-cummins-489889',\n",
       " '/player/mitchell-starc-311592',\n",
       " '/player/adam-zampa-379504',\n",
       " '/player/josh-hazlewood-288284',\n",
       " '/player/trent-boult-277912',\n",
       " '/player/tim-southee-232364',\n",
       " '/player/mitchell-santner-502714',\n",
       " '/player/lockie-ferguson-493773',\n",
       " '/player/ish-sodhi-559066',\n",
       " '/player/devon-conway-379140',\n",
       " '/player/adrian-holdstock-45448',\n",
       " '/player/kumar-dharmasena-48469',\n",
       " '/player/langton-rusere-393453',\n",
       " '/player/richard-illingworth-15383',\n",
       " '/player/chris-broad-9230',\n",
       " '/player/david-warner-219889',\n",
       " '/player/aaron-finch-5334',\n",
       " '/player/mitchell-marsh-272450',\n",
       " '/player/glenn-maxwell-325026',\n",
       " '/player/marcus-stoinis-325012',\n",
       " '/player/tim-david-892749',\n",
       " '/player/matthew-wade-230193',\n",
       " '/player/pat-cummins-489889',\n",
       " '/player/mitchell-starc-311592',\n",
       " '/player/adam-zampa-379504',\n",
       " '/player/josh-hazlewood-288284',\n",
       " '/player/trent-boult-277912',\n",
       " '/player/tim-southee-232364',\n",
       " '/player/mitchell-santner-502714',\n",
       " '/player/lockie-ferguson-493773',\n",
       " '/player/ish-sodhi-559066',\n",
       " '/player/sam-curran-662973',\n",
       " '/player/sam-curran-662973',\n",
       " '/player/sam-curran-662973',\n",
       " '/player/sam-curran-662973',\n",
       " '/player/hazratullah-zazai-793457',\n",
       " '/player/rahmanullah-gurbaz-974087',\n",
       " '/player/ibrahim-zadran-921509',\n",
       " '/player/usman-ghani-711559',\n",
       " '/player/najibullah-zadran-524049',\n",
       " '/player/mohammad-nabi-25913',\n",
       " '/player/azmatullah-omarzai-819429',\n",
       " '/player/rashid-khan-793463',\n",
       " '/player/mujeeb-ur-rahman-974109',\n",
       " '/player/fareed-ahmad-568136',\n",
       " '/player/fazalhaq-farooqi-974175',\n",
       " '/player/ben-stokes-311158',\n",
       " '/player/chris-woakes-247235',\n",
       " '/player/mark-wood-351588',\n",
       " '/player/sam-curran-662973',\n",
       " '/player/adil-rashid-244497',\n",
       " '/player/jos-buttler-308967',\n",
       " '/player/alex-hales-249866',\n",
       " '/player/dawid-malan-236489',\n",
       " '/player/ben-stokes-311158',\n",
       " '/player/liam-livingstone-403902',\n",
       " '/player/harry-brook-911707',\n",
       " '/player/moeen-ali-8917',\n",
       " '/player/chris-woakes-247235',\n",
       " '/player/sam-curran-662973',\n",
       " '/player/adil-rashid-244497',\n",
       " '/player/mark-wood-351588',\n",
       " '/player/fazalhaq-farooqi-974175',\n",
       " '/player/azmatullah-omarzai-819429',\n",
       " '/player/mujeeb-ur-rahman-974109',\n",
       " '/player/rashid-khan-793463',\n",
       " '/player/fareed-ahmad-568136',\n",
       " '/player/mohammad-nabi-25913',\n",
       " '/player/sam-curran-662973',\n",
       " '/player/aleem-dar-39157',\n",
       " '/player/chris-brown-36352',\n",
       " '/player/paul-reiffel-7326',\n",
       " '/player/paul-wilson-8241',\n",
       " '/player/andy-pycroft-55700',\n",
       " '/player/jos-buttler-308967',\n",
       " '/player/alex-hales-249866',\n",
       " '/player/dawid-malan-236489',\n",
       " '/player/ben-stokes-311158',\n",
       " '/player/liam-livingstone-403902',\n",
       " '/player/harry-brook-911707',\n",
       " '/player/moeen-ali-8917',\n",
       " '/player/fazalhaq-farooqi-974175',\n",
       " '/player/azmatullah-omarzai-819429',\n",
       " '/player/mujeeb-ur-rahman-974109',\n",
       " '/player/rashid-khan-793463',\n",
       " '/player/fareed-ahmad-568136',\n",
       " '/player/mohammad-nabi-25913',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/paul-stirling-303427',\n",
       " '/player/andy-balbirnie-303423',\n",
       " '/player/lorcan-tucker-928057',\n",
       " '/player/harry-tector-961407',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/george-dockrell-348034',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/mark-adair-526441',\n",
       " '/player/simi-singh-1005257',\n",
       " '/player/barry-mccarthy-348059',\n",
       " '/player/josh-little-928067',\n",
       " '/player/binura-fernando-629080',\n",
       " '/player/lahiru-kumara-784375',\n",
       " '/player/maheesh-theekshana-1138316',\n",
       " '/player/chamika-karunaratne-623695',\n",
       " '/player/wanindu-hasaranga-de-silva-784379',\n",
       " '/player/dhananjaya-de-silva-465793',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/dhananjaya-de-silva-465793',\n",
       " '/player/charith-asalanka-784367',\n",
       " '/player/ashen-bandara-958691',\n",
       " '/player/bhanuka-rajapaksa-342619',\n",
       " '/player/dasun-shanaka-437316',\n",
       " '/player/wanindu-hasaranga-de-silva-784379',\n",
       " '/player/chamika-karunaratne-623695',\n",
       " '/player/maheesh-theekshana-1138316',\n",
       " '/player/lahiru-kumara-784375',\n",
       " '/player/binura-fernando-629080',\n",
       " '/player/josh-little-928067',\n",
       " '/player/mark-adair-526441',\n",
       " '/player/barry-mccarthy-348059',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/simi-singh-1005257',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/ahsan-raza-39146',\n",
       " '/player/chris-gaffaney-37097',\n",
       " '/player/nitin-menon-30988',\n",
       " '/player/michael-gough-13413',\n",
       " '/player/david-boon-4169',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/dhananjaya-de-silva-465793',\n",
       " '/player/charith-asalanka-784367',\n",
       " '/player/josh-little-928067',\n",
       " '/player/mark-adair-526441',\n",
       " '/player/barry-mccarthy-348059',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/simi-singh-1005257',\n",
       " '/player/virat-kohli-253802',\n",
       " '/player/virat-kohli-253802',\n",
       " '/player/virat-kohli-253802',\n",
       " '/player/virat-kohli-253802',\n",
       " '/player/mohammad-rizwan-323389',\n",
       " '/player/babar-azam-348144',\n",
       " '/player/shan-masood-233901',\n",
       " '/player/iftikhar-ahmed-480603',\n",
       " '/player/shadab-khan-922943',\n",
       " '/player/haider-ali-1168651',\n",
       " '/player/mohammad-nawaz-348148',\n",
       " '/player/asif-ali-494230',\n",
       " '/player/shaheen-shah-afridi-1072470',\n",
       " '/player/haris-rauf-1161606',\n",
       " '/player/naseem-shah-1158088',\n",
       " '/player/bhuvneshwar-kumar-326016',\n",
       " '/player/arshdeep-singh-1125976',\n",
       " '/player/mohammed-shami-481896',\n",
       " '/player/hardik-pandya-625371',\n",
       " '/player/ravichandran-ashwin-26421',\n",
       " '/player/axar-patel-554691',\n",
       " '/player/kl-rahul-422108',\n",
       " '/player/rohit-sharma-34102',\n",
       " '/player/virat-kohli-253802',\n",
       " '/player/suryakumar-yadav-446507',\n",
       " '/player/axar-patel-554691',\n",
       " '/player/hardik-pandya-625371',\n",
       " '/player/dinesh-karthik-30045',\n",
       " '/player/ravichandran-ashwin-26421',\n",
       " '/player/mohammed-shami-481896',\n",
       " '/player/bhuvneshwar-kumar-326016',\n",
       " '/player/arshdeep-singh-1125976',\n",
       " '/player/shaheen-shah-afridi-1072470',\n",
       " '/player/naseem-shah-1158088',\n",
       " '/player/haris-rauf-1161606',\n",
       " '/player/shadab-khan-922943',\n",
       " '/player/mohammad-nawaz-348148',\n",
       " '/player/virat-kohli-253802',\n",
       " '/player/marais-erasmus-44971',\n",
       " '/player/rod-tucker-7986',\n",
       " '/player/richard-kettleborough-15872',\n",
       " '/player/joel-wilson-387601',\n",
       " '/player/ranjan-madugalle-49623',\n",
       " '/player/kl-rahul-422108',\n",
       " '/player/rohit-sharma-34102',\n",
       " '/player/virat-kohli-253802',\n",
       " '/player/suryakumar-yadav-446507',\n",
       " '/player/axar-patel-554691',\n",
       " '/player/hardik-pandya-625371',\n",
       " '/player/dinesh-karthik-30045',\n",
       " '/player/ravichandran-ashwin-26421',\n",
       " '/player/shaheen-shah-afridi-1072470',\n",
       " '/player/naseem-shah-1158088',\n",
       " '/player/haris-rauf-1161606',\n",
       " '/player/shadab-khan-922943',\n",
       " '/player/mohammad-nawaz-348148',\n",
       " '/player/taskin-ahmed-538506',\n",
       " '/player/taskin-ahmed-538506',\n",
       " '/player/colin-ackermann-379774',\n",
       " '/player/colin-ackermann-379774',\n",
       " '/player/najmul-hossain-shanto-629058',\n",
       " '/player/soumya-sarkar-436677',\n",
       " '/player/litton-das-536936',\n",
       " '/player/shakib-al-hasan-56143',\n",
       " '/player/afif-hossain-935995',\n",
       " '/player/yasir-ali-629059',\n",
       " '/player/nurul-hasan-410765',\n",
       " '/player/mosaddek-hossain-550133',\n",
       " '/player/taskin-ahmed-538506',\n",
       " '/player/hasan-mahmud-926629',\n",
       " '/player/mustafizur-rahman-330902',\n",
       " '/player/fred-klaassen-1104703',\n",
       " '/player/colin-ackermann-379774',\n",
       " '/player/paul-van-meekeren-348109',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/tim-pringle-1193548',\n",
       " '/player/shariz-ahmad-1278252',\n",
       " '/player/logan-van-beek-440522',\n",
       " '/player/vikramjit-singh-1153767',\n",
       " '/player/max-o-dowd-643197',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/colin-ackermann-379774',\n",
       " '/player/tom-cooper-219885',\n",
       " '/player/scott-edwards-1127317',\n",
       " '/player/tim-pringle-1193548',\n",
       " '/player/logan-van-beek-440522',\n",
       " '/player/shariz-ahmad-1278252',\n",
       " '/player/fred-klaassen-1104703',\n",
       " '/player/paul-van-meekeren-348109',\n",
       " '/player/taskin-ahmed-538506',\n",
       " '/player/hasan-mahmud-926629',\n",
       " '/player/shakib-al-hasan-56143',\n",
       " '/player/mustafizur-rahman-330902',\n",
       " '/player/soumya-sarkar-436677',\n",
       " '/player/mosaddek-hossain-550133',\n",
       " '/player/taskin-ahmed-538506',\n",
       " '/player/chris-gaffaney-37097',\n",
       " '/player/nitin-menon-30988',\n",
       " '/player/michael-gough-13413',\n",
       " '/player/ahsan-raza-39146',\n",
       " '/player/david-boon-4169',\n",
       " '/player/vikramjit-singh-1153767',\n",
       " '/player/max-o-dowd-643197',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/colin-ackermann-379774',\n",
       " '/player/tom-cooper-219885',\n",
       " '/player/scott-edwards-1127317',\n",
       " '/player/tim-pringle-1193548',\n",
       " '/player/logan-van-beek-440522',\n",
       " '/player/shariz-ahmad-1278252',\n",
       " '/player/fred-klaassen-1104703',\n",
       " '/player/paul-van-meekeren-348109',\n",
       " '/player/taskin-ahmed-538506',\n",
       " '/player/hasan-mahmud-926629',\n",
       " '/player/shakib-al-hasan-56143',\n",
       " '/player/mustafizur-rahman-330902',\n",
       " '/player/soumya-sarkar-436677',\n",
       " ...]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "player_urls = []\n",
    "for url in filtered_urls:\n",
    "    res = requests.get(\"https://stats.espncricinfo.com\"+ url)\n",
    "    soup = BeautifulSoup(res.content, 'html.parser')\n",
    "    links = soup.find_all('a', href=True)\n",
    "    for link in links:\n",
    "        if '/player/' in link.get('href'):\n",
    "            player_urls.append(link.get('href'))\n",
    "player_urls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['/player/jan-frylinck-482478'],\n",
       " ['/player/michael-van-lingen-833777'],\n",
       " ['/player/divan-la-cock-1178065'],\n",
       " ['/player/jan-nicol-loftie-eaton-1071473'],\n",
       " ['/player/stephan-baard-437927'],\n",
       " ['/player/gerhard-erasmus-519070'],\n",
       " ['/player/david-wiese-221140'],\n",
       " ['/player/jj-smit-553821'],\n",
       " ['/player/zane-green-596664'],\n",
       " ['/player/bernard-scholtz-330223'],\n",
       " ['/player/ben-shikongo-1069820'],\n",
       " ['/player/maheesh-theekshana-1138316'],\n",
       " ['/player/dushmantha-chameera-552152'],\n",
       " ['/player/pramod-madushan-826689'],\n",
       " ['/player/chamika-karunaratne-623695'],\n",
       " ['/player/wanindu-hasaranga-de-silva-784379'],\n",
       " ['/player/pathum-nissanka-1028655'],\n",
       " ['/player/kusal-mendis-629074'],\n",
       " ['/player/dhananjaya-de-silva-465793'],\n",
       " ['/player/danushka-gunathilaka-345821'],\n",
       " ['/player/bhanuka-rajapaksa-342619'],\n",
       " ['/player/dasun-shanaka-437316'],\n",
       " ['/player/joel-wilson-387601'],\n",
       " ['/player/rod-tucker-7986'],\n",
       " ['/player/paul-reiffel-7326'],\n",
       " ['/player/marais-erasmus-44971'],\n",
       " ['/player/andy-pycroft-55700'],\n",
       " ['/player/bas-de-leede-1036191'],\n",
       " ['/player/junaid-siddique-1203754'],\n",
       " ['/player/chirag-suri-534734'],\n",
       " ['/player/muhammad-waseem-1241277'],\n",
       " ['/player/kashif-daud-229225'],\n",
       " ['/player/vriitya-aravind-1178586'],\n",
       " ['/player/zawar-farid-1196500'],\n",
       " ['/player/basil-hameed-1209110'],\n",
       " ['/player/chundangapoyil-rizwan-474760'],\n",
       " ['/player/aayan-afzal-khan-1241265'],\n",
       " ['/player/karthik-meiyappan-1058987'],\n",
       " ['/player/zahoor-khan-384525'],\n",
       " ['/player/fred-klaassen-1104703'],\n",
       " ['/player/tim-pringle-1193548'],\n",
       " ['/player/logan-van-beek-440522'],\n",
       " ['/player/paul-van-meekeren-348109'],\n",
       " ['/player/roelof-van-der-merwe-47850'],\n",
       " ['/player/vikramjit-singh-1153767'],\n",
       " ['/player/max-o-dowd-643197'],\n",
       " ['/player/colin-ackermann-379774'],\n",
       " ['/player/tom-cooper-219885'],\n",
       " ['/player/scott-edwards-1127317'],\n",
       " ['/player/richard-kettleborough-15872'],\n",
       " ['/player/ranjan-madugalle-49623'],\n",
       " ['/player/george-munsey-671805'],\n",
       " ['/player/michael-jones-1093091'],\n",
       " ['/player/matthew-cross-417268'],\n",
       " ['/player/richie-berrington-25490'],\n",
       " ['/player/calum-macleod-232435'],\n",
       " ['/player/michael-leask-414966'],\n",
       " ['/player/chris-greaves-873199'],\n",
       " ['/player/mark-watt-659081'],\n",
       " ['/player/josh-davey-407265'],\n",
       " ['/player/safyaan-sharif-414970'],\n",
       " ['/player/brad-wheal-807535'],\n",
       " ['/player/kyle-mayers-348056'],\n",
       " ['/player/akeal-hosein-530812'],\n",
       " ['/player/alzarri-joseph-670031'],\n",
       " ['/player/obed-mccoy-906783'],\n",
       " ['/player/jason-holder-391485'],\n",
       " ['/player/odean-smith-820691'],\n",
       " ['/player/evin-lewis-431901'],\n",
       " ['/player/brandon-king-670035'],\n",
       " ['/player/nicholas-pooran-604302'],\n",
       " ['/player/shamarh-brooks-230555'],\n",
       " ['/player/rovman-powell-820351'],\n",
       " ['/player/aleem-dar-39157'],\n",
       " ['/player/paul-wilson-8241'],\n",
       " ['/player/chris-brown-36352'],\n",
       " ['/player/kumar-dharmasena-48469'],\n",
       " ['/player/chris-broad-9230'],\n",
       " ['/player/sikandar-raza-299572'],\n",
       " ['/player/regis-chakabva-293831'],\n",
       " ['/player/craig-ervine-55412'],\n",
       " ['/player/wessly-madhevere-938959'],\n",
       " ['/player/sean-williams-55870'],\n",
       " ['/player/milton-shumba-951781'],\n",
       " ['/player/ryan-burl-495964'],\n",
       " ['/player/luke-jongwe-541224'],\n",
       " ['/player/tendai-chatara-425639'],\n",
       " ['/player/richard-ngarava-806241'],\n",
       " ['/player/blessing-muzarabani-827051'],\n",
       " ['/player/josh-little-928067'],\n",
       " ['/player/mark-adair-526441'],\n",
       " ['/player/barry-mccarthy-348059'],\n",
       " ['/player/curtis-campher-595921'],\n",
       " ['/player/simi-singh-1005257'],\n",
       " ['/player/gareth-delany-1099379'],\n",
       " ['/player/paul-stirling-303427'],\n",
       " ['/player/andy-balbirnie-303423'],\n",
       " ['/player/lorcan-tucker-928057'],\n",
       " ['/player/harry-tector-961407'],\n",
       " ['/player/george-dockrell-348034'],\n",
       " ['/player/timm-van-der-gugten-333782'],\n",
       " ['/player/charith-asalanka-784367'],\n",
       " ['/player/aryan-lakra-1058989'],\n",
       " ['/player/johnson-charles-333066'],\n",
       " ['/player/tony-munyonga-1122853'],\n",
       " ['/player/lahiru-kumara-784375'],\n",
       " ['/player/binura-fernando-629080'],\n",
       " ['/player/richard-illingworth-15383'],\n",
       " ['/player/alishan-sharafu-1161038'],\n",
       " ['/player/fahad-nawaz-1126002'],\n",
       " ['/player/ahmed-raza-245490'],\n",
       " ['/player/ruben-trumpelmann-698317'],\n",
       " ['/player/ahsan-raza-39146'],\n",
       " ['/player/chris-gaffaney-37097'],\n",
       " ['/player/michael-gough-13413'],\n",
       " ['/player/nitin-menon-30988'],\n",
       " ['/player/david-boon-4169'],\n",
       " ['/player/devon-conway-379140'],\n",
       " ['/player/finn-allen-959759'],\n",
       " ['/player/kane-williamson-277906'],\n",
       " ['/player/glenn-phillips-823509'],\n",
       " ['/player/james-neesham-355269'],\n",
       " ['/player/mark-chapman-438563'],\n",
       " ['/player/mitchell-santner-502714'],\n",
       " ['/player/ish-sodhi-559066'],\n",
       " ['/player/tim-southee-232364'],\n",
       " ['/player/lockie-ferguson-493773'],\n",
       " ['/player/trent-boult-277912'],\n",
       " ['/player/mitchell-starc-311592'],\n",
       " ['/player/josh-hazlewood-288284'],\n",
       " ['/player/pat-cummins-489889'],\n",
       " ['/player/marcus-stoinis-325012'],\n",
       " ['/player/adam-zampa-379504'],\n",
       " ['/player/david-warner-219889'],\n",
       " ['/player/aaron-finch-5334'],\n",
       " ['/player/mitchell-marsh-272450'],\n",
       " ['/player/glenn-maxwell-325026'],\n",
       " ['/player/tim-david-892749'],\n",
       " ['/player/matthew-wade-230193'],\n",
       " ['/player/adrian-holdstock-45448'],\n",
       " ['/player/langton-rusere-393453'],\n",
       " ['/player/sam-curran-662973'],\n",
       " ['/player/hazratullah-zazai-793457'],\n",
       " ['/player/rahmanullah-gurbaz-974087'],\n",
       " ['/player/ibrahim-zadran-921509'],\n",
       " ['/player/usman-ghani-711559'],\n",
       " ['/player/najibullah-zadran-524049'],\n",
       " ['/player/mohammad-nabi-25913'],\n",
       " ['/player/azmatullah-omarzai-819429'],\n",
       " ['/player/rashid-khan-793463'],\n",
       " ['/player/mujeeb-ur-rahman-974109'],\n",
       " ['/player/fareed-ahmad-568136'],\n",
       " ['/player/fazalhaq-farooqi-974175'],\n",
       " ['/player/ben-stokes-311158'],\n",
       " ['/player/chris-woakes-247235'],\n",
       " ['/player/mark-wood-351588'],\n",
       " ['/player/adil-rashid-244497'],\n",
       " ['/player/jos-buttler-308967'],\n",
       " ['/player/alex-hales-249866'],\n",
       " ['/player/dawid-malan-236489'],\n",
       " ['/player/liam-livingstone-403902'],\n",
       " ['/player/harry-brook-911707'],\n",
       " ['/player/moeen-ali-8917'],\n",
       " ['/player/ashen-bandara-958691'],\n",
       " ['/player/virat-kohli-253802'],\n",
       " ['/player/mohammad-rizwan-323389'],\n",
       " ['/player/babar-azam-348144'],\n",
       " ['/player/shan-masood-233901'],\n",
       " ['/player/iftikhar-ahmed-480603'],\n",
       " ['/player/shadab-khan-922943'],\n",
       " ['/player/haider-ali-1168651'],\n",
       " ['/player/mohammad-nawaz-348148'],\n",
       " ['/player/asif-ali-494230'],\n",
       " ['/player/shaheen-shah-afridi-1072470'],\n",
       " ['/player/haris-rauf-1161606'],\n",
       " ['/player/naseem-shah-1158088'],\n",
       " ['/player/bhuvneshwar-kumar-326016'],\n",
       " ['/player/arshdeep-singh-1125976'],\n",
       " ['/player/mohammed-shami-481896'],\n",
       " ['/player/hardik-pandya-625371'],\n",
       " ['/player/ravichandran-ashwin-26421'],\n",
       " ['/player/axar-patel-554691'],\n",
       " ['/player/kl-rahul-422108'],\n",
       " ['/player/rohit-sharma-34102'],\n",
       " ['/player/suryakumar-yadav-446507'],\n",
       " ['/player/dinesh-karthik-30045'],\n",
       " ['/player/taskin-ahmed-538506'],\n",
       " ['/player/najmul-hossain-shanto-629058'],\n",
       " ['/player/soumya-sarkar-436677'],\n",
       " ['/player/litton-das-536936'],\n",
       " ['/player/shakib-al-hasan-56143'],\n",
       " ['/player/afif-hossain-935995'],\n",
       " ['/player/yasir-ali-629059'],\n",
       " ['/player/nurul-hasan-410765'],\n",
       " ['/player/mosaddek-hossain-550133'],\n",
       " ['/player/hasan-mahmud-926629'],\n",
       " ['/player/mustafizur-rahman-330902'],\n",
       " ['/player/shariz-ahmad-1278252'],\n",
       " ['/player/kagiso-rabada-550215'],\n",
       " ['/player/wayne-parnell-265564'],\n",
       " ['/player/lungi-ngidi-542023'],\n",
       " ['/player/keshav-maharaj-267724'],\n",
       " ['/player/anrich-nortje-481979'],\n",
       " ['/player/quinton-de-kock-379143'],\n",
       " ['/player/temba-bavuma-372116'],\n",
       " ['/player/rilee-rossouw-318845'],\n",
       " ['/player/aiden-markram-600498'],\n",
       " ['/player/david-miller-321777'],\n",
       " ['/player/tristan-stubbs-595978'],\n",
       " ['/player/ashton-agar-505120'],\n",
       " ['/player/fionn-hand-1099225'],\n",
       " ['/player/naveen-ul-haq-793447'],\n",
       " ['/player/darwish-rasooli-819441'],\n",
       " ['/player/qais-ahmad-914171'],\n",
       " ['/player/mohammad-saleem-1174749'],\n",
       " ['/player/martin-guptill-226492'],\n",
       " ['/player/michael-bracewell-326968'],\n",
       " ['/player/daryl-mitchell-381743'],\n",
       " ['/player/adam-milne-450860'],\n",
       " ['/player/tabraiz-shamsi-379145'],\n",
       " ['/player/mehidy-hasan-miraz-629063'],\n",
       " ['/player/brad-evans-696127'],\n",
       " ['/player/mohammad-wasim-1185538'],\n",
       " ['/player/graham-hume-379144'],\n",
       " ['/player/conor-olphert-1229953'],\n",
       " ['/player/steven-smith-267192'],\n",
       " ['/player/kane-richardson-272262'],\n",
       " ['/player/cameron-green-1076713'],\n",
       " ['/player/chris-jordan-288992'],\n",
       " ['/player/david-willey-308251'],\n",
       " ['/player/tymal-mills-459257'],\n",
       " ['/player/phil-salt-669365'],\n",
       " ['/player/kasun-rajitha-499594'],\n",
       " ['/player/stephan-myburgh-233712'],\n",
       " ['/player/brandon-glover-595419'],\n",
       " ['/player/fakhar-zaman-512191'],\n",
       " ['/player/deepak-hooda-497121'],\n",
       " ['/player/gulbadin-naib-352048'],\n",
       " ['/player/shoriful-islam-990039'],\n",
       " ['/player/mohammad-haris-1205559'],\n",
       " ['/player/heinrich-klaasen-436757'],\n",
       " ['/player/nasum-ahmed-348049'],\n",
       " ['/player/ebadot-hossain-932355'],\n",
       " ['/player/rishabh-pant-931581'],\n",
       " ['/player/wellington-masakadza-571703']]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp = pd.DataFrame(player_urls)\n",
    "temp.drop_duplicates(inplace=True)\n",
    "player_urls = temp.to_numpy().tolist()\n",
    "player_urls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['/player/jan-frylinck-482478',\n",
       " '/player/michael-van-lingen-833777',\n",
       " '/player/divan-la-cock-1178065',\n",
       " '/player/jan-nicol-loftie-eaton-1071473',\n",
       " '/player/stephan-baard-437927',\n",
       " '/player/gerhard-erasmus-519070',\n",
       " '/player/david-wiese-221140',\n",
       " '/player/jj-smit-553821',\n",
       " '/player/zane-green-596664',\n",
       " '/player/bernard-scholtz-330223',\n",
       " '/player/ben-shikongo-1069820',\n",
       " '/player/maheesh-theekshana-1138316',\n",
       " '/player/dushmantha-chameera-552152',\n",
       " '/player/pramod-madushan-826689',\n",
       " '/player/chamika-karunaratne-623695',\n",
       " '/player/wanindu-hasaranga-de-silva-784379',\n",
       " '/player/pathum-nissanka-1028655',\n",
       " '/player/kusal-mendis-629074',\n",
       " '/player/dhananjaya-de-silva-465793',\n",
       " '/player/danushka-gunathilaka-345821',\n",
       " '/player/bhanuka-rajapaksa-342619',\n",
       " '/player/dasun-shanaka-437316',\n",
       " '/player/joel-wilson-387601',\n",
       " '/player/rod-tucker-7986',\n",
       " '/player/paul-reiffel-7326',\n",
       " '/player/marais-erasmus-44971',\n",
       " '/player/andy-pycroft-55700',\n",
       " '/player/bas-de-leede-1036191',\n",
       " '/player/junaid-siddique-1203754',\n",
       " '/player/chirag-suri-534734',\n",
       " '/player/muhammad-waseem-1241277',\n",
       " '/player/kashif-daud-229225',\n",
       " '/player/vriitya-aravind-1178586',\n",
       " '/player/zawar-farid-1196500',\n",
       " '/player/basil-hameed-1209110',\n",
       " '/player/chundangapoyil-rizwan-474760',\n",
       " '/player/aayan-afzal-khan-1241265',\n",
       " '/player/karthik-meiyappan-1058987',\n",
       " '/player/zahoor-khan-384525',\n",
       " '/player/fred-klaassen-1104703',\n",
       " '/player/tim-pringle-1193548',\n",
       " '/player/logan-van-beek-440522',\n",
       " '/player/paul-van-meekeren-348109',\n",
       " '/player/roelof-van-der-merwe-47850',\n",
       " '/player/vikramjit-singh-1153767',\n",
       " '/player/max-o-dowd-643197',\n",
       " '/player/colin-ackermann-379774',\n",
       " '/player/tom-cooper-219885',\n",
       " '/player/scott-edwards-1127317',\n",
       " '/player/richard-kettleborough-15872',\n",
       " '/player/ranjan-madugalle-49623',\n",
       " '/player/george-munsey-671805',\n",
       " '/player/michael-jones-1093091',\n",
       " '/player/matthew-cross-417268',\n",
       " '/player/richie-berrington-25490',\n",
       " '/player/calum-macleod-232435',\n",
       " '/player/michael-leask-414966',\n",
       " '/player/chris-greaves-873199',\n",
       " '/player/mark-watt-659081',\n",
       " '/player/josh-davey-407265',\n",
       " '/player/safyaan-sharif-414970',\n",
       " '/player/brad-wheal-807535',\n",
       " '/player/kyle-mayers-348056',\n",
       " '/player/akeal-hosein-530812',\n",
       " '/player/alzarri-joseph-670031',\n",
       " '/player/obed-mccoy-906783',\n",
       " '/player/jason-holder-391485',\n",
       " '/player/odean-smith-820691',\n",
       " '/player/evin-lewis-431901',\n",
       " '/player/brandon-king-670035',\n",
       " '/player/nicholas-pooran-604302',\n",
       " '/player/shamarh-brooks-230555',\n",
       " '/player/rovman-powell-820351',\n",
       " '/player/aleem-dar-39157',\n",
       " '/player/paul-wilson-8241',\n",
       " '/player/chris-brown-36352',\n",
       " '/player/kumar-dharmasena-48469',\n",
       " '/player/chris-broad-9230',\n",
       " '/player/sikandar-raza-299572',\n",
       " '/player/regis-chakabva-293831',\n",
       " '/player/craig-ervine-55412',\n",
       " '/player/wessly-madhevere-938959',\n",
       " '/player/sean-williams-55870',\n",
       " '/player/milton-shumba-951781',\n",
       " '/player/ryan-burl-495964',\n",
       " '/player/luke-jongwe-541224',\n",
       " '/player/tendai-chatara-425639',\n",
       " '/player/richard-ngarava-806241',\n",
       " '/player/blessing-muzarabani-827051',\n",
       " '/player/josh-little-928067',\n",
       " '/player/mark-adair-526441',\n",
       " '/player/barry-mccarthy-348059',\n",
       " '/player/curtis-campher-595921',\n",
       " '/player/simi-singh-1005257',\n",
       " '/player/gareth-delany-1099379',\n",
       " '/player/paul-stirling-303427',\n",
       " '/player/andy-balbirnie-303423',\n",
       " '/player/lorcan-tucker-928057',\n",
       " '/player/harry-tector-961407',\n",
       " '/player/george-dockrell-348034',\n",
       " '/player/timm-van-der-gugten-333782',\n",
       " '/player/charith-asalanka-784367',\n",
       " '/player/aryan-lakra-1058989',\n",
       " '/player/johnson-charles-333066',\n",
       " '/player/tony-munyonga-1122853',\n",
       " '/player/lahiru-kumara-784375',\n",
       " '/player/binura-fernando-629080',\n",
       " '/player/richard-illingworth-15383',\n",
       " '/player/alishan-sharafu-1161038',\n",
       " '/player/fahad-nawaz-1126002',\n",
       " '/player/ahmed-raza-245490',\n",
       " '/player/ruben-trumpelmann-698317',\n",
       " '/player/ahsan-raza-39146',\n",
       " '/player/chris-gaffaney-37097',\n",
       " '/player/michael-gough-13413',\n",
       " '/player/nitin-menon-30988',\n",
       " '/player/david-boon-4169',\n",
       " '/player/devon-conway-379140',\n",
       " '/player/finn-allen-959759',\n",
       " '/player/kane-williamson-277906',\n",
       " '/player/glenn-phillips-823509',\n",
       " '/player/james-neesham-355269',\n",
       " '/player/mark-chapman-438563',\n",
       " '/player/mitchell-santner-502714',\n",
       " '/player/ish-sodhi-559066',\n",
       " '/player/tim-southee-232364',\n",
       " '/player/lockie-ferguson-493773',\n",
       " '/player/trent-boult-277912',\n",
       " '/player/mitchell-starc-311592',\n",
       " '/player/josh-hazlewood-288284',\n",
       " '/player/pat-cummins-489889',\n",
       " '/player/marcus-stoinis-325012',\n",
       " '/player/adam-zampa-379504',\n",
       " '/player/david-warner-219889',\n",
       " '/player/aaron-finch-5334',\n",
       " '/player/mitchell-marsh-272450',\n",
       " '/player/glenn-maxwell-325026',\n",
       " '/player/tim-david-892749',\n",
       " '/player/matthew-wade-230193',\n",
       " '/player/adrian-holdstock-45448',\n",
       " '/player/langton-rusere-393453',\n",
       " '/player/sam-curran-662973',\n",
       " '/player/hazratullah-zazai-793457',\n",
       " '/player/rahmanullah-gurbaz-974087',\n",
       " '/player/ibrahim-zadran-921509',\n",
       " '/player/usman-ghani-711559',\n",
       " '/player/najibullah-zadran-524049',\n",
       " '/player/mohammad-nabi-25913',\n",
       " '/player/azmatullah-omarzai-819429',\n",
       " '/player/rashid-khan-793463',\n",
       " '/player/mujeeb-ur-rahman-974109',\n",
       " '/player/fareed-ahmad-568136',\n",
       " '/player/fazalhaq-farooqi-974175',\n",
       " '/player/ben-stokes-311158',\n",
       " '/player/chris-woakes-247235',\n",
       " '/player/mark-wood-351588',\n",
       " '/player/adil-rashid-244497',\n",
       " '/player/jos-buttler-308967',\n",
       " '/player/alex-hales-249866',\n",
       " '/player/dawid-malan-236489',\n",
       " '/player/liam-livingstone-403902',\n",
       " '/player/harry-brook-911707',\n",
       " '/player/moeen-ali-8917',\n",
       " '/player/ashen-bandara-958691',\n",
       " '/player/virat-kohli-253802',\n",
       " '/player/mohammad-rizwan-323389',\n",
       " '/player/babar-azam-348144',\n",
       " '/player/shan-masood-233901',\n",
       " '/player/iftikhar-ahmed-480603',\n",
       " '/player/shadab-khan-922943',\n",
       " '/player/haider-ali-1168651',\n",
       " '/player/mohammad-nawaz-348148',\n",
       " '/player/asif-ali-494230',\n",
       " '/player/shaheen-shah-afridi-1072470',\n",
       " '/player/haris-rauf-1161606',\n",
       " '/player/naseem-shah-1158088',\n",
       " '/player/bhuvneshwar-kumar-326016',\n",
       " '/player/arshdeep-singh-1125976',\n",
       " '/player/mohammed-shami-481896',\n",
       " '/player/hardik-pandya-625371',\n",
       " '/player/ravichandran-ashwin-26421',\n",
       " '/player/axar-patel-554691',\n",
       " '/player/kl-rahul-422108',\n",
       " '/player/rohit-sharma-34102',\n",
       " '/player/suryakumar-yadav-446507',\n",
       " '/player/dinesh-karthik-30045',\n",
       " '/player/taskin-ahmed-538506',\n",
       " '/player/najmul-hossain-shanto-629058',\n",
       " '/player/soumya-sarkar-436677',\n",
       " '/player/litton-das-536936',\n",
       " '/player/shakib-al-hasan-56143',\n",
       " '/player/afif-hossain-935995',\n",
       " '/player/yasir-ali-629059',\n",
       " '/player/nurul-hasan-410765',\n",
       " '/player/mosaddek-hossain-550133',\n",
       " '/player/hasan-mahmud-926629',\n",
       " '/player/mustafizur-rahman-330902',\n",
       " '/player/shariz-ahmad-1278252',\n",
       " '/player/kagiso-rabada-550215',\n",
       " '/player/wayne-parnell-265564',\n",
       " '/player/lungi-ngidi-542023',\n",
       " '/player/keshav-maharaj-267724',\n",
       " '/player/anrich-nortje-481979',\n",
       " '/player/quinton-de-kock-379143',\n",
       " '/player/temba-bavuma-372116',\n",
       " '/player/rilee-rossouw-318845',\n",
       " '/player/aiden-markram-600498',\n",
       " '/player/david-miller-321777',\n",
       " '/player/tristan-stubbs-595978',\n",
       " '/player/ashton-agar-505120',\n",
       " '/player/fionn-hand-1099225',\n",
       " '/player/naveen-ul-haq-793447',\n",
       " '/player/darwish-rasooli-819441',\n",
       " '/player/qais-ahmad-914171',\n",
       " '/player/mohammad-saleem-1174749',\n",
       " '/player/martin-guptill-226492',\n",
       " '/player/michael-bracewell-326968',\n",
       " '/player/daryl-mitchell-381743',\n",
       " '/player/adam-milne-450860',\n",
       " '/player/tabraiz-shamsi-379145',\n",
       " '/player/mehidy-hasan-miraz-629063',\n",
       " '/player/brad-evans-696127',\n",
       " '/player/mohammad-wasim-1185538',\n",
       " '/player/graham-hume-379144',\n",
       " '/player/conor-olphert-1229953',\n",
       " '/player/steven-smith-267192',\n",
       " '/player/kane-richardson-272262',\n",
       " '/player/cameron-green-1076713',\n",
       " '/player/chris-jordan-288992',\n",
       " '/player/david-willey-308251',\n",
       " '/player/tymal-mills-459257',\n",
       " '/player/phil-salt-669365',\n",
       " '/player/kasun-rajitha-499594',\n",
       " '/player/stephan-myburgh-233712',\n",
       " '/player/brandon-glover-595419',\n",
       " '/player/fakhar-zaman-512191',\n",
       " '/player/deepak-hooda-497121',\n",
       " '/player/gulbadin-naib-352048',\n",
       " '/player/shoriful-islam-990039',\n",
       " '/player/mohammad-haris-1205559',\n",
       " '/player/heinrich-klaasen-436757',\n",
       " '/player/nasum-ahmed-348049',\n",
       " '/player/ebadot-hossain-932355',\n",
       " '/player/rishabh-pant-931581',\n",
       " '/player/wellington-masakadza-571703']"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from itertools import chain\n",
    "player_urls = list(chain(*player_urls))\n",
    "player_urls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['/player/jan-frylinck-482478/photos',\n",
       " '/player/michael-van-lingen-833777/photos',\n",
       " '/player/jan-nicol-loftie-eaton-1071473/photos',\n",
       " '/player/stephan-baard-437927/photos',\n",
       " '/player/gerhard-erasmus-519070/photos',\n",
       " '/player/david-wiese-221140/photos',\n",
       " '/player/jj-smit-553821/photos',\n",
       " '/player/zane-green-596664/photos',\n",
       " '/player/bernard-scholtz-330223/photos',\n",
       " '/player/ben-shikongo-1069820/photos',\n",
       " '/player/maheesh-theekshana-1138316/photos',\n",
       " '/player/dushmantha-chameera-552152/photos',\n",
       " '/player/pramod-madushan-826689/photos',\n",
       " '/player/chamika-karunaratne-623695/photos',\n",
       " '/player/wanindu-hasaranga-de-silva-784379/photos',\n",
       " '/player/pathum-nissanka-1028655/photos',\n",
       " '/player/kusal-mendis-629074/photos',\n",
       " '/player/dhananjaya-de-silva-465793/photos',\n",
       " '/player/danushka-gunathilaka-345821/photos',\n",
       " '/player/bhanuka-rajapaksa-342619/photos',\n",
       " '/player/dasun-shanaka-437316/photos',\n",
       " '/player/joel-wilson-387601/photos',\n",
       " '/player/rod-tucker-7986/photos',\n",
       " '/player/paul-reiffel-7326/photos',\n",
       " '/player/marais-erasmus-44971/photos',\n",
       " '/player/andy-pycroft-55700/photos',\n",
       " '/player/bas-de-leede-1036191/photos',\n",
       " '/player/junaid-siddique-1203754/photos',\n",
       " '/player/chirag-suri-534734/photos',\n",
       " '/player/muhammad-waseem-1241277/photos',\n",
       " '/player/vriitya-aravind-1178586/photos',\n",
       " '/player/zawar-farid-1196500/photos',\n",
       " '/player/basil-hameed-1209110/photos',\n",
       " '/player/chundangapoyil-rizwan-474760/photos',\n",
       " '/player/aayan-afzal-khan-1241265/photos',\n",
       " '/player/karthik-meiyappan-1058987/photos',\n",
       " '/player/zahoor-khan-384525/photos',\n",
       " '/player/fred-klaassen-1104703/photos',\n",
       " '/player/tim-pringle-1193548/photos',\n",
       " '/player/logan-van-beek-440522/photos',\n",
       " '/player/paul-van-meekeren-348109/photos',\n",
       " '/player/roelof-van-der-merwe-47850/photos',\n",
       " '/player/vikramjit-singh-1153767/photos',\n",
       " '/player/max-o-dowd-643197/photos',\n",
       " '/player/colin-ackermann-379774/photos',\n",
       " '/player/tom-cooper-219885/photos',\n",
       " '/player/scott-edwards-1127317/photos',\n",
       " '/player/richard-kettleborough-15872/photos',\n",
       " '/player/ranjan-madugalle-49623/photos',\n",
       " '/player/george-munsey-671805/photos',\n",
       " '/player/michael-jones-1093091/photos',\n",
       " '/player/matthew-cross-417268/photos',\n",
       " '/player/richie-berrington-25490/photos',\n",
       " '/player/calum-macleod-232435/photos',\n",
       " '/player/michael-leask-414966/photos',\n",
       " '/player/chris-greaves-873199/photos',\n",
       " '/player/mark-watt-659081/photos',\n",
       " '/player/josh-davey-407265/photos',\n",
       " '/player/safyaan-sharif-414970/photos',\n",
       " '/player/brad-wheal-807535/photos',\n",
       " '/player/kyle-mayers-348056/photos',\n",
       " '/player/akeal-hosein-530812/photos',\n",
       " '/player/alzarri-joseph-670031/photos',\n",
       " '/player/obed-mccoy-906783/photos',\n",
       " '/player/jason-holder-391485/photos',\n",
       " '/player/odean-smith-820691/photos',\n",
       " '/player/evin-lewis-431901/photos',\n",
       " '/player/brandon-king-670035/photos',\n",
       " '/player/nicholas-pooran-604302/photos',\n",
       " '/player/shamarh-brooks-230555/photos',\n",
       " '/player/rovman-powell-820351/photos',\n",
       " '/player/aleem-dar-39157/photos',\n",
       " '/player/paul-wilson-8241/photos',\n",
       " '/player/chris-brown-36352/photos',\n",
       " '/player/kumar-dharmasena-48469/photos',\n",
       " '/player/chris-broad-9230/photos',\n",
       " '/player/sikandar-raza-299572/photos',\n",
       " '/player/regis-chakabva-293831/photos',\n",
       " '/player/craig-ervine-55412/photos',\n",
       " '/player/wessly-madhevere-938959/photos',\n",
       " '/player/sean-williams-55870/photos',\n",
       " '/player/milton-shumba-951781/photos',\n",
       " '/player/ryan-burl-495964/photos',\n",
       " '/player/luke-jongwe-541224/photos',\n",
       " '/player/tendai-chatara-425639/photos',\n",
       " '/player/richard-ngarava-806241/photos',\n",
       " '/player/blessing-muzarabani-827051/photos',\n",
       " '/player/josh-little-928067/photos',\n",
       " '/player/mark-adair-526441/photos',\n",
       " '/player/barry-mccarthy-348059/photos',\n",
       " '/player/curtis-campher-595921/photos',\n",
       " '/player/simi-singh-1005257/photos',\n",
       " '/player/gareth-delany-1099379/photos',\n",
       " '/player/paul-stirling-303427/photos',\n",
       " '/player/andy-balbirnie-303423/photos',\n",
       " '/player/lorcan-tucker-928057/photos',\n",
       " '/player/harry-tector-961407/photos',\n",
       " '/player/george-dockrell-348034/photos',\n",
       " '/player/timm-van-der-gugten-333782/photos',\n",
       " '/player/charith-asalanka-784367/photos',\n",
       " '/player/aryan-lakra-1058989/photos',\n",
       " '/player/johnson-charles-333066/photos',\n",
       " '/player/tony-munyonga-1122853/photos',\n",
       " '/player/lahiru-kumara-784375/photos',\n",
       " '/player/binura-fernando-629080/photos',\n",
       " '/player/richard-illingworth-15383/photos',\n",
       " '/player/ahmed-raza-245490/photos',\n",
       " '/player/ruben-trumpelmann-698317/photos',\n",
       " '/player/ahsan-raza-39146/photos',\n",
       " '/player/chris-gaffaney-37097/photos',\n",
       " '/player/michael-gough-13413/photos',\n",
       " '/player/nitin-menon-30988/photos',\n",
       " '/player/david-boon-4169/photos',\n",
       " '/player/devon-conway-379140/photos',\n",
       " '/player/finn-allen-959759/photos',\n",
       " '/player/kane-williamson-277906/photos',\n",
       " '/player/glenn-phillips-823509/photos',\n",
       " '/player/james-neesham-355269/photos',\n",
       " '/player/mark-chapman-438563/photos',\n",
       " '/player/mitchell-santner-502714/photos',\n",
       " '/player/ish-sodhi-559066/photos',\n",
       " '/player/tim-southee-232364/photos',\n",
       " '/player/lockie-ferguson-493773/photos',\n",
       " '/player/trent-boult-277912/photos',\n",
       " '/player/mitchell-starc-311592/photos',\n",
       " '/player/josh-hazlewood-288284/photos',\n",
       " '/player/pat-cummins-489889/photos',\n",
       " '/player/marcus-stoinis-325012/photos',\n",
       " '/player/adam-zampa-379504/photos',\n",
       " '/player/david-warner-219889/photos',\n",
       " '/player/aaron-finch-5334/photos',\n",
       " '/player/mitchell-marsh-272450/photos',\n",
       " '/player/glenn-maxwell-325026/photos',\n",
       " '/player/tim-david-892749/photos',\n",
       " '/player/matthew-wade-230193/photos',\n",
       " '/player/adrian-holdstock-45448/photos',\n",
       " '/player/langton-rusere-393453/photos',\n",
       " '/player/sam-curran-662973/photos',\n",
       " '/player/hazratullah-zazai-793457/photos',\n",
       " '/player/rahmanullah-gurbaz-974087/photos',\n",
       " '/player/ibrahim-zadran-921509/photos',\n",
       " '/player/usman-ghani-711559/photos',\n",
       " '/player/najibullah-zadran-524049/photos',\n",
       " '/player/mohammad-nabi-25913/photos',\n",
       " '/player/azmatullah-omarzai-819429/photos',\n",
       " '/player/rashid-khan-793463/photos',\n",
       " '/player/mujeeb-ur-rahman-974109/photos',\n",
       " '/player/fareed-ahmad-568136/photos',\n",
       " '/player/fazalhaq-farooqi-974175/photos',\n",
       " '/player/ben-stokes-311158/photos',\n",
       " '/player/chris-woakes-247235/photos',\n",
       " '/player/mark-wood-351588/photos',\n",
       " '/player/adil-rashid-244497/photos',\n",
       " '/player/jos-buttler-308967/photos',\n",
       " '/player/alex-hales-249866/photos',\n",
       " '/player/dawid-malan-236489/photos',\n",
       " '/player/liam-livingstone-403902/photos',\n",
       " '/player/harry-brook-911707/photos',\n",
       " '/player/moeen-ali-8917/photos',\n",
       " '/player/ashen-bandara-958691/photos',\n",
       " '/player/virat-kohli-253802/photos',\n",
       " '/player/mohammad-rizwan-323389/photos',\n",
       " '/player/babar-azam-348144/photos',\n",
       " '/player/shan-masood-233901/photos',\n",
       " '/player/iftikhar-ahmed-480603/photos',\n",
       " '/player/shadab-khan-922943/photos',\n",
       " '/player/haider-ali-1168651/photos',\n",
       " '/player/mohammad-nawaz-348148/photos',\n",
       " '/player/asif-ali-494230/photos',\n",
       " '/player/shaheen-shah-afridi-1072470/photos',\n",
       " '/player/haris-rauf-1161606/photos',\n",
       " '/player/naseem-shah-1158088/photos',\n",
       " '/player/bhuvneshwar-kumar-326016/photos',\n",
       " '/player/arshdeep-singh-1125976/photos',\n",
       " '/player/mohammed-shami-481896/photos',\n",
       " '/player/hardik-pandya-625371/photos',\n",
       " '/player/ravichandran-ashwin-26421/photos',\n",
       " '/player/axar-patel-554691/photos',\n",
       " '/player/kl-rahul-422108/photos',\n",
       " '/player/rohit-sharma-34102/photos',\n",
       " '/player/suryakumar-yadav-446507/photos',\n",
       " '/player/dinesh-karthik-30045/photos',\n",
       " '/player/taskin-ahmed-538506/photos',\n",
       " '/player/najmul-hossain-shanto-629058/photos',\n",
       " '/player/soumya-sarkar-436677/photos',\n",
       " '/player/litton-das-536936/photos',\n",
       " '/player/shakib-al-hasan-56143/photos',\n",
       " '/player/afif-hossain-935995/photos',\n",
       " '/player/yasir-ali-629059/photos',\n",
       " '/player/nurul-hasan-410765/photos',\n",
       " '/player/mosaddek-hossain-550133/photos',\n",
       " '/player/hasan-mahmud-926629/photos',\n",
       " '/player/mustafizur-rahman-330902/photos',\n",
       " '/player/shariz-ahmad-1278252/photos',\n",
       " '/player/kagiso-rabada-550215/photos',\n",
       " '/player/wayne-parnell-265564/photos',\n",
       " '/player/lungi-ngidi-542023/photos',\n",
       " '/player/keshav-maharaj-267724/photos',\n",
       " '/player/anrich-nortje-481979/photos',\n",
       " '/player/quinton-de-kock-379143/photos',\n",
       " '/player/temba-bavuma-372116/photos',\n",
       " '/player/rilee-rossouw-318845/photos',\n",
       " '/player/aiden-markram-600498/photos',\n",
       " '/player/david-miller-321777/photos',\n",
       " '/player/tristan-stubbs-595978/photos',\n",
       " '/player/ashton-agar-505120/photos',\n",
       " '/player/fionn-hand-1099225/photos',\n",
       " '/player/naveen-ul-haq-793447/photos',\n",
       " '/player/darwish-rasooli-819441/photos',\n",
       " '/player/qais-ahmad-914171/photos',\n",
       " '/player/martin-guptill-226492/photos',\n",
       " '/player/michael-bracewell-326968/photos',\n",
       " '/player/daryl-mitchell-381743/photos',\n",
       " '/player/adam-milne-450860/photos',\n",
       " '/player/tabraiz-shamsi-379145/photos',\n",
       " '/player/mehidy-hasan-miraz-629063/photos',\n",
       " '/player/brad-evans-696127/photos',\n",
       " '/player/mohammad-wasim-1185538/photos',\n",
       " '/player/graham-hume-379144/photos',\n",
       " '/player/conor-olphert-1229953/photos',\n",
       " '/player/steven-smith-267192/photos',\n",
       " '/player/kane-richardson-272262/photos',\n",
       " '/player/cameron-green-1076713/photos',\n",
       " '/player/chris-jordan-288992/photos',\n",
       " '/player/david-willey-308251/photos',\n",
       " '/player/tymal-mills-459257/photos',\n",
       " '/player/phil-salt-669365/photos',\n",
       " '/player/kasun-rajitha-499594/photos',\n",
       " '/player/stephan-myburgh-233712/photos',\n",
       " '/player/brandon-glover-595419/photos',\n",
       " '/player/fakhar-zaman-512191/photos',\n",
       " '/player/deepak-hooda-497121/photos',\n",
       " '/player/gulbadin-naib-352048/photos',\n",
       " '/player/shoriful-islam-990039/photos',\n",
       " '/player/mohammad-haris-1205559/photos',\n",
       " '/player/heinrich-klaasen-436757/photos',\n",
       " '/player/nasum-ahmed-348049/photos',\n",
       " '/player/ebadot-hossain-932355/photos',\n",
       " '/player/rishabh-pant-931581/photos',\n",
       " '/player/wellington-masakadza-571703/photos']"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "player_photos = []\n",
    "for url in player_urls:\n",
    "    res = requests.get(\"https://espncricinfo.com\"+ url)\n",
    "    soup = BeautifulSoup(res.content, 'html.parser')\n",
    "    links = soup.find_all('a', href=True)\n",
    "    for link in links:\n",
    "        if '/photos' in link.get('href'):\n",
    "            player_photos.append(link.get('href'))\n",
    "temp = pd.DataFrame(player_photos)\n",
    "temp.drop_duplicates(inplace=True)\n",
    "player_photos = temp.to_numpy().tolist()\n",
    "player_photos = list(chain(*player_photos))\n",
    "player_photos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Player name - Michael van Lingen\n",
      "Player team - Namibia\n",
      "Batting style - Left hand Bat\n",
      "Bowling style - Left arm Medium\n",
      "Player role - Bowling Allrounder\n"
     ]
    }
   ],
   "source": [
    "res = requests.get(\"https://espncricinfo.com/player/michael-van-lingen-833777\")\n",
    "soup = BeautifulSoup(res.content, 'html.parser')\n",
    "name = soup.find_all('h1', class_='ds-text-title-l ds-font-bold')\n",
    "print('Player name -', name[0].text)\n",
    "team = soup.find_all('span', class_='ds-text-title-s ds-font-bold ds-text-ui-typo ds-underline ds-decoration-ui-stroke hover:ds-text-ui-typo-primary hover:ds-decoration-ui-stroke-primary ds-block')\n",
    "print('Player team -', team[0].text)\n",
    "h5 = soup.find_all('h5')\n",
    "print('Batting style -', h5[3].text)\n",
    "print('Bowling style -', h5[4].text)\n",
    "print('Player role -', h5[5].text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<span class=\"ds-text-title-s ds-font-bold ds-text-ui-typo ds-underline ds-decoration-ui-stroke hover:ds-text-ui-typo-primary hover:ds-decoration-ui-stroke-primary ds-block\">Namibia</span>"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "team[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'name': 'Jan Frylinck', 'team': 'Namibia', 'batting_style': 'Left hand Bat', 'bowling_style': 'Left arm Fast medium', 'player_role': 'Allrounder'}\n",
      "{'name': 'Michael van Lingen', 'team': 'Namibia', 'batting_style': 'Left hand Bat', 'bowling_style': 'Left arm Medium', 'player_role': 'Bowling Allrounder'}\n",
      "{'name': 'Divan la Cock', 'team': 'Namibia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak', 'player_role': 'Opening Batter'}\n",
      "{'name': 'Jan Nicol Loftie-Eaton', 'team': 'Namibia', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Medium, Legbreak', 'player_role': 'Batter'}\n",
      "{'name': 'Stephan Baard', 'team': 'Namibia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Batter'}\n",
      "{'name': 'Gerhard Erasmus', 'team': 'Namibia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Allrounder'}\n",
      "{'name': 'David Wiese', 'team': 'Namibia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Allrounder'}\n",
      "{'name': 'JJ Smit', 'team': 'Namibia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Left arm Medium fast', 'player_role': 'Bowling Allrounder'}\n",
      "{'name': 'Zane Green', 'team': 'Namibia', 'batting_style': 'Left hand Bat', 'bowling_style': 'Wicketkeeper', 'player_role': 'Wicketkeeper Batter'}\n",
      "{'name': 'Bernard Scholtz', 'team': 'Namibia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Bowler'}\n",
      "{'name': 'Ben Shikongo', 'team': 'Namibia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Maheesh Theekshana', 'team': 'Sri Lanka', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Bowler'}\n",
      "{'name': 'Dushmantha Chameera', 'team': 'Sri Lanka', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Pramod Madushan', 'team': 'Sri Lanka', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Chamika Karunaratne', 'team': 'Sri Lanka', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Bowling Allrounder'}\n",
      "{'name': 'Wanindu Hasaranga de Silva', 'team': 'Sri Lanka', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak', 'player_role': 'Allrounder'}\n",
      "{'name': 'Pathum Nissanka', 'team': 'Sri Lanka', 'batting_style': 'Right hand Bat', 'bowling_style': 'Top order Batter', 'player_role': 'Isipathana College, Colombo'}\n",
      "{'name': 'Kusal Mendis', 'team': 'Sri Lanka', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak', 'player_role': 'Wicketkeeper'}\n",
      "{'name': 'Dhananjaya de Silva', 'team': 'Sri Lanka', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Allrounder'}\n",
      "{'name': 'Danushka Gunathilaka', 'team': 'Sri Lanka', 'batting_style': 'Dana', 'bowling_style': 'Left hand Bat', 'player_role': 'Right arm Offbreak'}\n",
      "{'name': 'Bhanuka Rajapaksa', 'team': 'Sri Lanka', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Top order Batter'}\n",
      "{'name': 'Dasun Shanaka', 'team': 'Sri Lanka', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Allrounder'}\n",
      "{'name': 'Joel Wilson', 'team': 'West Indies', 'batting_style': 'Umpire', 'bowling_style': 'Umpire & Referee', 'player_role': 'Explore Statsguru Analysis'}\n",
      "{'name': 'Rod Tucker', 'team': 'Australia', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Umpire'}\n",
      "{'name': 'Paul Reiffel', 'team': 'Australia', 'batting_style': 'Pistol', 'bowling_style': 'Right hand Bat', 'player_role': 'Right arm Fast medium'}\n",
      "{'name': 'Marais Erasmus', 'team': 'South Africa', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'DF Malan High School, Paarl Teachers Training College, Stellenbosch University'}\n",
      "{'name': 'Andy Pycroft', 'team': 'Zimbabwe', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Referee, Coach'}\n",
      "{'name': 'Bas de Leede', 'team': 'Netherlands', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Batting Allrounder'}\n",
      "{'name': 'Junaid Siddique', 'team': 'U.A.E.', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Chirag Suri', 'team': 'U.A.E.', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak, Legbreak Googly', 'player_role': 'Opening Batter'}\n",
      "{'name': 'Muhammad Waseem', 'team': 'U.A.E.', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Opening Batter'}\n",
      "{'name': 'Kashif Daud', 'team': 'U.A.E.', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Bowling Allrounder'}\n",
      "{'name': 'Vriitya Aravind', 'team': 'U.A.E.', 'batting_style': 'Right hand Bat', 'bowling_style': 'Wicketkeeper', 'player_role': 'Batting & Fielding'}\n",
      "{'name': 'Zawar Farid', 'team': 'U.A.E.', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Basil Hameed', 'team': 'U.A.E.', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'Chundangapoyil Rizwan', 'team': 'U.A.E.', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak Googly', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'Aayan Afzal Khan', 'team': 'U.A.E.', 'batting_style': 'Right hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Bowling Allrounder'}\n",
      "{'name': 'Karthik Meiyappan', 'team': 'U.A.E.', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak', 'player_role': 'Bowler'}\n",
      "{'name': 'Zahoor Khan', 'team': 'U.A.E.', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Fred Klaassen', 'team': 'Netherlands', 'batting_style': 'Right hand Bat', 'bowling_style': 'Left arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Tim Pringle', 'team': 'Netherlands', 'batting_style': 'Right hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Allrounder'}\n",
      "{'name': 'Logan van Beek', 'team': 'Netherlands', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Paul van Meekeren', 'team': 'Netherlands', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Roelof van der Merwe', 'team': 'Netherlands', 'batting_style': 'Roela', 'bowling_style': 'Right hand Bat', 'player_role': 'Slow Left arm Orthodox'}\n",
      "{'name': 'Vikramjit Singh', 'team': 'Netherlands', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Opening Batter'}\n",
      "{'name': \"Max O'Dowd\", 'team': 'Netherlands', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Opening Batter'}\n",
      "{'name': 'Colin Ackermann', 'team': 'Netherlands', 'batting_style': 'Ackers', 'bowling_style': 'Right hand Bat', 'player_role': 'Right arm Offbreak'}\n",
      "{'name': 'Tom Cooper', 'team': 'Netherlands', 'batting_style': 'Coops', 'bowling_style': 'Right hand Bat', 'player_role': 'Right arm Offbreak'}\n",
      "{'name': 'Scott Edwards', 'team': 'Netherlands', 'batting_style': 'Right hand Bat', 'bowling_style': 'Wicketkeeper', 'player_role': 'Wicketkeeper Batter'}\n",
      "{'name': 'Richard Kettleborough', 'team': 'England', 'batting_style': 'Ketts', 'bowling_style': 'Left hand Bat', 'player_role': 'Right arm Medium'}\n",
      "{'name': 'Ranjan Madugalle', 'team': 'Sri Lanka', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'George Munsey', 'team': 'Scotland', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Opening Batter'}\n",
      "{'name': 'Michael Jones', 'team': 'Scotland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Top order Batter'}\n",
      "{'name': 'Matthew Cross', 'team': 'Scotland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Wicketkeeper', 'player_role': 'Wicketkeeper Batter'}\n",
      "{'name': 'Richie Berrington', 'team': 'Scotland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Top order Batter'}\n",
      "{'name': 'Calum MacLeod', 'team': 'Scotland', 'batting_style': 'Cloudy, Highlander, Scot', 'bowling_style': 'Right hand Bat', 'player_role': 'Right arm Medium fast, Right arm Offbreak'}\n",
      "{'name': 'Michael Leask', 'team': 'Scotland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Allrounder'}\n",
      "{'name': 'Chris Greaves', 'team': 'Scotland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak', 'player_role': 'Bowler'}\n",
      "{'name': 'Mark Watt', 'team': 'Scotland', 'batting_style': 'Left hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Bowler'}\n",
      "{'name': 'Josh Davey', 'team': 'Scotland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Safyaan Sharif', 'team': 'Scotland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Brad Wheal', 'team': 'Scotland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Kyle Mayers', 'team': 'West Indies', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Batting Allrounder'}\n",
      "{'name': 'Akeal Hosein', 'team': 'West Indies', 'batting_style': 'Left hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Bowler'}\n",
      "{'name': 'Alzarri Joseph', 'team': 'West Indies', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Obed McCoy', 'team': 'West Indies', 'batting_style': 'Left hand Bat', 'bowling_style': 'Left arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Jason Holder', 'team': 'West Indies', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Bowling Allrounder'}\n",
      "{'name': 'Odean Smith', 'team': 'West Indies', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Bowling Allrounder'}\n",
      "{'name': 'Evin Lewis', 'team': 'West Indies', 'batting_style': 'Left hand Bat', 'bowling_style': 'Opening Batter', 'player_role': 'Batting & Fielding'}\n",
      "{'name': 'Brandon King', 'team': 'West Indies', 'batting_style': 'Right hand Bat', 'bowling_style': 'Top order Batter', 'player_role': 'Batting & Fielding'}\n",
      "{'name': 'Nicholas Pooran', 'team': 'West Indies', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Wicketkeeper'}\n",
      "{'name': 'Shamarh Brooks', 'team': 'West Indies', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak', 'player_role': 'Top order Batter'}\n",
      "{'name': 'Rovman Powell', 'team': 'West Indies', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'Aleem Dar', 'team': 'Pakistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak', 'player_role': 'Umpire'}\n",
      "{'name': 'Paul Wilson', 'team': 'Australia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Umpire, Coach'}\n",
      "{'name': 'Chris Brown', 'team': 'New Zealand', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Umpire'}\n",
      "{'name': 'Kumar Dharmasena', 'team': 'Sri Lanka', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Allrounder'}\n",
      "{'name': 'Chris Broad', 'team': 'England', 'batting_style': 'Walter, Broodie', 'bowling_style': 'Left hand Bat', 'player_role': 'Right arm Medium'}\n",
      "{'name': 'Sikandar Raza', 'team': 'Zimbabwe', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Batting Allrounder'}\n",
      "{'name': 'Regis Chakabva', 'team': 'Zimbabwe', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Wicketkeeper'}\n",
      "{'name': 'Craig Ervine', 'team': 'Zimbabwe', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'Wessly Madhevere', 'team': 'Zimbabwe', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Allrounder'}\n",
      "{'name': 'Sean Williams', 'team': 'Zimbabwe', 'batting_style': 'Left hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'Milton Shumba', 'team': 'Zimbabwe', 'batting_style': 'Left hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Top order Batter'}\n",
      "{'name': 'Ryan Burl', 'team': 'Zimbabwe', 'batting_style': 'Left hand Bat', 'bowling_style': 'Legbreak', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'Luke Jongwe', 'team': 'Zimbabwe', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Tendai Chatara', 'team': 'Zimbabwe', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Richard Ngarava', 'team': 'Zimbabwe', 'batting_style': 'Left hand Bat', 'bowling_style': 'Left arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Blessing Muzarabani', 'team': 'Zimbabwe', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Josh Little', 'team': 'Ireland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Left arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Mark Adair', 'team': 'Ireland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Bowling Allrounder'}\n",
      "{'name': 'Barry McCarthy', 'team': 'Ireland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Curtis Campher', 'team': 'Ireland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Allrounder'}\n",
      "{'name': 'Simi Singh', 'team': 'Ireland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak, Legbreak Googly', 'player_role': 'Bowling Allrounder'}\n",
      "{'name': 'Gareth Delany', 'team': 'Ireland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak Googly', 'player_role': 'Batting Allrounder'}\n",
      "{'name': 'Paul Stirling', 'team': 'Ireland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Batting Allrounder'}\n",
      "{'name': 'Andy Balbirnie', 'team': 'Ireland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Occasional Wicketkeeper'}\n",
      "{'name': 'Lorcan Tucker', 'team': 'Ireland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Wicketkeeper', 'player_role': 'Wicketkeeper Batter'}\n",
      "{'name': 'Harry Tector', 'team': 'Ireland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'George Dockrell', 'team': 'Ireland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Allrounder'}\n",
      "{'name': 'Timm van der Gugten', 'team': 'Netherlands', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Charith Asalanka', 'team': 'Sri Lanka', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Batting Allrounder'}\n",
      "{'name': 'Aryan Lakra', 'team': 'U.A.E.', 'batting_style': 'Left hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Bowler'}\n",
      "{'name': 'Johnson Charles', 'team': 'West Indies', 'batting_style': 'Right hand Bat', 'bowling_style': 'Wicketkeeper', 'player_role': 'Wicketkeeper Batter'}\n",
      "{'name': 'Tony Munyonga', 'team': 'Zimbabwe', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Allrounder'}\n",
      "{'name': 'Lahiru Kumara', 'team': 'Sri Lanka', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Binura Fernando', 'team': 'Sri Lanka', 'batting_style': 'Right hand Bat', 'bowling_style': 'Left arm Medium fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Richard Illingworth', 'team': 'England', 'batting_style': 'Right hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Bowler'}\n",
      "{'name': 'Alishan Sharafu', 'team': 'U.A.E.', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Opening Batter'}\n",
      "{'name': 'Fahad Nawaz', 'team': 'U.A.E.', 'batting_style': 'Right hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Allrounder'}\n",
      "{'name': 'Ahmed Raza', 'team': 'U.A.E.', 'batting_style': 'Right hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Bowler'}\n",
      "{'name': 'Ruben Trumpelmann', 'team': 'Namibia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Left arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Ahsan Raza', 'team': 'Pakistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Wicketkeeper', 'player_role': 'Umpire'}\n",
      "{'name': 'Chris Gaffaney', 'team': 'New Zealand', 'batting_style': 'Right hand Bat', 'bowling_style': 'Umpire', 'player_role': 'Batting & Fielding'}\n",
      "{'name': 'Michael Gough', 'team': 'England', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Umpire'}\n",
      "{'name': 'Nitin Menon', 'team': 'India', 'batting_style': 'Right hand Bat', 'bowling_style': 'Umpire', 'player_role': 'Batting & Fielding'}\n",
      "{'name': 'David Boon', 'team': 'Australia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Top order Batter'}\n",
      "{'name': 'Devon Conway', 'team': 'New Zealand', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Occasional Wicketkeeper'}\n",
      "{'name': 'Finn Allen', 'team': 'New Zealand', 'batting_style': 'Right hand Bat', 'bowling_style': 'Occasional Wicketkeeper', 'player_role': 'Top order Batter'}\n",
      "{'name': 'Kane Williamson', 'team': 'New Zealand', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Top order Batter'}\n",
      "{'name': 'Glenn Phillips', 'team': 'New Zealand', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Wicketkeeper'}\n",
      "{'name': 'James Neesham', 'team': 'New Zealand', 'batting_style': 'Jimmy Neesham', 'bowling_style': 'Left hand Bat', 'player_role': 'Right arm Medium fast'}\n",
      "{'name': 'Mark Chapman', 'team': 'New Zealand', 'batting_style': 'Left hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Allrounder'}\n",
      "{'name': 'Mitchell Santner', 'team': 'New Zealand', 'batting_style': 'Left hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Bowling Allrounder'}\n",
      "{'name': 'Ish Sodhi', 'team': 'New Zealand', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak', 'player_role': 'Bowler'}\n",
      "{'name': 'Tim Southee', 'team': 'New Zealand', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Lockie Ferguson', 'team': 'New Zealand', 'batting_style': 'Lockie', 'bowling_style': 'Right hand Bat', 'player_role': 'Right arm Fast'}\n",
      "{'name': 'Trent Boult', 'team': 'New Zealand', 'batting_style': 'Right hand Bat', 'bowling_style': 'Left arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Mitchell Starc', 'team': 'Australia', 'batting_style': 'Left hand Bat', 'bowling_style': 'Left arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Josh Hazlewood', 'team': 'Australia', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Pat Cummins', 'team': 'Australia', 'batting_style': 'Cummo', 'bowling_style': 'Right hand Bat', 'player_role': 'Right arm Fast'}\n",
      "{'name': 'Marcus Stoinis', 'team': 'Australia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Batting Allrounder'}\n",
      "{'name': 'Adam Zampa', 'team': 'Australia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak Googly', 'player_role': 'Bowler'}\n",
      "{'name': 'David Warner', 'team': 'Australia', 'batting_style': 'Lloyd', 'bowling_style': 'Left hand Bat', 'player_role': 'Legbreak'}\n",
      "{'name': 'Aaron Finch', 'team': 'Australia', 'batting_style': 'Finchy', 'bowling_style': 'Right hand Bat', 'player_role': 'Slow Left arm Orthodox'}\n",
      "{'name': 'Mitchell Marsh', 'team': 'Australia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Allrounder'}\n",
      "{'name': 'Glenn Maxwell', 'team': 'Australia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Batting Allrounder'}\n",
      "{'name': 'Tim David', 'team': 'Australia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'Matthew Wade', 'team': 'Australia', 'batting_style': 'Wadey', 'bowling_style': 'Left hand Bat', 'player_role': 'Right arm Medium'}\n",
      "{'name': 'Adrian Holdstock', 'team': 'South Africa', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Umpire'}\n",
      "{'name': 'Langton Rusere', 'team': 'Zimbabwe', 'batting_style': 'Umpire', 'bowling_style': 'Umpire & Referee', 'player_role': 'Explore Statsguru Analysis'}\n",
      "{'name': 'Sam Curran', 'team': 'England', 'batting_style': 'Left hand Bat', 'bowling_style': 'Left arm Medium fast', 'player_role': 'Allrounder'}\n",
      "{'name': 'Hazratullah Zazai', 'team': 'Afghanistan', 'batting_style': 'Left hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Opening Batter'}\n",
      "{'name': 'Rahmanullah Gurbaz', 'team': 'Afghanistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Wicketkeeper', 'player_role': 'Wicketkeeper Batter'}\n",
      "{'name': 'Ibrahim Zadran', 'team': 'Afghanistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Opening Batter'}\n",
      "{'name': 'Usman Ghani', 'team': 'Afghanistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Opening Batter', 'player_role': 'Batting & Fielding'}\n",
      "{'name': 'Najibullah Zadran', 'team': 'Afghanistan', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'Mohammad Nabi', 'team': 'Afghanistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Allrounder'}\n",
      "{'name': 'Azmatullah Omarzai', 'team': 'Afghanistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Allrounder'}\n",
      "{'name': 'Rashid Khan', 'team': 'Afghanistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak Googly', 'player_role': 'Bowling Allrounder'}\n",
      "{'name': 'Mujeeb Ur Rahman', 'team': 'Afghanistan', 'batting_style': 'Mujeeb Zadran', 'bowling_style': 'Right hand Bat', 'player_role': 'Right arm Offbreak'}\n",
      "{'name': 'Fareed Ahmad', 'team': 'Afghanistan', 'batting_style': 'Farid Malik', 'bowling_style': 'Left hand Bat', 'player_role': 'Left arm Fast medium'}\n",
      "{'name': 'Fazalhaq Farooqi', 'team': 'Afghanistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Left arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Ben Stokes', 'team': 'England', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Allrounder'}\n",
      "{'name': 'Chris Woakes', 'team': 'England', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Allrounder'}\n",
      "{'name': 'Mark Wood', 'team': 'England', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Adil Rashid', 'team': 'England', 'batting_style': 'Dilly, Hoover', 'bowling_style': 'Right hand Bat', 'player_role': 'Legbreak'}\n",
      "{'name': 'Jos Buttler', 'team': 'England', 'batting_style': 'Right hand Bat', 'bowling_style': 'Wicketkeeper', 'player_role': 'Wicketkeeper Batter'}\n",
      "{'name': 'Alex Hales', 'team': 'England', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Occasional Wicketkeeper'}\n",
      "{'name': 'Dawid Malan', 'team': 'England', 'batting_style': 'AC', 'bowling_style': 'Left hand Bat', 'player_role': 'Legbreak'}\n",
      "{'name': 'Liam Livingstone', 'team': 'England', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak', 'player_role': 'Batting Allrounder'}\n",
      "{'name': 'Harry Brook', 'team': 'England', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Batter'}\n",
      "{'name': 'Moeen Ali', 'team': 'England', 'batting_style': 'Moe', 'bowling_style': 'Left hand Bat', 'player_role': 'Right arm Offbreak'}\n",
      "{'name': 'Ashen Bandara', 'team': 'Sri Lanka', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'Virat Kohli', 'team': 'India', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Top order Batter'}\n",
      "{'name': 'Mohammad Rizwan', 'team': 'Pakistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Wicketkeeper', 'player_role': 'Wicketkeeper Batter'}\n",
      "{'name': 'Babar Azam', 'team': 'Pakistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Batter'}\n",
      "{'name': 'Shan Masood', 'team': 'Pakistan', 'batting_style': 'Shaan Masood', 'bowling_style': 'Shaani', 'player_role': 'Left hand Bat'}\n",
      "{'name': 'Iftikhar Ahmed', 'team': 'Pakistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'Shadab Khan', 'team': 'Pakistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak', 'player_role': 'Allrounder'}\n",
      "{'name': 'Haider Ali', 'team': 'Pakistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Middle order Batter', 'player_role': 'Batting & Fielding'}\n",
      "{'name': 'Mohammad Nawaz', 'team': 'Pakistan', 'batting_style': 'Left hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Allrounder'}\n",
      "{'name': 'Asif Ali', 'team': 'Pakistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'Shaheen Shah Afridi', 'team': 'Pakistan', 'batting_style': 'Left hand Bat', 'bowling_style': 'Left arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Haris Rauf', 'team': 'Pakistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Naseem Shah', 'team': 'Pakistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Bhuvneshwar Kumar', 'team': 'India', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Arshdeep Singh', 'team': 'India', 'batting_style': 'Left hand Bat', 'bowling_style': 'Left arm Medium fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Mohammed Shami', 'team': 'India', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Hardik Pandya', 'team': 'India', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Allrounder'}\n",
      "{'name': 'Ravichandran Ashwin', 'team': 'India', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Bowling Allrounder'}\n",
      "{'name': 'Axar Patel', 'team': 'India', 'batting_style': 'Akshar Patel', 'bowling_style': 'Left hand Bat', 'player_role': 'Slow Left arm Orthodox'}\n",
      "{'name': 'KL Rahul', 'team': 'India', 'batting_style': 'Right hand Bat', 'bowling_style': 'Wicketkeeper', 'player_role': 'Opening Batter'}\n",
      "{'name': 'Rohit Sharma', 'team': 'India', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Top order Batter'}\n",
      "{'name': 'Suryakumar Yadav', 'team': 'India', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium, Right arm Offbreak', 'player_role': 'Batter'}\n",
      "{'name': 'Dinesh Karthik', 'team': 'India', 'batting_style': 'Dinesh', 'bowling_style': 'Right hand Bat', 'player_role': 'Right arm Offbreak'}\n",
      "{'name': 'Taskin Ahmed', 'team': 'Bangladesh', 'batting_style': 'Tazin', 'bowling_style': 'Left hand Bat', 'player_role': 'Right arm Fast'}\n",
      "{'name': 'Najmul Hossain Shanto', 'team': 'Bangladesh', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Top order Batter'}\n",
      "{'name': 'Soumya Sarkar', 'team': 'Bangladesh', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'Litton Das', 'team': 'Bangladesh', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Wicketkeeper'}\n",
      "{'name': 'Shakib Al Hasan', 'team': 'Bangladesh', 'batting_style': 'Saqibul Hasan', 'bowling_style': 'Left hand Bat', 'player_role': 'Slow Left arm Orthodox'}\n",
      "{'name': 'Afif Hossain', 'team': 'Bangladesh', 'batting_style': 'Dhrubo', 'bowling_style': 'Left hand Bat', 'player_role': 'Right arm Offbreak'}\n",
      "{'name': 'Yasir Ali', 'team': 'Bangladesh', 'batting_style': 'Yasir Ali Rabbi', 'bowling_style': 'Rabbi', 'player_role': 'Right hand Bat'}\n",
      "{'name': 'Nurul Hasan', 'team': 'Bangladesh', 'batting_style': 'Sohan', 'bowling_style': 'Right hand Bat', 'player_role': 'Wicketkeeper'}\n",
      "{'name': 'Mosaddek Hossain', 'team': 'Bangladesh', 'batting_style': 'Saikat', 'bowling_style': 'Right hand Bat', 'player_role': 'Right arm Offbreak'}\n",
      "{'name': 'Hasan Mahmud', 'team': 'Bangladesh', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Mustafizur Rahman', 'team': 'Bangladesh', 'batting_style': 'Left hand Bat', 'bowling_style': 'Left arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Shariz Ahmad', 'team': 'Netherlands', 'batting_style': 'Left hand Bat', 'bowling_style': 'Legbreak Googly', 'player_role': 'Bowler'}\n",
      "{'name': 'Kagiso Rabada', 'team': 'South Africa', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Wayne Parnell', 'team': 'South Africa', 'batting_style': 'Pigeon, Parny', 'bowling_style': 'Left hand Bat', 'player_role': 'Left arm Medium fast'}\n",
      "{'name': 'Lungi Ngidi', 'team': 'South Africa', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Keshav Maharaj', 'team': 'South Africa', 'batting_style': 'Right hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Bowler'}\n",
      "{'name': 'Anrich Nortje', 'team': 'South Africa', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Quinton de Kock', 'team': 'South Africa', 'batting_style': 'Left hand Bat', 'bowling_style': 'Wicketkeeper', 'player_role': 'Wicketkeeper Batter'}\n",
      "{'name': 'Temba Bavuma', 'team': 'South Africa', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'Rilee Rossouw', 'team': 'South Africa', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Top order Batter'}\n",
      "{'name': 'Aiden Markram', 'team': 'South Africa', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Opening Batter'}\n",
      "{'name': 'David Miller', 'team': 'South Africa', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Middle order Batter'}\n",
      "{'name': 'Tristan Stubbs', 'team': 'South Africa', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Wicketkeeper'}\n",
      "{'name': 'Ashton Agar', 'team': 'Australia', 'batting_style': 'Left hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Bowler'}\n",
      "{'name': 'Fionn Hand', 'team': 'Ireland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Bowling Allrounder'}\n",
      "{'name': 'Naveen-ul-Haq', 'team': 'Afghanistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Darwish Rasooli', 'team': 'Afghanistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Top order Batter'}\n",
      "{'name': 'Qais Ahmad', 'team': 'Afghanistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Legbreak', 'player_role': 'Bowler'}\n",
      "{'name': 'Mohammad Saleem', 'team': 'Afghanistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Martin Guptill', 'team': 'New Zealand', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Opening Batter'}\n",
      "{'name': 'Michael Bracewell', 'team': 'New Zealand', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Wicketkeeper'}\n",
      "{'name': 'Daryl Mitchell', 'team': 'New Zealand', 'batting_style': 'Moose', 'bowling_style': 'Right hand Bat', 'player_role': 'Right arm Medium'}\n",
      "{'name': 'Adam Milne', 'team': 'New Zealand', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Tabraiz Shamsi', 'team': 'South Africa', 'batting_style': 'Right hand Bat', 'bowling_style': 'Left arm Wrist spin', 'player_role': 'Bowler'}\n",
      "{'name': 'Mehidy Hasan Miraz', 'team': 'Bangladesh', 'batting_style': 'Miraz', 'bowling_style': 'Right hand Bat', 'player_role': 'Right arm Offbreak'}\n",
      "{'name': 'Brad Evans', 'team': 'Zimbabwe', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast', 'player_role': 'Allrounder'}\n",
      "{'name': 'Mohammad Wasim', 'team': 'Pakistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Allrounder'}\n",
      "{'name': 'Graham Hume', 'team': 'Ireland', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Conor Olphert', 'team': 'Ireland', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Steven Smith', 'team': 'Australia', 'batting_style': 'Steve Smith', 'bowling_style': 'Right hand Bat', 'player_role': 'Legbreak Googly'}\n",
      "{'name': 'Kane Richardson', 'team': 'Australia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Cameron Green', 'team': 'Australia', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Batting Allrounder'}\n",
      "{'name': 'Chris Jordan', 'team': 'England', 'batting_style': 'CJ', 'bowling_style': 'Right hand Bat', 'player_role': 'Right arm Fast medium'}\n",
      "{'name': 'David Willey', 'team': 'England', 'batting_style': 'Left hand Bat', 'bowling_style': 'Left arm Fast medium', 'player_role': 'Bowling Allrounder'}\n",
      "{'name': 'Tymal Mills', 'team': 'England', 'batting_style': 'Right hand Bat', 'bowling_style': 'Left arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Phil Salt', 'team': 'England', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Wicketkeeper'}\n",
      "{'name': 'Kasun Rajitha', 'team': 'Sri Lanka', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Medium fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Stephan Myburgh', 'team': 'Netherlands', 'batting_style': 'Left hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Opening Batter'}\n",
      "{'name': 'Brandon Glover', 'team': 'Netherlands', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Fakhar Zaman', 'team': 'Pakistan', 'batting_style': 'Left hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Opening Batter'}\n",
      "{'name': 'Deepak Hooda', 'team': 'India', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Allrounder'}\n",
      "{'name': 'Gulbadin Naib', 'team': 'Afghanistan', 'batting_style': 'Gulbadeen Naib', 'bowling_style': 'Right hand Bat', 'player_role': 'Right arm Medium fast'}\n",
      "{'name': 'Shoriful Islam', 'team': 'Bangladesh', 'batting_style': 'Left hand Bat', 'bowling_style': 'Left arm Medium fast', 'player_role': 'Bowler'}\n",
      "{'name': 'Mohammad Haris', 'team': 'Pakistan', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Occasional Wicketkeeper'}\n",
      "{'name': 'Heinrich Klaasen', 'team': 'South Africa', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Offbreak', 'player_role': 'Wicketkeeper'}\n",
      "{'name': 'Nasum Ahmed', 'team': 'Bangladesh', 'batting_style': 'Left hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Bowler'}\n",
      "{'name': 'Ebadot Hossain', 'team': 'Bangladesh', 'batting_style': 'Right hand Bat', 'bowling_style': 'Right arm Fast medium', 'player_role': 'Bowler'}\n",
      "{'name': 'Rishabh Pant', 'team': 'India', 'batting_style': 'Left hand Bat', 'bowling_style': 'Wicketkeeper', 'player_role': 'Wicketkeeper Batter'}\n",
      "{'name': 'Wellington Masakadza', 'team': 'Zimbabwe', 'batting_style': 'Left hand Bat', 'bowling_style': 'Slow Left arm Orthodox', 'player_role': 'Bowler'}\n"
     ]
    },
    {
     "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>name</th>\n",
       "      <th>team</th>\n",
       "      <th>batting_style</th>\n",
       "      <th>bowling_style</th>\n",
       "      <th>player_role</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Jan Frylinck</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Left arm Fast medium</td>\n",
       "      <td>Allrounder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Michael van Lingen</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Left arm Medium</td>\n",
       "      <td>Bowling Allrounder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Divan la Cock</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Legbreak</td>\n",
       "      <td>Opening Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Jan Nicol Loftie-Eaton</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Right arm Medium, Legbreak</td>\n",
       "      <td>Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Stephan Baard</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Medium fast</td>\n",
       "      <td>Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>Heinrich Klaasen</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Offbreak</td>\n",
       "      <td>Wicketkeeper</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>Nasum Ahmed</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Slow Left arm Orthodox</td>\n",
       "      <td>Bowler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>Ebadot Hossain</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Fast medium</td>\n",
       "      <td>Bowler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>Rishabh Pant</td>\n",
       "      <td>India</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Wicketkeeper</td>\n",
       "      <td>Wicketkeeper Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>Wellington Masakadza</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Slow Left arm Orthodox</td>\n",
       "      <td>Bowler</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>245 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       name          team   batting_style  \\\n",
       "0              Jan Frylinck       Namibia   Left hand Bat   \n",
       "1        Michael van Lingen       Namibia   Left hand Bat   \n",
       "2             Divan la Cock       Namibia  Right hand Bat   \n",
       "3    Jan Nicol Loftie-Eaton       Namibia   Left hand Bat   \n",
       "4             Stephan Baard       Namibia  Right hand Bat   \n",
       "..                      ...           ...             ...   \n",
       "240        Heinrich Klaasen  South Africa  Right hand Bat   \n",
       "241             Nasum Ahmed    Bangladesh   Left hand Bat   \n",
       "242          Ebadot Hossain    Bangladesh  Right hand Bat   \n",
       "243            Rishabh Pant         India   Left hand Bat   \n",
       "244    Wellington Masakadza      Zimbabwe   Left hand Bat   \n",
       "\n",
       "                  bowling_style          player_role  \n",
       "0          Left arm Fast medium           Allrounder  \n",
       "1               Left arm Medium   Bowling Allrounder  \n",
       "2                      Legbreak       Opening Batter  \n",
       "3    Right arm Medium, Legbreak               Batter  \n",
       "4         Right arm Medium fast               Batter  \n",
       "..                          ...                  ...  \n",
       "240          Right arm Offbreak         Wicketkeeper  \n",
       "241      Slow Left arm Orthodox               Bowler  \n",
       "242       Right arm Fast medium               Bowler  \n",
       "243                Wicketkeeper  Wicketkeeper Batter  \n",
       "244      Slow Left arm Orthodox               Bowler  \n",
       "\n",
       "[245 rows x 5 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "player_info = pd.DataFrame(columns=['name', 'team', 'batting_style', 'bowling_style', 'player_role'])\n",
    "for url in player_urls:\n",
    "    res = requests.get(\"https://espncricinfo.com\"+ url)\n",
    "    soup = BeautifulSoup(res.content, 'html.parser')\n",
    "    name = soup.find_all('h1', class_='ds-text-title-l ds-font-bold')\n",
    "    team = soup.find_all('span', class_='ds-text-comfortable-s')\n",
    "    h5 = soup.find_all('h5')\n",
    "    \n",
    "    temp = {'name':name[0].get_text(strip=True) if name[0] else None, 'team': team[0].get_text(strip=True) if team[0] else None, \n",
    "    'batting_style': h5[3].get_text(strip=True) if h5[3] else None, 'bowling_style': h5[4].get_text(strip=True) if h5[4] else None, \n",
    "    'player_role': h5[5].get_text(strip=True) if h5[5] else None}\n",
    "    print(temp)\n",
    "    temp = pd.DataFrame(temp, index=[0])\n",
    "    player_info = pd.concat([player_info, temp], ignore_index=True)\n",
    "        \n",
    "player_info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "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>name</th>\n",
       "      <th>team</th>\n",
       "      <th>batting_style</th>\n",
       "      <th>bowling_style</th>\n",
       "      <th>player_role</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td>India</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Umpire</td>\n",
       "      <td>Batting &amp; Fielding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>Virat Kohli</td>\n",
       "      <td>India</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Medium</td>\n",
       "      <td>Top order Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>Bhuvneshwar Kumar</td>\n",
       "      <td>India</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Medium</td>\n",
       "      <td>Bowler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>Arshdeep Singh</td>\n",
       "      <td>India</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Left arm Medium fast</td>\n",
       "      <td>Bowler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>Mohammed Shami</td>\n",
       "      <td>India</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Fast</td>\n",
       "      <td>Bowler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>Hardik Pandya</td>\n",
       "      <td>India</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Medium fast</td>\n",
       "      <td>Allrounder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>Ravichandran Ashwin</td>\n",
       "      <td>India</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Offbreak</td>\n",
       "      <td>Bowling Allrounder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>Axar Patel</td>\n",
       "      <td>India</td>\n",
       "      <td>Akshar Patel</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Slow Left arm Orthodox</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>KL Rahul</td>\n",
       "      <td>India</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Wicketkeeper</td>\n",
       "      <td>Opening Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>Rohit Sharma</td>\n",
       "      <td>India</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Offbreak</td>\n",
       "      <td>Top order Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>Suryakumar Yadav</td>\n",
       "      <td>India</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Medium, Right arm Offbreak</td>\n",
       "      <td>Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>Dinesh Karthik</td>\n",
       "      <td>India</td>\n",
       "      <td>Dinesh</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Offbreak</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>Deepak Hooda</td>\n",
       "      <td>India</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Offbreak</td>\n",
       "      <td>Allrounder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>Rishabh Pant</td>\n",
       "      <td>India</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Wicketkeeper</td>\n",
       "      <td>Wicketkeeper Batter</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    name   team   batting_style  \\\n",
       "115          Nitin Menon  India  Right hand Bat   \n",
       "164          Virat Kohli  India  Right hand Bat   \n",
       "176    Bhuvneshwar Kumar  India  Right hand Bat   \n",
       "177       Arshdeep Singh  India   Left hand Bat   \n",
       "178       Mohammed Shami  India  Right hand Bat   \n",
       "179        Hardik Pandya  India  Right hand Bat   \n",
       "180  Ravichandran Ashwin  India  Right hand Bat   \n",
       "181           Axar Patel  India    Akshar Patel   \n",
       "182             KL Rahul  India  Right hand Bat   \n",
       "183         Rohit Sharma  India  Right hand Bat   \n",
       "184     Suryakumar Yadav  India  Right hand Bat   \n",
       "185       Dinesh Karthik  India          Dinesh   \n",
       "236         Deepak Hooda  India  Right hand Bat   \n",
       "243         Rishabh Pant  India   Left hand Bat   \n",
       "\n",
       "                            bowling_style             player_role  \n",
       "115                                Umpire      Batting & Fielding  \n",
       "164                      Right arm Medium        Top order Batter  \n",
       "176                      Right arm Medium                  Bowler  \n",
       "177                  Left arm Medium fast                  Bowler  \n",
       "178                        Right arm Fast                  Bowler  \n",
       "179                 Right arm Medium fast              Allrounder  \n",
       "180                    Right arm Offbreak      Bowling Allrounder  \n",
       "181                         Left hand Bat  Slow Left arm Orthodox  \n",
       "182                          Wicketkeeper          Opening Batter  \n",
       "183                    Right arm Offbreak        Top order Batter  \n",
       "184  Right arm Medium, Right arm Offbreak                  Batter  \n",
       "185                        Right hand Bat      Right arm Offbreak  \n",
       "236                    Right arm Offbreak              Allrounder  \n",
       "243                          Wicketkeeper     Wicketkeeper Batter  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "player_info[player_info['team']=='India']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Player name - Dinesh Karthik\n",
      "Player team - India\n",
      "Batting style - Dinesh\n",
      "Bowling style - Right hand Bat\n",
      "Player role - Right arm Offbreak\n"
     ]
    }
   ],
   "source": [
    "response = requests.get('https://www.espncricinfo.com/player/dinesh-karthik-30045')\n",
    "soup = BeautifulSoup(response.content, 'html.parser')\n",
    "name = soup.find_all('h1', class_='ds-text-title-l ds-font-bold')\n",
    "team = soup.find_all('span', class_='ds-text-comfortable-s')\n",
    "h5 = soup.find_all('h5')\n",
    "print('Player name -', name[0].get_text(strip=True) if name[0] else None)\n",
    "print('Player team -', team[0].get_text(strip=True) if team[0] else None)\n",
    "print('Batting style -', h5[3].get_text(strip=True) if h5[3] else None)\n",
    "print('Bowling style -', h5[4].get_text(strip=True) if h5[4] else None)\n",
    "print('Player role -', h5[5].get_text(strip=True) if h5[5] else None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Finn Allen</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>None</td>\n",
       "      <td>Top order Batter</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            0            1               2     3                 4\n",
       "0  Finn Allen  New Zealand  Right hand Bat  None  Top order Batter"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame()\n",
    "response = requests.get('https://www.espncricinfo.com/player/finn-allen-959759')\n",
    "soup = BeautifulSoup(response.content, 'html.parser')\n",
    "name = soup.find_all('h1', class_='ds-text-title-l ds-font-bold')\n",
    "team = soup.find_all('span', class_='ds-text-comfortable-s')\n",
    "divs = soup.find_all('div', class_= 'ds-grid lg:ds-grid-cols-3 ds-grid-cols-2 ds-gap-4 ds-mb-8')\n",
    "dict = {}\n",
    "dict['name'] = name[0].text\n",
    "dict['team'] = team[0].text\n",
    "for div in divs:\n",
    "    paras = div.find_all('p')\n",
    "    headers = div.find_all('h5')\n",
    "    for p, h in zip(paras, headers):\n",
    "        dict[p.text] = h.text\n",
    "    try:\n",
    "        bat = dict['Batting Style']\n",
    "    except:\n",
    "        bat = None\n",
    "    try:\n",
    "        bowl = dict['Bowling Style']\n",
    "    except:\n",
    "        bowl = None\n",
    "    try:\n",
    "        role = dict['Playing Role']\n",
    "    except:\n",
    "        role = None\n",
    "    temp = [[dict['name'], dict['team'], bat, bowl, role]]\n",
    "    df1 = pd.DataFrame(temp, index=[0])\n",
    "    df = pd.concat([df, df1], ignore_index=True, axis=0 )\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Jan Frylinck</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Left arm Fast medium</td>\n",
       "      <td>Allrounder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Michael van Lingen</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Left arm Medium</td>\n",
       "      <td>Bowling Allrounder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Divan la Cock</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Legbreak</td>\n",
       "      <td>Opening Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Jan Nicol Loftie-Eaton</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Right arm Medium, Legbreak</td>\n",
       "      <td>Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Stephan Baard</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Medium fast</td>\n",
       "      <td>Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>Heinrich Klaasen</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Offbreak</td>\n",
       "      <td>Wicketkeeper Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>Nasum Ahmed</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Slow Left arm Orthodox</td>\n",
       "      <td>Bowler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>Ebadot Hossain</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>Right hand Bat</td>\n",
       "      <td>Right arm Fast medium</td>\n",
       "      <td>Bowler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>Rishabh Pant</td>\n",
       "      <td>India</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>None</td>\n",
       "      <td>Wicketkeeper Batter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>Wellington Masakadza</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Left hand Bat</td>\n",
       "      <td>Slow Left arm Orthodox</td>\n",
       "      <td>Bowler</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>245 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          0             1               2  \\\n",
       "0              Jan Frylinck       Namibia   Left hand Bat   \n",
       "1        Michael van Lingen       Namibia   Left hand Bat   \n",
       "2             Divan la Cock       Namibia  Right hand Bat   \n",
       "3    Jan Nicol Loftie-Eaton       Namibia   Left hand Bat   \n",
       "4             Stephan Baard       Namibia  Right hand Bat   \n",
       "..                      ...           ...             ...   \n",
       "240        Heinrich Klaasen  South Africa  Right hand Bat   \n",
       "241             Nasum Ahmed    Bangladesh   Left hand Bat   \n",
       "242          Ebadot Hossain    Bangladesh  Right hand Bat   \n",
       "243            Rishabh Pant         India   Left hand Bat   \n",
       "244    Wellington Masakadza      Zimbabwe   Left hand Bat   \n",
       "\n",
       "                              3                    4  \n",
       "0          Left arm Fast medium           Allrounder  \n",
       "1               Left arm Medium   Bowling Allrounder  \n",
       "2                      Legbreak       Opening Batter  \n",
       "3    Right arm Medium, Legbreak               Batter  \n",
       "4         Right arm Medium fast               Batter  \n",
       "..                          ...                  ...  \n",
       "240          Right arm Offbreak  Wicketkeeper Batter  \n",
       "241      Slow Left arm Orthodox               Bowler  \n",
       "242       Right arm Fast medium               Bowler  \n",
       "243                        None  Wicketkeeper Batter  \n",
       "244      Slow Left arm Orthodox               Bowler  \n",
       "\n",
       "[245 rows x 5 columns]"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame()\n",
    "for url in player_urls:\n",
    "    response = requests.get('https://www.espncricinfo.com'+ url)\n",
    "    soup = BeautifulSoup(response.content, 'html.parser')\n",
    "    name = soup.find_all('h1', class_='ds-text-title-l ds-font-bold')\n",
    "    team = soup.find_all('span', class_='ds-text-comfortable-s')\n",
    "    divs = soup.find_all('div', class_= 'ds-grid lg:ds-grid-cols-3 ds-grid-cols-2 ds-gap-4 ds-mb-8')\n",
    "    dict = {}\n",
    "    dict['name'] = name[0].text\n",
    "    dict['team'] = team[0].text\n",
    "    for div in divs:\n",
    "        paras = div.find_all('p')\n",
    "        headers = div.find_all('h5')\n",
    "        for p, h in zip(paras, headers):\n",
    "            dict[p.text] = h.text\n",
    "        try:\n",
    "            bat = dict['Batting Style']\n",
    "        except:\n",
    "            bat = None\n",
    "        try:\n",
    "            bowl = dict['Bowling Style']\n",
    "        except:\n",
    "            bowl = None\n",
    "        try:\n",
    "            role = dict['Playing Role']\n",
    "        except:\n",
    "            role = None\n",
    "        temp = [[dict['name'], dict['team'], bat, bowl, role]]\n",
    "    df1 = pd.DataFrame(temp, index=[0])\n",
    "    df = pd.concat([df, df1], ignore_index=True, axis=0)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "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.8.10 (tags/v3.8.10:3d8993a, May  3 2021, 11:48:03) [MSC v.1928 64 bit (AMD64)]"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "90a0f2c3a9f249079dbc8efbd290dbce1e1949696e8cdd244d7184cd10e2e446"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}