ipl-dc-rr.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sb\n",
    "import missingno as msg\n",
    "%matplotlib inline\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('deliveries.csv')\n",
    "df1 = pd.read_csv('matches.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(5)"
   ]
  },
  {
   "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>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>2017</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>2017-04-05</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>2017</td>\n",
       "      <td>Pune</td>\n",
       "      <td>2017-04-06</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>2017</td>\n",
       "      <td>Rajkot</td>\n",
       "      <td>2017-04-07</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>2017</td>\n",
       "      <td>Indore</td>\n",
       "      <td>2017-04-08</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>2017</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>2017-04-08</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    2017  Hyderabad  2017-04-05          Sunrisers Hyderabad   \n",
       "1   2    2017       Pune  2017-04-06               Mumbai Indians   \n",
       "2   3    2017     Rajkot  2017-04-07                Gujarat Lions   \n",
       "3   4    2017     Indore  2017-04-08       Rising Pune Supergiant   \n",
       "4   5    2017  Bangalore  2017-04-08  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": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "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')\n",
      " \n",
      "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')\n"
     ]
    }
   ],
   "source": [
    "print(df.columns)\n",
    "print(\" \")\n",
    "print(df1.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.team1.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Royal Challengers Bangalore', 'Rising Pune Supergiant',\n",
       "       'Kolkata Knight Riders', 'Kings XI Punjab', 'Delhi Daredevils',\n",
       "       'Sunrisers Hyderabad', 'Mumbai Indians', 'Gujarat Lions',\n",
       "       'Rajasthan Royals', 'Chennai Super Kings', 'Deccan Chargers',\n",
       "       'Pune Warriors', 'Kochi Tuskers Kerala', 'Rising Pune Supergiants',\n",
       "       'Delhi Capitals'], dtype=object)"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.team2.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1['team1'] = df1['team1'].replace('Delhi Daredevils', 'Delhi Capitals')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1['team2'] = df1['team2'].replace('Delhi Daredevils', 'Delhi Capitals')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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>2017</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>2017-04-05</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>2017</td>\n",
       "      <td>Pune</td>\n",
       "      <td>2017-04-06</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>2017</td>\n",
       "      <td>Rajkot</td>\n",
       "      <td>2017-04-07</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>2017</td>\n",
       "      <td>Indore</td>\n",
       "      <td>2017-04-08</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>2017</td>\n",
       "      <td>Bangalore</td>\n",
       "      <td>2017-04-08</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",
       "    </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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>751</th>\n",
       "      <td>11347</td>\n",
       "      <td>2019</td>\n",
       "      <td>Mumbai</td>\n",
       "      <td>05/05/19</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td>11412</td>\n",
       "      <td>2019</td>\n",
       "      <td>Chennai</td>\n",
       "      <td>07/05/19</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>753</th>\n",
       "      <td>11413</td>\n",
       "      <td>2019</td>\n",
       "      <td>Visakhapatnam</td>\n",
       "      <td>08/05/19</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>754</th>\n",
       "      <td>11414</td>\n",
       "      <td>2019</td>\n",
       "      <td>Visakhapatnam</td>\n",
       "      <td>10/05/19</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>755</th>\n",
       "      <td>11415</td>\n",
       "      <td>2019</td>\n",
       "      <td>Hyderabad</td>\n",
       "      <td>12/05/19</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",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>756 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id  season           city        date                        team1  \\\n",
       "0        1    2017      Hyderabad  2017-04-05          Sunrisers Hyderabad   \n",
       "1        2    2017           Pune  2017-04-06               Mumbai Indians   \n",
       "2        3    2017         Rajkot  2017-04-07                Gujarat Lions   \n",
       "3        4    2017         Indore  2017-04-08       Rising Pune Supergiant   \n",
       "4        5    2017      Bangalore  2017-04-08  Royal Challengers Bangalore   \n",
       "..     ...     ...            ...         ...                          ...   \n",
       "751  11347    2019         Mumbai    05/05/19        Kolkata Knight Riders   \n",
       "752  11412    2019        Chennai    07/05/19          Chennai Super Kings   \n",
       "753  11413    2019  Visakhapatnam    08/05/19          Sunrisers Hyderabad   \n",
       "754  11414    2019  Visakhapatnam    10/05/19               Delhi Capitals   \n",
       "755  11415    2019      Hyderabad    12/05/19               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 Capitals  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  \n",
       "0          NJ Llong                      NaN  \n",
       "1            S Ravi                      NaN  \n",
       "2         CK Nandan                      NaN  \n",
       "3     C Shamshuddin                      NaN  \n",
       "4               NaN                      NaN  \n",
       "..              ...                      ...  \n",
       "751        O Nandan                   S Ravi  \n",
       "752     Nitin Menon                Ian Gould  \n",
       "753             NaN                      NaN  \n",
       "754  Bruce Oxenford  Chettithody Shamshuddin  \n",
       "755       Ian Gould              Nigel Llong  \n",
       "\n",
       "[756 rows x 18 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Extract RR and DC"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ques -1 : who will win ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "main_df = df1[((df1['team1'] == 'Rajasthan Royals') & (df1['team2'] == 'Delhi Capitals')) | ((df1['team1'] == 'Delhi Capitals') & (df1['team2'] == 'Rajasthan Royals'))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(20, 18)\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>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>61</th>\n",
       "      <td>62</td>\n",
       "      <td>2008</td>\n",
       "      <td>Delhi</td>\n",
       "      <td>2008-04-19</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>bat</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>MF Maharoof</td>\n",
       "      <td>Feroz Shah Kotla</td>\n",
       "      <td>Aleem Dar</td>\n",
       "      <td>GA Pratapkumar</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>93</td>\n",
       "      <td>2008</td>\n",
       "      <td>Jaipur</td>\n",
       "      <td>2008-05-11</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>SR Watson</td>\n",
       "      <td>Sawai Mansingh Stadium</td>\n",
       "      <td>SJ Davis</td>\n",
       "      <td>RE Koertzen</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>115</td>\n",
       "      <td>2008</td>\n",
       "      <td>Mumbai</td>\n",
       "      <td>2008-05-30</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>field</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>105</td>\n",
       "      <td>0</td>\n",
       "      <td>SR Watson</td>\n",
       "      <td>Wankhede Stadium</td>\n",
       "      <td>BF Bowden</td>\n",
       "      <td>RE Koertzen</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>133</td>\n",
       "      <td>2009</td>\n",
       "      <td>Centurion</td>\n",
       "      <td>2009-04-28</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>bat</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>YK Pathan</td>\n",
       "      <td>SuperSport Park</td>\n",
       "      <td>GAV Baxter</td>\n",
       "      <td>RE Koertzen</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>165</td>\n",
       "      <td>2009</td>\n",
       "      <td>Bloemfontein</td>\n",
       "      <td>2009-05-17</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Rajasthan Royals</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>bat</td>\n",
       "      <td>normal</td>\n",
       "      <td>0</td>\n",
       "      <td>Delhi Daredevils</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>AB de Villiers</td>\n",
       "      <td>OUTsurance Oval</td>\n",
       "      <td>SS Hazare</td>\n",
       "      <td>IL Howell</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id  season          city        date             team1  \\\n",
       "61    62    2008         Delhi  2008-04-19  Rajasthan Royals   \n",
       "92    93    2008        Jaipur  2008-05-11    Delhi Capitals   \n",
       "114  115    2008        Mumbai  2008-05-30  Rajasthan Royals   \n",
       "132  133    2009     Centurion  2009-04-28    Delhi Capitals   \n",
       "164  165    2009  Bloemfontein  2009-05-17    Delhi Capitals   \n",
       "\n",
       "                team2       toss_winner toss_decision  result  dl_applied  \\\n",
       "61     Delhi Capitals  Rajasthan Royals           bat  normal           0   \n",
       "92   Rajasthan Royals  Rajasthan Royals         field  normal           0   \n",
       "114    Delhi Capitals  Delhi Daredevils         field  normal           0   \n",
       "132  Rajasthan Royals  Delhi Daredevils           bat  normal           0   \n",
       "164  Rajasthan Royals  Delhi Daredevils           bat  normal           0   \n",
       "\n",
       "               winner  win_by_runs  win_by_wickets player_of_match  \\\n",
       "61   Delhi Daredevils            0               9     MF Maharoof   \n",
       "92   Rajasthan Royals            0               3       SR Watson   \n",
       "114  Rajasthan Royals          105               0       SR Watson   \n",
       "132  Rajasthan Royals            0               5       YK Pathan   \n",
       "164  Delhi Daredevils           14               0  AB de Villiers   \n",
       "\n",
       "                      venue     umpire1         umpire2 umpire3  \n",
       "61         Feroz Shah Kotla   Aleem Dar  GA Pratapkumar     NaN  \n",
       "92   Sawai Mansingh Stadium    SJ Davis     RE Koertzen     NaN  \n",
       "114        Wankhede Stadium   BF Bowden     RE Koertzen     NaN  \n",
       "132         SuperSport Park  GAV Baxter     RE Koertzen     NaN  \n",
       "164         OUTsurance Oval   SS Hazare       IL Howell     NaN  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(main_df.shape)\n",
    "(main_df.head())\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "main_df['winner'] = main_df['winner'].replace('Delhi Daredevils', 'Delhi Capitals')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Rajasthan Royals    11\n",
       "Delhi Capitals       9\n",
       "Name: winner, dtype: int64"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df['winner'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x15a82c94220>"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX4AAAEGCAYAAABiq/5QAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+j8jraAAARP0lEQVR4nO3de5AlZX3G8e8DCwICAu7ECBgXEUmJ4m0l3ktBUoREsJRCTFBQEzReEK/BxICXssqoaBSNuqJcFDUloEGNIiJ4JeAsIFfxAogoyiCIgngBf/mje/Q4zC7D7Mzp3X2/n6qp06f7Pf3+Dts80+c93e+kqpAktWODoQuQJI2XwS9JjTH4JakxBr8kNcbgl6TGLBm6gLlYunRpLVu2bOgyJGmdsnLlyuuramLm+nUi+JctW8bk5OTQZUjSOiXJD2Zb71CPJDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1Zp24c1dan139hgcPXYLWQn9xxEWLtm/P+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMYY/JLUGINfkhpj8EtSYxYt+JN8KMl1SS4eWbdNktOTfLd/3Hqx+pckzW4xz/iPA/aase5w4Iyq2gk4o38uSRqjRQv+qvoKcMOM1fsCx/fLxwNPXaz+JUmzG/cY/72q6lqA/vHPxty/JDVvrf1yN8khSSaTTE5NTQ1djiStN8Yd/D9Ncm+A/vG6VTWsqhVVtbyqlk9MTIytQEla3407+E8FDuqXDwL+Z8z9S1LzFvNyzo8BZwM7J7kmyfOANwN7JvkusGf/XJI0RksWa8dV9cxVbNpjsfqUJN25tfbLXUnS4jD4JakxBr8kNcbgl6TGGPyS1BiDX5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktSYRZudc23ziFedMHQJWgutfOuzhy5BGjvP+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMYY/JLUGINfkhpj8EtSYwx+SWrMIMGf5GVJLklycZKPJdlkiDokqUVjD/4k2wGHAsur6kHAhsAB465Dklo11FDPEmDTJEuAzYAfD1SHJDVn7MFfVT8C3gZcDVwL3FRVX5jZLskhSSaTTE5NTY27TElabw0x1LM1sC+wA7AtcPckB85sV1Urqmp5VS2fmJgYd5mStN4aYqjnycCVVTVVVb8DTgEeM0AdktSkIYL/auBRSTZLEmAP4LIB6pCkJg0xxn8OcBJwHnBRX8OKcdchSa1aMkSnVXUkcOQQfUtS67xzV5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMYY/JLUGINfkhpj8EtSYwx+SWqMwS9JjTH4JakxBr8kNcbgl6TGGPyS1BiDX5IaM6fgT3LGXNZJktZ+S1a3MckmwGbA0iRbA+k3bQlsu8i1SZIWwWqDH3g+cBhdyK/kj8H/C+A9i1iXJGmRrDb4q+qdwDuTvKSqjh5TTZKkRXRnZ/wAVNXRSR4DLBt9TVWdMJ9Ok2wFHAM8CCjguVV19nz2JUm6a+YU/Ek+DOwIXADc3q8uYF7BD7wT+HxV7ZdkY7rvESRJYzCn4AeWAw+sqlrTDpNsCTwBOBigqn4L/HZN9ytJmpu5Xsd/MfDnC9Tn/YAp4Ngk5yc5JsndZzZKckiSySSTU1NTC9S1JGmuwb8UuDTJaUlOnf6ZZ59LgIcD762qhwG3AIfPbFRVK6pqeVUtn5iYmGdXkqSZ5jrU87oF7PMa4JqqOqd/fhKzBL8kaXHM9aqeLy9Uh1X1kyQ/TLJzVV0O7AFculD7lySt3lyv6vkl3VU8ABsDGwG3VNWW8+z3JcCJ/RU9VwDPmed+JEl30VzP+LcYfZ7kqcBu8+20qi6gu1JIkjRm85qds6o+Bey+wLVIksZgrkM9Txt5ugHd2foaX9MvSRq/uV7V85SR5duAq4B9F7waSdKim+sYv1++StJ6Yq5/iGX7JJ9Mcl2SnyY5Ocn2i12cJGnhzfXL3WOBU+nm5d8O+HS/TpK0jplr8E9U1bFVdVv/cxzgPAqStA6aa/Bfn+TAJBv2PwcCP1vMwiRJi2Ouwf9cYH/gJ8C1wH54t60krZPmejnnG4GDqupGgCTbAG+j+4UgSVqHzPWMf9fp0AeoqhuAhy1OSZKkxTTX4N8gydbTT/oz/rl+WpAkrUXmGt5HAd9IchLdVA37A29atKokSYtmrnfunpBkkm5itgBPqyrn0JekddCch2v6oDfsJWkdN69pmSVJ6y6DX5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNGSz4+z/afn6SzwxVgyS1aMgz/pcClw3YvyQ1aZDgT7I98LfAMUP0L0ktG+qM/z+BVwO/X1WDJIckmUwyOTU1Nb7KJGk9N/bgT/J3wHVVtXJ17apqRVUtr6rlExMTY6pOktZ/Q5zxPxbYJ8lVwMeB3ZN8ZIA6JKlJYw/+qnpNVW1fVcuAA4AvVdWB465DklrldfyS1JglQ3ZeVWcBZw1ZgyS1xjN+SWqMwS9JjTH4JakxBr8kNcbgl6TGGPyS1BiDX5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMYY/JLUGINfkhpj8EtSYwx+SWqMwS9JjTH4JakxBr8kNcbgl6TGjD34k9wnyZlJLktySZKXjrsGSWrZkgH6vA14RVWdl2QLYGWS06vq0gFqkaTmjP2Mv6qurarz+uVfApcB2427Dklq1aBj/EmWAQ8Dzpll2yFJJpNMTk1Njbs0SVpvDRb8STYHTgYOq6pfzNxeVSuqanlVLZ+YmBh/gZK0nhok+JNsRBf6J1bVKUPUIEmtGuKqngAfBC6rqrePu39Jat0QZ/yPBZ4F7J7kgv5n7wHqkKQmjf1yzqr6GpBx9ytJ6njnriQ1xuCXpMYY/JLUGINfkhpj8EtSYwx+SWqMwS9JjTH4JakxBr8kNcbgl6TGGPyS1BiDX5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMYY/JLUGINfkhpj8EtSYwYJ/iR7Jbk8yfeSHD5EDZLUqrEHf5INgfcAfwM8EHhmkgeOuw5JatUQZ/y7Ad+rqiuq6rfAx4F9B6hDkpq0ZIA+twN+OPL8GuCvZjZKcghwSP/05iSXj6G2ViwFrh+6iLVB3nbQ0CXoT3lsTjsyC7GX+862cojgn+3d1B1WVK0AVix+Oe1JMllVy4euQ5rJY3M8hhjquQa4z8jz7YEfD1CHJDVpiOD/JrBTkh2SbAwcAJw6QB2S1KSxD/VU1W1JXgycBmwIfKiqLhl3HY1zCE1rK4/NMUjVHYbXJUnrMe/claTGGPyS1BiDf4yS3J7kgiSXJPlWkpcnWe2/QZJlSS7ulw9O8u5VtPvfJFvNsn7zJO9P8v2+368kucN9E3Os/w1JntwvH5Zkszm85qwkXp43sJFj7+Ikn57tWJnRfnmSd82jn62SvHDk+ROTfGY+Nd9JP8uS3Nq/p0uTnJBkowXuY709dg3+8bq1qh5aVbsAewJ7A0cuxI6rau+q+vksm44BbgB26vs9mO4mmfn0cURVfbF/ehhwp8Gvtcb0sfcguuPhRatrXFWTVXXoPPrZCnjhnbZaGN+vqocCD6a7LHz/MfW7zjP4B1JV19HdmfzidDZM8tYk30xyYZLnr+Kl2yb5fJLvJnnL9MokVyX5k0BPsiPdXdGvrarf9/1eUVWf7bd/KsnK/pPAISOvuznJUUnOS3JGkol+/XFJ9ktyKLAtcGaSM/tt700y2e/r9TOL7t/fcf0Z50VJXrYG//m0Zs6mu4OeJLsl+UaS8/vHnfv1fzhTX02bXZKc2591X5hkJ+DNwI79urf2/W2e5KQk305yYpL0rz+iP94vTrJiZP1ZSf6j3/d3kjx+dW+mqm4Hzh15T3v0tV6U5ENJ7tav++T0a5LsmeSUfrm9Y7eq/BnTD3DzLOtuBO5F90vgtf26uwGTwA7AMuDifv3BwBXAPYBNgB8A9+m3XQUsnbHvfYBPrqaebfrHTYGLgXv2zwv4h375CODd/fJxwH6z9Teyrw2Bs4Bd++dnAcuBRwCnj7Tfauh/j5Z+po+9/t/nE8Be/fMtgSX98pOBk/vlJwKfuZM2R48cJxv3x9EfjteR/dxEd0a+Ad0vnceNHjP98oeBp4wcM0f1y3sDX5zl/Yz+f7EJcCawa7/8Q+AB/bYT6D6dBvg2MNGv/+hIf80du57xD296Cou/Bp6d5ALgHOCewE6ztD+jqm6qql8Dl7KKuTjm6NAk3wL+j+5u6un+fg/8d7/8EeBxc9jX/knOA84HdqGbeXXUFcD9khydZC/gF2tQt+66Tftj62fANsDp/fp7AJ9I9z3SO+j+7WZaVZuzgX9N8i/Afavq1lX0fW5VXVPdp84L6EIb4ElJzklyEbD7jL5P6R9XjrSfaceR93R1VV0I7AxcWVXf6dscDzyhusT+MHBg//3Go4HP9W2aO3YN/gEluR9wO3Ad3S+Al1Q3DvvQqtqhqr4wy8t+M7J8O6u/Ce8S4CGZ5QvkJE+kO3t7dFU9hO6g32QV+1ntzR5JdgBeCexRVbsCn525r6q6EXgI3VnUi+i+e9D43FrdePh96c7Op8f43wicWd3Y/1OY/RiYtU1VfZTuU+WtwGlJdl9F33c4ZpNsAvwX3SfIBwMfmNH3b0bbr2K/02P89wcelWQfZp8LbNqxwIHAM4FPVHczaZPHrsE/kH7c/H10wyhFdyfzP09fmZDkAUnuviZ9VNX36YaMXj8yfrpTkn3pzuJurKpfJflL4FEjL90A2K9f/nvga7Ps/pfAFv3ylsAtwE1J7kX3txZmvt+lwAZVdTLw78DD1+S9aX6q6ibgUOCV/bF2D+BH/eaDV/GyWdv0Jy5XVNW76KZd2ZU/PS5WZzpcr0+yOX883u6yqroWOBx4Dd1wzrIk9+83Pwv4ct/ux3Tzgr2WbtgSGj12h5ids2XTH7c3Am6j++j59n7bMXQfac/rQ3oKeOoC9PmPwFHA95L8iu5j8auAC4EXJLkQuJxuuGfaLcAuSVbSjc8+Y5b9rgA+l+TaqnpSkvPpPmFcAXx9lvbbAceOfPp4zZq/Nc1HVZ3fD/EdALwFOD7Jy4EvzWzaP66qzTPohk5+B/wEeENV3ZDk6/2w0OfozqBnq+HnST4AXET3fdE31/BtfQp4HfBI4Dl0Q1NL+v2+b6TdiXTj/Jf2dXyrxWPXKRt0B0lurqrNh65Dw0nydGCfqlqv/mBBuvtgzq+qDw5dy5A845f0J/qx8jcBzx26loXUf4K9BXjF0LUMzTN+SWqMX+5KUmMMfklqjMEvSY0x+KXVyCpmPZXWZX65Kw0oyYbVTTImjY1n/Gpaklenm22UJO9I8qV+eY8kH0k/62m6+d8vS/KBfhbHLyTZtG8762ySWcWMq+lmvjwzyUfpbmCSxsrgV+u+AkxP+7ucbgrhjegmpvvqjLY7Ae+p7u8a/Bx4+si2JVW1G91MkNN/Y+F5wE1V9Ui6O0r/qZ8bBmA34N+qauaEYNKiM/jVupXAI5JsQTcx2Nl0vwAezx2D/8qqumDkdctGts02m+TqZlw9t6quXLi3Ic2dd+6qaVX1uyRX0c3v8g26OYyeBOwIXDaj+cxZJjedZdvobJLTM66eNrqTfmbUWxagfGlePOOXuuGeV/aPXwVeAFxQa37lw4LPuCotBINf6sL+3sDZVfVT4NfccZhnPo6h+2M55/WzVb4fP2VrLeDlnJLUGM/4JakxBr8kNcbgl6TGGPyS1BiDX5IaY/BLUmMMfklqzP8DxDqJmEryYTIAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sb.countplot(main_df['winner'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "### Acc to this data , RR has an edge over DC\n",
    "### Lets dig into 2020 stats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "### In head to head \n",
    "### RR - 11 , Dc - 10"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 166,
   "metadata": {},
   "outputs": [],
   "source": [
    "### looking at the stats and also the bowling lineup of DC , I think DC will win this match\n",
    "### They are looking very strong and have good batsman "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ques 1 Ans -- DC"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "########################################################################################################################"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ques 2 - Runs in Powerplay ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['batting_team'] = df['batting_team'].replace('Delhi Daredevils', 'Delhi Capitals')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "main_df_team = df[(df['batting_team'] == 'Rajasthan Royals') | (df['batting_team'] == 'Delhi Capitals')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "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>1084</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1085</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1086</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1087</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>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>1088</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>B Stanlake</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>...</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>178709</th>\n",
       "      <td>11414</td>\n",
       "      <td>1</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>TA Boult</td>\n",
       "      <td>A Mishra</td>\n",
       "      <td>RA Jadeja</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>6</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178710</th>\n",
       "      <td>11414</td>\n",
       "      <td>1</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>20</td>\n",
       "      <td>3</td>\n",
       "      <td>TA Boult</td>\n",
       "      <td>A Mishra</td>\n",
       "      <td>RA Jadeja</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>TA Boult</td>\n",
       "      <td>bowled</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178711</th>\n",
       "      <td>11414</td>\n",
       "      <td>1</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>20</td>\n",
       "      <td>4</td>\n",
       "      <td>I Sharma</td>\n",
       "      <td>A Mishra</td>\n",
       "      <td>RA Jadeja</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>178712</th>\n",
       "      <td>11414</td>\n",
       "      <td>1</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>20</td>\n",
       "      <td>5</td>\n",
       "      <td>I Sharma</td>\n",
       "      <td>A Mishra</td>\n",
       "      <td>RA Jadeja</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>178713</th>\n",
       "      <td>11414</td>\n",
       "      <td>1</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Chennai Super Kings</td>\n",
       "      <td>20</td>\n",
       "      <td>6</td>\n",
       "      <td>I Sharma</td>\n",
       "      <td>A Mishra</td>\n",
       "      <td>RA Jadeja</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>6</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>37987 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        match_id  inning    batting_team                 bowling_team  over  \\\n",
       "1084           5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1085           5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1086           5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1087           5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1088           5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "...          ...     ...             ...                          ...   ...   \n",
       "178709     11414       1  Delhi Capitals          Chennai Super Kings    20   \n",
       "178710     11414       1  Delhi Capitals          Chennai Super Kings    20   \n",
       "178711     11414       1  Delhi Capitals          Chennai Super Kings    20   \n",
       "178712     11414       1  Delhi Capitals          Chennai Super Kings    20   \n",
       "178713     11414       1  Delhi Capitals          Chennai Super Kings    20   \n",
       "\n",
       "        ball      batsman  non_striker      bowler  is_super_over  ...  \\\n",
       "1084       1      AP Tare  SW Billings  B Stanlake              0  ...   \n",
       "1085       2      AP Tare  SW Billings  B Stanlake              0  ...   \n",
       "1086       3      AP Tare  SW Billings  B Stanlake              0  ...   \n",
       "1087       4      AP Tare  SW Billings  B Stanlake              0  ...   \n",
       "1088       5  SW Billings      AP Tare  B Stanlake              0  ...   \n",
       "...      ...          ...          ...         ...            ...  ...   \n",
       "178709     2     TA Boult     A Mishra   RA Jadeja              0  ...   \n",
       "178710     3     TA Boult     A Mishra   RA Jadeja              0  ...   \n",
       "178711     4     I Sharma     A Mishra   RA Jadeja              0  ...   \n",
       "178712     5     I Sharma     A Mishra   RA Jadeja              0  ...   \n",
       "178713     6     I Sharma     A Mishra   RA Jadeja              0  ...   \n",
       "\n",
       "        bye_runs  legbye_runs  noball_runs  penalty_runs  batsman_runs  \\\n",
       "1084           0            0            0             0             0   \n",
       "1085           0            0            0             0             0   \n",
       "1086           0            0            0             0             0   \n",
       "1087           0            0            0             0             1   \n",
       "1088           0            0            0             0             0   \n",
       "...          ...          ...          ...           ...           ...   \n",
       "178709         0            0            0             0             6   \n",
       "178710         0            0            0             0             0   \n",
       "178711         0            0            0             0             0   \n",
       "178712         0            0            0             0             4   \n",
       "178713         0            0            0             0             6   \n",
       "\n",
       "        extra_runs  total_runs  player_dismissed dismissal_kind fielder  \n",
       "1084             0           0               NaN            NaN     NaN  \n",
       "1085             1           1               NaN            NaN     NaN  \n",
       "1086             0           0               NaN            NaN     NaN  \n",
       "1087             0           1               NaN            NaN     NaN  \n",
       "1088             0           0               NaN            NaN     NaN  \n",
       "...            ...         ...               ...            ...     ...  \n",
       "178709           0           6               NaN            NaN     NaN  \n",
       "178710           0           0          TA Boult         bowled     NaN  \n",
       "178711           0           0               NaN            NaN     NaN  \n",
       "178712           0           4               NaN            NaN     NaN  \n",
       "178713           0           6               NaN            NaN     NaN  \n",
       "\n",
       "[37987 rows x 21 columns]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df_team"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('int64')"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df_team['over'].dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 1,  2,  3,  4,  5,  6,  7,  8,  9, 10, 11, 12, 13, 14, 15, 16, 17,\n",
       "       18, 19, 20], dtype=int64)"
      ]
     },
     "execution_count": 102,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df_team['over'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "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>1084</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1085</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1086</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1087</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>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>1088</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>B Stanlake</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>1089</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>B Stanlake</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>1090</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>B Stanlake</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>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1091</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>YS Chahal</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>1092</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>YS Chahal</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>1093</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>YS Chahal</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>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>1094</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>YS Chahal</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>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>1095</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>YS Chahal</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>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>1096</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>YS Chahal</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>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>1097</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1098</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1099</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1100</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1101</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1102</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1103</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>Iqbal Abdulla</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>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>1104</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>Iqbal Abdulla</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>1105</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>Iqbal Abdulla</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>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>1106</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>Iqbal Abdulla</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>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>1107</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>Iqbal Abdulla</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>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>1108</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>Iqbal Abdulla</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>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>1109</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>AP Tare</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>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>1110</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</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>1111</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</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>1112</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</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>AP Tare</td>\n",
       "      <td>bowled</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1113</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>KK Nair</td>\n",
       "      <td>SW Billings</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>1114</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>KK Nair</td>\n",
       "      <td>SW Billings</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>1115</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>KK Nair</td>\n",
       "      <td>B Stanlake</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>1116</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>KK Nair</td>\n",
       "      <td>B Stanlake</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>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>1117</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>KK Nair</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>KK Nair</td>\n",
       "      <td>bowled</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1118</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>SV Samson</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1119</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>SV Samson</td>\n",
       "      <td>B Stanlake</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>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>1120</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>SV Samson</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>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",
       "  </tbody>\n",
       "</table>\n",
       "<p>37 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      match_id  inning    batting_team                 bowling_team  over  \\\n",
       "1084         5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1085         5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1086         5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1087         5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1088         5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1089         5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1090         5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1091         5       2  Delhi Capitals  Royal Challengers Bangalore     2   \n",
       "1092         5       2  Delhi Capitals  Royal Challengers Bangalore     2   \n",
       "1093         5       2  Delhi Capitals  Royal Challengers Bangalore     2   \n",
       "1094         5       2  Delhi Capitals  Royal Challengers Bangalore     2   \n",
       "1095         5       2  Delhi Capitals  Royal Challengers Bangalore     2   \n",
       "1096         5       2  Delhi Capitals  Royal Challengers Bangalore     2   \n",
       "1097         5       2  Delhi Capitals  Royal Challengers Bangalore     3   \n",
       "1098         5       2  Delhi Capitals  Royal Challengers Bangalore     3   \n",
       "1099         5       2  Delhi Capitals  Royal Challengers Bangalore     3   \n",
       "1100         5       2  Delhi Capitals  Royal Challengers Bangalore     3   \n",
       "1101         5       2  Delhi Capitals  Royal Challengers Bangalore     3   \n",
       "1102         5       2  Delhi Capitals  Royal Challengers Bangalore     3   \n",
       "1103         5       2  Delhi Capitals  Royal Challengers Bangalore     4   \n",
       "1104         5       2  Delhi Capitals  Royal Challengers Bangalore     4   \n",
       "1105         5       2  Delhi Capitals  Royal Challengers Bangalore     4   \n",
       "1106         5       2  Delhi Capitals  Royal Challengers Bangalore     4   \n",
       "1107         5       2  Delhi Capitals  Royal Challengers Bangalore     4   \n",
       "1108         5       2  Delhi Capitals  Royal Challengers Bangalore     4   \n",
       "1109         5       2  Delhi Capitals  Royal Challengers Bangalore     5   \n",
       "1110         5       2  Delhi Capitals  Royal Challengers Bangalore     5   \n",
       "1111         5       2  Delhi Capitals  Royal Challengers Bangalore     5   \n",
       "1112         5       2  Delhi Capitals  Royal Challengers Bangalore     5   \n",
       "1113         5       2  Delhi Capitals  Royal Challengers Bangalore     5   \n",
       "1114         5       2  Delhi Capitals  Royal Challengers Bangalore     5   \n",
       "1115         5       2  Delhi Capitals  Royal Challengers Bangalore     6   \n",
       "1116         5       2  Delhi Capitals  Royal Challengers Bangalore     6   \n",
       "1117         5       2  Delhi Capitals  Royal Challengers Bangalore     6   \n",
       "1118         5       2  Delhi Capitals  Royal Challengers Bangalore     6   \n",
       "1119         5       2  Delhi Capitals  Royal Challengers Bangalore     6   \n",
       "1120         5       2  Delhi Capitals  Royal Challengers Bangalore     6   \n",
       "\n",
       "      ball      batsman  non_striker         bowler  is_super_over  ...  \\\n",
       "1084     1      AP Tare  SW Billings     B Stanlake              0  ...   \n",
       "1085     2      AP Tare  SW Billings     B Stanlake              0  ...   \n",
       "1086     3      AP Tare  SW Billings     B Stanlake              0  ...   \n",
       "1087     4      AP Tare  SW Billings     B Stanlake              0  ...   \n",
       "1088     5  SW Billings      AP Tare     B Stanlake              0  ...   \n",
       "1089     6  SW Billings      AP Tare     B Stanlake              0  ...   \n",
       "1090     7  SW Billings      AP Tare     B Stanlake              0  ...   \n",
       "1091     1  SW Billings      AP Tare      YS Chahal              0  ...   \n",
       "1092     2  SW Billings      AP Tare      YS Chahal              0  ...   \n",
       "1093     3  SW Billings      AP Tare      YS Chahal              0  ...   \n",
       "1094     4      AP Tare  SW Billings      YS Chahal              0  ...   \n",
       "1095     5  SW Billings      AP Tare      YS Chahal              0  ...   \n",
       "1096     6      AP Tare  SW Billings      YS Chahal              0  ...   \n",
       "1097     1      AP Tare  SW Billings     B Stanlake              0  ...   \n",
       "1098     2      AP Tare  SW Billings     B Stanlake              0  ...   \n",
       "1099     3      AP Tare  SW Billings     B Stanlake              0  ...   \n",
       "1100     4      AP Tare  SW Billings     B Stanlake              0  ...   \n",
       "1101     5      AP Tare  SW Billings     B Stanlake              0  ...   \n",
       "1102     6      AP Tare  SW Billings     B Stanlake              0  ...   \n",
       "1103     1  SW Billings      AP Tare  Iqbal Abdulla              0  ...   \n",
       "1104     2      AP Tare  SW Billings  Iqbal Abdulla              0  ...   \n",
       "1105     3      AP Tare  SW Billings  Iqbal Abdulla              0  ...   \n",
       "1106     4      AP Tare  SW Billings  Iqbal Abdulla              0  ...   \n",
       "1107     5  SW Billings      AP Tare  Iqbal Abdulla              0  ...   \n",
       "1108     6  SW Billings      AP Tare  Iqbal Abdulla              0  ...   \n",
       "1109     1  SW Billings      AP Tare       TS Mills              0  ...   \n",
       "1110     2      AP Tare  SW Billings       TS Mills              0  ...   \n",
       "1111     3      AP Tare  SW Billings       TS Mills              0  ...   \n",
       "1112     4      AP Tare  SW Billings       TS Mills              0  ...   \n",
       "1113     5      KK Nair  SW Billings       TS Mills              0  ...   \n",
       "1114     6      KK Nair  SW Billings       TS Mills              0  ...   \n",
       "1115     1  SW Billings      KK Nair     B Stanlake              0  ...   \n",
       "1116     2  SW Billings      KK Nair     B Stanlake              0  ...   \n",
       "1117     3      KK Nair  SW Billings     B Stanlake              0  ...   \n",
       "1118     4    SV Samson  SW Billings     B Stanlake              0  ...   \n",
       "1119     5  SW Billings    SV Samson     B Stanlake              0  ...   \n",
       "1120     6    SV Samson  SW Billings     B Stanlake              0  ...   \n",
       "\n",
       "      bye_runs  legbye_runs  noball_runs  penalty_runs  batsman_runs  \\\n",
       "1084         0            0            0             0             0   \n",
       "1085         0            0            0             0             0   \n",
       "1086         0            0            0             0             0   \n",
       "1087         0            0            0             0             1   \n",
       "1088         0            0            0             0             0   \n",
       "1089         0            0            0             0             4   \n",
       "1090         0            0            0             0             3   \n",
       "1091         0            0            0             0             0   \n",
       "1092         0            0            0             0             0   \n",
       "1093         0            0            0             0             1   \n",
       "1094         0            0            0             0             1   \n",
       "1095         0            0            0             0             1   \n",
       "1096         0            0            0             0             1   \n",
       "1097         0            0            0             0             4   \n",
       "1098         0            0            0             0             0   \n",
       "1099         0            0            0             0             0   \n",
       "1100         0            0            0             0             0   \n",
       "1101         0            0            0             0             0   \n",
       "1102         0            0            0             0             4   \n",
       "1103         0            0            0             0             1   \n",
       "1104         0            0            0             0             4   \n",
       "1105         0            0            0             0             2   \n",
       "1106         0            0            0             0             1   \n",
       "1107         0            0            0             0             2   \n",
       "1108         0            0            0             0             1   \n",
       "1109         0            0            0             0             1   \n",
       "1110         0            0            0             0             0   \n",
       "1111         0            0            0             0             0   \n",
       "1112         0            0            0             0             0   \n",
       "1113         0            0            0             0             0   \n",
       "1114         0            0            0             0             4   \n",
       "1115         0            0            0             0             0   \n",
       "1116         0            0            0             0             1   \n",
       "1117         0            0            0             0             0   \n",
       "1118         0            0            0             0             3   \n",
       "1119         0            0            0             0             1   \n",
       "1120         0            0            0             0             1   \n",
       "\n",
       "      extra_runs  total_runs  player_dismissed dismissal_kind fielder  \n",
       "1084           0           0               NaN            NaN     NaN  \n",
       "1085           1           1               NaN            NaN     NaN  \n",
       "1086           0           0               NaN            NaN     NaN  \n",
       "1087           0           1               NaN            NaN     NaN  \n",
       "1088           0           0               NaN            NaN     NaN  \n",
       "1089           0           4               NaN            NaN     NaN  \n",
       "1090           0           3               NaN            NaN     NaN  \n",
       "1091           0           0               NaN            NaN     NaN  \n",
       "1092           0           0               NaN            NaN     NaN  \n",
       "1093           0           1               NaN            NaN     NaN  \n",
       "1094           0           1               NaN            NaN     NaN  \n",
       "1095           0           1               NaN            NaN     NaN  \n",
       "1096           0           1               NaN            NaN     NaN  \n",
       "1097           0           4               NaN            NaN     NaN  \n",
       "1098           0           0               NaN            NaN     NaN  \n",
       "1099           0           0               NaN            NaN     NaN  \n",
       "1100           0           0               NaN            NaN     NaN  \n",
       "1101           0           0               NaN            NaN     NaN  \n",
       "1102           0           4               NaN            NaN     NaN  \n",
       "1103           0           1               NaN            NaN     NaN  \n",
       "1104           0           4               NaN            NaN     NaN  \n",
       "1105           0           2               NaN            NaN     NaN  \n",
       "1106           0           1               NaN            NaN     NaN  \n",
       "1107           0           2               NaN            NaN     NaN  \n",
       "1108           0           1               NaN            NaN     NaN  \n",
       "1109           0           1               NaN            NaN     NaN  \n",
       "1110           0           0               NaN            NaN     NaN  \n",
       "1111           0           0               NaN            NaN     NaN  \n",
       "1112           0           0           AP Tare         bowled     NaN  \n",
       "1113           0           0               NaN            NaN     NaN  \n",
       "1114           0           4               NaN            NaN     NaN  \n",
       "1115           0           0               NaN            NaN     NaN  \n",
       "1116           0           1               NaN            NaN     NaN  \n",
       "1117           0           0           KK Nair         bowled     NaN  \n",
       "1118           0           3               NaN            NaN     NaN  \n",
       "1119           0           1               NaN            NaN     NaN  \n",
       "1120           0           1               NaN            NaN     NaN  \n",
       "\n",
       "[37 rows x 21 columns]"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "powerplay = main_df_team[:37]\n",
    "powerplay"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1    7\n",
      "6    6\n",
      "5    6\n",
      "4    6\n",
      "3    6\n",
      "2    6\n",
      "Name: over, dtype: int64\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXgAAAEGCAYAAABvtY4XAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+j8jraAAAOrklEQVR4nO3df6xkZX3H8feHXQiCEGx3VAS2WxtDa2wFvMHabdGiNaiI1hCrCbbVtrdJlUK0Gm2TVtuYpmk1GqumGxClIkYXtlXT+iOtiFoF78KqwGJiCeoqupeqEWgigX77x5wNd93LOrs7z8zuc9+vZHJn5pw53+9Jdj/33GeeeSZVhSSpP0fNuwFJUhsGvCR1yoCXpE4Z8JLUKQNekjq1ft4NrLRhw4batGnTvNuQpCPG9u3b766q0WrbDquA37RpE0tLS/NuQ5KOGEm+8XDbHKKRpE4Z8JLUKQNekjplwEtSpwx4SeqUAS9JnWoW8ElOT7Jjxe1HSS5tVU+StLdm8+Cr6mvAGQBJ1gHfBra1qidJ2tushmieCfx3VT3shHxJ0nTN6pOsLwGuXm1DkkVgEWDjxo37bH/Ka69s2lgL2//+d+fdgiS1v4JPcgxwAfDh1bZX1ZaqWqiqhdFo1eUUJEkHYRZDNM8Bbqqq782gliRpMIuAfykPMzwjSWqnacAnOQ74LeDalnUkSftq+iZrVf0v8LMta0iSVucnWSWpUwa8JHXKgJekThnwktQpA16SOmXAS1KnDHhJ6pQBL0mdMuAlqVMGvCR1yoCXpE4Z8JLUKQNekjplwEtSpwx4SeqUAS9JnTLgJalTBrwkdcqAl6ROGfCS1KmmAZ/kpCRbk9yeZGeSp7WsJ0l6yPrGx3878PGqujDJMcBxjetJkgbNAj7JicA5wO8DVNX9wP2t6kmS9tbyCv7xwDJwRZInA9uBS6rqvpU7JVkEFgE2btzYsJ3D0zf/+pfn3cIB2/iXX514383v2Nywk+n7/MWfP6D9P3PO0xt10sbTr//MxPv+42s+2rCTNl71ludPvO+bL7qwYSdt/MX7tx7Q/i3H4NcDZwHvrqozgfuA1//kTlW1paoWqmphNBo1bEeS1paWAb8L2FVVNwyPtzIOfEnSDDQL+Kr6LvCtJKcPTz0TuK1VPUnS3lrPorkYuGqYQXMH8PLG9SRJg6YBX1U7gIWWNSRJq/OTrJLUKQNekjplwEtSpwx4SeqUAS9JnTLgJalTBrwkdcqAl6ROGfCS1CkDXpI6ZcBLUqcMeEnqlAEvSZ0y4CWpUwa8JHXKgJekThnwktQpA16SOmXAS1KnDHhJ6pQBL0mdWt/y4EnuBO4BHgQeqKqFlvUkSQ9pGvCD36yqu2dQR5K0gkM0ktSp1gFfwCeTbE+yuNoOSRaTLCVZWl5ebtyOJK0drQN+c1WdBTwHeGWSc35yh6raUlULVbUwGo0atyNJa0fTgK+q7ww/dwPbgLNb1pMkPaRZwCc5PskJe+4DzwZuaVVPkrS3lrNoHgNsS7Knzgeq6uMN60mSVmgW8FV1B/DkVseXJO2f0yQlqVMGvCR1yoCXpE4Z8JLUKQNekjplwEtSpwx4SeqUAS9JnTLgJalTBrwkdcqAl6ROGfCS1CkDXpI6ZcBLUqcMeEnqlAEvSZ0y4CWpUwa8JHXKgJekThnwktSp5gGfZF2Sm5N8rHUtSdJDZnEFfwmwcwZ1JEkrTBTwSf5jkudW2edU4HnAZQfemiTpUKzf38YkxwLHARuSPArIsOlE4HETHP9twOuAE/ZTYxFYBNi4ceMEh5QkTeKnXcH/MbAd+MXh557bvwLv3N8Lk5wP7K6q7fvbr6q2VNVCVS2MRqOJG5ck7d9+r+Cr6u3A25NcXFXvOMBjbwYuSPJc4FjgxCTvr6qLDrJXSdIB2G/A71FV70jya8Cmla+pqiv385o3AG8ASPIM4M8Md0manYkCPsk/A78A7AAeHJ4u4GEDXpI0XxMFPLAAPLGq6mCKVNV1wHUH81pJ0sGZdB78LcBjWzYiSZquSa/gNwC3JbkR+PGeJ6vqgiZdSZIO2aQB/8aWTUiSpm/SWTSfad2IJGm6Jp1Fcw/jWTMAxwBHA/dV1YmtGpMkHZpJr+D3WmogyQuBs5t0JEmaioNaTbKq/gU4d8q9SJKmaNIhmheteHgU43nxBzUnXpI0G5POonn+ivsPAHcCL5h6N5KkqZl0DP7lrRuRJE3XpF/4cWqSbUl2J/lekmuGL/OQJB2mJn2T9QrgI4y/5OMU4KPDc5Kkw9SkAT+qqiuq6oHh9l7Ab+eQpMPYpAF/d5KLkqwbbhcB/9OyMUnSoZk04F8BvBj4LnAXcCHgG6+SdBibdJrk3wC/V1U/AEjyM8A/MA5+SdJhaNIr+F/ZE+4AVfV94Mw2LUmSpmHSgD8qyaP2PBiu4Ce9+pckzcGkIf0W4L+SbGW8RMGLgTc360qSdMgm/STrlUmWGC8wFuBFVXVb084kSYdk4mGWIdANdUk6QhzUcsGTSHJskhuTfDnJrUne1KqWJGlfLd8o/TFwblXdm+Ro4HNJ/r2qvtiwpiRp0Czgq6qAe4eHRw8315CXpBlpNkQDMCxrsAPYDXyqqm5YZZ/FJEtJlpaXl1u2I0lrStOAr6oHq+oM4FTg7CRPWmWfLVW1UFULo5Hrl0nStDQN+D2q6ofAdcB5s6gnSWo7i2aU5KTh/iOAZwG3t6onSdpby1k0JwPvS7KO8S+SD1XVxxrWkySt0HIWzVdwQTJJmpuZjMFLkmbPgJekThnwktQpA16SOmXAS1KnDHhJ6pQBL0mdMuAlqVMGvCR1yoCXpE4Z8JLUKQNekjplwEtSpwx4SeqUAS9JnTLgJalTBrwkdcqAl6ROGfCS1CkDXpI61Szgk5yW5NNJdia5NcklrWpJkva1vuGxHwBeU1U3JTkB2J7kU1V1W8OakqRBsyv4qrqrqm4a7t8D7AROaVVPkrS3mYzBJ9kEnAncMIt6kqQZBHySRwLXAJdW1Y9W2b6YZCnJ0vLycut2JGnNaBrwSY5mHO5XVdW1q+1TVVuqaqGqFkajUct2JGlNaTmLJsDlwM6qemurOpKk1bW8gt8MvAw4N8mO4fbchvUkSSs0myZZVZ8D0ur4kqT985OsktQpA16SOmXAS1KnDHhJ6pQBL0mdMuAlqVMGvCR1yoCXpE4Z8JLUKQNekjplwEtSpwx4SeqUAS9JnTLgJalTBrwkdcqAl6ROGfCS1CkDXpI6ZcBLUqcMeEnqlAEvSZ1qFvBJ3pNkd5JbWtWQJD28llfw7wXOa3h8SdJ+NAv4qroe+H6r40uS9m/uY/BJFpMsJVlaXl6edzuS1I25B3xVbamqhapaGI1G825Hkrox94CXJLVhwEtSp1pOk7wa+AJwepJdSf6gVS1J0r7WtzpwVb201bElST+dQzSS1CkDXpI6ZcBLUqcMeEnqlAEvSZ0y4CWpUwa8JHXKgJekThnwktQpA16SOmXAS1KnDHhJ6pQBL0mdMuAlqVMGvCR1yoCXpE4Z8JLUKQNekjplwEtSpwx4SeqUAS9JnWoa8EnOS/K1JF9P8vqWtSRJe2sW8EnWAe8EngM8EXhpkie2qidJ2lvLK/izga9X1R1VdT/wQeAFDetJklZIVbU5cHIhcF5V/eHw+GXAU6vqVT+x3yKwODw8Hfhak4b2tQG4e0a15sHzO7J5fkeuWZ/bz1XVaLUN6xsWzSrP7fPbpKq2AFsa9rGqJEtVtTDrurPi+R3ZPL8j1+F0bi2HaHYBp614fCrwnYb1JEkrtAz4LwFPSPLzSY4BXgJ8pGE9SdIKzYZoquqBJK8CPgGsA95TVbe2qncQZj4sNGOe35HN8ztyHTbn1uxNVknSfPlJVknqlAEvSZ1acwGf5D1Jdie5Zd69tJDktCSfTrIzya1JLpl3T9OU5NgkNyb58nB+b5p3T9OWZF2Sm5N8bN69TFuSO5N8NcmOJEvz7mfakpyUZGuS24f/g0+baz9rbQw+yTnAvcCVVfWkefczbUlOBk6uqpuSnABsB15YVbfNubWpSBLg+Kq6N8nRwOeAS6rqi3NubWqSvBpYAE6sqvPn3c80JbkTWKiqLj/klOR9wGer6rJh9uBxVfXDefWz5q7gq+p64Pvz7qOVqrqrqm4a7t8D7AROmW9X01Nj9w4Pjx5u3VylJDkVeB5w2bx70YFJciJwDnA5QFXdP89whzUY8GtJkk3AmcAN8+1kuoYhjB3AbuBTVdXT+b0NeB3wf/NupJECPplk+7BMSU8eDywDVwxDbJclOX6eDRnwnUrySOAa4NKq+tG8+5mmqnqwqs5g/Onos5N0MdSW5Hxgd1Vtn3cvDW2uqrMYrzL7ymHItBfrgbOAd1fVmcB9wFyXSTfgOzSMTV8DXFVV1867n1aGP3+vA86bcyvTshm4YBin/iBwbpL3z7el6aqq7ww/dwPbGK8624tdwK4Vf1FuZRz4c2PAd2Z4E/JyYGdVvXXe/UxbklGSk4b7jwCeBdw+366mo6reUFWnVtUmxkt7/GdVXTTntqYmyfHDG/8MQxfPBrqZzVZV3wW+leT04alnAnOd3NByNcnDUpKrgWcAG5LsAv6qqi6fb1dTtRl4GfDVYZwa4M+r6t/m2NM0nQy8b/hCmaOAD1VVd9MJO/UYYNv4GoT1wAeq6uPzbWnqLgauGmbQ3AG8fJ7NrLlpkpK0VjhEI0mdMuAlqVMGvCR1yoCXpE4Z8JLUKQNekjplwEtTkjH/T+mw4T9GrWlJXp3kluF2aZK/S/InK7a/MclrhvuvTfKlJF/Zsw59kk3Dut/vAm4CTpvPmUj7MuC1ZiV5CuNPGj4V+FXgjxivAfM7K3Z7MfDhJM8GnsB47ZQzgKesWCjrdMbfL3BmVX1jVv1LP82aW6pAWuHXgW1VdR9AkmuB3wAeneRxwAj4QVV9M8mfMl475ebhtY9kHPjfBL7R0xeOqB8GvNayPMzzW4ELgccyvqLfs+/fVtU/7XWA8Zr79zXqTzokDtFoLbseeGGS44bVDX8b+CzjUH8J45DfOuz7CeAVwzr7JDklyaPn0LM0Ma/gtWYN31v7XuDG4anLqupmgGFZ229X1V3Dvp9M8kvAF4bVEO8FLgIenHnj0oRcTVKSOuUQjSR1yoCXpE4Z8JLUKQNekjplwEtSpwx4SeqUAS9Jnfp/Pbt2cNqLqlAAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sb.countplot(powerplay['over'])\n",
    "list = [(powerplay['over'].value_counts())]\n",
    "print(sum(list))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "over  batting_team  \n",
       "1     Delhi Capitals     9\n",
       "2     Delhi Capitals     4\n",
       "3     Delhi Capitals     8\n",
       "4     Delhi Capitals    11\n",
       "5     Delhi Capitals     5\n",
       "6     Delhi Capitals     6\n",
       "Name: total_runs, dtype: int64"
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "powerplay.groupby(['over' , 'batting_team'])['total_runs'].sum()[:12]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "43"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum_dc = 9+4+8+11+5+6\n",
    "sum_dc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Acc to stats - powerplay score is 43\n",
    "## Acc to 2020 stats - average powerplay score is above 40\n",
    "## And also Shikhar Dhawan and Prithvi Shaw are good opener (right + left combo)\n",
    "## Hence I choose 41-50"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ques 2 ans - 41:50"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [],
   "source": [
    "########################################################################################################################"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ques 3 - Runs by Smith ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "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>1084</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1085</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1086</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>1087</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>B Stanlake</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>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>1088</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Delhi Capitals</td>\n",
       "      <td>Royal Challengers Bangalore</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>SW Billings</td>\n",
       "      <td>AP Tare</td>\n",
       "      <td>B Stanlake</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",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      match_id  inning    batting_team                 bowling_team  over  \\\n",
       "1084         5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1085         5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1086         5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1087         5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "1088         5       2  Delhi Capitals  Royal Challengers Bangalore     1   \n",
       "\n",
       "      ball      batsman  non_striker      bowler  is_super_over  ...  \\\n",
       "1084     1      AP Tare  SW Billings  B Stanlake              0  ...   \n",
       "1085     2      AP Tare  SW Billings  B Stanlake              0  ...   \n",
       "1086     3      AP Tare  SW Billings  B Stanlake              0  ...   \n",
       "1087     4      AP Tare  SW Billings  B Stanlake              0  ...   \n",
       "1088     5  SW Billings      AP Tare  B Stanlake              0  ...   \n",
       "\n",
       "      bye_runs  legbye_runs  noball_runs  penalty_runs  batsman_runs  \\\n",
       "1084         0            0            0             0             0   \n",
       "1085         0            0            0             0             0   \n",
       "1086         0            0            0             0             0   \n",
       "1087         0            0            0             0             1   \n",
       "1088         0            0            0             0             0   \n",
       "\n",
       "      extra_runs  total_runs  player_dismissed dismissal_kind fielder  \n",
       "1084           0           0               NaN            NaN     NaN  \n",
       "1085           1           1               NaN            NaN     NaN  \n",
       "1086           0           0               NaN            NaN     NaN  \n",
       "1087           0           1               NaN            NaN     NaN  \n",
       "1088           0           0               NaN            NaN     NaN  \n",
       "\n",
       "[5 rows x 21 columns]"
      ]
     },
     "execution_count": 126,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df_team.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Int64Index([  1084,   1085,   1086,   1087,   1088,   1089,   1090,   1091,\n",
       "              1092,   1093,\n",
       "            ...\n",
       "            178704, 178705, 178706, 178707, 178708, 178709, 178710, 178711,\n",
       "            178712, 178713],\n",
       "           dtype='int64', length=37987)"
      ]
     },
     "execution_count": 129,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df_team.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {},
   "outputs": [],
   "source": [
    "main_df_team.reset_index(inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RangeIndex(start=0, stop=37987, step=1)"
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df_team.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "batsman\n",
       "AM Rahane           2353\n",
       "SR Watson           1734\n",
       "SV Samson           1728\n",
       "V Sehwag            1410\n",
       "SS Iyer             1370\n",
       "R Dravid            1177\n",
       "DA Warner           1107\n",
       "RR Pant             1104\n",
       "G Gambhir            991\n",
       "KK Nair              917\n",
       "NV Ojha              852\n",
       "KD Karthik           835\n",
       "JP Duminy            795\n",
       "S Dhawan             700\n",
       "YK Pathan            655\n",
       "GC Smith             637\n",
       "DPMD Jayawardene     628\n",
       "SPD Smith            626\n",
       "AB de Villiers       582\n",
       "JC Buttler           579\n",
       "Name: total_runs, dtype: int64"
      ]
     },
     "execution_count": 122,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df_team.groupby('batsman')['total_runs'].count().sort_values(ascending = False)[:20]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "batsman\n",
       "AM Rahane     2957\n",
       "SR Watson     2489\n",
       "V Sehwag      2315\n",
       "SV Samson     2301\n",
       "RR Pant       1855\n",
       "SS Iyer       1785\n",
       "DA Warner     1514\n",
       "R Dravid      1346\n",
       "G Gambhir     1262\n",
       "KK Nair       1196\n",
       "KD Karthik    1086\n",
       "YK Pathan     1069\n",
       "JP Duminy     1061\n",
       "NV Ojha       1022\n",
       "JC Buttler     947\n",
       "S Dhawan       926\n",
       "SPD Smith      819\n",
       "STR Binny      767\n",
       "Q de Kock      761\n",
       "GC Smith       755\n",
       "Name: total_runs, dtype: int64"
      ]
     },
     "execution_count": 124,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df_team.groupby('batsman')['total_runs'].sum().sort_values(ascending = False)[:20]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "819 626\n"
     ]
    }
   ],
   "source": [
    "r = 0\n",
    "c =0\n",
    "for i in range(0 , len(main_df_team)):\n",
    "    if main_df_team.loc[i , 'batsman'] == 'SPD Smith':\n",
    "        r = r + main_df_team.loc[i , 'total_runs']\n",
    "        c = c+1\n",
    "print(r , c)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "23.142857142857142"
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "162 / 7"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Acc to stats , Smith (one of the best Aussie Batsman) has an average runs of 23.14"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ques 3 ans - 16-30"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "metadata": {},
   "outputs": [],
   "source": [
    "########################################################################################################################"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ques 4 - Wides ? "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['level_0', 'index', 'match_id', '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',\n",
       "       'player_dismissed', 'dismissal_kind', 'fielder'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df_team.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "over\n",
       "1     0.058083\n",
       "2     0.039702\n",
       "3     0.036355\n",
       "4     0.038942\n",
       "5     0.031595\n",
       "6     0.033367\n",
       "7     0.041835\n",
       "8     0.027890\n",
       "9     0.028455\n",
       "10    0.027425\n",
       "11    0.034990\n",
       "12    0.031681\n",
       "13    0.039286\n",
       "14    0.030224\n",
       "15    0.040966\n",
       "16    0.024364\n",
       "17    0.033758\n",
       "18    0.036628\n",
       "19    0.041070\n",
       "20    0.041137\n",
       "Name: wide_runs, dtype: float64"
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df_team.groupby('over')['wide_runs'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5.675"
      ]
     },
     "execution_count": 153,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df_team['wide_runs'].sum()  / 240"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Avg wide is 5.675"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "metadata": {},
   "outputs": [],
   "source": [
    "## But , sometimes DC bowler bowls more wide ,hehe\n",
    "## Hence ans is more than 6"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ques 4 ans - more than 6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {},
   "outputs": [],
   "source": [
    "####################################################################################################################"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 161,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1922"
      ]
     },
     "execution_count": 161,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df_team['player_dismissed'].notna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 162,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "36065"
      ]
     },
     "execution_count": 162,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df_team['player_dismissed'].isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 163,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "8.008333333333333"
      ]
     },
     "execution_count": 163,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "1922 / 240"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Average Around 8 wickets haul\n",
    "## Lets check for 2020 stats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Since , RR has been all out many num of times ,and they have more wickets downfall\n",
    "## I guess RR will loose 5 wickets and Dc will loose 3 wickets"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ques 5 ans - 6-10 wickets"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}