icc-cricket-api.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:58:59.779005Z",
     "start_time": "2020-02-06T15:58:59.755409Z"
    }
   },
   "outputs": [],
   "source": [
    "# https://cricketapi-icc.pulselive.com/fixtures?matchTypes=T20I%2CT20%2CTEST%2CODI%2CFIRST_CLASS%2CLIST_A&tournamentTypes=I%2CWI&teamTypes=m&matchStates=C&page=0&pageSize=10&sort=desc\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:00.654768Z",
     "start_time": "2020-02-06T15:58:59.782682Z"
    }
   },
   "outputs": [],
   "source": [
    "from datetime import date\n",
    "from datetime import timedelta\n",
    "from datetime import datetime\n",
    "import re\n",
    "import requests as req\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:00.672449Z",
     "start_time": "2020-02-06T15:59:00.660552Z"
    }
   },
   "outputs": [],
   "source": [
    "api_endpoints = {\n",
    "    1: 'https://cricketapi-icc.pulselive.com/fixtures',\n",
    "    2: 'https://cricketapi-icc.pulselive.com/fixtures?matchTypes=T20I',\n",
    "    3: 'https://cricketapi-icc.pulselive.com/fixtures?matchTypes=ODI',\n",
    "    4: 'https://cricketapi-icc.pulselive.com/fixtures?matchTypes=T20',\n",
    "    5: 'https://cricketapi-icc.pulselive.com/fixtures?tournamentId=2858',\n",
    "    6: 'https://cricketapi-icc.pulselive.com/teams/',\n",
    "    7: 'https://cricketapi-icc.pulselive.com/fixtures?matchTypes=LIST_A',\n",
    "    8: 'https://cricketapi-icc.pulselive.com/fixtures?matchTypes=TEST',\n",
    "    9: 'https://cricketapi-icc.pulselive.com/fixtures/8199/scoring',\n",
    "    10: 'https://cricketapi-icc.pulselive.com/fixtures/8199/uds/traj',\n",
    "    11: 'https://cricketapi-icc.pulselive.com/fixtures/8199/uds/',\n",
    "    12: 'https://cricketapi-icc.pulselive.com/fixtures?tournamentTypes=I',\n",
    "    13: 'https://cricketapi-icc.pulselive.com/fixtures?startDate=2020-02-20',\n",
    "    14: 'https://cricketapi-ecb.pulselive.com/players',\n",
    "    15: 'https://cricketapi-ecb.pulselive.com/fixtures?tournamentIds=3123&pageSize=300',\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:01.485206Z",
     "start_time": "2020-02-06T15:59:00.677519Z"
    }
   },
   "outputs": [],
   "source": [
    "url = \"https://cricketapi-icc.pulselive.com/fixtures/8199/uds/\"\n",
    "match = req.get(url).json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:01.504113Z",
     "start_time": "2020-02-06T15:59:01.489871Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "match_keys = \n",
      "['teams', 'match', 'description', 'battingOrder', 'isLimitedOvers', 'lastUpdated', 'overs']\n",
      "match_teams_keys = \n",
      "['id', 'team', 'players', 'wicketKeeper', 'captain']\n",
      "teams_players_keys = \n",
      "['id', 'fullName', 'shortName', 'nationality', 'dateOfBirth', 'rightArmedBowl', 'rightHandedBat']\n"
     ]
    }
   ],
   "source": [
    "match_keys = list(match.keys())\n",
    "match_teams_keys = list(match['teams'][0].keys())\n",
    "teams_players_keys = list(match['teams'][0]['players'][0].keys())\n",
    "print('match_keys = ', match_keys,\n",
    "      'match_teams_keys = ', match_teams_keys,\n",
    "      'teams_players_keys = ', teams_players_keys,\n",
    "      sep = '\\n'\n",
    "     )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:01.530861Z",
     "start_time": "2020-02-06T15:59:01.508485Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Description = Match 8\n",
      "Batting Order = \n",
      "[0, 1]\n",
      "Is Limited? True\n",
      "Last Updated = \n",
      "[1581004579722]\n",
      "Overs = 50\n"
     ]
    }
   ],
   "source": [
    "desc = match['description']\n",
    "batting_order = match['battingOrder']\n",
    "is_limited = match['isLimitedOvers']\n",
    "last_updated = match['lastUpdated']\n",
    "overs = match['overs']\n",
    "\n",
    "\n",
    "print(\"Description = \" + desc,\n",
    "      \"Batting Order = \", batting_order,\n",
    "      \"Is Limited? \" + str(is_limited),\n",
    "      \"Last Updated = \", last_updated,\n",
    "      \"Overs = \" + str(overs),\n",
    "     sep=\"\\n\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:01.616469Z",
     "start_time": "2020-02-06T15:59:01.532981Z"
    }
   },
   "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>id</th>\n",
       "      <th>team</th>\n",
       "      <th>players</th>\n",
       "      <th>wicketKeeper</th>\n",
       "      <th>captain</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>19680</td>\n",
       "      <td>{'id': 19, 'fullName': 'South Africa', 'shortN...</td>\n",
       "      <td>[{'id': 456, 'fullName': 'Hashim Amla', 'short...</td>\n",
       "      <td>{'id': 834, 'fullName': 'Quinton de Kock', 'sh...</td>\n",
       "      <td>{'id': 24, 'fullName': 'Faf du Plessis', 'shor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>19681</td>\n",
       "      <td>{'id': 14, 'fullName': 'India', 'shortName': '...</td>\n",
       "      <td>[{'id': 107, 'fullName': 'Rohit Sharma', 'shor...</td>\n",
       "      <td>{'id': 1, 'fullName': 'MS Dhoni', 'shortName':...</td>\n",
       "      <td>{'id': 164, 'fullName': 'Virat Kohli', 'shortN...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id                                               team  \\\n",
       "0  19680  {'id': 19, 'fullName': 'South Africa', 'shortN...   \n",
       "1  19681  {'id': 14, 'fullName': 'India', 'shortName': '...   \n",
       "\n",
       "                                             players  \\\n",
       "0  [{'id': 456, 'fullName': 'Hashim Amla', 'short...   \n",
       "1  [{'id': 107, 'fullName': 'Rohit Sharma', 'shor...   \n",
       "\n",
       "                                        wicketKeeper  \\\n",
       "0  {'id': 834, 'fullName': 'Quinton de Kock', 'sh...   \n",
       "1  {'id': 1, 'fullName': 'MS Dhoni', 'shortName':...   \n",
       "\n",
       "                                             captain  \n",
       "0  {'id': 24, 'fullName': 'Faf du Plessis', 'shor...  \n",
       "1  {'id': 164, 'fullName': 'Virat Kohli', 'shortN...  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match['teams'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:01.641371Z",
     "start_time": "2020-02-06T15:59:01.626417Z"
    }
   },
   "outputs": [],
   "source": [
    "south_africa = pd.DataFrame.from_dict(match['teams'][0]['team'], orient='index')\n",
    "india = pd.DataFrame.from_dict(match['teams'][1]['team'], orient='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:01.665853Z",
     "start_time": "2020-02-06T15:59:01.645813Z"
    }
   },
   "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>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>19</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fullName</th>\n",
       "      <td>South Africa</td>\n",
       "      <td>India</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>shortName</th>\n",
       "      <td>South Africa</td>\n",
       "      <td>India</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>abbreviation</th>\n",
       "      <td>SA</td>\n",
       "      <td>IND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>type</th>\n",
       "      <td>m</td>\n",
       "      <td>m</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>primaryColor</th>\n",
       "      <td>0B5425</td>\n",
       "      <td>0057AF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>secondaryColor</th>\n",
       "      <td>F5AB00</td>\n",
       "      <td>FF5500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           0       0\n",
       "id                        19      14\n",
       "fullName        South Africa   India\n",
       "shortName       South Africa   India\n",
       "abbreviation              SA     IND\n",
       "type                       m       m\n",
       "primaryColor          0B5425  0057AF\n",
       "secondaryColor        F5AB00  FF5500"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.concat([south_africa, india], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:01.689393Z",
     "start_time": "2020-02-06T15:59:01.668384Z"
    }
   },
   "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>id</th>\n",
       "      <th>name</th>\n",
       "      <th>tournamentId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>8199</td>\n",
       "      <td>ICC Cricket World Cup 2019-08</td>\n",
       "      <td>8191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</th>\n",
       "      <td>8199</td>\n",
       "      <td>ICC Cricket World Cup 2019-08</td>\n",
       "      <td>ICC Cricket World Cup 2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>provisional</th>\n",
       "      <td>8199</td>\n",
       "      <td>ICC Cricket World Cup 2019-08</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               id                           name                tournamentId\n",
       "id           8199  ICC Cricket World Cup 2019-08                        8191\n",
       "name         8199  ICC Cricket World Cup 2019-08  ICC Cricket World Cup 2019\n",
       "provisional  8199  ICC Cricket World Cup 2019-08                       False"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match['match'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:01.704390Z",
     "start_time": "2020-02-06T15:59:01.697201Z"
    }
   },
   "outputs": [],
   "source": [
    "south_africa_captain = pd.DataFrame.from_dict(match['teams'][0]['captain'], orient='index')\n",
    "india_captain = pd.DataFrame.from_dict(match['teams'][1]['captain'], orient='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:01.738522Z",
     "start_time": "2020-02-06T15:59:01.710539Z"
    }
   },
   "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>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>24</td>\n",
       "      <td>164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fullName</th>\n",
       "      <td>Faf du Plessis</td>\n",
       "      <td>Virat Kohli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>shortName</th>\n",
       "      <td>F du Plessis</td>\n",
       "      <td>V Kohli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nationality</th>\n",
       "      <td>South African</td>\n",
       "      <td>Indian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dateOfBirth</th>\n",
       "      <td>1984-07-13</td>\n",
       "      <td>1988-11-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>rightArmedBowl</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>rightHandedBat</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bowlingStyle</th>\n",
       "      <td>LEG_SPIN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             0            0\n",
       "id                          24          164\n",
       "fullName        Faf du Plessis  Virat Kohli\n",
       "shortName         F du Plessis      V Kohli\n",
       "nationality      South African       Indian\n",
       "dateOfBirth         1984-07-13   1988-11-05\n",
       "rightArmedBowl            True         True\n",
       "rightHandedBat            True         True\n",
       "bowlingStyle          LEG_SPIN          NaN"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.concat([south_africa_captain, india_captain], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:01.761301Z",
     "start_time": "2020-02-06T15:59:01.742898Z"
    }
   },
   "outputs": [],
   "source": [
    "south_africa_wk = pd.DataFrame.from_dict(match['teams'][0]['wicketKeeper'], orient='index')\n",
    "india_wk = pd.DataFrame.from_dict(match['teams'][1]['wicketKeeper'], orient='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:01.790407Z",
     "start_time": "2020-02-06T15:59:01.763659Z"
    }
   },
   "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>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>834</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fullName</th>\n",
       "      <td>Quinton de Kock</td>\n",
       "      <td>MS Dhoni</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>shortName</th>\n",
       "      <td>Q de Kock</td>\n",
       "      <td>MS Dhoni</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nationality</th>\n",
       "      <td>South African</td>\n",
       "      <td>Indian</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dateOfBirth</th>\n",
       "      <td>1992-12-17</td>\n",
       "      <td>1981-07-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>rightArmedBowl</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>rightHandedBat</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              0           0\n",
       "id                          834           1\n",
       "fullName        Quinton de Kock    MS Dhoni\n",
       "shortName             Q de Kock    MS Dhoni\n",
       "nationality       South African      Indian\n",
       "dateOfBirth          1992-12-17  1981-07-07\n",
       "rightArmedBowl            False        True\n",
       "rightHandedBat            False        True"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.concat([south_africa_wk, india_wk], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:01.844599Z",
     "start_time": "2020-02-06T15:59:01.793709Z"
    }
   },
   "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>id</th>\n",
       "      <th>fullName</th>\n",
       "      <th>shortName</th>\n",
       "      <th>nationality</th>\n",
       "      <th>dateOfBirth</th>\n",
       "      <th>rightArmedBowl</th>\n",
       "      <th>rightHandedBat</th>\n",
       "      <th>bowlingStyle</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>456</td>\n",
       "      <td>Hashim Amla</td>\n",
       "      <td>H Amla</td>\n",
       "      <td>South African</td>\n",
       "      <td>1983-03-31</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>834</td>\n",
       "      <td>Quinton de Kock</td>\n",
       "      <td>Q de Kock</td>\n",
       "      <td>South African</td>\n",
       "      <td>1992-12-17</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>24</td>\n",
       "      <td>Faf du Plessis</td>\n",
       "      <td>F du Plessis</td>\n",
       "      <td>South African</td>\n",
       "      <td>1984-07-13</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>LEG_SPIN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1277</td>\n",
       "      <td>Rassie van der Dussen</td>\n",
       "      <td>R van der Dussen</td>\n",
       "      <td>South African</td>\n",
       "      <td>1989-02-07</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>187</td>\n",
       "      <td>David Miller</td>\n",
       "      <td>D Miller</td>\n",
       "      <td>South African</td>\n",
       "      <td>1989-06-10</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>182</td>\n",
       "      <td>JP Duminy</td>\n",
       "      <td>JP Duminy</td>\n",
       "      <td>South African</td>\n",
       "      <td>1984-04-14</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1662</td>\n",
       "      <td>Andile Phehlukwayo</td>\n",
       "      <td>A Phehlukwayo</td>\n",
       "      <td>South African</td>\n",
       "      <td>1996-03-03</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>836</td>\n",
       "      <td>Chris Morris</td>\n",
       "      <td>C Morris</td>\n",
       "      <td>South African</td>\n",
       "      <td>1987-04-30</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>FAST_SEAM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1664</td>\n",
       "      <td>Kagiso Rabada</td>\n",
       "      <td>K Rabada</td>\n",
       "      <td>South African</td>\n",
       "      <td>1995-05-25</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>898</td>\n",
       "      <td>Imran Tahir</td>\n",
       "      <td>I Tahir</td>\n",
       "      <td>South African</td>\n",
       "      <td>1979-03-27</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3309</td>\n",
       "      <td>Tabraiz Shamsi</td>\n",
       "      <td>T Shamsi</td>\n",
       "      <td>South African</td>\n",
       "      <td>1990-02-18</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id               fullName         shortName    nationality dateOfBirth  \\\n",
       "0    456            Hashim Amla            H Amla  South African  1983-03-31   \n",
       "1    834        Quinton de Kock         Q de Kock  South African  1992-12-17   \n",
       "2     24         Faf du Plessis      F du Plessis  South African  1984-07-13   \n",
       "3   1277  Rassie van der Dussen  R van der Dussen  South African  1989-02-07   \n",
       "4    187           David Miller          D Miller  South African  1989-06-10   \n",
       "5    182              JP Duminy         JP Duminy  South African  1984-04-14   \n",
       "6   1662     Andile Phehlukwayo     A Phehlukwayo  South African  1996-03-03   \n",
       "7    836           Chris Morris          C Morris  South African  1987-04-30   \n",
       "8   1664          Kagiso Rabada          K Rabada  South African  1995-05-25   \n",
       "9    898            Imran Tahir           I Tahir  South African  1979-03-27   \n",
       "10  3309         Tabraiz Shamsi          T Shamsi  South African  1990-02-18   \n",
       "\n",
       "    rightArmedBowl  rightHandedBat bowlingStyle  \n",
       "0             True            True          NaN  \n",
       "1            False           False          NaN  \n",
       "2             True            True     LEG_SPIN  \n",
       "3            False            True          NaN  \n",
       "4            False           False          NaN  \n",
       "5            False           False          NaN  \n",
       "6            False           False          NaN  \n",
       "7             True            True    FAST_SEAM  \n",
       "8             True           False          NaN  \n",
       "9             True            True          NaN  \n",
       "10           False            True          NaN  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match['teams'][0]['players'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:01.881912Z",
     "start_time": "2020-02-06T15:59:01.846725Z"
    }
   },
   "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>id</th>\n",
       "      <th>fullName</th>\n",
       "      <th>shortName</th>\n",
       "      <th>nationality</th>\n",
       "      <th>dateOfBirth</th>\n",
       "      <th>rightArmedBowl</th>\n",
       "      <th>rightHandedBat</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>107</td>\n",
       "      <td>Rohit Sharma</td>\n",
       "      <td>R Sharma</td>\n",
       "      <td>Indian</td>\n",
       "      <td>1987-04-30</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>41</td>\n",
       "      <td>Shikhar Dhawan</td>\n",
       "      <td>S Dhawan</td>\n",
       "      <td>Indian</td>\n",
       "      <td>1985-12-05</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>164</td>\n",
       "      <td>Virat Kohli</td>\n",
       "      <td>V Kohli</td>\n",
       "      <td>Indian</td>\n",
       "      <td>1988-11-05</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1125</td>\n",
       "      <td>KL Rahul</td>\n",
       "      <td>KL Rahul</td>\n",
       "      <td>Indian</td>\n",
       "      <td>1992-04-18</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>297</td>\n",
       "      <td>Kedar Jadhav</td>\n",
       "      <td>K Jadhav</td>\n",
       "      <td>Indian</td>\n",
       "      <td>1985-03-26</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>MS Dhoni</td>\n",
       "      <td>MS Dhoni</td>\n",
       "      <td>Indian</td>\n",
       "      <td>1981-07-07</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2740</td>\n",
       "      <td>Hardik Pandya</td>\n",
       "      <td>H Pandya</td>\n",
       "      <td>Indian</td>\n",
       "      <td>1993-10-11</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>116</td>\n",
       "      <td>Bhuvneshwar Kumar</td>\n",
       "      <td>B Kumar</td>\n",
       "      <td>Indian</td>\n",
       "      <td>1990-12-05</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>261</td>\n",
       "      <td>Kuldeep Yadav</td>\n",
       "      <td>K Yadav</td>\n",
       "      <td>Indian</td>\n",
       "      <td>1994-12-14</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>111</td>\n",
       "      <td>Yuzvendra Chahal</td>\n",
       "      <td>Y Chahal</td>\n",
       "      <td>Indian</td>\n",
       "      <td>1990-07-23</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1124</td>\n",
       "      <td>Jasprit Bumrah</td>\n",
       "      <td>J Bumrah</td>\n",
       "      <td>Indian</td>\n",
       "      <td>1993-12-06</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id           fullName shortName nationality dateOfBirth  rightArmedBowl  \\\n",
       "0    107       Rohit Sharma  R Sharma      Indian  1987-04-30            True   \n",
       "1     41     Shikhar Dhawan  S Dhawan      Indian  1985-12-05           False   \n",
       "2    164        Virat Kohli   V Kohli      Indian  1988-11-05            True   \n",
       "3   1125           KL Rahul  KL Rahul      Indian  1992-04-18           False   \n",
       "4    297       Kedar Jadhav  K Jadhav      Indian  1985-03-26            True   \n",
       "5      1           MS Dhoni  MS Dhoni      Indian  1981-07-07            True   \n",
       "6   2740      Hardik Pandya  H Pandya      Indian  1993-10-11            True   \n",
       "7    116  Bhuvneshwar Kumar   B Kumar      Indian  1990-12-05            True   \n",
       "8    261      Kuldeep Yadav   K Yadav      Indian  1994-12-14           False   \n",
       "9    111   Yuzvendra Chahal  Y Chahal      Indian  1990-07-23            True   \n",
       "10  1124     Jasprit Bumrah  J Bumrah      Indian  1993-12-06            True   \n",
       "\n",
       "    rightHandedBat  \n",
       "0             True  \n",
       "1            False  \n",
       "2             True  \n",
       "3             True  \n",
       "4             True  \n",
       "5             True  \n",
       "6             True  \n",
       "7             True  \n",
       "8            False  \n",
       "9             True  \n",
       "10            True  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match['teams'][1]['players'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:01.900896Z",
     "start_time": "2020-02-06T15:59:01.884053Z"
    }
   },
   "outputs": [],
   "source": [
    "url = 'https://cricketapi-icc.pulselive.com/fixtures?matchTypes=ODI'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:02.188571Z",
     "start_time": "2020-02-06T15:59:01.909413Z"
    }
   },
   "outputs": [],
   "source": [
    "odi = req.get(url).json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:02.210662Z",
     "start_time": "2020-02-06T15:59:02.194535Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['timestamp',\n",
       " 'label',\n",
       " 'tournamentId',\n",
       " 'tournamentLabel',\n",
       " 'scheduleEntry',\n",
       " 'resultOnly',\n",
       " 'timestampMs',\n",
       " 'endTimestampMs',\n",
       " 'endTimestamp']"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(odi['content'][0].keys())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:02.323461Z",
     "start_time": "2020-02-06T15:59:02.217969Z"
    }
   },
   "outputs": [],
   "source": [
    "# today's matches\n",
    "today = str(date.today()).split('-')\n",
    "url = \"https://cricketapi-icc.pulselive.com/fixtures?startDate=\"+str(date.today())+\"&pageSize=300\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:02.638743Z",
     "start_time": "2020-02-06T15:59:02.328328Z"
    }
   },
   "outputs": [],
   "source": [
    "todays_fixtures = req.get(url).json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:04.155763Z",
     "start_time": "2020-02-06T15:59:02.643747Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://cricketapi-icc.pulselive.com/fixtures?startDate=2020-02-06&pageSize=300&numPage=1\n",
      "https://cricketapi-icc.pulselive.com/fixtures?startDate=2020-02-06&pageSize=300&numPage=2\n",
      "https://cricketapi-icc.pulselive.com/fixtures?startDate=2020-02-06&pageSize=300&numPage=3\n",
      "https://cricketapi-icc.pulselive.com/fixtures?startDate=2020-02-06&pageSize=300&numPage=4\n",
      "https://cricketapi-icc.pulselive.com/fixtures?startDate=2020-02-06&pageSize=300&numPage=5\n",
      "{'timestamp': '2020-02-11T09:00:00+0530', 'label': '136th  ODI', 'tournamentId': {'id': 19836, 'name': 'Womens Under 23 One Day Trophy 2019-20', 'provisional': False}, 'tournamentLabel': 'Womens Under 23 One Day Trophy 2019-20', 'scheduleEntry': {'matchId': {'id': 20048, 'name': 'Womens Under 23 One Day Trophy 2019-20-136', 'tournamentId': {'id': 19836, 'name': 'Womens Under 23 One Day Trophy 2019-20', 'provisional': False}}, 'description': '136th  ODI', 'matchDate': '2020-02-11T09:00:00+0530', 'matchType': 'LIST_A', 'matchState': 'U', 'venue': {'id': 629, 'fullName': 'Ravenshaw University Ground', 'shortName': 'Ravenshaw University Ground', 'city': 'Cuttack', 'country': 'India'}, 'team1': {'team': {'id': 809, 'fullName': 'Arunachal Pradesh', 'shortName': '', 'abbreviation': 'ARCA', 'primaryColor': 'FFFFFF', 'secondaryColor': 'FFFFFF'}}, 'team2': {'team': {'id': 811, 'fullName': 'Meghalaya', 'shortName': '', 'abbreviation': 'MECA', 'primaryColor': 'FFFFFF', 'secondaryColor': 'FFFFFF'}}, 'groupName': 'Plate'}, 'resultOnly': False, 'timestampMs': 1581391800000, 'endTimestampMs': 1581442200000, 'endTimestamp': '2020-02-11T23:00:00+0530'}\n"
     ]
    }
   ],
   "source": [
    "todays_fixtures['pageInfo']\n",
    "for i in range(todays_fixtures['pageInfo']['numPages']):\n",
    "    new_url = \"https://cricketapi-icc.pulselive.com/fixtures?startDate=\" + str(date.today()) + \"&pageSize=300&numPage=\" + str(i+1)\n",
    "    print(new_url)\n",
    "    todays_fixtures['content'].extend(req.get(new_url).json().pop('content'))\n",
    "print(todays_fixtures['content'][400])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:04.179489Z",
     "start_time": "2020-02-06T15:59:04.167770Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['timestamp',\n",
       " 'label',\n",
       " 'tournamentId',\n",
       " 'tournamentLabel',\n",
       " 'scheduleEntry',\n",
       " 'resultOnly',\n",
       " 'timestampMs',\n",
       " 'endTimestampMs',\n",
       " 'endTimestamp']"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(todays_fixtures['content'][0].keys())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:04.224176Z",
     "start_time": "2020-02-06T15:59:04.201836Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Timestamp = 2020-02-03T09:30:00+0530\n",
      "Label = 150th  MD\n",
      "tournament ID = \n",
      "{'id': 19407, 'name': 'Cooch Behar Trophy 2019-20', 'provisional': False}\n",
      "Tournament Label = Cooch Behar Trophy 2019-20\n",
      "Schedule Entry =\n",
      "{'matchId': {'id': 19963, 'name': 'Cooch Behar Trophy 2019-20-150', 'tournamentId': {'id': 19407, 'name': 'Cooch Behar Trophy 2019-20', 'provisional': False}}, 'description': '150th  MD', 'matchDate': '2020-02-03T09:30:00+0530', 'matchType': 'FIRST_CLASS', 'matchState': 'C', 'venue': {'id': 791, 'fullName': 'VCA KALAMNA', 'shortName': 'VCA KALAMNA', 'city': 'Nagpur', 'country': 'India'}, 'matchStatus': {'outcome': 'D', 'text': 'Match Drawn Vidarbha took first innings lead (Qualified)'}, 'team1': {'team': {'id': 213, 'fullName': 'Vidarbha', 'shortName': 'Vidarbha', 'abbreviation': 'VCA', 'type': 'm', 'primaryColor': 'FFFFFF', 'secondaryColor': 'FFFFFF'}, 'innings': [{'inningsNumber': 2, 'runs': 426, 'wkts': 7, 'ballsFaced': 804, 'maxBalls': 0, 'allOut': False, 'declared': False}]}, 'team2': {'team': {'id': 203, 'fullName': 'Mumbai', 'shortName': 'Mumbai', 'abbreviation': 'MCA', 'type': 'm', 'primaryColor': 'FFFFFF', 'secondaryColor': 'FFFFFF'}, 'innings': [{'inningsNumber': 1, 'runs': 258, 'wkts': 10, 'ballsFaced': 503, 'maxBalls': 0, 'allOut': True, 'declared': False}]}, 'groupName': ''}\n",
      "Result Only = False\n"
     ]
    }
   ],
   "source": [
    "ts = todays_fixtures['content'][0]['timestamp']\n",
    "label = todays_fixtures['content'][0]['label']\n",
    "tournament_id = todays_fixtures['content'][0]['tournamentId']\n",
    "tournament_label = todays_fixtures['content'][0]['tournamentLabel']\n",
    "schedule_entry = todays_fixtures['content'][0]['scheduleEntry']\n",
    "result_only = todays_fixtures['content'][0]['resultOnly']\n",
    "\n",
    "\n",
    "print(\"Timestamp = \" + ts, \n",
    "      \"Label = \" + label, \n",
    "      \"tournament ID = \", tournament_id, \n",
    "      \"Tournament Label = \" + tournament_label,\n",
    "      \"Schedule Entry =\", schedule_entry,\n",
    "      \"Result Only = \"+ str(result_only),\n",
    "      sep='\\n')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:04.251657Z",
     "start_time": "2020-02-06T15:59:04.230003Z"
    }
   },
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fullName</th>\n",
       "      <td>VCA KALAMNA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>shortName</th>\n",
       "      <td>VCA KALAMNA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city</th>\n",
       "      <td>Nagpur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>country</th>\n",
       "      <td>India</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     0\n",
       "id                 791\n",
       "fullName   VCA KALAMNA\n",
       "shortName  VCA KALAMNA\n",
       "city            Nagpur\n",
       "country          India"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(schedule_entry['venue'], orient='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:04.445030Z",
     "start_time": "2020-02-06T15:59:04.254002Z"
    }
   },
   "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>timestamp</th>\n",
       "      <th>label</th>\n",
       "      <th>tournamentId</th>\n",
       "      <th>tournamentLabel</th>\n",
       "      <th>scheduleEntry</th>\n",
       "      <th>resultOnly</th>\n",
       "      <th>timestampMs</th>\n",
       "      <th>endTimestampMs</th>\n",
       "      <th>endTimestamp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-02-03T09:30:00+0530</td>\n",
       "      <td>150th  MD</td>\n",
       "      <td>{'id': 19407, 'name': 'Cooch Behar Trophy 2019...</td>\n",
       "      <td>Cooch Behar Trophy 2019-20</td>\n",
       "      <td>{'matchId': {'id': 19963, 'name': 'Cooch Behar...</td>\n",
       "      <td>False</td>\n",
       "      <td>1580702400000</td>\n",
       "      <td>1581010200000</td>\n",
       "      <td>2020-02-06T23:00:00+0530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-02-03T09:30:00+0530</td>\n",
       "      <td>151st  MD</td>\n",
       "      <td>{'id': 19407, 'name': 'Cooch Behar Trophy 2019...</td>\n",
       "      <td>Cooch Behar Trophy 2019-20</td>\n",
       "      <td>{'matchId': {'id': 19964, 'name': 'Cooch Behar...</td>\n",
       "      <td>False</td>\n",
       "      <td>1580702400000</td>\n",
       "      <td>1581010200000</td>\n",
       "      <td>2020-02-06T23:00:00+0530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-02-04T08:45:00+0530</td>\n",
       "      <td>127th  MD</td>\n",
       "      <td>{'id': 19514, 'name': 'Ranji Trophy 2019-20', ...</td>\n",
       "      <td>Ranji Trophy 2019-20</td>\n",
       "      <td>{'matchId': {'id': 19988, 'name': 'Ranji Troph...</td>\n",
       "      <td>False</td>\n",
       "      <td>1580786100000</td>\n",
       "      <td>1581096600000</td>\n",
       "      <td>2020-02-07T23:00:00+0530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-02-04T08:45:00+0530</td>\n",
       "      <td>128th  MD</td>\n",
       "      <td>{'id': 19514, 'name': 'Ranji Trophy 2019-20', ...</td>\n",
       "      <td>Ranji Trophy 2019-20</td>\n",
       "      <td>{'matchId': {'id': 19989, 'name': 'Ranji Troph...</td>\n",
       "      <td>False</td>\n",
       "      <td>1580786100000</td>\n",
       "      <td>1581096600000</td>\n",
       "      <td>2020-02-07T23:00:00+0530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-02-04T08:45:00+0530</td>\n",
       "      <td>129th  MD</td>\n",
       "      <td>{'id': 19514, 'name': 'Ranji Trophy 2019-20', ...</td>\n",
       "      <td>Ranji Trophy 2019-20</td>\n",
       "      <td>{'matchId': {'id': 19990, 'name': 'Ranji Troph...</td>\n",
       "      <td>False</td>\n",
       "      <td>1580786100000</td>\n",
       "      <td>1581096600000</td>\n",
       "      <td>2020-02-07T23:00:00+0530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1795</th>\n",
       "      <td>2020-02-24T09:00:00+0530</td>\n",
       "      <td>58th  ODI</td>\n",
       "      <td>{'id': 20102, 'name': 'Womens Senior One Day T...</td>\n",
       "      <td>Womens Senior One Day Trophy 2019-20</td>\n",
       "      <td>{'matchId': {'id': 20203, 'name': 'Womens Seni...</td>\n",
       "      <td>False</td>\n",
       "      <td>1582515000000</td>\n",
       "      <td>1582565400000</td>\n",
       "      <td>2020-02-24T23:00:00+0530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1796</th>\n",
       "      <td>2020-02-24T09:00:00+0530</td>\n",
       "      <td>59th  ODI</td>\n",
       "      <td>{'id': 20102, 'name': 'Womens Senior One Day T...</td>\n",
       "      <td>Womens Senior One Day Trophy 2019-20</td>\n",
       "      <td>{'matchId': {'id': 20204, 'name': 'Womens Seni...</td>\n",
       "      <td>False</td>\n",
       "      <td>1582515000000</td>\n",
       "      <td>1582565400000</td>\n",
       "      <td>2020-02-24T23:00:00+0530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1797</th>\n",
       "      <td>2020-02-24T09:00:00+0530</td>\n",
       "      <td>60th  ODI</td>\n",
       "      <td>{'id': 20102, 'name': 'Womens Senior One Day T...</td>\n",
       "      <td>Womens Senior One Day Trophy 2019-20</td>\n",
       "      <td>{'matchId': {'id': 20205, 'name': 'Womens Seni...</td>\n",
       "      <td>False</td>\n",
       "      <td>1582515000000</td>\n",
       "      <td>1582565400000</td>\n",
       "      <td>2020-02-24T23:00:00+0530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1798</th>\n",
       "      <td>2020-02-24T09:00:00+0530</td>\n",
       "      <td>31st  ODI</td>\n",
       "      <td>{'id': 20127, 'name': 'Womens Under 19 One Day...</td>\n",
       "      <td>Womens Under 19 One Day Trophy 2019-20</td>\n",
       "      <td>{'matchId': {'id': 20206, 'name': 'Womens Unde...</td>\n",
       "      <td>False</td>\n",
       "      <td>1582515000000</td>\n",
       "      <td>1582565400000</td>\n",
       "      <td>2020-02-24T23:00:00+0530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1799</th>\n",
       "      <td>2020-02-24T09:00:00+0530</td>\n",
       "      <td>32nd  ODI</td>\n",
       "      <td>{'id': 20127, 'name': 'Womens Under 19 One Day...</td>\n",
       "      <td>Womens Under 19 One Day Trophy 2019-20</td>\n",
       "      <td>{'matchId': {'id': 20207, 'name': 'Womens Unde...</td>\n",
       "      <td>False</td>\n",
       "      <td>1582515000000</td>\n",
       "      <td>1582565400000</td>\n",
       "      <td>2020-02-24T23:00:00+0530</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1800 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     timestamp      label  \\\n",
       "0     2020-02-03T09:30:00+0530  150th  MD   \n",
       "1     2020-02-03T09:30:00+0530  151st  MD   \n",
       "2     2020-02-04T08:45:00+0530  127th  MD   \n",
       "3     2020-02-04T08:45:00+0530  128th  MD   \n",
       "4     2020-02-04T08:45:00+0530  129th  MD   \n",
       "...                        ...        ...   \n",
       "1795  2020-02-24T09:00:00+0530  58th  ODI   \n",
       "1796  2020-02-24T09:00:00+0530  59th  ODI   \n",
       "1797  2020-02-24T09:00:00+0530  60th  ODI   \n",
       "1798  2020-02-24T09:00:00+0530  31st  ODI   \n",
       "1799  2020-02-24T09:00:00+0530  32nd  ODI   \n",
       "\n",
       "                                           tournamentId  \\\n",
       "0     {'id': 19407, 'name': 'Cooch Behar Trophy 2019...   \n",
       "1     {'id': 19407, 'name': 'Cooch Behar Trophy 2019...   \n",
       "2     {'id': 19514, 'name': 'Ranji Trophy 2019-20', ...   \n",
       "3     {'id': 19514, 'name': 'Ranji Trophy 2019-20', ...   \n",
       "4     {'id': 19514, 'name': 'Ranji Trophy 2019-20', ...   \n",
       "...                                                 ...   \n",
       "1795  {'id': 20102, 'name': 'Womens Senior One Day T...   \n",
       "1796  {'id': 20102, 'name': 'Womens Senior One Day T...   \n",
       "1797  {'id': 20102, 'name': 'Womens Senior One Day T...   \n",
       "1798  {'id': 20127, 'name': 'Womens Under 19 One Day...   \n",
       "1799  {'id': 20127, 'name': 'Womens Under 19 One Day...   \n",
       "\n",
       "                             tournamentLabel  \\\n",
       "0                 Cooch Behar Trophy 2019-20   \n",
       "1                 Cooch Behar Trophy 2019-20   \n",
       "2                       Ranji Trophy 2019-20   \n",
       "3                       Ranji Trophy 2019-20   \n",
       "4                       Ranji Trophy 2019-20   \n",
       "...                                      ...   \n",
       "1795    Womens Senior One Day Trophy 2019-20   \n",
       "1796    Womens Senior One Day Trophy 2019-20   \n",
       "1797    Womens Senior One Day Trophy 2019-20   \n",
       "1798  Womens Under 19 One Day Trophy 2019-20   \n",
       "1799  Womens Under 19 One Day Trophy 2019-20   \n",
       "\n",
       "                                          scheduleEntry  resultOnly  \\\n",
       "0     {'matchId': {'id': 19963, 'name': 'Cooch Behar...       False   \n",
       "1     {'matchId': {'id': 19964, 'name': 'Cooch Behar...       False   \n",
       "2     {'matchId': {'id': 19988, 'name': 'Ranji Troph...       False   \n",
       "3     {'matchId': {'id': 19989, 'name': 'Ranji Troph...       False   \n",
       "4     {'matchId': {'id': 19990, 'name': 'Ranji Troph...       False   \n",
       "...                                                 ...         ...   \n",
       "1795  {'matchId': {'id': 20203, 'name': 'Womens Seni...       False   \n",
       "1796  {'matchId': {'id': 20204, 'name': 'Womens Seni...       False   \n",
       "1797  {'matchId': {'id': 20205, 'name': 'Womens Seni...       False   \n",
       "1798  {'matchId': {'id': 20206, 'name': 'Womens Unde...       False   \n",
       "1799  {'matchId': {'id': 20207, 'name': 'Womens Unde...       False   \n",
       "\n",
       "        timestampMs  endTimestampMs              endTimestamp  \n",
       "0     1580702400000   1581010200000  2020-02-06T23:00:00+0530  \n",
       "1     1580702400000   1581010200000  2020-02-06T23:00:00+0530  \n",
       "2     1580786100000   1581096600000  2020-02-07T23:00:00+0530  \n",
       "3     1580786100000   1581096600000  2020-02-07T23:00:00+0530  \n",
       "4     1580786100000   1581096600000  2020-02-07T23:00:00+0530  \n",
       "...             ...             ...                       ...  \n",
       "1795  1582515000000   1582565400000  2020-02-24T23:00:00+0530  \n",
       "1796  1582515000000   1582565400000  2020-02-24T23:00:00+0530  \n",
       "1797  1582515000000   1582565400000  2020-02-24T23:00:00+0530  \n",
       "1798  1582515000000   1582565400000  2020-02-24T23:00:00+0530  \n",
       "1799  1582515000000   1582565400000  2020-02-24T23:00:00+0530  \n",
       "\n",
       "[1800 rows x 9 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(todays_fixtures['content'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:04.463858Z",
     "start_time": "2020-02-06T15:59:04.447959Z"
    }
   },
   "outputs": [],
   "source": [
    "# Next 7 Days ODI, Men\n",
    "today = str(date.today())\n",
    "end_date = str(date.today() + timedelta(days=7))\n",
    "url = \"https://cricketapi-icc.pulselive.com/fixtures?matchTypes=ODI&teamTypes=m&startDate=\"+today+\"&endDate=\"+end_date+\"&pageSize=300\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:04.789513Z",
     "start_time": "2020-02-06T15:59:04.466561Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'timestamp': '2020-02-06T09:30:00+0600',\n",
       " 'label': 'Match 26',\n",
       " 'tournamentId': {'id': 21579,\n",
       "  'name': 'triseries-nep-2020',\n",
       "  'provisional': False},\n",
       " 'tournamentLabel': 'ICC Cricket World Cup League 2',\n",
       " 'scheduleEntry': {'matchId': {'id': 21581,\n",
       "   'name': 'triseries-nep-2020-02',\n",
       "   'tournamentId': {'id': 21579,\n",
       "    'name': 'triseries-nep-2020',\n",
       "    'provisional': False}},\n",
       "  'description': 'Match 26',\n",
       "  'matchDate': '2020-02-06T09:30:00+0600',\n",
       "  'matchType': 'ODI',\n",
       "  'matchState': 'C',\n",
       "  'venue': {'id': 1010,\n",
       "   'fullName': 'Tribhuvan University International Cricket Ground',\n",
       "   'shortName': 'Tribhuvan University International Cricket Ground',\n",
       "   'city': 'Kirtipur',\n",
       "   'country': 'Nepal'},\n",
       "  'matchStatus': {'outcome': 'A', 'text': 'Oman win by 6 wickets'},\n",
       "  'team1': {'team': {'id': 128,\n",
       "    'fullName': 'Oman',\n",
       "    'shortName': 'Oman',\n",
       "    'abbreviation': 'OMA',\n",
       "    'type': 'm',\n",
       "    'primaryColor': 'B30121',\n",
       "    'secondaryColor': '06B89F'},\n",
       "   'innings': [{'inningsNumber': 2,\n",
       "     'runs': 214,\n",
       "     'wkts': 4,\n",
       "     'ballsFaced': 297,\n",
       "     'maxBalls': 300,\n",
       "     'allOut': False,\n",
       "     'declared': False}]},\n",
       "  'team2': {'team': {'id': 572,\n",
       "    'fullName': 'United States of America',\n",
       "    'shortName': 'USA',\n",
       "    'abbreviation': 'USA',\n",
       "    'type': 'm',\n",
       "    'primaryColor': '0000FF',\n",
       "    'secondaryColor': 'FF0A0A'},\n",
       "   'innings': [{'inningsNumber': 1,\n",
       "     'runs': 213,\n",
       "     'wkts': 10,\n",
       "     'ballsFaced': 300,\n",
       "     'maxBalls': 300,\n",
       "     'allOut': True,\n",
       "     'declared': False}]},\n",
       "  'groupName': ''},\n",
       " 'resultOnly': False,\n",
       " 'timestampMs': 1580959800000,\n",
       " 'endTimestampMs': 1581009300000,\n",
       " 'endTimestamp': '2020-02-06T23:00:00+0545'}"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "next7_ifixtures_odi = req.get(url).json()\n",
    "next7_ifixtures_odi['content'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:04.816810Z",
     "start_time": "2020-02-06T15:59:04.795674Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['timestamp',\n",
       " 'label',\n",
       " 'tournamentId',\n",
       " 'tournamentLabel',\n",
       " 'scheduleEntry',\n",
       " 'resultOnly',\n",
       " 'timestampMs',\n",
       " 'endTimestampMs',\n",
       " 'endTimestamp']"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(next7_ifixtures_odi['content'][0].keys())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:04.862927Z",
     "start_time": "2020-02-06T15:59:04.821365Z"
    }
   },
   "outputs": [],
   "source": [
    "def filter_fixtures(fixtures):\n",
    "    team_1 = [i['scheduleEntry']['team1']['team']['fullName'] for i in fixtures['content']]\n",
    "    team_2 = [i['scheduleEntry']['team2']['team']['fullName'] for i in fixtures['content']]\n",
    "    city = [i['scheduleEntry']['venue']['city'] for i in fixtures['content']]\n",
    "    venue = [i['scheduleEntry']['venue']['shortName'] for i in fixtures['content']]\n",
    "    match_date = [i['scheduleEntry']['matchDate'].split('T')[0] for i in fixtures['content']]\n",
    "    match_time_local = [i['scheduleEntry']['matchDate'].split('T')[1] for i in fixtures['content']]\n",
    "    match_id = [i['scheduleEntry']['matchId']['id'] for i in fixtures['content']]\n",
    "    tournament_id = [i['tournamentId']['id'] for i in fixtures['content']]\n",
    "    begin_utc = [datetime.utcfromtimestamp(i['timestampMs']/1000).strftime('%H:%M') \n",
    "                 for i in fixtures['content']]\n",
    "    end_utc = [datetime.utcfromtimestamp(i['endTimestampMs']/1000).strftime('%H:%M') \n",
    "                 for i in fixtures['content']]\n",
    "    \n",
    "    df = pd.DataFrame.from_dict(fixtures['content'])\n",
    "    \n",
    "    df = df.assign(Match_ID=match_id,\n",
    "               Team_1=team_1, \n",
    "               Team_2=team_2, \n",
    "               City=city, \n",
    "               Venue=venue, \n",
    "               Match_Date=match_date, \n",
    "               Match_Time_Local=match_time_local,\n",
    "               Tournament_ID=tournament_id, \n",
    "               Begin_UTC=begin_utc, \n",
    "               End_UTC=end_utc)\n",
    "\n",
    "    df = df.drop(['resultOnly', 'timestamp', 'timestampMs', 'endTimestampMs'], axis=1)\n",
    "    df = df[['Match_Date', 'Match_ID', 'Team_1','Team_2','label','tournamentLabel', 'Tournament_ID', \n",
    "        'Venue','City', 'Begin_UTC', 'End_UTC', 'Match_Time_Local']]\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:04.939137Z",
     "start_time": "2020-02-06T15:59:04.866975Z"
    }
   },
   "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>Match_Date</th>\n",
       "      <th>Match_ID</th>\n",
       "      <th>Team_1</th>\n",
       "      <th>Team_2</th>\n",
       "      <th>label</th>\n",
       "      <th>tournamentLabel</th>\n",
       "      <th>Tournament_ID</th>\n",
       "      <th>Venue</th>\n",
       "      <th>City</th>\n",
       "      <th>Begin_UTC</th>\n",
       "      <th>End_UTC</th>\n",
       "      <th>Match_Time_Local</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-02-06</td>\n",
       "      <td>21581</td>\n",
       "      <td>Oman</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Match 26</td>\n",
       "      <td>ICC Cricket World Cup League 2</td>\n",
       "      <td>21579</td>\n",
       "      <td>Tribhuvan University International Cricket Ground</td>\n",
       "      <td>Kirtipur</td>\n",
       "      <td>03:30</td>\n",
       "      <td>17:15</td>\n",
       "      <td>09:30:00+0600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-02-07</td>\n",
       "      <td>15254</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>England</td>\n",
       "      <td>2nd ODI</td>\n",
       "      <td>South Africa v England 2019/20</td>\n",
       "      <td>15248</td>\n",
       "      <td>Kingsmead</td>\n",
       "      <td>Durban</td>\n",
       "      <td>11:00</td>\n",
       "      <td>21:00</td>\n",
       "      <td>13:00:00+0200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-02-08</td>\n",
       "      <td>15359</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>India</td>\n",
       "      <td>2nd ODI</td>\n",
       "      <td>New Zealand v India 2020</td>\n",
       "      <td>15352</td>\n",
       "      <td>Eden Park</td>\n",
       "      <td>Auckland</td>\n",
       "      <td>02:00</td>\n",
       "      <td>10:00</td>\n",
       "      <td>15:00:00+1300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-02-08</td>\n",
       "      <td>21582</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Match 27</td>\n",
       "      <td>ICC Cricket World Cup League 2</td>\n",
       "      <td>21579</td>\n",
       "      <td>Tribhuvan University International Cricket Ground</td>\n",
       "      <td>Kirtipur</td>\n",
       "      <td>03:45</td>\n",
       "      <td>17:15</td>\n",
       "      <td>09:30:00+0545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-02-09</td>\n",
       "      <td>21583</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>Oman</td>\n",
       "      <td>Match 28</td>\n",
       "      <td>ICC Cricket World Cup League 2</td>\n",
       "      <td>21579</td>\n",
       "      <td>Tribhuvan University International Cricket Ground</td>\n",
       "      <td>Kirtipur</td>\n",
       "      <td>03:45</td>\n",
       "      <td>17:15</td>\n",
       "      <td>09:30:00+0545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2020-02-09</td>\n",
       "      <td>15255</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>England</td>\n",
       "      <td>3rd ODI</td>\n",
       "      <td>South Africa v England 2019/20</td>\n",
       "      <td>15248</td>\n",
       "      <td>New Wanderers Stadium</td>\n",
       "      <td>Johannesburg</td>\n",
       "      <td>08:00</td>\n",
       "      <td>21:00</td>\n",
       "      <td>10:00:00+0200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2020-02-11</td>\n",
       "      <td>15360</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>India</td>\n",
       "      <td>3rd ODI</td>\n",
       "      <td>New Zealand v India 2020</td>\n",
       "      <td>15352</td>\n",
       "      <td>Bay Oval</td>\n",
       "      <td>Tauranga</td>\n",
       "      <td>02:00</td>\n",
       "      <td>10:00</td>\n",
       "      <td>15:00:00+1300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2020-02-11</td>\n",
       "      <td>21584</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Oman</td>\n",
       "      <td>Match 29</td>\n",
       "      <td>ICC Cricket World Cup League 2</td>\n",
       "      <td>21579</td>\n",
       "      <td>Tribhuvan University International Cricket Ground</td>\n",
       "      <td>Kirtipur</td>\n",
       "      <td>03:45</td>\n",
       "      <td>17:15</td>\n",
       "      <td>09:30:00+0545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2020-02-12</td>\n",
       "      <td>21585</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Match 30</td>\n",
       "      <td>ICC Cricket World Cup League 2</td>\n",
       "      <td>21579</td>\n",
       "      <td>Tribhuvan University International Cricket Ground</td>\n",
       "      <td>Kirtipur</td>\n",
       "      <td>03:45</td>\n",
       "      <td>17:15</td>\n",
       "      <td>09:30:00+0545</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Match_Date  Match_ID                    Team_1                    Team_2  \\\n",
       "0  2020-02-06     21581                      Oman  United States of America   \n",
       "1  2020-02-07     15254              South Africa                   England   \n",
       "2  2020-02-08     15359               New Zealand                     India   \n",
       "3  2020-02-08     21582                     Nepal  United States of America   \n",
       "4  2020-02-09     21583                     Nepal                      Oman   \n",
       "5  2020-02-09     15255              South Africa                   England   \n",
       "6  2020-02-11     15360               New Zealand                     India   \n",
       "7  2020-02-11     21584  United States of America                      Oman   \n",
       "8  2020-02-12     21585                     Nepal  United States of America   \n",
       "\n",
       "      label                 tournamentLabel  Tournament_ID  \\\n",
       "0  Match 26  ICC Cricket World Cup League 2          21579   \n",
       "1   2nd ODI  South Africa v England 2019/20          15248   \n",
       "2   2nd ODI        New Zealand v India 2020          15352   \n",
       "3  Match 27  ICC Cricket World Cup League 2          21579   \n",
       "4  Match 28  ICC Cricket World Cup League 2          21579   \n",
       "5   3rd ODI  South Africa v England 2019/20          15248   \n",
       "6   3rd ODI        New Zealand v India 2020          15352   \n",
       "7  Match 29  ICC Cricket World Cup League 2          21579   \n",
       "8  Match 30  ICC Cricket World Cup League 2          21579   \n",
       "\n",
       "                                               Venue          City Begin_UTC  \\\n",
       "0  Tribhuvan University International Cricket Ground      Kirtipur     03:30   \n",
       "1                                          Kingsmead        Durban     11:00   \n",
       "2                                          Eden Park      Auckland     02:00   \n",
       "3  Tribhuvan University International Cricket Ground      Kirtipur     03:45   \n",
       "4  Tribhuvan University International Cricket Ground      Kirtipur     03:45   \n",
       "5                              New Wanderers Stadium  Johannesburg     08:00   \n",
       "6                                           Bay Oval      Tauranga     02:00   \n",
       "7  Tribhuvan University International Cricket Ground      Kirtipur     03:45   \n",
       "8  Tribhuvan University International Cricket Ground      Kirtipur     03:45   \n",
       "\n",
       "  End_UTC Match_Time_Local  \n",
       "0   17:15    09:30:00+0600  \n",
       "1   21:00    13:00:00+0200  \n",
       "2   10:00    15:00:00+1300  \n",
       "3   17:15    09:30:00+0545  \n",
       "4   17:15    09:30:00+0545  \n",
       "5   21:00    10:00:00+0200  \n",
       "6   10:00    15:00:00+1300  \n",
       "7   17:15    09:30:00+0545  \n",
       "8   17:15    09:30:00+0545  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filter_fixtures(next7_ifixtures_odi)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:05.208004Z",
     "start_time": "2020-02-06T15:59:04.941270Z"
    }
   },
   "outputs": [],
   "source": [
    "# Next 7 Days T20I, Men\n",
    "url = \"https://cricketapi-icc.pulselive.com/fixtures?matchTypes=T20I&teamTypes=m&startDate=\"+today+\"&endDate=\"+end_date+\"&pageSize=300\"\n",
    "next7_ifixtures_t20i = req.get(url).json()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:05.272452Z",
     "start_time": "2020-02-06T15:59:05.212756Z"
    }
   },
   "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>Match_Date</th>\n",
       "      <th>Match_ID</th>\n",
       "      <th>Team_1</th>\n",
       "      <th>Team_2</th>\n",
       "      <th>label</th>\n",
       "      <th>tournamentLabel</th>\n",
       "      <th>Tournament_ID</th>\n",
       "      <th>Venue</th>\n",
       "      <th>City</th>\n",
       "      <th>Begin_UTC</th>\n",
       "      <th>End_UTC</th>\n",
       "      <th>Match_Time_Local</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-02-12</td>\n",
       "      <td>15256</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>England</td>\n",
       "      <td>1st T20I</td>\n",
       "      <td>South Africa v England 2019/20</td>\n",
       "      <td>15248</td>\n",
       "      <td>Buffalo Park</td>\n",
       "      <td>East London</td>\n",
       "      <td>16:00</td>\n",
       "      <td>21:00</td>\n",
       "      <td>18:00:00+0200</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Match_Date  Match_ID        Team_1   Team_2     label  \\\n",
       "0  2020-02-12     15256  South Africa  England  1st T20I   \n",
       "\n",
       "                  tournamentLabel  Tournament_ID         Venue         City  \\\n",
       "0  South Africa v England 2019/20          15248  Buffalo Park  East London   \n",
       "\n",
       "  Begin_UTC End_UTC Match_Time_Local  \n",
       "0     16:00   21:00    18:00:00+0200  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filter_fixtures(next7_ifixtures_t20i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:05.573635Z",
     "start_time": "2020-02-06T15:59:05.274806Z"
    }
   },
   "outputs": [],
   "source": [
    "# Year Fixtures, All Formats, Men\n",
    "url = \"https://cricketapi-icc.pulselive.com/fixtures?matchTypes=T20I,TEST,ODI&teamTypes=m&startDate=2020-01-01&endDate=2020-12-31&pageSize=300\"\n",
    "allyear_ifixtures = req.get(url).json()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:05.672862Z",
     "start_time": "2020-02-06T15:59:05.578542Z"
    }
   },
   "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>Match_Date</th>\n",
       "      <th>Match_ID</th>\n",
       "      <th>Team_1</th>\n",
       "      <th>Team_2</th>\n",
       "      <th>label</th>\n",
       "      <th>tournamentLabel</th>\n",
       "      <th>Tournament_ID</th>\n",
       "      <th>Venue</th>\n",
       "      <th>City</th>\n",
       "      <th>Begin_UTC</th>\n",
       "      <th>End_UTC</th>\n",
       "      <th>Match_Time_Local</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-03</td>\n",
       "      <td>11481</td>\n",
       "      <td>Australia</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>3rd Test</td>\n",
       "      <td>Australia v New Zealand 2019/20</td>\n",
       "      <td>11478</td>\n",
       "      <td>SCG</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>23:30</td>\n",
       "      <td>12:00</td>\n",
       "      <td>10:30:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-01-03</td>\n",
       "      <td>15250</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>England</td>\n",
       "      <td>2nd Test</td>\n",
       "      <td>South Africa v England 2019/20</td>\n",
       "      <td>15248</td>\n",
       "      <td>Newlands</td>\n",
       "      <td>Cape Town</td>\n",
       "      <td>08:30</td>\n",
       "      <td>21:00</td>\n",
       "      <td>10:30:00+0200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-01-05</td>\n",
       "      <td>21429</td>\n",
       "      <td>Oman</td>\n",
       "      <td>United Arab Emirates</td>\n",
       "      <td>Match 1</td>\n",
       "      <td>ICC Cricket World Cup League 2</td>\n",
       "      <td>21428</td>\n",
       "      <td>Al Amerat Cricket Ground</td>\n",
       "      <td>Al Amerat</td>\n",
       "      <td>06:00</td>\n",
       "      <td>19:00</td>\n",
       "      <td>10:00:00+0400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-01-05</td>\n",
       "      <td>18726</td>\n",
       "      <td>India</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>1st T20I</td>\n",
       "      <td>India v Sri Lanka 2020</td>\n",
       "      <td>18725</td>\n",
       "      <td>Barsapara Cricket Ground</td>\n",
       "      <td>Guwahati</td>\n",
       "      <td>13:30</td>\n",
       "      <td>17:30</td>\n",
       "      <td>19:00:00+0530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-01-06</td>\n",
       "      <td>21430</td>\n",
       "      <td>United Arab Emirates</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>Match 2</td>\n",
       "      <td>ICC Cricket World Cup League 2</td>\n",
       "      <td>21428</td>\n",
       "      <td>Al Amerat Cricket Ground</td>\n",
       "      <td>Al Amerat</td>\n",
       "      <td>06:00</td>\n",
       "      <td>19:00</td>\n",
       "      <td>10:00:00+0400</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>188</th>\n",
       "      <td>2020-11-06</td>\n",
       "      <td>10974</td>\n",
       "      <td>Australia</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>Super 12s Match 26</td>\n",
       "      <td>ICC Men's T20 World Cup 2020</td>\n",
       "      <td>10935</td>\n",
       "      <td>MCG</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>2020-11-07</td>\n",
       "      <td>10975</td>\n",
       "      <td>England</td>\n",
       "      <td>A2</td>\n",
       "      <td>Super 12s Match 27</td>\n",
       "      <td>ICC Men's T20 World Cup 2020</td>\n",
       "      <td>10935</td>\n",
       "      <td>Adelaide Oval</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>03:30</td>\n",
       "      <td>12:30</td>\n",
       "      <td>14:00:00+1030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>2020-11-07</td>\n",
       "      <td>10976</td>\n",
       "      <td>West Indies</td>\n",
       "      <td>A1</td>\n",
       "      <td>Super 12s Match 28</td>\n",
       "      <td>ICC Men's T20 World Cup 2020</td>\n",
       "      <td>10935</td>\n",
       "      <td>MCG</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>2020-11-08</td>\n",
       "      <td>10977</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>B1</td>\n",
       "      <td>Super 12s Match 29</td>\n",
       "      <td>ICC Men's T20 World Cup 2020</td>\n",
       "      <td>10935</td>\n",
       "      <td>SCG</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>03:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>14:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>2020-11-08</td>\n",
       "      <td>10978</td>\n",
       "      <td>India</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Super 12s Match 30</td>\n",
       "      <td>ICC Men's T20 World Cup 2020</td>\n",
       "      <td>10935</td>\n",
       "      <td>SCG</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>193 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Match_Date  Match_ID                Team_1                Team_2  \\\n",
       "0    2020-01-03     11481             Australia           New Zealand   \n",
       "1    2020-01-03     15250          South Africa               England   \n",
       "2    2020-01-05     21429                  Oman  United Arab Emirates   \n",
       "3    2020-01-05     18726                 India             Sri Lanka   \n",
       "4    2020-01-06     21430  United Arab Emirates               Namibia   \n",
       "..          ...       ...                   ...                   ...   \n",
       "188  2020-11-06     10974             Australia           New Zealand   \n",
       "189  2020-11-07     10975               England                    A2   \n",
       "190  2020-11-07     10976           West Indies                    A1   \n",
       "191  2020-11-08     10977          South Africa                    B1   \n",
       "192  2020-11-08     10978                 India           Afghanistan   \n",
       "\n",
       "                  label                  tournamentLabel  Tournament_ID  \\\n",
       "0              3rd Test  Australia v New Zealand 2019/20          11478   \n",
       "1              2nd Test   South Africa v England 2019/20          15248   \n",
       "2               Match 1   ICC Cricket World Cup League 2          21428   \n",
       "3              1st T20I           India v Sri Lanka 2020          18725   \n",
       "4               Match 2   ICC Cricket World Cup League 2          21428   \n",
       "..                  ...                              ...            ...   \n",
       "188  Super 12s Match 26     ICC Men's T20 World Cup 2020          10935   \n",
       "189  Super 12s Match 27     ICC Men's T20 World Cup 2020          10935   \n",
       "190  Super 12s Match 28     ICC Men's T20 World Cup 2020          10935   \n",
       "191  Super 12s Match 29     ICC Men's T20 World Cup 2020          10935   \n",
       "192  Super 12s Match 30     ICC Men's T20 World Cup 2020          10935   \n",
       "\n",
       "                        Venue       City Begin_UTC End_UTC Match_Time_Local  \n",
       "0                         SCG     Sydney     23:30   12:00    10:30:00+1100  \n",
       "1                    Newlands  Cape Town     08:30   21:00    10:30:00+0200  \n",
       "2    Al Amerat Cricket Ground  Al Amerat     06:00   19:00    10:00:00+0400  \n",
       "3    Barsapara Cricket Ground   Guwahati     13:30   17:30    19:00:00+0530  \n",
       "4    Al Amerat Cricket Ground  Al Amerat     06:00   19:00    10:00:00+0400  \n",
       "..                        ...        ...       ...     ...              ...  \n",
       "188                       MCG  Melbourne     08:00   12:00    19:00:00+1100  \n",
       "189             Adelaide Oval   Adelaide     03:30   12:30    14:00:00+1030  \n",
       "190                       MCG  Melbourne     08:00   12:00    19:00:00+1100  \n",
       "191                       SCG     Sydney     03:00   12:00    14:00:00+1100  \n",
       "192                       SCG     Sydney     08:00   12:00    19:00:00+1100  \n",
       "\n",
       "[193 rows x 12 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filter_fixtures(allyear_ifixtures)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:05.959829Z",
     "start_time": "2020-02-06T15:59:05.675077Z"
    }
   },
   "outputs": [],
   "source": [
    "# T20 World Cup 2020 Fixtureshttps://cricketapi-ecb.pulselive.com/fixtures?tournamentIds=3123&pageSize=300\n",
    "url = \"https://cricketapi-icc.pulselive.com/fixtures?matchTypes=T20I&tournamentIds=10935&pageSize=300\"\n",
    "t20_worldcup_ifixtures = req.get(url).json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:06.056133Z",
     "start_time": "2020-02-06T15:59:05.962694Z"
    }
   },
   "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>Match_Date</th>\n",
       "      <th>label</th>\n",
       "      <th>Team_1</th>\n",
       "      <th>Team_2</th>\n",
       "      <th>Begin_UTC</th>\n",
       "      <th>End_UTC</th>\n",
       "      <th>City</th>\n",
       "      <th>Venue</th>\n",
       "      <th>Match_Time_Local</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-10-18</td>\n",
       "      <td>Match 1</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>03:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Geelong</td>\n",
       "      <td>Simonds Stadium</td>\n",
       "      <td>14:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-10-18</td>\n",
       "      <td>Match 2</td>\n",
       "      <td>Papua New Guinea</td>\n",
       "      <td>Oman</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Geelong</td>\n",
       "      <td>Simonds Stadium</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-10-19</td>\n",
       "      <td>Match 3</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>03:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Hobart</td>\n",
       "      <td>Blundstone Arena</td>\n",
       "      <td>14:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-10-19</td>\n",
       "      <td>Match 4</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>Scotland</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Hobart</td>\n",
       "      <td>Blundstone Arena</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-10-20</td>\n",
       "      <td>Match 5</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>Oman</td>\n",
       "      <td>03:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Geelong</td>\n",
       "      <td>Simonds Stadium</td>\n",
       "      <td>14:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2020-10-20</td>\n",
       "      <td>Match 6</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Papua New Guinea</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Geelong</td>\n",
       "      <td>Simonds Stadium</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2020-10-21</td>\n",
       "      <td>Match 7</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>Scotland</td>\n",
       "      <td>03:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Hobart</td>\n",
       "      <td>Blundstone Arena</td>\n",
       "      <td>14:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2020-10-21</td>\n",
       "      <td>Match 8</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Hobart</td>\n",
       "      <td>Blundstone Arena</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2020-10-22</td>\n",
       "      <td>Match 9</td>\n",
       "      <td>Papua New Guinea</td>\n",
       "      <td>Ireland</td>\n",
       "      <td>03:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Geelong</td>\n",
       "      <td>Simonds Stadium</td>\n",
       "      <td>14:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2020-10-22</td>\n",
       "      <td>Match 10</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Oman</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Geelong</td>\n",
       "      <td>Simonds Stadium</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2020-10-23</td>\n",
       "      <td>Match 11</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>Namibia</td>\n",
       "      <td>03:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Hobart</td>\n",
       "      <td>Blundstone Arena</td>\n",
       "      <td>14:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2020-10-23</td>\n",
       "      <td>Match 12</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>Scotland</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Hobart</td>\n",
       "      <td>Blundstone Arena</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2020-10-24</td>\n",
       "      <td>Super 12s Match 1</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>SCG</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2020-10-24</td>\n",
       "      <td>Super 12s Match 2</td>\n",
       "      <td>India</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>11:00</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Perth</td>\n",
       "      <td>Perth Stadium</td>\n",
       "      <td>19:00:00+0800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2020-10-25</td>\n",
       "      <td>Super 12s Match 3</td>\n",
       "      <td>A1</td>\n",
       "      <td>B2</td>\n",
       "      <td>03:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Hobart</td>\n",
       "      <td>Blundstone Arena</td>\n",
       "      <td>14:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2020-10-25</td>\n",
       "      <td>Super 12s Match 4</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>West Indies</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>MCG</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2020-10-26</td>\n",
       "      <td>Super 12s Match 5</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>A2</td>\n",
       "      <td>06:00</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Perth</td>\n",
       "      <td>Perth Stadium</td>\n",
       "      <td>14:00:00+0800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2020-10-26</td>\n",
       "      <td>Super 12s Match 6</td>\n",
       "      <td>England</td>\n",
       "      <td>B1</td>\n",
       "      <td>11:00</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Perth</td>\n",
       "      <td>Perth Stadium</td>\n",
       "      <td>19:00:00+0800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2020-10-27</td>\n",
       "      <td>Super 12s Match 7</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>B2</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Hobart</td>\n",
       "      <td>Blundstone Arena</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2020-10-28</td>\n",
       "      <td>Super 12s Match 8</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>B1</td>\n",
       "      <td>06:00</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Perth</td>\n",
       "      <td>Perth Stadium</td>\n",
       "      <td>14:00:00+0800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2020-10-28</td>\n",
       "      <td>Super 12s Match 9</td>\n",
       "      <td>Australia</td>\n",
       "      <td>West Indies</td>\n",
       "      <td>11:00</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Perth</td>\n",
       "      <td>Perth Stadium</td>\n",
       "      <td>19:00:00+0800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2020-10-29</td>\n",
       "      <td>Super 12s Match 10</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>A1</td>\n",
       "      <td>03:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>SCG</td>\n",
       "      <td>14:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2020-10-29</td>\n",
       "      <td>Super 12s Match 11</td>\n",
       "      <td>India</td>\n",
       "      <td>A2</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>MCG</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2020-10-30</td>\n",
       "      <td>Super 12s Match 12</td>\n",
       "      <td>England</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>SCG</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2020-10-30</td>\n",
       "      <td>Super 12s Match 13</td>\n",
       "      <td>West Indies</td>\n",
       "      <td>B2</td>\n",
       "      <td>11:00</td>\n",
       "      <td>15:00</td>\n",
       "      <td>Perth</td>\n",
       "      <td>Perth Stadium</td>\n",
       "      <td>19:00:00+0800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2020-10-31</td>\n",
       "      <td>Super 12s Match 14</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>04:00</td>\n",
       "      <td>13:00</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>Brisbane Cricket Ground</td>\n",
       "      <td>14:00:00+1000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2020-10-31</td>\n",
       "      <td>Super 12s Match 15</td>\n",
       "      <td>Australia</td>\n",
       "      <td>A1</td>\n",
       "      <td>09:00</td>\n",
       "      <td>13:00</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>Brisbane Cricket Ground</td>\n",
       "      <td>19:00:00+1000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2020-11-01</td>\n",
       "      <td>Super 12s Match 16</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>03:30</td>\n",
       "      <td>12:30</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>Adelaide Oval</td>\n",
       "      <td>14:00:00+1030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2020-11-01</td>\n",
       "      <td>Super 12s Match 17</td>\n",
       "      <td>India</td>\n",
       "      <td>England</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>MCG</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2020-11-02</td>\n",
       "      <td>Super 12s Match 18</td>\n",
       "      <td>A2</td>\n",
       "      <td>B1</td>\n",
       "      <td>03:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>SCG</td>\n",
       "      <td>14:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2020-11-02</td>\n",
       "      <td>Super 12s Match 19</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>A1</td>\n",
       "      <td>09:00</td>\n",
       "      <td>13:00</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>Brisbane Cricket Ground</td>\n",
       "      <td>19:00:00+1000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>Super 12s Match 20</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>West Indies</td>\n",
       "      <td>03:30</td>\n",
       "      <td>12:30</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>Adelaide Oval</td>\n",
       "      <td>14:00:00+1030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2020-11-03</td>\n",
       "      <td>Super 12s Match 21</td>\n",
       "      <td>Australia</td>\n",
       "      <td>B2</td>\n",
       "      <td>08:30</td>\n",
       "      <td>12:30</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>Adelaide Oval</td>\n",
       "      <td>19:00:00+1030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2020-11-04</td>\n",
       "      <td>Super 12s Match 22</td>\n",
       "      <td>England</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>09:00</td>\n",
       "      <td>13:00</td>\n",
       "      <td>Brisbane</td>\n",
       "      <td>Brisbane Cricket Ground</td>\n",
       "      <td>19:00:00+1000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2020-11-05</td>\n",
       "      <td>Super 12s Match 23</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>A2</td>\n",
       "      <td>03:30</td>\n",
       "      <td>12:30</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>Adelaide Oval</td>\n",
       "      <td>14:00:00+1030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2020-11-05</td>\n",
       "      <td>Super 12s Match 24</td>\n",
       "      <td>India</td>\n",
       "      <td>B1</td>\n",
       "      <td>08:30</td>\n",
       "      <td>12:30</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>Adelaide Oval</td>\n",
       "      <td>19:00:00+1030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2020-11-06</td>\n",
       "      <td>Super 12s Match 25</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>B2</td>\n",
       "      <td>03:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>MCG</td>\n",
       "      <td>14:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2020-11-06</td>\n",
       "      <td>Super 12s Match 26</td>\n",
       "      <td>Australia</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>MCG</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2020-11-07</td>\n",
       "      <td>Super 12s Match 27</td>\n",
       "      <td>England</td>\n",
       "      <td>A2</td>\n",
       "      <td>03:30</td>\n",
       "      <td>12:30</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>Adelaide Oval</td>\n",
       "      <td>14:00:00+1030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2020-11-07</td>\n",
       "      <td>Super 12s Match 28</td>\n",
       "      <td>West Indies</td>\n",
       "      <td>A1</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>MCG</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2020-11-08</td>\n",
       "      <td>Super 12s Match 29</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>B1</td>\n",
       "      <td>03:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>SCG</td>\n",
       "      <td>14:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>2020-11-08</td>\n",
       "      <td>Super 12s Match 30</td>\n",
       "      <td>India</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>SCG</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2020-11-11</td>\n",
       "      <td>Semi Final 1</td>\n",
       "      <td>TBC</td>\n",
       "      <td>TBC</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>SCG</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2020-11-12</td>\n",
       "      <td>Semi Final 2</td>\n",
       "      <td>TBC</td>\n",
       "      <td>TBC</td>\n",
       "      <td>08:30</td>\n",
       "      <td>12:30</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>Adelaide Oval</td>\n",
       "      <td>19:00:00+1030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2020-11-15</td>\n",
       "      <td>Final</td>\n",
       "      <td>TBC</td>\n",
       "      <td>TBC</td>\n",
       "      <td>08:00</td>\n",
       "      <td>12:00</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>MCG</td>\n",
       "      <td>19:00:00+1100</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Match_Date               label            Team_1            Team_2  \\\n",
       "0   2020-10-18             Match 1         Sri Lanka           Ireland   \n",
       "1   2020-10-18             Match 2  Papua New Guinea              Oman   \n",
       "2   2020-10-19             Match 3        Bangladesh           Namibia   \n",
       "3   2020-10-19             Match 4       Netherlands          Scotland   \n",
       "4   2020-10-20             Match 5           Ireland              Oman   \n",
       "5   2020-10-20             Match 6         Sri Lanka  Papua New Guinea   \n",
       "6   2020-10-21             Match 7           Namibia          Scotland   \n",
       "7   2020-10-21             Match 8        Bangladesh       Netherlands   \n",
       "8   2020-10-22             Match 9  Papua New Guinea           Ireland   \n",
       "9   2020-10-22            Match 10         Sri Lanka              Oman   \n",
       "10  2020-10-23            Match 11       Netherlands           Namibia   \n",
       "11  2020-10-23            Match 12        Bangladesh          Scotland   \n",
       "12  2020-10-24   Super 12s Match 1         Australia          Pakistan   \n",
       "13  2020-10-24   Super 12s Match 2             India      South Africa   \n",
       "14  2020-10-25   Super 12s Match 3                A1                B2   \n",
       "15  2020-10-25   Super 12s Match 4       New Zealand       West Indies   \n",
       "16  2020-10-26   Super 12s Match 5       Afghanistan                A2   \n",
       "17  2020-10-26   Super 12s Match 6           England                B1   \n",
       "18  2020-10-27   Super 12s Match 7       New Zealand                B2   \n",
       "19  2020-10-28   Super 12s Match 8       Afghanistan                B1   \n",
       "20  2020-10-28   Super 12s Match 9         Australia       West Indies   \n",
       "21  2020-10-29  Super 12s Match 10          Pakistan                A1   \n",
       "22  2020-10-29  Super 12s Match 11             India                A2   \n",
       "23  2020-10-30  Super 12s Match 12           England      South Africa   \n",
       "24  2020-10-30  Super 12s Match 13       West Indies                B2   \n",
       "25  2020-10-31  Super 12s Match 14          Pakistan       New Zealand   \n",
       "26  2020-10-31  Super 12s Match 15         Australia                A1   \n",
       "27  2020-11-01  Super 12s Match 16      South Africa       Afghanistan   \n",
       "28  2020-11-01  Super 12s Match 17             India           England   \n",
       "29  2020-11-02  Super 12s Match 18                A2                B1   \n",
       "30  2020-11-02  Super 12s Match 19       New Zealand                A1   \n",
       "31  2020-11-03  Super 12s Match 20          Pakistan       West Indies   \n",
       "32  2020-11-03  Super 12s Match 21         Australia                B2   \n",
       "33  2020-11-04  Super 12s Match 22           England       Afghanistan   \n",
       "34  2020-11-05  Super 12s Match 23      South Africa                A2   \n",
       "35  2020-11-05  Super 12s Match 24             India                B1   \n",
       "36  2020-11-06  Super 12s Match 25          Pakistan                B2   \n",
       "37  2020-11-06  Super 12s Match 26         Australia       New Zealand   \n",
       "38  2020-11-07  Super 12s Match 27           England                A2   \n",
       "39  2020-11-07  Super 12s Match 28       West Indies                A1   \n",
       "40  2020-11-08  Super 12s Match 29      South Africa                B1   \n",
       "41  2020-11-08  Super 12s Match 30             India       Afghanistan   \n",
       "42  2020-11-11        Semi Final 1               TBC               TBC   \n",
       "43  2020-11-12        Semi Final 2               TBC               TBC   \n",
       "44  2020-11-15               Final               TBC               TBC   \n",
       "\n",
       "   Begin_UTC End_UTC       City                    Venue Match_Time_Local  \n",
       "0      03:00   12:00    Geelong          Simonds Stadium    14:00:00+1100  \n",
       "1      08:00   12:00    Geelong          Simonds Stadium    19:00:00+1100  \n",
       "2      03:00   12:00     Hobart         Blundstone Arena    14:00:00+1100  \n",
       "3      08:00   12:00     Hobart         Blundstone Arena    19:00:00+1100  \n",
       "4      03:00   12:00    Geelong          Simonds Stadium    14:00:00+1100  \n",
       "5      08:00   12:00    Geelong          Simonds Stadium    19:00:00+1100  \n",
       "6      03:00   12:00     Hobart         Blundstone Arena    14:00:00+1100  \n",
       "7      08:00   12:00     Hobart         Blundstone Arena    19:00:00+1100  \n",
       "8      03:00   12:00    Geelong          Simonds Stadium    14:00:00+1100  \n",
       "9      08:00   12:00    Geelong          Simonds Stadium    19:00:00+1100  \n",
       "10     03:00   12:00     Hobart         Blundstone Arena    14:00:00+1100  \n",
       "11     08:00   12:00     Hobart         Blundstone Arena    19:00:00+1100  \n",
       "12     08:00   12:00     Sydney                      SCG    19:00:00+1100  \n",
       "13     11:00   15:00      Perth            Perth Stadium    19:00:00+0800  \n",
       "14     03:00   12:00     Hobart         Blundstone Arena    14:00:00+1100  \n",
       "15     08:00   12:00  Melbourne                      MCG    19:00:00+1100  \n",
       "16     06:00   15:00      Perth            Perth Stadium    14:00:00+0800  \n",
       "17     11:00   15:00      Perth            Perth Stadium    19:00:00+0800  \n",
       "18     08:00   12:00     Hobart         Blundstone Arena    19:00:00+1100  \n",
       "19     06:00   15:00      Perth            Perth Stadium    14:00:00+0800  \n",
       "20     11:00   15:00      Perth            Perth Stadium    19:00:00+0800  \n",
       "21     03:00   12:00     Sydney                      SCG    14:00:00+1100  \n",
       "22     08:00   12:00  Melbourne                      MCG    19:00:00+1100  \n",
       "23     08:00   12:00     Sydney                      SCG    19:00:00+1100  \n",
       "24     11:00   15:00      Perth            Perth Stadium    19:00:00+0800  \n",
       "25     04:00   13:00   Brisbane  Brisbane Cricket Ground    14:00:00+1000  \n",
       "26     09:00   13:00   Brisbane  Brisbane Cricket Ground    19:00:00+1000  \n",
       "27     03:30   12:30   Adelaide            Adelaide Oval    14:00:00+1030  \n",
       "28     08:00   12:00  Melbourne                      MCG    19:00:00+1100  \n",
       "29     03:00   12:00     Sydney                      SCG    14:00:00+1100  \n",
       "30     09:00   13:00   Brisbane  Brisbane Cricket Ground    19:00:00+1000  \n",
       "31     03:30   12:30   Adelaide            Adelaide Oval    14:00:00+1030  \n",
       "32     08:30   12:30   Adelaide            Adelaide Oval    19:00:00+1030  \n",
       "33     09:00   13:00   Brisbane  Brisbane Cricket Ground    19:00:00+1000  \n",
       "34     03:30   12:30   Adelaide            Adelaide Oval    14:00:00+1030  \n",
       "35     08:30   12:30   Adelaide            Adelaide Oval    19:00:00+1030  \n",
       "36     03:00   12:00  Melbourne                      MCG    14:00:00+1100  \n",
       "37     08:00   12:00  Melbourne                      MCG    19:00:00+1100  \n",
       "38     03:30   12:30   Adelaide            Adelaide Oval    14:00:00+1030  \n",
       "39     08:00   12:00  Melbourne                      MCG    19:00:00+1100  \n",
       "40     03:00   12:00     Sydney                      SCG    14:00:00+1100  \n",
       "41     08:00   12:00     Sydney                      SCG    19:00:00+1100  \n",
       "42     08:00   12:00     Sydney                      SCG    19:00:00+1100  \n",
       "43     08:30   12:30   Adelaide            Adelaide Oval    19:00:00+1030  \n",
       "44     08:00   12:00  Melbourne                      MCG    19:00:00+1100  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = filter_fixtures(t20_worldcup_ifixtures)\n",
    "df.drop(['tournamentLabel','Tournament_ID'], axis=1)\n",
    "df[['Match_Date', 'label', 'Team_1', 'Team_2', 'Begin_UTC', 'End_UTC', \n",
    "    'City', 'Venue', 'Match_Time_Local']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:06.332096Z",
     "start_time": "2020-02-06T15:59:06.057972Z"
    }
   },
   "outputs": [],
   "source": [
    "# Today's International Fixtures, Men's\n",
    "today = str(date.today())\n",
    "url = \"https://cricketapi-icc.pulselive.com/fixtures?matchTypes=T20I,TEST,ODI&teamTypes=m&startDate=\"+today+\"&endDate=\"+today+\"&pageSize=300\"\n",
    "todays_ifixtures = req.get(url).json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:06.381555Z",
     "start_time": "2020-02-06T15:59:06.335262Z"
    }
   },
   "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>Match_Date</th>\n",
       "      <th>Match_ID</th>\n",
       "      <th>Team_1</th>\n",
       "      <th>Team_2</th>\n",
       "      <th>label</th>\n",
       "      <th>tournamentLabel</th>\n",
       "      <th>Tournament_ID</th>\n",
       "      <th>Venue</th>\n",
       "      <th>City</th>\n",
       "      <th>Begin_UTC</th>\n",
       "      <th>End_UTC</th>\n",
       "      <th>Match_Time_Local</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-02-06</td>\n",
       "      <td>21581</td>\n",
       "      <td>Oman</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Match 26</td>\n",
       "      <td>ICC Cricket World Cup League 2</td>\n",
       "      <td>21579</td>\n",
       "      <td>Tribhuvan University International Cricket Ground</td>\n",
       "      <td>Kirtipur</td>\n",
       "      <td>03:30</td>\n",
       "      <td>17:15</td>\n",
       "      <td>09:30:00+0600</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Match_Date  Match_ID Team_1                    Team_2     label  \\\n",
       "0  2020-02-06     21581   Oman  United States of America  Match 26   \n",
       "\n",
       "                  tournamentLabel  Tournament_ID  \\\n",
       "0  ICC Cricket World Cup League 2          21579   \n",
       "\n",
       "                                               Venue      City Begin_UTC  \\\n",
       "0  Tribhuvan University International Cricket Ground  Kirtipur     03:30   \n",
       "\n",
       "  End_UTC Match_Time_Local  \n",
       "0   17:15    09:30:00+0600  "
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filter_fixtures(todays_ifixtures)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:06.657148Z",
     "start_time": "2020-02-06T15:59:06.385968Z"
    }
   },
   "outputs": [],
   "source": [
    "url = 'https://cricketapi-icc.pulselive.com/fixtures/8199/scoring'\n",
    "match_scorecard = req.get(url).json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:06.690018Z",
     "start_time": "2020-02-06T15:59:06.660888Z"
    }
   },
   "outputs": [],
   "source": [
    "def filter_innings(scorecard):\n",
    "    innings = [i for i in scorecard['innings']]\n",
    "    s = [i['scorecard'] for i in innings]\n",
    "    runs = [i['runs'] for i in s]\n",
    "    wkts = [i['wkts'] for i in s]\n",
    "    all_out = [i['allOut'] for i in s]\n",
    "    extras = [i['extras'] for i in s]\n",
    "    declared = [i['declared'] for i in innings]\n",
    "    over_progress = [i['overProgress'] for i in innings]\n",
    "    run_rate = [i['runRate'] for i in innings]\n",
    "    no_balls = [i['noBallRuns'] for i in extras]  \n",
    "    leg_byes = [i['legByeRuns'] for i in extras] \n",
    "    byes = [i['byeRuns'] for i in extras] \n",
    "    wides = [i['wideRuns'] for i in extras] \n",
    "    \n",
    "    df = pd.DataFrame([])\n",
    "    \n",
    "    df = df.assign(Runs=runs, \n",
    "                   Run_Rate=run_rate,\n",
    "                   Wickets=wkts, \n",
    "                   All_Out=all_out, \n",
    "                   No_Balls=no_balls, \n",
    "                   Leg_Byes=leg_byes, \n",
    "                   Byes=byes, \n",
    "                   Wides=wides, \n",
    "                   Declared=declared, \n",
    "                   Over_Progress=over_progress)\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:06.765952Z",
     "start_time": "2020-02-06T15:59:06.694810Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'inningsNumber': 1,\n",
       "  'runRate': '4.54',\n",
       "  'overProgress': '50',\n",
       "  'declared': False,\n",
       "  'scorecard': {'runs': 227,\n",
       "   'wkts': 9,\n",
       "   'allOut': False,\n",
       "   'battingStats': [{'playerId': 456,\n",
       "     'r': 6,\n",
       "     'b': 9,\n",
       "     'sr': '66.66',\n",
       "     '4s': 1,\n",
       "     '6s': 0,\n",
       "     'mod': {'dismissedBp': {'innings': 1, 'over': 4, 'ball': 2},\n",
       "      'countingBp': {'innings': 1, 'over': 4, 'ball': 2},\n",
       "      'text': 'c Rohit Sharma b Jasprit Bumrah',\n",
       "      'bowlerId': 1124,\n",
       "      'additionalPlayerIds': [107],\n",
       "      'dismissedMethod': 'ct',\n",
       "      'isOut': True}},\n",
       "    {'playerId': 834,\n",
       "     'r': 10,\n",
       "     'b': 17,\n",
       "     'sr': '58.82',\n",
       "     '4s': 1,\n",
       "     '6s': 0,\n",
       "     'mod': {'dismissedBp': {'innings': 1, 'over': 6, 'ball': 5},\n",
       "      'countingBp': {'innings': 1, 'over': 6, 'ball': 5},\n",
       "      'text': 'c Virat Kohli b Jasprit Bumrah',\n",
       "      'bowlerId': 1124,\n",
       "      'additionalPlayerIds': [164],\n",
       "      'dismissedMethod': 'ct',\n",
       "      'isOut': True}},\n",
       "    {'playerId': 24,\n",
       "     'r': 38,\n",
       "     'b': 54,\n",
       "     'sr': '70.37',\n",
       "     '4s': 4,\n",
       "     '6s': 0,\n",
       "     'mod': {'dismissedBp': {'innings': 1, 'over': 20, 'ball': 7},\n",
       "      'countingBp': {'innings': 1, 'over': 20, 'ball': 6},\n",
       "      'text': 'b Yuzvendra Chahal',\n",
       "      'bowlerId': 111,\n",
       "      'dismissedMethod': 'b',\n",
       "      'isOut': True}},\n",
       "    {'playerId': 1277,\n",
       "     'r': 22,\n",
       "     'b': 37,\n",
       "     'sr': '59.45',\n",
       "     '4s': 1,\n",
       "     '6s': 0,\n",
       "     'mod': {'dismissedBp': {'innings': 1, 'over': 20, 'ball': 1},\n",
       "      'countingBp': {'innings': 1, 'over': 20, 'ball': 1},\n",
       "      'text': 'b Yuzvendra Chahal',\n",
       "      'bowlerId': 111,\n",
       "      'dismissedMethod': 'b',\n",
       "      'isOut': True}},\n",
       "    {'playerId': 187,\n",
       "     'r': 31,\n",
       "     'b': 40,\n",
       "     'sr': '77.50',\n",
       "     '4s': 1,\n",
       "     '6s': 0,\n",
       "     'mod': {'dismissedBp': {'innings': 1, 'over': 36, 'ball': 3},\n",
       "      'countingBp': {'innings': 1, 'over': 36, 'ball': 3},\n",
       "      'text': 'c & b Yuzvendra Chahal',\n",
       "      'bowlerId': 111,\n",
       "      'additionalPlayerIds': [111],\n",
       "      'dismissedMethod': 'ct',\n",
       "      'isOut': True}},\n",
       "    {'playerId': 182,\n",
       "     'r': 3,\n",
       "     'b': 11,\n",
       "     'sr': '27.27',\n",
       "     '4s': 0,\n",
       "     '6s': 0,\n",
       "     'mod': {'dismissedBp': {'innings': 1, 'over': 23, 'ball': 6},\n",
       "      'countingBp': {'innings': 1, 'over': 23, 'ball': 6},\n",
       "      'text': 'lbw Kuldeep Yadav',\n",
       "      'bowlerId': 261,\n",
       "      'dismissedMethod': 'lbw',\n",
       "      'isOut': True}},\n",
       "    {'playerId': 1662,\n",
       "     'r': 34,\n",
       "     'b': 61,\n",
       "     'sr': '55.73',\n",
       "     '4s': 2,\n",
       "     '6s': 1,\n",
       "     'mod': {'dismissedBp': {'innings': 1, 'over': 40, 'ball': 3},\n",
       "      'countingBp': {'innings': 1, 'over': 40, 'ball': 3},\n",
       "      'text': 'st MS Dhoni b Yuzvendra Chahal',\n",
       "      'bowlerId': 111,\n",
       "      'additionalPlayerIds': [1],\n",
       "      'dismissedMethod': 'st',\n",
       "      'isOut': True}},\n",
       "    {'playerId': 836,\n",
       "     'r': 42,\n",
       "     'b': 34,\n",
       "     'sr': '123.52',\n",
       "     '4s': 1,\n",
       "     '6s': 2,\n",
       "     'mod': {'dismissedBp': {'innings': 1, 'over': 50, 'ball': 2},\n",
       "      'countingBp': {'innings': 1, 'over': 50, 'ball': 2},\n",
       "      'text': 'c Virat Kohli b Bhuvneshwar Kumar',\n",
       "      'bowlerId': 116,\n",
       "      'additionalPlayerIds': [164],\n",
       "      'dismissedMethod': 'ct',\n",
       "      'isOut': True}},\n",
       "    {'playerId': 1664, 'r': 31, 'b': 35, 'sr': '88.57', '4s': 2, '6s': 0},\n",
       "    {'playerId': 898,\n",
       "     'r': 0,\n",
       "     'b': 2,\n",
       "     'sr': '0.00',\n",
       "     '4s': 0,\n",
       "     '6s': 0,\n",
       "     'mod': {'dismissedBp': {'innings': 1, 'over': 50, 'ball': 6},\n",
       "      'countingBp': {'innings': 1, 'over': 50, 'ball': 6},\n",
       "      'text': 'c Kedar Jadhav b Bhuvneshwar Kumar',\n",
       "      'bowlerId': 116,\n",
       "      'additionalPlayerIds': [297],\n",
       "      'dismissedMethod': 'ct',\n",
       "      'isOut': True}}],\n",
       "   'bowlingStats': [{'playerId': 116,\n",
       "     'ov': '10',\n",
       "     'r': 44,\n",
       "     'w': 2,\n",
       "     'd': 33,\n",
       "     'maid': 0,\n",
       "     'e': '4.40',\n",
       "     'wd': 2,\n",
       "     'nb': 0},\n",
       "    {'playerId': 1124,\n",
       "     'ov': '10',\n",
       "     'r': 35,\n",
       "     'w': 2,\n",
       "     'd': 41,\n",
       "     'maid': 1,\n",
       "     'e': '3.50',\n",
       "     'wd': 0,\n",
       "     'nb': 0},\n",
       "    {'playerId': 2740,\n",
       "     'ov': '6',\n",
       "     'r': 31,\n",
       "     'w': 0,\n",
       "     'd': 16,\n",
       "     'maid': 0,\n",
       "     'e': '5.16',\n",
       "     'wd': 0,\n",
       "     'nb': 0},\n",
       "    {'playerId': 261,\n",
       "     'ov': '10',\n",
       "     'r': 46,\n",
       "     'w': 1,\n",
       "     'd': 28,\n",
       "     'maid': 0,\n",
       "     'e': '4.60',\n",
       "     'wd': 1,\n",
       "     'nb': 0},\n",
       "    {'playerId': 111,\n",
       "     'ov': '10',\n",
       "     'r': 51,\n",
       "     'w': 4,\n",
       "     'd': 32,\n",
       "     'maid': 0,\n",
       "     'e': '5.10',\n",
       "     'wd': 3,\n",
       "     'nb': 0},\n",
       "    {'playerId': 297,\n",
       "     'ov': '4',\n",
       "     'r': 16,\n",
       "     'w': 0,\n",
       "     'd': 13,\n",
       "     'maid': 0,\n",
       "     'e': '4.00',\n",
       "     'wd': 0,\n",
       "     'nb': 0}],\n",
       "   'fow': [{'bp': {'innings': 1, 'over': 4, 'ball': 2},\n",
       "     'playerId': 456,\n",
       "     'ret': False,\n",
       "     'w': 1,\n",
       "     'r': 11},\n",
       "    {'bp': {'innings': 1, 'over': 6, 'ball': 5},\n",
       "     'playerId': 834,\n",
       "     'ret': False,\n",
       "     'w': 2,\n",
       "     'r': 24},\n",
       "    {'bp': {'innings': 1, 'over': 20, 'ball': 1},\n",
       "     'playerId': 1277,\n",
       "     'ret': False,\n",
       "     'w': 3,\n",
       "     'r': 78},\n",
       "    {'bp': {'innings': 1, 'over': 20, 'ball': 6},\n",
       "     'playerId': 24,\n",
       "     'ret': False,\n",
       "     'w': 4,\n",
       "     'r': 80},\n",
       "    {'bp': {'innings': 1, 'over': 23, 'ball': 6},\n",
       "     'playerId': 182,\n",
       "     'ret': False,\n",
       "     'w': 5,\n",
       "     'r': 89},\n",
       "    {'bp': {'innings': 1, 'over': 36, 'ball': 3},\n",
       "     'playerId': 187,\n",
       "     'ret': False,\n",
       "     'w': 6,\n",
       "     'r': 135},\n",
       "    {'bp': {'innings': 1, 'over': 40, 'ball': 3},\n",
       "     'playerId': 1662,\n",
       "     'ret': False,\n",
       "     'w': 7,\n",
       "     'r': 158},\n",
       "    {'bp': {'innings': 1, 'over': 50, 'ball': 2},\n",
       "     'playerId': 836,\n",
       "     'ret': False,\n",
       "     'w': 8,\n",
       "     'r': 224},\n",
       "    {'bp': {'innings': 1, 'over': 50, 'ball': 6},\n",
       "     'playerId': 898,\n",
       "     'ret': False,\n",
       "     'w': 9,\n",
       "     'r': 227}],\n",
       "   'extras': {'noBallRuns': 0,\n",
       "    'wideRuns': 6,\n",
       "    'byeRuns': 1,\n",
       "    'legByeRuns': 3,\n",
       "    'penaltyRuns': 0},\n",
       "   'declared': False},\n",
       "  'overHistory': [{'ovNo': 1, 'ovBalls': ['1', '.', '.', '1', '.', '.']},\n",
       "   {'ovNo': 2, 'ovBalls': ['.', '.', '.', '2', '.', '.']},\n",
       "   {'ovNo': 3, 'ovBalls': ['4', '.', '1', '1', '.', '.']},\n",
       "   {'ovNo': 4, 'ovBalls': ['1B', 'W', '4', '.', '.', '.']},\n",
       "   {'ovNo': 5, 'ovBalls': ['4', '1', '2', '.', '.', '.']},\n",
       "   {'ovNo': 6, 'ovBalls': ['.', '.', '1', '1', 'W', '2']},\n",
       "   {'ovNo': 7, 'ovBalls': ['.', '.', '.', '.', '.', '4']},\n",
       "   {'ovNo': 8, 'ovBalls': ['1', '.', '.', '.', '.', '.']},\n",
       "   {'ovNo': 9, 'ovBalls': ['1', '.', '.', '.', '.', '.']},\n",
       "   {'ovNo': 10, 'ovBalls': ['.', '.', '.', '2', '.', '.']},\n",
       "   {'ovNo': 11, 'ovBalls': ['.', '1', '1', '1', '.', '.']},\n",
       "   {'ovNo': 12, 'ovBalls': ['1', '1', '1', '.', '.', '.']},\n",
       "   {'ovNo': 13, 'ovBalls': ['.', '2', '.', '1', '.', '.']},\n",
       "   {'ovNo': 14, 'ovBalls': ['.', '.', '.', '.', '1', '4']},\n",
       "   {'ovNo': 15, 'ovBalls': ['2', '.', '4', '1', '.', '1']},\n",
       "   {'ovNo': 16, 'ovBalls': ['1', '.', '2', '4', '1', '1']},\n",
       "   {'ovNo': 17, 'ovBalls': ['2', '1Lb', '.', '1', '.', '2']},\n",
       "   {'ovNo': 18, 'ovBalls': ['3', '.', '.', '.', '.', '1']},\n",
       "   {'ovNo': 19, 'ovBalls': ['.', '.', '1', '.', '1', '1']},\n",
       "   {'ovNo': 20, 'ovBalls': ['W', '.', '1Wd', '.', '1', '.', 'W']},\n",
       "   {'ovNo': 21, 'ovBalls': ['1', '1', '1', '.', '1', '1']},\n",
       "   {'ovNo': 22, 'ovBalls': ['1', '.', '.', '1', '.', '1']},\n",
       "   {'ovNo': 23, 'ovBalls': ['1', '.', '.', '.', '.', 'W']},\n",
       "   {'ovNo': 24, 'ovBalls': ['2', '1', '.', '4', '1', '1']},\n",
       "   {'ovNo': 25, 'ovBalls': ['1', '.', '1', '1', '1', '1']},\n",
       "   {'ovNo': 26, 'ovBalls': ['.', '1', '.', '.', '1', '.']},\n",
       "   {'ovNo': 27, 'ovBalls': ['.', '1', '1', '.', '.', '.']},\n",
       "   {'ovNo': 28, 'ovBalls': ['1', '.', '1', '.', '1', '2']},\n",
       "   {'ovNo': 29, 'ovBalls': ['1', '.', '.', '1', '4', '.']},\n",
       "   {'ovNo': 30, 'ovBalls': ['1', '.', '2', '1', '.', '1']},\n",
       "   {'ovNo': 31, 'ovBalls': ['.', '.', '.', '.', '.', '.']},\n",
       "   {'ovNo': 32, 'ovBalls': ['.', '.', '1', '.', '.', '.']},\n",
       "   {'ovNo': 33, 'ovBalls': ['.', '1', '1', '1', '.', '.']},\n",
       "   {'ovNo': 34, 'ovBalls': ['.', '1', '4', '.', '.', '.']},\n",
       "   {'ovNo': 35, 'ovBalls': ['1', '.', '.', '.', '1', '.']},\n",
       "   {'ovNo': 36, 'ovBalls': ['.', '1', 'W', '3', '.', '.']},\n",
       "   {'ovNo': 37, 'ovBalls': ['1', '.', '.', '.', '.', '1']},\n",
       "   {'ovNo': 38, 'ovBalls': ['2', '1Wd', '1', '.', '1', '.', '1Wd', '.']},\n",
       "   {'ovNo': 39, 'ovBalls': ['1', '6', '1', '1', '1', '1']},\n",
       "   {'ovNo': 40, 'ovBalls': ['1', '.', 'W', '1', '.', '2']},\n",
       "   {'ovNo': 41, 'ovBalls': ['.', '2', '.', '.', '1Wd', '.', '.']},\n",
       "   {'ovNo': 42, 'ovBalls': ['6', '1', '1', '1', '.', '.']},\n",
       "   {'ovNo': 43, 'ovBalls': ['.', '1', '1', '1', '2', '4']},\n",
       "   {'ovNo': 44, 'ovBalls': ['.', '.', '.', '6', '1', '1']},\n",
       "   {'ovNo': 45, 'ovBalls': ['.', '.', '.', '1Lb', '1', '.']},\n",
       "   {'ovNo': 46, 'ovBalls': ['1Wd', '1', '1Lb', '1', '1', '1Wd', '2', '.']},\n",
       "   {'ovNo': 47, 'ovBalls': ['1', '4', '1', '2', '.', '1']},\n",
       "   {'ovNo': 48, 'ovBalls': ['2', '1', '1', '2', '1', '2']},\n",
       "   {'ovNo': 49, 'ovBalls': ['.', '1', '.', '1', '4', '.']},\n",
       "   {'ovNo': 50, 'ovBalls': ['.', 'W', '2', '1', '.', 'W']}]},\n",
       " {'inningsNumber': 2,\n",
       "  'runRate': '4.84',\n",
       "  'overProgress': '47.3',\n",
       "  'declared': False,\n",
       "  'scorecard': {'runs': 230,\n",
       "   'wkts': 4,\n",
       "   'allOut': False,\n",
       "   'battingStats': [{'playerId': 41,\n",
       "     'r': 8,\n",
       "     'b': 12,\n",
       "     'sr': '66.66',\n",
       "     '4s': 1,\n",
       "     '6s': 0,\n",
       "     'mod': {'dismissedBp': {'innings': 2, 'over': 6, 'ball': 1},\n",
       "      'countingBp': {'innings': 2, 'over': 6, 'ball': 1},\n",
       "      'text': 'c Quinton de Kock b Kagiso Rabada',\n",
       "      'bowlerId': 1664,\n",
       "      'additionalPlayerIds': [834],\n",
       "      'dismissedMethod': 'ct',\n",
       "      'isOut': True}},\n",
       "    {'playerId': 107, 'r': 122, 'b': 144, 'sr': '84.72', '4s': 13, '6s': 2},\n",
       "    {'playerId': 164,\n",
       "     'r': 18,\n",
       "     'b': 34,\n",
       "     'sr': '52.94',\n",
       "     '4s': 1,\n",
       "     '6s': 0,\n",
       "     'mod': {'dismissedBp': {'innings': 2, 'over': 16, 'ball': 3},\n",
       "      'countingBp': {'innings': 2, 'over': 16, 'ball': 3},\n",
       "      'text': 'c Quinton de Kock b Andile Phehlukwayo',\n",
       "      'bowlerId': 1662,\n",
       "      'additionalPlayerIds': [834],\n",
       "      'dismissedMethod': 'ct',\n",
       "      'isOut': True}},\n",
       "    {'playerId': 1125,\n",
       "     'r': 26,\n",
       "     'b': 42,\n",
       "     'sr': '61.90',\n",
       "     '4s': 2,\n",
       "     '6s': 0,\n",
       "     'mod': {'dismissedBp': {'innings': 2, 'over': 32, 'ball': 3},\n",
       "      'countingBp': {'innings': 2, 'over': 32, 'ball': 3},\n",
       "      'text': 'c Faf du Plessis b Kagiso Rabada',\n",
       "      'bowlerId': 1664,\n",
       "      'additionalPlayerIds': [24],\n",
       "      'dismissedMethod': 'ct',\n",
       "      'isOut': True}},\n",
       "    {'playerId': 1,\n",
       "     'r': 34,\n",
       "     'b': 46,\n",
       "     'sr': '73.91',\n",
       "     '4s': 2,\n",
       "     '6s': 0,\n",
       "     'mod': {'dismissedBp': {'innings': 2, 'over': 47, 'ball': 1},\n",
       "      'countingBp': {'innings': 2, 'over': 47, 'ball': 1},\n",
       "      'text': 'c & b Chris Morris',\n",
       "      'bowlerId': 836,\n",
       "      'additionalPlayerIds': [836],\n",
       "      'dismissedMethod': 'ct',\n",
       "      'isOut': True}},\n",
       "    {'playerId': 2740, 'r': 15, 'b': 7, 'sr': '214.28', '4s': 3, '6s': 0}],\n",
       "   'bowlingStats': [{'playerId': 898,\n",
       "     'ov': '10',\n",
       "     'r': 58,\n",
       "     'w': 0,\n",
       "     'd': 20,\n",
       "     'maid': 0,\n",
       "     'e': '5.80',\n",
       "     'wd': 0,\n",
       "     'nb': 0},\n",
       "    {'playerId': 1664,\n",
       "     'ov': '10',\n",
       "     'r': 39,\n",
       "     'w': 2,\n",
       "     'd': 40,\n",
       "     'maid': 1,\n",
       "     'e': '3.90',\n",
       "     'wd': 1,\n",
       "     'nb': 0},\n",
       "    {'playerId': 836,\n",
       "     'ov': '10',\n",
       "     'r': 36,\n",
       "     'w': 1,\n",
       "     'd': 43,\n",
       "     'maid': 3,\n",
       "     'e': '3.60',\n",
       "     'wd': 1,\n",
       "     'nb': 0},\n",
       "    {'playerId': 1662,\n",
       "     'ov': '8.3',\n",
       "     'r': 40,\n",
       "     'w': 1,\n",
       "     'd': 30,\n",
       "     'maid': 0,\n",
       "     'e': '4.70',\n",
       "     'wd': 1,\n",
       "     'nb': 0},\n",
       "    {'playerId': 3309,\n",
       "     'ov': '9',\n",
       "     'r': 54,\n",
       "     'w': 0,\n",
       "     'd': 25,\n",
       "     'maid': 0,\n",
       "     'e': '6.00',\n",
       "     'wd': 1,\n",
       "     'nb': 0}],\n",
       "   'fow': [{'bp': {'innings': 2, 'over': 6, 'ball': 1},\n",
       "     'playerId': 41,\n",
       "     'ret': False,\n",
       "     'w': 1,\n",
       "     'r': 13},\n",
       "    {'bp': {'innings': 2, 'over': 16, 'ball': 3},\n",
       "     'playerId': 164,\n",
       "     'ret': False,\n",
       "     'w': 2,\n",
       "     'r': 54},\n",
       "    {'bp': {'innings': 2, 'over': 32, 'ball': 3},\n",
       "     'playerId': 1125,\n",
       "     'ret': False,\n",
       "     'w': 3,\n",
       "     'r': 139},\n",
       "    {'bp': {'innings': 2, 'over': 47, 'ball': 1},\n",
       "     'playerId': 1,\n",
       "     'ret': False,\n",
       "     'w': 4,\n",
       "     'r': 213}],\n",
       "   'extras': {'noBallRuns': 0,\n",
       "    'wideRuns': 4,\n",
       "    'byeRuns': 0,\n",
       "    'legByeRuns': 3,\n",
       "    'penaltyRuns': 0},\n",
       "   'declared': False},\n",
       "  'overHistory': [{'ovNo': 1, 'ovBalls': ['.', '.', '1', '1', '.', '1']},\n",
       "   {'ovNo': 2, 'ovBalls': ['.', '1', '.', '.', '.', '.']},\n",
       "   {'ovNo': 3, 'ovBalls': ['1', '.', '.', '1', '4', '.']},\n",
       "   {'ovNo': 4, 'ovBalls': ['.', '.', '.', '.', '1', '.']},\n",
       "   {'ovNo': 5, 'ovBalls': ['2', '.', '.', '.', '.', '.']},\n",
       "   {'ovNo': 6, 'ovBalls': ['W', '.', '.', '.', '1', '.']},\n",
       "   {'ovNo': 7, 'ovBalls': ['.', '.', '.', '.', '.', '.']},\n",
       "   {'ovNo': 8, 'ovBalls': ['.', '.', '6', '4', '.', '1Wd', '4']},\n",
       "   {'ovNo': 9, 'ovBalls': ['.', '.', '.', '.', '.', '2']},\n",
       "   {'ovNo': 10, 'ovBalls': ['1', '1', '.', '.', '.', '1']},\n",
       "   {'ovNo': 11, 'ovBalls': ['.', '.', '.', '1', '.', '1']},\n",
       "   {'ovNo': 12, 'ovBalls': ['1', '.', '.', '1', '.', '1']},\n",
       "   {'ovNo': 13, 'ovBalls': ['1', '1', '1', '1', '.', '1']},\n",
       "   {'ovNo': 14, 'ovBalls': ['1', '.', '1', '1', '.', '.']},\n",
       "   {'ovNo': 15, 'ovBalls': ['1', '.', '1', '.', '1', '.']},\n",
       "   {'ovNo': 16, 'ovBalls': ['.', '4', 'W', '.', '.', '.']},\n",
       "   {'ovNo': 17, 'ovBalls': ['4', '1', '1', '.', '1', '1']},\n",
       "   {'ovNo': 18, 'ovBalls': ['1', '.', '.', '.', '2', '.']},\n",
       "   {'ovNo': 19, 'ovBalls': ['.', '.', '1', '.', '2', '.']},\n",
       "   {'ovNo': 20, 'ovBalls': ['4', '.', '.', '1', '4', '1']},\n",
       "   {'ovNo': 21, 'ovBalls': ['.', '1Lb', '1', '1', '1', '.']},\n",
       "   {'ovNo': 22, 'ovBalls': ['.', '.', '.', '.', '.', '.']},\n",
       "   {'ovNo': 23, 'ovBalls': ['.', '6', '.', '.', '1', '2']},\n",
       "   {'ovNo': 24, 'ovBalls': ['.', '.', '.', '.', '.', '1Lb']},\n",
       "   {'ovNo': 25, 'ovBalls': ['.', '2', '.', '.', '.', '1']},\n",
       "   {'ovNo': 26, 'ovBalls': ['1Wd', '1', '.', '.', '.', '4', '1']},\n",
       "   {'ovNo': 27, 'ovBalls': ['1', '4', '1', '1', '4', '.']},\n",
       "   {'ovNo': 28, 'ovBalls': ['.', '1', '.', '1', '.', '.']},\n",
       "   {'ovNo': 29, 'ovBalls': ['1', '.', '.', '3', '4', '.']},\n",
       "   {'ovNo': 30, 'ovBalls': ['.', '1', '.', '4', '.', '1']},\n",
       "   {'ovNo': 31, 'ovBalls': ['4', '.', '1', '1', '2', '2']},\n",
       "   {'ovNo': 32, 'ovBalls': ['.', '.', 'W', '.', '.', '.']},\n",
       "   {'ovNo': 33, 'ovBalls': ['1', '1', '.', '2', '.', '.']},\n",
       "   {'ovNo': 34, 'ovBalls': ['.', '.', '.', '1Wd', '.', '1', '.']},\n",
       "   {'ovNo': 35, 'ovBalls': ['1', '1', '1', '1', '1', '.']},\n",
       "   {'ovNo': 36, 'ovBalls': ['1', '1', '.', '1', '1', '.']},\n",
       "   {'ovNo': 37, 'ovBalls': ['.', '.', '.', '.', '4', '.']},\n",
       "   {'ovNo': 38, 'ovBalls': ['1', '.', '.', '1', '.', '4']},\n",
       "   {'ovNo': 39, 'ovBalls': ['.', '1', '1', '.', '1', '1']},\n",
       "   {'ovNo': 40, 'ovBalls': ['.', '.', '.', '.', '2', '1']},\n",
       "   {'ovNo': 41, 'ovBalls': ['1', '.', '2', '1', '.', '1']},\n",
       "   {'ovNo': 42, 'ovBalls': ['2', '.', '.', '.', '1Lb', '.']},\n",
       "   {'ovNo': 43, 'ovBalls': ['.', '4', '1', '4', '3', '2']},\n",
       "   {'ovNo': 44, 'ovBalls': ['.', '.', '.', '4', '.', '1']},\n",
       "   {'ovNo': 45, 'ovBalls': ['2', '1', '1', '4', '1', '1']},\n",
       "   {'ovNo': 46, 'ovBalls': ['.', '2', '1', '.', '1', '1']},\n",
       "   {'ovNo': 47, 'ovBalls': ['W', '1', '.', '4', '4', '1']},\n",
       "   {'ovNo': 48, 'ovBalls': ['2', '.', '1Wd', '4']}]}]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "match_scorecard['innings']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:06.780732Z",
     "start_time": "2020-02-06T15:59:06.769087Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['inningsNumber',\n",
       " 'runRate',\n",
       " 'overProgress',\n",
       " 'declared',\n",
       " 'scorecard',\n",
       " 'overHistory']"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(match_scorecard['innings'][0].keys())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:06.792877Z",
     "start_time": "2020-02-06T15:59:06.782871Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['additionalInfo',\n",
       " 'teams',\n",
       " 'venue',\n",
       " 'matchDate',\n",
       " 'matchEndDate',\n",
       " 'matchDateMs',\n",
       " 'matchEndDateMs',\n",
       " 'isLimitedOvers',\n",
       " 'battingOrder',\n",
       " 'matchBroadcast',\n",
       " 'matchState',\n",
       " 'matchStatus',\n",
       " 'description',\n",
       " 'matchSummary',\n",
       " 'matchType',\n",
       " 'tournamentLabel',\n",
       " 'oversLimit',\n",
       " 'groupName']"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(match_scorecard['matchInfo'].keys())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:06.802599Z",
     "start_time": "2020-02-06T15:59:06.795356Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['id', 'name', 'tournamentId']"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(match_scorecard['matchId'].keys())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:06.814262Z",
     "start_time": "2020-02-06T15:59:06.805041Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['inProgress',\n",
       " 'phase',\n",
       " 'currentInningsIndex',\n",
       " 'currentBatsmen',\n",
       " 'facingBatsman',\n",
       " 'nonFacingBatsman',\n",
       " 'currentBowler',\n",
       " 'currentBowlerCurrentSpell',\n",
       " 'previousBowler',\n",
       " 'previousBowlerCurrentSpell',\n",
       " 'currentPartnership',\n",
       " 'partnership',\n",
       " 'recentOvers']"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(match_scorecard['currentState'].keys())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:06.851886Z",
     "start_time": "2020-02-06T15:59:06.816759Z"
    }
   },
   "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>Runs</th>\n",
       "      <th>Run_Rate</th>\n",
       "      <th>Wickets</th>\n",
       "      <th>All_Out</th>\n",
       "      <th>No_Balls</th>\n",
       "      <th>Leg_Byes</th>\n",
       "      <th>Byes</th>\n",
       "      <th>Wides</th>\n",
       "      <th>Declared</th>\n",
       "      <th>Over_Progress</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>227</td>\n",
       "      <td>4.54</td>\n",
       "      <td>9</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>230</td>\n",
       "      <td>4.84</td>\n",
       "      <td>4</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>False</td>\n",
       "      <td>47.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Runs Run_Rate  Wickets  All_Out  No_Balls  Leg_Byes  Byes  Wides  Declared  \\\n",
       "0   227     4.54        9    False         0         3     1      6     False   \n",
       "1   230     4.84        4    False         0         3     0      4     False   \n",
       "\n",
       "  Over_Progress  \n",
       "0            50  \n",
       "1          47.3  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# match_scorecard['innings'][0]\n",
    "# pd.DataFrame.from_dict(match_scorecard['innings'][0], orient='index')\n",
    "# pd.DataFrame.from_dict(match_scorecard['innings'][0]['scorecard'], orient='index')\n",
    "# dff = filter_innings(match_scorecard)\n",
    "# pd.DataFrame(match_scorecard['innings'])\n",
    "\n",
    "filter_innings(match_scorecard)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:06.936427Z",
     "start_time": "2020-02-06T15:59:06.854185Z"
    }
   },
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>inningsNumber</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>runRate</th>\n",
       "      <td>4.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>overProgress</th>\n",
       "      <td>47.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>declared</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>scorecard</th>\n",
       "      <td>{'runs': 230, 'wkts': 4, 'allOut': False, 'bat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>overHistory</th>\n",
       "      <td>[{'ovNo': 1, 'ovBalls': ['.', '.', '1', '1', '...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                               0\n",
       "inningsNumber                                                  2\n",
       "runRate                                                     4.84\n",
       "overProgress                                                47.3\n",
       "declared                                                   False\n",
       "scorecard      {'runs': 230, 'wkts': 4, 'allOut': False, 'bat...\n",
       "overHistory    [{'ovNo': 1, 'ovBalls': ['.', '.', '1', '1', '..."
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match_scorecard['innings'][1], orient='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:06.975522Z",
     "start_time": "2020-02-06T15:59:06.938847Z"
    }
   },
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>runs</th>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>balls</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>runRate</th>\n",
       "      <td>12.75</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             0\n",
       "runs        17\n",
       "balls        8\n",
       "runRate  12.75"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match_scorecard['currentState']['partnership'], orient='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:06.994132Z",
     "start_time": "2020-02-06T15:59:06.979737Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[107, 2740]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "match_scorecard['currentState']['currentBatsmen']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.013604Z",
     "start_time": "2020-02-06T15:59:06.997017Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2740"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "match_scorecard['currentState']['facingBatsman']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.036668Z",
     "start_time": "2020-02-06T15:59:07.015642Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "107"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "match_scorecard['currentState']['nonFacingBatsman']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.059658Z",
     "start_time": "2020-02-06T15:59:07.039704Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1662"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "match_scorecard['currentState']['currentBowler']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.105881Z",
     "start_time": "2020-02-06T15:59:07.062764Z"
    }
   },
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>playerId</th>\n",
       "      <td>1662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ov</th>\n",
       "      <td>0.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>r</th>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>w</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>d</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>maid</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>e</th>\n",
       "      <td>14.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>wd</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nb</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              0\n",
       "playerId   1662\n",
       "ov          0.3\n",
       "r             7\n",
       "w             0\n",
       "d             1\n",
       "maid          0\n",
       "e         14.00\n",
       "wd            1\n",
       "nb            0"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match_scorecard['currentState']['currentBowlerCurrentSpell'], orient='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.143240Z",
     "start_time": "2020-02-06T15:59:07.115340Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "836"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "match_scorecard['currentState']['previousBowler']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.171889Z",
     "start_time": "2020-02-06T15:59:07.150116Z"
    }
   },
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>playerId</th>\n",
       "      <td>836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ov</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>r</th>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>w</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>d</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>maid</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>e</th>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>wd</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>nb</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              0\n",
       "playerId    836\n",
       "ov            1\n",
       "r            10\n",
       "w             1\n",
       "d             2\n",
       "maid          0\n",
       "e         10.00\n",
       "wd            0\n",
       "nb            0"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match_scorecard['currentState']['previousBowlerCurrentSpell'], orient='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.207151Z",
     "start_time": "2020-02-06T15:59:07.178490Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "17"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "match_scorecard['currentState']['currentPartnership']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.246815Z",
     "start_time": "2020-02-06T15:59:07.209412Z"
    }
   },
   "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>ovNo</th>\n",
       "      <th>ovBalls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>43</td>\n",
       "      <td>[., 4, 1, 4, 3, 2]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>44</td>\n",
       "      <td>[., ., ., 4, ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>45</td>\n",
       "      <td>[2, 1, 1, 4, 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>46</td>\n",
       "      <td>[., 2, 1, ., 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>47</td>\n",
       "      <td>[W, 1, ., 4, 4, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>48</td>\n",
       "      <td>[2, ., 1Wd, 4]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   ovNo             ovBalls\n",
       "0    43  [., 4, 1, 4, 3, 2]\n",
       "1    44  [., ., ., 4, ., 1]\n",
       "2    45  [2, 1, 1, 4, 1, 1]\n",
       "3    46  [., 2, 1, ., 1, 1]\n",
       "4    47  [W, 1, ., 4, 4, 1]\n",
       "5    48      [2, ., 1Wd, 4]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(match_scorecard['currentState']['recentOvers'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.273833Z",
     "start_time": "2020-02-06T15:59:07.250162Z"
    }
   },
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>referee.name</th>\n",
       "      <td>Ranjan Madugalle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>toss.elected</th>\n",
       "      <td>South Africa, who chose to bat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>umpire.name.1</th>\n",
       "      <td>Richard Kettleborough</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>umpire.name.2</th>\n",
       "      <td>Michael Gough</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>toss.winner</th>\n",
       "      <td>South Africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>umpire.name.3</th>\n",
       "      <td>Richard Illingworth</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>umpire.name.4</th>\n",
       "      <td>Aleem Dar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>match.summary</th>\n",
       "      <td>India win by 6 wickets</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            0\n",
       "referee.name                 Ranjan Madugalle\n",
       "toss.elected   South Africa, who chose to bat\n",
       "umpire.name.1           Richard Kettleborough\n",
       "umpire.name.2                   Michael Gough\n",
       "toss.winner                      South Africa\n",
       "umpire.name.3             Richard Illingworth\n",
       "umpire.name.4                       Aleem Dar\n",
       "match.summary          India win by 6 wickets"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match_scorecard['matchInfo']['additionalInfo'], orient='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.307461Z",
     "start_time": "2020-02-06T15:59:07.280664Z"
    }
   },
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fullName</th>\n",
       "      <td>The Ageas Bowl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>shortName</th>\n",
       "      <td>The Ageas Bowl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city</th>\n",
       "      <td>Southampton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>country</th>\n",
       "      <td>England</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        0\n",
       "id                     72\n",
       "fullName   The Ageas Bowl\n",
       "shortName  The Ageas Bowl\n",
       "city          Southampton\n",
       "country           England"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match_scorecard['matchInfo']['venue'], orient='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.340057Z",
     "start_time": "2020-02-06T15:59:07.313000Z"
    }
   },
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>outcome</th>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>text</th>\n",
       "      <td>India win by 6 wickets</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              0\n",
       "outcome                       B\n",
       "text     India win by 6 wickets"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match_scorecard['matchInfo']['matchStatus'], orient='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.557706Z",
     "start_time": "2020-02-06T15:59:07.347845Z"
    }
   },
   "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>inningsNumber</th>\n",
       "      <th>runRate</th>\n",
       "      <th>overProgress</th>\n",
       "      <th>declared</th>\n",
       "      <th>scorecard</th>\n",
       "      <th>overHistory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>4.54</td>\n",
       "      <td>50</td>\n",
       "      <td>False</td>\n",
       "      <td>{'runs': 227, 'wkts': 9, 'allOut': False, 'bat...</td>\n",
       "      <td>[{'ovNo': 1, 'ovBalls': ['1', '.', '.', '1', '...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>4.84</td>\n",
       "      <td>47.3</td>\n",
       "      <td>False</td>\n",
       "      <td>{'runs': 230, 'wkts': 4, 'allOut': False, 'bat...</td>\n",
       "      <td>[{'ovNo': 1, 'ovBalls': ['.', '.', '1', '1', '...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   inningsNumber runRate overProgress  declared  \\\n",
       "0              1    4.54           50     False   \n",
       "1              2    4.84         47.3     False   \n",
       "\n",
       "                                           scorecard  \\\n",
       "0  {'runs': 227, 'wkts': 9, 'allOut': False, 'bat...   \n",
       "1  {'runs': 230, 'wkts': 4, 'allOut': False, 'bat...   \n",
       "\n",
       "                                         overHistory  \n",
       "0  [{'ovNo': 1, 'ovBalls': ['1', '.', '.', '1', '...  \n",
       "1  [{'ovNo': 1, 'ovBalls': ['.', '.', '1', '1', '...  "
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(match_scorecard['innings'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.640638Z",
     "start_time": "2020-02-06T15:59:07.561262Z"
    }
   },
   "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>ovNo</th>\n",
       "      <th>ovBalls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>[1, ., ., 1, ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>[., ., ., 2, ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>[4, ., 1, 1, ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>[1B, W, 4, ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>[4, 1, 2, ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>[., ., 1, 1, W, 2]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>[., ., ., ., ., 4]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>[1, ., ., ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>[1, ., ., ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>[., ., ., 2, ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>[., 1, 1, 1, ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>[1, 1, 1, ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>[., 2, ., 1, ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>[., ., ., ., 1, 4]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>[2, ., 4, 1, ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>[1, ., 2, 4, 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>[2, 1Lb, ., 1, ., 2]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>[3, ., ., ., ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>[., ., 1, ., 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>[W, ., 1Wd, ., 1, ., W]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>[1, 1, 1, ., 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>[1, ., ., 1, ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>[1, ., ., ., ., W]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>[2, 1, ., 4, 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>[1, ., 1, 1, 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>[., 1, ., ., 1, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>[., 1, 1, ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>[1, ., 1, ., 1, 2]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>[1, ., ., 1, 4, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>[1, ., 2, 1, ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>31</td>\n",
       "      <td>[., ., ., ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>32</td>\n",
       "      <td>[., ., 1, ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>33</td>\n",
       "      <td>[., 1, 1, 1, ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>34</td>\n",
       "      <td>[., 1, 4, ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>35</td>\n",
       "      <td>[1, ., ., ., 1, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>36</td>\n",
       "      <td>[., 1, W, 3, ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>37</td>\n",
       "      <td>[1, ., ., ., ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>38</td>\n",
       "      <td>[2, 1Wd, 1, ., 1, ., 1Wd, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>39</td>\n",
       "      <td>[1, 6, 1, 1, 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>40</td>\n",
       "      <td>[1, ., W, 1, ., 2]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>41</td>\n",
       "      <td>[., 2, ., ., 1Wd, ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>42</td>\n",
       "      <td>[6, 1, 1, 1, ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>43</td>\n",
       "      <td>[., 1, 1, 1, 2, 4]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>44</td>\n",
       "      <td>[., ., ., 6, 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>45</td>\n",
       "      <td>[., ., ., 1Lb, 1, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>46</td>\n",
       "      <td>[1Wd, 1, 1Lb, 1, 1, 1Wd, 2, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>47</td>\n",
       "      <td>[1, 4, 1, 2, ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>48</td>\n",
       "      <td>[2, 1, 1, 2, 1, 2]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>49</td>\n",
       "      <td>[., 1, ., 1, 4, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>50</td>\n",
       "      <td>[., W, 2, 1, ., W]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    ovNo                         ovBalls\n",
       "0      1              [1, ., ., 1, ., .]\n",
       "1      2              [., ., ., 2, ., .]\n",
       "2      3              [4, ., 1, 1, ., .]\n",
       "3      4             [1B, W, 4, ., ., .]\n",
       "4      5              [4, 1, 2, ., ., .]\n",
       "5      6              [., ., 1, 1, W, 2]\n",
       "6      7              [., ., ., ., ., 4]\n",
       "7      8              [1, ., ., ., ., .]\n",
       "8      9              [1, ., ., ., ., .]\n",
       "9     10              [., ., ., 2, ., .]\n",
       "10    11              [., 1, 1, 1, ., .]\n",
       "11    12              [1, 1, 1, ., ., .]\n",
       "12    13              [., 2, ., 1, ., .]\n",
       "13    14              [., ., ., ., 1, 4]\n",
       "14    15              [2, ., 4, 1, ., 1]\n",
       "15    16              [1, ., 2, 4, 1, 1]\n",
       "16    17            [2, 1Lb, ., 1, ., 2]\n",
       "17    18              [3, ., ., ., ., 1]\n",
       "18    19              [., ., 1, ., 1, 1]\n",
       "19    20         [W, ., 1Wd, ., 1, ., W]\n",
       "20    21              [1, 1, 1, ., 1, 1]\n",
       "21    22              [1, ., ., 1, ., 1]\n",
       "22    23              [1, ., ., ., ., W]\n",
       "23    24              [2, 1, ., 4, 1, 1]\n",
       "24    25              [1, ., 1, 1, 1, 1]\n",
       "25    26              [., 1, ., ., 1, .]\n",
       "26    27              [., 1, 1, ., ., .]\n",
       "27    28              [1, ., 1, ., 1, 2]\n",
       "28    29              [1, ., ., 1, 4, .]\n",
       "29    30              [1, ., 2, 1, ., 1]\n",
       "30    31              [., ., ., ., ., .]\n",
       "31    32              [., ., 1, ., ., .]\n",
       "32    33              [., 1, 1, 1, ., .]\n",
       "33    34              [., 1, 4, ., ., .]\n",
       "34    35              [1, ., ., ., 1, .]\n",
       "35    36              [., 1, W, 3, ., .]\n",
       "36    37              [1, ., ., ., ., 1]\n",
       "37    38    [2, 1Wd, 1, ., 1, ., 1Wd, .]\n",
       "38    39              [1, 6, 1, 1, 1, 1]\n",
       "39    40              [1, ., W, 1, ., 2]\n",
       "40    41         [., 2, ., ., 1Wd, ., .]\n",
       "41    42              [6, 1, 1, 1, ., .]\n",
       "42    43              [., 1, 1, 1, 2, 4]\n",
       "43    44              [., ., ., 6, 1, 1]\n",
       "44    45            [., ., ., 1Lb, 1, .]\n",
       "45    46  [1Wd, 1, 1Lb, 1, 1, 1Wd, 2, .]\n",
       "46    47              [1, 4, 1, 2, ., 1]\n",
       "47    48              [2, 1, 1, 2, 1, 2]\n",
       "48    49              [., 1, ., 1, 4, .]\n",
       "49    50              [., W, 2, 1, ., W]"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(match_scorecard['innings'][0]['overHistory'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.691797Z",
     "start_time": "2020-02-06T15:59:07.642891Z"
    }
   },
   "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>ovNo</th>\n",
       "      <th>ovBalls</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>[., ., 1, 1, ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>[., 1, ., ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>[1, ., ., 1, 4, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>[., ., ., ., 1, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>[2, ., ., ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>[W, ., ., ., 1, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>[., ., ., ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>[., ., 6, 4, ., 1Wd, 4]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>[., ., ., ., ., 2]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>[1, 1, ., ., ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>[., ., ., 1, ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>[1, ., ., 1, ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>[1, 1, 1, 1, ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>[1, ., 1, 1, ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>[1, ., 1, ., 1, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>[., 4, W, ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>[4, 1, 1, ., 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>[1, ., ., ., 2, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>[., ., 1, ., 2, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>[4, ., ., 1, 4, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>[., 1Lb, 1, 1, 1, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>[., ., ., ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>[., 6, ., ., 1, 2]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>[., ., ., ., ., 1Lb]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>[., 2, ., ., ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>[1Wd, 1, ., ., ., 4, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>[1, 4, 1, 1, 4, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>[., 1, ., 1, ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>[1, ., ., 3, 4, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>[., 1, ., 4, ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>31</td>\n",
       "      <td>[4, ., 1, 1, 2, 2]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>32</td>\n",
       "      <td>[., ., W, ., ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>33</td>\n",
       "      <td>[1, 1, ., 2, ., .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>34</td>\n",
       "      <td>[., ., ., 1Wd, ., 1, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>35</td>\n",
       "      <td>[1, 1, 1, 1, 1, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>36</td>\n",
       "      <td>[1, 1, ., 1, 1, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>37</td>\n",
       "      <td>[., ., ., ., 4, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>38</td>\n",
       "      <td>[1, ., ., 1, ., 4]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>39</td>\n",
       "      <td>[., 1, 1, ., 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>40</td>\n",
       "      <td>[., ., ., ., 2, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>41</td>\n",
       "      <td>[1, ., 2, 1, ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>42</td>\n",
       "      <td>[2, ., ., ., 1Lb, .]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>43</td>\n",
       "      <td>[., 4, 1, 4, 3, 2]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>44</td>\n",
       "      <td>[., ., ., 4, ., 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>45</td>\n",
       "      <td>[2, 1, 1, 4, 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>46</td>\n",
       "      <td>[., 2, 1, ., 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>47</td>\n",
       "      <td>[W, 1, ., 4, 4, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>48</td>\n",
       "      <td>[2, ., 1Wd, 4]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    ovNo                  ovBalls\n",
       "0      1       [., ., 1, 1, ., 1]\n",
       "1      2       [., 1, ., ., ., .]\n",
       "2      3       [1, ., ., 1, 4, .]\n",
       "3      4       [., ., ., ., 1, .]\n",
       "4      5       [2, ., ., ., ., .]\n",
       "5      6       [W, ., ., ., 1, .]\n",
       "6      7       [., ., ., ., ., .]\n",
       "7      8  [., ., 6, 4, ., 1Wd, 4]\n",
       "8      9       [., ., ., ., ., 2]\n",
       "9     10       [1, 1, ., ., ., 1]\n",
       "10    11       [., ., ., 1, ., 1]\n",
       "11    12       [1, ., ., 1, ., 1]\n",
       "12    13       [1, 1, 1, 1, ., 1]\n",
       "13    14       [1, ., 1, 1, ., .]\n",
       "14    15       [1, ., 1, ., 1, .]\n",
       "15    16       [., 4, W, ., ., .]\n",
       "16    17       [4, 1, 1, ., 1, 1]\n",
       "17    18       [1, ., ., ., 2, .]\n",
       "18    19       [., ., 1, ., 2, .]\n",
       "19    20       [4, ., ., 1, 4, 1]\n",
       "20    21     [., 1Lb, 1, 1, 1, .]\n",
       "21    22       [., ., ., ., ., .]\n",
       "22    23       [., 6, ., ., 1, 2]\n",
       "23    24     [., ., ., ., ., 1Lb]\n",
       "24    25       [., 2, ., ., ., 1]\n",
       "25    26  [1Wd, 1, ., ., ., 4, 1]\n",
       "26    27       [1, 4, 1, 1, 4, .]\n",
       "27    28       [., 1, ., 1, ., .]\n",
       "28    29       [1, ., ., 3, 4, .]\n",
       "29    30       [., 1, ., 4, ., 1]\n",
       "30    31       [4, ., 1, 1, 2, 2]\n",
       "31    32       [., ., W, ., ., .]\n",
       "32    33       [1, 1, ., 2, ., .]\n",
       "33    34  [., ., ., 1Wd, ., 1, .]\n",
       "34    35       [1, 1, 1, 1, 1, .]\n",
       "35    36       [1, 1, ., 1, 1, .]\n",
       "36    37       [., ., ., ., 4, .]\n",
       "37    38       [1, ., ., 1, ., 4]\n",
       "38    39       [., 1, 1, ., 1, 1]\n",
       "39    40       [., ., ., ., 2, 1]\n",
       "40    41       [1, ., 2, 1, ., 1]\n",
       "41    42     [2, ., ., ., 1Lb, .]\n",
       "42    43       [., 4, 1, 4, 3, 2]\n",
       "43    44       [., ., ., 4, ., 1]\n",
       "44    45       [2, 1, 1, 4, 1, 1]\n",
       "45    46       [., 2, 1, ., 1, 1]\n",
       "46    47       [W, 1, ., 4, 4, 1]\n",
       "47    48           [2, ., 1Wd, 4]"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(match_scorecard['innings'][1]['overHistory'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.712163Z",
     "start_time": "2020-02-06T15:59:07.697529Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['runs',\n",
       " 'wkts',\n",
       " 'allOut',\n",
       " 'battingStats',\n",
       " 'bowlingStats',\n",
       " 'fow',\n",
       " 'extras',\n",
       " 'declared']"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(match_scorecard['innings'][0]['scorecard'].keys())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.772885Z",
     "start_time": "2020-02-06T15:59:07.714329Z"
    }
   },
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>runs</th>\n",
       "      <td>227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>wkts</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>allOut</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>battingStats</th>\n",
       "      <td>[{'playerId': 456, 'r': 6, 'b': 9, 'sr': '66.6...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bowlingStats</th>\n",
       "      <td>[{'playerId': 116, 'ov': '10', 'r': 44, 'w': 2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fow</th>\n",
       "      <td>[{'bp': {'innings': 1, 'over': 4, 'ball': 2}, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>extras</th>\n",
       "      <td>{'noBallRuns': 0, 'wideRuns': 6, 'byeRuns': 1,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>declared</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                              0\n",
       "runs                                                        227\n",
       "wkts                                                          9\n",
       "allOut                                                    False\n",
       "battingStats  [{'playerId': 456, 'r': 6, 'b': 9, 'sr': '66.6...\n",
       "bowlingStats  [{'playerId': 116, 'ov': '10', 'r': 44, 'w': 2...\n",
       "fow           [{'bp': {'innings': 1, 'over': 4, 'ball': 2}, ...\n",
       "extras        {'noBallRuns': 0, 'wideRuns': 6, 'byeRuns': 1,...\n",
       "declared                                                  False"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match_scorecard['innings'][0]['scorecard'], orient='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.830741Z",
     "start_time": "2020-02-06T15:59:07.775317Z"
    }
   },
   "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>playerId</th>\n",
       "      <th>r</th>\n",
       "      <th>b</th>\n",
       "      <th>sr</th>\n",
       "      <th>4s</th>\n",
       "      <th>6s</th>\n",
       "      <th>mod</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>456</td>\n",
       "      <td>6</td>\n",
       "      <td>9</td>\n",
       "      <td>66.66</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>{'dismissedBp': {'innings': 1, 'over': 4, 'bal...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>834</td>\n",
       "      <td>10</td>\n",
       "      <td>17</td>\n",
       "      <td>58.82</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>{'dismissedBp': {'innings': 1, 'over': 6, 'bal...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>24</td>\n",
       "      <td>38</td>\n",
       "      <td>54</td>\n",
       "      <td>70.37</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>{'dismissedBp': {'innings': 1, 'over': 20, 'ba...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1277</td>\n",
       "      <td>22</td>\n",
       "      <td>37</td>\n",
       "      <td>59.45</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>{'dismissedBp': {'innings': 1, 'over': 20, 'ba...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>187</td>\n",
       "      <td>31</td>\n",
       "      <td>40</td>\n",
       "      <td>77.50</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>{'dismissedBp': {'innings': 1, 'over': 36, 'ba...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>182</td>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>27.27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>{'dismissedBp': {'innings': 1, 'over': 23, 'ba...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1662</td>\n",
       "      <td>34</td>\n",
       "      <td>61</td>\n",
       "      <td>55.73</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>{'dismissedBp': {'innings': 1, 'over': 40, 'ba...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>836</td>\n",
       "      <td>42</td>\n",
       "      <td>34</td>\n",
       "      <td>123.52</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>{'dismissedBp': {'innings': 1, 'over': 50, 'ba...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1664</td>\n",
       "      <td>31</td>\n",
       "      <td>35</td>\n",
       "      <td>88.57</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>898</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>{'dismissedBp': {'innings': 1, 'over': 50, 'ba...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   playerId   r   b      sr  4s  6s  \\\n",
       "0       456   6   9   66.66   1   0   \n",
       "1       834  10  17   58.82   1   0   \n",
       "2        24  38  54   70.37   4   0   \n",
       "3      1277  22  37   59.45   1   0   \n",
       "4       187  31  40   77.50   1   0   \n",
       "5       182   3  11   27.27   0   0   \n",
       "6      1662  34  61   55.73   2   1   \n",
       "7       836  42  34  123.52   1   2   \n",
       "8      1664  31  35   88.57   2   0   \n",
       "9       898   0   2    0.00   0   0   \n",
       "\n",
       "                                                 mod  \n",
       "0  {'dismissedBp': {'innings': 1, 'over': 4, 'bal...  \n",
       "1  {'dismissedBp': {'innings': 1, 'over': 6, 'bal...  \n",
       "2  {'dismissedBp': {'innings': 1, 'over': 20, 'ba...  \n",
       "3  {'dismissedBp': {'innings': 1, 'over': 20, 'ba...  \n",
       "4  {'dismissedBp': {'innings': 1, 'over': 36, 'ba...  \n",
       "5  {'dismissedBp': {'innings': 1, 'over': 23, 'ba...  \n",
       "6  {'dismissedBp': {'innings': 1, 'over': 40, 'ba...  \n",
       "7  {'dismissedBp': {'innings': 1, 'over': 50, 'ba...  \n",
       "8                                                NaN  \n",
       "9  {'dismissedBp': {'innings': 1, 'over': 50, 'ba...  "
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(match_scorecard['innings'][0]['scorecard']['battingStats'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.862373Z",
     "start_time": "2020-02-06T15:59:07.843732Z"
    }
   },
   "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>playerId</th>\n",
       "      <th>ov</th>\n",
       "      <th>r</th>\n",
       "      <th>w</th>\n",
       "      <th>d</th>\n",
       "      <th>maid</th>\n",
       "      <th>e</th>\n",
       "      <th>wd</th>\n",
       "      <th>nb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>116</td>\n",
       "      <td>10</td>\n",
       "      <td>44</td>\n",
       "      <td>2</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>4.40</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1124</td>\n",
       "      <td>10</td>\n",
       "      <td>35</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>1</td>\n",
       "      <td>3.50</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2740</td>\n",
       "      <td>6</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>5.16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>261</td>\n",
       "      <td>10</td>\n",
       "      <td>46</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>4.60</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>111</td>\n",
       "      <td>10</td>\n",
       "      <td>51</td>\n",
       "      <td>4</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>5.10</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>297</td>\n",
       "      <td>4</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>4.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   playerId  ov   r  w   d  maid     e  wd  nb\n",
       "0       116  10  44  2  33     0  4.40   2   0\n",
       "1      1124  10  35  2  41     1  3.50   0   0\n",
       "2      2740   6  31  0  16     0  5.16   0   0\n",
       "3       261  10  46  1  28     0  4.60   1   0\n",
       "4       111  10  51  4  32     0  5.10   3   0\n",
       "5       297   4  16  0  13     0  4.00   0   0"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match_scorecard['innings'][0]['scorecard']['bowlingStats'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:07.989582Z",
     "start_time": "2020-02-06T15:59:07.864995Z"
    }
   },
   "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>playerId</th>\n",
       "      <th>r</th>\n",
       "      <th>b</th>\n",
       "      <th>sr</th>\n",
       "      <th>4s</th>\n",
       "      <th>6s</th>\n",
       "      <th>mod</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>41</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>66.66</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>{'dismissedBp': {'innings': 2, 'over': 6, 'bal...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>107</td>\n",
       "      <td>122</td>\n",
       "      <td>144</td>\n",
       "      <td>84.72</td>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>164</td>\n",
       "      <td>18</td>\n",
       "      <td>34</td>\n",
       "      <td>52.94</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>{'dismissedBp': {'innings': 2, 'over': 16, 'ba...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1125</td>\n",
       "      <td>26</td>\n",
       "      <td>42</td>\n",
       "      <td>61.90</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>{'dismissedBp': {'innings': 2, 'over': 32, 'ba...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>46</td>\n",
       "      <td>73.91</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>{'dismissedBp': {'innings': 2, 'over': 47, 'ba...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2740</td>\n",
       "      <td>15</td>\n",
       "      <td>7</td>\n",
       "      <td>214.28</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   playerId    r    b      sr  4s  6s  \\\n",
       "0        41    8   12   66.66   1   0   \n",
       "1       107  122  144   84.72  13   2   \n",
       "2       164   18   34   52.94   1   0   \n",
       "3      1125   26   42   61.90   2   0   \n",
       "4         1   34   46   73.91   2   0   \n",
       "5      2740   15    7  214.28   3   0   \n",
       "\n",
       "                                                 mod  \n",
       "0  {'dismissedBp': {'innings': 2, 'over': 6, 'bal...  \n",
       "1                                                NaN  \n",
       "2  {'dismissedBp': {'innings': 2, 'over': 16, 'ba...  \n",
       "3  {'dismissedBp': {'innings': 2, 'over': 32, 'ba...  \n",
       "4  {'dismissedBp': {'innings': 2, 'over': 47, 'ba...  \n",
       "5                                                NaN  "
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match_scorecard['innings'][1]['scorecard']['battingStats'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-02-06T15:59:08.024000Z",
     "start_time": "2020-02-06T15:59:07.992892Z"
    }
   },
   "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>playerId</th>\n",
       "      <th>ov</th>\n",
       "      <th>r</th>\n",
       "      <th>w</th>\n",
       "      <th>d</th>\n",
       "      <th>maid</th>\n",
       "      <th>e</th>\n",
       "      <th>wd</th>\n",
       "      <th>nb</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>898</td>\n",
       "      <td>10</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>5.80</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1664</td>\n",
       "      <td>10</td>\n",
       "      <td>39</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>3.90</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>836</td>\n",
       "      <td>10</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>3</td>\n",
       "      <td>3.60</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1662</td>\n",
       "      <td>8.3</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>4.70</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3309</td>\n",
       "      <td>9</td>\n",
       "      <td>54</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>6.00</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   playerId   ov   r  w   d  maid     e  wd  nb\n",
       "0       898   10  58  0  20     0  5.80   0   0\n",
       "1      1664   10  39  2  40     1  3.90   1   0\n",
       "2       836   10  36  1  43     3  3.60   1   0\n",
       "3      1662  8.3  40  1  30     0  4.70   1   0\n",
       "4      3309    9  54  0  25     0  6.00   1   0"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(match_scorecard['innings'][1]['scorecard']['bowlingStats'])"
   ]
  },
  {
   "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}