{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "c67dc850-faf9-4837-af74-6d77be4ca303",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "from yaml import safe_load\n",
    "import os\n",
    "from tqdm import tqdm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "3dfa8810-7976-467c-8c6a-39f902bdc902",
   "metadata": {},
   "outputs": [],
   "source": [
    "filenames=[]\n",
    "for file in os.listdir('scoredata'):\n",
    "    filenames.append(os.path.join('scoredata',file))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "a3df7ccf-a9ca-4d54-bec9-554571c04269",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['scoredata/64928.yaml',\n",
       " 'scoredata/1177016.yaml',\n",
       " 'scoredata/582190.yaml',\n",
       " 'scoredata/1115779.yaml',\n",
       " 'scoredata/267712.yaml']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filenames[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "e98b55f0-e8c2-42df-8a39-a632062e776d",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      " 76%|█████████████████████████████▊         | 1554/2034 [04:30<01:08,  7.02it/s]"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Error processing file scoredata/README.txt: \n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|███████████████████████████████████████| 2034/2034 [05:56<00:00,  5.70it/s]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>innings</th>\n",
       "      <th>meta.data_version</th>\n",
       "      <th>meta.created</th>\n",
       "      <th>meta.revision</th>\n",
       "      <th>info.city</th>\n",
       "      <th>info.dates</th>\n",
       "      <th>info.gender</th>\n",
       "      <th>info.match_type</th>\n",
       "      <th>info.match_type_number</th>\n",
       "      <th>info.outcome.result</th>\n",
       "      <th>...</th>\n",
       "      <th>info.supersubs.Zimbabwe</th>\n",
       "      <th>info.supersubs.ICC World XI</th>\n",
       "      <th>info.supersubs.Sri Lanka</th>\n",
       "      <th>info.supersubs.Pakistan</th>\n",
       "      <th>info.supersubs.England</th>\n",
       "      <th>info.supersubs.Bangladesh</th>\n",
       "      <th>info.supersubs.West Indies</th>\n",
       "      <th>info.outcome.eliminator</th>\n",
       "      <th>info.supersubs.Africa XI</th>\n",
       "      <th>info.supersubs.Asia XI</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2020-12-04</td>\n",
       "      <td>1</td>\n",
       "      <td>Durban</td>\n",
       "      <td>[2005-02-11]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>2225.0</td>\n",
       "      <td>no result</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'Pakistan', 'deliver...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2019-10-31</td>\n",
       "      <td>1</td>\n",
       "      <td>Potchefstroom</td>\n",
       "      <td>[2019-05-09]</td>\n",
       "      <td>female</td>\n",
       "      <td>ODI</td>\n",
       "      <td>1153.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'New Zealand', 'deli...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2012-11-16</td>\n",
       "      <td>2</td>\n",
       "      <td>Hambantota</td>\n",
       "      <td>[2012-11-10]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'New Zealand', 'deli...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2020-05-14</td>\n",
       "      <td>1</td>\n",
       "      <td>Christchurch</td>\n",
       "      <td>[2018-03-10]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>3992.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'Sri Lanka', 'delive...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2015-10-04</td>\n",
       "      <td>1</td>\n",
       "      <td>Rajkot</td>\n",
       "      <td>[2007-02-11]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'West Indies', 'deli...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2011-04-29</td>\n",
       "      <td>2</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>[2011-04-28]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2015-02-28</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[2015-02-27]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'West Indies', 'deli...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2013-02-23</td>\n",
       "      <td>2</td>\n",
       "      <td>Grenada</td>\n",
       "      <td>[2013-02-22]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2016-06-16</td>\n",
       "      <td>1</td>\n",
       "      <td>St Kitts</td>\n",
       "      <td>[2016-06-15]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'Afghanistan', 'deli...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2020-06-02</td>\n",
       "      <td>1</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>[2018-09-20]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>4041.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2033 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              innings  meta.data_version  \\\n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...                0.9   \n",
       "0   [{'1st innings': {'team': 'Pakistan', 'deliver...                0.9   \n",
       "0   [{'1st innings': {'team': 'New Zealand', 'deli...                0.9   \n",
       "0   [{'1st innings': {'team': 'New Zealand', 'deli...                0.9   \n",
       "0   [{'1st innings': {'team': 'Sri Lanka', 'delive...                0.9   \n",
       "..                                                ...                ...   \n",
       "0   [{'1st innings': {'team': 'West Indies', 'deli...                0.9   \n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...                0.9   \n",
       "0   [{'1st innings': {'team': 'West Indies', 'deli...                0.9   \n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...                0.9   \n",
       "0   [{'1st innings': {'team': 'Afghanistan', 'deli...                0.9   \n",
       "\n",
       "   meta.created  meta.revision      info.city    info.dates info.gender  \\\n",
       "0    2020-12-04              1         Durban  [2005-02-11]        male   \n",
       "0    2019-10-31              1  Potchefstroom  [2019-05-09]      female   \n",
       "0    2012-11-16              2     Hambantota  [2012-11-10]        male   \n",
       "0    2020-05-14              1   Christchurch  [2018-03-10]        male   \n",
       "0    2015-10-04              1         Rajkot  [2007-02-11]        male   \n",
       "..          ...            ...            ...           ...         ...   \n",
       "0    2011-04-29              2       Barbados  [2011-04-28]        male   \n",
       "0    2015-02-28              1            NaN  [2015-02-27]        male   \n",
       "0    2013-02-23              2        Grenada  [2013-02-22]        male   \n",
       "0    2016-06-16              1       St Kitts  [2016-06-15]        male   \n",
       "0    2020-06-02              1      Abu Dhabi  [2018-09-20]        male   \n",
       "\n",
       "   info.match_type  info.match_type_number info.outcome.result  ...  \\\n",
       "0              ODI                  2225.0           no result  ...   \n",
       "0              ODI                  1153.0                 NaN  ...   \n",
       "0              ODI                     NaN                 NaN  ...   \n",
       "0              ODI                  3992.0                 NaN  ...   \n",
       "0              ODI                     NaN                 NaN  ...   \n",
       "..             ...                     ...                 ...  ...   \n",
       "0              ODI                     NaN                 NaN  ...   \n",
       "0              ODI                     NaN                 NaN  ...   \n",
       "0              ODI                     NaN                 NaN  ...   \n",
       "0              ODI                     NaN                 NaN  ...   \n",
       "0              ODI                  4041.0                 NaN  ...   \n",
       "\n",
       "    info.supersubs.Zimbabwe info.supersubs.ICC World XI  \\\n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "..                      ...                         ...   \n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "\n",
       "   info.supersubs.Sri Lanka info.supersubs.Pakistan info.supersubs.England  \\\n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "..                      ...                     ...                    ...   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "\n",
       "   info.supersubs.Bangladesh  info.supersubs.West Indies  \\\n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "..                       ...                         ...   \n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "\n",
       "   info.outcome.eliminator  info.supersubs.Africa XI info.supersubs.Asia XI  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "..                     ...                       ...                    ...  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "\n",
       "[2033 rows x 37 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df = pd.DataFrame()\n",
    "counter = 1\n",
    "\n",
    "for file in tqdm(filenames):\n",
    "    try:\n",
    "        with open(file, 'r') as f:\n",
    "            df = pd.json_normalize(safe_load(f))\n",
    "            df['match_id'] = counter\n",
    "            final_df = pd.concat([final_df, df])\n",
    "            counter += 1\n",
    "    except NotImplementedError as e:\n",
    "        print(f\"Error processing file {file}: {e}\")\n",
    "        continue\n",
    "\n",
    "final_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "091cded4-e35b-48a4-9507-c8fecf08372d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['scoredata/64928.yaml',\n",
       " 'scoredata/1177016.yaml',\n",
       " 'scoredata/582190.yaml',\n",
       " 'scoredata/1115779.yaml',\n",
       " 'scoredata/267712.yaml']"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filenames[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "419a1702-b5af-4a54-a2dd-7ed6c09d7007",
   "metadata": {},
   "outputs": [],
   "source": [
    "backup=final_df.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "c598ac73-3015-4162-9a6f-5e925a0e6542",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>innings</th>\n",
       "      <th>meta.data_version</th>\n",
       "      <th>meta.created</th>\n",
       "      <th>meta.revision</th>\n",
       "      <th>info.city</th>\n",
       "      <th>info.dates</th>\n",
       "      <th>info.gender</th>\n",
       "      <th>info.match_type</th>\n",
       "      <th>info.match_type_number</th>\n",
       "      <th>info.outcome.result</th>\n",
       "      <th>...</th>\n",
       "      <th>info.supersubs.Zimbabwe</th>\n",
       "      <th>info.supersubs.ICC World XI</th>\n",
       "      <th>info.supersubs.Sri Lanka</th>\n",
       "      <th>info.supersubs.Pakistan</th>\n",
       "      <th>info.supersubs.England</th>\n",
       "      <th>info.supersubs.Bangladesh</th>\n",
       "      <th>info.supersubs.West Indies</th>\n",
       "      <th>info.outcome.eliminator</th>\n",
       "      <th>info.supersubs.Africa XI</th>\n",
       "      <th>info.supersubs.Asia XI</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2020-12-04</td>\n",
       "      <td>1</td>\n",
       "      <td>Durban</td>\n",
       "      <td>[2005-02-11]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>2225.0</td>\n",
       "      <td>no result</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'Pakistan', 'deliver...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2019-10-31</td>\n",
       "      <td>1</td>\n",
       "      <td>Potchefstroom</td>\n",
       "      <td>[2019-05-09]</td>\n",
       "      <td>female</td>\n",
       "      <td>ODI</td>\n",
       "      <td>1153.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'New Zealand', 'deli...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2012-11-16</td>\n",
       "      <td>2</td>\n",
       "      <td>Hambantota</td>\n",
       "      <td>[2012-11-10]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'New Zealand', 'deli...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2020-05-14</td>\n",
       "      <td>1</td>\n",
       "      <td>Christchurch</td>\n",
       "      <td>[2018-03-10]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>3992.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'Sri Lanka', 'delive...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2015-10-04</td>\n",
       "      <td>1</td>\n",
       "      <td>Rajkot</td>\n",
       "      <td>[2007-02-11]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'West Indies', 'deli...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2011-04-29</td>\n",
       "      <td>2</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>[2011-04-28]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2015-02-28</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[2015-02-27]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'West Indies', 'deli...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2013-02-23</td>\n",
       "      <td>2</td>\n",
       "      <td>Grenada</td>\n",
       "      <td>[2013-02-22]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2016-06-16</td>\n",
       "      <td>1</td>\n",
       "      <td>St Kitts</td>\n",
       "      <td>[2016-06-15]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'Afghanistan', 'deli...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2020-06-02</td>\n",
       "      <td>1</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>[2018-09-20]</td>\n",
       "      <td>male</td>\n",
       "      <td>ODI</td>\n",
       "      <td>4041.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2033 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              innings  meta.data_version  \\\n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...                0.9   \n",
       "0   [{'1st innings': {'team': 'Pakistan', 'deliver...                0.9   \n",
       "0   [{'1st innings': {'team': 'New Zealand', 'deli...                0.9   \n",
       "0   [{'1st innings': {'team': 'New Zealand', 'deli...                0.9   \n",
       "0   [{'1st innings': {'team': 'Sri Lanka', 'delive...                0.9   \n",
       "..                                                ...                ...   \n",
       "0   [{'1st innings': {'team': 'West Indies', 'deli...                0.9   \n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...                0.9   \n",
       "0   [{'1st innings': {'team': 'West Indies', 'deli...                0.9   \n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...                0.9   \n",
       "0   [{'1st innings': {'team': 'Afghanistan', 'deli...                0.9   \n",
       "\n",
       "   meta.created  meta.revision      info.city    info.dates info.gender  \\\n",
       "0    2020-12-04              1         Durban  [2005-02-11]        male   \n",
       "0    2019-10-31              1  Potchefstroom  [2019-05-09]      female   \n",
       "0    2012-11-16              2     Hambantota  [2012-11-10]        male   \n",
       "0    2020-05-14              1   Christchurch  [2018-03-10]        male   \n",
       "0    2015-10-04              1         Rajkot  [2007-02-11]        male   \n",
       "..          ...            ...            ...           ...         ...   \n",
       "0    2011-04-29              2       Barbados  [2011-04-28]        male   \n",
       "0    2015-02-28              1            NaN  [2015-02-27]        male   \n",
       "0    2013-02-23              2        Grenada  [2013-02-22]        male   \n",
       "0    2016-06-16              1       St Kitts  [2016-06-15]        male   \n",
       "0    2020-06-02              1      Abu Dhabi  [2018-09-20]        male   \n",
       "\n",
       "   info.match_type  info.match_type_number info.outcome.result  ...  \\\n",
       "0              ODI                  2225.0           no result  ...   \n",
       "0              ODI                  1153.0                 NaN  ...   \n",
       "0              ODI                     NaN                 NaN  ...   \n",
       "0              ODI                  3992.0                 NaN  ...   \n",
       "0              ODI                     NaN                 NaN  ...   \n",
       "..             ...                     ...                 ...  ...   \n",
       "0              ODI                     NaN                 NaN  ...   \n",
       "0              ODI                     NaN                 NaN  ...   \n",
       "0              ODI                     NaN                 NaN  ...   \n",
       "0              ODI                     NaN                 NaN  ...   \n",
       "0              ODI                  4041.0                 NaN  ...   \n",
       "\n",
       "    info.supersubs.Zimbabwe info.supersubs.ICC World XI  \\\n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "..                      ...                         ...   \n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "0                       NaN                         NaN   \n",
       "\n",
       "   info.supersubs.Sri Lanka info.supersubs.Pakistan info.supersubs.England  \\\n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "..                      ...                     ...                    ...   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "0                       NaN                     NaN                    NaN   \n",
       "\n",
       "   info.supersubs.Bangladesh  info.supersubs.West Indies  \\\n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "..                       ...                         ...   \n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "0                        NaN                         NaN   \n",
       "\n",
       "   info.outcome.eliminator  info.supersubs.Africa XI info.supersubs.Asia XI  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "..                     ...                       ...                    ...  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "0                      NaN                       NaN                    NaN  \n",
       "\n",
       "[2033 rows x 37 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "1e4eab88-6ba6-4f6f-8ba4-20279b3c6187",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['innings', 'meta.data_version', 'meta.created', 'meta.revision',\n",
       "       'info.city', 'info.dates', 'info.gender', 'info.match_type',\n",
       "       'info.match_type_number', 'info.outcome.result', 'info.overs',\n",
       "       'info.teams', 'info.toss.decision', 'info.toss.winner', 'info.umpires',\n",
       "       'info.venue', 'match_id', 'info.outcome.winner',\n",
       "       'info.outcome.by.wickets', 'info.player_of_match',\n",
       "       'info.outcome.method', 'info.outcome.by.runs', 'info.neutral_venue',\n",
       "       'info.supersubs.South Africa', 'info.supersubs.New Zealand',\n",
       "       'info.supersubs.Australia', 'info.supersubs.India',\n",
       "       'info.supersubs.Zimbabwe', 'info.supersubs.ICC World XI',\n",
       "       'info.supersubs.Sri Lanka', 'info.supersubs.Pakistan',\n",
       "       'info.supersubs.England', 'info.supersubs.Bangladesh',\n",
       "       'info.supersubs.West Indies', 'info.outcome.eliminator',\n",
       "       'info.supersubs.Africa XI', 'info.supersubs.Asia XI'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df.columns\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "c6f1c7d0-7b22-49db-a423-65d11cd3b72a",
   "metadata": {},
   "outputs": [],
   "source": [
    "final_df.drop(columns=[\n",
    "    'meta.data_version',\n",
    "    'meta.created',\n",
    "    'meta.revision',\n",
    "    'info.outcome.eliminator',\n",
    "    'info.match_type_number',\n",
    "    'info.outcome.result',\n",
    "    \n",
    "    \n",
    "],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "3d374f78-38e0-4803-90d1-a32d49c0145e",
   "metadata": {},
   "outputs": [],
   "source": [
    "final_df.drop(columns=[\n",
    "    'info.umpires',\n",
    "    'info.supersubs.South Africa', 'info.supersubs.New Zealand',\n",
    "    'info.supersubs.Australia', 'info.supersubs.India',\n",
    "    'info.supersubs.Zimbabwe', 'info.supersubs.ICC World XI',\n",
    "    'info.supersubs.Sri Lanka', 'info.supersubs.Pakistan',\n",
    "    'info.supersubs.England', 'info.supersubs.Bangladesh',\n",
    "    'info.supersubs.West Indies','info.supersubs.Africa XI', 'info.supersubs.Asia XI'\n",
    "    \n",
    "],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "d3bb529f-f031-4e69-a9f0-0780ddefd847",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0             NaN\n",
       "0    South Africa\n",
       "0       Sri Lanka\n",
       "0         England\n",
       "0       Sri Lanka\n",
       "         ...     \n",
       "0        Pakistan\n",
       "0    South Africa\n",
       "0     West Indies\n",
       "0    South Africa\n",
       "0     Afghanistan\n",
       "Name: info.outcome.winner, Length: 2033, dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df['info.outcome.winner']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "4940d207-c756-4cc6-8b23-b4db16f3f5ad",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "info.gender\n",
       "male      1799\n",
       "female     234\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df['info.gender'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "ccb52ce8-23f0-4660-96f7-93b956b53a2e",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/bl/1s8rszdj6_7cxljgp0nvyk7w0000gn/T/ipykernel_1389/2343689724.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  final_df.drop(columns=['info.gender'],inplace=True)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>innings</th>\n",
       "      <th>info.city</th>\n",
       "      <th>info.dates</th>\n",
       "      <th>info.match_type</th>\n",
       "      <th>info.overs</th>\n",
       "      <th>info.teams</th>\n",
       "      <th>info.toss.decision</th>\n",
       "      <th>info.toss.winner</th>\n",
       "      <th>info.venue</th>\n",
       "      <th>match_id</th>\n",
       "      <th>info.outcome.winner</th>\n",
       "      <th>info.outcome.by.wickets</th>\n",
       "      <th>info.player_of_match</th>\n",
       "      <th>info.outcome.method</th>\n",
       "      <th>info.outcome.by.runs</th>\n",
       "      <th>info.neutral_venue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>Durban</td>\n",
       "      <td>[2005-02-11]</td>\n",
       "      <td>ODI</td>\n",
       "      <td>50</td>\n",
       "      <td>[South Africa, England]</td>\n",
       "      <td>bat</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>Kingsmead</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'New Zealand', 'deli...</td>\n",
       "      <td>Hambantota</td>\n",
       "      <td>[2012-11-10]</td>\n",
       "      <td>ODI</td>\n",
       "      <td>50</td>\n",
       "      <td>[Sri Lanka, New Zealand]</td>\n",
       "      <td>field</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Mahinda Rajapaksa International Cricket Stadiu...</td>\n",
       "      <td>3</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>7.0</td>\n",
       "      <td>[BMAJ Mendis]</td>\n",
       "      <td>D/L</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'New Zealand', 'deli...</td>\n",
       "      <td>Christchurch</td>\n",
       "      <td>[2018-03-10]</td>\n",
       "      <td>ODI</td>\n",
       "      <td>50</td>\n",
       "      <td>[New Zealand, England]</td>\n",
       "      <td>field</td>\n",
       "      <td>England</td>\n",
       "      <td>Hagley Oval</td>\n",
       "      <td>4</td>\n",
       "      <td>England</td>\n",
       "      <td>7.0</td>\n",
       "      <td>[JM Bairstow]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'Sri Lanka', 'delive...</td>\n",
       "      <td>Rajkot</td>\n",
       "      <td>[2007-02-11]</td>\n",
       "      <td>ODI</td>\n",
       "      <td>50</td>\n",
       "      <td>[India, Sri Lanka]</td>\n",
       "      <td>field</td>\n",
       "      <td>India</td>\n",
       "      <td>Madhavrao Scindia Cricket Ground</td>\n",
       "      <td>5</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[KC Sangakkara]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'England', 'deliveri...</td>\n",
       "      <td>London</td>\n",
       "      <td>[2011-06-28]</td>\n",
       "      <td>ODI</td>\n",
       "      <td>50</td>\n",
       "      <td>[England, Sri Lanka]</td>\n",
       "      <td>field</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Kennington Oval</td>\n",
       "      <td>6</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[JM Anderson]</td>\n",
       "      <td>D/L</td>\n",
       "      <td>110.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'West Indies', 'deli...</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>[2011-04-28]</td>\n",
       "      <td>ODI</td>\n",
       "      <td>50</td>\n",
       "      <td>[West Indies, Pakistan]</td>\n",
       "      <td>field</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Kensington Oval, Bridgetown</td>\n",
       "      <td>2029</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>3.0</td>\n",
       "      <td>[Misbah-ul-Haq]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[2015-02-27]</td>\n",
       "      <td>ODI</td>\n",
       "      <td>50</td>\n",
       "      <td>[South Africa, West Indies]</td>\n",
       "      <td>bat</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>Sydney Cricket Ground</td>\n",
       "      <td>2030</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[AB de Villiers]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>257.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'West Indies', 'deli...</td>\n",
       "      <td>Grenada</td>\n",
       "      <td>[2013-02-22]</td>\n",
       "      <td>ODI</td>\n",
       "      <td>50</td>\n",
       "      <td>[West Indies, Zimbabwe]</td>\n",
       "      <td>field</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>National Cricket Stadium, St George's</td>\n",
       "      <td>2031</td>\n",
       "      <td>West Indies</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[J Charles]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>156.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>St Kitts</td>\n",
       "      <td>[2016-06-15]</td>\n",
       "      <td>ODI</td>\n",
       "      <td>50</td>\n",
       "      <td>[West Indies, South Africa]</td>\n",
       "      <td>field</td>\n",
       "      <td>West Indies</td>\n",
       "      <td>Warner Park, Basseterre</td>\n",
       "      <td>2032</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Imran Tahir]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>139.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'Afghanistan', 'deli...</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>[2018-09-20]</td>\n",
       "      <td>ODI</td>\n",
       "      <td>50</td>\n",
       "      <td>[Afghanistan, Bangladesh]</td>\n",
       "      <td>bat</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Sheikh Zayed Stadium</td>\n",
       "      <td>2033</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Rashid Khan]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>136.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1799 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              innings     info.city  \\\n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...        Durban   \n",
       "0   [{'1st innings': {'team': 'New Zealand', 'deli...    Hambantota   \n",
       "0   [{'1st innings': {'team': 'New Zealand', 'deli...  Christchurch   \n",
       "0   [{'1st innings': {'team': 'Sri Lanka', 'delive...        Rajkot   \n",
       "0   [{'1st innings': {'team': 'England', 'deliveri...        London   \n",
       "..                                                ...           ...   \n",
       "0   [{'1st innings': {'team': 'West Indies', 'deli...      Barbados   \n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...           NaN   \n",
       "0   [{'1st innings': {'team': 'West Indies', 'deli...       Grenada   \n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...      St Kitts   \n",
       "0   [{'1st innings': {'team': 'Afghanistan', 'deli...     Abu Dhabi   \n",
       "\n",
       "      info.dates info.match_type  info.overs                   info.teams  \\\n",
       "0   [2005-02-11]             ODI          50      [South Africa, England]   \n",
       "0   [2012-11-10]             ODI          50     [Sri Lanka, New Zealand]   \n",
       "0   [2018-03-10]             ODI          50       [New Zealand, England]   \n",
       "0   [2007-02-11]             ODI          50           [India, Sri Lanka]   \n",
       "0   [2011-06-28]             ODI          50         [England, Sri Lanka]   \n",
       "..           ...             ...         ...                          ...   \n",
       "0   [2011-04-28]             ODI          50      [West Indies, Pakistan]   \n",
       "0   [2015-02-27]             ODI          50  [South Africa, West Indies]   \n",
       "0   [2013-02-22]             ODI          50      [West Indies, Zimbabwe]   \n",
       "0   [2016-06-15]             ODI          50  [West Indies, South Africa]   \n",
       "0   [2018-09-20]             ODI          50    [Afghanistan, Bangladesh]   \n",
       "\n",
       "   info.toss.decision info.toss.winner  \\\n",
       "0                 bat     South Africa   \n",
       "0               field        Sri Lanka   \n",
       "0               field          England   \n",
       "0               field            India   \n",
       "0               field        Sri Lanka   \n",
       "..                ...              ...   \n",
       "0               field         Pakistan   \n",
       "0                 bat     South Africa   \n",
       "0               field         Zimbabwe   \n",
       "0               field      West Indies   \n",
       "0                 bat      Afghanistan   \n",
       "\n",
       "                                           info.venue  match_id  \\\n",
       "0                                           Kingsmead         1   \n",
       "0   Mahinda Rajapaksa International Cricket Stadiu...         3   \n",
       "0                                         Hagley Oval         4   \n",
       "0                    Madhavrao Scindia Cricket Ground         5   \n",
       "0                                     Kennington Oval         6   \n",
       "..                                                ...       ...   \n",
       "0                         Kensington Oval, Bridgetown      2029   \n",
       "0                               Sydney Cricket Ground      2030   \n",
       "0               National Cricket Stadium, St George's      2031   \n",
       "0                             Warner Park, Basseterre      2032   \n",
       "0                                Sheikh Zayed Stadium      2033   \n",
       "\n",
       "   info.outcome.winner  info.outcome.by.wickets info.player_of_match  \\\n",
       "0                  NaN                      NaN                  NaN   \n",
       "0            Sri Lanka                      7.0        [BMAJ Mendis]   \n",
       "0              England                      7.0        [JM Bairstow]   \n",
       "0            Sri Lanka                      NaN      [KC Sangakkara]   \n",
       "0              England                      NaN        [JM Anderson]   \n",
       "..                 ...                      ...                  ...   \n",
       "0             Pakistan                      3.0      [Misbah-ul-Haq]   \n",
       "0         South Africa                      NaN     [AB de Villiers]   \n",
       "0          West Indies                      NaN          [J Charles]   \n",
       "0         South Africa                      NaN        [Imran Tahir]   \n",
       "0          Afghanistan                      NaN        [Rashid Khan]   \n",
       "\n",
       "   info.outcome.method  info.outcome.by.runs  info.neutral_venue  \n",
       "0                  NaN                   NaN                 NaN  \n",
       "0                  D/L                   NaN                 NaN  \n",
       "0                  NaN                   NaN                 NaN  \n",
       "0                  NaN                   5.0                 NaN  \n",
       "0                  D/L                 110.0                 NaN  \n",
       "..                 ...                   ...                 ...  \n",
       "0                  NaN                   NaN                 NaN  \n",
       "0                  NaN                 257.0                 1.0  \n",
       "0                  NaN                 156.0                 NaN  \n",
       "0                  NaN                 139.0                 NaN  \n",
       "0                  NaN                 136.0                 NaN  \n",
       "\n",
       "[1799 rows x 16 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df=final_df[final_df['info.gender']=='male']\n",
    "final_df.drop(columns=['info.gender'],inplace=True)\n",
    "final_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "daa317ec-698b-4096-bf93-8ab9a3f44791",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "info.match_type\n",
       "ODI    1799\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df['info.match_type'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "e88cdbac-eff2-41da-8ec9-842dc8048812",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "info.overs\n",
       "50    1799\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df['info.overs'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "2f90af49-eb45-4fd3-8565-fec6cf7f9f6f",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/bl/1s8rszdj6_7cxljgp0nvyk7w0000gn/T/ipykernel_1389/88217534.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  final_df.drop(columns=['info.overs','info.match_type'],inplace=True)\n"
     ]
    }
   ],
   "source": [
    "final_df.drop(columns=['info.overs','info.match_type'],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "9f550da3-778b-452f-a33a-7640c8af1cff",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>innings</th>\n",
       "      <th>info.city</th>\n",
       "      <th>info.dates</th>\n",
       "      <th>info.teams</th>\n",
       "      <th>info.toss.decision</th>\n",
       "      <th>info.toss.winner</th>\n",
       "      <th>info.venue</th>\n",
       "      <th>match_id</th>\n",
       "      <th>info.outcome.winner</th>\n",
       "      <th>info.outcome.by.wickets</th>\n",
       "      <th>info.player_of_match</th>\n",
       "      <th>info.outcome.method</th>\n",
       "      <th>info.outcome.by.runs</th>\n",
       "      <th>info.neutral_venue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>Durban</td>\n",
       "      <td>[2005-02-11]</td>\n",
       "      <td>[South Africa, England]</td>\n",
       "      <td>bat</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>Kingsmead</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'New Zealand', 'deli...</td>\n",
       "      <td>Hambantota</td>\n",
       "      <td>[2012-11-10]</td>\n",
       "      <td>[Sri Lanka, New Zealand]</td>\n",
       "      <td>field</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Mahinda Rajapaksa International Cricket Stadiu...</td>\n",
       "      <td>3</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>7.0</td>\n",
       "      <td>[BMAJ Mendis]</td>\n",
       "      <td>D/L</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'New Zealand', 'deli...</td>\n",
       "      <td>Christchurch</td>\n",
       "      <td>[2018-03-10]</td>\n",
       "      <td>[New Zealand, England]</td>\n",
       "      <td>field</td>\n",
       "      <td>England</td>\n",
       "      <td>Hagley Oval</td>\n",
       "      <td>4</td>\n",
       "      <td>England</td>\n",
       "      <td>7.0</td>\n",
       "      <td>[JM Bairstow]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'Sri Lanka', 'delive...</td>\n",
       "      <td>Rajkot</td>\n",
       "      <td>[2007-02-11]</td>\n",
       "      <td>[India, Sri Lanka]</td>\n",
       "      <td>field</td>\n",
       "      <td>India</td>\n",
       "      <td>Madhavrao Scindia Cricket Ground</td>\n",
       "      <td>5</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[KC Sangakkara]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'England', 'deliveri...</td>\n",
       "      <td>London</td>\n",
       "      <td>[2011-06-28]</td>\n",
       "      <td>[England, Sri Lanka]</td>\n",
       "      <td>field</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Kennington Oval</td>\n",
       "      <td>6</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[JM Anderson]</td>\n",
       "      <td>D/L</td>\n",
       "      <td>110.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'West Indies', 'deli...</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>[2011-04-28]</td>\n",
       "      <td>[West Indies, Pakistan]</td>\n",
       "      <td>field</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Kensington Oval, Bridgetown</td>\n",
       "      <td>2029</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>3.0</td>\n",
       "      <td>[Misbah-ul-Haq]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[2015-02-27]</td>\n",
       "      <td>[South Africa, West Indies]</td>\n",
       "      <td>bat</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>Sydney Cricket Ground</td>\n",
       "      <td>2030</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[AB de Villiers]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>257.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'West Indies', 'deli...</td>\n",
       "      <td>Grenada</td>\n",
       "      <td>[2013-02-22]</td>\n",
       "      <td>[West Indies, Zimbabwe]</td>\n",
       "      <td>field</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>National Cricket Stadium, St George's</td>\n",
       "      <td>2031</td>\n",
       "      <td>West Indies</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[J Charles]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>156.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>St Kitts</td>\n",
       "      <td>[2016-06-15]</td>\n",
       "      <td>[West Indies, South Africa]</td>\n",
       "      <td>field</td>\n",
       "      <td>West Indies</td>\n",
       "      <td>Warner Park, Basseterre</td>\n",
       "      <td>2032</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Imran Tahir]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>139.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'Afghanistan', 'deli...</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>[2018-09-20]</td>\n",
       "      <td>[Afghanistan, Bangladesh]</td>\n",
       "      <td>bat</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Sheikh Zayed Stadium</td>\n",
       "      <td>2033</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Rashid Khan]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>136.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1799 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              innings     info.city  \\\n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...        Durban   \n",
       "0   [{'1st innings': {'team': 'New Zealand', 'deli...    Hambantota   \n",
       "0   [{'1st innings': {'team': 'New Zealand', 'deli...  Christchurch   \n",
       "0   [{'1st innings': {'team': 'Sri Lanka', 'delive...        Rajkot   \n",
       "0   [{'1st innings': {'team': 'England', 'deliveri...        London   \n",
       "..                                                ...           ...   \n",
       "0   [{'1st innings': {'team': 'West Indies', 'deli...      Barbados   \n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...           NaN   \n",
       "0   [{'1st innings': {'team': 'West Indies', 'deli...       Grenada   \n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...      St Kitts   \n",
       "0   [{'1st innings': {'team': 'Afghanistan', 'deli...     Abu Dhabi   \n",
       "\n",
       "      info.dates                   info.teams info.toss.decision  \\\n",
       "0   [2005-02-11]      [South Africa, England]                bat   \n",
       "0   [2012-11-10]     [Sri Lanka, New Zealand]              field   \n",
       "0   [2018-03-10]       [New Zealand, England]              field   \n",
       "0   [2007-02-11]           [India, Sri Lanka]              field   \n",
       "0   [2011-06-28]         [England, Sri Lanka]              field   \n",
       "..           ...                          ...                ...   \n",
       "0   [2011-04-28]      [West Indies, Pakistan]              field   \n",
       "0   [2015-02-27]  [South Africa, West Indies]                bat   \n",
       "0   [2013-02-22]      [West Indies, Zimbabwe]              field   \n",
       "0   [2016-06-15]  [West Indies, South Africa]              field   \n",
       "0   [2018-09-20]    [Afghanistan, Bangladesh]                bat   \n",
       "\n",
       "   info.toss.winner                                         info.venue  \\\n",
       "0      South Africa                                          Kingsmead   \n",
       "0         Sri Lanka  Mahinda Rajapaksa International Cricket Stadiu...   \n",
       "0           England                                        Hagley Oval   \n",
       "0             India                   Madhavrao Scindia Cricket Ground   \n",
       "0         Sri Lanka                                    Kennington Oval   \n",
       "..              ...                                                ...   \n",
       "0          Pakistan                        Kensington Oval, Bridgetown   \n",
       "0      South Africa                              Sydney Cricket Ground   \n",
       "0          Zimbabwe              National Cricket Stadium, St George's   \n",
       "0       West Indies                            Warner Park, Basseterre   \n",
       "0       Afghanistan                               Sheikh Zayed Stadium   \n",
       "\n",
       "    match_id info.outcome.winner  info.outcome.by.wickets  \\\n",
       "0          1                 NaN                      NaN   \n",
       "0          3           Sri Lanka                      7.0   \n",
       "0          4             England                      7.0   \n",
       "0          5           Sri Lanka                      NaN   \n",
       "0          6             England                      NaN   \n",
       "..       ...                 ...                      ...   \n",
       "0       2029            Pakistan                      3.0   \n",
       "0       2030        South Africa                      NaN   \n",
       "0       2031         West Indies                      NaN   \n",
       "0       2032        South Africa                      NaN   \n",
       "0       2033         Afghanistan                      NaN   \n",
       "\n",
       "   info.player_of_match info.outcome.method  info.outcome.by.runs  \\\n",
       "0                   NaN                 NaN                   NaN   \n",
       "0         [BMAJ Mendis]                 D/L                   NaN   \n",
       "0         [JM Bairstow]                 NaN                   NaN   \n",
       "0       [KC Sangakkara]                 NaN                   5.0   \n",
       "0         [JM Anderson]                 D/L                 110.0   \n",
       "..                  ...                 ...                   ...   \n",
       "0       [Misbah-ul-Haq]                 NaN                   NaN   \n",
       "0      [AB de Villiers]                 NaN                 257.0   \n",
       "0           [J Charles]                 NaN                 156.0   \n",
       "0         [Imran Tahir]                 NaN                 139.0   \n",
       "0         [Rashid Khan]                 NaN                 136.0   \n",
       "\n",
       "    info.neutral_venue  \n",
       "0                  NaN  \n",
       "0                  NaN  \n",
       "0                  NaN  \n",
       "0                  NaN  \n",
       "0                  NaN  \n",
       "..                 ...  \n",
       "0                  NaN  \n",
       "0                  1.0  \n",
       "0                  NaN  \n",
       "0                  NaN  \n",
       "0                  NaN  \n",
       "\n",
       "[1799 rows x 14 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "42bb0b33-2353-4c9c-8d43-968bacc59f1a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pickle\n",
    "pickle.dump(final_df,open('dataset_level1.pkl','wb'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "cfee18b0-6a00-486b-ae83-ec6985e3e2a8",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pickle\n",
    "with open('dataset_level1.pkl', 'rb') as file:\n",
    "    matches = pickle.load(file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "1257d750-6bea-4fbd-9795-a4bf9a3c186b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>innings</th>\n",
       "      <th>info.city</th>\n",
       "      <th>info.dates</th>\n",
       "      <th>info.teams</th>\n",
       "      <th>info.toss.decision</th>\n",
       "      <th>info.toss.winner</th>\n",
       "      <th>info.venue</th>\n",
       "      <th>match_id</th>\n",
       "      <th>info.outcome.winner</th>\n",
       "      <th>info.outcome.by.wickets</th>\n",
       "      <th>info.player_of_match</th>\n",
       "      <th>info.outcome.method</th>\n",
       "      <th>info.outcome.by.runs</th>\n",
       "      <th>info.neutral_venue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>Durban</td>\n",
       "      <td>[2005-02-11]</td>\n",
       "      <td>[South Africa, England]</td>\n",
       "      <td>bat</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>Kingsmead</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'New Zealand', 'deli...</td>\n",
       "      <td>Hambantota</td>\n",
       "      <td>[2012-11-10]</td>\n",
       "      <td>[Sri Lanka, New Zealand]</td>\n",
       "      <td>field</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Mahinda Rajapaksa International Cricket Stadiu...</td>\n",
       "      <td>3</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>7.0</td>\n",
       "      <td>[BMAJ Mendis]</td>\n",
       "      <td>D/L</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'New Zealand', 'deli...</td>\n",
       "      <td>Christchurch</td>\n",
       "      <td>[2018-03-10]</td>\n",
       "      <td>[New Zealand, England]</td>\n",
       "      <td>field</td>\n",
       "      <td>England</td>\n",
       "      <td>Hagley Oval</td>\n",
       "      <td>4</td>\n",
       "      <td>England</td>\n",
       "      <td>7.0</td>\n",
       "      <td>[JM Bairstow]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'Sri Lanka', 'delive...</td>\n",
       "      <td>Rajkot</td>\n",
       "      <td>[2007-02-11]</td>\n",
       "      <td>[India, Sri Lanka]</td>\n",
       "      <td>field</td>\n",
       "      <td>India</td>\n",
       "      <td>Madhavrao Scindia Cricket Ground</td>\n",
       "      <td>5</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[KC Sangakkara]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'England', 'deliveri...</td>\n",
       "      <td>London</td>\n",
       "      <td>[2011-06-28]</td>\n",
       "      <td>[England, Sri Lanka]</td>\n",
       "      <td>field</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Kennington Oval</td>\n",
       "      <td>6</td>\n",
       "      <td>England</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[JM Anderson]</td>\n",
       "      <td>D/L</td>\n",
       "      <td>110.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'West Indies', 'deli...</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>[2011-04-28]</td>\n",
       "      <td>[West Indies, Pakistan]</td>\n",
       "      <td>field</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Kensington Oval, Bridgetown</td>\n",
       "      <td>2029</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>3.0</td>\n",
       "      <td>[Misbah-ul-Haq]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[2015-02-27]</td>\n",
       "      <td>[South Africa, West Indies]</td>\n",
       "      <td>bat</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>Sydney Cricket Ground</td>\n",
       "      <td>2030</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[AB de Villiers]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>257.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'West Indies', 'deli...</td>\n",
       "      <td>Grenada</td>\n",
       "      <td>[2013-02-22]</td>\n",
       "      <td>[West Indies, Zimbabwe]</td>\n",
       "      <td>field</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>National Cricket Stadium, St George's</td>\n",
       "      <td>2031</td>\n",
       "      <td>West Indies</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[J Charles]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>156.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'South Africa', 'del...</td>\n",
       "      <td>St Kitts</td>\n",
       "      <td>[2016-06-15]</td>\n",
       "      <td>[West Indies, South Africa]</td>\n",
       "      <td>field</td>\n",
       "      <td>West Indies</td>\n",
       "      <td>Warner Park, Basseterre</td>\n",
       "      <td>2032</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Imran Tahir]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>139.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[{'1st innings': {'team': 'Afghanistan', 'deli...</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>[2018-09-20]</td>\n",
       "      <td>[Afghanistan, Bangladesh]</td>\n",
       "      <td>bat</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Sheikh Zayed Stadium</td>\n",
       "      <td>2033</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Rashid Khan]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>136.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1799 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              innings     info.city  \\\n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...        Durban   \n",
       "0   [{'1st innings': {'team': 'New Zealand', 'deli...    Hambantota   \n",
       "0   [{'1st innings': {'team': 'New Zealand', 'deli...  Christchurch   \n",
       "0   [{'1st innings': {'team': 'Sri Lanka', 'delive...        Rajkot   \n",
       "0   [{'1st innings': {'team': 'England', 'deliveri...        London   \n",
       "..                                                ...           ...   \n",
       "0   [{'1st innings': {'team': 'West Indies', 'deli...      Barbados   \n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...           NaN   \n",
       "0   [{'1st innings': {'team': 'West Indies', 'deli...       Grenada   \n",
       "0   [{'1st innings': {'team': 'South Africa', 'del...      St Kitts   \n",
       "0   [{'1st innings': {'team': 'Afghanistan', 'deli...     Abu Dhabi   \n",
       "\n",
       "      info.dates                   info.teams info.toss.decision  \\\n",
       "0   [2005-02-11]      [South Africa, England]                bat   \n",
       "0   [2012-11-10]     [Sri Lanka, New Zealand]              field   \n",
       "0   [2018-03-10]       [New Zealand, England]              field   \n",
       "0   [2007-02-11]           [India, Sri Lanka]              field   \n",
       "0   [2011-06-28]         [England, Sri Lanka]              field   \n",
       "..           ...                          ...                ...   \n",
       "0   [2011-04-28]      [West Indies, Pakistan]              field   \n",
       "0   [2015-02-27]  [South Africa, West Indies]                bat   \n",
       "0   [2013-02-22]      [West Indies, Zimbabwe]              field   \n",
       "0   [2016-06-15]  [West Indies, South Africa]              field   \n",
       "0   [2018-09-20]    [Afghanistan, Bangladesh]                bat   \n",
       "\n",
       "   info.toss.winner                                         info.venue  \\\n",
       "0      South Africa                                          Kingsmead   \n",
       "0         Sri Lanka  Mahinda Rajapaksa International Cricket Stadiu...   \n",
       "0           England                                        Hagley Oval   \n",
       "0             India                   Madhavrao Scindia Cricket Ground   \n",
       "0         Sri Lanka                                    Kennington Oval   \n",
       "..              ...                                                ...   \n",
       "0          Pakistan                        Kensington Oval, Bridgetown   \n",
       "0      South Africa                              Sydney Cricket Ground   \n",
       "0          Zimbabwe              National Cricket Stadium, St George's   \n",
       "0       West Indies                            Warner Park, Basseterre   \n",
       "0       Afghanistan                               Sheikh Zayed Stadium   \n",
       "\n",
       "    match_id info.outcome.winner  info.outcome.by.wickets  \\\n",
       "0          1                 NaN                      NaN   \n",
       "0          3           Sri Lanka                      7.0   \n",
       "0          4             England                      7.0   \n",
       "0          5           Sri Lanka                      NaN   \n",
       "0          6             England                      NaN   \n",
       "..       ...                 ...                      ...   \n",
       "0       2029            Pakistan                      3.0   \n",
       "0       2030        South Africa                      NaN   \n",
       "0       2031         West Indies                      NaN   \n",
       "0       2032        South Africa                      NaN   \n",
       "0       2033         Afghanistan                      NaN   \n",
       "\n",
       "   info.player_of_match info.outcome.method  info.outcome.by.runs  \\\n",
       "0                   NaN                 NaN                   NaN   \n",
       "0         [BMAJ Mendis]                 D/L                   NaN   \n",
       "0         [JM Bairstow]                 NaN                   NaN   \n",
       "0       [KC Sangakkara]                 NaN                   5.0   \n",
       "0         [JM Anderson]                 D/L                 110.0   \n",
       "..                  ...                 ...                   ...   \n",
       "0       [Misbah-ul-Haq]                 NaN                   NaN   \n",
       "0      [AB de Villiers]                 NaN                 257.0   \n",
       "0           [J Charles]                 NaN                 156.0   \n",
       "0         [Imran Tahir]                 NaN                 139.0   \n",
       "0         [Rashid Khan]                 NaN                 136.0   \n",
       "\n",
       "    info.neutral_venue  \n",
       "0                  NaN  \n",
       "0                  NaN  \n",
       "0                  NaN  \n",
       "0                  NaN  \n",
       "0                  NaN  \n",
       "..                 ...  \n",
       "0                  NaN  \n",
       "0                  1.0  \n",
       "0                  NaN  \n",
       "0                  NaN  \n",
       "0                  NaN  \n",
       "\n",
       "[1799 rows x 14 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "0ecae681-36b0-4153-b9f4-5b67ce7ecc92",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{0.1: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'GC Smith'}},\n",
       " {0.2: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'GC Smith'}},\n",
       " {0.3: {'non_striker': 'GC Smith',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {0.4: {'non_striker': 'GC Smith',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {0.5: {'non_striker': 'GC Smith',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {0.6: {'non_striker': 'GC Smith',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {1.1: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'GC Smith'}},\n",
       " {1.2: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'GC Smith'}},\n",
       " {1.3: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'GC Smith'}},\n",
       " {1.4: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'GC Smith'}},\n",
       " {1.5: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'GC Smith'}},\n",
       " {1.6: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'GC Smith'}},\n",
       " {2.1: {'non_striker': 'GC Smith',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {2.2: {'non_striker': 'GC Smith',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {2.3: {'non_striker': 'GC Smith',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {2.4: {'non_striker': 'GC Smith',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {2.5: {'non_striker': 'GC Smith',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {2.6: {'non_striker': 'GC Smith',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {3.1: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'GC Smith',\n",
       "   'wicket': {'player_out': 'GC Smith',\n",
       "    'fielders': ['ME Trescothick'],\n",
       "    'kind': 'caught'}}},\n",
       " {3.2: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'JH Kallis',\n",
       "   'wicket': {'player_out': 'JH Kallis',\n",
       "    'fielders': ['AJ Strauss'],\n",
       "    'kind': 'caught'}}},\n",
       " {3.3: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 2, 'batsman': 2},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {3.4: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {3.5: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {3.6: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {4.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {4.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {4.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {4.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {4.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {4.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {5.1: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {5.2: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {5.3: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {5.4: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {5.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {5.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {6.1: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {6.2: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {6.3: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {6.4: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {6.5: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {6.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {7.1: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {7.2: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {7.3: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {7.4: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {7.5: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {7.6: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {8.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {8.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {8.3: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {8.4: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {8.5: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {8.6: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {9.1: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {9.2: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {9.3: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 2, 'batsman': 2},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {9.4: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {9.5: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 2, 'batsman': 2},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {9.6: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {10.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {10.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {10.3: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {10.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {10.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {10.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {11.1: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {11.2: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {11.3: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {11.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {11.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {11.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {12.1: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {12.2: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {12.3: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {12.4: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {12.5: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {12.6: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {13.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {13.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {13.3: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 2, 'batsman': 2},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {13.4: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 2, 'batsman': 2},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {13.5: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 1, 'total': 5, 'batsman': 4},\n",
       "   'extras': {'noballs': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {13.6: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {13.7: {'non_striker': 'AM Bacher',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {14.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {14.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {14.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 1, 'total': 1, 'batsman': 0},\n",
       "   'extras': {'wides': 1},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {14.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher'}},\n",
       " {14.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AM Bacher',\n",
       "   'wicket': {'player_out': 'AM Bacher', 'kind': 'lbw'}}},\n",
       " {14.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {14.7: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {15.1: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {15.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 3, 'batsman': 3},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {15.3: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {15.4: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {15.5: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {15.6: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {16.1: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {16.2: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 6, 'batsman': 6},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {16.3: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {16.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {16.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {16.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {17.1: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {17.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {17.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {17.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {17.5: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 2, 'batsman': 2},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {17.6: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {18.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {18.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {18.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {18.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {18.5: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {18.6: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 4, 'total': 4, 'batsman': 0},\n",
       "   'extras': {'byes': 4},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {19.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {19.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {19.3: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {19.4: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {19.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {19.6: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {20.1: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {20.2: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {20.3: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {20.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {20.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {20.6: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {21.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {21.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {21.3: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {21.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {21.5: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {21.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {22.1: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {22.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {22.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {22.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {22.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {22.6: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {23.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {23.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {23.3: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {23.4: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {23.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {23.6: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {24.1: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {24.2: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {24.3: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {24.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {24.5: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {24.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {25.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {25.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {25.3: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {25.4: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {25.5: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {25.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {26.1: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {26.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {26.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {26.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {26.5: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {26.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {27.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {27.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {27.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {27.4: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {27.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {27.6: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {28.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {28.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {28.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {28.4: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {28.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {28.6: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {29.1: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {29.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AG Prince'}},\n",
       " {29.3: {'non_striker': 'AG Prince',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {29.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AG Prince',\n",
       "   'wicket': {'player_out': 'AG Prince',\n",
       "    'fielders': ['PD Collingwood'],\n",
       "    'kind': 'caught'}}},\n",
       " {29.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {29.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {30.1: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {30.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {30.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {30.4: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {30.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {30.6: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {31.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {31.2: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {31.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {31.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {31.5: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {31.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {32.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {32.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {32.3: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {32.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {32.5: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {32.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'MP Vaughan',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {33.1: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 3, 'batsman': 3},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {33.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {33.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {33.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {33.5: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {33.6: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {34.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {34.2: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {34.3: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {34.4: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {34.5: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {34.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {35.1: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {35.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 2, 'total': 2, 'batsman': 0},\n",
       "   'extras': {'legbyes': 2},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {35.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {35.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {35.5: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 2, 'batsman': 2},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {35.6: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'AF Giles',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {36.1: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {36.2: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {36.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 1, 'total': 1, 'batsman': 0},\n",
       "   'extras': {'legbyes': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {36.4: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {36.5: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 2, 'batsman': 2},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {36.6: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 2, 'batsman': 2},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {37.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {37.2: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {37.3: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {37.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 1, 'total': 2, 'batsman': 1},\n",
       "   'extras': {'noballs': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {37.5: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {37.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {37.7: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {38.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {38.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {38.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {38.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {38.5: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {38.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 2, 'batsman': 2},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {39.1: {'non_striker': 'MV Boucher',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {39.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'MV Boucher'}},\n",
       " {39.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'MV Boucher',\n",
       "   'wicket': {'player_out': 'MV Boucher',\n",
       "    'fielders': ['Kabir Ali'],\n",
       "    'kind': 'caught'}}},\n",
       " {39.4: {'non_striker': 'JM Kemp',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {39.5: {'non_striker': 'JM Kemp',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {39.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'JM Kemp'}},\n",
       " {40.1: {'non_striker': 'JM Kemp',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {40.2: {'non_striker': 'JM Kemp',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {40.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'JM Kemp'}},\n",
       " {40.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'JM Kemp'}},\n",
       " {40.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'JM Kemp',\n",
       "   'wicket': {'player_out': 'JM Kemp',\n",
       "    'fielders': ['AJ Strauss'],\n",
       "    'kind': 'caught'}}},\n",
       " {40.6: {'non_striker': 'SM Pollock',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {41.1: {'non_striker': 'SM Pollock',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {41.2: {'non_striker': 'SM Pollock',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 2, 'batsman': 2},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {41.3: {'non_striker': 'SM Pollock',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {41.4: {'non_striker': 'SM Pollock',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {41.5: {'non_striker': 'SM Pollock',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {41.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'SM Pollock'}},\n",
       " {42.1: {'non_striker': 'SM Pollock',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {42.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'SM Pollock'}},\n",
       " {42.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'SM Pollock'}},\n",
       " {42.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'SM Pollock',\n",
       "   'wicket': {'player_out': 'SM Pollock', 'kind': 'lbw'}}},\n",
       " {42.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 2, 'batsman': 2},\n",
       "   'batsman': 'AJ Hall'}},\n",
       " {42.6: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'PD Collingwood',\n",
       "   'runs': {'extras': 0, 'total': 2, 'batsman': 2},\n",
       "   'batsman': 'AJ Hall'}},\n",
       " {43.1: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {43.2: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AJ Hall'}},\n",
       " {43.3: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 1, 'total': 1, 'batsman': 0},\n",
       "   'extras': {'legbyes': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {43.4: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AJ Hall'}},\n",
       " {43.5: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {43.6: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 1, 'total': 1, 'batsman': 0},\n",
       "   'extras': {'wides': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {43.7: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'AG Wharf',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {44.1: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 1, 'total': 2, 'batsman': 1},\n",
       "   'extras': {'noballs': 1},\n",
       "   'batsman': 'AJ Hall'}},\n",
       " {44.2: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {44.3: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AJ Hall'}},\n",
       " {44.4: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {44.5: {'non_striker': 'HH Gibbs',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AJ Hall'}},\n",
       " {44.6: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 4, 'batsman': 4},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {44.7: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 1, 'total': 1, 'batsman': 0},\n",
       "   'extras': {'wides': 1},\n",
       "   'batsman': 'HH Gibbs'}},\n",
       " {44.8: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'HH Gibbs',\n",
       "   'wicket': {'player_out': 'HH Gibbs',\n",
       "    'fielders': ['PD Collingwood'],\n",
       "    'kind': 'caught'}}},\n",
       " {45.1: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'M Ntini'}},\n",
       " {45.2: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'M Ntini',\n",
       "   'wicket': {'player_out': 'M Ntini',\n",
       "    'fielders': ['AJ Strauss'],\n",
       "    'kind': 'caught'}}},\n",
       " {45.3: {'non_striker': 'A Nel',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'AJ Hall'}},\n",
       " {45.4: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'A Nel'}},\n",
       " {45.5: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'A Nel'}},\n",
       " {45.6: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'D Gough',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'A Nel'}},\n",
       " {46.1: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'A Nel'}},\n",
       " {46.2: {'non_striker': 'AJ Hall',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 1, 'batsman': 1},\n",
       "   'batsman': 'A Nel'}},\n",
       " {46.3: {'non_striker': 'A Nel',\n",
       "   'bowler': 'Kabir Ali',\n",
       "   'runs': {'extras': 0, 'total': 0, 'batsman': 0},\n",
       "   'batsman': 'AJ Hall',\n",
       "   'wicket': {'player_out': 'AJ Hall', 'kind': 'bowled'}}}]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches.iloc[0]['innings'][0]['1st innings']['deliveries']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "1074fcf8-bde1-4b7a-b918-030ed323f4b7",
   "metadata": {},
   "outputs": [],
   "source": [
    "count=1\n",
    "delivery_df=pd.DataFrame()\n",
    "for index, row in matches.iterrows():\n",
    "    \n",
    "    count+=1\n",
    "    ball_of_match=[]\n",
    "    batsman=[]\n",
    "    bowler=[]\n",
    "    runs=[]\n",
    "    player_of_dismissed=[]\n",
    "    teams=[]\n",
    "    batting_team=[]\n",
    "    match_id=[]\n",
    "    city=[]\n",
    "    venue=[]\n",
    "    \n",
    "    for ball in row['innings'][0]['1st innings']['deliveries']:\n",
    "        for key in ball.keys():\n",
    "            match_id.append(count)\n",
    "            batting_team.append(row['innings'][0]['1st innings']['team'])\n",
    "            teams.append(row['info.teams'])\n",
    "            ball_of_match.append(key)\n",
    "            batsman.append(ball[key]['batsman'])\n",
    "            bowler.append(ball[key]['bowler'])\n",
    "            runs.append(ball[key]['runs']['total'])\n",
    "            city.append(row['info.city'])\n",
    "            venue.append(row['info.venue'])\n",
    "            try:\n",
    "                player_of_dismissed.append(ball[key]['wicket']['player_out'])\n",
    "            except:\n",
    "                player_of_dismissed.append('0')\n",
    "    loop_df=pd.DataFrame({\n",
    "            'match_id':match_id,\n",
    "            'teams':teams,\n",
    "            'batting_team':batting_team,\n",
    "            'ball':ball_of_match,\n",
    "            'batsman':batsman,\n",
    "            'bowler':bowler,\n",
    "            'runs':runs,\n",
    "            'player_dismissed':player_of_dismissed,\n",
    "            'city':city,\n",
    "            'venue':venue\n",
    "      })\n",
    "    delivery_df = pd.concat([delivery_df, loop_df], ignore_index=True)\n",
    "  \n",
    "        \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "efd4477c-cbfb-4880-9743-d3972dc4fcb5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>match_id</th>\n",
       "      <th>teams</th>\n",
       "      <th>batting_team</th>\n",
       "      <th>ball</th>\n",
       "      <th>batsman</th>\n",
       "      <th>bowler</th>\n",
       "      <th>runs</th>\n",
       "      <th>player_dismissed</th>\n",
       "      <th>city</th>\n",
       "      <th>venue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>[South Africa, England]</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>0.1</td>\n",
       "      <td>GC Smith</td>\n",
       "      <td>D Gough</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Durban</td>\n",
       "      <td>Kingsmead</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>[South Africa, England]</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>0.2</td>\n",
       "      <td>GC Smith</td>\n",
       "      <td>D Gough</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Durban</td>\n",
       "      <td>Kingsmead</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>[South Africa, England]</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>0.3</td>\n",
       "      <td>AM Bacher</td>\n",
       "      <td>D Gough</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Durban</td>\n",
       "      <td>Kingsmead</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>[South Africa, England]</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>0.4</td>\n",
       "      <td>AM Bacher</td>\n",
       "      <td>D Gough</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Durban</td>\n",
       "      <td>Kingsmead</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>[South Africa, England]</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>0.5</td>\n",
       "      <td>AM Bacher</td>\n",
       "      <td>D Gough</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Durban</td>\n",
       "      <td>Kingsmead</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519641</th>\n",
       "      <td>1800</td>\n",
       "      <td>[Afghanistan, Bangladesh]</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>49.2</td>\n",
       "      <td>Rashid Khan</td>\n",
       "      <td>Mashrafe Mortaza</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>Sheikh Zayed Stadium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519642</th>\n",
       "      <td>1800</td>\n",
       "      <td>[Afghanistan, Bangladesh]</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>49.3</td>\n",
       "      <td>Rashid Khan</td>\n",
       "      <td>Mashrafe Mortaza</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>Sheikh Zayed Stadium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519643</th>\n",
       "      <td>1800</td>\n",
       "      <td>[Afghanistan, Bangladesh]</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>49.4</td>\n",
       "      <td>Rashid Khan</td>\n",
       "      <td>Mashrafe Mortaza</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>Sheikh Zayed Stadium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519644</th>\n",
       "      <td>1800</td>\n",
       "      <td>[Afghanistan, Bangladesh]</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>49.5</td>\n",
       "      <td>Rashid Khan</td>\n",
       "      <td>Mashrafe Mortaza</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>Sheikh Zayed Stadium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519645</th>\n",
       "      <td>1800</td>\n",
       "      <td>[Afghanistan, Bangladesh]</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>49.6</td>\n",
       "      <td>Rashid Khan</td>\n",
       "      <td>Mashrafe Mortaza</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>Sheikh Zayed Stadium</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>519646 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id                      teams  batting_team  ball      batsman  \\\n",
       "0              2    [South Africa, England]  South Africa   0.1     GC Smith   \n",
       "1              2    [South Africa, England]  South Africa   0.2     GC Smith   \n",
       "2              2    [South Africa, England]  South Africa   0.3    AM Bacher   \n",
       "3              2    [South Africa, England]  South Africa   0.4    AM Bacher   \n",
       "4              2    [South Africa, England]  South Africa   0.5    AM Bacher   \n",
       "...          ...                        ...           ...   ...          ...   \n",
       "519641      1800  [Afghanistan, Bangladesh]   Afghanistan  49.2  Rashid Khan   \n",
       "519642      1800  [Afghanistan, Bangladesh]   Afghanistan  49.3  Rashid Khan   \n",
       "519643      1800  [Afghanistan, Bangladesh]   Afghanistan  49.4  Rashid Khan   \n",
       "519644      1800  [Afghanistan, Bangladesh]   Afghanistan  49.5  Rashid Khan   \n",
       "519645      1800  [Afghanistan, Bangladesh]   Afghanistan  49.6  Rashid Khan   \n",
       "\n",
       "                  bowler  runs player_dismissed       city  \\\n",
       "0                D Gough     0                0     Durban   \n",
       "1                D Gough     1                0     Durban   \n",
       "2                D Gough     0                0     Durban   \n",
       "3                D Gough     0                0     Durban   \n",
       "4                D Gough     0                0     Durban   \n",
       "...                  ...   ...              ...        ...   \n",
       "519641  Mashrafe Mortaza     4                0  Abu Dhabi   \n",
       "519642  Mashrafe Mortaza     4                0  Abu Dhabi   \n",
       "519643  Mashrafe Mortaza     2                0  Abu Dhabi   \n",
       "519644  Mashrafe Mortaza     4                0  Abu Dhabi   \n",
       "519645  Mashrafe Mortaza     4                0  Abu Dhabi   \n",
       "\n",
       "                       venue  \n",
       "0                  Kingsmead  \n",
       "1                  Kingsmead  \n",
       "2                  Kingsmead  \n",
       "3                  Kingsmead  \n",
       "4                  Kingsmead  \n",
       "...                      ...  \n",
       "519641  Sheikh Zayed Stadium  \n",
       "519642  Sheikh Zayed Stadium  \n",
       "519643  Sheikh Zayed Stadium  \n",
       "519644  Sheikh Zayed Stadium  \n",
       "519645  Sheikh Zayed Stadium  \n",
       "\n",
       "[519646 rows x 10 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "delivery_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "4c645566-a717-4101-b002-166c2245b87a",
   "metadata": {},
   "outputs": [],
   "source": [
    "def bowl(row):\n",
    "    for team in row['teams']:\n",
    "        if team != row['batting_team']:\n",
    "            return team"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "337aa595-6b0e-468d-a5de-1e95fa159651",
   "metadata": {},
   "outputs": [],
   "source": [
    "delivery_df['bowling_team']=delivery_df.apply(bowl,axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "1e2f2d3c-b1c5-40f8-b692-76026e765e91",
   "metadata": {},
   "outputs": [],
   "source": [
    "delivery_df.drop(columns=['teams'],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "a021251c-377f-4998-a774-8fb70f6dc7ec",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['South Africa', 'New Zealand', 'Sri Lanka', 'England', 'Asia XI',\n",
       "       'West Indies', 'Australia', 'Canada', 'Kenya', 'Zimbabwe',\n",
       "       'Netherlands', 'Pakistan', 'Bangladesh', 'Ireland', 'Nepal',\n",
       "       'India', 'United Arab Emirates', 'Afghanistan', 'Scotland',\n",
       "       'United States of America', 'Papua New Guinea', 'Bermuda', 'Oman',\n",
       "       'Namibia', 'Hong Kong', 'Africa XI'], dtype=object)"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "delivery_df['batting_team'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "4b9524db-65ae-44e3-a76c-e528bafb5323",
   "metadata": {},
   "outputs": [],
   "source": [
    "teams=[\n",
    "    'Australia',\n",
    "    'India',\n",
    "    'Bangladesh',\n",
    "    'New Zealand',\n",
    "    'South Africa',\n",
    "    'England',\n",
    "    'Afghanistan',\n",
    "    'Pakistan',\n",
    "    'Sri Lanka',\n",
    "    'Netherlands'\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "ccbffe38-9012-44d9-8cc7-e8a6d2ba678e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "bowling_team\n",
       "India                       64601\n",
       "England                     50012\n",
       "Pakistan                    47858\n",
       "West Indies                 45433\n",
       "Sri Lanka                   45080\n",
       "South Africa                42901\n",
       "Australia                   42011\n",
       "New Zealand                 39410\n",
       "Bangladesh                  36406\n",
       "Zimbabwe                    32970\n",
       "Ireland                     18478\n",
       "Afghanistan                 12548\n",
       "Scotland                     7391\n",
       "United Arab Emirates         7326\n",
       "Canada                       4876\n",
       "Kenya                        4592\n",
       "Netherlands                  3741\n",
       "Hong Kong                    2826\n",
       "Papua New Guinea             2723\n",
       "Oman                         2695\n",
       "United States of America     1172\n",
       "Nepal                         992\n",
       "Bermuda                       948\n",
       "Africa XI                     934\n",
       "Namibia                       628\n",
       "ICC World XI                  614\n",
       "Asia XI                       480\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "delivery_df['bowling_team'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "fe90a5d4-8f72-4be1-951d-85154276da7d",
   "metadata": {},
   "outputs": [],
   "source": [
    "delivery_df=delivery_df[delivery_df['batting_team'].isin(teams)]\n",
    "delivery_df=delivery_df[delivery_df['bowling_team'].isin(teams)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "4b3a5f9d-06c5-43eb-bc47-92951b3ba3d9",
   "metadata": {},
   "outputs": [],
   "source": [
    "output=delivery_df[['match_id','batting_team','bowling_team','ball','runs','player_dismissed','city','venue']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "11c1daa0-118d-4659-a18e-103c90862d90",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>match_id</th>\n",
       "      <th>batting_team</th>\n",
       "      <th>bowling_team</th>\n",
       "      <th>ball</th>\n",
       "      <th>runs</th>\n",
       "      <th>player_dismissed</th>\n",
       "      <th>city</th>\n",
       "      <th>venue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>England</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Durban</td>\n",
       "      <td>Kingsmead</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>England</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Durban</td>\n",
       "      <td>Kingsmead</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>England</td>\n",
       "      <td>0.3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Durban</td>\n",
       "      <td>Kingsmead</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>England</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Durban</td>\n",
       "      <td>Kingsmead</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>England</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Durban</td>\n",
       "      <td>Kingsmead</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519641</th>\n",
       "      <td>1800</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>49.2</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>Sheikh Zayed Stadium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519642</th>\n",
       "      <td>1800</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>49.3</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>Sheikh Zayed Stadium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519643</th>\n",
       "      <td>1800</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>49.4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>Sheikh Zayed Stadium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519644</th>\n",
       "      <td>1800</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>49.5</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>Sheikh Zayed Stadium</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519645</th>\n",
       "      <td>1800</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>49.6</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>Sheikh Zayed Stadium</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>312984 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id  batting_team bowling_team  ball  runs player_dismissed  \\\n",
       "0              2  South Africa      England   0.1     0                0   \n",
       "1              2  South Africa      England   0.2     1                0   \n",
       "2              2  South Africa      England   0.3     0                0   \n",
       "3              2  South Africa      England   0.4     0                0   \n",
       "4              2  South Africa      England   0.5     0                0   \n",
       "...          ...           ...          ...   ...   ...              ...   \n",
       "519641      1800   Afghanistan   Bangladesh  49.2     4                0   \n",
       "519642      1800   Afghanistan   Bangladesh  49.3     4                0   \n",
       "519643      1800   Afghanistan   Bangladesh  49.4     2                0   \n",
       "519644      1800   Afghanistan   Bangladesh  49.5     4                0   \n",
       "519645      1800   Afghanistan   Bangladesh  49.6     4                0   \n",
       "\n",
       "             city                 venue  \n",
       "0          Durban             Kingsmead  \n",
       "1          Durban             Kingsmead  \n",
       "2          Durban             Kingsmead  \n",
       "3          Durban             Kingsmead  \n",
       "4          Durban             Kingsmead  \n",
       "...           ...                   ...  \n",
       "519641  Abu Dhabi  Sheikh Zayed Stadium  \n",
       "519642  Abu Dhabi  Sheikh Zayed Stadium  \n",
       "519643  Abu Dhabi  Sheikh Zayed Stadium  \n",
       "519644  Abu Dhabi  Sheikh Zayed Stadium  \n",
       "519645  Abu Dhabi  Sheikh Zayed Stadium  \n",
       "\n",
       "[312984 rows x 8 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "566ef84e-b931-4836-9f53-971fe732ebc3",
   "metadata": {},
   "outputs": [],
   "source": [
    "pickle.dump(output,open('dataset_level2.pkl','wb'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ddf3d996-ec0a-4e61-82a9-7474168c0628",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "82da4484-9369-497f-9d86-4a1a456438cb",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "870d9bbe-035b-4200-b900-814a3560829c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e5f9ef14-d8a7-4fd4-bb44-9e4606196cfd",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "41714379-0597-4c3b-bfb5-347b6a8fab1f",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f5b7c4e0-ac5d-4a05-b5a3-709414bcc0f6",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fd9cc2e8-ee85-473a-957f-02e386c13d9a",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0d482200-6d5b-4093-ad08-0b42dc26370d",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.11.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}