IPL Win Probability Predictor.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import seaborn as sn\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>team1</th>\n",
       "      <th>team2</th>\n",
       "      <th>toss_winner</th>\n",
       "      <th>toss_decision</th>\n",
       "      <th>result</th>\n",
       "      <th>dl_applied</th>\n",
       "      <th>winner</th>\n",
       "      <th>win_by_runs</th>\n",
       "      <th>win_by_wickets</th>\n",
       "      <th>player_of_match</th>\n",
       "      <th>venue</th>\n",
       "      <th>umpire1</th>\n",
       "      <th>umpire2</th>\n",
       "      <th>umpire3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>05-04-2017</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>Yuvraj Singh</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>AY Dandekar</td>\n",
       "      <td>NJ Llong</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Pune</td>\n",
       "      <td>06-04-2017</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Rising Pune Supergiant</td>\n",
       "      <td>Rising Pune Supergiant</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Rising Pune Supergiant</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>SPD Smith</td>\n",
       "      <td>Maharashtra Cricket Association Stadium</td>\n",
       "      <td>A Nand Kishore</td>\n",
       "      <td>S Ravi</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Rajkot</td>\n",
       "      <td>07-04-2017</td>\n",
       "      <td>Gujarat Lions</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>CA Lynn</td>\n",
       "      <td>Saurashtra Cricket Association Stadium</td>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td>CK Nandan</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Indore</td>\n",
       "      <td>08-04-2017</td>\n",
       "      <td>Rising Pune Supergiant</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>GJ Maxwell</td>\n",
       "      <td>Holkar Cricket Stadium</td>\n",
       "      <td>AK Chaudhary</td>\n",
       "      <td>C Shamshuddin</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>08-04-2017</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>bat</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>KM Jadhav</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id    Season       city        date                        team1  \\\n",
       "0   1  IPL-2017  Hyderabad  05-04-2017          Sunrisers Hyderabad   \n",
       "1   2  IPL-2017       Pune  06-04-2017               Mumbai Indians   \n",
       "2   3  IPL-2017     Rajkot  07-04-2017                Gujarat Lions   \n",
       "3   4  IPL-2017     Indore  08-04-2017       Rising Pune Supergiant   \n",
       "4   5  IPL-2017  Bangalore  08-04-2017  Royal Challengers Bangalore   \n",
       "\n",
       "                         team2                  toss_winner toss_decision  \\\n",
       "0  Royal Challengers Bangalore  Royal Challengers Bangalore         field   \n",
       "1       Rising Pune Supergiant       Rising Pune Supergiant         field   \n",
       "2        Kolkata Knight Riders        Kolkata Knight Riders         field   \n",
       "3              Kings XI Punjab              Kings XI Punjab         field   \n",
       "4             Delhi Daredevils  Royal Challengers Bangalore           bat   \n",
       "\n",
       "   result  dl_applied                       winner  win_by_runs  \\\n",
       "0  normal           0          Sunrisers Hyderabad           35   \n",
       "1  normal           0       Rising Pune Supergiant            0   \n",
       "2  normal           0        Kolkata Knight Riders            0   \n",
       "3  normal           0              Kings XI Punjab            0   \n",
       "4  normal           0  Royal Challengers Bangalore           15   \n",
       "\n",
       "   win_by_wickets player_of_match                                      venue  \\\n",
       "0               0    Yuvraj Singh  Rajiv Gandhi International Stadium, Uppal   \n",
       "1               7       SPD Smith    Maharashtra Cricket Association Stadium   \n",
       "2              10         CA Lynn     Saurashtra Cricket Association Stadium   \n",
       "3               6      GJ Maxwell                     Holkar Cricket Stadium   \n",
       "4               0       KM Jadhav                      M Chinnaswamy Stadium   \n",
       "\n",
       "          umpire1        umpire2 umpire3  \n",
       "0     AY Dandekar       NJ Llong     NaN  \n",
       "1  A Nand Kishore         S Ravi     NaN  \n",
       "2     Nitin Menon      CK Nandan     NaN  \n",
       "3    AK Chaudhary  C Shamshuddin     NaN  \n",
       "4             NaN            NaN     NaN  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches = pd.read_csv('matches.csv')\n",
    "deliveries = pd.read_csv('deliveries.csv')\n",
    "matches.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "((756, 18), (179078, 21))"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches.shape,deliveries.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>batsman</th>\n",
       "      <th>non_striker</th>\n",
       "      <th>bowler</th>\n",
       "      <th>is_super_over</th>\n",
       "      <th>...</th>\n",
       "      <th>bye_runs</th>\n",
       "      <th>legbye_runs</th>\n",
       "      <th>noball_runs</th>\n",
       "      <th>penalty_runs</th>\n",
       "      <th>batsman_runs</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs</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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td>S Dhawan</td>\n",
       "      <td>TS Mills</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td>S Dhawan</td>\n",
       "      <td>TS Mills</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td>S Dhawan</td>\n",
       "      <td>TS Mills</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td>S Dhawan</td>\n",
       "      <td>TS Mills</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td>S Dhawan</td>\n",
       "      <td>TS Mills</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   match_id  inning         batting_team                 bowling_team  over  \\\n",
       "0         1       1  Sunrisers Hyderabad  Royal Challengers Bangalore     1   \n",
       "1         1       1  Sunrisers Hyderabad  Royal Challengers Bangalore     1   \n",
       "2         1       1  Sunrisers Hyderabad  Royal Challengers Bangalore     1   \n",
       "3         1       1  Sunrisers Hyderabad  Royal Challengers Bangalore     1   \n",
       "4         1       1  Sunrisers Hyderabad  Royal Challengers Bangalore     1   \n",
       "\n",
       "   ball    batsman non_striker    bowler  is_super_over  ...  bye_runs  \\\n",
       "0     1  DA Warner    S Dhawan  TS Mills              0  ...         0   \n",
       "1     2  DA Warner    S Dhawan  TS Mills              0  ...         0   \n",
       "2     3  DA Warner    S Dhawan  TS Mills              0  ...         0   \n",
       "3     4  DA Warner    S Dhawan  TS Mills              0  ...         0   \n",
       "4     5  DA Warner    S Dhawan  TS Mills              0  ...         0   \n",
       "\n",
       "   legbye_runs  noball_runs  penalty_runs  batsman_runs  extra_runs  \\\n",
       "0            0            0             0             0           0   \n",
       "1            0            0             0             0           0   \n",
       "2            0            0             0             4           0   \n",
       "3            0            0             0             0           0   \n",
       "4            0            0             0             0           2   \n",
       "\n",
       "   total_runs  player_dismissed dismissal_kind fielder  \n",
       "0           0               NaN            NaN     NaN  \n",
       "1           0               NaN            NaN     NaN  \n",
       "2           4               NaN            NaN     NaN  \n",
       "3           0               NaN            NaN     NaN  \n",
       "4           2               NaN            NaN     NaN  \n",
       "\n",
       "[5 rows x 21 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "deliveries.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['match_id', 'inning', 'batting_team', 'bowling_team', 'over', 'ball',\n",
       "       'batsman', 'non_striker', 'bowler', 'is_super_over', 'wide_runs',\n",
       "       'bye_runs', 'legbye_runs', 'noball_runs', 'penalty_runs',\n",
       "       'batsman_runs', 'extra_runs', 'total_runs', 'player_dismissed',\n",
       "       'dismissal_kind', 'fielder'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "deliveries.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1523</th>\n",
       "      <td>11413</td>\n",
       "      <td>2</td>\n",
       "      <td>170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1524</th>\n",
       "      <td>11414</td>\n",
       "      <td>1</td>\n",
       "      <td>155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1525</th>\n",
       "      <td>11414</td>\n",
       "      <td>2</td>\n",
       "      <td>162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1526</th>\n",
       "      <td>11415</td>\n",
       "      <td>1</td>\n",
       "      <td>152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1527</th>\n",
       "      <td>11415</td>\n",
       "      <td>2</td>\n",
       "      <td>157</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1528 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      match_id  inning  total_runs\n",
       "0            1       1         207\n",
       "1            1       2         172\n",
       "2            2       1         184\n",
       "3            2       2         187\n",
       "4            3       1         183\n",
       "...        ...     ...         ...\n",
       "1523     11413       2         170\n",
       "1524     11414       1         155\n",
       "1525     11414       2         162\n",
       "1526     11415       1         152\n",
       "1527     11415       2         157\n",
       "\n",
       "[1528 rows x 3 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# grouping the 1st innings,2nd innings score in a particular matchid\n",
    "# lets say match id = 1,so inning 1 score = 207,inning 2 score = 172,in that way\n",
    "\n",
    "totalrun_df = deliveries.groupby(['match_id','inning']).sum()['total_runs'].reset_index()\n",
    "\n",
    "totalrun_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\meet\\anaconda3\\envs\\tensorflow--new\\lib\\site-packages\\ipykernel_launcher.py:4: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  after removing the cwd from sys.path.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1518</th>\n",
       "      <td>11347</td>\n",
       "      <td>1</td>\n",
       "      <td>144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1520</th>\n",
       "      <td>11412</td>\n",
       "      <td>1</td>\n",
       "      <td>137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1522</th>\n",
       "      <td>11413</td>\n",
       "      <td>1</td>\n",
       "      <td>172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1524</th>\n",
       "      <td>11414</td>\n",
       "      <td>1</td>\n",
       "      <td>156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1526</th>\n",
       "      <td>11415</td>\n",
       "      <td>1</td>\n",
       "      <td>153</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>756 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      match_id  inning  total_runs\n",
       "0            1       1         208\n",
       "2            2       1         185\n",
       "4            3       1         184\n",
       "6            4       1         164\n",
       "8            5       1         158\n",
       "...        ...     ...         ...\n",
       "1518     11347       1         144\n",
       "1520     11412       1         137\n",
       "1522     11413       1         172\n",
       "1524     11414       1         156\n",
       "1526     11415       1         153\n",
       "\n",
       "[756 rows x 3 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# capturing only the first innings,as we will be predicting for the second innnigs\n",
    "\n",
    "totalrun_df = totalrun_df[totalrun_df['inning']==1]\n",
    "totalrun_df['total_runs'] = totalrun_df['total_runs'].apply(lambda x:x+1)\n",
    "totalrun_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['id', 'Season', 'city', 'date', 'team1', 'team2', 'toss_winner',\n",
       "       'toss_decision', 'result', 'dl_applied', 'winner', 'win_by_runs',\n",
       "       'win_by_wickets', 'player_of_match', 'venue', 'umpire1', 'umpire2',\n",
       "       'umpire3'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matches.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": true
   },
   "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>team1</th>\n",
       "      <th>team2</th>\n",
       "      <th>toss_winner</th>\n",
       "      <th>toss_decision</th>\n",
       "      <th>result</th>\n",
       "      <th>dl_applied</th>\n",
       "      <th>winner</th>\n",
       "      <th>win_by_runs</th>\n",
       "      <th>win_by_wickets</th>\n",
       "      <th>player_of_match</th>\n",
       "      <th>venue</th>\n",
       "      <th>umpire1</th>\n",
       "      <th>umpire2</th>\n",
       "      <th>umpire3</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>1</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>05-04-2017</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>Yuvraj Singh</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>AY Dandekar</td>\n",
       "      <td>NJ Llong</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Pune</td>\n",
       "      <td>06-04-2017</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Rising Pune Supergiant</td>\n",
       "      <td>Rising Pune Supergiant</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Rising Pune Supergiant</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>SPD Smith</td>\n",
       "      <td>Maharashtra Cricket Association Stadium</td>\n",
       "      <td>A Nand Kishore</td>\n",
       "      <td>S Ravi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Rajkot</td>\n",
       "      <td>07-04-2017</td>\n",
       "      <td>Gujarat Lions</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>CA Lynn</td>\n",
       "      <td>Saurashtra Cricket Association Stadium</td>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td>CK Nandan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Indore</td>\n",
       "      <td>08-04-2017</td>\n",
       "      <td>Rising Pune Supergiant</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>GJ Maxwell</td>\n",
       "      <td>Holkar Cricket Stadium</td>\n",
       "      <td>AK Chaudhary</td>\n",
       "      <td>C Shamshuddin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>08-04-2017</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>bat</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>KM Jadhav</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>158</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>751</th>\n",
       "      <td>11347</td>\n",
       "      <td>IPL-2019</td>\n",
       "      <td>Mumbai</td>\n",
       "      <td>05-05-2019</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>HH Pandya</td>\n",
       "      <td>Wankhede Stadium</td>\n",
       "      <td>Nanda Kishore</td>\n",
       "      <td>O Nandan</td>\n",
       "      <td>S Ravi</td>\n",
       "      <td>11347</td>\n",
       "      <td>144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td>11412</td>\n",
       "      <td>IPL-2019</td>\n",
       "      <td>Chennai</td>\n",
       "      <td>07-05-2019</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>bat</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>AS Yadav</td>\n",
       "      <td>M. A. Chidambaram Stadium</td>\n",
       "      <td>Nigel Llong</td>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td>Ian Gould</td>\n",
       "      <td>11412</td>\n",
       "      <td>137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>753</th>\n",
       "      <td>11413</td>\n",
       "      <td>IPL-2019</td>\n",
       "      <td>Visakhapatnam</td>\n",
       "      <td>08-05-2019</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>RR Pant</td>\n",
       "      <td>ACA-VDCA Stadium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11413</td>\n",
       "      <td>172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>754</th>\n",
       "      <td>11414</td>\n",
       "      <td>IPL-2019</td>\n",
       "      <td>Visakhapatnam</td>\n",
       "      <td>10-05-2019</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>F du Plessis</td>\n",
       "      <td>ACA-VDCA Stadium</td>\n",
       "      <td>Sundaram Ravi</td>\n",
       "      <td>Bruce Oxenford</td>\n",
       "      <td>Chettithody Shamshuddin</td>\n",
       "      <td>11414</td>\n",
       "      <td>156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>755</th>\n",
       "      <td>11415</td>\n",
       "      <td>IPL-2019</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>12-05-2019</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>bat</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>JJ Bumrah</td>\n",
       "      <td>Rajiv Gandhi Intl. Cricket Stadium</td>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td>Ian Gould</td>\n",
       "      <td>Nigel Llong</td>\n",
       "      <td>11415</td>\n",
       "      <td>153</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>756 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id    Season           city        date                        team1  \\\n",
       "0        1  IPL-2017      Hyderabad  05-04-2017          Sunrisers Hyderabad   \n",
       "1        2  IPL-2017           Pune  06-04-2017               Mumbai Indians   \n",
       "2        3  IPL-2017         Rajkot  07-04-2017                Gujarat Lions   \n",
       "3        4  IPL-2017         Indore  08-04-2017       Rising Pune Supergiant   \n",
       "4        5  IPL-2017      Bangalore  08-04-2017  Royal Challengers Bangalore   \n",
       "..     ...       ...            ...         ...                          ...   \n",
       "751  11347  IPL-2019         Mumbai  05-05-2019        Kolkata Knight Riders   \n",
       "752  11412  IPL-2019        Chennai  07-05-2019          Chennai Super Kings   \n",
       "753  11413  IPL-2019  Visakhapatnam  08-05-2019          Sunrisers Hyderabad   \n",
       "754  11414  IPL-2019  Visakhapatnam  10-05-2019               Delhi Capitals   \n",
       "755  11415  IPL-2019      Hyderabad  12-05-2019               Mumbai Indians   \n",
       "\n",
       "                           team2                  toss_winner toss_decision  \\\n",
       "0    Royal Challengers Bangalore  Royal Challengers Bangalore         field   \n",
       "1         Rising Pune Supergiant       Rising Pune Supergiant         field   \n",
       "2          Kolkata Knight Riders        Kolkata Knight Riders         field   \n",
       "3                Kings XI Punjab              Kings XI Punjab         field   \n",
       "4               Delhi Daredevils  Royal Challengers Bangalore           bat   \n",
       "..                           ...                          ...           ...   \n",
       "751               Mumbai Indians               Mumbai Indians         field   \n",
       "752               Mumbai Indians          Chennai Super Kings           bat   \n",
       "753               Delhi Capitals               Delhi Capitals         field   \n",
       "754          Chennai Super Kings          Chennai Super Kings         field   \n",
       "755          Chennai Super Kings               Mumbai Indians           bat   \n",
       "\n",
       "     result  dl_applied                       winner  win_by_runs  \\\n",
       "0    normal           0          Sunrisers Hyderabad           35   \n",
       "1    normal           0       Rising Pune Supergiant            0   \n",
       "2    normal           0        Kolkata Knight Riders            0   \n",
       "3    normal           0              Kings XI Punjab            0   \n",
       "4    normal           0  Royal Challengers Bangalore           15   \n",
       "..      ...         ...                          ...          ...   \n",
       "751  normal           0               Mumbai Indians            0   \n",
       "752  normal           0               Mumbai Indians            0   \n",
       "753  normal           0               Delhi Capitals            0   \n",
       "754  normal           0          Chennai Super Kings            0   \n",
       "755  normal           0               Mumbai Indians            1   \n",
       "\n",
       "     win_by_wickets player_of_match  \\\n",
       "0                 0    Yuvraj Singh   \n",
       "1                 7       SPD Smith   \n",
       "2                10         CA Lynn   \n",
       "3                 6      GJ Maxwell   \n",
       "4                 0       KM Jadhav   \n",
       "..              ...             ...   \n",
       "751               9       HH Pandya   \n",
       "752               6        AS Yadav   \n",
       "753               2         RR Pant   \n",
       "754               6    F du Plessis   \n",
       "755               0       JJ Bumrah   \n",
       "\n",
       "                                         venue         umpire1  \\\n",
       "0    Rajiv Gandhi International Stadium, Uppal     AY Dandekar   \n",
       "1      Maharashtra Cricket Association Stadium  A Nand Kishore   \n",
       "2       Saurashtra Cricket Association Stadium     Nitin Menon   \n",
       "3                       Holkar Cricket Stadium    AK Chaudhary   \n",
       "4                        M Chinnaswamy Stadium             NaN   \n",
       "..                                         ...             ...   \n",
       "751                           Wankhede Stadium   Nanda Kishore   \n",
       "752                  M. A. Chidambaram Stadium     Nigel Llong   \n",
       "753                           ACA-VDCA Stadium             NaN   \n",
       "754                           ACA-VDCA Stadium   Sundaram Ravi   \n",
       "755         Rajiv Gandhi Intl. Cricket Stadium     Nitin Menon   \n",
       "\n",
       "            umpire2                  umpire3  match_id  total_runs  \n",
       "0          NJ Llong                      NaN         1         208  \n",
       "1            S Ravi                      NaN         2         185  \n",
       "2         CK Nandan                      NaN         3         184  \n",
       "3     C Shamshuddin                      NaN         4         164  \n",
       "4               NaN                      NaN         5         158  \n",
       "..              ...                      ...       ...         ...  \n",
       "751        O Nandan                   S Ravi     11347         144  \n",
       "752     Nitin Menon                Ian Gould     11412         137  \n",
       "753             NaN                      NaN     11413         172  \n",
       "754  Bruce Oxenford  Chettithody Shamshuddin     11414         156  \n",
       "755       Ian Gould              Nigel Llong     11415         153  \n",
       "\n",
       "[756 rows x 20 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''\n",
    "Merging the total first innings score df with the matches df,\n",
    "where left side merging is done on \"id\" column of the matches\n",
    "and right side merging is done on \"match_id\" column of the totalrun_df\n",
    "\n",
    "'''\n",
    "\n",
    "match_df = matches.merge(totalrun_df[['match_id','total_runs']],\n",
    "                       left_on='id',right_on='match_id')\n",
    "\n",
    "match_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Sunrisers Hyderabad', 'Mumbai Indians', 'Gujarat Lions',\n",
       "       'Rising Pune Supergiant', 'Royal Challengers Bangalore',\n",
       "       'Kolkata Knight Riders', 'Delhi Daredevils', 'Kings XI Punjab',\n",
       "       'Chennai Super Kings', 'Rajasthan Royals', 'Deccan Chargers',\n",
       "       'Kochi Tuskers Kerala', 'Pune Warriors', 'Rising Pune Supergiants',\n",
       "       'Delhi Capitals'], dtype=object)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "match_df['team1'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "teams = [\n",
    "    'Sunrisers Hyderabad',\n",
    "    'Mumbai Indians',\n",
    "    'Royal Challengers Bangalore',\n",
    "    'Kolkata Knight Riders',\n",
    "    'Kings XI Punjab',\n",
    "    'Chennai Super Kings',\n",
    "    'Rajasthan Royals',\n",
    "    'Delhi Capitals'\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# replacing the Delhi Daredevils with Delhi Capitals\n",
    "\n",
    "match_df['team1'] = match_df['team1'].str.replace('Delhi Daredevils','Delhi Capitals')\n",
    "match_df['team2'] = match_df['team2'].str.replace('Delhi Daredevils','Delhi Capitals')\n",
    "\n",
    "\n",
    "# replacing the Deccan Chargers with Sunrises Hyderabad\n",
    "\n",
    "match_df['team1'] = match_df['team1'].str.replace('Deccan Chargers','Sunrisers Hyderabad')\n",
    "match_df['team2'] = match_df['team2'].str.replace('Deccan Chargers','Sunrisers Hyderabad')\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Sunrisers Hyderabad', 'Royal Challengers Bangalore',\n",
       "       'Kolkata Knight Riders', 'Kings XI Punjab', 'Delhi Capitals',\n",
       "       'Mumbai Indians', 'Chennai Super Kings', 'Rajasthan Royals'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# will consider only frequently occuring teams,\n",
    "# which are mentioned in the teams list\n",
    "\n",
    "match_df = match_df[match_df['team1'].isin(teams)]\n",
    "match_df = match_df[match_df['team2'].isin(teams)]\n",
    "\n",
    "match_df['team1'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(641, 20)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "match_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>team1</th>\n",
       "      <th>team2</th>\n",
       "      <th>toss_winner</th>\n",
       "      <th>toss_decision</th>\n",
       "      <th>result</th>\n",
       "      <th>dl_applied</th>\n",
       "      <th>winner</th>\n",
       "      <th>win_by_runs</th>\n",
       "      <th>win_by_wickets</th>\n",
       "      <th>player_of_match</th>\n",
       "      <th>venue</th>\n",
       "      <th>umpire1</th>\n",
       "      <th>umpire2</th>\n",
       "      <th>umpire3</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>1</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>05-04-2017</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>Yuvraj Singh</td>\n",
       "      <td>Rajiv Gandhi International Stadium, Uppal</td>\n",
       "      <td>AY Dandekar</td>\n",
       "      <td>NJ Llong</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>08-04-2017</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>bat</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>KM Jadhav</td>\n",
       "      <td>M Chinnaswamy Stadium</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Mumbai</td>\n",
       "      <td>09-04-2017</td>\n",
       "      <td>Kolkata Knight Riders</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>N Rana</td>\n",
       "      <td>Wankhede Stadium</td>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td>CK Nandan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Indore</td>\n",
       "      <td>10-04-2017</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>bat</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>AR Patel</td>\n",
       "      <td>Holkar Cricket Stadium</td>\n",
       "      <td>AK Chaudhary</td>\n",
       "      <td>C Shamshuddin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>IPL-2017</td>\n",
       "      <td>Mumbai</td>\n",
       "      <td>12-04-2017</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>JJ Bumrah</td>\n",
       "      <td>Wankhede Stadium</td>\n",
       "      <td>Nitin Menon</td>\n",
       "      <td>CK Nandan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>159</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id    Season       city        date                        team1  \\\n",
       "0   1  IPL-2017  Hyderabad  05-04-2017          Sunrisers Hyderabad   \n",
       "4   5  IPL-2017  Bangalore  08-04-2017  Royal Challengers Bangalore   \n",
       "6   7  IPL-2017     Mumbai  09-04-2017        Kolkata Knight Riders   \n",
       "7   8  IPL-2017     Indore  10-04-2017  Royal Challengers Bangalore   \n",
       "9  10  IPL-2017     Mumbai  12-04-2017          Sunrisers Hyderabad   \n",
       "\n",
       "                         team2                  toss_winner toss_decision  \\\n",
       "0  Royal Challengers Bangalore  Royal Challengers Bangalore         field   \n",
       "4               Delhi Capitals  Royal Challengers Bangalore           bat   \n",
       "6               Mumbai Indians               Mumbai Indians         field   \n",
       "7              Kings XI Punjab  Royal Challengers Bangalore           bat   \n",
       "9               Mumbai Indians               Mumbai Indians         field   \n",
       "\n",
       "   result  dl_applied                       winner  win_by_runs  \\\n",
       "0  normal           0          Sunrisers Hyderabad           35   \n",
       "4  normal           0  Royal Challengers Bangalore           15   \n",
       "6  normal           0               Mumbai Indians            0   \n",
       "7  normal           0              Kings XI Punjab            0   \n",
       "9  normal           0               Mumbai Indians            0   \n",
       "\n",
       "   win_by_wickets player_of_match                                      venue  \\\n",
       "0               0    Yuvraj Singh  Rajiv Gandhi International Stadium, Uppal   \n",
       "4               0       KM Jadhav                      M Chinnaswamy Stadium   \n",
       "6               4          N Rana                           Wankhede Stadium   \n",
       "7               8        AR Patel                     Holkar Cricket Stadium   \n",
       "9               4       JJ Bumrah                           Wankhede Stadium   \n",
       "\n",
       "        umpire1        umpire2 umpire3  match_id  total_runs  \n",
       "0   AY Dandekar       NJ Llong     NaN         1         208  \n",
       "4           NaN            NaN     NaN         5         158  \n",
       "6   Nitin Menon      CK Nandan     NaN         7         179  \n",
       "7  AK Chaudhary  C Shamshuddin     NaN         8         149  \n",
       "9   Nitin Menon      CK Nandan     NaN        10         159  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "match_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col11,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col18,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col12,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col12,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col11,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col12,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col12,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col12,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col11,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col19,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col11,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col12,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col11,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col12,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col12,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col11,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col9,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col12{\n",
       "            background-color:  #0d0887;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col12{\n",
       "            background-color:  #f2844b;\n",
       "            color:  #000000;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col19{\n",
       "            background-color:  #9613a1;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col18,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col18{\n",
       "            background-color:  #100788;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col11,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col18{\n",
       "            background-color:  #350498;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col19{\n",
       "            background-color:  #7801a8;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col11{\n",
       "            background-color:  #240691;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col19{\n",
       "            background-color:  #c9447a;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col18,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col18,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col18{\n",
       "            background-color:  #130789;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col12,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col11,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col19,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col18,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col18,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col18{\n",
       "            background-color:  #f0f921;\n",
       "            color:  #000000;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col19,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col11,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col11{\n",
       "            background-color:  #4b03a1;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col11{\n",
       "            background-color:  #5002a2;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col19{\n",
       "            background-color:  #da5a6a;\n",
       "            color:  #000000;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col11{\n",
       "            background-color:  #5502a4;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col19{\n",
       "            background-color:  #fba238;\n",
       "            color:  #000000;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col18,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col18{\n",
       "            background-color:  #20068f;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col19{\n",
       "            background-color:  #6c00a8;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col12{\n",
       "            background-color:  #b12a90;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col18{\n",
       "            background-color:  #2e0595;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col12{\n",
       "            background-color:  #fca636;\n",
       "            color:  #000000;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col19{\n",
       "            background-color:  #bd3786;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col18{\n",
       "            background-color:  #2f0596;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col11{\n",
       "            background-color:  #6700a8;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col19{\n",
       "            background-color:  #f48849;\n",
       "            color:  #000000;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col0,#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col18{\n",
       "            background-color:  #310597;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col12{\n",
       "            background-color:  #e16462;\n",
       "            color:  #000000;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col19{\n",
       "            background-color:  #aa2395;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col19{\n",
       "            background-color:  #d6556d;\n",
       "            color:  #000000;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col12{\n",
       "            background-color:  #fcce25;\n",
       "            color:  #000000;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col19{\n",
       "            background-color:  #fcd225;\n",
       "            color:  #000000;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col11{\n",
       "            background-color:  #2a0593;\n",
       "            color:  #f1f1f1;\n",
       "        }#T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col19{\n",
       "            background-color:  #f9dd25;\n",
       "            color:  #000000;\n",
       "        }</style><table id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >id</th>        <th class=\"col_heading level0 col1\" >Season</th>        <th class=\"col_heading level0 col2\" >city</th>        <th class=\"col_heading level0 col3\" >date</th>        <th class=\"col_heading level0 col4\" >team1</th>        <th class=\"col_heading level0 col5\" >team2</th>        <th class=\"col_heading level0 col6\" >toss_winner</th>        <th class=\"col_heading level0 col7\" >toss_decision</th>        <th class=\"col_heading level0 col8\" >result</th>        <th class=\"col_heading level0 col9\" >dl_applied</th>        <th class=\"col_heading level0 col10\" >winner</th>        <th class=\"col_heading level0 col11\" >win_by_runs</th>        <th class=\"col_heading level0 col12\" >win_by_wickets</th>        <th class=\"col_heading level0 col13\" >player_of_match</th>        <th class=\"col_heading level0 col14\" >venue</th>        <th class=\"col_heading level0 col15\" >umpire1</th>        <th class=\"col_heading level0 col16\" >umpire2</th>        <th class=\"col_heading level0 col17\" >umpire3</th>        <th class=\"col_heading level0 col18\" >match_id</th>        <th class=\"col_heading level0 col19\" >total_runs</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row0\" class=\"row_heading level0 row0\" >56</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col0\" class=\"data row0 col0\" >57</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col1\" class=\"data row0 col1\" >IPL-2017</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col2\" class=\"data row0 col2\" >Bangalore</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col3\" class=\"data row0 col3\" >17-05-2017</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col4\" class=\"data row0 col4\" >Sunrisers Hyderabad</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col5\" class=\"data row0 col5\" >Kolkata Knight Riders</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col6\" class=\"data row0 col6\" >Kolkata Knight Riders</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col7\" class=\"data row0 col7\" >field</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col8\" class=\"data row0 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col9\" class=\"data row0 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col10\" class=\"data row0 col10\" >Kolkata Knight Riders</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col11\" class=\"data row0 col11\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col12\" class=\"data row0 col12\" >7</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col13\" class=\"data row0 col13\" >NM Coulter-Nile</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col14\" class=\"data row0 col14\" >M Chinnaswamy Stadium</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col15\" class=\"data row0 col15\" >AK Chaudhary</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col16\" class=\"data row0 col16\" >Nitin Menon</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col17\" class=\"data row0 col17\" >nan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col18\" class=\"data row0 col18\" >57</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row0_col19\" class=\"data row0 col19\" >129</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row1\" class=\"row_heading level0 row1\" >99</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col0\" class=\"data row1 col0\" >100</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col1\" class=\"data row1 col1\" >IPL-2008</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col2\" class=\"data row1 col2\" >Delhi</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col3\" class=\"data row1 col3\" >17-05-2008</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col4\" class=\"data row1 col4\" >Delhi Capitals</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col5\" class=\"data row1 col5\" >Kings XI Punjab</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col6\" class=\"data row1 col6\" >Delhi Daredevils</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col7\" class=\"data row1 col7\" >bat</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col8\" class=\"data row1 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col9\" class=\"data row1 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col10\" class=\"data row1 col10\" >Kings XI Punjab</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col11\" class=\"data row1 col11\" >6</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col12\" class=\"data row1 col12\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col13\" class=\"data row1 col13\" >DPMD Jayawardene</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col14\" class=\"data row1 col14\" >Feroz Shah Kotla</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col15\" class=\"data row1 col15\" >AV Jayaprakash</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col16\" class=\"data row1 col16\" >RE Koertzen</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col17\" class=\"data row1 col17\" >nan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col18\" class=\"data row1 col18\" >100</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row1_col19\" class=\"data row1 col19\" >119</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row2\" class=\"row_heading level0 row2\" >102</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col0\" class=\"data row2 col0\" >103</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col1\" class=\"data row2 col1\" >IPL-2008</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col2\" class=\"data row2 col2\" >Kolkata</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col3\" class=\"data row2 col3\" >18-05-2008</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col4\" class=\"data row2 col4\" >Kolkata Knight Riders</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col5\" class=\"data row2 col5\" >Chennai Super Kings</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col6\" class=\"data row2 col6\" >Kolkata Knight Riders</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col7\" class=\"data row2 col7\" >bat</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col8\" class=\"data row2 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col9\" class=\"data row2 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col10\" class=\"data row2 col10\" >Chennai Super Kings</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col11\" class=\"data row2 col11\" >3</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col12\" class=\"data row2 col12\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col13\" class=\"data row2 col13\" >M Ntini</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col14\" class=\"data row2 col14\" >Eden Gardens</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col15\" class=\"data row2 col15\" >Asad Rauf</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col16\" class=\"data row2 col16\" >K Hariharan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col17\" class=\"data row2 col17\" >nan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col18\" class=\"data row2 col18\" >103</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row2_col19\" class=\"data row2 col19\" >150</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row3\" class=\"row_heading level0 row3\" >119</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col0\" class=\"data row3 col0\" >120</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col1\" class=\"data row3 col1\" >IPL-2009</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col2\" class=\"data row3 col2\" >Cape Town</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col3\" class=\"data row3 col3\" >19-04-2009</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col4\" class=\"data row3 col4\" >Kings XI Punjab</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col5\" class=\"data row3 col5\" >Delhi Capitals</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col6\" class=\"data row3 col6\" >Delhi Daredevils</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col7\" class=\"data row3 col7\" >field</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col8\" class=\"data row3 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col9\" class=\"data row3 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col10\" class=\"data row3 col10\" >Delhi Daredevils</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col11\" class=\"data row3 col11\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col12\" class=\"data row3 col12\" >10</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col13\" class=\"data row3 col13\" >DL Vettori</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col14\" class=\"data row3 col14\" >Newlands</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col15\" class=\"data row3 col15\" >MR Benson</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col16\" class=\"data row3 col16\" >SD Ranade</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col17\" class=\"data row3 col17\" >nan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col18\" class=\"data row3 col18\" >120</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row3_col19\" class=\"data row3 col19\" >105</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row4\" class=\"row_heading level0 row4\" >122</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col0\" class=\"data row4 col0\" >123</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col1\" class=\"data row4 col1\" >IPL-2009</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col2\" class=\"data row4 col2\" >Durban</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col3\" class=\"data row4 col3\" >21-04-2009</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col4\" class=\"data row4 col4\" >Kings XI Punjab</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col5\" class=\"data row4 col5\" >Kolkata Knight Riders</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col6\" class=\"data row4 col6\" >Kolkata Knight Riders</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col7\" class=\"data row4 col7\" >field</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col8\" class=\"data row4 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col9\" class=\"data row4 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col10\" class=\"data row4 col10\" >Kolkata Knight Riders</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col11\" class=\"data row4 col11\" >11</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col12\" class=\"data row4 col12\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col13\" class=\"data row4 col13\" >CH Gayle</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col14\" class=\"data row4 col14\" >Kingsmead</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col15\" class=\"data row4 col15\" >DJ Harper</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col16\" class=\"data row4 col16\" >SD Ranade</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col17\" class=\"data row4 col17\" >nan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col18\" class=\"data row4 col18\" >123</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row4_col19\" class=\"data row4 col19\" >159</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row5\" class=\"row_heading level0 row5\" >148</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col0\" class=\"data row5 col0\" >149</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col1\" class=\"data row5 col1\" >IPL-2009</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col2\" class=\"data row5 col2\" >Centurion</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col3\" class=\"data row5 col3\" >07-05-2009</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col4\" class=\"data row5 col4\" >Chennai Super Kings</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col5\" class=\"data row5 col5\" >Kings XI Punjab</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col6\" class=\"data row5 col6\" >Chennai Super Kings</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col7\" class=\"data row5 col7\" >bat</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col8\" class=\"data row5 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col9\" class=\"data row5 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col10\" class=\"data row5 col10\" >Chennai Super Kings</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col11\" class=\"data row5 col11\" >12</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col12\" class=\"data row5 col12\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col13\" class=\"data row5 col13\" >ML Hayden</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col14\" class=\"data row5 col14\" >SuperSport Park</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col15\" class=\"data row5 col15\" >DJ Harper</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col16\" class=\"data row5 col16\" >TH Wijewardene</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col17\" class=\"data row5 col17\" >nan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col18\" class=\"data row5 col18\" >149</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row5_col19\" class=\"data row5 col19\" >186</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row6\" class=\"row_heading level0 row6\" >280</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col0\" class=\"data row6 col0\" >281</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col1\" class=\"data row6 col1\" >IPL-2011</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col2\" class=\"data row6 col2\" >Kolkata</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col3\" class=\"data row6 col3\" >07-05-2011</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col4\" class=\"data row6 col4\" >Chennai Super Kings</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col5\" class=\"data row6 col5\" >Kolkata Knight Riders</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col6\" class=\"data row6 col6\" >Chennai Super Kings</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col7\" class=\"data row6 col7\" >bat</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col8\" class=\"data row6 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col9\" class=\"data row6 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col10\" class=\"data row6 col10\" >Kolkata Knight Riders</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col11\" class=\"data row6 col11\" >10</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col12\" class=\"data row6 col12\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col13\" class=\"data row6 col13\" >Iqbal Abdulla</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col14\" class=\"data row6 col14\" >Eden Gardens</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col15\" class=\"data row6 col15\" >Asad Rauf</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col16\" class=\"data row6 col16\" >PR Reiffel</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col17\" class=\"data row6 col17\" >nan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col18\" class=\"data row6 col18\" >281</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row6_col19\" class=\"data row6 col19\" >115</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row7\" class=\"row_heading level0 row7\" >290</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col0\" class=\"data row7 col0\" >291</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col1\" class=\"data row7 col1\" >IPL-2011</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col2\" class=\"data row7 col2\" >Bangalore</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col3\" class=\"data row7 col3\" >14-05-2011</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col4\" class=\"data row7 col4\" >Kolkata Knight Riders</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col5\" class=\"data row7 col5\" >Royal Challengers Bangalore</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col6\" class=\"data row7 col6\" >Royal Challengers Bangalore</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col7\" class=\"data row7 col7\" >field</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col8\" class=\"data row7 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col9\" class=\"data row7 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col10\" class=\"data row7 col10\" >Royal Challengers Bangalore</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col11\" class=\"data row7 col11\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col12\" class=\"data row7 col12\" >4</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col13\" class=\"data row7 col13\" >CH Gayle</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col14\" class=\"data row7 col14\" >M Chinnaswamy Stadium</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col15\" class=\"data row7 col15\" >RE Koertzen</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col16\" class=\"data row7 col16\" >RB Tiffin</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col17\" class=\"data row7 col17\" >nan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col18\" class=\"data row7 col18\" >291</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row7_col19\" class=\"data row7 col19\" >90</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row8\" class=\"row_heading level0 row8\" >488</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col0\" class=\"data row8 col0\" >489</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col1\" class=\"data row8 col1\" >IPL-2014</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col2\" class=\"data row8 col2\" >Delhi</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col3\" class=\"data row8 col3\" >10-05-2014</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col4\" class=\"data row8 col4\" >Delhi Capitals</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col5\" class=\"data row8 col5\" >Sunrisers Hyderabad</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col6\" class=\"data row8 col6\" >Sunrisers Hyderabad</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col7\" class=\"data row8 col7\" >field</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col8\" class=\"data row8 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col9\" class=\"data row8 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col10\" class=\"data row8 col10\" >Sunrisers Hyderabad</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col11\" class=\"data row8 col11\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col12\" class=\"data row8 col12\" >8</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col13\" class=\"data row8 col13\" >DW Steyn</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col14\" class=\"data row8 col14\" >Feroz Shah Kotla</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col15\" class=\"data row8 col15\" >RM Deshpande</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col16\" class=\"data row8 col16\" >BNJ Oxenford</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col17\" class=\"data row8 col17\" >nan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col18\" class=\"data row8 col18\" >489</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row8_col19\" class=\"data row8 col19\" >144</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row9\" class=\"row_heading level0 row9\" >536</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col0\" class=\"data row9 col0\" >537</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col1\" class=\"data row9 col1\" >IPL-2015</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col2\" class=\"data row9 col2\" >Visakhapatnam</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col3\" class=\"data row9 col3\" >22-04-2015</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col4\" class=\"data row9 col4\" >Sunrisers Hyderabad</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col5\" class=\"data row9 col5\" >Kolkata Knight Riders</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col6\" class=\"data row9 col6\" >Kolkata Knight Riders</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col7\" class=\"data row9 col7\" >field</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col8\" class=\"data row9 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col9\" class=\"data row9 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col10\" class=\"data row9 col10\" >Sunrisers Hyderabad</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col11\" class=\"data row9 col11\" >16</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col12\" class=\"data row9 col12\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col13\" class=\"data row9 col13\" >DA Warner</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col14\" class=\"data row9 col14\" >Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col15\" class=\"data row9 col15\" >RK Illingworth</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col16\" class=\"data row9 col16\" >VA Kulkarni</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col17\" class=\"data row9 col17\" >nan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col18\" class=\"data row9 col18\" >537</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row9_col19\" class=\"data row9 col19\" >177</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row10\" class=\"row_heading level0 row10\" >567</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col0\" class=\"data row10 col0\" >568</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col1\" class=\"data row10 col1\" >IPL-2015</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col2\" class=\"data row10 col2\" >Hyderabad</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col3\" class=\"data row10 col3\" >15-05-2015</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col4\" class=\"data row10 col4\" >Sunrisers Hyderabad</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col5\" class=\"data row10 col5\" >Royal Challengers Bangalore</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col6\" class=\"data row10 col6\" >Sunrisers Hyderabad</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col7\" class=\"data row10 col7\" >bat</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col8\" class=\"data row10 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col9\" class=\"data row10 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col10\" class=\"data row10 col10\" >Royal Challengers Bangalore</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col11\" class=\"data row10 col11\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col12\" class=\"data row10 col12\" >6</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col13\" class=\"data row10 col13\" >V Kohli</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col14\" class=\"data row10 col14\" >Rajiv Gandhi International Stadium, Uppal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col15\" class=\"data row10 col15\" >AK Chaudhary</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col16\" class=\"data row10 col16\" >HDPK Dharmasena</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col17\" class=\"data row10 col17\" >nan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col18\" class=\"data row10 col18\" >568</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row10_col19\" class=\"data row10 col19\" >136</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row11\" class=\"row_heading level0 row11\" >625</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col0\" class=\"data row11 col0\" >626</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col1\" class=\"data row11 col1\" >IPL-2016</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col2\" class=\"data row11 col2\" >Bangalore</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col3\" class=\"data row11 col3\" >18-05-2016</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col4\" class=\"data row11 col4\" >Royal Challengers Bangalore</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col5\" class=\"data row11 col5\" >Kings XI Punjab</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col6\" class=\"data row11 col6\" >Kings XI Punjab</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col7\" class=\"data row11 col7\" >field</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col8\" class=\"data row11 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col9\" class=\"data row11 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col10\" class=\"data row11 col10\" >Royal Challengers Bangalore</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col11\" class=\"data row11 col11\" >82</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col12\" class=\"data row11 col12\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col13\" class=\"data row11 col13\" >V Kohli</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col14\" class=\"data row11 col14\" >M Chinnaswamy Stadium</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col15\" class=\"data row11 col15\" >KN Ananthapadmanabhan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col16\" class=\"data row11 col16\" >M Erasmus</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col17\" class=\"data row11 col17\" >nan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col18\" class=\"data row11 col18\" >626</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row11_col19\" class=\"data row11 col19\" >212</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row12\" class=\"row_heading level0 row12\" >641</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col0\" class=\"data row12 col0\" >7899</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col1\" class=\"data row12 col1\" >IPL-2018</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col2\" class=\"data row12 col2\" >Jaipur</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col3\" class=\"data row12 col3\" >11-04-2018</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col4\" class=\"data row12 col4\" >Rajasthan Royals</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col5\" class=\"data row12 col5\" >Delhi Capitals</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col6\" class=\"data row12 col6\" >Delhi Daredevils</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col7\" class=\"data row12 col7\" >field</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col8\" class=\"data row12 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col9\" class=\"data row12 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col10\" class=\"data row12 col10\" >Rajasthan Royals</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col11\" class=\"data row12 col11\" >10</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col12\" class=\"data row12 col12\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col13\" class=\"data row12 col13\" >SV Samson</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col14\" class=\"data row12 col14\" >Sawai Mansingh Stadium</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col15\" class=\"data row12 col15\" >K Ananthapadmanabhan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col16\" class=\"data row12 col16\" >Rod Tucker</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col17\" class=\"data row12 col17\" >Nitin Menon</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col18\" class=\"data row12 col18\" >7899</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row12_col19\" class=\"data row12 col19\" >157</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row13\" class=\"row_heading level0 row13\" >653</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col0\" class=\"data row13 col0\" >7911</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col1\" class=\"data row13 col1\" >IPL-2018</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col2\" class=\"data row13 col2\" >Kolkata</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col3\" class=\"data row13 col3\" >21-04-2018</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col4\" class=\"data row13 col4\" >Kolkata Knight Riders</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col5\" class=\"data row13 col5\" >Kings XI Punjab</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col6\" class=\"data row13 col6\" >Kings XI Punjab</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col7\" class=\"data row13 col7\" >field</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col8\" class=\"data row13 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col9\" class=\"data row13 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col10\" class=\"data row13 col10\" >Kings XI Punjab</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col11\" class=\"data row13 col11\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col12\" class=\"data row13 col12\" >9</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col13\" class=\"data row13 col13\" >KL Rahul</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col14\" class=\"data row13 col14\" >Eden Gardens</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col15\" class=\"data row13 col15\" >C Shamshuddin</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col16\" class=\"data row13 col16\" >A.D Deshmukh</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col17\" class=\"data row13 col17\" >S Ravi</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col18\" class=\"data row13 col18\" >7911</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row13_col19\" class=\"data row13 col19\" >201</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748level0_row14\" class=\"row_heading level0 row14\" >667</th>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col0\" class=\"data row14 col0\" >7925</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col1\" class=\"data row14 col1\" >IPL-2018</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col2\" class=\"data row14 col2\" >Delhi</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col3\" class=\"data row14 col3\" >02-05-2018</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col4\" class=\"data row14 col4\" >Delhi Capitals</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col5\" class=\"data row14 col5\" >Rajasthan Royals</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col6\" class=\"data row14 col6\" >Rajasthan Royals</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col7\" class=\"data row14 col7\" >field</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col8\" class=\"data row14 col8\" >normal</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col9\" class=\"data row14 col9\" >1</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col10\" class=\"data row14 col10\" >Delhi Daredevils</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col11\" class=\"data row14 col11\" >4</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col12\" class=\"data row14 col12\" >0</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col13\" class=\"data row14 col13\" >RR Pant</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col14\" class=\"data row14 col14\" >Feroz Shah Kotla</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col15\" class=\"data row14 col15\" >O Nandan</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col16\" class=\"data row14 col16\" >Virender Kumar Sharma</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col17\" class=\"data row14 col17\" >Bruce Oxenford</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col18\" class=\"data row14 col18\" >7925</td>\n",
       "                        <td id=\"T_19bef4dc_2d6c_11ec_aed9_c46516b21748row14_col19\" class=\"data row14 col19\" >204</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x23c3e540dc8>"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# checking the matches which resulted in dl method\n",
    "\n",
    "match_df[match_df['dl_applied']==1].style.background_gradient(cmap = 'plasma')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>match_id</th>\n",
       "      <th>city</th>\n",
       "      <th>winner</th>\n",
       "      <th>total_runs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Mumbai</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Indore</td>\n",
       "      <td>Kings XI Punjab</td>\n",
       "      <td>149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Mumbai</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>751</th>\n",
       "      <td>11347</td>\n",
       "      <td>Mumbai</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td>11412</td>\n",
       "      <td>Chennai</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>753</th>\n",
       "      <td>11413</td>\n",
       "      <td>Visakhapatnam</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>754</th>\n",
       "      <td>11414</td>\n",
       "      <td>Visakhapatnam</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>755</th>\n",
       "      <td>11415</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>153</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>626 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     match_id           city                       winner  total_runs\n",
       "0           1      Hyderabad          Sunrisers Hyderabad         208\n",
       "4           5      Bangalore  Royal Challengers Bangalore         158\n",
       "6           7         Mumbai               Mumbai Indians         179\n",
       "7           8         Indore              Kings XI Punjab         149\n",
       "9          10         Mumbai               Mumbai Indians         159\n",
       "..        ...            ...                          ...         ...\n",
       "751     11347         Mumbai               Mumbai Indians         144\n",
       "752     11412        Chennai               Mumbai Indians         137\n",
       "753     11413  Visakhapatnam               Delhi Capitals         172\n",
       "754     11414  Visakhapatnam          Chennai Super Kings         156\n",
       "755     11415      Hyderabad               Mumbai Indians         153\n",
       "\n",
       "[626 rows x 4 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# ignoring the rows which were DL method\n",
    "\n",
    "match_df = match_df[match_df['dl_applied']==0]\n",
    "\n",
    "# considering the match_id,city,winner and total runs\n",
    "\n",
    "match_df = match_df[['match_id','city','winner','total_runs']]\n",
    "\n",
    "match_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>batsman</th>\n",
       "      <th>non_striker</th>\n",
       "      <th>bowler</th>\n",
       "      <th>is_super_over</th>\n",
       "      <th>...</th>\n",
       "      <th>bye_runs</th>\n",
       "      <th>legbye_runs</th>\n",
       "      <th>noball_runs</th>\n",
       "      <th>penalty_runs</th>\n",
       "      <th>batsman_runs</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs</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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td>S Dhawan</td>\n",
       "      <td>TS Mills</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td>S Dhawan</td>\n",
       "      <td>TS Mills</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td>S Dhawan</td>\n",
       "      <td>TS Mills</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   match_id  inning         batting_team                 bowling_team  over  \\\n",
       "0         1       1  Sunrisers Hyderabad  Royal Challengers Bangalore     1   \n",
       "1         1       1  Sunrisers Hyderabad  Royal Challengers Bangalore     1   \n",
       "2         1       1  Sunrisers Hyderabad  Royal Challengers Bangalore     1   \n",
       "\n",
       "   ball    batsman non_striker    bowler  is_super_over  ...  bye_runs  \\\n",
       "0     1  DA Warner    S Dhawan  TS Mills              0  ...         0   \n",
       "1     2  DA Warner    S Dhawan  TS Mills              0  ...         0   \n",
       "2     3  DA Warner    S Dhawan  TS Mills              0  ...         0   \n",
       "\n",
       "   legbye_runs  noball_runs  penalty_runs  batsman_runs  extra_runs  \\\n",
       "0            0            0             0             0           0   \n",
       "1            0            0             0             0           0   \n",
       "2            0            0             0             4           0   \n",
       "\n",
       "   total_runs  player_dismissed dismissal_kind fielder  \n",
       "0           0               NaN            NaN     NaN  \n",
       "1           0               NaN            NaN     NaN  \n",
       "2           4               NaN            NaN     NaN  \n",
       "\n",
       "[3 rows x 21 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "deliveries.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>batsman</th>\n",
       "      <th>...</th>\n",
       "      <th>bye_runs</th>\n",
       "      <th>legbye_runs</th>\n",
       "      <th>noball_runs</th>\n",
       "      <th>penalty_runs</th>\n",
       "      <th>batsman_runs</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs_y</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>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>1</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>1</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>1</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>1</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>1</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>DA Warner</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   match_id       city               winner  total_runs_x  inning  \\\n",
       "0         1  Hyderabad  Sunrisers Hyderabad           208       1   \n",
       "1         1  Hyderabad  Sunrisers Hyderabad           208       1   \n",
       "2         1  Hyderabad  Sunrisers Hyderabad           208       1   \n",
       "3         1  Hyderabad  Sunrisers Hyderabad           208       1   \n",
       "4         1  Hyderabad  Sunrisers Hyderabad           208       1   \n",
       "\n",
       "          batting_team                 bowling_team  over  ball    batsman  \\\n",
       "0  Sunrisers Hyderabad  Royal Challengers Bangalore     1     1  DA Warner   \n",
       "1  Sunrisers Hyderabad  Royal Challengers Bangalore     1     2  DA Warner   \n",
       "2  Sunrisers Hyderabad  Royal Challengers Bangalore     1     3  DA Warner   \n",
       "3  Sunrisers Hyderabad  Royal Challengers Bangalore     1     4  DA Warner   \n",
       "4  Sunrisers Hyderabad  Royal Challengers Bangalore     1     5  DA Warner   \n",
       "\n",
       "   ... bye_runs legbye_runs  noball_runs  penalty_runs  batsman_runs  \\\n",
       "0  ...        0           0            0             0             0   \n",
       "1  ...        0           0            0             0             0   \n",
       "2  ...        0           0            0             0             4   \n",
       "3  ...        0           0            0             0             0   \n",
       "4  ...        0           0            0             0             0   \n",
       "\n",
       "   extra_runs  total_runs_y  player_dismissed  dismissal_kind  fielder  \n",
       "0           0             0               NaN             NaN      NaN  \n",
       "1           0             0               NaN             NaN      NaN  \n",
       "2           0             4               NaN             NaN      NaN  \n",
       "3           0             0               NaN             NaN      NaN  \n",
       "4           2             2               NaN             NaN      NaN  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# merging matchdf with delevieries on match_id\n",
    "\n",
    "delivery_df = match_df.merge(deliveries,on='match_id')\n",
    "\n",
    "delivery_df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['match_id', 'city', 'winner', 'total_runs_x', 'inning', 'batting_team',\n",
       "       'bowling_team', 'over', 'ball', 'batsman', 'non_striker', 'bowler',\n",
       "       'is_super_over', 'wide_runs', 'bye_runs', 'legbye_runs', 'noball_runs',\n",
       "       'penalty_runs', 'batsman_runs', 'extra_runs', 'total_runs_y',\n",
       "       'player_dismissed', 'dismissal_kind', 'fielder'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "delivery_df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>batsman</th>\n",
       "      <th>...</th>\n",
       "      <th>bye_runs</th>\n",
       "      <th>legbye_runs</th>\n",
       "      <th>noball_runs</th>\n",
       "      <th>penalty_runs</th>\n",
       "      <th>batsman_runs</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs_y</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>125</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>CH Gayle</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     match_id       city               winner  total_runs_x  inning  \\\n",
       "125         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "126         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "127         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "128         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "129         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "\n",
       "                    batting_team         bowling_team  over  ball  \\\n",
       "125  Royal Challengers Bangalore  Sunrisers Hyderabad     1     1   \n",
       "126  Royal Challengers Bangalore  Sunrisers Hyderabad     1     2   \n",
       "127  Royal Challengers Bangalore  Sunrisers Hyderabad     1     3   \n",
       "128  Royal Challengers Bangalore  Sunrisers Hyderabad     1     4   \n",
       "129  Royal Challengers Bangalore  Sunrisers Hyderabad     1     5   \n",
       "\n",
       "           batsman  ... bye_runs legbye_runs  noball_runs  penalty_runs  \\\n",
       "125       CH Gayle  ...        0           0            0             0   \n",
       "126  Mandeep Singh  ...        0           0            0             0   \n",
       "127  Mandeep Singh  ...        0           0            0             0   \n",
       "128  Mandeep Singh  ...        0           0            0             0   \n",
       "129  Mandeep Singh  ...        0           0            0             0   \n",
       "\n",
       "     batsman_runs  extra_runs  total_runs_y  player_dismissed  dismissal_kind  \\\n",
       "125             1           0             1               NaN             NaN   \n",
       "126             0           0             0               NaN             NaN   \n",
       "127             0           0             0               NaN             NaN   \n",
       "128             2           0             2               NaN             NaN   \n",
       "129             4           0             4               NaN             NaN   \n",
       "\n",
       "     fielder  \n",
       "125      NaN  \n",
       "126      NaN  \n",
       "127      NaN  \n",
       "128      NaN  \n",
       "129      NaN  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# considering the 2nd innings \n",
    "\n",
    "delivery_df = delivery_df[delivery_df['inning'] == 2]\n",
    "delivery_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(72413, 24)"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "delivery_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>batsman</th>\n",
       "      <th>...</th>\n",
       "      <th>legbye_runs</th>\n",
       "      <th>noball_runs</th>\n",
       "      <th>penalty_runs</th>\n",
       "      <th>batsman_runs</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs_y</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>125</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>CH Gayle</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>127</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>128</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     match_id       city               winner  total_runs_x  inning  \\\n",
       "125         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "126         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "127         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "128         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "129         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "\n",
       "                    batting_team         bowling_team  over  ball  \\\n",
       "125  Royal Challengers Bangalore  Sunrisers Hyderabad     1     1   \n",
       "126  Royal Challengers Bangalore  Sunrisers Hyderabad     1     2   \n",
       "127  Royal Challengers Bangalore  Sunrisers Hyderabad     1     3   \n",
       "128  Royal Challengers Bangalore  Sunrisers Hyderabad     1     4   \n",
       "129  Royal Challengers Bangalore  Sunrisers Hyderabad     1     5   \n",
       "\n",
       "           batsman  ... legbye_runs noball_runs  penalty_runs  batsman_runs  \\\n",
       "125       CH Gayle  ...           0           0             0             1   \n",
       "126  Mandeep Singh  ...           0           0             0             0   \n",
       "127  Mandeep Singh  ...           0           0             0             0   \n",
       "128  Mandeep Singh  ...           0           0             0             2   \n",
       "129  Mandeep Singh  ...           0           0             0             4   \n",
       "\n",
       "     extra_runs  total_runs_y  player_dismissed  dismissal_kind  fielder  \\\n",
       "125           0             1               NaN             NaN      NaN   \n",
       "126           0             0               NaN             NaN      NaN   \n",
       "127           0             0               NaN             NaN      NaN   \n",
       "128           0             2               NaN             NaN      NaN   \n",
       "129           0             4               NaN             NaN      NaN   \n",
       "\n",
       "     current_score  \n",
       "125              1  \n",
       "126              1  \n",
       "127              1  \n",
       "128              3  \n",
       "129              7  \n",
       "\n",
       "[5 rows x 25 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''\n",
    "So by observation we can observe that in the matchdf we had taken\n",
    "firstinnings total runs,right and in the second case,that is in the \n",
    "delivery dataframe we considered second inning runs,as our main aim\n",
    "is to find the probability of either teams to win or loose,we need \n",
    "current runs and runrate,so for current runs,we can apply groupby\n",
    "on matchid and take the cummulative sum wrt total_runs_y,now,basically\n",
    "totalruns was present in matchdf as well as deliveries_df,but as we merged\n",
    "both the dataframes,it resulted in total_runs_x,and total_runs_y,\n",
    "so total_runs_x is the first innings runs and total_runs_y are the second\n",
    "innings runs,ball by ball,by applying cummulative sum,this becomes \n",
    "current score\n",
    "\n",
    "\n",
    "total_runs_y gives the run scored after each ball,so in the second innings,\n",
    "we want to get the total second innings runs,so we will groupby match id\n",
    "and will apply the cummulative sum\n",
    "\n",
    "\n",
    "'''\n",
    "\n",
    "# current score of particular match\n",
    "\n",
    "delivery_df['current_score'] = delivery_df.groupby('match_id').cumsum()['total_runs_y']\n",
    "\n",
    "delivery_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>batsman</th>\n",
       "      <th>...</th>\n",
       "      <th>noball_runs</th>\n",
       "      <th>penalty_runs</th>\n",
       "      <th>batsman_runs</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs_y</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>125</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>CH Gayle</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>201</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     match_id       city               winner  total_runs_x  inning  \\\n",
       "125         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "126         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "127         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "128         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "129         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "\n",
       "                    batting_team         bowling_team  over  ball  \\\n",
       "125  Royal Challengers Bangalore  Sunrisers Hyderabad     1     1   \n",
       "126  Royal Challengers Bangalore  Sunrisers Hyderabad     1     2   \n",
       "127  Royal Challengers Bangalore  Sunrisers Hyderabad     1     3   \n",
       "128  Royal Challengers Bangalore  Sunrisers Hyderabad     1     4   \n",
       "129  Royal Challengers Bangalore  Sunrisers Hyderabad     1     5   \n",
       "\n",
       "           batsman  ... noball_runs penalty_runs  batsman_runs  extra_runs  \\\n",
       "125       CH Gayle  ...           0            0             1           0   \n",
       "126  Mandeep Singh  ...           0            0             0           0   \n",
       "127  Mandeep Singh  ...           0            0             0           0   \n",
       "128  Mandeep Singh  ...           0            0             2           0   \n",
       "129  Mandeep Singh  ...           0            0             4           0   \n",
       "\n",
       "     total_runs_y  player_dismissed  dismissal_kind  fielder  current_score  \\\n",
       "125             1               NaN             NaN      NaN              1   \n",
       "126             0               NaN             NaN      NaN              1   \n",
       "127             0               NaN             NaN      NaN              1   \n",
       "128             2               NaN             NaN      NaN              3   \n",
       "129             4               NaN             NaN      NaN              7   \n",
       "\n",
       "     runs_left  \n",
       "125        207  \n",
       "126        207  \n",
       "127        207  \n",
       "128        205  \n",
       "129        201  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# runs left \n",
    "\n",
    "delivery_df['runs_left'] = delivery_df['total_runs_x']-delivery_df['current_score']\n",
    "\n",
    "delivery_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>batsman</th>\n",
       "      <th>...</th>\n",
       "      <th>penalty_runs</th>\n",
       "      <th>batsman_runs</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs_y</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>125</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>CH Gayle</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "      <td>118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "      <td>117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>205</td>\n",
       "      <td>116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>201</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>149573</th>\n",
       "      <td>11415</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>153</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>152</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149574</th>\n",
       "      <td>11415</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>153</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>20</td>\n",
       "      <td>3</td>\n",
       "      <td>SR Watson</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>154</td>\n",
       "      <td>-1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149575</th>\n",
       "      <td>11415</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>153</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>20</td>\n",
       "      <td>4</td>\n",
       "      <td>SR Watson</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>SR Watson</td>\n",
       "      <td>run out</td>\n",
       "      <td>KH Pandya</td>\n",
       "      <td>155</td>\n",
       "      <td>-2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149576</th>\n",
       "      <td>11415</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>153</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>20</td>\n",
       "      <td>5</td>\n",
       "      <td>SN Thakur</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>157</td>\n",
       "      <td>-4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149577</th>\n",
       "      <td>11415</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>153</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>20</td>\n",
       "      <td>6</td>\n",
       "      <td>SN Thakur</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>SN Thakur</td>\n",
       "      <td>lbw</td>\n",
       "      <td>NaN</td>\n",
       "      <td>157</td>\n",
       "      <td>-4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>72413 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id       city               winner  total_runs_x  inning  \\\n",
       "125            1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "126            1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "127            1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "128            1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "129            1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "...          ...        ...                  ...           ...     ...   \n",
       "149573     11415  Hyderabad       Mumbai Indians           153       2   \n",
       "149574     11415  Hyderabad       Mumbai Indians           153       2   \n",
       "149575     11415  Hyderabad       Mumbai Indians           153       2   \n",
       "149576     11415  Hyderabad       Mumbai Indians           153       2   \n",
       "149577     11415  Hyderabad       Mumbai Indians           153       2   \n",
       "\n",
       "                       batting_team         bowling_team  over  ball  \\\n",
       "125     Royal Challengers Bangalore  Sunrisers Hyderabad     1     1   \n",
       "126     Royal Challengers Bangalore  Sunrisers Hyderabad     1     2   \n",
       "127     Royal Challengers Bangalore  Sunrisers Hyderabad     1     3   \n",
       "128     Royal Challengers Bangalore  Sunrisers Hyderabad     1     4   \n",
       "129     Royal Challengers Bangalore  Sunrisers Hyderabad     1     5   \n",
       "...                             ...                  ...   ...   ...   \n",
       "149573          Chennai Super Kings       Mumbai Indians    20     2   \n",
       "149574          Chennai Super Kings       Mumbai Indians    20     3   \n",
       "149575          Chennai Super Kings       Mumbai Indians    20     4   \n",
       "149576          Chennai Super Kings       Mumbai Indians    20     5   \n",
       "149577          Chennai Super Kings       Mumbai Indians    20     6   \n",
       "\n",
       "              batsman  ... penalty_runs batsman_runs  extra_runs  \\\n",
       "125          CH Gayle  ...            0            1           0   \n",
       "126     Mandeep Singh  ...            0            0           0   \n",
       "127     Mandeep Singh  ...            0            0           0   \n",
       "128     Mandeep Singh  ...            0            2           0   \n",
       "129     Mandeep Singh  ...            0            4           0   \n",
       "...               ...  ...          ...          ...         ...   \n",
       "149573      RA Jadeja  ...            0            1           0   \n",
       "149574      SR Watson  ...            0            2           0   \n",
       "149575      SR Watson  ...            0            1           0   \n",
       "149576      SN Thakur  ...            0            2           0   \n",
       "149577      SN Thakur  ...            0            0           0   \n",
       "\n",
       "        total_runs_y  player_dismissed  dismissal_kind    fielder  \\\n",
       "125                1               NaN             NaN        NaN   \n",
       "126                0               NaN             NaN        NaN   \n",
       "127                0               NaN             NaN        NaN   \n",
       "128                2               NaN             NaN        NaN   \n",
       "129                4               NaN             NaN        NaN   \n",
       "...              ...               ...             ...        ...   \n",
       "149573             1               NaN             NaN        NaN   \n",
       "149574             2               NaN             NaN        NaN   \n",
       "149575             1         SR Watson         run out  KH Pandya   \n",
       "149576             2               NaN             NaN        NaN   \n",
       "149577             0         SN Thakur             lbw        NaN   \n",
       "\n",
       "        current_score  runs_left  balls_left  \n",
       "125                 1        207         119  \n",
       "126                 1        207         118  \n",
       "127                 1        207         117  \n",
       "128                 3        205         116  \n",
       "129                 7        201         115  \n",
       "...               ...        ...         ...  \n",
       "149573            152          1           4  \n",
       "149574            154         -1           3  \n",
       "149575            155         -2           2  \n",
       "149576            157         -4           1  \n",
       "149577            157         -4           0  \n",
       "\n",
       "[72413 rows x 27 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''\n",
    "if one ball is played,then balls left = 120-1 = 119........(1)\n",
    "if two balls are played,then balls left = 120-2 = 118\n",
    "\n",
    "so similarly if over=1,over has 6 balls right,so 1*6 = 6\n",
    "now,ball = 1,so 6+1 = 7,now 126-7 = 119,which is same as (1)\n",
    "\n",
    "so we'll use balls_left = 126-(over*6+current_ball)\n",
    "\n",
    "'''\n",
    "\n",
    "# balls left\n",
    "\n",
    "\n",
    "delivery_df['balls_left'] = 126-(delivery_df['over']*6+delivery_df['ball'])\n",
    "\n",
    "delivery_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[nan, 'Mandeep Singh']"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(delivery_df['player_dismissed'].unique())[:2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([0, 1])"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "# filling nan values with \"0\"\n",
    "\n",
    "delivery_df['player_dismissed'] = delivery_df['player_dismissed'].fillna(\"0\")\n",
    "\n",
    "# now we will convert this player_dismissed col into a boolean col\n",
    "# if the player is not dismissed then it's 0 else its 1\n",
    "\n",
    "delivery_df['player_dismissed'] = delivery_df['player_dismissed'].apply(lambda x:x if x==\"0\" else \"1\")\n",
    "\n",
    "# converting string to int\n",
    "\n",
    "delivery_df['player_dismissed'] = delivery_df['player_dismissed'].astype('int')\n",
    "\n",
    "\n",
    "delivery_df['player_dismissed'].unique()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "scrolled": true
   },
   "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>batsman</th>\n",
       "      <th>...</th>\n",
       "      <th>batsman_runs</th>\n",
       "      <th>extra_runs</th>\n",
       "      <th>total_runs_y</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</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>CH Gayle</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "      <td>119</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "      <td>117</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>205</td>\n",
       "      <td>116</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>201</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>149573</th>\n",
       "      <td>11415</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>153</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>RA Jadeja</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>152</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149574</th>\n",
       "      <td>11415</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>153</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>20</td>\n",
       "      <td>3</td>\n",
       "      <td>SR Watson</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>154</td>\n",
       "      <td>-1</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149575</th>\n",
       "      <td>11415</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>153</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>20</td>\n",
       "      <td>4</td>\n",
       "      <td>SR Watson</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>run out</td>\n",
       "      <td>KH Pandya</td>\n",
       "      <td>155</td>\n",
       "      <td>-2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149576</th>\n",
       "      <td>11415</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>153</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>20</td>\n",
       "      <td>5</td>\n",
       "      <td>SN Thakur</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>157</td>\n",
       "      <td>-4</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149577</th>\n",
       "      <td>11415</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>153</td>\n",
       "      <td>2</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>Mumbai Indians</td>\n",
       "      <td>20</td>\n",
       "      <td>6</td>\n",
       "      <td>SN Thakur</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>lbw</td>\n",
       "      <td>NaN</td>\n",
       "      <td>157</td>\n",
       "      <td>-4</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>72413 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id       city               winner  total_runs_x  inning  \\\n",
       "125            1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "126            1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "127            1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "128            1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "129            1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "...          ...        ...                  ...           ...     ...   \n",
       "149573     11415  Hyderabad       Mumbai Indians           153       2   \n",
       "149574     11415  Hyderabad       Mumbai Indians           153       2   \n",
       "149575     11415  Hyderabad       Mumbai Indians           153       2   \n",
       "149576     11415  Hyderabad       Mumbai Indians           153       2   \n",
       "149577     11415  Hyderabad       Mumbai Indians           153       2   \n",
       "\n",
       "                       batting_team         bowling_team  over  ball  \\\n",
       "125     Royal Challengers Bangalore  Sunrisers Hyderabad     1     1   \n",
       "126     Royal Challengers Bangalore  Sunrisers Hyderabad     1     2   \n",
       "127     Royal Challengers Bangalore  Sunrisers Hyderabad     1     3   \n",
       "128     Royal Challengers Bangalore  Sunrisers Hyderabad     1     4   \n",
       "129     Royal Challengers Bangalore  Sunrisers Hyderabad     1     5   \n",
       "...                             ...                  ...   ...   ...   \n",
       "149573          Chennai Super Kings       Mumbai Indians    20     2   \n",
       "149574          Chennai Super Kings       Mumbai Indians    20     3   \n",
       "149575          Chennai Super Kings       Mumbai Indians    20     4   \n",
       "149576          Chennai Super Kings       Mumbai Indians    20     5   \n",
       "149577          Chennai Super Kings       Mumbai Indians    20     6   \n",
       "\n",
       "              batsman  ... batsman_runs extra_runs  total_runs_y  \\\n",
       "125          CH Gayle  ...            1          0             1   \n",
       "126     Mandeep Singh  ...            0          0             0   \n",
       "127     Mandeep Singh  ...            0          0             0   \n",
       "128     Mandeep Singh  ...            2          0             2   \n",
       "129     Mandeep Singh  ...            4          0             4   \n",
       "...               ...  ...          ...        ...           ...   \n",
       "149573      RA Jadeja  ...            1          0             1   \n",
       "149574      SR Watson  ...            2          0             2   \n",
       "149575      SR Watson  ...            1          0             1   \n",
       "149576      SN Thakur  ...            2          0             2   \n",
       "149577      SN Thakur  ...            0          0             0   \n",
       "\n",
       "        player_dismissed  dismissal_kind    fielder  current_score  runs_left  \\\n",
       "125                    0             NaN        NaN              1        207   \n",
       "126                    0             NaN        NaN              1        207   \n",
       "127                    0             NaN        NaN              1        207   \n",
       "128                    0             NaN        NaN              3        205   \n",
       "129                    0             NaN        NaN              7        201   \n",
       "...                  ...             ...        ...            ...        ...   \n",
       "149573                 0             NaN        NaN            152          1   \n",
       "149574                 0             NaN        NaN            154         -1   \n",
       "149575                 1         run out  KH Pandya            155         -2   \n",
       "149576                 0             NaN        NaN            157         -4   \n",
       "149577                 1             lbw        NaN            157         -4   \n",
       "\n",
       "        balls_left  wickets  \n",
       "125            119       10  \n",
       "126            118       10  \n",
       "127            117       10  \n",
       "128            116       10  \n",
       "129            115       10  \n",
       "...            ...      ...  \n",
       "149573           4        5  \n",
       "149574           3        5  \n",
       "149575           2        4  \n",
       "149576           1        4  \n",
       "149577           0        3  \n",
       "\n",
       "[72413 rows x 28 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# wickets fallen \n",
    "\n",
    "wickets = delivery_df.groupby('match_id').cumsum()['player_dismissed'].values\n",
    "\n",
    "delivery_df['wickets'] = 10-wickets\n",
    "\n",
    "delivery_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>batsman</th>\n",
       "      <th>...</th>\n",
       "      <th>total_runs_y</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</th>\n",
       "      <th>cur_run_rate</th>\n",
       "      <th>req_run_rate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>CH Gayle</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "      <td>119</td>\n",
       "      <td>10</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.436975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Mandeep Singh</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>207</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10.525424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Mandeep Singh</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>207</td>\n",
       "      <td>117</td>\n",
       "      <td>10</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.615385</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     match_id       city               winner  total_runs_x  inning  \\\n",
       "125         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "126         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "127         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "\n",
       "                    batting_team         bowling_team  over  ball  \\\n",
       "125  Royal Challengers Bangalore  Sunrisers Hyderabad     1     1   \n",
       "126  Royal Challengers Bangalore  Sunrisers Hyderabad     1     2   \n",
       "127  Royal Challengers Bangalore  Sunrisers Hyderabad     1     3   \n",
       "\n",
       "           batsman  ... total_runs_y player_dismissed  dismissal_kind  \\\n",
       "125       CH Gayle  ...            1                0             NaN   \n",
       "126  Mandeep Singh  ...            0                0             NaN   \n",
       "127  Mandeep Singh  ...            0                0             NaN   \n",
       "\n",
       "     fielder  current_score  runs_left  balls_left  wickets  cur_run_rate  \\\n",
       "125      NaN              1        207         119       10           6.0   \n",
       "126      NaN              1        207         118       10           3.0   \n",
       "127      NaN              1        207         117       10           2.0   \n",
       "\n",
       "     req_run_rate  \n",
       "125     10.436975  \n",
       "126     10.525424  \n",
       "127     10.615385  \n",
       "\n",
       "[3 rows x 30 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# current run rate\n",
    "\n",
    "delivery_df['cur_run_rate'] = (delivery_df['current_score']*6)/(120-delivery_df['balls_left'])\n",
    "\n",
    "# required run rate\n",
    "\n",
    "delivery_df['req_run_rate'] = (delivery_df['runs_left']*6)/(delivery_df['balls_left'])\n",
    "\n",
    "\n",
    "delivery_df.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "def resultfun(row):\n",
    "    \n",
    "    return 1 if row['batting_team'] == row['winner'] else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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>batsman</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</th>\n",
       "      <th>cur_run_rate</th>\n",
       "      <th>req_run_rate</th>\n",
       "      <th>result</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>CH Gayle</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "      <td>119</td>\n",
       "      <td>10</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.436975</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10.525424</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "      <td>117</td>\n",
       "      <td>10</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.615385</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>205</td>\n",
       "      <td>116</td>\n",
       "      <td>10</td>\n",
       "      <td>4.5</td>\n",
       "      <td>10.603448</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>1</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>208</td>\n",
       "      <td>2</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>Mandeep Singh</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>201</td>\n",
       "      <td>115</td>\n",
       "      <td>10</td>\n",
       "      <td>8.4</td>\n",
       "      <td>10.486957</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     match_id       city               winner  total_runs_x  inning  \\\n",
       "125         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "126         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "127         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "128         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "129         1  Hyderabad  Sunrisers Hyderabad           208       2   \n",
       "\n",
       "                    batting_team         bowling_team  over  ball  \\\n",
       "125  Royal Challengers Bangalore  Sunrisers Hyderabad     1     1   \n",
       "126  Royal Challengers Bangalore  Sunrisers Hyderabad     1     2   \n",
       "127  Royal Challengers Bangalore  Sunrisers Hyderabad     1     3   \n",
       "128  Royal Challengers Bangalore  Sunrisers Hyderabad     1     4   \n",
       "129  Royal Challengers Bangalore  Sunrisers Hyderabad     1     5   \n",
       "\n",
       "           batsman  ... player_dismissed dismissal_kind  fielder  \\\n",
       "125       CH Gayle  ...                0            NaN      NaN   \n",
       "126  Mandeep Singh  ...                0            NaN      NaN   \n",
       "127  Mandeep Singh  ...                0            NaN      NaN   \n",
       "128  Mandeep Singh  ...                0            NaN      NaN   \n",
       "129  Mandeep Singh  ...                0            NaN      NaN   \n",
       "\n",
       "     current_score  runs_left  balls_left  wickets  cur_run_rate  \\\n",
       "125              1        207         119       10           6.0   \n",
       "126              1        207         118       10           3.0   \n",
       "127              1        207         117       10           2.0   \n",
       "128              3        205         116       10           4.5   \n",
       "129              7        201         115       10           8.4   \n",
       "\n",
       "     req_run_rate  result  \n",
       "125     10.436975       0  \n",
       "126     10.525424       0  \n",
       "127     10.615385       0  \n",
       "128     10.603448       0  \n",
       "129     10.486957       0  \n",
       "\n",
       "[5 rows x 31 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "delivery_df['result'] = delivery_df.apply(resultfun,axis=1)\n",
    "delivery_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x23c4807db08>"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZIAAAEGCAYAAABPdROvAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAVR0lEQVR4nO3df6xf9X3f8ecrdkZYEyg/LsyxnRkFr5uhizNbntVoUxai4mVq7XTQ3kgNbmvJESJTI1VVodOWpJvVoCZFoS2ojqC2WRuwSFO8LCxh0Cyr6tq5pA7GEJSrQsGxh51AwdkEk533/vh+bvL15eubax9/7/XlPh/S0fd83+d8zvdzLFsvf87nfM83VYUkSWfqDbPdAUnS3GaQSJI6MUgkSZ0YJJKkTgwSSVInC2e7AzPt0ksvrWXLls12NyRpTnn00Ue/U1Ujg7bNuyBZtmwZY2Njs90NSZpTkvztqbZ5aUuS1IlBIknqxCCRJHVikEiSOjFIJEmdGCSSpE4MEklSJwaJJKkTg0SS1Mm8+2a79Hr27G/95Gx3Qeegt/3H/UM9viMSSVInBokkqRODRJLUiUEiSerEIJEkdWKQSJI6MUgkSZ0YJJKkTgwSSVInBokkqRODRJLUiUEiSepkaEGS5E1J9ib5RpIDST7e6h9L8u0k+9ryvr42tyQZT/JUkmv76quS7G/bbk+SVj8vyX2tvifJsmGdjyRpsGGOSF4F3lNV7wBWAuuSrG3bbquqlW35IkCSFcAocBWwDrgjyYK2/53AZmB5W9a1+ibgxaq6ErgNuHWI5yNJGmBoQVI932tv39iWmqLJeuDeqnq1qp4GxoE1SRYBF1TV7qoqYAewoa/N9rZ+P3DNxGhFkjQzhjpHkmRBkn3AEeChqtrTNn04yWNJ7k5yUastBp7ra36w1Ra39cn1k9pU1XHgJeCSAf3YnGQsydjRo0fP0tlJkmDIQVJVJ6pqJbCE3ujianqXqd5O73LXYeBTbfdBI4maoj5Vm8n92FpVq6tq9cjIyGmehSRpKjNy11ZV/R3wFWBdVT3fAub7wGeANW23g8DSvmZLgEOtvmRA/aQ2SRYCFwIvDOk0JEkDDPOurZEkP97WzwfeC3yzzXlMeD/weFvfBYy2O7GuoDepvreqDgPHkqxt8x83AA/0tdnY1q8DHmnzKJKkGTLM32xfBGxvd169AdhZVV9Ick+SlfQuQT0DfAigqg4k2Qk8ARwHbqqqE+1YNwLbgPOBB9sCcBdwT5JxeiOR0SGezw+s+vUdM/ExmmMe/Z0bZrsL0qwYWpBU1WPAOwfUPzhFmy3AlgH1MeDqAfVXgOu79VSS1IXfbJckdWKQSJI6MUgkSZ0YJJKkTgwSSVInBokkqRODRJLUiUEiSerEIJEkdWKQSJI6MUgkSZ0YJJKkTgwSSVInBokkqRODRJLUiUEiSerEIJEkdWKQSJI6GVqQJHlTkr1JvpHkQJKPt/rFSR5K8q32elFfm1uSjCd5Ksm1ffVVSfa3bbcnSaufl+S+Vt+TZNmwzkeSNNgwRySvAu+pqncAK4F1SdYCNwMPV9Vy4OH2niQrgFHgKmAdcEeSBe1YdwKbgeVtWdfqm4AXq+pK4Dbg1iGejyRpgKEFSfV8r719Y1sKWA9sb/XtwIa2vh64t6peraqngXFgTZJFwAVVtbuqCtgxqc3Ese4HrpkYrUiSZsZQ50iSLEiyDzgCPFRVe4DLq+owQHu9rO2+GHiur/nBVlvc1ifXT2pTVceBl4BLhnM2kqRBhhokVXWiqlYCS+iNLq6eYvdBI4maoj5Vm5MPnGxOMpZk7OjRoz+q25Kk0zAjd21V1d8BX6E3t/F8u1xFez3SdjsILO1rtgQ41OpLBtRPapNkIXAh8MKAz99aVauravXIyMhZOitJEgz3rq2RJD/e1s8H3gt8E9gFbGy7bQQeaOu7gNF2J9YV9CbV97bLX8eSrG3zHzdMajNxrOuAR9o8iiRphiwc4rEXAdvbnVdvAHZW1ReS7AZ2JtkEPAtcD1BVB5LsBJ4AjgM3VdWJdqwbgW3A+cCDbQG4C7gnyTi9kcjoEM9HkjTA0IKkqh4D3jmg/l3gmlO02QJsGVAfA14zv1JVr9CCSJI0O/xmuySpE4NEktSJQSJJ6sQgkSR1YpBIkjoxSCRJnRgkkqRODBJJUicGiSSpE4NEktSJQSJJ6sQgkSR1YpBIkjoxSCRJnRgkkqRODBJJUicGiSSpE4NEktSJQSJJ6mRoQZJkaZI/T/JkkgNJfrXVP5bk20n2teV9fW1uSTKe5Kkk1/bVVyXZ37bdniStfl6S+1p9T5JlwzofSdJgwxyRHAd+rar+CbAWuCnJirbttqpa2ZYvArRto8BVwDrgjiQL2v53ApuB5W1Z1+qbgBer6krgNuDWIZ6PJGmAoQVJVR2uqq+39WPAk8DiKZqsB+6tqler6mlgHFiTZBFwQVXtrqoCdgAb+tpsb+v3A9dMjFYkSTNjRuZI2iWndwJ7WunDSR5LcneSi1ptMfBcX7ODrba4rU+un9Smqo4DLwGXDPj8zUnGkowdPXr0rJyTJKln6EGS5M3A54CPVNXL9C5TvR1YCRwGPjWx64DmNUV9qjYnF6q2VtXqqlo9MjJymmcgSZrKUIMkyRvphcgfV9WfAlTV81V1oqq+D3wGWNN2Pwgs7Wu+BDjU6ksG1E9qk2QhcCHwwnDORpI0yDDv2gpwF/BkVf1uX31R327vBx5v67uA0XYn1hX0JtX3VtVh4FiSte2YNwAP9LXZ2NavAx5p8yiSpBmycIjHfhfwQWB/kn2t9pvAB5KspHcJ6hngQwBVdSDJTuAJend83VRVJ1q7G4FtwPnAg22BXlDdk2Sc3khkdIjnI0kaYGhBUlV/weA5jC9O0WYLsGVAfQy4ekD9FeD6Dt2UJHXkN9slSZ0YJJKkTgwSSVInBokkqRODRJLUiUEiSerEIJEkdWKQSJI6MUgkSZ0YJJKkTqYVJEkenk5NkjT/TPmsrSRvAv4+cGn7AaqJZ2ddALx1yH2TJM0BP+qhjR8CPkIvNB7lh0HyMvAHQ+yXJGmOmDJIqurTwKeT/Luq+r0Z6pMkaQ6Z1mPkq+r3kvwUsKy/TVXtGFK/JElzxLSCJMk99H5nfR8w8WNTBRgkkjTPTfeHrVYDK/wZW0nSZNP9HsnjwD8YZkckSXPTdIPkUuCJJF9KsmtimapBkqVJ/jzJk0kOJPnVVr84yUNJvtVeL+prc0uS8SRPJbm2r74qyf627fYkafXzktzX6nuSLDvdPwBJUjfTvbT1sTM49nHg16rq60neAjya5CHgl4CHq+oTSW4GbgZ+I8kKYBS4it7txv8jyT+qqhPAncBm4K/o/eb7OuBBYBPwYlVdmWQUuBX4hTPoqyTpDE33rq3/eboHrqrDwOG2fizJk8BiYD3w7rbbduArwG+0+r1V9SrwdJJxYE2SZ4ALqmo3QJIdwAZ6QbKeH4bc/cDvJ4lzOZI0c6b7iJRjSV5uyytJTiR5ebof0i45vRPYA1zeQmYibC5ruy0GnutrdrDVFrf1yfWT2lTVceAl4JIBn785yViSsaNHj06325KkaZjuiOQt/e+TbADWTKdtkjcDnwM+UlUvt+mNgbsO+ugp6lO1OblQtRXYCrB69WpHK5J0Fp3R03+r6s+A9/yo/ZK8kV6I/HFV/WkrP59kUdu+CDjS6geBpX3NlwCHWn3JgPpJbZIsBC4EXjiDU5IknaHpXtr6ub7luiSfYMD//Ce1CXAX8GRV/W7fpl3Axra+EXigrz7a7sS6AlgO7G2Xv44lWduOecOkNhPHug54xPkRSZpZ071r62f61o8Dz9Cb6J7Ku4APAvuT7Gu13wQ+AexMsgl4FrgeoKoOJNkJPNE+46Z2xxbAjcA24Hx6k+wPtvpdwD1tYv4Fend9SZJm0HTnSH75dA9cVX/B4DkMgGtO0WYLsGVAfQy4ekD9FVoQSZJmx3QvbS1J8vkkR5I8n+RzSZb86JaSpNe76U62/xG9+Yi30rvl9r+2miRpnptukIxU1R9V1fG2bANGhtgvSdIcMd0g+U6SX0yyoC2/CHx3mB2TJM0N0w2SXwF+Hvjf9B57ch1w2hPwkqTXn+ne/vufgI1V9SL0nuALfJJewEiS5rHpjkj+6USIAFTVC/SenSVJmuemGyRvmPS7IRcz/dGMJOl1bLph8CngL5PcT+/RKD/PgC8OSpLmn+l+s31HkjF6D2oM8HNV9cRQeyZJmhOmfXmqBYfhIUk6yRk9Rl6SpAkGiSSpE4NEktSJQSJJ6sQgkSR1YpBIkjoxSCRJnQwtSJLc3X5R8fG+2seSfDvJvra8r2/bLUnGkzyV5Nq++qok+9u225Ok1c9Lcl+r70mybFjnIkk6tWGOSLYB6wbUb6uqlW35IkCSFcAocFVrc0eSBW3/O4HNwPK2TBxzE/BiVV0J3AbcOqwTkSSd2tCCpKq+Crwwzd3XA/dW1atV9TQwDqxJsgi4oKp2V1UBO4ANfW22t/X7gWsmRiuSpJkzG3MkH07yWLv0NfFE4cXAc337HGy1xW19cv2kNlV1HHgJuGTQBybZnGQsydjRo0fP3plIkmY8SO4E3g6spPdLi59q9UEjiZqiPlWb1xartlbV6qpaPTLiT81L0tk0o0FSVc9X1Ymq+j7wGWBN23QQWNq36xLgUKsvGVA/qU2ShcCFTP9SmiTpLJnRIGlzHhPeD0zc0bULGG13Yl1Bb1J9b1UdBo4lWdvmP24AHuhrs7GtXwc80uZRJEkzaGi/cpjks8C7gUuTHAQ+Crw7yUp6l6CeAT4EUFUHkuyk95j648BNVXWiHepGeneAnQ882BaAu4B7kozTG4mMDutcJEmnNrQgqaoPDCjfNcX+Wxjwq4tVNQZcPaD+CnB9lz5Kkrrzm+2SpE4MEklSJwaJJKkTg0SS1IlBIknqxCCRJHVikEiSOjFIJEmdGCSSpE4MEklSJwaJJKkTg0SS1IlBIknqxCCRJHVikEiSOjFIJEmdGCSSpE4MEklSJ0MLkiR3JzmS5PG+2sVJHkryrfZ6Ud+2W5KMJ3kqybV99VVJ9rdttydJq5+X5L5W35Nk2bDORZJ0asMckWwD1k2q3Qw8XFXLgYfbe5KsAEaBq1qbO5IsaG3uBDYDy9syccxNwItVdSVwG3Dr0M5EknRKQwuSqvoq8MKk8npge1vfDmzoq99bVa9W1dPAOLAmySLggqraXVUF7JjUZuJY9wPXTIxWJEkzZ6bnSC6vqsMA7fWyVl8MPNe338FWW9zWJ9dPalNVx4GXgEsGfWiSzUnGkowdPXr0LJ2KJAnOncn2QSOJmqI+VZvXFqu2VtXqqlo9MjJyhl2UJA0y00HyfLtcRXs90uoHgaV9+y0BDrX6kgH1k9okWQhcyGsvpUmShmymg2QXsLGtbwQe6KuPtjuxrqA3qb63Xf46lmRtm/+4YVKbiWNdBzzS5lEkSTNo4bAOnOSzwLuBS5McBD4KfALYmWQT8CxwPUBVHUiyE3gCOA7cVFUn2qFupHcH2PnAg20BuAu4J8k4vZHI6LDORZJ0akMLkqr6wCk2XXOK/bcAWwbUx4CrB9RfoQWRJGn2nCuT7ZKkOcogkSR1YpBIkjoxSCRJnRgkkqRODBJJUicGiSSpE4NEktSJQSJJ6sQgkSR1YpBIkjoxSCRJnRgkkqRODBJJUicGiSSpE4NEktSJQSJJ6sQgkSR1MitBkuSZJPuT7Esy1moXJ3koybfa60V9+9+SZDzJU0mu7auvascZT3J7kszG+UjSfDabI5J/VVUrq2p1e38z8HBVLQcebu9JsgIYBa4C1gF3JFnQ2twJbAaWt2XdDPZfksS5dWlrPbC9rW8HNvTV762qV6vqaWAcWJNkEXBBVe2uqgJ29LWRJM2Q2QqSAr6c5NEkm1vt8qo6DNBeL2v1xcBzfW0Pttritj65LkmaQQtn6XPfVVWHklwGPJTkm1PsO2jeo6aov/YAvbDaDPC2t73tdPsqSZrCrIxIqupQez0CfB5YAzzfLlfRXo+03Q8CS/uaLwEOtfqSAfVBn7e1qlZX1eqRkZGzeSqSNO/NeJAk+bEkb5lYB34aeBzYBWxsu20EHmjru4DRJOcluYLepPredvnrWJK17W6tG/raSJJmyGxc2roc+Hy7U3ch8CdV9d+TfA3YmWQT8CxwPUBVHUiyE3gCOA7cVFUn2rFuBLYB5wMPtkWSNINmPEiq6m+Adwyofxe45hRttgBbBtTHgKvPdh8lSdN3Lt3+K0magwwSSVInBokkqRODRJLUiUEiSerEIJEkdWKQSJI6MUgkSZ0YJJKkTgwSSVInBokkqRODRJLUiUEiSerEIJEkdWKQSJI6MUgkSZ0YJJKkTgwSSVInBokkqZM5HyRJ1iV5Ksl4kptnuz+SNN/M6SBJsgD4A+BfAyuADyRZMbu9kqT5ZU4HCbAGGK+qv6mq/wfcC6yf5T5J0ryycLY70NFi4Lm+9weBfz55pySbgc3t7feSPDUDfZsvLgW+M9udOBfkkxtnuws6mX83J3w0Z+Mo//BUG+Z6kAz606nXFKq2AluH3535J8lYVa2e7X5Ik/l3c+bM9UtbB4Glfe+XAIdmqS+SNC/N9SD5GrA8yRVJ/h4wCuya5T5J0rwypy9tVdXxJB8GvgQsAO6uqgOz3K35xkuGOlf5d3OGpOo1UwqSJE3bXL+0JUmaZQaJJKkTg0RnxEfT6FyV5O4kR5I8Ptt9mS8MEp02H02jc9w2YN1sd2I+MUh0Jnw0jc5ZVfVV4IXZ7sd8YpDoTAx6NM3iWeqLpFlmkOhMTOvRNJLmB4NEZ8JH00j6AYNEZ8JH00j6AYNEp62qjgMTj6Z5Etjpo2l0rkjyWWA38BNJDibZNNt9er3zESmSpE4ckUiSOjFIJEmdGCSSpE4MEklSJwaJJKkTg0SaI5L8UpLfb+sbfFCmzhUGiTRk6Tnb/9Y20HvysjTrDBJpCJIsS/JkkjuArwP/IcnXkjyW5ONtnx9L8t+SfCPJ40l+odWfSXJpW1+d5CuTjv1TwM8Cv5NkX5K3z+jJSZMsnO0OSK9jPwH8MvBnwHX0Hr8fYFeSfwmMAIeq6t8AJLlwOgetqr9Msgv4QlXdP5SeS6fBEYk0PH9bVX8F/HRb/pre6OQfA8uB/cB7k9ya5F9U1Uuz11XpzDkikYbn/7TXAL9dVX84eYckq4D3Ab+d5MtV9VvAcX74n7w3zUhPpQ4ckUjD9yXgV5K8GSDJ4iSXJXkr8H+r6r8AnwT+Wdv/GWBVW/+3pzjmMeAtw+uyNH0GiTRkVfVl4E+A3Un2A/fTC4GfBPYm2Qf8e+A/tyYfBz6d5H8BJ05x2HuBX0/y1062a7b59F9JUieOSCRJnRgkkqRODBJJUicGiSSpE4NEktSJQSJJ6sQgkSR18v8Bs7ENAI3dfyEAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sn.countplot(delivery_df['result'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "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</th>\n",
       "      <th>total_runs_x</th>\n",
       "      <th>cur_run_rate</th>\n",
       "      <th>req_run_rate</th>\n",
       "      <th>result</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>207</td>\n",
       "      <td>119</td>\n",
       "      <td>10</td>\n",
       "      <td>208</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.436975</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>207</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>208</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10.525424</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>207</td>\n",
       "      <td>117</td>\n",
       "      <td>10</td>\n",
       "      <td>208</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.615385</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>205</td>\n",
       "      <td>116</td>\n",
       "      <td>10</td>\n",
       "      <td>208</td>\n",
       "      <td>4.5</td>\n",
       "      <td>10.603448</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>201</td>\n",
       "      <td>115</td>\n",
       "      <td>10</td>\n",
       "      <td>208</td>\n",
       "      <td>8.4</td>\n",
       "      <td>10.486957</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    batting_team         bowling_team       city  runs_left  \\\n",
       "125  Royal Challengers Bangalore  Sunrisers Hyderabad  Hyderabad        207   \n",
       "126  Royal Challengers Bangalore  Sunrisers Hyderabad  Hyderabad        207   \n",
       "127  Royal Challengers Bangalore  Sunrisers Hyderabad  Hyderabad        207   \n",
       "128  Royal Challengers Bangalore  Sunrisers Hyderabad  Hyderabad        205   \n",
       "129  Royal Challengers Bangalore  Sunrisers Hyderabad  Hyderabad        201   \n",
       "\n",
       "     balls_left  wickets  total_runs_x  cur_run_rate  req_run_rate  result  \n",
       "125         119       10           208           6.0     10.436975       0  \n",
       "126         118       10           208           3.0     10.525424       0  \n",
       "127         117       10           208           2.0     10.615385       0  \n",
       "128         116       10           208           4.5     10.603448       0  \n",
       "129         115       10           208           8.4     10.486957       0  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df = delivery_df[['batting_team','bowling_team','city','runs_left',\n",
    "                        'balls_left','wickets','total_runs_x','cur_run_rate',\n",
    "                        'req_run_rate','result']]\n",
    "\n",
    "final_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(72413, 10)"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "batting_team      0\n",
       "bowling_team      0\n",
       "city            832\n",
       "runs_left         0\n",
       "balls_left        0\n",
       "wickets           0\n",
       "total_runs_x      0\n",
       "cur_run_rate      0\n",
       "req_run_rate      5\n",
       "result            0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "batting_team    0\n",
       "bowling_team    0\n",
       "city            0\n",
       "runs_left       0\n",
       "balls_left      0\n",
       "wickets         0\n",
       "total_runs_x    0\n",
       "cur_run_rate    0\n",
       "req_run_rate    0\n",
       "result          0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# dropping of null values\n",
    "\n",
    "\n",
    "final_df = final_df.dropna()\n",
    "\n",
    "final_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_df = final_df[final_df['balls_left'] != 0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "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</th>\n",
       "      <th>total_runs_x</th>\n",
       "      <th>cur_run_rate</th>\n",
       "      <th>req_run_rate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>207</td>\n",
       "      <td>119</td>\n",
       "      <td>10</td>\n",
       "      <td>208</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.436975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>207</td>\n",
       "      <td>118</td>\n",
       "      <td>10</td>\n",
       "      <td>208</td>\n",
       "      <td>3.0</td>\n",
       "      <td>10.525424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>207</td>\n",
       "      <td>117</td>\n",
       "      <td>10</td>\n",
       "      <td>208</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.615385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>205</td>\n",
       "      <td>116</td>\n",
       "      <td>10</td>\n",
       "      <td>208</td>\n",
       "      <td>4.5</td>\n",
       "      <td>10.603448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>Sunrisers Hyderabad</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>201</td>\n",
       "      <td>115</td>\n",
       "      <td>10</td>\n",
       "      <td>208</td>\n",
       "      <td>8.4</td>\n",
       "      <td>10.486957</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    batting_team         bowling_team       city  runs_left  \\\n",
       "125  Royal Challengers Bangalore  Sunrisers Hyderabad  Hyderabad        207   \n",
       "126  Royal Challengers Bangalore  Sunrisers Hyderabad  Hyderabad        207   \n",
       "127  Royal Challengers Bangalore  Sunrisers Hyderabad  Hyderabad        207   \n",
       "128  Royal Challengers Bangalore  Sunrisers Hyderabad  Hyderabad        205   \n",
       "129  Royal Challengers Bangalore  Sunrisers Hyderabad  Hyderabad        201   \n",
       "\n",
       "     balls_left  wickets  total_runs_x  cur_run_rate  req_run_rate  \n",
       "125         119       10           208           6.0     10.436975  \n",
       "126         118       10           208           3.0     10.525424  \n",
       "127         117       10           208           2.0     10.615385  \n",
       "128         116       10           208           4.5     10.603448  \n",
       "129         115       10           208           8.4     10.486957  "
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = final_df.copy()\n",
    "\n",
    "test = data['result']\n",
    "\n",
    "train = data.drop(['result'],axis = 1)\n",
    "\n",
    "train.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "((57073, 9), (14269, 9))"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.model_selection import train_test_split\n",
    "X_train,X_test,y_train,y_test = train_test_split(train,test,test_size=0.2,random_state=1)\n",
    "\n",
    "X_train.shape,X_test.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['batting_team', 'bowling_team', 'city', 'runs_left', 'balls_left',\n",
       "       'wickets', 'total_runs_x', 'cur_run_rate', 'req_run_rate'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X_train.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.compose import ColumnTransformer\n",
    "from sklearn.preprocessing import OneHotEncoder\n",
    "from sklearn.linear_model import LogisticRegression\n",
    "from sklearn.ensemble import RandomForestClassifier\n",
    "from sklearn.pipeline import Pipeline\n",
    "from sklearn import metrics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "# batting team,bowling team and city are categorical columns\n",
    "# they will be converted to numeric using onehot encoder\n",
    "\n",
    "cf = ColumnTransformer([\n",
    "    ('trf',OneHotEncoder(sparse=False,drop='first'),['batting_team','bowling_team','city'])\n",
    "],remainder='passthrough')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Pipeline(steps=[('step1',\n",
       "                 ColumnTransformer(remainder='passthrough',\n",
       "                                   transformers=[('trf',\n",
       "                                                  OneHotEncoder(drop='first',\n",
       "                                                                sparse=False),\n",
       "                                                  ['batting_team',\n",
       "                                                   'bowling_team', 'city'])])),\n",
       "                ('step2', LogisticRegression(solver='liblinear'))])"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# creating the pipeline\n",
    "\n",
    "\n",
    "pipe = Pipeline(steps=[\n",
    "    ('step1',cf),\n",
    "    ('step2',LogisticRegression(solver='liblinear'))\n",
    "])\n",
    "\n",
    "# fitting the training data\n",
    "\n",
    "pipe.fit(X_train,y_train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.8064335272268555\n"
     ]
    }
   ],
   "source": [
    "y_pred = pipe.predict(X_test)\n",
    "print(metrics.accuracy_score(y_test,y_pred))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([0.54420048, 0.45579952])"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pipe.predict_proba(X_test)[10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.9989487700609714\n"
     ]
    }
   ],
   "source": [
    "# Selecting Random Forest Classifier\n",
    "\n",
    "pipe2 = Pipeline(steps=[\n",
    "    ('step1',cf),\n",
    "    ('step2',RandomForestClassifier())\n",
    "])\n",
    "\n",
    "pipe2.fit(X_train,y_train)\n",
    "print(metrics.accuracy_score(y_test,pipe2.predict(X_test)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([0.02, 0.98])"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# oth index is loose prob and 1st index is win prob\n",
    "\n",
    "pipe2.predict_proba(X_test)[10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "'''\n",
    "I will go with Logistic Regression because i need to \n",
    "showcase the probability right,even though Random Forest is \n",
    "giving much accurate result,but RandomForest is being baised\n",
    "at one side,as you can observe the prob of winning for 10th sample\n",
    "is shown as 98% and 2% loose prob,this is kind of tooo strong or may\n",
    "be sometimes unrealistic,so its better to use a model which gives equal \n",
    "justice towards both side,as we also don't know which team will outperform \n",
    "and win the game!\n",
    "\n",
    "'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [],
   "source": [
    "# saving the logistic regression model\n",
    "\n",
    "import pickle\n",
    "pickle.dump(pipe,open('pipe.pkl','wb'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}