IPL 2024 Predictions.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "f5a62411-3026-4d68-a367-3e97a16a8ba5",
   "metadata": {},
   "source": [
    "<font size=\"20\">IPL 2024 PREDICTIONS 🏏🏆"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "13784d21-c94c-4a7d-b64d-5574f7f27e24",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd \n",
    "import numpy as np\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a86ffe3e-4f21-4ad6-9264-91f327a74e8f",
   "metadata": {},
   "source": [
    "### Overview of the Dataset:\n",
    "\n",
    "- The dataset comprises two distinct CSV files: \"matches\" and \"deliveries.\" These files encompass the summary of each match and detailed information regarding each ball bowled, respectively.\n",
    "\n",
    "- The dataset is updated up to the IPL season of 2023.\n",
    "\n",
    "- [IPL Complete Dataset (2008-2023)](https://www.kaggle.com/datasets/patrickb1912/ipl-complete-dataset-20082020/data)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "549cfda2-d212-4875-a53d-06c975db4993",
   "metadata": {},
   "source": [
    "<font size=\"5\">Loading First Dataset <font size=\"3\">(https://www.kaggle.com/datasets/patrickb1912/ipl-complete-dataset-20082020/data?select=deliveries.csv)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "92b0959c-834b-49f6-9548-b55eb5e0bd00",
   "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>inning</th>\n",
       "      <th>batting_team</th>\n",
       "      <th>bowling_team</th>\n",
       "      <th>over</th>\n",
       "      <th>ball</th>\n",
       "      <th>batter</th>\n",
       "      <th>bowler</th>\n",
       "      <th>non_striker</th>\n",
       "      <th>batsman_runs</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs</th>\n",
       "      <th>extras_type</th>\n",
       "      <th>is_wicket</th>\n",
       "      <th>player_dismissed</th>\n",
       "      <th>dismissal_kind</th>\n",
       "      <th>fielder</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>335982</td>\n",
       "      <td>1</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>SC Ganguly</td>\n",
       "      <td>P Kumar</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>legbyes</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>335982</td>\n",
       "      <td>1</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>P Kumar</td>\n",
       "      <td>SC Ganguly</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>335982</td>\n",
       "      <td>1</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>P Kumar</td>\n",
       "      <td>SC Ganguly</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>wides</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>335982</td>\n",
       "      <td>1</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>P Kumar</td>\n",
       "      <td>SC Ganguly</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>335982</td>\n",
       "      <td>1</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>P Kumar</td>\n",
       "      <td>SC Ganguly</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243812</th>\n",
       "      <td>1370353</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>MM Sharma</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243813</th>\n",
       "      <td>1370353</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>MM Sharma</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243814</th>\n",
       "      <td>1370353</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>MM Sharma</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243815</th>\n",
       "      <td>1370353</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>MM Sharma</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243816</th>\n",
       "      <td>1370353</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>MM Sharma</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>243817 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id  inning           batting_team                 bowling_team  \\\n",
       "0         335982       1  Kolkata Knight Riders  Royal Challengers Bangalore   \n",
       "1         335982       1  Kolkata Knight Riders  Royal Challengers Bangalore   \n",
       "2         335982       1  Kolkata Knight Riders  Royal Challengers Bangalore   \n",
       "3         335982       1  Kolkata Knight Riders  Royal Challengers Bangalore   \n",
       "4         335982       1  Kolkata Knight Riders  Royal Challengers Bangalore   \n",
       "...          ...     ...                    ...                          ...   \n",
       "243812   1370353       2    Chennai Super Kings               Gujarat Titans   \n",
       "243813   1370353       2    Chennai Super Kings               Gujarat Titans   \n",
       "243814   1370353       2    Chennai Super Kings               Gujarat Titans   \n",
       "243815   1370353       2    Chennai Super Kings               Gujarat Titans   \n",
       "243816   1370353       2    Chennai Super Kings               Gujarat Titans   \n",
       "\n",
       "        over  ball       batter     bowler  non_striker  batsman_runs  \\\n",
       "0          0     1   SC Ganguly    P Kumar  BB McCullum             0   \n",
       "1          0     2  BB McCullum    P Kumar   SC Ganguly             0   \n",
       "2          0     3  BB McCullum    P Kumar   SC Ganguly             0   \n",
       "3          0     4  BB McCullum    P Kumar   SC Ganguly             0   \n",
       "4          0     5  BB McCullum    P Kumar   SC Ganguly             0   \n",
       "...      ...   ...          ...        ...          ...           ...   \n",
       "243812    14     2       S Dube  MM Sharma    RA Jadeja             1   \n",
       "243813    14     3    RA Jadeja  MM Sharma       S Dube             1   \n",
       "243814    14     4       S Dube  MM Sharma    RA Jadeja             1   \n",
       "243815    14     5    RA Jadeja  MM Sharma       S Dube             6   \n",
       "243816    14     6    RA Jadeja  MM Sharma       S Dube             4   \n",
       "\n",
       "        extra_runs  total_runs extras_type  is_wicket player_dismissed  \\\n",
       "0                1           1     legbyes          0              NaN   \n",
       "1                0           0         NaN          0              NaN   \n",
       "2                1           1       wides          0              NaN   \n",
       "3                0           0         NaN          0              NaN   \n",
       "4                0           0         NaN          0              NaN   \n",
       "...            ...         ...         ...        ...              ...   \n",
       "243812           0           1         NaN          0              NaN   \n",
       "243813           0           1         NaN          0              NaN   \n",
       "243814           0           1         NaN          0              NaN   \n",
       "243815           0           6         NaN          0              NaN   \n",
       "243816           0           4         NaN          0              NaN   \n",
       "\n",
       "       dismissal_kind fielder  \n",
       "0                 NaN     NaN  \n",
       "1                 NaN     NaN  \n",
       "2                 NaN     NaN  \n",
       "3                 NaN     NaN  \n",
       "4                 NaN     NaN  \n",
       "...               ...     ...  \n",
       "243812            NaN     NaN  \n",
       "243813            NaN     NaN  \n",
       "243814            NaN     NaN  \n",
       "243815            NaN     NaN  \n",
       "243816            NaN     NaN  \n",
       "\n",
       "[243817 rows x 17 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "first_dataset = pd.read_csv(\"C:/Users/Loki/Documents/IPL 2024 Predictions/deliveries.csv\")\n",
    "first_dataset"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "372f6159-0d1d-4c95-bd32-9fcc91ba00a0",
   "metadata": {},
   "source": [
    "<font size=\"5\">Loading Second Dataset <font size=\"3\">(https://www.kaggle.com/datasets/patrickb1912/ipl-complete-dataset-20082020/data?select=matches.csv)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "d0904d5a-2149-4c52-a320-cd5f1ab822de",
   "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>id</th>\n",
       "      <th>season</th>\n",
       "      <th>city</th>\n",
       "      <th>date</th>\n",
       "      <th>match_type</th>\n",
       "      <th>player_of_match</th>\n",
       "      <th>venue</th>\n",
       "      <th>team1</th>\n",
       "      <th>team2</th>\n",
       "      <th>toss_winner</th>\n",
       "      <th>toss_decision</th>\n",
       "      <th>winner</th>\n",
       "      <th>result</th>\n",
       "      <th>result_margin</th>\n",
       "      <th>target_runs</th>\n",
       "      <th>target_overs</th>\n",
       "      <th>super_over</th>\n",
       "      <th>method</th>\n",
       "      <th>umpire1</th>\n",
       "      <th>umpire2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>335982</td>\n",
       "      <td>2007/08</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>2008-04-18</td>\n",
       "      <td>League</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>field</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>runs</td>\n",
       "      <td>140.0</td>\n",
       "      <td>223.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Asad Rauf</td>\n",
       "      <td>RE Koertzen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>335983</td>\n",
       "      <td>2007/08</td>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>2008-04-19</td>\n",
       "      <td>League</td>\n",
       "      <td>MEK Hussey</td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>bat</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>runs</td>\n",
       "      <td>33.0</td>\n",
       "      <td>241.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MR Benson</td>\n",
       "      <td>SL Shastri</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>335984</td>\n",
       "      <td>2007/08</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>2008-04-19</td>\n",
       "      <td>League</td>\n",
       "      <td>MF Maharoof</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>bat</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>wickets</td>\n",
       "      <td>9.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aleem Dar</td>\n",
       "      <td>GA Pratapkumar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>335985</td>\n",
       "      <td>2007/08</td>\n",
       "      <td>Mumbai</td>\n",
       "      <td>2008-04-20</td>\n",
       "      <td>League</td>\n",
       "      <td>MV Boucher</td>\n",
       "      <td>Wankhede Stadium</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>bat</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>wickets</td>\n",
       "      <td>5.0</td>\n",
       "      <td>166.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SJ Davis</td>\n",
       "      <td>DJ Harper</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>335986</td>\n",
       "      <td>2007/08</td>\n",
       "      <td>Kolkata</td>\n",
       "      <td>2008-04-20</td>\n",
       "      <td>League</td>\n",
       "      <td>DJ Hussey</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>bat</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>wickets</td>\n",
       "      <td>5.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BF Bowden</td>\n",
       "      <td>K Hariharan</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1019</th>\n",
       "      <td>1359544</td>\n",
       "      <td>2023</td>\n",
       "      <td>Bengaluru</td>\n",
       "      <td>2023-05-21</td>\n",
       "      <td>League</td>\n",
       "      <td>Shubman Gill</td>\n",
       "      <td>M Chinnaswamy Stadium, Bengaluru</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>field</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>wickets</td>\n",
       "      <td>6.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td>VK Sharma</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1020</th>\n",
       "      <td>1370350</td>\n",
       "      <td>2023</td>\n",
       "      <td>Chennai</td>\n",
       "      <td>2023-05-23</td>\n",
       "      <td>Qualifier 1</td>\n",
       "      <td>RD Gaikwad</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk, Chennai</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>field</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>runs</td>\n",
       "      <td>15.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AK Chaudhary</td>\n",
       "      <td>CB Gaffaney</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1021</th>\n",
       "      <td>1370351</td>\n",
       "      <td>2023</td>\n",
       "      <td>Chennai</td>\n",
       "      <td>2023-05-24</td>\n",
       "      <td>Eliminator</td>\n",
       "      <td>Akash Madhwal</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk, Chennai</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Lucknow Super Giants</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>bat</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>runs</td>\n",
       "      <td>81.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BNJ Oxenford</td>\n",
       "      <td>VK Sharma</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1022</th>\n",
       "      <td>1370352</td>\n",
       "      <td>2023</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>2023-05-26</td>\n",
       "      <td>Qualifier 2</td>\n",
       "      <td>Shubman Gill</td>\n",
       "      <td>Narendra Modi Stadium, Ahmedabad</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>field</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>runs</td>\n",
       "      <td>62.0</td>\n",
       "      <td>234.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td>RJ Tucker</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1023</th>\n",
       "      <td>1370353</td>\n",
       "      <td>2023</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>2023-05-29</td>\n",
       "      <td>Final</td>\n",
       "      <td>DP Conway</td>\n",
       "      <td>Narendra Modi Stadium, Ahmedabad</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>field</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>wickets</td>\n",
       "      <td>5.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>N</td>\n",
       "      <td>D/L</td>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td>RJ Tucker</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1024 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           id   season        city        date   match_type player_of_match  \\\n",
       "0      335982  2007/08   Bangalore  2008-04-18       League     BB McCullum   \n",
       "1      335983  2007/08  Chandigarh  2008-04-19       League      MEK Hussey   \n",
       "2      335984  2007/08       Delhi  2008-04-19       League     MF Maharoof   \n",
       "3      335985  2007/08      Mumbai  2008-04-20       League      MV Boucher   \n",
       "4      335986  2007/08     Kolkata  2008-04-20       League       DJ Hussey   \n",
       "...       ...      ...         ...         ...          ...             ...   \n",
       "1019  1359544     2023   Bengaluru  2023-05-21       League    Shubman Gill   \n",
       "1020  1370350     2023     Chennai  2023-05-23  Qualifier 1      RD Gaikwad   \n",
       "1021  1370351     2023     Chennai  2023-05-24   Eliminator   Akash Madhwal   \n",
       "1022  1370352     2023   Ahmedabad  2023-05-26  Qualifier 2    Shubman Gill   \n",
       "1023  1370353     2023   Ahmedabad  2023-05-29        Final       DP Conway   \n",
       "\n",
       "                                           venue                        team1  \\\n",
       "0                          M Chinnaswamy Stadium  Royal Challengers Bangalore   \n",
       "1     Punjab Cricket Association Stadium, Mohali              Kings XI Punjab   \n",
       "2                               Feroz Shah Kotla             Delhi Daredevils   \n",
       "3                               Wankhede Stadium               Mumbai Indians   \n",
       "4                                   Eden Gardens        Kolkata Knight Riders   \n",
       "...                                          ...                          ...   \n",
       "1019            M Chinnaswamy Stadium, Bengaluru  Royal Challengers Bangalore   \n",
       "1020    MA Chidambaram Stadium, Chepauk, Chennai          Chennai Super Kings   \n",
       "1021    MA Chidambaram Stadium, Chepauk, Chennai               Mumbai Indians   \n",
       "1022            Narendra Modi Stadium, Ahmedabad               Gujarat Titans   \n",
       "1023            Narendra Modi Stadium, Ahmedabad               Gujarat Titans   \n",
       "\n",
       "                            team2                  toss_winner toss_decision  \\\n",
       "0           Kolkata Knight Riders  Royal Challengers Bangalore         field   \n",
       "1             Chennai Super Kings          Chennai Super Kings           bat   \n",
       "2                Rajasthan Royals             Rajasthan Royals           bat   \n",
       "3     Royal Challengers Bangalore               Mumbai Indians           bat   \n",
       "4                 Deccan Chargers              Deccan Chargers           bat   \n",
       "...                           ...                          ...           ...   \n",
       "1019               Gujarat Titans               Gujarat Titans         field   \n",
       "1020               Gujarat Titans               Gujarat Titans         field   \n",
       "1021         Lucknow Super Giants               Mumbai Indians           bat   \n",
       "1022               Mumbai Indians               Mumbai Indians         field   \n",
       "1023          Chennai Super Kings          Chennai Super Kings         field   \n",
       "\n",
       "                           winner   result  result_margin  target_runs  \\\n",
       "0           Kolkata Knight Riders     runs          140.0        223.0   \n",
       "1             Chennai Super Kings     runs           33.0        241.0   \n",
       "2                Delhi Daredevils  wickets            9.0        130.0   \n",
       "3     Royal Challengers Bangalore  wickets            5.0        166.0   \n",
       "4           Kolkata Knight Riders  wickets            5.0        111.0   \n",
       "...                           ...      ...            ...          ...   \n",
       "1019               Gujarat Titans  wickets            6.0        198.0   \n",
       "1020          Chennai Super Kings     runs           15.0        173.0   \n",
       "1021               Mumbai Indians     runs           81.0        183.0   \n",
       "1022               Gujarat Titans     runs           62.0        234.0   \n",
       "1023          Chennai Super Kings  wickets            5.0        171.0   \n",
       "\n",
       "      target_overs super_over method       umpire1         umpire2  \n",
       "0             20.0          N    NaN     Asad Rauf     RE Koertzen  \n",
       "1             20.0          N    NaN     MR Benson      SL Shastri  \n",
       "2             20.0          N    NaN     Aleem Dar  GA Pratapkumar  \n",
       "3             20.0          N    NaN      SJ Davis       DJ Harper  \n",
       "4             20.0          N    NaN     BF Bowden     K Hariharan  \n",
       "...            ...        ...    ...           ...             ...  \n",
       "1019          20.0          N    NaN   Nitin Menon       VK Sharma  \n",
       "1020          20.0          N    NaN  AK Chaudhary     CB Gaffaney  \n",
       "1021          20.0          N    NaN  BNJ Oxenford       VK Sharma  \n",
       "1022          20.0          N    NaN   Nitin Menon       RJ Tucker  \n",
       "1023          15.0          N    D/L   Nitin Menon       RJ Tucker  \n",
       "\n",
       "[1024 rows x 20 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "second_dataset = pd.read_csv(\"C:/Users/Loki/Documents/IPL 2024 Predictions/matches.csv\")\n",
    "second_dataset"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e4df3d1d-a865-4a50-a31a-169d2a9e9460",
   "metadata": {},
   "source": [
    "<font size=\"5\">Data Cleaning"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "39e84ba2-e0f9-417f-bf2b-be7a15e5de3b",
   "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>inning</th>\n",
       "      <th>total_runs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>335982</td>\n",
       "      <td>1</td>\n",
       "      <td>223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>335982</td>\n",
       "      <td>2</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>335983</td>\n",
       "      <td>1</td>\n",
       "      <td>241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>335983</td>\n",
       "      <td>2</td>\n",
       "      <td>208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>335984</td>\n",
       "      <td>1</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>335984</td>\n",
       "      <td>2</td>\n",
       "      <td>133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>335985</td>\n",
       "      <td>1</td>\n",
       "      <td>166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>335985</td>\n",
       "      <td>2</td>\n",
       "      <td>167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>335986</td>\n",
       "      <td>1</td>\n",
       "      <td>111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>335986</td>\n",
       "      <td>2</td>\n",
       "      <td>113</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   match_id  inning  total_runs\n",
       "0    335982       1         223\n",
       "1    335982       2          83\n",
       "2    335983       1         241\n",
       "3    335983       2         208\n",
       "4    335984       1         130\n",
       "5    335984       2         133\n",
       "6    335985       1         166\n",
       "7    335985       2         167\n",
       "8    335986       1         111\n",
       "9    335986       2         113"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Finding Total Runs Scored in each innings\n",
    "total_runs = first_dataset.groupby(['match_id','inning']).sum()['total_runs'].add(1).reset_index()\n",
    "total_runs.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "c889505d-0eef-4d43-a449-7cea831a4445",
   "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>inning</th>\n",
       "      <th>total_runs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>335982</td>\n",
       "      <td>1</td>\n",
       "      <td>223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>335983</td>\n",
       "      <td>1</td>\n",
       "      <td>241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>335984</td>\n",
       "      <td>1</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>335985</td>\n",
       "      <td>1</td>\n",
       "      <td>166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>335986</td>\n",
       "      <td>1</td>\n",
       "      <td>111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2065</th>\n",
       "      <td>1359544</td>\n",
       "      <td>1</td>\n",
       "      <td>198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2067</th>\n",
       "      <td>1370350</td>\n",
       "      <td>1</td>\n",
       "      <td>173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2069</th>\n",
       "      <td>1370351</td>\n",
       "      <td>1</td>\n",
       "      <td>183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2071</th>\n",
       "      <td>1370352</td>\n",
       "      <td>1</td>\n",
       "      <td>234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2073</th>\n",
       "      <td>1370353</td>\n",
       "      <td>1</td>\n",
       "      <td>215</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1024 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      match_id  inning  total_runs\n",
       "0       335982       1         223\n",
       "2       335983       1         241\n",
       "4       335984       1         130\n",
       "6       335985       1         166\n",
       "8       335986       1         111\n",
       "...        ...     ...         ...\n",
       "2065   1359544       1         198\n",
       "2067   1370350       1         173\n",
       "2069   1370351       1         183\n",
       "2071   1370352       1         234\n",
       "2073   1370353       1         215\n",
       "\n",
       "[1024 rows x 3 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#selecting only first innings to find target score for each match\n",
    "total_runs = total_runs[total_runs['inning'] == 1]\n",
    "total_runs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "3f115165-7302-41e1-b195-c1cafdd37846",
   "metadata": {},
   "outputs": [],
   "source": [
    "#merging total runs df with second dataset\n",
    "match_df = second_dataset.merge(total_runs[['match_id','total_runs']],left_on='id',right_on='match_id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "023f06b7-1077-455d-8c40-f612dd4e4827",
   "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>id</th>\n",
       "      <th>season</th>\n",
       "      <th>city</th>\n",
       "      <th>date</th>\n",
       "      <th>match_type</th>\n",
       "      <th>player_of_match</th>\n",
       "      <th>venue</th>\n",
       "      <th>team1</th>\n",
       "      <th>team2</th>\n",
       "      <th>toss_winner</th>\n",
       "      <th>...</th>\n",
       "      <th>result</th>\n",
       "      <th>result_margin</th>\n",
       "      <th>target_runs</th>\n",
       "      <th>target_overs</th>\n",
       "      <th>super_over</th>\n",
       "      <th>method</th>\n",
       "      <th>umpire1</th>\n",
       "      <th>umpire2</th>\n",
       "      <th>match_id</th>\n",
       "      <th>total_runs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>335982</td>\n",
       "      <td>2007/08</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>2008-04-18</td>\n",
       "      <td>League</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>...</td>\n",
       "      <td>runs</td>\n",
       "      <td>140.0</td>\n",
       "      <td>223.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Asad Rauf</td>\n",
       "      <td>RE Koertzen</td>\n",
       "      <td>335982</td>\n",
       "      <td>223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>335983</td>\n",
       "      <td>2007/08</td>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>2008-04-19</td>\n",
       "      <td>League</td>\n",
       "      <td>MEK Hussey</td>\n",
       "      <td>Punjab Cricket Association Stadium, Mohali</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>...</td>\n",
       "      <td>runs</td>\n",
       "      <td>33.0</td>\n",
       "      <td>241.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MR Benson</td>\n",
       "      <td>SL Shastri</td>\n",
       "      <td>335983</td>\n",
       "      <td>241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>335984</td>\n",
       "      <td>2007/08</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>2008-04-19</td>\n",
       "      <td>League</td>\n",
       "      <td>MF Maharoof</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>...</td>\n",
       "      <td>wickets</td>\n",
       "      <td>9.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aleem Dar</td>\n",
       "      <td>GA Pratapkumar</td>\n",
       "      <td>335984</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>335985</td>\n",
       "      <td>2007/08</td>\n",
       "      <td>Mumbai</td>\n",
       "      <td>2008-04-20</td>\n",
       "      <td>League</td>\n",
       "      <td>MV Boucher</td>\n",
       "      <td>Wankhede Stadium</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>...</td>\n",
       "      <td>wickets</td>\n",
       "      <td>5.0</td>\n",
       "      <td>166.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SJ Davis</td>\n",
       "      <td>DJ Harper</td>\n",
       "      <td>335985</td>\n",
       "      <td>166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>335986</td>\n",
       "      <td>2007/08</td>\n",
       "      <td>Kolkata</td>\n",
       "      <td>2008-04-20</td>\n",
       "      <td>League</td>\n",
       "      <td>DJ Hussey</td>\n",
       "      <td>Eden Gardens</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>Deccan Chargers</td>\n",
       "      <td>...</td>\n",
       "      <td>wickets</td>\n",
       "      <td>5.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BF Bowden</td>\n",
       "      <td>K Hariharan</td>\n",
       "      <td>335986</td>\n",
       "      <td>111</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>1019</th>\n",
       "      <td>1359544</td>\n",
       "      <td>2023</td>\n",
       "      <td>Bengaluru</td>\n",
       "      <td>2023-05-21</td>\n",
       "      <td>League</td>\n",
       "      <td>Shubman Gill</td>\n",
       "      <td>M Chinnaswamy Stadium, Bengaluru</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>...</td>\n",
       "      <td>wickets</td>\n",
       "      <td>6.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td>VK Sharma</td>\n",
       "      <td>1359544</td>\n",
       "      <td>198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1020</th>\n",
       "      <td>1370350</td>\n",
       "      <td>2023</td>\n",
       "      <td>Chennai</td>\n",
       "      <td>2023-05-23</td>\n",
       "      <td>Qualifier 1</td>\n",
       "      <td>RD Gaikwad</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk, Chennai</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>...</td>\n",
       "      <td>runs</td>\n",
       "      <td>15.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>AK Chaudhary</td>\n",
       "      <td>CB Gaffaney</td>\n",
       "      <td>1370350</td>\n",
       "      <td>173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1021</th>\n",
       "      <td>1370351</td>\n",
       "      <td>2023</td>\n",
       "      <td>Chennai</td>\n",
       "      <td>2023-05-24</td>\n",
       "      <td>Eliminator</td>\n",
       "      <td>Akash Madhwal</td>\n",
       "      <td>MA Chidambaram Stadium, Chepauk, Chennai</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Lucknow Super Giants</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>...</td>\n",
       "      <td>runs</td>\n",
       "      <td>81.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BNJ Oxenford</td>\n",
       "      <td>VK Sharma</td>\n",
       "      <td>1370351</td>\n",
       "      <td>183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1022</th>\n",
       "      <td>1370352</td>\n",
       "      <td>2023</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>2023-05-26</td>\n",
       "      <td>Qualifier 2</td>\n",
       "      <td>Shubman Gill</td>\n",
       "      <td>Narendra Modi Stadium, Ahmedabad</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>...</td>\n",
       "      <td>runs</td>\n",
       "      <td>62.0</td>\n",
       "      <td>234.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>N</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td>RJ Tucker</td>\n",
       "      <td>1370352</td>\n",
       "      <td>234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1023</th>\n",
       "      <td>1370353</td>\n",
       "      <td>2023</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>2023-05-29</td>\n",
       "      <td>Final</td>\n",
       "      <td>DP Conway</td>\n",
       "      <td>Narendra Modi Stadium, Ahmedabad</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>...</td>\n",
       "      <td>wickets</td>\n",
       "      <td>5.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>N</td>\n",
       "      <td>D/L</td>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td>RJ Tucker</td>\n",
       "      <td>1370353</td>\n",
       "      <td>215</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1024 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           id   season        city        date   match_type player_of_match  \\\n",
       "0      335982  2007/08   Bangalore  2008-04-18       League     BB McCullum   \n",
       "1      335983  2007/08  Chandigarh  2008-04-19       League      MEK Hussey   \n",
       "2      335984  2007/08       Delhi  2008-04-19       League     MF Maharoof   \n",
       "3      335985  2007/08      Mumbai  2008-04-20       League      MV Boucher   \n",
       "4      335986  2007/08     Kolkata  2008-04-20       League       DJ Hussey   \n",
       "...       ...      ...         ...         ...          ...             ...   \n",
       "1019  1359544     2023   Bengaluru  2023-05-21       League    Shubman Gill   \n",
       "1020  1370350     2023     Chennai  2023-05-23  Qualifier 1      RD Gaikwad   \n",
       "1021  1370351     2023     Chennai  2023-05-24   Eliminator   Akash Madhwal   \n",
       "1022  1370352     2023   Ahmedabad  2023-05-26  Qualifier 2    Shubman Gill   \n",
       "1023  1370353     2023   Ahmedabad  2023-05-29        Final       DP Conway   \n",
       "\n",
       "                                           venue                        team1  \\\n",
       "0                          M Chinnaswamy Stadium  Royal Challengers Bangalore   \n",
       "1     Punjab Cricket Association Stadium, Mohali              Kings XI Punjab   \n",
       "2                               Feroz Shah Kotla             Delhi Daredevils   \n",
       "3                               Wankhede Stadium               Mumbai Indians   \n",
       "4                                   Eden Gardens        Kolkata Knight Riders   \n",
       "...                                          ...                          ...   \n",
       "1019            M Chinnaswamy Stadium, Bengaluru  Royal Challengers Bangalore   \n",
       "1020    MA Chidambaram Stadium, Chepauk, Chennai          Chennai Super Kings   \n",
       "1021    MA Chidambaram Stadium, Chepauk, Chennai               Mumbai Indians   \n",
       "1022            Narendra Modi Stadium, Ahmedabad               Gujarat Titans   \n",
       "1023            Narendra Modi Stadium, Ahmedabad               Gujarat Titans   \n",
       "\n",
       "                            team2                  toss_winner  ...   result  \\\n",
       "0           Kolkata Knight Riders  Royal Challengers Bangalore  ...     runs   \n",
       "1             Chennai Super Kings          Chennai Super Kings  ...     runs   \n",
       "2                Rajasthan Royals             Rajasthan Royals  ...  wickets   \n",
       "3     Royal Challengers Bangalore               Mumbai Indians  ...  wickets   \n",
       "4                 Deccan Chargers              Deccan Chargers  ...  wickets   \n",
       "...                           ...                          ...  ...      ...   \n",
       "1019               Gujarat Titans               Gujarat Titans  ...  wickets   \n",
       "1020               Gujarat Titans               Gujarat Titans  ...     runs   \n",
       "1021         Lucknow Super Giants               Mumbai Indians  ...     runs   \n",
       "1022               Mumbai Indians               Mumbai Indians  ...     runs   \n",
       "1023          Chennai Super Kings          Chennai Super Kings  ...  wickets   \n",
       "\n",
       "     result_margin target_runs  target_overs  super_over  method  \\\n",
       "0            140.0       223.0          20.0           N     NaN   \n",
       "1             33.0       241.0          20.0           N     NaN   \n",
       "2              9.0       130.0          20.0           N     NaN   \n",
       "3              5.0       166.0          20.0           N     NaN   \n",
       "4              5.0       111.0          20.0           N     NaN   \n",
       "...            ...         ...           ...         ...     ...   \n",
       "1019           6.0       198.0          20.0           N     NaN   \n",
       "1020          15.0       173.0          20.0           N     NaN   \n",
       "1021          81.0       183.0          20.0           N     NaN   \n",
       "1022          62.0       234.0          20.0           N     NaN   \n",
       "1023           5.0       171.0          15.0           N     D/L   \n",
       "\n",
       "           umpire1         umpire2 match_id total_runs  \n",
       "0        Asad Rauf     RE Koertzen   335982        223  \n",
       "1        MR Benson      SL Shastri   335983        241  \n",
       "2        Aleem Dar  GA Pratapkumar   335984        130  \n",
       "3         SJ Davis       DJ Harper   335985        166  \n",
       "4        BF Bowden     K Hariharan   335986        111  \n",
       "...            ...             ...      ...        ...  \n",
       "1019   Nitin Menon       VK Sharma  1359544        198  \n",
       "1020  AK Chaudhary     CB Gaffaney  1370350        173  \n",
       "1021  BNJ Oxenford       VK Sharma  1370351        183  \n",
       "1022   Nitin Menon       RJ Tucker  1370352        234  \n",
       "1023   Nitin Menon       RJ Tucker  1370353        215  \n",
       "\n",
       "[1024 rows x 22 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "match_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "506dcb4c-63dc-4d8a-bfcd-354565b6b9fd",
   "metadata": {},
   "outputs": [],
   "source": [
    "match_df = match_df[['match_id','city','winner','total_runs']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "dce186dc-fe5e-4c02-9556-ebc6e1c00916",
   "metadata": {},
   "outputs": [],
   "source": [
    "match_df = match_df.rename(columns={'id':'match_id'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "c77643b4-c665-4111-b50f-270c7400919b",
   "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>city</th>\n",
       "      <th>winner</th>\n",
       "      <th>total_runs_x</th>\n",
       "      <th>inning</th>\n",
       "      <th>batting_team</th>\n",
       "      <th>bowling_team</th>\n",
       "      <th>over</th>\n",
       "      <th>ball</th>\n",
       "      <th>batter</th>\n",
       "      <th>bowler</th>\n",
       "      <th>non_striker</th>\n",
       "      <th>batsman_runs</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs_y</th>\n",
       "      <th>extras_type</th>\n",
       "      <th>is_wicket</th>\n",
       "      <th>player_dismissed</th>\n",
       "      <th>dismissal_kind</th>\n",
       "      <th>fielder</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>1</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>SC Ganguly</td>\n",
       "      <td>P Kumar</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>legbyes</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>1</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>P Kumar</td>\n",
       "      <td>SC Ganguly</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>1</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>P Kumar</td>\n",
       "      <td>SC Ganguly</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>wides</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>1</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>P Kumar</td>\n",
       "      <td>SC Ganguly</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>1</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>BB McCullum</td>\n",
       "      <td>P Kumar</td>\n",
       "      <td>SC Ganguly</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243812</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>MM Sharma</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243813</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>MM Sharma</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243814</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>MM Sharma</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243815</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>MM Sharma</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243816</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>MM Sharma</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>243817 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id       city                 winner  total_runs_x  inning  \\\n",
       "0         335982  Bangalore  Kolkata Knight Riders           223       1   \n",
       "1         335982  Bangalore  Kolkata Knight Riders           223       1   \n",
       "2         335982  Bangalore  Kolkata Knight Riders           223       1   \n",
       "3         335982  Bangalore  Kolkata Knight Riders           223       1   \n",
       "4         335982  Bangalore  Kolkata Knight Riders           223       1   \n",
       "...          ...        ...                    ...           ...     ...   \n",
       "243812   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243813   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243814   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243815   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243816   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "\n",
       "                 batting_team                 bowling_team  over  ball  \\\n",
       "0       Kolkata Knight Riders  Royal Challengers Bangalore     0     1   \n",
       "1       Kolkata Knight Riders  Royal Challengers Bangalore     0     2   \n",
       "2       Kolkata Knight Riders  Royal Challengers Bangalore     0     3   \n",
       "3       Kolkata Knight Riders  Royal Challengers Bangalore     0     4   \n",
       "4       Kolkata Knight Riders  Royal Challengers Bangalore     0     5   \n",
       "...                       ...                          ...   ...   ...   \n",
       "243812    Chennai Super Kings               Gujarat Titans    14     2   \n",
       "243813    Chennai Super Kings               Gujarat Titans    14     3   \n",
       "243814    Chennai Super Kings               Gujarat Titans    14     4   \n",
       "243815    Chennai Super Kings               Gujarat Titans    14     5   \n",
       "243816    Chennai Super Kings               Gujarat Titans    14     6   \n",
       "\n",
       "             batter     bowler  non_striker  batsman_runs  extra_runs  \\\n",
       "0        SC Ganguly    P Kumar  BB McCullum             0           1   \n",
       "1       BB McCullum    P Kumar   SC Ganguly             0           0   \n",
       "2       BB McCullum    P Kumar   SC Ganguly             0           1   \n",
       "3       BB McCullum    P Kumar   SC Ganguly             0           0   \n",
       "4       BB McCullum    P Kumar   SC Ganguly             0           0   \n",
       "...             ...        ...          ...           ...         ...   \n",
       "243812       S Dube  MM Sharma    RA Jadeja             1           0   \n",
       "243813    RA Jadeja  MM Sharma       S Dube             1           0   \n",
       "243814       S Dube  MM Sharma    RA Jadeja             1           0   \n",
       "243815    RA Jadeja  MM Sharma       S Dube             6           0   \n",
       "243816    RA Jadeja  MM Sharma       S Dube             4           0   \n",
       "\n",
       "        total_runs_y extras_type  is_wicket player_dismissed dismissal_kind  \\\n",
       "0                  1     legbyes          0              NaN            NaN   \n",
       "1                  0         NaN          0              NaN            NaN   \n",
       "2                  1       wides          0              NaN            NaN   \n",
       "3                  0         NaN          0              NaN            NaN   \n",
       "4                  0         NaN          0              NaN            NaN   \n",
       "...              ...         ...        ...              ...            ...   \n",
       "243812             1         NaN          0              NaN            NaN   \n",
       "243813             1         NaN          0              NaN            NaN   \n",
       "243814             1         NaN          0              NaN            NaN   \n",
       "243815             6         NaN          0              NaN            NaN   \n",
       "243816             4         NaN          0              NaN            NaN   \n",
       "\n",
       "       fielder  \n",
       "0          NaN  \n",
       "1          NaN  \n",
       "2          NaN  \n",
       "3          NaN  \n",
       "4          NaN  \n",
       "...        ...  \n",
       "243812     NaN  \n",
       "243813     NaN  \n",
       "243814     NaN  \n",
       "243815     NaN  \n",
       "243816     NaN  \n",
       "\n",
       "[243817 rows x 20 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "second_innings = match_df.merge(first_dataset,on='match_id')\n",
    "second_innings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "d1732315-8314-40f1-ba1a-5c00be7f03d3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(117531, 20)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "second_innings = second_innings[second_innings['inning']==2]\n",
    "second_innings.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e2b068b2-df6c-478e-aad8-849ca6043a07",
   "metadata": {},
   "source": [
    "Data Cleaning (removing old and repeating teams)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "ec202d0c-1e87-4681-a88f-ff77e0523d1a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "batting_team\n",
       "Kolkata Knight Riders          14310\n",
       "Mumbai Indians                 13680\n",
       "Royal Challengers Bangalore    13426\n",
       "Rajasthan Royals               12290\n",
       "Chennai Super Kings            11838\n",
       "Kings XI Punjab                10753\n",
       "Delhi Daredevils               10027\n",
       "Sunrisers Hyderabad             9518\n",
       "Delhi Capitals                  5061\n",
       "Deccan Chargers                 3754\n",
       "Pune Warriors                   2995\n",
       "Gujarat Titans                  2143\n",
       "Gujarat Lions                   1832\n",
       "Lucknow Super Giants            1805\n",
       "Punjab Kings                    1756\n",
       "Rising Pune Supergiant           906\n",
       "Rising Pune Supergiants          731\n",
       "Kochi Tuskers Kerala             706\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "second_innings['batting_team'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "c36c8f6f-a2ad-4301-ae96-da956eb3556b",
   "metadata": {},
   "outputs": [],
   "source": [
    "teams = ['Kolkata Knight Riders', \n",
    "         'Chennai Super Kings',\n",
    "         'Punjab Kings', \n",
    "         'Rajasthan Royals',\n",
    "         'Mumbai Indians',\n",
    "         'Delhi Capitals',\n",
    "         'Royal Challengers Bangalore',\n",
    "         'Sunrisers Hyderabad',\n",
    "         'Lucknow Super Giants',\n",
    "         'Gujarat Titans'\n",
    "         ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "b7d5c6f2-e86b-440f-8ccf-fc8ca97a0410",
   "metadata": {},
   "outputs": [],
   "source": [
    "second_innings['batting_team'] = second_innings['batting_team'].str.replace('Delhi Daredevils','Delhi Capitals')\n",
    "second_innings['bowling_team'] = second_innings['bowling_team'].str.replace('Delhi Daredevils','Delhi Capitals')\n",
    "\n",
    "second_innings['batting_team'] = second_innings['batting_team'].str.replace('Deccan Chargers','Sunrisers Hyderabad')\n",
    "second_innings['bowling_team'] = second_innings['bowling_team'].str.replace('Deccan Chargers','Sunrisers Hyderabad')\n",
    "\n",
    "second_innings['batting_team'] = second_innings['batting_team'].str.replace('Kings XI Punjab','Punjab Kings')\n",
    "second_innings['bowling_team'] = second_innings['bowling_team'].str.replace('Kings XI Punjab','Punjab Kings')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "7c9e199f-b2a1-47a0-a6ad-afd4a881bc93",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Royal Challengers Bangalore', 'Punjab Kings', 'Delhi Capitals',\n",
       "       'Kolkata Knight Riders', 'Rajasthan Royals', 'Mumbai Indians',\n",
       "       'Chennai Super Kings', 'Sunrisers Hyderabad', 'Pune Warriors',\n",
       "       'Kochi Tuskers Kerala', 'Rising Pune Supergiants', 'Gujarat Lions',\n",
       "       'Rising Pune Supergiant', 'Gujarat Titans', 'Lucknow Super Giants'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "second_innings['batting_team'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "30763f65-42a4-49a8-8222-b696bdef8cb6",
   "metadata": {},
   "outputs": [],
   "source": [
    "second_innings = second_innings[second_innings['batting_team'].isin(teams)]\n",
    "second_innings = second_innings[second_innings['bowling_team'].isin(teams)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "f2624cbe-5ee2-4888-844d-c87a02fdc6cd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Royal Challengers Bangalore', 'Punjab Kings', 'Delhi Capitals',\n",
       "       'Kolkata Knight Riders', 'Rajasthan Royals', 'Mumbai Indians',\n",
       "       'Chennai Super Kings', 'Sunrisers Hyderabad', 'Gujarat Titans',\n",
       "       'Lucknow Super Giants'], dtype=object)"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "second_innings['batting_team'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "3b3957aa-8bf1-4686-8dab-ca6af130e199",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(104595, 20)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "second_innings.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "61ee6f15-f403-477c-953b-b36d22424679",
   "metadata": {},
   "outputs": [],
   "source": [
    "#finding current score with cumsum method\n",
    "second_innings['current_Score'] = second_innings.groupby('match_id')['total_runs_y'].cumsum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "bc799a1e-67df-4e37-bd31-c025434e3238",
   "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>city</th>\n",
       "      <th>winner</th>\n",
       "      <th>total_runs_x</th>\n",
       "      <th>inning</th>\n",
       "      <th>batting_team</th>\n",
       "      <th>bowling_team</th>\n",
       "      <th>over</th>\n",
       "      <th>ball</th>\n",
       "      <th>batter</th>\n",
       "      <th>...</th>\n",
       "      <th>non_striker</th>\n",
       "      <th>batsman_runs</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs_y</th>\n",
       "      <th>extras_type</th>\n",
       "      <th>is_wicket</th>\n",
       "      <th>player_dismissed</th>\n",
       "      <th>dismissal_kind</th>\n",
       "      <th>fielder</th>\n",
       "      <th>current_Score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>wides</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</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>243812</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243813</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243814</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243815</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243816</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>171</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104595 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id       city                 winner  total_runs_x  inning  \\\n",
       "124       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "125       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "126       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "127       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "128       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "...          ...        ...                    ...           ...     ...   \n",
       "243812   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243813   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243814   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243815   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243816   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "\n",
       "                       batting_team           bowling_team  over  ball  \\\n",
       "124     Royal Challengers Bangalore  Kolkata Knight Riders     0     1   \n",
       "125     Royal Challengers Bangalore  Kolkata Knight Riders     0     2   \n",
       "126     Royal Challengers Bangalore  Kolkata Knight Riders     0     3   \n",
       "127     Royal Challengers Bangalore  Kolkata Knight Riders     0     4   \n",
       "128     Royal Challengers Bangalore  Kolkata Knight Riders     0     5   \n",
       "...                             ...                    ...   ...   ...   \n",
       "243812          Chennai Super Kings         Gujarat Titans    14     2   \n",
       "243813          Chennai Super Kings         Gujarat Titans    14     3   \n",
       "243814          Chennai Super Kings         Gujarat Titans    14     4   \n",
       "243815          Chennai Super Kings         Gujarat Titans    14     5   \n",
       "243816          Chennai Super Kings         Gujarat Titans    14     6   \n",
       "\n",
       "           batter  ... non_striker batsman_runs  extra_runs  total_runs_y  \\\n",
       "124      R Dravid  ...    W Jaffer            1           0             1   \n",
       "125      W Jaffer  ...    R Dravid            0           1             1   \n",
       "126      W Jaffer  ...    R Dravid            0           0             0   \n",
       "127      W Jaffer  ...    R Dravid            1           0             1   \n",
       "128      R Dravid  ...    W Jaffer            1           0             1   \n",
       "...           ...  ...         ...          ...         ...           ...   \n",
       "243812     S Dube  ...   RA Jadeja            1           0             1   \n",
       "243813  RA Jadeja  ...      S Dube            1           0             1   \n",
       "243814     S Dube  ...   RA Jadeja            1           0             1   \n",
       "243815  RA Jadeja  ...      S Dube            6           0             6   \n",
       "243816  RA Jadeja  ...      S Dube            4           0             4   \n",
       "\n",
       "        extras_type is_wicket  player_dismissed dismissal_kind fielder  \\\n",
       "124             NaN         0               NaN            NaN     NaN   \n",
       "125           wides         0               NaN            NaN     NaN   \n",
       "126             NaN         0               NaN            NaN     NaN   \n",
       "127             NaN         0               NaN            NaN     NaN   \n",
       "128             NaN         0               NaN            NaN     NaN   \n",
       "...             ...       ...               ...            ...     ...   \n",
       "243812          NaN         0               NaN            NaN     NaN   \n",
       "243813          NaN         0               NaN            NaN     NaN   \n",
       "243814          NaN         0               NaN            NaN     NaN   \n",
       "243815          NaN         0               NaN            NaN     NaN   \n",
       "243816          NaN         0               NaN            NaN     NaN   \n",
       "\n",
       "       current_Score  \n",
       "124                1  \n",
       "125                2  \n",
       "126                2  \n",
       "127                3  \n",
       "128                4  \n",
       "...              ...  \n",
       "243812           159  \n",
       "243813           160  \n",
       "243814           161  \n",
       "243815           167  \n",
       "243816           171  \n",
       "\n",
       "[104595 rows x 21 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "second_innings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "acc3a2de-fcb0-4eee-9ff2-59734b75a160",
   "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>city</th>\n",
       "      <th>winner</th>\n",
       "      <th>total_runs_x</th>\n",
       "      <th>inning</th>\n",
       "      <th>batting_team</th>\n",
       "      <th>bowling_team</th>\n",
       "      <th>over</th>\n",
       "      <th>ball</th>\n",
       "      <th>batter</th>\n",
       "      <th>...</th>\n",
       "      <th>batsman_runs</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs_y</th>\n",
       "      <th>extras_type</th>\n",
       "      <th>is_wicket</th>\n",
       "      <th>player_dismissed</th>\n",
       "      <th>dismissal_kind</th>\n",
       "      <th>fielder</th>\n",
       "      <th>current_Score</th>\n",
       "      <th>runs_left</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>wides</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>219</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>243812</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>159</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243813</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>160</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243814</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>161</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243815</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243816</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>171</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104595 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id       city                 winner  total_runs_x  inning  \\\n",
       "124       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "125       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "126       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "127       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "128       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "...          ...        ...                    ...           ...     ...   \n",
       "243812   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243813   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243814   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243815   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243816   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "\n",
       "                       batting_team           bowling_team  over  ball  \\\n",
       "124     Royal Challengers Bangalore  Kolkata Knight Riders     0     1   \n",
       "125     Royal Challengers Bangalore  Kolkata Knight Riders     0     2   \n",
       "126     Royal Challengers Bangalore  Kolkata Knight Riders     0     3   \n",
       "127     Royal Challengers Bangalore  Kolkata Knight Riders     0     4   \n",
       "128     Royal Challengers Bangalore  Kolkata Knight Riders     0     5   \n",
       "...                             ...                    ...   ...   ...   \n",
       "243812          Chennai Super Kings         Gujarat Titans    14     2   \n",
       "243813          Chennai Super Kings         Gujarat Titans    14     3   \n",
       "243814          Chennai Super Kings         Gujarat Titans    14     4   \n",
       "243815          Chennai Super Kings         Gujarat Titans    14     5   \n",
       "243816          Chennai Super Kings         Gujarat Titans    14     6   \n",
       "\n",
       "           batter  ... batsman_runs extra_runs  total_runs_y  extras_type  \\\n",
       "124      R Dravid  ...            1          0             1          NaN   \n",
       "125      W Jaffer  ...            0          1             1        wides   \n",
       "126      W Jaffer  ...            0          0             0          NaN   \n",
       "127      W Jaffer  ...            1          0             1          NaN   \n",
       "128      R Dravid  ...            1          0             1          NaN   \n",
       "...           ...  ...          ...        ...           ...          ...   \n",
       "243812     S Dube  ...            1          0             1          NaN   \n",
       "243813  RA Jadeja  ...            1          0             1          NaN   \n",
       "243814     S Dube  ...            1          0             1          NaN   \n",
       "243815  RA Jadeja  ...            6          0             6          NaN   \n",
       "243816  RA Jadeja  ...            4          0             4          NaN   \n",
       "\n",
       "        is_wicket player_dismissed  dismissal_kind fielder current_Score  \\\n",
       "124             0              NaN             NaN     NaN             1   \n",
       "125             0              NaN             NaN     NaN             2   \n",
       "126             0              NaN             NaN     NaN             2   \n",
       "127             0              NaN             NaN     NaN             3   \n",
       "128             0              NaN             NaN     NaN             4   \n",
       "...           ...              ...             ...     ...           ...   \n",
       "243812          0              NaN             NaN     NaN           159   \n",
       "243813          0              NaN             NaN     NaN           160   \n",
       "243814          0              NaN             NaN     NaN           161   \n",
       "243815          0              NaN             NaN     NaN           167   \n",
       "243816          0              NaN             NaN     NaN           171   \n",
       "\n",
       "       runs_left  \n",
       "124          222  \n",
       "125          221  \n",
       "126          221  \n",
       "127          220  \n",
       "128          219  \n",
       "...          ...  \n",
       "243812        56  \n",
       "243813        55  \n",
       "243814        54  \n",
       "243815        48  \n",
       "243816        44  \n",
       "\n",
       "[104595 rows x 22 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#calculate runs left after each ball using target and currenct score\n",
    "second_innings['runs_left'] = second_innings['total_runs_x'] - second_innings['current_Score']\n",
    "second_innings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "a4755676-4955-4d36-809e-748f4a23f547",
   "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>city</th>\n",
       "      <th>winner</th>\n",
       "      <th>total_runs_x</th>\n",
       "      <th>inning</th>\n",
       "      <th>batting_team</th>\n",
       "      <th>bowling_team</th>\n",
       "      <th>over</th>\n",
       "      <th>ball</th>\n",
       "      <th>batter</th>\n",
       "      <th>...</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs_y</th>\n",
       "      <th>extras_type</th>\n",
       "      <th>is_wicket</th>\n",
       "      <th>player_dismissed</th>\n",
       "      <th>dismissal_kind</th>\n",
       "      <th>fielder</th>\n",
       "      <th>current_Score</th>\n",
       "      <th>runs_left</th>\n",
       "      <th>balls_left</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>222</td>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>wides</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>221</td>\n",
       "      <td>118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>221</td>\n",
       "      <td>117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>220</td>\n",
       "      <td>116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>219</td>\n",
       "      <td>115</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>243812</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>159</td>\n",
       "      <td>56</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243813</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>160</td>\n",
       "      <td>55</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243814</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>161</td>\n",
       "      <td>54</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243815</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167</td>\n",
       "      <td>48</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243816</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>171</td>\n",
       "      <td>44</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104595 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id       city                 winner  total_runs_x  inning  \\\n",
       "124       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "125       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "126       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "127       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "128       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "...          ...        ...                    ...           ...     ...   \n",
       "243812   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243813   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243814   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243815   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243816   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "\n",
       "                       batting_team           bowling_team  over  ball  \\\n",
       "124     Royal Challengers Bangalore  Kolkata Knight Riders     0     1   \n",
       "125     Royal Challengers Bangalore  Kolkata Knight Riders     0     2   \n",
       "126     Royal Challengers Bangalore  Kolkata Knight Riders     0     3   \n",
       "127     Royal Challengers Bangalore  Kolkata Knight Riders     0     4   \n",
       "128     Royal Challengers Bangalore  Kolkata Knight Riders     0     5   \n",
       "...                             ...                    ...   ...   ...   \n",
       "243812          Chennai Super Kings         Gujarat Titans    14     2   \n",
       "243813          Chennai Super Kings         Gujarat Titans    14     3   \n",
       "243814          Chennai Super Kings         Gujarat Titans    14     4   \n",
       "243815          Chennai Super Kings         Gujarat Titans    14     5   \n",
       "243816          Chennai Super Kings         Gujarat Titans    14     6   \n",
       "\n",
       "           batter  ... extra_runs total_runs_y  extras_type  is_wicket  \\\n",
       "124      R Dravid  ...          0            1          NaN          0   \n",
       "125      W Jaffer  ...          1            1        wides          0   \n",
       "126      W Jaffer  ...          0            0          NaN          0   \n",
       "127      W Jaffer  ...          0            1          NaN          0   \n",
       "128      R Dravid  ...          0            1          NaN          0   \n",
       "...           ...  ...        ...          ...          ...        ...   \n",
       "243812     S Dube  ...          0            1          NaN          0   \n",
       "243813  RA Jadeja  ...          0            1          NaN          0   \n",
       "243814     S Dube  ...          0            1          NaN          0   \n",
       "243815  RA Jadeja  ...          0            6          NaN          0   \n",
       "243816  RA Jadeja  ...          0            4          NaN          0   \n",
       "\n",
       "        player_dismissed dismissal_kind  fielder current_Score runs_left  \\\n",
       "124                  NaN            NaN      NaN             1       222   \n",
       "125                  NaN            NaN      NaN             2       221   \n",
       "126                  NaN            NaN      NaN             2       221   \n",
       "127                  NaN            NaN      NaN             3       220   \n",
       "128                  NaN            NaN      NaN             4       219   \n",
       "...                  ...            ...      ...           ...       ...   \n",
       "243812               NaN            NaN      NaN           159        56   \n",
       "243813               NaN            NaN      NaN           160        55   \n",
       "243814               NaN            NaN      NaN           161        54   \n",
       "243815               NaN            NaN      NaN           167        48   \n",
       "243816               NaN            NaN      NaN           171        44   \n",
       "\n",
       "       balls_left  \n",
       "124           119  \n",
       "125           118  \n",
       "126           117  \n",
       "127           116  \n",
       "128           115  \n",
       "...           ...  \n",
       "243812         34  \n",
       "243813         33  \n",
       "243814         32  \n",
       "243815         31  \n",
       "243816         30  \n",
       "\n",
       "[104595 rows x 23 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#calculating balls left after each ball \n",
    "second_innings['balls_left'] = 120 - (second_innings['over']*6 +second_innings['ball'])\n",
    "second_innings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "1c87844e-735d-4b18-a165-13313087e0d0",
   "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>city</th>\n",
       "      <th>winner</th>\n",
       "      <th>total_runs_x</th>\n",
       "      <th>inning</th>\n",
       "      <th>batting_team</th>\n",
       "      <th>bowling_team</th>\n",
       "      <th>over</th>\n",
       "      <th>ball</th>\n",
       "      <th>batter</th>\n",
       "      <th>...</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs_y</th>\n",
       "      <th>extras_type</th>\n",
       "      <th>is_wicket</th>\n",
       "      <th>player_dismissed</th>\n",
       "      <th>dismissal_kind</th>\n",
       "      <th>fielder</th>\n",
       "      <th>current_Score</th>\n",
       "      <th>runs_left</th>\n",
       "      <th>balls_left</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>222</td>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>wides</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>221</td>\n",
       "      <td>118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>221</td>\n",
       "      <td>117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>220</td>\n",
       "      <td>116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>219</td>\n",
       "      <td>115</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>243812</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>159</td>\n",
       "      <td>56</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243813</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>160</td>\n",
       "      <td>55</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243814</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>161</td>\n",
       "      <td>54</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243815</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167</td>\n",
       "      <td>48</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243816</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>171</td>\n",
       "      <td>44</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104595 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id       city                 winner  total_runs_x  inning  \\\n",
       "124       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "125       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "126       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "127       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "128       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "...          ...        ...                    ...           ...     ...   \n",
       "243812   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243813   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243814   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243815   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243816   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "\n",
       "                       batting_team           bowling_team  over  ball  \\\n",
       "124     Royal Challengers Bangalore  Kolkata Knight Riders     0     1   \n",
       "125     Royal Challengers Bangalore  Kolkata Knight Riders     0     2   \n",
       "126     Royal Challengers Bangalore  Kolkata Knight Riders     0     3   \n",
       "127     Royal Challengers Bangalore  Kolkata Knight Riders     0     4   \n",
       "128     Royal Challengers Bangalore  Kolkata Knight Riders     0     5   \n",
       "...                             ...                    ...   ...   ...   \n",
       "243812          Chennai Super Kings         Gujarat Titans    14     2   \n",
       "243813          Chennai Super Kings         Gujarat Titans    14     3   \n",
       "243814          Chennai Super Kings         Gujarat Titans    14     4   \n",
       "243815          Chennai Super Kings         Gujarat Titans    14     5   \n",
       "243816          Chennai Super Kings         Gujarat Titans    14     6   \n",
       "\n",
       "           batter  ... extra_runs total_runs_y  extras_type  is_wicket  \\\n",
       "124      R Dravid  ...          0            1          NaN          0   \n",
       "125      W Jaffer  ...          1            1        wides          0   \n",
       "126      W Jaffer  ...          0            0          NaN          0   \n",
       "127      W Jaffer  ...          0            1          NaN          0   \n",
       "128      R Dravid  ...          0            1          NaN          0   \n",
       "...           ...  ...        ...          ...          ...        ...   \n",
       "243812     S Dube  ...          0            1          NaN          0   \n",
       "243813  RA Jadeja  ...          0            1          NaN          0   \n",
       "243814     S Dube  ...          0            1          NaN          0   \n",
       "243815  RA Jadeja  ...          0            6          NaN          0   \n",
       "243816  RA Jadeja  ...          0            4          NaN          0   \n",
       "\n",
       "        player_dismissed dismissal_kind  fielder current_Score runs_left  \\\n",
       "124                  NaN            NaN      NaN             1       222   \n",
       "125                  NaN            NaN      NaN             2       221   \n",
       "126                  NaN            NaN      NaN             2       221   \n",
       "127                  NaN            NaN      NaN             3       220   \n",
       "128                  NaN            NaN      NaN             4       219   \n",
       "...                  ...            ...      ...           ...       ...   \n",
       "243812               NaN            NaN      NaN           159        56   \n",
       "243813               NaN            NaN      NaN           160        55   \n",
       "243814               NaN            NaN      NaN           161        54   \n",
       "243815               NaN            NaN      NaN           167        48   \n",
       "243816               NaN            NaN      NaN           171        44   \n",
       "\n",
       "       balls_left  \n",
       "124           119  \n",
       "125           118  \n",
       "126           117  \n",
       "127           116  \n",
       "128           115  \n",
       "...           ...  \n",
       "243812         34  \n",
       "243813         33  \n",
       "243814         32  \n",
       "243815         31  \n",
       "243816         30  \n",
       "\n",
       "[104595 rows x 23 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "second_innings"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5d31cc80-5946-42fd-b9d1-6c79196d98e4",
   "metadata": {},
   "source": [
    "Getting Wickets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "23439b16-7124-4044-ae16-0d6d40a225a0",
   "metadata": {},
   "outputs": [],
   "source": [
    "#calculate the wickets left \n",
    "#filling nan values with 0 \n",
    "second_innings['player_dismissed'] = second_innings['player_dismissed'].fillna(\"0\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "82e035d6-1bcb-4e16-a922-56a0727a1e3d",
   "metadata": {},
   "outputs": [],
   "source": [
    "#filling where 0 is not there and there is a wicket with 1 \n",
    "second_innings['player_dismissed'] = second_innings['player_dismissed'].apply(lambda x:x if x==\"0\" else \"1\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "c1e39be5-83d6-4f79-a125-73f51293df3c",
   "metadata": {},
   "outputs": [],
   "source": [
    "#converting the type to int\n",
    "second_innings['player_dismissed'] = second_innings['player_dismissed'].astype('int')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "34d32689-7780-4cc8-b09e-3268c10aacdc",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Perform cumulative sum operation\n",
    "wickets = second_innings.groupby('match_id')['player_dismissed'].cumsum()\n",
    "\n",
    "\n",
    "# Calculate wickets remaining\n",
    "second_innings['wickets_remaining'] = 10 - wickets\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "364b570f-8ee6-4566-92f3-c37d9a5b588d",
   "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>city</th>\n",
       "      <th>winner</th>\n",
       "      <th>total_runs_x</th>\n",
       "      <th>inning</th>\n",
       "      <th>batting_team</th>\n",
       "      <th>bowling_team</th>\n",
       "      <th>over</th>\n",
       "      <th>ball</th>\n",
       "      <th>batter</th>\n",
       "      <th>...</th>\n",
       "      <th>total_runs_y</th>\n",
       "      <th>extras_type</th>\n",
       "      <th>is_wicket</th>\n",
       "      <th>player_dismissed</th>\n",
       "      <th>dismissal_kind</th>\n",
       "      <th>fielder</th>\n",
       "      <th>current_Score</th>\n",
       "      <th>runs_left</th>\n",
       "      <th>balls_left</th>\n",
       "      <th>wickets_remaining</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>222</td>\n",
       "      <td>119</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>wides</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>221</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>221</td>\n",
       "      <td>117</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>220</td>\n",
       "      <td>116</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>219</td>\n",
       "      <td>115</td>\n",
       "      <td>10</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>243812</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>159</td>\n",
       "      <td>56</td>\n",
       "      <td>34</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243813</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>160</td>\n",
       "      <td>55</td>\n",
       "      <td>33</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243814</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>161</td>\n",
       "      <td>54</td>\n",
       "      <td>32</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243815</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167</td>\n",
       "      <td>48</td>\n",
       "      <td>31</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243816</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>171</td>\n",
       "      <td>44</td>\n",
       "      <td>30</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104595 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id       city                 winner  total_runs_x  inning  \\\n",
       "124       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "125       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "126       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "127       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "128       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "...          ...        ...                    ...           ...     ...   \n",
       "243812   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243813   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243814   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243815   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243816   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "\n",
       "                       batting_team           bowling_team  over  ball  \\\n",
       "124     Royal Challengers Bangalore  Kolkata Knight Riders     0     1   \n",
       "125     Royal Challengers Bangalore  Kolkata Knight Riders     0     2   \n",
       "126     Royal Challengers Bangalore  Kolkata Knight Riders     0     3   \n",
       "127     Royal Challengers Bangalore  Kolkata Knight Riders     0     4   \n",
       "128     Royal Challengers Bangalore  Kolkata Knight Riders     0     5   \n",
       "...                             ...                    ...   ...   ...   \n",
       "243812          Chennai Super Kings         Gujarat Titans    14     2   \n",
       "243813          Chennai Super Kings         Gujarat Titans    14     3   \n",
       "243814          Chennai Super Kings         Gujarat Titans    14     4   \n",
       "243815          Chennai Super Kings         Gujarat Titans    14     5   \n",
       "243816          Chennai Super Kings         Gujarat Titans    14     6   \n",
       "\n",
       "           batter  ... total_runs_y extras_type  is_wicket  player_dismissed  \\\n",
       "124      R Dravid  ...            1         NaN          0                 0   \n",
       "125      W Jaffer  ...            1       wides          0                 0   \n",
       "126      W Jaffer  ...            0         NaN          0                 0   \n",
       "127      W Jaffer  ...            1         NaN          0                 0   \n",
       "128      R Dravid  ...            1         NaN          0                 0   \n",
       "...           ...  ...          ...         ...        ...               ...   \n",
       "243812     S Dube  ...            1         NaN          0                 0   \n",
       "243813  RA Jadeja  ...            1         NaN          0                 0   \n",
       "243814     S Dube  ...            1         NaN          0                 0   \n",
       "243815  RA Jadeja  ...            6         NaN          0                 0   \n",
       "243816  RA Jadeja  ...            4         NaN          0                 0   \n",
       "\n",
       "        dismissal_kind fielder  current_Score  runs_left balls_left  \\\n",
       "124                NaN     NaN              1        222        119   \n",
       "125                NaN     NaN              2        221        118   \n",
       "126                NaN     NaN              2        221        117   \n",
       "127                NaN     NaN              3        220        116   \n",
       "128                NaN     NaN              4        219        115   \n",
       "...                ...     ...            ...        ...        ...   \n",
       "243812             NaN     NaN            159         56         34   \n",
       "243813             NaN     NaN            160         55         33   \n",
       "243814             NaN     NaN            161         54         32   \n",
       "243815             NaN     NaN            167         48         31   \n",
       "243816             NaN     NaN            171         44         30   \n",
       "\n",
       "       wickets_remaining  \n",
       "124                   10  \n",
       "125                   10  \n",
       "126                   10  \n",
       "127                   10  \n",
       "128                   10  \n",
       "...                  ...  \n",
       "243812                 5  \n",
       "243813                 5  \n",
       "243814                 5  \n",
       "243815                 5  \n",
       "243816                 5  \n",
       "\n",
       "[104595 rows x 24 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "second_innings"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8f67f546-0229-4e85-b01c-6088731c05cd",
   "metadata": {},
   "source": [
    "Current Run Rate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "68757309-1677-47d5-9f82-aa21d40f3480",
   "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>city</th>\n",
       "      <th>winner</th>\n",
       "      <th>total_runs_x</th>\n",
       "      <th>inning</th>\n",
       "      <th>batting_team</th>\n",
       "      <th>bowling_team</th>\n",
       "      <th>over</th>\n",
       "      <th>ball</th>\n",
       "      <th>batter</th>\n",
       "      <th>...</th>\n",
       "      <th>extras_type</th>\n",
       "      <th>is_wicket</th>\n",
       "      <th>player_dismissed</th>\n",
       "      <th>dismissal_kind</th>\n",
       "      <th>fielder</th>\n",
       "      <th>current_Score</th>\n",
       "      <th>runs_left</th>\n",
       "      <th>balls_left</th>\n",
       "      <th>wickets_remaining</th>\n",
       "      <th>crr</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>222</td>\n",
       "      <td>119</td>\n",
       "      <td>10</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>wides</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>221</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>221</td>\n",
       "      <td>117</td>\n",
       "      <td>10</td>\n",
       "      <td>4.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>220</td>\n",
       "      <td>116</td>\n",
       "      <td>10</td>\n",
       "      <td>4.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>219</td>\n",
       "      <td>115</td>\n",
       "      <td>10</td>\n",
       "      <td>4.80</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>243812</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>159</td>\n",
       "      <td>56</td>\n",
       "      <td>34</td>\n",
       "      <td>5</td>\n",
       "      <td>11.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243813</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>160</td>\n",
       "      <td>55</td>\n",
       "      <td>33</td>\n",
       "      <td>5</td>\n",
       "      <td>11.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243814</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>161</td>\n",
       "      <td>54</td>\n",
       "      <td>32</td>\n",
       "      <td>5</td>\n",
       "      <td>10.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243815</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167</td>\n",
       "      <td>48</td>\n",
       "      <td>31</td>\n",
       "      <td>5</td>\n",
       "      <td>11.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243816</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>171</td>\n",
       "      <td>44</td>\n",
       "      <td>30</td>\n",
       "      <td>5</td>\n",
       "      <td>11.40</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104595 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id       city                 winner  total_runs_x  inning  \\\n",
       "124       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "125       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "126       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "127       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "128       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "...          ...        ...                    ...           ...     ...   \n",
       "243812   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243813   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243814   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243815   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243816   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "\n",
       "                       batting_team           bowling_team  over  ball  \\\n",
       "124     Royal Challengers Bangalore  Kolkata Knight Riders     0     1   \n",
       "125     Royal Challengers Bangalore  Kolkata Knight Riders     0     2   \n",
       "126     Royal Challengers Bangalore  Kolkata Knight Riders     0     3   \n",
       "127     Royal Challengers Bangalore  Kolkata Knight Riders     0     4   \n",
       "128     Royal Challengers Bangalore  Kolkata Knight Riders     0     5   \n",
       "...                             ...                    ...   ...   ...   \n",
       "243812          Chennai Super Kings         Gujarat Titans    14     2   \n",
       "243813          Chennai Super Kings         Gujarat Titans    14     3   \n",
       "243814          Chennai Super Kings         Gujarat Titans    14     4   \n",
       "243815          Chennai Super Kings         Gujarat Titans    14     5   \n",
       "243816          Chennai Super Kings         Gujarat Titans    14     6   \n",
       "\n",
       "           batter  ... extras_type is_wicket  player_dismissed  \\\n",
       "124      R Dravid  ...         NaN         0                 0   \n",
       "125      W Jaffer  ...       wides         0                 0   \n",
       "126      W Jaffer  ...         NaN         0                 0   \n",
       "127      W Jaffer  ...         NaN         0                 0   \n",
       "128      R Dravid  ...         NaN         0                 0   \n",
       "...           ...  ...         ...       ...               ...   \n",
       "243812     S Dube  ...         NaN         0                 0   \n",
       "243813  RA Jadeja  ...         NaN         0                 0   \n",
       "243814     S Dube  ...         NaN         0                 0   \n",
       "243815  RA Jadeja  ...         NaN         0                 0   \n",
       "243816  RA Jadeja  ...         NaN         0                 0   \n",
       "\n",
       "        dismissal_kind  fielder current_Score  runs_left  balls_left  \\\n",
       "124                NaN      NaN             1        222         119   \n",
       "125                NaN      NaN             2        221         118   \n",
       "126                NaN      NaN             2        221         117   \n",
       "127                NaN      NaN             3        220         116   \n",
       "128                NaN      NaN             4        219         115   \n",
       "...                ...      ...           ...        ...         ...   \n",
       "243812             NaN      NaN           159         56          34   \n",
       "243813             NaN      NaN           160         55          33   \n",
       "243814             NaN      NaN           161         54          32   \n",
       "243815             NaN      NaN           167         48          31   \n",
       "243816             NaN      NaN           171         44          30   \n",
       "\n",
       "       wickets_remaining    crr  \n",
       "124                   10   6.00  \n",
       "125                   10   6.00  \n",
       "126                   10   4.00  \n",
       "127                   10   4.50  \n",
       "128                   10   4.80  \n",
       "...                  ...    ...  \n",
       "243812                 5  11.09  \n",
       "243813                 5  11.03  \n",
       "243814                 5  10.98  \n",
       "243815                 5  11.26  \n",
       "243816                 5  11.40  \n",
       "\n",
       "[104595 rows x 25 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "second_innings['crr'] = round((second_innings['current_Score']*6)/(120 - second_innings['balls_left']),2)\n",
    "second_innings"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4c20768b-c335-474f-85f7-16b1456b98ea",
   "metadata": {},
   "source": [
    "Required Run Rate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "dabb6363-087f-4464-870f-5d62660dce3e",
   "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>city</th>\n",
       "      <th>winner</th>\n",
       "      <th>total_runs_x</th>\n",
       "      <th>inning</th>\n",
       "      <th>batting_team</th>\n",
       "      <th>bowling_team</th>\n",
       "      <th>over</th>\n",
       "      <th>ball</th>\n",
       "      <th>batter</th>\n",
       "      <th>...</th>\n",
       "      <th>is_wicket</th>\n",
       "      <th>player_dismissed</th>\n",
       "      <th>dismissal_kind</th>\n",
       "      <th>fielder</th>\n",
       "      <th>current_Score</th>\n",
       "      <th>runs_left</th>\n",
       "      <th>balls_left</th>\n",
       "      <th>wickets_remaining</th>\n",
       "      <th>crr</th>\n",
       "      <th>rrr</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>222</td>\n",
       "      <td>119</td>\n",
       "      <td>10</td>\n",
       "      <td>6.00</td>\n",
       "      <td>11.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>221</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>6.00</td>\n",
       "      <td>11.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>221</td>\n",
       "      <td>117</td>\n",
       "      <td>10</td>\n",
       "      <td>4.00</td>\n",
       "      <td>11.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>220</td>\n",
       "      <td>116</td>\n",
       "      <td>10</td>\n",
       "      <td>4.50</td>\n",
       "      <td>11.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>219</td>\n",
       "      <td>115</td>\n",
       "      <td>10</td>\n",
       "      <td>4.80</td>\n",
       "      <td>11.43</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>243812</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>159</td>\n",
       "      <td>56</td>\n",
       "      <td>34</td>\n",
       "      <td>5</td>\n",
       "      <td>11.09</td>\n",
       "      <td>9.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243813</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>160</td>\n",
       "      <td>55</td>\n",
       "      <td>33</td>\n",
       "      <td>5</td>\n",
       "      <td>11.03</td>\n",
       "      <td>10.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243814</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>161</td>\n",
       "      <td>54</td>\n",
       "      <td>32</td>\n",
       "      <td>5</td>\n",
       "      <td>10.98</td>\n",
       "      <td>10.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243815</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167</td>\n",
       "      <td>48</td>\n",
       "      <td>31</td>\n",
       "      <td>5</td>\n",
       "      <td>11.26</td>\n",
       "      <td>9.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243816</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>171</td>\n",
       "      <td>44</td>\n",
       "      <td>30</td>\n",
       "      <td>5</td>\n",
       "      <td>11.40</td>\n",
       "      <td>8.80</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104595 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id       city                 winner  total_runs_x  inning  \\\n",
       "124       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "125       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "126       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "127       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "128       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "...          ...        ...                    ...           ...     ...   \n",
       "243812   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243813   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243814   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243815   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243816   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "\n",
       "                       batting_team           bowling_team  over  ball  \\\n",
       "124     Royal Challengers Bangalore  Kolkata Knight Riders     0     1   \n",
       "125     Royal Challengers Bangalore  Kolkata Knight Riders     0     2   \n",
       "126     Royal Challengers Bangalore  Kolkata Knight Riders     0     3   \n",
       "127     Royal Challengers Bangalore  Kolkata Knight Riders     0     4   \n",
       "128     Royal Challengers Bangalore  Kolkata Knight Riders     0     5   \n",
       "...                             ...                    ...   ...   ...   \n",
       "243812          Chennai Super Kings         Gujarat Titans    14     2   \n",
       "243813          Chennai Super Kings         Gujarat Titans    14     3   \n",
       "243814          Chennai Super Kings         Gujarat Titans    14     4   \n",
       "243815          Chennai Super Kings         Gujarat Titans    14     5   \n",
       "243816          Chennai Super Kings         Gujarat Titans    14     6   \n",
       "\n",
       "           batter  ... is_wicket player_dismissed  dismissal_kind  fielder  \\\n",
       "124      R Dravid  ...         0                0             NaN      NaN   \n",
       "125      W Jaffer  ...         0                0             NaN      NaN   \n",
       "126      W Jaffer  ...         0                0             NaN      NaN   \n",
       "127      W Jaffer  ...         0                0             NaN      NaN   \n",
       "128      R Dravid  ...         0                0             NaN      NaN   \n",
       "...           ...  ...       ...              ...             ...      ...   \n",
       "243812     S Dube  ...         0                0             NaN      NaN   \n",
       "243813  RA Jadeja  ...         0                0             NaN      NaN   \n",
       "243814     S Dube  ...         0                0             NaN      NaN   \n",
       "243815  RA Jadeja  ...         0                0             NaN      NaN   \n",
       "243816  RA Jadeja  ...         0                0             NaN      NaN   \n",
       "\n",
       "        current_Score runs_left  balls_left  wickets_remaining    crr    rrr  \n",
       "124                 1       222         119                 10   6.00  11.19  \n",
       "125                 2       221         118                 10   6.00  11.24  \n",
       "126                 2       221         117                 10   4.00  11.33  \n",
       "127                 3       220         116                 10   4.50  11.38  \n",
       "128                 4       219         115                 10   4.80  11.43  \n",
       "...               ...       ...         ...                ...    ...    ...  \n",
       "243812            159        56          34                  5  11.09   9.88  \n",
       "243813            160        55          33                  5  11.03  10.00  \n",
       "243814            161        54          32                  5  10.98  10.12  \n",
       "243815            167        48          31                  5  11.26   9.29  \n",
       "243816            171        44          30                  5  11.40   8.80  \n",
       "\n",
       "[104595 rows x 26 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "second_innings['rrr'] = round((second_innings['runs_left']*6)/(second_innings['balls_left']),2)\n",
    "second_innings"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ddbd0dfb-8880-47ce-8c9d-09c38f32524b",
   "metadata": {},
   "source": [
    "Finding Winner"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "74c328ca-7d6b-4189-86fe-55c6c92e3fe5",
   "metadata": {},
   "outputs": [],
   "source": [
    "def winner(team):\n",
    "    return 1 if team['batting_team'] == team['winner'] else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "1a86b7b2-cc79-4e1f-aad4-edb2650ee4ae",
   "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>city</th>\n",
       "      <th>winner</th>\n",
       "      <th>total_runs_x</th>\n",
       "      <th>inning</th>\n",
       "      <th>batting_team</th>\n",
       "      <th>bowling_team</th>\n",
       "      <th>over</th>\n",
       "      <th>ball</th>\n",
       "      <th>batter</th>\n",
       "      <th>...</th>\n",
       "      <th>player_dismissed</th>\n",
       "      <th>dismissal_kind</th>\n",
       "      <th>fielder</th>\n",
       "      <th>current_Score</th>\n",
       "      <th>runs_left</th>\n",
       "      <th>balls_left</th>\n",
       "      <th>wickets_remaining</th>\n",
       "      <th>crr</th>\n",
       "      <th>rrr</th>\n",
       "      <th>results</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>222</td>\n",
       "      <td>119</td>\n",
       "      <td>10</td>\n",
       "      <td>6.00</td>\n",
       "      <td>11.19</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>221</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>6.00</td>\n",
       "      <td>11.24</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>221</td>\n",
       "      <td>117</td>\n",
       "      <td>10</td>\n",
       "      <td>4.00</td>\n",
       "      <td>11.33</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>W Jaffer</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>220</td>\n",
       "      <td>116</td>\n",
       "      <td>10</td>\n",
       "      <td>4.50</td>\n",
       "      <td>11.38</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>335982</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>223</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>R Dravid</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>219</td>\n",
       "      <td>115</td>\n",
       "      <td>10</td>\n",
       "      <td>4.80</td>\n",
       "      <td>11.43</td>\n",
       "      <td>0</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>243812</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>159</td>\n",
       "      <td>56</td>\n",
       "      <td>34</td>\n",
       "      <td>5</td>\n",
       "      <td>11.09</td>\n",
       "      <td>9.88</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243813</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>160</td>\n",
       "      <td>55</td>\n",
       "      <td>33</td>\n",
       "      <td>5</td>\n",
       "      <td>11.03</td>\n",
       "      <td>10.00</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243814</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "      <td>S Dube</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>161</td>\n",
       "      <td>54</td>\n",
       "      <td>32</td>\n",
       "      <td>5</td>\n",
       "      <td>10.98</td>\n",
       "      <td>10.12</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243815</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167</td>\n",
       "      <td>48</td>\n",
       "      <td>31</td>\n",
       "      <td>5</td>\n",
       "      <td>11.26</td>\n",
       "      <td>9.29</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243816</th>\n",
       "      <td>1370353</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>215</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>171</td>\n",
       "      <td>44</td>\n",
       "      <td>30</td>\n",
       "      <td>5</td>\n",
       "      <td>11.40</td>\n",
       "      <td>8.80</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104595 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id       city                 winner  total_runs_x  inning  \\\n",
       "124       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "125       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "126       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "127       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "128       335982  Bangalore  Kolkata Knight Riders           223       2   \n",
       "...          ...        ...                    ...           ...     ...   \n",
       "243812   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243813   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243814   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243815   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "243816   1370353  Ahmedabad    Chennai Super Kings           215       2   \n",
       "\n",
       "                       batting_team           bowling_team  over  ball  \\\n",
       "124     Royal Challengers Bangalore  Kolkata Knight Riders     0     1   \n",
       "125     Royal Challengers Bangalore  Kolkata Knight Riders     0     2   \n",
       "126     Royal Challengers Bangalore  Kolkata Knight Riders     0     3   \n",
       "127     Royal Challengers Bangalore  Kolkata Knight Riders     0     4   \n",
       "128     Royal Challengers Bangalore  Kolkata Knight Riders     0     5   \n",
       "...                             ...                    ...   ...   ...   \n",
       "243812          Chennai Super Kings         Gujarat Titans    14     2   \n",
       "243813          Chennai Super Kings         Gujarat Titans    14     3   \n",
       "243814          Chennai Super Kings         Gujarat Titans    14     4   \n",
       "243815          Chennai Super Kings         Gujarat Titans    14     5   \n",
       "243816          Chennai Super Kings         Gujarat Titans    14     6   \n",
       "\n",
       "           batter  ... player_dismissed dismissal_kind  fielder  \\\n",
       "124      R Dravid  ...                0            NaN      NaN   \n",
       "125      W Jaffer  ...                0            NaN      NaN   \n",
       "126      W Jaffer  ...                0            NaN      NaN   \n",
       "127      W Jaffer  ...                0            NaN      NaN   \n",
       "128      R Dravid  ...                0            NaN      NaN   \n",
       "...           ...  ...              ...            ...      ...   \n",
       "243812     S Dube  ...                0            NaN      NaN   \n",
       "243813  RA Jadeja  ...                0            NaN      NaN   \n",
       "243814     S Dube  ...                0            NaN      NaN   \n",
       "243815  RA Jadeja  ...                0            NaN      NaN   \n",
       "243816  RA Jadeja  ...                0            NaN      NaN   \n",
       "\n",
       "        current_Score  runs_left balls_left  wickets_remaining    crr    rrr  \\\n",
       "124                 1        222        119                 10   6.00  11.19   \n",
       "125                 2        221        118                 10   6.00  11.24   \n",
       "126                 2        221        117                 10   4.00  11.33   \n",
       "127                 3        220        116                 10   4.50  11.38   \n",
       "128                 4        219        115                 10   4.80  11.43   \n",
       "...               ...        ...        ...                ...    ...    ...   \n",
       "243812            159         56         34                  5  11.09   9.88   \n",
       "243813            160         55         33                  5  11.03  10.00   \n",
       "243814            161         54         32                  5  10.98  10.12   \n",
       "243815            167         48         31                  5  11.26   9.29   \n",
       "243816            171         44         30                  5  11.40   8.80   \n",
       "\n",
       "       results  \n",
       "124          0  \n",
       "125          0  \n",
       "126          0  \n",
       "127          0  \n",
       "128          0  \n",
       "...        ...  \n",
       "243812       1  \n",
       "243813       1  \n",
       "243814       1  \n",
       "243815       1  \n",
       "243816       1  \n",
       "\n",
       "[104595 rows x 27 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "second_innings['results'] = second_innings.apply(winner,axis=1)\n",
    "second_innings"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6fbc5229-9d85-48d1-ae64-fdf3f104bc38",
   "metadata": {},
   "source": [
    "only taking required columns we need "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "fe7fd837-efab-4527-8316-8e346d7a1935",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>batting_team</th>\n",
       "      <th>bowling_team</th>\n",
       "      <th>city</th>\n",
       "      <th>runs_left</th>\n",
       "      <th>balls_left</th>\n",
       "      <th>wickets_remaining</th>\n",
       "      <th>total_runs_x</th>\n",
       "      <th>crr</th>\n",
       "      <th>rrr</th>\n",
       "      <th>results</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>222</td>\n",
       "      <td>119</td>\n",
       "      <td>10</td>\n",
       "      <td>223</td>\n",
       "      <td>6.00</td>\n",
       "      <td>11.19</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>221</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>223</td>\n",
       "      <td>6.00</td>\n",
       "      <td>11.24</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>221</td>\n",
       "      <td>117</td>\n",
       "      <td>10</td>\n",
       "      <td>223</td>\n",
       "      <td>4.00</td>\n",
       "      <td>11.33</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>220</td>\n",
       "      <td>116</td>\n",
       "      <td>10</td>\n",
       "      <td>223</td>\n",
       "      <td>4.50</td>\n",
       "      <td>11.38</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>219</td>\n",
       "      <td>115</td>\n",
       "      <td>10</td>\n",
       "      <td>223</td>\n",
       "      <td>4.80</td>\n",
       "      <td>11.43</td>\n",
       "      <td>0</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>243812</th>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>56</td>\n",
       "      <td>34</td>\n",
       "      <td>5</td>\n",
       "      <td>215</td>\n",
       "      <td>11.09</td>\n",
       "      <td>9.88</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243813</th>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>55</td>\n",
       "      <td>33</td>\n",
       "      <td>5</td>\n",
       "      <td>215</td>\n",
       "      <td>11.03</td>\n",
       "      <td>10.00</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243814</th>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>54</td>\n",
       "      <td>32</td>\n",
       "      <td>5</td>\n",
       "      <td>215</td>\n",
       "      <td>10.98</td>\n",
       "      <td>10.12</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243815</th>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>48</td>\n",
       "      <td>31</td>\n",
       "      <td>5</td>\n",
       "      <td>215</td>\n",
       "      <td>11.26</td>\n",
       "      <td>9.29</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243816</th>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Gujarat Titans</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>44</td>\n",
       "      <td>30</td>\n",
       "      <td>5</td>\n",
       "      <td>215</td>\n",
       "      <td>11.40</td>\n",
       "      <td>8.80</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>104595 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       batting_team           bowling_team       city  \\\n",
       "124     Royal Challengers Bangalore  Kolkata Knight Riders  Bangalore   \n",
       "125     Royal Challengers Bangalore  Kolkata Knight Riders  Bangalore   \n",
       "126     Royal Challengers Bangalore  Kolkata Knight Riders  Bangalore   \n",
       "127     Royal Challengers Bangalore  Kolkata Knight Riders  Bangalore   \n",
       "128     Royal Challengers Bangalore  Kolkata Knight Riders  Bangalore   \n",
       "...                             ...                    ...        ...   \n",
       "243812          Chennai Super Kings         Gujarat Titans  Ahmedabad   \n",
       "243813          Chennai Super Kings         Gujarat Titans  Ahmedabad   \n",
       "243814          Chennai Super Kings         Gujarat Titans  Ahmedabad   \n",
       "243815          Chennai Super Kings         Gujarat Titans  Ahmedabad   \n",
       "243816          Chennai Super Kings         Gujarat Titans  Ahmedabad   \n",
       "\n",
       "        runs_left  balls_left  wickets_remaining  total_runs_x    crr    rrr  \\\n",
       "124           222         119                 10           223   6.00  11.19   \n",
       "125           221         118                 10           223   6.00  11.24   \n",
       "126           221         117                 10           223   4.00  11.33   \n",
       "127           220         116                 10           223   4.50  11.38   \n",
       "128           219         115                 10           223   4.80  11.43   \n",
       "...           ...         ...                ...           ...    ...    ...   \n",
       "243812         56          34                  5           215  11.09   9.88   \n",
       "243813         55          33                  5           215  11.03  10.00   \n",
       "243814         54          32                  5           215  10.98  10.12   \n",
       "243815         48          31                  5           215  11.26   9.29   \n",
       "243816         44          30                  5           215  11.40   8.80   \n",
       "\n",
       "        results  \n",
       "124           0  \n",
       "125           0  \n",
       "126           0  \n",
       "127           0  \n",
       "128           0  \n",
       "...         ...  \n",
       "243812        1  \n",
       "243813        1  \n",
       "243814        1  \n",
       "243815        1  \n",
       "243816        1  \n",
       "\n",
       "[104595 rows x 10 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "required_data = second_innings[['batting_team','bowling_team','city','runs_left','balls_left','wickets_remaining','total_runs_x','crr','rrr','results']]\n",
    "required_data"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4b9cd96e-b435-4488-aa80-54c0480f4378",
   "metadata": {},
   "source": [
    "Sampling Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "56d7773f-2348-49d8-9b9b-2117f0a1ca05",
   "metadata": {},
   "outputs": [],
   "source": [
    "final_data = required_data.sample(required_data.shape[0])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "52650c5b-1c50-465b-b8ae-8afa7aa22c4e",
   "metadata": {},
   "source": [
    "Droping null values "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "fe462550-68aa-4f0c-8255-c48adeb47894",
   "metadata": {},
   "outputs": [],
   "source": [
    "final_data.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5cd03135-521a-4293-a085-e65d3fba5a29",
   "metadata": {},
   "source": [
    "Removing rows where balls_left==0 to remove -inf and inf from rrr column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "6cb0611f-a8cd-4126-807f-52bc8feab9f5",
   "metadata": {},
   "outputs": [],
   "source": [
    "final_data = final_data[final_data['balls_left']!=0]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ab3478f3-c82f-4794-8aa2-7870870cad35",
   "metadata": {},
   "source": [
    "Storing data in new csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "3b5734d1-69ae-4abc-9a2b-40202a25272c",
   "metadata": {},
   "outputs": [],
   "source": [
    "final_data.to_csv(\"final_data.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a7878408-43a0-420a-8099-918555725473",
   "metadata": {},
   "source": [
    "<font size=\"5\">Building Model"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "78c08106-0639-4cc9-bec7-ddff8b77d70f",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.model_selection import train_test_split as tts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "766781fb-7e6c-453d-a040-d73d85531457",
   "metadata": {},
   "outputs": [],
   "source": [
    "x = final_data.iloc[:, :-1]\n",
    "y = final_data.iloc[:, -1]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "ddb1d042-dcfe-4250-acbf-3f2677bae164",
   "metadata": {},
   "outputs": [],
   "source": [
    "x_train, x_test, y_train, y_test = tts(x, y, test_size=0.25, random_state=100)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "1de13c4e-b73f-42b0-b665-cfa454b2e775",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.compose import ColumnTransformer\n",
    "from sklearn.preprocessing import OneHotEncoder\n",
    "# Defining a transformer for one-hot encoding categorical features\n",
    "trf = ColumnTransformer([\n",
    "    ('trf', OneHotEncoder(drop='first', sparse_output=False), ['batting_team', 'bowling_team', 'city'])\n",
    "],\n",
    "remainder='passthrough')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "3d1af1f9-106f-47a8-a691-030ad7747d9e",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.linear_model import LogisticRegression\n",
    "from sklearn.pipeline import Pipeline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "416b5d14-2bc0-4be8-af02-85f5ab0defee",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Creating a pipeline with column transformation and logistic regression\n",
    "pipe = Pipeline([\n",
    "    ('step1', trf),\n",
    "    ('step2', LogisticRegression(solver='liblinear'))\n",
    "])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "38626884-7ad7-4e0d-8b34-abfc0a42c260",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>#sk-container-id-1 {\n",
       "  /* Definition of color scheme common for light and dark mode */\n",
       "  --sklearn-color-text: black;\n",
       "  --sklearn-color-line: gray;\n",
       "  /* Definition of color scheme for unfitted estimators */\n",
       "  --sklearn-color-unfitted-level-0: #fff5e6;\n",
       "  --sklearn-color-unfitted-level-1: #f6e4d2;\n",
       "  --sklearn-color-unfitted-level-2: #ffe0b3;\n",
       "  --sklearn-color-unfitted-level-3: chocolate;\n",
       "  /* Definition of color scheme for fitted estimators */\n",
       "  --sklearn-color-fitted-level-0: #f0f8ff;\n",
       "  --sklearn-color-fitted-level-1: #d4ebff;\n",
       "  --sklearn-color-fitted-level-2: #b3dbfd;\n",
       "  --sklearn-color-fitted-level-3: cornflowerblue;\n",
       "\n",
       "  /* Specific color for light theme */\n",
       "  --sklearn-color-text-on-default-background: var(--sg-text-color, var(--theme-code-foreground, var(--jp-content-font-color1, black)));\n",
       "  --sklearn-color-background: var(--sg-background-color, var(--theme-background, var(--jp-layout-color0, white)));\n",
       "  --sklearn-color-border-box: var(--sg-text-color, var(--theme-code-foreground, var(--jp-content-font-color1, black)));\n",
       "  --sklearn-color-icon: #696969;\n",
       "\n",
       "  @media (prefers-color-scheme: dark) {\n",
       "    /* Redefinition of color scheme for dark theme */\n",
       "    --sklearn-color-text-on-default-background: var(--sg-text-color, var(--theme-code-foreground, var(--jp-content-font-color1, white)));\n",
       "    --sklearn-color-background: var(--sg-background-color, var(--theme-background, var(--jp-layout-color0, #111)));\n",
       "    --sklearn-color-border-box: var(--sg-text-color, var(--theme-code-foreground, var(--jp-content-font-color1, white)));\n",
       "    --sklearn-color-icon: #878787;\n",
       "  }\n",
       "}\n",
       "\n",
       "#sk-container-id-1 {\n",
       "  color: var(--sklearn-color-text);\n",
       "}\n",
       "\n",
       "#sk-container-id-1 pre {\n",
       "  padding: 0;\n",
       "}\n",
       "\n",
       "#sk-container-id-1 input.sk-hidden--visually {\n",
       "  border: 0;\n",
       "  clip: rect(1px 1px 1px 1px);\n",
       "  clip: rect(1px, 1px, 1px, 1px);\n",
       "  height: 1px;\n",
       "  margin: -1px;\n",
       "  overflow: hidden;\n",
       "  padding: 0;\n",
       "  position: absolute;\n",
       "  width: 1px;\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-dashed-wrapped {\n",
       "  border: 1px dashed var(--sklearn-color-line);\n",
       "  margin: 0 0.4em 0.5em 0.4em;\n",
       "  box-sizing: border-box;\n",
       "  padding-bottom: 0.4em;\n",
       "  background-color: var(--sklearn-color-background);\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-container {\n",
       "  /* jupyter's `normalize.less` sets `[hidden] { display: none; }`\n",
       "     but bootstrap.min.css set `[hidden] { display: none !important; }`\n",
       "     so we also need the `!important` here to be able to override the\n",
       "     default hidden behavior on the sphinx rendered scikit-learn.org.\n",
       "     See: https://github.com/scikit-learn/scikit-learn/issues/21755 */\n",
       "  display: inline-block !important;\n",
       "  position: relative;\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-text-repr-fallback {\n",
       "  display: none;\n",
       "}\n",
       "\n",
       "div.sk-parallel-item,\n",
       "div.sk-serial,\n",
       "div.sk-item {\n",
       "  /* draw centered vertical line to link estimators */\n",
       "  background-image: linear-gradient(var(--sklearn-color-text-on-default-background), var(--sklearn-color-text-on-default-background));\n",
       "  background-size: 2px 100%;\n",
       "  background-repeat: no-repeat;\n",
       "  background-position: center center;\n",
       "}\n",
       "\n",
       "/* Parallel-specific style estimator block */\n",
       "\n",
       "#sk-container-id-1 div.sk-parallel-item::after {\n",
       "  content: \"\";\n",
       "  width: 100%;\n",
       "  border-bottom: 2px solid var(--sklearn-color-text-on-default-background);\n",
       "  flex-grow: 1;\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-parallel {\n",
       "  display: flex;\n",
       "  align-items: stretch;\n",
       "  justify-content: center;\n",
       "  background-color: var(--sklearn-color-background);\n",
       "  position: relative;\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-parallel-item {\n",
       "  display: flex;\n",
       "  flex-direction: column;\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-parallel-item:first-child::after {\n",
       "  align-self: flex-end;\n",
       "  width: 50%;\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-parallel-item:last-child::after {\n",
       "  align-self: flex-start;\n",
       "  width: 50%;\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-parallel-item:only-child::after {\n",
       "  width: 0;\n",
       "}\n",
       "\n",
       "/* Serial-specific style estimator block */\n",
       "\n",
       "#sk-container-id-1 div.sk-serial {\n",
       "  display: flex;\n",
       "  flex-direction: column;\n",
       "  align-items: center;\n",
       "  background-color: var(--sklearn-color-background);\n",
       "  padding-right: 1em;\n",
       "  padding-left: 1em;\n",
       "}\n",
       "\n",
       "\n",
       "/* Toggleable style: style used for estimator/Pipeline/ColumnTransformer box that is\n",
       "clickable and can be expanded/collapsed.\n",
       "- Pipeline and ColumnTransformer use this feature and define the default style\n",
       "- Estimators will overwrite some part of the style using the `sk-estimator` class\n",
       "*/\n",
       "\n",
       "/* Pipeline and ColumnTransformer style (default) */\n",
       "\n",
       "#sk-container-id-1 div.sk-toggleable {\n",
       "  /* Default theme specific background. It is overwritten whether we have a\n",
       "  specific estimator or a Pipeline/ColumnTransformer */\n",
       "  background-color: var(--sklearn-color-background);\n",
       "}\n",
       "\n",
       "/* Toggleable label */\n",
       "#sk-container-id-1 label.sk-toggleable__label {\n",
       "  cursor: pointer;\n",
       "  display: block;\n",
       "  width: 100%;\n",
       "  margin-bottom: 0;\n",
       "  padding: 0.5em;\n",
       "  box-sizing: border-box;\n",
       "  text-align: center;\n",
       "}\n",
       "\n",
       "#sk-container-id-1 label.sk-toggleable__label-arrow:before {\n",
       "  /* Arrow on the left of the label */\n",
       "  content: \"▸\";\n",
       "  float: left;\n",
       "  margin-right: 0.25em;\n",
       "  color: var(--sklearn-color-icon);\n",
       "}\n",
       "\n",
       "#sk-container-id-1 label.sk-toggleable__label-arrow:hover:before {\n",
       "  color: var(--sklearn-color-text);\n",
       "}\n",
       "\n",
       "/* Toggleable content - dropdown */\n",
       "\n",
       "#sk-container-id-1 div.sk-toggleable__content {\n",
       "  max-height: 0;\n",
       "  max-width: 0;\n",
       "  overflow: hidden;\n",
       "  text-align: left;\n",
       "  /* unfitted */\n",
       "  background-color: var(--sklearn-color-unfitted-level-0);\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-toggleable__content.fitted {\n",
       "  /* fitted */\n",
       "  background-color: var(--sklearn-color-fitted-level-0);\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-toggleable__content pre {\n",
       "  margin: 0.2em;\n",
       "  border-radius: 0.25em;\n",
       "  color: var(--sklearn-color-text);\n",
       "  /* unfitted */\n",
       "  background-color: var(--sklearn-color-unfitted-level-0);\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-toggleable__content.fitted pre {\n",
       "  /* unfitted */\n",
       "  background-color: var(--sklearn-color-fitted-level-0);\n",
       "}\n",
       "\n",
       "#sk-container-id-1 input.sk-toggleable__control:checked~div.sk-toggleable__content {\n",
       "  /* Expand drop-down */\n",
       "  max-height: 200px;\n",
       "  max-width: 100%;\n",
       "  overflow: auto;\n",
       "}\n",
       "\n",
       "#sk-container-id-1 input.sk-toggleable__control:checked~label.sk-toggleable__label-arrow:before {\n",
       "  content: \"▾\";\n",
       "}\n",
       "\n",
       "/* Pipeline/ColumnTransformer-specific style */\n",
       "\n",
       "#sk-container-id-1 div.sk-label input.sk-toggleable__control:checked~label.sk-toggleable__label {\n",
       "  color: var(--sklearn-color-text);\n",
       "  background-color: var(--sklearn-color-unfitted-level-2);\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-label.fitted input.sk-toggleable__control:checked~label.sk-toggleable__label {\n",
       "  background-color: var(--sklearn-color-fitted-level-2);\n",
       "}\n",
       "\n",
       "/* Estimator-specific style */\n",
       "\n",
       "/* Colorize estimator box */\n",
       "#sk-container-id-1 div.sk-estimator input.sk-toggleable__control:checked~label.sk-toggleable__label {\n",
       "  /* unfitted */\n",
       "  background-color: var(--sklearn-color-unfitted-level-2);\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-estimator.fitted input.sk-toggleable__control:checked~label.sk-toggleable__label {\n",
       "  /* fitted */\n",
       "  background-color: var(--sklearn-color-fitted-level-2);\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-label label.sk-toggleable__label,\n",
       "#sk-container-id-1 div.sk-label label {\n",
       "  /* The background is the default theme color */\n",
       "  color: var(--sklearn-color-text-on-default-background);\n",
       "}\n",
       "\n",
       "/* On hover, darken the color of the background */\n",
       "#sk-container-id-1 div.sk-label:hover label.sk-toggleable__label {\n",
       "  color: var(--sklearn-color-text);\n",
       "  background-color: var(--sklearn-color-unfitted-level-2);\n",
       "}\n",
       "\n",
       "/* Label box, darken color on hover, fitted */\n",
       "#sk-container-id-1 div.sk-label.fitted:hover label.sk-toggleable__label.fitted {\n",
       "  color: var(--sklearn-color-text);\n",
       "  background-color: var(--sklearn-color-fitted-level-2);\n",
       "}\n",
       "\n",
       "/* Estimator label */\n",
       "\n",
       "#sk-container-id-1 div.sk-label label {\n",
       "  font-family: monospace;\n",
       "  font-weight: bold;\n",
       "  display: inline-block;\n",
       "  line-height: 1.2em;\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-label-container {\n",
       "  text-align: center;\n",
       "}\n",
       "\n",
       "/* Estimator-specific */\n",
       "#sk-container-id-1 div.sk-estimator {\n",
       "  font-family: monospace;\n",
       "  border: 1px dotted var(--sklearn-color-border-box);\n",
       "  border-radius: 0.25em;\n",
       "  box-sizing: border-box;\n",
       "  margin-bottom: 0.5em;\n",
       "  /* unfitted */\n",
       "  background-color: var(--sklearn-color-unfitted-level-0);\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-estimator.fitted {\n",
       "  /* fitted */\n",
       "  background-color: var(--sklearn-color-fitted-level-0);\n",
       "}\n",
       "\n",
       "/* on hover */\n",
       "#sk-container-id-1 div.sk-estimator:hover {\n",
       "  /* unfitted */\n",
       "  background-color: var(--sklearn-color-unfitted-level-2);\n",
       "}\n",
       "\n",
       "#sk-container-id-1 div.sk-estimator.fitted:hover {\n",
       "  /* fitted */\n",
       "  background-color: var(--sklearn-color-fitted-level-2);\n",
       "}\n",
       "\n",
       "/* Specification for estimator info (e.g. \"i\" and \"?\") */\n",
       "\n",
       "/* Common style for \"i\" and \"?\" */\n",
       "\n",
       ".sk-estimator-doc-link,\n",
       "a:link.sk-estimator-doc-link,\n",
       "a:visited.sk-estimator-doc-link {\n",
       "  float: right;\n",
       "  font-size: smaller;\n",
       "  line-height: 1em;\n",
       "  font-family: monospace;\n",
       "  background-color: var(--sklearn-color-background);\n",
       "  border-radius: 1em;\n",
       "  height: 1em;\n",
       "  width: 1em;\n",
       "  text-decoration: none !important;\n",
       "  margin-left: 1ex;\n",
       "  /* unfitted */\n",
       "  border: var(--sklearn-color-unfitted-level-1) 1pt solid;\n",
       "  color: var(--sklearn-color-unfitted-level-1);\n",
       "}\n",
       "\n",
       ".sk-estimator-doc-link.fitted,\n",
       "a:link.sk-estimator-doc-link.fitted,\n",
       "a:visited.sk-estimator-doc-link.fitted {\n",
       "  /* fitted */\n",
       "  border: var(--sklearn-color-fitted-level-1) 1pt solid;\n",
       "  color: var(--sklearn-color-fitted-level-1);\n",
       "}\n",
       "\n",
       "/* On hover */\n",
       "div.sk-estimator:hover .sk-estimator-doc-link:hover,\n",
       ".sk-estimator-doc-link:hover,\n",
       "div.sk-label-container:hover .sk-estimator-doc-link:hover,\n",
       ".sk-estimator-doc-link:hover {\n",
       "  /* unfitted */\n",
       "  background-color: var(--sklearn-color-unfitted-level-3);\n",
       "  color: var(--sklearn-color-background);\n",
       "  text-decoration: none;\n",
       "}\n",
       "\n",
       "div.sk-estimator.fitted:hover .sk-estimator-doc-link.fitted:hover,\n",
       ".sk-estimator-doc-link.fitted:hover,\n",
       "div.sk-label-container:hover .sk-estimator-doc-link.fitted:hover,\n",
       ".sk-estimator-doc-link.fitted:hover {\n",
       "  /* fitted */\n",
       "  background-color: var(--sklearn-color-fitted-level-3);\n",
       "  color: var(--sklearn-color-background);\n",
       "  text-decoration: none;\n",
       "}\n",
       "\n",
       "/* Span, style for the box shown on hovering the info icon */\n",
       ".sk-estimator-doc-link span {\n",
       "  display: none;\n",
       "  z-index: 9999;\n",
       "  position: relative;\n",
       "  font-weight: normal;\n",
       "  right: .2ex;\n",
       "  padding: .5ex;\n",
       "  margin: .5ex;\n",
       "  width: min-content;\n",
       "  min-width: 20ex;\n",
       "  max-width: 50ex;\n",
       "  color: var(--sklearn-color-text);\n",
       "  box-shadow: 2pt 2pt 4pt #999;\n",
       "  /* unfitted */\n",
       "  background: var(--sklearn-color-unfitted-level-0);\n",
       "  border: .5pt solid var(--sklearn-color-unfitted-level-3);\n",
       "}\n",
       "\n",
       ".sk-estimator-doc-link.fitted span {\n",
       "  /* fitted */\n",
       "  background: var(--sklearn-color-fitted-level-0);\n",
       "  border: var(--sklearn-color-fitted-level-3);\n",
       "}\n",
       "\n",
       ".sk-estimator-doc-link:hover span {\n",
       "  display: block;\n",
       "}\n",
       "\n",
       "/* \"?\"-specific style due to the `<a>` HTML tag */\n",
       "\n",
       "#sk-container-id-1 a.estimator_doc_link {\n",
       "  float: right;\n",
       "  font-size: 1rem;\n",
       "  line-height: 1em;\n",
       "  font-family: monospace;\n",
       "  background-color: var(--sklearn-color-background);\n",
       "  border-radius: 1rem;\n",
       "  height: 1rem;\n",
       "  width: 1rem;\n",
       "  text-decoration: none;\n",
       "  /* unfitted */\n",
       "  color: var(--sklearn-color-unfitted-level-1);\n",
       "  border: var(--sklearn-color-unfitted-level-1) 1pt solid;\n",
       "}\n",
       "\n",
       "#sk-container-id-1 a.estimator_doc_link.fitted {\n",
       "  /* fitted */\n",
       "  border: var(--sklearn-color-fitted-level-1) 1pt solid;\n",
       "  color: var(--sklearn-color-fitted-level-1);\n",
       "}\n",
       "\n",
       "/* On hover */\n",
       "#sk-container-id-1 a.estimator_doc_link:hover {\n",
       "  /* unfitted */\n",
       "  background-color: var(--sklearn-color-unfitted-level-3);\n",
       "  color: var(--sklearn-color-background);\n",
       "  text-decoration: none;\n",
       "}\n",
       "\n",
       "#sk-container-id-1 a.estimator_doc_link.fitted:hover {\n",
       "  /* fitted */\n",
       "  background-color: var(--sklearn-color-fitted-level-3);\n",
       "}\n",
       "</style><div id=\"sk-container-id-1\" class=\"sk-top-container\"><div class=\"sk-text-repr-fallback\"><pre>Pipeline(steps=[(&#x27;step1&#x27;,\n",
       "                 ColumnTransformer(remainder=&#x27;passthrough&#x27;,\n",
       "                                   transformers=[(&#x27;trf&#x27;,\n",
       "                                                  OneHotEncoder(drop=&#x27;first&#x27;,\n",
       "                                                                sparse_output=False),\n",
       "                                                  [&#x27;batting_team&#x27;,\n",
       "                                                   &#x27;bowling_team&#x27;, &#x27;city&#x27;])])),\n",
       "                (&#x27;step2&#x27;, LogisticRegression(solver=&#x27;liblinear&#x27;))])</pre><b>In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook. <br />On GitHub, the HTML representation is unable to render, please try loading this page with nbviewer.org.</b></div><div class=\"sk-container\" hidden><div class=\"sk-item sk-dashed-wrapped\"><div class=\"sk-label-container\"><div class=\"sk-label fitted sk-toggleable\"><input class=\"sk-toggleable__control sk-hidden--visually\" id=\"sk-estimator-id-1\" type=\"checkbox\" ><label for=\"sk-estimator-id-1\" class=\"sk-toggleable__label fitted sk-toggleable__label-arrow fitted\">&nbsp;&nbsp;Pipeline<a class=\"sk-estimator-doc-link fitted\" rel=\"noreferrer\" target=\"_blank\" href=\"https://scikit-learn.org/1.4/modules/generated/sklearn.pipeline.Pipeline.html\">?<span>Documentation for Pipeline</span></a><span class=\"sk-estimator-doc-link fitted\">i<span>Fitted</span></span></label><div class=\"sk-toggleable__content fitted\"><pre>Pipeline(steps=[(&#x27;step1&#x27;,\n",
       "                 ColumnTransformer(remainder=&#x27;passthrough&#x27;,\n",
       "                                   transformers=[(&#x27;trf&#x27;,\n",
       "                                                  OneHotEncoder(drop=&#x27;first&#x27;,\n",
       "                                                                sparse_output=False),\n",
       "                                                  [&#x27;batting_team&#x27;,\n",
       "                                                   &#x27;bowling_team&#x27;, &#x27;city&#x27;])])),\n",
       "                (&#x27;step2&#x27;, LogisticRegression(solver=&#x27;liblinear&#x27;))])</pre></div> </div></div><div class=\"sk-serial\"><div class=\"sk-item sk-dashed-wrapped\"><div class=\"sk-label-container\"><div class=\"sk-label fitted sk-toggleable\"><input class=\"sk-toggleable__control sk-hidden--visually\" id=\"sk-estimator-id-2\" type=\"checkbox\" ><label for=\"sk-estimator-id-2\" class=\"sk-toggleable__label fitted sk-toggleable__label-arrow fitted\">&nbsp;step1: ColumnTransformer<a class=\"sk-estimator-doc-link fitted\" rel=\"noreferrer\" target=\"_blank\" href=\"https://scikit-learn.org/1.4/modules/generated/sklearn.compose.ColumnTransformer.html\">?<span>Documentation for step1: ColumnTransformer</span></a></label><div class=\"sk-toggleable__content fitted\"><pre>ColumnTransformer(remainder=&#x27;passthrough&#x27;,\n",
       "                  transformers=[(&#x27;trf&#x27;,\n",
       "                                 OneHotEncoder(drop=&#x27;first&#x27;,\n",
       "                                               sparse_output=False),\n",
       "                                 [&#x27;batting_team&#x27;, &#x27;bowling_team&#x27;, &#x27;city&#x27;])])</pre></div> </div></div><div class=\"sk-parallel\"><div class=\"sk-parallel-item\"><div class=\"sk-item\"><div class=\"sk-label-container\"><div class=\"sk-label fitted sk-toggleable\"><input class=\"sk-toggleable__control sk-hidden--visually\" id=\"sk-estimator-id-3\" type=\"checkbox\" ><label for=\"sk-estimator-id-3\" class=\"sk-toggleable__label fitted sk-toggleable__label-arrow fitted\">trf</label><div class=\"sk-toggleable__content fitted\"><pre>[&#x27;batting_team&#x27;, &#x27;bowling_team&#x27;, &#x27;city&#x27;]</pre></div> </div></div><div class=\"sk-serial\"><div class=\"sk-item\"><div class=\"sk-estimator fitted sk-toggleable\"><input class=\"sk-toggleable__control sk-hidden--visually\" id=\"sk-estimator-id-4\" type=\"checkbox\" ><label for=\"sk-estimator-id-4\" class=\"sk-toggleable__label fitted sk-toggleable__label-arrow fitted\">&nbsp;OneHotEncoder<a class=\"sk-estimator-doc-link fitted\" rel=\"noreferrer\" target=\"_blank\" href=\"https://scikit-learn.org/1.4/modules/generated/sklearn.preprocessing.OneHotEncoder.html\">?<span>Documentation for OneHotEncoder</span></a></label><div class=\"sk-toggleable__content fitted\"><pre>OneHotEncoder(drop=&#x27;first&#x27;, sparse_output=False)</pre></div> </div></div></div></div></div><div class=\"sk-parallel-item\"><div class=\"sk-item\"><div class=\"sk-label-container\"><div class=\"sk-label fitted sk-toggleable\"><input class=\"sk-toggleable__control sk-hidden--visually\" id=\"sk-estimator-id-5\" type=\"checkbox\" ><label for=\"sk-estimator-id-5\" class=\"sk-toggleable__label fitted sk-toggleable__label-arrow fitted\">remainder</label><div class=\"sk-toggleable__content fitted\"><pre>[&#x27;runs_left&#x27;, &#x27;balls_left&#x27;, &#x27;wickets_remaining&#x27;, &#x27;total_runs_x&#x27;, &#x27;crr&#x27;, &#x27;rrr&#x27;]</pre></div> </div></div><div class=\"sk-serial\"><div class=\"sk-item\"><div class=\"sk-estimator fitted sk-toggleable\"><input class=\"sk-toggleable__control sk-hidden--visually\" id=\"sk-estimator-id-6\" type=\"checkbox\" ><label for=\"sk-estimator-id-6\" class=\"sk-toggleable__label fitted sk-toggleable__label-arrow fitted\">passthrough</label><div class=\"sk-toggleable__content fitted\"><pre>passthrough</pre></div> </div></div></div></div></div></div></div><div class=\"sk-item\"><div class=\"sk-estimator fitted sk-toggleable\"><input class=\"sk-toggleable__control sk-hidden--visually\" id=\"sk-estimator-id-7\" type=\"checkbox\" ><label for=\"sk-estimator-id-7\" class=\"sk-toggleable__label fitted sk-toggleable__label-arrow fitted\">&nbsp;LogisticRegression<a class=\"sk-estimator-doc-link fitted\" rel=\"noreferrer\" target=\"_blank\" href=\"https://scikit-learn.org/1.4/modules/generated/sklearn.linear_model.LogisticRegression.html\">?<span>Documentation for LogisticRegression</span></a></label><div class=\"sk-toggleable__content fitted\"><pre>LogisticRegression(solver=&#x27;liblinear&#x27;)</pre></div> </div></div></div></div></div></div>"
      ],
      "text/plain": [
       "Pipeline(steps=[('step1',\n",
       "                 ColumnTransformer(remainder='passthrough',\n",
       "                                   transformers=[('trf',\n",
       "                                                  OneHotEncoder(drop='first',\n",
       "                                                                sparse_output=False),\n",
       "                                                  ['batting_team',\n",
       "                                                   'bowling_team', 'city'])])),\n",
       "                ('step2', LogisticRegression(solver='liblinear'))])"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Fitting the pipeline to the training data\n",
    "pipe.fit(x_train, y_train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "c7d2aed0-72fd-49bf-82e0-96734b53313d",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Making predictions on the test data\n",
    "y_pred = pipe.predict(x_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "8184094a-02b2-47eb-a829-84933cdf7980",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.8145026668295264"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Calculating the accuracy of the model\n",
    "from sklearn.metrics import accuracy_score\n",
    "accuracy_score(y_test, y_pred)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "ed858e94-ed4b-419b-a7fa-20db92e6f4b3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([0.58909948, 0.41090052])"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Predicting class probabilities for the first instance in the test set\n",
    "pipe.predict_proba(x_test)[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "1e83cf42-626b-4053-80d9-c9ad44a6f2ac",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Saving the trained pipeline as a binary file\n",
    "import pickle\n",
    "pickle.dump(pipe, open('pipe.pkl', 'wb'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "79fabff6-853d-486d-a732-120967ac5f3f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Mumbai', 'Delhi', 'Chennai', 'Abu Dhabi', 'Visakhapatnam',\n",
       "       'Hyderabad', 'Chandigarh', 'Ahmedabad', 'Bangalore', 'Jaipur',\n",
       "       'Kolkata', 'Port Elizabeth', 'Cuttack', 'Navi Mumbai', 'Centurion',\n",
       "       'Bengaluru', 'Pune', 'Johannesburg', 'Dubai', 'Cape Town',\n",
       "       'Lucknow', 'Durban', 'Dharamsala', 'Indore', 'East London',\n",
       "       'Sharjah', 'Guwahati', 'Raipur', 'Ranchi', 'Nagpur', 'Kimberley',\n",
       "       'Bloemfontein'], dtype=object)"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_data['city'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ba0c80da-057a-4e82-893e-09f3e59c578d",
   "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.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}